Go To View:  -- Select a View -- AA_ADVANCEMENT_RATING AA_ANNUAL_GIVING AA_CAMPAIGN AA_CAMPAIGN_COMMENT AA_CAMPAIGN_DESIGNATION AA_CAMPAIGN_EXPENSE AA_CAMPAIGN_FUNDRAISER AA_CAMPAIGN_GIVING_HISTORY AA_CAMPAIGN_MAIL AA_CAMPAIGN_SOLICITATION AA_CONSTITUENT AA_CONSTITUENT_CONTACT AA_CONSTITUENT_PLAN AA_CONSTITUENT_STAFF_ASSIGN AA_CON_CONF_COMMENT_SUBJ AA_CON_ENTITY_CONF_COMMENT AA_DEGREE AA_DESIGNATION AA_DESIGNATION_ADJUSTMENT AA_DESIGNATION_ATTRIBUTE AA_DESIGNATION_CLASS_YEAR AA_DESIGNATION_COMMENT AA_DESIGNATION_COMMENT_SUBJ AA_DESIGNATION_FINAID_FUND AA_DESIGNATION_GIVING_HISTORY AA_DESIGNATION_ID AA_DONOR_CATEGORY AA_EXCLUSION AA_FUNDING_INTEREST AA_GIFT AA_GIFT_ASSOCIATED_ENTITY AA_GIFT_AUXILIARY AA_GIFT_MATCHING AA_GIFT_MEMO AA_GIFT_MULTIPLE AA_GIFT_SOCIETY AA_INTEREST AA_MAIL AA_MEMBERSHIP AA_MEMBERSHIP_DUES AA_MEMBERSHIP_INTEREST AA_ORGANIZATIONAL_CONSTITUENT AA_ORGANIZATION_CONTACT AA_ORGANIZATION_FUNDING_AREA AA_PLEDGE AA_PLEDGE_ASSOCIATED_ENTITY AA_PLEDGE_AUXILIARY AA_PLEDGE_CONDITIONAL AA_PLEDGE_INSTALLMENT AA_PLEDGE_MATCHING AA_PREVIOUS_EMPLOYMENT AA_PROJECT_INTEREST AA_PROSPECT_CONF_COMMENT AA_PROSPECT_CONF_COMMENT_SUBJ AA_PROSPECT_CONTACT_EXPENSE AA_PROSPECT_INFO AA_PROSPECT_MOVES_MANAGEMENT AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_RESULT AA_PROSPECT_STAFF_ASSIGNMENT AA_RELATIONSHIP AA_SALUTATION AA_SOLICITOR AA_SOLICITOR_ASSIGNMENT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORGANIZATION AA_SOLICITOR_ORG_COMMENT AA_SOLICITOR_ORG_FUNDRAISER AA_SOL_ORG_FUNDRAISER_GOAL AA_SOL_ORG_GOAL AA_SPECIAL_ACTIVITY AA_SPECIAL_ACTIVITY_YEAR AA_SPECIAL_PURPOSE_GROUP AA_VALIDATION AA_YEAR_TYPE_DEFINITION AE_ACCOUNTING AE_APPROVAL_HISTORY AE_AUTHORIZATION AE_CIRC_HEADER_STEP AE_CIRC_RECIP_NOTIF AE_DELEGATE_ASSIGNMENT AE_EXPENSE_ITEM AE_EXPENSE_ITEM_TAX AE_ITINERARY AE_PORTFOLIO AE_PROFILE AE_REIMBURSEMENT AE_STATUS_HISTORY AF_ACCOUNT_ATTRIBUTES_ODS AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_INDEX AF_ACCOUNT_TYPE_ATTRIBUTES_ODS AF_ACTIVITY_ATTRIBUTES_ODS AF_ATTRIBUTE_SETS_ODS AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_CHART_ATTRIBUTES_ODS AF_CHECKS AF_CLAUSE AF_ENCUMBRANCE AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_LEDGER AF_ENDOWMENT AF_ENDOWMENT_ATTRIBUTES AF_ENDOWMENT_DIST AF_ENDOWMENT_MARKET_VALUES AF_ENDOWMENT_UNITS AF_FISCAL_PERIOD AF_FIXED_ASSET_ADJUSTMENT AF_FIXED_ASSET_ATTRIBUTES AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_FIXED_ASSET_ITEM AF_FUND_ATTRIBUTES_ODS AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_TYPE_ATTRIBUTES_ODS AF_GENERAL_LEDGER AF_GRANT AF_GRANT_ATTRIBUTES_ODS AF_GRANT_BILLING_DETAIL AF_GRANT_DEFERRED_COST AF_GRANT_EVENT AF_GRANT_EVENT_STATUS AF_GRANT_FUND AF_GRANT_LEDGER AF_GRANT_PERSONNEL AF_INVOICE AF_INVOICE_ACCOUNTING AF_INVOICE_CHECK AF_INVOICE_ITEM AF_INVOICE_TAX_RATE AF_LOCATION_ATTRIBUTES_ODS AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL AF_OPERATING_LEDGER AF_ORGANIZATION_ATTRIBUTES_ODS AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL AF_PROGRAM_ATTRIBUTES_ODS AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_PROPOSAL AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ITEM AF_PURCHASE_ORDER_TAX_RATE AF_RECEIVED_ITEM AF_RETURNED_ITEM AF_TEXT AF_TRANSACTION_HISTORY AF_VALIDATION AF_VENDOR AF_VENDOR_TAXABLE_REPORTING AG_ALTERNATIVE_ID AG_COMMUNICATION AG_EVENT AG_EVENT_INVITEE AG_GEOGRAPHIC_REGION AG_GEOGRAPHIC_REGION_INST AG_INTERNET_ADDRESS AG_VALIDATION AN_EMPLOYEE_POSITION AN_FISCAL_YEAR AN_FMLA_LEAVE_COMMENT AN_JOB_FTE_TRACKING AN_LABOR_COST_DISTRIBUTION AN_PAYROLL_DISTRIBUTION AN_PERSONNEL_ACTION AN_PERSONNEL_ACTION_COMMENT AN_PERSONNEL_ACTION_EARNING AN_PERSONNEL_ACTION_GENERAL AN_PERSONNEL_ACTION_LABOR_DIST AN_POSITION_BUDGET AN_POSITION_DEFINITION AN_POSITION_LABOR_DISTRIBUTION AN_SALARY_RATE AN_SUPERVISOR AN_VALIDATION AP_BARGAINING_UNIT AP_BENEFICIARY_DEPENDENT AP_BENEFIT_DEDUCTION AP_CERTIFICATION AP_EARNING_TOTALS_CY AP_EARNING_TOTALS_FY AP_EMPLOYEE AP_EMPLOYEE_EARNING_CY AP_EMPLOYEE_EARNING_FY AP_FACULTY_APPOINTMENT_HISTORY AP_FACULTY_RANK_HISTORY AP_FACULTY_SABBATICAL_HISTORY AP_FAMILY_MEDICAL_LEAVE_HIST AP_HR_APPLICATION AP_HR_APPLICATION_STATUS AP_HR_REQUISITION AP_INTERVIEW AP_LEAVE_ACCRUAL AP_LEAVE_BALANCE AP_MONTHLY_DEDUCTION AP_PAST_EMPLOYMENT AP_PAYROLL_ATTENDANCE AP_PAYROLL_DEDUCTION AP_PAYROLL_DOCUMENT AP_PAYROLL_EARNING AP_PAYROLL_EMPLOYEE_POSITION AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_TIMESHEET AP_REFERENCE AP_REVIEW AP_SKILL AP_TAX AP_VALIDATION AP_YEARLY_DEDUCTION AR_APPLICANT_NEED AR_APPLICANT_RESOURCE AR_AWARD_BY_AID_YEAR AR_AWARD_BY_FUND AR_AWARD_BY_PERSON AR_AWARD_DISBURSEMENT AR_FINAID_APPLICANT_STATUS AR_FINAID_APPLICATION1 AR_FINAID_APPLICATION2 AR_FINAID_APPLICATION3 AR_FINAID_APPLICATION4 AR_FINAID_BUDGET_COMPONENT AR_FINAID_COMMENTS AR_FINAID_ENROLLMENT AR_FINAID_FUND AR_FINAID_HOLD AR_FINAID_MESSAGE AR_FINAID_TRACKING_REQUIREMENT AR_FUND_MESSAGE_RULE AR_LOAN_AGGREGATES AR_LOAN_APPLICATION AR_LOAN_DISBURSEMENT AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_OVERRIDE AR_NEED_ANALYSIS_PROFILE_SPEC AR_SATISFACTORY_ACAD_PROGRESS AR_STUDENT_PERIOD_DEFINITION AR_USER_DEFINED_FIELDS AR_VALIDATION AR_YEAR_TYPE_DEFINITION AS_ACADEMIC_HISTORY_EVENT AS_ACADEMIC_OUTCOME AS_ACADEMIC_STANDING AS_ACTIVE_TERMS AS_ADDRESS AS_ADMINISTRATOR AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_ATTRIBUTE AS_ADMISSIONS_COHORT AS_ADMISSIONS_DECISION AS_ADMISSIONS_RATING AS_ADMISSIONS_REQUIREMENT AS_ADMISSIONS_SOURCE AS_ADVISOR AS_CONTACT AS_COURSE_ATTRIBUTE AS_COURSE_CATALOG AS_COURSE_COREQ AS_COURSE_LEVEL AS_COURSE_OFFERING AS_COURSE_OFFERING_FEES AS_COURSE_PREREQ AS_COURSE_SCHEDULE AS_COURSE_SUPPLEMENTAL AS_CURRICULUM AS_CURRICULUM_FOS AS_DISABILITY_INFORMATION AS_ENROLLMENT AS_ENROLLMENT_HISTORY AS_ENROLLMENT_WITHDRAWAL AS_FACULTY AS_FACULTY_ATTRIBUTE AS_FACULTY_CONTRACT AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK_DETAIL AS_FIELD_OF_STUDY AS_GENERAL_STUDENT AS_GENSTU_END_TERM AS_GPA_LEVEL AS_GPA_TERM AS_HOLD AS_INSTITUTION AS_INSTITUTION_CHARACTERISTIC AS_INSTITUTION_DEMOGRAPHIC AS_INSTRUCTIONAL_ASSIGNMENT AS_INTEREST AS_LEARNER_CURRICULUM_FOS AS_MEAL_ASSIGNMENT AS_MEDICAL_INFORMATION AS_MEETING_TIME AS_NONINSTRUCTIONAL_ASSIGNMENT AS_OFFERING_COREQ AS_OFFERING_GRADE_MODE AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_ORGANIZATION_ENTITY AS_OUTCOME_HONOR_DEPT AS_OUTCOME_HONOR_INST AS_PERSON AS_PHONE_ASSIGNMENT AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_HSCH AS_PREVIOUS_EDUCATION_PCOL AS_PRE_STUDENT AS_RACE AS_RECRUITMENT_ATTRIBUTE AS_RECRUITMENT_COHORT AS_RECRUITMENT_INFORMATION AS_RECRUITMENT_LEARNED AS_RECRUITMENT_SOURCE AS_ROOM_ASSIGNMENT AS_SCHEDULE_ATTRIBUTE AS_SECONDARY_SCHOOL_SUBJECT AS_SPORT AS_STUDENT_ACTIVITY AS_STUDENT_ATTRIBUTE AS_STUDENT_CLASSIFICATION AS_STUDENT_COHORT AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_ATTR_TRANS AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_REG_AUDIT AS_STUDENT_COURSE_TRANSFER AS_STUDENT_TRANSFERRED_COURSE AS_STUDENT_WORK_EXPERIENCE AS_TELEPHONE AS_TEST AS_TRANSCRIPT_LEVEL_COMMENT AS_TRANSCRIPT_TERM_COMMENT AS_VALIDATION AS_VETERAN_CERTIFICATION AS_VISA AS_YEAR_TYPE_DEFINITION AT_ACCOUNT AT_ACCOUNT_DETAIL AT_APPLICATION_OF_PAYMENT AT_AR_DEPOSIT AT_CONTRACT AT_CONTRACT_PAYMENT_DETAIL AT_EXEMPTION AT_GRANT_ACCOUNT_DETAIL AT_GRANT_APPLICATION_PAYMENT AT_INSTALLMENT_PLAN AT_LEDGER_ACCOUNTING AT_MEMO AT_MISCELLANEOUS_TRANSACTION AT_STUDENT_TAX_NOTIFICATION AT_VALIDATION

RETURN TO COMPOSITE VIEW REPORTS LIST

Reporting View Source: FUNCTION Travel And Expense

SGHE Banner Operational Data Store

Composite 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)
ACTIVE_HOLD_IND
AOKODSF.F_GET_PROJ_ASSIGN_PROS_IND( AMRPROP_PIDM, AMRPROP_PROJ_CODE)
AOKODSF.F_GET_STAFF_INDICATOR
CASE WHEN ACADEMIC_TIME_KEY = ACADEMIC_TIME_KET THEN ACADEMIC_STUDY_KEY ELSE 0
CASE WHEN AMRINFO_SYS_IND
CASE WHEN BIRTH_DATE IS NULL THEN NULL WHEN TRUNC(MONTH_BETWEEN)<23 THEN 1 ELSE 0
CASE WHEN CHANGED_MAJOR_COUNT>0 THEN ACADEMIC_STUDY_CHANGE_IND = 1 ELSE 0
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
CASE WHEN VETERAN_TYPE <> MTVPARM_DESC AND VETERAN_CATEGORY <> 0 THEN 1 ELSE 0
CASE WHEN VISA_TYPE <> MTVPARM_DESC AND DEMOGRAPHIC_KEY <> 0 THEN 1 ELSE 0
COUNT(*) FROM WFT_STUDENT_COURSE
DECODE(DFAS.FM_FULLY_MET_NEED_IND,Y, S.PERSON_UID,NULL)
DECODE(DFAS.FM_FULLY_MET_NEED_IND,Y, S.PERSON_UID,NULL)
DECODE(DFAS.FM_NEED_ELIGIBLE_IND,Y, S.PERSON_UID,NULL)
DECODE(DFAS.FM_NEED_ELIGIBLE_IND,Y, S.PERSON_UID,NULL)
DECODE(DFAS.IM_NEED_ELIGIBLE_IND,Y, S.PERSON_UID,NULL)
DECODE(DS.HOUSING_IND,Y,S.PERSON_UID, NULL)
DECODE(DS.HOUSING_IND,Y,S.PERSON_UID, NULL)
DECODE(DSS.ACAD_HISTORY_EXISTS_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.ACAD_HISTORY_EXISTS_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.COOP_ED_PARTICIPANT_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.COOP_ED_PARTICIPANT_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.ENROLLED_IND,1,S.PERSON_UID, NULL)
DECODE(DSS.ENROLLED_IND,1,S.PERSON_UID, NULL)
DECODE(DSS.ENROLL_BY_CENSUS_DATE1_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.ENROLL_BY_CENSUS_DATE1_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.ENROLL_BY_CENSUS_DATE2_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.ENROLL_BY_CENSUS_DATE2_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.GRADUATE_CREDIT_ELIG_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.GRADUATE_CREDIT_ELIG_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.MATRICULATED_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.MATRICULATED_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.NEW_STUDENT_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.NEW_STUDENT_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.PERMIT_REGISTRATION_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.REGISTERED_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.REGISTERED_IND,1, S.PERSON_UID,NULL)
DECODE(DSS.WITHDRAWN_IND,1,S.PERSON_UID, NULL)
DECODE(DSS.WITHDRAWN_IND,1,S.PERSON_UID, NULL)
DECODE(FRBEVNG_PMT_METHOD_TYPE_IND)
DECODE(GOKODSF.F_GET_DESC)
DECODE(MST_RACE.RACE_CATEGORY)
DECODE(NOT_RETAINED_COLLEGE_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_C
DECODE(NOT_RETAINED_COLLEGE_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_C
DECODE(NOT_RETAINED_OVERALL_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_HEADCOUNT
DECODE(NOT_RETAINED_OVERALL_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT
DECODE(NOT_RETAINED_PROGRAM_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_P
DECODE(NOT_RETAINED_PROGRAM_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_P
DECODE(NOT_RETAINED_STDLEVL_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_S,
DECODE(NOT_RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_S
DECODE(RETAINED_COLLEGE_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_C
DECODE(RETAINED_COLLEGE_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_C
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_C
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_P
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_SXCLUDE_HEADC OUNT_S
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_C
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_P
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_S
DECODE(RETAINED_PROGRAM_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_P
DECODE(RETAINED_PROGRAM_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_P
DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_S
DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_S
DECODE(STVRESD_IN_STATE_IND)
DECODE(YEAR1_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR1_GRAD_EXCLUDE_HEADCOUNT,
DECODE(YEAR1_GRADUATION_IND,1,PERSON_IN, NULL) YEAR1_GRADUATION_HEADCOUNT,
DECODE(YEAR1_RETAINED_IND,1,PERSON_IN, NULL)
DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR2_GRAD_EXCLUDE_HEADCOUNT
DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR2_RET_EXCLUDE_HEADCOUNT,
DECODE(YEAR2_GRADUATION_IND,1,PERSON_IN, NULL) YEAR2_GRADUATION_HEADCOUNT
DECODE(YEAR2_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR2_NOT_REGISTERED_HEADCOUNT,
DECODE(YEAR2_RETAINED_IND,1,PERSON_IN, NULL) YEAR2_REGISTERED_HEADCOUNT,
DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR3_GRAD_EXCLUDE_HEADCOUNT,
DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR3_RET_EXCLUDE_HEADCOUNT,
DECODE(YEAR3_GRADUATION_IND,1,PERSON_IN, NULL) YEAR3_GRADUATION_HEADCOUNT,
DECODE(YEAR3_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR3_NOT_REGISTERED_HEADCOUNT,
DECODE(YEAR3_RETAINED_IND,1,PERSON_IN, NULL)YEAR3_REGISTERED_HEADCOUNT,
DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR4_GRAD_EXCLUDE_HEADCOUNT,
DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR4_RET_EXCLUDE_HEADCOUNT,
DECODE(YEAR4_GRADUATION_IND,1,PERSON_IN, NULL) YEAR4_GRADUATION_HEADCOUNT,
DECODE(YEAR4_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR4_NOT_REGISTERED_HEADCOUNT,
DECODE(YEAR4_RETAINED_IND,1,PERSON_IN, NULL)YEAR4_REGISTERED_HEADCOUNT,
DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR5_GRAD_EXCLUDE_HEADCOUNT,
DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR5_RET_EXCLUDE_HEADCOUNT
DECODE(YEAR5_GRADUATION_IND,1,PERSON_IN, NULL) YEAR5_GRADUATION_HEADCOUNT,
DECODE(YEAR5_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR5_NOT_REGISTERED_HEADCOUNT,
DECODE(YEAR5_RETAINED_IND,1,PERSON_IN, NULL)YEAR5_REGISTERED_HEADCOUNT,
DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_GRAD_EXCLUDE_HEADCOUNT
DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_RET_EXCLUDE_HEADCOUNT
DECODE(YEAR6_GRADUATION_IND,1,PERSON_IN, NULL) YEAR6_GRADUATION_HEADCOUNT
DECODE(YEAR6_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR6_NOT_REGISTERED_HEADCOUNT,
DECODE(YEAR6_RETAINED_IND,1,PERSON_IN, NULL)YEAR6_REGISTERED_HEADCOUNT,
DECODE(YEAR7_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR7_GRAD_EXCLUDE_HEADCOUNT,
DECODE(YEAR7_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR7_RET_EXCLUDE_HEADCOUNT,
DECODE(YEAR7_GRADUATION_IND,1,PERSON_IN, NULL) YEAR7_GRADUATION_HEADCOUNT,
DECODE(YEAR7_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR7_NOT_REGISTERED_HEADCOUNT,
DECODE(YEAR7_RETAINED_IND,1,PERSON_IN, NULL)YEAR7_REGISTERED_HEADCOUNT,
DECODE(YEAR8_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR8_GRAD_EXCLUDE_HEADCOUNT
DECODE(YEAR8_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR8_RET_EXCLUDE_HEADCOUNT
DECODE(YEAR8_GRADUATION_IND,1,PERSON_IN, NULL) YEAR8_GRADUATION_HEADCOUNT,
DECODE(YEAR8_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR8_NOT_REGISTERED_HEADCOUNT,
DECODE(YEAR8_RETAINED_IND,1,PERSON_IN, NULL)YEAR8_REGISTERED_HEADCOUNT,
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
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_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(COURSE_CREDITS )
SUM(COURSE_CREDITS_ATTEMPTED ) TOTAL_CREDITS_ATTM,
SUM(COURSE_CREDITS_EARNED ) TOTAL_CREDITS_EARN,
SUM(COURSE_CREDITS_FOR_GPA ) TOT_CRED_GPA
SUM(COURSE_CREDITS_PASSED ) TOTAL_CREDITS_PASS,
SUM(FINAL_GRADE_QUALITY_POINTS ) FINAL_GRD_QLTY_PNTS,
SUM(NVL(AMRPEXP_EXPN_AMT, 0))
SYSDATE
TBD
TBD??
CASE WHEN (INGRP1.ATVCFAE_TYPE >= 1 AND INGRP1.ATVCFAE_TYPE < 12) THEN 'CURRENT OPERATIONS' WHEN ( INGRP1.ATVCFAE_TYPE IN (20,21,32)) THEN 'CAPITAL PURPOSES' WHEN (INGRP1.ATVCFAE_TYPE >= 22 AND INGRP1.ATVCFAE_TYPE < 32) THEN 'ENDOWMENT RESTRICTED' END
CASE WHEN (INGRP1.ATVCFAE_TYPE >= 1 AND INGRP1.ATVCFAE_TYPE < 12) THEN'CURRENT OPERATIONS' WHEN ( INGRP1.ATVCFAE_TYPE IN (20,21,32)) THEN'CAPITAL PURPOSES' WHEN (INGRP1.ATVCFAE_TYPE >= 22 AND INGRP1.ATVCFAE_TYPE < 32) THEN'ENDOWMENT RESTRICTED' END
CASE WHEN INGRP1.ADRFUND_DESG = INGRP1.ADBDESG_DESG THEN 1 ELSE 0 END
CASE WHEN INGRP1.ADRFUND_DESG = INGRP1.ADBDESG_DESG THEN YES ELSE NO END
SUM(F.COURSE_CREDITS_ATTEMPTED ) CUMULATIVE_CREDITS_ATTEMPTED,
SUM(F.COURSE_CREDITS_EARNED ) CUMULATIVE_CREDITS_EARNED,
SUM(F.COURSE_CREDITS_FOR_GPA ) CUMULATIVE_CREDITS_FOR_GPA
SUM(F.COURSE_CREDITS_PASSED ) CUMULATIVE_CREDITS_PASSED,
SUM(F.FINAL_GRADE_QUALITY_POINTS ) CUMULATIVE_QUALITY_POINTS,
TO BE FILLED IN BY DEVELOPER

Ver: