TL_ADMD_SRCH_LG(SQL View) |
Index Back |
---|---|
T&L EMPL_RCD F4 prompt viewThis view is a clone of TL_ADM_SRCH_VW with EMP_RCD set as a key. 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 , %DateIn(%Date('1900-01-01')) , A.LANGUAGE_CD , A.JOBCODE_DESCR FROM PS_TL_ADM_EERCDLNG A |
# | 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 Record |
4 | DUR | Date(10) | DATE |
Date Under Report associates time being reported, scheduled or paid, to a specific date.
Default Value: %Date |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |