SGHE Banner Operational Data Store
Composite View Source: FULL_NAME_EXPRESSION - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| ENTITY_NAME_EXPRESSION |
TBD |
|
|
|
CASE when APBCONS_TBL = 'AOBORGN' then SPRIDEN_LAST_NAME else SPRIDEN_LAST_NAME || ', ' || SPRIDEN_FIRST_NAME || ' ' || SUBSTR(SPRIDEN_MI, 1, 1) || '.' end |
| FULL_NAME_FMIL_EXPRESSION |
TBD |
|
|
|
CASE when APBCONS_TBL = 'AOBORGN' THEN NULL ELSE SPRIDEN_FIRST_NAME || ' ' || SUBSTR(SPRIDEN_MI, 1, 1) || '. ' || SPRIDEN_LAST_NAME END |
| FULL_NAME_LFMI_EXPRESSION |
TBD |
|
|
|
CASE when APBCONS_TBL = 'AOBORGN' THEN NULL ELSE SPRIDEN_LAST_NAME || ', ' || SPRIDEN_FIRST_NAME || ' ' || SUBSTR(SPRIDEN_MI, 1, 1) || '.' END |