FileLayout_Vendor.doc
DOC document 54 KB Posted
- Attached to
- State Employee Commuter Benefits Program
- Solicitation number
- S119109-vCurrent
- Issued by
- Suffolk County, Massachusetts
About this file
This document is a file layout specification for an interface data file used for payment posting between the Commonwealth of Massachusetts and its vendors. The file contains four record types: a header record with vendor information, an employee detail record, a payment control record, and a file control record. The employee detail record includes data fields such as department ID and name, pay period end date, employee SSN, name, bargaining unit, scheduled hours, deduction code and description, plan type, benefit plan and description, and deduction amount and year-to-date total. The payment control record includes a payment reference number, number of detail records, and total dollar amount. The file control record provides the total number of detail records and total dollar amount across all vendors. This file layout appears to be part of a state or local contract opportunity between the Commonwealth of Massachusetts and its vendors.
The file does not provide any additional details about the specific contract opportunity, such as the products or services being procured, response dates, award information, pricing terms, or funding sources. The document appears to be focused solely on the technical file layout requirements for the payment interface between the Commonwealth and its vendors.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| c_tc.doc | DOC document | |
| consig.doc | DOC document | |
| eo504.doc | DOC document | |
| req_specs.doc | DOC document | |
| 054.doc | DOC document | |
| newMass_W9.doc | DOC document | |
| QTB_response_Template.doc | DOC document | |
| S119109-vCurrent_OD.xlsx | XLSX spreadsheet | |
| out_state_work_locations.xls.doc | DOC document | |
| RFR_QTB_1202010.doc | DOC document | |
| scf2001.doc | DOC document | |
| FINAL_ANSWERS_FORUM.doc | DOC document | |
| consltfm.doc | DOC document | |
| 055.doc | DOC document |
Show all 14
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Commonwealth of Massachusetts - File Layout, Interface Data File
For payment posting
Interface Field Name Field Type Field Length Start Position Value Special Logic Description
Record type Char ‘1’
File header record.
Vendor_ID Char
EIN number of vendor.
Vendor_Name Char
Name of vendor receiving data and payment.
Pay period End Date Date
YYYYMMDD
This will be the last day of the biweekly payroll cycle.
Filler Char Blank
Blanks to make record length 325.
Interface Field Name Field Type Field Length Start Position Hard Coded Value Special Logic
Record type Char ‘2’
Employee detail record.
Dept _ID Char
This will identify the departmental code of the employee having the deduction.
Dept. Name Char
This will identify departmental name of the employee having the deduction.
Pay period End Date Date
YYYYMMDD
This will be the last day of the biweekly payroll cycle.
SSN
Num
Social Security of the employee having the deduction.
EE Last Name Char
Last name of employee having the deduction.
EE First Name Char
First name of employee having the deduction.
EE Middle Initial Char
Middle initial name of employee having the deduction.
Bargaining Unit Char
Bargaining Unit (Union) that the employee is associated with for a specific job.
Scheduled hours Num
Implicit decimal 2.2 Number of hour's employee is scheduled to work for one week.
Deduction Code Char
Code used to identity a specific deduction.
Deduction Description Char
Provides description to identify a specific deduction code. (An example of this would be whether an employee is paying union dues or an agency fee and which union local the employee is associated with).
Plan_type Char
Used to indicate one of a number of plans an employee may belong to (An example of this would be: Retirement, Deferred Comp).
Benefit_Plan Char
Code used to identify a specific Benefit Plan.
Benefit Description Char
Description of Benefit Plan. (An example of this would be the percentage associated with a retirement plan and if it is pre or post tax).
Deduction Amount Num
Implicit decimal 8.2 The amount of the deduction for the employee.
Year to date Num
Implicit decimal 8.2 Total amount of deduction for the calendar year.
Filler Char Blank
Blanks to make record length 325.
Interface Field Name Field Type Field Length Start Position Hard
‘3’
Payment control record.
Payment_ref_nbr Number
Payment reference number will link the EFT with the data transfer. This will enable you to reconcile the payment and data file information together for a specific pay period
#recs Number
Number of detail records i.e., records of type 2 associated with the payment reference number.
#total Number
Implicit decimal 8.2 The total dollar amount reported in the records of type 2 associated with the payment reference number.
Filler Char Blank
Blanks to make record length 325.
Interface Field Name Field Type Field Length Start Position Hard
‘4’
File control record.
#vendor_recs number
Total number of details records i.e., records of type 2 which appear in this data file.
#vendor_total number
Implicit decimal 8.2 The total dollar amount reported in the records of type 2 which appear in this data file.
Filler char Blank
Blanks to make record length 325.
*The length of all records are 325 characters.
File details come from the government source that posted it. Updated .