TL_WC_ATNACT_VW(SQL View) |
Index Back |
|---|---|
Attndnce Action TL WrkCenterFetches all Attendance Action |
| SELECT DISTINCT A.OPRID , A.ROWSECCLASS , A.EMPLID , B.DUR , N.NAME_DISPLAY , N.LAST_NAME , N.FIRST_NAME , B.PUNCH_BEGIN , B.EXCEPTION_ID , B.ACTION_RQRD , B.DATE_CLEAR , E.DESCR FROM PS_TL_ADM_SRCH_VW A , PS_TL_ATTENDANCE B , PS_NAMES N , PS_TL_EXCEPT_DEFN E WHERE A.EMPLID = B.EMPLID AND B.EXCEPTION_ID=E.EXCEPTION_ID AND %EffdtCheck(TL_EXCEPT_DEFN, E, %CurrentDateIn) AND A.EMPLID = N.EMPLID AND N.NAME_TYPE = 'PRI' AND N.EFFDT = ( SELECT MAX(SN.EFFDT) FROM PS_NAMES SN WHERE SN.EMPLID = N.EMPLID AND SN.NAME_TYPE=N.NAME_TYPE AND SN.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 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 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 8 | PUNCH_BEGIN | DateTime(26) | TIMESTAMP | Punch Time |
| 9 | EXCEPTION_ID | Character(8) | VARCHAR2(8) NOT NULL | Exception ID |
| 10 | ACTION_RQRD | Character(30) | VARCHAR2(30) NOT NULL | Action Required |
| 11 | DATE_CLEAR | Date(10) | DATE | Date Cleared |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |