StudentParticipation
The StudentParticipation object provides a student's participation values for a given program. This object is sent as data is changed to the ELL, Lunch Status, and Economic Disability of a student.
The PowerSchool SIF Agent provides publishing capabilities for the following data object and its elements:
ELL Records
Sent when ELL type = 2349
Element/@Attribute | Source | Table | Column | Business Rules |
|---|---|---|---|---|
@RefId | Calculated | |||
@StudentPersonalRefId | Calculated | |||
StudentParticipationAsOfDate | Database | STUDENTS | EntryDate | Sends the student's current entry date into school. |
ProgramType/Code | Database | S_OK_STU_X | ELL | Value must be 2349 for a record to be sent. |
ProgramType/OtherCodeList/OtherCode[@Codeset='StateProvince'] | Database | Value is always blank. | ||
ProgramExitDate | Database | Value is always blank. |
Economic Disadvantage Records
Records are generated from the lunch page where the value of the EconomicDisadvantage = Yes. This can result in multiple records for the school year.
Element/@Attribute | Source | Table | Column | Business Rules |
|---|---|---|---|---|
@RefId | Calculated | |||
@StudentPersonalRefId | Calculated | |||
StudentParticipationAsOfDate | Database | STUDENTS S_STU_LUNCH_C | EntryDate | If the lunch status start date is before the first day of school, then the student's entry date is used. Otherwise, the lunch status start date is used. |
ProgramType/Code | Calculated | Value is hard coded to 9999. | ||
ProgramType/OtherCodeList/OtherCode[@Codeset='StateProvince'] | Calculated | Value is hard coded to 0900. | ||
ProgramExitDate | Database | S_STU_LUNCH_C | End_Date |
Lunch Status Records
Element/@Attribute | Source | Table | Column | Business Rules |
|---|---|---|---|---|
@RefId | Calculated | |||
@StudentPersonalRefId | Calculated | |||
StudentParticipationAsOfDate | Database | STUDENTS S_STU_LUNCH_C | EntryDate | If the lunch status start date is before the first day of school, then the student's entry date is used. Otherwise, the lunch status start date is used. |
ProgramType/Code | Calculated | Value is hard coded to 9999. | ||
ProgramType/OtherCodeList/OtherCode[@Codeset='StateProvince'] | Calculated | S_STU_LUNCH_C | ReportedValue LunchStatus | If the ReportedValue is blank, the LunchStatus is used. The following mappings occurs: F, FDC = S010 |
ProgramExitDate | Database | S_STU_LUNCH_C | End_Date |