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
| 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 | LunchStatusOverride | 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. |