Athletics Integration

[txoof]

Add integration from SIS for Athletics

• [x] Add template manually via IPSIS -- one time process
  • [x] Check w/ Athletics dept for content on this template that will be copied down to all teams (e.g. links, etc.)
• [ ] Pull all Athletics Activities as courses
  • [x] Add power query
  • [x] Test PQ
  • [x] Add template
  • [ ] Add schedule
• [ ] Add students to Activities via enrollments
  • [x] Add power query
  • [x] Test PQ
  • [x] Add template
  • [ ] Add schedule
• [ ] Create procedure for adding coaches
  • [ ] Internal Coaches
  • [ ] External Coaches
• [ ] Migrate PSL courses over

[txoof]

Test if this will work as a PowerQuery

SELECT distinct
    -- Students.LastFirst,
    'course offering' as "type",
    'UPDATE' as "action",
    Gen.Name AS Activity,
    PS_CustomFields.GetStudentsCF(Students.ID,Gen.Value) AS
Enrolled_in_Activity
    -- STUDENTS.STUDENT_NUMBER as child_code,
    /* REGEXP_REPLACE(U_STUDENTSUSERFIELDS.EMAILSTUDENT, '(^.*)(@.*)',
'\1') as "child_code", */
    -- 'Learner' as "role_name"
FROM
    Students
    JOIN Gen ON Gen.cat='activity'
WHERE
    Students.Enroll_Status = 0
    and STUDENTS.GRADE_LEVEL >=5
    AND PS_CustomFields.GetStudentsCF(Students.ID,Gen.Value) IS NOT NULL
    AND PS_CustomFields.GetStudentsCF(Students.ID,Gen.Value) >=1
    AND Gen.Name LIKE '%Athletics - %'
ORDER BY
    -- Students.LastFirst,
    Gen.Name

[txoof]

Query works -- need to resolve way to set term number

[txoof]

May not need to worry about terms -- could just use a term called "Athletics"

Check in with Athletics department regarding this.

[txoof]

No one wants this. No one needs this. Closing.