...
Global
Custom WHERE filter
- For as long as these fake courses exist on SSASECT(SSBSECT) we will have to keep custom.
Will not pull SCBCRSE_SUBJ_CODE = ('CLEP', ‘TRNS’, ‘AP’, ‘AML1’, ‘CAR1’, ‘BB’. ‘CED1’, ‘CER1’, ‘HFW1’,'MED1’) and will not pull 'LIBR490AB' in XB_COS
| Code Block |
|---|
AND A.SCBCRSE_SUBJ_CODE NOT IN
('CLEP','TRNS','AP','AML1','CAR1','BB','CED1','CER1','HFW1','MED1') -- COS change ADDED
AND (SCBCRSE_SUBJ_CODE || SCBCRSE_CRSE_NUMB <> 'LIBR490AB')
--COS Above 2 lines added |
- Jordan Lamb Ask Daniel Alvarado if any
SCBCRSE_SUBJ_CODE= ('CLEP', ‘TRNS’, ‘AP’, ‘AML1’, ‘CAR1’, ‘BB’. ‘CED1’, ‘CER1’, ‘HFW1’,'MED1’) are still active on the catalog level. If not, then we can remove this line of code.
XB01
- Can use baseline if Warning below is heeded.
| Note |
|---|
STVACCT codes must begin with the XB01 value that is to be reported. Regardless of Baseline or Custom. Obsolete codes that do not follow this practice are a liability in reporting correctly. For example, the ‘XE’ codes. |
Baseline Logic
XB01 uses the first character of SSBSECT_ACCT_CODE. STVACCT
Custom Logic:
cos_sv_mis_xb_bp.f_get_acct_mthd(SSBSECT_ACCT_CODE) ACCT_CODE
If SSBSECT_ACCT_CODE, XB01 = ' ‘, if SSBSECT_ACCT_CODE = ‘WE’ THEN XB01 = 'I’
XB10
- Would require a business practice change and decision from Academic Services on if it could be assessed on a catalog or section level. Section level requiring more manual data entry than catalog level.
| Note |
|---|
Out of compliance with this. Or at least, less accurate than the CO perhaps intended. |
Custom Logic
cos_sv_mis_xb_bp.f_get_cvu_stat
...
| Info |
|---|
Assessed 5/22 and Instructional Methods listed are still valid. |
Baseline Logic
sv_mis_xb_bp.f_get_cvu_stat
...
GVATRMP does not seem capable of crosswalking values.
XB11
- Can use baseline if XB01 Warning is heeded.
Custom
cos_sv_mis_xb_bp.f_get_wsch
STVACCT_CODE = lv_acct_mth = 'W' OR lv_acct_mth = 'L' OR lv_acct_mth = 'WE' then returns the sum of SSRMEET_HRS_WEEK for crn CRN and termTERM, else return default 8888.88
...
STVACCT_CODE = lv_acct_mth = 'W' OR lv_acct_mth = 'L' then returns the sum of SSRMEET_HRS_WEEK for crn CRN and termTERM, else return default 8888.88
...