SGHE Banner Operational Data Store
Composite View Source: CALCULATION - NULL
Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
CASE WHEN (RORSTAT_ADDL_PELL_ELIG_IND |
TBD |
|
|
|
|
( TRUNC(SYSDATE) - NVL( CONT_LAST_REC.CONTACT_DATE,TRUNC( SYSDATE)) ); |
NA |
|
|
|
|
(MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100 |
NA |
|
|
|
|
ACCT.PAY_CURRENCY_AMOUNT - ACCT.PAY_CURRENCY_AMOUNT_NO_TAX |
NA |
|
|
|
|
AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER ||AORCONT_PHONE_EXT |
NA |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT |
PHONE_NUMBER_COMBINED |
|
CASE STVFFVA_TYPE WHEN |
NA |
COMPOSITE VIEW |
AS_FACULTY_FEEDBACK_DETAIL |
FEEDBACK_TYPE_DESC |
|
CASE WHEN (RCRAPP1_SEQ_NO |
TBD |
|
|
|
|
CASE WHEN AORCONT_PRIMARY_IND |
NA |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT |
PRIMARY_CONTACT_IND |
|
CASE WHEN ENCUMBRANCE_NUMBER |
NA |
COMPOSITE VIEW |
AF_ENCUMBRANCE |
HR_ENCUMBRANCE_IND |
|
CASE WHEN FABBKTP_RECON_IND |
NA |
COMPOSITE VIEW |
AF_CHECKS |
BANK_RECONCILIATION_IND_DESC |
|
CASE WHEN FABCHKS_CHECK_TYPE_IND |
NA |
COMPOSITE VIEW |
AF_CHECKS |
CHECK_TYPE_DESC |
|
CASE WHEN FABCHKS_RECON_IND |
NA |
COMPOSITE VIEW |
AF_CHECKS |
RECONCILIATION_IND_DESC |
|
CASE WHEN FGBENCD_CMT_TYPE |
NA |
|
|
|
|
CASE WHEN FGBENCD_FIELD_CODE |
NA |
|
|
|
|
CASE WHEN FTVVEND_CHECK_PIDM IS NULL |
NA |
|
|
|
|
CASE WHEN HR_ENCUMBRANCE_IND |
NA |
|
|
|
|
CASE WHEN NORTRAN_AUBK_CODE = 'SPRIDEN' THEN 'IDEN' |
NA |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_GENERAL |
PAF_TRANSACTION_TYPE |
|
CASE WHEN RBRAPBC_SYS_IND |
NA |
|
|
|
|
CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND |
TBD |
|
|
|
|
CASE WHEN RORSTAT_DEP_NO_PAR_DATA |
TBD |
|
|
|
|
CASE WHEN RRRAREQ_SYS_IND |
NA |
|
|
|
|
CASE WHEN STAFF_ASSIGNMENT_STATUS_IND |
NA |
|
|
|
|
CASE WHEN STRATEGY_PLAN_STATUS_IND |
NA |
|
|
|
|
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND (M.ENTITY_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION') |
NA |
|
|
|
|
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND ( M.MATCH_EMPLOYER_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION') |
NA |
|
|
|
|
DECODE(C.EXPENSE_TYPE_CODE, '9900ADVC', 'Y','N') |
TBD |
|
|
|
|
DECODE(ENROLLED_IND |
NA |
|
|
|
|
DECODE(FORCIRR_DATA_ORIGIN) |
NA |
|
|
|
|
DECODE(FPRPODA_NSF_SUSP_IND) |
FPAPURR |
|
|
|
|
DECODE(FRBEVNG_PMT_METHOD_TYPE_IND) |
NA |
COMPOSITE VIEW |
AF_GRANT_EVENT |
PAYMENT_METHOD_DESC |
|
DECODE(FRVBFRM_TYPE_IND) |
NA |
COMPOSITE VIEW |
AF_GRANT_EVENT AF_GRANT_PERSONNEL |
BILL_FORMAT_TYPE_DESC BILL_FORMAT_TYPE_DESC |
|
DECODE(RCRAPP2_C_1_ANLY_TYPE) |
RNARSXX |
|
|
|
|
DECODE(RCRAPP2_C_1_CTRB_OFFL_EST) |
RNARSXX |
|
|
|
|
DECODE(RCRAPP2_C_MRTL_STATUS) |
NA |
|
|
|
|
DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE) |
RNINAIQ |
|
|
|
|
DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST) |
RNARSXX |
|
|
|
|
DECODE(RCRAPP2_C_PAR_MRTL_STATUS) |
NA |
|
|
|
|
DECODE(RCRAPP2_MODEL_CDE) |
NA |
|
|
|
|
DECODE(RCRAPP2_PELL_ANLY_TYPE) |
NA |
|
|
|
|
DECODE(RCRAPP2_PELL_PGI_OFFL_EST) |
RNARSXX |
|
|
|
|
DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST) |
RNINAIQ |
|
|
|
|
DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST) |
RNINAIQ |
|
|
|
|
DECODE(RCRAPP4_EFC_CHANGE_IND) |
NA |
|
|
|
|
DECODE(RCRAPP4_NSLDS_MATCH) |
NA |
|
|
|
|
DECODE(RCRAPP4_SOURCE_CORRECTION) |
NA |
|
|
|
|
DECODE(SFBETRM_PIDM, NULL, 'N', 'Y') |
NA |
|
|
|
|
DECODE(STVAPDC_APPL_INACT) |
NA |
|
|
|
|
DECODE(STVAPDC_INST_ACC_IND) |
NA |
|
|
|
|
DECODE(STVAPDC_REJECT_IND) |
NA |
|
|
|
|
DECODE(STVAPDC_SIGNF_IND) |
NA |
|
|
|
|
DECODE(STVAPDC_STDN_ACC_IND) |
NA |
|
|
|
|
DECODE(STVSBGI_TYPE_IND,'C','COLLEGE', 'H','HIGHSCHOOL','S','SOURCE-ONLY',NULL) |
NA |
|
|
|
|
DECODE���.. |
NA |
|
|
|
|
EARN |
NA |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
PAF_TRANSACTION_TYPE |
|
FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVENT_DESC |
NA |
|
|
|
|
FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC |
NA |
COMPOSITE VIEW |
AF_GRANT_EVENT |
GRANT_EVENT_FULL_DESC |
|
F_GET_NORM_BALANCE |
NA |
|
|
|
|
NVL(AMBPLAN_END_DATE,'31-DEC-2099') |
NA |
|
|
|
|
NVL(AMRSTAF_END_DATE,'31-DEC-2099') |
NA |
|
|
|
|
NVL(FARINVA_APPR_AMT,0)+NVL( FARINVA_ADDL_CHRG_AMT,0)+NVL( FARINVA_TAX_AMT,0)-NVL(FARINVA_DISC_AMT, 0) |
FAAINVE |
|
|
|
|
NVL(FGBENCD_ABAL_OVERRIDE) |
NA |
|
|
|
|
NVL(FGBENCH_EDIT_DEFERRAL,'N') |
NA |
|
|
|
|
NVL(FGBENCH_NSF_ON_OFF_IND,'N') |
NA |
|
|
|
|
NVL(FPRPODA_AMT,0) |
FPAPURR |
|
|
|
|
NVL(FPRPODA_AMT,0)+NVL( FPRPODA_ADDL_CHRG_AMT,0)+NVL( FPRPODA_TAX_AMT,0)-NVL(FPRPODA_DISC_AMT, 0) |
FPAPURR |
|
|
|
|
NVL(FPRPODA_CLOSED_IND,'N') |
FPAPURR |
|
|
|
|
NVL(FPRPODA_CONVERT_ADDL_CHRG_AMT,0) |
FPAPURR |
|
|
|
|
NVL(FPRPODA_CONVERT_AMT,0) |
FPAPURR |
|
|
|
|
NVL(FPRPODA_CONVERT_DISC_AMT,0) |
FPAPURR |
|
|
|
|
NVL(FPRPODA_CONVERT_TAX_AMT,0) |
FPAPURR |
|
|
|
|
NVL(FPRPODA_DISC_AMT,0) |
FPAPURR |
|
|
|
|
NVL(FPRPODA_ENCB_ADJT_AMT,0) |
FPAPURR |
|
|
|
|
NVL(FPRPODA_NSF_OVERRIDE_IND,'N') |
FPAPURR |
|
|
|
|
NVL(FPRPODA_SUSP_IND,'N') |
FPAPURR |
|
|
|
|
NVL(FPRPODA_TAX_AMT,0) |
FPAPURR |
|
|
|
|
NVL(FPRPODT_ADDL_CHRG_AMT,0) |
FPAPURR |
|
|
|
|
NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID) |
NA |
COMPOSITE VIEW |
AE_EXPENSE_ITEM |
PURCHASE_CARD_ID |
|
NVL(FTVVEND_TERM_DATE,'31-DEC-2099') |
NA |
|
|
|
|
NVL(FTVVEND_VEND_CHECK_PIDM, FTVVEND_PIDM) |
NA |
|
|
|
|
NVL(RCRAPP4_DUP_SSN_IND) |
NA |
|
|
|
|
NVL(RCRAPP4_PUSH_ISIR_FLAG) |
NA |
|
|
|
|
NVL(RPRLAPP_DEFERMENT_OPT,'N') |
NA |
|
|
|
|
NVL(RPRLAPP_MAX_LOAN_IND,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_APPR_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_ATTS_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_CAMP_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_CAPC_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_CHRT_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_CLAS_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_COLL_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_CORQ_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_DEGC_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_DEPT_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_DUPL_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_LEVL_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_LINK_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_MAJR_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_MEXC_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_PREQ_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_PROG_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_REPT_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_RPTH_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_TEST_OVER,'N') |
NA |
|
|
|
|
NVL(SFRSTCR_TIME_OVER,'N') |
NA |
|
|
|
|
SFRSTCR_SUBJ_CODE||SFRSTCR_CRSE_NUMB |
NA |
COMPOSITE VIEW |
AS_FACULTY_FEEDBACK |
COURSE_IDENTIFICATION |
|
SHRTRCE_SUBJ_CODE||SHRTRCE_CRSE_NUMB |
SHATRNS |
|
|
|
|
SHRTRCE_TRIT_SEQ_NO||TO_CHAR( SHRTRCE_TRAM_SEQ_NO,'FM09')||TO_CHAR( NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009') ||TO_CHAR(SHRTRCE_SEQ_NO,'FM009') |
MULTIPLE |
|
|
|
|
SHRTRCR_TRANS_COURSE_NAME||SHRTRCR_TRANS _COURSE_NUMBERS |
SHATRNS |
COMPOSITE VIEW |
AS_STUDENT_TRANSFERRED_COURSE |
TRANSFER_COURSE_IDENTIFICATION |
|
SIGN(SUM(NVL((SELECT 0 FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = EDW EXTRACT PARAMETERS AND MTVPARM_INTERNAL_CODE = MINORITY_IND AND MTVPARM_INTERNAL_CODE_2 = NON_MINORITY_RACE_CATEGORY AND MTVPARM_EXTERNAL_CODE = RACE_CATEGORY), 1))) |
NA |
|
|
|
|
SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA| |SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT |
NA |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT AA_ORGANIZATION_CONTACT |
PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED |
|
TBD |
NA |
COMPOSITE VIEW |
AF_OPERATING_LEDGER AF_OPERATING_LEDGER AF_OPERATING_LEDGER AF_OPERATING_LEDGER |
CURR_PERIOD_LAST_YEAR_ACTUAL SUM_LAST_YEAR_ACTUAL CURR_PERIOD_LAST_YEAR_ACTUAL SUM_LAST_YEAR_ACTUAL |
|
TBD?? |
NA |
|
|
|
|
TBLD |
NA |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_LABOR_DIST |
PAF_TRANSACTION_TYPE |
|
TO_CHAR (TO_DATE (FAB1099_RPT_YR, 'RR'), 'YYYY') |
NA |
COMPOSITE VIEW |
AF_VENDOR_TAXABLE_REPORTING |
TAX_YEAR |
|
TO_CHAR (TO_DATE (FRRGRNH_FSYR_CODE, 'RR'), 'YYYY' |
NA |
COMPOSITE VIEW |
AF_GRANT_DEFERRED_COST |
FISCAL_YEAR |
|
TTBTAXN_AMOUNT_3 * -1 |
NA |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
PRIOR_YEAR_CHARGES_ADJUSTED |
|
TTBTAXN_AMOUNT_5 * -1 |
NA |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
PRIOR_YR_SCHOLARSHIP_GRANT_ADJ |
|