| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 3 |
PPK_PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project ID
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
BC_PROJ_REQ_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Status of the Project Request.
01=Approved
02=Pending
03=Submitted
04=Canceled
05=Declined
06=Returned
07=Costing
08=Hold
09=Complete
10=Executed
11=Operationally Approved
|
| 6 |
BC_PRIORITY_REQSTR |
Number(3,0) |
SMALLINT NOT NULL |
Requester Priority
Default Value: 5
Prompt Table:
BC_PRJ_PRTY_TBL
|
| 7 |
BC_PRIORITY_APPRVR |
Number(3,0) |
SMALLINT NOT NULL |
Approver Priority
Prompt Table:
BC_PRJ_PRTY_TBL
|
| 8 |
BC_INVESTMENT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Investment Type
01=Run Rate
02=Infrastructure
03=Transactional
04=Informational
05=Utilities
|
| 9 |
BC_SPONSOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Sponsor ID
Prompt Table:
PPK_SPONSOR_VW
|
| 10 |
BC_SPONSOR |
Character(40) |
VARCHAR2(40) NOT NULL |
Business Sponsor of Project.
|
| 11 |
BC_REQUESTER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requester ID
Prompt Table:
PPK_REQUESTR_VW
|
| 12 |
BC_REQUESTER |
Character(50) |
VARCHAR2(50) NOT NULL |
Requester of Project Request.
|
| 13 |
BC_APPROVER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator ID for the approver
Prompt Table:
PPK_APPROVER_VW
|
| 14 |
BC_APPROVER |
Character(50) |
VARCHAR2(50) NOT NULL |
Approver of Project Request.
|
| 15 |
BC_DEPTID_REQSTER |
Character(10) |
VARCHAR2(10) NOT NULL |
Department of the project requester.
Prompt Table:
%EDITTABLE19
Set Control Field: BUSINESS_UNIT_REQ
|
| 16 |
BC_PROJ_OWNER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Owner ID
Prompt Table:
PPK_OWNER_VW
|
| 17 |
BC_PROJECT_OWNER |
Character(40) |
VARCHAR2(40) NOT NULL |
Project Owner
|
| 18 |
BC_PROJ_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Project Owning Deptid
Prompt Table:
%EDITTABLE19
Set Control Field: BUSINESS_UNIT_HR
|
| 19 |
BC_FINISH_DATE |
Date(10) |
DATE |
Desired Finish Date
|
| 20 |
BASELINE_START_DT |
Date(10) |
DATE NOT NULL |
Baseline Start Date
Default Value: %Date
|
| 21 |
BASELINE_FINISH_DT |
Date(10) |
DATE NOT NULL |
Baseline Finish Date
Default Value: %Date
|
| 22 |
CREATE_DATE |
Date(10) |
DATE |
Creation Date
|
| 23 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 24 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table:
CURRENCY_CD_TBL
|
| 25 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 26 |
BC_ESTIMATED_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Cost used on Project Request page.
|
| 27 |
BC_CAPITALIZE_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Capitalized Cost
|
| 28 |
BC_EXPENSE_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Expensed Cost
|
| 29 |
BC_MAINT_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Maintenance Cost
|
| 30 |
PPK_MAINT_TRNS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Maintenance Cost
|
| 31 |
BC_FUNDING |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Additional Funding Amount used on Project Request page.
|
| 32 |
BC_RISK |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Risk
01=1- High
02=2 - Medium
03=3 - Low
|
| 33 |
BC_KBO_SUPPORT |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
KBO Support
|
| 34 |
BC_EST_BENEFITS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Benefits
|
| 35 |
BC_BENEFIT_TERM |
Number(4,0) |
SMALLINT NOT NULL |
Benefit Term
|
| 36 |
BC_BENEFIT_BEGIN |
Number(4,0) |
SMALLINT NOT NULL |
Benefit Begin
|
| 37 |
BC_NET_PRESENT_VAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Present Value
|
| 38 |
BC_PV_BENEFITS |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Net Present Value of Benefits
|
| 39 |
BC_ROI |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Return on Investment
|
| 40 |
USER_AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 41 |
USER_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 42 |
USER_AMT3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 43 |
KP_USER_FLD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Report Attribute field
|
| 44 |
KP_USER_FLD2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Attribute field
|
| 45 |
KP_USER_FLD3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Attribute field
|
| 46 |
KP_USER_FLD4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Report Attribute field
|
| 47 |
KP_USER_FLD5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Report Attribute field
|
| 48 |
KP_USER_FLD6 |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Attribute field
|
| 49 |
KP_USER_FLD7 |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Attribute field
|
| 50 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 51 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 52 |
COMMENTS_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
EDI Comments
|
| 53 |
BC_PUBLISH |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish Flag
Y/N Table Edit
Default Value: N
|
| 54 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 55 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
BUS_UNIT_TBL_PC
|
| 56 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Default Value: OPR_DEF_TBL_PC.INTEGRATION_TMPL
Prompt Table:
PC_INT_TMPL
|
| 57 |
PPK_PROJ_VERSION |
Character(15) |
VARCHAR2(15) NOT NULL |
An identifier that represents a version of the Project Request.
|
| 58 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 59 |
BC_INDUSTRY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Industry Type - Commercial C
Edu. and Govt. E
C=Commercial
E=Education & Government
|
| 60 |
PPK_PG_REQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Communication Status with Program Management
|
| 61 |
PPK_INIT_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Initiative Type ID
Prompt Table:
PPK_INITYPE_TBL
|
| 62 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
Prompt Table:
%EDITTABLE2
|
| 63 |
APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
Default Value: P
|
| 64 |
APPR_INSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Unique number for each runtime occurrence of a virtual approver process
|
| 65 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 66 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 67 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 68 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|
| 69 |
RELEASE |
Character(15) |
VARCHAR2(15) NOT NULL |
Release - Carries Release Information driven by the BUSINESS_UNIT
Prompt Table:
PGM_RELEASE_ALL
|
| 70 |
CATEGORY_IND |
Character(10) |
VARCHAR2(10) NOT NULL |
An additional attribute of the project, program, or project request for further classification. This field is user-defined. Examples of usage include "Strategic", "Operational", "Tactical", etc.
Prompt Table:
PGM_CATEGORY_AC
|
| 71 |
APPLICATION_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
Prompt Table:
PGM_APPLAREA_AC
|
| 72 |
APPLICATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area.
Prompt Table:
PGM_APPLICAT_AC
|
| 73 |
REQUEST_USER_DT1 |
Date(10) |
DATE |
User defined date field for a project request.
|
| 74 |
REQUEST_USER_DT2 |
Date(10) |
DATE |
User defined date field for project request.
|