The Line Number Assignment upload file is a pipe-delimited (|) text file containing line number assignment data for the Annual Spending Plan crosswalk configuration (ohefin_cxacct table).
The following table lists the positions, lengths, field names, descriptions, data types, and whether the field is required for the Line Number Assignment upload file.
|
Position |
Length |
Field Name |
Description |
Data Type |
Required |
|---|---|---|---|---|---|
|
1 |
5,3 |
Line Number |
The line number for the spending plan record (e.g., 1.000, 1.100, 2.000). Used to order and identify rows in the spending plan. |
Decimal |
Yes |
|
2 |
30 |
Description |
The description of the spending plan line item. |
Character |
No |
|
3 |
8 |
From Account |
The starting account number for the account range to include. |
Character |
No |
|
4 |
8 |
To Account |
The ending account number for the account range. If blank, it defaults to the From Account value. |
Character |
No |
|
5 |
8 |
From Fund |
The starting fund number for the fund range to include. |
Character |
No |
|
6 |
8 |
To Fund |
The ending fund number for the fund range. If blank, it defaults to the From Fund value. |
Character |
No |
|
7 |
8 |
From Organization |
The starting organization code for the organization range to include. |
Character |
No |
|
8 |
8 |
To Organization |
The ending organization code for the organization range. If blank, it defaults to the From Organization value. |
Character |
No |
|
9 |
1 |
Total Line Indicator |
Indicates whether this is a total line. Valid values:
This field can also be blank. |
Character |
No |
|
10 |
5,3 |
Total From Line |
If the Total Line Indicator value is Y, this field specifies the starting line number to include in the total calculation. |
Decimal |
Conditional |
|
11 |
5,3 |
Total To Line |
If the Total Line Indicator value is Y, this field specifies the ending line number to include in the total calculation. If blank, it defaults to the Total From Line value. |
Decimal |
Conditional |
|
12 |
1 |
Minus Indicator |
If the Total Line Indicator value is Y, this field indicates whether to subtract this range from the total. Valid values:
|
Character |
Conditional |