NH Monthly Retirement Report - nhretpayp table
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/2 | 21 |
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 report month, you can have multiple records in the nhretpayp table.