PC_LABOR_EMP_VW

(SQL View)
 Index Back

Reported Project Labor Time

View of reported labor time to project.

SELECT RES.EMPLID , RES.UNIT_OF_MEASURE , RES.BUSINESS_UNIT , RES.PROJECT_ID , RES.ACTIVITY_ID , 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.EMPLID, RES.UNIT_OF_MEASURE, RES.BUSINESS_UNIT, RES.PROJECT_ID, RES.ACTIVITY_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 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

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: SP_PROJ_NONVW

5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACTIVITY

6 TOTAL_LABOR_HOURS Signed Number(16,2) DECIMAL(14,2) NOT NULL Total Labor Hours