Attachment C.pdf
PDF 79 KB Posted
- Attached to
- Banking Services State and local contract opportunity
- Solicitation number
- 5400028775
- Issued by
- Charleston County, South Carolina
About this file
This is a technical specification document for a Human Resources System payroll check file to be produced by a servicing bank in South Carolina for reconciliation of physical payroll checks. The file establishes standardized record formats and data specifications for banking services related to payroll processing. The document outlines three record types—header, detail, and trailer lines—each with fixed record lengths of 80 characters in ASCII format. The header record includes the payroll bank account number and statement cutoff date in YYYYMMDD format. Detail records contain specific information for each paid check, including the bank account number, check amount with implied decimals, paid date, transaction indicator, check number, and a detail record indicator. The trailer record summarizes the total paid amount and total number of checks paid for the statement period, allowing for complete reconciliation of all payroll disbursements.
The specification mandates right-justified, zero-filled numeric fields and specific position allocations for all data elements to ensure consistency and accuracy in payroll reconciliation processes. Header records must be identified with "HR" in positions 1-2, detail records with "D" in position 76, and trailer records with "TR" in positions 1-2, with transaction indicators marked as "R" for paid or reconciled checks. This standardized format enables the servicing bank to reliably transmit payroll check information for verification against the agency's internal records, supporting financial controls and audit requirements for the state's banking services operations.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| 5400028775.pdf | ||
| Attachment D.pdf | ||
| Attachment B.pdf | ||
| Attachment A.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
HUMAN RESOURCES SYSTEM (HR)
PAYROLL CHECK FILE SHALL BE PRODUCED BY SERVICING BANK
FOR RECONCILIATION OF BANK PAID PAYROLL CHECKS
PHYSICAL FILE CHARACTERISTICS
FILE ORGANIZATION: 1 (one) Record per Line
RECORD LENGTH: 80
RECORD FORMAT: Fixed
DATA REPRESENTATION: ASCII
RECORD LAYOUT
Header Line:
HEADER LENGTH START END FORMAT
ID 2 1 2 (Must be "HR" for header)
FILLER 10 3 12 SPACES
PAYROLL BANK ACCT # 13 13 25 Right Just. Zero Filled
FILLER 8 26 33 SPACES
AS OF DATE 8 34 41
Right Just. (YYYYMMDD) Statement
Cutoff Date
FILLER 39 42 80 SPACES
Detail line:
FIELD LENGTH START END FORMAT
PAYROLL BANK ACCT NO 13 1 13 Right Just. Zero Filled
FILLER 10 14 23 ZEROS
CHECK AMOUNT 10 24 33
Right Just. Zero Filled. Decimal implied
PAID DATE 8 34 41 Right Just. (YYYYMMDD)
TRANSACTION.IND 1 42 42 Must be a "R" for paid/reconciled
FILLER 8 43 50 ZEROS
FILLER 15 51 65 SPACES
CHECK NO 10 66 75 Right Just. Zero Filled
RECORD IND 1 76 76 Must be a "D" for Detail record
FILLER 4 77 80 SPACES
Trailer Line:
TRAILER LENGTH START END FORMAT
ID 2 1 2 (Must be “TR” for trailer)
FILLER 10 3 12 SPACES
PAYROLL BANK ACCT NO 13 13 25 Right Just. Zero Filled
AS OF DATE 8 26 33
Right Just. (YYYYMMDD) Statement
Cutoff Date
TOTAL PAID AMOUNT 12 34 45
Right Just. Zero Filled. Decimal implied
TOTAL NO OF CHECKS
PAID 10 46 55 Right Just. Zero Filled.
FILLER 25 56 80 SPACES
File details come from the government source that posted it. Updated .