NH Retirement Payroll Report - nhretdemo table
The following table lists the column names, data types, and the valid data codes or format of the nhretdemo 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 |
Batch ID | Integer/10 | The valid number for each month is obtained from the ERS website. If this is a DEMO or UNSCH batch, the Batch ID should be 0. |
Fund ID | Integer/10 | 1 |
Employer ID | String/30 | The valid value is the ID assigned by NHRS. |
Fiscal Year | Integer/4 |
|
Report Date | Smalldatetime | YYYY-MM-DD |
First Name | Character/25 | Upper case |
Last Name | Character/25 | Upper case |
Gender | Character/1 | Valid values:
|
Birth Date | Smalldatetime | YYYY-MM-DD |
Entry Date | Smalldatetime | YYYY-MM-DD |
Employment Date | Smalldatetime | YYYY-MM-DD |
Is New Member | Character/1 | Valid values:
|
Address Effective Date | Smalldatetime | YYYY-MM-DD |
Address Type | Character/5 | The valid value is HOME |
Address Line 1 | Character/30 | Not applicable |
Address Line 2 | Character/30 | Not applicable |
City | Character/30 | Not applicable |
State | Character/2 | Not applicable |
Zip | Character/9 | Not applicable |
Country | Character/5 | Vaid values:
|
Phone 1 Type | Character/5 | Valid values:
|
Country Code | Character/5 | International calling code. The valid value is 1 |
Area Code | Character/3 | Defaults to 603. |
Phone 1 | Character/15 | XXX-XXX-XXXX It can include the area code. |
Phone 2 Type | Character/5 | Valid values:
|
Phone 2 | Character/15 | XXX-XXX-XXXX It can include the area code. |
Phone 3 Type | Character/5 | Valid values:
|
Phone 3 | Character/15 | XXX-XXX-XXXX It can include the area code. |
Email Type | Character/4 | Valid values:
|
Email Address | Character/50 | Not applicable |
Email 2 Type | Character/4 | Valid values:
|
Email Address 2 | Character/50 | Not applicable |
Middle Name | Character/25 | Upper case |
Suffix | Character/5 | JR., SR., III, IV, V |
Marital Status | Character/4 | Valid values:
|
Rehire | Character/1 | Valid values:
|
Hire Date | smalldatetime | YYYY-MM-DD |
Participation Begin Date | smalldatetime | YYYY-MM-DD |
Termination Date | smalldatetime | YYYY-MM-DD |
Termination Reason | Character/4 | Valid values:
|
Death Date | smalldatetime | YYYY-MM-DD |
Death Type | Character/4 | Valid values:
|
Final Report | Character/1 | Valid values:
|
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.
You can have a scheduled and unscheduled batch for each pay period start date and pay period end date.
For each combination of employee number, pay date, pay period start date, and pay period end date, you can have a regular and an adjustment record type.