EMPLIDCAL_RUN_IDGP_PAYGROUPCAL_IDEMPL_RCDGP_EXCL_WRK(SQL Table) |
Index Back |
|---|---|
Payee Slctn temporary tableWork table used during the Identify process Incrementally populated with data from rows previously inserted into GP PYE PRC STAT to prevent duplicating the insert for payees that qualify for selection for more than one reason |
| # | 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 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 4 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |