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: SCHED = scheduled UNSCH = unscheduled DEMO = demographic
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	2024 (for pay dates on or after July 1, 2023) 2025 (for pay dates on or after July 1, 2024)
Report Date	Smalldatetime	YYYY-MM-DD
First Name	Character/25	Upper case
Last Name	Character/25	Upper case
Gender	Character/1	Valid values: M=Male F=Female U=Unknown
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: T=True F=False
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: CAN - 107 MEX - 335 USA - 481
Phone 1 Type	Character/5	Valid values: CELLU=cellular FAX=fax number HOME=home PH=main phone WORK=work or office SEM=seminar phone
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: CELLU=cellular FAX=fax number HOME=home PH=main phone WORK=work or office SEM=seminar phone
Phone 2	Character/15	XXX-XXX-XXXX It can include the area code.
Phone 3 Type	Character/5	Valid values: CELLU=cellular FAX=fax number HOME=home PH=main phone WORK=work or office SEM=seminar phone
Phone 3	Character/15	XXX-XXX-XXXX It can include the area code.
Email Type	Character/4	Valid values: Main Other
Email Address	Character/50	Not applicable
Email 2 Type	Character/4	Valid values: Main Other
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: Single - 2068 Married - 2071 Separated - 2073 Divorced - 2075 Unknown - 2077 Widowed - 3470 Domestic Partner - 573
Rehire	Character/1	Valid values: T=True F=False
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: Terminated Employment - 0312 Settlement - 0311 Death - 4
Death Date	smalldatetime	YYYY-MM-DD
Death Type	Character/4	Valid values: Duty - 2419 Nonduty - 2422 Violent - 2424
Final Report	Character/1	Valid values: T=True F=False
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.