Data Futures Return: Course Role Entity

For each Course extract record, an entity is created for each Roles record defined at Sub-Plan, Plan, or Program level. In each case, the latest record where the effective date falls on or before the reporting period end date is considered.

Course Role extract records are created if you selected the Include Course Entities parameter check box.

For each Course entity in the extract for the return with an active status:

• If the Course.COURSEID is derived from a Sub-Plan, an entity is created for each eligible record:

  • If at least one Role is defined for the Sub-plan. The derivation step for each field is set to 1.

  • If at least one Role is defined for the parent Plan. The derivation step for each field is set to 2.

  • If the parent Plan is associated with an Academic Program (ACAD_PROG in ACAD_PLAN_TBL) and at least one Role is defined for the parent Program. The derivation step for each field is set to 3.

• If the Course.COURSEID is derived from a Plan, an entity is created for each eligible record:

  • If at least one Initiative is defined for the Plan with Valid To either blank or a date on or after the Reporting Period start date. The derivation step for each field is set to 2.

  • If the Plan is associated with an Academic Program (ACAD_PROG in ACAD_PLAN_TBL) and at least one Initiative is defined for the parent Program with Valid To either blank or a date on or after the Reporting Period start date. The derivation step for each field is set to 3.

If no eligible records are found at any level, a single entity is created with field values (COURSEROLEHESAID, ROLETYPECR and CRPROPORTION) derived for any default values defined for the return with derivation step 4.