Account Translations - File Layout and Data Mapping
The default file names for the Account Translations reports are:
RPT: pemfin1.rpt
PDF: pemfin1_<xxxxx>.pdf
Excel: pemfin1rpt<xxxx_xxxxx>.xlsx
The report format varies depending on whether the Full Account Format is enabled.
Non-Full Account Format
The following table shows the columns, names, descriptions, and the data source or valid values for the Account Translations report’s Excel file when the Full Account Format is off.
Column | Name | Description | Data Source or Valid Values |
|---|---|---|---|
A | DISTRICT KEY ORGANIZATION | The key organization used by the district. | Retrieved from the District Key Orgn field on the Account Translations page. |
B | DISTRICT KEY ORGANIZATION TITLE | The title of the key organization used by the district. | Retrieved from the District Key Orgn Title field on the Account Translations page. |
C | DISTRICT ACCOUNT | The account used by the district. | Retrieved from the District Account field on the Account Translations page. |
D | DISTRICT ACCOUNT TITLE | The title of the account used by the district. | Retrieved from the District Account Title field on the Account Translations page. |
E | STATE FUND | The state fund. | Retrieved from the State Fund field on the Account Translations page. |
F | STATE FUNCTION | The state function. | Retrieved from the State Function field on the Account Translations page. |
G | STATE OBJECT | The state object. | Retrieved from the State Object field on the Account Translations page. |
H | STATE ORGANIZATION | The state organization code. | Retrieved from the State Organization field on the Account Translations page. |
I | STATE PROGRAM | The state program. | Retrieved from the State Program field on the Account Translations page. |
J | STATE YEAR | The state year. | Retrieved from the State Year field on the Account Translations page. |
Full Account Format
The following table shows the columns, names, descriptions, and the data source or valid values for the Account Translations report’s Excel file when the Full Account Format is enabled.
Column | Name | Description | Data Source or Valid Values |
|---|---|---|---|
A | DISTRICT ACCOUNT NUMBER | The full account number used by the district. | Retrieved from the District Account Number field on the Account Translations page. |
B | DISTRICT ACCOUNT NUMBER TITLE | The title of the full account number used by the district. | Retrieved from the District Account Number Title field on the Account Translations page. |
C | STATE FUND | The state fund. | Retrieved from the State Fund field on the Account Translations page. |
D | STATE FUNCTION | The state function. | Retrieved from the State Function field on the Account Translations page. |
E | STATE OBJECT | The state object. | Retrieved from the State Object field on the Account Translations page. |
F | STATE ORGANIZATION | The state organization code. | Retrieved from the State Organization field on the Account Translations page. |
G | STATE PROGRAM | The state program. | Retrieved from the State Program field on the Account Translations page. |
H | STATE YEAR | The state year. | Retrieved from the State Year field on the Account Translations page. |