SGHE Banner Operational Data Store
Composite View Source: DEPENDANT_EXPRESSION - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| PROPOSAL_ASSIGNMENT_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
CASE PROPOSAL_KEY WHEN 0 THEN NULL ELSE (PROPOSAL_KEY + ( MULTI_SOURCE_KEY * .01)) END |
| PROPOSAL_ASSIGNMENT_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN PROPOSAL_KEY > 0 THEN 1 ELSE 0 END |
| PROSPECT_ASSIGNMENT_GROUP_KEY_EXPRESSION |
TBD |
|
|
|
CASE PROSPECT_KEY WHEN 0 THEN NULL ELSE (PROSPECT_KEY + ( MULTI_SOURCE_KEY * .01)) END |
| START_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |
| STOP_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |