EMPLIDEMPL_RCDDURSEQ_NBRTL_SRCH_KEY_VW(SQL View) |
Index Back |
|---|---|
Search Rec for TL Search Comp |
| SELECT A.EMPLID , A.EMPL_RCD , A.DUR , A.SEQ_NBR FROM PS_TL_RPTD_TIME A UNION SELECT A.EMPLID , A.EMPL_RCD , A.DUR , A.SEQ_NBR FROM PS_TL_PAYABLE_TIME A UNION SELECT A.EMPLID , A.EMPL_RCD , A.DUR , A.SEQ_NBR FROM PS_TL_EXCEPTION A |
| # | 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 | DUR |
Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |