S_AL_STU_Custom_X ver 19.11.1.0
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentSDCID | 19.11.1.0 | Number(19,0) | The primary key that relates the extended table back to the Students table. |
Accepted_Act_Military_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student was accepted for Active Military Duty. |
Act_Attainment_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student attained appropriate ACT scores. |
Act_Military_Family_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student is from an Active Duty Military Family. |
Address_County | 19.11.1.0 | Number(11,0) | The county in which the student lives. |
AP_Attainment_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student attained Advanced Placement. |
Athlete_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student is an athlete. |
Birth_Cert_Country | 20.10.2.0 | Number(11,0) | The country in which the student was born, according to their birth certificate. |
Birth_Cert_Verification | 19.11.1.0 | Number(11,0) | The state in which the student was born, according to their birth certificate. |
Birth_Certificate | 19.11.1.0 | Varchar2(30) | The student's Birth Certificate number. |
Career_Tech_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student is part of a Career Tech program. |
Col_Credit_Attain_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student has attained College Credit. |
ISENRICHMENT_TF | 21.8.2.0 | NUMBER(1,0) | Indicates Is Enrichment |
DECE_ASAP_ID | 21.4.2.0 | Varchar2(7) | To collect DECE ASAP ID value. |
RESIDES_OUT_OF_DISTRICT | 21.4.2.0 | Number(1,0) | Indicates whether the student is Resides out of District. |
Foreign_Exchange | 20.3.2.0 | Number(1,0) | Indicates whether the student is a Foreign Exchange student. |
Guard_RES_Military_Fam_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student is from a Guard or Reserve Military Family. |
IB_Attainment_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student attained the International Baccalaureate (IB) program |
IsTution_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student is funded by tuition. |
Mailing_Address_County | 19.11.1.0 | Number(11,0) | The student's mailing address County. |
Medicaid_TF | 20.10.2.0 | Number(1,0) | Indicates whether the student is on Medicaid |
STATEISSUED | 20.6.2.0 | NUMBER(11,0) | Indicates State Issued for students |
Non_Trad_School_Type | 19.11.1.0 | Number(11,0) | The student's non-traditional school type. |
Original_Enrollment_Date | 20.3.2.0 | Date | The student's original enrollment date. |
Other_Edu_Barrier_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student has an educational barrier. |
ParentDeclined_TF | 20.10.2.0 | Number(1,0) | Indicates whether the student's parent has declined their identified population. |
Single_Parent_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student is raised by a single parent. |
Student_Language | 20.3.2.0 | Number(40,0) | The student's Language. |
WorkKeys_Attainment_TF | 19.11.1.0 | Number(1,0) | Indicates whether the student successfully completed a WorkKeys assessment. |
ROADTEST_GRADE | 22.5.1.0 | Number(11,0) | Indicates grade of student in road test |
ROADTEST_PASS_FAIL | 22.5.1.0 | Varchar2(10) | Indicates whether student has passed/failed in road test |
ROADTEST_TEST_DATE | 22.5.1.0 | Date | Indicates date on which student took road test |
VESSELTEST_GRADE | 22.5.1.0 | Number(11,0) | Indicates grade of student in vessel test |
DRIVERSLICENSEORPERMIT | 20.6.2.0 | VARCHAR2(20) | Indicates Driver License For Permit |
VESSELTEST_PASS_FAIL | 22.5.1.0 | Varchar2(10) | Indicates whether student has passed/failed in vessel test |
VESSELTEST_TEST_DATE | 22.5.1.0 | Date | Indicates date on which student took vessel test |
WAIVER_TYPE | 22.5.1.0 | Varchar2(50) | Indicates the waiver type |
WAIVERFORMDATE | 22.5.1.0 | Date | Indicates the waiver date |
GRADUATION_EXIT_TYPE | 22.5.1.0 | Varchar2(50) | Indicates the exit type of graduation for a student |
GRADUATIONDATE | 22.6.1.0 | Date | Indicates graduation date of student |
KNOWLEDGETEST_GRADE | 22.8.2.0 | Varchar2(10) | Indicates grade of student in knowledge test |
KNOWLEDGETEST_PASS_FAIL | 22.8.2.0 | Number(11,0) | Indicates whether student has passed/failed in knowledge test |
KNOWLEDGETEST_TEST_DATE | 22.8.2.0 | Date | Indicates date on which student took knowledge test |
ADDRESS_COUNTY_OLD | 23.1.2.0 | NUMBER(11,0) | Read only field to retain address county value |
MAILING_ADDRESS_COUNTY_OLD NUMBER | 23.1.2.0 | NUMBER(11,0) | Read only field to retain mailing address county value |
ESSENTIALS_COMPLETER | 23.11.2.0 | Boolean | Essentials Completer |
ALT_ACHIEV_COMPLETER | 23.11.2.0 | Boolean | Alternate Achievement Completer |
DATA_SHARING_OPTIN | 24.4.2.0 | Boolean | Opt-in to have credentials and skills shared with state-approved third-party vendor |
STU_NONPUBLIC_TF | 24.11.2.0 | Boolean | Student transferred in from a nonpublic educational institution |
YEAROFTRANSFER | 24.11.2.0 | NUMBER(11,0) | Year of Transfer |