S_SC_STU_EFA_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_EFA_History]unique_ID. |
School_ID | 20.8.2.0 | Number(11,0) | Migrated from [SC_EFA_History]school_id. 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_EFA_History]datetime_created. |
DateTime_Updated | 20.8.2.0 | Varchar2(20) | Migrated from [SC_EFA_History]datetime_updated. |
EFA_2 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_2. |
EFA_3 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_3. |
EFA_4 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_4. |
EFA_5 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_5. |
EFA_6 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_6. |
EFA_7 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_7. |
EFA_8 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_8. |
EFA_9 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_9. |
EFA_10 | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_10. |
EFA_Primary | 20.8.2.0 | Varchar2(10) | Migrated from [SC_EFA_History]efa_primary. |
ForeignKey | 20.8.2.0 | Number(11,0) | Migrated From [SC_EFA_History]foreignKey. |
ForeignKey_Alpha | 20.8.2.0 | Varchar2(31) | Migrated From [SC_EFA_History]foreignKey_alpha. |
RptUserID | 20.8.2.0 | Number(11,0) | Migrated from [SC_EFA_History]user_defined_numeric. Updated data type from Number(25,10) to Number 11,0) in version 20.8.2.0. |
SchoolID | 20.8.2.0 | Number(11,0) | Migrated From [SC_EFA_History]schoolID. |
SchoolID_Updated | 20.8.2.0 | Number(11,0) | Migrated from [SC_EFA_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_EFA_History]start_dt. |
Stop_DT | 20.8.2.0 | Date | Migrated from [SC_EFA_History]stop_dt. |
UserID_Updated | 20.8.2.0 | Number(11,0) | Migrated from [SC_EFA_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_EFA_History]user_defined_integer. |