...
Collector files will contain a header record, with information to identify the sender and an email address to send messages as to whether the file was processed or contained errors. Detail records will be many. For each two sided account entry, there will be two KFS entries. One will be the credit entry and the second will be the debit entry. The number of credit detail entries must match the number of debit detail entries. The last type of record is the trailer record. This will contain a count of the total number of entries submitted (Credit + Debit) and a total dollar amount. The amount cannot be zero.
A collector file batch is considered a duplicate if all the following fields match any existing batch already processed.
| Field | Where Found | Column |
|---|---|---|
| Chart of Accounts Code | Header (HD) | 5-6 |
| Organization Code | Header (HD) | 7-10 |
| Transmission Date | Header (HD) | 16-25 |
| Batch Sequence Number | Header (HD) | 28 |
| Number of Records in File | Trailer (TL) | 47-51 |
| File Amount | Trailer (TL) | 93-112 |
The Collector Feed is a fixed length format with file name ending with the .data extension. Below is the mapping for the fixed length format. The file must have a matching file name with the .done extension to be processed.
Header Record (One per file):
...
Field Name | Position | Type + Length | Description |
Fiscal Year | 1-4 | Year – 4 | Changes on July 1st |
Chart of Accounts code | 5-6 | Char – 2 | UC |
Organization Code | 7-10 | Char - 4 | Hardcoded value supplied for each organization. Found on KFS Organization Table. |
Filler | 11-15 | Char - 5 | Blanks or Spaces |
Transmission Date | 16-25 | Date - 10 | Format CCYY-MM-DD |
Record Type | 26-27 | Char – 2 | HD |
Batch Sequence Number | 28 | Integer - 1 | Cannot be zero. Must be unique for each transmission date. |
Email Address | 29-68 | Char – 40 | To be supplied by responsible party – preferably a department email |
Department Contact Person | 69-98 | Char – 30 | To be supplied by responsible party |
Department Name | 99-128 | Char – 30 | To be supplied by responsible party |
Campus Mailing Address | 129-158 | Char – 30 | To be supplied by responsible party |
Campus Code | 159-160 | Char – 2 | 01 |
Department Contact Phone Number | 161-170 | Char - 10 | To be supplied by responsible party – format AAAEEENNNN |
Filler | 171-172 | Char – 2 | Blanks or spaces |
...
Trailer Record (One per file):
Field Name | Output Position | Type + Length | Description |
Filler | 1-25 | Char - 25 | Blank or spaces |
Record Type | 26-27 |
Char – 2 | TL | ||
Filler | 28-46 | Char - 19 | Blank or Spaces |
Number of |
records in file | 47-51 | Integer - 5 | Total Credit GL Entries plus Total Debit GL Entries (do not count header and trailer records) |
Filler | 52-92 | Char - 41 | Blank or Spaces |
File |
Amount | 93-112 | Money format ( 2 decimal places) right aligned, leading zeroes, no commas - 20 | Total amount credited plus total amount debited. Cannot be zero. Must include decimal point, for example 00000000000000114.00 |