The following table lists the column names, data types, and the valid data codes or format of the nhretpayp table.
|
Column Name |
Data Type |
Valid Data Codes or Format |
|---|---|---|
|
Begin Date |
Smalldatetime |
YYYY-MM-DD |
|
End Date |
Smalldatetime |
YYYY-MM-DD |
|
Batch Type |
Character/5 |
Valid values:
|
|
SSN |
Character/15 |
999999999 or 999-99-9999 |
|
Pay Period End Date |
Smalldatetime |
YYYY-MM-DD |
|
Pay Period ID |
Integer/10 |
Normally 1 – 12 or 1 – 27 |
|
Pay Date |
Smalldatetime |
YYYY-MM-DD |
|
Action |
Character/1 |
Valid values:
|
|
SPC Payment |
Decimal(9,2) |
999999999.99 |
|
Earnable Salary |
Decimal(9,2) |
999999999.99 |
|
Gross Salary |
Decimal(9,2) |
999999999.99 (No longer used) |
|
Pensionable Salary |
Decimal(9,2) |
999999999.99 (No longer used) |
|
Units Worked |
Decimal(9,2) |
999999999.99 |
|
Units Worked Indicator |
Character/5 |
The valid value is MON (Monthly). |
|
Employment Type |
Character/5 |
Valid values:
|
|
Employment Type Effective Date |
Smalldatetime |
YYYY-MM-DD |
|
Job Class |
Character/5 |
Valid values:
|
|
Job Class Effective Date |
Smalldatetime |
YYYY-MM-DD |
|
Current Pre Tax Amount |
Decimal(9,2) |
999999999.99 |
|
Current Post Tax Amount |
Decimal(9,2) |
999999999.99 |
|
Additional Pre Tax Amount |
Decimal(9,2) |
999999999.99 |
|
Additional Post Tax Amount |
Decimal(9,2) |
999999999.99 |
|
Base Salary |
Decimal(9,2) |
999999999.99 |
|
Compensation Over Base |
Decimal(9,2) |
999999999.99 |
|
Extra or Special Duty Pay |
Decimal(9,2) |
999999999.99 |
|
Employer Pre Tax Amount |
Decimal(9,2) |
999999999.99 |
|
Employer Post Tax Amount |
Decimal(9,2) |
999999999.99 |
|
Medical Subsidy Pre Tax Amount |
Decimal(9,2) |
999999999.99 |
|
Medical Subsidy Post Tax Amount |
Decimal(9,2) |
999999999.99 |
|
Subgroup |
Character/4 |
Valid values:
|
|
Contract Begin Date |
Smalldatetime |
YYYY-MM-DD |
|
Contract End Date |
Smalldatetime |
YYYY-MM-DD |
|
Contract Salary |
Decimal(9,2) |
999999999.99 |
|
Pay Period Frequency |
Character/4 |
Valid values:
|
|
Job Share |
Character/1 |
Not applicable |
|
Job Share position |
Integer/6 |
123456 |
|
Apply Subsequently |
Character/1 |
Not applicable |
|
Employee Number |
Integer/15 |
12345 |
|
Version |
Character/1 |
This field is not in the user interface. |
For each record in the nhretdemo table for a reporting month, you can have multiple records in the nhretpayp table.