financialReports
http://www.sifassociation.org/datamodel/na/3.5
Documentation
A flat-file layout report for financial education information that follows the education Chart of Accounts methodology.
Tree
Table
Name | Mandatory | Characteristics | Type | Description | XPath |
---|---|---|---|---|---|
@refId | * | gRefIdType | /financialReports/financialReport/@refId | ||
financialReport | any | /financialReports/financialReport | |||
reportDate | * | M | date | Date on which snapshot was generated (e.g., 6/30/14) | /financialReports/financialReport/reportDate |
@codesetName | * | string | /financialReports/financialReport/stateProvinceId/@codesetName | ||
code | * | M | token | State assigned reporting ID for district or agency (e.g., 00180000) | /financialReports/financialReport/stateProvinceId/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/stateProvinceId/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/stateProvinceId/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/stateProvinceId/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/stateProvinceId/otherCodeList/otherCode | |||
fiscalYear | * | M | string | The calendar year in which the last day of the fiscal year falls. Similar to school year in that the value contains one and only one four digit year. | /financialReports/financialReport/fiscalYear |
startDate | * | M | date | Start date of the period, inclusive. | /financialReports/financialReport/reportPeriod/startDate |
endDate | * | M | date | End date of the period, inclusive. | /financialReports/financialReport/reportPeriod/endDate |
@codesetName | * | string | /financialReports/financialReport/recordList/record/accountId/@codesetName | ||
code | * | M | token | A coded field that indicates the account classification. See the code set for up-to-date values and definitions. For example, 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 | /financialReports/financialReport/recordList/record/accountId/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/recordList/record/accountId/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/recordList/record/accountId/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/recordList/record/accountId/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/recordList/record/accountId/otherCodeList/otherCode | |||
@codesetName | * | string | /financialReports/financialReport/recordList/record/fund/@codesetName | ||
code | * | M | token | From NCES: A fund is a separate fiscal and accounting entity with a self-balancing set of accounts recording cash and other financial resources, together with all related liabilities and residual equities or balances, or changes therein. Current fund classifications: 1 General, 2 Special Revenue, 3 Capital Projects, 4 Debt Service, 5 Permanent, 6 Enterprise, 7 Internal Service, 8 Trust, 9 Agency | /financialReports/financialReport/recordList/record/fund/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/recordList/record/fund/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/recordList/record/fund/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/recordList/record/fund/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/recordList/record/fund/otherCodeList/otherCode | |||
@codesetName | * | string | /financialReports/financialReport/recordList/record/levelOfInstruction/@codesetName | ||
code | * | M | token | FROM NCES: This classification permits expenditures to be segregated by instructional level. Current level classifications: 10 Elementary, 11 Prekindergarten, 12 Kindergarten, 19, Other Elementary, 20 Middle, 30 Secondary, 37 Elementary and Secondary combined, 40 Postsecondary, 41 Programs for Adult/Continuing, 42 Community/Junior College, 50 School-wide | /financialReports/financialReport/recordList/record/levelOfInstruction/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/recordList/record/levelOfInstruction/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/recordList/record/levelOfInstruction/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/recordList/record/levelOfInstruction/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/recordList/record/levelOfInstruction/otherCodeList/otherCode | |||
@codesetName | * | string | /financialReports/financialReport/recordList/record/function/@codesetName | ||
code | * | M | token | From NCES: FunctionThe function describes the activity for which a service or material object is acquired. The functions of a school district are classified into five broad areas: instruction, support services, operation of noninstructional services, facilities acquisition and construction, and debt service. Functions are further classified into subfunctions. | /financialReports/financialReport/recordList/record/function/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/recordList/record/function/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/recordList/record/function/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/recordList/record/function/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/recordList/record/function/otherCodeList/otherCode | |||
@codesetName | * | string | /financialReports/financialReport/recordList/record/object/@codesetName | ||
code | * | M | token | From NCES: This classification is used to describe the service or commodity obtained as the result of a specific expenditure. | /financialReports/financialReport/recordList/record/object/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/recordList/record/object/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/recordList/record/object/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/recordList/record/object/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/recordList/record/object/otherCodeList/otherCode | |||
@codesetName | * | string | /financialReports/financialReport/recordList/record/program/@codesetName | ||
code | * | M | token | From NCES: A program is a plan of activities and procedures designed to accomplish a predetermined objective or set of objectives. Current broad classifications: 100 Regular elementary/secondary education programs, 200 Special programs, 300 Vocational and technical programs, 400 Other instructional programs--elementary/secondary, 500 Nonpublic school programs, 600 Adult/continuing education programs, 700 Community/Junior college education programs, 800 Community services programs, Cocurricular and extracurricular activities | /financialReports/financialReport/recordList/record/program/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/recordList/record/program/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/recordList/record/program/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/recordList/record/program/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/recordList/record/program/otherCodeList/otherCode | |||
@codesetName | * | string | /financialReports/financialReport/recordList/record/facility/@codesetName | ||
code | * | M | token | District-assigned operational unit or cost objective. | /financialReports/financialReport/recordList/record/facility/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/recordList/record/facility/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/recordList/record/facility/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/recordList/record/facility/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/recordList/record/facility/otherCodeList/otherCode | |||
@codesetName | * | string | /financialReports/financialReport/recordList/record/project/@codesetName | ||
code | * | M | token | From NCES: The project/reporting code permits school districts to accumulate expenditures to meet a variety of specialized reporting requirements at local, state, and federal levels. Current ranges: 010-190 Local Projects, 200-390 State Projects, 400-990 Federal Projects, 000 Noncategorical. | /financialReports/financialReport/recordList/record/project/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/recordList/record/project/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/recordList/record/project/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/recordList/record/project/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/recordList/record/project/otherCodeList/otherCode | |||
@codesetName | * | string | /financialReports/financialReport/recordList/record/source/@codesetName | ||
code | * | M | token | From NCES: These codes are for recording revenue and other receivables by source. | /financialReports/financialReport/recordList/record/source/code |
hexValue | string | As of version 3.4 hex values are not published with the code sets. | /financialReports/financialReport/recordList/record/source/hexValue | ||
hexValueDashed | string | This element is deprecated as of version 3.3 and should not be used. | /financialReports/financialReport/recordList/record/source/hexValueDashed | ||
@codesetName | string | /financialReports/financialReport/recordList/record/source/otherCodeList/otherCode/@codesetName | |||
otherCode | string | /financialReports/financialReport/recordList/record/source/otherCodeList/otherCode | |||
amount | * | M | string | Amount of a transaction or a summarized amount. | /financialReports/financialReport/recordList/record/amount |
Download: .xlsx (with CEDS & Formats)
Structure