TL_APP_APPRV_VW

(SQL View)
Index Back

TL Approvers

Operator IDs linked to approvers listed in approver TL Groups

SELECT D.TL_GROUP_ID ,D.EMPLID ,O.OPRID ,MIN(D.TL_APPR_PRIORITY) FROM PS_TL_GROUP_DTL D , PSOPRDEFN O WHERE D.EMPLID = O.EMPLID GROUP BY D.TL_GROUP_ID ,D.EMPLID , O.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TL_GROUP_ID Character(7) VARCHAR2(7) NOT NULL Time and Labor Groups
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 TL_APPR_PRIORITY Number(3,0) SMALLINT NOT NULL Used to set a sequence priority for approvers assigned to a TL Approval Group