S_NC_LEP_Data (ver 13.6.0)
This table is a child table of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ACTIVE | 13.6.0 | VARCHAR2(100) | |
| ALT_DESC | 13.6.0 | VARCHAR2(255) | |
| AREA | 13.6.0 | VARCHAR2(100) | |
| CODE | 13.6.0 | VARCHAR2(5) | |
| CODE_TYPE | 13.6.0 | VARCHAR2(5) | |
| DESCRIPTION | 13.6.0 | VARCHAR2(255) | |
| ID | 13.6.0 | NUMBER(19,0) | Primary key |
| LDO_BORN_OUTSIDE_US | 13.6.0 | VARCHAR2(100) | |
| LDO_BTW_3_21 | 13.6.0 | VARCHAR2(100) | |
| LDO_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| LDO_CHANGED_ON | 13.6.0 | DATE | |
| LDO_CLASS_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_COUNT_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_DOB | 13.6.0 | DATE | |
| LDO_EXITED_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_FIRST_NAME | 13.6.0 | VARCHAR2(100) | |
| LDO_FIRST_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_GRADE_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_HOMELANG_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_IMMIGRANT_STATUS | 13.6.0 | VARCHAR2(100) | |
| LDO_IMM_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_LAST_NAME | 13.6.0 | VARCHAR2(100) | |
| LDO_LEP_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_NCWISE_ID | 13.6.0 | VARCHAR2(100) | |
| LDO_OUT_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_RETURNED_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_SCHOOL_CODE | 13.6.0 | VARCHAR2(100) | |
| LDO_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_SIE_STUDENT_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_TIER_ID | 13.6.0 | NUMBER(11,0) | |
| LDO_VALIDATED_VIA_TEST | 13.6.0 | VARCHAR2(100) | |
| LDO_YEARS_US_SCHOOL | 13.6.0 | NUMBER(11,0) | |
| LDO_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| LEP_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| LEP_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| LEP_CHANGED_ON | 13.6.0 | DATE | |
| LEP_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| LEP_EXITED_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| LEP_EXPECTED_TO_PART | 13.6.0 | VARCHAR2(100) | |
| LEP_HOMELANG_ID | 13.6.0 | NUMBER(11,0) | |
| LEP_IN_AMAO1_DENOM | 13.6.0 | VARCHAR2(100) | |
| LEP_IN_AMAO2_DENOM | 13.6.0 | VARCHAR2(100) | |
| LEP_IN_OCT_HEADCOUNT | 13.6.0 | NUMBER(11,0) | |
| LEP_PROGRESS | 13.6.0 | VARCHAR2(100) | |
| LEP_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| LEP_STATUS_ID | 13.6.0 | NUMBER(11,0) | |
| LEP_TIER_ID | 13.6.0 | NUMBER(11,0) | |
| LEP_YEARS_US_SCHOOL | 13.6.0 | NUMBER(11,0) | |
| LEP_YEAR_1_ALT_EXEMPT | 13.6.0 | VARCHAR2(5) | |
| LEP_YEAR_1_EXEMPT | 13.6.0 | VARCHAR2(5) | |
| LEP_YEAR_2_ALT_EXEMPT | 13.6.0 | VARCHAR2(5) | |
| MAE_504_PLAN | 13.6.0 | VARCHAR2(100) | |
| MAE_ABSENT_LISTEN | 13.6.0 | VARCHAR2(100) | |
| MAE_ABSENT_READ | 13.6.0 | VARCHAR2(100) | |
| MAE_ABSENT_SPEAK | 13.6.0 | VARCHAR2(100) | |
| MAE_ABSENT_WRITE | 13.6.0 | VARCHAR2(100) | |
| MAE_AMER_INDIAN | 13.6.0 | VARCHAR2(100) | |
| MAE_ASIAN | 13.6.0 | VARCHAR2(100) | |
| MAE_AUDIO_AMP_DEVICE | 13.6.0 | VARCHAR2(100) | |
| MAE_BLACK | 13.6.0 | VARCHAR2(100) | |
| MAE_BOOKLET_SERIAL_NO | 13.6.0 | VARCHAR2(100) | |
| MAE_BRAILLE_TEST_OR_WRITER | 13.6.0 | VARCHAR2(100) | |
| MAE_CLUSTER | 13.6.0 | VARCHAR2(100) | |
| MAE_COC | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPOSITE_CONFIDE_H_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_COMPOSITE_CONFIDE_L_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_COMPOSITE_PROF_LEVEL | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPOSITE_PROF_LEVEL_K | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPOSITE_SCALE_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPREH_CONFIDE_H_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_COMPREH_CONFIDE_L_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_COMPREH_LA_RAW_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPREH_MATH_RAW_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPREH_PROF_LEVEL | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPREH_PROF_LEVEL_K | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPREH_SCIENCE_RAW_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPREH_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPREH_SI_RAW_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPREH_SS_RAW_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_COMPUTER_ASSISTED | 13.6.0 | VARCHAR2(100) | |
| MAE_CONTENT_AREA_TUTOR | 13.6.0 | VARCHAR2(100) | |
| MAE_CONTENT_BASED_ESL | 13.6.0 | VARCHAR2(100) | |
| MAE_DEVELOPMENTAL_BILINGUAL | 13.6.0 | VARCHAR2(100) | |
| MAE_DISTRICT_NAME | 13.6.0 | VARCHAR2(100) | |
| MAE_DISTRICT_NUMBER | 13.6.0 | VARCHAR2(100) | |
| MAE_DISTRICT_STUDENT_ID | 13.6.0 | VARCHAR2(100) | |
| MAE_DIST_DEF_OPT_DATA | 13.6.0 | VARCHAR2(100) | |
| MAE_DOB | 13.6.0 | DATE | |
| MAE_DUAL_LANG_2WAY_IMMERSION | 13.6.0 | VARCHAR2(100) | |
| MAE_ESE_504_LISTEN | 13.6.0 | VARCHAR2(100) | |
| MAE_ESE_504_READ | 13.6.0 | VARCHAR2(100) | |
| MAE_ESE_504_SPEAK | 13.6.0 | VARCHAR2(100) | |
| MAE_ESE_504_WRITE | 13.6.0 | VARCHAR2(100) | |
| MAE_ETHNICITY | 13.6.0 | VARCHAR2(100) | |
| MAE_FIRST_ENROLL | 13.6.0 | DATE | |
| MAE_FIRST_NAME | 13.6.0 | VARCHAR2(100) | |
| MAE_FORM_NUMBER | 13.6.0 | NUMBER(11,0) | |
| MAE_GENDER | 13.6.0 | VARCHAR2(100) | |
| MAE_GRADE | 13.6.0 | NUMBER(11,0) | |
| MAE_HERITAGE_LANG | 13.6.0 | VARCHAR2(100) | |
| MAE_IEP_STATUS | 13.6.0 | VARCHAR2(100) | |
| MAE_INCLUSIONARY_SUPPORT | 13.6.0 | VARCHAR2(100) | |
| MAE_INVALID_LISTEN | 13.6.0 | VARCHAR2(100) | |
| MAE_INVALID_READ | 13.6.0 | VARCHAR2(100) | |
| MAE_INVALID_SPEAK | 13.6.0 | VARCHAR2(100) | |
| MAE_INVALID_WRITE | 13.6.0 | VARCHAR2(100) | |
| MAE_K_LISTEN_RAW_ITEM_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_K_LISTEN_SCORED_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_K_READ_RAW_ITEM_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_K_READ_SCORED_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_K_SPEAK_RAW_ITEM_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_K_SPEAK_SCORED_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_K_WRITE_RAW_ITEM_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_K_WRITE_SCORED_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_LARGE_PRINT_BOOKLET | 13.6.0 | VARCHAR2(100) | |
| MAE_LAST_NAME | 13.6.0 | VARCHAR2(100) | |
| MAE_LENGTH_IN_PROGRAM | 13.6.0 | NUMBER(11,0) | |
| MAE_LEP_ID | 13.6.0 | NUMBER(11,0) | |
| MAE_LISTEN_CONFIDE_H_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_LISTEN_CONFIDE_L_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_LISTEN_PROF_LEVEL | 13.6.0 | VARCHAR2(100) | |
| MAE_LISTEN_PROF_LEVEL_K | 13.6.0 | VARCHAR2(100) | |
| MAE_LISTEN_RAW_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_LISTEN_SCALE_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_LISTEN_SCOD_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_LITERACY_CONFIDE_H_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_LITERACY_CONFIDE_L_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_LITERACY_PROF_LEVEL | 13.6.0 | VARCHAR2(100) | |
| MAE_LITERACY_PROF_LEVEL_K | 13.6.0 | VARCHAR2(100) | |
| MAE_LITERACY_SCALE_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_MAG_LOW_VISION_AIDS | 13.6.0 | VARCHAR2(100) | |
| MAE_MIDDLE_NAME | 13.6.0 | VARCHAR2(100) | |
| MAE_MIGRANT | 13.6.0 | VARCHAR2(100) | |
| MAE_MOD_PRES_FORMAT | 13.6.0 | VARCHAR2(100) | |
| MAE_MOD_TEST_DIR | 13.6.0 | VARCHAR2(100) | |
| MAE_MOD_TIMING | 13.6.0 | VARCHAR2(100) | |
| MAE_NATIVE_LANG | 13.6.0 | VARCHAR2(100) | |
| MAE_NO_ADDITIONAL_SERVICE | 13.6.0 | VARCHAR2(100) | |
| MAE_ORAL_CONFIDE_H_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_ORAL_PROF_LEVEL | 13.6.0 | VARCHAR2(100) | |
| MAE_ORAL_PROF_LEVEL_K | 13.6.0 | VARCHAR2(100) | |
| MAE_ORAL_SCALE_CONFIDE_L_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_ORAL_SCALE_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_OTHER_APPROVED_ACCOMM | 13.6.0 | VARCHAR2(100) | |
| MAE_PACIFIC_ISLANDER | 13.6.0 | VARCHAR2(100) | |
| MAE_PARENT_REFUSE_4SERVICES | 13.6.0 | VARCHAR2(100) | |
| MAE_PROCESSED_FLAG | 13.6.0 | VARCHAR2(100) | |
| MAE_PULL_OUT_4IND_SUPPORT | 13.6.0 | VARCHAR2(100) | |
| MAE_PULL_OUT_ESL | 13.6.0 | VARCHAR2(100) | |
| MAE_READ_CONFIDE_H_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_READ_CONFIDE_L_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_READ_PROF_LEVEL | 13.6.0 | VARCHAR2(100) | |
| MAE_READ_PROF_LEVEL_K | 13.6.0 | VARCHAR2(100) | |
| MAE_READ_RAW_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_READ_SCALE_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_READ_SCOD_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_REFUSED_LISTEN | 13.6.0 | VARCHAR2(100) | |
| MAE_REFUSED_READ | 13.6.0 | VARCHAR2(100) | |
| MAE_REFUSED_SPEAK | 13.6.0 | VARCHAR2(100) | |
| MAE_REFUSED_WRITE | 13.6.0 | VARCHAR2(100) | |
| MAE_SCHOOL_NAME | 13.6.0 | VARCHAR2(100) | |
| MAE_SCHOOL_NUMBER | 13.6.0 | VARCHAR2(100) | |
| MAE_SCORING_CENTER_USE | 13.6.0 | NUMBER(11,0) | |
| MAE_SCRIBE | 13.6.0 | VARCHAR2(100) | |
| MAE_SELF_CONTAINED | 13.6.0 | VARCHAR2(100) | |
| MAE_SETTING_FORMAT_SF | 13.6.0 | VARCHAR2(100) | |
| MAE_SHELTER_ENG_INSTRUCTION | 13.6.0 | VARCHAR2(100) | |
| MAE_SHORT_SEGMENT_TEST_ADMIN | 13.6.0 | VARCHAR2(100) | |
| MAE_SPEAK_CONFIDE_H_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_SPEAK_CONFIDE_L_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_SPEAK_LA_SS_RAW_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_SPEAK_MATH_SCI_RAW_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_SPEAK_PROF_LEVEL | 13.6.0 | VARCHAR2(100) | |
| MAE_SPEAK_PROF_LEVEL_K | 13.6.0 | VARCHAR2(100) | |
| MAE_SPEAK_RAW_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_SPEAK_SCALE_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_SPEAK_SCOD_RESPS | 13.6.0 | NUMBER(11,0) | |
| MAE_SPEAK_SI_RAW_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_STATE_DEF_OPT_DATA | 13.6.0 | VARCHAR2(100) | |
| MAE_STATE_STUDENT_ID | 13.6.0 | VARCHAR2(100) | |
| MAE_STATE_SUPPORT_DELIVER_NA | 13.6.0 | VARCHAR2(100) | |
| MAE_STRUCT_ENG_IMMERS_SDAIE | 13.6.0 | VARCHAR2(100) | |
| MAE_STU_MADE_TAPE_READ_TEST | 13.6.0 | VARCHAR2(100) | |
| MAE_TIER | 13.6.0 | VARCHAR2(100) | |
| MAE_TITLE3_STATUS | 13.6.0 | VARCHAR2(100) | |
| MAE_TRANSITIONAL_BILINGUAL | 13.6.0 | VARCHAR2(100) | |
| MAE_UPDATED | 13.6.0 | VARCHAR2(100) | |
| MAE_WHITE | 13.6.0 | VARCHAR2(100) | |
| MAE_WRITE_CONFIDE_H_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_WRITE_CONFIDE_L_SCO | 13.6.0 | NUMBER(11,0) | |
| MAE_WRITE_LA_SS_SCOS | 13.6.0 | VARCHAR2(100) | |
| MAE_WRITE_MATH_SCOS | 13.6.0 | VARCHAR2(100) | |
| MAE_WRITE_PROF_LEVEL | 13.6.0 | VARCHAR2(100) | |
| MAE_WRITE_PROF_LEVEL_K | 13.6.0 | VARCHAR2(100) | |
| MAE_WRITE_RAW_SCOS_1 | 13.6.0 | NUMBER(11,0) | |
| MAE_WRITE_RAW_SCOS_2 | 13.6.0 | NUMBER(11,0) | |
| MAE_WRITE_RAW_SCOS_3 | 13.6.0 | NUMBER(11,0) | |
| MAE_WRITE_RAW_SCOS_4 | 13.6.0 | NUMBER(11,0) | |
| MAE_WRITE_SCALE_SCO | 13.6.0 | VARCHAR2(100) | |
| MAE_WRITE_SCIENCE_SCOS | 13.6.0 | VARCHAR2(100) | |
| MAE_WRITE_SI_SCOS | 13.6.0 | VARCHAR2(100) | |
| SCHOOLID | 13.6.0 | NUMBER(11,0) | |
| SORT_ORDER | 13.6.0 | NUMBER(11,0) | |
| STUDENTSDCID | 13.6.0 | NUMBER(19,0) | Foreign key that links to the students table. |
| STUDENT_NUMBER | 13.6.0 | NUMBER(11,0) | The PowerSchool student number. |
| WHATCREATED | 13.6.0 | VARCHAR2(50) | |
| WHATMODIFIED | 13.6.0 | VARCHAR2(50) |