The header record should always be the first record.
Each of the fields should be delimited in the header by the field name referenced below.
The following table shows the fields, delimiters, descriptions, data types, data sources or valid values, and whether the field is required or optional for the LA Unique Id upload file’s header record.
|
Field |
Delimiter |
Description |
Data Type |
Data Source or Valid Values |
Required or Optional |
|---|---|---|---|---|---|
|
Record Type |
Not applicable |
Identifies the record type. |
Char (2) |
The valid value is TH. |
Required |
|
Extract Date |
Not applicable |
The date the file was created. The following formats are valid:
|
Date (10) |
The valid value is the date the file was created. |
Required |
|
Extract Time |
Not applicable |
The time the file was created. The format is hh:mm:ss. |
Time (8) |
The valid value is the time the file was created. |
Required |
|
Transmission ID |
Not applicable |
Use this number for auditing, as an identifier for the submission. |
VarChar (10) |
Not applicable |
Required |
|
Version |
Not applicable |
The file format version. |
Char (3) |
The valid value is 3.0. |
Required |
|
Delimiter |
delimiter= |
The character literal or the hex representation of the delimiter that is used in the detail records (either tab or comma). |
VarChar (4) |
|
Required |
|
Source Name |
source= |
The valid source system name. Batches will fail if the source name is not defined in the Source System table. System administrators manage the Source System table. |
VarChar (3) |
The valid value is PEP. |
Required |
|
Text Qualifier |
qualifier= |
The text or hex representation of the text qualifier that is used in the detail records. |
Not applicable |
The valid value is the text or hex representation of the text qualifier that is used in the detail records. |
Optional |
|
Batch Indicator |
batch_indicator= |
The batch level indicator. |
Not applicable |
The system will accept a value of D. D indicates an LEA Level File. |
Optional |