This object is linked to the Student Personal object via Refid and requires a student personal record to publish. This is used to provide enrollment data for current, previous and remote program enrollment to Connect. Students excluded from state reporting are not published. A single record is generated per School District.
The following data object and its elements are published:
|
Element |
Source |
Table |
Column |
Business Rules |
|
RefId |
Derived Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program; Start Page > Student Selection > Maine Economic Status Information > Economic Status tab > Economic Status Information; Start Page > Student Selection > Re-Enroll/Transfer workflow > Maine State Information |
STUDENTS; S_ME_STU_SPED_C; REENROLLMENTS |
DCID; ID; DCID |
Builds deterministic participation RefId. SPED uses student DCID + SPED ID; current economic uses student DCID + EC; historical economic uses student DCID + reenrollment DCID. |
|
StudentPersonalRefId |
SIF Agent / staging temp Navigation path: Generated by publishing process; not entered directly in UI |
CST_PUBPUBLISHED_TMP |
SUPPORTINGKEYS |
Uses the precomputed StudentPersonal supporting key. |
|
StudentParticipationAsOfDate |
Runtime |
N/A |
SYSDATE |
Current implementation reports the system date formatted as YYYY-MM-DD. |
|
ProgramType/Code/value |
Derived Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab; Start Page > Student Selection > Maine Economic Status Information > Economic Status tab > Economic Status Information |
Derived from participation source |
PARTICIPATION_TYPE |
Reports 04888 for SPED rows and 04922 for economic status rows. |
|
ManagingPublicAgency/SIF_RefObject |
Constant |
N/A |
N/A |
Always reports LEAInfo. |
|
ManagingPublicAgency/value |
Derived Navigation path: Start Page > District Setup > District Information > Maine State Information > District/Subdistrict setup |
CST_SCHOOLSUBDISTRICTS; CST_SUBDISTRICTS; PREFS |
SUBDISTRICTID; ID; DISTRICTNUMBER |
Uses subdistrict LEA RefId when subdistricts are supported; otherwise uses district number preference RefId. |
|
ManagingSchool/SIF_RefObject |
Constant |
N/A |
N/A |
Always reports SchoolInfo. |
|
ManagingSchool/value |
Derived Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > School; Start Page > Student Selection > Transfer Info / Edit Current Enrollment > School |
SCHOOLS |
DCID |
Builds SchoolInfo RefId from the managing school DCID for the SPED or economic participation row. |
|
ExceptionalityCategories/ExceptionalityCategory/Code/value |
Database Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Disability |
S_ME_STU_SPED_C |
DISABILITY |
SPED only; null for economic status participation rows. |
|
ExceptionalityCategories/ExceptionalityCategory/ExceptionalityPriority |
Derived Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Disability |
Derived from participation type |
PARTICIPATION_TYPE |
Reports Primary for SPED rows; null for economic status rows. |
|
ProgramPlacementDate |
Database / derived Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Start Date; Start Page > Student Selection > Maine Economic Status Information > Economic Status tab > Economic Status Information > Eligibility Start Date; Start Page > Student Selection > Transfer Info / Edit Current Enrollment > Entry Date |
S_ME_STU_SPED_C; S_ME_STU_X; S_ME_REN_X; STUDENTS; REENROLLMENTS |
STARTDATE; ECONMICSTATUSELIGIBSTARTDATE; ENTRYDATE |
SPED uses SPED start date. Economic status uses eligibility start override when present; otherwise uses current or historical enrollment entry date. |
|
LeastRestrictiveEnvironment/Code/value |
Database Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Placement |
S_ME_STU_SPED_C |
PLACEMENT |
SPED only; null for economic status rows. |
|
LeastRestrictiveEnvironment/OtherCodeList/OtherCode/value |
Database Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Placement |
S_ME_STU_SPED_C |
PLACEMENT |
Repeats placement as the state/province other code value when placement is populated. |
|
LeastRestrictiveEnvironment/OtherCodeList/OtherCode/Codeset |
Derived Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Placement |
S_ME_STU_SPED_C |
PLACEMENT |
Reports StateProvince when placement is populated; otherwise null. |
|
ProgramExitDate |
Database / derived Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Exit Date; Start Page > Student Selection > Maine Economic Status Information > Economic Status tab > Economic Status Information > Eligibility End Date; Start Page > Student Selection > Re-Enroll/Transfer workflow > Maine State Information > Exit Date |
S_ME_STU_SPED_C; S_ME_STU_X; S_ME_REN_X; REENROLLMENTS |
EXITDATE; ECONMICSTATUSELIGIBENDDATE; EXITDATE |
SPED uses SPED exit date. Current economic uses economic eligibility end date. Historical economic uses reenrollment exit date. |
|
ProgramExitReason/Code/value |
Database Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Exit Reason |
S_ME_STU_SPED_C |
REASONFOREXIT |
SPED only; null for economic status rows. |
|
PlannedAssessmentParticipation/Codeset |
Derived Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Alternate Assessment |
S_ME_STU_SPED_C |
ALTERNATEASSESSMENT |
Reports StateProvince only when SPED alternate assessment is Y. |
|
PlannedAssessmentParticipation/value |
Derived Navigation path: Start Page > Student Selection > Maine Special Education Programs Information > Special Education Programs tab > New/Edit Special Education Program > Alternate Assessment |
S_ME_STU_SPED_C |
ALTERNATEASSESSMENT |
Reports SpecialEdAlternateAssessment only when SPED alternate assessment is Y. |
|
FreeAndReducedStatus |
Database / derived Navigation path: Start Page > Student Selection > Maine Economic Status Information > Economic Status tab > Economic Status Information; Start Page > Student Selection > State/Province - ME Lunch/Economic Status fields; Start Page > Student Selection > Re-Enroll/Transfer workflow > Maine State Information > Lunch/Economic status |
S_ME_STU_X; S_ME_REN_X; STUDENTS; REENROLLMENTS |
SCHOOLLUNCHELIGCODE; LUNCHSTATUS |
Economic status only. Uses state lunch eligibility override when present, otherwise lunch status. Maps A to AlternateEconomicForm; P/E/T to FullPrice; R/RDC to ReducedPrice; F/FDC to Free. |