Audit Log - File Layout and Data Mapping | PowerSchool ERP Compliance

The default file names of the Audit Log are:

PDF: IA Certified Annual Report (CAR)_Audit Log_<MMDDYYYY>_<hhmmss>.pdf
Excel: IA Certified Annual Report (CAR)_Audit Log_<MMDDYYYY>_<hhmmss>.csv

The following table shows the columns, names, descriptions, and the data sources or valid values for the Audit Log’s .csv file format.

Column	Column Name	Description	Data Source or Valid Values
A	FISCAL YEAR	The fiscal year of the data.	The field value is retrieved from the Reporting Year field on the IA Certified Annual Report (CAR) - Reports - Audit Log page.
B	DISTRICT ID	The district ID.	The field value is retrieved from the District ID field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
C	RECORD TYPE	Indicates whether the record was added, changed, or deleted.	Valid values: ADD CHANGE DELETE
D	BUDGET CODE1	Low organization to record transactions in your Expenditure Ledger, as defined in the Organization Chart. An expenditure record is identified by its budget unit-account combination and the fiscal year. The key organization, as it appears in the expenditure or revenue ledgers, or the fund code, as it appears in the general ledger.	The field value is retrieved from the *Budget Unit* field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
E	ACCOUNT	The account as it appears in the ledgers.	The field value is retrieved from the Account field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
F	CAR FUND	A separate fiscal and accounting entity with a self-balancing set of accounts, recording cash and other financial resources, and all related liabilities and residual equities, balances, or changes.	The field value is retrieved from the CAR Fund field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
G	CAR FACILITY	A combination of the operational unit and level of instruction. Only required for Charter schools.	The field value is retrieved from the CAR Facility field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
H	CAR FUNCTION	Describes the activity for which a service or material object is acquired. Required for expenditures.	The field value is retrieved from the CAR Function field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
I	CAR PROGRAM	A plan of activities and procedures designed to accomplish a predetermined objective or set of objectives.	The field value is retrieved from the CAR Program field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
J	CAR PROJECT	The project or reporting code enables school districts to track revenues and expenditures, meeting specialized reporting requirements at the local, state, and federal levels.	The field value is retrieved from the CAR Project field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
K	CAR OBJECT	This classification describes the service or commodity obtained as the result of a specific expenditure. Not used for revenue or balance sheet.	The field value is retrieved from the CAR Object field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
L	CAR SOURCE	The classification code for recording revenue and other receivables. Required for revenue.	The field value is retrieved from the CAR Source field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
M	CAR ACCOUNT	Balance sheet accounts track financial transactions for each fund. Not used for revenue or expenditure.	The field value is retrieved from the CAR Account field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
N	CHANGED AMOUNT	The updated cumulative total for all 13 periods for this organization/account or fund/account.	The field value is retrieved from the Amount field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.
O	ORIGINAL AMOUNT	The original cumulative total for all 13 periods for this organization/account or fund/account.	The application checks if the Amount field value changed after the last Load process. If there is a change, the previous Amount field value is stored in this field.
P	ACCOUNT ID	A code used to identify whether an accounting entry is a balance sheet, revenue, or expenditure. For balance sheet items, the account ID is the first position of the account code.	Valid values: 1 - Current Asset 2 - Long Term Asset 3 - Other Asset 4 - Current Liability 5 - Long Term Liability 6 - Other Liability 7 - Fund Balance 8 - Revenue 9 - Expenditure 1-7 indicates a Balance Sheet account. 8 indicates a Revenue account. 9 indicates an Expenditure account. The field value is retrieved from the Account ID field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.