SGHE Banner Operational Data Store
Composite View Source: ASSIGNED_IND_AND_DATES - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| PROSPECT_ASSIGNED_IND_EXPRESSION |
TBD |
|
|
|
DECODE(AMRSTAF_PIDM, NULL, 0, 1) |
| PROSPECT_RATE_ENTRY_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(NVL( AMRINFO_RATE_ENTRY_DATE ,TO_DATE('31-DEC-2099','DD-MON-YYYY'))) |
| PROSPECT_TARGET_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(NVL( AMRINFO_TARGET_ASK_DATE ,TO_DATE('31-DEC-2099','DD-MON-YYYY'))) |