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 |
---|---|---|---|---|---|
@RefId | The Id (GUID) of this record. | Generated by Infinite Campus. | person.personId | M | |
@SIF_RefId | The GUID of an associated object, either StudentRecordExchange or StudentPersonal. | Reports the GUID of associated student. | person.personId | M | |
@SIF_RefObject | The associated object type. | M | |||
ReportingDate | The date this record was prepared. | reports today's date | M | ||
StudentPersonalData | Collects elements of interest from StudentPersonal. | M | |||
StudentPersonalData/LocalId | Reports the Student Number | Census > People > Demographics > Student Number when Student Number is not Null. Otherwise does not report the element. | person.studentNumber | O | |
StudentPersonalData/StateProvinceId | The state-assigned identifier for this student. | Reports the Student State Id | Census > People > Demographics > Student State Id when Student State Id is not Null. Otherwise does not report the element. | person.stateId | O |
StudentPersonalData/SSN | Reports the Student's SSN | Census > People > Demographics > Social Security Number when Social Security Number is not Null. Otherwise does not report the element. | identity.ssn | O | |
StudentPersonalData/OtherIdList | Lists all "other" identifiers associated with the student. | Optional. Does not Report. | O | ||
StudentPersonalData/Name | Name of the student. Note: Type value of 04 must be used here. | M | |||
StudentPersonalData/Name/@Type | Code that specifies what type of name this is. | Reports "04" | M | ||
StudentPersonalData/Name/LastName | Last name | Reports the student's Last Name | Census> People> Identities | identity.lastName | M |
StudentPersonalData/Name/FirstName | First name | Reports the student's First Name | Census> People> Identities | identity.firstName | M |
StudentPersonalData/Name/MiddleName | Middle name | Reports the student's Middle Name if not Null. Otherwise does not report the element. | Census> People> Identities | identity.middleName | O |
StudentPersonalData/Name/Suffix | Generation of suffix like II, Jr, | Reports the student's suffix if not Null. Otherwise does not report the element. | Census> People> Identities | identity.suffix | O |
StudentPersonalData/Name/PreferredName | This is a name that the person prefers to be called by. | Reports the student's nickname if not Null. Otherwise does not report | Census> People> Identities | identity.alias | O |
StudentPersonalData/Name/SortName | This is the name to be used for sorting purposes. | Last Name, Last Name (space) Middle Initial | Last Name, Last Name + Middle Initial | identity.lastName , identity.firstName + identity.Middle Name | O |
StudentPersonalData/Name/FullName | A free text field for the complete name | First Name + Middle Name + Last Name | First Name + Middle Name + Last Name | identity.firstName + identity.Middle Name + identity.lastName | O |
StudentPersonalData/OtherNames | Previous, alternate or other names or aliases associated with the student. | Optional. Does not Report. | O | ||
StudentPersonalData/DemographicsData | Collects 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> Identities | raceEthnicity.code | M |
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.raceEthnicity | MR | ||
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 Gender | Census> People> Identities | identity.gender | O | |
StudentPersonalData/DemographicsData/BirthDate | Reports person's date of birth | Census> People> Identities | identity.birthDate | O | |
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 Language | Census> People> Identities | identity.homePrimaryLanguage | M | |
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 Language | Census> People> Identities | identity.homePrimaryLanguage | MR |
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> Identities | identity.hispanicEthnicity | O | |
StudentPersonalData/DemographicsData/ CountryOfBirth | When Birth Country is blank, reports "US" | Census> People> Identities | identity.birthCountry | O | |
StudentPersonalData/DemographicsData/ DwellingArrangement | Setting/environment in which the person resides. | Optional. Does not Report | O | ||
StudentPersonalData/AddressList | The 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 @Type | Code 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.
| Census > Households > Addresses | address.postOfficeBox householdlocation.private householdmember.private | M |
StudentPersonalData/AddressList/Address/Street | The 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 > Addresses | address.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 > Addresses | address.postOfficeBox address.number address.prefix address.street address.tag address.dir | M |
StudentPersonalData/AddressList/AddressList/ Address/Street/Line2 | Address line 2. | Census > Households > Addresses | address.apt | O | |
StudentPersonalData/AddressList/AddressList/ Address/Street/Line3 | Address line 3. | address.city, address.state + address.zip | Census > Households > Addresses | address.city address.state address.zip | O |
StudentPersonalData/AddressList/AddressList/ Address/Street/StreetNumber | The address number assigned to the building. | Census > Households > Addresses | address.number | O | |
StudentPersonalData/AddressList/AddressList/ Address/Street/StreetPrefix | Street prefix like NE | Census > Households > Addresses | address.prefix | O | |
StudentPersonalData/AddressList/AddressList/ Address/Street/StreetName | The name of the street | Census > Households > Addresses | address.street | O | |
StudentPersonalData/AddressList/AddressList/ Address/Street/StreetType | The type of street. For example, Lane, Blvd., Ave., etc. | Census > Households > Addresses | address.tag | O | |
StudentPersonalData/AddressList/AddressList/ Address/Street/StreetSuffix | Street suffix like SW. | Census > Households > Addresses | address.dir | O | |
StudentPersonalData/AddressList/AddressList/ Address/Street/ApartmentNumber | The number of the apartment. | Census > Households > Addresses | address.apt | O | |
StudentPersonalData/AddressList/AddressList/ Address/City | The city part of the address. | Census > Households > Addresses | address.city | M | |
StudentPersonalData/AddressList/AddressList/ County | The county part of the address. | Census > Households > Addresses | address.county | M | |
StudentPersonalData/AddressList/AddressList/ Address/StateProvince | The state or province code. | Census > Households > Addresses | address.state | M | |
StudentPersonalData/AddressList/AddressList/ Address/Country | The country code. | Hardcoded to "US" | M | ||
StudentPersonalData/AddressList/AddressList/ Address/PostalCode | The ZIP/postal code. | Census > Households > Addresses | address.zip | M | |
StudentPersonalData/PhoneNumberList | Lists 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 > Phone | household.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 > Phone | household.phone contact.cellPhone contact.workPhone | M |
StudentPersonalData/IDEA | Is the student IDEA-eligible ("special education")? (Mutually exclusive with Section 504 classification.) |
| Student Information > Special Ed Student Information > Special Ed > State Reporting | plan.startDate SpecialEDState.startDate SpecialEDState.endDate Enrollment.specialEdStatus | O |
StudentPersonalData/Migrant | Is this a migrant student? |
| Student Information> Program Participation> Migrant Student Information> General> Enrollments | enrollment.migrant migrant.lastQualifyingArrivalDate | O |
StudentPersonalData/Title1 | Is the student in Title 1 programs? |
| Student Information> Program Participation> Title1 Student Information> General> Enrollments System Administration> Resources> School> Title 1 | enrollment.title1 title1.startDate title1.endDate | O |
StudentPersonalData/GiftedTalented | Is the student in Gifted/Talented programs? |
| Student Information> Program Participation> Gifted Student Information> General> Enrollments | enrollment.giftedTalented gifted.startDate | O |
StudentPersonalData/EconomicDisadvantage | Does the student meet the State criteria for classification as having an economic disadvantage? |
| posEligibility.eligibility | O | |
StudentPersonalData/ELL | Is the student an English Language Learner under Title 3? |
| Student Information> Program Participation> ELL Student Information> General> Enrollments | lep.identifiedDate lep.exitDate | O |
StudentPersonalData/Homeless | Is the student homeless? |
| Student Information> Program Participation> Homeless Student Information> General> Enrollments | enrollment.homeless homeless.startDate homeless.endDate | O |
StudentPersonalData/Section504 | Is the student a qualified individual under Section 504 of the Rehabilitation Act? (Mututally exclusive with IDEA classification |
| Student Information> Program Participation> Section504 Student Information> General> Enrollments | enrollment.Section504 Section504.startDate Section504.endDate | O |
StudentPersonalData/VocationalConcentrator | Does the student meet the State criteria for classification as a vocational concentrator? |
| Program Admin > Programs > Academic Programs Student Information > Academic Planning > Programs Student Information> General> Enrollments | Program.cte ProgramParticipation.startDate ProgramParticipation.endDate Enrollment.vocationalCode | O |
StudentPersonalData/Immigrant | Does the student meet the State criteria for classification as being an immigrant? |
| enrollment.immigrant | O | |
StudentPersonalData/NeglectedDelinquent | Is the student participating in programs for neglected, delinquent, or at risk children? |
| 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 |
StudentContactsSummary | Reports 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/ParentGuardian1 | First parent/guardian. | M | |||
StudentContactsSummary/ParentGuardian1/Name | The 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 name | The Last Name of the guardian | Census> People> Identities | relatedPair.name identity.lastName | M |
StudentContactsSummary/ParentGuardian1/ Name/FirstName | The first name | The First Name of the guardian | Census> People> Identities | relatedPair.name identity.firstName | M |
StudentContactsSummary/ParentGuardian1/ PhoneNumberList | Optional. Do not report. | O | |||
StudentContactsSummary/ParentGuardian1/ AddressList | Optional. Do not report. | O | |||
StudentContactsSummary/ParentGuardian2 | Second 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 guardian | The Last Name of the second guardian | relatedPair.name identity.lastName | M | |
StudentContactsSummary/ParentGuardian2/ Name/FirstName | The First Name of the second guardian | The 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 |