Resource Overview
-
Ed-Fi endpoint:
/data/v3/staffs -
Published view/entity: Staff
-
Purpose: Staff demographic data
-
Source query:
Staff -
Dependencies:
staffEducationOrganizationEmploymentAssociations
This resource represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. This resource is required for all Staff and Teachers.
Primary PowerSchool Source Data
-
[Users]
-
[S_TN_USR_X]
-
[TeacherRace]
Selection Criteria
Records are published if the following criteria are met:
-
StaffUniqueId must be populated in PowerSchool.
-
The staff member must not be excluded from state reporting.
-
The staff member is not designated as Lunch Staff or Substitute.
-
The staff member has an assignment in the school year for the term selected in the PowerSchool UI.
Note: On a staff member’s publishing page - Staff > Data Exchange > Publishing, district administrators can use the new "Publish All Records" button to automatically publish new and updated records for all staff related resources, such as Staff Demographics, Staff Education Organization Employment Assignment, Staff Education Organization Assignment Association, Staff Section Association. This ensures that admins do not have to publish each staff resource individually to push updates to the ODS.
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
staffUniqueId |
StaffUID |
Y |
[Users]DCID; Transformation: EDFI_TN_LIB.getStaffUniqueId(p_profileid, u.dcid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StaffUID. |
|
personalTitlePrefix |
PersonalTitlePrefix |
Conditional |
[Users]Title |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: PersonalTitlePrefix. |
|
firstName |
FirstName |
Y |
[Users]First_name |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: FirstName. |
|
middleName |
MiddleName |
Conditional |
[Users]Middle_name |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: MiddleName. |
|
lastSurname |
LastName |
Y |
[Users]Last_name; Transformation: trim( case when CST_PUBWORKFLOW_LIB.getGenerationSuffix(p_profileid, u.last_name) is null then u.last_name else substr(trim(u.last_name), 1, instr(trim(u.last_name), ' ', -1)) end ) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LastName. |
|
generationCodeSuffix |
GenerationCodeSuffix |
Conditional |
[S_TN_USR_X]LICNAME_EDFI_YN; [S_TN_USR_X]LIC_LNAME; [S_TN_USR_X]NameSuffix; [Users]Last_name; Transformation: case when xt.LICNAME_EDFI_YN =1 and xt.LIC_LNAME is not null then coalesce( trim(xt.NameSuffix), CST_PUBWORKFLOW_LIB.getGenerationSuffix(p_profileid, xt.LIC_LNAME)) else coalesce( trim(xt.NameSuffix), CST_PUBWORKFLOW_LIB.getGenerationSuffix(p_profileid, u.last_name)) end |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: GenerationCodeSuffix. |
|
maidenName |
MaidenName |
Conditional |
Publishing framework or supporting query Query alias: MaidenName |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: MaidenName. |
|
sexDescriptor |
Sex_DX |
Conditional |
[Userscorefields]Gender; transformation: case when uc.gender='F' then 'Female' when uc.gender='M' then 'Male' else 'Not Selected' end |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: Sex_DX. |
|
birthDate |
BirthDate |
Conditional |
[SchoolStaff]Id; [Users]DCID; Transformation: to_char( CST_PUBWORKFLOW_LIB.getDateFromMDY( coalesce( ps_customfields.getcf('teachers', ss.id, 'DOB'), (select max(ps_customfields.getcf('teachers', ss1.id, 'DOB')) from SchoolStaff ss1 where ss1.Users_DCID = u.DCID) ) ), 'YYYY-MM-DD' ) |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: datetime. Query alias: BirthDate. |
|
citizenshipStatusDescriptor |
CitizenshipStatus_DX |
Conditional |
Publishing framework or supporting query Query alias: CitizenshipStatus_DX |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: CitizenshipStatus_DX. |
|
highlyQualifiedTeacher |
HighlyQualifiedTeacher |
Conditional |
Publishing framework or supporting query Query alias: HighlyQualifiedTeacher |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: HighlyQualifiedTeacher. |
|
highestCompletedLevelOfEducationDescriptor |
LevelOfEducation_DX |
Conditional |
Publishing framework or supporting query Query alias: LevelOfEducation_DX |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: LevelOfEducation_DX. |
|
hispanicLatinoEthnicity |
HispanicLatinoEthnicity |
Conditional |
[Users]FedEthnicity; Transformation: case u.FedEthnicity when 1 then '1' else '0' end |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: HispanicLatinoEthnicity. |
|
credentials[].credentialReference.credentialIdentifier |
CredentialIdentifier |
Y |
[S_TN_USR_X]LicenseNumber; Transformation: Case when secDet.Cnt > 0 then lpad(to_char(xt.LicenseNumber), 9, '0') else null end |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: CredentialIdentifier. |
|
credentials[].credentialReference.stateOfIssueStateAbbreviationDescriptor |
StateOfIssueAbbrev_DX |
Y |
Staging rule: Staffs 'TN' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StateOfIssueAbbrev_DX. |
|
oldEthnicityDescriptor |
OldEthnicity_DX |
Conditional |
[Users]Ethnicity; Transformation: CST_PUBWORKFLOW_LIB.getEthnicityType(p_profileid, g.name, u.ethnicity) |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: OldEthnicity_DX. |
|
otherNames[].otherNameTypeDescriptor |
OtherNameType_DX |
Y |
Publishing framework or supporting query Query alias: OtherNameType_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: OtherNameType_DX. |
|
otherNames[].personalTitlePrefix |
OtherNamePrefix |
Conditional |
Publishing framework or supporting query Query alias: OtherNamePrefix |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: OtherNamePrefix. |
|
otherNames[].firstname |
OtherNameFirst |
Y |
Publishing framework or supporting query Query alias: OtherNameFirst |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: OtherNameFirst. |
|
otherNames[].middlename |
OtherNameMiddle |
Conditional |
Publishing framework or supporting query Query alias: OtherNameMiddle |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: OtherNameMiddle. |
|
otherNames[].lastSurname |
OtherNameLast |
Y |
Publishing framework or supporting query Query alias: OtherNameLast |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: OtherNameLast. |
|
otherNames[].generationCodeSuffix |
OtherNameSuffix |
Conditional |
Publishing framework or supporting query Query alias: OtherNameSuffix |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: OtherNameSuffix. |
|
personalIdentificationDocuments[].identificationDocumentUseDescriptor |
IdentDocUse1_DX |
Y |
Publishing framework or supporting query Query alias: IdentDocUse1_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: IdentDocUse1_DX. |
|
personalIdentificationDocuments[].personalInformationVerificationDescriptor |
IdentDocPersInfoVer1_DX |
Y |
Publishing framework or supporting query Query alias: IdentDocPersInfoVer1_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: IdentDocPersInfoVer1_DX. |
|
personalIdentificationDocuments[].documentTitle |
IdentDocTitle1 |
Conditional |
Publishing framework or supporting query Query alias: IdentDocTitle1 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: IdentDocTitle1. |
|
personalIdentificationDocuments[].issuerName |
IdentDocIssuerName1 |
Conditional |
Publishing framework or supporting query Query alias: IdentDocIssuerName1 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: IdentDocIssuerName1. |
|
races[].raceDescriptor |
Race_DX |
Y |
[TeacherRace]Racecd; Transformation: case when tr.racecd in ('A', 'AS') then 'Asian' when tr.racecd in ('B', 'BL') then 'Black - African American' when tr.racecd in ('I', 'AM') then 'American Indian - Alaska Native' when tr.racecd in ('P', 'PI') then 'Native Hawaiian - Pacific Islander' when tr.racecd in ('W', 'WH') then 'White' end |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: Race_DX. |
|
tribalAffiliations[].tribalAffiliationDescriptor |
TribalAffiliation1_DX |
Y |
Publishing framework or supporting query Query alias: TribalAffiliation1_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: TribalAffiliation1_DX. |
|
yearsOfPriorProfessionalExperience |
YearsPriorProfessional |
Conditional |
Publishing framework or supporting query Query alias: YearsPriorProfessional |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: YearsPriorProfessional. |
|
yearsOfPriorTeachingExperience |
YearsPriorTeaching |
Conditional |
Publishing framework or supporting query Query alias: YearsPriorTeaching |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: YearsPriorTeaching. |