BUSINESS_UNITPROJECT_IDUNIT_OF_MEASUREMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Default Value: OPR_DEF_TBL_PC.UNIT_OF_MEASURE
Prompt Table: UNITS_TBL
ACTIVITY_IDPrompt Table: PROJ_ACTIVITY
EMPLIDPC_LABOR_ACT_VW(SQL View) |
Index Back |
|---|---|
Reported Project Labor TimeView of reported labor time to project. |
| SELECT RES.BUSINESS_UNIT , RES.PROJECT_ID , RES.UNIT_OF_MEASURE , RES.ACTIVITY_ID , RES.EMPLID , SUM(RES.RESOURCE_QUANTITY) RESQTY FROM PS_PC_SUMMARY_TBL RES , PS_PROJ_AN_GRP_MAP ANGRP , PS_SET_CNTRL_REC SCR WHERE RES.BUSINESS_UNIT = SCR.SETCNTRLVALUE AND SCR.RECNAME = 'PROJ_AN_GRP_MAP' AND SCR.SETID = ANGRP.SETID AND ANGRP.ANALYSIS_GROUP = 'LABOR' AND ANGRP.ANALYSIS_TYPE = RES.ANALYSIS_TYPE GROUP BY RES.BUSINESS_UNIT, RES.PROJECT_ID, RES.UNIT_OF_MEASURE, RES.ACTIVITY_ID, RES.EMPLID |
| # | 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 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Default Value: OPR_DEF_TBL_PC.UNIT_OF_MEASURE Prompt Table: UNITS_TBL |
| 4 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACTIVITY |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | TOTAL_LABOR_HOURS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Total Labor Hours |