SIF v2.7 - StaffPersonal

Classic View: System Administration > Data Utilities > SIF

Search Term: SIF 

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
AddWhen a person is assigned an district assignment record.
ChangeAny 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.
DeleteA 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:  

  1. If the record is being triggered from a District Assignment record and it is marked as Exclude

  2. If the record is being triggered from a District Assignment record and the School is marked as Exclude (note: this will be addressed later for all Objects)

  3. If Exclude checkbox is checked in Zone Option, exclude StaffPersonal whose District Assignments are Excluded


 Object Data Elements

Data Element LabelDescriptionBusiness RulesData Source GUI PathDatabase FieldM, C or O
@RefIdThe GUID of the staff member.

Person.personID, District.districtGUIDM
LocalIdThe locally-assigned identifier for this staff member.
Census > People > DemographicsPerson.staffNumberM
StateProvinceIdThe state-assigned identifier for this staff member.
Census > People > DemographicsPerson.staff
StateID
O
ElectronicIdListElectronic identifier(s) associated with this entity.Optional. Do not Report

O
OtherIdListLists all "other" identifiers associated with the staff member.


O
OtherIdList/OtherIdLists 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 > IdentitiesWhen 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
NameName of the staff member. Note: Type value of 04 must be used here.


M
Name/@TypeName of the staff member. Note: Type value of 04 must be used here.Type value of 04 must be used here.

M
Name/LastNameThe last name.
Census > People > IdentitiesIdentity.lastNameM
Name/FirstNameThe first name.
Census > People > IdentitiesIdentity.firstNameM
Name/SuffixGeneration of suffix like II, Jr., etc.
Census > People > IdentitiesIdentity.suffixO
Name/PreferredNameThis is a name that the person prefers to be called by.
Census > People > IdentitiesIdentity.aliasO
Name/SortNameThis is the name to be used for sorting purposes.Last Name, First Name (space) Middle Initial
identity.lastName, identity.firstName, identity.middleNameO
Name/FullNameA free text field for the complete name.First Name + Middle Name + Last Name
identity.firstName, identity.middleName, identity.lastNameO
OtherNamesPrevious, alternate or other names or aliases associated with the staff member.Optional. Do note Report

O
DemographicsThis element contains information related to staff member demographics.


O
Demographics/RaceList



O
Demographics/RaceList/
Race




MR
Demographics/RaceList/Race/CodeThe 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/EthnicitySIFDictionary.codeM
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 > IdentitiesIdentity.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 = StateProvinceCensus > People > IdentitiesIdentity.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/GenderPerson's gender.
Census > People > IdentitiesIdentity.genderO
Demographics/BirthDateThe person's date of birth.
Census > People > IdentitiesIdentity.birthdateO
Demographics/
PlaceOfBirth
The person's place of birth—like village, town, city etc.
Census > People > IdentitiesIdentity.birthCityO
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 > IdentitiesIdentity.birthStateO
Demographics/
CountryOfBirth
The person's country of birth.When Birth Country = Null, reports US.Census > People > IdentitiesIdentity.
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 reportSIFDictionary.codeM

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 = StateProvinceOptional. 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
TitleThe staff member's title.
Staff > District Assignment > Title
O
AddressListThe 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
  1. Report Primary before secondary
    • If the Primary address is NOT active, report the secondary household with the latest End Date
  2. If above is tied, then in order of start date
  3. If above is tied, then in order of MemberID 
    • When a staff does not have a HouseholdMembership that overlaps today's date, then report the address for the staff's HouseholdMembership with latest end date before today's date.
    • If the staff has no past HouseholdMemberships, report blank.
    • Do not report addresses where Private is checked
  4. The AddressType should be unique for a student
  5. Do not report more than 5 addresses for a staff
  6. For each reported address: 
    • Reports "0123" when address.postOfficeBox = checked on the staff's household.
      Reports "0765" for the first non-secondary address.
      Reports "1073" for the first secondary address.
      Subsequent addresses report "2382", then "0124", then "1074", and then "1075" for the remaining addresses
    • Do not report more than one P.O.Box.


M
AddressList/Address/StreetThe 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 > AddressesAddress.aptO
AddressList/Address/Street/
Line3
Address line 3.Reports in format: City, ST ZIPCensus > Households > AddressesAddress.city, .state, .zipO
AddressList/Address/Street/StreetNumberThe address number assigned to the building.
Census > Households > AddressesAddress.numberO
AddressList/Address/Street/StreetPrefixStreet prefix like NE
Census > Households > AddressesAddress.prefixO
AddressList/Address/Street/StreetNameThe name of the street.
Census > Households > AddressesAddress.streetO
AddressList/Address/Street/
StreetType
The type of street. For example, Lane, Blvd., Ave., etc.
Census > Households > AddressesAddress.tagO
AddressList/Address/Street/
StreetSuffix
Street suffix like SW.
Census > Households > AddressesAddress.dirO
AddressList/Address/Street/ApartmentNumberType of apartment, for example, Suite.
Census > Households > AddressesAddress.aptO
AddressList/
Address/City
The city part of the address.
Census > Households > AddressesAddress.cityM
AddressList/Address/CountyThe county part of the address.
Census > Households > AddressesAddress.countyO
AddressList/Address/
StateProvince
The state or province code.
Census > Households > AddressesAddress.stateM
AddressList/Address/
Country
The country code.
N/AdefaultM
AddressList/Address/
PostalCode
The ZIP/postal code.
Census > Households > AddressesAddress.zipM
PhoneNumberListThe 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 objectsReport 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 InformationContact.workPhone
EmailListThe staff member's e-mail address(es).


O
EmailList/EmailThe staff member's e-mail address(es).
Census > People > Demographics > Personal Contact InformationContact.emailMR
EmailList/Email/
@Type
Type of e-mailValid values:
Primary
Alternate1
Alternate2
Alternate3
Alternate4


M
EmployeePersonal
RefId
Allows for a linkage to the HR/Fin EmployeePersonal object.Optional. Do not report