CA_DTL_PROJ2_VW(SQL View) |
Index Back |
|---|---|
Contract Projects / ActivitiesThis view joins CA_DETAIL, CA_DETAIL_PROJ and PROJ_ACTIVITY to get all Activities linked to rate based contract lines or Contract lines whose revenue plan is set to Billing manages revenue. |
| SELECT HDR.BUSINESS_UNIT ,HDR.CONTRACT_NUM ,HDR.SOLD_TO_CUST_ID ,HDR.CA_RQST_SRC ,HDR.CONTRACT_TYPE ,HDR.REVENUE_PROFILE , CD.CONTRACT_LINE_NUM , CD.ACCT_PLAN_ID , CD.REV_RECOG_METHOD , CD.CA_FEE_TYPE , CDP.BUSINESS_UNIT_PC , CDP.PROJECT_ID , CDP.ACTIVITY_ID , CDP.RESOURCE_TYPE , CDP.RESOURCE_CATEGORY , CDP.RESOURCE_SUB_CAT , PA.ACTIVITY_TYPE FROM PS_CA_CONTR_HDR HDR ,PS_CA_DETAIL CD , PS_CA_DETAIL_PROJ CDP , PS_PROJ_ACTIVITY PA WHERE HDR.CONTRACT_NUM = CD.CONTRACT_NUM AND CD.CONTRACT_NUM = CDP.CONTRACT_NUM AND CD.CONTRACT_LINE_NUM = CDP.CONTRACT_LINE_NUM AND CDP.BUSINESS_UNIT_PC = PA.BUSINESS_UNIT AND CDP.PROJECT_ID = PA.PROJECT_ID AND CDP.ACTIVITY_ID = PA.ACTIVITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 |  CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 4 | CA_RQST_SRC | Character(3) | VARCHAR2(3) NOT NULL |
Contract Classification
FED=Federal Reimbursable Agreement GEN=Generic Application GOV=Government INT=Internal OND=CRM Field Services On Demand STD=Standard |
| 5 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 6 | REVENUE_PROFILE | Character(15) | VARCHAR2(15) NOT NULL | Contract Revenue Profile |
| 7 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 8 | ACCT_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Revenue Recognition Plan |
| 9 | REV_RECOG_METHOD | Character(4) | VARCHAR2(4) NOT NULL |
Revenue Recognition Method
1=As Incurred 2=Apportionment 3=Percent Complete 4=Milestone 5=Billing Manages Revenue |
| 10 | CA_FEE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Cost Plus Fee Type
01=None 02=Fixed Fee 03=Award Fee 04=Incentive Fee 05=Other Fee |
| 11 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 12 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 13 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 14 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 15 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 16 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 17 | ACTIVITY_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason |