Reporting View Source: CALCULATION

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: CALCULATION Travel And Expense Reporting View Meta Data Reports

**Banner Operational Data Store**
Source Column	Source Form	Local Source	Target Type	Target	Target Column	Local Target	Calculation Formula
(APPLIED_AMOUNT * (CLGR.PERCENT/100) * ( PLGR.PERCENT/100))	NA	NO	REPORTING VIEW	APPL_OF_PAY_DETAIL_ACCOUNTING	APPLIED_AMOUNT	NO	Calculates acutal amount applied to the transaction based upon accounting distribution percentages.
(FGBOPAL_XX_ADOPT_BUD + FGBOPAL_XX_BUD_ADJT) - ( FGBOPAL_XX_YTD_ACTV + FGBOPAL_XX_ENCUMB + FGBOPAL_XX_BUD_RSRV) - (FGBOPAL_XX- 1_ADOPT_BUD + FGBOPAL_XX-1_BUD_ADJT) - ( FGBOPAL_XX-1_YTD_ACTV + FGBOPAL_XX- 1_ENCUMB + FGBOPAL_XX-1_BUD_RSRV)	NA	NO	REPORTING VIEW	OPERATING_LEDGER	CURR_REMAINING_BALANCE	NO
(FGBOPAL_XX_ADOPT_BUD+ FGBOPAL_XX_BUD_ADJT)-( FGBOPAL_XX_YTD_ACTV+FGBOPAL_XX_ENCUMB+ FGBOPAL_XX_BUD_RSRV)	FGIBDST	NO	REPORTING VIEW	OPERATING_LEDGER	SUM_REMAINING_BALANCE	NO	This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes all activity up to and including this period.
(FRRGRNL_XX_ADOPT_BUD + FRRGRNL_XX_BUD_ADJT - FRRGRNL_XX_YTD_ACTV - FRRGRNL_XX_ENCUMB - FRRGRNL_XX_BUD_RSRV)	FRIGITD	NO	REPORTING VIEW	GRANT_LEDGER	SUM_REMAINING_BALANCE	NO	This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes all activity up to and including this period.
(FRRGRNL_XX_ADOPT_BUD + FRRGRNL_XX_BUD_ADJT) - ( FRRGRNL_XX_YTD_ACTV + FRRGRNL_XX_ENCUMB + FRRGRNL_XX_BUD_RSRV) - (FRRGRNL_XX- 1_ADOPT_BUD + FRRGRNL_XX-1_BUD_ADJT) - ( FRRGRNL_XX-1_YTD_ACTV + FRRGRNL_XX- 1_ENCUMB + FRRGRNL_XX-1_BUD_RSRV)	FRIGITD	NO	REPORTING VIEW	GRANT_LEDGER	CURR_REMAINING_BALANCE	NO	This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes only activity in this period.
(MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES + MAKFUNC.F_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100	NA	NO	REPORTING VIEW	CAMPAIGN	PCT_PROGRESS_CAMPAIGN_GOAL	NO
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100	NA	NO	REPORTING VIEW	CAMPAIGN_DESIGNATION	PCT_DESG_PROGRESS_CAMP_GOAL	NO
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFRDESG_GOAL * 100	NA	NO	REPORTING VIEW	CAMPAIGN_DESIGNATION	PCT_PROGRESS_DESIGNATION_GOAL	NO
(MAKFUNC.F_ORG_TOTAL_GIFTS + MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100	NA	NO	REPORTING VIEW	SOLICITOR_ORGANIZATION	PCT_PROGRESS_ORGANIZATION_GOAL	NO
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100	NA	NO	REPORTING VIEW	CAMPAIGN_SOLICITATION	PCT_SOLT_PROGRESS_CAMP_GOAL	NO
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFRCSOL_GOAL * 100	NA	NO	REPORTING VIEW	CAMPAIGN_SOLICITATION	PCT_PROGRESS_SOLT_GOAL	NO
(MAKFUNC.F_SOL_FR_TOTAL_PLEDGES + MAKFUNC.F_SOL_FR_TOTAL_GIFTS + MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100	NA	NO	REPORTING VIEW	SOLICITOR_ORG_FUNDRAISER	PCT_SOLICITOR_PROG_ORG_GOAL	NO
(NVL(FARINVC_APPR_QTY,0)*NVL( FARINVC_APPR_UNIT_PRICE,0))+NVL( FARINVC_ADDL_CHRG_AMT,0)+NVL( FARINVC_TAX_AMT,0)-NVL(FARINVC_DISC_AMT, 0)	FAAINVE	NO	REPORTING VIEW	INVOICE_ITEM	APPROVED_ITEM_AMOUNT	NO	This calculation returns the approved item amount for the invoice item. The amount is calculated as the approved quantity multiplied by the unit price plus any additional charges and tax amount and then subtracting any discount.
(NVL(FBVBLDL_BUDG_AMT,0)+NVL( FBVBLDL_ADJT_AMT,0))	FBABDMN	NO	REPORTING VIEW	BUDGET_DETAIL	BUDGET_AMOUNT	NO	This calculation returns the budgeted amount by adding the original budget to any budget adjustments.
(NVL(FPRPODT_QTY,0)*NVL( CONVERTED_FPRPODT_UNIT_PRICE,0))+NVL( FPRPODT_CONVERTED_ADDL_CHRG_AMT,0)+NVL( FPRPODT_CONVERTED_TAX_AMT,0)-NVL( FPRPODT_CONVERTED_DISC_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_APPROVED_ITEM_AMOUNT	NO
(NVL(FPRPODT_QTY,0)*NVL( FPRPODT_UNIT_PRICE,0))+NVL( FPRPODT_ADDL_CHRG_AMT,0)+NVL( FPRPODT_TAX_AMT,0)-NVL(FPRPODT_DISC_AMT, 0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY PURCHASE_ORDER_ITEM	APPROVED_ITEM_AMOUNT APPROVED_ITEM_AMOUNT	NO NO	This calculation returns the approved item amount for the purchase order item. The amount is calculated as the approved quantity multiplied by the unit price plus any additional charges and tax amount and then subtracting any discount.
AARMEMB_AMT_QUALIFY - AOKODSF.F_GET_MEMBER_AMT_PAID	NA	NO	REPORTING VIEW	MEMBERSHIP	MEMBERSHIP_DUES_AMOUNT_OWED	NO
ACCT.PAY_CURRENCY_AMOUNT - ACCT.PAY_CURRENCY_AMOUNT_NO_TAX	NA	NO	REPORTING VIEW	AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING	PAY_CURRENCY_TAX_AMOUNT PAY_CURRENCY_TAX_AMOUNT	NO NO
AFRCSOL_GOAL / AFBCAMP_GOAL * 100	NA	NO	REPORTING VIEW	CAMPAIGN_SOLICITATION	SOLT_PERCENT_OF_CAMPAIGN_GOAL	NO
AFRDESG_GOAL / AFBCAMP_GOAL * 100	NA	NO	REPORTING VIEW	CAMPAIGN_DESIGNATION	DESG_PERCENT_OF_CAMPAIGN_GOAL	NO
AGBMGID_AMT - AGBMGID_AMT_PAID	NA	NO	REPORTING VIEW	GIFT_MATCHING_TRANSACTION	MATCH_GIFT_BALANCE	NO	NA
AGRGDES_AMT-F_GIFT_HARD_CREDIT	NA	NO	REPORTING VIEW	GIFT	GIFT_CREDIT_AMOUNT	NO	NA
AGRPDES_AMT-AGRPDES_AMT_PAID	NA	NO	REPORTING VIEW	PLEDGE	PLEDGE_BALANCE	NO	NA
AGRPDES_AMT-F_PLEDGE_HARD_CREDIT	NA	NO	REPORTING VIEW	PLEDGE	PLEDGE_CREDIT	NO	NA
AGRPDES_AMT_PAID - SUM(AGRPDES_AMT_PAID)	NA	NO	REPORTING VIEW	PLEDGE_TRANSACTION	PLEDGE_TRANS_BALANCE	NO
AORCONT_FAX_AREA\|\|AORCONT_FAX_NUMBER\|\|AO RCONT_FAX_EXT	NA	NO	REPORTING VIEW	ORGANIZATION_CONTACT	FAX_NUMBER_COMBINED	NO
AORCONT_PHONE_AREA\|\|AORCONT_PHONE_NUMBER \|\|AORCONT_PHONE_EXT	NA	NO	REPORTING VIEW	ORGANIZATION_CONTACT	PHONE_NUMBER_COMBINED	NO
ASBSORG_UPD_WEB_IND	NA	NO	REPORTING VIEW	SOLICITOR_ORGANIZATION	ALLOW_WEB_UPDATE_IND	NO
ASRSORG_DOLLAR_GOAL / ASBSORG_DOLLAR_GOAL * 100	NA	NO	REPORTING VIEW	SOLICITOR_ORG_FUNDRAISER	SOLICITOR_PCT_OF_ORG_GOAL	NO
ASRSORG_UPD_WEB_IND	NA	NO	REPORTING VIEW	CAMPAIGN_FUNDRAISER	ALLOW_WEB_UPDATE_SOLICITOR_IND	NO
CASE NBBPOSN_PREMIUM_ROLL_IND	TBD	NO	REPORTING VIEW	POSITION_DEFINITION	PREMIUM_EARNINGS_ROLL_IND_DESC	NO
CASE NBBPOSN_ROLL_IND	TBD	NO	REPORTING VIEW	POSITION_DEFINITION	BUDGET_ROLL_IND_DESC	NO
CASE SFRFFST_STATUS_CDE WHEN	TBD	NO	REPORTING VIEW	FACULTY_FEEDBACK	FEEDBACK_STATUS_DESC	NO
CASE STVFFVA_TYPE WHEN	NA	NO
CASE STVFFVA_TYPE WHEN 'ISSUE' THEN 'ISSUE' WHEN 'RECOMMEND' THEN 'RECOMMENDATION' END	TBD	NO	REPORTING VIEW	FACULTY_FEEDBACK_DETAIL	FEEDBACK_TYPE_DESC	NO
CASE SYS.ANYDATA.GETTYPENAME( GORSDAV_VALUE)	TBD	NO	REPORTING VIEW	SUPPLEMENTAL_DATA	ATTRIBUTE_VALUE	NO	This calculation retrieves the value from GORSDAV_VALUE based on datatype.
CASE STATEMENT	NA	NO	REPORTING VIEW	STUDENT_COURSE	REGISTRATION_OVERRIDE_IND	NO	(CASE WHEN ( SFRSTCR_DUPL_OVER = 'Y' OR SFRSTCR_LINK_OVER = 'Y' OR SFRSTCR_CORQ_OVER = 'Y' OR SFRSTCR_PREQ_OVER = 'Y' OR SFRSTCR_TIME_OVER = 'Y' OR SFRSTCR_CAPC_OVER = 'Y' OR SFRSTCR_LEVL_OVER = 'Y' OR SFRSTCR_COLL_OVER = 'Y' OR SFRSTCR_MAJR_OVER = 'Y' OR SFRSTCR_CLAS_OVER = 'Y' OR SFRSTCR_APPR_OVER = 'Y' OR SFRSTCR_REPT_OVER = 'Y' OR SFRSTCR_RPTH_OVER = 'Y' OR SFRSTCR_TEST_OVER = 'Y' OR SFRSTCR_CAMP_OVER = 'Y' OR SFRSTCR_DEGC_OVER = 'Y' OR SFRSTCR_PROG_OVER = 'Y' OR SFRSTCR_DEPT_OVER = 'Y' OR SFRSTCR_ATTS_OVER = 'Y' OR SFRSTCR_CHRT_OVER = 'Y' OR SFRSTCR_MEXC_OVER = 'Y') THEN 'Y' ELSE 'N' END)
CASE WHEN (C.DAP_TRANSFER = 'C') AND ( C.DAP_INPROGRESS = 'N')	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE AUDIT_STUDENT_COURSE	COURSE_SOURCE_DESC COURSE_SOURCE	NO NO
CASE WHEN (RCRAPP1_SEQ_NO	NA	NO	REPORTING VIEW	FINAID_APPLICANT_STATUS FINAID_APPLICANT_STATUS FINAID_APPLICANT_STATUS	IM_APPLICATION_IND FINANCIAL_AID_APPLICATION_IND FM_APPLICATION_IND	NO NO NO
CASE WHEN A.ADVANCE_STATUS = 'O' THEN 'OUTSTANDING' WHEN A.ADVANCE_STATUS = 'R' THEN 'RECONCILED' WHEN A.ADVANCE_STATUS = 'D' THEN 'OVERDUE' ELSE 'UNKNOWN' END	TBD	NO	REPORTING VIEW	AUTHORIZATION	ADVANCE_STATUS_DESC	NO
CASE WHEN AORCONT_CONT_ORG_IND	NA	NO	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_ADDRESS_SOURCE_DESC	NO
CASE WHEN AORCONT_EMAL_SRC_IND	NA	NO	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_EMAIL_SOURCE_DESC	NO
CASE WHEN AORCONT_FAX_SRC_IND	NA	NO	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_FAX_SOURCE_DESC	NO
CASE WHEN AORCONT_PRIMARY_IND	NA	NO	REPORTING VIEW	ORGANIZATION_CONTACT	PRIMARY_CONTACT_IND	NO
CASE WHEN AORCONT_TELE_SRC_IND	NA	NO	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_PHONE_SOURCE_DESC	NO
CASE WHEN APPROVAL_METHOD	NA	NO	REPORTING VIEW	REGISTRATION_PLAN	APPROVAL_METHOD_DESC	NO
CASE WHEN APPROVAL_STATUS	NA	NO	REPORTING VIEW	REGISTRATION_PLAN	APPROVAL_STATUS_DESC	NO
CASE WHEN CONTACT_DECEASED_IND	NA	NO	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_DECEASED_IND_DESC	NO
CASE WHEN DAP_AUDIT_TYPE	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE AUDIT_STUDENT_BLOCK AUDIT_COURSE_NEEDED EXCEPTION_APPLIED AUDIT_STUDENT_NON_COURSE	AUDIT_TYPE_DESC AUDIT_TYPE_DESC AUDIT_TYPE_DESC AUDIT_TYPE_DESC AUDIT_TYPE_DESC	NO NO NO NO NO
CASE WHEN DAP_REASON_INSUF	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	INSUFFICIENT_REASON_DESC	NO
CASE WHEN DAP_RESULT_TYPE	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE	AUDIT_RESULT_TYPE_DESC AUDIT_RESULT_TYPE_DESC	NO NO
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	COURSE_APPLIED_IND	NO
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' AND AUDIT_TYPE = 'PL'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	PLANNED_COURSE_IND	NO
CASE WHEN DAP_RESULT_TYPE = 'CLASSNEEDED'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	COURSE_NEEDED_IND	NO
CASE WHEN DAP_RESULT_TYPE = 'FALLCLASSAPPLIED'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	COURSE_FALLTHROUGH_IND	NO
CASE WHEN DAP_RESULT_TYPE = 'FALLNONCRAPPLIED'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_NON_COURSE	NONCOURSE_FALLTHROUGH_IND	NO
CASE WHEN DAP_RESULT_TYPE = 'INSUFFCLASSAPPLIED'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	COURSE_INSUFFICIENT_IND	NO
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_NON_COURSE	NONCOURSE_APPLIED_IND	NO
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' AND AUDIT_TYPE = 'PL' AND SUBSTR(VALUE3,1,2) = 'PN'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_NON_COURSE	PLANNED_NON_COURSE_IND	NO
CASE WHEN DAP_RESULT_TYPE = 'NONCRNEEDED'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_NON_COURSE	NONCOURSE_NEEDED_IND	NO
CASE WHEN DAP_RESULT_TYPE = 'OTLCLASSAPPLIED'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	COURSE_OVER_THE_LIMIT_IND	NO
CASE WHEN DAP_TRANSFER = 'C' AND DAP_INPROGRESS = 'N'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	INSTITUTION_COURSE_IND	NO
CASE WHEN DAP_TRANSFER = 'T'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	TRANSFER_COURSE_IND	NO
CASE WHEN ENCUMBRANCE_NUMBER	NA	NO	REPORTING VIEW	ENCUMBRANCE_ACCOUNTING ENCUMBRANCE	HR_ENCUMBRANCE_IND HR_ENCUMBRANCE_IND	NO NO
CASE WHEN FABBKTP_RECON_IND	NA	NO	REPORTING VIEW	INVOICE_CHECK	BANK_RECONCILIATION_IND_DESC	NO
CASE WHEN FABCHKS_CHECK_TYPE_IND	NA	NO	REPORTING VIEW	INVOICE_CHECK	CHECK_TYPE_DESC	NO
CASE WHEN FABCHKS_PAY_TYPE	NA	NO	REPORTING VIEW	INVOICE_CHECK	PAY_TYPE_DESC	NO	Hard code a pay type description based upon the pay_type value CASE WHEN FABCHKS_PAY_TYPE = 'Check' THEN 'Check' WHEN FABCHKS_PAY_TYPE = 'ACH' THEN 'Direct Deposit' WHEN FABCHKS_PAY_TYPE = 'vCard' THEN 'Virtual Card' WHEN FABCHKS_PAY_TYPE = 'PNE' THEN 'Temporary Pay Type' WHEN FABCHKS_PAY_TYPE = 'Wire' THEN 'Wire Transfer' END
CASE WHEN FABCHKS_RECON_IND	NA	NO	REPORTING VIEW	INVOICE_CHECK	RECONCILIATION_IND_DESC	NO
CASE WHEN FABRUIV_SUB_IND	NA	NO	REPORTING VIEW	INVOICE	REPEATING_FREQUENCY_DESC	NO
CASE WHEN FGBENCD_CMT_TYPE	NA	NO	REPORTING VIEW	AF_ENCUMBRANCE_ACCOUNTING	COMMITMENT_TYPE_DESC	NO
CASE WHEN FGBENCD_FIELD_CODE	NA	NO	REPORTING VIEW	ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING	FIELD_CODE_DESC FIELD_CODE_DESC	NO NO
CASE WHEN FTVVEND_CHECK_PIDM IS NULL	NA	NO	REPORTING VIEW	VENDOR VENDOR AF_VENDOR AF_VENDOR	REMIT_TO_ADDRESS_NUMBER REMIT_TO_ADDRESS_TYPE REMIT_TO_ADDRESS_NUMBER REMIT_TO_ADDRESS_TYPE	NO NO NO NO
CASE WHEN GROUP_TYPE	NA	NO	REPORTING VIEW	PLAN_TEMPLATE_COURSE	TEMPLATE_GROUP_TYPE_DESC	NO	CASE RTRIM (G.GROUP_TYPE) WHEN 'UN' THEN G$_NLS.GET ('DPVTMCR-0001', 'SQL', 'Union within group') WHEN 'CH' THEN G$_NLS.GET ('DPVTMCR-0002', 'SQL', 'Choice within group') WHEN 'NA' THEN G$_NLS.GET ('DPVTMCR-0003', 'SQL', 'Not applicable') END
CASE WHEN HR_ENCUMBRANCE_IND	NA	NO	REPORTING VIEW	ENCUMBRANCE_ACCOUNTING ENCUMBRANCE_ACCOUNTING ENCUMBRANCE_ACCOUNTING	LABOR_ITEM_TYPE HR_ENCUMBRANCE_PERIOD_DESC HR_ENCUMBRANCE_PERIOD	NO NO NO
CASE WHEN NORTRAN_AUBK_CODE = 'SPRIDEN' THEN 'IDEN'	NA	NO	REPORTING VIEW	PERSONNEL_ACTION_GENERAL	PAF_TRANSACTION_TYPE	NO
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE =	NA	NO	REPORTING VIEW	RECEIVABLE_ACCOUNTING RECEIVABLE_ACCOUNT_DETAIL	DESIGNATOR_TYPE DESIGNATOR_TYPE	NO NO	Tests to determine if the detail code is term based or aid year based detail code or neither CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = 'T' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE = 'A' ELSE DESIGNATOR_TYPE = 'N' END CASE;
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC =	NA	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL RECEIVABLE_ACCOUNTING	DESIGNATOR_TYPE_DESC DESIGNATOR_TYPE_DESC	NO NO	Hard code the description based upon the designator type. CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE_DESC = 'Academic period-based' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE_DESC = 'Aid year-based' ELSE DESIGNATOR_TYPE_DESC = 'No designator' END CASE;
CASE WHEN NVL(TBBEACT_TBDC_IND, 'N')	NA	NO	REPORTING VIEW	RECEIVABLE_ACCOUNTING	DESIGNATOR	NO
CASE WHEN OFFICIAL_TRACKING_STATUS	NA	NO	REPORTING VIEW	REGISTRATION_PLAN REGISTRATION_PLAN	OFFICIAL_TRACKING_STATUS_DESC PLAN_TRACK_STATUS_DESC	NO NO
CASE WHEN PLAN_SOURCE	NA	NO	REPORTING VIEW	REGISTRATION_PLAN	PLAN_SOURCE_DESC	NO
CASE WHEN R.DAP_RESULT_TYPE = 'CLASSNEEDED' THEN 'N' WHEN R.DAP_RESULT_TYPE <> 'CLASSNEEDED' AND R.DAP_AUDIT_TYPE = 'PL'	NA	NO	REPORTING VIEW	AUDIT_STUDENT_COURSE	IN_PROGRESS_COURSE_IND	NO
CASE WHEN RBRAPBC_SYS_IND = 'S'	TBD	NO	REPORTING VIEW	PERIOD_BUDGET_COMPONENT	COMPONENT_SOURCE_DESC	NO
CASE WHEN RFRASPC_DIRECT_LOAN_IND	NA	NO	REPORTING VIEW	FINAID_FUND	DIRECT_LOAN_TYPE_DESC	NO
CASE WHEN RFRASPC_EL_LOAN_IND	NA	NO	REPORTING VIEW	FINAID_FUND	ELECTRONIC_LOAN_TYPE_DESC	NO
CASE WHEN RFRASPC_MANUAL_LOAN_IND	NA	NO	REPORTING VIEW	FINAID_FUND	MANUAL_LOAN_TYPE_DESC	NO
CASE WHEN RORSTAT_ADDL_PELL_ELIB_IND	NA	NO	REPORTING VIEW	FINAID_APPLICANT_STATUS	ADDITIONAL_PELL_AWARDS_DESC	NO
CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND	NA	NO	REPORTING VIEW	FINAID_APPLICANT_STATUS	ADDITIONAL_STAFFORD_AWRDS_DESC	NO
CASE WHEN RORSTAT_DEP_NO_PAR_DATA	NA	NO	REPORTING VIEW	FINAID_APPLICANT_STATUS	DEPENDENT_NO_PARENT_DATA_DESC	NO
CASE WHEN RRRAREQ_SYS_IND	NA	NO	REPORTING VIEW	FINAID_TRACKING_REQUIREMENT	REQUIREMENT_SOURCE_DESC	NO
CASE WHEN SFRBRDB_COURSE_RESTRICTION	NA	NO	REPORTING VIEW	BLOCK_REGISTRATION_COURSE	BLOCK_COURSE_RESTRICTION_DESC	NO	IF SFRBRDB_COURSE_RESTRICTION = 'NA THEN Add/Drop Courses Not Available, WHEN SFRBRDB_COURSE_RESTRICTION = NB THEN Add/Drop only Non-Block Courses, WHEN SFRBRDB_COURSE_RESTRICTION = NR THEN Add/Drop Courses with No Restriction
CASE WHEN SFRSTCR_GRDE_CODE	NA	NO	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE	COURSE_PASSED_IND COURSE_EARNED_IND CREDIT_FOR_GPA_IND REPEAT_EVALUATE_IND INCOMPLETE_GRADE_IND LAST_DATE_ATTEND_REQUIRED_IND COURSE_ATTEMPTED_IND	NO NO NO NO NO NO NO	Determines if course was attempted, earned, passed, credit for GPA, considered for repeat, incomplete,or last date of attendance is required. If sfrstcr_grde_code is not null THEN course_attempted_ind = shrgrde_attempted_ind; If sfrstcr_grde_code is not null THEN course_earned_ind = shrgrde_completed_ind; If sfrstcr_grde_code is not null THEN course_passed_ind = shrgrde_passed_ind; If sfrstcr_grde_code is not null THEN course_gpa_ind = shrgrde_gpa_ind;
CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRGRDE_ATTEMPTED_IND	NA	NO	REPORTING VIEW	STUDENT_COURSE	COURSE_FAILED_IND	NO	Determines if student passed or failed the course. CASE WHEN SFRSTCR_GRDE_CODE IS NOT NULL THEN CASE WHEN shrgrde_attempted_ind = 'Y' AND shrgrde_passed_ind = 'N' AND shrgrde_gpa_ind = 'Y' THEN 'Y' ELSE 'N
CASE WHEN SFRSTCR_WAIV_HRS	NA	NO	REPORTING VIEW	STUDENT_COURSE	CHARGES_WAIVED_IND	NO
CASE WHEN SHRTCKG_GRDE_CODE_FINAL	NA	NO	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE	LAST_DATE_ATTEND_REQUIRED_IND COURSE_EARNED_IND COURSE_ATTEMPTED_IND REPEAT_EVALUATE_IND COURSE_PASSED_IND CREDIT_FOR_GPA_IND INCOMPLETE_GRADE_IND	NO NO NO NO NO NO NO	Determines if course was attempted, earned, passed, credit for GPA, considered for repeat, incomplete,or last date of attendance is required. If shrtckg_grde_code_final is not null THEN course_attempted_ind = shrgrde_attempted_ind; If shrtckg_grde_code_final is not null THEN course_earned_ind = shrgrde_completed_ind; If shrtckg_grde_code_final is not null THEN course_passed_ind = shrgrde_passed_ind; If shrtckg_grde_code_final is not null THEN credit_for_gpa_ind = shrgrde_gpa_ind;
CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRGRDE_ATTEMPTED_IND	NA	NO	REPORTING VIEW	STUDENT_COURSE	COURSE_FAILED_IND	NO	Determines if student passed or failed the course. CASE WHEN SHRTCKG_GRDE_CODE_FINAL IS NOT NULL THEN CASE WHEN shrgrde_attempted_ind = 'Y' AND shrgrde_passed_ind = 'N' AND shrgrde_gpa_ind = 'Y' THEN 'Y' ELSE 'N
CASE WHEN SHRTRCE_GRDE_CODE	NA	NO	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE STUDENT_COURSE	COURSE_EARNED_IND LAST_DATE_ATTEND_REQUIRED_IND CREDIT_FOR_GPA_IND COURSE_ATTEMPTED_IND COURSE_PASSED_IND INCOMPLETE_GRADE_IND REPEAT_EVALUATE_IND	NO NO NO NO NO NO NO	Determines if course was attempted, earned, passed, credit for GPA, considered for repeat, incomplete,or last date of attendance is required. If shrtrce_grde_code is not null THEN course_attempted_ind = shrgrde_attempted_ind; If shrtrce_grde_code is not null THEN course_earned_ind = shrgrde_completed_ind; If shrtrce_grde_code is not null THEN course_passed_ind = shrgrde_passed_ind; If shrtrce_grde_code is not null THEN credit_for_gpa_ind = shrgrde_gpa_ind;
CASE WHEN SHRTRCE_GRDE_CODE CASE WHEN SHRGRDE_ATTEMPTED_IND	NA	NO	REPORTING VIEW	STUDENT_COURSE	COURSE_FAILED_IND	NO	Determines if student passed or failed the course. CASE WHEN SHRTRCE_GRDE_CODE IS NOT NULL THEN CASE WHEN shrgrde_attempted_ind = 'Y' AND shrgrde_passed_ind = 'N' AND shrgrde_gpa_ind = 'Y' THEN 'Y' ELSE 'N
CASE WHEN SSBSECT_CENSUS_2_DATE	NA	NO	REPORTING VIEW	STUDENT_COURSE	REGISTER_CENSUS_DATE2_IND	NO
CASE WHEN SSBSECT_CENSUS_ENROLL	NA	NO	REPORTING VIEW	STUDENT_COURSE	REGISTER_CENSUS_DATE1_IND	NO
CASE WHEN STAFF_ASSIGNMENT_STATUS_IND	NA	NO	REPORTING VIEW	PROSPECT_STAFF_ASSIGNMENT	ACTIVE_STAFF_ASSIGNMENT_IND	NO
CASE WHEN STATUS_CHANGE_IND	NA	NO	REPORTING VIEW	PROSPECT_CONTACT_STAFF	CONTACT_ORIGINATOR_IND_DESC	NO
CASE WHEN STRATEGY_PLAN_STATUS_IND	NA	NO	REPORTING VIEW	CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT	ACTIVE_PROSPECT_STRATEGY_IND ACTIVE_PROSPECT_STRATEGY_IND	NO NO
CASE WHEN STVESTS_EFF_HEADCOUNT	NA	NO					Determines if the student is not enrolled.
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID = 0 THEN 'Y' ELSE 'N'	NA	NO	REPORTING VIEW	PLEDGE_TRANSACTION	PLEDGE_TRANS_FULLY_PAID_IND	NO
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID > 0 AND SUM( AGRPDES_AMT_PAID) < AGRPDES_AMT_PAID THEN 'Y' ELSE 'N'	NA	NO	REPORTING VIEW	PLEDGE_TRANSACTION	PLEDGE_TRANS_PARTIAL_PAID_IND	NO
CASE WHEN SYSDATE BETWEEN EXCLUSION_DATE	NA	NO	REPORTING VIEW	EXCLUSION	ACTIVE_EXCLUSION_IND	NO
CASE WHEN TAX_DOCUMENT_BOX	NA	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL RECEIVABLE_ACCOUNT_DETAIL RECEIVABLE_ACCOUNT_DETAIL	TAX_DOCUMENT_BOX_NUMBER_PR_DESC TAX_DOCUMENT_BOX_NUMBER_DESC TAX_DOCUMENT_BOX_NUMBER_SG_DESC	NO NO NO	Determine TAX_DOCUMENT_BOX hard coded descriptions based upon TBRACCD_TAX_REPT_BOX value.
CASE WHEN TAX_NOTIFICATION_STATUS	NA	NO	REPORTING VIEW	STUDENT_TAX_NOTIFICATION	FEDERAL_REPORT_STATUS_DESC	NO	Determines hard coded descriptions for TAX_NOTIFICATION_STATUS based upon the values in TTBTAXN_STUD_NOTIF_STATUS.
CASE WHEN TBBDETC_REFUND_IND	NA	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	REFUND_DESC	NO	Hard code the description based upon the TBBDETC_REFUND_IND Hard code the detail code refund description based upon the refund indicator. CASE WHEN TBBDETC_REFUND_IND = 'Y' THEN REFUND_DESC = 'Refund' WHEN TBBDETC_REFUND_IND = 'M' THEN REFUND_DESC = 'Manual Refund' WHEN TBBDETC_REFUND_IND = 'P' THEN REFUND_DESC = 'Parent PLUS Refund' ELSE REFUND_DESC = 'No Refund' END
CASE WHEN TBBDETC_TBDC_IND	NA	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	LEDGER_DESIGNATOR	NO	Checks to determine if the detail code is a term based detail code, and if not, then checks to determine if the detail code is an aid year based detail code. CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = 'T' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE = 'A' ELSE DESIGNATOR_TYPE = 'N' END CASE;
CASE WHEN TBBEACT_TBDC_IND	NA	NO	REPORTING VIEW	RECEIVABLE_ACCOUNTING APPLICATION_OF_PAYMENT APPLICATION_OF_PAYMENT	DESIGNATOR_IND CHARGE_OPERATING_DESIGNATOR PAY_OPERATING_DESIGNATOR	NO NO NO	Determines if the detail code is used as a designator detail code. CASE WHEN TBBEACT_TBDC_IND = 'Y' OR TBBEACT_ABDC_IND = 'Y' THEN 'Y' ELSE 'N' END
CASE WHEN TBBEACT_TBDC_IND = 'Y'	NA	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	OPERATING_DESIGNATOR	NO
CASE WHEN TRACKING_STATUS	NA	NO	REPORTING VIEW	REGISTRATION_PLAN_COURSE	TRACKING_STATUS_DESC	NO
CASE WHEN UNOFFICIAL_TRACKING_STATUS	NA	NO	REPORTING VIEW	REGISTRATION_PLAN REGISTRATION_PLAN	PLAN_UNOFF_TRACK_STATUS_DESC UNOFFICIAL_TRACK_STATUS_DESC	NO NO
CASE(AMRCONT_GEN_CONTACT_IND)	NA	NO	REPORTING VIEW	CONSTITUENT_CONTACT	PROSPECT_CONTACT_IND	NO
COUNT (*) OVER (PARTITION BY B.PERSON_UID)	NA	NO	REPORTING VIEW	REGISTRATION_PLAN_COURSE	PROJECTED_SEAT_NEEDED	NO	COUNT (*) OVER (PARTITION BY B.PERSON_UID, B.ACADEMIC_PERIOD, B.SUB_ACADEMIC_PERIOD, B.PLAN_COURSE_SEQUENCE_NUMBER, B.COURSE_IDENTIFICATION, B.COURSE_REFERENCE_NUMBER)
COUNT (*) OVER (PARTITION BY COURSE_IDENTIFICATION, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER)	TBD	NO	REPORTING VIEW	PROJECTED_SEATS_NEEDED	SEATS_NEEDED	NO
COUNT (DISTINCT COURSE_REFERENCE_NUMBER)	TBD	NO	REPORTING VIEW	PROJECTED_SEATS_NEEDED	SCHEDULE_OFFERING_COUNT	NO
COUNT (DISTINCT PERSON_UID)	TBD	NO	REPORTING VIEW	PROJECTED_SEATS_NEEDED	STUDENT_HEADCOUNT	NO
COUNT(AMRATTN_PIDM)	NA	NO	REPORTING VIEW	CONSTITUENT_CONTACT	TOTAL_STAFF_COUNT	NO
COURSE_DISCIPLINE\|\|COURSE_NUMBER	NA	NO	REPORTING VIEW	PLAN_TEMPLATE_COURSE	COURSE_IDENTIFICATION	NO
DAP_VALUE1 \|\| DAP_VALUE2	NA	NO	REPORTING VIEW	AUDIT_COURSE_NEEDED AUDIT_STUDENT_COURSE	COURSE_IDENTIFICATION COURSE_IDENTIFICATION	NO NO
DAP_VALUE2 \|\| DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID'	NA	NO	REPORTING VIEW	AUDIT_COURSE_NEEDED AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_COURSE	AUDIT_RUN_DATE AUDIT_RUN_DATE AUDIT_RUN_DATE	NO NO NO
DECODE ( DECODE ( SIGN ( NVL ( TBRACCD_TRANS_DATE, TBRACCD_EFFECTIVE_DATE)	TSADETL	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	OPERATING_DATE	NO
DECODE (MRVAND0_EFC_IND, 'F', '', RNKNEED.F_CALC_BUDGET_AMT (MRVAND0_PIDM, MRVAND0_AIDY_CODE, 'I')), '999999999D99')	TBD	NO	REPORTING VIEW	APPLICANT_NEED	IM_COST_OF_EDUCATION	NO
DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND)	NA	NO	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	EXEMPTION_TYPE_DESC EXEMPTION_TYPE_DESC	NO NO	DECODE(NBBPOSN_EXEMPT_IND,'Y',DECODE(NTRPCLS_EXEMPT_IND,'Y','Exemption Position Class and Position Definition','Non-exempt Position Class and Position Definition'),DECODE(NTRPCLS_EXEMPT_IND,'Y','Exempt Class but overridden by the Position Definition','Non-exempt Position Class but overridden by the Position Definition'))
DECODE (RCRAPP1_WARD_OF_COURT, '1', 'Y', 'N')	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	WARD_OF_COURT_IND	NO
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND (ENTITY_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION')	TBD	NO	REPORTING VIEW	GIFT_MATCHING_DETAIL	ENTITY_IND_DESC	NO
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND ( MATCH_EMPLOYER_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION')	TBD	NO	REPORTING VIEW	GIFT_MATCHING_DETAIL	MATCH_ENTITY_IND_DESC	NO
DECODE(AGBMGID_DELETE_IND,'I','N','Y'),	NA	NO	REPORTING VIEW	GIFT_MATCHING	ACTIVE_IND	NO	NA
DECODE(AGBMGID_DELETE_IND,NULL, DECODE( AGBMGID_STATUS,NULL,'W','P','P','I','I') ,'N'),	NA	NO	REPORTING VIEW	GIFT_MATCHING GIFT_MATCHING_TRANSACTION	MATCH_GIFT_STATUS MATCH_GIFT_STATUS	NO NO	NA
DECODE(AGBMGID_DELETE_IND,NULL, DECODE( AGBMGID_STATUS,NULL,'WAITING, NO PAYMENT','P','PAID IN FULL','I', 'WAITING, PARTIAL PAYMENT'),'NO PAYMENT EXPECTED'),	NA	NO	REPORTING VIEW	GIFT_MATCHING GIFT_MATCHING_TRANSACTION	MATCH_GIFT_STATUS_DESC MATCH_GIFT_STATUS_DESC	NO NO	NA
DECODE(AGRGAUX_ACC_REJ_IND,'A','ACCEPT', 'R','REJECT','NOT APPLICABLE'),	NA	NO	REPORTING VIEW	GIFT_AUXILIARY	BENEFIT_ACCEPT_REJECT_DESC	NO	NA
DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)	NA	NO	REPORTING VIEW	PLEDGE_AUXILIARY PLEDGE_AUXILIARY	PLEDGE_VOID_IND PLEDGE_ADJUSTMENT_IND	NO NO
DECODE(AGRPCON_MET_IND)	NA	NO	REPORTING VIEW	PLEDGE_CONDITIONAL	CONDITION_MET_DESC	NO
DECODE(AGRPDES_AMT-AGRPDES_AMT_PAID)	NA	NO	REPORTING VIEW	PLEDGE	PLEDGE_FULLY_PAID_IND	NO	NA
DECODE(AGRPDES_AMT_PAID)	NA	NO	REPORTING VIEW	PLEDGE	PLEDGE_PARTIAL_PAID_IND	NO	NA
DECODE(AMRPLAN_PROJ_CODE, AMRCONT_PROJ_CODE)	NA	NO	REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT	PRIMARY_PROJECT_IND	NO
DECODE(AMRPRRT_RATING_PIDM,NULL, AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM)	NA	NO	REPORTING VIEW	ADVANCEMENT_RATING	RATER_UID	NO	NA
DECODE(APRADEG_HOND_CODE_1)	NA	NO	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME	DEPARTMENT_HONORS_COUNT	NO
DECODE(APRADEG_HONR_CODE)	NA	NO	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME	INSTITUTIONAL_HONORS_COUNT	NO	Determines if this person should be counted in the institutional honors count.
DECODE(APRADEG_SBGI_CODE, AUBINST_SBGI_CODE,'Y','N')	NA	NO	REPORTING VIEW	DEGREE_SLOT DEGREE	INSTITUTION_IND INSTITUTION_IND	NO NO	NA
DECODE(APRCSPS_MARS_IND,'A','ACTIVE', 'I','INACTIVE')	APACONS	NO	REPORTING VIEW	RELATIONSHIP	SPOUSE_STATUS_DESC	NO	This calculation checks APRCSPS_MARS_IND to derive a description. If 'A' description is 'active'. If 'I' description is 'inactive'.
DECODE(APRDCLB_DCYR_CODE,'9999','Y','N')	NA	NO	REPORTING VIEW	GIFT_SOCIETY	LIFETIME_GIFT_SOCIETY_IND	NO	NA
DECODE(APRIGRP_DISPLAY_WEB_IND)	NA	NO
DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY', 'S','SECONDARY')	NA	NO	REPORTING VIEW	RELATIONSHIP	COMBINED_MAILING_PRIORITY_DESC	NO	This calculation checks APRXREF_CM_PRI_IND to derive a description. If 'P' description is 'primary'. If 'S' description is 'secondary'.
DECODE(ATVADJT_DEBIT_CREDIT_IND)	NA	NO	REPORTING VIEW	DESIGNATION_ADJUSTMENT	ADJUSTMENT_DEBIT_CREDIT_DESC	NO
DECODE(ATVCFAE_MG_PURPOSE,'A','ALUMNI OR OTHER ASSOCIATIONS','B','RELIGIOUS PURPOSES AT THE INSTITUTION','C', 'POLITICAL PURPOSES AT THE INSTITUTION', 'D','ATHLETIC ACTIVITIES','E','ATHLETIC SCHOLARSHIP FUNDS','F','NON-ATHLETIC SCHOLARSHIP FUNDS',ETC.)	TBD	NO	REPORTING VIEW	DESIGNATION CAMPAIGN_DESIGNATION	MATCHING_GIFT_VSE_PURPOSE_DESC MATCHING_GIFT_VSE_PURPOSE_DESC	NO NO
DECODE(ATVDONR_CFAE_2)	NA	NO					NA
DECODE(ATVGIFT_CFAE_GIFT_CATG)	NA	NO	REPORTING VIEW	GIFT_TRANSACTION GIFT	GIFT_VSE_DESC GIFT_VSE_DESC	NO NO	NA
DECODE(BENEFICIARY_NAME)	NA	NO	REPORTING VIEW	BENEFICIARY_DEPENDENT	BENEFICIARY_NAME	NO	DECODE(B.BENEFICIARY_LAST_NAME, NULL, BP.FULL_NAME_LFMI, B.BENEFICIARY_LAST_NAME\|\|', '\|\|B.BENEFICIARY_FIRST_NAME\|\|' '\|\|DECODE(B.BENEFICIARY_MIDDLE_INITIAL,NULL,NULL,SUBSTR(BENEFICIARY_MIDDLE_INITIAL,1,1))\|\| '.')
DECODE(C.EXPENSE_TYPE_CODE, '9900ADVC', 'Y','N')	TBD	NO	REPORTING VIEW	REIMBURSEMENT_ACCOUNTING REIMBURSEMENT_ITEM	EXPENSE_ADVANCE_CLEARED_IND EXPENSE_ADVANCE_CLEARED_IND	NO NO
DECODE(ENROLLED_IND, 'N', 'Y', 'N')	NA	NO	REPORTING VIEW	ENROLLMENT	NOT_ENROLLED_IND	NO
DECODE(EXPENSE_TYPE_CODE,'9900ADVC')	TBD	NO	REPORTING VIEW	PORTFOLIO_SUMMARY	EXPENSE_ADVANCE_CLEARED_IND	NO
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL)	FAAINVE	NO	REPORTING VIEW	INVOICE	REMIT_TO_STREET_LINE1	NO	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL)	FAAINVE	NO	REPORTING VIEW	INVOICE	REMIT_TO_STREET_LINE2	NO	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL)	FAAINVE	NO	REPORTING VIEW	INVOICE	REMIT_TO_STREET_LINE3	NO	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_CITY, NULL)	FAAINVE	NO	REPORTING VIEW	INVOICE	REMIT_TO_CITY	NO	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_NATN, NULL)	FAAINVE	NO	REPORTING VIEW	INVOICE	REMIT_TO_NATION	NO	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_STATE, NULL)	FAAINVE	NO	REPORTING VIEW	INVOICE	REMIT_TO_STATE_PROVINCE	NO	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ZIP, NULL)	FAAINVE	NO	REPORTING VIEW	INVOICE	REMIT_TO_POSTAL_CODE	NO	NA
DECODE(FABINVH_ATYP_CODE, NULL, TO_NUMBER(NULL), FABINVH_ATYP_SEQ_NUM)	FAAINVE	NO	REPORTING VIEW	INVOICE	REMIT_TO_ADDRESS_TYPE_NUMBER	NO	NA
DECODE(FABINVH_ATYP_CODE,NULL,'Y','N')	FAAINVE	NO	REPORTING VIEW	INVOICE	ONE_TIME_VENDOR_ADDRESS_IND	NO	NA
DECODE(FABINVH_GROUPING_IND)	NA	NO	REPORTING VIEW	INVOICE INVOICE	GROUPING_DESC GROUPING	NO NO
DECODE(FABINVH_INVOICE_TYPE_IND)	FAAINVE	NO	REPORTING VIEW	INVOICE	INVOICE_TYPE_DESC	NO	This calculation evaluates the column FABINVH_INVOICE_TYPE_IND. If it is a D, it will return DIRECT. If it is an R, it will return REGULAR. If it is neither D nor R, it will return NULL.
DECODE(FABINVH_MATCH_REQUIRED)	NA	NO	REPORTING VIEW	INVOICE	RECEIVING_REQUIRED_DESC	NO
DECODE(FABINVH_VEND_CHECK_PIDM,NULL,'N', 'Y')	FAAINVE	NO	REPORTING VIEW	INVOICE	THIRD_PARTY_ADDRESS_IND	NO	NA
DECODE(FEEDBACK_COMMENT,NULL,'NO','YES')	TBD	NO	REPORTING VIEW	FACULTY_FEEDBACK_DETAIL	FEEDBACK_COMMENT_IND	NO
DECODE(FEEDBACK_ESTIMATED_GRADE,NULL, 'NO','YES')	TBD	NO	REPORTING VIEW	FACULTY_FEEDBACK_DETAIL	FEEDBACK_ESTIMATED_GRADE_IND	NO
DECODE(FEEDBACK_STATUS,'M','YES','NO')	TBD	NO	REPORTING VIEW	FACULTY_FEEDBACK_DETAIL	STUDENT_MONITOR_IND	NO
DECODE(FFBMAST_SUBORDINATE_TYPE)	FFAMAST	NO	REPORTING VIEW	FIXED_ASSET_ITEM	SUBORDINATE_TYPE_DESC	NO	This calculation evaulates the column FFBMAST_SUBORDINATE_TYPE. If it is a C, it returns COMPONENT. If it is an A, it returns ATTACHEDTO. If it is neither C nor A, it returns NEITHER.
DECODE(FFRMASA_DEPR_POST_CODE)	FFADEPR	NO	REPORTING VIEW	FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ACCOUNTING_HISTORY	DEPRECIATION_POSTING_STATUS DEPRECIATION_POSTING_STATUS	NO NO	This calculation evaluates the column FFRMASA_DEPR_POST_CODE. If it is an M, it will return Memo Post. If it is a P, it will return Post. If it is neither M nor P, it will return No Post.
DECODE(FGBENCD_STATUS)	FGIENCD	NO	REPORTING VIEW	ENCUMBRANCE_ACCOUNTING	ENCUMBRANCE_STATUS	NO	This calculation evaluates the column FGBENCD_STATUS. If it is a C, it will return Closed. Otherwise it will return Open.
DECODE(FGBENCD_STATUS_IND)	FGIENCD	NO	REPORTING VIEW	ENCUMBRANCE_ACCOUNTING	POSTABLE_IND	NO	This calculation evaluates the column FGBENCD_STATUS_IND. If it is a P, it will return Y. Otherwise, it will return an N.
DECODE(FGBENCH_SOURCE_IND)	FGIENCD	NO	REPORTING VIEW	ENCUMBRANCE	ENCUMBRANCE_SOURCE	NO	This calculation evaluates the column FGBENCH_SOURCE_IND. If it is an R, it will return Requisition. If it is a P, it will return Purchase Order. If it is an E, it will return Encumbrance. Otherwise, it will return Unknown Source.
DECODE(FGBENCH_STATUS)	FGIENCD	NO	REPORTING VIEW	ENCUMBRANCE	COMPLETE_IND	NO	This calculation evaluates the column FGBENCH_STATUS. If it is a C, it will return Y. Otherwise, it will return an N.
DECODE(FGBENCH_STATUS_IND)	FGIENCD	NO	REPORTING VIEW	ENCUMBRANCE ENCUMBRANCE_ACCOUNTING	ENCUMBRANCE_STATUS DOCUMENT_ENCUMBRANCE_STATUS	NO NO	This calculation will evaluate the column FGBENCH_STATUS_IND. If it is a C, it will return Closed. Otherwise it will return Open.
DECODE(FNVENDW_REST_TYPE)	NA	NO	REPORTING VIEW	ENDOWMENT_UNITS ENDOWMENT_DISTRIBUTION	RESTRICTION_TYPE_DESC RESTRICTION_TYPE_DESC	NO NO	This calculation will evaluate the column FNVENDW_REST_TYPE. If it is an R, it will return RESTRICTED. If it is a U, it will return UNRESTRICTED. Otherwise it will return NULL.
DECODE(FNVPOOL_STATUS_IND)	FNMPOOL	NO	REPORTING VIEW	ENDOWMENT_DISTRIBUTION ENDOWMENT_UNITS	POOL_STATUS_DESC POOL_STATUS_DESC	NO NO	This calculation will evaluate the column FNVPOOL_STATUS_IND. If it is an A, it will return ACTIVE. If it is an I, it will return INACTIVE. Otherwise, it will return NULL.
DECODE(FOKODSF.F_GET_REST_IND)	NA	NO	REPORTING VIEW	FUND_HIERARCHY FUND_HIERARCHY_FISCAL	FUND_BALANCE_RESTRICTION_DESC FUND_BALANCE_RESTRICTION_DESC	NO NO
DECODE(FORCIRR_DATA_ORIGIN)	NA	NO	REPORTING VIEW	AUTHORIZATION_APPROVAL_HISTORY REIMBURSEMENT_APPROVAL_HISTORY	ADDITIONAL_APPROVER_IND ADDITIONAL_APPROVER_IND	NO NO
DECODE(FPBPOHD_MATCH_REQUIRED)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER	RECEIVING_REQUIRED_DESC	NO
DECODE(FPBPOHD_PO_TYPE_IND)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER	PURCHASE_ORDER_TYPE_DESC	NO	This calculation will evaluate the column FPBPOHD_PO_TYPE_IND. If it is an R, it will return REGULAR. If it is an S, it will return STANDING. Otherwise, it will return NULL.
DECODE(FPBPOHD_REQ_BID_IND)	FPAPOAS	NO	REPORTING VIEW	PURCHASE_ORDER	REQUISITION_OR_BID_SOURCE_DESC	NO
DECODE(FPBPOHD_TEXT_IND)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER	REQUISITION_TEXT_DESC	NO
DECODE(FPBRCDT_ADJUST_RECEIVE_IND)	FPARCVD	NO	REPORTING VIEW	RECEIVED_ITEM	ADJUSTED_IND	NO	This calculation returns a Y or N if the item was adjusted or not adjusted.
DECODE(FPRPODA_NSF_SUSP_IND)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_ACCOUNTING PURCHASE_ORDER_ACCOUNTING	NSF_SUSPENSE_DESC NSF_SUSPENSE_DESC	NO NO
DECODE(FPRPODT_TEXT_USAGE)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	TEXT_USAGE_DESC	NO
DECODE(FPRRCDT_PARTIAL_FINAL_IND)	FPARCVD	NO	REPORTING VIEW	RECEIVED_ITEM	FINAL_RECEIPT_IND	NO	Calculation determines if value is set to (P)artial or (F)inal.
DECODE(FRBEVNG_PMT_METHOD_TYPE_IND)	NA	NO
DECODE(FRRBDET_ACCT_CLASS_CODE)	FRABDCN	NO	REPORTING VIEW	GRANT_BILLING_DETAIL	ACCOUNT_CLASS	NO	This calculation will evaluate the column FRRBDET_ACCT_CLASS_CODE. If it is a C, it will return COST SHARE. If it is an I, it will return INDIRECT COST. If it is a D, it will return DIRECT EXPENSE. If it is an F, it will return FIXED ASSETS. If it is a U, it will return UNITIZATION.
DECODE(FRRBDET_BILL_STATUS)	FRABDCN	NO	REPORTING VIEW	GRANT_BILLING_DETAIL	BILL_STATUS_DESC	NO	This calculation will evaluate the column FRRBDET_BILL_STATUS. If it is a B, it will return BILLED. If it is a U, it will return UNBILLED. If it is an H, it will return HOLD. If it is a W, it will return WITHHOLDING.
DECODE(FRVBFRM_TYPE_IND)	NA	NO	REPORTING VIEW	GRANT_PERSONNEL GRANT_EVENT	BILL_FORMAT_TYPE_DESC BILL_FORMAT_TYPE_DESC	NO NO
DECODE(FTVATTT_STATUS_IND)	FTMATTT	NO	REPORTING VIEW	ACCOUNT_ATTRIBUTES ORGANIZATION_ATTRIBUTES ATTRIBUTE_SETS PROGRAM_ATTRIBUTES CHART_ATTRIBUTES ACTIVITY_ATTRIBUTES FUND_TYPE_ATTRIBUTES LOCATION_ATTRIBUTES ACCOUNT_TYPE_ATTRIBUTES FUND_ATTRIBUTES	ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC	NO NO NO NO NO NO NO NO NO NO	This calculation will evaluate the column FTVATTT_STATUS_IND. If it is an A, it will return Active. Otherwise, it will return Inactive.
DECODE(FTVBAL_FBAL_IND)	NA	NO	REPORTING VIEW	FUND_HIERARCHY FUND_HIERARCHY_FISCAL	FUND_BALANCE_DESC FUND_BALANCE_DESC	NO NO
DECODE(FTVFSPD_PRD_STATUS_IND)	NA	NO	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER GENERAL_LEDGER OPERATING_LEDGER	FISCAL_PERIOD_STATUS_DESC FISCAL_PERIOD_STATUS_DESC FISCAL_PERIOD_STATUS_DESC	NO NO NO
DECODE(FTVFUND_REST_IND)	NA	NO	REPORTING VIEW	FUND_HIERARCHY FUND_HIERARCHY_FISCAL	FUND_RESTRICTION_DESC FUND_RESTRICTION_DESC	NO NO
DECODE(FTVVEND_1099_RPT_ID)	FTMVEND	NO	REPORTING VIEW	VENDOR	FEDERAL_REPORTABLE_TAX_IND	NO	This calculation will evaluate the column FTVVEND_1099_RPT_ID. If it is NULL, it will return an N. Otherwise, it will return a Y.
DECODE(F_DISPOSITION_IND,'H','HIRED', 'N','NO LONGER CONSIDERED','U','UNDER CONSIDERATION')	NA	NO	REPORTING VIEW	HR_APPLICATION	STATUS_DISPOSITION_DESC	NO	This function returns HIRE if the disposition indicator is H, NO LONGER CONSIDERED if it is N or UNDER CONSIDERATION if it is U.
DECODE(GOREMAL_STATUS_IND)	NA	NO	REPORTING VIEW	INTERNET_ADDRESS	INTERNET_ADDRESS_STATUS_DESC	NO
DECODE(GORSGEO_SOURCE_IND,'S','N','Y')	NA	NO	REPORTING VIEW	GEOGRAPHIC_REGION_INSTITUTION	GEOGRAPHIC_SOURCE_USER_IND	NO	DECODE(GORSGEO_SOURCE_IND,'S','N','Y')
DECODE(GORSGEO_STATUS_IND,NULL,'A','I')	NA	NO	REPORTING VIEW	GEOGRAPHIC_REGION_INSTITUTION	GEOGRAPHIC_REGION_STATUS	NO	DECODE(GORSGEO_STATUS_IND,NULL,'A','I')
DECODE(GORSGEO_STATUS_IND,NULL,'ACTIVE', 'INACTIVE')	NA	NO	REPORTING VIEW	GEOGRAPHIC_REGION_INSTITUTION	GEOGRAPHIC_REGION_STATUS_DESC	NO	DECODE(GORSGEO_STATUS_IND,NULL,'Active','Inactive')
DECODE(GROUP_TYPE)	NA	NO	REPORTING VIEW	REGISTRATION_PLAN_COURSE	PLAN_GROUP_TYPE_DESC	NO
DECODE(GURMAIL_DATE_PRINTED,NULL,'Y', 'N')	NA	NO	REPORTING VIEW	COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	PENDING_LETTER_IND PENDING_LETTER_IND1 PENDING_LETTER_IND3 PENDING_LETTER_IND4 PENDING_LETTER_IND5 PENDING_LETTER_IND2	NO NO NO NO NO NO	NA
DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')	SUAMAIL	NO	REPORTING VIEW	COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	COMMUNICATION_TYPE_DESC COMMUNICATION_TYPE_DESC5 COMMUNICATION_TYPE_DESC4 COMMUNICATION_TYPE_DESC2 COMMUNICATION_TYPE_DESC1 COMMUNICATION_TYPE_DESC3	NO NO NO NO NO NO	NA
DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	DEPENDENCY_OVERRIDE_DESC	NO
DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C', CANCELLED,'F',FROZEN,'I',INACTIVE)	NA	NO	REPORTING VIEW	POSITION_DEFINITION	POSITION_STATUS_DESC	NO	This function returns ACTIVE if the status NBBPOSN_STATUS is A, Cancelled if C, FROZEN if F and INACTIVE if I.
DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')	NA	NO	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	POSITION_CONTRACT_TYPE_DESC POSITION_CONTRACT_TYPE_DESC	NO NO	This function returns Primary if the contract type NBRBJOB_CONTRACT_TYPE is P, Secondary if it is S and Overload if it is O.
DECODE(NBRJOBS_PERS_PAY_CODE)	NA	NO	REPORTING VIEW	EMPLOYEE_POSITION	PUBLIC_RETIRE_PAY_RATE_DESC	NO	SUBSTR(DECODE(P.NBRJOBS_PERS_PAY_CODE, '01', G$_NLS.GET('x','SQL','Monthly Pay Rate'), '02', G$_NLS.GET('x','SQL','Monthly Pay Rate (LA)'), '04', G$_NLS.GET('x','SQL','Hourly Pay Rate'), '08', G$_NLS.GET('x','SQL','Daily Pay Rate'), '09', G$_NLS.GET('x','SQL','Miscellaneous Pay Rate')),1,30),
DECODE(NBRJOBS_STATUS)	NA	NO	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION EMPLOYEE PAYROLL_POSITION_TIMESHEET	POSITION_STATUS_DESC POSITION_STATUS_DESC POSITION_STATUS_DESC	NO NO NO	This function return Active if the employee status NBRJOBS_STATUS is A, Leave withoutpay and with benefit if it is B, Leave without pay and without benefit if it is L, Leave with pay and with benefit if it is F, Leave with part pay and with benefit if it is P, Terminated if it is T.
DECODE(NBRJOBS_STRS_PAY_CODE)	NA	NO	REPORTING VIEW	EMPLOYEE_POSITION	STATE_RETIREMENT_PAY_RATE_DESC	NO	SUBSTR(DECODE(P.NBRJOBS_STRS_PAY_CODE, '0', G$_NLS.GET('x','SQL','Annual or Lump Sum'), '1', G$_NLS.GET('x','SQL','12 Monthly Payments'), '2', G$_NLS.GET('x','SQL','11 Monthly Payments'), '3', G$_NLS.GET('x','SQL','10 Monthly Payments'), '4', G$_NLS.GET('x','SQL','Hourly Rate'), '7', G$_NLS.GET('x','SQL','13 Payments'), '8', G$_NLS.GET('x','SQL','Daily Rate')),1,30),
DECODE(NBRPTOT_STATUS,'A',APPROVED,'C', CLOSED,'T',TRANSFERRED,'W',WORKING)	NA	NO	REPORTING VIEW	PAYROLL_DISTRIBUTION POSITION_BUDGET	BUDGET_STATUS_DESC BUDGET_STATUS_DESC	NO NO	This function returns APPROVED if the status NBRPTOT_STATUS is A, CLOSED if it is C, TRANSFERRED if it is T and WORKING if it is W.
DECODE(NHRDIST_HIST_TYPE_IND)	NA	NO	REPORTING VIEW	PAYROLL_DISTRIBUTION	PAYROLL_EVENT_TYPE_DESC	NO	SUBSTR(DECODE(NHRDIST_HIST_TYPE_IND, 'J', G$_NLS.GET('x','SQL','Adjusted'), 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Original'), 'R', G$_NLS.GET('x','SQL','Redistributed'), 'I', G$_NLS.GET('x','SQL','Reissued'), 'V', G$_NLS.GET('x','SQL','Voided')),1,30)
DECODE(NORMAL_BALANCE)	NA	NO	REPORTING VIEW	PAYROLL_DISTRIBUTION	NORMALIZED_TRANSACTION_AMOUNT	NO	NA
DECODE(NVL(AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'N', NVL(AGVPLG1_PLEDGE_AMOUNT,0) , 'N','Y')	NA	NO					NA
DECODE(PAYROLL_DEDUCTION)	NA	NO	REPORTING VIEW	YEARLY_DEDUCTION YEARLY_DEDUCTION	GROSS_COMPENSATION_YTD EMPLOYER_CONTRIBUTION_YTD	NO NO	SUM(NVL(DECODE(PAYROLL_DEDUCTION_MONTH, 1, EMPLOYEE_CONTRIBUTION_AMOUNT, 2, EMPLOYEE_CONTRIBUTION_AMOUNT, 3, EMPLOYEE_CONTRIBUTION_AMOUNT,0),0))
DECODE(PDRDEDN_STATUS,'A','ACTIVE','B', 'EXEMPT','W','WAIVE','T','TERMINATED',')	NA	NO	REPORTING VIEW	BENEFIT_DEDUCTION	STATUS_DESC	NO	This function returns ACTIVE if the status PDRDEDN_STATUS is A, EXEMPT if the status is B WAIVE if the status is W or TERMINATED if the status is T.
DECODE(PDRDEDN_STATUS,'A','ACTIVE','B', 'EXEMPT','W','WAIVED','T','TERMINATED')	NA	NO	REPORTING VIEW	TAX	STATUS_DESC	NO	NA
DECODE(PEBEMPL_1042_RECIPIENT_CD)	NA	NO	REPORTING VIEW	EMPLOYEE	FOREIGN_INCOME_RECIPIENT_DESC	NO	This function returns Individual if the 1042 receipient code PEBEMPL_1042_RECIPIENT_CD is 01, Corporation if it is 02, Partnership if it is 03, Fiduciary if it is 04, Nominee if it is 05, Govt or International Organization if iti 06, Tax Exempt Organization if it is 07, Private Foundation if it 08, Artist or athlete if it is 09, Other if it is 19, Type of recipient unknown if it is 20.
DECODE(PEBEMPL_CALIF_PENSION_IND)	NA	NO	REPORTING VIEW	EMPLOYEE	PUBLIC_RETIREMENT_MEMBER_DESC	NO
DECODE(PEBEMPL_EMPL_STATUS)	NA	NO	REPORTING VIEW	EMPLOYEE	EMPLOYEE_STATUS_DESC	NO	This function return Active if the employee status PEBEMPL_EMPL_STATUS is A, Leave withoutpay and with benefit if it is B, Leave without pay and without benefit if it is L, Leave with pay and with benefit if it is F, Leave with part pay and with benefit if it is P, Terminated if it is T.
DECODE(PEBEMPL_FLSA_IND)	NA	NO	REPORTING VIEW	EMPLOYEE	FAIR_LABOR_STANDARDS_TYPE_DESC	NO	This function return a description based upon the value of fair labor standards for an employee PEBEMPL_FLSA_STATUS. Accrual is A, Cash is C, and No FLSA is N.
DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED, N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT)	NA	NO	REPORTING VIEW	EMPLOYEE	IMMIGRATION_STATUS_DESC	NO	This function returns RECEIVED if the I9 form indicator PEBEMPL_I9_FORM_IND is R, NOTRECEIVED if it is N, TEMPORARY if it is T,
DECODE(PERAPPT_DECISION)	NA	NO	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_DECISION_DESC APPOINTMENT_DECISION_DESC	NO NO	SUBSTR(DECODE(PERAPPT_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30)
DECODE(PERBFAC_PRIMARY_ACTIVITY)	PEAFACT,PEAFACD	NO	REPORTING VIEW	FACULTY_TRACKING	PRIMARY_ACTIVITY_DESC	NO	SUBSTR(DECODE(PERBFAC_PRIMARY_ACTIVITY, 'A', G$_NLS.GET('x','SQL','Administrative'), 'I', G$_NLS.GET('x','SQL','Instructional'),'R', G$_NLS.GET('x','SQL','Research')),1,30)
DECODE(PERJTOT_MONTH,1,1,2,1,3,1,4,2,5, 2,6,2,7,3,8,3,9,3,10,4,11,4,12,4)	NA	NO	REPORTING VIEW	EMPLOYEE_EARNING_CY	QUARTER	NO	This function returns what quarter it is based on the month PERJTOT_MONTH. 1, 2, 3 are the first quarter. 4, 5, 6 are the second quarter. 7, 8, 9 are the third quarter. 10, 11, 12 are the fourth quarter.
DECODE(PERRANK_DECISION)	NA	NO	REPORTING VIEW	FACULTY_TRACKING	RANK_DECISION_DESC	NO	SUBSTR(DECODE(PERRANK_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30)
DECODE(PERSABB_DECISION)	NA	NO	REPORTING VIEW	FACULTY_TRACKING	SABBATICAL_DECISION_DESC	NO	SUBSTR(DECODE(PERSABB_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30)
DECODE(PHRACCR_CALC_GEN_IND)	NA	NO	REPORTING VIEW	LEAVE_ACCRUAL	PAYROLL_CALCULATION_TYPE_DESC	NO	SUBSTR(DECODE(PHRACCR_CALC_GEN_IND, 'Y', G$_NLS.GET('x','SQL','Calculated'), 'N', G$_NLS.GET('x','SQL','Manual')),1,30)
DECODE(PHRATND_TS_ROSTER_IND)	NA	NO	REPORTING VIEW	PAYROLL_ATTENDANCE	TIMESHEET_METHOD_DESC	NO
DECODE(PHRDOCM_DOC_TYPE)	NA	NO	REPORTING VIEW	PAYROLL_DOCUMENT	DIRECT_DEPOSIT_IND	NO	DECODE(PHRDOCM_DOC_TYPE, 'C', 'N', 'D', 'Y')
DECODE(PHRELBD_TS_ROSTER_IND)	NA	NO	REPORTING VIEW	PAYROLL_LABOR_DIST_OVERRIDE	TIMESHEET_METHOD_DESC	NO
DECODE(PHRHIST_CALC_IND)	NA	NO	REPORTING VIEW	PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION	PAYROLL_CALCULATION_TYPE_DESC PAYROLL_CALCULATION_TYPE_DESC	NO NO	SUBSTR(DECODE(PHRHIST_CALC_IND, 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Calculated')),1,30)
DECODE(PHRHIST_PRINT_IND)	NA	NO	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	DOCUMENT_PRINT_METHOD_DESC DOCUMENT_PRINT_METHOD_DESC	NO NO	SUBSTR(DECODE(PHRHIST_PRINT_IND, 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Calculated')),1,30)
DECODE(PHRHIST_TYPE_IND)	NA	NO	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION	PAYROLL_EVENT_TYPE_DESC	NO
DECODE(PHRJOBS_TIME_ENTRY_IND)	NA	NO	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	TIME_ENTRY_TYPE_DESC TIME_ENTRY_TYPE_DESC	NO NO	SUBSTR(DECODE(PHRJOBS_TIME_ENTRY_IND, 'P', G$_NLS.GET('x','SQL','Pay Period'), 'F', G$_NLS.GET('x','SQL','FSLA'), 'W', G$_NLS.GET('x','SQL','Weekly'), 'D', G$_NLS.GET('x','SQL','Daily'), 'N', G$_NLS.GET('x','SQL','None')),1,30)
DECODE(PHRJOBS_TS_ROSTER_IND)	NA	NO	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_EARNING PAYROLL_POSITION_TIMESHEET	TIMESHEET_METHOD_DESC TIMESHEET_METHOD_DESC TIMESHEET_METHOD_DESC	NO NO NO	SUBSTR(DECODE(PHRJOBS_TS_ROSTER_IND, 'T', G$_NLS.GET('x','SQL','Timesheet'), 'O', G$_NLS.GET('x','SQL','Organization'), 'R', G$_NLS.GET('x','SQL','Roster')),1,30)
DECODE(PHRJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')	NA	NO	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	POSITION_CONTRACT_TYPE_DESC POSITION_CONTRACT_TYPE_DESC	NO NO	NA
DECODE(PTRBDCA_CALC_RULE)	NA	NO	REPORTING VIEW	PAYROLL_DEDUCTION	TAX_DEDUCTION_IND	NO	substr(gokodsf.f_get_null_varchar2,1,6), substr(gokodsf.f_get_desc(null, 'GTVVPDI') ,1,30), substr(gokodsf.f_get_null_varchar2,1,6), substr(gokodsf.f_get_null_varchar2,1,6),
DECODE(RCRAPP1_ACTIVE_DUTY,'1','Y','N')	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	ACTIVE_DUTY_IND	NO
DECODE(RCRAPP1_AT_RISK_HOMELESS,'1', 'Y','N')	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	AT_RISK_HOMELESS_IND	NO
DECODE(RCRAPP1_BORN_BEFORE_1_1_XX)	RNANAXX RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	OLDER_THAN_24_IND	NO
DECODE(RCRAPP1_DEGREE_BY_JULY)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	DEGREE_BY_JULY_IND	NO
DECODE(RCRAPP1_EMANCIPATED_MINOR,'1', 'Y','N')	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	EMANCIPATED_MINOR_IND	NO
DECODE(RCRAPP1_HAS_LEGAL_DEPEND)	RNANAXX RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	LEGAL_DEPENDENT_IND	NO
DECODE(RCRAPP1_INS)	RNARSXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PERM_RESIDENCY_CONFIRMED_IND	NO
DECODE(RCRAPP1_LEGAL_GUARDIAN,'1', 'Y', 'N')	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	LEGAL_GUARDIAN_IND	NO
DECODE(RCRAPP1_LINE2_RELSHIP)	RNASUXX	NO
DECODE(RCRAPP1_LINE3_ATTEND_COLL)	RNASUXX	NO
DECODE(RCRAPP1_LINE3_RELSHIP)	RNASUXX	NO
DECODE(RCRAPP1_LINE4_ATTEND_COLL)	RNASUXX	NO
DECODE(RCRAPP1_LINE4_RELSHIP)	NA	NO
DECODE(RCRAPP1_LINE5_ATTEND_COLL)	RNASUXX	NO
DECODE(RCRAPP1_LINE5_RELSHIP)	NA	NO
DECODE(RCRAPP1_LINE6_ATTEND_COLL)	RNASUXX	NO
DECODE(RCRAPP1_LINE6_RELSHIP)	RNASUXX	NO
DECODE(RCRAPP1_LINE7_ATTEND_COLL)	RNASUXX	NO
DECODE(RCRAPP1_LINE7_RELSHIP)	RNASUXX	NO
DECODE(RCRAPP1_LINE8_ATTEND_COLL)	RNASUXX	NO
DECODE(RCRAPP1_LINE8_RELSHIP)	RNASUXX	NO
DECODE(RCRAPP1_MRTL_STATUS)	NA	NO
DECODE(RCRAPP1_PAR_DIV_SEP_REM_IND)	RNASUXX	NO
DECODE(RCRAPP1_PAR_HOUS_STAT)	RNASUXX	NO
DECODE(RCRAPP1_PAR_TAX_FORM_IND)	RNAPRXX RNANAXX	NO
DECODE(RCRAPP1_PERMIT_DRAFT_REG)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PERMIT_DRAFT_REGISTRATION_IND	NO
DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR)	RNAPRXX	NO
DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR)	RNAPRXX	NO
DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR)	RNAPRXX	NO
DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR)	RNAPRXX	NO
DECODE(RCRAPP1_SIGNED)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_DEMOGRAPHIC	APPLICATION_SIGNED_BY APPLICATION_SIGNED_BY_DESC	NO NO
DECODE(RCRAPP1_TAX_FORM_IND)	RNANAXX	NO
DECODE(RCRAPP1_TITLE)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	NAME_PREFIX	NO
DECODE(RCRAPP1_UNACCOMP_YOUTH_HUD,'1', 'Y','N')	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	UNACCOMPANIED_YOUTH_HUD_IND	NO
DECODE(RCRAPP1_UNACCOMP_YOUTH_SCHOOL, '1', 'Y','N')	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	UNACCOMPANIED_YOUTH_SCHOOL_IND	NO
DECODE(RCRAPP1_US_VET)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	VETERAN_IND	NO
DECODE(RCRAPP1_VERIFICATION_MSG)	RNARSXX RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SELECTED_FOR_VERIFICATION_IND	NO
DECODE(RCRAPP1_YR_IN_COLL)	RNASUXX	NO
DECODE(RCRAPP2_C_1_ANLY_TYPE)	RNARSXX	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_ANALYSIS_TYPE_DESC	NO
DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)	RNARSXX	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_CONTRIBUTION_OFFICIAL_DESC	NO
DECODE(RCRAPP2_C_1_VA_BEN_INCL)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_VETERAN_BENEFITS_IND	NO
DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_CONTRIBUTION_OFFICIAL_DESC	NO
DECODE(RCRAPP2_C_2_VA_BEN_INCL)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_VETERAN_BENEFITS_IND	NO
DECODE(RCRAPP2_C_DEPEND_STATUS)	NA	NO	REPORTING VIEW	NEED_ANALYSIS	DEPENDENCY_STATUS_DESC	NO
DECODE(RCRAPP2_C_MRTL_STATUS)	TBD	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_MARITAL_STATUS_DESC	NO
DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_PARENT_ANALYSIS_TYPE_DESC	NO
DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST)	RNARSXX	NO
DECODE(RCRAPP2_C_PAR_2_CTRB_FR_ASSET)	RNINAIQ	NO
DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_PARENT_CONTRIB_OFF_DESC	NO
DECODE(RCRAPP2_C_PAR_MRTL_STATUS)	TBD	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_PARENT_MARITAL_STATUS_DESC	NO
DECODE(RCRAPP2_ELIGIBILITY_MSG)	RNARSXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS	SAR_C_IND SAR_C_IND	NO NO
DECODE(RCRAPP2_MODEL_CDE)	ROASTAT	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD NEED_ANALYSIS NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_DEMOGRAPHIC	FM_FAMILY_SIZE FAMILY_SIZE FAMILY_IN_COLLEGE FAMILY_IN_COLLEGE FAMILY_SIZE	NO NO NO NO NO
DECODE(RCRAPP2_PELL_ANLY_TYPE)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SIMPLIFIED_NEEDS_TEST_IND	NO
DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_EST_CONTRIB_OFFICIAL_DESC	NO
DECODE(RCRAPP2_PELL_PGI_OFFL_EST)	RNARSXX	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	PELL_EFC_OFFICIAL_DESC	NO
DECODE(RCRAPP2_PELL_P_ANLY_TYPE)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_PARENT_EST_ANAL_TYPE_DESC	NO
DECODE(RCRAPP3_C_SIGNED)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SIGNATURE_IND	NO
DECODE(RCRAPP3_C_SIGNED_FATH)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	FATHER_SIGNATURE_IND	NO
DECODE(RCRAPP3_C_SIGNED_MOTH)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	MOTHER_SIGNATURE_IND	NO
DECODE(RCRAPP3_C_SIGNED_SPS)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SPOUSE_SIGNATURE_IND	NO
DECODE(RCRAPP3_DEGREE_TYPE)	RNAPRXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	DEGREE_TYPE_DESC	NO
DECODE(RCRAPP3_FAA_DEP_OVERRIDE)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS	DEPENDENCY_OVERRIDE_DESC	NO
DECODE(RCRAPP3_FATH_SSN_MATCH)	RNANAXX RNARSXX	NO
DECODE(RCRAPP3_GRAD_OR_PROF)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS	GRADUATE_PROFESSIONAL_IND GRADUATE_PROFESSIONAL_IND	NO NO
DECODE(RCRAPP3_LIVE_ON_FARM)	RNAPRXX	NO
DECODE(RCRAPP3_MARRIED)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS	MARITAL_STATUS_IND	NO
DECODE(RCRAPP3_MOTH_SSN_MATCH)	RNANAXX RNARSXX	NO
DECODE(RCRAPP3_OFFL_UNOFFL_IND)	RNARSXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS	OFFICIAL_SOURCE_IND OFFICIAL_SOURCE_IND	NO NO
DECODE(RCRAPP3_PAR_LIVE_ON_FARM)	RNAPRXX	NO
DECODE(RCRAPP3_PREPARER_SIGN)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PREPARER_SIGNATURE_IND	NO
DECODE(RCRAPP3_SOC_SEC)	RNARSXX	NO
DECODE(RCRAPP3_YR_IN_COLL_2)	RNASUXX	NO
DECODE(RCRAPP4_1040A_ELIG_IND)	RNAPRXX RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS	SHORT_TAX_FORM_IND	NO
DECODE(RCRAPP4_ADDRESS_CHG_FLAG)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	ADDRESS_CHANGE_DESC	NO
DECODE(RCRAPP4_CUSTODIAL_PARENT)	RNASUXX RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_CUSTODIAL_PARENT_DESC	NO
DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	PELL_EFC_OFFICIAL_EST_DESC	NO
DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_PARENT_CONTRIB_OFF_EST_DESC	NO
DECODE(RCRAPP4_EFC_CHANGE_IND)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	EFC_CHANGE_FLAG_DESC	NO
DECODE(RCRAPP4_FEE_WAIVER_IND)	TBD	NO
DECODE(RCRAPP4_FORMULA_FOR_CALC)	RNINAIQ	NO	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_FORMULA_DESC	NO
DECODE(RCRAPP4_HAVE_CHILDREN)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS	SUPPORT_CHILDREN_IND	NO
DECODE(RCRAPP4_HS_GED_RCVD)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SECONDARY_SCHOOL_DIPLOMA_IND	NO
DECODE(RCRAPP4_LEGAL_RES_IND)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	LEGAL_RESIDENT_IND	NO
DECODE(RCRAPP4_NSLDS_MATCH)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	NATIONAL_STUDENT_LOAN_SYS_DESC	NO
DECODE(RCRAPP4_PAR_1040A_ELIG_IND)	RNAPRXX RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS	PARENT_SHORT_TAX_FORM_IND	NO
DECODE(RCRAPP4_PAR_LEGAL_RES_IND)	RNANAXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PARENT_LEGAL_RESIDENT_IND	NO
DECODE(RCRAPP4_SAR_C_CHANGE_FLAG)	RNIMSXX	NO
DECODE(RCRAPP4_SEC_INS_MATCH_IND)	RNARSXX	NO
DECODE(RCRAPP4_SOURCE_CORRECTION)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	CORRECTION_SOURCE_DESC	NO
DECODE(RCRAPP4_SSA_CITIZEN_IND)	RNARSXX	NO
DECODE(RCRAPP4_SS_MATCH)	RNARSXX	NO
DECODE(RCRAPP4_SS_REG_FLAG)	RNARSXX	NO
DECODE(RCRAPP4_TX_RET_FILED_IND)	RNAPRXX	NO
DECODE(RCRAPP4_TYPE_DATA_AVAIL)	RNINAIQ	NO
DECODE(RCRAPP4_VA_MATCH_FLAG)	RNARSXX	NO
DECODE(RCRAPP4_VISA_CLASS)	RNASUXX	NO
DECODE(RCRAPP4_WORK_STUDY)	RNANAXX	NO
DECODE(RCRESAR_AUTO_ZERO_EFC_FLAG)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	AUTOMATIC_ZERO_EFC_IND	NO
DECODE(RCRESAR_A_BORN_BEFORE_IND)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	OLDER_THAN_24_IND	NO
DECODE(RCRESAR_A_CITZ_IND)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ASSUMED_CITIZENSHIP_DESC	NO
DECODE(RCRESAR_A_MARRIED)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ASSUMED_MARRIED_IND	NO
DECODE(RCRESAR_A_MRTL_STATUS_IND)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MARITAL_STATUS_IND	NO
DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	PARENT_MARITAL_STATUS_IND	NO
DECODE(RCRESAR_A_PAR_TAX_FILED_IND)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	PARENT_TAX_FILER_IND	NO
DECODE(RCRESAR_A_S_DEPENDANTS)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ASSUMED_DEPENDENT_IND	NO
DECODE(RCRESAR_A_TAX_FILED_IND)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	TAX_FILER_IND	NO
DECODE(RCRESAR_A_VA_STATUS)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ASSUMED_VETERAN_IND	NO
DECODE(RCRESAR_DUP_REQ_IND)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	DUPLICATE_REQUEST_IND	NO
DECODE(RCRESAR_EDE_ETI_IND)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ISIR_ELECT_TRANSACTION_DESC	NO
DECODE(RCRESAR_EDE_INST_IND)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ELECT_APPL_ENTRY_SOURCE_IND	NO
DECODE(RCRESAR_FED_HOUS_CDE_1)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING1_DESC	NO
DECODE(RCRESAR_FED_HOUS_CDE_10)	NA	NO
DECODE(RCRESAR_FED_HOUS_CDE_2)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING2_DESC	NO
DECODE(RCRESAR_FED_HOUS_CDE_3)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING3_DESC	NO
DECODE(RCRESAR_FED_HOUS_CDE_4)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING4_DESC	NO
DECODE(RCRESAR_FED_HOUS_CDE_5)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING5_DESC	NO
DECODE(RCRESAR_FED_HOUS_CDE_6)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING6_DESC	NO
DECODE(RCRESAR_FED_HOUS_CDE_7)	NA	NO
DECODE(RCRESAR_FED_HOUS_CDE_8)	NA	NO
DECODE(RCRESAR_FED_HOUS_CDE_9)	NA	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_1)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG1_DESC	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_10)	NA	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_2)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG2_DESC	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_3)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG3_DESC	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_4)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG4_DESC	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_5)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG5_DESC	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_6)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG6_DESC	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_7)	NA	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_8)	NA	NO
DECODE(RCRESAR_M_SCHOOL_FLAG_9)	NA	NO
DECODE(RCRESAR_REC_TYPE)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	PROCESSED_RECORD_TYPE_DESC	NO
DECODE(RCRESAR_SEC_EFC_TYPE)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	SECONDARY_EFC_TYPE_DESC	NO
DECODE(RCRESAR_SUB_APP)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	SUBSEQUENT_APPLICATION_IND	NO
DECODE(RCRIMP1_AID_STATUS)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	FINANCIAL_AID_STATUS_DESC	NO
DECODE(RCRIMP1_APPLIC_TYPE)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_PROFILE_SPECIFIC	APPLICATION_TYPE_DESC APPLICATION_TYPE_DESC	NO NO
DECODE(RCRIMP1_FIN_AID_STATUS)	RNASUXX	NO
DECODE(RCRIMP1_FOREIGN_ADDR_IND)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC NEED_ANALYSIS_DEMOGRAPHIC	FOREIGN_ADDRESS_IND FOREIGN_ADDRESS_IND	NO NO
DECODE(RCRIMP1_HOUS_CDE_10)	RNASUXX	NO
DECODE(RCRIMP1_HOUS_CDE_9)	RNASUXX	NO
DECODE(RCRIMP1_LINE2_SCHL_TYPE)	RNASUXX	NO
DECODE(RCRIMP1_LINE3_SCHL_TYPE)	RNASUXX	NO
DECODE(RCRIMP1_LINE4_SCHL_TYPE)	RNASUXX	NO
DECODE(RCRIMP1_LINE5_SCHL_TYPE)	RNASUXX	NO
DECODE(RCRIMP1_LINE6_SCHL_TYPE)	RNASUXX	NO
DECODE(RCRIMP1_LINE7_SCHL_TYPE)	RNASUXX	NO
DECODE(RCRIMP1_LINE8_SCHL_TYPE)	RNASUXX	NO
DECODE(RCRIMP1_LOCATION_COMPUTER)	RNASUXX	NO
DECODE(RCRIMP1_ONLINE_SIG)	RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	ONLINE_SIGNATURE_IND	NO
DECODE(RCRIMP1_OWN_BUS_HM_SELF_EMP)	RNAPRXX	NO	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	IM_SELF_EMPLOYED_IND	NO
DECODE(RCRIMP1_PAR_NTRL_SEP_DIV)	RNASUXX	NO
DECODE(RCRIMP1_PAR_OWN_BUS_FARM)	RNAPRXX	NO	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	PARENT_OWN_BUSINESS_IND	NO
DECODE(RCRIMP1_PAR_SELF_EMPLOYED)	RNAPRXX	NO	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	IM_PARENT_SELF_EMPLOYED_IND	NO
DECODE(RCRIMP1_PAR_SMALL_BUSINESS)	RNAPRXX	NO	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	IM_PARENT_LARGE_BUSINESS_IND	NO
DECODE(RCRIMP1_SMALL_BUSINESS)	RNAPRXX	NO	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	IM_LARGE_BUSINESS_IND	NO
DECODE(RCRIMP1_STU_MOST_SUPPORT_FROM)	RNASUXX	NO
DECODE(RCRIMP1_TRUST_AVAIL_IND)	RNAPRXX RNASUXX	NO	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	TRUST_AVAILABILITY_IND	NO
DECODE(RCRIMP1_TRUST_ESTAB_BY)	RNAPRXX	NO
DECODE(RNROVRD_ADD_BK_HOPE_OPT)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_ADD_HOPE_LL_IND	NO
DECODE(RNROVRD_ALLOW_IM_PC_LOWR_FM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_LOWER_THAN_FM_IND	NO
DECODE(RNROVRD_ALLOW_IM_SC_LOWR_FM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_LOWER_THAN_FM_IND	NO
DECODE(RNROVRD_CALC_US_TAX_FM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_STUD_CALC_FED_TAX_OVR_IND	NO
DECODE(RNROVRD_CALC_US_TAX_IM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_CALC_FEDERAL_TAX_OVR_DESC	NO
DECODE(RNROVRD_CHG_DEPEND_FM)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_CHANGE_DEPENDENCY_STAT_DESC	NO
DECODE(RNROVRD_CHG_DEPEND_IM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_CHANGE_DEPENDENCY_STAT_DESC	NO
DECODE(RNROVRD_FAMILY_ASSETS)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_ASSET_COMBINED_DESC	NO
DECODE(RNROVRD_FM_PAR_NUM_COL)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_PARENT_NO_COLLEGE_OVR_IND	NO
DECODE(RNROVRD_F_SSN_NO_DOB_REJ_OVRD)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_S_IND	NO
DECODE(RNROVRD_F_SSN_NO_NAME_REJ_OVRD)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_E_IND	NO
DECODE(RNROVRD_HOME_VAL_PROJ)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_HOME_VALUE_PROJ_DESC	NO
DECODE(RNROVRD_INV_PROJ)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_IMPUTE_ASSET_DESC	NO
DECODE(RNROVRD_LIMIT_PC_BY_BDGT)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	LIMIT_OTHERS_SHARE_PC_DESC	NO
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_T_IND	NO
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD_	RNAOVXX	NO
DECODE(RNROVRD_M_SSN_NO_NAME_REJ_OVRD)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_F_IND	NO
DECODE(RNROVRD_NON_CUST_OPT)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_NONCUS_CONT_CAL_DESC	NO
DECODE(RNROVRD_NON_CUST_PC_OPT)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_USE_NONCUSTODIAL_PC_IND	NO
DECODE(RNROVRD_PAR_ADD_BK_HOPE_OPT)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_ADD_HOPE_LL_IND	NO
DECODE(RNROVRD_PAR_AGI_OPT)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_WHICH_AGI_DESC	NO
DECODE(RNROVRD_PAR_CALC_US_TAX_FM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_PARENT_CALC_FED_TAX_OVR_IND	NO
DECODE(RNROVRD_PAR_CALC_US_TAX_IM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_CALC_FED_TAX_OV_DESC	NO
DECODE(RNROVRD_PAR_USE_PROJ_INC_EFM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_EFM_EST_INCOME_IND	NO
DECODE(RNROVRD_SKIP_AGE_EXCL)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_SKIP_AGE_EXCLUSION_IND	NO
DECODE(RNROVRD_SSN_NO_DOB_REJ_OVRD)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_R_IND	NO
DECODE(RNROVRD_SSN_NO_NAME_REJ_OVRD)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_D_IND	NO
DECODE(RNROVRD_S_HOME_VAL_PROJ)	NA	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_HOME_VALUE_PROJECT_DESC	NO
DECODE(RNROVRD_USE_PROJ_INC_EFM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_EFM_ESTIMATED_INCOME_IND	NO
DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	USE_PARENT_STATE_PROV_TAX_IND	NO
DECODE(RNROVRD_ZERO_LOSS_BUS_FARM)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_ZERO_LOSS_BUS_IND	NO
DECODE(RNROVRD_ZERO_LOSS_OTH)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_ZERO_LOSS_OTH_IND	NO
DECODE(RPRADSB_ALTERNATE_PELL_IND,'N')	ROAPELL	NO	REPORTING VIEW	AWARD_DISBURSEMENT	ALTERNATE_PELL_PAY_SCHED_IND	NO
DECODE(RPRADSB_CONCUR_ENROLL_FLAG)	NA	NO	REPORTING VIEW	AWARD_DISBURSEMENT	COD_CONCURRENT_ENROLLMENT_IND	NO
DECODE(RPRADSB_DEBIT_CREDIT_IND)	RPRADSB	NO	REPORTING VIEW	AWARD_DISBURSEMENT	DEBIT_CREDIT_DESC	NO
DECODE(RPRADSB_DISBURSE_LOAD)	RPAAWRD	NO	REPORTING VIEW	AWARD_DISBURSEMENT	DISBURSEMENT_LOAD_DESC	NO
DECODE(RPRADSB_DISBURSE_LOAD_OPT)	RPRADSB	NO	REPORTING VIEW	AWARD_DISBURSEMENT	DISBURSEMENT_LOAD_OPT_DESC	NO
DECODE(RPRADSB_DISB_ACPT_DEBIT_CR_IND)	RPRADSB	NO	REPORTING VIEW	AWARD_DISBURSEMENT	COD_DEBIT_CREDIT_DESC	NO
DECODE(RPRADSB_DISB_ACTION_CODE)	RPRADSB	NO	REPORTING VIEW	AWARD_DISBURSEMENT	COD_DISBURSEMENT_ACTION_DESC	NO
DECODE(RPRADSB_PELLC_DISB_LOAD)	RPAAWRD	NO	REPORTING VIEW	AWARD_DISBURSEMENT	PELL_CALCULATED_DISB_LOAD_DESC	NO
DECODE(RPRADSB_PELLC_DISB_LOAD_OPT)	RPRADSB	NO	REPORTING VIEW	AWARD_DISBURSEMENT	PELL_CALC_DISB_LOAD_OPT_DESC	NO
DECODE(RPRADSB_POTENTIAL_OVERPMT_FLAG)	NA	NO	REPORTING VIEW	AWARD_DISBURSEMENT	COD_POTENTIAL_OVERPAYMENT_IND	NO
DECODE(RPRADSB_SHARED_SAR_ID_FLAG)	NA	NO	REPORTING VIEW	AWARD_DISBURSEMENT	COD_SHARED_SAR_IDENTIFIER_IND	NO
DECODE(RPRARSC_TYPE_CODE)	RPAARSC	NO	REPORTING VIEW	APPLICANT_RESOURCE	RESOURCE_TYPE_DESC	NO
DECODE(RPRATRM_LOCK_IND)	NA	NO	REPORTING VIEW	AWARD_BY_PERSON	AWARD_LOCKED_DESC	NO	This function returns Locked if the student's lock indicator RPRATRM_LOCK_IND is Y, Locked except for enrollment adjustments during disbursement if the value is E, and Not Locked if the value is N.
DECODE(RPRATRM_NSLDS_OVRD_IND)	NA	NO					This function returns Limit Tests (aggregate) if the student rules have been overridden for the award for the period if the value is L, Default Tests if the value is D, Overpayment Tests if the value is O, and All Tests if the value is A.
DECODE(RPRATRM_PCKG_LOAD_IND)	NA	NO					This function returns Full Time as a time status description if the packaging load indicator for the student RPRATRM_PCKG_LOAD_IND is 1, 3/4 Time if 2, 1/2 Time if 3, Less than 1/2 Time if 4, and Not Enrolled if 5.
DECODE(RPRATRM_PELL_AWRD_LOAD_OPT)	NA	NO					This function returns Full Time as a pell enrollment award option description if the applicant grant award enrollment option for the student RPRATRM_PELL_AWRD_LOAD_OPT is 1, 3/4 Time if 2, 1/2 Time if 3, Less than 1/2 Time if 4, Adjusted Hours if A, Billing hours if B, Defaults if D, Expected enrollment if E, ISIR/FAFSA enrollment if I, and Manual if M.
DECODE(RPRAWRD_LOCK_IND)	NA	NO	REPORTING VIEW	AWARD_BY_PERSON	ANNUAL_AWARD_LOCKED_DESC	NO	This function returns Locked as an award locked description if the award has been locked for the student RPRAWRD_LOCK_IND is Y, Locked except for enrollment adjustements during disbursement if E, and Not locked if N.
DECODE(RPRAWRD_OVERRIDE_YR_IN_COLL)	NA	NO
DECODE(RPRAWRD_SYS_IND)	NA	NO	REPORTING VIEW	AWARD_BY_PERSON	SYSTEM_DESC	NO	This function returns Manual as a system description if the system indicator for the applicant RPRAWRD_SYSTEM_IND is M, System if S, and Both if B.
DECODE(RPRAWRD_UNMET_NEED_OVRDE_IND)	NA	NO					This function returns Loan as an unmet need override description if the unmet need override indicator for the applicant RPRAWRD_UNMET_NEED_OVRD_IND is L, No if N, and Yes if Y.
DECODE(RPRLADB_DISBURSE_LOAD)	RPALDSB	NO	REPORTING VIEW	LOAN_DISBURSEMENT	ENROLLMENT_LOAD_DESC	NO
DECODE(RPRLADB_DISBURSE_LOAD_OPT)	RPALDSB	NO
DECODE(RPRLADB_DISB_STATUS)	RPALORG	NO
DECODE(RPRLADB_FEED_IND)	NA	NO	REPORTING VIEW	LOAN_DISBURSEMENT	DISBURSEMENT_FEED_DESC	NO
DECODE(RPRLADB_HOLD_REL_STATUS)	RPAELAP	NO	REPORTING VIEW	LOAN_DISBURSEMENT	HOLD_RELEASE_STATUS_DESC	NO
DECODE(RPRLADB_SERV_TRANS_TYPE)	NA	NO	REPORTING VIEW	LOAN_DISBURSEMENT	TRANSACTION_TYPE_DESC	NO
DECODE(RPRLAPP_COSIGN1_RELATION_IND)	NA	NO	REPORTING VIEW	LOAN_APPLICATION	COSIGN1_RELATIONSHIP_DESC	NO	DECODE(RPRLAPP_COSIGN1_RELATION_IND,'E','Employer','F','Friend','G','Guardian','O','Other','P','Parent','R','Relative','S','Sibling',NULL)
DECODE(RPRLAPP_COSIGN2_RELATION_IND)	NA	NO	REPORTING VIEW	LOAN_APPLICATION	COSIGN2_RELATIONSHIP_DESC	NO	DECODE(RPRLAPP_COSIGN1_RELATION_IND,'E','Employer','F','Friend','G','Guardian','O','Other','P','Parent','R','Relative','S','Sibling',NULL)
DECODE(RPRLAPP_IN_DEFAULT)	RPALORG	NO
DECODE(RTVFSRC_IND)	NA	NO	REPORTING VIEW	DESIGNATION_FINAID_FUND	FUND_SOURCE_TYPE_DESC	NO	NA
DECODE(RTVFTYP_ATYP_IND)	NA	NO	REPORTING VIEW	AWARD_BY_PERSON FINAID_FUND AWARD_BY_FUND FINAID_FUND AWARD_BY_FUND FINAID_FUND AWARD_BY_PERSON	GIFT_OR_SELF_HELP_AID_DESC GIFT_OR_SELF_HELP_AID_DESC GIFT_OR_SELF_HELP_AID_DESC FINANCIAL_AID_TYPE_DESC GIFT_OR_SELF_HELP_AID GIFT_OR_SELF_HELP_AID GIFT_OR_SELF_HELP_AID	NO NO NO NO NO NO NO	NA
DECODE(RTVFTYP_IND)	NA	NO	REPORTING VIEW	DESIGNATION_FINAID_FUND	FINANCIAL_AID_TYPE_DESC	NO
DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME')	SAAADMS	NO	REPORTING VIEW	GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT	INTENDED_TIME_STATUS_DESC INTENDED_TIME_STATUS_DESC	NO NO	NA
DECODE(SFBETRM_AR_IND)	TBD	NO	REPORTING VIEW	STUDENT ENROLLMENT	AR_CHARGES_ACCEPT_IND_DESC AR_CHARGES_ACCEPT_IND_DESC	NO NO
DECODE(SFBETRM_MAXH_SRCE_CDE)	TBD	NO	REPORTING VIEW	ENROLLMENT	MAXIMUM_REQUIRED_SOURCE_DESC	NO
DECODE(SFBETRM_MINH_SRCE_CDE)	TBD	NO	REPORTING VIEW	ENROLLMENT	MINIMUM_REQUIRED_SOURCE_DESC	NO
DECODE(SFBETRM_PIDM, NULL, 'N', 'Y')	NA	NO	REPORTING VIEW	VETERAN_CERTIFICATION ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY ENROLLMENT STUDENT STUDENT_EXTENDED	ENROLLMENT_EXISTS_IND ENROLLMENT_EXISTS_IND ENROLLMENT_EXISTS_IND ENROLLMENT_EXISTS_IND ENROLLMENT_EXISTS_IND ENROLLMENT_EXISTS_IND	NO NO NO NO NO NO
DECODE(SFRPLAN_COMMENT)	NA	NO	REPORTING VIEW	REGISTRATION_PLAN REGISTRATION_PLAN_COURSE	PLAN_COMMENT_EXISTS_IND PLAN_COMMENT_EXISTS_IND	NO NO
DECODE(SFRPLAN_SRC_CDE)	NA	NO	REPORTING VIEW	REGISTRATION_PLAN_COURSE	PLAN_COURSE_SOURCE_DESC	NO
DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y')	SFASLST	NO	REPORTING VIEW	STUDENT_COURSE	FINAL_GRADE_ROLL_IND	NO	This function returns an N if the grade date SFRSTCR_GRDE_DATE is null else it returns a Y.
DECODE(SFRSTCR_PIDM,NULL,'N','Y')	SFAREGS	NO	REPORTING VIEW	STUDENT_COURSE	IN_PROGRESS_COURSE_IND	NO	This function returns an N if the registration record SFRSTCR does not exist for the specified UID, academic period and course else it returns a Y.
DECODE(SFRSTCR_PIDM,NULL,'Y','N')	SFAREGS	NO	REPORTING VIEW	STUDENT_COURSE	INSTITUTION_COURSE_IND	NO	This function returns an N if the registration record SFRSTCR does not exist for the specified UID, academic period and course else it returns a Y.
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1)+DECODE(SGBSTDN_LEVL_CODE_2,NULL,0, DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1))	SGASTDN	NO	REPORTING VIEW	STUDENT_EXTENDED STUDENT	ACADEMIC_STUDY_MATRIC_IN_COUNT ACADEMIC_STUDY_MATRIC_IN_COUNT	NO NO	This function returns a 0, 1, or 2 based on the matriculated academic period SGBSTDN_TERM_CODE_MATRIC and the secondary level code SGBSTDN_LEVL_CODE_2. If the matriculated academic period is null and the secondary level code is null then this will return a 0. If the matriculated academic period is null and the secondary level code is not null then this will return a 0. If the matriculated academic period is not null and the secondary level code is null then it will return a 1. If both values are not null then it will return a 2.
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,N, Y)	SGASTDN	NO					DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,N,Y)
DECODE(SHRATTR_PIDM, NULL, 'N', 'Y')	NA	NO	REPORTING VIEW	STUDENT_COURSE_ATTRIBUTE	INSTITUTION_COURSE_IND	NO	NA
DECODE(SHRDGDH_HOND_CODE,NULL,NULL,'D')	SHADEGR	NO					This function returns a null if the honor code SHRDGDH_HOND_CODE is null, else it returns an D.
DECODE(SHRDGIH_HONR_CODE,NULL,NULL,'I')	SHADEGR	NO					This function returns a null if the honor code SHRDGIH_HONR_CODE is null, else it returns an I.
DECODE(SHRLGPA_GPA_TYPE_IND,'I', 'INSTITUTION','T','TRANSFER','O', 'OVERALL')	NA	NO	REPORTING VIEW	GPA_BY_LEVEL GPA	GPA_TYPE_DESC GPA_TYPE_DESC	NO NO	This function returns Institution if the gpa type indicator SHRLGPA_GPA_TYPE_IND is I, it returns Transfer if the gpa type indicator is a T else it returns Overall if the gpa type indicator is an O.
DECODE(SHRTATT_PIDM, NULL, 'N', 'Y')	NA	NO	REPORTING VIEW	STUDENT_COURSE_ATTRIBUTE	TRANSFER_COURSE_IND	NO	NA
DECODE(SHRTATT_PIDM, NULL, 'Y', 'N')	NA	NO					NA
DECODE(SHRTGPA_GPA_TYPE_IND,'I', 'INSTITUTION','T','TRANSFER')	NA	NO	REPORTING VIEW	GPA GPA_BY_TERM	GPA_TYPE_DESC GPA_TYPE_DESC	NO NO	This function returns Institution if the gpa type indicator SHRLGPA_GPA_TYPE_IND is I, else it returns Transfer if the gpa type indicator is a T.
DECODE(SHRTRCE_PIDM,NULL,'N','Y')	SHATRNS	NO	REPORTING VIEW	STUDENT_COURSE	TRANSFER_COURSE_IND	NO	This function returns a N if the transfer course record SHRTRCE doesn't exist, else a Y.
DECODE(SHRTRCR_ART_IND,NULL,'NO ARTICULATION RULE','N','COURSE HAS NO INSTITUTION EQUIVALENT','Y','COURSE HAS INSTITUTION EQUIVALENT')	TBD	NO	REPORTING VIEW	STUDENT_TRANSFERRED_COURSE	TRANS_ARTICULATION_RULE_DESC	NO
DECODE(SHRTTRM_RECORD_STATUS_IND)	NA	NO	REPORTING VIEW	STUDENT STUDENT_EXTENDED	GRADE_MAILER_STATUS_DESC GRADE_MAILER_STATUS_DESC	NO NO
DECODE(SIBFACD_PRIMARY_ACTIVITY)	NA	NO	REPORTING VIEW	FACULTY	PRIMARY_ACTIVITY_DESC	NO	This function returns Administrator as primary activity description if the primary activity for the faculty SIBFACD_PRIMARY_ACTIIVTY is A, Instructional if I, and Research if R.
DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C', 'CLASS','OTHER')	SLARASG	NO	REPORTING VIEW	ROOM_ASSIGNMENT	ROOM_TYPE_DESC	NO	This function returns DORM if the room type SLBRDEF_ROOM_TYPE is D, CLASS if the room type is C else OTHER.
DECODE(SORAPPT_INTV_PIDM,NULL,NULL, F_FORMAT_NAME(SORAPPT_INTV_PIDM,'LFMI'))	SOAAPPT	NO	REPORTING VIEW	CONTACT	INTERVIEWER_NAME	NO	This function returns null if the pidm is null SORAPPT_INTV_PIDM else it returns the formatted name of the interviewer.
DECODE(SORBACD_STATE_APPROV_IND)	NA	NO	REPORTING VIEW	INSTITUTION_DEMOGRAPHIC	APPROVED_IND	NO	DECODE(SORBACD_STATE_APPROV_IND,'Y','Y','N')
DECODE(SORDEGR_SBGI_CODE)	NA	NO	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME	TRANSFER_WORK_EXISTS_IND	NO
DECODE(SORLCUR_SITE_CODE)	NA	NO	REPORTING VIEW	GOVERNMENT_STUDENT	SITE	NO	DECODE(SORLCUR_SITE_CODE,NULL,SGBSTDN_SITE_CODE,SORLCUR_SITE_CODE)
DECODE(SORLCUR_TERM_CODE_ADMIT)	NA	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	NEW_STUDENT_IND NEW_STUDENT_IND	NO NO	NA
DECODE(SORLCUR_TERM_CODE_MATRIC)	SGASTDN	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	MATRICULATED_IND MATRICULATED_IND	NO NO	DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,'N','Y')
DECODE(SPBPERS_NAME_PREFIX,NULL,DECODE( SPBPERS_SEX,'M','MR.','F','MS.'), SPBPERS_NAME_PREFIX)	NA	NO	REPORTING VIEW	CONSTITUENT	NAME_PREFIX	NO	This function returns Mr. or Ms. Based on the gender if the name prefix SPBPERS_NAME_PREFIX is null, else it returns the name prefix.
DECODE(SPBPERS_SEX,'M','MALE','F', 'FEMALE','N','NOT REPORTED')	SPAPERS	NO	REPORTING VIEW	GOVERNMENT_ADMISSIONS PERSON_DETAIL GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_SENSITIVE PERSON GOVERNMENT_STUDENT	GENDER_DESC GENDER_DESC GENDER_DESC GENDER_DESC GENDER_DESC GENDER_DESC GENDER_DESC	NO NO NO NO NO NO NO	This calculation returns MALE if the gender SPBPERS_SEX is M else it returns FEMALE if the gender is F else if the gender is N it returns NOT REPORTED.
DECODE(SPBPERS_VERA_IND)	SPAPERS	NO	REPORTING VIEW	PERSON	VETERAN_CATEGORY_DESC	NO	This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran.
DECODE(SPBPERS_VERA_IND, NULL, NULL, O, OTHER PROTECTED VETERAN ONLY, V, VIETNAM VETERAN ONLY, B, BOTH - VIETNAM AND OTHER ELIGIBLE VETERAN)	SPAPERS	NO	REPORTING VIEW	PERSON_VETERAN	VETERAN_CATEGORY_DESC	NO	NA
DECODE(SPBPERS_VERA_IND,NULL,NULL, 'VETERAN')	SPAPERS	NO	REPORTING VIEW	PERSON_DETAIL	VETERAN_CATEGORY_DESC	NO	This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran.
DECODE(SPRIDEN_ID,NULL,NULL,'BANNER')	NA	NO	REPORTING VIEW	PERSON_DETAIL PERSON	ID_SOURCE ID_SOURCE	NO NO	This function returns null if the id SPRIDEN_ID is null else it returns BANNER.
DECODE(SPRMEDI_DISB_IND,'Y','Y','N')	SPAMEDI	NO					NA
DECODE(SSRFEES_FEE_IND)	SSADETL	NO	REPORTING VIEW	COURSE_OFFERING_FEES	FEE_METHOD_DESC	NO
DECODE(STVAPDC_APPL_INACT)	NA	NO	REPORTING VIEW	ADMISSIONS_DECISION GOVERNMENT_ADMISSIONS	APPLICATION_INACTIVE_IND APPLICATION_INACTIVE_IND	NO NO	DECODE (stvapdc_appl_inact, NULL, 'N', stvapdc_appl_inact)
DECODE(STVAPDC_INST_ACC_IND)	NA	NO	REPORTING VIEW	GOVERNMENT_ADMISSIONS ADMISSIONS_DECISION	INSTITUTION_ADMIT_IND INSTITUTION_ADMIT_IND	NO NO	DECODE (stvapdc_inst_acc_ind, NULL, 'N', stvapdc_inst_acc_ind)
DECODE(STVAPDC_REJECT_IND)	NA	NO	REPORTING VIEW	GOVERNMENT_ADMISSIONS ADMISSIONS_DECISION	INSTITUTION_DENIED_IND INSTITUTION_DENIED_IND	NO NO	DECODE (stvapdc_reject_ind, NULL, 'N', stvapdc_reject_ind)
DECODE(STVAPDC_SIGNF_IND)	NA	NO	REPORTING VIEW	GOVERNMENT_ADMISSIONS ADMISSIONS_DECISION	APPLICATION_SIGNIF_IND APPLICATION_SIGNIF_IND	NO NO	DECODE (stvapdc_signf_ind, NULL, 'N', stvapdc_signf_ind)
DECODE(STVAPDC_STDN_ACC_IND)	NA	NO	REPORTING VIEW	ADMISSIONS_DECISION GOVERNMENT_ADMISSIONS	APPLICANT_ACCEPT_IND APPLICANT_ACCEPT_IND	NO NO	This functions returns Applicant when the indicator ro student acceptance indicated by the decision value is Y, Institution with the value for institution acceptance indicated by the decision value is Y, Institution when the decision code is a reject decision, and Indeterminate if either value is null. CASE WHEN stvapdc_stdn_acc_ind = 'Y' THEN 'Applicant' WHEN stvapdc_inst_acc_ind = 'Y' THEN 'Institution' WHEN stvapdc_reject_ind = 'Y' THEN 'Institution' ELSE 'Indeterminate' END
DECODE(STVEVEN_TRANS_IND)	NA	NO	REPORTING VIEW	ACADEMIC_HISTORY_EVENT	TRANSCRIPT_IND	NO
DECODE(STVRESD_IN_STATE_IND)	NA	NO	REPORTING VIEW	STUDENT_EXTENDED	RESIDENCY_IND	NO
DECODE(STVRRCD_MONTHLY_IND,'Y', 'MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y', 'DAILY','TERMLY'))	SLARASG	NO	REPORTING VIEW	ROOM_ASSIGNMENT	ROOM_RATE_TIME	NO	This function returns Monthly if the monthly indicator STVRRCD_MONTHLY_IND is Y, it returns Daily if the daily indicator STVRRCD_DAILY_IND is Y, else it returns Termly.
DECODE(STVSBGI_TYPE_IND,'C','COLLEGE', 'H','HIGHSCHOOL','S','SOURCE-ONLY',NULL)	SOASBGI	NO	REPORTING VIEW	FINAID_TRACKING_REQUIREMENT RECRUITMENT_SOURCE INSTITUTION ADMISSIONS_SOURCE	INSTITUTION_TYPE_DESC RECRUIT_SOURCE_TYPE_DESC INSTITUTION_TYPE_DESC ADMISSIONS_SOURCE_TYPE_DESC	NO NO NO NO	This function returns COLLEGE when the institution type STVSBGI_TYPE_IND is C, HIGHSCHOOL if the institution type is an H, SOURCE-ONLY if the institution type is S else null.
DECODE(TBBACCT_REFUND_IND)	NA	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT	REFUND_IND_DESC	NO	This function determines the refund indicator description based upon the refund indicator. 'N'= 'No refund' 'Y' = 'Generate Refund' 'P' = 'Refund being processed' or NULL
DECODE(TBBCSTU_DEL_IND)	TSACONT	NO	REPORTING VIEW	CONTRACT	STUDENT_INACTIVATED_IND	NO	NA
DECODE(TBBESTU_DEL_IND)	TSAEXPP	NO	REPORTING VIEW	EXEMPTION	EXEMPTION_CANCELLED_IND	NO	NA
DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y')	TSADETC	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	RETURNED_CHECK_IND	NO	This function returns a N if the detail code TBBRETC_DETAIL_CODE is null else it return a Y.
DECODE(TBRACCD_BILL_DATE, NULL, NULL, TBRACCD_AMOUNT)	TSADETL	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	BILL_AMOUNT	NO	This function returns a null if the billing date TBRACCD_BILL_DATE is null, else it returns the transaction amount TBRACCD_AMOUNT.
DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_AMOUNT)	TSADETL	NO	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	ACCOUNT_POSTED_AMOUNT	NO	This function returns null if the feed date TBRACCD_FEED_DATE is null else it returns the transaction amount TBRACCD_AMOUNT.
DECODE(TBRDEPO_FEED_DATE, NULL, NULL, TBRDEPO_AMOUNT)	TSADETL	NO	REPORTING VIEW	DEPOSIT	ACCOUNT_POSTED_AMOUNT	NO	This function returns null if the feed date TBRDEPO_FEED_DATE is null else it returns the transaction amount TBRDEPO_AMOUNT.
DECODE(TBRMISD_PIDM)	TFAMISC	NO	REPORTING VIEW	MISCELLANEOUS_TRANSACTION	EXTERNAL_IND	NO	This function determines if the entity is external to the system.
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y')	NA	NO	REPORTING VIEW	CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT	MOVE_COMPLETION_IND PLANNED_MOVE_COMPLETE_IND	NO NO	NA
DECODE(TRANSACTION_HISTORY.FUND_POOL, NULL,FUND_HIERARCHY.FUND_POOL_DESC, TRANSACTION_HISTORY.FUND_POOL_DESC)	NA	NO	REPORTING VIEW	TRANSACTION_HISTORY	FUND_POOL_DESC	NO	Population of fund pool description is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
EARN	NA	NO	REPORTING VIEW	PERSONNEL_ACTION_EARNING	PAF_TRANSACTION_TYPE	NO
FFRMASA_AMT+FFRMASA_ADJ_AMT- FFRMASA_DEPR_ACCUM_AMT	FFAMAST	NO	REPORTING VIEW	FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_SOURCE	BOOK_VALUE BOOK_VALUE	NO NO	This calculation returns the book value for an asset by taking its original cost adding any adjustments and then subtracting the accumulated depreciation.
FGBGENL_SUM_PERIODIC_DR- FGBGENL_SUM_PERIODIC_CR	FGIGLAC	NO	REPORTING VIEW	GENERAL_LEDGER	CURRENT_ACTUAL	NO	This calculation returns the current actual for the general ledger entry by subtracting the credits from the debits.
FGBOPAL_XX_ACCTD_BUD - FGBOPAL_XX- 1_ACCT_BUD	FGIBDST	NO	REPORTING VIEW	OPERATING_LEDGER	CURR_ACCUMULATED_BUDGET	NO	This calculation returns the accumulated budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_ADOPT_BUD - FGBOPAL_XX- 1_ADOPT_BUD	FGIBDST	NO	REPORTING VIEW	OPERATING_LEDGER	CURR_ADOPTED_BUDGET	NO	This calculation returns the adopted budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_BUD_ADJT - FGBOPAL_XX- 1_BUD_ADJT	FGIBDST	NO	REPORTING VIEW	OPERATING_LEDGER	CURR_BUDGET_ADJUSTMENTS	NO	This calculation returns the budget adjustments for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_BUD_RSRV - FGBOPAL_XX- 1_BUD_RSRV	FGIBDST	NO	REPORTING VIEW	OPERATING_LEDGER	CURR_BUDGET_RESERVATION	NO	This calculation returns the budget reservations for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_ENCUMB - FGBOPAL_XX-1_ENCUMB	FGIBDST	NO	REPORTING VIEW	OPERATING_LEDGER	CURR_ENCUMBRANCES	NO	This calculation returns the encumbrances for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_TEMP_BUD - FGBOPAL_XX- 1_TEMP_BUD	FGIBDST	NO	REPORTING VIEW	OPERATING_LEDGER	CURR_TEMPORARY_BUDGET	NO	This calculation returns the temporary budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_YTD_ACTV - FGBOPAL_XX- 1_YTD_ACTV	NA	NO	REPORTING VIEW	OPERATING_LEDGER	CURR_YEAR_TO_DATE_ACTIVITY	NO	This calculation returns the activity for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_ACCTD_BUD - FRRGRNL_XX- 1_ACCTD_BUD	FRIGITD	NO	REPORTING VIEW	GRANT_LEDGER	CURR_ACCOUNTED_BUDGET	NO	This calculation returns the accounted budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_ADOPT_BUD - FRRGRNL_XX- 1_ADOPT_BUD	FRIGITD	NO	REPORTING VIEW	GRANT_LEDGER	CURR_ADOPTED_BUDGET	NO	This calculation returns the adopted budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_BUD_ADJT - FRRGRNL_XX- 1_BUD_ADJT	FRIGITD	NO	REPORTING VIEW	GRANT_LEDGER	CURR_BUDGET_ADJUSTMENTS	NO	This calculation returns the budget adjustments for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_BUD_RSRV - FRRGRNL_XX- 1_BUD_RSRV	FRIGITD	NO	REPORTING VIEW	GRANT_LEDGER	CURR_BUDGET_RESERVATIONS	NO	This calculation returns the budget reservations for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_ENCUMB - FRRGRNL_XX-1_ENCUMB	FRIGITD	NO	REPORTING VIEW	GRANT_LEDGER	CURR_ENCUMBRANCES	NO	This calculation returns the encumbrances for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_TEMP_BUD - FRRGRNL_XX- 1_TEMP_BUD	NA	NO	REPORTING VIEW	GRANT_LEDGER	CURR_TEMPORARY_BUDGET	NO	This calculation returns the temporary budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_YTD_ACTV - FRRGRNL_XX- 1_YTD_FRRGRNL	FRIGITD	NO	REPORTING VIEW	GRANT_LEDGER	CURR_YEAR_TO_DATE_ACTIVITY	NO	This calculation returns the activity for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRMEML_XX_YTD_ACTV - FRRMEML_XX- 1_YTD_ACTV	FRIMEMO	NO	REPORTING VIEW	GRANT_LEDGER	CURR_MEMO_COSTS	NO	This calculation returns the memo costs for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRVEVNT_DESC \|\| FRBEVNG_ALTERNATE_EVENT_DESC	NA	NO	REPORTING VIEW	GRANT_EVENT	GRANT_EVENT_FULL_DESC	NO
FRVEVNT_DESC \|\| FRBEVNG_ALTERNATE_EVNT_DESC	NA	NO	REPORTING VIEW	GRANT_EVENT_STATUS	GRANT_EVENT_FULL_DESC	NO
FTVSHIP_PHONE_AREA\|\|FTVSHIP_PHONE_NUM\|\|F TVSHIP_PHONE_EXT	NA	NO	REPORTING VIEW	PURCHASE_ORDER PURCHASE_ORDER_ITEM	PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED	NO NO	This calculation formulates the combined phone number by concatenating FTVSHIP_PHONE_AREA, FTVSHIP_PHONE_NUM, and FTVSHIP_PHONE_EXT.
FTVVEND_PHONE_AREA\|\|FTVVEND_PHONE_NUMBER \|\|FTVVEND_PHONE_EXT	NA	NO	REPORTING VIEW	VENDOR	PHONE_NUMBER_COMBINED	NO	This calculation formulates the combined phone number by concatenating FTVVEND_PHONE_AREA, FTVVEND_PHONE_NUMBER, and FTVVEND_PHONE_EXT.
F_GET_NORM_BALANCE	NA	NO	REPORTING VIEW	GRANT_DEFERRED_COST	ORIG_CALC_TRANSACTION_AMOUNT	NO
IF AGBMGID_AMT_PAID > = AGBMGID_AMT THEN Y, ELSE N	NA	NO	REPORTING VIEW	GIFT_MATCHING_TRANSACTION	MATCH_GIFT_FULLY_PAID_IND	NO	NA
IF AGBMGID_AMT_PAID IS > 0 AND < AGBMGID_AMT THEN Y, ELSE N	NA	NO	REPORTING VIEW	GIFT_MATCHING_TRANSACTION	MATCH_GIFT_PARTIAL_PAID_IND	NO	NA
LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+ RCRAPP2_C_PAR_1_CTRB_FOR_STDT)	NA	NO					LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)
LEVEL	FTMFUND	NO	REPORTING VIEW	ORGANIZATION_HIERARCHY_FISCAL PROGRAM_HIERARCHY ACCOUNT_HIERARCHY_FISCAL FUND_HIERARCHY FUND_HIERARCHY FUND_HIERARCHY_FISCAL ACCOUNT_HIERARCHY ORGANIZATION_HIERARCHY ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL LOCATION_HIERARCHY FUND_HIERARCHY_FISCAL LOCATION_HIERARCHY_FISCAL PROGRAM_HIERARCHY_FISCAL	ORGANIZATION_LEVEL PROGRAM_LEVEL ACCOUNT_TYPE_LEVEL FUND_LEVEL FUND_TYPE_LEVEL FUND_TYPE_LEVEL ACCOUNT_TYPE_LEVEL ORGANIZATION_LEVEL ACCOUNT_LEVEL ACCOUNT_LEVEL LOCATION_LEVEL FUND_LEVEL LOCATION_LEVEL PROGRAM_LEVEL	NO NO NO NO NO NO NO NO NO NO NO NO NO NO	This value is retrieved upon formulation of the validation table hierarchy and pertains to what level this code associates to within its hierarchy. (Level 1 being the highest level.)
MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS - MAKFUNC.F_CAMP_EXPENSES	NA	NO	REPORTING VIEW	CAMPAIGN	CAMPAIGN_VALUE	NO
MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS	NA	NO	REPORTING VIEW	CAMPAIGN	CAMPAIGN_PLEDGE_BALANCE	NO
MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES - MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS	NA	NO	REPORTING VIEW	CAMPAIGN_DESIGNATION	CAMP_DESG_PLEDGE_BALANCE	NO
MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100	NA	NO	REPORTING VIEW	SOLICITOR_ORGANIZATION	PCT_PROGRESS_DONOR_COUNT_GOAL	NO
MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS	NA	NO	REPORTING VIEW	SOLICITOR_ORGANIZATION	ORGANIZATION_PLEDGE_BALANCE	NO
MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS	NA	NO	REPORTING VIEW	CAMPAIGN_SOLICITATION	SOLICITATION_PLEDGE_BALANCE	NO
MAKFUNC.F_SOL_FR_TOTAL_PLEDGES - MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS	NA	NO	REPORTING VIEW	SOLICITOR_ORG_FUNDRAISER	SOLICITOR_PLEDGE_BALANCE	NO
MAX(APRACYR_YEAR)	NA	NO	REPORTING VIEW	SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT	LAST_YEAR1 LAST_YEAR LAST_YEAR3 LAST_YEAR2	NO NO NO NO	NA
MEKFUNC.F_AUTHORIZED_TOTAL ( R.PORTFOLIO_KEY, '%', 'Y') + MEKFUNC.F_TOTAL_NOT_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y')	TBD	NO	REPORTING VIEW	REIMBURSEMENT	PAY_AMOUNT_NOT_SUBMITTED	NO
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y')	TBD	NO	REPORTING VIEW	REIMBURSEMENT	PAY_AMOUNT_SUBMITTED	NO
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '9900ADVC', '%','Y')	TBD	NO	REPORTING VIEW	REIMBURSEMENT	ADVANCE_CLEARED	NO
MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE	FNIEBAL	NO	REPORTING VIEW	ENDOWMENT_SUMMARIZED_UNITS	MARKET_VALUE	NO	NA
MIN(APRACYR_YEAR)	NA	NO	REPORTING VIEW	SPECIAL_ACTIVITY	FIRST_YEAR	NO	NA
MONTHS_BETWEEN	NA	NO					NA
MONTHS_BETWEEN(NVL(APREHIS_TO_DATE, SYSDATE),APREHIS_FROM_DATE)	NA	NO	REPORTING VIEW	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	YEARS_MONTHS_IN_POSITION2 YEARS_MONTHS_IN_POSITION1 MONTHS_IN_POSITION YEARS_MONTHS_IN_POSITION3 YEARS_MONTHS_IN_POSITION4	NO NO NO NO NO	NA
MONTHS_BETWEEN(NVL(PPREXPE_END_DATE, SYSDATE),PPREXPE_START_DATE)	NA	NO	REPORTING VIEW	EMPLOYMENT_HISTORY	MONTHS_IN_POSITION	NO
MONTHS_BETWEEN(PPREXPE_END_DATE, PPREXPE_START_DATE)	NA	NO	REPORTING VIEW	CURRENT_EMPLOYMENT	MONTHS_IN_POSITION	NO	NA
NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND	NBAPBUD	NO	REPORTING VIEW	POSITION_BUDGET	AMOUNT_REMAINING	NO	This function calculates the result of the budget minus the encumbrance and minus the expenditures. NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND.
NVL (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE)	NA	NO	REPORTING VIEW	PREVIOUS_EDUCATION_ATTENDANCE	TRANSCRIPT_RECEIVED_DATE	NO	NVL (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE) returns transfer received date and if null, then returns prior college transcript received date.
NVL(ADBDESG_WEB_GIFT_IND,'N')	NA	NO	REPORTING VIEW	DESIGNATION	ALLOW_WEB_GIFT_IND	NO
NVL(ADBDESG_WEB_PLDG_IND,'N')	NA	NO	REPORTING VIEW	DESIGNATION	ALLOW_WEB_PLEGE_IND	NO
NVL(ADRCONF_CONFID_IND)	NA	NO	REPORTING VIEW	DESIGNATION_COMMENT	COMMENT_CONFIDENTIALITY_IND	NO
NVL(AFBCAMP_ASSOC_IND,'N')	NA	NO	REPORTING VIEW	CAMPAIGN	COUNT_IN_GIVING_IND	NO
NVL(AFRCSOL_GOAL,0)	NA	NO	REPORTING VIEW	CAMPAIGN_SOLICITATION	CAMPAIGN_SOLICITATION_GOAL	NO
NVL(AFRDESG_GOAL,0)	NA	NO	REPORTING VIEW	CAMPAIGN_DESIGNATION	CAMPAIGN_DESIGNATION_GOAL	NO
NVL(AGBPLDG_MATCH_FORM_IND)	NA	NO	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	MATCHING_GIFT_FORM_IND MATCHING_GIFT_FORM_IND	NO NO
NVL(AGBPLDG_MATCH_PROCESSED)	NA	NO	REPORTING VIEW	PLEDGE_TRANSACTION PLEDGE	MATCH_GIFT_FORM_PROCESSED_IND MATCH_GIFT_FORM_PROCESSED_IND	NO NO
NVL(AGBPLDG_MGFORM_READYTOSEND)	NA	NO	REPORTING VIEW	PLEDGE_TRANSACTION PLEDGE	MATCHGIFT_FORM_READYTOSEND_IND MATCHGIFT_FORM_READYTOSEND_IND	NO NO
NVL(AGBPLDG_PACK_IND,'N'),	NA	NO					NA
NVL(AGBPLDG_RECEIPT_IND,'N'),	NA	NO					NA
NVL(AGRGAUX_DEDUCT_FOR_TAXES,'N')	NA	NO	REPORTING VIEW	GIFT_AUXILIARY	DEDUCT_FOR_TAXES_IND	NO	NA
NVL(AMBPLAN_END_DATE,'31-DEC-2099')	NA	NO	REPORTING VIEW	CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT	STRATEGY_PLAN_END_DATE STRATEGY_PLAN_END_DATE	NO NO
NVL(AMRCONF_CONFID_IND)	NA	NO	REPORTING VIEW	PROSPECT_CONFIDENTIAL_COMMENT	COMMENT_CONFIDENTIALITY_IND	NO
NVL(AMRCONT_CONFID_IND)	NA	NO	REPORTING VIEW	CONSTITUENT_CONTACT	TICKLER_CONFIDENTIAL_IND	NO
NVL(AMRINFO_WEB_GIFT_IND,'N')	NA	NO	REPORTING VIEW	PROSPECT_INFO	ALLOW_WEB_GIFT_IND	NO
NVL(AMRINFO_WEB_PLDG_IND,'N')	NA	NO	REPORTING VIEW	PROSPECT_INFO	ALLOW_WEB_PLEDGE_IND	NO
NVL(AMRSTAF_END_DATE,'31-DEC-2099')	NA	NO	REPORTING VIEW	PROSPECT_STAFF_ASSIGNMENT	STAFF_ASSIGNMENT_END_DATE	NO
NVL(AMRSTAF_SOLICIT_IND,'N')	NA	NO	REPORTING VIEW	PROSPECT_INFO	SOLICITOR_IND	NO
NVL(APRCONF_CONFID_IND)	NA	NO	REPORTING VIEW	CONSTITUENT_CONF_COMMENT	COMMENT_CONFIDENTIALITY_IND	NO
NVL(APRCONF_DISP_NOTES_IND)	NA	NO	REPORTING VIEW	CONSTITUENT_CONF_COMMENT	DISPLAYED_IN_NOTE_IND	NO
NVL(APRCONF_OK_FOR_NOTES_IND)	NA	NO	REPORTING VIEW	CONSTITUENT_CONF_COMMENT	OK_FOR_NOTE_IND	NO
NVL(APRCONF_REVIEWED_IND)	NA	NO	REPORTING VIEW	CONSTITUENT_CONF_COMMENT	WEB_REVIEWED_IND	NO
NVL(ASBSORG_DOLLAR_GOAL,)	NA	NO
NVL(ASBSORG_DOLLAR_GOAL,0)	NA	NO	REPORTING VIEW	SOLICITOR_ORGANIZATION	ORGANIZATION_GOAL	NO
NVL(ASBSORG_DONOR_COUNT_GOAL,)	NA	NO
NVL(ASBSORG_DONOR_COUNT_GOAL,0)	NA	NO	REPORTING VIEW	SOLICITOR_ORGANIZATION	ORGANIZATION_DONOR_COUNT_GOAL	NO
NVL(ASBSORG_UPD_WEB_IND)	NA	NO
NVL(ASRSORG_UPD_WEB_IND)	NA	NO	REPORTING VIEW	SOLICITOR_ORG_FUNDRAISER	ALLOW_WEB_UPDATE_SOLICITOR_IND	NO
NVL(ATVCMPT_CAPITAL_IND,'N')	NA	NO	REPORTING VIEW	CAMPAIGN	CAPITAL_CAMPAIGN_IND	NO
NVL(ATVEMPS_ACTIVE_IND,'N')	ATVEMPS	NO					NA
NVL(AXBMGID_MGFORM_READYTOSEND)	NA	NO	REPORTING VIEW	PLEDGE_MATCHING_TRANSACTION PLEDGE_MATCHING	MATCH_FORM_SENT_IND MATCH_FORM_SENT_IND	NO NO
NVL(CURR_ADOPTED_BUDGET + CURR_BUDGET_ADJUSTMENTS, 0)	NA	NO	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER	CURR_TOTAL_BUDGET	NO	Calculates the total current budget as current adopted budget + current budget adjustments.
NVL(CURR_YEAR_TO_DATE_ACTV + CURR_ENCUMBRANCES + CURR_BUDGET_RESERVATION, 0)	NA	NO	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER	CURR_COMMITTED_BALANCE	NO	Calculates the current commited balance as current year to date activity + current encumbrances + current budget reservations (requisistions).
NVL(FABINVH_ACH_OVERRIDE_IND,'N')	NA	NO	REPORTING VIEW	INVOICE	DIRECT_DEPOSIT_OVERRIDE_IND	NO
NVL(FABINVH_DISB_AGENT_IND,'N')	NA	NO	REPORTING VIEW	INVOICE	DISBURSING_AGENT_IND	NO
NVL(FABINVH_EDIT_DEFER_IND,'N')	NA	NO	REPORTING VIEW	INVOICE	DEFERRED_EDIT_IND	NO
NVL(FABINVH_INVD_RE_ESTABLISH_IND,'N')	NA	NO	REPORTING VIEW	INVOICE	INVOICE_RE_ESTABLISHED_IND	NO
NVL(FABINVH_NSF_ON_OFF_IND,'N')	NA	NO	REPORTING VIEW	INVOICE	NSF_ON_OFF_IND	NO
NVL(FABINVH_RUIV_IND,'N')	FAAINVE	NO	REPORTING VIEW	INVOICE	REPEATING_INVOICE_IND	NO
NVL(FABINVH_RUIV_INSTALLMENT_IND,'N')	FAAINVE	NO	REPORTING VIEW	INVOICE	INSTALLMENT_IND	NO
NVL(FABINVH_SINGLE_ACCTG_IND,'N')	NA	NO	REPORTING VIEW	INVOICE	DOCUMENT_ACCOUNTING_IND	NO
NVL(FABINVH_TEXT_IND,'N')	NA	NO	REPORTING VIEW	INVOICE	TEXT_EXISTS_IND	NO
NVL(FABRUIV_MAX_SUB,0)	NA	NO	REPORTING VIEW	INVOICE	MAXIMUM_NUMBER_SUBMISSIONS	NO
NVL(FABRUIV_MAX_SUB,0) - NVL( FABRUIV_SUB_TO_DATE,0)	NA	NO	REPORTING VIEW	INVOICE	REMAINING_SUBMISSIONS	NO
NVL(FABRUIV_SUB_TO_DATE,0)	NA	NO	REPORTING VIEW	INVOICE	SUBMISSIONS_TO_DATE	NO
NVL(FARINVA_APPR_AMT,0)+NVL( FARINVA_ADDL_CHRG_AMT,0)+NVL( FARINVA_TAX_AMT,0)-NVL(FARINVA_DISC_AMT, 0)	FAAINVE	NO	REPORTING VIEW	INVOICE_ITEM_ACCOUNTING INVOICE_ACCOUNTING	APPROVED_CHARGE_AMOUNT APPROVED_CHARGE_AMOUNT	NO NO	This calculation returns the approved charge amount by summing the approved amount, additional charges, and tax amount and subtracting any associated discount.
NVL(FGBENCD_ABAL_OVERRIDE)	NA	NO	REPORTING VIEW	ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING	AVAILABLE_BALANCE_OVERRIDE_IND AVAILABLE_BALANCE_OVERRIDE_IND	NO NO
NVL(FGBENCH_EDIT_DEFERRAL,'N')	NA	NO	REPORTING VIEW	ENCUMBRANCE	DEFERRED_EDIT_IND	NO
NVL(FGBENCH_NSF_ON_OFF_IND,'N')	NA	NO	REPORTING VIEW	ENCUMBRANCE	NSF_ON_OFF_IND	NO
NVL(FPBPOHD_BLANKET_IND,'N')	FPABLAR	NO	REPORTING VIEW	PURCHASE_ORDER	BLANKET_ORDER_IND	NO
NVL(FPBPOHD_CANCEL_IND,'N')	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER	CANCEL_IND	NO
NVL(FPBPOHD_CLOSED_IND,'N')	NA	NO	REPORTING VIEW	PURCHASE_ORDER	CLOSED_IND	NO
NVL(FPBPOHD_EDI_IND,'N')	NA	NO	REPORTING VIEW	PURCHASE_ORDER	EDI_IND	NO
NVL(FPBPOHD_PRINT_IND,'N')	NA	NO	REPORTING VIEW	PURCHASE_ORDER	PRINT_IND	NO
NVL(FPBPOHD_REXP_DATE, FPBPOHD_BLANKET_TERM_DATE)	FPABLAR	NO	REPORTING VIEW	PURCHASE_ORDER	PO_END_DATE	NO	NA
NVL(FPBPOHD_SUSP_IND,'N')	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER	SUSPENSE_IND	NO
NVL(FPRPODA_ADDL_CHRG_AMT,0)	FPAPURR	NO
NVL(FPRPODA_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING	AMOUNT AMOUNT	NO NO
NVL(FPRPODA_AMT,0)+NVL( FPRPODA_ADDL_CHRG_AMT,0)+NVL( FPRPODA_TAX_AMT,0)-NVL(FPRPODA_DISC_AMT, 0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING	APPROVED_CHARGE_AMOUNT APPROVED_CHARGE_AMOUNT	NO NO	This calculation returns the approved charge amount by summing the approved amount, additional charges, and tax amount and subtracting any associated discount.
NVL(FPRPODA_CLOSED_IND,'N')	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_ACCOUNTING PURCHASE_ORDER_ACCOUNTING	CLOSED_IND CLOSED_IND	NO NO
NVL(FPRPODA_CONVERT_ADDL_CHRG_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING	CONVERTED_ADDITIONAL_AMOUNT CONVERTED_ADDITIONAL_AMOUNT	NO NO
NVL(FPRPODA_CONVERT_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING	CONVERTED_AMOUNT CONVERTED_AMOUNT	NO NO
NVL(FPRPODA_CONVERT_DISC_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING	CONVERTED_DISCOUNT_AMOUNT CONVERTED_DISCOUNT_AMOUNT	NO NO
NVL(FPRPODA_CONVERT_TAX_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING	CONVERTED_TAX_AMOUNT CONVERTED_TAX_AMOUNT	NO NO
NVL(FPRPODA_DISC_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_ACCOUNTING PURCHASE_ORDER_ACCOUNTING	DISCOUNT_AMOUNT DISCOUNT_AMOUNT	NO NO
NVL(FPRPODA_ENCB_ADJT_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_ACCOUNTING PURCHASE_ORDER_ACCOUNTING	ENCUMBRANCE_ADJUSTMENT_AMOUNT ENCUMBRANCE_ADJUSTMENT_AMOUNT	NO NO
NVL(FPRPODA_NSF_OVERRIDE_IND,'N')	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING	NSF_OVERRIDE_IND NSF_OVERRIDE_IND	NO NO
NVL(FPRPODA_SUSP_IND,'N')	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING	SUSPENSE_IND SUSPENSE_IND	NO NO
NVL(FPRPODA_TAX_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING	TAX_AMOUNT TAX_AMOUNT	NO NO
NVL(FPRPODT_ADDL_CHRG_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING PURCHASE_ORDER_ITEM	ADDITIONAL_AMOUNT ADDITIONAL_AMOUNT ADDITIONAL_CHARGES_AMOUNT	NO NO NO
NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_ADDITNAL_AMOUNT	NO
NVL(FPRPODT_CONVERT_DISC_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_DISCOUNT_AMOUNT	NO
NVL(FPRPODT_CONVERT_TAX_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_TAX_AMOUNT	NO
NVL(FPRPODT_CONVERT_UNIT_PRICE,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_UNIT_PRICE	NO
NVL(FPRPODT_DESC_CHGE_IND,'N')	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	COMMODITY_DESC_CHANGE_IND	NO
NVL(FPRPODT_DISC_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	DISCOUNT_AMOUNT	NO
NVL(FPRPODT_LIQ_AMT,0)	NA	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	LIQUIDATION_AMOUNT	NO
NVL(FPRPODT_QTY,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	QUANTITY	NO
NVL(FPRPODT_TAX_AMT,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	TAX_AMOUNT	NO
NVL(FPRPODT_UNIT_PRICE,0)	FPAPURR	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM	UNIT_PRICE	NO
NVL(FPRRCDT_TOL_OVERRIDE_IND)	FPARCVD	NO	REPORTING VIEW	RECEIVED_ITEM	TOLERANCE_OVERRIDE_IND	NO	Calculations deterimines if the override is set to (Y)es or (N)o.
NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID)	NA	NO
NVL(FTRACTA_ATTS_CODE,'NONE')	FTMFATA	NO	REPORTING VIEW	ACCOUNT_ATTRIBUTES	SET_CODE	NO	NA
NVL(FTRACVA_ATTS_CODE,'NONE')	FTMFATA	NO	REPORTING VIEW	ACTIVITY_ATTRIBUTES	SET_CODE	NO	NA
NVL(FTRATYA_ATTS_CODE,'NONE')	FTMFATA	NO	REPORTING VIEW	ACCOUNT_TYPE_ATTRIBUTES	SET_CODE	NO	NA
NVL(FTRFNDA_ATTS_CODE,'NONE')	FTMFATA	NO	REPORTING VIEW	FUND_ATTRIBUTES	SET_CODE	NO	NA
NVL(FTRFTYA_ATTS_CODE,'NONE')	FTMFATA	NO	REPORTING VIEW	FUND_TYPE_ATTRIBUTES	SET_CODE	NO	NA
NVL(FTRLCNA_ATTS_CODE,'NONE')	FTMFATA	NO	REPORTING VIEW	LOCATION_ATTRIBUTES	SET_CODE	NO	NA
NVL(FTRORGA_ATTS_CODE,'NONE')	FTMFATA	NO	REPORTING VIEW	ORGANIZATION_ATTRIBUTES	SET_CODE	NO	NA
NVL(FTRPRGA_ATTS_CODE,'NONE')	FTMFATA	NO	REPORTING VIEW	PROGRAM_ATTRIBUTES	SET_CODE	NO	NA
NVL(FTVACCT_ACCT_CODE_POOL, FTVACCT_ACCT_CODE)	FTMACCT	NO	REPORTING VIEW	ACCOUNT_HIERARCHY_FISCAL GRANT_LEDGER TRANSACTION_HISTORY TRANSACTION_HISTORY ACCOUNT_HIERARCHY GENERAL_LEDGER OPERATING_LEDGER GENERAL_LEDGER OPERATING_LEDGER GRANT_LEDGER BUDGET_AVAILABILITY_LEDGER BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL	ACCOUNT_POOL ACCOUNT_POOL ACCOUNT_POOL ORIG_ACCOUNT_POOL ACCOUNT_POOL ORIG_ACCOUNT_POOL ORIG_ACCOUNT_POOL ACCOUNT_POOL ACCOUNT_POOL ORIG_ACCOUNT_POOL ORIG_ACCOUNT_POOL ACCOUNT_POOL ACCOUNT_POOL	NO NO NO NO NO NO NO NO NO NO NO NO NO	This calculation retrieves the FTVACCT_ACCT_CODE_POOL if it is not NULL. Otherwise it retrieves the FTVACCT_ACCT_CODE.
NVL(FTVFUND_FUND_CODE_BAVL, FTVFUND_FUND_CODE)	FTMFUND	NO	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER GRANT_LEDGER OPERATING_LEDGER GENERAL_LEDGER GRANT_LEDGER BUDGET_DETAIL TRANSACTION_HISTORY FUND_HIERARCHY FUND_HIERARCHY_FISCAL BUDGET_AVAILABILITY_LEDGER GENERAL_LEDGER OPERATING_LEDGER	FUND_POOL ORIG_FUND_POOL ORIG_FUND_POOL ORIG_FUND_POOL FUND_POOL FUND_POOL ORIG_FUND_POOL FUND_POOL FUND_POOL ORIG_FUND_POOL FUND_POOL FUND_POOL	NO NO NO NO NO NO NO NO NO NO NO NO	This calculation retrieves the FTVFUND_FUND_CODE_BAVL if it is not NULL. Otherwise it retrieves the FTVFUND_FUND_CODE.
NVL(FTVORGN_ORGN_CODE_NSF, FTVORGN_ORGN_CODE)	FTMORGN	NO	REPORTING VIEW	OPERATING_LEDGER BUDGET_AVAILABILITY_LEDGER ORGANIZATION_HIERARCHY_FISCAL OPERATING_LEDGER TRANSACTION_HISTORY BUDGET_DETAIL BUDGET_AVAILABILITY_LEDGER GRANT_LEDGER ORGANIZATION_HIERARCHY	ORGANIZATION_POOL ORIG_ORGANIZATION_POOL ORGANIZATION_POOL ORIG_ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL	NO NO NO NO NO NO NO NO NO	This calculation retrieves the FTVORGN_CODE_NSF if it is not NULL. Otherwise it retrieves the FTVORGN_ORGN_CODE.
NVL(FTVVEND_TERM_DATE,'31-DEC-2099')	NA	NO	REPORTING VIEW	VENDOR AF_VENDOR	VENDOR_TERMINATION_DATE VENDOR_TERMINATION_DATE	NO NO
NVL(FTVVEND_VEND_CHECK_PIDM, FTVVEND_PIDM)	NA	NO	REPORTING VIEW	VENDOR AF_VENDOR	REMIT_TO_VENDOR_UID REMIT_TO_VENDOR_UID	NO NO
NVL(GERATTD_FEES_DESC, GTVFEES_DESC)	NA	NO	REPORTING VIEW	EVENT_INVITEE	FEE_STATUS_DESC	NO	NVL(GERATTD_FEES_DESC, GTVFEES_DESC), returns fee status for the invitee, and if it doesn't exist, then the fee status for the fee.
NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)	NA	NO	REPORTING VIEW	COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	DATE_SENT3 DATE_SENT1 DATE_SENT DATE_SENT2 DATE_SENT4 DATE_SENT5	NO NO NO NO NO NO	NA
NVL(NBBPOSN_ACCRUE_SENIORITY_IND, NTRPCLS_ACCRUE_SENIORITY_IND)	MULTIPLE	NO	REPORTING VIEW	POSITION_DEFINITION	SENIORITY_ACCRUED_IND	NO	Retrieves seniority accrual indicator from postion classification rule table if the indicator is null in the position record.
NVL(NBBPOSN_GRADE,NTRPCLS_GRADE)	NA	NO					This function returns NBBPOSN_GRADE if it is not null else it returns NTRPCLS_GRADE.
NVL(NBBPOSN_POSN_REPORTS, MPKFUNC.F_GET_POSITION_REPORTS)	MULTIPLE	NO	REPORTING VIEW	POSITION_DEFINITION	POSITION_REPORTS	NO	NVL(POSITION_REPORTS, SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION,'POSITION'),1,63))
NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE)	NA	NO	REPORTING VIEW	POSITION_DEFINITION	SALARY_GROUP	NO	NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE) returns salary group code for the salary group and if null, then returns salary group code for the position class.
NVL(NBBPOSN_STEP,NTRPCLS_STEP)	NA	NO					This function returns NBBPOSN_STEP if it is not null else it returns NTRPCLS_STEP.
NVL(NBBPOSN_TABLE,NTRPCLS_TABLE)	NA	NO					This function returns NBBPOSN_TABLE if it is not null, else it returns NTRPCLS_TABLE.
NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR)	NA	NO	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	SUPERVISOR_UID SUPERVISOR_UID	NO NO	NVL(P.NBRJOBS_SUPERVISOR_PIDM, TO_NUMBER(NOKODSF.F_GET_SUPERVISOR(B.NBBPOSN_POSN_REPORTS,'PIDM')))
NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS)	NA	NO	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	SUPERVISOR_POSITION SUPERVISOR_POSITION	NO NO	If the supervisor position in NBRJOBS is null, then retrieve the position reports number and calculate who the supervisor is.
NVL(NBRJOBS_SUPERVISOR_SUFF, NOKODSF.F_GET_SUPERVISOR)	NA	NO	REPORTING VIEW	EMPLOYEE_POSITION EMPLOYEE	SUPERVISOR_JOB_SUFFIX SUPERVISOR_JOB_SUFFIX	NO NO	NVL(NBRJOBS_SUPERVISOR_SUFF, SUBSTR(NOKODSF.F_GET_SUPERVISOR(NBBPOSN_POSN_REPORTS,'SUFFIX'),1,2)
NVL(PAY.TRANSACTION_DATE, CHG.TRANSACTION_DATE)	NA	NO	REPORTING VIEW	APPLICATION_OF_PAYMENT APPL_OF_PAY_DETAIL_ACCOUNTING	APPLIED_DATE APPLIED_DATE	NO NO	Applied date is set from the payment transaction date, and if null, then is set to the charge transaction date when the payment is applied to the charge.
NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL( RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0)	NA	NO	REPORTING VIEW	NEED_ANALYSIS	INAS_TFC	NO	NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL(RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0)
NVL(RCRAPP4_DUP_SSN_IND)	TBD	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	DUPLICATE_TAX_ID_IND	NO
NVL(RCRAPP4_PUSH_ISIR_FLAG)	RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	CPS_ISIR_PUSHED_IND	NO
NVL(RCRESAR_AUTO_ZERO_EFC_FLAG)	TBD	NO
NVL(RCRESAR_SUB_APP)	RNIMSXX	NO
NVL(RCRESAR_VERIF_CHANGE_IND)	RNARSXX RNIMSXX	NO	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	VERIFICATION_SELECT_CHANGE_IND	NO
NVL(RNROVRD_ADD_BK_HOPE_OPT)	TBD	NO
NVL(RNROVRD_ALLOW_IM_PC_LOWR_FM)	TBD	NO
NVL(RNROVRD_ALLOW_IM_SC_LOWR_FM)	TBD	NO
NVL(RNROVRD_CALC_US_TAX_FM)	TBD	NO
NVL(RNROVRD_NON_CUST_PC_OPT)	TBD	NO
NVL(RNROVRD_PAR_ADD_BK_HOME_OPT)	TBD	NO
NVL(RNROVRD_PAR_CALC_US_TAX_FM)	TBD	NO
NVL(RNROVRD_PAR_EXCL_TUIT_DED)	RNAOVXX	NO	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_EXCL_TUITION_FEE_IND	NO
NVL(RNROVRD_PAR_USE_PROJ_INC_EFM)	TBD	NO
NVL(RNROVRD_SKIP_AGE_EXCL)	TBD	NO
NVL(RNROVRD_USE_PROJ_INC_EFM)	TBD	NO
NVL(RNROVRD_ZERO_LOSS_BUS_FARM)	TBD	NO
NVL(RNROVRD_ZERO_LOSS_OTH)	TBD	NO
NVL(RPRADSB_ALTERNATE_PELL_IND,'N')	ROAPELL	NO
NVL(RPRADSB_CPS_VER_IND,'N')	READIXX	NO	REPORTING VIEW	AWARD_DISBURSEMENT	CPS_VERIFICATION_IND	NO
NVL(RPRADSB_DISB_LOCK_IND,'N')	READIXX	NO	REPORTING VIEW	AWARD_DISBURSEMENT	COD_DISBURSEMENT_LOCK_IND	NO
NVL(RPRADSB_EXCL_FROM_NET_AMT,'N')	READIXX	NO	REPORTING VIEW	AWARD_DISBURSEMENT	COD_NET_AMOUNT_EXCLUSION_IND	NO
NVL(RPRLAPP_ADDL_STFD_ELIG_IND,'N')	NA	NO	REPORTING VIEW	LOAN_APPLICATION LOAN_APPLICATION	ADDITIONAL_STAFFORD_ELIG_IND ADDL_UNSUBSIDIZED_ELIG_IND	NO NO
NVL(RPRLAPP_DEFERMENT_OPT,'N')	NA	NO	REPORTING VIEW	LOAN_APPLICATION	DEFERRED_PAYMENT_IND	NO
NVL(RPRLAPP_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO)	NA	NO	REPORTING VIEW	LOAN_APPLICATION	FIRST_NAME	NO
NVL(RPRLAPP_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO)	NA	NO	REPORTING VIEW	LOAN_APPLICATION	LAST_NAME	NO
NVL(RPRLAPP_MAX_LOAN_IND,'N')	NA	NO	REPORTING VIEW	LOAN_APPLICATION	MAXIMUM_LOAN_REQUESTED_IND	NO
NVL(RPRLAPP_MI, MGKFUNC.F_GET_PERSON_INFO)	NA	NO	REPORTING VIEW	LOAN_APPLICATION	MIDDLE_INITIAL	NO
NVL(RPRLAPP_SSN, MGKFUNC.F_GET_PERSON_INFO)	NA	NO	REPORTING VIEW	LOAN_APPLICATION	TAX_ID	NO
NVL(RPRLATR_EXCLUDE_LNEX_FLAG,'N')	RPALORG RPAELAP RPALAPP	NO
NVL(SARADAP_FEE_IND,'N')	NA	NO	REPORTING VIEW	ADMISSIONS_APPLICATION	APPLICATION_FEE_REQUIRED_IND	NO	NA
NVL(SFRSTCR_APPR_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	SPECIAL_APPROVAL_OVERRIDE_IND	NO
NVL(SFRSTCR_ATTS_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	STUDENT_ATTRIBUTE_OVERRIDE_IND	NO
NVL(SFRSTCR_CAMP_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	CAMPUS_RESTRICT_OVERRIDE_IND	NO
NVL(SFRSTCR_CAPC_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	CAPACITY_OVERRIDE_IND	NO
NVL(SFRSTCR_CHRT_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	STUDENT_COHORT_OVERRIDE_IND	NO
NVL(SFRSTCR_CLAS_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	CLASS_RESTRICT_OVERRIDE_IND	NO
NVL(SFRSTCR_COLL_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	COLLEGE_RESTRICT_OVERRIDE_IND	NO
NVL(SFRSTCR_CORQ_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	COREQUISITE_OVERRIDE_IND	NO
NVL(SFRSTCR_DEGC_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	DEGREE_RESTRICT_OVERRIDE_IND	NO
NVL(SFRSTCR_DEPT_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	DEPARTMENT_RESTRICT_OVER_IND	NO
NVL(SFRSTCR_DUPL_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	DUPLICATE_COURSE_OVERRIDE_IND	NO
NVL(SFRSTCR_LEVL_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	LEVEL_RESTRICT_OVERRIDE_IND	NO
NVL(SFRSTCR_LINK_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	LINK_OVERRIDE_IND	NO
NVL(SFRSTCR_MAJR_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	MAJOR_RESTRICT_OVERRIDE_IND	NO
NVL(SFRSTCR_MEXC_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	MUTUTAL_EXCLUSION_OVERRIDE_IND	NO
NVL(SFRSTCR_PREQ_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	PREREQUISITE_OVERRIDE_IND	NO
NVL(SFRSTCR_PROG_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	PROGRAM_RESTRICT_OVERRIDE_IND	NO
NVL(SFRSTCR_REPT_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	REPEAT_COURSE_OVERRIDE_IND	NO
NVL(SFRSTCR_RPTH_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	REPEAT_COURSE_CREDIT_OVER_IND	NO
NVL(SFRSTCR_TEST_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	TEST_SCORE_OVERRIDE_IND	NO
NVL(SFRSTCR_TIME_OVER,'N')	NA	NO	REPORTING VIEW	STUDENT_COURSE	TIME_CONFLICT_OVERRIDE_IND	NO
NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS( SHRTCKN_PIDM,SHRTCKN_TERM_CODE, SHRTCKN_CRN))	NA	NO					This calculates the number of extensions SHRTCKN_NUMBER_OF_EXTENSIONS for the specified UID, academic period and course if it exists, else it returns the function which returns the number of extensions MAX(SFRAREG_EXTENSION_NUMBER) a student has been granted to complete the class for the specified UID, academic period and course where the withdrawal indicator is N.
NVL(SHRTCKN_REG_COMPLETION_DATE, SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM, SHRTCKN_TERM_CODE,SHRTCKN_CRN, SHRTCKN_PTRM_CODE,'E'))	NA	NO					This function returns the registration start date SHRTCKN_REG_START_DATE if it exists, else it returns the course start date for a specified UID, academic period, course and subacademic period.
NVL(SHRTCKN_REG_START_DATE, SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM, SHRTCKN_TERM_CODE,SHRTCKN_CRN, SHRTCKN_PTRM_CODE,'S'))	SFARHST	NO					This function returns the registration completion date SHRTCKN_REG_COMPLETION_DATE if it exists, else it returns the course end date for a specified UID, academic period, course and subacademic period.
NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE)	NA	NO	REPORTING VIEW	PREVIOUS_EDUCATION_ATTENDANCE	TRANSCRIPT_REVIEWED_DATE	NO	NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE) returns transfer acceptance date and if null, then returns prior college transcript reviewed date.
NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)	NA	NO	REPORTING VIEW	ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY	GRAD_YEAR_INTENDED GRAD_YEAR_INTENDED	NO NO	Retrieve intended year of graduation from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur.
NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)	MULTIPLE	NO	REPORTING VIEW	FIELD_OF_STUDY ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY	EXPECTED_GRADUATION_DATE EXPECTED_GRADUATION_DATE EXPECTED_GRADUATION_DATE	NO NO NO	Retrieve expected graduation date from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur.
NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE)	MULTIPLE	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	LEAVE_REASON LEAVE_REASON	NO NO	Retrieve leave reason from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur.
NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE)	MULTIPLE	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	LEAVE_DATE_FROM LEAVE_DATE_FROM	NO NO	Retrieve start date of the student leave from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE)	MULTIPLE	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	LEAVE_DATE_TO LEAVE_DATE_TO	NO NO	Retrieve end date of the student leave from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE)	MULTIPLE	NO	REPORTING VIEW	ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY	STUDENT_RATE STUDENT_RATE	NO NO	Retrieve student rate from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_SITE_CODE,SGBSTDN_SITE_CODE)	NA	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	SITE SITE	NO NO	Use site code from curriculum record and if null use site from student record sgbstdn.
NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE)	MULTIPLE	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	STUDENT_POPULATION STUDENT_POPULATION	NO NO	Retrieve student population or type from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD)	MULTIPLE	NO	REPORTING VIEW	ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY	GRAD_ACADEMIC_PERIOD_INTENDED GRAD_ACADEMIC_PERIOD_INTENDED	NO NO	Retrieve intended graduation term from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SPRIDEN_LAST_NAME,'STAFF')	SIAASGN	NO	REPORTING VIEW	INSTRUCTIONAL_ASSIGNMENT GOVERNMENT_COURSE INSTRUCT_ASSIGN_SLOT INSTRUCT_ASSIGN_SLOT SCHEDULE_OFFERING INSTRUCT_ASSIGN_SLOT	INSTRUCTOR_LAST_NAME INSTRUCTOR_LAST_NAME INSTRUCTOR_LAST_NAME2 PRIMARY_INSTRUCTOR_LAST_NAME PRIMARY_INSTRUCTOR_LAST_NAME INSTRUCTOR_LAST_NAME3	NO NO NO NO NO NO	This function returns the instructor''s last name SPRIDEN_LAST_NAME if it exists, else STAFF.
NVL(SPRIDEN_MI,'STAFF')	MULTIPLE	NO	REPORTING VIEW	INSTRUCT_ASSIGN_SLOT	PRIMARY_INSTRUCTOR_MIDDLE_NAME	NO	Retrieve the instructor''s last name SPRIDEN_LAST_NAME if it exists, else set to STAFF.
NVL(SSBOVRR_COLL_CODE,SCBCRSE_COLL_CODE)	SSAOVRR	NO					This function returns the override college SSBOVRR_COLL_CODE if it exists, else it returns the course college SCBCRSE_COLL_CODE.
NVL(SSBOVRR_DEPT_CODE,SCBCRSE_DEPT_CODE)	SSAOVRR	NO					This function returns the override department SSBOVRR_DEPT_CODE if it exists, else it returns the department SCBCRSE_DEPT_CODE.
NVL(SSBOVRR_DIVS_CODE,SCBCRSE_DIVS_CODE)	SSAOVRR	NO					This function returns the override division SSBOVRR_DIVS_CODE if it exists, else it returns the course division SCBCRSE_DIVS_CODE.
NVL(SSBSECT_CONT_HR, SCBCRSE_CONT_HR_HIGH)	SCACRSE	NO	REPORTING VIEW	GOVERNMENT_COURSE	TOTAL_CONTACT_HOURS	NO	NA
NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE)	SCACRSE	NO	REPORTING VIEW	GOVERNMENT_COURSE	COURSE_TITLE_SHORT	NO	NA
NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH)	SCACRSE	NO	REPORTING VIEW	GOVERNMENT_COURSE	LAB_CONTACT_HOURS	NO	NA
NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH)	SCACRSE	NO	REPORTING VIEW	GOVERNMENT_COURSE	LECTURE_CONTACT_HOURS	NO	NA
NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH)	SCACRSE	NO	REPORTING VIEW	GOVERNMENT_COURSE	OTHER_CONTACT_HOURS	NO	NA
NVL(SUM_ADOPTED_BUDGET + SUM_BUDGET_ADJUSTMENTS, 0)	NA	NO	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER	SUM_TOTAL_BUDGET	NO	Calculates total budget as of this period to be the sum of all adopted budget and all budget adjustments up to this period.
NVL(SUM_YEAR_TO_DATE_ACTV + SUM_ENCUMBRANCES + SUM_BUDGET_RESERVATION, 0)	NA	NO	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER	SUM_COMMITTED_BALANCE	NO	Calculates summary committed balance as of this period to be the sum of all year to date activity plus all year to date encumbrances plue all year to date budget reservations.
NVL(TBRDEPO_AMOUNT-F_ACCD_AMOUNT( TBRDEPO_PIDM,TBRDEPO_TRAN_NUMBER),0)	TSADETL	NO	REPORTING VIEW	DEPOSIT	BALANCE_AMOUNT	NO	This function returns the difference between the deposit amount TBRDEPO_AMOUNT and the summarized transaction amount SUM(TBRACCD_AMOUNT) for a specified UID and transaction number.
NVL(TBRDEPO_TRANS_DATE, TBRDEPO_EFFECTIVE_DATE)-NVL( TBRDEPO_FEED_DATE,SYSDATE)	TSADETL	NO	REPORTING VIEW	DEPOSIT	OPERATING_DATE	NO	This function returns the difference between the transaction date TBRDEPO_TRANS_DATE or if null, the effective date TBRDEPO_EFFECTIVE_DATE and the feed date TBRDEPO_FEED_DATE or if null, today's date SYSDATE.
NVL(TRANSACTION_HISTORY.FUND_POOL, FUND_HIERARCHY.FUND_POOL)	NA	NO	REPORTING VIEW	TRANSACTION_HISTORY	FUND_POOL	NO	Population of fund pool is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
NVL=(ASBSORG_PARTICIPATION_GOAL,0)	NA	NO	REPORTING VIEW	SOLICITOR_ORGANIZATION	ORG_PARTICIPATION_GOAL	NO
PPREXPE_SUPER_PHONE_AREA\|\|PPREXPE_SUPER_ PHONE_NUMBER\|\|PPREXPE_SUPER_PHONE_EXT	NA	NO					NA
PPRREFE_PHONE_AREA\|\|PPRREFE_PHONE_NUMBER \|\|PPRREFE_PHONE_EXT	NA	NO					This function concatenates the phone area code, the phone number and the phone extension from the PPRREFE table.
ROW_NUMBER	TBD	NO	REPORTING VIEW	RECRUITMENT_INFORMATION ACADEMIC_OUTCOME ADMISSIONS_APPLICATION GOVERNMENT_ADMISSIONS	CURRICULUM_ORDER CURRICULUM_ORDER CURRICULUM_ORDER CURRICULUM_ORDER	NO NO NO NO
SCBCRSE_SUBJ_CODE\|\|SCBCRSE_CRSE_NUMB	SCACRSE	NO	REPORTING VIEW	REGISTRATION_PLAN_COURSE COURSE_PREREQ STUDENT_WORK_EXPERIENCE COURSE_CATALOG	COURSE_IDENTIFICATION COURSE_IDENTIFICATION_PREREQ COURSE_IDENTIFICATION COURSE_IDENTIFICATION	NO NO NO NO	This concatenates the course subject code with the course number from the SCBCRSE record.
SCBSUPP_SUBJ_CODE\|\|SCBSUPP_CRSE_NUMB	SCADETL	NO					This concatenates the course subject code with the course number from the SCBSUPP record.
SCRATTR_SUBJ_CODE\|\|SCRATTR_CRSE_NUMB	SCADETL	NO	REPORTING VIEW	COURSE_ATTRIBUTE	COURSE_IDENTIFICATION	NO	NA
SCRCORQ_SUBJ_CODE_CORQ\|\|SCRCORQ_CRSE_NUM B_CORQ	SCADETL	NO	REPORTING VIEW	COURSE_COREQ	COURSE_IDENTIFICATION_COREQ	NO	This concatenates the course subject code co-requisite with the course number co-requisite from the SCRCORQ record.
SCRCORQ_SUBJ_CODE\|\|SCRCORQ_CRSE_NUMB	SCADETL	NO	REPORTING VIEW	COURSE_COREQ	COURSE_IDENTIFICATION	NO	This concatenates the course subject code with the course number from the SCRCORQ record.
SCRGMOD_SUBJ_CODE\|\|SCRGMOD_CRSE_NUMB,	SSASECT	NO					This concatenates the course subject code with the course number from the SGRGMOD record.
SCRLEVL_SUBJ_CODE\|\|SCRLEVL_CRSE_NUMB	SCACRSE	NO	REPORTING VIEW	COURSE_LEVEL	COURSE_IDENTIFICATION	NO	This concatenates the course subject code with the course number from the SCRLEVL record.
SCRRTST_SUBJ_CODE\|\|SCRRTST_CRSE_NUMB	SCAPREQ	NO	REPORTING VIEW	COURSE_PREREQ COURSE_PREREQ_COMBINED	COURSE_IDENTIFICATION COURSE_IDENTIFICATION	NO NO	This concatenates the course subject code with the course number from the SCRRTST record.
SCRSCHD_SUBJ_CODE\|\|SCRSCHD_CRSE_NUMB	SCACRSE	NO	REPORTING VIEW	COURSE_SCHEDULE	COURSE_IDENTIFICATION	NO	This concatenates the course subject code with the course number from the SCRSCHD record.
SEASONS_COMPETITION_AVAILABLE - SEASONS_COMPETITION_USED	NA	NO	REPORTING VIEW	SPORT	SEASONS_COMPETITION_REMAINING	NO
SELECT RORMVAL_DESC FROM RORMVAL WHERE RORMVAL_COLUMN = 'RFRASPC_APPL_MEMO_IND' AND RORMVAL_CODE = RFRASPC_APPL_MEMO_IND	NA	NO	REPORTING VIEW	FINAID_FUND	MEMO_AWARD_ALLOWED_DESC	NO
SFRPLAN_SUBJ_CODE\|\|SFRPLAN_CRSE_NUMB	NA	NO	REPORTING VIEW	PROJECTED_SEATS_NEEDED	COURSE_IDENTIFICATION	NO
SFRSTCR_SUBJ_CODE\|\|SFRSTCR_CRSE_NUMB	SFAREGS	NO	REPORTING VIEW	FACULTY_FEEDBACK FACULTY_FEEDBACK_DETAIL STUDENT_COURSE	COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION	NO NO NO	This concatenates the course subject code with the course number from the SFRSTCR record.
SGRCOOP_PHONE_AREA\|\|SGRCOOP_PHONE_NUMBER \|\|SGRCOOP_PHONE_EXT	NA	NO	REPORTING VIEW	STUDENT_WORK_EXPERIENCE	PHONE_NUMBER_COMBINED	NO	NA
SHRTATT_TRIT_SEQ_NO\|\|TO_CHAR( SHRTATT_TRAM_SEQ_NO,'FM09')\|\|TO_CHAR( NVL(SHRTATT_TRCR_SEQ_NO,0),'FM009') \|\|TO_CHAR(SHRTATT_TRCE_SEQ_NO,'FM009')	MULTIPLE	NO	REPORTING VIEW	STUDENT_COURSE_ATTRIBUTE STUDENT_COURSE_ATT_SLOT	COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER	NO NO
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_ATTEMPTED_IND,'Y',1,0)	SHATCKS	NO	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE_GRADE_CHANGE	CREDITS_ATTEMPTED CREDITS_ATTEMPTED	NO NO	This calculates the credit hours attempted by the student.
SHRTCKG_CREDIT_HOURSDECODE( SHRGRDE_COMPLETED_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)	SHATCKS	NO	REPORTING VIEW	STUDENT_COURSE_GRADE_CHANGE STUDENT_COURSE	CREDITS_EARNED CREDITS_EARNED	NO NO	This calculates the credit hours earned by the student.
SHRTCKG_CREDIT_HOURSDECODE( SHRGRDE_GPA_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1)	SHATCKS	NO	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE_GRADE_CHANGE	CREDITS_FOR_GPA CREDITS_FOR_GPA	NO NO	This calculates the credits that are used to calculate the GPA for the student.
SHRTCKG_CREDIT_HOURSDECODE( SHRGRDE_PASSED_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)	SHATCKS	NO	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE_GRADE_CHANGE	CREDITS_PASSED CREDITS_PASSED	NO NO	This calculates the quality points earned by the student.
SHRTCKG_CREDIT_HOURSSHRGRDE_QUALITY_POI NTSDECODE(SHRGRDE_GPA_IND,'Y',1,0) *DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0, 1)	SHAINST	NO	REPORTING VIEW	STUDENT_COURSE_GRADE_CHANGE STUDENT_COURSE	QUALITY_POINTS QUALITY_POINTS	NO NO	This calculates the credit hours passed by the student.
SHRTCKN_SUBJ_CODE\|\|SHRTCKN_CRSE_NUMB	SHAINST	NO	REPORTING VIEW	GOVERNMENT_COURSE STUDENT_COURSE_ATTRIBUTE STUDENT_COURSE STUDENT_COURSE_GRADE_CHANGE	COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION	NO NO NO NO	This concatenates the course subject code with the course number from the SHRTCKN record.
SHRTRCE_CREDIT_HOURSDECODE( SHRGRDE_ATTEMPTED_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1)	TBD	NO	REPORTING VIEW	STUDENT_TRANSFERRED_COURSE	CREDITS_ATTEMPTED	NO
SHRTRCE_CREDIT_HOURSDECODE( SHRGRDE_EARNED_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1)	TBD	NO	REPORTING VIEW	STUDENT_TRANSFERRED_COURSE	CREDITS_EARNED	NO
SHRTRCE_CREDIT_HOURSDECODE( SHRGRDE_GPA_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1)	TBD	NO	REPORTING VIEW	STUDENT_TRANSFERRED_COURSE	CREDITS_FOR_GPA	NO
SHRTRCE_CREDIT_HOURSDECODE( SHRGRDE_PASSED_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1)	TBD	NO	REPORTING VIEW	STUDENT_TRANSFERRED_COURSE	CREDITS_PASSED	NO
SHRTRCE_CREDIT_HOURSSHRGRDE_QUALITY_POI NTSDECODE(SHRGRDE_GPA_IND,'Y',1,0) *DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0, 1)	TBD	NO	REPORTING VIEW	STUDENT_TRANSFERRED_COURSE	QUALITY_POINTS	NO
SHRTRCE_SUBJ_CODE\|\|SHRTRCE_CRSE_NUMB	SHATRNS	NO	REPORTING VIEW	STUDENT_COURSE	COURSE_IDENTIFICATION	NO	This concatenates the course subject code with the course number from the SHRTRCE record.
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')	TBD	NO	REPORTING VIEW REPORTING VIEW	STUDENT_COURSE STUDENT_TRANSFERRED_COURSE STUDENT_COURSE STUDENT_TRANSFERRED_COURSE	COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER	NO NO NO NO
SHRTRCR_TRANS_COURSE_NAME\|\|SHRTRCR_TRANS _COURSE_NUMBERS	NA	NO	REPORTING VIEW	STUDENT_TRANSFERRED_COURSE STUDENT_TRANSFERRED_COURSE	COURSE_IDENTIFICATION TRANSFER_COURSE_IDENTIFICATION	NO NO
SLBBLDG_PHONE_AREA\|\|SLBBLDG_PHONE_NUMBER \|\|SLBBLDG_PHONE_EXTENSION	SLABLDG	NO	REPORTING VIEW	ROOM_ASSIGNMENT	BUILDING_PHONE_NUM_COMBINED	NO	This concatenates the area code, the phone number and the phone extension from the SLBBLDG table.
SLBEVNT_PHONE_AREA\|\|SLBEVNT_PHONE\|\|SLBEV NT_PHONE_EXT	NA	NO	REPORTING VIEW	EVENT	PHONE_NUMBER_COMBINED	NO	NA
SLBRDEF_PHONE_AREA\|\|SLBRDEF_PHONE_NUMBER \|\|SLBRDEF_PHONE_EXTENSION	SLARASG	NO	REPORTING VIEW	ROOM_ASSIGNMENT	ROOM_PHONE_NUM_COMBINED	NO	This concatenates the area code, the phone number and the phone extension from the SLBRDEF table.
SLRPASG_PHONE_AREA\|\|SLRPASG_PHONE_NUMBER \|\|SLRPASG_PHONE_EXT	NA	NO	REPORTING VIEW	PHONE_ASSIGNMENT	PHONE_NUMBER_COMBINED	NO	This concatenates the area code, the phone number and the phone extension from the SLRPASG table.
SORBCNT_PHONE_AREA\|\|SORBCNT_PHONE_NUMBER \|\|SORBCNT_PHONE_EXT	SOASBGI	NO	REPORTING VIEW	INSTITUTION	CONTACT_PHONE_NUMBER_COMBINED	NO	NA
SPRADDR_CNTY_CODE	FAAINVE	NO	REPORTING VIEW	INVOICE	REMIT_TO_COUNTY	NO	NA
SPRIDEN_FIRST_NAME \|\| SUBSTR(SPRIDEN_MI, 1,1) \|\| SPRIDEN_LAST_NAME	NA	NO	REPORTING VIEW	PLEDGE_MATCHING_TRANSACTION	MATCH_EMPLOYER_NAME	NO
SPRIDEN_FIRST_NAME\|\|SPRIDEN_MI\|\|SPRIDEN_ LAST_NAME	NA	NO					NA
SPRTELE_INTL_ACCESS \|\| SPRTELE_PHONE_AREA \|\| SPRTELE_PHONE_NUMBER \|\| SPRTELE_PHONE_EXT	NA	NO	REPORTING VIEW	VENDOR VENDOR	ORDER_FROM_PHONE_COMBINED REMIT_TO_PHONE_NUMBER_COMBINED	NO NO	This calculation formulates the combined phone number by concatenating SPRTELE_INTL_ACCESS, SPRTELE_PHONE_AREA, SPRTELE_PHONE_NUMBER, and SPRTELE_PHONE_EXT.
SPRTELE_INTL_ACCESS\|\|SPRTELE_PHONE_AREA\| \|SPRTELE_PHONE_NUMBER\|\|SPRTELE_PHONE_EXT	NA	NO	REPORTING VIEW	ORGANIZATION_ENTITY ORGANIZATION_CONTACT REFERENCE GRANT_PERSONNEL ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT PERSON ORGANIZATION_CONTACT CONSTITUENT_ENTITY	PHONE_NUMBER_COMBINED FAX_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED	NO NO NO NO NO NO NO NO NO NO	This calculation formulates the combined phone number by concatenating SPRTELE_INTL_ACCESS, SPRTELE_PHONE_AREA, SPRTELE_PHONE_NUMBER, and SPRTELE_PHONE_EXT.
SSBSECT_SUBJ_CODE\|\|SSBSECT_CRSE_NUMB	SFAREGS	NO	REPORTING VIEW	MEETING_TIME COURSE_OFFERING_FEES BLOCK_REGISTRATION_COURSE STUDENT_COURSE_REG_AUDIT OFFERING_GRADE_TYPE GOVERNMENT_COURSE OFFERING_COREQ OFFERING_PREREQ SCHEDULE_OFFERING	COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION	NO NO NO NO NO NO NO NO NO	This concatenates the course subject code with the course number from the SSBSECT record.
SSRRTST_SUBJ_CODE_PREQ\|\|SSRRTST_CRSE_NUM B_PREQ	SSAPREQ	NO	REPORTING VIEW	OFFERING_PREREQ	PREREQ_COURSE_IDENTIFICATION	NO	This concatenates the prerequisite course subject code with the prerequisite course number from the SSRRTST record.
SUBSTR(SPRIDEN_MI,1,1)	NA	NO	REPORTING VIEW	PERSON PERSON_DETAIL	MIDDLE_INITIAL MIDDLE_INITIAL	NO NO	This function returns the middle initial.
SUM(AGRPDES_AMT_PAID)	TBD	NO	REPORTING VIEW	PLEDGE_TRANSACTION	PLEDGE_TRANS_AMOUNT_PAID	NO
SUM(AMOUNT)	NA	NO	REPORTING VIEW	RECEIVABLE_SUMMARY	AMOUNT	NO	This summarizes the amount SUM(TBRACCD_AMOUNT) for a given term, category code and detail code.
SUM(FPRRCDT_AMT_RCVD)	FPARCVD	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY	RECEIVED_AMOUNT_TO_DATE	NO	NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY)	FPARCVD FPARTRN	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY	QUANTITY_ACCEPTED_TO_DATE	NO	NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD)	FPARCVD	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY RECEIVED_ITEM	QTY_RECEIVED_REJECTED_TO_DATE QUANTITY_RECEIVED_REJECTED	NO NO	NA
SUM(FPRRCDT_QTY_RCVD)	FPARCVD	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY PURCHASE_ORDER_ITEM_SUMMARY	QUANTITY_REJECTED_TO_DATE QUANTITY_RECEIVED_TO_DATE	NO NO	NA
SUM(FPRRTRN_QTY)	FPARCVD	NO	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY	QUANTITY_RETURNED_TO_DATE	NO	Returns the sum of all quantities returned for a purchase order item.
SUM(PERJTOT_GRS)	NA	NO					This function returns the sum of the hours SUM(PERJTOT_GRS).
SUM(PERJTOT_HRS)	NA	NO					This function returns the sum of the hours SUM(PERJTOT_HRS).
SUM(RPRAWRD_ACCEPT_AMT)	NA	NO	REPORTING VIEW	AWARD_BY_FUND	ACCEPT_AMOUNT	NO	SUM(RPRAWRD_ACCEPT_AMT)
SUM(RPRAWRD_AUTHORIZE_AMT)	NA	NO	REPORTING VIEW	AWARD_BY_FUND	AUTHORIZED_AMOUNT	NO	NA
SUM(RPRAWRD_CANCEL_AMT)	NA	NO	REPORTING VIEW	AWARD_BY_FUND	CANCEL_AMOUNT	NO	NA
SUM(RPRAWRD_DECLINE_AMT)	NA	NO	REPORTING VIEW	AWARD_BY_FUND	DECLINE_AMOUNT	NO	NA
SUM(RPRAWRD_MEMO_AMT)	NA	NO	REPORTING VIEW	AWARD_BY_FUND	MEMO_AMOUNT	NO	NA
SUM(RPRAWRD_OFFER_AMT)	NA	NO	REPORTING VIEW	AWARD_BY_FUND	OFFER_AMOUNT	NO	NA
SUM(RPRAWRD_PAID_AMT)	NA	NO	REPORTING VIEW	AWARD_BY_FUND	PAID_AMOUNT	NO	NA
SYSDATE BETWEEN SPRHOLD_FROM_DATE AND SPRHOLD_TO_DATE	NA	NO	REPORTING VIEW	HOLD	ACTIVE_HOLD_IND	NO
TBD	NA	NO
TBLD	NA	NO
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE1')	NA	NO	REPORTING VIEW	GOVERNMENT_STUDENT	CENSUS_FTE_1	NO	Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE2')	NA	NO	REPORTING VIEW	GOVERNMENT_STUDENT	CENSUS_FTE_2	NO	Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE3')	NA	NO	REPORTING VIEW	GOVERNMENT_STUDENT	CENSUS_FTE_3	NO	Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE4')	NA	NO	REPORTING VIEW	GOVERNMENT_STUDENT	CENSUS_FTE_4	NO	Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TO_CHAR (TO_DATE (FAB1099_RPT_YR, 'RR'), 'YYYY')	NA	NO	REPORTING VIEW	VENDOR_TAXABLE_REPORTING	TAX_YEAR	NO
TO_CHAR (TO_DATE (FRRGRNH_FSYR_CODE, 'RR'), 'YYYY'	NA	NO	REPORTING VIEW	GRANT_DEFERRED_COST	FISCAL_YEAR	NO
TO_CHAR(TBRACCD_CSHR_END_DATE, 'HH24:MM:SS')	NA	NO	REPORTING VIEW	APPLICATION_OF_PAYMENT RECEIVABLE_ACCOUNT_DETAIL	CASHIER_END_TIME CASHIER_END_TIME	NO NO	This calculation retrieves the 24 hour time from TBRACCD_CSHR_END_DATE.
TO_CHAR(TBRDEPO_CSHR_END_DATE, 'HH24:MM:SS')	NA	NO	REPORTING VIEW	DEPOSIT	CASHIER_END_TIME	NO	This calculation retrieves the 24 hour time from TBRDEPO_CSHR_END_DATE.
TO_CHAR(TBRMISD_CSHR_END_DATE, 'HH24:MM:SS')	NA	NO	REPORTING VIEW	MISCELLANEOUS_TRANSACTION	CASHIER_END_TIME	NO	This calculation retrieves the 24 hour time from TBRMISD_CSHR_END_DATE.
TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'), 'YYYY')	NA	NO	REPORTING VIEW	TRANSACTION_HISTORY	FISCAL_YEAR	NO	This calculation transforms a two digit fiscal year into a 4 digit fiscal year for the transaction detail record.
TO_CHAR(TO_DATE(FGBTRNH_FSYR_CODE,'RR'), 'YYYY')	NA	NO	REPORTING VIEW	TRANSACTION_HISTORY	FISCAL_YEAR_HEADER	NO	This calculation transforms a two digit fiscal year into a 4 digit fiscal year for the transaction history record.
TO_CHAR(TRRACCD_CSHR_END_DATE, 'HH24:MM:SS')	NA	NO	REPORTING VIEW	GRANT_RECEIVABLE_ACCT_DETAIL	CASHIER_END_TIME	NO	This calculation retrieves the 24 hour time from TRRACCD_CSHR_END_DATE.
TTBTAXN_AMOUNT_3 * -1	NA	NO	REPORTING VIEW	STUDENT_TAX_NOTIFICATION	PRIOR_YEAR_CHARGES_ADJUSTED	NO
TTBTAXN_AMOUNT_5 * -1	NA	NO	REPORTING VIEW	STUDENT_TAX_NOTIFICATION	PRIOR_YR_SCHOLARSHIP_GRANT_ADJ	NO
TTBTAXN_AMOUNT_6 * -1	NA	NO	REPORTING VIEW	STUDENT_TAX_NOTIFICATION	PRIOR_YEAR_PAYMENT_ADJ	NO
CASE WHEN RLRDDAS_DISB_SEQ_NO	NA	NO	REPORTING VIEW	LOAN_DISBURSEMENT_DETAIL	RECORD_SOURCE	NO
SUBSTR(GORSDAV_PK_PARENTTAB,)	TBD	NO	REPORTING VIEW	SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA_SLOT SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA_SLOT SUPPLEMENTAL_DATA_SLOT SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA_SLOT SUPPLEMENTAL_DATA_SLOT SUPPLEMENTAL_DATA_SLOT	PARENT_TABLE_PK_COL5 PARENT_TABLE_PK_COL5 PARENT_TABLE_PK_COL4 PARENT_TABLE_PK_COL2 PARENT_TABLE_PK_COL1 PARENT_TABLE_PK_COL6 PARENT_TABLE_PK_COL3 PARENT_TABLE_PK_COL6 PARENT_TABLE_PK_COL1 PARENT_TABLE_PK_COL3 PARENT_TABLE_PK_COL2 PARENT_TABLE_PK_COL4	NO NO NO NO NO NO NO NO NO NO NO NO	This calculation retrieves the portion of the composite primary key-GORSDAV_PK_PARENTTAB.

Ver: 9.2