TL_APP_APPRV_VW(SQL View) |
Index Back |
---|---|
TL ApproversOperator 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 |