S_WI_STU_WISE_X (ver 16.10.1)
This table is an extension of the [Students] table. This table provides WISEid-specific fields for Wisconsin.
Column Name | Version | Data Type | Description |
---|---|---|---|
StudentsDCID | 16.10.1 | Number(10,0) | Primary Key. |
Alias_Fname | 16.10.1 | Varchar2(70) | Other First Name. |
Alias_Lname | 16.10.1 | Varchar2(70) | Other Last Name. |
Alias_Mname | 16.10.1 | Varchar2(70) | Other Middle Name. |
Alias_Suffix | 16.10.1 | Varchar2(20) | Other Suffix (I, II, III, IV, V, Sr, Jr, SJ). |
Birth_City | 16.10.1 | Varchar2(60) | Birth City. |
Birth_County | 16.10.1 | Varchar2(40) | Birth County. |
Birth_State | 16.10.1 | Varchar2(4) | Birth State. |
Multiple_Birth_Status | 19.5.1.0 | Varchar2(1) | Multiple Birth Indicator. |
Name_Suffix | 16.10.1 | Varchar2(5) | Suffix (I, II, III, IV, V, Sr, Jr, SJ). |
Guardian2_FN | 16.10.1 | Varchar2(70) | Secondary Parent/Guardian First Name. |
Guardian2_LN | 16.10.1 | Varchar2(70) | Secondary Parent/Guardian Last Name. |
Guardian2_MN | 16.10.1 | Varchar2(70) | Secondary Parent/Guardian Middle Name. |
Guardian2_Rel | 16.10.1 | Varchar2(5) | Secondary Parent/Guardian Relationship (F=Father, M=Mother, G=Guardian, O=Other). |
No_Release | 16.10.1 | Number(1,0) | No Location Release data element indicates that a person is part of a privacy program protecting the person's location. Obsoleted in 19.5.1.0. |
LocateAssgn_Date | 16.10.1 | Date | WSLS - Locate/Assign (SSL) Date Sent. |
EUT_Date | 16.10.1 | Date | WSLS - Exit Update Transaction (EUT) Date Sent. |
SSL_Date | 16.10.1 | Date | WSLS - School Student Load (SSL) Date Sent. |