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) |