Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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

key summary type created updated assignee priority status resolution
Refresh

On this page

Global

XF00 - Session Identifier

We use Row ID

XF01

  • Will have to change and repercussions are unknown.

Baseline Logic

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;

  • No labels