This object is linked to the School Info object via SchoolRefid and requires a school to be defined in Powerschool to have a generated RefID. This is used to provide demographic, race, address, and Maine-specific extended elements about the Student for Connect. Students excluded from state reporting are not published. Students with the same entry/exit date are not published.
The following data object and its elements are published:
|
Element |
Source |
Table |
Column |
Business Rules |
|
@RefId |
SIF Agent |
CST_PUBPUBLISHED_TMP |
SUPPORTINGKEYS |
SIF reference ID generated from the staged published record. |
|
StateProvinceId |
Database Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > State Student ID |
STUDENTS |
STATE_STUDENTNUMBER |
Published only when populated; otherwise blank. |
|
Name/Type |
Derived |
STUDENTS; STUDENTCOREFIELDS |
FIRST_NAME, MIDDLE_NAME, LAST_NAME; PSCORE_LEGAL_FIRST_NAME, PSCORE_LEGAL_LAST_NAME |
PreferredGivenName when both preferred and legal names exist; FullName when only preferred name exists. |
|
Name/FirstName |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > First Name; Start Page > Student Selection > Maine Legal Info > Legal Info tab > Legal Identifications > Legal First Name |
STUDENTCOREFIELDS; STUDENTS |
PSCORE_LEGAL_FIRST_NAME; FIRST_NAME |
Legal first name is used first; falls back to student first name. |
|
Name/LastName |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Last Name; Start Page > Student Selection > Maine Legal Info > Legal Info tab > Legal Identifications > Legal Last Name |
STUDENTCOREFIELDS; STUDENTS |
PSCORE_LEGAL_LAST_NAME; LAST_NAME |
Legal last name is used first; falls back to student last name. |
|
Demographics/RaceList/Race/Code/value |
Database Navigation path: Start Page > Student Selection > General Demographics > Race/Ethnicity |
STUDENTRACE |
RACECD |
Race codes are translated: W/C=White, A=Asian, B=BlackOrAfricanAmerican I=AmericanIndianOrAlaskaNative P=NativeHawaiianOrOtherPacificIslander |
|
Demographics/HispanicLatino/value |
Database Navigation path: Start Page > Student Selection > General Demographics > Federal Ethnicity |
STUDENTS |
FEDETHNICITY |
0 maps to N; 1 maps to Y. |
|
Demographics/Gender/value |
Database Navigation path: Start Page > Student Selection > General Demographics > Gender; Start Page > Student Selection > Maine Legal Info > Legal Info tab > Legal Identifications > Gender |
STUDENTCOREFIELDS; STUDENTS |
PSCORE_LEGAL_GENDER; GENDER |
Legal gender is used first; M=Male, F=Female, N=NotSelected; otherwise, the stored value is passed through. |
|
Demographics/BirthDate |
Database Navigation path: Start Page > Student Selection > General Demographics > Date of Birth |
STUDENTS |
DOB |
Formatted as YYYY-MM-DD. |
|
AddressList/Address/Type |
Constant |
|
|
Physical address type is always Physical. |
|
AddressList/Address/Street/Line1 |
Database Navigation path: Start Page > Student Selection > Student address fields > Physical Address > Street |
STUDENTS |
STREET |
Student physical street line 1. |
|
AddressList/Address/City |
Database Navigation path: Start Page > Student Selection > Student address fields > Physical Address > City |
STUDENTS |
CITY |
Student physical city. |
|
AddressList/Address/StateProvince/value |
Database Navigation path: Start Page > Student Selection > Student address fields > Physical Address > State |
STUDENTS |
STATE |
Student physical state. |
|
AddressList/Address/PostalCode |
Database Navigation path: Start Page > Student Selection > Student address fields > Physical Address > Zip |
STUDENTS |
ZIP |
Hyphens are removed, value is limited to first five digits, then left-padded to five digits. |
|
AddressList/Address[Mailing]/Type |
Derived |
STUDENTS |
MAILING_STREET, MAILING_CITY, MAILING_STATE, MAILING_ZIP |
Mailing address is published only when all mailing address fields are populated; type is Mailing. |
|
AddressList/Address[Mailing]/Street/Line1 |
Database Navigation path: Start Page > Student Selection > Student address fields > Mailing Address > Street |
STUDENTS |
MAILING_STREET |
Published only when complete mailing address exists. |
|
AddressList/Address[Mailing]/City |
Database Navigation path: Start Page > Student Selection > Student address fields > Mailing Address > City |
STUDENTS |
MAILING_CITY |
Published only when complete mailing address exists. |
|
AddressList/Address[Mailing]/StateProvince/value |
Database Navigation path: Start Page > Student Selection > Student address fields > Mailing Address > State |
STUDENTS |
MAILING_STATE |
Published only when complete mailing address exists. |
|
AddressList/Address[Mailing]/PostalCode |
Database Navigation path: Start Page > Student Selection > Student address fields > Mailing Address > Zip |
STUDENTS |
MAILING_ZIP |
Published only when complete mailing address exists; hyphens are removed, value is limited to first five digits, then left-padded to five digits. |
|
SIF_ExtendedElements/FirstEntryDateIntoUSSchool |
Database Navigation path: Start Page > Student Selection > Maine English Learner Information > English Learner tab > US School Date |
S_ME_STU_X; S_STU_X |
USSCHOOLDATE; ENTRYDATEINTOUSSCHOOL |
Maine value is used first; falls back to core extension value; date is formatted as YYYY-MM-DD and omitted when blank. |
|
SIF_ExtendedElements/NativeLanguage |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language |
S_ME_STU_X |
HOMELANGUAGECODE |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/NativeInterpreter |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language Interpreter |
S_ME_STU_X |
NATIVELANGINTERPRETER_YN |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/NativeLanguage2 |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language 2 |
S_ME_STU_X |
NATIVELANGUAGECODE2 |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/NativeInterpreter2 |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language 2 Interpreter |
S_ME_STU_X |
NATIVELANGINTERPRETER_YN2 |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/NativeLanguage3 |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language 3 |
S_ME_STU_X |
NATIVELANGUAGECODE3 |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/NativeInterpreter3 |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language 3 Interpreter |
S_ME_STU_X |
NATIVELANGINTERPRETER_YN3 |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/NativeLanguage4 |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language 4 |
S_ME_STU_X |
NATIVELANGUAGECODE4 |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/NativeInterpreter4 |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language 4 Interpreter |
S_ME_STU_X |
NATIVELANGINTERPRETER_YN4 |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/NativeLanguage5 |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language 5 |
S_ME_STU_X |
NATIVELANGUAGECODE5 |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/NativeInterpreter5 |
Database Navigation path: Start Page > Student Selection > Maine Personal Information > Personal tab > Personal Information > Native Language 5 Interpreter |
S_ME_STU_X |
NATIVELANGINTERPRETER_YN5 |
Extended element is emitted only when the value is populated. |
|
SIF_ExtendedElements/MLStartDate |
Database Navigation path: Start Page > Student Selection > Maine English Learner Information > English Learner tab > EL Start Date |
S_ME_STU_X |
ENGLISHLEARNERSTARTDATE |
Date is formatted as YYYY-MM-DD; extended element is emitted only when the value is populated. |