CCUBS_Data_Dictonary_MAQCS.xlsx
XLSX spreadsheet 52 KB Posted
- Attached to
- Montana Access to Quality Childcare System MAQCS
- Solicitation number
- DPHHS-RFP-2024-0492KH
- Issued by
- Montana
About this file
The document is a comprehensive data dictionary for the Montana Access to Quality Childcare System (MAQCS), developed for the State of Montana's child care licensing and subsidy management system. The data dictionary contains 404 database tables spanning multiple subject areas including authorization, contracts, invoicing, inspections, persons, providers, workers, and financial transactions. The system supports critical child care administrative functions such as provider licensing, subsidy management, contract tracking, background investigations, and eligibility determinations.
The data dictionary reveals a complex, interconnected database design with numerous code tables and reference tables that enable detailed tracking and management of child care services. Key functional areas include provider management (with tables tracking provider types, statuses, licenses, and quality levels), contract management (including budget items, applications, and worker associations), and comprehensive person and caregiver tracking (with tables for certifications, training, career paths, and approvals). The database appears designed to support comprehensive, data-driven decision-making across the child care ecosystem, with robust capabilities for recording, verifying, and reporting on various child care system interactions and stakeholder information.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attach 8 - Technology Matrix.xlsx | XLSX spreadsheet | |
| 1175725-event.pdf | ||
| CCUBS_Production_Calendar_2023_MAQCS.pdf | ||
| Section_5_Cost_Sheet.xlsx | XLSX spreadsheet | |
| Output_Inventory_MAQCS.xlsx | XLSX spreadsheet | |
| Project_Management_Deliverables_MAQCS.xlsx | XLSX spreadsheet | |
| CCUBS_ERD_Tables_MAQCS.pdf | ||
| Attach 7 - Resource Allocation Schedules.xlsx | XLSX spreadsheet | |
| Acronyms_Definitions_and_Terms_MAQCS.xlsx | XLSX spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Main Anchor Tables
| Main Table? Yes/No, then related tables | Count of Row | |
| No | 183 | Main Tables |
| ADDRESS | 6 | CAREGIVER |
| ALERTS | 2 | CONTRACT |
| AUTHORIZATION | 21 | CONTRACTS |
| BACKGROUND-INVESTIGATION | 8 | INSPECTION |
| CASE-EVENT | 18 | INVOICE |
| CASE-EVENT-PERSON | 9 | NOTES |
| CHIMES-INTERFACE | 2 | NOTIFICATION |
| COPAY | 4 | ORGANIZATION |
| ELIGIBILITY-DETERMINATION | 8 | PERSON |
| FINANCIAL | 8 | PROVIDER |
| GENERAL-SYSTEM-INFO | 6 | WORKER |
| INCOME-ACTIVITY-DEDUCTION | 13 | |
| INFORMATION-COMPLAINTS | 19 | |
| JOB-PROCESSES | 4 | |
| NOTIFICATION-PROCESSING | 2 | |
| ONLINE-APP | 7 | |
| ONLINE-PORTAL | 3 | |
| PROVIDER-LICENSE | 6 | |
| PROVIDER-RATES | 7 | |
| REPORTING | 6 | |
| STAGING-TABLES | 4 | |
| STAR-QUALITY | 9 | |
| TARGET-MAILER | 6 | |
| (blank) | 5 | |
| Yes | 140 | |
| CAREGIVER | 19 | |
| CONTRACT | 14 | |
| CONTRACTS | 2 | |
| INSPECTION | 9 | |
| INVOICE | 21 | |
| NOTES | 5 | |
| NOTIFICATION | 10 | |
| ORGANIZATION | 11 | |
| PERSON | 28 | |
| PROVIDER | 10 | |
| WORKER | 11 | |
| Grand Total | 323 |
All Tables
| Row | Main | MAIN SUBJECT AREA | TABLE_NAME | OTHER SUBJECT AREAS | COMMENTS |
| 1 | No | CHCA_ABSENT_DAYS_MM | Absent Days Month (Not used since 5/30/2020) | ||
| 2 | No | GENERAL-SYSTEM-INFO | CHCA_ACCESS_TYPES | Type associated to the information complaint worker. There is only one type on the database and that is Assigned. | |
| 10 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_ACTIVITY_TYPES | Activity Types Code Table | |
| 11 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_ACTV_SCHE_VARIATION_TYPS | Activity Schedule Vairiation Type Code Table | |
| 12 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_ACTV_VERIFICATION_TYPES | Activity Verification Type Code Table | |
| 13 | No | ADDRESS | CHCA_ADDRESS_TYPES | Address Types Code Table | |
| 14 | No | ADDRESS | CHCA_ADDRESS_USAGE_TYPES | Address Usage Types Code Table | |
| 15 | No | ADDRESS | CHCA_ADDRESSES | PERSON,PROVIDER,ORGANIZATION,INFORMATION-COMPLAINT, | Address details based on the address type and usage |
| 16 | Yes | INVOICE | CHCA_ADJ_ACTIVITIES | Adjustment activity details | |
| 17 | Yes | INVOICE | CHCA_ADJ_OVERPAYMENT_DETAILS | Adjustment overpayment details | |
| 18 | Yes | INVOICE | CHCA_ADJUSTMENT_ACTIVITY_TYPES | Adjustment Activity Types Code Table | |
| 19 | Yes | INVOICE | CHCA_ADJUSTMENT_REASONS | Reason for Adjustment Code Table | |
| 20 | Yes | INVOICE | CHCA_ADJUSTMENT_TYPES | Adjustment Types Code Table | |
| 21 | Yes | INVOICE | CHCA_ADJUSTMENTS | CONTRACT | Adjustment detail information |
| 22 | No | ALERTS | CHCA_ALERT_TYPES | Alert Types Code Table | |
| 23 | Yes | INSPECTION | CHCA_ARM_NUMBER_DETAILS | Arm Number Details Code Table | |
| 25 | Yes | INSPECTION | CHCA_ARMS_EXCEPTION_REASONS | Arms Exception Reasons Code Table | |
| 26 | Yes | INVOICE | CHCA_ATTENDANCE_CODES | Attendance Code Types Code Table | |
| 27 | No | AUTHORIZATION | CHCA_AUTH_DOLLR_AMT_OVRRD_RSNS | Authorization Dollar Amount Override Reason Code Table | |
| 28 | No | AUTHORIZATION | CHCA_AUTH_PROV_MMY_FEES | The provider fee authorization details | |
| 29 | No | AUTHORIZATION | CHCA_AUTH_SERVICE_PERIOD_TYPES | Authorization of Services Period Code Type Table | |
| 30 | No | AUTHORIZATION | CHCA_AUTH_STS_HISTS | The status history for the authorization | |
| 31 | No | AUTHORIZATION | CHCA_AUTH_WORKSHEET_DAILY_HRS | Authorization worksheet entries capturing the projected number of hours for each day. | |
| 32 | No | AUTHORIZATION | CHCA_AUTH_WORKSHEET_TYPES | Authorization worksheet types. | |
| 33 | No | AUTHORIZATION | CHCA_AUTH_WORKSHEETS | Authorization worksheets used to determine the projected attendance for an authorization. | |
| 34 | No | AUTHORIZATION | CHCA_AUTHORIZATION_DETAILS | Contains additional authorization details including monthly authorized amount | |
| 35 | No | AUTHORIZATION | CHCA_AUTHORIZATION_STS_TYPES | Authorization Status Types Code Table | |
| 36 | No | AUTHORIZATION | CHCA_AUTHORIZATION_TYPES | Authorization Types Code Table | |
| 37 | No | AUTHORIZATION | CHCA_AUTHORIZATIONS | CASE-EVENT-PERSON, NOTIFICATION | Authorization details for a child including the provider and hours / days authorized |
| 38 | No | AUTHORIZATION | CHCA_AUTHORIZED_PROV_FEE_TYPES | Provider Fee Types Code Table | |
| 39 | No | AUTHORIZATION | CHCA_AUTHORIZED_RATES | The rates authorized for the authorization | |
| 40 | Yes | PROVIDER | CHCA_BILLING_CYCLE_TYPES | Billing Cycle Types Code Table | |
| 41 | No | BACKGROUND-INVESTIGATION | CHCA_BKGD_INVST_BASED_ON_TYPES | The code table identifying the Based On types for a background investigation. | |
| 42 | No | BACKGROUND-INVESTIGATION | CHCA_BKGD_INVSTG_SOURCE_CODES | Background Investigation Source Code Table | |
| 43 | No | BACKGROUND-INVESTIGATION | CHCA_BKGD_INVSTG_STATE_RESULTS | The results of a persons Background Investigation | |
| 44 | No | BACKGROUND-INVESTIGATION | CHCA_BKGD_INVSTG_STT_RESLT_TPS | Background Investigation Result Types Code Table | |
| 45 | No | BACKGROUND-INVESTIGATION | CHCA_BKGD_INVSTG_TYPE_CODES | Background Investigation Types Code Table | |
| 46 | No | BACKGROUND-INVESTIGATION | CHCA_BKGD_INVSTGS | CAREGIVER | Person Background Investigation details |
| 47 | No | BACKGROUND-INVESTIGATION | CHCA_BKGD_INVSTGT_STT_CODES | Background Investigation Status Code Table | |
| 48 | No | STAR-QUALITY | CHCA_BONUS_HISTS | A providers quailty bonus spans | |
| 49 | Yes | CONTRACTS | CHCA_BUDGET_ITEM_CODES | Budget Item Types Code Table used by contracts | |
| 50 | Yes | CONTRACTS | CHCA_BUDGET_SECTION_CODES | Budget Section Types Code Table used by contracts | |
| 59 | Yes | CAREGIVER | CHCA_CARE_APPROV_CRITER_TYPES | Caregiver Approval Criteria Type code table. | |
| 60 | Yes | CAREGIVER | CHCA_CARE_APPROV_ROLE_TYPE | Caregiver Approval Highest Approved Role Type Code table. | |
| 61 | Yes | CAREGIVER | CHCA_CARE_APPROV_STS_CODES | Caregiver Approval Status Code table. | |
| 62 | No | STAR-QUALITY | CHCA_CARE_PROV_ACCRDITG_BODIES | Care Provider Accrediting Body Code Table | |
| 63 | Yes | PROVIDER | CHCA_CARE_PROV_BILLING_CYCLES | A providers billing cycles | |
| 64 | No | AUTHORIZATION | CHCA_CARE_PROV_BY_TYPES | Code table listing types of care providers | |
| 65 | No | STAR-QUALITY | CHCA_CARE_PROV_ENVIRNMT_QLTIES | Deprecated. No new data since 2004 | |
| 66 | No | STAR-QUALITY | CHCA_CARE_PROV_QLTY_HISTS | Quality levels for a provider | |
| 67 | No | STAR-QUALITY | CHCA_CARE_PROV_QUALITY_LEVELS | Provider Quality Level Code Table | |
| 69 | Yes | PROVIDER | CHCA_CARE_PROV_STATUSES | A providers status | |
| 70 | Yes | PROVIDER | CHCA_CARE_PROV_STS_TYPES | Provider Status Types Code Table | |
| 71 | No | INFORMATION-COMPLAINTS | CHCA_CARE_PROVIDER_COMPLAINTS | Cross reference table between a provider and a complaint | |
| 72 | Yes | PROVIDER | CHCA_CARE_PROVIDER_TYPES | Provider Types Code Table | |
| 73 | Yes | PROVIDER | CHCA_CARE_PROVIDER_WORKERS | The workers assigned to a provider | |
| 74 | Yes | PROVIDER | CHCA_CARE_PROVIDERS | ORGANIZATION,STAR-QUALITY,ALERTS | General information about a child care provider |
| 75 | No | STAR-QUALITY | CHCA_CARE_QUALIFY_LEVEL_TYPES | Caregiver Experience/Training Qualification Level code table. | |
| 76 | No | CASE-EVENT | CHCA_CARE_REASON_CATEGORIES | Care Reason Category Types Code Table | |
| 77 | Yes | CAREGIVER | CHCA_CAREER_PATH_STATUS_TYPES | Career Path Status Code Type Table | |
| 78 | Yes | CAREGIVER | CHCA_CAREER_PATH_TYPES | Career Path Code Type Table | |
| 79 | No | CASE-EVENT-PERSON | CHCA_CASE_EVENT_PERSONS | AUTHORIZATION, NOTES,NOTIFICATION | General information about each person assoicated with a case event |
| 80 | No | CASE-EVENT | CHCA_CASE_EVENT_PROVIDERS | AUTHORIZATION, NOTIFICATION,INSPECTION | Cross reference table between a case event and a provider |
| 81 | No | CASE-EVENT | CHCA_CASE_EVENT_REASONS | A case events reasons for care | |
| 82 | No | CASE-EVENT | CHCA_CASE_EVENT_WORKERS | Cross reference table between a case event and a worker | |
| 83 | No | CASE-EVENT | CHCA_CASE_EVENTS | ELIGIBILITY-DETERMINATION,NOTES, ONLINE-APP,ALERTS | General information about a case event |
| 84 | No | CASE-EVENT | CHCA_CASE_EVNT_COPAY_ASMTS | A case events copay obligation | |
| 85 | No | CASE-EVENT-PERSON | CHCA_CASE_EVNT_PERS_TO_PRIMS | Case Event Person Association Types Code Table | |
| 86 | No | CASE-EVENT-PERSON | CHCA_CASE_EVNT_PERSON_PTCPS | A persons participation on a case event | |
| 89 | No | REPORTING | CHCA_CCDF_ACF_800S | ACF-801 Data Extract | |
| 90 | No | CASE-EVENT | CHCA_CE_CLOSURE_RSN_TYPES | Case Event Closure Reason Types Code Table | |
| 91 | No | CASE-EVENT | CHCA_CE_PROV_COPAY_AMTS | Copay amounts for specific months for a provider | |
| 92 | No | CASE-EVENT | CHCA_CE_PROV_COPAY_EFF_DATES | Cross reference between the case event and the copay months used by the copay amounts | |
| 93 | No | CASE-EVENT | CHCA_CE_STATUS_TYPES | Case Event Status Types Code Table | |
| 94 | No | CASE-EVENT | CHCA_CE_STATUSES | The statuses of a case event | |
| 95 | No | CASE-EVENT | CHCA_CE_WORKER_ASSOCS | The workers assigned to a case event | |
| 97 | No | GENERAL-SYSTEM-INFO | CHCA_CFS_REGIONS | Child and Family Services Regions Code Table | |
| 98 | No | CASE-EVENT | CHCA_CHILD_CARE_CASES | Listing of Case Id Seqs | |
| 99 | No | PROVIDER-RATES | CHCA_CHILD_CARE_RATE_PRCNTGS | Subsidy Rate Child Care Rate Percentages. | |
| 100 | No | NOTIFICATION-PROCESSING | CHCA_CHILD_CARE_REGIONS | Child Care Regions Code Table | |
| 101 | No | AUTHORIZATION | CHCA_CHILD_CARE_SERVICE_TYPES | Child Care Servicce Types Code Table | |
| 102 | No | AUTHORIZATION | CHCA_CHILD_CARE_TYPES | Child Care Types Code Table | |
| 103 | No | PROVIDER-RATES | CHCA_CHILD_RATE_CATEGORIES | Child Rate Categories Code Table | |
| 104 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_CHILD_SUPPORT_CHILDREN | An association between child support income and the child person record | |
| 105 | No | CHIMES-INTERFACE | CHCA_CHIMES_ED_LEVEL_CODES | CHIMES Education Level Code Table | |
| 106 | No | CHIMES-INTERFACE | CHCA_CHIMES_RLTSHIP_CODES | CHIMES Relationship information for WoRC Referral from CHIMES SNAP-TANF | |
| 107 | Yes | PERSON | CHCA_CITIZENSHIP_VRF_TYPES | Citizenship Verification Types Code Table | |
| 109 | No | INFORMATION-COMPLAINTS | CHCA_CMPLT_ALLEGATIONS | Complaint Allegations associated with an Information Complaint | |
| 110 | No | INFORMATION-COMPLAINTS | CHCA_CMPLT_ASSESSMENTS | Assessments associated with an Information Complaint | |
| 111 | No | INFORMATION-COMPLAINTS | CHCA_CMPLT_INVSTG_METHOD_CODES | Information Complaint Investigation Method Code Table | |
| 112 | No | INFORMATION-COMPLAINTS | CHCA_COMPLAINT_ALLEGATION_CDS | Information Complaint Allegation Types Code Table | |
| 113 | No | INFORMATION-COMPLAINTS | CHCA_COMPLAINT_ASSESSMENT_CDS | Information Complaint Assessment Code Table | |
| 114 | No | INFORMATION-COMPLAINTS | CHCA_COMPLAINT_INVSTGS | Investigations associated to an Information Complaint | |
| 115 | No | INFORMATION-COMPLAINTS | CHCA_COMPLAINT_METHOD_CODES | Information Complaint Method Code Table | |
| 116 | No | INFORMATION-COMPLAINTS | CHCA_COMPLAINT_WORKERS | Cross reference table between an information complaint and a worker | |
| 117 | Yes | CONTRACT | CHCA_CONTACT_METHODS | Contact Methods Code Table | |
| 118 | Yes | CONTRACT | CHCA_CONTRACT_APPL_STAT_CODES | Contract Application Status Code Table | |
| 119 | Yes | CONTRACT | CHCA_CONTRACT_APPLICATIONS | CAREGIVER | General information about a contract application |
| 120 | Yes | CONTRACT | CHCA_CONTRACT_BUDGET_ITEMS | The budget items associated with a contract budget | |
| 121 | Yes | CONTRACT | CHCA_CONTRACT_BUDGETS | The budget information for a contract | |
| 123 | Yes | CONTRACT | CHCA_CONTRACT_REQUIRED_ITEMS | The required items associated with a contract | |
| 124 | Yes | CONTRACT | CHCA_CONTRACT_STATUS_CODES | Contract Status Code Table | |
| 125 | Yes | CONTRACT | CHCA_CONTRACT_TYPE_CODES | Type of Contract Code Table | |
| 126 | Yes | CONTRACT | CHCA_CONTRACT_WORKERS | WORKER | Cross reference table between a contract and a worker |
| 127 | Yes | CONTRACT | CHCA_CONTRACTS | NOTIFICATION,ALERTS | General information about a contract |
| 128 | Yes | CONTRACT | CHCA_CONTT_DENIAL_TERM_CODES | Contract Denial Termination Code Table | |
| 129 | No | COPAY | CHCA_COPAY_AMTS | Income threshold and percentage of income code table for determining copay amount | |
| 130 | No | COPAY | CHCA_COPAY_FAMILY_SIZES | Familiy size code table for determining copay amounts | |
| 131 | No | COPAY | CHCA_COPAY_FEE_SCALES | Cross reference table of copay effective dates | |
| 132 | No | COPAY | CHCA_COPAY_WAIVER_REASONS | Copay Waive Reason code table | |
| 133 | No | ADDRESS | CHCA_COUNTIES | TARGET-MAILER | County FIPS Code Table |
| 134 | Yes | WORKER | CHCA_CRISS_TRAINING | CRISS Training Table. | |
| 135 | Yes | CONTRACT | CHCA_CURRENT_CONTRACTORS | General information about a contractor | |
| 136 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_DEDUCTION_VRF_TYPES | Deduction Verification Types Code Table | |
| 137 | No | PROVIDER-LICENSE | CHCA_DENIAL_TERMN_REASON_CODES | Denial or Termination Reason Code Table for provider licenses | |
| 138 | Yes | PERSON | CHCA_DOB_VERIFICATION_TYPES | Date of Birth Verification Code Table | |
| 139 | Yes | CAREGIVER | CHCA_DOCUMENT_TYPES | Document type code table | |
| 141 | No | CASE-EVENT-PERSON | CHCA_ELIG_CASE_MEMBER_INFO | CASE-EVENT,ELIGIBILITY-DETERMINATION | Case member information at eligibility determination |
| 142 | No | ELIGIBILITY-DETERMINATION | CHCA_ELIG_DET_FACTORS | Factors used for determining eligibility for a case event | |
| 143 | Yes | INVOICE | CHCA_ELIG_OR_MAN_ADJ_RSN_TYPES | Adjustment Reason Code Table | |
| 144 | Yes | INVOICE | CHCA_ELIG_OR_MANUAL_ADJ_RSNS | Cross reference between an adjustment and an adjustment reason type | |
| 145 | No | ELIGIBILITY-DETERMINATION | CHCA_ELIGIBILITY_DET_REASONS | Eligibility Determiantion Reasons Code Table | |
| 146 | No | ELIGIBILITY-DETERMINATION | CHCA_ELIGIBILITY_DETS | CASE-EVENT-PERSON, CASE-EVENT, NOTIFICATION | Eligibility Determination information for a case event |
| 150 | Yes | PERSON | CHCA_ETHNIC_AFFINITIES | Ethnic Affinity Code Table | |
| 151 | No | ELIGIBILITY-DETERMINATION | CHCA_EVALUATION_DET_REASONS | Evaluation Determination Reasons Code Table | |
| 152 | No | ELIGIBILITY-DETERMINATION | CHCA_EVALUATION_TYPES | Evaluation Types Code Table | |
| 153 | No | ELIGIBILITY-DETERMINATION | CHCA_EVALUATIONS | CASE-EVENT-PERSON | Evaluation details for an eligiblity determination for a case event |
| 163 | Yes | WORKER | CHCA_FAVORITES | Contains favorite screens in forms for easy access for a worker | |
| 164 | Yes | ORGANIZATION | CHCA_FEINS | Contains the FEIN Ids for an organization | |
| 165 | No | FINANCIAL | CHCA_FINANCIAL_TRAN_DETAILS | Contains Financial Transaction detail information for an invoice | |
| 166 | No | FINANCIAL | CHCA_FINANCIAL_TRAN_STATUSES | Financial Transaction Status Code Table | |
| 167 | No | FINANCIAL | CHCA_FINANCIAL_TRANSACTIONS | Contains Financial Transactions information including warrant numbers and recipient. | |
| 168 | No | GENERAL-SYSTEM-INFO | CHCA_FISCAL_YEAR | A list of calendar months and the fiscal years they belong to | |
| 169 | No | CASE-EVENT | CHCA_FMLY_HMLSS_HSTRY | ELIGIBILITY-DETERMINATION | Case Event Family Homeless History |
| 170 | No | CASE-EVENT | CHCA_FMLY_HMLSS_STS | ELIGIBILITY-DETERMINATION | Case Event Family Homeless Status |
| 171 | No | FINANCIAL | CHCA_FNCL_TRANS_DETAIL_TYPES | Financial Transaction Detail types Code Table | |
| 172 | No | FINANCIAL | CHCA_FNCL_TRANS_STS_HISTS | History of the statuses for a Financial Transaction | |
| 174 | No | AUTHORIZATION | CHCA_FUND_ACCOUNTS | Fund Account Code Table | |
| 176 | No | TARGET-MAILER | CHCA_GRPT_MAIL_XREF | Target Mailer Details information for including mailers with specific notifications | |
| 177 | No | TARGET-MAILER | CHCA_GRPT_TYPE | Target Mailer Group Type Code Table | |
| 178 | No | GENERAL-SYSTEM-INFO | CHCA_HOLIDAY_NAMES | Holiday Names Code Table | |
| 179 | No | GENERAL-SYSTEM-INFO | CHCA_HOLIDAYS | Contains the Holiday Dates | |
| 181 | Yes | CAREGIVER | CHCA_IMMUNIZATION_TYPES | Immunization Types Code Table | |
| 182 | Yes | CAREGIVER | CHCA_IMMUNIZATION_VRF_TYPES | Immunization Verification Types Code Table | |
| 183 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_INCOME_DEDUCTION_TYPES | Income Deduction Types Code Table | |
| 184 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_INCOME_SOURCE_TYPES | Income Source Types Code Table | |
| 186 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_INCOME_VERIFICATION_TYPES | Income Verification Types Code Table | |
| 187 | No | INFORMATION-COMPLAINTS | CHCA_INFO_CMPL_INVST_INSPT_CMN | Comments for Information Complaints Investigations and Inspections | |
| 188 | No | INFORMATION-COMPLAINTS | CHCA_INFO_COMPL_ACTION_CODES | Information Complaint Action Codes Code Table | |
| 189 | No | INFORMATION-COMPLAINTS | CHCA_INFO_COMPL_STATUS_CODES | Information Complaint Status Codes Code Table | |
| 190 | No | INFORMATION-COMPLAINTS | CHCA_INFO_COMPLAINT_PERSONS | CAREGIVER | Contains information for persons associated to an Information Complaint |
| 191 | No | INFORMATION-COMPLAINTS | CHCA_INFO_COMPLAINT_ROLE_CODES | Information Complaint Role Code Table | |
| 192 | No | INFORMATION-COMPLAINTS | CHCA_INFO_COMPLAINT_STATUSES | History of the statuses for an Information Complaint | |
| 193 | No | INFORMATION-COMPLAINTS | CHCA_INFO_COMPLAINT_TYPE_CODES | Information Complaint Types Code Table | |
| 194 | No | INFORMATION-COMPLAINTS | CHCA_INFORMATION_CMPLT_ACTIONS | Cross reference between the information complaint and actions | |
| 195 | No | INFORMATION-COMPLAINTS | CHCA_INFORMATION_COMPLAINTS | ADDRESS, NOTES,NOTIFICATION,ALERTS,INSPECTION | Details for each Information Complaint |
| 197 | Yes | INSPECTION | CHCA_INSPECTION_STATUS_CODES | Inspection Status Codes Code Table | |
| 198 | Yes | INSPECTION | CHCA_INSPECTION_TYPE_CODES | Inspection Type Codes Code Table | |
| 199 | Yes | INSPECTION | CHCA_INSPT_SURVEY_TOOLS | Inspection Survey Tools Code Table | |
| 201 | Yes | INVOICE | CHCA_INVOICE_APPROVALS | History of the approvals for an invoice | |
| 202 | No | AUTHORIZATION | CHCA_INVOICE_AUTH_TOTALS | Invoice authorization totals | |
| 203 | Yes | INVOICE | CHCA_INVOICE_DETAIL_SPANS | Time interval spans for child care services provided | |
| 204 | Yes | INVOICE | CHCA_INVOICE_DETAILS | Invoice Details including amounts and attendance | |
| 205 | Yes | INVOICE | CHCA_INVOICE_HISTORIES | Listing of Invoice History records | |
| 206 | Yes | INVOICE | CHCA_INVOICE_STATUS | Invoice Status Types Code Table | |
| 207 | Yes | INVOICE | CHCA_INVOICE_STATUS_HISTORIES | History of the statuses for an invoice history | |
| 208 | Yes | INVOICE | CHCA_INVOICES | NOTIFICATION | Details for each Invoice |
| 210 | Yes | PERSON | CHCA_LAST_GRADE_COMPLETED | Last Grade in School Completed Code Table | |
| 212 | No | NOTIFICATION-PROCESSING | CHCA_LICENSING_ENTITY_CODES | Licensing Entity Types Code Table | |
| 213 | No | TARGET-MAILER | CHCA_LICENSING_SRVC_AREAS | Licensing Service Area Code Table | |
| 214 | Yes | PERSON | CHCA_MARITAL_STATUSES | Marital Status Types Code Table | |
| 216 | No | CHCA_MATCH_TYPE_CODES | Match Types Code Table | ||
| 217 | No | BACKGROUND-INVESTIGATION | CHCA_MEETS_CRITERIA_TYPES | The code table identifying a Meets Criteria types. | |
| 219 | No | CASE-EVENT | CHCA_MLRTY_HSTRY | Case Event Military History | |
| 220 | No | CHCA_MLRTY_STS | Case Event Military Status | ||
| 221 | Yes | INSPECTION | CHCA_MONTANA_ARM_NUMBERS | Montana ARM Number Code Table | |
| 222 | Yes | ORGANIZATION | CHCA_NAIC_CODES | NAIC Codes Code Table for organizations | |
| 223 | Yes | NOTES | CHCA_NOTE_CATEGORIES | Note Category Types Code Table | |
| 224 | Yes | NOTES | CHCA_NOTE_DETAILS | Note Details of a Note | |
| 225 | Yes | NOTES | CHCA_NOTE_TYPE_CTG_TYPE_XREFS | Cross reference between a note catgory and the note type. | |
| 226 | Yes | NOTES | CHCA_NOTE_TYPES | Note Types Code Table | |
| 227 | Yes | NOTES | CHCA_NOTES | CASE-EVENT-PERSON,CASE-EVENT, PERSON,PROVIDER,WORKER | Listing of Notes records |
| 228 | Yes | NOTIFICATION | CHCA_NOTIFICATION_ADDRESSEES | ADDRESS | Address types associated to a notification |
| 229 | Yes | NOTIFICATION | CHCA_NOTIFICATION_BRCD | Barcode information for a recipient and their notifications | |
| 230 | Yes | NOTIFICATION | CHCA_NOTIFICATION_DETAILS | Listing of Details to be used in the notification | |
| 231 | Yes | NOTIFICATION | CHCA_NOTIFICATION_PDFS | Contains the PDF file of the notification | |
| 232 | Yes | NOTIFICATION | CHCA_NOTIFICATION_STATUS_TYPES | Notificaton Status Types Code Table | |
| 233 | Yes | NOTIFICATION | CHCA_NOTIFICATION_TYPES | TARGET-MAILER | Notification Types Code Table |
| 234 | Yes | NOTIFICATION | CHCA_NOTIFICATIONS | ELIGIBILITY-DETERMINATION, ONLINE-APP,WORKER | Listing of Notification records |
| 235 | Yes | NOTIFICATION | CHCA_NTF_ADDRESSEE_TYPES | Notification Addressee Types Code Table | |
| 236 | Yes | NOTIFICATION | CHCA_NTF_STATUSES | History of the statuses for a notification | |
| 237 | Yes | NOTIFICATION | CHCA_NTF_TYPE_ADDRESSEES | Cross Reference of addressee types and notification types | |
| 238 | No | ONLINE-APP | CHCA_OA_HOIN | Online Application Household Information | |
| 239 | No | ONLINE-APP | CHCA_OA_HOME | Online Application Household Members | |
| 240 | No | ONLINE-APP | CHCA_OA_PRNA | Online Application Pervious Names | |
| 241 | No | ONLINE-APP | CHCA_OA_RAET | Online Application Race and Ethnicity | |
| 242 | No | ONLINE-APP | CHCA_OA_STATUS_CODES | Online Application Status Codes | |
| 243 | No | ONLINE-APP | CHCA_OA_STATUSES | Online Application Statuses | |
| 244 | No | STAGING-TABLES | CHCA_OI_AUTH_STG | Online Invoice Authorized Children | |
| 245 | No | STAGING-TABLES | CHCA_OI_DETAIL_SPANS_STG | Staging table capturing time-in and time-out records for a single Invoice Detail. | |
| 246 | No | STAGING-TABLES | CHCA_OI_DETAILS_STG | Online Invoice Details | |
| 247 | Yes | INVOICE | CHCA_OI_PARTICIPATION | Online Invoice Participation | |
| 248 | No | ONLINE-APP | CHCA_ONLINE_APPS | CASE-EVENT, NOTIFICATION | Online Applications |
| 250 | No | STAGING-TABLES | CHCA_ONLINE_INVC_STG | Online Invoices | |
| 251 | No | ONLINE-PORTAL | CHCA_ONLINE_NOTIFICATIONS | Online Notification Options | |
| 253 | Yes | ORGANIZATION | CHCA_ORG_ALT_DESG | A listing of an organizations alternate designators | |
| 254 | Yes | ORGANIZATION | CHCA_ORG_ALT_DESIGNATOR_TYPES | Organization Alternate Designator Types Code Table | |
| 255 | Yes | ORGANIZATION | CHCA_ORG_ASSOCIATION_REASONS | Organization Association Reasons Code Table | |
| 256 | Yes | ORGANIZATION | CHCA_ORG_NAMES | A listing of an Organizations names | |
| 257 | Yes | ORGANIZATION | CHCA_ORGANIZATION_ASSOCIATIONS | An organizations association to another organization | |
| 258 | No | INFORMATION-COMPLAINTS | CHCA_ORGANIZATION_COMPLAINTS | Association between an organization and an inforrmation complaint | |
| 259 | Yes | ORGANIZATION | CHCA_ORGANIZATION_NAME_USAGES | Organization Name Usage Types Code Table | |
| 260 | Yes | ORGANIZATION | CHCA_ORGANIZATION_TYPES | Organization Types Code Table | |
| 261 | Yes | ORGANIZATION | CHCA_ORGANIZATIONS | ADDRESS,NOTES | Listing of Organization records |
| 262 | No | ELIGIBILITY-DETERMINATION | CHCA_OUTCOME_OVERRIDE_REASONS | Eligibility Outcome Override Reasons Code Table | |
| 263 | No | CASE-EVENT-PERSON | CHCA_PARTICIPATION_TYPES | Participation Types Code Table | |
| 264 | Yes | PERSON | CHCA_PERS_ALT_DESIGNATOR_TYPES | Person Alternate Designator Types Code Table | |
| 266 | Yes | ORGANIZATION | CHCA_PERS_ORG_PERS_ROLE_TYPES | Person or Organization Role Types Code Table | |
| 267 | No | ONLINE-PORTAL | CHCA_PERS_ORG_PORTAL_AUTH | Online Portal Access Authorization | |
| 268 | Yes | PERSON | CHCA_PERS_STDNT_ATTENDANCE_CDS | Persons Student Attendance Type Code Table | |
| 269 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_PERSON_ACTIVITIES | A listing of a persons activities used for determining eligibility for child care | |
| 270 | Yes | PERSON | CHCA_PERSON_ALERT_TYPES | Person Alert Types Code Tables | |
| 271 | Yes | PERSON | CHCA_PERSON_ALERTS | A listing of a persons alerts | |
| 272 | Yes | PERSON | CHCA_PERSON_ALT_DESIGNATORS | A listing of a persons alternate designators | |
| 273 | Yes | CAREGIVER | CHCA_PERSON_CAREER_PATHS | Person Career Path Table | |
| 274 | Yes | CAREGIVER | CHCA_PERSON_CERTIFICATIONS | Person Certifications Table | |
| 275 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_PERSON_DEDUCTIONS | A listing of a persons income deductions | |
| 276 | Yes | PERSON | CHCA_PERSON_DOCUMENTS | Person Document Table | |
| 277 | Yes | CAREGIVER | CHCA_PERSON_IMMUNIZATIONS | A listing of a persons immunizations | |
| 278 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_PERSON_INCOMES | PERSON | A listing of a persons incomes |
| 279 | Yes | PERSON | CHCA_PERSON_LANGUAGES | Person Primary Languages | |
| 280 | Yes | PERSON | CHCA_PERSON_NAME_USAGES | Person Name Usage Types Code Table | |
| 281 | Yes | PERSON | CHCA_PERSON_NAMES | A listing of a persons names | |
| 282 | Yes | CAREGIVER | CHCA_PERSON_ORGANIZATIONS | ORGANIZATION | An association between a person and a provider or organization |
| 284 | Yes | PERSON | CHCA_PERSON_RACES | A listing of a persons race | |
| 286 | Yes | PERSON | CHCA_PERSON_SEX_CATEGORIES | Person Sex Category Code Table | |
| 287 | Yes | PERSON | CHCA_PERSON_SPECIAL_NEEDS | A listing of a person special needs | |
| 288 | Yes | CAREGIVER | CHCA_PERSON_TRAINING | Person Training Table | |
| 289 | Yes | PERSON | CHCA_PERSONS | ADDRESS,CAREGIVER,CASE-EVENT-PERSON,INCOME-ACTIVITY-DEDUCTION, NOTES, NOTIFICATION, ONLINE-APP, PROVIDER | A listing of Person records |
| 290 | Yes | PERSON | CHCA_PERSONS_MARITAL_STATUSES | BACKGROUND-INVESTIGATION | A listing of a persons marital statuses |
| 291 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_PGM_DEDUCTION_INCLU_RLS | Cross reference between an income deduction type and a program | |
| 292 | No | INCOME-ACTIVITY-DEDUCTION | CHCA_PGM_INCOME_INCLU_RLS | Cross reference between an income source type and a program | |
| 293 | No | CHCA_PHYS_EXAM_DT_VRF_TYPES | Physical Exam Date Verification Types Code Table | ||
| 294 | No | ONLINE-PORTAL | CHCA_PORTAL_PRIVILEGES | Staff Portal Privileges | |
| 295 | Yes | PERSON | CHCA_PRIM_LANG | Primary Language Code Table. | |
| 296 | Yes | PERSON | CHCA_PRIM_LANG_TYPES | Primary Language Code Type Table | |
| 297 | No | JOB-PROCESSES | CHCA_PROCESS_HISTORIES | A history of batch processes | |
| 298 | No | JOB-PROCESSES | CHCA_PROCESS_MESSAGES | Messages associated with a batch process | |
| 299 | No | JOB-PROCESSES | CHCA_PROCESS_STATISTICS | Job Statistics associated with a batch process | |
| 300 | No | JOB-PROCESSES | CHCA_PROCESS_TYPES | Batch Process Types Code Table | |
| 302 | No | CASE-EVENT | CHCA_PROGRAM_ELIGIBILITIES | Cross referecne between a case and the child care program eligiblity | |
| 303 | No | AUTHORIZATION | CHCA_PROGRAM_FUND_ACCOUNTS | Program and Fund Accounts Code Table | |
| 304 | No | PROVIDER-LICENSE | CHCA_PROGRAM_TYPES | Type of Program Code Table for the provider license | |
| 305 | No | ELIGIBILITY-DETERMINATION | CHCA_PROGRAMS | Child Care Programs Types Code Table | |
| 306 | Yes | CONTRACT | CHCA_PROV_CONTRACT_LIAISONS | Cross reference between a person and contract | |
| 307 | Yes | PROVIDER | CHCA_PROV_DISMISSAL_RSN_TYPES | Reason for Provider license to be closed code table | |
| 310 | No | PROVIDER-LICENSE | CHCA_PROV_LICENSE_APPROVALS | A history of a providers license approvals | |
| 311 | No | PROVIDER-LICENSE | CHCA_PROV_LICENSE_HISTORIES | A history of a providers license details | |
| 312 | No | PROVIDER-LICENSE | CHCA_PROV_LICENSE_STATUS_CODES | License Status Types Code Table | |
| 315 | Yes | INSPECTION | CHCA_PROVIDER_INSPECTIONS | NOTIFICATION,INFORMATION-COMPLAINTS | A listing of provider inspections |
| 316 | No | PROVIDER-LICENSE | CHCA_PROVIDER_LICENSE_STATUSES | A listing of a providers license statuses | |
| 317 | Yes | PROVIDER | CHCA_PROVIDER_OPERATIONS | A listing of a providers days and hour of operation | |
| 318 | No | PROVIDER-RATES | CHCA_PROVIDER_OVERLAPS | A listing of a providers overlap days and hours and number of children | |
| 320 | No | PROVIDER-RATES | CHCA_PROVIDER_SERVICES | A listing of a providers rates for a child care services and category | |
| 321 | Yes | PROVIDER | CHCA_PROVIDER_TYPE_HISTORIES | NOTIFICATION, ALERTS | A history of a providers license details |
| 322 | Yes | CAREGIVER | CHCA_PRSN_CARE_APPROV_CRITER | A listing of a persons caregiver approval criteria | |
| 323 | Yes | CAREGIVER | CHCA_PRSN_CARE_APPROV_HIST | Person Caregiver Approval History. | |
| 324 | No | STAR-QUALITY | CHCA_QLTY_LVL_INCTV_AMT | Quality Level Incentive Amount Code Table | |
| 325 | No | STAR-QUALITY | CHCA_QLTY_TRM_RDC_RSNS | STAR Quality Termination/Reduction Reasons Code Table | |
| 326 | No | STAR-QUALITY | CHCA_QUALITY_DENIAL_RSNS | STAR Quality Denial Reasons Code Table | |
| 327 | Yes | CONTRACT | CHCA_QUARTERLY_REPORTS | A listing of a contracts quarterly reports received no records since 2016 | |
| 329 | Yes | PERSON | CHCA_RACES | Person Race Type Code Table | |
| 330 | No | PROVIDER-RATES | CHCA_RATE_AMOUNTS | A listing of a providers rates based on the rate type and service type | |
| 331 | No | AUTHORIZATION | CHCA_RATE_OVERRIDE_REASONS | Provider Rate Override Reasons Code Table | |
| 332 | No | PROVIDER-RATES | CHCA_RATE_TYPES | Provider Rate Type Code Table | |
| 333 | Yes | INVOICE | CHCA_RECOVERY_METHOD_TYPES | Recovery Method Types Code Table | |
| 334 | Yes | INVOICE | CHCA_RECOVERY_WAIVER_REASONS | Recovery Waiver Reason Code Table | |
| 335 | No | TARGET-MAILER | CHCA_RECP_GRPT_XREF | Cross reference between the target mailer group and recipient | |
| 336 | No | TARGET-MAILER | CHCA_RECP_TYPE | Target Mailer Recipient Type Code Table | |
| 337 | No | REPORTING | CHCA_REPORT_FREQUENCY | Report Frequency Code Table | |
| 338 | No | REPORTING | CHCA_REPORT_IMAGES | A history of report images | |
| 339 | No | REPORTING | CHCA_REPORTS | A listing of Reports | |
| 343 | Yes | PERSON | CHCA_RESIDENCY_VRF_TYPES | Residency Verification Types Code Table | |
| 347 | No | TARGET-MAILER | CHCA_RGN_LIC_SERV_AREAS | Cross reference between the regions and licensing service areas | |
| 348 | No | REPORTING | CHCA_RPT_WRKR_TYPE_ASSOCS | Cross reference between the report and the worker type | |
| 349 | Yes | INSPECTION | CHCA_SANS_INSP_ITEMS | A history of Sanswrite inspection items for a provider | |
| 350 | No | CASE-EVENT-PERSON | CHCA_SCHOOL_ENROLLMENT_TYPES | School Enrollment Types Code Table | |
| 351 | No | REPORTING | CHCA_SERVICE_PAYMENT_CHILDREN | A listing of a childs service payments for reporting | |
| 353 | Yes | PERSON | CHCA_SPECIAL_NEED_TYPES | Special Need Type Code Table | |
| 354 | Yes | PERSON | CHCA_SPECIAL_NEED_VRF_TYPES | Special Need Vertification Type Code Table | |
| 358 | Yes | PERSON | CHCA_SSN_VERIFICATION_TYPES | SSN Verification Types Code Table | |
| 360 | No | ADDRESS | CHCA_STATES | State Code Table | |
| 361 | No | PROVIDER-RATES | CHCA_STT_CARE_PROV_MAX_RATES | Effective date cross reference between provider type and rate category | |
| 362 | Yes | WORKER | CHCA_SUPERVISORS | A history of a supervisor relationship between workers | |
| 363 | Yes | INVOICE | CHCA_SUPPLEMENTAL_PAYMT_TYPES | Supplemental Payment Types Code Table | |
| 365 | Yes | INSPECTION | CHCA_SURVEY_TYPE_CODES | Provider Inspections Survey Types Code Table | |
| 366 | No | GENERAL-SYSTEM-INFO | CHCA_SYSTEM_VALUES | System Values Code Table | |
| 367 | No | CASE-EVENT | CHCA_TANF_TYPES | TANF Status Types Code Table | |
| 376 | Yes | INVOICE | CHCA_TIME_INCREMENTS | Subsidy Rate Time Increments. | |
| 377 | Yes | CAREGIVER | CHCA_TRAINING_CERT_TYPES | Training Certification Code Type Table | |
| 378 | Yes | CAREGIVER | CHCA_TRAINING_COURSE_TYPES | Training Course Code Type Table | |
| 379 | Yes | CAREGIVER | CHCA_TRAINING_QUAL_TYPES | Training Qualification Code Type Table | |
| 380 | Yes | CAREGIVER | CHCA_TRAINING_SOURCE_TYPES | The Training Source Type code table | |
| 381 | Yes | PERSON | CHCA_TRIBAL_AFFILIATIONS | Listing of a persons tribal affiliations | |
| 382 | Yes | PERSON | CHCA_TRIBAL_CODES | Tribal Codes Code Table | |
| 383 | No | CASE-EVENT-PERSON | CHCA_WAITLIST_ASSOCIATIONS | Watilist association between a person on a case and the program | |
| 384 | No | CASE-EVENT-PERSON | CHCA_WAITLIST_STATUS_TYPES | Watilist Status Types Code Table | |
| 385 | No | CASE-EVENT-PERSON | CHCA_WAITLIST_STATUSES | History of the waitlist statuses for a person | |
| 387 | No | FINANCIAL | CHCA_WARRANT_STATUS_HISTORIES | History of the statuses of a warrant | |
| 388 | No | FINANCIAL | CHCA_WARRANT_STATUSES | Warrant Status Types Code Table | |
| 390 | No | FINANCIAL | CHCA_WARRANTS | Listing of warrants associated with a process history | |
| 391 | No | AUTHORIZATION | CHCA_WEEKDAYS | Weekday Code Table | |
| 394 | No | ALERTS | CHCA_WORKER_ALERTS | WORKER | Listing of a workers alerts |
| 395 | Yes | WORKER | CHCA_WORKER_ALTER_DESIGNATORS | Deprecated. No data since 2007 | |
| 396 | Yes | WORKER | CHCA_WORKER_COUNTIES | Association between a worker and a county | |
| 397 | Yes | WORKER | CHCA_WORKER_ORGANIZATIONS | Association between a worker and an organization | |
| 398 | Yes | WORKER | CHCA_WORKER_REGIONS | Association between a worker and a region | |
| 399 | Yes | WORKER | CHCA_WORKER_ROLE_TYPES | Worker Role Types Code Tables | |
| 400 | Yes | WORKER | CHCA_WORKER_ROLES | Listing of the roles of a worker | |
| 401 | Yes | WORKER | CHCA_WORKER_SERVICE_AREAS | TARGET-MAILER | Association between a worker and service areas |
| 402 | Yes | WORKER | CHCA_WORKERS | ADDRESS,AUTHORIZATION,INFORMATION-COMPLAINTS, NOTES,NOTIFICATION,TARGET-MAILER | CCUBS Workers |
| 403 | No | CHCA_ZIP_CODE_DATA | Deprecated. No data since 2003 | ||
| 404 | No | ADDRESS | CHCA_ZIP_CODES | Zip Codes Code Table |
File details come from the government source that posted it. Updated .