Composite View Source: CALCULATION

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: CALCULATION Travel And Expense

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
(APPLIED_AMOUNT * (CLGR.PERCENT/100) * ( PLGR.PERCENT/100))	NA				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
(FGBOPAL_XX_ADOPT_BUD+ FGBOPAL_XX_BUD_ADJT)-( FGBOPAL_XX_YTD_ACTV+FGBOPAL_XX_ENCUMB+ FGBOPAL_XX_BUD_RSRV)	FGIBDST	COMPOSITE VIEW	AF_OPERATING_LEDGER	SUM_REMAINING_BALANCE	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	COMPOSITE VIEW	AF_GRANT_LEDGER	SUM_REMAINING_BALANCE	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	COMPOSITE VIEW	AF_GRANT_LEDGER	CURR_REMAINING_BALANCE	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
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100	NA
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFRDESG_GOAL * 100	NA
(MAKFUNC.F_ORG_TOTAL_GIFTS + MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100	NA
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100	NA
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFRCSOL_GOAL * 100	NA
(MAKFUNC.F_SOL_FR_TOTAL_PLEDGES + MAKFUNC.F_SOL_FR_TOTAL_GIFTS + MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100	NA
(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	COMPOSITE VIEW	AF_INVOICE_ITEM	APPROVED_ITEM_AMOUNT	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	COMPOSITE VIEW	AF_BUDGET_DETAIL	BUDGET_AMOUNT	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
(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	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	APPROVED_ITEM_AMOUNT	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
AARMEMB_AMT_QUALIFY - AOKODSF.F_GET_MEMBE_AMT_PAID	NA
ACCT.PAY_CURRENCY_AMOUNT - ACCT.PAY_CURRENCY_AMOUNT_NO_TAX	NA
AFRCSOL_GOAL / AFBCAMP_GOAL * 100	NA
AFRDESG_GOAL / AFBCAMP_GOAL * 100	NA
AGBMGID_AMT - AGBMGID_AMT_PAID	NA	COMPOSITE VIEW	AA_GIFT_MATCHING	MATCH_GIFT_BALANCE	NA
AGRGDES_AMT-F_GIFT_HARD_CREDIT	NA	COMPOSITE VIEW	AA_GIFT	GIFT_CREDIT_AMOUNT	NA
AGRPDES_AMT-AGRPDES_AMT_PAID	NA	COMPOSITE VIEW	AA_PLEDGE	PLEDGE_BALANCE	NA
AGRPDES_AMT-F_PLEDGE_HARD_CREDIT	NA	COMPOSITE VIEW	AA_PLEDGE	PLEDGE_CREDIT	NA
AGRPDES_AMT_PAID - SUM(AGRPDES_AMT_PAID)	NA	COMPOSITE VIEW	AA_PLEDGE	PLEDGE_TRANS_BALANCE
AORCONT_FAX_AREA\|\|AORCONT_FAX_NUMBER\|\|AO RCONT_FAX_EXT	NA	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	FAX_NUMBER_COMBINED
AORCONT_PHONE_AREA\|\|AORCONT_PHONE_NUMBER \|\|AORCONT_PHONE_EXT	NA	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	PHONE_NUMBER_COMBINED
ASBSORG_UPD_WEB_IND	NA
ASRSORG_DOLLAR_GOAL / ASBSORG_DOLLAR_GOAL * 100	NA
ASRSORG_UPD_WEB_IND	NA
CASE NBBPOSN_PREMIUM_ROLL_IND	TBD
CASE NBBPOSN_ROLL_IND	NA
CASE SFRFFST_STATUS_CDE WHEN	TBD
CASE STVFFVA_TYPE WHEN	NA	COMPOSITE VIEW	AS_FACULTY_FEEDBACK_DETAIL	FEEDBACK_TYPE_DESC
CASE STVFFVA_TYPE WHEN 'ISSUE' THEN 'ISSUE' WHEN 'RECOMMEND' THEN 'RECOMMENDATION' END	TBD
CASE STATEMENT	NA				(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
CASE WHEN (RCRAPP1_SEQ_NO	NA
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
CASE WHEN AORCONT_CONT_ORG_IND	NA	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_ADDRESS_SOURCE_DESC
CASE WHEN AORCONT_EMAL_SRC_IND	NA	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_EMAIL_SOURCE_DESC
CASE WHEN AORCONT_FAX_SRC_IND	NA	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_FAX_SOURCE_DESC
CASE WHEN AORCONT_PRIMARY_IND	NA	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	PRIMARY_CONTACT_IND
CASE WHEN AORCONT_TELE_SRC_IND	NA	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_PHONE_SOURCE_DESC
CASE WHEN APPROVAL_METHOD	NA
CASE WHEN APPROVAL_STATUS	NA
CASE WHEN CONTACT_DECEASED_IND	NA
CASE WHEN DAP_AUDIT_TYPE	NA
CASE WHEN DAP_REASON_INSUF	NA
CASE WHEN DAP_RESULT_TYPE	NA
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED'	NA
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' AND AUDIT_TYPE = 'PL'	NA
CASE WHEN DAP_RESULT_TYPE = 'CLASSNEEDED'	NA
CASE WHEN DAP_RESULT_TYPE = 'FALLCLASSAPPLIED'	NA
CASE WHEN DAP_RESULT_TYPE = 'FALLNONCRAPPLIED'	NA
CASE WHEN DAP_RESULT_TYPE = 'INSUFFCLASSAPPLIED'	NA
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED'	NA
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' AND AUDIT_TYPE = 'PL' AND SUBSTR(VALUE3,1,2) = 'PN'	NA
CASE WHEN DAP_RESULT_TYPE = 'NONCRNEEDED'	NA
CASE WHEN DAP_RESULT_TYPE = 'OTLCLASSAPPLIED'	NA
CASE WHEN DAP_TRANSFER = 'C' AND DAP_INPROGRESS = 'N'	NA
CASE WHEN DAP_TRANSFER = 'T'	NA
CASE WHEN ENCUMBRANCE_NUMBER	NA	COMPOSITE VIEW	AF_ENCUMBRANCE	HR_ENCUMBRANCE_IND
CASE WHEN FABBKTP_RECON_IND	NA	COMPOSITE VIEW	AF_CHECKS	BANK_RECONCILIATION_IND_DESC
CASE WHEN FABCHKS_CHECK_TYPE_IND	NA	COMPOSITE VIEW	AF_CHECKS	CHECK_TYPE_DESC
CASE WHEN FABCHKS_PAY_TYPE	NA				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	COMPOSITE VIEW	AF_CHECKS	RECONCILIATION_IND_DESC
CASE WHEN FABRUIV_SUB_IND	NA	COMPOSITE VIEW	AF_INVOICE	REPEATING_FREQUENCY_DESC
CASE WHEN FGBENCD_CMT_TYPE	NA
CASE WHEN FGBENCD_FIELD_CODE	NA
CASE WHEN FTVVEND_CHECK_PIDM IS NULL	NA
CASE WHEN GROUP_TYPE	NA				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
CASE WHEN NORTRAN_AUBK_CODE = 'SPRIDEN' THEN 'IDEN'	NA	COMPOSITE VIEW	AN_PERSONNEL_ACTION_GENERAL	PAF_TRANSACTION_TYPE
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE =	NA				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				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
CASE WHEN OFFICIAL_TRACKING_STATUS	NA
CASE WHEN PLAN_SOURCE	NA
CASE WHEN R.DAP_RESULT_TYPE = 'CLASSNEEDED' THEN 'N' WHEN R.DAP_RESULT_TYPE <> 'CLASSNEEDED' AND R.DAP_AUDIT_TYPE = 'PL'	NA
CASE WHEN RBRAPBC_SYS_IND = 'S'	TBD
CASE WHEN RFRASPC_DIRECT_LOAN_IND	NA
CASE WHEN RFRASPC_EL_LOAN_IND	NA
CASE WHEN RFRASPC_MANUAL_LOAN_IND	NA
CASE WHEN RORSTAT_ADDL_PELL_ELIB_IND	NA
CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND	NA
CASE WHEN RORSTAT_DEP_NO_PAR_DATA	NA
CASE WHEN RRRAREQ_SYS_IND	NA
CASE WHEN SFRBRDB_COURSE_RESTRICTION	NA				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				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				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
CASE WHEN SHRTCKG_GRDE_CODE_FINAL	NA				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				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				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				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
CASE WHEN SSBSECT_CENSUS_ENROLL	NA
CASE WHEN STAFF_ASSIGNMENT_STATUS_IND	NA
CASE WHEN STATUS_CHANGE_IND	NA
CASE WHEN STRATEGY_PLAN_STATUS_IND	NA
CASE WHEN STVESTS_EFF_HEADCOUNT	NA	COMPOSITE VIEW	AS_ENROLLMENT_HISTORY AS_ENROLLMENT	NOT_ENROLLED_IND NOT_ENROLLED_IND	Determines if the student is not enrolled.
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID = 0 THEN 'Y' ELSE 'N'	NA	COMPOSITE VIEW	AA_PLEDGE	PLEDGE_TRANS_FULLY_PAID_IND
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID > 0 AND SUM( AGRPDES_AMT_PAID) < AGRPDES_AMT_PAID THEN 'Y' ELSE 'N'	NA	COMPOSITE VIEW	AA_PLEDGE	PLEDGE_TRANS_PARTIAL_PAID_IND
CASE WHEN SYSDATE BETWEEN EXCLUSION_DATE	NA
CASE WHEN TAX_DOCUMENT_BOX	NA				Determine TAX_DOCUMENT_BOX hard coded descriptions based upon TBRACCD_TAX_REPT_BOX value.
CASE WHEN TAX_NOTIFICATION_STATUS	NA				Determines hard coded descriptions for TAX_NOTIFICATION_STATUS based upon the values in TTBTAXN_STUD_NOTIF_STATUS.
CASE WHEN TBBDETC_REFUND_IND	NA	COMPOSITE VIEW	AT_ACCOUNT_DETAIL	REFUND_DESC	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				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				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
CASE WHEN TRACKING_STATUS	NA
CASE WHEN UNOFFICIAL_TRACKING_STATUS	NA
CASE(AMRCONT_GEN_CONTACT_IND)	NA	COMPOSITE VIEW	AA_CONSTITUENT_CONTACT	PROSPECT_CONTACT_IND
COUNT (*) OVER (PARTITION BY B.PERSON_UID)	NA				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
COUNT (DISTINCT COURSE_REFERENCE_NUMBER)	TBD
COUNT (DISTINCT PERSON_UID)	TBD
COUNT(AMRATTN_PIDM)	NA
COURSE_DISCIPLINE\|\|COURSE_NUMBER	NA
DAP_VALUE1 \|\| DAP_VALUE2	NA
DAP_VALUE2 \|\| DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID'	NA
DECODE ( DECODE ( SIGN ( NVL ( TBRACCD_TRANS_DATE, TBRACCD_EFFECTIVE_DATE)	TSADETL
DECODE (MRVAND0_EFC_IND, 'F', '', RNKNEED.F_CALC_BUDGET_AMT (MRVAND0_PIDM, MRVAND0_AIDY_CODE, 'I')), '999999999D99')	NA
DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND)	NA				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 (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND (ENTITY_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION')	NA
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND ( MATCH_EMPLOYER_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION')	NA
DECODE(AGBMGID_DELETE_IND,'I','N','Y'),	NA	COMPOSITE VIEW	AA_GIFT_MATCHING	ACTIVE_IND	NA
DECODE(AGBMGID_DELETE_IND,NULL, DECODE( AGBMGID_STATUS,NULL,'W','P','P','I','I') ,'N'),	NA	COMPOSITE VIEW	AA_GIFT_MATCHING	MATCH_GIFT_STATUS	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	COMPOSITE VIEW	AA_GIFT_MATCHING	MATCH_GIFT_STATUS_DESC	NA
DECODE(AGRGAUX_ACC_REJ_IND,'A','ACCEPT', 'R','REJECT','NOT APPLICABLE'),	NA	COMPOSITE VIEW	AA_GIFT_AUXILIARY	BENEFIT_ACCEPT_REJECT_DESC	NA
DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)	NA	COMPOSITE VIEW	AA_PLEDGE_AUXILIARY AA_PLEDGE_AUXILIARY	PLEDGE_VOID_IND PLEDGE_ADJUSTMENT_IND
DECODE(AGRPCON_MET_IND)	NA	COMPOSITE VIEW	AA_PLEDGE_CONDITIONAL	CONDITION_MET_DESC
DECODE(AGRPDES_AMT-AGRPDES_AMT_PAID)	NA				NA
DECODE(AGRPDES_AMT_PAID)	NA				NA
DECODE(AMRPLAN_PROJ_CODE, AMRCONT_PROJ_CODE)	NA
DECODE(AMRPRRT_RATING_PIDM,NULL, AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM)	NA	COMPOSITE VIEW	AA_ADVANCEMENT_RATING	RATER_UID	NA
DECODE(APRADEG_HOND_CODE_1)	NA
DECODE(APRADEG_HONR_CODE)	NA				Determines if this person should be counted in the institutional honors count.
DECODE(APRADEG_SBGI_CODE, AUBINST_SBGI_CODE,'Y','N')	NA	COMPOSITE VIEW	AA_DEGREE	INSTITUTION_IND	NA
DECODE(APRCSPS_MARS_IND,'A','ACTIVE', 'I','INACTIVE')	APACONS	COMPOSITE VIEW	AA_RELATIONSHIP	SPOUSE_STATUS_DESC	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	COMPOSITE VIEW	AA_GIFT_SOCIETY	LIFETIME_GIFT_SOCIETY_IND	NA
DECODE(APRIGRP_DISPLAY_WEB_IND)	NA	COMPOSITE VIEW	AA_INTEREST	DISPLAY_WEB_IND
DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY', 'S','SECONDARY')	NA	COMPOSITE VIEW	AA_RELATIONSHIP	COMBINED_MAILING_PRIORITY_DESC	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	COMPOSITE VIEW	AA_DESIGNATION_ADJUSTMENT	ADJUSTMENT_DEBIT_CREDIT_DESC
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	COMPOSITE VIEW	AA_DESIGNATION	MATCHING_GIFT_VSE_PURPOSE_DESC
DECODE(ATVDONR_CFAE_2)	NA	COMPOSITE VIEW	AA_DONOR_CATEGORY	VSE_DESC_2	NA
DECODE(ATVGIFT_CFAE_GIFT_CATG)	NA	COMPOSITE VIEW	AA_GIFT	GIFT_VSE_DESC	NA
DECODE(BENEFICIARY_NAME)	NA				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
DECODE(ENROLLED_IND, 'N', 'Y', 'N')	NA
DECODE(EXPENSE_TYPE_CODE,'9900ADVC')	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL)	FAAINVE	COMPOSITE VIEW	AF_INVOICE	REMIT_TO_STREET_LINE1	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL)	FAAINVE	COMPOSITE VIEW	AF_INVOICE	REMIT_TO_STREET_LINE2	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL)	FAAINVE	COMPOSITE VIEW	AF_INVOICE	REMIT_TO_STREET_LINE3	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_CITY, NULL)	FAAINVE	COMPOSITE VIEW	AF_INVOICE	REMIT_TO_CITY	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_NATN, NULL)	FAAINVE	COMPOSITE VIEW	AF_INVOICE	REMIT_TO_NATION	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_STATE, NULL)	FAAINVE	COMPOSITE VIEW	AF_INVOICE	REMIT_TO_STATE_PROVINCE	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ZIP, NULL)	FAAINVE	COMPOSITE VIEW	AF_INVOICE	REMIT_TO_POSTAL_CODE	NA
DECODE(FABINVH_ATYP_CODE, NULL, TO_NUMBER(NULL), FABINVH_ATYP_SEQ_NUM)	FAAINVE	COMPOSITE VIEW	AF_INVOICE	REMIT_TO_ADDRESS_TYPE_NUMBER	NA
DECODE(FABINVH_ATYP_CODE,NULL,'Y','N')	FAAINVE	COMPOSITE VIEW	AF_INVOICE	ONE_TIME_VENDOR_ADDRESS_IND	NA
DECODE(FABINVH_GROUPING_IND)	NA	COMPOSITE VIEW	AF_INVOICE AF_INVOICE	GROUPING GROUPING_DESC
DECODE(FABINVH_INVOICE_TYPE_IND)	FAAINVE	COMPOSITE VIEW	AF_INVOICE	INVOICE_TYPE_DESC	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	COMPOSITE VIEW	AF_INVOICE	RECEIVING_REQUIRED_DESC
DECODE(FABINVH_VEND_CHECK_PIDM,NULL,'N', 'Y')	FAAINVE	COMPOSITE VIEW	AF_INVOICE	THIRD_PARTY_ADDRESS_IND	NA
DECODE(FEEDBACK_COMMENT,NULL,'NO','YES')	NA
DECODE(FEEDBACK_ESTIMATED_GRADE,NULL, 'NO','YES')	NA
DECODE(FEEDBACK_STATUS,'M','YES','NO')	NA
DECODE(FFBMAST_SUBORDINATE_TYPE)	FFAMAST	COMPOSITE VIEW	AF_FIXED_ASSET_ITEM	SUBORDINATE_TYPE_DESC	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	COMPOSITE VIEW	AF_FIXED_ASSET_DEPRECIATION	DEPRECIATION_POSTING_STATUS	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	COMPOSITE VIEW	AF_ENCUMBRANCE_ACCOUNTING	ENCUMBRANCE_STATUS	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	COMPOSITE VIEW	AF_ENCUMBRANCE_ACCOUNTING	POSTABLE_IND	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	COMPOSITE VIEW	AF_ENCUMBRANCE	ENCUMBRANCE_SOURCE	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	COMPOSITE VIEW	AF_ENCUMBRANCE	COMPLETE_IND	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	COMPOSITE VIEW	AF_ENCUMBRANCE	ENCUMBRANCE_STATUS	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	COMPOSITE VIEW	AF_ENDOWMENT	RESTRICTION_TYPE_DESC	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				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	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY	FUND_BALANCE_RESTRICTION_DESC FUND_BALANCE_RESTRICTION_DESC
DECODE(FORCIRR_DATA_ORIGIN)	NA
DECODE(FPBPOHD_MATCH_REQUIRED)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER	RECEIVING_REQUIRED_DESC
DECODE(FPBPOHD_PO_TYPE_IND)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER	PURCHASE_ORDER_TYPE_DESC	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	COMPOSITE VIEW	AF_PURCHASE_ORDER	REQUISITION_OR_BID_SOURCE_DESC
DECODE(FPBPOHD_TEXT_IND)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER	REQUISITION_TEXT_DESC
DECODE(FPBRCDT_ADJUST_RECEIVE_IND)	FPARCVD	COMPOSITE VIEW	AF_RECEIVED_ITEM	ADJUSTED_IND	This calculation returns a Y or N if the item was adjusted or not adjusted.
DECODE(FPRPODA_NSF_SUSP_IND)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	NSF_SUSPENSE_DESC
DECODE(FPRPODT_TEXT_USAGE)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	TEXT_USAGE_DESC
DECODE(FPRRCDT_PARTIAL_FINAL_IND)	FPARCVD	COMPOSITE VIEW	AF_RECEIVED_ITEM	FINAL_RECEIPT_IND	Calculation determines if value is set to (P)artial or (F)inal.
DECODE(FRBEVNG_PMT_METHOD_TYPE_IND)	NA	COMPOSITE VIEW	AF_GRANT_EVENT	PAYMENT_METHOD_DESC
DECODE(FRRBDET_ACCT_CLASS_CODE)	FRABDCN	COMPOSITE VIEW	AF_GRANT_BILLING_DETAIL	ACCOUNT_CLASS	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	COMPOSITE VIEW	AF_GRANT_BILLING_DETAIL	BILL_STATUS_DESC	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	COMPOSITE VIEW	AF_GRANT_EVENT AF_GRANT_PERSONNEL	BILL_FORMAT_TYPE_DESC BILL_FORMAT_TYPE_DESC
DECODE(FTVATTT_STATUS_IND)	FTMATTT	COMPOSITE VIEW	AF_PROGRAM_ATTRIBUTES_ODS AF_ACCOUNT_ATTRIBUTES_ODS AF_ACCOUNT_TYPE_ATTRIBUTES_ODS AF_ACTIVITY_ATTRIBUTES_ODS AF_CHART_ATTRIBUTES_ODS AF_FUND_ATTRIBUTES_ODS AF_FUND_TYPE_ATTRIBUTES_ODS AF_ATTRIBUTE_SETS_ODS AF_ORGANIZATION_ATTRIBUTES_ODS AF_LOCATION_ATTRIBUTES_ODS	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	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	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL	FUND_BALANCE_DESC FUND_BALANCE_DESC
DECODE(FTVFSPD_PRD_STATUS_IND)	NA	COMPOSITE VIEW	AF_FISCAL_PERIOD	PERIOD_STATUS_DESC
DECODE(FTVFUND_REST_IND)	NA	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY	FUND_RESTRICTION_DESC FUND_RESTRICTION_DESC
DECODE(FTVVEND_1099_RPT_ID)	FTMVEND	COMPOSITE VIEW	AF_VENDOR	FEDERAL_REPORTABLE_TAX_IND	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	COMPOSITE VIEW	AP_HR_APPLICATION	STATUS_DISPOSITION_DESC	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	COMPOSITE VIEW	AG_INTERNET_ADDRESS	INTERNET_ADDRESS_STATUS_DESC
DECODE(GORSGEO_SOURCE_IND,'S','N','Y')	NA	COMPOSITE VIEW	AG_GEOGRAPHIC_REGION_INST	GEOGRAPHIC_SOURCE_USER_IND	DECODE(GORSGEO_SOURCE_IND,'S','N','Y')
DECODE(GORSGEO_STATUS_IND,NULL,'A','I')	NA	COMPOSITE VIEW	AG_GEOGRAPHIC_REGION_INST	GEOGRAPHIC_REGION_STATUS	DECODE(GORSGEO_STATUS_IND,NULL,'A','I')
DECODE(GORSGEO_STATUS_IND,NULL,'ACTIVE', 'INACTIVE')	NA	COMPOSITE VIEW	AG_GEOGRAPHIC_REGION_INST	GEOGRAPHIC_REGION_STATUS_DESC	DECODE(GORSGEO_STATUS_IND,NULL,'Active','Inactive')
DECODE(GROUP_TYPE)	NA
DECODE(GURMAIL_DATE_PRINTED,NULL,'Y', 'N')	NA	COMPOSITE VIEW	AG_COMMUNICATION	PENDING_LETTER_IND	NA
DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')	SUAMAIL	COMPOSITE VIEW	AG_COMMUNICATION	COMMUNICATION_TYPE_DESC	NA
DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE)	RNIMSXX
DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C', CANCELLED,'F',FROZEN,'I',INACTIVE)	NA	COMPOSITE VIEW	AN_SUPERVISOR AN_POSITION_DEFINITION	POSITION_STATUS_DESC POSITION_STATUS_DESC	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	COMPOSITE VIEW	AN_EMPLOYEE_POSITION AP_EMPLOYEE AN_SUPERVISOR	POSITION_CONTRACT_TYPE_DESC CONTRACT_TYPE_DESC POSITION_CONTRACT_TYPE_DESC	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	COMPOSITE VIEW	AN_EMPLOYEE_POSITION	PUBLIC_RETIRE_PAY_RATE_DESC	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	COMPOSITE VIEW	AN_EMPLOYEE_POSITION	POSITION_STATUS_DESC	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	COMPOSITE VIEW	AN_EMPLOYEE_POSITION	STATE_RETIREMENT_PAY_RATE_DESC	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	COMPOSITE VIEW	AN_POSITION_BUDGET AN_PAYROLL_DISTRIBUTION	BUDGET_STATUS_DESC BUDGET_STATUS_DESC	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	COMPOSITE VIEW	AN_PAYROLL_DISTRIBUTION	PAYROLL_EVENT_TYPE_DESC	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				NA
DECODE(NVL(AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'N', NVL(AGVPLG1_PLEDGE_AMOUNT,0) , 'N','Y')	NA	COMPOSITE VIEW	AA_PLEDGE	PLEDGE_PARTIAL_PAID_IND	NA
DECODE(PAYROLL_DEDUCTION)	NA				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	COMPOSITE VIEW	AP_BENEFIT_DEDUCTION	STATUS_DESC	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	COMPOSITE VIEW	AP_TAX	STATUS_DESC	NA
DECODE(PEBEMPL_1042_RECIPIENT_CD)	NA	COMPOSITE VIEW	AP_EMPLOYEE	FOREIGN_INCOME_RECIPIENT_DESC	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	COMPOSITE VIEW	AP_EMPLOYEE	PUBLIC_RETIREMENT_MEMBER_DESC
DECODE(PEBEMPL_EMPL_STATUS)	NA	COMPOSITE VIEW	AP_EMPLOYEE	EMPLOYEE_STATUS_DESC	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	COMPOSITE VIEW	AP_EMPLOYEE	FAIR_LABOR_STANDARDS_TYPE_DESC	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	COMPOSITE VIEW	AP_EMPLOYEE	IMMIGRATION_STATUS_DESC	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				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				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	COMPOSITE VIEW	AP_EMPLOYEE_EARNING_CY	QUARTER	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				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				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				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	COMPOSITE VIEW	AP_PAYROLL_ATTENDANCE	TIMESHEET_METHOD_DESC
DECODE(PHRDOCM_DOC_TYPE)	NA				DECODE(PHRDOCM_DOC_TYPE, 'C', 'N', 'D', 'Y')
DECODE(PHRELBD_TS_ROSTER_IND)	NA	COMPOSITE VIEW	AP_PAYROLL_LABOR_DIST_OVERRIDE	TIMESHEET_METHOD_DESC
DECODE(PHRHIST_CALC_IND)	NA				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				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
DECODE(PHRJOBS_TIME_ENTRY_IND)	NA				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				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				NA
DECODE(PTRBDCA_CALC_RULE)	NA				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_BORN_BEFORE_1_1_XX)	RNANAXX RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	OLDER_THAN_24_IND
DECODE(RCRAPP1_DEGREE_BY_JULY)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	DEGREE_BY_JULY_IND
DECODE(RCRAPP1_HAS_LEGAL_DEPEND)	RNANAXX RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LEGAL_DEPENDENT_IND
DECODE(RCRAPP1_INS)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	PERM_RESIDENCY_CONFIRMED_IND
DECODE(RCRAPP1_LINE2_RELSHIP)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE2_RELATIONSHIP_DESC
DECODE(RCRAPP1_LINE3_ATTEND_COLL)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE3_ATTEND_COLLEGE_DESC
DECODE(RCRAPP1_LINE3_RELSHIP)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE3_RELATIONSHIP_DESC
DECODE(RCRAPP1_LINE4_ATTEND_COLL)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE4_ATTEND_COLLEGE_DESC
DECODE(RCRAPP1_LINE4_RELSHIP)	NA	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE4_RELATIONSHIP_DESC
DECODE(RCRAPP1_LINE5_ATTEND_COLL)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE5_ATTEND_COLLEGE_DESC
DECODE(RCRAPP1_LINE5_RELSHIP)	NA	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE5_RELATIONSHIP_DESC
DECODE(RCRAPP1_LINE6_ATTEND_COLL)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE6_ATTEND_COLLEGE_DESC
DECODE(RCRAPP1_LINE6_RELSHIP)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE6_RELATIONSHIP_DESC
DECODE(RCRAPP1_LINE7_ATTEND_COLL)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE7_ATTEND_COLLEGE_DESC
DECODE(RCRAPP1_LINE7_RELSHIP)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE7_RELATIONSHIP_DESC
DECODE(RCRAPP1_LINE8_ATTEND_COLL)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE8_ATTEND_COLLEGE_DESC
DECODE(RCRAPP1_LINE8_RELSHIP)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	LINE8_RELATIONSHIP_DESC
DECODE(RCRAPP1_MRTL_STATUS)	NA	COMPOSITE VIEW	AR_FINAID_APPLICATION1	MARITAL_STATUS_DESC
DECODE(RCRAPP1_PAR_DIV_SEP_REM_IND)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	DIVORCED_PARENT_INFO_IND
DECODE(RCRAPP1_PAR_HOUS_STAT)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	PARENT_HOUSING_STATUS_DESC
DECODE(RCRAPP1_PAR_TAX_FORM_IND)	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	PARENT_TAX_RETURN_TYPE_DESC
DECODE(RCRAPP1_PERMIT_DRAFT_REG)	RNANAXX
DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR)	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	REQUESTED_AID_SPRING_DESC
DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR)	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	REQUESTED_AID_NEXT_SUMMER_DESC
DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR)	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	REQUESTED_AID_PREC_SUMMER_DESC
DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR)	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	REQUESTED_AID_WINTER_DESC
DECODE(RCRAPP1_SIGNED)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	APPLICATION_SIGNED_BY_DESC
DECODE(RCRAPP1_TAX_FORM_IND)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	TAX_RETURN_TYPE_DESC
DECODE(RCRAPP1_TITLE)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	NAME_PREFIX
DECODE(RCRAPP1_US_VET)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	VETERAN_IND
DECODE(RCRAPP1_VERIFICATION_MSG)	RNARSXX RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION1	SELECTED_FOR_VERIFICATION_IND
DECODE(RCRAPP1_YR_IN_COLL)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION1	YEAR_IN_COLLEGE_DESC
DECODE(RCRAPP2_C_1_ANLY_TYPE)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION2	FM_ANALYSIS_TYPE_DESC
DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION2	FM_CONTRIBUTION_OFFICIAL_DESC
DECODE(RCRAPP2_C_1_VA_BEN_INCL)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION2	FM_VETERAN_BENEFITS_IND
DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION2	IM_CONTRIBUTION_OFFICIAL_DESC
DECODE(RCRAPP2_C_2_VA_BEN_INCL)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION2	IM_VETERAN_BENEFITS_IND
DECODE(RCRAPP2_C_DEPEND_STATUS)	NA	COMPOSITE VIEW	AR_FINAID_APPLICATION2	DEPENDENCY_STATUS_DESC
DECODE(RCRAPP2_C_MRTL_STATUS)	TBD	COMPOSITE VIEW	AR_FINAID_APPLICATION2	MARITAL_STATUS_DESC
DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION2	FM_PARENT_ANALYSIS_TYPE_DESC
DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION2	FM_PARENT_CONTRIB_OFF_DESC
DECODE(RCRAPP2_C_PAR_2_CTRB_FR_ASSET)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION2	IM_PARENT_CONTRIBUTION_ASSET
DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION2	IM_PARENT_CONTRIB_OFF_DESC
DECODE(RCRAPP2_C_PAR_MRTL_STATUS)	TBD	COMPOSITE VIEW	AR_FINAID_APPLICATION2	PARENT_MARITAL_STATUS_DESC
DECODE(RCRAPP2_ELIGIBILITY_MSG)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION2	SAR_C_IND
DECODE(RCRAPP2_MODEL_CDE)	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICATION2	DEPENDENCY_INDEPEND_DESC
DECODE(RCRAPP2_PELL_ANLY_TYPE)	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION2	SIMPLIFIED_NEEDS_TEST_IND
DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION2	FM_EST_CONTRIB_OFFICIAL_DESC
DECODE(RCRAPP2_PELL_PGI_OFFL_EST)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION2	PELL_EFC_OFFICIAL_DESC
DECODE(RCRAPP2_PELL_P_ANLY_TYPE)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION2	FM_PARENT_EST_ANAL_TYPE_DESC
DECODE(RCRAPP3_C_SIGNED)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	SIGNATURE_IND
DECODE(RCRAPP3_C_SIGNED_FATH)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	FATHER_SIGNATURE_IND
DECODE(RCRAPP3_C_SIGNED_MOTH)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	MOTHER_SIGNATURE_IND
DECODE(RCRAPP3_C_SIGNED_SPS)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	SPOUSE_SIGNATURE_IND
DECODE(RCRAPP3_DEGREE_TYPE)	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	DEGREE_TYPE_DESC
DECODE(RCRAPP3_FAA_DEP_OVERRIDE)	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	DEPENDENCY_OVERRIDE_DESC
DECODE(RCRAPP3_FATH_SSN_MATCH)	RNANAXX RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	FATHER_TAX_ID_MATCH_DESC
DECODE(RCRAPP3_GRAD_OR_PROF)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	GRADUATE_PROFESSIONAL_IND
DECODE(RCRAPP3_LIVE_ON_FARM)	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	RESIDE_FARM_IND
DECODE(RCRAPP3_MARRIED)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	MARITAL_STATUS_IND
DECODE(RCRAPP3_MOTH_SSN_MATCH)	RNANAXX RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	MOTHER_TAX_ID_MATCH_DESC
DECODE(RCRAPP3_OFFL_UNOFFL_IND)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	OFFICIAL_SOURCE_IND
DECODE(RCRAPP3_PAR_LIVE_ON_FARM)	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	PARENT_RESIDE_FARM_IND
DECODE(RCRAPP3_PREPARER_SIGN)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	PREPARER_SIGNATURE_IND
DECODE(RCRAPP3_SOC_SEC)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	TAX_ID_MATCH_STATUS_DESC
DECODE(RCRAPP3_YR_IN_COLL_2)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION3	YEAR_IN_COLLEGE2_DESC
DECODE(RCRAPP4_1040A_ELIG_IND)	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	SHORT_TAX_FORM_IND
DECODE(RCRAPP4_ADDRESS_CHG_FLAG)	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	ADDRESS_CHANGE_DESC
DECODE(RCRAPP4_CUSTODIAL_PARENT)	RNASUXX RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_CUSTODIAL_PARENT_DESC
DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST)	RNINAIQ
DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST)	RNINAIQ
DECODE(RCRAPP4_EFC_CHANGE_IND)	RNIMSXX
DECODE(RCRAPP4_FEE_WAIVER_IND)	TBD	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PROFILE_FEE_WAIVER_IND
DECODE(RCRAPP4_FORMULA_FOR_CALC)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_FORMULA_DESC
DECODE(RCRAPP4_HAVE_CHILDREN)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	SUPPORT_CHILDREN_IND
DECODE(RCRAPP4_HS_GED_RCVD)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	SECONDARY_SCHOOL_DIPLOMA_IND
DECODE(RCRAPP4_LEGAL_RES_IND)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	LEGAL_RESIDENT_IND
DECODE(RCRAPP4_NSLDS_MATCH)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	NATIONAL_STUDENT_LOAN_SYS_DESC
DECODE(RCRAPP4_PAR_1040A_ELIG_IND)	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_SHORT_TAX_FORM_IND
DECODE(RCRAPP4_PAR_LEGAL_RES_IND)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_LEGAL_RESIDENT_IND
DECODE(RCRAPP4_SAR_C_CHANGE_FLAG)	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	SAR_C_CHANGE_IND
DECODE(RCRAPP4_SEC_INS_MATCH_IND)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PERM_RESIDENCY_VER_STATUS_DESC
DECODE(RCRAPP4_SOURCE_CORRECTION)	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	CORRECTION_SOURCE_DESC
DECODE(RCRAPP4_SSA_CITIZEN_IND)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	CITIZENSHIP_TYPE_DESC
DECODE(RCRAPP4_SS_MATCH)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	MILITARY_REGIST_STATUS_DESC
DECODE(RCRAPP4_SS_REG_FLAG)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	MILITARY_REG_REQ_STATUS_DESC
DECODE(RCRAPP4_TX_RET_FILED_IND)	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	TAX_RETURN_FILED_DESC
DECODE(RCRAPP4_TYPE_DATA_AVAIL)	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	DATA_TYPE_AVAILABLE_DESC
DECODE(RCRAPP4_VA_MATCH_FLAG)	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	VETERAN_MATCH_STATUS_DESC
DECODE(RCRAPP4_VISA_CLASS)	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	VISA_CLASSIFICATION_DESC
DECODE(RCRAPP4_WORK_STUDY)	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	WORK_STUDY_INTEREST_IND
DECODE(RCRESAR_AUTO_ZERO_EFC_FLAG)	RNIMSXX
DECODE(RCRESAR_A_BORN_BEFORE_IND)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	OLDER_THAN_24_IND
DECODE(RCRESAR_A_CITZ_IND)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	ASSUMED_CITIZENSHIP_DESC
DECODE(RCRESAR_A_MARRIED)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	ASSUMED_MARRIED_IND
DECODE(RCRESAR_A_MRTL_STATUS_IND)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	MARITAL_STATUS_IND
DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	PARENT_MARITAL_STATUS_IND
DECODE(RCRESAR_A_PAR_TAX_FILED_IND)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	PARENT_TAX_FILER_IND
DECODE(RCRESAR_A_S_DEPENDANTS)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	ASSUMED_DEPENDENT_IND
DECODE(RCRESAR_A_TAX_FILED_IND)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	TAX_FILER_IND
DECODE(RCRESAR_A_VA_STATUS)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	ASSUMED_VETERAN_IND
DECODE(RCRESAR_DUP_REQ_IND)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	DUPLICATE_REQUEST_IND
DECODE(RCRESAR_EDE_ETI_IND)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	ISIR_ELECT_TRANSACTION_DESC
DECODE(RCRESAR_EDE_INST_IND)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	ELECT_APPL_ENTRY_SOURCE_IND
DECODE(RCRESAR_FED_HOUS_CDE_1)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	FEDERAL_HOUSING1_DESC
DECODE(RCRESAR_FED_HOUS_CDE_2)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	FEDERAL_HOUSING2_DESC
DECODE(RCRESAR_FED_HOUS_CDE_3)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	FEDERAL_HOUSING3_DESC
DECODE(RCRESAR_FED_HOUS_CDE_4)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	FEDERAL_HOUSING4_DESC
DECODE(RCRESAR_FED_HOUS_CDE_5)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	FEDERAL_HOUSING5_DESC
DECODE(RCRESAR_FED_HOUS_CDE_6)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	FEDERAL_HOUSING6_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_1)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	MULTI_SCHOOL_FLAG1_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_2)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	MULTI_SCHOOL_FLAG2_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_3)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	MULTI_SCHOOL_FLAG3_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_4)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	MULTI_SCHOOL_FLAG4_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_5)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	MULTI_SCHOOL_FLAG5_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_6)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	MULTI_SCHOOL_FLAG6_DESC
DECODE(RCRESAR_REC_TYPE)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	PROCESSED_RECORD_TYPE_DESC
DECODE(RCRESAR_SEC_EFC_TYPE)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	SECONDARY_EFC_TYPE_DESC
DECODE(RCRESAR_SUB_APP)	RNIMSXX
DECODE(RCRIMP1_AID_STATUS)	RNASUXX
DECODE(RCRIMP1_APPLIC_TYPE)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	APPLICATION_TYPE_DESC
DECODE(RCRIMP1_FIN_AID_STATUS)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	FINANCIAL_AID_STATUS_DESC
DECODE(RCRIMP1_FOREIGN_ADDR_IND)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	FOREIGN_ADDRESS_IND
DECODE(RCRIMP1_HOUS_CDE_10)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	HOUSING10_DESC
DECODE(RCRIMP1_HOUS_CDE_9)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	HOUSING9_DESC
DECODE(RCRIMP1_LINE2_SCHL_TYPE)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	LINE2_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE3_SCHL_TYPE)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	LINE3_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE4_SCHL_TYPE)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	LINE4_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE5_SCHL_TYPE)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	LINE5_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE6_SCHL_TYPE)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	LINE6_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE7_SCHL_TYPE)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	LINE7_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE8_SCHL_TYPE)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	LINE8_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LOCATION_COMPUTER)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	PROFILE_COMPUTER_LOCATION_DESC
DECODE(RCRIMP1_ONLINE_SIG)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	ONLINE_SIGNATURE_IND
DECODE(RCRIMP1_OWN_BUS_HM_SELF_EMP)	RNAPRXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	IM_SELF_EMPLOYED_IND
DECODE(RCRIMP1_PAR_NTRL_SEP_DIV)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	PARENT_MARIT_STAT_SEP_DIV_DESC
DECODE(RCRIMP1_PAR_OWN_BUS_FARM)	RNAPRXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	PARENT_OWN_BUSINESS_IND
DECODE(RCRIMP1_PAR_SELF_EMPLOYED)	RNAPRXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	IM_PARENT_SELF_EMPLOYED_IND
DECODE(RCRIMP1_PAR_SMALL_BUSINESS)	RNAPRXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	IM_PARENT_LARGE_BUSINESS_IND
DECODE(RCRIMP1_SMALL_BUSINESS)	RNAPRXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	IM_LARGE_BUSINESS_IND
DECODE(RCRIMP1_STU_MOST_SUPPORT_FROM)	RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	PARENT_SUPPORT_PRIMARY_DESC
DECODE(RCRIMP1_TRUST_AVAIL_IND)	RNAPRXX RNASUXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	TRUST_AVAILABILITY_IND
DECODE(RCRIMP1_TRUST_ESTAB_BY)	RNAPRXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_PROFILE_SPEC	TRUST_ESTABLISHER_DESC
DECODE(RNROVRD_ADD_BK_HOPE_OPT)	RNAOVXX
DECODE(RNROVRD_ALLOW_IM_PC_LOWR_FM)	RNAOVXX
DECODE(RNROVRD_ALLOW_IM_SC_LOWR_FM)	RNAOVXX
DECODE(RNROVRD_CALC_US_TAX_FM)	RNAOVXX
DECODE(RNROVRD_CALC_US_TAX_IM)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_CALC_FEDERAL_TAX_OVR_DESC
DECODE(RNROVRD_CHG_DEPEND_FM)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_CHANGE_DEPENDENCY_STAT_DESC
DECODE(RNROVRD_CHG_DEPEND_IM)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_CHANGE_DEPENDENCY_STAT_DESC
DECODE(RNROVRD_FAMILY_ASSETS)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_ASSET_COMBINED_DESC
DECODE(RNROVRD_FM_PAR_NUM_COL)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_PARENT_NO_COLLEGE_OVR_IND
DECODE(RNROVRD_F_SSN_NO_DOB_REJ_OVRD)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_REJECT_S_IND
DECODE(RNROVRD_F_SSN_NO_NAME_REJ_OVRD)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_REJECT_E_IND
DECODE(RNROVRD_HOME_VAL_PROJ)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_HOME_VALUE_PROJ_DESC
DECODE(RNROVRD_INV_PROJ)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_IMPUTE_ASSET_DESC
DECODE(RNROVRD_LIMIT_PC_BY_BDGT)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	LIMIT_OTHERS_SHARE_PC_DESC
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD)	RNAOVXX
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD_	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_REJECT_T_IND
DECODE(RNROVRD_M_SSN_NO_NAME_REJ_OVRD)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_REJECT_F_IND
DECODE(RNROVRD_NON_CUST_OPT)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_NONCUS_CONT_CAL_DESC
DECODE(RNROVRD_NON_CUST_PC_OPT)	RNAOVXX
DECODE(RNROVRD_PAR_ADD_BK_HOPE_OPT)	RNAOVXX
DECODE(RNROVRD_PAR_AGI_OPT)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_WHICH_AGI_DESC
DECODE(RNROVRD_PAR_CALC_US_TAX_FM)	RNAOVXX
DECODE(RNROVRD_PAR_CALC_US_TAX_IM)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_CALC_FED_TAX_OV_DESC
DECODE(RNROVRD_PAR_USE_PROJ_INC_EFM)	RNAOVXX
DECODE(RNROVRD_SKIP_AGE_EXCL)	RNAOVXX
DECODE(RNROVRD_SSN_NO_DOB_REJ_OVRD)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_REJECT_R_IND
DECODE(RNROVRD_SSN_NO_NAME_REJ_OVRD)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_REJECT_D_IND
DECODE(RNROVRD_S_HOME_VAL_PROJ)	NA	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_HOME_VALUE_PROJECT_DESC
DECODE(RNROVRD_USE_PROJ_INC_EFM)	RNAOVXX
DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	USE_PARENT_STATE_PROV_TAX_IND
DECODE(RNROVRD_ZERO_LOSS_BUS_FARM)	RNAOVXX
DECODE(RNROVRD_ZERO_LOSS_OTH)	RNAOVXX
DECODE(RPRADSB_ALTERNATE_PELL_IND,'N')	ROAPELL
DECODE(RPRADSB_CONCUR_ENROLL_FLAG)	NA	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_CONCURRENT_ENROLLMENT_IND
DECODE(RPRADSB_DEBIT_CREDIT_IND)	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DEBIT_CREDIT_DESC
DECODE(RPRADSB_DISBURSE_LOAD)	RPAAWRD	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DISBURSEMENT_LOAD_DESC
DECODE(RPRADSB_DISBURSE_LOAD_OPT)	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	DISBURSEMENT_LOAD_OPT_DESC
DECODE(RPRADSB_DISB_ACPT_DEBIT_CR_IND)	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DEBIT_CREDIT_DESC
DECODE(RPRADSB_DISB_ACTION_CODE)	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISBURSEMENT_ACTION_DESC
DECODE(RPRADSB_PELLC_DISB_LOAD)	RPAAWRD	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	PELL_CALCULATED_DISB_LOAD_DESC
DECODE(RPRADSB_PELLC_DISB_LOAD_OPT)	RPRADSB	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	PELL_CALC_DISB_LOAD_OPT_DESC
DECODE(RPRADSB_POTENTIAL_OVERPMT_FLAG)	NA	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_POTENTIAL_OVERPAYMENT_IND
DECODE(RPRADSB_SHARED_SAR_ID_FLAG)	NA	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_SHARED_SAR_IDENTIFIER_IND
DECODE(RPRARSC_TYPE_CODE)	RPAARSC	COMPOSITE VIEW	AR_APPLICANT_RESOURCE	RESOURCE_TYPE_DESC
DECODE(RPRATRM_LOCK_IND)	NA	COMPOSITE VIEW	AR_AWARD_BY_PERSON	AWARD_LOCKED_DESC	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				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				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				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	COMPOSITE VIEW	AR_AWARD_BY_PERSON	ANNUAL_AWARD_LOCKED_DESC	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
DECODE(RPRAWRD_SYS_IND)	NA	COMPOSITE VIEW	AR_AWARD_BY_PERSON	SYSTEM_DESC	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				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	COMPOSITE VIEW	AR_LOAN_DISBURSEMENT	ENROLLMENT_LOAD_DESC
DECODE(RPRLADB_DISBURSE_LOAD_OPT)	RPALDSB
DECODE(RPRLADB_DISB_STATUS)	RPALORG
DECODE(RPRLADB_FEED_IND)	NA	COMPOSITE VIEW	AR_LOAN_DISBURSEMENT	DISBURSEMENT_FEED_DESC
DECODE(RPRLADB_HOLD_REL_STATUS)	RPAELAP	COMPOSITE VIEW	AR_LOAN_DISBURSEMENT	HOLD_RELEASE_STATUS_DESC
DECODE(RPRLADB_SERV_TRANS_TYPE)	NA	COMPOSITE VIEW	AR_LOAN_DISBURSEMENT	TRANSACTION_TYPE_DESC
DECODE(RPRLAPP_COSIGN1_RELATION_IND)	NA	COMPOSITE VIEW	AR_LOAN_APPLICATION	COSIGN1_RELATIONSHIP_DESC	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	COMPOSITE VIEW	AR_LOAN_APPLICATION	COSIGN2_RELATIONSHIP_DESC	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
DECODE(RTVFSRC_IND)	NA	COMPOSITE VIEW	AR_FINAID_FUND	FUND_SOURCE_TYPE_DESC	NA
DECODE(RTVFTYP_ATYP_IND)	NA	COMPOSITE VIEW	AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND	FINANCIAL_AID_TYPE_DESC GIFT_OR_SELF_HELP_AID_DESC GIFT_OR_SELF_HELP_AID	NA
DECODE(RTVFTYP_IND)	NA
DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME')	SAAADMS				NA
DECODE(SFBETRM_AR_IND)	TBD
DECODE(SFBETRM_MAXH_SRCE_CDE)	TBD
DECODE(SFBETRM_MINH_SRCE_CDE)	TBD
DECODE(SFBETRM_PIDM, NULL, 'N', 'Y')	NA
DECODE(SFBPLAN_COMMENT)	NA
DECODE(SFRPLAN_COMMENT)	NA
DECODE(SFRPLAN_SRC_CDE)	NA
DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y')	SFASLST	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY	FINAL_GRADE_ROLL_IND FINAL_GRADE_ROLL_IND	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	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	IN_PROGRESS_COURSE_IND	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	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_IN_PROGRESS	TRANSFER_COURSE_IND INSTITUTION_COURSE_IND	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				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	COMPOSITE VIEW	AS_CURRICULUM	MATRICULATED_IND	DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,N,Y)
DECODE(SHRATTR_PIDM, NULL, 'N', 'Y')	NA				NA
DECODE(SHRDGDH_HOND_CODE,NULL,NULL,'D')	SHADEGR	COMPOSITE VIEW	AS_OUTCOME_HONOR_DEPT	HONOR_IND	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	COMPOSITE VIEW	AS_OUTCOME_HONOR_INST	HONOR_IND	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	COMPOSITE VIEW	AS_GPA_LEVEL	GPA_TYPE_DESC	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	COMPOSITE VIEW	AS_STUDENT_COURSE_ATTR_TRANS	TRANSFER_COURSE_IND	NA
DECODE(SHRTATT_PIDM, NULL, 'Y', 'N')	NA	COMPOSITE VIEW	AS_STUDENT_COURSE_ATTR_TRANS	INSTITUTION_COURSE_IND	NA
DECODE(SHRTGPA_GPA_TYPE_IND,'I', 'INSTITUTION','T','TRANSFER')	NA	COMPOSITE VIEW	AS_GPA_TERM	GPA_TYPE_DESC	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				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
DECODE(SHRTTRM_RECORD_STATUS_IND)	NA
DECODE(SIBFACD_PRIMARY_ACTIVITY)	NA				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	COMPOSITE VIEW	AS_ROOM_ASSIGNMENT	ROOM_TYPE_DESC	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				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				DECODE(SORBACD_STATE_APPROV_IND,'Y','Y','N')
DECODE(SORDEGR_SBGI_CODE)	NA
DECODE(SORLCUR_SITE_CODE)	NA				DECODE(SORLCUR_SITE_CODE,NULL,SGBSTDN_SITE_CODE,SORLCUR_SITE_CODE)
DECODE(SORLCUR_TERM_CODE_ADMIT)	NA				NA
DECODE(SORLCUR_TERM_CODE_MATRIC)	SGASTDN				DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,'N','Y')
DECODE(SPBPERS_NAME_PREFIX,NULL,DECODE( SPBPERS_SEX,'M','MR.','F','MS.'), SPBPERS_NAME_PREFIX)	NA				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	COMPOSITE VIEW	AS_PERSON AA_RELATIONSHIP	GENDER_DESC RELATED_GENDER_DESC	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	COMPOSITE VIEW	AS_PERSON	VETERAN_CATEGORY_DESC	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				NA
DECODE(SPBPERS_VERA_IND,NULL,NULL, 'VETERAN')	SPAPERS				This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran.
DECODE(SPRIDEN_ID,NULL,NULL,'BANNER')	NA	COMPOSITE VIEW	AS_PERSON	ID_NUMBER_SOURCE	This function returns null if the id SPRIDEN_ID is null else it returns BANNER.
DECODE(SPRMEDI_DISB_IND,'Y','Y','N')	SPAMEDI	COMPOSITE VIEW	AS_MEDICAL_INFORMATION	PRIMARY_DISABILITY_IND	NA
DECODE(SSRFEES_FEE_IND)	SSADETL
DECODE(STVAPDC_APPL_INACT)	NA	COMPOSITE VIEW	AS_ADMISSIONS_DECISION	APPLICATION_INACTIVE_IND	DECODE (stvapdc_appl_inact, NULL, 'N', stvapdc_appl_inact)
DECODE(STVAPDC_INST_ACC_IND)	NA	COMPOSITE VIEW	AS_ADMISSIONS_DECISION	INSTITUTION_ADMIT_IND	DECODE (stvapdc_inst_acc_ind, NULL, 'N', stvapdc_inst_acc_ind)
DECODE(STVAPDC_REJECT_IND)	NA	COMPOSITE VIEW	AS_ADMISSIONS_DECISION	INSTITUTION_DENIED_IND	DECODE (stvapdc_reject_ind, NULL, 'N', stvapdc_reject_ind)
DECODE(STVAPDC_SIGNF_IND)	NA	COMPOSITE VIEW	AS_ADMISSIONS_DECISION	APPLICATION_SIGNIF_IND	DECODE (stvapdc_signf_ind, NULL, 'N', stvapdc_signf_ind)
DECODE(STVAPDC_STDN_ACC_IND)	NA	COMPOSITE VIEW	AS_ADMISSIONS_DECISION	APPLICANT_ACCEPT_IND	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
DECODE(STVRESD_IN_STATE_IND)	NA
DECODE(STVRRCD_MONTHLY_IND,'Y', 'MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y', 'DAILY','TERMLY'))	SLARASG	COMPOSITE VIEW	AS_ROOM_ASSIGNMENT	ROOM_RATE_TIME	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	COMPOSITE VIEW	AS_INSTITUTION	INSTITUTION_TYPE_DESC	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				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	COMPOSITE VIEW	AT_CONTRACT	STUDENT_INACTIVATED_IND	NA
DECODE(TBBESTU_DEL_IND)	TSAEXPP	COMPOSITE VIEW	AT_EXEMPTION	EXEMPTION_CANCELLED	NA
DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y')	TSADETC	COMPOSITE VIEW	AT_ACCOUNT_DETAIL	RETURNED_CHECK_IND	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	COMPOSITE VIEW	AT_ACCOUNT_DETAIL	BILL_AMOUNT	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	COMPOSITE VIEW	AT_ACCOUNT_DETAIL	ACCOUNT_POSTED_AMOUNT	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	COMPOSITE VIEW	AT_AR_DEPOSIT	ACCOUNT_POSTED_AMOUNT	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				This function determines if the entity is external to the system.
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y')	NA	COMPOSITE VIEW	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_PLAN	PLANNED_MOVE_COMPLETE_IND MOVE_COMPLETION_IND	NA
DECODE(TRANSACTION_HISTORY.FUND_POOL, NULL,FUND_HIERARCHY.FUND_POOL_DESC, TRANSACTION_HISTORY.FUND_POOL_DESC)	NA				Population of fund pool description is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
EARN	NA	COMPOSITE VIEW	AN_PERSONNEL_ACTION_EARNING	PAF_TRANSACTION_TYPE
FFRMASA_AMT+FFRMASA_ADJ_AMT- FFRMASA_DEPR_ACCUM_AMT	FFAMAST	COMPOSITE VIEW	AF_FIXED_ASSET_DEPRECIATION	BOOK_VALUE	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	COMPOSITE VIEW	AF_GENERAL_LEDGER	CURRENT_ACTUAL	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	COMPOSITE VIEW	AF_OPERATING_LEDGER	CURR_ACCUMULATED_BUDGET	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	COMPOSITE VIEW	AF_OPERATING_LEDGER	CURR_ADOPTED_BUDGET	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	COMPOSITE VIEW	AF_OPERATING_LEDGER	CURR_BUDGET_ADJUSTMENTS	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	COMPOSITE VIEW	AF_OPERATING_LEDGER	CURR_BUDGET_RESERVATION	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	COMPOSITE VIEW	AF_OPERATING_LEDGER	CURR_ENCUMBRANCES	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	COMPOSITE VIEW	AF_OPERATING_LEDGER	CURR_TEMPORARY_BUDGET	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	COMPOSITE VIEW	AF_OPERATING_LEDGER	CURR_YEAR_TO_DATE_ACTIVITY	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	COMPOSITE VIEW	AF_GRANT_LEDGER	CURR_ACCOUNTED_BUDGET	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	COMPOSITE VIEW	AF_GRANT_LEDGER	CURR_ADOPTED_BUDGET	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	COMPOSITE VIEW	AF_GRANT_LEDGER	CURR_BUDGET_ADJUSTMENTS	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	COMPOSITE VIEW	AF_GRANT_LEDGER	CURR_BUDGET_RESERVATIONS	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	COMPOSITE VIEW	AF_GRANT_LEDGER	CURR_ENCUMBRANCES	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	COMPOSITE VIEW	AF_GRANT_LEDGER	CURR_TEMPORARY_BUDGET	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	COMPOSITE VIEW	AF_GRANT_LEDGER	CURR_YEAR_TO_DATE_ACTIVITY	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	COMPOSITE VIEW	AF_GRANT_LEDGER	CURR_MEMO_COSTS	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
FRVEVNT_DESC \|\| FRBEVNG_ALTERNATE_EVNT_DESC	NA	COMPOSITE VIEW	AF_GRANT_EVENT	GRANT_EVENT_FULL_DESC
FTVSHIP_PHONE_AREA\|\|FTVSHIP_PHONE_NUM\|\|F TVSHIP_PHONE_EXT	NA	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM AF_PURCHASE_ORDER	PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED	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	COMPOSITE VIEW	AF_VENDOR	PHONE_NUMBER_COMBINED	This calculation formulates the combined phone number by concatenating FTVVEND_PHONE_AREA, FTVVEND_PHONE_NUMBER, and FTVVEND_PHONE_EXT.
F_GET_NORM_BALANCE	NA
IF AGBMGID_AMT_PAID > = AGBMGID_AMT THEN Y, ELSE N	NA				NA
IF AGBMGID_AMT_PAID IS > 0 AND < AGBMGID_AMT THEN Y, ELSE N	NA				NA
LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+ RCRAPP2_C_PAR_1_CTRB_FOR_STDT)	NA				LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)
LEVEL	FTMFUND	COMPOSITE VIEW	AF_FUND_HIERARCHY AF_ACCOUNT_HIERARCHY AF_FUND_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY AF_FUND_HIERARCHY_FISCAL	FUND_TYPE_LEVEL ACCOUNT_TYPE_LEVEL FUND_LEVEL PROGRAM_LEVEL ACCOUNT_LEVEL ACCOUNT_LEVEL LOCATION_LEVEL ORGANIZATION_LEVEL ORGANIZATION_LEVEL ACCOUNT_TYPE_LEVEL FUND_LEVEL LOCATION_LEVEL PROGRAM_LEVEL FUND_TYPE_LEVEL	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
MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS	NA
MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES - MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS	NA
MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100	NA
MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS	NA
MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS	NA
MAKFUNC.F_SOL_FR_TOTAL_PLEDGES - MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS	NA
MAX(APRACYR_YEAR)	NA	COMPOSITE VIEW	AA_SPECIAL_ACTIVITY	LAST_YEAR	NA
MEKFUNC.F_AUTHORIZED_TOTAL ( R.PORTFOLIO_KEY, '%', 'Y') + MEKFUNC.F_TOTAL_NOT_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y')	TBD
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y')	TBD
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '9900ADVC', '%','Y')	TBD
MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE	FNIEBAL				NA
MIN(APRACYR_YEAR)	NA	COMPOSITE VIEW	AA_SPECIAL_ACTIVITY	FIRST_YEAR	NA
MONTHS_BETWEEN	NA	COMPOSITE VIEW	AP_PAST_EMPLOYMENT	YEARS_MONTHS_IN_POSITION	NA
MONTHS_BETWEEN(NVL(APREHIS_TO_DATE, SYSDATE),APREHIS_FROM_DATE)	NA	COMPOSITE VIEW	AA_PREVIOUS_EMPLOYMENT	MONTHS_IN_POSITION	NA
MONTHS_BETWEEN(NVL(PPREXPE_END_DATE, SYSDATE),PPREXPE_START_DATE)	NA
MONTHS_BETWEEN(PPREXPE_END_DATE, PPREXPE_START_DATE)	NA				NA
NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND	NBAPBUD	COMPOSITE VIEW	AN_POSITION_BUDGET	AMOUNT_REMAINING	This function calculates the result of the budget minus the encumbrance and minus the expenditures. NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND.
NVL(ADBDESG_WEB_GIFT_IND,'N')	NA	COMPOSITE VIEW	AA_DESIGNATION	ALLOW_WEB_GIFT_IND
NVL(ADBDESG_WEB_PLDG_IND,'N')	NA	COMPOSITE VIEW	AA_DESIGNATION	ALLOW_WEB_PLEGE_IND
NVL(ADRCONF_CONFID_IND)	NA	COMPOSITE VIEW	AA_DESIGNATION_COMMENT	COMMENT_CONFIDENTIALITY_IND
NVL(AFBCAMP_ASSOC_IND,'N')	NA
NVL(AFRCSOL_GOAL,0)	NA
NVL(AFRDESG_GOAL,0)	NA
NVL(AGBPLDG_MATCH_FORM_IND)	NA	COMPOSITE VIEW	AA_PLEDGE	MATCHING_GIFT_FORM_IND
NVL(AGBPLDG_MATCH_PROCESSED)	NA	COMPOSITE VIEW	AA_PLEDGE	MATCH_GIFT_FORM_PROCESSED_IND
NVL(AGBPLDG_MGFORM_READYTOSEND)	NA	COMPOSITE VIEW	AA_PLEDGE	MATCHGIFT_FORM_READYTOSEND_IND
NVL(AGBPLDG_PACK_IND,'N'),	NA	COMPOSITE VIEW	AA_PLEDGE	PLEDGE_ACKNOWLEDGED_IND	NA
NVL(AGBPLDG_RECEIPT_IND,'N'),	NA	COMPOSITE VIEW	AA_PLEDGE	RECEIPT_REQUIRED_IND	NA
NVL(AGRGAUX_DEDUCT_FOR_TAXES,'N')	NA	COMPOSITE VIEW	AA_GIFT_AUXILIARY	DEDUCT_FOR_TAXES_IND	NA
NVL(AMBPLAN_END_DATE,'31-DEC-2099')	NA
NVL(AMRCONF_CONFID_IND)	NA	COMPOSITE VIEW	AA_PROSPECT_CONF_COMMENT	COMMENT_CONFIDENTIALITY_IND
NVL(AMRCONT_CONFID_IND)	NA	COMPOSITE VIEW	AA_CONSTITUENT_CONTACT	TICKLER_CONFIDENTIAL_IND
NVL(AMRINFO_WEB_GIFT_IND,'N')	NA	COMPOSITE VIEW	AA_PROSPECT_INFO	ALLOW_WEB_GIFT_IND
NVL(AMRINFO_WEB_PLDG_IND,'N')	NA	COMPOSITE VIEW	AA_PROSPECT_INFO	ALLOW_WEB_PLEDGE_IND
NVL(AMRSTAF_END_DATE,'31-DEC-2099')	NA
NVL(AMRSTAF_SOLICIT_IND,'N')	NA	COMPOSITE VIEW	AA_PROSPECT_INFO	SOLICITOR_IND
NVL(APRCONF_CONFID_IND)	NA	COMPOSITE VIEW	AA_CON_ENTITY_CONF_COMMENT	COMMENT_CONFIDENTIALITY_IND
NVL(APRCONF_DISP_NOTES_IND)	NA	COMPOSITE VIEW	AA_CON_ENTITY_CONF_COMMENT	DISPLAYED_IN_NOTE_IND
NVL(APRCONF_OK_FOR_NOTES_IND)	NA	COMPOSITE VIEW	AA_CON_ENTITY_CONF_COMMENT	OK_FOR_NOTE_IND
NVL(APRCONF_REVIEWED_IND)	NA	COMPOSITE VIEW	AA_CON_ENTITY_CONF_COMMENT	WEB_REVIEWED_IND
NVL(ASBSORG_DOLLAR_GOAL,)	NA	COMPOSITE VIEW	AA_SOLICITOR_ORGANIZATION	ORGANIZATION_GOAL
NVL(ASBSORG_DOLLAR_GOAL,0)	NA
NVL(ASBSORG_DONOR_COUNT_GOAL,)	NA	COMPOSITE VIEW	AA_SOLICITOR_ORGANIZATION	ORGANIZATION_DONOR_COUNT_GOAL
NVL(ASBSORG_DONOR_COUNT_GOAL,0)	NA
NVL(ASBSORG_UPD_WEB_IND)	NA	COMPOSITE VIEW	AA_SOLICITOR_ORGANIZATION	ALLOW_WEB_UPDATE_IND
NVL(ASRSORG_UPD_WEB_IND)	NA	COMPOSITE VIEW	AA_SOLICITOR_ORG_FUNDRAISER AA_CAMPAIGN_FUNDRAISER	ALLOW_WEB_UPDATE_SOLICITOR_IND ALLOW_WEB_UPDATE_SOLICITOR_IND
NVL(ATVCMPT_CAPITAL_IND,'N')	NA
NVL(ATVEMPS_ACTIVE_IND,'N')	ATVEMPS	COMPOSITE VIEW	AA_PREVIOUS_EMPLOYMENT	EMPLOYMENT_STATUS_ACTIVE_IND	NA
NVL(AXBMGID_MGFORM_READYTOSEND)	NA	COMPOSITE VIEW	AA_PLEDGE_MATCHING	MATCH_FORM_SENT_IND
NVL(CURR_ADOPTED_BUDGET + CURR_BUDGET_ADJUSTMENTS, 0)	NA				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				Calculates the current commited balance as current year to date activity + current encumbrances + current budget reservations (requisistions).
NVL(FABINVH_ACH_OVERRIDE_IND,'N')	NA	COMPOSITE VIEW	AF_INVOICE	DIRECT_DEPOSIT_OVERRIDE_IND
NVL(FABINVH_DISB_AGENT_IND,'N')	NA	COMPOSITE VIEW	AF_INVOICE	DISBURSING_AGENT_IND
NVL(FABINVH_EDIT_DEFER_IND,'N')	NA	COMPOSITE VIEW	AF_INVOICE	DEFERRED_EDIT_IND
NVL(FABINVH_INVD_RE_ESTABLISH_IND,'N')	NA	COMPOSITE VIEW	AF_INVOICE	INVOICE_RE_ESTABLISHED_IND
NVL(FABINVH_NSF_ON_OFF_IND,'N')	NA	COMPOSITE VIEW	AF_INVOICE	NSF_ON_OFF_IND
NVL(FABINVH_RUIV_IND,'N')	FAAINVE	COMPOSITE VIEW	AF_INVOICE	REPEATING_INVOICE_IND
NVL(FABINVH_RUIV_INSTALLMENT_IND,'N')	FAAINVE	COMPOSITE VIEW	AF_INVOICE	INSTALLMENT_IND
NVL(FABINVH_SINGLE_ACCTG_IND,'N')	NA	COMPOSITE VIEW	AF_INVOICE	DOCUMENT_ACCOUNTING_IND
NVL(FABINVH_TEXT_IND,'N')	NA	COMPOSITE VIEW	AF_INVOICE	TEXT_EXISTS_IND
NVL(FABRUIV_MAX_SUB,0)	NA	COMPOSITE VIEW	AF_INVOICE	MAXIMUM_NUMBER_SUBMISSIONS
NVL(FABRUIV_MAX_SUB,0) - NVL( FABRUIV_SUB_TO_DATE,0)	NA	COMPOSITE VIEW	AF_INVOICE	REMAINING_SUBMISSIONS
NVL(FABRUIV_SUB_TO_DATE,0)	NA	COMPOSITE VIEW	AF_INVOICE	SUBMISSIONS_TO_DATE
NVL(FARINVA_APPR_AMT,0)+NVL( FARINVA_ADDL_CHRG_AMT,0)+NVL( FARINVA_TAX_AMT,0)-NVL(FARINVA_DISC_AMT, 0)	FAAINVE	COMPOSITE VIEW	AF_INVOICE_ACCOUNTING	APPROVED_CHARGE_AMOUNT	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
NVL(FGBENCH_EDIT_DEFERRAL,'N')	NA
NVL(FGBENCH_NSF_ON_OFF_IND,'N')	NA
NVL(FPBPOHD_BLANKET_IND,'N')	FPABLAR	COMPOSITE VIEW	AF_PURCHASE_ORDER	BLANKET_ORDER_IND
NVL(FPBPOHD_CANCEL_IND,'N')	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER	CANCEL_IND
NVL(FPBPOHD_CLOSED_IND,'N')	NA	COMPOSITE VIEW	AF_PURCHASE_ORDER	CLOSED_IND
NVL(FPBPOHD_EDI_IND,'N')	NA	COMPOSITE VIEW	AF_PURCHASE_ORDER	EDI_IND
NVL(FPBPOHD_PRINT_IND,'N')	NA	COMPOSITE VIEW	AF_PURCHASE_ORDER	PRINT_IND
NVL(FPBPOHD_REXP_DATE, FPBPOHD_BLANKET_TERM_DATE)	FPABLAR	COMPOSITE VIEW	AF_PURCHASE_ORDER	PO_END_DATE	NA
NVL(FPBPOHD_SUSP_IND,'N')	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER	SUSPENSE_IND
NVL(FPRPODA_ADDL_CHRG_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	ADDITIONAL_AMOUNT
NVL(FPRPODA_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	AMOUNT
NVL(FPRPODA_AMT,0)+NVL( FPRPODA_ADDL_CHRG_AMT,0)+NVL( FPRPODA_TAX_AMT,0)-NVL(FPRPODA_DISC_AMT, 0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	APPROVED_CHARGE_AMOUNT	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	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	CLOSED_IND
NVL(FPRPODA_CONVERT_ADDL_CHRG_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	CONVERTED_ADDITIONAL_AMOUNT
NVL(FPRPODA_CONVERT_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	CONVERTED_AMOUNT
NVL(FPRPODA_CONVERT_DISC_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	CONVERTED_DISCOUNT_AMOUNT
NVL(FPRPODA_CONVERT_TAX_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	CONVERTED_TAX_AMOUNT
NVL(FPRPODA_DISC_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	DISCOUNT_AMOUNT
NVL(FPRPODA_ENCB_ADJT_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	ENCUMBRANCE_ADJUSTMENT_AMOUNT
NVL(FPRPODA_NSF_OVERRIDE_IND,'N')	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	NSF_OVERRIDE_IND
NVL(FPRPODA_SUSP_IND,'N')	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	SUSPENSE_IND
NVL(FPRPODA_TAX_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ACCOUNTING	TAX_AMOUNT
NVL(FPRPODT_ADDL_CHRG_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	ADDITIONAL_CHARGES_AMOUNT
NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	CONVERTED_ADDITNAL_AMOUNT
NVL(FPRPODT_CONVERT_DISC_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	CONVERTED_DISCOUNT_AMOUNT
NVL(FPRPODT_CONVERT_TAX_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	CONVERTED_TAX_AMOUNT
NVL(FPRPODT_CONVERT_UNIT_PRICE,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	CONVERTED_UNIT_PRICE
NVL(FPRPODT_DESC_CHGE_IND,'N')	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	COMMODITY_DESC_CHANGE_IND
NVL(FPRPODT_DISC_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	DISCOUNT_AMOUNT
NVL(FPRPODT_LIQ_AMT,0)	NA	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	LIQUIDATION_AMOUNT
NVL(FPRPODT_QTY,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	QUANTITY
NVL(FPRPODT_TAX_AMT,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	TAX_AMOUNT
NVL(FPRPODT_UNIT_PRICE,0)	FPAPURR	COMPOSITE VIEW	AF_PURCHASE_ORDER_ITEM	UNIT_PRICE
NVL(FPRRCDT_TOL_OVERRIDE_IND)	FPARCVD				Calculations deterimines if the override is set to (Y)es or (N)o.
NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID)	NA	COMPOSITE VIEW	AE_EXPENSE_ITEM	PURCHASE_CARD_ID
NVL(FTRACTA_ATTS_CODE,'NONE')	FTMFATA	COMPOSITE VIEW	AF_ACCOUNT_ATTRIBUTES_ODS	SET_CODE	NA
NVL(FTRACVA_ATTS_CODE,'NONE')	FTMFATA	COMPOSITE VIEW	AF_ACTIVITY_ATTRIBUTES_ODS	SET_CODE	NA
NVL(FTRATYA_ATTS_CODE,'NONE')	FTMFATA	COMPOSITE VIEW	AF_ACCOUNT_TYPE_ATTRIBUTES_ODS	SET_CODE	NA
NVL(FTRFNDA_ATTS_CODE,'NONE')	FTMFATA	COMPOSITE VIEW	AF_FUND_ATTRIBUTES_ODS	SET_CODE	NA
NVL(FTRFTYA_ATTS_CODE,'NONE')	FTMFATA	COMPOSITE VIEW	AF_FUND_TYPE_ATTRIBUTES_ODS	SET_CODE	NA
NVL(FTRLCNA_ATTS_CODE,'NONE')	FTMFATA	COMPOSITE VIEW	AF_LOCATION_ATTRIBUTES_ODS	SET_CODE	NA
NVL(FTRORGA_ATTS_CODE,'NONE')	FTMFATA	COMPOSITE VIEW	AF_ORGANIZATION_ATTRIBUTES_ODS	SET_CODE	NA
NVL(FTRPRGA_ATTS_CODE,'NONE')	FTMFATA	COMPOSITE VIEW	AF_PROGRAM_ATTRIBUTES_ODS	SET_CODE	NA
NVL(FTVACCT_ACCT_CODE_POOL, FTVACCT_ACCT_CODE)	FTMACCT	COMPOSITE VIEW	AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL	ACCOUNT_POOL ACCOUNT_POOL	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	COMPOSITE VIEW	AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY	FUND_POOL FUND_POOL	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	COMPOSITE VIEW	AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY	ORGANIZATION_POOL ORGANIZATION_POOL	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
NVL(FTVVEND_VEND_CHECK_PIDM, FTVVEND_PIDM)	NA
NVL(GERATTD_FEES_DESC, GTVFEES_DESC)	NA	COMPOSITE VIEW	AG_EVENT_INVITEE	FEE_STATUS_DESC	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				NA
NVL(NBBPOSN_ACCRUE_SENIORITY_IND, NTRPCLS_ACCRUE_SENIORITY_IND)	MULTIPLE	COMPOSITE VIEW	AN_POSITION_DEFINITION	SENIORITY_ACCRUED_IND	Retrieves seniority accrual indicator from postion classification rule table if the indicator is null in the position record.
NVL(NBBPOSN_GRADE,NTRPCLS_GRADE)	NA	COMPOSITE VIEW	AN_POSITION_DEFINITION	SALARY_GRADE	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				NVL(POSITION_REPORTS, SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION,'POSITION'),1,63))
NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE)	NA				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	COMPOSITE VIEW	AN_POSITION_DEFINITION	SALARY_STEP	This function returns NBBPOSN_STEP if it is not null else it returns NTRPCLS_STEP.
NVL(NBBPOSN_TABLE,NTRPCLS_TABLE)	NA	COMPOSITE VIEW	AN_POSITION_DEFINITION	SALARY_TABLE	This function returns NBBPOSN_TABLE if it is not null, else it returns NTRPCLS_TABLE.
NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR)	NA	COMPOSITE VIEW	AN_SUPERVISOR	SUPERVISOR_UID	NVL(P.NBRJOBS_SUPERVISOR_PIDM, TO_NUMBER(NOKODSF.F_GET_SUPERVISOR(B.NBBPOSN_POSN_REPORTS,'PIDM')))
NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS)	NA	COMPOSITE VIEW	AN_SUPERVISOR	SUPERVISOR_POSITION	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	COMPOSITE VIEW	AN_SUPERVISOR	SUPERVISOR_JOB_SUFFIX	NVL(NBRJOBS_SUPERVISOR_SUFF, SUBSTR(NOKODSF.F_GET_SUPERVISOR(NBBPOSN_POSN_REPORTS,'SUFFIX'),1,2)
NVL(PAY.TRANSACTION_DATE, CHG.TRANSACTION_DATE)	NA				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(RCRAPP4_DUP_SSN_IND)	TBD	COMPOSITE VIEW	AR_FINAID_APPLICATION4	DUPLICATE_TAX_ID_IND
NVL(RCRAPP4_PUSH_ISIR_FLAG)	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	CPS_ISIR_PUSHED_IND
NVL(RCRESAR_AUTO_ZERO_EFC_FLAG)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	AUTOMATIC_ZERO_EFC_IND
NVL(RCRESAR_SUB_APP)	RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	SUBSEQUENT_APPLICATION_IND
NVL(RCRESAR_VERIF_CHANGE_IND)	RNARSXX RNIMSXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_ISIR_SPEC	VERIFICATION_SELECT_CHANGE_IND
NVL(RNROVRD_ADD_BK_HOPE_OPT)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_ADD_HOPE_LL_IND
NVL(RNROVRD_ALLOW_IM_PC_LOWR_FM)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_LOWER_THAN_FM_IND
NVL(RNROVRD_ALLOW_IM_SC_LOWR_FM)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_LOWER_THAN_FM_IND
NVL(RNROVRD_CALC_US_TAX_FM)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_STUD_CALC_FED_TAX_OVR_IND
NVL(RNROVRD_NON_CUST_PC_OPT)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_USE_NONCUSTODIAL_PC_IND
NVL(RNROVRD_PAR_ADD_BK_HOME_OPT)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_ADD_HOPE_LL_IND
NVL(RNROVRD_PAR_CALC_US_TAX_FM)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	FM_PARENT_CALC_FED_TAX_OVR_IND
NVL(RNROVRD_PAR_EXCL_TUIT_DED)	RNAOVXX	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_EXCL_TUITION_FEE_IND
NVL(RNROVRD_PAR_USE_PROJ_INC_EFM)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_EFM_EST_INCOME_IND
NVL(RNROVRD_SKIP_AGE_EXCL)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_SKIP_AGE_EXCLUSION_IND
NVL(RNROVRD_USE_PROJ_INC_EFM)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_EFM_ESTIMATED_INCOME_IND
NVL(RNROVRD_ZERO_LOSS_BUS_FARM)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_ZERO_LOSS_BUS_IND
NVL(RNROVRD_ZERO_LOSS_OTH)	TBD	COMPOSITE VIEW	AR_NEED_ANALYSIS_OVERRIDE	IM_PARENT_ZERO_LOSS_OTH_IND
NVL(RPRADSB_ALTERNATE_PELL_IND,'N')	ROAPELL	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	ALTERNATE_PELL_PAY_SCHED_IND
NVL(RPRADSB_CPS_VER_IND,'N')	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	CPS_VERIFICATION_IND
NVL(RPRADSB_DISB_LOCK_IND,'N')	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_DISBURSEMENT_LOCK_IND
NVL(RPRADSB_EXCL_FROM_NET_AMT,'N')	READIXX	COMPOSITE VIEW	AR_AWARD_DISBURSEMENT	COD_NET_AMOUNT_EXCLUSION_IND
NVL(RPRLAPP_ADDL_STFD_ELIG_IND,'N')	NA	COMPOSITE VIEW	AR_LOAN_APPLICATION	ADDL_STAFFORD_ELIG_IND
NVL(RPRLAPP_DEFERMENT_OPT,'N')	NA
NVL(RPRLAPP_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO)	NA
NVL(RPRLAPP_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO)	NA
NVL(RPRLAPP_MAX_LOAN_IND,'N')	NA
NVL(RPRLAPP_MI, MGKFUNC.F_GET_PERSON_INFO)	NA
NVL(RPRLAPP_SSN, MGKFUNC.F_GET_PERSON_INFO)	NA
NVL(RPRLATR_EXCLUDE_LNEX_FLAG,'N')	RPALORG RPAELAP RPALAPP	COMPOSITE VIEW	AR_LOAN_DISBURSEMENT	EXCLUDE_EXCEPTION_REPORT_IND
NVL(SARADAP_FEE_IND,'N')	NA	COMPOSITE VIEW	AS_ADMISSIONS_APPLICATION	APPLICATION_FEE_REQUIRED_IND	NA
NVL(SFRSTCR_APPR_OVER,'N')	NA
NVL(SFRSTCR_ATTS_OVER,'N')	NA
NVL(SFRSTCR_CAMP_OVER,'N')	NA
NVL(SFRSTCR_CAPC_OVER,'N')	NA
NVL(SFRSTCR_CHRT_OVER,'N')	NA
NVL(SFRSTCR_CLAS_OVER,'N')	NA
NVL(SFRSTCR_COLL_OVER,'N')	NA
NVL(SFRSTCR_CORQ_OVER,'N')	NA
NVL(SFRSTCR_DEGC_OVER,'N')	NA
NVL(SFRSTCR_DEPT_OVER,'N')	NA
NVL(SFRSTCR_DUPL_OVER,'N')	NA
NVL(SFRSTCR_LEVL_OVER,'N')	NA
NVL(SFRSTCR_LINK_OVER,'N')	NA
NVL(SFRSTCR_MAJR_OVER,'N')	NA
NVL(SFRSTCR_MEXC_OVER,'N')	NA
NVL(SFRSTCR_PREQ_OVER,'N')	NA
NVL(SFRSTCR_PROG_OVER,'N')	NA
NVL(SFRSTCR_REPT_OVER,'N')	NA
NVL(SFRSTCR_RPTH_OVER,'N')	NA
NVL(SFRSTCR_TEST_OVER,'N')	NA
NVL(SFRSTCR_TIME_OVER,'N')	NA
NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS( SHRTCKN_PIDM,SHRTCKN_TERM_CODE, SHRTCKN_CRN))	NA	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY	EXTENSIONS	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	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY	END_DATE	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	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	START_DATE	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	COMPOSITE VIEW	AS_PREVIOUS_EDUCATION_PCOL	TRANSCRIPT_REVIEWED_DATE	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	COMPOSITE VIEW	AS_LEARNER_CURRICULUM_FOS	GRAD_YEAR_INTENDED	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	COMPOSITE VIEW	AS_LEARNER_CURRICULUM_FOS	EXPECTED_GRADUATION_DATE	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	COMPOSITE VIEW	AS_LEARNER_CURRICULUM_FOS	LEAVE_REASON	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	COMPOSITE VIEW	AS_LEARNER_CURRICULUM_FOS	LEAVE_DATE_FROM	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	COMPOSITE VIEW	AS_LEARNER_CURRICULUM_FOS	LEAVE_DATE_TO	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	COMPOSITE VIEW	AS_LEARNER_CURRICULUM_FOS	STUDENT_RATE	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				Use site code from curriculum record and if null use site from student record sgbstdn.
NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE)	MULTIPLE				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	COMPOSITE VIEW	AS_LEARNER_CURRICULUM_FOS	GRAD_ACADEMIC_PERIOD_INTENDED	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	COMPOSITE VIEW	AS_INSTRUCTIONAL_ASSIGNMENT	INSTRUCTOR_LAST_NAME	This function returns the instructor''s last name SPRIDEN_LAST_NAME if it exists, else STAFF.
NVL(SPRIDEN_MI,'STAFF')	MULTIPLE				Retrieve the instructor''s last name SPRIDEN_LAST_NAME if it exists, else set to STAFF.
NVL(SSBOVRR_COLL_CODE,SCBCRSE_COLL_CODE)	SSAOVRR	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	COURSE_COLLEGE	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	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	COURSE_DEPARTMENT	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	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	COURSE_DIVISION	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				NA
NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE)	SCACRSE	COMPOSITE VIEW	AS_STUDENT_COURSE_IN_PROGRESS	COURSE_TITLE_SHORT	NA
NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH)	SCACRSE				NA
NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH)	SCACRSE				NA
NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH)	SCACRSE				NA
NVL(SUM_ADOPTED_BUDGET + SUM_BUDGET_ADJUSTMENTS, 0)	NA				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				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	COMPOSITE VIEW	AT_AR_DEPOSIT	BALANCE_AMOUNT	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	COMPOSITE VIEW	AT_AR_DEPOSIT	OPERATING_DATE	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				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	COMPOSITE VIEW	AA_SOLICITOR_ORGANIZATION	ORG_PARTICIPATION_GOAL
PPREXPE_SUPER_PHONE_AREA\|\|PPREXPE_SUPER_ PHONE_NUMBER\|\|PPREXPE_SUPER_PHONE_EXT	NA	COMPOSITE VIEW	AP_PAST_EMPLOYMENT	SUPERVISOR_COMBINED_PHONE	NA
PPRREFE_PHONE_AREA\|\|PPRREFE_PHONE_NUMBER \|\|PPRREFE_PHONE_EXT	NA	COMPOSITE VIEW	AP_REFERENCE	COMBINED_PHONE	This function concatenates the phone area code, the phone number and the phone extension from the PPRREFE table.
ROW_NUMBER	TBD
SCBCRSE_SUBJ_CODE\|\|SCBCRSE_CRSE_NUMB	SCACRSE	COMPOSITE VIEW	AS_COURSE_CATALOG	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SCBCRSE record.
SCBSUPP_SUBJ_CODE\|\|SCBSUPP_CRSE_NUMB	SCADETL	COMPOSITE VIEW	AS_COURSE_SUPPLEMENTAL	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SCBSUPP record.
SCRATTR_SUBJ_CODE\|\|SCRATTR_CRSE_NUMB	SCADETL				NA
SCRCORQ_SUBJ_CODE_CORQ\|\|SCRCORQ_CRSE_NUM B_CORQ	SCADETL	COMPOSITE VIEW	AS_COURSE_COREQ	COURSE_IDENTIFICATION_COREQ	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	COMPOSITE VIEW	AS_COURSE_COREQ	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SCRCORQ record.
SCRGMOD_SUBJ_CODE\|\|SCRGMOD_CRSE_NUMB,	SSASECT	COMPOSITE VIEW	AS_OFFERING_GRADE_MODE	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SGRGMOD record.
SCRLEVL_SUBJ_CODE\|\|SCRLEVL_CRSE_NUMB	SCACRSE	COMPOSITE VIEW	AS_COURSE_LEVEL	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SCRLEVL record.
SCRRTST_SUBJ_CODE\|\|SCRRTST_CRSE_NUMB	SCAPREQ	COMPOSITE VIEW	AS_COURSE_PREREQ	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SCRRTST record.
SCRSCHD_SUBJ_CODE\|\|SCRSCHD_CRSE_NUMB	SCACRSE	COMPOSITE VIEW	AS_COURSE_SCHEDULE	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SCRSCHD record.
SEASONS_COMPETITION_AVAILABLE - SEASONS_COMPETITION_USED	NA
SELECT RORMVAL_DESC FROM RORMVAL WHERE RORMVAL_COLUMN = 'RFRASPC_APPL_MEMO_IND' AND RORMVAL_CODE = RFRASPC_APPL_MEMO_IND	NA
SFRPLAN_SUBJ_CODE\|\|SFRPLAN_CRSE_NUMB	NA
SFRSTCR_SUBJ_CODE\|\|SFRSTCR_CRSE_NUMB	SFAREGS	COMPOSITE VIEW	AS_FACULTY_FEEDBACK	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SFRSTCR record.
SGRCOOP_PHONE_AREA\|\|SGRCOOP_PHONE_NUMBER \|\|SGRCOOP_PHONE_EXT	NA				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	COMPOSITE VIEW	AS_STUDENT_COURSE_ATTR_TRANS	COURSE_REFERENCE_NUMBER
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_ATTEMPTED_IND,'Y',1,0)	SHATCKS	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_GRADE_CHG	CREDITS_ATTEMPTED CREDITS_ATTEMPTED	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	COMPOSITE VIEW	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_GRADE_CHG	CREDITS_EARNED CREDITS_EARNED	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	COMPOSITE VIEW	AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY	CREDITS_FOR_GPA CREDITS_FOR_GPA	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	COMPOSITE VIEW	AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY	CREDITS_PASSED CREDITS_PASSED	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	COMPOSITE VIEW	AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY	QUALITY_POINTS QUALITY_POINTS	This calculates the credit hours passed by the student.
SHRTCKN_SUBJ_CODE\|\|SHRTCKN_CRSE_NUMB	SHAINST				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
SHRTRCE_CREDIT_HOURSDECODE( SHRGRDE_EARNED_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1)	TBD
SHRTRCE_CREDIT_HOURSDECODE( SHRGRDE_GPA_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1)	TBD
SHRTRCE_CREDIT_HOURSDECODE( SHRGRDE_PASSED_IND,'Y',1,0)DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1)	TBD
SHRTRCE_CREDIT_HOURSSHRGRDE_QUALITY_POI NTSDECODE(SHRGRDE_GPA_IND,'Y',1,0) *DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0, 1)	TBD
SHRTRCE_TRIT_SEQ_NO\|\|TO_CHAR( SHRTRCE_TRAM_SEQ_NO,'FM09')\|\|TO_CHAR( NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009') \|\|TO_CHAR(SHRTRCE_SEQ_NO,'FM009')	MULTIPLE	COMPOSITE VIEW	AS_STUDENT_COURSE_TRANSFER AS_STUDENT_TRANSFERRED_COURSE AS_STUDENT_COURSE_TRANSFER AS_STUDENT_TRANSFERRED_COURSE	COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER
SHRTRCR_TRANS_COURSE_NAME\|\|SHRTRCR_TRANS _COURSE_NUMBERS	NA	COMPOSITE VIEW	AS_STUDENT_TRANSFERRED_COURSE	TRANSFER_COURSE_IDENTIFICATION
SLBBLDG_PHONE_AREA\|\|SLBBLDG_PHONE_NUMBER \|\|SLBBLDG_PHONE_EXTENSION	SLABLDG	COMPOSITE VIEW	AS_ROOM_ASSIGNMENT	BUILDING_PHONE_NUM_COMBINED	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	COMPOSITE VIEW	AG_EVENT	PHONE_NUMBER_COMBINED	NA
SLBRDEF_PHONE_AREA\|\|SLBRDEF_PHONE_NUMBER \|\|SLBRDEF_PHONE_EXTENSION	SLARASG	COMPOSITE VIEW	AS_ROOM_ASSIGNMENT	ROOM_PHONE_NUM_COMBINED	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	COMPOSITE VIEW	AS_PHONE_ASSIGNMENT	PHONE_NUMBER_COMBINED	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	COMPOSITE VIEW	AS_INSTITUTION	CONTACT_PHONE_NUMBER_COMBINED	NA
SPRADDR_CNTY_CODE	FAAINVE				NA
SPRIDEN_FIRST_NAME \|\| SUBSTR(SPRIDEN_MI, 1,1) \|\| SPRIDEN_LAST_NAME	NA
SPRIDEN_FIRST_NAME\|\|SPRIDEN_MI\|\|SPRIDEN_ LAST_NAME	NA	COMPOSITE VIEW	AA_PLEDGE_MATCHING	MATCH_EMPLOYER_NAME	NA
SPRTELE_INTL_ACCESS \|\| SPRTELE_PHONE_AREA \|\| SPRTELE_PHONE_NUMBER \|\| SPRTELE_PHONE_EXT	NA				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	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AA_ORGANIZATION_CONTACT AS_TELEPHONE	FAX_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED	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	COMPOSITE VIEW	AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_COURSE_OFFERING AS_MEETING_TIME AS_OFFERING_COREQ AS_STUDENT_COURSE_IN_PROGRESS	COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SSBSECT record.
SSRRTST_SUBJ_CODE_PREQ\|\|SSRRTST_CRSE_NUM B_PREQ	SSAPREQ	COMPOSITE VIEW	AS_OFFERING_PREREQ	PREREQ_COURSE_IDENTIFICATION	This concatenates the prerequisite course subject code with the prerequisite course number from the SSRRTST record.
SUBSTR(SPRIDEN_MI,1,1)	NA	COMPOSITE VIEW	AS_PERSON	MIDDLE_INITIAL	This function returns the middle initial.
SUM(AGRPDES_AMT_PAID)	TBD	COMPOSITE VIEW	AA_PLEDGE	PLEDGE_TRANS_AMOUNT_PAID
SUM(AMOUNT)	NA				This summarizes the amount SUM(TBRACCD_AMOUNT) for a given term, category code and detail code.
SUM(FPRRCDT_AMT_RCVD)	FPARCVD				NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY)	FPARCVD FPARTRN				NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD)	FPARCVD	COMPOSITE VIEW	AF_RECEIVED_ITEM	QUANTITY_RECEIVED_REJECTED	NA
SUM(FPRRCDT_QTY_RCVD)	FPARCVD				NA
SUM(FPRRTRN_QTY)	FPARCVD				Returns the sum of all quantities returned for a purchase order item.
SUM(PERJTOT_GRS)	NA	COMPOSITE VIEW	AP_EARNING_TOTALS_FY AP_EARNING_TOTALS_CY	TOTAL_EARNINGS_FISCAL_YEAR TOTAL_GROSS_CALENDAR_YEAR	This function returns the sum of the hours SUM(PERJTOT_GRS).
SUM(PERJTOT_HRS)	NA	COMPOSITE VIEW	AP_EARNING_TOTALS_FY AP_EARNING_TOTALS_CY	TOTAL_HOURS_FISCAL_YEAR TOTAL_HOURS_CALENDAR_YEAR	This function returns the sum of the hours SUM(PERJTOT_HRS).
SUM(RPRAWRD_ACCEPT_AMT)	NA	COMPOSITE VIEW	AR_AWARD_BY_FUND	ACCEPT_AMOUNT	SUM(RPRAWRD_ACCEPT_AMT)
SUM(RPRAWRD_AUTHORIZE_AMT)	NA	COMPOSITE VIEW	AR_AWARD_BY_FUND	AUTHORIZED_AMOUNT	NA
SUM(RPRAWRD_CANCEL_AMT)	NA	COMPOSITE VIEW	AR_AWARD_BY_FUND	CANCEL_AMOUNT	NA
SUM(RPRAWRD_DECLINE_AMT)	NA	COMPOSITE VIEW	AR_AWARD_BY_FUND	DECLINE_AMOUNT	NA
SUM(RPRAWRD_MEMO_AMT)	NA	COMPOSITE VIEW	AR_AWARD_BY_FUND	MEMO_AMOUNT	NA
SUM(RPRAWRD_OFFER_AMT)	NA	COMPOSITE VIEW	AR_AWARD_BY_FUND	OFFER_AMOUNT	NA
SUM(RPRAWRD_PAID_AMT)	NA	COMPOSITE VIEW	AR_AWARD_BY_FUND	PAID_AMOUNT	NA
SYSDATE BETWEEN SPRHOLD_FROM_DATE AND SPRHOLD_TO_DATE	NA
TBD	NA	COMPOSITE VIEW	AF_OPERATING_LEDGER AF_OPERATING_LEDGER	SUM_LAST_YEAR_ACTUAL CURR_PERIOD_LAST_YEAR_ACTUAL
TBLD	NA	COMPOSITE VIEW	AN_PERSONNEL_ACTION_LABOR_DIST	PAF_TRANSACTION_TYPE
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE1')	NA				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				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				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				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	COMPOSITE VIEW	AF_VENDOR_TAXABLE_REPORTING	TAX_YEAR
TO_CHAR (TO_DATE (FRRGRNH_FSYR_CODE, 'RR'), 'YYYY'	NA	COMPOSITE VIEW	AF_GRANT_DEFERRED_COST	FISCAL_YEAR
TO_CHAR(TBRACCD_CSHR_END_DATE, 'HH24:MM:SS')	NA				This calculation retrieves the 24 hour time from TBRACCD_CSHR_END_DATE.
TO_CHAR(TBRDEPO_CSHR_END_DATE, 'HH24:MM:SS')	NA				This calculation retrieves the 24 hour time from TBRDEPO_CSHR_END_DATE.
TO_CHAR(TBRMISD_CSHR_END_DATE, 'HH24:MM:SS')	NA				This calculation retrieves the 24 hour time from TBRMISD_CSHR_END_DATE.
TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'), 'YYYY')	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	FISCAL_YEAR	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	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	FISCAL_YEAR_HEADER	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				This calculation retrieves the 24 hour time from TRRACCD_CSHR_END_DATE.
TTBTAXN_AMOUNT_3 * -1	NA	COMPOSITE VIEW	AT_STUDENT_TAX_NOTIFICATION	PRIOR_YEAR_CHARGES_ADJUSTED
TTBTAXN_AMOUNT_5 * -1	NA	COMPOSITE VIEW	AT_STUDENT_TAX_NOTIFICATION	PRIOR_YR_SCHOLARSHIP_GRANT_ADJ

Ver: