S_NC_LEP_DOM (ver 13.6.0)
This table is an extension 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(20) | |
| CODE_TYPE | 13.6.0 | VARCHAR2(5) | |
| COLLECTION_ID | 13.6.0 | NUMBER(11,0) | |
| COMP_MIN | 13.6.0 | NUMBER(11,0) | |
| CONSORTIUM_ID | 13.6.0 | NUMBER(11,0) | |
| COUNT_ID | 13.6.0 | NUMBER(11,0) | |
| DESCRIPTION | 13.6.0 | VARCHAR2(255) | |
| DPI_USE_ONLY | 13.6.0 | VARCHAR2(1) | |
| DUPE_SCORING_CENTER_USE | 13.6.0 | NUMBER(11,0) | |
| END_DATE | 13.6.0 | DATE | |
| FCOD_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| FCOD_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| FCOD_CHANGED_COMMENT | 13.6.0 | VARCHAR2(100) | |
| FCOD_CHANGED_ON | 13.6.0 | DATE | |
| FCOD_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| FCOD_CODE | 13.6.0 | VARCHAR2(100) | |
| FCOD_COLLECTION_ID | 13.6.0 | NUMBER(11,0) | |
| FCOD_COUNT_ID | 13.6.0 | NUMBER(11,0) | |
| FCOD_DESC | 13.6.0 | VARCHAR2(100) | |
| FCOD_SORT_ORDER | 13.6.0 | NUMBER(11,0) | |
| FEB_COUNT_DATE | 13.6.0 | DATE | |
| FED_CODE | 13.6.0 | VARCHAR2(100) | |
| FHLD_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| FHLD_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| FHLD_CHANGED_COMMENT | 13.6.0 | VARCHAR2(100) | |
| FHLD_CHANGED_ON | 13.6.0 | DATE | |
| FHLD_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| FHLD_CODE | 13.6.0 | VARCHAR2(100) | |
| FHLD_DESC | 13.6.0 | VARCHAR2(100) | |
| FHLD_FED_CODE | 13.6.0 | VARCHAR2(100) | |
| FHLD_HOMELANG_ID | 13.6.0 | NUMBER(11,0) | |
| FHLD_SORT_ORDER | 13.6.0 | NUMBER(11,0) | |
| FTP_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| FTP_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| FTP_CHANGED_COMMENTS | 13.6.0 | VARCHAR2(100) | |
| FTP_CHANGED_ON | 13.6.0 | DATE | |
| FTP_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| FTP_COLLECTION_ID | 13.6.0 | NUMBER(11,0) | |
| FTP_END_DATE | 13.6.0 | DATE | |
| FTP_GRACE_DATE | 13.6.0 | DATE | |
| FTP_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| FTP_START_DATE | 13.6.0 | DATE | |
| GRACE_DATE | 13.6.0 | DATE | |
| HOMELANG_ID | 13.6.0 | NUMBER(11,0) | |
| ID | 13.6.0 | NUMBER(19,0) | Primary key |
| LAST_DATE | 13.6.0 | DATE | |
| LCOD_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| LCOD_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| LCOD_CHANGED_COMMENT | 13.6.0 | VARCHAR2(100) | |
| LCOD_CHANGED_ON | 13.6.0 | DATE | |
| LCOD_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| LCOD_CODE | 13.6.0 | VARCHAR2(100) | |
| LCOD_CONSORTIUM_ID | 13.6.0 | NUMBER(11,0) | |
| LCOD_DESC | 13.6.0 | VARCHAR2(100) | |
| LCOD_SORT_ORDER | 13.6.0 | NUMBER(11,0) | |
| LISTENING_MIN | 13.6.0 | NUMBER(11,0) | |
| LSCD_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| LSCD_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| LSCD_CHANGED_COMMENT | 13.6.0 | VARCHAR2(100) | |
| LSCD_CHANGED_ON | 13.6.0 | DATE | |
| LSCD_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| LSCD_CODE | 13.6.0 | VARCHAR2(100) | |
| LSCD_DESC | 13.6.0 | VARCHAR2(100) | |
| LSCD_MIN_ADJ_CPL | 13.6.0 | NUMBER(11,0) | |
| LSCD_MIN_LISTENING_PL | 13.6.0 | NUMBER(11,0) | |
| LSCD_MIN_READING_PL | 13.6.0 | NUMBER(11,0) | |
| LSCD_MIN_SPEAKING_PL | 13.6.0 | NUMBER(11,0) | |
| LSCD_MIN_WRITING_PL | 13.6.0 | NUMBER(11,0) | |
| LSCD_RANGE_ID | 13.6.0 | NUMBER(11,0) | |
| LSCD_STATUS_CALC_ID | 13.6.0 | NUMBER(11,0) | |
| LSTD_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| LSTD_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| LSTD_CHANGED_COMMENT | 13.6.0 | VARCHAR2(100) | |
| LSTD_CHANGED_ON | 13.6.0 | DATE | |
| LSTD_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| LSTD_CODE | 13.6.0 | VARCHAR2(100) | |
| LSTD_DESC | 13.6.0 | VARCHAR2(100) | |
| LSTD_SORT_ORDER | 13.6.0 | NUMBER(11,0) | |
| LSTD_STATUS_ID | 13.6.0 | NUMBER(11,0) | |
| LTA_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| LTA_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| LTA_CHANGED_ON | 13.6.0 | DATE | |
| LTA_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| LTA_CONSORTIUM_104 | 13.6.0 | NUMBER(11,0) | |
| LTA_CONSORTIUM_111 | 13.6.0 | NUMBER(11,0) | |
| LTA_ID | 13.6.0 | NUMBER(11,0) | |
| LTA_PLANNING_BUDGET_104 | 13.6.0 | NUMBER(11,0) | |
| LTA_PLANNING_BUDGET_111 | 13.6.0 | NUMBER(11,0) | |
| LTA_PRC104_STATUS | 13.6.0 | NUMBER(11,0) | |
| LTA_PRC111_STATUS | 13.6.0 | NUMBER(11,0) | |
| LTA_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| LTA_SUBGRANTEE | 13.6.0 | VARCHAR2(100) | |
| LTID_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| LTID_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| LTID_CHANGED_COMMENT | 13.6.0 | VARCHAR2(100) | |
| LTID_CHANGED_ON | 13.6.0 | DATE | |
| LTID_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| LTID_CODE | 13.6.0 | VARCHAR2(100) | |
| LTID_DESC | 13.6.0 | VARCHAR2(100) | |
| LTID_MAX_PL | 13.6.0 | NUMBER(11,0) | |
| LTID_MIN_PL | 13.6.0 | NUMBER(11,0) | |
| LTID_SORT_ORDER | 13.6.0 | NUMBER(11,0) | |
| LTID_TIER_ID | 13.6.0 | NUMBER(11,0) | |
| MAD_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| MAD_CHANGED_ON | 13.6.0 | DATE | |
| MAD_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| MAD_DUPE_SCORING_CENTER_USE | 13.6.0 | NUMBER(11,0) | |
| MAD_REAL_SCORING_CENTER_USE | 13.6.0 | NUMBER(11,0) | |
| MAD_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| MAIN | 13.6.0 | VARCHAR2(100) | |
| MAX_PL | 13.6.0 | NUMBER(11,0) | |
| MCOD_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| MCOD_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| MCOD_CHANGED_ON | 13.6.0 | DATE | |
| MCOD_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| MCOD_COMP_MIN | 13.6.0 | NUMBER(11,0) | |
| MCOD_LISTENING_MIN | 13.6.0 | NUMBER(11,0) | |
| MCOD_READING_MIN | 13.6.0 | NUMBER(11,0) | |
| MCOD_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| MCOD_SPEAKING_MIN | 13.6.0 | NUMBER(11,0) | |
| MCOD_WRITING_MIN | 13.6.0 | NUMBER(11,0) | |
| MIN_ADJ_CPL | 13.6.0 | NUMBER(11,0) | |
| MIN_LISTENING_PL | 13.6.0 | NUMBER(11,0) | |
| MIN_PL | 13.6.0 | NUMBER(11,0) | |
| MIN_READING_PL | 13.6.0 | NUMBER(11,0) | |
| MIN_SPEAKING_PL | 13.6.0 | NUMBER(11,0) | |
| MIN_WRITING_PL | 13.6.0 | NUMBER(11,0) | |
| MPFD_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| MPFD_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| MPFD_CHANGED_COMMENT | 13.6.0 | VARCHAR2(100) | |
| MPFD_CHANGED_ON | 13.6.0 | DATE | |
| MPFD_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| MPFD_CODE | 13.6.0 | VARCHAR2(100) | |
| MPFD_DESC | 13.6.0 | VARCHAR2(100) | |
| MPFD_MAIN | 13.6.0 | VARCHAR2(100) | |
| MPFD_PROCESS_FLAG_ID | 13.6.0 | NUMBER(11,0) | |
| MPFD_SORT_ORDER | 13.6.0 | NUMBER(11,0) | |
| NCTD_ACTIVE | 13.6.0 | VARCHAR2(100) | |
| NCTD_CHANGED_BY | 13.6.0 | VARCHAR2(100) | |
| NCTD_CHANGED_COMMENT | 13.6.0 | VARCHAR2(100) | |
| NCTD_CHANGED_ON | 13.6.0 | DATE | |
| NCTD_CHANGED_WITH | 13.6.0 | VARCHAR2(100) | |
| NCTD_CODE | 13.6.0 | VARCHAR2(100) | |
| NCTD_DESC | 13.6.0 | VARCHAR2(100) | |
| NCTD_NCWISE_TEST_ID | 13.6.0 | NUMBER(11,0) | |
| NCTD_RANGE_ID | 13.6.0 | NUMBER(11,0) | |
| NCTD_SCORE_TYPE | 13.6.0 | NUMBER(11,0) | |
| NCTD_SCORE_TYPE_CODE | 13.6.0 | VARCHAR2(100) | |
| NCTD_SORT_ORDER | 13.6.0 | NUMBER(11,0) | |
| NCTD_SUB_TEST_CODE | 13.6.0 | VARCHAR2(100) | |
| NCTD_SUB_TEST_ID | 13.6.0 | NUMBER(11,0) | |
| NCTD_TEST_ID | 13.6.0 | NUMBER(11,0) | |
| NCTD_TIER_ID | 13.6.0 | NUMBER(11,0) | |
| NCWISE_TEST_ID | 13.6.0 | NUMBER(11,0) | |
| OCT_COUNT_DATE | 13.6.0 | DATE | |
| PROCESS_FLAG_ID | 13.6.0 | NUMBER(11,0) | |
| RANGE_ID | 13.6.0 | NUMBER(11,0) | |
| READING_MIN | 13.6.0 | NUMBER(11,0) | |
| REAL_SCORING_CENTER_USE | 13.6.0 | NUMBER(11,0) | |
| SCHOOL_YEAR_ID | 13.6.0 | NUMBER(11,0) | |
| SCORE_TYPE | 13.6.0 | NUMBER(11,0) | |
| SCORE_TYPE_CODE | 13.6.0 | VARCHAR2(100) | |
| SORT_ORDER | 13.6.0 | NUMBER(11,0) | |
| SPEAKING_MIN | 13.6.0 | NUMBER(11,0) | |
| START_DATE | 13.6.0 | DATE | |
| STATUS_CALC_ID | 13.6.0 | NUMBER(11,0) | |
| STATUS_ID | 13.6.0 | NUMBER(11,0) | |
| SUB_TEST_CODE | 13.6.0 | VARCHAR2(100) | |
| SUB_TEST_ID | 13.6.0 | NUMBER(11,0) | |
| TEST_ID | 13.6.0 | NUMBER(11,0) | |
| TIER_ID | 13.6.0 | NUMBER(11,0) | |
| WHATCREATED | 13.6.0 | VARCHAR2(50) | |
| WHATMODIFIED | 13.6.0 | VARCHAR2(50) |