SPR_CONROSPS_VW

(SQL View)
Index Back

SP Analysis Roster Fact

SP Analysis Roster Fact

SELECT A.OPRID ,A.BUSINESS_UNIT ,A.PROJECT_ID , B.DESCR ,COUNT(DISTINCT A.WO_CONID) FROM PS_SPR_ROSTER_FACT A , PS_SPR_PROJECT_DIM B WHERE A.BUSINESS_UNIT_PC = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID GROUP BY A.OPRID ,A.BUSINESS_UNIT ,A.PROJECT_ID , B.DESCR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: SP_PROJ_NONVW

4 SP_PROJECT_DESCR Character(30) VARCHAR2(30) NOT NULL Project Description
5 SPR_CONCOUNT Number(15,0) DECIMAL(15) NOT NULL Contractor Count