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

Other files attached to Banking Services, newest first.
File Type Posted
5400028775.pdf PDF
Attachment D.pdf PDF
Attachment B.pdf PDF
Attachment A.pdf 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 .