📋 Overview
Status | ASSESSING |
|---|---|
Owner | Academic Services |
Contributors | |
Goals | Assess how the Custom XE report differs from Baseline. Determine steps and issues in moving to Baseline. |
Jira tickets | |
On this page |
XE01
p_fstp_code_in is SIBINST_FSTP_CODE on SIAINST>”Staff Type”
p_asty_code_in is SIRASGN_ASTY_CODE is SIAASGN>Faculty Assignment>”Assignment Type”
Custom
If “Assignment Type” ends with “O”, “A”, or “S” then it reports the crosswalked value on GVATRMP.
If the above isn’t true, then it reports the GVATRMP crosswalked value of the employee’s “Staff Type”.
If those two fields are empty, then it reports “4 - Contract Staff: not a district employee”
COS_SV_MIS_XE.f_get_asgn_type IF p_asty_code_in like '%O' or p_asty_code_in like '%A' or p_asty_code_in like '%S' THEN lv_map_value := gv_rept_xml.F_MapValue(p_report_in, 'XE01', p_asty_code_in); ELSE lv_map_value := gv_rept_xml.F_MapValue(p_report_in, 'XE01',p_fstp_code_in); END IF; IF lv_map_value is NOT NULL THEN RETURN lv_map_value; ELSE RETURN '4'; --if no faculty data found, return 4 for contracted employee END IF;
Baseline
If “Staff Type” is not empty, then it reports the crosswalked value on GVATRMP.
Else if the crosswalked “Staff Type” is empty or the crosswalked value does not equal “1” or “4”, then it checks to see if “Assignment Type” has a value. If so, it reports the crosswalked value of “Assignment Type”.
Else it reports the crosswalked value of “Assignment Type”
If those are empty, it reports “3 - Regular Staff: not an OVERLOAD assignment”
SV_MIS_XE.f_get_asgn_type
FUNCTION f_get_asgn_type( p_asty_code_in IN SIRASGN.SIRASGN_ASTY_CODE%TYPE,
p_fstp_code_in IN SIBINST.SIBINST_FSTP_CODE%TYPE,
p_report_in IN GVVRPDF.GVVRPDF_REPORT%TYPE )
RETURN VARCHAR2
IS
lv_map_value VARCHAR2(4);
BEGIN
IF p_fstp_code_in IS NOT NULL THEN
lv_map_value := gv_rept_xml.F_MapValue(p_report_in, 'XE01', p_fstp_code_in);
IF lv_map_value IS NULL OR lv_map_value NOT IN ('1', '4') THEN
IF p_asty_code_in IS NOT NULL THEN
lv_map_value := gv_rept_xml.F_MapValue(p_report_in, 'XE01', p_asty_code_in);
END IF;
END IF;
ELSE
IF p_asty_code_in IS NOT NULL THEN
lv_map_value := gv_rept_xml.F_MapValue(p_report_in, 'XE01', p_asty_code_in);
END IF;
END IF;
-- C3SC JC 06/09/2011 END
IF lv_map_value IS NOT NULL THEN
RETURN lv_map_value;
ELSE
RETURN '3'; -- C3SC JC 06/09/2011 CHANGED
END IF;
END f_get_asgn_type;
Add Comment