Resource Overview
-
Ed-Fi endpoint:
/data/v3/studentCohortAssociations -
Published view/entity: Student Cohort
-
Purpose: Cohorts for which a student is designated
-
Source query:
StudentCohortAssociation -
Dependencies:
cohorts,students,studentSchoolAssociations,studentSectionAssociations
Primary PowerSchool Source Data
-
[Students]
Selection Criteria
Records are published if the following criteria are met:
-
-
The student was published in the Student category.
-
StudentUniqueId must be populated in PowerSchool.
-
The student must not be excluded from state reporting.
-
The school must not be excluded from state reporting.
-
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
cohortReference.cohortIdentifier |
CohortIdentifier |
Y |
Staging rule: studentCohortPullouts 'S\|' || sec.dcid |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: CohortIdentifier. |
|
cohortReference.educationOrganizationId |
LEAOrgID |
Y |
[CST_PUBPublished_Tmp]EDUORGID |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LEAOrgID. |
|
studentReference.studentUniqueId |
StudentUID |
Y |
[Students]DCID; Transformation: EDFI_TN_LIB.getStudentUniqueId(p_profileid, s.dcid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StudentUID. |
|
beginDate |
BeginDate |
Y |
[CST_PUBPublished_Tmp]Runtimeprop_1; [CST_PUBENROLLMENT_TMP]EntryDate; transformation: -- greatest(tmp.runtimeprop_1, TO_CHAR(enr.entrydate, 'YYYY-MM-DD')) tmp.runtimeprop_1 |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: BeginDate. |
|
endDate |
EndDate |
Conditional |
[CST_PUBPublished_Tmp]Runtimeprop_2 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: datetime. Query alias: EndDate. |