...
Status | |
|---|
Owner | Scheduling Coordinator |
|---|
Contributors | Jordan Lamb John Zamora (Unlicensed) |
|---|
Goals | Assess the difference between Baseline and Custom XB reports. Assess deficiencies w/ Custom Report and recommend implementation of Baseline Business Practices. |
|---|
Jira tickets | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| columns | key,summary,type,created,updated,assignee,priority,status,resolution |
|---|
| maximumIssues | 20 |
|---|
| jqlQuery | summary ~ "ej" OR description ~ "ej" |
|---|
| serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
|---|
|
|
|---|
On this page | |
|---|
...
Global
Custom WHERE filter
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 |
XB10
Custom Logic
cos_sv_mis_xb_bp.f_get_cvu_stat
...
| Expand |
|---|
|
| Code Block |
|---|
FUNCTION f_get_wsch( p_acct_code STVACCT.STVACCT_CODE%TYPE,
p_crn SSBSECT.SSBSECT_CRN%TYPE,
p_term STVTERM.STVTERM_CODE%TYPE )
RETURN VARCHAR2
IS
lv_wsch NUMBER:=0;
lv_acct_mth STVACCT.STVACCT_CODE%TYPE;
CURSOR ssrmeet_c( p_crn SSBSECT.SSBSECT_CRN%TYPE,
p_term_code SSBSECT.SSBSECT_TERM_CODE%TYPE
) IS
SELECT *
FROM ssrmeet
WHERE ssrmeet_crn = p_crn
AND ssrmeet_term_code = p_term_code;
BEGIN
-- Get Accounting Method
lv_acct_mth := f_get_acct_mthd(p_acct_code);
IF lv_acct_mth IS NOT NULL AND
( lv_acct_mth = 'W' OR
lv_acct_mth = 'L' )
THEN
-- Calculate WSCH according with Chris' tech specification
-- you need a cursor to get the ssrmeet rows using the crn, and term
FOR lv_ssrmeet_rec IN ssrmeet_c(p_crn, p_term) LOOP
-- lv_wsch := NVL( NVL(lv_ssrmeet_rec.ssrmeet_hrs_week, sv_acad_calendar_bp.F_Calc_weekcontact_Hrs ( lv_ssrmeet_rec)),0) + lv_wsch; -- C3SC Mod JR 08/01/2007
lv_wsch := NVL(lv_ssrmeet_rec.ssrmeet_hrs_week, 0) + lv_wsch; -- C3SC Mod JR 12/05/2007
END LOOP;
RETURN (lv_wsch);
ELSE
RETURN 8888.88;
END IF;
END f_get_wsch; |
|
Custom WHERE filter
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 |