COMPANYPrompt Table: COMPANY_TBL
PAYGROUPPrompt Table: PAYGROUP_TBL
PAY_END_DTPrompt Table: PAY_CALENDAR
OFF_CYCLEY/N Table Edit
PAGE_NUMLINE_NUMSEPCHKEMPL_RCDERNCD_SPCLPA_HST_SPL_EARN(SQL Table) |
Index Back |
|---|---|
Historical Payroll DataThis is an employee table containing Historical Payroll Data. This is copied directly from the Payroll tables and retained within Pension. This record contains paycheck information for special earnings accumulators. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 3 | PAY_END_DT |
Date(10) | DATE NOT NULL |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
| 4 | OFF_CYCLE |
Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit |
| 5 | PAGE_NUM |
Number(5,0) | INTEGER NOT NULL | Page Nbr |
| 6 | LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Line Nbr |
| 7 | SEPCHK |
Number(2,0) | SMALLINT NOT NULL | Separate check number. |
| 8 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 9 | ERNCD_SPCL |
Character(3) | VARCHAR2(3) NOT NULL | Special Accumulator Code |
| 10 | SPCL_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Special Hours |
| 11 | SPCL_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Special Earnings |