SPR_CONROSMS_VW

(SQL View)
Index Back

SP Analysis Roster Fact

SP Analysis Roster Fact

SELECT A.OPRID ,A.BUSINESS_UNIT ,A.WO_CLIID ,A.TE_APPROVER ,B.NAME ,COUNT(DISTINCT A.WO_CONID) ,1 FROM PS_SPR_ROSTER_FACT A ,PS_SPR_EMPLID_DIM B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.OPRID = A.WO_CLIID GROUP BY A.OPRID ,A.BUSINESS_UNIT ,A.TE_APPROVER ,B.NAME,A.WO_CLIID

# 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 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
4 TE_APPROVER Character(30) VARCHAR2(30) NOT NULL Time Approver

Prompt Table: SPF_APPROVER_VW

5 SP_MANAGER_NAME Character(50) VARCHAR2(50) NOT NULL Requester Name
6 SPR_CONCOUNT Number(15,0) DECIMAL(15) NOT NULL Contractor Count
7 SPR_AVG_CONCOUNT Number(15,0) DECIMAL(15) NOT NULL Contractor Count