S_NC_UID_BATCH_DETAIL ver 13.6.0
This table is a stand alone table that stores detail information about UserID imports performed by the state.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ALTERNATE_ID | 13.6.0 | Varchar2(50) | |
| ALTERNATE_LAST_NAME | 13.6.0 | Varchar2(60) | The alternate last name for the student. |
| ALTERNATE_SOURCE | 13.6.0 | Varchar2(60) | |
| CURRENT_DISTRICT_CODE | 13.6.0 | Varchar2(20) | The district code where the student is currently enrolled. |
| CURRENT_GRADE_LEVEL | 13.6.0 | Varchar2(2) | The current grade level of the student. |
| CURRENT_SCHOOL_CODE | 13.6.0 | Clob | The current school code where the student is enrolled. |
| CURRENT_SCHOOL_CODE_2 | 13.6.0 | Varchar2(20) | |
| CURRENT_SCHOOL_YEAR | 13.6.0 | Varchar2(10) | The current school year. |
| CUSTOMER_DEFINED_FIELD_1 | 13.6.0 | Varchar2(25) | |
| CUSTOMER_DEFINED_FIELD_2 | 13.6.0 | Varchar2(25) | |
| CUSTOMER_DEFINED_FIELD_3 | 13.6.0 | Varchar2(25) | |
| CUSTOMER_DEFINED_FIELD_4 | 13.6.0 | Varchar2(25) | |
| CUSTOMER_DEFINED_FIELD_5 | 13.6.0 | Varchar2(25) | |
| CUSTOMER_DEFINED_FIELD_6 | 13.6.0 | Varchar2(25) | |
| CUSTOMER_DEFINED_FIELD_7 | 13.6.0 | Varchar2(25) | |
| CUSTOMER_DEFINED_FIELD_8 | 13.6.0 | Varchar2(25) | |
| DOB | 13.6.0 | Varchar2(10) | The student Date of birth. |
| ERROR_DETAIL | 13.6.0 | Varchar2(255) | |
| ETHNICITY_INDICATOR | 13.6.0 | Varchar2(4) | The Hispanic/Latino code for the student. |
| FIRST_NAME | 13.6.0 | Varchar2(60) | The student's first name. |
| GENDER | 13.6.0 | Varchar2(6) | The student's gender. |
| ID | 13.6.0 | Number(11,0) | Primary key |
| LAST_NAME | 13.6.0 | Varchar2(60) | The student's last name. |
| LOCAL_STUDENT_ID | 13.6.0 | Varchar2(20) | The local student Number. |
| MIDDLE_NAME | 13.6.0 | Varchar2(60) | The student's middle name. |
| NAME_SUFFIX | 13.6.0 | Varchar2(10) | The generation description for the student. |
| RACE_2_CODE | 13.6.0 | Varchar2(10) | Indicates a second race code if applicable. |
| RACE_3_CODE | 13.6.0 | Varchar2(10) | Indicates a third race code if applicable. |
| RACE_4_CODE | 13.6.0 | Varchar2(10) | Indicates a fourth race code if applicable. |
| RACE_5_CODE | 13.6.0 | Varchar2(10) | Indicates a fifth race code if applicable. |
| RACE_ETHNICITY | 13.6.0 | Varchar2(10) | The student's first race code. |
| RECORD_REFERENCE_Number | 13.6.0 | Varchar2(12) | |
| RECORD_STATUS | 13.6.0 | Varchar2(255) | |
| RECORD_TYPE | 13.6.0 | Clob | |
| RECORD_TYPE_2 | 13.6.0 | Varchar2(2) | |
| RECORD_UPDate_Date | 13.6.0 | Varchar2(10) | |
| RESERVED_BOOLEAN | 13.6.0 | Number(1,0) | |
| RESERVED_Date | 13.6.0 | Date | |
| RESERVED_DOUBLE | 13.6.0 | Number(25,10) | |
| RESERVED_INTEGER | 13.6.0 | Number(11,0) | |
| RESERVED_STRING | 13.6.0 | Varchar2(100) | |
| RESIDENT_DISTRICT_CODE | 13.6.0 | Clob | |
| RESIDENT_DISTRICT_CODE_2 | 13.6.0 | Varchar2(20) | |
| SSN | 13.6.0 | Varchar2(11) | Indicates the social security Number of the student. |
| STATE_ID | 13.6.0 | Varchar2(25) | Indicates the state student Number of the student. |
| S_NC_UID_BATCH_LOGID | 13.6.0 | Number(11,0) |