| Info |
|---|
Last Known Custom XB Changes Were Made in Spring 2010 |
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; |