T1708 - Exhibit 6 ENF CSESP INCOMING 11.07.2025.docx

DOCX document 26 KB Posted

Attached to
T1708 - New Hire, National Medical Support Notification, Child Support Employer Portal
Solicitation number
26DPP01238
Issued by
New Jersey

About this file

Written by GovTribe AI ·

This is a technical specification document detailing the file layout and data structure for the LOAD_CSESP_DETAILS.TXT file, which is managed by a child support enforcement agency and processes employer registration information from the Child Support Employer Services Portal (CSESP). The file is transmitted via FTP and loaded into a staging table within the Stellarware system. The incoming file contains comprehensive employer details including employer identification numbers, Federal Employer Identification Numbers (FEIN), business names, Doing Business As (DBA) information, and contact information across multiple departments: Headquarters (HQ), New Hire Reporting (NHR), New Medical Support Notice (NMSN), Income Withholding (IW), Unemployment Insurance (UI), Workers' Compensation (WC), and Pension contact types. The file structure is fixed-format with a maximum estimated size of 1.1 MB and contains 2,981 total character positions with fields encompassing employer addresses, contact names, telephone numbers, fax numbers, email addresses, preference codes, and creation/update timestamps formatted as YYYYMMDDHHMISS.

All fields from the LOAD_CSESP_DETAILS.TXT file are mapped directly to corresponding fields in the LOAD_CSESP_DETAILS database table without transformation or manipulation. The file format uses character (C), date (D), and numeric (N) data types, with character fields for text data and numeric fields for employer IDs, parent company IDs, FEINs, and record identifiers. Contact preference codes and document preference codes are captured as single-character indicators for each contact type. The system accommodates multiple contact types per employer, allowing for flexibility in routing communications and documentation based on organizational structure and designated contact preferences.

View the file

Other files

File Type Posted
T1708 Bid Solicitation Checklist 11.07.2025.2025 —
T1708- NJThird Party Information Security Questionnaire 11.07.2025.pdf PDF
T1708-New Jersey Standard Terms and Conditions 11.07.2025.pdf PDF
T1708 Exhibit 7 Monitoring_Escalation Process update 11.07.25.docx DOCX document
T1708 - Exhibit 2 Technical Environment 11.07.2025.pdf PDF
TT1708 - Exhibit 1 File Transfer Guide 11.07.2025.docx DOCX document
T1708 - Exhibit 3 LOAD FULLNEWHIRE 11.07.2025.docx DOCX document
T1708 - Exhibit 4 EXT NEWMEMBER STATEHIRE 11.07.2025.docx DOCX document
T1708 State Supplied Price Sheet 11.07.2025.xlsx XLSX spreadsheet
T1708 - Exhibit 5 SP EXT MEMBER STATEHIRE 11.07.2025.docx DOCX document
T1708 Bid Solicitation 11.07.2025.docx DOCX document
T1708 Pre-Quote Conference 11.07.25.pptx PPTX presentation
Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

EXHIBIT 10 – ENF_CSESP_INCOMING

Reads the employer details received from Child Support Employer Services Portal (CSESP) registration file and loads into a staging table.

S.No
Name of the File
File Format
Transfer Mechanism
File location
Estimated size (in MBs)
1
LOAD_CSESP_DETAILS.TXT
-
FTP
-
-

1.1.1.11.1 File Layout

Field Name
Position
Length
Type
Format / Default Value
Description

C-Char

D-Date

N-Number

EMPLOYER_ID
01-10
10
N

Stellarware Employer ID

PARENT_ID
11-20
10
N

Parent Company Employer ID

FEIN
21-29
9
N

Employer FEIN

NAME
30-89
60
C

Employer Name

DBA
90-119
30
C

Employer DBA

WEB_NMSN
120-120
1
C
N
Web NMSN
ELECTRONIC_IWN
121-121
1
C
N
Electronic Income Withholding Notice
EMP_PROCESS_IND
122-122
1
C

Indicator Field

CREATED_DATE
123-136
14
N
YYYYMMDDHHMISS
Employer Created
UPDATED_DATE
137-150
14
N
YYYYMMDDHHMISS
Employer Updated
H_CONTACT_TYPE
151-151
1
C

HQ Contact Type

H_REC_ID
152-161
10
N

HQ Stellarware record ID

H_ID_OTHP
162-170
9
N

HQ NJKIDS OTHP ID

H_ADDRESS1
171-220
50
C

HQ Address Line 1

H_ADDRESS2
221-270
50
C

HQ Address Line 2

H_ADDRESS3
271-320
50
C

HQ Address Line 3

H_CITY
321-348
28
C

HQ City

H_STATE
349-350
2
C

HQ State

H_ZIP
351-365
15
C

HQ Zip

H_COUNTRY
366-367
2
C

HQ Country

H_ADDR_CREATED_DATE
368-381
14
N
YYYYMMDDHHMISS
HQ Address Created
H_ADDR_UPDATED_DATE
382-395
14
N
YYYYMMDDHHMISS
HQ Address Updated
H_NAME
396-425
30
C

HQ Contact Name

H_PHONE
426-440
15
C

HQ Contact Phone

H_FAX
441-455
15
C

HQ Contact Fax

H_EMAIL
456-515
60
C

HQ Contact Email

H_PREF
516-516
1
C

HQ Contact Preference Code

H_DPREF
517-517
1
C

HQ Document Preference Code

H_CONTACT_CREATED_DATE
518-531
14
N
YYYYMMDDHHMISS
HQ Contact Created
H_CONTACT_UPDATED_DATE
532-545
14
N
YYYYMMDDHHMISS
HQ Contact Updated
N_SAME_AS_CORPORATE
546-546
1
C

NHR Address Same As Corporate

N_CONTACT_TYPE
547-547
1
C

NHR Contact Type

N_THIRD_PARTY_ID
548-557
10
N

NHR Third Party ID

N_REC_ID
558-567
10
N

NHR Stellarware record ID

N_ID_OTHP
568-576
9
N

NHR NJKIDS OTHP ID

N_ADDRESS1
577-626
50
C

NHR Address Line 1

N_ADDRESS2
627-676
50
C

NHR Address Line 2

N_ADDRESS3
677-726
50
C

NHR Address Line 3

N_CITY
727-754
28
C

NHR City

N_STATE
755-756
2
C

NHR State

N_ZIP
757-771
15
C

NHR Zip

N_COUNTRY
772-773
2
C

NHR Country

N_ADDR_CREATED_DATE
774-787
14
N
YYYYMMDDHHMISS
NHR Address Created
N_ADDR_UPDATED_DATE
788-801
14
N
YYYYMMDDHHMISS
NHR Address Updated
N_NAME
802-831
30
C

NHR Contact Name

N_PHONE
832-846
15
C

NHR Contact Phone

N_FAX
847-861
15
C

NHR Contact Fax

N_EMAIL
862-921
60
C

NHR Contact Email

N_PREF
922-922
1
C

NHR Contact Preference Code

N_DPREF
923-923
1
C

NHR Document Preference Code

N_CONTACT_CREATED_DATE
924-937
14
N
YYYYMMDDHHMISS
NHR Contact Created
N_CONTACT_UPDATED_DATE
938-951
14
N
YYYYMMDDHHMISS
NHR Contact Updated
M_CONTACT_TYPE
952-952
1
C

NMSN Contact Type

M_SAME_AS_CORPORATE
953-953
1
C

NMSN Address Same As Corporate

M_THIRD_PARTY_ID
954-963
10
N

NMSN Third Party ID

M_REC_ID
964-973
10
N

NMSN Stellarware record ID

M_ID_OTHP
974-982
9
N

NMSN NJKIDS OTHP ID

M_ADDRESS1
983-1032
50
C

NMSN Address Line 1

M_ADDRESS2
1033-1082
50
C

NMSN Address Line 2

M_ADDRESS3
1083-1132
50
C

NMSN Address Line 3

M_CITY
1133-1160
28
C

NMSN City

M_STATE
1161-1162
2
C

NMSN State

M_ZIP
1163-1177
15
C

NMSN Zip

M_COUNTRY
1178-1179
2
C

NMSN Country

M_ADDR_CREATED_DATE
1180-1193
14
N
YYYYMMDDHHMISS
NMSN Address Created
M_ADDR_UPDATED_DATE
1194-1207
14
N
YYYYMMDDHHMISS
NMSN Address Updated
M_NAME
1208-1237
30
C

NMSN Contact Name

M_PHONE
1238-1252
15
C

NMSN Contact Phone

M_FAX
1253-1267
15
C

NMSN Contact Fax

M_EMAIL
1268-1327
60
C

NMSN Contact Email

M_PREF
1328-1328
1
C

NMSN Contact Preference Code

M_DPREF
1329-1329
1
C

NMSN Document Preference Code

M_CONTACT_CREATED_DATE
1330-1343
14
N
YYYYMMDDHHMISS
NMSN Contact Created
M_CONTACT_UPDATED_DATE
1344-1357
14
N
YYYYMMDDHHMISS
NMSN Contact Updated
I_CONTACT_TYPE
1358-1358
1
C

IW Contact Type

I_SAME_AS_CORPORATE
1359-1359
1
C

IW Address Same As Corporate

I_THIRD_PARTY_ID
1360-1369
10
N

IW Third Party ID

I_REC_ID
1370-1379
10
N

IW Stellarware record ID

I_ID_OTHP
1380-1388
9
N

IW NJKIDS OTHP ID

I_ADDRESS1
1389-1438
50
C

IW Address Line 1

I_ADDRESS2
1439-1488
50
C

IW Address Line 2

I_ADDRESS3
1489-1538
50
C

IW Address Line 3

I_CITY
1539-1566
28
C

IW City

I_STATE
1567-1568
2
C

IW State

I_ZIP
1569-1583
15
C

IW Zip

I_COUNTRY
1584-1585
2
C

IW Country

I_ADDR_CREATED_DATE
1586-1599
14
N
YYYYMMDDHHMISS
IW Address Created
I_ADDR_UPDATED_DATE
1600-1613
14
N
YYYYMMDDHHMISS
IW Address Updated
I_NAME
1614-1643
30
C

IW Contact Name

I_PHONE
1644-1658
15
C

IW Contact Phone

I_FAX
1659-1673
15
C

IW Contact Fax

I_EMAIL
1674-1733
60
C

IW Contact Email

I_PREF
1734-1734
1
C

IW Contact Preference Code

I_DPREF
1735-1735
1
C

IW Document Preference Code

I_CONTACT_CREATED_DATE
1736-1749
14
N
YYYYMMDDHHMISS
IW Contact Created
I_CONTACT_UPDATED_DATE
1750-1763
14
N
YYYYMMDDHHMISS
IW Contact Updated
U_CONTACT_TYPE
1764-1764
1
C

UI Contact Type

U_SAME_AS_CORPORATE
1765-1765
1
C

UI Address Same As Corporate

U_THIRD_PARTY_ID
1766-1775
10
N

UI Third Party ID

U_REC_ID
1776-1785
10
N

UI Stellarware record ID

U_ID_OTHP
1786-1794
9
N

UI NJKIDS OTHP ID

U_ADDRESS1
1795-1844
50
C

UI Address Line 1

U_ADDRESS2
1845-1894
50
C

UI Address Line 2

U_ADDRESS3
1895-1944
50
C

UI Address Line 3

U_CITY
1945-1972
28
C

UI City

U_STATE
1973-1974
2
C

UI State

U_ZIP
1975-1989
15
C

UI Zip

U_COUNTRY
1990-1991
2
C

UI Country

U_ADDR_CREATED_DATE
1992-2005
14
N
YYYYMMDDHHMISS
UI Address Created
U_ADDR_UPDATED_DATE
2006-2019
14
N
YYYYMMDDHHMISS
UI Address Updated
U_NAME
2020-2049
30
C

UI Contact Name

U_PHONE
2050-2064
15
C

UI Contact Phone

U_FAX
2065-2079
15
C

UI Contact Fax

U_EMAIL
2080-2139
60
C

UI Contact Email

U_PREF
2140-2140
1
C

UI Contact Preference Code

U_DPREF
2141-2141
1
C

UI Document Preference Code

U_CONTACT_CREATED_DATE
2142-2155
14
N
YYYYMMDDHHMISS
UI Contact Created
U_CONTACT_UPDATED_DATE
2156-2169
14
N
YYYYMMDDHHMISS
UI Contact Updated
W_CONTACT_TYPE
2170-2170
1
C

WC Contact Type

W_SAME_AS_CORPORATE
2171-2171
1
C

WC Address Same As Corporate

W_THIRD_PARTY_ID
2172-2181
10
N

WC Third Party ID

W_REC_ID
2182-2191
10
N

WC Stellarware record ID

W_ID_OTHP
2192-2200
9
N

WC NJKIDS OTHP ID

W_ADDRESS1
2201-2250
50
C

WC Address Line 1

W_ADDRESS2
2251-2300
50
C

WC Address Line 2

W_ADDRESS3
2301-2350
50
C

WC Address Line 3

W_CITY
2351-2378
28
C

WC City

W_STATE
2379-2380
2
C

WC State

W_ZIP
2381-2395
15
C

WC Zip

W_COUNTRY
2396-2397
2
C

WC Country

W_ADDR_CREATED_DATE
2398-2411
14
N
YYYYMMDDHHMISS
WC Address Created
W_ADDR_UPDATED_DATE
2412-2425
14
N
YYYYMMDDHHMISS
WC Address Updated
W_NAME
2426-2455
30
C

WC Contact Name

W_PHONE
2456-2470
15
C

WC Contact Phone

W_FAX
2471-2485
15
C

WC Contact Fax

W_EMAIL
2486-2545
60
C

WC Contact Email

W_PREF
2546-2546
1
C

WC Contact Preference Code

W_DPREF
2547-2547
1
C

WC Document Preference Code

W_CONTACT_CREATED_DATE
2548-2561
14
N
YYYYMMDDHHMISS
WC Contact Created
W_CONTACT_UPDATED_DATE
2562-2575
14
N
YYYYMMDDHHMISS
WC Contact Updated
P_CONTACT_TYPE
2576-2576
1
C

Pension Contact Type

P_SAME_AS_CORPORATE
2577-2577
1
C

Pension Address Same As Corporate

P_THIRD_PARTY_ID
2578-2587
10
N

Pension Third Party ID

P_REC_ID
2588-2597
10
N

Pension Stellarware record ID

P_ID_OTHP
2598-2606
9
N

Pension NJKIDS OTHP ID

P_ADDRESS1
2607-2656
50
C

Pension Address Line 1

P_ADDRESS2
2657-2706
50
C

Pension Address Line 2

P_ADDRESS3
2707-2756
50
C

Pension Address Line 3

P_CITY
2757-2784
28
C

Pension City

P_STATE
2785-2786
2
C

Pension State

P_ZIP
2787-2801
15
C

Pension Zip

P_COUNTRY
2802-2803
2
C

Pension Country

P_ADDR_CREATED_DATE
2804-2817
14
N
YYYYMMDDHHMISS
Pension Address Created
P_ADDR_UPDATED_DATE
2818-2831
14
N
YYYYMMDDHHMISS
Pension Address Updated
P_NAME
2832-2861
30
C

Pension Contact Name

P_PHONE
2862-2876
15
C

Pension Contact Phone

P_FAX
2877-2891
15
C

Pension Contact Fax

P_EMAIL
2892-2951
60
C

Pension Contact Email

P_PREF
2952-2952
1
C

Pension Contact Preference Code

P_DPREF
2953-2953
1
C

Pension Document Preference Code

P_CONTACT_CREATED_DATE
2954-2967
14
N
YYYYMMDDHHMISS
Pension Contact Created
P_CONTACT_UPDATED_DATE
2968-2981
14
N
YYYYMMDDHHMISS
Pension Contact Updated

All the fields from the load file are mapped directly to the corresponding fields in the LOAD_CSESP_DETAILS table.

File details come from the government source that posted it. Updated .