S_SC_STU_EIA_HISTORY_C (ver 20.8.2.0)
This table is a child table of the Students table.
Column Name | Version | Data Type | Description |
---|---|---|---|
Unique_ID | 20.8.2.0 | Number(11,0) | Migrated From [SC_EIA_History]unique_ID. |
SchoolID | 20.8.2.0 | Number(11,0) | Migrated From [SC_EIA_History]schoolID. Updated data type from Number(25,10) to Number 11,0) in version 20.8.2.0. |
DateTime_Created | 20.8.2.0 | Varchar2(20) | Migrated from [SC_EIA_History]datetime_created. |
DateTime_Updated | 20.8.2.0 | Varchar2(20) | Migrated from [SC_EIA_History]datetime_updated. |
EIA_1 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_1. |
EIA_2 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_2. |
EIA_3 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_3. |
EIA_4 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_4. |
EIA_5 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_5. |
EIA_6 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_6. |
EIA_7 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_7. |
EIA_8 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_8. |
EIA_9 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_9. |
EIA_10 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EIA_History]eia_10. |
ForeignKey | 20.8.2.0 | Number(11,0) | Migrated From [SC_EIA_History]foreignKey. |
ForeignKey_Alpha | 20.8.2.0 | Varchar2(31) | Migrated From [SC_EIA_History]foreignKey_alpha. |
RptUserID | 20.8.2.0 | Number(11,0) | Migrated from [SC_EIA_History]user_defined_numeric. Updated data type from Number(25,10) to Number 11,0) in version 20.8.2.0. |
SC_GT_Academic_Area | 20.8.2.0 | Varchar2(1) | Migrated from [SC_EIA_History]SC_GT_Academic_Area. |
SC_GT_Artistic_Discipline | 20.8.2.0 | Varchar2(1) | Migrated from [SC_EIA_History]SC_GT_Artistic_Discipline. |
SchoolID_Updated | 20.8.2.0 | Number(11,0) | Migrated from [SC_EIA_History]schoolid_updated. Updated data type from Number(25,10) to Number 11,0) in version 20.8.2.0. |
Start_DT | 20.8.2.0 | Date | Migrated from [SC_EIA_History]start_dt. |
Stop_DT | 20.8.2.0 | Date | Migrated from [SC_EIA_History]stop_dt. |
UserID_Updated | 20.8.2.0 | Number(11,0) | Migrated from [SC_EIA_History]userid_updated. Updated data type from Number(25,10) to Number 11,0) in version 20.8.2.0. |
YearID | 20.8.2.0 | Number(11,0) | Migrated from [SC_EIA_History]user_defined_integer. |