Skip to main content
Skip table of contents

StudentPersonal

The StudentPersonal object is used to publish the Student's Demographic. This object is also used to obtain the Student Testing Number (STN) from the state.

The Oklahoma SMP provides publishing capabilities for the following data object and its elements:

Element/@Attribute

Source

Table

Column

Business Rules

@RefId

 

  

 

LocalId

Database

Students

Student_Number

The locally-assigned identifier for this student.

StateProvinceId

Database

Students

State_StudentNumber

The state-assigned identifier for this student.

OtherIdList/OtherId[@Type="0004"]

Database

Students

SSN

 

Name[@Type='04']/LastName

Database

Students

Last_Name

The student's name.

Name[@Type='04']/FirstName StudentsFirst_Name 
Name[@Type='04']/MiddleName StudentsMiddle_Name 
Name[@Type='04']/FullNameDatabaseStudentsLastFirst 

Demographics/RaceList/Race/Code

Database

StudentRace

RaceCD

The Oklahoma SMP will publish the Federal Race/Ethnicity checkboxes.

Demographics/HispanicLatinoDatabaseStudentsFedEthnicity 
Demographics/GenderDatabaseStudentsGender 
Demographics/BirthDateDatabaseStudentsDOB 
Demographics/StateOfBirthDatabaseS_OK_STU_XBirthState 
Demographics/CountryOfBirthDatabaseS_OK_STU_XBirthCountry 
Demographics/EnglishProficiency/CodeDatabaseS_OK_STU_XELLDefaults to 1633.

Demographics/EnglishProficiency/OtherCodeList/@StateProvince

DatabaseS_OK_STU_X

EnlgishProfOther

Defaults to 'NA'.
Demographics/LanguageList/CodeDatabaseS_OK_STU_XELLLanguageCode 

Demographics/LanguageList/OtherCodeList/@StateProvince

DatabaseS_OK_STU_X

ELLLanguageCode
NAILanguage
ELLLanguageOtherCode

 

When ELLLanguageCode = ‘nai’, then NAILanguage is published. When ELLLanguageCode = ‘mis’, then ELLLanguageOtherCode is published.

Demographics/LanguageList/LanguageTypeDatabaseS_OK_STU_X

LanguageType

Defaults to 1037 if ELLLanguageCode has a value, but LanguageType is blank.

AddressList/Address[@Type='0765']/Street/Line1

Database

Students

 

Street

 

 

AddressList/Address[@Type='0765']/CityDatabaseStudentsCity 
AddressList/Address[@Type='0765']/StateProvinceDatabaseStudentsState 
AddressList/Address[@Type='0765']/CountryDatabaseStudents Hard coded to US.
AddressList/Address[@Type='0765']/PostalCode DatabaseStudentsZip 
AddressList/Address[@Type='0123']/Street/Line1 DatabaseStudentsMailing_Street 
AddressList/Address[@Type='0123']/CityDatabaseStudentsMailing_City 
AddressList/Address[@Type='0123']/StateProvinceDatabaseStudentsMailing_State 
AddressList/Address[@Type='0123']/CountryDatabaseStudents Hard coded to US.
AddressList/Address[@Type='0123']/PostalCodeDatabaseStudentsMailing_Zip 

PhoneNumberList/PhoneNumber[@Type='0096']/Number

Database

Students

Home_Phone

 

PhoneNumberList/PhoneNumber[@Type='0350']/NumberDatabaseStudentsEmerg_Phone_1 

ProjectedGraduationYear

Database

Students

Graduation_Year

 

OnTimeGraduationYear

Database

Students

Sched_YearofGraduation

 

GraduationDate

Database

S_OK_STU_X

GraduationDate

 

Idea

Database

S_OK_STU_X

IDEA

 

Migrant

Database

S_OK_STU_X

Migrant

 

Title1

Database

S_OK_STU_X

Title1

 

GiftedTalented

Database

S_OK_STU_X

Gifted

 

EconomicDisadvantage

Database

S_OK_STU_X

EconomicDisadvantage

 

ELL

Database

S_OK_STU_X

ELL

 

Homeless

Database

S_OK_STU_X

Homeless

 

Section504

Database

S_OK_STU_X

Section504

 

VocationalConcentrator

Database

S_OK_STU_X

VocationalConcentrator

 

Immigrant

Database

S_OK_STU_X

Immigrant

 

NeglectedDelinquent

Database

S_OK_STU_X

Delinquent

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“Bilingual”]

DatabaseS_OK_STU_X

BilingualStatus

Defaults to No.

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“FreeReduced”]

Database

S_OK_STU_X
Students

LunchStatusOverride
LunchStatus

If LunchStatusOverride is populated, then it is published. Otherwise, LunchStatus is used.

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“AltEd”]

Database

S_OK_STU_X

AltEdInd

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“GiftedTalentedIdentified”]

Database

S_OK_STU_X

GiftedTalentedIdentified

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“HomelessPrimaryNightTimeResidence”]

Database

S_OK_STU_X

PrimaryNightTimeRes

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“TechnologicallyLiterate”]

Database

S_OK_STU_X

TechnologicallyLiterate

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“LunchEligibilityDetermination”]

Database

S_OK_STU_X

LunchEligibilityDetermination

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“CoreInd”]

Database

S_OK_STU_X

CoreCurriculum

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“HomelessMcKinneyVento”]

Database

S_OK_STU_X

HomelessMcKinneyVento

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“HomelessUnaccompaniedYouth”]

Database

S_OK_STU_X

HomelessUnaccompaniedYouth

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“NDAtRisk”]

Database

S_OK_STU_X

NDAtRisk

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“NDNeglected”]

Database

S_OK_STU_X

Delinquent

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“NDJuvenileDetention”]

Database

S_OK_STU_X

NDJuvenileCorrections

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“NDJuvenileCorrections”]

Database

S_OK_STU_X

NDJuvenileDetention

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“NDOther”]

Database

S_OK_STU_X

NDOther

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“MSIArmedForces”]

DatabaseS_OK_STU_X

ArmedForces

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“MSIReserve”]

DatabaseS_OK_STU_XReserve 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“MSINationalGuard”]

DatabaseS_OK_STU_X

NationalGuard

 
JavaScript errors detected

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

If this problem persists, please contact our support.