TL_WC_ATTEND_VW(SQL View) |
Index Back |
---|---|
Attndnce Hist for TL WrkCenterFetches Attendance Hist for TL Fluid WrkCenter |
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.ATTEND_POINTS , B.ATTEND_TOTAL , B.IN_PERIOD , E.DESCR FROM PS_TL_ADM_SRCH_VW A , PS_TL_ATTEND_HIST 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 | ATTEND_POINTS | Number(6,2) | DECIMAL(5,2) NOT NULL | Points |
11 | ATTEND_TOTAL | Number(6,2) | DECIMAL(5,2) NOT NULL | Points Accumulated |
12 | IN_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
In Current Attendance Period
Y/N Table Edit |
13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |