Custom XF vs. Baseline XF
- Jordan Lamb
Owned by Jordan Lamb
Last Known Custom XB Changes Were Made in Spring 2010
Status | ASSESSING |
|---|---|
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 |
|
On this page |
Global
XF00 - Session Identifier
We use Row ID
XF01
- Will have to change and repercussions are unknown.
Baseline Logic
@John Zamora (Unlicensed) Find out if we have Baseline in our system.
Refers to STVSCHD_INSM_CODE instead of OBSOLETE STVSCHD_INSTRUCT_METH
Custom Logic:
If STVSCHD_INSTRUCT_METH is null then “XX”, ELSE RETURN STVSCHD_INSTRUCT_METH
@Jordan Lamb Check in on bad data on SCHEDULE TYPE field
SELECT * FROM SSRMEET
JOIN STVSCHD ON STVSCHD_CODE = SSRMEET_SCHD_CODE
WHERE STVSCHD_INSTRUCT_METHOD is null
AND SSRMEET_TERM_CODE > 202010
AND SSRMEET_TERM_CODE < 202410;