Tool Search: SIF
The current version of SIF is v2.7.
This object contains all the personal information relating to a staff member, who might be a teacher or other employee of the school or district.
SIF_Events are reported for this object.
Object Triggering
| Event Type | Requirement |
|---|---|
| Add | When a person is assigned an district assignment record. |
| Change | Any changes to a staff's Person record. |
| Change | Any changes to a staff's Identity record. |
| Change | Any changes to a staff's District Assignment record and is not excluded based on the zone options. |
| Delete | A deletion to staff's District Assignment record will cause a delete and is not excluded based on the zone options. |
Object Population and Business Rules
| Requirement |
|---|
| Generate only 1 StaffPersonal object regardless of the number of district assignments a staff member has. |
| Report from the latest District Assignment across all schools. |
| Reports when the staff has a district assignment in a non-SIF excluded calendar |
Do NOT report a record if any one of the following scenarios are true:
|
Object Data Elements
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | M, C or O |
| @RefId | The GUID of the staff member. | Person.personID, District.districtGUID | M | ||
| LocalId | The locally-assigned identifier for this staff member. | Census > People > Demographics | Person.staffNumber | M | |
| StateProvinceId | The state-assigned identifier for this staff member. | Census > People > Demographics | Person.staff StateID | O | |
| ElectronicIdList | Electronic identifier(s) associated with this entity. | Optional. Do not Report | O | ||
| OtherIdList | Lists all "other" identifiers associated with the staff member. | O | |||
| OtherIdList/OtherId | Lists an "other" identifier associated with the staff member. | When "Publish Social Security Numbers in StaffPersonal" is selected in Zone Option, then report the SSN | Census > People > Identities | When Type = 0004 = Identity.SSN (with Zone Options checkbox=1) | MR |
| OtherIdList/OtherId/ @Type | Code that defines the type of this other Id. | Hard coded '0004" | M | ||
| Name | Name of the staff member. Note: Type value of 04 must be used here. | M | |||
| Name/@Type | Name of the staff member. Note: Type value of 04 must be used here. | Type value of 04 must be used here. | M | ||
| Name/LastName | The last name. | Census > People > Identities | Identity.lastName | M | |
| Name/FirstName | The first name. | Census > People > Identities | Identity.firstName | M | |
| Name/Suffix | Generation of suffix like II, Jr., etc. | Census > People > Identities | Identity.suffix | O | |
| Name/PreferredName | This is a name that the person prefers to be called by. | Census > People > Identities | Identity.alias | O | |
| Name/SortName | This is the name to be used for sorting purposes. | Last Name, First Name (space) Middle Initial | identity.lastName, identity.firstName, identity.middleName | O | |
| Name/FullName | A free text field for the complete name. | First Name + Middle Name + Last Name | identity.firstName, identity.middleName, identity.lastName | O | |
| OtherNames | Previous, alternate or other names or aliases associated with the staff member. | Optional. Do note Report | O | ||
| Demographics | This element contains information related to staff member demographics. | O | |||
| Demographics/RaceList | O | ||||
| Demographics/RaceList/ Race | MR | ||||
| Demographics/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 > Demographics > Race/Ethnicity | SIFDictionary.code | M |
| Demographics/RaceList/Race/OtherCodeList | O | ||||
Demographics/RaceList/ Race/OtherCodeList/ therCode | 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. | Census > People > Identities | Identity.raceEthnicity, IdentityRaceEthnicity. code | MR | |
Demographics/RaceList/Race/OtherCodeList/ OtherCode/@Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | Where Codeset = StateProvince | Census > People > Identities | Identity.raceEthnicity IdentityRace Ethnicity.code | M |
| Demographics/ HispanicLatino | An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central or South America, or other Spanish cultures, regardless of race. | If Yes, Yes If No, No | Census > People > Demographics > Race/Ethinicty > "Is the invidiual Hispanic/Latino?" | Identity. hispanicEthnicity | O |
| Demographics/Gender | Person's gender. | Census > People > Identities | Identity.gender | O | |
| Demographics/BirthDate | The person's date of birth. | Census > People > Identities | Identity.birthdate | O | |
| Demographics/ PlaceOfBirth | The person's place of birth—like village, town, city etc. | Census > People > Identities | Identity.birthCity | O | |
| Demographics/ StateOfBirth | The person's state of birth. | Reports the SIF-mapped code aligned with the selection in Birth State. If SIF codes are not mapped for Birth State in this district's state, reports Birth State. | Census > People > Identities | Identity.birthState | O |
| Demographics/ CountryOfBirth | The person's country of birth. | When Birth Country = Null, reports US. | Census > People > Identities | Identity. birthCountry | O |
| Demographics/ EnglishProficiency | Person's proficiency in English. | Optional. Do not report | O | ||
| Demographics/ EnglishProficiency/Code | Person's proficiency in English. | Optional. Do not report | SIFDictionary.code | M | |
Demographics/ EnglishProficiency/ OtherCodeList | Optional. Do not report | O | |||
Demographics/ EnglishProficiency/ 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. | Optional. Do not report | MR | ||
Demographics/ EnglishProficiency/ OtherCodeList/ @Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | Where Codeset = StateProvince | Optional. Do not report | M | |
| Demographics/ LanguageList | List of languages an individual uses to communicate. | Language of the person | O | ||
| Demographics/ LanguageList/ Language | Language of the person | MR | |||
| Demographics/ LanguageList/ Language/Code | The code representing the specific language that an individual uses to communicate. | Reports the SIF-mapped code for the selection made in Census > Home Primary Language | identity.home PrimaryLanguage | M | |
Demographics/ LanguageList/ Language/ OtherCodeList | |||||
Demographics/ 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. | Where Codeset = StateProvince | MR | ||
Demographics/ LanguageList/ Language/ OtherCodeList/ @Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | Where Codeset = StateProvince | M | ||
| Title | The staff member's title. | Staff > District Assignment > Title | O | ||
| AddressList | The staff member's address(es). | O | |||
| AddressList/Address | Order address by: 1. Non-secondary 2. Most recent Start Date | MR | |||
| AddressList/Address Type | Report Addresses in the following hierarchy
| M | |||
| AddressList/Address/Street | The street element is a complex element and breaks the street down into several parts. | M | |||
| AddressList/Address/Street/ Line1 | Address line 1. | When address.postOfficeBox = checked, reports "P.O. Box " followed by address.number (e.g. "P.O. Box 1234" When address.postOfficeBox = not checked, reports address.number, prefix, street, tag, and dir separated by spaces | Address.number, .prefix, .street, .tag, .dir | M | |
| AddressList/Address/Street/ Line2 | Address line 2. | Census > Households > Addresses | Address.apt | O | |
| AddressList/Address/Street/ Line3 | Address line 3. | Reports in format: City, ST ZIP | Census > Households > Addresses | Address.city, .state, .zip | O |
| AddressList/Address/Street/StreetNumber | The address number assigned to the building. | Census > Households > Addresses | Address.number | O | |
| AddressList/Address/Street/StreetPrefix | Street prefix like NE | Census > Households > Addresses | Address.prefix | O | |
| AddressList/Address/Street/StreetName | The name of the street. | Census > Households > Addresses | Address.street | O | |
| AddressList/Address/Street/ StreetType | The type of street. For example, Lane, Blvd., Ave., etc. | Census > Households > Addresses | Address.tag | O | |
| AddressList/Address/Street/ StreetSuffix | Street suffix like SW. | Census > Households > Addresses | Address.dir | O | |
| AddressList/Address/Street/ApartmentNumber | Type of apartment, for example, Suite. | Census > Households > Addresses | Address.apt | O | |
| AddressList/ Address/City | The city part of the address. | Census > Households > Addresses | Address.city | M | |
| AddressList/Address/County | The county part of the address. | Census > Households > Addresses | Address.county | O | |
| AddressList/Address/ StateProvince | The state or province code. | Census > Households > Addresses | Address.state | M | |
| AddressList/Address/ Country | The country code. | N/A | default | M | |
| AddressList/Address/ PostalCode | The ZIP/postal code. | Census > Households > Addresses | Address.zip | M | |
| PhoneNumberList | The staff member's phone number(s). | O | |||
| PhoneNumberList/ PhoneNumber | MR | ||||
| 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 | Report 0096 for Main telephone number | M | ||
| PhoneNumberList/ PhoneNumber/ Number | Phone number. Free-form, but typical U.S. formats include: (###) ###-#### or ###-#### | Census > People > Demographics > Personal Contact Information | Contact.workPhone | ||
| EmailList | The staff member's e-mail address(es). | O | |||
| EmailList/Email | The staff member's e-mail address(es). | Census > People > Demographics > Personal Contact Information | Contact.email | MR | |
| EmailList/Email/ @Type | Type of e-mail | Valid values: Primary Alternate1 Alternate2 Alternate3 Alternate4 | M | ||
| EmployeePersonal RefId | Allows for a linkage to the HR/Fin EmployeePersonal object. | Optional. Do not report |
