PROCESS_INSTANCEPrompt Table: CA_PREPAID_SRCH
BUSINESS_UNIT_PCPrompt Table: SP_BU_PC_NONVW
PROJECT_IDPrompt Table: SP_PROJ_NONVW
ACTIVITY_IDPrompt Table: PROJ_ACT_SRCH
CA_PGP_CC2AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_PREPAID_SRCH |
| 4 | CA_PGP_SEQ | Number(3,0) | SMALLINT NOT NULL | Progress Payment Sequence |
| 5 | ASOF_DT | Date(10) | DATE | As of Date |
| 6 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 7 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 8 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_SRCH |