SGHE Banner Operational Data Store
Reporting View Source: FUNCTION - NULL
| Source Column |
Business Definition |
Target |
Target Column |
Calculation Formula |
| (SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE =PAF_TRANSACTION_STATUS) |
|
|
|
|
| AOKODSF.F_GET_PROJ_ASSIGN_PROS_IND( AMRPROP_PIDM, AMRPROP_PROJ_CODE) |
|
|
|
|
| AOKODSF.F_GET_STAFF_INDICATOR |
|
|
|
|
| CASE WHEN AMRINFO_SYS_IND |
|
|
|
|
| CASE WHEN EXISTS FTOBDLGT |
|
|
|
|
| CASE WHEN FTVACCT_DATA_ENTRY_IND |
|
|
|
|
| CASE WHEN FTVEVND_COLLECT_TAX |
|
|
|
|
| CASE WHEN FTVFUND_DATA_ENTRY_IND |
|
|
|
|
| CASE WHEN FTVORGN_DATA_ENTRY_IND |
|
|
|
|
| CASE WHEN FTVPROG_DATA_ENTRY_IND |
|
|
|
|
| CASE WHEN FTVVEND_CARRIER_IND |
|
|
|
|
| CASE WHEN FTVVEND_GROUPING_IND |
|
|
|
|
| CASE WHEN FTVVEND_IN_ST_IND |
|
|
|
|
| CASE WHEN PROPOSAL_RESULT_PLEDGE_NUMBER |
|
|
|
|
| CASE WHEN SSRMEET_OVER_RIDE |
|
|
|
|
| DECODE(FRBEVNG_PMT_METHOD_TYPE_IND) |
|
|
|
|
| DECODE(GOKODSF.F_GET_DESC) |
|
|
|
|
| DECODE(STVRESD_IN_STATE_IND) |
|
STUDENT_EXTENDED |
RESIDENCY_IND |
|
| FOFYCNV |
|
|
|
|
| FOFYCNV(FTVFSPD_FSYR_CODE) |
|
|
|
|
| FOKODSF.F_GET_ACCT_HIER |
|
|
|
|
| FOKODSF.F_GET_FINANCE_DESC |
|
|
|
|
| FOKODSF.F_GET_FINANCE_STATUS |
|
|
|
|
| FOKODSF.F_GET_FUND_HIER |
|
|
|
|
| FOKODSF.F_GET_LOCN_HIER |
|
|
|
|
| FOKODSF.F_GET_ORGN_HIER |
|
|
|
|
| FOKODSF.F_GET_PROG_HIER |
|
|
|
|
| FOKODSF.F_GET_SDAT_TITLE |
|
|
|
|
| FRKIDEN.F_GET_FRBGRNT_STATUS_CODE |
|
|
|
|
| FRKIDEN.F_GET_FRBGRNT_TITLE |
|
|
|
|
| FTVORGN_FMGR_CODE_PIDM |
|
|
|
|
| F_CALC_REGISTRATION_HOURS |
|
|
|
|
| F_CLASS_CALC_FNC |
|
|
|
|
| F_ENROLLED_THIS_TERM |
|
|
|
|
| F_FINAID_APPLICANT_IND |
|
|
|
|
| F_FORMAT_NAME |
|
|
|
|
| F_GET_FINANCE_DESC |
|
|
|
|
| F_GET_FINANCE_STATUS |
|
|
|
|
| F_GET_NORM_BALANCE |
|
|
|
|
| F_HOUS_THIS_TERM |
|
|
|
|
| F_INQUIRER_FNC |
|
|
|
|
| F_INST_AID_FNC |
|
|
|
|
| F_LEVEL_ADMITTED_FNC |
|
|
|
|
| F_LEVEL_APPL_FNC |
|
|
|
|
| F_PAID_ADMISSIONS_DEPOSIT |
|
|
|
|
| F_PROSPECT_FNC |
|
|
|
|
| F_REGISTERED_THIS_TERM |
|
|
|
|
| GOKODSF.F_DIRECT_DEPOSIT_IND |
|
|
|
|
| GOKODSF.F_GET_DESC |
|
|
|
|
| GOKODSF.F_GET_DESC(CASE WHEN FTVVEND_VEND_CHECK_PIDM IS NULL) |
|
|
|
|
| GOKODSF.F_TRIM_LONGS |
|
|
|
|
| MAKFUNC.F_CAMP_EXPENSES |
|
|
|
|
| MAKFUNC.F_CAMP_MATCH_GIFTS_ANTICIPATED |
|
|
|
|
| MAKFUNC.F_CAMP_MATCH_GIFTS_PAID |
|
|
|
|
| MAKFUNC.F_CAMP_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_OUTRIGHT_GD_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_OUTRIGHT_GIFTS |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PD_NP_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PD_PAID_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES - MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_CAMP_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_CAMP_TOTAL_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_DESG_CAMP_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED |
|
|
|
|
| MAKFUNC.F_DESG_MATCH_GIFTS_PAID |
|
|
|
|
| MAKFUNC.F_DESG_OUTRIGHT_GIFTS |
|
|
|
|
| MAKFUNC.F_DESG_OUTRIGHT_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_OUTRIGHT_GIFT_DONOR_CNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_BALANCE |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_DONOR_NO_PAY_CNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_DONOR_PAID_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_PAYMENT |
|
|
|
|
| MAKFUNC.F_DESG_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_DESG_TOTAL_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_GET_ENTITY_IND |
|
|
|
|
| MAKFUNC.F_GET_PERSON_INFO |
|
|
|
|
| MAKFUNC.F_ORG_OUTRIGHT_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_OUTRIGHT_GIFTS |
|
|
|
|
| MAKFUNC.F_ORG_OUTRIGHT_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_ORG_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_ORG_TOTAL_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_SOLG_CAMP_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_SOLP_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_SOLP_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_SOLP_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_OUTRIGHT_GD_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_OUTRIGHT_GIFTS |
|
|
|
|
| MAKFUNC.F_SOL_FR_OUTRIGHT_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PD_NP_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PD_PAID_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT/ORGAN IZATION_DONOR_COUNT_GOAL |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT/SOLIC ITOR_DONOR_COUNT_GOAL |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_PLEDGES |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_REMAINING |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_TOTAL |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_TOTAL( PORTFOLIO_KEY, '%', '%') |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_TOTAL( PORTFOLIO_KEY, '%', 'N') |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_TOTAL( PORTFOLIO_KEY, '%', 'Y') |
|
|
|
|
| MEKFUNC.F_GET_TAX_AMOUNT( E.EXPENSE_ITEM_KEY,'A') |
|
|
|
|
| MEKFUNC.F_GET_TAX_AMOUNT( E.EXPENSE_ITEM_KEY,'C') |
|
|
|
|
| MEKFUNC.F_GET_TAX_AMOUNT( E.EXPENSE_ITEM_KEY,'P') |
|
|
|
|
| MEKFUNC.F_ITINERARY_DATE |
|
|
|
|
| MEKFUNC.F_LIFE_TOTAL_REIMBURSE_PAID |
|
|
|
|
| MEKFUNC.F_NOTIFICATION_CHANGE_HOURS |
|
|
|
|
| MEKFUNC.F_STATUS_CHANGE_HOURS( AUTHORIZATION_KEY, STATUS_DATE, 'A', 'L') |
|
|
|
|
| MEKFUNC.F_STATUS_CHANGE_HOURS( AUTHORIZATION_KEY, STATUS_DATE, 'A', 'T') |
|
|
|
|
| MEKFUNC.F_STATUS_CHANGE_HOURS( REIMBURSEMENT_KEY, STATUS_DATE, 'R', 'L') |
|
|
|
|
| MEKFUNC.F_STATUS_CHANGE_HOURS( REIMBURSEMENT_KEY, STATUS_DATE, 'R', 'T') |
|
|
|
|
| MEKFUNC.F_TOTAL_NOT_SUBMITTED |
|
|
|
|
| MEKFUNC.F_TOTAL_NOT_SUBMITTED( PORTFOLIO_KEY, '%', '%') |
|
|
|
|
| MEKFUNC.F_TOTAL_NOT_SUBMITTED( PORTFOLIO_KEY, '%', 'N') |
|
|
|
|
| MEKFUNC.F_TOTAL_NOT_SUBMITTED( PORTFOLIO_KEY, '%', 'Y') |
|
|
|
|
| MEKFUNC.F_TOTAL_REIMBURSE_NOT_PAID |
|
|
|
|
| MEKFUNC.F_TOTAL_REIMBURSE_NOT_PAID( PORTFOLIO_KEY, '%') |
|
|
|
|
| MEKFUNC.F_TOTAL_REIMBURSE_PAID |
|
|
|
|
| MEKFUNC.F_TOTAL_REIMBURSE_PAID( PORTFOLIO_KEY, '%') |
|
|
|
|
| MEKFUNC.F_TOTAL_SUBMITTED |
|
|
|
|
| MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', '%') |
|
|
|
|
| MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'N') |
|
|
|
|
| MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'Y') |
|
|
|
|
| MFKFUNC.F_GET_LEDGER_ENCUMBERED_AMOUNT |
|
|
|
|
| MFKFUNC.F_GET_LEDGER_REMAINING_BALANCE |
|
|
|
|
| MFKFUNC.F_GET_VENDOR_FIELDS |
|
|
|
|
| MGKFUNC.F_GET_PERSON_INFO |
|
|
|
|
| MPKFUNC.F_GET_EMPL_POSITION_INFO |
|
|
|
|
| MPKFUNC.F_GET_PERSONNEL_ACTION_IND |
|
|
|
|
| MPKFUNC.F_POSITION_CURRENT_IND |
|
EMPLOYEE_POSITION EMPLOYEE_POSITION |
LATEST_POSITION_IND POSITION_CURRENT_IND |
|
| MRKFUNC.F_GET_AID_ENROLL_PERIOD |
|
|
|
Extracts the aid year, aid year description, aid enrollment period, or aid enrollment period description for a student and a given term. |
| MSKFUNC.F_CHECK_COOP_IND |
|
|
|
|
| MSKFUNC.F_COUNT_ADVISORS |
|
|
|
|
| MSKFUNC.F_COUNT_COHORTS |
|
|
|
|
| MSKFUNC.F_COUNT_HOLDS |
|
|
|
|
| MSKFUNC.F_COUNT_SPORTS |
|
|
|
|
| MSKFUNC.F_COUNT_STUDENT_COURSE_ATTR |
|
|
|
|
| MSKFUNC.F_DEGR_ENROLLED_IND |
|
|
|
|
| MSKFUNC.F_GET_OUTCOME_AWARDED_IND |
|
|
|
|
| NOKODSF.F_GET_PAF_COMMENT_COUNT |
|
|
|
|
| ROKODSF.F_GET_CIPC_DESC |
|
LOAN_DISBURSEMENT |
PROGRAM_CLASSIFICATION_DESC |
|
| ROKODSF.F_GET_RORMVAL_DESC |
|
AWARD_BY_PERSON AWARD_BY_PERSON AWARD_BY_PERSON AWARD_BY_PERSON LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT AWARD_BY_PERSON LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION LOAN_DISBURSEMENT LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION LOAN_APPLICATION |
STUDENT_LOAN_OVERRIDE_DESC TIME_STATUS_DESC ACADEMIC_YEAR_OVERRIDE_DESC PELL_AWARD_ENROLLMENT_OPT_DESC PREP_TEACH_CERTIFICATION_DESC LOAN_TYPE_DESC YEAR_IN_COLLEGE_DESC DEFAULT_IND_DESC DEFAULT_IND_DESC ORIGINAL_CREDIT_STATUS_DESC ENROLLMENT_LOAD_OPTION_DESC CREDIT_ACTION_STATUS_DESC PLUS_CREDIT_CHECK_STATUS_DESC DISBURSEMENT_PROC_STATUS_DESC UNMET_NEED_OVERRIDE_DESC MPN_TYPE_DESC CREDIT_CHECK_OVERRIDDEN_DESC PROGRAM_OF_STUDY_DESC ENROLLMENT_STATUS_DESC CREDIT_ACTION_DESC CREDIT_CHK_APPEAL_STATUS_DESC DEPENDENCY_STATUS_DESC DISCLOSURE_REQUIRED_IND_DESC DL_MPN_STATUS_DESC |
|
| ROKODSF.F_GET_RORMVAL_DESC( RPRLAPP_LOAN_TYPE,RPRLAPP_AIDY_CODE, RPRLAPP_INFC_CODE,RPRLAPP_LOAN_TYPE) |
|
|
|
|
| SELECT DISTINCT(SUBSTR(FISCAL_PERIOD1, 63)) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE |
|
|
|
|
| SELECT DISTINCT(SUBSTR(FISCAL_YEAR,1,63) ) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE = PAF_TRANSACTION_STATUS |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS' AND VALUE =PAF_APPLY_STATUS |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS'AND VALUE =PAF_APPLY_STATUS |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255)FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE |
|
|
|
|
| SELECT SUBSTR(FISCAL_PERIOD,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE |
|
|
|
|
| SELECT SUBSTR(FISCAL_YEAR,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'ENCUMBRANCE_TYPE' AND VALUE = ENCUMBRANCE_TYPE |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRBEVNG_BEG_DATE_IND' AND VALUE = BEGIN_EVENT_RULE |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRBEVNG_FREQ_IND' AND VALUE = EVENT_FREQUENCY |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_DOCUMENT_BOX' AND VALUE = TAX_DOCUMENT_BOX_NUMBER |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_NOTIFICATION_STATUS' AND VALUE = FEDERAL_REPORT_STATUS |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_NOTIFICATION_STATUS' AND VALUE = NOTIFICATION_STATUS |
|
|
|
|
| SGKCLAS.F_CLASS_CODE |
|
|
|
|
| SOKODSF.F_CALCULATE_AGE_ADMIT |
|
|
|
|
| SOKODSF.F_CHECK_FOR_GRADUATE_IND |
|
|
|
|
| SOKODSF.F_COUNT_COMPLETED_OUTCOMES |
|
|
|
|
| SUM(NVL(AMRPEXP_EXPN_AMT, 0)) |
|
|
|
|
| SYSDATE |
|
|
|
|
| TBD |
|
|
|
|
| TBD?? |
|
|
|
|
| TO BE FILLED IN BY DEVELOPER |
|
|
|
|