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

 

Students

First_Name

 

Name[@Type='04']/MiddleName

 

Students

Middle_Name

 

Name[@Type='04']/FullName

Database

Students

LastFirst

 

Demographics/RaceList/Race/Code

Database

StudentRace

RaceCD

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

Demographics/HispanicLatino

Database

Students

FedEthnicity

 

Demographics/Gender

Database

Students

Gender

 

Demographics/BirthDate

Database

Students

DOB

 

Demographics/StateOfBirth

Database

S_OK_STU_X

BirthState

 

Demographics/CountryOfBirth

Database

S_OK_STU_X

BirthCountry

 

Demographics/EnglishProficiency/Code

Database

S_OK_STU_X

ELL

Defaults to 1633.

Demographics/EnglishProficiency/OtherCodeList/@StateProvince

Database

S_OK_STU_X

EnlgishProfOther

Defaults to 'NA'.

Demographics/LanguageList/Code

Database

S_OK_STU_X

ELLLanguageCode

 

Demographics/LanguageList/OtherCodeList/@StateProvince

Database

S_OK_STU_X

ELLLanguageCode
NAILanguage
ELLLanguageOtherCode

 

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

Demographics/LanguageList/LanguageType

Database

S_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']/City

Database

Students

City

 

AddressList/Address[@Type='0765']/StateProvince

Database

Students

State

 

AddressList/Address[@Type='0765']/Country

Database

Students

 

Hard coded to US.

AddressList/Address[@Type='0765']/PostalCode 

Database

Students

Zip

 

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

Database

Students

Mailing_Street

 

AddressList/Address[@Type='0123']/City

Database

Students

Mailing_City

 

AddressList/Address[@Type='0123']/StateProvince

Database

Students

Mailing_State

 

AddressList/Address[@Type='0123']/Country

Database

Students

 

Hard coded to US.

AddressList/Address[@Type='0123']/PostalCode

Database

Students

Mailing_Zip

 

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

Database

Students

Home_Phone

 

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

Database

Students

Emerg_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_STU_X

EconomicDisadvantage

 

ELL

Database

S_OK_STU_X

ELL

 

Homeless

Database

S_OK_STU_X

Homeless

Defaults to No.

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”]

Database

S_OK_STU_X

BilingualStatus

Defaults to No.

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“FreeReduced”]

Database

S_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

Defaults to Not Identified as Homeless (NIH)

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“TechnologicallyLiterate”]

Database

S_OK_STU_X

TechnologicallyLiterate

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“LunchEligibilityDetermination”]

Database

S_STU_X

LunchEligibility

 

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”]

Database

S_OK_STU_X

ArmedForces

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“MSIReserve”]

Database

S_OK_STU_X

Reserve

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“MSINationalGuard”]

Database

S_OK_STU_X

NationalGuard

 

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“TribalAffiliation”]

Database

S_STU_X

Tribal_Affiliation_SIF_1

We only send the first Tribal Affiliation based on the state rules.

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“ELIS”]

Database

S_OK_STU_X

EnglishLearnerIntStrategy

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“WeightedGPA”]

Database

ClassRank

GPA

When publishing the GPA, we use the selected GPA Calculation Method that is selected on the School Setup page. If a values exists in the ClassRank table for this student, GPA Method and for this year, the calculated GPA will be published here. If no record exists, or the student is in grade 6 or below, then NA is published.

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“UnWeightedGPA”]

Database

ClassRank

GPA

When publishing the GPA, we use the selected GPA Calculation Method that is selected on the School Setup page. If a values exists in the ClassRank table for this student, GPA Method and for this year, the calculated GPA will be published here. If no record exists, or the student is in grade 6 or below, then NA is published.

SIF_ExtendedElements/SIF_ExtendedElement[@Name=“ClassRank”]

Database

ClassRank

Rank/OutOf

When publishing the ClassRank, we use the selected GPA Calculation Method that is selected on the School Setup page for the Unweighted GPA Method. If a values exists in the ClassRank table for this student, GPA Method and for this year, the Rank and OutOf fields will be published as # out of #. If no record exists, or the student is in grade 6 or below, then NA is published.

JavaScript errors detected

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

If this problem persists, please contact our support.