SGHE Banner Operational Data Store
Reporting View Source: EXPRESSIONS - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| CITIZENSHIP_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN STVCITZ_CITIZEN_IND = 'Y' THEN 1 ELSE 0 END |
| DECEASED_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPBPERS_DEAD_IND = 'Y' THEN 1 ELSE 0 END |
| FIRST_PROPOSAL_RESULT_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(NVL( AMRPRRS_RESULT_DATE, '31-DEC-2099')) |
| GENDER_LD_EXPRESSION |
TBD |
|
|
|
DECODE ( SPBPERS_SEX , 'M', 'Male', 'F', 'Female', 'N', 'Not Reported', '') |
| GENDER_SD_EXPRESSION |
TBD |
|
|
|
DECODE ( SPBPERS_SEX , 'M', 'Male', 'F', 'Female', 'N', 'Not Reported', '') |
| HISPANIC_LATINO_ETHNICITY_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPBPERS_ETHN_CODE = '1' THEN 0 WHEN SPBPERS_ETHN_CODE = '2' THEN 1 END |
| LATEST_PROPOSAL_ASK_AMOUNT_EXPRESSION |
TBD |
|
|
|
nvl( LATEST_ASK_AMOUNT ,0) |
| LATEST_PROPOSAL_ASK_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(NVL( LATEST_PROPOSAL_ASK_DATE, '31-DEC-2099')) |
| NON_RESIDENT_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN NUMBER_OF_RACES = 0 AND STVVTYP_NON_RES_IND = 'Y' THEN 1 ELSE 0 END |
| PRIMARY_DISABILITY_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPRMEDI_DISB_IND = 'Y' THEN SPRMEDI_MEDI_CODE END |
| PRIMARY_DISABILITY_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPRMEDI_DISB_IND = 'Y' THEN STVMEDI_DESC END |
| PRIMARY_DISABILITY_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPRMEDI_DISB_IND = 'Y' THEN STVMEDI_DESC END |
| PROPOSAL_ASK_AMOUNT_EXPRESSION |
TBD |
|
|
|
nvl( PROPOSAL_ASK_AMT ,0) |
| PROPOSAL_ASK_MADE_IND_EXPRESSION |
TBD |
|
|
|
NVL(PROPOSAL_ASK_MADE_IND,0) |
| PROPOSAL_ASSIGNED_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN AMBPROP_STAFF_IDEN_CODE IS NOT NULL OR AMBPROP_STAFF_PIDM IS NOT NULL THEN 1 ELSE 0 END |
| PROPOSAL_DURATION_EXPRESSION |
TBD |
|
|
|
TRUNC(NVL(PROPOSAL_STOP_DATE, SYSDATE) - AMBPROP_CREATE_DATE) |
| PROPOSAL_START_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(NVL( AMBPROP_CREATE_DATE, '31-DEC-2099')) |
| PROPOSAL_STOP_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(NVL(PROPOSAL_STOP_DATE, '31-DEC-2099')) |
| PROPOSAL_TARGET_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(NVL(AMBPROP_DUE_DATE, '31-DEC-2099')) |
| PROPOSAL_TOTAL_RESULT_AMOUNT_EXPRESSION |
TBD |
|
|
|
nvl( PROPOSAL_TOTAL_RESULT_AMOUNT ,0) |
| PROSPECT_INT_ACTIVE_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN ATVPRST_ACTIVE_IND = 'Y' THEN 1 ELSE 0 END |
| PROSPECT_INT_ASK_AMOUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN SUM_ASK_AMT > 0 THEN SUM_ASK_AMT ELSE 0 END |
| PROSPECT_INT_END_DATE_EXPRESSION |
TBD |
|
|
|
nvl(trunc( AMRPRIN_PROJ_EFF_TO_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_INT_LATEST_ASK_DATE_EXPRESSION |
TBD |
|
|
|
nvl(trunc( LATEST_ASK_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_INT_LATEST_ASK_EXPRESSION |
TBD |
|
|
|
CASE WHEN LATEST_ASK_AMT > 0 THEN LATEST_ASK_AMT ELSE 0 END |
| PROSPECT_INT_START_DATE_EXPRESSION |
TBD |
|
|
|
nvl(trunc( AMRPRIN_PROJ_EFF_FROM_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_INT_STATUS_DATE_EXPRESSION |
TBD |
|
|
|
nvl(trunc( AMRPRIN_PRST_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_INT_TARGET_AMOUNT_EXPRESSION |
TBD |
|
|
|
NVL( AMRPRIN_TARGET_ASK_AMT ,0) |
| PROSPECT_INT_TARGET_DATE_EXPRESSION |
TBD |
|
|
|
nvl(trunc( AMRPRIN_TARGET_ASK_DATE ),TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| RACE_ETHNICITY_CONFIRM_IND_EXPRESSION |
TBD |
|
|
|
DECODE(SPBPERS_CONFIRMED_RE_CDE, 'Y', 1, 0) |
| RACE_ETHNICITY_UNKNOWN_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPBPERS_ETHN_CODE = '1' AND NUMBER_OF_RACES = 0 And STVVTYP_NON_RES_IND = 'N' THEN 1 ELSE 0 END |
| VETERAN_CATEGORY_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPBPERS_VERA_IND = 'O' THEN 'Other Protected Veteran Only' WHEN SPBPERS_VERA_IND = 'V' THEN 'Vietnam Veteran Only' WHEN SPBPERS_VERA_IND = 'B' THEN 'Both - Vietnam and Other Eligible Veteran' END |
| VETERAN_CATEGORY_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN SPBPERS_VERA_IND = 'O' THEN 'Other Protected Veteran Only' WHEN SPBPERS_VERA_IND = 'V' THEN 'Vietnam Veteran Only' WHEN SPBPERS_VERA_IND = 'B' THEN 'Both - Vietnam and Other Eligible Veteran' END |