Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: FUNCTION Travel And Expense Reporting View Meta Data Reports
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        


Ver: 8.5