Core SIF - StudentDemographicRecord

Tool Search: SIF

The current version of SIF is v2.7.

This object conveys a student's demographic data for student record exchange and transcript purposes.

This object is designed to be a dual-purpose object. It can be linked to a Studeent Record Exchange object for record exchange purposes. There may also be Zones where systems can provide this information for record exchange systems or general informational purposes, in which case the object can be linked directly to Student Personal.

SIF_Events are NOT reported for this object.

Object Triggering

SIF Events are NOT reported for this object

Object Population and Business Rules

Requirements
The district belongs to the same calendar and year assigned to the SIF Zone.
Exclude All Secondary Enrollments (zone options)
Exclude State Exclude (zone options)
Exclude No Show (regardless of zone options)
Grade Level > Exclude From SIF Reporting
Calendar "SIF Exclude"

Follow SIF Zone Options Rules for Zones:

Do Not Report when the Calendar > 'Exclude from SIF Exchange' is selected.

Object Data Elements

Data Element Label
Description
Business Rules
Data Source GUI Path
Database
Field
M, C or O
@RefIdThe Id (GUID) of this record.Generated by Infinite Campus.
person.personIdM
@SIF_RefIdThe GUID of an associated object, either StudentRecordExchange or StudentPersonal.Reports the GUID of associated student.
person.personIdM
@SIF_RefObjectThe associated object type.


M
ReportingDateThe date this record was prepared.reports today's date

M
StudentPersonalDataCollects elements of interest from StudentPersonal.


M
StudentPersonalData/LocalId
Reports the Student NumberCensus > People > Demographics > Student Number when Student Number is not Null. Otherwise does not report the element.person.studentNumberO
StudentPersonalData/StateProvinceIdThe state-assigned identifier for this student.Reports the Student State IdCensus > People > Demographics > Student State Id when Student State Id is not Null. Otherwise does not report the element.person.stateIdO
StudentPersonalData/SSN
Reports the Student's SSNCensus > People > Demographics > Social Security Number when Social Security Number is not Null. Otherwise does not report the element.identity.ssnO
StudentPersonalData/OtherIdListLists all "other" identifiers associated with the student.Optional. Does not Report.

O
StudentPersonalData/NameName of the student. Note: Type value of 04 must be used here.


M
StudentPersonalData/Name/@TypeCode that specifies what type of name this is.Reports "04"

M
StudentPersonalData/Name/LastNameLast nameReports the student's Last NameCensus> People> Identitiesidentity.lastNameM
StudentPersonalData/Name/FirstNameFirst name Reports the student's First NameCensus> People> Identitiesidentity.firstNameM
StudentPersonalData/Name/MiddleNameMiddle name Reports the student's Middle Name if not Null. Otherwise does not report the element.Census> People> Identitiesidentity.middleNameO
StudentPersonalData/Name/SuffixGeneration of suffix like II, Jr,Reports the student's suffix if not Null. Otherwise does not report the element.Census> People> Identitiesidentity.suffixO
StudentPersonalData/Name/PreferredNameThis is a name that the person prefers to be called by.Reports the student's nickname if not Null. Otherwise does not reportCensus> People> Identitiesidentity.aliasO
StudentPersonalData/Name/SortNameThis is the name to be used for sorting purposes.Last Name, Last Name (space) Middle InitialLast Name, Last Name + Middle Initialidentity.lastName , identity.firstName + identity.Middle NameO
StudentPersonalData/Name/FullNameA free text field for the complete nameFirst Name + Middle Name + Last NameFirst Name + Middle Name + Last Nameidentity.firstName + identity.Middle Name + identity.lastNameO
StudentPersonalData/OtherNamesPrevious, alternate or other names or aliases associated with the student.Optional. Does not Report.

O
StudentPersonalData/DemographicsDataCollects elements of interest from Demographics.


O
StudentPersonalData/DemographicsData/RaceList



O

StudentPersonalData/DemographicsData/

RaceList/Race


Reports for each of the races in the person's current identity record

MR

StudentPersonalData/DemographicsData/RaceList/

Race/Code

The general racial category which reflects the individual's recognition of his or her community or with which the individual most identifies

Reports the SIF race code mapped to the race:

When American Indian or Alaska Native, report 0998

When Asian, report 0999

When Black or African American, report 1000

When Native Hawaiian or Other Pacific Islander, report 1001

When White, report 1002

Census> People> IdentitiesraceEthnicity.codeM

StudentPersonalData/DemographicsData/RaceList/

Race/OtherCodeList





O

StudentPersonalData/DemographicsData/RaceList/

Race/OtherCodeList/OtherCode

A state/province code, local code, other code or a text string that crosswalks to or serves as a translation of an associated Code element.

identity.raceEthnicityMR

StudentPersonalData/DemographicsData/RaceList/

Race/OtherCodeList/ @Codeset

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.Reports "StateProvince"

M
StudentPersonalData/DemographicsData/Gender
Reports Person's GenderCensus> People> Identitiesidentity.genderO
StudentPersonalData/DemographicsData/BirthDate

Reports person's date of birth

Census> People> Identitiesidentity.birthDateO

StudentPersonalData/DemographicsData/

EnglishProficiency

Person's proficiency in English. Optional. Do Not Report.

O

StudentPersonalData/DemographicsData/

LanguageList

List of languages an individual uses to communicate. Requires an entry in Home Primary Language

O

StudentPersonalData/DemographicsData/

LanguageList/Language





MR

StudentPersonalData/DemographicsData/

LanguageList/Language/Code


Reports the SIF-mapped code for the selection made in Census > Home Primary LanguageCensus> People> Identitiesidentity.homePrimaryLanguageM

StudentPersonalData/DemographicsData/

LanguageList/Language/OtherCodeList





O

StudentPersonalData/DemographicsData/

LanguageList/Language/OtherCodeList/OtherCode

A state/province code, local code, other code or a text string that crosswalks to or serves as a translation of an associated Code element.Report the Code selected in Census > Home Primary LanguageCensus> People> Identitiesidentity.homePrimaryLanguageMR

StudentPersonalData/DemographicsData/

LanguageList/Language/OtherCodeList/@Codeset

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.Reports "StateProvince"

M

StudentPersonalData/DemographicsData/

HispanicLatino


When Yes, Yes.
When No, No
Census> People> Identitiesidentity.hispanicEthnicityO

StudentPersonalData/DemographicsData/

CountryOfBirth


When Birth Country is blank, reports "US"Census> People> Identitiesidentity.birthCountryO

StudentPersonalData/DemographicsData/

DwellingArrangement

Setting/environment in which the person resides.Optional. Does not Report

O
StudentPersonalData/AddressListThe address of the student.


O
StudentPersonalData/AddressList/Address
A collection of the addresses that exist for the student.
Orders address by:
1. Non-secondary
2. Most recent Start Date
Census > Households > Addresses
MR
StudentPersonalData/AddressList/Address @TypeCode that defines the location of the address. Note: A subset of specific valid values for each instance in a data object may be listed in that object

Matches StudentPersonal elements.

  1. Report Addresses in the following hierarchy
    1. Report Primary Household before Secondary Household
      1. If more than 1 Primary Households address then report in order of start date
    2. If above is tied, then report in order of MemberID 
      1. When a student does not have a HouseholdMembership that overlaps today's date, then report the address for the student's HouseholdMembership with latest end date before today's date.
      2. If the student has no past HouseholdMemberships, report blank.
      3. Do not report addresses where Private is checked
    3. The AddressType should be unique for a student
    4. Do not report more than 5 addresses for a student
    5. For each reported address: 
      1. Reports "0123" when address.postOfficeBox = checked on the student's household.
      2. Reports "0765" for the first non-secondary address.
      3. Reports "1073" for the first secondary address.
      4. Subsequent addresses report "2382", then "0124", then "1074", and then "1075" for the remaining addresses
    6. Do not report more than one P.O.Box.
      1. In multiple Primary Household scenarios
        1. Report in order of Household start date
        2. If above is tied, then report in order of MemberID 
Census > Households > Addresses

address.postOfficeBox
householdLocation.secondary


householdlocation.private

householdmember.private

M
StudentPersonalData/AddressList/Address/StreetThe street element is a complex element and breaks the street down into several parts.When address.postOfficeBox = checked, reports "P.O. Box" + address.number
When address.postOfficeBox NOT = checked, reports address.number + address.prefix + address.street + address.tag + address.dir
Census > Households > Addressesaddress.postOfficeBox
address.number
address.prefix
address.street
address.tag
address.dir
M

StudentPersonalData/AddressList/AddressList/

Address/Street/Line1

Address line 1.When address.postOfficeBox = checked, reports "P.O. Box" + address.number
When address.postOfficeBox NOT = checked, reports address.number + address.prefix + address.street + address.tag + address.dir
Census > Households > Addressesaddress.postOfficeBox
address.number
address.prefix
address.street
address.tag
address.dir
M

StudentPersonalData/AddressList/AddressList/

Address/Street/Line2

Address line 2.
Census > Households > Addressesaddress.aptO

StudentPersonalData/AddressList/AddressList/

Address/Street/Line3

Address line 3.address.city, address.state + address.zipCensus > Households > Addressesaddress.city
address.state
address.zip
O

StudentPersonalData/AddressList/AddressList/

Address/Street/StreetNumber

The address number assigned to the building.
Census > Households > Addressesaddress.numberO

StudentPersonalData/AddressList/AddressList/

Address/Street/StreetPrefix

Street prefix like NE
Census > Households > Addressesaddress.prefixO

StudentPersonalData/AddressList/AddressList/

Address/Street/StreetName

The name of the street
Census > Households > Addressesaddress.streetO

StudentPersonalData/AddressList/AddressList/

Address/Street/StreetType

The type of street. For example, Lane, Blvd., Ave., etc.
Census > Households > Addressesaddress.tagO

StudentPersonalData/AddressList/AddressList/

Address/Street/StreetSuffix

Street suffix like SW.
Census > Households > Addressesaddress.dirO

StudentPersonalData/AddressList/AddressList/

Address/Street/ApartmentNumber

The number of the apartment.
Census > Households > Addressesaddress.aptO

StudentPersonalData/AddressList/AddressList/

Address/City

The city part of the address.
Census > Households > Addressesaddress.cityM

StudentPersonalData/AddressList/AddressList/

County

The county part of the address.
Census > Households > Addressesaddress.countyM

StudentPersonalData/AddressList/AddressList/

Address/StateProvince

The state or province code.
Census > Households > Addressesaddress.stateM

StudentPersonalData/AddressList/AddressList/

Address/Country

The country code.
Hardcoded to "US"
M

StudentPersonalData/AddressList/AddressList/

Address/PostalCode

The ZIP/postal code.
Census > Households > Addressesaddress.zipM
StudentPersonalData/PhoneNumberListLists phone numbers associated with an entity.Reports the household phone, and either cell phone or work phone

O

StudentPersonalData/PhoneNumberList/

PhoneNumber





MR

StudentPersonalData/PhoneNumberList/

PhoneNumber/ @Type

Code that specifies what type of phone number this is. Note: A subset of valid values may be specified in data objects.When household.phone is not null, reports "0096"
When contact.cellPhone or contact.workPhone is not null, reports "0350"
Census > Households > Phonehousehold.phone
contact.cellPhone
contact.workPhone
M

StudentPersonalData/PhoneNumberList/

PhoneNumber/Number

Phone number. Free-form, but typical U.S. formats include:Reports household.phone.
When contact.cellPhone is not null, reports this number first. Otherwise reports contact.workPhone
Census > Households > Phonehousehold.phone
contact.cellPhone
contact.workPhone
M
StudentPersonalData/IDEAIs the student IDEA-eligible ("special education")? (Mutually exclusive with Section 504 classification.)
  1. When the student has a locked IEP where the Start Date is null or on or before today's date, and the End Date is null or on or after today's date, then report "Yes".
  2. When the student has a record in Special Ed > State Reporting (SpecialEDState table) where the Start Date is null or on or before today's date, and the End Date is null or on or after today's date, then report "Yes".
  3. When Enrollment.specialEdStatus is NOT equal to any of the following: null, "N", "", "0", or "00", then report "Yes".
  4. Otherwise report "No"

Student Information > Special Ed 


Student Information > Special Ed > State Reporting

plan.startDate 

SpecialEDState.startDate

SpecialEDState.endDate

Enrollment.specialEdStatus

O
StudentPersonalData/MigrantIs this a migrant student?
  1. When the student has a Migrant record where the Last Qualifying Arrival Date is null or on or before today's date, and the Eligibility Expiration Date is null or on or after today's date, then report "Yes".
  2. When Enrollment.migrant is NOT equal to any of the following: null, "N", "", "0", or "00", then report "Yes".
  3. Otherwise report "No"

Student Information> Program Participation> Migrant


Student Information> General> Enrollments

enrollment.migrant

migrant.lastQualifyingArrivalDate

O
StudentPersonalData/Title1Is the student in Title 1 programs?
  1. When the latest School History record for this school with an effective date on or before today's date has Title 1 = "Targeted Assistance Eligible - No Program", "Schoolwide Eligible - No Program", or "Not a Title I School", report "No".
  2. When the latest School History record for this school with an effective date on or before today's date has Title 1 = "Schoolwide Program", report "Yes".
  3. Title 1 Tab if the Title 1 tab is active
    1. When the student has a Title1 record where the Start Date is on or before today's date, and the End Date is null or on or after today's date, then report "Yes".
  4. Otherwise, when enrollment.title1 is null, "N", "", "0", or "00", report "No".
    1. Otherwise report "Yes".
  5. Otherwise, report "No"

Student Information> Program Participation> Title1

Student Information> General> Enrollments

System Administration> Resources> School> Title 1

enrollment.title1

title1.startDate

title1.endDate

O
StudentPersonalData/GiftedTalentedIs the student in Gifted/Talented programs?
  1. When the student has a Gifted & Talented record where the Start Date is on or before today's date, and the End Date is null or on or after today's date, then report "Yes".
  2. When Enrollment.giftedTalented is NOT equal to any of the following: null, "N", "", "0", or "00", then report "Yes".
  3. Otherwise report "No"

Student Information> Program Participation> Gifted 

Student Information> General> Enrollments

enrollment.giftedTalented 

gifted.startDate

O
StudentPersonalData/EconomicDisadvantageDoes the student meet the State criteria for classification as having an economic disadvantage?
  1. When the student has an active FRAM record with Eligibility = Free or Reduced, reports "Yes".
  2. Otherwise report  "No".


posEligibility.eligibilityO
StudentPersonalData/ELLIs the student an English Language Learner under Title 3?
  1. When the student has an active EL record, reports "Yes".
  2. Otherwise, report "No".

Student Information> Program Participation> ELL

Student Information> General> Enrollments

lep.identifiedDate
lep.exitDate
O
StudentPersonalData/HomelessIs the student homeless?
  1. When the student has a Homeless record where the Start Date is on or before today's date, and the End Date is null or on or after today's date, then report "Yes".
  2. When Enrollment.homeless is NOT equal to any of the following: null, "N", "", "0", or "00", then report "Yes".
  3. Otherwise report "No"

Student Information> Program Participation> Homeless

Student Information> General> Enrollments

enrollment.homeless

homeless.startDate

homeless.endDate

O
StudentPersonalData/Section504Is the student a qualified individual under Section 504 of the Rehabilitation Act? (Mututally exclusive with IDEA classification
  1. When the student has a Section 504 record where the Start Date is on or before today's date, and the End Date is null or on or after today's date, then report "Yes".
  2. When Enrollment.section504 is NOT equal to any of the following: null, "N", "", "0", or "00", then report "Yes".
  3. Otherwise report "No"

Student Information> Program Participation> Section504

Student Information> General> Enrollments

enrollment.Section504

Section504.startDate

Section504.endDate

O
StudentPersonalData/VocationalConcentratorDoes the student meet the State criteria for classification as a vocational concentrator?
  1. When the student has an Academic Program with a Program Type of CTE where the Start Date is on or before today's date, and the End Date is null or on or after today's date, then report "Yes".
  2. When Enrollment.vocationalCode is NOT equal to any of the following: null, "N", "", "0", or "00", then report "Yes".
  3. Otherwise report "No"

Program Admin > Programs > Academic Programs

Student Information > Academic Planning > Programs

Student Information> General> Enrollments

Program.cte

ProgramParticipation.startDate

ProgramParticipation.endDate

Enrollment.vocationalCode

O
StudentPersonalData/ImmigrantDoes the student meet the State criteria for classification as being an immigrant?
  1. When immigrant is null, "N", "", "0", or "00", report "No".
  2. Otherwise report "Yes".

enrollment.immigrantO
StudentPersonalData/NeglectedDelinquentIs the student participating in programs for neglected, delinquent, or at risk children?
  1. Report if the Title 1 tab is active and has a Title 1 Program of "Title 1 Part D - Neglected, Delinquent or At Risk"
    1. When the student has a "Title 1 Part D - Neglected, Delinquent or At Risk" record where the Start Date is on or before today's date, and the End Date is null or on or after today's date, then report "Yes".
  2. CustomStudent
    1. When value of the CustomStudent.value attribute is null, "N", "", "0", or "00", report "No".
    2. Otherwise report "Yes".
  3. Otherwise, report "No".

Student Information> Program Participation> Title 1>Title 1 Part D - Neglected, Delinquent

System Administration> Resources> School> Title 1

CustomStudent.value = NY

title1.title1PartDProgram = ID

Title1.startDate

Title1.endDate

O
StudentContactsSummaryReports up to two parents/guardians of the student.Reports based on the following priority when the guardian exists on a student household:
1. Father
2. Mother
3. Other guardians


O
StudentContactsSummary/ParentGuardian1First parent/guardian.


M
StudentContactsSummary/ParentGuardian1/NameThe Name element, which could belong to a student, staff member, contact, etc. 


M

StudentContactsSummary/ParentGuardian1/

Name @Type

Code that specifies what type of name this is. If unsure, use 04.Reports "04"

M

StudentContactsSummary/ParentGuardian1/

Name/LastName

The last nameThe Last Name of the guardianCensus> People> IdentitiesrelatedPair.name
identity.lastName
M

StudentContactsSummary/ParentGuardian1/

Name/FirstName

The first nameThe First Name of the guardianCensus> People> IdentitiesrelatedPair.name
identity.firstName
M

StudentContactsSummary/ParentGuardian1/

PhoneNumberList


Optional. Do not report.

O

StudentContactsSummary/ParentGuardian1/

AddressList


Optional. Do not report.

O
StudentContactsSummary/ParentGuardian2Second parent/guardian.


O
StudentContactsSummary/ParentGuardian2/Name



M

StudentContactsSummary/ParentGuardian2/

Name @Type

Code that specifies what type of name this is. If unsure, use 04.Reports "04"

M

StudentContactsSummary/ParentGuardian2/

Name/LastName

The Last Name of the second guardianThe Last Name of the second guardian
relatedPair.name
identity.lastName
M

StudentContactsSummary/ParentGuardian2/

Name/FirstName

The First Name of the second guardianThe First Name of the second guardian
relatedPair.name
identity.firstName
M

StudentContactsSummary/ParentGuardian2/

PhoneNumberList


Optional. Do not report

O

StudentContactsSummary/ParentGuardian2/

AddressList


Optional. Do not report

O