Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.