PGM_PRJRQ_AET(SQL Table) |
Index Back |
---|---|
State Record for PGM_PRJRQ_AEState Record for Project Request Analysis application engine. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
4 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
5 | PGM_EPT_NAME | Character(18) | VARCHAR2(18) NOT NULL | The name of the Enterprise Program Tree. |
6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
7 | BUD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Status
1=Active 2=Inactive 3=Submitted 4=Returned |
8 | PC_BUDGET_ID | Number(3,0) | SMALLINT NOT NULL | Budget Plan ID |
9 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
11 | 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. |
12 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
13 | PROJECT_ID_2 | Character(15) | VARCHAR2(15) NOT NULL | Project |
14 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
15 | BUDGET_AMT_TMP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Temp Amount |
16 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
17 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |