ROWSECCLASSEMPLIDEMPL_RCDDURSCH_MNG_SCH_VW(SQL View) |
Index Back |
|---|---|
Manage Schedule Search VwThe view returns the employee names and job titles for each Time Reporter the operator has access to, and for each date where theTime Reporters have Schedule Workday Overrides. Access is determined by the TL Group Security defined for the Operator's Row Security Class. When the Operator's Row Security Class has no specific Group Security, HR Department Security is used to determine access. |
| SELECT A.ROWSECCLASS , A.EMPLID , A.EMPL_RCD , B.DUR , A.NAME , A.JOBCODE , A.JOBCODE_DESCR , A.TL_SYSTEM_DT FROM PS_TL_ADM_SRCH_VW A , PS_SCH_MNG_SCH_TBL B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROWSECCLASS |
Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | DUR |
Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 8 | TL_SYSTEM_DT | Date(10) | DATE | TL System Date |