CAL_RUN_IDEMPLIDEMPL_RCDTL_ABS_DEL_ST(SQL Table) |
Index Back |
|---|---|
ECD reset during payrol cancelThis Table is used for holding the Employee data that is being deleted during cancel and suspend run and later to be used for reset of ECD of these EMPLID. This table is populated when GP_PAYBEFORE runs only for cancel and suspend runs and used in TL_ABS_GENPT. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | EFFDT | Date(10) | DATE | Effective Date |
| 5 | END_DT | Date(10) | DATE | end date |