The Restricted Grid import file must be in one of the following formats:
-
.csv
-
.txt (pipe-delimited format)
The first three rows in the import file are skipped during the import process, but must contain data. You can fill these three rows with filler data.
The following table shows the column names, descriptions, and destination database fields for the Restricted Grid import file in .csv format.
|
Column |
Name |
Description |
Destination Field |
|---|---|---|---|
|
A |
blank |
Leave this column blank. |
Not applicable |
|
B |
Restricted Indicator |
Indicates whether this is a Restricted Grid import file. The valid value is RESTRICTED. |
Imported into the Restricted field on the Information form of the MN UFARS Report - Chapter X Validation page. |
|
C |
no name |
The valid value is X. |
Not applicable |
|
D |
Finance From/To |
The value of the valid UFARS Finance code range. The same value is used for Finance From and Finance To. |
Imported into the Finance From and Finance To fields on the Information form of the MN UFARS Report - Chapter X Validation page. |
|
E |
blank |
Leave this column blank. |
Not applicable |
|
F |
Fund |
The UFARS Fund code to which this validation rule applies. |
Imported into the Fund field on the Information form of the MN UFARS Report - Chapter X Validation page. |
|
G |
blank |
Leave this column blank. |
Not applicable |
|
H |
Org From |
The starting (low) value of the valid UFARS Organization code range. |
Imported into the Org From field on the Information form of the MN UFARS Report - Chapter X Validation page. |
|
I |
blank |
Leave this column blank. |
Not applicable |
|
J |
Org To |
The ending (high) value of the valid UFARS Organization code range. |
Imported into the Org To field on the Information form of the MN UFARS Report - Chapter X Validation page. |
|
K |
blank |
Leave this column blank. |
Not applicable |
|
L |
Program From |
The starting (low) value of the valid UFARS Program code range. |
Imported into the Program From field on the Information form of the MN UFARS Report - Chapter X Validation page. |
|
M |
blank |
Leave this column blank. |
Not applicable |
|
N |
Program To |
The ending (high) value of the valid UFARS Program code range. |
Imported into the Program To field on the Information form of the MN UFARS Report - Chapter X Validation page. |
|
O |
blank |
Leave this column blank. |
Not applicable |
|
P |
Object To |
The ending (high) value of the valid UFARS Object code range. |
Imported into the Object To field on the Information form of the MN UFARS Report - Chapter X Validation page. |
|
Q |
blank |
Leave this column blank. |
Not applicable |
|
R |
Object From |
The starting (low) value of the valid UFARS Organization code range. |
Imported into the Object From field on the Information form of the MN UFARS Report - Chapter X Validation page. |