EMPLIDCAL_RUN_IDRUN_CNTL_IDGPXPYE_HIS2_WRK(SQL Table) |
Index Back |
|---|---|
History Segment Pointer AidHistory Segment Pointer for the Global Absence and Payroll process. The table is populated during the Identify phase and then emptied during the Cancel or Finalize phase for entries for that Cal Run ID. The purpose is to give the calculation process a pointer back to the most up-to-date balances. This table helps marking the globally latest up-to-date balance across both absence and payroll |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | PRC_ORD_TS | DateTime(26) | TIMESTAMP | Process Order Timestamp |
| 6 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |