WI DPI WISEdata Ed-Fi Docs

/localActuals

Data Properties:

#

Property Name

Data Type

Public (Required/ Optional/ Conditional)

Choice (Required/ Optional/ Conditional)

Business Definition

1.0

asOfDate

string

REQ'D

NOT REQ'D

The date of the reported amount for Account.

2.0

accountIdentifier

string

REQ'D

NOT REQ'D

Code value for the valid combination of account dimensions by LEA under which financials are reported.

3.0

educationOrganizationId

integer

REQ'D

NOT REQ'D

The identifier assigned to an education organization.

4.0

fiscalYear (under the localAccountReference)

integer

REQ'D

NOT REQ'D

Fiscal year for the account

5.0

amount

number

REQ'D

NOT REQ'D

Current balance for the account.


Use Cases:

#

Use Case Title

Use Case Description

What to Submit/retrieve

#

Use Case Title

Use Case Description

What to Submit/retrieve

1.0

Sending local actuals

LEAs are expected to submit actuals to the local account which is referenced to the DPI chart of account.

POST on /localActuals:

asOfDate: 2021-09-26
localAccountReference:
accountIdentifier: 18 digit account string. Can be the same AccountIdentifier on /chartOfAccount or a granular local account.
educationOrganizationId: 3166
fiscalYear: 2020,
amount: 8449.93

2.0

Sending the local actual amounts multiple times for an account

Sometimes LEAs need to correct the local actual amount for an account. If the account is already submitted to DPI with an As-of-Date, then LEAs has to submitted corrected amount with a new As-of-Date.

The amount with the latest As-of-Date is treated as valid amount when multiple amounts are submitted for the same chart of account in the same fiscal year.

POST on /localActuals:

asOfDate: 2021-09-26
localAccountReference:
accountIdentifier: 18 digit account string. Can be the same AccountIdentifier on /chartOfAccount or a granular local account.
educationOrganizationId: 3166
fiscalYear: 2020,
amount: 8449.93

POST on /localActuals:

asOfDate: 2021-12-19
localAccountReference:
accountIdentifier: 18 digit account string. Can be the same AccountIdentifier on /chartOfAccount or a granular local account.
educationOrganizationId: 3166
fiscalYear: 2020,
amount: 9000


JSON Sample:

{ "asOfDate": "2018-12-11 01:02:21.000", "localAccountReference": { "accountIdentifier": "50B000111456000000", "educationOrganizationId": 7533, "fiscalYear": 2020, }, "amount": '42643', }

 

 

Wisconsin Department of Public Instruction