CONTRACT_NUMCONTRACT_LINE_NUMCA_PROJ_DTL_VW2(SQL View) |
Index Back |
|---|
| SELECT DISTINCT DTL.CONTRACT_NUM ,DTL.CONTRACT_LINE_NUM ,DTL.BUSINESS_UNIT_PC ,DTL.ACCT_PLAN_ID ,DP.PROJECT_ID ,DP.ACTIVITY_ID ,PRJ.PERCENT_COMPLETE ,ACT.PERCENT_COMPLETE FROM PS_CA_DETAIL DTL , PS_CA_DETAIL_PROJ DP , PS_PROJECT PRJ , PS_PROJ_ACTIVITY ACT WHERE %Join(common_keys, CA_DETAIL DTL,CA_DETAIL_PROJ DP) AND %Join(common_keys, CA_DETAIL_PROJ DP, PROJECT PRJ) AND %Join(common_keys, PROJECT PRJ, PROJ_ACTIVITY ACT) |
| # | 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_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 4 | ACCT_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Revenue Recognition Plan |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 6 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 7 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
| 8 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |