If errors are encountered during the Load data process, you can correct the source data on the Fund Accounting Data form of the CT UCOA Municipal Trial Balance Report page. After corrections, you must purge and reload the data.
PowerSchool recommends that you correct the report’s source data that is retrieved from the Core application.
-
On the CT UCOA Municipal Trial Balance Report page, filter records using the filter criteria. To enter filter criteria:
-
Select an option in the first field.
-
Select or enter a value.
-
Select Add if the button is enabled.
Refer to Search for records for more information.-
To add a record, select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, and then Yes.
-
To edit a record, select the ellipsis in the Actions column and then select Edit. Update the information and select Save.
-
To delete a record, select the ellipsis in the Actions column, select Delete, and then select Yes.
-
To download the information, select Download, then select Download PDF or Download as an Excel Document.
-
-
Field descriptions
The following table describes the fields on the Fund Accounting Data form of the CT UCOA Municipal Trial Balance Report page.
|
Field |
Description |
Load logic - Data source and Valid values |
|---|---|---|
|
Year |
The fiscal year of the fund accounting data. This field is view-only and cannot be updated after saving the record. |
Not applicable |
|
UCOA Fund |
The state-level UCOA fund. |
Not applicable |
|
*Budget Unit* |
The budget unit (low organization). Select the Lookup icon to search for and select an organization. This field is view-only and cannot be updated after saving the record. |
The records in the Organization Search Tool are retrieved from the Organization Chart page. |
|
Title |
The title of the budget unit (low organization). This field is view-only. |
The field value is retrieved from the Title field on the Organization Record page. |
|
Fund |
The local district fund. This field is view-only and cannot be updated after saving the record. |
Not applicable |
|
UCOA Function |
The state-level UCOA function. |
Not applicable |
|
Function |
The local district function. This field is view-only and cannot be updated after saving the record. |
Not applicable |
|
UCOA Department |
The state-level UCOA department. |
Not applicable |
|
Department |
The local district department. This field is view-only and cannot be updated after saving the record. |
Not applicable |
|
UCOA Sub Department |
The state-level UCOA sub-department. |
Not applicable |
|
Sub Department |
The local district sub-department. This field is view-only and cannot be updated after saving the record. |
Not applicable |
|
UCOA Object |
The state-level UCOA object. |
Not applicable |
|
Account |
The local district account. Select the Lookup icon to search for and select an account. |
The records in the Account Search Tool are retrieved from the Account List page. |
|
Account Title |
The local district account’s title. This field is view-only. |
The field value is retrieved from the Title field on the Account List page. |
|
UCOA Account |
The state-level UCOA account. |
Not applicable |
|
Amount |
The total amount associated with the account. |
Not applicable |
|
Account Type |
The type of account. |
Valid values:
|
|
Exclude from report |
Indicates whether to exclude this record from the UCOA Municipal Trial Balance report. |
Valid values:
|