Document
Crosswalk - All Data Elements
ICR 202610-0938-013 · OMB 0938-1148 · Object 174253800.
Document Viewer [xlsx]
Document Metadata
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
|---|---|
| File Title | Crosswalk - All Data Elements |
| Author | Brynn Hagen |
| Last Modified By | Calc |
| File Modified | 2026-05-13 |
| File Created | 2026-10-28 |
| Conversion State | complete |
Extracted Text
Indicator # 1 2 3 5 5a 5b 5c 5d 5e 5f 5g 5h 5i 5j 5k 5l 5m 5n 6 6a 6e 6f 6g 6h 6j 6k 7 7a 7b 7c 7d 7e 8 8a 8b 8c 8d 8e 8f 8g 8h 9 9a 9b 9c 9d 9e 9f 9g 9h 9i 9j 9k 9l 9m 9n 9o 9p 10 10a 10b 10c 10d 10e 10f 10g 10h 10i 10j 10k 10l 10m 10n 10o 11 11a 11b 11c 11d 12 12a 12b 12c 12d 12e 12f 12g 12h 12i 12j 12k 12l 12m 12n 12o 12p 12q 12r 12s 12t 12u 12v Indicator Total Call Center Volume Call Center #1 Volume Call Center #2 Volume Call Center #3 Volume Call Center #4 Volume Call Center #5 Volume Call Center #6 Volume Call Center #7 Volume Call Center #8 Volume Call Center #9 Volume Call Center #10 Volume Average Call Center Wait Time Call Center #1 Wait Time Call Center #2 Wait Time Call Center #3 Wait Time Call Center #4 Wait Time Call Center #5 Wait Time Call Center #6 Wait Time Call Center #7 Wait Time Call Center #8 Wait Time Call Center #9 Wait Time Call Center #10 Wait Time Average Call Center Abandonment Rate Call Center #1 Abandonment Rate Call Center #2 Abandonment Rate Call Center #3 Abandonment Rate Call Center #4 Abandonment Rate Call Center #5 Abandonment Rate Call Center #6 Abandonment Rate Call Center #7 Abandonment Rate Call Center #8 Abandonment Rate Call Center #9 Abandonment Rate Call Center #10 Abandonment Rate Number of Applications Received Total Applications Received Applications Received by Medicaid Agency Applications Received by Medicaid Agency, by Channel Online Applications Received by Medicaid Agency Mail Applications Received by Medicaid Agency In-Person Applications Received by Medicaid Agency Phone Applications Received by Medicaid Agency Other Applications Received by Medicaid Agency Applications Received by CHIP Agency Applications Received by CHIP Agency, by Channel Online Applications Received by CHIP Agency Mail Applications Received by CHIP Agency In-Person Applications Received by CHIP Agency Phone Applications Received by CHIP Agency Other Applications Received by CHIP Agency Applications Received by SBM Number of Electronic Accounts Transferred Total Transfer Accounts Received From the FFM By Transfer Type Determined Account Transfers Received Assessed Account Transfers Received Request for Full Determination Transfers Received Transfers of Unknown Type Received Total Transfer Accounts Sent to the FFM Transfers to Non-Integrated SBM Systems Number of Renewals Number of Renewals up for Annual Redetermination By Determination Type Medicaid MAGI Renewals Medicaid Non-MAGI Renewals CHIP Renewals Renewals of Unknown Type Total Enrollment Total Medicaid Enrollees Medicaid MAGI enrollment Total MAGI Enrollees MAGI Child Enrollees MAGI Adult Enrollees Medicaid Non-MAGI enrollment Total Non-MAGI Enrollees Non-MAGI Child Enrollees Non-MAGI Adult Enrollees Total CHIP Enrollees Total Number of Individuals Determined Eligible Total Medicaid Eligible By Determination Type Medicaid MAGI Eligibility Determinations Medicaid Non-MAGI Eligibility Determinations By Reason for Determination Medicaid Eligibility Determined at Application Medicaid Eligibility at Application under MAGI Rules Medicaid Eligibility at Application under Non-MAGI Rules Medicaid Eligibility Determined at Annual Renewal Medicaid Eligible via Administrative Determination Medicaid Eligible via Other Method Total CHIP Eligible By Reason for Determination Determined CHIP Eligible at Application Determined CHIP Eligible at Annual Renewal All Others Determined CHIP Eligible By Community Engagement at Application Number of individuals determined eligible who are determined to be a specified excluded individual Number of individuals determined eligible who are applicable individuals and either demonstrated community Number of individuals determined eligible who are applicable individuals and were deemed to have demonstrated Total Number of Individuals Determined Ineligible Total Medicaid Ineligible By Determination Reason Medicaid Determination - Ineligibility Established Medicaid Determination - Eligibility Cannot be Established By Type of Determination Medicaid Determination - Ineligible at Application Medicaid Determination - Ineligible at Annual Renewal Medicaid Determination - Ineligible via Other Application Type Total CHIP Ineligible By Determination Reason CHIP Determination - Ineligibility Established CHIP Determination - Eligibility Cannot be Established By Type of Determination CHIP Determination - Ineligible at Application CHIP Determination - Ineligible at Annual Renewal CHIP Determination - Ineligible via Other Application Type By Community Engagement at Application Number of individuals determined ineligible due to not meeting the community engagement requirement Number of individuals determined ineligible for procedural reasons Number of individuals determined ineligible for all other reasons Number of Pending Applications or Redeterminations Pending at Medicaid Agency Number Pending at Medicaid Pending at Medicaid Agency Type Pending at Separate CHIP Agency Number Pending at Separate CHIP Agency Pending at Separate CHIP Agency Type Processing Time for Determinations Median Processing Time – All Medicaid Determinations Type of Medicaid Determination Median Processing Time – MAGI Determinations Median Processing Time – Non-MAGI Determinations Source of Medicaid Application Median Processing Time – Direct Application Median Processing Time – Transfer Application from FFM Number of Medicaid MAGI Applications, by Processing Time Less than 24 Hours 24 Hours – 7 Days 8 Days – 30 Days 31 Days – 45 Days More than 45 Days Number of Medicaid Non-MAGI Applications, by Processing Time Less than 30 Days 31 – 60 Days 61 – 90 Days More than 90 days Source of CHIP Application Median Processing Time – Separate CHIP Agency Median Processing Time – Direct Application Median Processing Time – Transfer Application from FFM Number of CHIP Applications, by Processing Time Less than 24 Hours 24 Hours – 7 Days 8 Days – 30 Days 31 Days – 45 Days More than 45 Days DKAN data element CALL_CNTR_TOT_VOL_CNT CALL_CNTR_1_VOL_CNT CALL_CNTR_2_VOL_CNT CALL_CNTR_3_VOL_CNT CALL_CNTR_4_VOL_CNT CALL_CNTR_5_VOL_CNT CALL_CNTR_6_VOL_CNT CALL_CNTR_7_VOL_CNT CALL_CNTR_8_VOL_CNT CALL_CNTR_9_VOL_CNT CALL_CNTR_10_VOL_CNT Call center volume text CALL_CNTR_AVG_WAIT_TIME CALL_CNTR_1_AVG_WAIT_TIME CALL_CNTR_2_AVG_WAIT_TIME CALL_CNTR_3_AVG_WAIT_TIME CALL_CNTR_4_AVG_WAIT_TIME CALL_CNTR_5_AVG_WAIT_TIME CALL_CNTR_6_AVG_WAIT_TIME CALL_CNTR_7_AVG_WAIT_TIME CALL_CNTR_8_AVG_WAIT_TIME CALL_CNTR_9_AVG_WAIT_TIME CALL_CNTR_10_AVG_WAIT_TIME call wait time text CALL_CNTR_AVG_ABANDON_RATE CALL_CNTR_1_AVG_ABANDON_RATE CALL_CNTR_2_AVG_ABANDON_RATE CALL_CNTR_3_AVG_ABANDON_RATE CALL_CNTR_4_AVG_ABANDON_RATE CALL_CNTR_5_AVG_ABANDON_RATE CALL_CNTR_6_AVG_ABANDON_RATE CALL_CNTR_7_AVG_ABANDON_RATE CALL_CNTR_8_AVG_ABANDON_RATE CALL_CNTR_9_AVG_ABANDON_RATE CALL_CNTR_10_AVG_ABANDON_RATE call abandonment rate text APLCTN_TOT_CNT APLCTN_MDCD_CNT APLCTN_MDCD_ONLN_CNT APLCTN_MDCD_MAIL_CNT APLCTN_MDCD_IN_PRSN_CNT APLCTN_MDCD_PHNE_CNT APLCTN_MDCD_OTHR_CNT APLCTN_CHIP_CNT APLCTN_CHIP_ONLN_CNT APLCTN_CHIP_MAIL_CNT APLCTN_CHIP_IN_PRSN_CNT APLCTN_CHIP_PHNE_CNT APLCTN_CHIP_OTHR_CNT APLCTN_IES_CNT Applicatin Text TRNSFR_TOT_RCVD_CNT TRNSFR_DTRMNTN_RCVD_CNT TRNSFR_ASMT_RCVD_CNT TRNSFR_FULL_DTRMNTN_RCVD_CNT TRNSFR_UNK_TYPE_RCVD_CNT TRNSFR_FFM_SENT_CNT TRNSFR_SBM_SENT_CNT Account transfers text RNWL_TOT_CNT RNWL_MAGI_TOT_CNT RNWL_NONMAGI_TOT_CNT RNWL_CHIP_TOT_CNT RNWL_UNK_TYPE_TOT_CNT Renewal Text ENRLMT_MDCD_TOT_CNT ENRLMT_MAGI_TOT_CNT ENRLMT_MAGI_CHLD_CNT ENRLMT_MAGI_ADLT_CNT ENRLMT_NONMAGI_TOT_CNT ENRLMT_NONMAGI_CHLD_CNT ENRLMT_NONMAGI_ADLT_CNT Enrollment Text ENRLMT_CHIP_TOT_CNT ELGBL_MDCD_TOT_CNT ELGBL_MDCD_DTRMNTN_MAGI_CNT ELGBL_MDCD_DTRMNTN_NONMAGI_CNT ELGBL_MDCD_APLCTN_CNT ELGBL_MDCD_APLCTN_MAGI_CNT ELGBL_MDCD_APLCTN_NONMAGI_CNT ELGBL_MDCD_RNWL_CNT ELGBL_MDCD_ADMIN_CNT ELGBL_MDCD_OTHR_CNT ELGBL_CHIP_TOT_CNT ELGBL_CHIP_APLCTN_CNT ELGBL_CHIP_RNWL_CNT ELGBL_CHIP_OTHR_CNT ELGBL_MDCD_APLCTN_SXI_CNT ELGBL_MDCD_APLCTN_ACT_MNDT_EX_CNT ELGBL_MDCD_APLCTN_STHS_EX _CNT Eligibility Determination TEXT INELGBL_MDCD_TOT_CNT INELGBL_MDCD_DTRMNTN_ESTB_CNT INELGBL_MDCD_DTRMNTN_DCMTN_CNT INELGBL_MDCD_APLCTN_CNT INELGBL_MDCD_RNWL_CNT INELGBL_MDCD_OTHR_CNT INELGBL_CHIP_TOT_CNT INELGBL_CHIP_DTRMNTN_ESTB_CNT INELGBL_CHIP_DTRMNTN_DCMTN_CNT INELGBL_CHIP_APLCTN_CNT INELGBL_CHIP_RNWL_CNT INELGBL_CHIP_OTHR_CNT INELGBL_MDCD_APLCTN_FLRMT_CE_CNT INELGBL_MDCD_APLCTN_PRCDRL_RSN_CNT INELGBL_MDCD_APLCTN_OTH_RSN_CNT Ineligibility Text PENDG_MDCD_CNT PENDG_MDCD_TYPE_IND PENDG_CHIP_CNT PENDG_CHIP_TYPE_IND Pending Text PROC_MDCD_ALL_MDN_DAY_NUM PROC_MDCD_MAGI_MDN_DAY_NUM PROC_MDCD_NONMAGI_MDN_DAY_NUM PROC_MDCD_DRCT_MDN_DAY_NUM PROC_MDCD_SBM_FFM_MDN_DAY_NUM PROC_MDCD_MAGI_CAT_1_CNT PROC_MDCD_MAGI_CAT_2_CNT PROC_MDCD_MAGI_CAT_3_CNT PROC_MDCD_MAGI_CAT_4_CNT PROC_MDCD_MAGI_CAT_5_CNT PROC_MDCD_NONMAGI_CAT_1_CNT PROC_MDCD_NONMAGI_CAT_2_CNT PROC_MDCD_NONMAGI_CAT_3_CNT PROC_MDCD_NONMAGI_CAT_4_CNT PROC_CHIP_ALL_MDN_DAY_NUM PROC_CHIP_DRCT_MDN_DAY_NUM PROC_CHIP_SBM_FFM_MDN_DAY_NUM PROC_CHIP_MAGI_CAT_1_CNT PROC_CHIP_MAGI_CAT_2_CNT PROC_CHIP_MAGI_CAT_3_CNT PROC_CHIP_MAGI_CAT_4_CNT PROC_CHIP_MAGI_CAT_5_CNT Processing Time Text USR_HTTP_LOG Preliminary_Updated Final Report (Y/N) Description Master Record ID Creation Timestamp Creator Name State Code State Approval Timestamp (Nonoperational) State Approver Name Reporting Period Start Date Reporting Period End Date Summary Data Limitations Update Timestamp Updater name Call Center #1 Description Call Center #2 Description Call Center #3 Description Call Center #4 Description Call Center #5 Description Call Center #6 Description Call Center #7 Description Call Center #8 Description Call Center #9 Description Call Center #10 Description Call Center Data Limitation Call Center Volume Data Limitation Call Center Wait Time Data Limitation Call Center Abandonment Rate Data Limitation Applications Data Limitation Transfers Data Limitation Renewals Data Limitation Enrollment Data Limitation Eligibility Data Limitation Ineligibility Data Limitation Pending Applications/Redeterminations Data Limitation Processing Time Data Limitation Logged user HTTP Final Report Indicator (Y/N) DKAN Data Element MSTR_REC_ID CREATN_TS CREATR_NAME STATE_CD STATE_APRVL_TS STATE_APRVR_NAME RPTG_PRD_STRT_DT RPTG_PRD_END_DT SMRY_DL_TXT UPDT_TS UPDTR_NAME CALL_CNTR_1_DESC CALL_CNTR_2_DESC CALL_CNTR_3_DESC CALL_CNTR_4_DESC CALL_CNTR_5_DESC CALL_CNTR_6_DESC CALL_CNTR_7_DESC CALL_CNTR_8_DESC CALL_CNTR_9_DESC CALL_CNTR_10_DESC CALL_CNTR_DL_TXT CALL_CNTR_VOL_DL_TXT CALL_CNTR_WAIT_TIME_DL_TXT CALL_CNTR_ABNDNMNT_RATE_DL_TXT APLCTN_DL_TXT TRNSFR_DL_TXT RNWL_DL_TXT ENRLMNT_DL_TXT ELGBL_DL_TXT INELGBL_DL_TXT PENDG_DL_TXT PROC_TIME_DL_TXT USR_HTTP_LOG Final_report Column A B C D E F G H I Z AA AB AC AD AE AF AG AH AI AJ AK AL AW BH BS CG CN CS CZ DL DW DZ EU EV EX