Skip to main content
Skip table of contents

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)
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.