DORIS Logo
 Back

  ChartOfAccounts


Description
Financial accounts used to record and organize financial transactions.

Data includes account status, description, applicable dates and parent/child relationship.

Fields
  chartOfAccountsId   string   
Unique identifier of chart of accounts
  chartOfAccountsTitle   string   
Chart of accounts description
  endDate   date   
End date of chart of accounts code
  isChild   boolean   
If chart of accounts code is associated with a child institution, value = 1, else 0
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  isParent   boolean   
If chart of accounts code is associated with a parent/main institution, value = 1, else 0
  recordActivityDate   date   
Date source record inserted or modified
  startDate   date   
Start date of chart of accounts code
  statusCode   enum   
Status of chart of accounts code
Allowed Values
  • Active
  • Inactive
Allowed Value Details
'Active' - Chart of accounts code is active and still posting to the ledger.

'Inactive' - Chart of accounts code is no longer active or is no longer contributing to an institution's financial activities.

Example SQL