PA_HST_PAY_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 payroll affecting information such as earnings, hours, location, tax information, etc. It is the core record for the payroll process. An employee might have more than one pay earning record depending on other payroll affecting activity during the pay period, such as change in pay rate, job, etc. Each pay earning record may have one or more subordinate Pay Other Earnings record(s). |
| # | 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 Default Value: N |
| 5 | PAGE_NUM |
Number(5,0) | INTEGER NOT NULL | Page Nbr |
| 6 | LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Line Nbr |
| 7 | ADDL_NBR |
Number(3,0) | SMALLINT NOT NULL | Additional Pay Line Nbr |
| 8 | SEPCHK | Number(2,0) | SMALLINT NOT NULL | Separate check number. |
| 9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 11 | EARNS_END_DT | Date(10) | DATE |
Earnings End Date
Default Value: PAY_EARNINGS.PAY_END_DT |
| 12 | EARNS_BEGIN_DT | Date(10) | DATE |
Earnings Begin Date
Default Value: PAY_CALENDAR.PAY_BEGIN_DT |
| 13 | ERNCD_REG_HRS | Character(3) | VARCHAR2(3) NOT NULL |
Regular Hours Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_REG_HRS |
| 14 | ERNCD_OT_HRS | Character(3) | VARCHAR2(3) NOT NULL |
OT Hours Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_OT_HRS |
| 15 | REG_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Regular Hours |
| 16 | OT_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Overtime Hours |
| 17 | REG_HRLY_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Regular Hourly Earnings |
| 18 | OT_HRLY_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Overtime Hourly Earnings |
| 19 | ERNCD_REG_EARNS | Character(3) | VARCHAR2(3) NOT NULL |
Regular Earns Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS |
| 20 | REG_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Regular Earnings |
| 21 | REG_EARN_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Regular Earnings Hours |