This is one of the steps the Ministry Client performs during the School Authority Synchronization with SADS process.

As the School Authority data structure between SADS and PASI are different, the data loaded from SADS is transformed to match the structure of the data within PASI.

SADS Data Structures for School Authority Data	PASI Data Structures for School Authority Data

This information is included within the base School Authority entity.

This field is populated with the value of the org_code attribute from the Org table in SADS.

This field is populated with the value of the tel_item attribute from the OrgTel table in SADS contained in the record meeting the following criteria:

• telty_cd is ‘TL’
• eff_end_dt is the End of Time

This field is populated with the value of the tel_item attribute from the OrgTel table in SADS contained in the record meeting the following criteria:

• telty_cd is ‘FC’
• eff_end_dt is the End of Time

This field is populated with the value of the tel_item attribute from the OrgTel table in SADS contained in the record meeting the following criteria:

• telty_cd is ‘EM’
• eff_end_dt is the End of Time

This field is populated with the value of the lst_mod_ts attribute from the Org table in SADS.

Each school authority is populated with a set of names based on the names available within SADS contained within the OrgNm table in SADS. An Organization Name is created for each associated OrgNm record in SADS that has an eff_end_dt greater than or equal to 2009-01-01.

The Name field is populated with the value of the Corporate Name (contained in the orgnm_corp_nm attribute) if populated within SADS. If a Corporate Name is not defined within SADS (i.e. is null, an empty string, or a string with just spaces), then the school authority’s Legal Name (contained in the orgnm_legal_nm attribute) is used.

The Effective Date field is populated with the value of the eff_start_dt attribute.

Each school authority is populated with a set of Organization Status records based on the records within SADS contained within the OrgStat table in SADS. An Organization Status is created for each associated OrgStat record in SADS that has an eff_end_dt greater than or equal to 2009-01-01 as long as the most recent AudJnl record (based on aj_aud_upd_dt) meeting the following criteria, does not have an aj_op value of D:

• an aj_table_nm of OrgStat
• an aj_parm_3 equal to the value of orgst_id in the OrgStat record

The Is Active field is populated based on the value of the orgstty_cd attribute.

• If the value is A, then Is Active is populated as True.
• If the value is anything other than A, Is Active is populated as False.

The Effective Date is populated with the value of the eff_start_dt attribute.

Each school authority is populated with a set of Authority Classification records based on the records within SADS contained within the OrgAuthCls table in SADS. An Authority Classification record is created for each associated OrgClass record in SADS that has an eff_end_dt greater than or equal to 2009-01-01.

This field is populated with the value of the authcl_id attribute.

This field is populated with the value of the eff_start_dt attribute.

A single Mailing Address record will be created as an Address in PASI based on the record in the OrgAddr table meeting the following criteria:

• eff_end_dt equal to the End of Time, and
• addrty_cd has a value of ML.

The details of the address come from the associated Addr table in SADS.

The field is populated with the value Mailing.

This field is populated based on the value of addr_ln_1 and addr_ln_2.

• If addr_ln_1 is not populated (i.e. is null, an empty string, or a string with just spaces), then Street is populated with the value of addr_ln_2.
• If addr_ln_2 is not populated, then Street is populated with the value of addr_ln_1.
• If both addr_ln_1 and addr_ln_2 are populated within SADS, then Street is populated with the concatenation of addr_ln_1, a Carriage Return and Line Feed, and addr_ln_2.

This field is populated with the value of the muni_nm attribute.

This field is populated with the value of the prov_cd attribute.

This field is populated with the value of the addr_pcd attribute.

This field is populated based on the value of the addr_cntry attribute. If the addr_cntry is a value representing Canada (i.e. CAND, CANA, or CAN) then Country is populated with the value Canada. If the addr_cntry field is any other value, Country is populated with the value of addr_cntry.

This field is populated with the value of eff_start_dt attribute.

This field is populated with the value of the eff_end_dt.

A single Delivery Address record will be created as an Address in PASI based on the record in the OrgAddr table meeting the following criteria:

• eff_end_dt equal to the End of Time, and
• addrty_cd has a value of DL.

The address details are populated in the same fashion as the Mailing Address, except for Address Type which is populated with a value of Delivery.