OPERATORTL_PG_TLSECR(SQL View) |
Index Back |
|---|---|
Time and Labor SecurityTime and Labor Group security |
| SELECT C.OPRID , A.EMPLID , A.EMPL_RCD FROM PS_TL_GROUP_DTL A , PS_TL_GRP_SECURITY B , PSOPRDEFN C WHERE ( A.TL_GROUP_ID = B.TL_GROUP_ID AND B.ROWSECCLASS = C.ROWSECCLASS AND C.OPRID IN ( SELECT D.ROLEUSER FROM PSROLEUSER D WHERE D.ROLENAME IN ('Time & Labor Administrator','Manager')) ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPERATOR |
Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |