Filetype Excel XLSX | Posted on 26 Jun 2022 | 4 years ago
Authentication
digital resources
379x Filetype XLSX File size 0.02 MB Source: www.in.gov
Sheet 1: Contact Information
| Contact Information File | |||||
| This file should be named contact.txt. | |||||
| This file contains unit and vendor contact information regarding the upload process. | |||||
| There will be only one record in the file. | |||||
| All numeric fields should be right justified and left zero filled as needed. | |||||
| Spaces in numeric fields will be considered an error. | |||||
| Include Carriage Return and Line Feed characters at the end of each record | |||||
| Do Not include an "End of File" character in the file | |||||
| START | Negative Amt | ||||
| FIELD DESCRIPTION | TYPE | COLUMN | WIDTH | Allowed | COMMENTS |
| Year | Numeric | 1 | 4 | N | Year of the Annual Report being submitted |
| Unit ID Number Which is Made Up of the Following Fields | See Unit ID Number List | ||||
| County Number | Numeric | 5 | 2 | N | |
| Unit Type | Numeric | 7 | 1 | N | |
| ID Number | Numeric | 8 | 4 | N | |
| Unit Contact Name | Character | 12 | 50 | NA | Unit contact person regarding the Annual Report Upload |
| Unit Contact Number | Character | 62 | 12 | NA | Format 999-999-9999 |
| Unit Contact E-mail | Character | 74 | 50 | NA | Format username@domain.org |
| Software Vendor Name | Character | 124 | 50 | NA | Company Name of the Vendor that created the upload files |
| Software Vendor Contact Name | Character | 174 | 50 | NA | Vendor contact person regarding the Annual Report Upload |
| Software Vendor Contact Phone Number | Character | 224 | 12 | NA | Format 999-999-9999 |
| Software Vendor Contact E-mail | Character | 236 | 50 | NA | Format username@domain.org |
| Total Record Length = 285 |
| Beginning Balances File | |||||
| This file should be named begbal.txt. | |||||
| This file contains the beginning balances for each fund for the Annual Report. See Note 1 | |||||
| There can only be one record for each fund. | |||||
| All numeric fields should be right justified and left zero filled as needed. | |||||
| Spaces in numeric fields will be considered an error. | |||||
| Include Carriage Return and Line Feed characters at the end of each record | |||||
| Do Not include an "End of File" character in the file | |||||
| START | Negative Amt | ||||
| FIELD DESCRIPTION | TYPE | COLUMN | WIDTH | Allowed? | COMMENTS |
| Year | Numeric | 1 | 4 | N | Year of the Annual Report being submitted |
| Unit ID Number Which is Made Up of the Following Fields | See Unit ID Number List | ||||
| County Number | Numeric | 5 | 2 | N | |
| Unit Type | Numeric | 7 | 1 | N | |
| ID Number | Numeric | 8 | 4 | N | |
| New 2011 Fund Number Which is Made Up of the Following Fields | See Note 2 | ||||
| Standard Fund Flag | Numeric | 12 | 1 | N | 1 = standard fund, 9 = non-standard fund |
| Old Annual Report Fund Number | Numeric | 13 | 5 | N | |
| Beginning Investment Balance for the Fund | Dollar Amount, see Note 2 | 18 | 14 | N | The amount of investments for this fund at the beginning of the year |
| Beginning Cash Balance for the Fund | Dollar Amount, see Note 2 | 32 | 14 | Y | The amount of cash for this fund at the beginning of the year |
| Unit’s Fund Number | Character | 46 | 10 | NA | Fund Number from the Unit’s Accounting System |
| Unit’s Fund Name | Character | 56 | 50 | NA | Fund Name from the Unit's Accounting System |
| Enterprise Number | Numeric | 106 | 2 | N | See Note 4 |
| Total Record Length = 107 | |||||
| All Referenced Notes are in AnnualReportUploadSpecs.docx |
| Receipts File | |||||
| This file should be named receipts.txt. | |||||
| This file contains the receipts by fund for the Annual Report. | |||||
| There can only be one record for each receipt code within each fund. See Note 5 for an exception. | |||||
| All numeric fields should be right justified and left zero filled as needed. | |||||
| Spaces in numeric fields will be considered an error. | |||||
| Include Carriage Return and Line Feed characters at the end of each record | |||||
| Do Not include an "End of File" character in the file | |||||
| START | Negative Amt | ||||
| FIELD DESCRIPTION | TYPE | COLUMN | WIDTH | Allowed | COMMENTS |
| Year | Numeric | 1 | 4 | N | Year of the Annual Report being submitted |
| Unit ID Number Which is Made Up of the Following Fields | See Unit ID Number List | ||||
| County Number | Numeric | 5 | 2 | N | |
| Unit Type | Numeric | 7 | 1 | N | |
| ID Number | Numeric | 8 | 4 | N | |
| New 2011 Fund Number Which is Made Up of the Following Fields | See Note 2 | ||||
| Standard Fund Flag | Numeric | 12 | 1 | N | 1 = standard fund, 9 = non-standard fund |
| Old Annual Report Fund Number | Numeric | 13 | 5 | N | |
| Receipt Code | Character | 18 | 4 | N | See Receipt Code List |
| Receipt Amount | Dollar Amount, see Note 2 | 22 | 14 | N | Total Receipts for the Year for this Revenue Code |
| Unit’s Account Number | Character | 36 | 15 | NA | See Note 5 |
| Unit's Account Name | Character | 51 | 50 | NA | See Note 5 |
| Enterprise Number | Numeric | 101 | 2 | N | See Note 4 |
| Total Record Length = 102 | |||||
| All Referenced Notes are in AnnualReportUploadSpecs.docx |
no reviews yet
Please Login to review.
