TL_ST_PCHTM_VW(SQL View) |
Index Back |
|---|---|
ST_PCHTIME viewView introduced for TL_ST_LD_DMN process. It is used to help determine EEs with pending transactions in TL_ST_PCHTIME. |
| SELECT EMPLID , EMPL_RCD , MIN(PUNCH_DTTM) , COUNT(*) FROM PS_TL_ST_PCHTIME A WHERE (ST_INSTANCE = 0 OR ST_INSTANCE IN ( SELECT PRCSINSTANCE FROM PSPRCSRQST WHERE RUNSTATUS IN ('2','3','10','8'))) AND NOT EXISTS ( SELECT 1 FROM PS_TL_ST_PCHTIME B , PSPRCSRQST R WHERE R.PRCSINSTANCE = B.ST_INSTANCE AND B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND R.RUNSTATUS IN ('4','5','6','7','9')) GROUP BY EMPLID, EMPL_RCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | PUNCH_DTTM | DateTime(26) | TIMESTAMP | Date and time when the punch occurred. |
| 4 | COUNTER | Signed Number(6,0) | DECIMAL(5) NOT NULL | Counter |