SPR_CONPERMS_VW

(SQL View)
 Index Back

SP Analysis Roster Fact

SP Analysis Roster Fact

SELECT A.OPRID ,A.BUSINESS_UNIT ,A.APPROVAL_OPRID ,B.NAME ,AVG(A.APPR_RATING_NUM) FROM PS_SPR_CONPER_FACT A , PS_SPR_EMPLID_DIM B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.OPRID= A.APPROVAL_OPRID GROUP BY A.OPRID,A.BUSINESS_UNIT ,A.APPROVAL_OPRID ,B.NAME

# 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 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
4 SP_MANAGER_NAME Character(50) VARCHAR2(50) NOT NULL Requester Name
5 APPR_RATING_NUM Number(4,2) DECIMAL(3,2) NOT NULL Performance Rating