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 |