S_NC_Migrant_COE (ver 13.6.0)
This table is an child table of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 13.6.0 | NUMBER(19,0) | Primary key |
| STUDENTSDCID | 13.6.0 | NUMBER(19,0) | Foreign key to Students table |
| Address | 14.10.0 | Varchar2(50) | |
Agri_Fish | 13.6.0 | Varchar2(1) | |
Children_Moved | 13.6.0 | Varchar2(30) | |
Children_Moved_On | 13.6.0 | Date | |
Children_Moved_On_Comment | 13.6.0 | Varchar2(500) | |
City | 14.10.0 | Varchar2(50) | |
COE_ID | 13.6.0 | Varchar2(20) | |
COE_Review_Date | 13.6.0 | Date | |
COE_Reviewer | 13.6.0 | Varchar2(20) | |
Contact_Phone | 14.10.0 | Varchar2(50) | |
Created_By | 13.6.0 | Varchar2(30) | |
Created_On | 13.6.0 | Date | |
Did_Not_Obtain_Qual_Work | 13.6.0 | Varchar2(20) | |
From_City | 13.6.0 | Varchar2(20) | |
From_Country | 13.6.0 | Varchar2(3) | |
From_School_District | 13.6.0 | Varchar2(50) | |
From_State | 13.6.0 | Varchar2(2) | |
| From_State_New | 14.10.0 | Varchar2(10) | |
| Guardian_Female_LN | 14.10.0 | Varchar2(50) | |
| Guardian_Female_FN | 14.10.0 | Varchar2(50) | |
| Guardian_Male_LN | 14.10.0 | Varchar2(50) | |
| Guardian_Male_FN | 14.10.0 | Varchar2(50) | |
| Home_Phone | 14.10.0 | Varchar2(50) | |
Interview_Date | 13.6.0 | Date | |
Interviewer | 13.6.0 | Varchar2(20) | |
Modified_By | 13.6.0 | Varchar2(30) | |
Modified_On | 13.6.0 | Date | |
Moved_To_Obtain | 13.6.0 | Varchar2(20) | |
Moved_To_Obtain_Comment | 13.6.0 | Varchar2(500) | |
Other_Comment | 13.6.0 | Varchar2(500) | |
Personal_Subsistence | 13.6.0 | Varchar2(1) | |
QA3_Date | 13.6.0 | Date | |
Qualifying_Activity | 13.6.0 | Varchar2(30) | |
Qualifying_Arrival_Date | 13.6.0 | Date | |
Qualifying_Move | 13.6.0 | Varchar2(10) | |
Relationship | 13.6.0 | Varchar2(20) | |
Signed_By | 13.6.0 | Varchar2(30) | |
Signed_Date | 13.6.0 | Date | |
| State | 14.10.0 | Varchar2(50) | |
Temp_SEAS | 13.6.0 | Varchar2(1) | |
Temp_SEAS_Comments | 13.6.0 | Varchar2(500) | |
Temp_Work_Based_On | 13.6.0 | Varchar2(20) | |
To_City | 13.6.0 | Varchar2(20) | |
To_School_District | 13.6.0 | Varchar2(50) | |
To_State | 13.6.0 | Varchar2(2) | |
Worker_Moved_On | 13.6.0 | Date | |
Workers_Name | 13.6.0 | Varchar2(30) | |
Workers_Relationship | 13.6.0 | Varchar2(20) | |
| Zip | 14.10.0 | Varchar2(50) |