PROJ_RES_OLAPVW(SQL View) |
Index Back |
|---|---|
PC Cube Fact DataSubset of Proj Resource used to build the Projects Cube. Original sql: SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.ANALYSIS_TYPE , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.UNIT_OF_MEASURE , A.TRANS_DT , A.ACCOUNTING_DT , A.JOBCODE , A.EMPLID , A.RESOURCE_QUANTITY , A.RESOURCE_AMOUNT FROM PS_PROJ_RESOURCE A |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.ANALYSIS_TYPE , CASE WHEN A.RESOURCE_TYPE = ' ' THEN 'NA' ELSE A.RESOURCE_TYPE END , CASE WHEN A.RESOURCE_CATEGORY = ' ' THEN 'NA' ELSE A.RESOURCE_CATEGORY END , CASE WHEN A.RESOURCE_SUB_CAT = ' ' THEN 'NA' ELSE A.RESOURCE_SUB_CAT END , CASE WHEN A.UNIT_OF_MEASURE = ' ' THEN 'NA' ELSE A.UNIT_OF_MEASURE END , A.TRANS_DT , A.ACCOUNTING_DT , CASE WHEN A.JOBCODE = ' ' THEN 'NA' ELSE A.JOBCODE END , CASE WHEN A.EMPLID = ' ' THEN 'NA' ELSE A.EMPLID END , A.RESOURCE_QUANTITY , A.RESOURCE_AMOUNT FROM PS_PROJ_RESOURCE A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_SRCH |
| 4 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table: PROJ_AN_GRP_VW |
| 5 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table: PROJ_RES_TYPE |
| 6 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table: %EDITTABLE |
| 7 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table: %EDITTABLE2 |
| 8 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 9 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 10 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 11 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PROJ_TEAM_VW |
| 13 | RESOURCE_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity |
| 14 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |