Resource Overview
-
Ed-Fi endpoint:
/data/v3/staffEducationOrganizationContactAssociations -
Published view/entity: Staff Contact Data
-
Purpose: Staff contact data including emails and telephones
-
Source query:
StaffEduOrgContactAssociation -
Dependencies: No resource dependency is declared.
Primary PowerSchool Source Data
-
[Users]
-
[S_USR_X]
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
contactTitle |
DistrictContactID |
Conditional |
Staging rule: staffEduOrgContact CST_PUBWORKFLOW.formatLEADistrictIDBase(p_profileid, 0, 0, 'districtnumber', 1) |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: DistrictContactID. |
|
educationOrganizationReference.educationOrganizationId |
DistrictContactID |
Y |
Staging rule: staffEduOrgContact CST_PUBWORKFLOW.formatLEADistrictIDBase(p_profileid, 0, 0, 'districtnumber', 1) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: DistrictContactID. |
|
staffReference.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. |
|
address.addressTypeDescriptor |
AddressType_DX |
Y |
Staging rule: staffEduOrgContact 'Physical' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: AddressType_DX. |
|
address.apartmentRoomSuiteNumber |
AptRoomSuiteNumber |
Conditional |
Publishing framework or supporting query Query alias: AptRoomSuiteNumber |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: AptRoomSuiteNumber. |
|
address.buildingSiteNumber |
BuildingSiteNumber |
Conditional |
Publishing framework or supporting query Query alias: BuildingSiteNumber |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: BuildingSiteNumber. |
|
address.streetNumberName |
StreetNumberName |
Y |
[Users]Street |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StreetNumberName. |
|
address.city |
City |
Y |
[Users]City |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: City. |
|
address.nameOfCounty |
NameOfCounty |
Conditional |
Publishing framework or supporting query Query alias: NameOfCounty |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: NameOfCounty. |
|
address.countyFIPSCode |
CountyFIPSCode |
Conditional |
Publishing framework or supporting queryQuery alias: CountyFIPSCode |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: CountyFIPSCode. |
|
address.stateAbbreviationDescriptor |
StateAbbreviation_DX |
Y |
[Users]State; Ttransformation: case when CST_PUBWORKFLOW_LIB.isValidStateProvCode(p_profileid, trim(u.State)) = 'Y' then trim(u.State) else null end |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StateAbbreviation_DX. |
|
address.postalCode |
PostalCode |
Y |
[Users]Zip |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: PostalCode. |
|
address.latitude |
Latitude |
Conditional |
Publishing framework or supporting query Query alias: Latitude |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: Latitude. |
|
address.longitude |
Longitude |
Conditional |
Publishing framework or supporting query Query alias: Longitude |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: Longitude. |
|
address.doNotPublishIndicator |
DoNotPublishIndicator |
Conditional |
Publishing framework or supporting query Query alias: DoNotPublishIndicator |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: DoNotPublishIndicator. |
|
address.periods[].beginDate |
AddressBeginDate |
Y |
Publishing framework or supporting query Query alias: AddressBeginDate |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: AddressBeginDate. |
|
address.periods[].endDate |
AddressEndDate |
Y |
Publishing framework or supporting query Query alias: AddressEndDate |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: AddressEndDate. |
|
address.localeDescriptor |
Locale_DX |
Conditional |
Publishing framework or supporting query Query alias: Locale_DX |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: Locale_DX. |
|
address.congressionalDistrict |
CongressionalDistrict |
Conditional |
Publishing framework or supporting query Query alias: CongressionalDistrict |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: CongressionalDistrict. |
|
contactTypeDescriptor |
ContactType_DX |
Conditional |
Staging rule: staffEduOrgContact null |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: ContactType_DX. |
|
electronicMailAddress |
EmailAddress |
Y |
[Users]Email_Addr |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: EmailAddress. |
|
telephones[].telephoneNumberTypeDescriptor |
TelephoneNumberType1_DX |
Y |
Staging rule: staffEduOrgContact 'Mobile' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: TelephoneNumberType1_DX. |
|
telephones[].doNotPublishIndicator |
DoNotPublish1 |
Conditional |
Staging rule: staffEduOrgContact 0 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: DoNotPublish1. |
|
telephones[].orderOfPriority |
OrderOfPriority1 |
Conditional |
Publishing framework or supporting query Query alias: OrderOfPriority1 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: OrderOfPriority1. |
|
telephones[].telephoneNumber |
TelephoneNumber1 |
Y |
[S_USR_X]Cell_phone |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: TelephoneNumber1. |
|
telephones[].textMessageCapabilityIndicator |
TextMessageCapable1 |
Conditional |
Staging rule: staffEduOrgContact 1 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: TextMessageCapable1. |
|
telephones[].telephoneNumberTypeDescriptor |
TelephoneNumberType2_DX |
Y |
Staging rule: staffEduOrgContact 'Work' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: TelephoneNumberType2_DX. |
|
telephones[].doNotPublishIndicator |
DoNotPublish2 |
Conditional |
Staging rule: staffEduOrgContact 0 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: DoNotPublish2. |
|
telephones[].orderOfPriority |
OrderOfPriority2 |
Conditional |
Publishing framework or supporting query Query alias: OrderOfPriority2 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: OrderOfPriority2. |
|
telephones[].telephoneNumber |
TelephoneNumber2 |
Y |
[S_USR_X]Cell_Phone; [Users]School_Phone; Transformation: case when (NVL(usrx.cell_phone,'X') != NVL(u.school_phone,'Y')) then trim(regexp_replace(regexp_substr(u.school_phone, '[^,a-zA-Z]+'),'[^0-9() \-]')) else null end |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: TelephoneNumber2. |
|
telephones[].textMessageCapabilityIndicator |
TextMessageCapable2 |
Conditional |
Staging rule: staffEduOrgContact 0 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: TextMessageCapable2. |
|
telephones[].telephoneNumberTypeDescriptor |
TelephoneNumberType3_DX |
Y |
Publishing framework or supporting query Query alias: TelephoneNumberType3_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: TelephoneNumberType3_DX. |
|
telephones[].doNotPublishIndicator |
DoNotPublish3 |
Conditional |
Publishing framework or supporting query Query alias: DoNotPublish3 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: DoNotPublish3. |
|
telephones[].orderOfPriority |
OrderOfPriority3 |
Conditional |
Publishing framework or supporting query Query alias: OrderOfPriority3 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: OrderOfPriority3. |
|
telephones[].telephoneNumber |
TelephoneNumber3 |
Y |
Publishing framework or supporting query Query alias: TelephoneNumber3 |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: TelephoneNumber3. |
|
telephones[].textMessageCapabilityIndicator |
TextMessageCapable3 |
Conditional |
Publishing framework or supporting query Query alias: TextMessageCapable3 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: TextMessageCapable3. |