StudentSchoolEnrollment

Element

Source

Table

Column

Business Rules

@RefId

SIF Agent

CST_PUBPUBLISHED_TMP

SUPPORTINGKEYS

SIF reference ID generated from the staged enrollment record.

StudentPersonalRefId

SIF Agent

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_1

References the staged StudentPersonal record.

SchoolInfoRefId

SIF Agent

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_2

References the staged SchoolInfo record.

MembershipType

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Enrollment Type Code; Start Page > Student Selection > Re-Enroll Student workflow > Maine State Information > Enrollment Type Code

S_ME_STU_X; S_ME_REN_X

ENROLLMENTTYPE

P maps to Primary; S maps to Secondary. Student rows use S_ME_STU_X; reenrollment rows use S_ME_REN_X.

TimeFrame

Constant

Always Current.

SchoolYear

Runtime

p_yearid

Published as p_yearid + 1991.

EntryDate

Database

Navigation path: Start Page > Student Selection > Transfer Info / Edit Current Enrollment > Entry Date; Start Page > Student Selection > Re-Enroll Student workflow > Maine State Information > Effective Date

STUDENTS; REENROLLMENTS

ENTRYDATE

Formatted as YYYY-MM-DD. Student rows use STUDENTS; reenrollment rows use REENROLLMENTS.

EntryType/Code/value

Constant

Always 09999.

EntryType/OtherCodeList/OtherCode/value

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Start Status; Start Page > Student Selection > Re-Enroll Student workflow > Maine State Information > Start Status

S_ME_STU_X; S_ME_REN_X

ENROLLMENTSTARTSTATUS

Published as the state-province entry status.

EntryType/OtherCodeList/OtherCode/Codeset

Constant

Always StateProvince.

GradeLevel/Code/value

Database

Navigation path: Start Page > Student Selection > Transfer Info / Edit Current Enrollment > Grade Level; Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Grade Level Code Override

S_ME_STU_X; S_ME_REN_X; STUDENTS; REENROLLMENTS

GRADELEVELCODE; GRADE_LEVEL

State grade override is used first; otherwise grade 0 maps to KG, negative grades map to PK, and other grades are left-padded to two digits.

ExitDate

Derived

Note: Future Dates are not published unless an ME Exit Type Code is provided.

STUDENTS; REENROLLMENTS

ENTRYDATE, EXITDATE, EXITCODE, ENROLL_STATUS

Calculated through SIF_ME_LIB.getPublishEnrollmentExitDate and formatted as YYYY-MM-DD.

ExitType/Code/value

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Exit Type; Start Page > Student Selection > Re-Enroll Student workflow > Maine State Information > Exit Type Code

S_ME_STU_X; S_ME_REN_X

ENROLLMENTEXITTYPE

Published from the enrollment exit type extension.

ExitType/OtherCodeList/OtherCode/value

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Exit Type; Start Page > Student Selection > Re-Enroll Student workflow > Maine State Information > Exit Type Code

S_ME_STU_X; S_ME_REN_X

ENROLLMENTEXITTYPE

Same state-province exit type value is emitted in OtherCode.

ExitType/OtherCodeList/OtherCode/Codeset

Constant

Always StateProvince.

FTPTStatus/value

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Full Time Part Time Status Codes (FTPT); Start Page > Student Selection > Transfer Out/Edit Enrollment workflow > Maine State Information > Full Time Part Time Status Codes (FTPT)

S_ME_STU_X; S_ME_REN_X

PERCENTAGESCHOOLDAYCODE

Null values are published as 0.

ResidencyStatus/Code/value

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Residency Status; Start Page > Student Selection > Re-Enroll Student workflow > Maine State Information > Residency Status

S_ME_STU_X; S_ME_REN_X

FISCALRESPONSIBILITY

Published as the residency status code.

ResidencyStatus/OtherCodeList/OtherCode/value

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Residency Status; Start Page > Student Selection > Re-Enroll Student workflow > Maine State Information > Residency Status

S_ME_STU_X; S_ME_REN_X

FISCALRESPONSIBILITY

Same fiscal responsibility value is emitted in OtherCode.

ResidencyStatus/OtherCodeList/OtherCode/Codeset

Constant

Always StateProvince.

SIF_ExtendedElements/Title1AFlagMath

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Title 1A Math; Start Page > Student Selection > Transfer Out/Edit Enrollment workflow > Maine State Information > Title 1A Math

S_ME_STU_X; S_ME_REN_X

TITLE1AMATH_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/Title1AFlagELA

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Title 1A ELA; Start Page > Student Selection > Transfer Out/Edit Enrollment workflow > Maine State Information > Title 1A ELA

S_ME_STU_X; S_ME_REN_X

TITLE1AELA_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/HomeInstructionFlag

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Home Schooled; Start Page > Student Selection > Transfer Out/Edit Enrollment workflow > Maine State Information > Home Schooled

S_ME_STU_X; S_ME_REN_X

HOMESCHOOLEDFLAG_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/Chapter504StatusFlag

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Chapter 504 Status; Start Page > Student Selection > Transfer Out/Edit Enrollment workflow > Maine State Information > Chapter 504 Status

S_ME_STU_X; S_ME_REN_X

CHAPTER504STATUSFLAG_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/GiftedTalentedAcademic

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Gifted and Talented - Academic; Start Page > Student Selection > Transfer Out/Edit Enrollment workflow > Maine State Information > Gifted and Talented - Academic

S_ME_STU_X; S_ME_REN_X

GIFTEDTALENTEDACADEMIC_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/GiftedTalentedArtistic

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Gifted and Talented - Artistic; Start Page > Student Selection > Transfer Out/Edit Enrollment workflow > Maine State Information > Gifted and Talented - Artistic

S_ME_STU_X; S_ME_REN_X

GIFTEDTALENTEDARTISTIC_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/MilitaryConnectedStudentIndicator

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Military Family Flag

S_ME_STU_X; S_ME_REN_X

MILITARYCONNECTION

Null values are published as Unknown.

SIF_ExtendedElements/HomelessPrimaryNighttimeResidenceCode

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Homeless Night-time Residence Code; Start Page > Student Selection > Transfer Out/Edit Enrollment workflow > Maine State Information > Homeless Night-time Residence Code

S_ME_STU_X; S_ME_REN_X

HOMELESSNIGHTTIMERESIDENCE

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/HomelessUnaccompaniedYouthStatus

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Unaccompanied Youth

S_ME_STU_X; S_ME_REN_X

UNACCOMPANIEDYOUTH_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/TransitionBilingualEarlyExit

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Transitional Bilingual Education or Early Exit Education

S_ME_STU_X; S_ME_REN_X

TRABILINGEARLYEXIT_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/DualLanguageTwoWayImmersion

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Dual Language or Two Way Immersion

S_ME_STU_X; S_ME_REN_X

DUALLANGTWOWAYIMMER_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/EngSecLangEngLangDev

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > English as a Second Language or Language Development

S_ME_STU_X; S_ME_REN_X

ESLELD_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/ContentClasses

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Content Classes with Integrated ESL Support

S_ME_STU_X; S_ME_REN_X

CONTENTCLASSES_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/Newcomer

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > NewComer Programs

S_ME_STU_X; S_ME_REN_X

NEWCOMER_YN

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/ParentsRefuseMLServices

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Parents Refuse ML Services

S_ME_STU_X

PARENTSREFUSEMLSERVICES

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/ResidentTownGeoCode

Database

Navigation path: Start Page > Student Selection > Maine Enrollment Information > Enrollment tab > Enrollment Information > Resident Town Geo Code; Start Page > Student Selection > Re-Enroll Student workflow > Maine State Information > Resident Town Geo Code

S_ME_STU_X; S_ME_REN_X

RESIDENTTOWNGEOCODE

Extended element is emitted only when the value is populated.

SIF_ExtendedElements/TruancyType

Derived

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_5 segment 1

Published from the staged truancy payload only when populated.

SIF_ExtendedElements/TruancyNotifySupDate

Derived

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_5 segment 2

Published from the staged truancy payload only when populated.

SIF_ExtendedElements/TruancyInterventionPlanDate

Derived

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_5 segment 3

Published from the staged truancy payload only when populated.

SIF_ExtendedElements/TruancyOfficialParentNotificationDate

Derived

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_5 segment 4

Published from the staged truancy payload only when populated.

SIF_ExtendedElements/TruancySupNotifyBoardDate

Derived

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_5 segment 5

Published from the staged truancy payload only when populated.

SIF_ExtendedElements/TruancyOfficialParentMeetingDate

Derived

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_5 segment 6

Published from the staged truancy payload only when populated.

SIF_ExtendedElements/TruancyRefLLEDate

Derived

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_5 segment 7

Published from the staged truancy payload only when populated.

SIF_ExtendedElements/TruancyAddtlInterventionDate

Derived

CST_PUBPUBLISHED_TMP

RUNTIMEPROP_5 segment 8

Published from the staged truancy payload only when populated.