Attachment_A_Interface_Filelayout_Information_09-08-2017.xlsx

XLSX spreadsheet 40 KB Posted Jun 28, 2018

Attached to: Third-Party Benefits Administration
Solicitation number: USCA19R0092
Issued by: The Judicial Branch

About this file

From the source

Attachment A

View the file

Other files

File	Type	Posted
USCA18R0092_0001_Signed_073118.pdf	PDF	Jul 31, 2018
Attachment_D_Pricing_Table_073118.xlsx	XLSX spreadsheet	Jul 31, 2018
Questions_and_Responses_for_USCA18R0092_072018_v2.pdf	PDF	Jul 20, 2018
USCA18R0092_062818_v2.pdf	PDF	Jun 28, 2018
Attachment_D_Pricing_Table_062818.xlsx	XLSX spreadsheet	Jun 28, 2018
Attachment_E_Past_Performance_Evaluation_Questionnaire_Form_061318.pdf	PDF	Jun 28, 2018
Attachment_B_Application_Security_Plan_Sample.pdf	PDF	Jun 28, 2018
Attachment_C_Flex_Plan_Document_effective_Jan_1_2015.pdf	PDF	Jun 28, 2018

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.

JLHM2912

Header Row
Field	Seq #	Field Length	Format
Record Type	1	3	"HDR" Value
Control Number	2	9	Assigned By Vendor:

Will always contain 000010076

Client Name	3	25	Will always contain “THE FEDERAL JUDICIARY”
Product Type	4	10	Will always contain “BPA”
Hdr effective date	5	8	YYYYMMDD
File type	6	14
Detail Row
Field	Seq #	Field Length	Format
Record Type	1	3	Will always contain an “COV”
SSN	2	9
Plan Type	3	2
Plan ID	4	6
Coverage Code	5	1
effective date	6	8	YYYYMMDD
Coverage Cost	7	10
Contribution percent	8	6
Contribution amount	9	10

Trailer Row
Field	Seq #	Field Length	Format
Record Type	1	3	Will always contain “TRL”
Control Number	2	9	Assigned By vendor: Will always contain 000010076
Filler	3	1	Space Fill
Total number of Records on File	4	10	Right justify, zero fill. Header and Trailer should be included.
Filler	5	69	Space Fill

JL_FEGLI_INBOUND

Field Name	Seq No	Field Type	Decimal Pos	Date Format	Date Separator	Field Length
JL_PAYCYCLE	1	Character				1
EMPLID	2	Character				10
JL_LAST_NAME	3	Character				25
JL_FIRST_NAME	4	Character				25
JL_MIDDLE_NAME	5	Character				20
BIRTHDATE	6	Date		MMDDYYYY	/	10
JL_SSN	7	Character				11
JL_AGENCY	8	Character				60
JL_OWCP_CLAIM_NBR	9	Character				15
JL_AGENCY_AD_CITY	10	Character				35
JL_AGENCY_AD_STATE	11	Character				2
JL_AGENCY_AD_ZIP	12	Character				10
JL_DAYTIME_PHONE	13	Character				25
JL_FEGLI_SIG_BASIC	14	Character				55
JL_FEGLI_BASIC_DT	15	Date		MMDDYYYY	/	10
JL_FEGLI_SIG_OPT_A	16	Character				55
JL_FEGLI_OPT_A_DT	17	Date		MMDDYYYY	/	10
JL_FEGLI_1_X_PAY	18	Character				1
JL_FEGLI_2_X_PAY	19	Character				1
JL_FEGLI_3_X_PAY	20	Character				1
JL_FEGLI_4_X_PAY	21	Character				1
JL_FEGLI_5_X_PAY	22	Character				1
JL_FEGLI_SIG_OPT_B	23	Character				55
JL_FEGLI_OPT_B_DT	24	Date		MMDDYYYY	/	10
JL_FEGLI_OPT_C_1_M	25	Character				1
JL_FEGLI_OPT_C_2_M	26	Character				1
JL_FEGLI_OPT_C_3_M	27	Character				1
JL_FEGLI_OPT_C_4_M	28	Character				1
JL_FEGLI_OPT_C_5_M	29	Character				1
JL_FEGLI_SIG_OPT_C	30	Character				55
JL_FEGLI_OPT_C_DT	31	Date		MMDDYYYY	/	10
JL_FEGLI_SIG_WAIVE	32	Character				55
JL_FEGLI_WAIVE_DT	33	Date		MMDDYYYY	/	10
JL_RMK_AGENCY	34	Character				120
JL_EVENT_CD	35	Character				5
JL_AGENCY1	36	Character				80
JL_AGENCY_STREET1	37	Character				35
JL_AGENCY_CITY1	38	Character				35
JL_AGENCY_STATE1	39	Character				2
JL_AGENCY_ZIP1	40	Character				10
RECEIVE_DT	41	Date		MMDDYYYY	/	10
EFFDT	42	Date		MMDDYYYY	/	10
JL_AUT_0_SIGNATURE	43	Character				80
JL_PERS_OFFICE_ID	44	Character				12
GVT_FEGLI	45	Character				2
EMPL_RCD	46	Number	0			3
JL_FORM_NAME	47	Character				6
ACTION_DT_SS	48	Date		MMDDYYYY	/	10
TRANS_EFFSEQ	49	Number	0			3
GVT_SF52_NBR	50	Character				10
GVT_NOA_CODE	51	Character				3
GVT_LEG_AUTH_1	52	Character				3
GVT_LEG_AUTH_2	53	Character				3
GVT_SF50_REMARK	54	Character				3
ACTION	55	Character				3
ACTION_REASON	56	Character				3
TRANSACTION_NAME	57	Character				25
WF_STATUS	58	Character				1
UPD_BY_USERID	59	Character				30
UPD_DTTM	60	Datetime				31
ORIGINATOR_ID	61	Character				11
FE_SS_STAT_IND	62	Character				1
FE_SS_FUTURE_FLAG	63	Character				1
MANUAL_UPD_USERID	64	Character				30
MANUAL_UPD_DTTM	65	Datetime				31
PROCESS_DATE	66	Date		MMDDYYYY	/	10

JL_SF2809_IN

Field Name	Seq No	Field Type	Decimal Pos	Date Format	Date Separator	Field Length
JL_PAYCYCLE	1	Character				1
EMPLID	2	Character				10
JL_NAME1	3	Character				70
JL_SSN	4	Character				11
BIRTHDATE	5	Date		MMDDYYYY	/	10
JL_EMP_MALE	6	Character				1
JL_EMP_FEMALE	7	Character				1
JL_MARRIED_YES	8	Character				1
JL_MARRIED_NO	9	Character				1
JL_EMP_ADDR1	10	Character				105
JL_EMP_ADDR2	11	Character				50
MEDICARE_A_IND	12	Character				1
MEDICARE_B_IND	13	Character				1
MEDICARE_D_IND	14	Character				1
JL_EMP_MED_CLM_NO	15	Character				35
JL_EMP_OTH_INS_Y	16	Character				1
JL_EMP_OTH_INS_N	17	Character				1
JL_EMP_TRICARE	18	Character				1
JL_EMP_OTH_INS	19	Character				1
JL_EMP_INS_NAME	20	Character				70
JL_EMP_POLICY_NBR	21	Character				40
JL_EMP_FEHB_INS	22	Character				1
JL_MEMBER1_NAME	23	Character				70
JL_MEMBER1_SSN	24	Character				11
JL_MEMBER1_BDATE	25	Date		MMDDYYYY	/	10
JL_MEMBER1_MALE	26	Character				1
JL_MEMBER1_FEMALE	27	Character				1
JL_MEMBER1_REL_CD	28	Character				2
JL_MEMBER1_ADDR1	29	Character				105
JL_MEMBER1_ADDR2	30	Character				50
JL_MEMBER1_MED_A	31	Character				1
JL_MEMBER1_MED_B	32	Character				1
JL_MEMBER1_MED_D	33	Character				1
JL_MEM1_MED_CLM_NO	34	Character				35
JL_MEM1_OTH_INS_Y	35	Character				1
JL_MEM1_OTH_INS_N	36	Character				1
JL_MEMBER1_TRICARE	37	Character				1
JL_MEMBER1_OTH_INS	38	Character				1
JL_MEMBER1_INS_NM	39	Character				70
JL_MEMBER1_POL_NO	40	Character				40
JL_MEM1_FEHB_INS	41	Character				1
JL_MEM1_EMAIL	42	Character				80
JL_MEM1_PHONE	43	Character				25
JL_MEMBER2_NAME	44	Character				70
JL_MEMBER2_SSN	45	Character				11
JL_MEMBER2_BDATE	46	Date		MMDDYYYY	/	10
JL_MEMBER2_MALE	47	Character				1
JL_MEMBER2_FEMALE	48	Character				1
JL_MEMBER2_REL_CD	49	Character				2
JL_MEMBER2_ADDR1	50	Character				105
JL_MEMBER2_ADDR2	51	Character				50
JL_MEMBER2_MED_A	52	Character				1
JL_MEMBER2_MED_B	53	Character				1
JL_MEMBER2_MED_D	54	Character				1
JL_MEM2_MED_CLM_NO	55	Character				35
JL_MEM2_OTH_INS_Y	56	Character				1
JL_MEM2_OTH_INS_N	57	Character				1
JL_MEMBER2_TRICARE	58	Character				1
JL_MEMBER2_OTH_INS	59	Character				1
JL_MEMBER2_INS_NM	60	Character				70
JL_MEMBER2_POL_NO	61	Character				40
JL_MEM2_FEHB_INS	62	Character				1
JL_MEM2_EMAIL	63	Character				80
JL_MEM2_PHONE	64	Character				25
JL_MEMBER3_NAME	65	Character				70
JL_MEMBER3_SSN	66	Character				11
JL_MEMBER3_BDATE	67	Date		MMDDYYYY	/	10
JL_MEMBER3_MALE	68	Character				1
JL_MEMBER3_FEMALE	69	Character				1
JL_MEMBER3_REL_CD	70	Character				2
JL_MEMBER3_ADDR1	71	Character				105
JL_MEMBER3_ADDR2	72	Character				50
JL_MEMBER3_MED_A	73	Character				1
JL_MEMBER3_MED_B	74	Character				1
JL_MEMBER3_MED_D	75	Character				1
JL_MEM3_MED_CLM_NO	76	Character				35
JL_MEM3_OTH_INS_Y	77	Character				1
JL_MEM3_OTH_INS_N	78	Character				1
JL_MEMBER3_TRICARE	79	Character				1
JL_MEMBER3_OTH_INS	80	Character				1
JL_MEMBER3_INS_NM	81	Character				70
JL_MEMBER3_POL_NO	82	Character				40
JL_MEM3_FEHB_INS	83	Character				1
JL_MEM3_EMAIL	84	Character				80
JL_MEM3_PHONE	85	Character				25
JL_MEMBER4_NAME	86	Character				70
JL_MEMBER4_SSN	87	Character				11
JL_MEMBER4_BDATE	88	Date		MMDDYYYY	/	10
JL_MEMBER4_MALE	89	Character				1
JL_MEMBER4_FEMALE	90	Character				1
JL_MEMBER4_REL_CD	91	Character				2
JL_MEMBER4_ADDR1	92	Character				105
JL_MEMBER4_ADDR2	93	Character				50
JL_MEMBER4_MED_A	94	Character				1
JL_MEMBER4_MED_B	95	Character				1
JL_MEMBER4_MED_D	96	Character				1
JL_MEM4_MED_CLM_NO	97	Character				35
JL_MEM4_OTH_INS_Y	98	Character				1
JL_MEM4_OTH_INS_N	99	Character				1
JL_MEMBER4_TRICARE	100	Character				1
JL_MEMBER4_OTH_INS	101	Character				1
JL_MEMBER4_INS_NM	102	Character				70
JL_MEMBER4_POL_NO	103	Character				40
JL_MEM4_FEHB_INS	104	Character				1
JL_MEM4_EMAIL	105	Character				80
JL_MEM4_PHONE	106	Character				25
JL_MEMBER5_NAME	107	Character				70
JL_MEMBER5_SSN	108	Character				11
JL_MEMBER5_BDATE	109	Date		MMDDYYYY	/	10
JL_MEMBER5_MALE	110	Character				1
JL_MEMBER5_FEMALE	111	Character				1
JL_MEMBER5_REL_CD	112	Character				2
JL_MEMBER5_ADDR1	113	Character				105
JL_MEMBER5_ADDR2	114	Character				50
JL_MEMBER5_MED_A	115	Character				1
JL_MEMBER5_MED_B	116	Character				1
JL_MEMBER5_MED_D	117	Character				1
JL_MEM5_MED_CLM_NO	118	Character				35
JL_MEM5_OTH_INS_Y	119	Character				1
JL_MEM5_OTH_INS_N	120	Character				1
JL_MEMBER5_TRICARE	121	Character				1
JL_MEMBER5_OTH_INS	122	Character				1
JL_MEMBER5_INS_NM	123	Character				70
JL_MEMBER5_POL_NO	124	Character				40
JL_MEM5_FEHB_INS	125	Character				1
JL_MEM5_EMAIL	126	Character				80
JL_MEM5_PHONE	127	Character				25
JL_MEMBER6_NAME	128	Character				70
JL_MEMBER6_SSN	129	Character				11
JL_MEMBER6_BDATE	130	Date		MMDDYYYY	/	10
JL_MEMBER6_MALE	131	Character				1
JL_MEMBER6_FEMALE	132	Character				1
JL_MEMBER6_REL_CD	133	Character				2
JL_MEMBER6_ADDR1	134	Character				105
JL_MEMBER6_ADDR2	135	Character				50
JL_MEMBER6_MED_A	136	Character				1
JL_MEMBER6_MED_B	137	Character				1
JL_MEMBER6_MED_D	138	Character				1
JL_MEM6_MED_CLM_NO	139	Character				35
JL_MEM6_OTH_INS_Y	140	Character				1
JL_MEM6_OTH_INS_N	141	Character				1
JL_MEMBER6_TRICARE	142	Character				1
JL_MEMBER6_OTH_INS	143	Character				1
JL_MEMBER6_INS_NM	144	Character				70
JL_MEMBER6_POL_NO	145	Character				40
JL_MEM6_FEHB_INS	146	Character				1
JL_MEM6_EMAIL	147	Character				80
JL_MEM6_PHONE	148	Character				25
JL_MEMBER7_NAME	149	Character				70
JL_MEMBER7_SSN	150	Character				11
JL_MEMBER7_BDATE	151	Date		MMDDYYYY	/	10
JL_MEMBER7_MALE	152	Character				1
JL_MEMBER7_FEMALE	153	Character				1
JL_MEMBER7_REL_CD	154	Character				2
JL_MEMBER7_ADDR1	155	Character				105
JL_MEMBER7_ADDR2	156	Character				50
JL_MEMBER7_MED_A	157	Character				1
JL_MEMBER7_MED_B	158	Character				1
JL_MEMBER7_MED_D	159	Character				1
JL_MEM7_MED_CLM_NO	160	Character				35
JL_MEM7_OTH_INS_Y	161	Character				1
JL_MEM7_OTH_INS_N	162	Character				1
JL_MEMBER7_TRICARE	163	Character				1
JL_MEMBER7_OTH_INS	164	Character				1
JL_MEMBER7_INS_NM	165	Character				70
JL_MEMBER7_POL_NO	166	Character				40
JL_MEM7_FEHB_INS	167	Character				1
JL_MEM7_EMAIL	168	Character				80
JL_MEM7_PHONE	169	Character				25
JL_MEMBER8_NAME	170	Character				70
JL_MEMBER8_SSN	171	Character				11
JL_MEMBER8_BDATE	172	Date		MMDDYYYY	/	10
JL_MEMBER8_MALE	173	Character				1
JL_MEMBER8_FEMALE	174	Character				1
JL_MEMBER8_REL_CD	175	Character				2
JL_MEMBER8_ADDR1	176	Character				105
JL_MEMBER8_ADDR2	177	Character				50
JL_MEMBER8_MED_A	178	Character				1
JL_MEMBER8_MED_B	179	Character				1
JL_MEMBER8_MED_D	180	Character				1
JL_MEM8_MED_CLM_NO	181	Character				35
JL_MEM8_OTH_INS_Y	182	Character				1
JL_MEM8_OTH_INS_N	183	Character				1
JL_MEMBER8_TRICARE	184	Character				1
JL_MEMBER8_OTH_INS	185	Character				1
JL_MEMBER8_INS_NM	186	Character				70
JL_MEMBER8_POL_NO	187	Character				40
JL_MEM8_FEHB_INS	188	Character				1
JL_MEM8_EMAIL	189	Character				80
JL_MEM8_PHONE	190	Character				25
JL_MEMBER9_NAME	191	Character				70
JL_MEMBER9_SSN	192	Character				11
JL_MEMBER9_BDATE	193	Date		MMDDYYYY	/	10
JL_MEMBER9_MALE	194	Character				1
JL_MEMBER9_FEMALE	195	Character				1
JL_MEMBER9_REL_CD	196	Character				2
JL_MEMBER9_ADDR1	197	Character				105
JL_MEMBER9_ADDR2	198	Character				50
JL_MEMBER9_MED_A	199	Character				1
JL_MEMBER9_MED_B	200	Character				1
JL_MEMBER9_MED_D	201	Character				1
JL_MEM9_MED_CLM_NO	202	Character				35
JL_MEM9_OTH_INS_Y	203	Character				1
JL_MEM9_OTH_INS_N	204	Character				1
JL_MEMBER9_TRICARE	205	Character				1
JL_MEMBER9_OTH_INS	206	Character				1
JL_MEMBER9_INS_NM	207	Character				70
JL_MEMBER9_POL_NO	208	Character				40
JL_MEM9_FEHB_INS	209	Character				1
JL_MEM9_EMAIL	210	Character				80
JL_MEM9_PHONE	211	Character				25
JL_MEMBER10_NAME	212	Character				70
JL_MEMBER10_SSN	213	Character				11
JL_MEMBER10_BDATE	214	Date		MMDDYYYY	/	10
JL_MEMBER10_MALE	215	Character				1
JL_MEMBER10_FEMALE	216	Character				1
JL_MEMBER10_REL_CD	217	Character				2
JL_MEMBER10_ADDR1	218	Character				105
JL_MEMBER10_ADDR2	219	Character				50
JL_MEMBER10_MED_A	220	Character				1
JL_MEMBER10_MED_B	221	Character				1
JL_MEMBER10_MED_D	222	Character				1
JL_MEM10MED_CLM_NO	223	Character				35
JL_MEM10_OTH_INS_Y	224	Character				1
JL_MEM10_OTH_INS_N	225	Character				1
JL_MEMBER10_TRICAR	226	Character				1
JL_MEMBER10_OTH_IN	227	Character				1
JL_MEMBER10_INS_NM	228	Character				70
JL_MEMBER10_POL_NO	229	Character				40
JL_MEM10_FEHB_INS	230	Character				1
JL_MEM10_EMAIL	231	Character				80
JL_MEM10_PHONE	232	Character				25
JL_PRESENT_PLAN_NM	233	Character				35
JL_PRESENT_ENRL_CD	234	Character				10
JL_NEW_PLAN_NAME	235	Character				35
JL_NEW_PLAN_CODE	236	Character				10
JL_EVENT_CD_2	237	Character				10
EVENT_DT	238	Date		MMDDYYYY	/	10
WAIVE_COVERAGE	239	Character				1
CANCEL_FLAG	240	Character				1
JL_SUSPEND_ENROL	241	Character				1
JL_EMP_SIGNATURE	242	Character				40
SIGNATURE_DT	243	Date		MMDDYYYY	/	10
JL_EMP_EMAIL	244	Character				80
JL_DAYTIME_PHONE	245	Character				25
JL_RMK_80	246	Character				160
RECEIVE_DT	247	Date		MMDDYYYY	/	10
EFFDT	248	Date		MMDDYYYY	/	10
JL_PERSONNEL_PHONE	249	Character				25
JL_AGENCY_NAME	250	Character				35
JL_AGENCY_ADDR1	251	Character				105
JL_AGENCY_ADDR2	252	Character				105
JL_AUTH_OFFICIAL	253	Character				40
JL_AUTH_SIGNATURE	254	Character				40
JL_PAYROLL_NUMBER	255	Character				25
JL_PAYROLL_CONTACT	256	Character				40
JL_PAYROLL_PHONE	257	Character				20
JL_PERS_OFFICE_ID	258	Character				12

JL_TSP_INBOUND

Field Name	Seq No	Field Type	Decimal Pos	Date Format	Date Separator
JL_PAYCYCLE	1	Character
EMPLID	2	Character
JL_LAST_NAME	3	Character
JL_FIRST_NAME	4	Character
JL_MIDDLE_NAME	5	Character
ADDRESS1	6	Character
ADDRESS2	7	Character
CITY	8	Character
STATE	9	Character
POSTAL	10	Character
SSN	11	Character
JL_AGENCY	12	Character
JL_PAYROLL_NUMBER	13	Character
JL_PERS_OFFICE_ID	14	Character
JL_AUTH_SIGNATURE	15	Character
JL_TSP_PLAN_TYPE	16	Character
JL_TSP_BEN_PLAN	17	Character
JL_TSP_PCT	18	Number	1
JL_TSP_AMT	19	Signed Number	2
JL_TSP_ROTH_PCT	20	Number	1
JL_TSP_ROTH_AMT	21	Number	2
JL_TSP_STOP_ALL	22	Character
JL_TSP_STOP_DEF	23	Character
JL_TSP_STOP_ROTH	24	Character
JL_EMP_SIGNATURE	25	Character
SIGNATURE_DT	26	Date		MMDDYYYY	/
RECEIVED_DT	27	Date		MMDDYYYY	/
EFFDT	28	Date		MMDDYYYY	/
JL_TSP_C_PLAN_TYPE	29	Character
JL_TSP_C_BEN_PLAN	30	Character
JL_TSP_C_AMT	31	Number	2
JL_TSP_C_ROTH_AMT	32	Number	2
JL_TSP_C_SIGNATURE	33	Character
JL_TSP_C_SIGN_DT	34	Date		MMDDYYYY	/
JL_TSP_C_STOP_ALL	35	Character
JL_TSP_C_STOP_DEF	36	Character
JL_TSP_C_STOP_ROTH	37	Character
JL_STOP_SIGNATURE	38	Character
JL_STOP_DATE	39	Date		MMDDYYYY	/
JL_TSP_C_REC_DT	40	Date		MMDDYYYY	/
JL_TSP_C_EFFDT	41	Date		MMDDYYYY	/
ERRORCODE	42	Character

Vendor Payment File

Vendor Payment file

Header Record - Outbound Payment File

(jlhm2911.sqr)
Field Name	Starting Position	Ending Position	Length	Field Type	Required	Comments
				A/N	Y/N
Record Type	1	3	3	A	Y	Will always contain “HDR”
Control Number	4	12	9	A	Y	Assigned By Vendor:
						Will always contain 000010076
Client Name	13	37	25	A	Y	Will always contain “THE FEDERAL JUDICIARY”
Product Type	38	47	10	A	Y	Will always contain “BPA”
Creation Date	48	55	8	N	Y	Format CCYYMMDD, this data represents the date the system generated the file
File type	56	84	30	A	Y	Will always contain “PAYROLL FEED”
Payroll Cycle	85	85	1	A	Y	Either “M” for monthly or “B” for biweekly payroll ( this field is no longer contained on the file)
Filler	86	92	6	A	Y	Space Fill

Participant Record Layout – Outbound Payment File

(jlhm2911.sqr)
Field Name	Starting Position	Ending Position	Length	Field Type	Required	HRMIS Table Name	HRMIS Field Name	Comments
				A/N	Y/N
Record Type	1	3	3	A	Y			Will always contain an “COV”
Participant National ID	4	12	9	A/N	Y	PERS_NID	NATIONAL_ID	Participant’s NID – no alpha and special characters will be used, field is alphanumeric to support leading zeroes
Plan Type	13	20	8	A	Y	PAY_DEDUCTION	PLAN_TYPE	Plan Type contains information that identifies the type of plan.

								See appendix for valid plan types
Plan Id	21	28	8	A/N	Y	HEALTH_BENEFIT (FEHB) or PAY_DEDUCTION (FSA ONLY)	DEDCD(FSA)	Plan ID contains information that identifies the plan the deduction applies to.

								See appendix for valid plan types and plan id’s
Plan Coverage Level	29	29	1	A/N	Y	HEALTH_BENEFIT(FEHB)	COVRG_CD(FEHB)	Plan Coverage Level contains information that identifies the plan tier the deduction being sent it for.

See appendix for valid plan coverage levels

Pay Period Begin Date	30	37	8	N	Y	PAY_DEDUCTION	PAY_BEGIN_DT	Format “CCYYMMDD”, represents pay period begin date
Filler	38	56	19	A	Y			Space fill
Deduction Amount	57	66	10	N	Y	PAY_DEDUCTION FSA	DED_CUR(FSA)	Amount The Federal Judiciary deducted from the participant’s paycheck. Right justified, 2 decimal places assumed. Zero if no deduction taken.
Filler	67	82	16	A	N			Space fill
Year to Date Deduction Amount	83	92	10	A/N	Y	DEDUCTION_BAL	DED_YTD	Sum of deductions per plan that have been taken during the plan/pay year.

Trailer Record – Outbound Payment File

(jlhm2911.sqr)
Field Name	Starting Position	Ending Position	Length	Field Type	Required	Comments
				A/N	Y/N
Record Type	1	3	3	A	Y	Will always contain “TRL”
Control Number	4	12	9	A	Y	Assigned By Vendor: Will always contain 000010076
Filler	13	13	1	A	Y	Space Fill
Total Number of Records on File	14	23	10	N	Y	Right justify, zero fill. Header and Trailer should be included.
Filler	24	92	69	A	Y	Space Fill

JL_VENDORELIG_OUT

Field Name	Seq No	Field Type	Decimal Pos	Date Format	Date Separator	Field Length
EMPLID	1	Character				11
EMPL_RCD	2	Number	0			3
SSN	3	Character				9
FIRST_NAME	4	Character				30
LAST_NAME	5	Character				30
MIDDLE_INITIAL	6	Character				1
ADDRESS1	7	Character				55
ADDRESS2	8	Character				55
ADDRESS3	9	Character				55
CITY	10	Character				30
STATE	11	Character				6
POSTAL	12	Character				12
COUNTY	13	Character				30
COUNTRY	14	Character				3
ADDRESS1_OTHER	15	Character				55
ADDRESS2_OTHER	16	Character				55
ADDRESS3_OTHER	17	Character				55
CITY_OTHER	18	Character				30
STATE_OTHER	19	Character				6
POSTAL_OTHER	20	Character				12
COUNTY_OTHER	21	Character				30
COUNTRY_OTHER	22	Character				3
SEX	23	Character				1
BIRTHDATE	24	Date		MMDDYYYY	/	10
JL_EOD	25	Date		MMDDYYYY	/	10
HIRE_DT	26	Date		MMDDYYYY	/	10
TERMINATION_DT	27	Date		MMDDYYYY	/	10
JL_BASE_RATE	28	Number	0			10
JL_PAYCYCLE	29	Character				1
JL_TOUR	30	Number	1			6
DISABLED	31	Character				1
GVT_APPT_EXPIR_DT	32	Date		MMDDYYYY	/	10
JOB_FUNCTION	33	Character				3
GVT_PAY_PLAN	34	Character				2
ACCOUNT_TYPE	35	Character				1
EFFDT	36	Date		MMDDYYYY	/	10
BANK_CD	37	Character				11
ACCOUNT_NUM	38	Character				17
JOBCODE	39	Character				6
DEPTID	40	Character				10
JL_HB_PRE	41	Character				3
JL_HB_POST	42	Character				3
REHIRE_DT	43	Date		MMDDYYYY	/	10
GVT_FEGLI	44	Character				2
GVT_ELIG_FEHB	45	Character				3
GVT_AGY_LOC_CODE	46	Character				8
GVT_POI	47	Character				4
CPDF_AGENCY_CD	48	Character				5
FEGLI_EFFDT	49	Date		MMDDYYYY	/	10
JL_TSP_HARDSHIP	50	Character				1
HARDSHIP_WTHD_DT	51	Date		MMDDYYYY	/	10
JL_TSP_ELIG	52	Character				3
JL_TSP_BEN_PLAN_E	53	Character				6
JL_TSP_PLAN_TYPE	54	Character				2
JL_TSP_BEN_PLAN	55	Character				6
JL_TSP_ELECTION	56	Character				1
JL_TSP_COVG_BEG_DT	57	Date		MMDDYYYY	/	10
JL_TSP_DED_BEG_DT	58	Date		MMDDYYYY	/	10
JL_TSP_ELECT_DT	59	Date		MMDDYYYY	/	10
FLAT_DED_AMT	60	Number	2			9
JL_TSP_PCT	61	Number	0			4
FLAT_DED_AMT_ATAX	62	Number	2			9
JL_TSP_ROTH_PCT	63	Number	0			4
JL_TSP_C_ELIGIBLE	64	Character				3
JL_TSP_C_PLAN_TYPE	65	Character				2
JL_TSP_C_BEN_PLAN	66	Character				6
JL_TSP_C_ELECTION	67	Character				1
JL_TSPC_COV_BEG_DT	68	Date		MMDDYYYY	/	10
JL_TSPC_DED_BEG_DT	69	Date		MMDDYYYY	/	10
JL_TSP_C_ELECT_DT	70	Date		MMDDYYYY	/	10
JL_TSP_C_AMT	71	Number	2			9
JL_TSP_C_AMT_ATAX	72	Number	2			9
JL_COURT_ORDER	73	Character				1

JL_FEHB_CDRTWRK

Field Name	Seq No	Field Type	Decimal Pos	Date Format	Date Separator	Field Length
BENEFIT_PROGRAM	1	Character				3
EFFDT	2	Date		MMDDYYYY	/	10
PLAN_TYPE	3	Character				2
BENEFIT_PLAN	4	Character				6
DESCR	5	Character				30
COVRG_CD	6	Character				1
DESCR1	7	Character				30
EMPL_COVRG_RATE	8	Number	2			9

VendorACA HR - Payroll info

HR Data Format file name - G34EB73T4XYW9Y1Y_fjudiciary_HRData_YYYYMMDD_######.xml
Client Info Header Format
Field Name	Seq No
OrganizationOID	1
Source System	2
Source System Version	3
SpecVersion	4
Employee HR Data Format
Field Name	Seq No
Employee ID	1
Social Security Number	2
Employee First Name	3
Employee Middle Name	4
Employee Last Name	5
Gender	6
BirthDate	7
Recent Hire Date	8
Previous Hire Date	9
Employee Status	10
Status Effective Date	11
Expected ACA Status	12
Expected ACA Status Effective Date	13
Effective Date of Indicative Data	14
Work State Code	15
Pay Type	16
Employee Type	17
HR Status	18
Federal EIN	19
Org Code 01	20
Org Code 02	21
Org Code 03	22
Org Code 04	23
Org Code 05	24
Hourly Rate	25
Hourly Rate Effective Date	26
Address Line 1	27
City	28
State	29
ZipCode	30
Country	31
Payroll File Format - G34EB73T4XYW9Y1Y_fjudiciary_PayrollData_YYYYMMDD_######.txt
Field Name	Seq No
COID	1
Client ID	2
AOID	3
Employee ID	4
File No	5
Co Code	6
SSN	7
First Name	8
Middle Name	9
Last Name	10
Gender	11
Birth Date	12
Hire Date	13
Status	14
Status Date	15
Leave Status	16
Leave Type	17
Work State	18
Pay Type	19
Location	20
Union Flag	21
Union Code	22
FTPT	23
Pay group	24
Home Dept	25
FEIN	26
Branch	27
Cost Number	28
Std Weekly Hours	29
Pay Per Start	30
Pay Per End	31
Freq	32
Hourscode	33
Total Hours Paid	34
Hourly Wage Rate	35
Wage Rate Effdate	36
Annual Salary	37
Salary Eff Date	38
Cal Year Box 1 W2 Wages	39
End of Year Box 1 W2 Wages	40
Cur YTD Box 1 W2 Wages	41
Payroll Number	42
Payroll Batch	43
Payroll Year	44
Payroll Week	45

File details come from the government source that posted it.