EMPLIDEMPL_RCDAS_OF_DATETRN_TRACK_DIF(SQL Table) |
Index Back |
|---|---|
Track DIF HistoryThis table is used by the DIF message to publish DIF information to ELM. |
| # | 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 Rcd Nbr |
| 3 | AS_OF_DATE |
Date(10) | DATE NOT NULL | As of Date |
| 4 | TRN_DIF_BAL_HRS | Signed Number(13,3) | DECIMAL(11,3) NOT NULL | DIF Balance in Hours |
| 5 | TRN_DIF_LIMIT_HRS | Number(6,1) | DECIMAL(5,1) NOT NULL | DIF Limit Hours |