EMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDSRC_CAL_IDSRC_CAL_RUN_IDPI_VER_NUMGP_TL_PIHD2_WRK(SQL Table) |
Index Back |
|---|---|
T&L Interface temporary tableTable is used during the GP TLCOST AE process. It is populated with rows for each payee with PI header that contained PI from TL that require update back to the TL_PAYABLE_TIME table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 5 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 6 | SRC_CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | Source Calendar ID |
| 7 | SRC_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |
| 8 | PI_VER_NUM |
Number(3,0) | SMALLINT NOT NULL | PI version number |