Staff setup - Demographics

Data Element

Additional Information

[Table]Field Name

Length

Used in these Reports

Name (Last, First MI)

Enter the name.

Note: Use the format: LastName, FirstName MiddleName

[Users]LastFirst

[Users]Last_Name

[Users]First_Name

[Users]Middle_Name

Max 40

Max 20

Max 20

Max 15

DOE_CP

Legal Name (Last First Middle Suffix)

Enter the staff's legal name.

Format: LastName, FirstName, MiddleName, Suffix

[UsersCoreFields]PSCore_Legal_Last_Name

[UsersCoreFields]PSCore_Legal_First_Name

[UsersCoreFields]PSCore_Legal_Middle_Name

[UsersCoreFields]PSCore_Legal_Suffix

75

75

75

10

Preferred Name

The names that staff wants to include in the preferred name.

Email Address

A prefix used to denote the title, degree, position, or seniority of the person.

[Users]Email_Addr

40

DOE-TL

Title

Enter the staff member's title. A prefix used to denote the title, degree, position, or seniority of the person.

[Users]Title

Gender

The staff's gender.

Valid values:

• Male

• Female

• Otherwise: 'Not Selected'

[SchoolStaff]Gender

Legal Gender

Choose the staff's legal gender.

Valid values:

• Male

• Female

[UsersCoreFields]Gender

1

Federal Ethnicity and Race

Ethnicity

Select Yes if the staff is Hispanic or Latino.

If [Users]FedEthnicity = 1: '1'

Otherwise:'0'

1

Race

Select the applicable race:

• White

• Black or African American

• Hispanic

• Asian

• Native Hawaiian or Other Pacific Islander

• American Indian or Alaska Native

[TeacherRace]RaceCd

1:'American Indian - Alaskan Native'
2: 'Black - African American'
3: 'Asian'
5: 'White'
7: 'Native Hawaiian - Pacific Islander'
Case

when u.fedethnicity = 1 then 'Hispanic Ethnicity and of any race'
when (select count(*) from teacherrace tr where tr.teacherid = ss.id) > 1 then 'Multiracial (two or more races)'
else case coalesce(u.ethnicity, (select racecd from teacherrace tr where tr.teacherid = ss.id))
when '1' then 'American Indian - Alaskan Native'
when '2' then 'Black - African American'
when '3' then 'Asian'
when '4' then 'Hispanic Ethnicity and of any race'
when '5' then 'White'
when '6' then 'Multiracial (two or more races)'
when '7' then 'Native Hawaiian - Pacific Islander'
end
end as RaceType

ID

Enter the ID.

[Users]TeacherNumber

Max 20

DOE_CP

StatePrld

Homeroom

If the staff member is a teacher, enter her/his homeroom number.

[Users]Homeroom

Home School

The staff member's home school.

[Users]HomeSchoolID

Lunch ID

Enter the staff member's lunch ID.

[Users]Lunch_ID

Home Phone

Enter the staff member's home phone number.

[Users]Home_Phone

School Phone

Enter the staff member's school phone number.

[Users]School_Phone

Street

Enter the street name of the staff member's address.

[Users]Street

City, State, Zip

Enter the city, state, and Zip code of the staff member's address.

[Users]City

[Users]State

[Users]Zip

SSN

Enter the staff member's social security number.

[Users]SSN

DOB

The staff's date of birth.

[ucf]dob

Staff Type

Select the staff member's role in the district.

[SchoolStaff]StaffStatus

Active

Indicates that the staff member is active.

[SchoolStaff]Status

Exclude from Ed-Fi

Indicate whether the staff is excluded from Ed-Fi publishing.

Valid values:

• Yes

• No

[S_USR_EDFI_X]ExcludeFromEdFi

Termination Date

The date the staff has exited the school. This field is reported as the end date for Staff Assignments if there is no session end date.

[S_IN_USR_X]Termination_Date

10

Years Prior Professional Experience

The number of years of experience of the staff.

This field is no longer published in Staff Demographics

[xt]yearsPriorProfExpericene