PC_RPO_FA_VW(SQL View) |
Index Back |
|---|---|
Summary Report ViewThis view is used in the Project Summary reports: PCPL1000 Financial Summary, and PCPL2000 Resource Summary. This view was created to pull data from PC_RPO rather than PROJ_RESOURCE. |
| SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.ANALYSIS_TYPE ,A.RESOURCE_TYPE ,A.RESOURCE_CATEGORY ,A.RESOURCE_SUB_CAT ,A.CURRENCY_CD ,A.UNIT_OF_MEASURE ,%Round(%DecMult(A.RESOURCE_QUANTITY, B.QUANTITY_MULTIPLY), 2) ,%Round(%DecMult(A.RESOURCE_AMOUNT, B.SIGNED_VALUE), 3) ,A.TRANS_DT ,A.OPRID ,B.SETID ,B.ANALYSIS_GROUP ,B.ANALYSIS_TYPE_MAP FROM PS_PC_RPO A , PS_PROJ_AN_GRP_MAP B WHERE A.ANALYSIS_TYPE = B.ANALYSIS_TYPE AND B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.RECNAME = 'PROJ_AN_GRP_MAP' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 5 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 6 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 7 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 10 | RESOURCE_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity |
| 11 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 12 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 13 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 14 | ANALYSIS_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 15 | ANALYSIS_GROUP | Character(5) | VARCHAR2(5) NOT NULL | Analysis Group |
| 16 | ANALYSIS_TYPE_MAP | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type Map |