S_NC_LEP_Audit (ver 13.6.0)
This table is a child table of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Access_Cluster | 13.6.0 | VARCHAR2(100) | |
| 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) | |
Collection_Code | 13.6.0 | VARCHAR2(100) | |
| Description | 13.6.0 | VARCHAR2(255) | |
FCOA_Action | 13.6.0 | VARCHAR2(100) | |
FCOA_Active | 13.6.0 | VARCHAR2(100) | |
FCOA_Audit_ID | 13.6.0 | NUMBER(11,0) | |
FCOA_Changed_By | 13.6.0 | VARCHAR2(100) | |
FCOA_Changed_On | 13.6.0 | DATE | |
FCOA_Changed_With | 13.6.0 | VARCHAR2(100) | |
FCOA_Count_ID | 13.6.0 | NUMBER(11,0) | |
FCOA_FDC_Count | 13.6.0 | NUMBER(11,0) | |
FCOA_FDC_Count_ID | 13.6.0 | NUMBER(11,0) | |
FCOA_School_Year_ID | 13.6.0 | NUMBER(11,0) | |
FCO_Active | 13.6.0 | VARCHAR2(100) | |
FCO_Changed_By | 13.6.0 | VARCHAR2(100) | |
FCO_Changed_On | 13.6.0 | DATE | |
FCO_Changed_With | 13.6.0 | VARCHAR2(100) | |
FCO_Count_ID | 13.6.0 | NUMBER(11,0) | |
FCO_FDC_Count | 13.6.0 | NUMBER(11,0) | |
FCO_FDC_Count_ID | 13.6.0 | NUMBER(11,0) | |
FCO_School_Year_ID | 13.6.0 | NUMBER(11,0) | |
First_Name | 13.6.0 | VARCHAR2(100) | |
FY_Exempt_2008 | 13.6.0 | VARCHAR2(100) | |
FY_US_Schools_Code | 13.6.0 | VARCHAR2(100) | |
FY_US_Schools_Data | 13.6.0 | VARCHAR2(100) | |
FY_US_Schools_Effective | 13.6.0 | VARCHAR2(100) | |
Grade | 13.6.0 | NUMBER(11,0) | |
| ID | 13.6.0 | NUMBER(19,0) | Primary key |
In_Latest_Accdemo | 13.6.0 | VARCHAR2(100) | |
Last_Name | 13.6.0 | VARCHAR2(100) | |
Latest_Accdemo_Ccode | 13.6.0 | VARCHAR2(100) | |
LEPA_Action | 13.6.0 | VARCHAR2(100) | |
LEPA_Active | 13.6.0 | VARCHAR2(100) | |
LEPA_Audit_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_Changed_By | 13.6.0 | VARCHAR2(100) | |
LEPA_Changed_DTE | 13.6.0 | DATE | |
LEPA_Changed_With | 13.6.0 | VARCHAR2(100) | |
LEPA_Class_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_Exited_School_Year_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_Expected_To_Part | 13.6.0 | VARCHAR2(100) | |
LEPA_First_School_Year_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_HomeLang_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_IMM_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_In_AMA01_Denom | 13.6.0 | VARCHAR2(100) | |
LEPA_In_AMA02_Denom | 13.6.0 | VARCHAR2(100) | |
LEPA_In_Federal_Headount | 13.6.0 | VARCHAR2(100) | |
LEPA_In_Oct_Headcount | 13.6.0 | VARCHAR2(100) | |
LEPA_Out_School_Year_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_Progress | 13.6.0 | VARCHAR2(100) | |
LEPA_Returned_School_Year_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_School_Code | 13.6.0 | VARCHAR2(100) | |
LEPA_School_Year_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_SIE_Student_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_Status_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_Student_ID | 13.6.0 | VARCHAR2(100) | |
LEPA_Temp_Student_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_Tier_ID | 13.6.0 | NUMBER(11,0) | |
LEPA_Validated_Via_Test | 13.6.0 | VARCHAR2(100) | |
LEPA_Year_US_School | 13.6.0 | NUMBER(11,0) | |
LEPFixer_First_Name | 13.6.0 | VARCHAR2(100) | |
LEPFixer_Last_Name | 13.6.0 | VARCHAR2(100) | |
LEP_Status | 13.6.0 | VARCHAR2(100) | |
LEP_Status_2008 | 13.6.0 | VARCHAR2(100) | |
LEP_Status_2009 | 13.6.0 | VARCHAR2(100) | |
Merged | 13.6.0 | VARCHAR2(100) | |
Reporting_Year | 13.6.0 | VARCHAR2(100) | |
School_Code | 13.6.0 | VARCHAR2(100) | |
SIE_Student_ID | 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 student table. |
| Student_ID | 13.6.0 | VARCHAR2(100) | |
WhatCreated | 13.6.0 | VARCHAR2(50) | |
| WhatModified | 13.6.0 | VARCHAR2(50) | |
| Year_Exited | 13.6.0 | VARCHAR2(100) |