Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • Leave of Absence Activated Headcount 
    •  In OBIEE this exists as a pre - calculated column by the same name
    • If connecting directly, this must be calculated using the following logic:  Count of Student ID where Registration Status = "L" and rp_f_reg_pipeline_mv.src<>'STUB'.
    • This data comes from the normal Term Registration portion of Registration Pipeline = to the current 'SIS - Term Registration' that is loaded nightly.
    • These students will be included in the Census Count if they are term activated as of census date
  • Leave of Absence Not Activated Headcount 
    • This data comes from the stub records built specifically for Reg Pipeline.
    • In OBIEE this exists as a pre - calculated column by the same name
    • If connecting directly, this must be calculated using the following logic: Count of students ID where Registration Status=’L' and rp_f_reg_pipeline_mv.src='STUB'.
    • In order to get an accurate count, you must utilize either Current Flag = "Y" or As of Date = Today Today (Do not use both)
    • After the first term of LOA, only the "Primary plan" and "Academic Group" are carried forward as part of the student's CPP. All other CPP information become null.
  • All Students on Leave of Absence Headcount
    • In OBIEE this exists as a pre - calculated column by the same name
    • If connecting directly, this must be calculated using the following logic=Leave of Absence Activated Headcount  + Leave of Absence Not Activated Headcount 

...