CONTRACT_NUMCONTRACT_LINE_NUMPROJECT_IDACTIVITY_IDPrompt Table: %EDITTABLE
ALL=All Activities
ONE=One Activity
PC_CA_DETAIL_VW(SQL View) |
Index Back |
|---|---|
View of CA_DETAIL_PROJThis view maps BUSINESS_UNIT_PC to BUSINESS_UNIT. |
| SELECT CONTRACT_NUM , CONTRACT_LINE_NUM , BUSINESS_UNIT_PC , PROJECT_ID , ACTIVITY_ID , BILLED_TO_DATE , ACTIVITY_FLAG , RESOURCE_TYPE , RESOURCE_CATEGORY , RESOURCE_SUB_CAT FROM PS_CA_DETAIL_PROJ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 5 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: %EDITTABLE |
| 6 | BILLED_TO_DATE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billed To Date |
| 7 | ACTIVITY_FLAG | Character(3) | VARCHAR2(3) NOT NULL |
Use all activities
ALL=All Activities ONE=One Activity |
| 8 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 9 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 10 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |