EDWS

EDW_WAREHOUSE Schema
FACT_CSAP_STUDENT Table
NOTE: Color denotes DIM table relationships

DIM_DISABLING_CONDITION11
DIM_504_PLAN11 DIM_ACCOMMODATION11 DIM_BILINGUAL11
PK DDIS_KEY DIM_CSAP_PROFICIENCY11 DIM_CSAP_SUBJECT11
PK D504_KEY PK DACM_KEY PK DBLN_KEY DIM_GRADE11
DDIS_SORT_KEY
DDIS_CODE D504_SORT_KEY DACM_SORT_KEY DBLN_SORT_KEY PK DCPF_KEY PK DCSB_KEY PK DGRD_KEY
DDIS_TEXT D504_CODE DACM_CODE DBLN_CODE
DDIS_CREATE_BATCH_NUM D504_TEXT DACM_TEXT DBLN_TEXT DCPF_SORT_KEY DCSB_SORT_KEY DGRD_SORT_KEY
DDIS_UPDATE_BATCH_NUM D504_CREATE_BATCH_NUM DACM_CREATE_BATCH_NUM DBLN_CREATE_BATCH_NUM DCPF_CODE DCSB_CODE DGRD_CODE
DDIS_MAPPING_BATCH_NUM D504_UPDATE_BATCH_NUM DACM_UPDATE_BATCH_NUM DBLN_UPDATE_BATCH_NUM DCPF_TEXT DCSB_TEXT DGRD_TEXT
DDIS_EFF_DATE_START D504_MAPPING_BATCH_NUM DACM_MAPPING_BATCH_NUM DBLN_MAPPING_BATCH_NUM DCPF_CREATE_BATCH_NUM DCSB_CALC_READING_YN DGRD_COMPARISON_ORDER
DDIS_EFF_DATE_END D504_EFF_DATE_START DACM_EFF_DATE_START DBLN_EFF_DATE_START DCPF_UPDATE_BATCH_NUM DCSB_CALC_WRITING_YN DGRD_CREATE_BATCH_NUM
DDIS_STATE_CODE D504_EFF_DATE_END DACM_EFF_DATE_END DBLN_EFF_DATE_END DCPF_MAPPING_BATCH_NUM DCSB_CALC_MATH_YN DGRD_UPDATE_BATCH_NUM
DCPF_EFF_DATE_START DCSB_CALC_SCIENCE_YN DGRD_MAPPING_BATCH_NUM
DCPF_EFF_DATE_END DCSB_CREATE_BATCH_NUM DGRD_EFF_DATE_START
DCSB_UPDATE_BATCH_NUM DGRD_EFF_DATE_END
DCSB_MAPPING_BATCH_NUM
DCSB_EFF_DATE_START
DCSB_EFF_DATE_END

DIM_GRANT_PROJECT_FUNDING11
DIM_DID_NOT_TEST11
PK DGPF_KEY
PK DDNT_KEY
DGPF_SORT_KEY
DDNT_SORT_KEY DGPF_CODE
DDNT_CODE DGPF_TEXT
DDNT_TEXT DGPF_CREATE_BATCH_NUM
DDNT_GRADE_CALC_EXEMPT_CODE DGPF_UPDATE_BATCH_NUM
DDNT_CREATE_BATCH_NUM DGPF_MAPPING_BATCH_NUM
DDNT_UPDATE_BATCH_NUM DGPF_EFF_DATE_START
DDNT_MAPPING_BATCH_NUM DGPF_EFF_DATE_END
DDNT_EFF_DATE_START
DDNT_EFF_DATE_END
DDNT_CSAP_CODE
DDNT_ACT_CODE
DDNT_CSAPA_CODE
DDNT_CELA_CODE
DIM_HOMELESS11

PK DHLS_KEY

DHLS_SORT_KEY
FACT_CSAP_STUDENT11 DHLS_CODE
DHLS_TEXT
DHLS_CREATE_BATCH_NUM
DHLS_UPDATE_BATCH_NUM
DHLS_MAPPING_BATCH_NUM
FCSD_KEY DHLS_EFF_DATE_START
DIM_DISTRICT11 FCSD_ACADEMIC_YEAR DHLS_EFF_DATE_END
FCSD_DASY_KEY
PK DDST_KEY FCSD_DIST_NUM
FCSD_DDST_KEY
DDST_SORT_KEY FCSD_DSCH_SCHOOL_NUMBER DIM_IEP11
DDST_DIST_NUMBER FCSD_DSCH_KEY
DDST_NAME
FCSD_DCSB_CODE PK DIEP_KEY
DDST_COUNTY
DDST_CONGRESSIONAL_DIST FCSD_DCSB_KEY
DDST_SETTING FCSD_DGRD_CODE DIEP_SORT_KEY
DDST_SQUARE_MILES FCSD_DGRD_KEY DIEP_CODE
DDST_ADDRESS DIEP_TEXT
FCSD_DGND_CODE
DDST_CITY DIEP_CSAP_EXEMPT_YN
FCSD_DGND_KEY DIEP_CREATE_BATCH_NUM
DDST_STATE
DDST_ZIP_CODE_5 FCSD_DCPF_CODE DIEP_UPDATE_BATCH_NUM
DDST_ZIP_PLUS_4 FCSD_DCPF_KEY DIEP_MAPPING_BATCH_NUM
DDST_PHONE_NUMBER FCSD_DETH_CODE DIEP_EFF_DATE_START
DDST_FAX_NUMBER DIEP_EFF_DATE_END
FCSD_DETH_KEY
DDST_WEB_SITE
FCSD_DDNT_CODE
DDST_OPEN_YN
DDST_CREATE_BATCH_NUM FCSD_DDNT_KEY
DDST_UPDATE_BATCH_NUM FCSD_D504_CODE
DDST_MAPPING_BATCH_NUM FCSD_D504_KEY
DDST_EFF_DATE_START FCSD_DIEP_CODE
DDST_EFF_DATE_END
FCSD_DIEP_KEY
DDST_REGION DIM_LANGUAGE_BACKGROUND11
DDST_SIZE FCSD_DDIS_CODE
DDST_ORGANIZATION_UNIT_TYPE FCSD_DDIS_KEY
PK DLNG_KEY
DDST_ADMIN_TYPE_CODE FCSD_DLNG_CODE
DDST_DORG_KEY FCSD_DLNG_KEY DLNG_SORT_KEY
DDST_DREG_KEY
FCSD_DTID_CODE DLNG_CODE
DDST_DATE_CLOSED
FCSD_DTID_KEY DLNG_TEXT
FCSD_DTIS_CODE DLNG_CSAP_EXEMPT_YN
DLNG_LANGUAGE_CODE
FCSD_DTIS_KEY DLNG_LANGUAGE_TEXT
FCSD_DTTL_CODE DLNG_REPORTING_LANGUAGE_TEXT
FCSD_DTTL_KEY DLNG_ENGLISH_PROFICIENCY_CODE
FCSD_DMGS_CODE DLNG_ENGLISH_PROFICIENCY_TEXT
FCSD_DMGS_KEY DLNG_IN_CO_3_OR_MORE_YRS_YN
DLNG_TIME_IN_COLORADO_TEXT
FCSD_DBLN_CODE DLNG_CREATE_BATCH_NUM
FCSD_DBLN_KEY DLNG_UPDATE_BATCH_NUM
FCSD_DESL_CODE DLNG_MAPPING_BATCH_NUM
FCSD_DESL_KEY DLNG_EFF_DATE_START
FCSD_DFRM_CODE DLNG_EFF_DATE_END
FCSD_DFRM_KEY
FCSD_DHLS_CODE
FCSD_DHLS_KEY
FCSD_DGFT_CODE
FCSD_DGFT_KEY
FCSD_DGCL_KEY
FCSD_DACM_KEY
FCSD_DEMH_CODE
FCSD_DEMH_KEY
FCSD_DGCE_CODE
FCSD_DGCE_KEY
FCSD_EXPELLED_YN
FCSD_CONTINUOUSLY_IN_STATE
FCSD_CONTINUOUSLY_IN_COUNTRY
DIM_ESL11 FCSD_CONTINUOUSLY_IN_ELL
FCSD_LANGUAGE_BACKGROUND
PK DESL_KEY FCSD_LANGUAGE_PROFICIENCY
FCSD_TEST_LANGUAGE
DESL_SORT_KEY FCSD_OCT_NEW_SCHOOL
DESL_CODE
FCSD_SASID
DESL_TEXT
DESL_CREATE_BATCH_NUM FCSD_LAST_NAME
DESL_UPDATE_BATCH_NUM FCSD_FIRST_NAME
DESL_MAPPING_BATCH_NUM FCSD_MIDDLE_NAME
DESL_EFF_DATE_START FCSD_TTL_SCALE_SCORE
DESL_EFF_DATE_END
FCSD_TTL_NUM_POINTS
FCSD_TTL_PCT_POINTS
FCSD_CONTENT_1_SCALE_SCORE
DIM_ETHNICITY11 FCSD_CONTENT_1_NUM_POINTS
FCSD_CONTENT_1_PCT_POINTS
PK DETH_KEY FCSD_DCCP_1_CODE
FCSD_DCCP_1_KEY
DETH_SORT_KEY
DETH_CODE FCSD_DCSN_1_KEY
DETH_TEXT FCSD_CONTENT_2_SCALE_SCORE
DETH_CREATE_BATCH_NUM FCSD_CONTENT_2_NUM_POINTS
DETH_UPDATE_BATCH_NUM FCSD_CONTENT_2_PCT_POINTS
DETH_MAPPING_BATCH_NUM
FCSD_DCCP_2_CODE
DETH_EFF_DATE_START
DETH_EFF_DATE_END FCSD_DCCP_2_KEY
FCSD_DCSN_2_KEY
FCSD_CONTENT_3_SCALE_SCORE
FCSD_CONTENT_3_NUM_POINTS
FCSD_CONTENT_3_PCT_POINTS DIM_MIGRANT_STATUS11
FCSD_DCCP_3_CODE
FCSD_DCCP_3_KEY PK DMGS_KEY
FCSD_DCSN_3_KEY
DMGS_SORT_KEY
FCSD_CONTENT_4_SCALE_SCORE DMGS_CODE
FCSD_CONTENT_4_NUM_POINTS DMGS_TEXT
FCSD_CONTENT_4_PCT_POINTS DMGS_MIGRANT_YN
FCSD_DCCP_4_CODE DMGS_IMMIGRANT_YN
DMGS_CREATE_BATCH_NUM
FCSD_DCCP_4_KEY
DMGS_UPDATE_BATCH_NUM
FCSD_DCSN_4_KEY DMGS_MAPPING_BATCH_NUM
FCSD_CONTENT_5_SCALE_SCORE DMGS_EFF_DATE_START
FCSD_CONTENT_5_NUM_POINTS DMGS_EFF_DATE_END
FCSD_CONTENT_5_PCT_POINTS
FCSD_DCCP_5_CODE
FCSD_DCCP_5_KEY
FCSD_DCSN_5_KEY
FCSD_CONTENT_6_SCALE_SCORE
FCSD_CONTENT_6_NUM_POINTS
FCSD_CONTENT_6_PCT_POINTS
FCSD_DCCP_6_CODE
FCSD_DCCP_6_KEY
FCSD_DCSN_6_KEY
FCSD_SUB_CONTENT_1_SCALE_SCORE
FCSD_SUB_CONTENT_1_NUM_POINTS
FCSD_SUB_CONTENT_1_PCT_POINTS
FCSD_SUB_CONTENT_1_PERF_LEVEL
FCSD_SUB_DCCP_1_CODE
FCSD_SUB_DCCP_1_KEY
FCSD_DSAN_1_KEY
FCSD_SUB_CONTENT_2_SCALE_SCORE
FCSD_SUB_CONTENT_2_NUM_POINTS
FCSD_SUB_CONTENT_2_PCT_POINTS
FCSD_SUB_CONTENT_2_PERF_LEVEL
FCSD_SUB_DCCP_2_CODE
FCSD_SUB_DCCP_2_KEY
FCSD_DSAN_2_KEY
FCSD_SUB_CONTENT_3_SCALE_SCORE
FCSD_SUB_CONTENT_3_NUM_POINTS
FCSD_SUB_CONTENT_3_PCT_POINTS
FCSD_SUB_CONTENT_3_PERF_LEVEL
DIM_FARM11
FCSD_SUB_DCCP_3_CODE
FCSD_SUB_DCCP_3_KEY
PK DFRM_KEY FCSD_DSAN_3_KEY
FCSD_SUB_CONTENT_4_SCALE_SCORE
DFRM_SORT_KEY FCSD_SUB_CONTENT_4_NUM_POINTS
DFRM_CODE FCSD_SUB_CONTENT_4_PCT_POINTS
DFRM_TEXT
FCSD_SUB_CONTENT_4_PERF_LEVEL
DFRM_CREATE_BATCH_NUM
DFRM_UPDATE_BATCH_NUM FCSD_SUB_DCCP_4_CODE
DFRM_MAPPING_BATCH_NUM FCSD_SUB_DCCP_4_KEY
DFRM_EFF_DATE_START FCSD_DSAN_4_KEY
DFRM_EFF_DATE_END FCSD_SUB_CONTENT_5_SCALE_SCORE
FCSD_SUB_CONTENT_5_NUM_POINTS
FCSD_SUB_CONTENT_5_PCT_POINTS
FCSD_SUB_CONTENT_5_PERF_LEVEL
FCSD_SUB_DCCP_5_CODE
FCSD_SUB_DCCP_5_KEY
FCSD_DSAN_5_KEY
FCSD_SUB_CONTENT_6_SCALE_SCORE
FCSD_SUB_CONTENT_6_NUM_POINTS
FCSD_SUB_CONTENT_6_PCT_POINTS
FCSD_SUB_CONTENT_6_PERF_LEVEL
FCSD_SUB_DCCP_6_CODE
DIM_GENDER11
FCSD_SUB_DCCP_6_KEY
FCSD_DSAN_6_KEY
PK DGND_KEY
FCSD_PERCENTILE
DGND_SORT_KEY FCSD_GAIN_LOSS_STABLE
DGND_CODE FCSD_CONTENT_7_SCALE_SCORE
DGND_TEXT FCSD_CONTENT_7_NUM_POINTS
DGND_CREATE_BATCH_NUM
FCSD_CONTENT_7_PCT_POINTS
DGND_UPDATE_BATCH_NUM
DGND_MAPPING_BATCH_NUM FCSD_DCCP_7_CODE
DGND_EFF_DATE_START FCSD_DCCP_7_KEY
DGND_EFF_DATE_END FCSD_DCSN_7_KEY
FCSD_CONTENT_8_SCALE_SCORE
FCSD_CONTENT_8_NUM_POINTS
FCSD_CONTENT_8_PCT_POINTS
FCSD_DCCP_8_CODE
FCSD_DCCP_8_KEY
FCSD_DCSN_8_KEY
FCSD_CONTENT_9_SCALE_SCORE
FCSD_CONTENT_9_NUM_POINTS
FCSD_CONTENT_9_PCT_POINTS
FCSD_DCCP_9_CODE
FCSD_DCCP_9_KEY
FCSD_DCSN_9_KEY
FCSD_CONTENT_0_SCALE_SCORE
DIM_GIFTED_TALENTED11
FCSD_CONTENT_0_NUM_POINTS
FCSD_CONTENT_0_PCT_POINTS
PK DGFT_KEY FCSD_DCCP_0_CODE
FCSD_DCCP_0_KEY
DGFT_SORT_KEY FCSD_DCSN_0_KEY
DGFT_CODE FCSD_SUB_CONTENT_7_SCALE_SCORE
DGFT_TEXT FCSD_SUB_CONTENT_7_NUM_POINTS
DGFT_CREATE_BATCH_NUM
DGFT_UPDATE_BATCH_NUM FCSD_SUB_CONTENT_7_PCT_POINTS
DGFT_MAPPING_BATCH_NUM FCSD_SUB_CONTENT_7_PERF_LEVEL
DGFT_EFF_DATE_START FCSD_SUB_DCCP_7_CODE
DGFT_EFF_DATE_END FCSD_SUB_DCCP_7_KEY
FCSD_DSAN_7_KEY
FCSD_SUB_CONTENT_8_SCALE_SCORE
FCSD_SUB_CONTENT_8_NUM_POINTS
FCSD_SUB_CONTENT_8_PCT_POINTS
FCSD_SUB_CONTENT_8_PERF_LEVEL
FCSD_SUB_DCCP_8_CODE
FCSD_SUB_DCCP_8_KEY DIM_TITLE_111
FCSD_DSAN_8_KEY
FCSD_SUB_CONTENT_9_SCALE_SCORE PK DTTL_KEY
DIM_GRAD_CLASS11
FCSD_SUB_CONTENT_9_NUM_POINTS
FCSD_SUB_CONTENT_9_PCT_POINTS DTTL_SORT_KEY
DTTL_CODE
PK DGCL_KEY FCSD_SUB_CONTENT_9_PERF_LEVEL
DTTL_TEXT
FCSD_SUB_DCCP_9_CODE DTTL_CREATE_BATCH_NUM
DGCL_SORT_KEY FCSD_SUB_DCCP_9_KEY DTTL_UPDATE_BATCH_NUM
DGCL_CODE FCSD_DSAN_9_KEY DTTL_MAPPING_BATCH_NUM
DGCL_TEXT FCSD_SUB_CONTENT_0_SCALE_SCORE DTTL_EFF_DATE_START
DGCL_CREATE_BATCH_NUM DTTL_EFF_DATE_END
DGCL_UPDATE_BATCH_NUM FCSD_SUB_CONTENT_0_NUM_POINTS
DGCL_MAPPING_BATCH_NUM FCSD_SUB_CONTENT_0_PCT_POINTS
DGCL_EFF_DATE_START FCSD_SUB_CONTENT_0_PERF_LEVEL
DGCL_EFF_DATE_END FCSD_SUB_DCCP_0_CODE
FCSD_SUB_DCCP_0_KEY
FCSD_DSAN_0_KEY
FCSD_STUDENT_GROWTH_PERCENTILE

DIM_GRADE_CALC_EXEMPTION11

PK DGCE_KEY
DIM_TIME_IN_SCHOOL11
DGCE_SORT_KEY
DGCE_CODE PK DTIS_KEY
DGCE_TEXT
DGCE_CREATE_BATCH_NUM DTIS_SORT_KEY
DGCE_UPDATE_BATCH_NUM DTIS_CODE
DGCE_MAPPING_BATCH_NUM DIM_SCHOOL_EMH11 DTIS_TEXT
DGCE_EFF_DATE_START DTIS_IN_SCHOOL_CONTINUOUSLY
DGCE_EFF_DATE_END DIM_SCHOOL_YEAR11 DTIS_CREATE_BATCH_NUM
PK DEMH_KEY DIM_SCHOOL11 DIM_TIME_IN_DISTRICT11 DTIS_UPDATE_BATCH_NUM
DEMH_DASY_SCHOOL_YEAR PK DASY_KEY DTIS_MAPPING_BATCH_NUM
PK DSCH_KEY PK DTID_KEY DTIS_EFF_DATE_START
DEMH_DASY_KEY
DEMH_DSCH_SCHOOL_NUMBER DASY_ACADEMIC_YEAR DTIS_EFF_DATE_END
DSCH_SORT_KEY DTID_SORT_KEY
DEMH_DSCH_KEY DASY_TEXT DSCH_DISTRICT_NUMBER
DEMH_EMH_CODE DASY_START_DATE DTID_CODE
DSCH_DDST_KEY DTID_TEXT
DEMH_SCHOOL_TITLE DASY_END_DATE DSCH_SCHOOL_NUMBER
DEMH_GRADE_SPAN_LOW DASY_ASSMNT_REPORTS_READY_YN DTID_IN_DISTRICT_CONTINUOUSLY
DSCH_NAME DTID_CREATE_BATCH_NUM
DEMH_LOW_DGRD_KEY DASY_CREATE_BATCH_NUM DSCH_COUNTY
DEMH_GRADE_SPAN_HIGH DASY_UPDATE_BATCH_NUM DTID_UPDATE_BATCH_NUM
DSCH_ADDRESS_1 DTID_MAPPING_BATCH_NUM
DEMH_HIGH_DGRD_KEY DASY_MAPPING_BATCH_NUM DSCH_ADDRESS_2
DEMH_LOC_XCOORD DASY_EFF_DATE_START DTID_EFF_DATE_START
DSCH_CITY DTID_EFF_DATE_END
DEMH_LOC_YCOORD DASY_EFF_DATE_END DSCH_STATE
DEMH_PRINT_GRADE_SPAN_YN DSCH_ZIP_CODE_5
DEMH_PRINT_REPCARD DSCH_ZIP_PLUS_4
DEMH_SORT_KEY DSCH_PHONE_NUMBER
DEMH_CREATE_BATCH_NUM DSCH_FAX_NUMBER
DEMH_UPDATE_BATCH_NUM DSCH_WEB_SITE
DEMH_MAPPING_BATCH_NUM DSCH_GRADE_SPAN_LOW
DEMH_EFF_DATE_END DSCH_GRADE_SPAN_HIGH
DEMH_EFF_DATE_START DSCH_PUBLIC_SCHOOL_FLAG
DEMH_NEW_SCHOOL_YN DSCH_NON_PUBLIC_PROFILE_TYPE
DEMH_DTTL_KEY DSCH_EMAIL_ADDRESS
DEMH_MADE_AYP_READING_YN DSCH_CHARTER_YN
DEMH_AYP_STATUS_CODE_READING DSCH_OPEN_YN
DEMH_AYP_STATUS_TEXT_READING DSCH_LOC_XCOORD
DEMH_MADE_AYP_MATH_YN DSCH_LOC_YCOORD
DEMH_AYP_STATUS_CODE_MATH DSCH_CREATE_BATCH_NUM
DEMH_AYP_STATUS_TEXT_MATH DSCH_UPDATE_BATCH_NUM
DEMH_ALTERNATIVE_EDUCATION_YN DSCH_MAPPING_BATCH_NUM
DEMH_IN_GRADE_CALC DSCH_EFF_DATE_START
DEMH_IN_GRADE_CALC_DESC DSCH_EFF_DATE_END
DEMH_PRINT_REPCARD_DESC DSCH_DATE_OPERATIONAL
DSCH_ALTERNATIVE_EDUCATION_YN
DSCH_CO_HOUSE_DISTRICT
DSCH_CO_SENATE_DISTRICT
DSCH_US_CONGRESS_DISTRICT
DSCH_NON_PUBLIC_SCHOOL_FLAG
DSCH_HEAD_START_FLAG
DSCH_DETENTION_CENTER_FLAG