...
Status |
| ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Scheduling Coordinator | ||||||||||||
Contributors | |||||||||||||
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
| Info |
|---|
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
| Code Block | ||
|---|---|---|
| ||
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; |