Status | |
Due date | Annual |
On this page |
โ Problem statement
EB14 isnโt generating values since going baseline.
SB38 is still null on submissions after itโs voluntary addition in 2019.
๐ Research/Backup
Issue | EB14โs logic is unfortunately a lot simpler than we thought. That case is being partially tracked on this Ellucian case. |
Background | Since going baseline we have only reported 5 distinct values for that field. |
Proposal | We will have to use the DED values on validation table, GORRACE. |
Actions | |
Dependency Statement |
|
๐ Helpful SQL Queries
GORRACE Codes Used and their Description
SELECT DISTINCT GORPRAC_RACE_CDE, GORRACE_DESC FROM SPBPERS LEFT JOIN GORPRAC ON SPBPERS_PIDM = GORPRAC_PIDM LEFT JOIN GORRACE ON GORPRAC_RACE_CDE = GORRACE_RACE_CDE
0 Comments