Reporting View Source: CALCULATION

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

**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	REPORTING VIEW	APPL_OF_PAY_DETAIL_ACCOUNTING	APPLIED_AMOUNT	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)	FGIBDST	REPORTING VIEW	OPERATING_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.
(FGBOPAL_XX_ADOPT_BUD+ FGBOPAL_XX_BUD_ADJT)-( FGBOPAL_XX_YTD_ACTV+FGBOPAL_XX_ENCUMB+ FGBOPAL_XX_BUD_RSRV)	FGIBDST	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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.
(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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_APPROVED_ITEM_AMOUNT
(NVL(FPRPODT_QTY,0)*NVL( FPRPODT_CONVERT_UNIT_PRICE,0))+NVL( FPRPODT_CONVERT_ADDL_CHRG_AMT,0)+NVL( FPRPODT_CONVERT_TAX_AMT,0)-NVL( FPRPODT_CONVERT_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	REPORTING VIEW	PURCHASE_ORDER_ITEM PURCHASE_ORDER_ITEM_SUMMARY	APPROVED_ITEM_AMOUNT 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 - SUM( AARMINT_AMOUNT)	NA	REPORTING VIEW	MEMBERSHIP	MEMBERSHIP_DUES_AMOUNT_OWED	NA
AARMEMB_STATUS_OVERRIDE_IND	NA				NA
ADD_MONTHS	NBAFISC				This function returns the specified date NBBFISC_BEGIN_DATE plus the specified number of months.
AGBMGID_AMT - AGBMGID_AMT_PAID	NA	REPORTING VIEW	GIFT_MATCHING_TRANSACTION	MATCH_GIFT_BALANCE	NA
AGRGDES_AMT-F_GIFT_HARD_CREDIT	NA	REPORTING VIEW	GIFT	GIFT_CREDIT_AMOUNT	NA
AGRGPAY_AMT + A$_3RD_PARTY_CREDIT NOT TO EXCEED AGRPINS_AMT	NA				NA
AGRPDES_AMT-AGRPDES_AMT_PAID	NA	REPORTING VIEW	PLEDGE	PLEDGE_BALANCE	NA
AGRPDES_AMT-F_PLEDGE_HARD_CREDIT	NA	REPORTING VIEW	PLEDGE	PLEDGE_CREDIT	NA
AGRPDES_AMT_PAID - SUM(AGRPDES_AMT_PAID)	NA	REPORTING VIEW	PLEDGE_TRANSACTION	PLEDGE_TRANS_BALANCE
AORCONT_PHONE_AREA\|\|AORCONT_PHONE_NUMBER \|\|AORCONT_PHONE_EXT	NA	REPORTING VIEW	ORGANIZATION_CONTACT	PHONE_NUMBER_COMBINED	AORCONT_PHONE_AREA\|\|AORCONT_PHONE_NUMBER\|\|AORCONT_PHONE_EXT
CALCULATION(RCRAPP1_PAR_MRTL_STATUS)	NA
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID = 0 THEN 'Y' ELSE 'N'	NA	REPORTING VIEW	PLEDGE_TRANSACTION	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	REPORTING VIEW	PLEDGE_TRANSACTION	PLEDGE_TRANS_PARTIAL_PAID_IND
DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND)	NA	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	EXEMPTION_TYPE_DESC EXEMPTION_TYPE_DESC	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('AIDY','AIDY','AIDY',NULL)	NA				NA
DECODE('INST_AIDY','INST_AIDY', 'INST_AIDY',NULL)	NA				NA
DECODE(AGBMGID_DELETE_IND,'I','N','Y'),	NA				NA
DECODE(AGBMGID_DELETE_IND,NULL, DECODE( AGBMGID_STATUS,NULL,'W','P','P','I','I') ,'N'),	NA	REPORTING VIEW	GIFT_MATCHING GIFT_MATCHING_TRANSACTION	MATCH_GIFT_STATUS 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	REPORTING VIEW	GIFT_MATCHING GIFT_MATCHING_TRANSACTION	MATCH_GIFT_STATUS_DESC MATCH_GIFT_STATUS_DESC	NA
DECODE(AGRGAUX_ACC_REJ_IND,'A','ACCEPT', 'R','REJECT','NOT APPLICABLE'),	NA	REPORTING VIEW	GIFT_AUXILIARY	BENEFIT_ACCEPT_REJECT_DESC	NA
DECODE(AGRGDES_AMT, NULL, NULL, AGBGIFT_AMT_TOT)	NA
DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)	NA	REPORTING VIEW	PLEDGE_AUXILIARY PLEDGE_AUXILIARY	PLEDGE_ADJUSTMENT_IND PLEDGE_VOID_IND
DECODE(AGRPCON_MET_IND)	NA	REPORTING VIEW	PLEDGE_CONDITIONAL	CONDITION_MET_DESC
DECODE(AGRPDES_AMT-AGRPDES_AMT_PAID)	NA	REPORTING VIEW	PLEDGE	PLEDGE_FULLY_PAID_IND	NA
DECODE(AGRPDES_AMT_PAID)	NA	REPORTING VIEW	PLEDGE	PLEDGE_PARTIAL_PAID_IND	NA
DECODE(AMBPROP_STAFF_PIDM)	NA				This calculation checks whether the AMBPROP_STAFF_PIDM is NULL. If it is, it retrieves information based upon the AMBPROP_STAFF_IDEN_CODE. Otherwise, it uses the AMBPROP_STAFF_PIDM to retrieve the information.
DECODE(AMRPRRT_RATING_PIDM,NULL, AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM)	NA	REPORTING VIEW	ADVANCEMENT_RATING	RATER_UID	NA
DECODE(APRADEG_HOND_CODE_1)	NA	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME	DEPARTMENT_HONORS_COUNT
DECODE(APRADEG_HONR_CODE)	TBD	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME	INSTITUTIONAL_HONORS_COUNT
DECODE(APRADEG_SBGI_CODE, AUBINST_SBGI_CODE,'Y','N')	NA	REPORTING VIEW	DEGREE DEGREE_SLOT	INSTITUTION_IND INSTITUTION_IND	NA
DECODE(APRCSPS_MARS_IND,'A','ACTIVE', 'I','INACTIVE')	APACONS	REPORTING VIEW	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	REPORTING VIEW	GIFT_SOCIETY	LIFETIME_GIFT_SOCIETY_IND	NA
DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY', 'S','SECONDARY')	NA	REPORTING VIEW	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(ATVDONR_CFAE_1)	NA				NA
DECODE(ATVDONR_CFAE_2)	NA				NA
DECODE(ATVGIFT_CFAE_GIFT_CATG)	NA	REPORTING VIEW	GIFT GIFT_TRANSACTION	GIFT_VSE_DESC GIFT_VSE_DESC	NA
DECODE(BENEFICIARY_NAME)	NA	REPORTING VIEW	BENEFICIARY_DEPENDENT	BENEFICIARY_NAME	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(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL)	FAAINVE	REPORTING VIEW	INVOICE	REMIT_TO_STREET_LINE1	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL)	FAAINVE	REPORTING VIEW	INVOICE	REMIT_TO_STREET_LINE2	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL)	FAAINVE	REPORTING VIEW	INVOICE	REMIT_TO_STREET_LINE3	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_CITY, NULL)	FAAINVE	REPORTING VIEW	INVOICE	REMIT_TO_CITY	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_NATN, NULL)	FAAINVE	REPORTING VIEW	INVOICE	REMIT_TO_NATION	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_STATE, NULL)	FAAINVE	REPORTING VIEW	INVOICE	REMIT_TO_STATE_PROVINCE	NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ZIP, NULL)	FAAINVE	REPORTING VIEW	INVOICE	REMIT_TO_POSTAL_CODE	NA
DECODE(FABINVH_ATYP_CODE, NULL, TO_NUMBER(NULL), FABINVH_ATYP_SEQ_NUM)	FAAINVE	REPORTING VIEW	INVOICE	REMIT_TO_ADDRESS_TYPE_NUMBER	NA
DECODE(FABINVH_ATYP_CODE,NULL,'Y','N')	FAAINVE	REPORTING VIEW	INVOICE	ONE_TIME_VENDOR_ADDRESS_IND	NA
DECODE(FABINVH_INVOICE_TYPE_IND)	FAAINVE	REPORTING VIEW	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_VEND_CHECK_PIDM,NULL,'N', 'Y')	FAAINVE	REPORTING VIEW	INVOICE	THIRD_PARTY_ADDRESS_IND	NA
DECODE(FABINVH_VEND_PIDM, NULL, FABINVH_ONE_TIME_VEND_NAME, NULL)	FAAINVE				NA
DECODE(FFBMAST_SUBORDINATE_TYPE)	FFAMAST	REPORTING VIEW	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	REPORTING VIEW	FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_SOURCE	DEPRECIATION_POSTING_STATUS 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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	ENCUMBRANCE ENCUMBRANCE_ACCOUNTING	ENCUMBRANCE_STATUS DOCUMENT_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	REPORTING VIEW	ENDOWMENT_DISTRIBUTION ENDOWMENT_UNITS	RESTRICTION_TYPE_DESC 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)	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(FNVPOOL_STATUS_IND)	FNMPOOL	REPORTING VIEW	ENDOWMENT_DISTRIBUTION ENDOWMENT_UNITS	POOL_STATUS_DESC POOL_STATUS_DESC	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(FPBPOHD_MATCH_REQUIRED)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER	RECEIVING_REQUIRED_DESC
DECODE(FPBPOHD_PO_TYPE_IND)	FPAPURR	REPORTING VIEW	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	REPORTING VIEW	PURCHASE_ORDER	REQUISITION_OR_BID_SOURCE_DESC
DECODE(FPBPOHD_TEXT_IND)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER	REQUISITION_TEXT_DESC
DECODE(FPBRCDT_ADJUST_RECEIVE_IND)	FPARCVD	REPORTING VIEW	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	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	NSF_SUSPENSE_DESC
DECODE(FPRPODT_TEXT_USAGE)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	TEXT_USAGE_DESC
DECODE(FPRRCDT_PARTIAL_FINAL_IND)	FPARCVD	REPORTING VIEW	RECEIVED_ITEM	FINAL_RECEIPT_IND	Calculation determines if value is set to (P)artial or (F)inal.
DECODE(FPRRCDT_TOL_ORVERRIDE_IND)	NA				NA
DECODE(FRRBDET_ACCT_CLASS_CODE)	FRABDCN	REPORTING VIEW	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	REPORTING VIEW	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(FTVATTT_STATUS_IND)	FTMATTT	REPORTING VIEW	ACCOUNT_ATTRIBUTES ACCOUNT_TYPE_ATTRIBUTES ACTIVITY_ATTRIBUTES ATTRIBUTE_SETS CHART_ATTRIBUTES FUND_ATTRIBUTES FUND_TYPE_ATTRIBUTES LOCATION_ATTRIBUTES ORGANIZATION_ATTRIBUTES PROGRAM_ATTRIBUTES	ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC	This calculation will evaluate the column FTVATTT_STATUS_IND. If it is an A, it will return Active. Otherwise, it will return Inactive.
DECODE(FTVFBAL_REST_IND)	NA
DECODE(FTVFSPD_PRD_STATUS_IND)	NA
DECODE(FTVFSYR_EOY_ACCR_STATUS_IND)	NA
DECODE(FTVFUND_FBAL_IND)	NA	REPORTING VIEW	FUND_HIERARCHY	FUND_BALANCE_DESC
DECODE(FTVFUND_REST_IND)	NA	REPORTING VIEW	FUND_HIERARCHY	FUND_RESTRICTION_DESC
DECODE(FTVVEND_1099_RPT_ID)	FTMVEND	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	INTERNET_ADDRESS	INTERNET_ADDRESS_STATUS_DESC
DECODE(GORSGEO_SOURCE_IND,'S','N','Y')	NA	REPORTING VIEW	GEOGRAPHIC_REGION_INSTITUTION	GEOGRAPHIC_SOURCE_USER_IND	DECODE(GORSGEO_SOURCE_IND,'S','N','Y')
DECODE(GORSGEO_STATUS_IND,NULL,'A','I')	NA	REPORTING VIEW	GEOGRAPHIC_REGION_INSTITUTION	GEOGRAPHIC_REGION_STATUS	DECODE(GORSGEO_STATUS_IND,NULL,'A','I')
DECODE(GORSGEO_STATUS_IND,NULL,'ACTIVE', 'INACTIVE')	NA	REPORTING VIEW	GEOGRAPHIC_REGION_INSTITUTION	GEOGRAPHIC_REGION_STATUS_DESC	DECODE(GORSGEO_STATUS_IND,NULL,'Active','Inactive')
DECODE(GURMAIL_DATE_PRINTED,NULL,'Y', 'N')	NA	REPORTING VIEW	COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	PENDING_LETTER_IND PENDING_LETTER_IND1 PENDING_LETTER_IND2 PENDING_LETTER_IND3 PENDING_LETTER_IND4 PENDING_LETTER_IND5	NA
DECODE(GURMAIL_MISC_DATE,NULL, GURMAIL_DATE_PRINTED)	NA				NA
DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')	SUAMAIL	REPORTING VIEW	COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	COMMUNICATION_TYPE_DESC COMMUNICATION_TYPE_DESC1 COMMUNICATION_TYPE_DESC2 COMMUNICATION_TYPE_DESC3 COMMUNICATION_TYPE_DESC4 COMMUNICATION_TYPE_DESC5	NA
DECODE( I105RNROVRD_F_SSN_NO_DOB_REJ_OVRD	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_S_IND
DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	DEPENDENCY_OVERRIDE_DESC
DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C', CANCELLED,'F',FROZEN,'I',INACTIVE)	NA	REPORTING VIEW	POSITION_DEFINITION	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	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	POSITION_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	REPORTING VIEW	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	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	POSITION_STATUS_DESC POSITION_STATUS_DESC POSITION_STATUS_DESC 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	REPORTING VIEW	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	REPORTING VIEW	PAYROLL_DISTRIBUTION POSITION_BUDGET	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	REPORTING VIEW	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	REPORTING VIEW	PAYROLL_DISTRIBUTION	NORMALIZED_TRANSACTION_AMOUNT	NA
DECODE(NVL(AGVPLG1_PLEDGE_AMOUNT,0) - NVL(AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'Y', 'N'),	NA				NA
DECODE(NVL(AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'N', NVL(AGVPLG1_PLEDGE_AMOUNT,0) , 'N','Y')	NA				NA
DECODE(PAYROLL_DEDUCTION)	NA	REPORTING VIEW	YEARLY_DEDUCTION YEARLY_DEDUCTION	EMPLOYER_CONTRIBUTION_YTD GROSS_COMPENSATION_YTD	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	REPORTING VIEW	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	REPORTING VIEW	TAX	STATUS_DESC	NA
DECODE(PEBEMPL_1042_RECIPIENT_CD)	NA	REPORTING VIEW	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	REPORTING VIEW	EMPLOYEE	PUBLIC_RETIREMENT_MEMBER_DESC
DECODE(PEBEMPL_EMPL_STATUS)	NA	REPORTING VIEW	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)	TBD	REPORTING VIEW	EMPLOYEE	FAIR_LABOR_STANDARDS_TYPE_DESC
DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED, N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT)	NA	REPORTING VIEW	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	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_DECISION_DESC APPOINTMENT_DECISION_DESC	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	REPORTING VIEW	FACULTY_TRACKING	PRIMARY_ACTIVITY_DESC	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	REPORTING VIEW	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	REPORTING VIEW	FACULTY_TRACKING	RANK_DECISION_DESC	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	REPORTING VIEW	FACULTY_TRACKING	SABBATICAL_DECISION_DESC	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	REPORTING VIEW	LEAVE_ACCRUAL	PAYROLL_CALCULATION_TYPE_DESC	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	REPORTING VIEW	PAYROLL_ATTENDANCE	TIMESHEET_METHOD_DESC
DECODE(PHRDOCM_DOC_TYPE)	NA	REPORTING VIEW	PAYROLL_DOCUMENT	DIRECT_DEPOSIT_IND	DECODE(PHRDOCM_DOC_TYPE, 'C', 'N', 'D', 'Y')
DECODE(PHRELBD_TS_ROSTER_IND)	NA	REPORTING VIEW	PAYROLL_LABOR_DIST_OVERRIDE	TIMESHEET_METHOD_DESC
DECODE(PHRHIST_CALC_IND)	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	PAYROLL_CALCULATION_TYPE_DESC PAYROLL_CALCULATION_TYPE_DESC	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	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	DOCUMENT_PRINT_METHOD_DESC DOCUMENT_PRINT_METHOD_DESC	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)	PHILIST	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION	PAYROLL_EVENT_TYPE_DESC
DECODE(PHRJOBS_TIME_ENTRY_IND)	NA	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	TIME_ENTRY_TYPE_DESC TIME_ENTRY_TYPE_DESC	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	REPORTING VIEW	PAYROLL_EARNING PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	TIMESHEET_METHOD_DESC TIMESHEET_METHOD_DESC TIMESHEET_METHOD_DESC	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	REPORTING VIEW	PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET	POSITION_CONTRACT_TYPE_DESC POSITION_CONTRACT_TYPE_DESC	NA
DECODE(POSITION_CLASS_EXEMPTION_IND)	NA
DECODE(PTRBDCA_CALC_RULE)	NA	REPORTING VIEW	PAYROLL_DEDUCTION	TAX_DEDUCTION_IND	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	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	OLDER_THAN_24_IND
DECODE(RCRAPP1_CITZ_IND)	NA	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	CITIZENSHIP_ELIGIBIL_TYPE_DESC
DECODE(RCRAPP1_DEGREE_BY_JULY)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	DEGREE_BY_JULY_IND
DECODE(RCRAPP1_EXP_ENROLL_STATUS)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS	EXPECTED_ENROLL_STATUS_DESC
DECODE(RCRAPP1_HAS_LEGAL_DEPEND)	RNANAXX RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	LEGAL_DEPENDENT_IND
DECODE(RCRAPP1_HOUS_CDE_1)	RNASUXX
DECODE(RCRAPP1_HOUS_CDE_2)	RNASUXX
DECODE(RCRAPP1_HOUS_CDE_3)	RNASUXX
DECODE(RCRAPP1_HOUS_CDE_4)	RNASUXX
DECODE(RCRAPP1_HOUS_CDE_5)	RNASUXX
DECODE(RCRAPP1_HOUS_CDE_6)	RNASUXX
DECODE(RCRAPP1_HOUS_CDE_7)	RNASUXX
DECODE(RCRAPP1_HOUS_CDE_8)	RNASUXX
DECODE(RCRAPP1_INS)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PERM_RESIDENCY_CONFIRMED_IND
DECODE(RCRAPP1_INST_HOUS_CDE)	RNANAXX RNASUXX	REPORTING VIEW	NEED_ANALYSIS	HOUSING_DESC
DECODE(RCRAPP1_INST_HOUS_CDE)`	RNANAXX RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	HOUSING_DESC
DECODE(RCRAPP1_LINE2_ATTEND_COLL)	RNASUXX
DECODE(RCRAPP1_LINE2_RELSHIP)	RNASUXX
DECODE(RCRAPP1_LINE3_ATTEND_COLL)	RNASUXX
DECODE(RCRAPP1_LINE3_RELSHIP)	RNASUXX
DECODE(RCRAPP1_LINE4_ATTEND_COLL)	RNASUXX
DECODE(RCRAPP1_LINE4_RELSHIP)	NA
DECODE(RCRAPP1_LINE5_ATTEND_COLL)	RNASUXX
DECODE(RCRAPP1_LINE5_RELSHIP)	NA
DECODE(RCRAPP1_LINE6_ATTEND_COLL)	RNASUXX
DECODE(RCRAPP1_LINE6_RELSHIP)	RNASUXX
DECODE(RCRAPP1_LINE7_ATTEND_COLL)	RNASUXX
DECODE(RCRAPP1_LINE7_RELSHIP)	RNASUXX
DECODE(RCRAPP1_LINE8_ATTEND_COLL)	RNASUXX
DECODE(RCRAPP1_LINE8_RELSHIP)	RNASUXX
DECODE(RCRAPP1_MRTL_STATUS)	NA	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	MARITAL_STATUS_DESC
DECODE(RCRAPP1_PAR_DIV_SEP_REM_IND)	RNASUXX
DECODE(RCRAPP1_PAR_HOUS_STAT)	RNASUXX
DECODE(RCRAPP1_PAR_MRTL_STATUS)	RNANAXX RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PARENT_MARITAL_STATUS_DESC
DECODE(RCRAPP1_PAR_TAX_FORM_IND)	RNAPRXX RNANAXX	REPORTING VIEW	NEED_ANALYSIS	PARENT_TAX_RETURN_TYPE_DESC
DECODE(RCRAPP1_PERMIT_DRAFT_REG)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PERMIT_DRAFT_REGISTRATION_IND
DECODE(RCRAPP1_RQST_FA_FALL_THIS_YR)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	REQUESTED_AID_FALL_DESC
DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	REQUESTED_AID_SPRING_DESC
DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	REQUESTED_AID_NEXT_SUMMER_DESC
DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	REQUESTED_AID_PREC_SUMMER_DESC
DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	REQUESTED_AID_WINTER_DESC
DECODE(RCRAPP1_SIGNED)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_DEMOGRAPHIC	APPLICATION_SIGNED_BY APPLICATION_SIGNED_BY_DESC
DECODE(RCRAPP1_TAX_FORM_IND)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS	TAX_RETURN_TYPE_DESC
DECODE(RCRAPP1_TITLE)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	NAME_PREFIX
DECODE(RCRAPP1_US_VET)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	VETERAN_IND
DECODE(RCRAPP1_VERIFICATION_MSG)	RNARSXX RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SELECTED_FOR_VERIFICATION_IND
DECODE(RCRAPP1_WARD_OF_COURT)	TBD
DECODE(RCRAPP1_YR_IN_COLL)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS	YEAR_IN_COLLEGE_DESC
DECODE(RCRAPP2_C_1_ANLY_TYPE)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_ANALYSIS_TYPE_DESC
DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_FEDERAL_METHOD	FM_CONTRIBUTION_OFFICIAL_DESC FM_CONTRIBUTION_OFFICIAL_DESC
DECODE(RCRAPP2_C_1_VA_BEN_INCL)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_VETERAN_BENEFITS_IND
DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_CONTRIBUTION_OFFICIAL_DESC
DECODE(RCRAPP2_C_2_VA_BEN_INCL)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_VETERAN_BENEFITS_IND
DECODE(RCRAPP2_C_DEPEND_STATUS)	NA	REPORTING VIEW	NEED_ANALYSIS	DEPENDENCY_STATUS_DESC
DECODE(RCRAPP2_C_MRTL_STATUS)	TBD
DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_PARENT_ANALYSIS_TYPE_DESC
DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_FEDERAL_METHOD	IM_PARENT_CONTRIB_OFF_DESC FM_PARENT_CONTRIB_OFF_DESC
DECODE(RCRAPP2_C_PAR_2_CTRB_FR_ASSET)	RNINAIQ
DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_PARENT_CONTRIB_OFF_DESC
DECODE(RCRAPP2_C_PAR_MRTL_STATUS)	TBD
DECODE(RCRAPP2_ELIGIBILITY_MSG)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC	SAR_C_IND SAR_C_IND
DECODE(RCRAPP2_IM_1_ANLY_TYPE)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_ANALYSIS_TYPE_DESC
DECODE(RCRAPP2_IM_1_PAR_ANLY_TYPE)	NA	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_PARENT_ANALYSIS_TYPE_DESC
DECODE(RCRAPP2_MODEL_CDE)	ROASTAT	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS NEED_ANALYSIS	DEPENDENCY_INDEPEND_DESC FAMILY_IN_COLLEGE FAMILY_SIZE
DECODE(RCRAPP2_MODULE_CD)	NA
DECODE(RCRAPP2_PELL_ANLY_TYPE)	RNIMSXX
DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_EST_CONTRIB_OFFICIAL_DESC
DECODE(RCRAPP2_PELL_PGI_OFFL_EST)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	PELL_EFC_OFFICIAL_DESC
DECODE(RCRAPP2_PELL_P_ANLY_TYPE)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_PARENT_EST_ANAL_TYPE_DESC
DECODE(RCRAPP3_C_SIGNED)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SIGNATURE_IND
DECODE(RCRAPP3_C_SIGNED_FATH)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	FATHER_SIGNATURE_IND
DECODE(RCRAPP3_C_SIGNED_MOTH)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	MOTHER_SIGNATURE_IND
DECODE(RCRAPP3_C_SIGNED_SPS)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SPOUSE_SIGNATURE_IND
DECODE(RCRAPP3_DEGREE_TYPE)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC	DEGREE_TYPE_DESC DEGREE_TYPE_DESC
DECODE(RCRAPP3_FAA_DEP_OVERRIDE)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS	DEPENDENCY_OVERRIDE_DESC
DECODE(RCRAPP3_FATH_SSN_MATCH)	RNANAXX RNARSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	FATHER_TAX_ID_MATCH_DESC
DECODE(RCRAPP3_GRAD_OR_PROF)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC	GRADUATE_PROFESSIONAL_IND GRADUATE_PROFESSIONAL_IND
DECODE(RCRAPP3_LIVE_ON_FARM)	RNAPRXX
DECODE(RCRAPP3_MARRIED)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS	MARITAL_STATUS_IND
DECODE(RCRAPP3_MOTH_SSN_MATCH)	RNANAXX RNARSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	MOTHER_TAX_ID_MATCH_DESC
DECODE(RCRAPP3_OFFL_UNOFFL_IND)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC	OFFICIAL_SOURCE_IND OFFICIAL_SOURCE_IND
DECODE(RCRAPP3_PAR_LIVE_ON_FARM)	RNAPRXX
DECODE(RCRAPP3_PREPARER_SIGN)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PREPARER_SIGNATURE_IND
DECODE(RCRAPP3_SOC_SEC)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC	TAX_ID_MATCH_STATUS_DESC TAX_ID_MATCH_STATUS_DESC
DECODE(RCRAPP3_YR_IN_COLL_2)	RNASUXX
DECODE(RCRAPP4_1040A_ELIG_IND)	RNAPRXX RNANAXX	REPORTING VIEW	NEED_ANALYSIS	SHORT_TAX_FORM_IND
DECODE(RCRAPP4_ADDRESS_CHG_FLAG)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	ADDRESS_CHANGE_DESC
DECODE(RCRAPP4_CUSTODIAL_PARENT)	RNASUXX RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_CUSTODIAL_PARENT_DESC
DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	PELL_EFC_OFFICIAL_EST_DESC
DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_PARENT_CONTRIB_OFF_EST_DESC
DECODE(RCRAPP4_DRUG_OFFENSE_CONVIC)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	AID_ELIGIBILITY_RESPONSE_DESC
DECODE(RCRAPP4_DUP_SSN_IND)	RNIMSXX
DECODE(RCRAPP4_EFC_CHANGE_IND)	RNIMSXX
DECODE(RCRAPP4_FEE_WAIVER_IND)	TBD
DECODE(RCRAPP4_FORMULA_FOR_CALC)	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_FORMULA_DESC
DECODE(RCRAPP4_HAVE_CHILDREN)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS	SUPPORT_CHILDREN_IND
DECODE(RCRAPP4_HS_GED_RCVD)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SECONDARY_SCHOOL_DIPLOMA_IND
DECODE(RCRAPP4_LEGAL_RES_IND)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	LEGAL_RESIDENT_IND
DECODE(RCRAPP4_LOAN_INT)	RNANAXX
DECODE(RCRAPP4_NSLDS_MATCH)	RNANAXX
DECODE(RCRAPP4_PAR_1040A_ELIG_IND)	RNAPRXX RNANAXX	REPORTING VIEW	NEED_ANALYSIS	PARENT_SHORT_TAX_FORM_IND
DECODE(RCRAPP4_PAR_LEGAL_RES_IND)	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PARENT_LEGAL_RESIDENT_IND
DECODE(RCRAPP4_PAR_TAX_RET_FILED_IND)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	PARENT_TAX_RETURN_FILED_DESC
DECODE(RCRAPP4_PAR_TX_RET_FILED_IND)	RNAPRXX
DECODE(RCRAPP4_SAR_C_CHANGE_FLAG)	RNIMSXX
DECODE(RCRAPP4_SEC_INS_MATCH_IND)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PERM_RESIDENCY_VER_STATUS_DESC
DECODE(RCRAPP4_SOURCE_CORRECTION)	RNIMSXX
DECODE(RCRAPP4_SSA_CITIZEN_IND)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	CITIZENSHIP_TYPE_DESC
DECODE(RCRAPP4_SS_MATCH)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	MILITARY_REGIST_STATUS_DESC
DECODE(RCRAPP4_SS_REG_FLAG)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	MILITARY_REG_REQ_STATUS_DESC
DECODE(RCRAPP4_TX_RET_FILED_IND)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	TAX_RETURN_FILED_DESC
DECODE(RCRAPP4_TYPE_DATA_AVAIL)	RNINAIQ
DECODE(RCRAPP4_VA_MATCH_FLAG)	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	VETERAN_MATCH_STATUS_DESC
DECODE(RCRAPP4_VISA_CLASS)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	VISA_CLASSIFICATION_DESC
DECODE(RCRAPP4_WORK_STUDY)	RNANAXX
DECODE(RCRESAR_AUTO_ZERO_EFC_FLAG)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	AUTOMATIC_ZERO_EFC_IND
DECODE(RCRESAR_A_BORN_BEFORE_IND)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	OLDER_THAN_24_IND
DECODE(RCRESAR_A_CITZ_IND)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ASSUMED_CITIZENSHIP_DESC
DECODE(RCRESAR_A_MARRIED)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ASSUMED_MARRIED_IND
DECODE(RCRESAR_A_MRTL_STATUS_IND)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MARITAL_STATUS_IND
DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	PARENT_MARITAL_STATUS_IND
DECODE(RCRESAR_A_PAR_TAX_FILED_IND)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	PARENT_TAX_FILER_IND
DECODE(RCRESAR_A_S_DEPENDANTS)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ASSUMED_DEPENDENT_IND
DECODE(RCRESAR_A_TAX_FILED_IND)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	TAX_FILER_IND
DECODE(RCRESAR_A_VA_STATUS)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ASSUMED_VETERAN_IND
DECODE(RCRESAR_DUP_REQ_IND)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	DUPLICATE_REQUEST_IND
DECODE(RCRESAR_EDE_ETI_IND)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ISIR_ELECT_TRANSACTION_DESC
DECODE(RCRESAR_EDE_INST_IND)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	ELECT_APPL_ENTRY_SOURCE_IND
DECODE(RCRESAR_FED_HOUS_CDE_1)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING1_DESC
DECODE(RCRESAR_FED_HOUS_CDE_2)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING2_DESC
DECODE(RCRESAR_FED_HOUS_CDE_3)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING3_DESC
DECODE(RCRESAR_FED_HOUS_CDE_4)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING4_DESC
DECODE(RCRESAR_FED_HOUS_CDE_5)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING5_DESC
DECODE(RCRESAR_FED_HOUS_CDE_6)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	FEDERAL_HOUSING6_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_1)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG1_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_2)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG2_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_3)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG3_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_4)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG4_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_5)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG5_DESC
DECODE(RCRESAR_M_SCHOOL_FLAG_6)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	MULTI_SCHOOL_FLAG6_DESC
DECODE(RCRESAR_REC_TYPE)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	PROCESSED_RECORD_TYPE_DESC
DECODE(RCRESAR_SEC_EFC_TYPE)	NA	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	SECONDARY_EFC_TYPE_DESC
DECODE(RCRESAR_SUB_APP)	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	SUBSEQUENT_APPLICATION_IND
DECODE(RCRIMP1_AID_STATUS)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	FINANCIAL_AID_STATUS_DESC
DECODE(RCRIMP1_APPLIC_TYPE)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_PROFILE_SPECIFIC	APPLICATION_TYPE_DESC APPLICATION_TYPE_DESC
DECODE(RCRIMP1_FIN_AID_STATUS)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	FINANCIAL_AID_STATUS_DESC
DECODE(RCRIMP1_FOREIGN_ADDR_IND)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_PROFILE_SPECIFIC	FOREIGN_ADDRESS_IND FOREIGN_ADDRESS_IND
DECODE(RCRIMP1_HOUS_CDE_10)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	HOUSING10_DESC
DECODE(RCRIMP1_HOUS_CDE_9)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	HOUSING9_DESC
DECODE(RCRIMP1_LINE2_SCHL_TYPE)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	LINE2_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE3_SCHL_TYPE)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	LINE3_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE4_SCHL_TYPE)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	LINE4_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE5_SCHL_TYPE)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	LINE5_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE6_SCHL_TYPE)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	LINE6_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE7_SCHL_TYPE)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	LINE7_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LINE8_SCHL_TYPE)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	LINE8_SCHOOL_TYPE_DESC
DECODE(RCRIMP1_LOCATION_COMPUTER)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	PROFILE_COMPUTER_LOCATION_DESC
DECODE(RCRIMP1_ONLINE_SIG)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	ONLINE_SIGNATURE_IND
DECODE(RCRIMP1_OWN_BUS_HM_SELF_EMP)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	IM_SELF_EMPLOYED_IND
DECODE(RCRIMP1_PAR_NTRL_SEP_DIV)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	PARENT_MARIT_STAT_SEP_DIV_DESC
DECODE(RCRIMP1_PAR_OWN_BUS_FARM)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	PARENT_OWN_BUSINESS_IND
DECODE(RCRIMP1_PAR_SELF_EMPLOYED)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	IM_PARENT_SELF_EMPLOYED_IND
DECODE(RCRIMP1_PAR_SMALL_BUSINESS)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	IM_PARENT_LARGE_BUSINESS_IND
DECODE(RCRIMP1_SMALL_BUSINESS)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	IM_LARGE_BUSINESS_IND
DECODE(RCRIMP1_STU_LIVES_WITH)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	PARENT_STUDENT_LIVE_PRIM_DESC
DECODE(RCRIMP1_STU_MOST_SUPPORT_FROM)	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	PARENT_SUPPORT_PRIMARY_DESC
DECODE(RCRIMP1_TRUST_AVAIL_IND)	RNAPRXX RNASUXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	TRUST_AVAILABILITY_IND
DECODE(RCRIMP1_TRUST_ESTAB_BY)	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_PROFILE_SPECIFIC	TRUST_ESTABLISHER_DESC
DECODE(RNROVRD_ADD_BK_HOPE_OPT)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_ADD_HOPE_LL_IND
DECODE(RNROVRD_ALLOW_IM_PC_LOWR_FM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_LOWER_THAN_FM_IND
DECODE(RNROVRD_ALLOW_IM_SC_LOWR_FM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_LOWER_THAN_FM_IND
DECODE(RNROVRD_CALC_US_TAX_FM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_STUD_CALC_FED_TAX_OVR_IND
DECODE(RNROVRD_CALC_US_TAX_IM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_CALC_FEDERAL_TAX_OVR_DESC
DECODE(RNROVRD_CHG_DEPEND_FM)	NA	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_CHANGE_DEPENDENCY_STAT_DESC
DECODE(RNROVRD_CHG_DEPEND_IM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_CHANGE_DEPENDENCY_STAT_DESC
DECODE(RNROVRD_FAMILY_ASSETS)	NA	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_ASSET_COMBINED_DESC
DECODE(RNROVRD_FM_PAR_NUM_COL)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_PARENT_NO_COLLEGE_OVR_IND
DECODE(RNROVRD_F_SSN_NO_DOB_REJ_OVRD)	RNAOVXX
DECODE(RNROVRD_F_SSN_NO_NAME_REJ_OVRD)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_E_IND
DECODE(RNROVRD_HOME_VAL_PROJ)	NA	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_HOME_VALUE_PROJ_DESC
DECODE(RNROVRD_INV_PROJ)	NA	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_IMPUTE_ASSET_DESC
DECODE(RNROVRD_LIMIT_PC_BY_BDGT)	NA	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	LIMIT_OTHERS_SHARE_PC_DESC
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_T_IND
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD_	RNAOVXX
DECODE(RNROVRD_M_SSN_NO_NAME_REJ_OVRD)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_F_IND
DECODE(RNROVRD_NON_CUST_OPT)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_NONCUS_CONT_CAL_DESC
DECODE(RNROVRD_NON_CUST_PC_OPT)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_USE_NONCUSTODIAL_PC_IND
DECODE(RNROVRD_PAR_ADD_BK_HOPE_OPT)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_ADD_HOPE_LL_IND
DECODE(RNROVRD_PAR_AGI_OPT)	NA	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_WHICH_AGI_DESC
DECODE(RNROVRD_PAR_CALC_US_TAX_FM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_PARENT_CALC_FED_TAX_OVR_IND
DECODE(RNROVRD_PAR_CALC_US_TAX_IM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_CALC_FED_TAX_OV_DESC
DECODE(RNROVRD_PAR_USE_PROJ_INC_EFM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_EFM_EST_INCOME_IND
DECODE(RNROVRD_SKIP_AGE_EXCL)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_SKIP_AGE_EXCLUSION_IND
DECODE(RNROVRD_SSN_NO_DOB_REJ_OVRD)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_R_IND
DECODE(RNROVRD_SSN_NO_NAME_REJ_OVRD)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	FM_REJECT_D_IND
DECODE(RNROVRD_S_HOME_VAL_PROJ)	NA	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_HOME_VALUE_PROJECT_DESC
DECODE(RNROVRD_USE_PROJ_INC_EFM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_EFM_ESTIMATED_INCOME_IND
DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	USE_PARENT_STATE_PROV_TAX_IND
DECODE(RNROVRD_ZERO_LOSS_BUS_FARM)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_ZERO_LOSS_BUS_IND
DECODE(RNROVRD_ZERO_LOSS_OTH)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_ZERO_LOSS_OTH_IND
DECODE(RPRADSB_ALTERNATE_PELL_IND,'N')	ROAPELL	REPORTING VIEW	AWARD_DISBURSEMENT	ALTERNATE_PELL_PAY_SCHED_IND
DECODE(RPRADSB_CONCUR_ENROLL_FLAG)	NA	REPORTING VIEW	AWARD_DISBURSEMENT	COD_CONCURRENT_ENROLLMENT_IND
DECODE(RPRADSB_DEBIT_CREDIT_IND)	RPRADSB	REPORTING VIEW	AWARD_DISBURSEMENT	DEBIT_CREDIT_DESC
DECODE(RPRADSB_DISBURSE_LOAD)	RPAAWRD	REPORTING VIEW	AWARD_DISBURSEMENT	DISBURSEMENT_LOAD_DESC
DECODE(RPRADSB_DISBURSE_LOAD_OPT)	RPRADSB	REPORTING VIEW	AWARD_DISBURSEMENT	DISBURSEMENT_LOAD_OPT_DESC
DECODE(RPRADSB_DISB_ACPT_DEBIT_CR_IND)	RPRADSB	REPORTING VIEW	AWARD_DISBURSEMENT	COD_DEBIT_CREDIT_DESC
DECODE(RPRADSB_DISB_ACTION_CODE)	RPRADSB	REPORTING VIEW	AWARD_DISBURSEMENT	COD_DISBURSEMENT_ACTION_DESC
DECODE(RPRADSB_PELLC_DISB_LOAD)	RPAAWRD	REPORTING VIEW	AWARD_DISBURSEMENT	PELL_CALCULATED_DISB_LOAD_DESC
DECODE(RPRADSB_PELLC_DISB_LOAD_OPT)	RPRADSB	REPORTING VIEW	AWARD_DISBURSEMENT	PELL_CALC_DISB_LOAD_OPT_DESC
DECODE(RPRADSB_POTENTIAL_OVERPMT_FLAG)	NA	REPORTING VIEW	AWARD_DISBURSEMENT	COD_POTENTIAL_OVERPAYMENT_IND
DECODE(RPRADSB_SHARED_SAR_ID_FLAG)	NA	REPORTING VIEW	AWARD_DISBURSEMENT	COD_SHARED_SAR_IDENTIFIER_IND
DECODE(RPRARSC_TYPE_CODE)	RPAARSC	REPORTING VIEW	APPLICANT_RESOURCE	RESOURCE_TYPE_DESC
DECODE(RPRATRM_LOCK_IND)	TBD	REPORTING VIEW	AWARD_BY_PERSON	AWARD_LOCKED_DESC
DECODE(RPRATRM_NSLDS_OVRD_IND)	TBD	REPORTING VIEW	AWARD_BY_PERSON	STUDENT_LOAN_OVERRIDE_DESC
DECODE(RPRATRM_PCKG_LOAD_IND)	TBD	REPORTING VIEW	AWARD_BY_PERSON	TIME_STATUS_DESC
DECODE(RPRATRM_PELL_AWRD_LOAD_OPT)	TBD	REPORTING VIEW	AWARD_BY_PERSON	PELL_AWARD_ENROLLMENT_OPT_DESC
DECODE(RPRAWRD_LOCK_IND)	TBD	REPORTING VIEW	AWARD_BY_PERSON	ANNUAL_AWARD_LOCKED_DESC
DECODE(RPRAWRD_OVERRIDE_YR_IN_COLL)	TBD	REPORTING VIEW	AWARD_BY_PERSON	ACADEMIC_YEAR_OVERRIDE_DESC
DECODE(RPRAWRD_SYS_IND)	TBD	REPORTING VIEW	AWARD_BY_PERSON	SYSTEM_DESC
DECODE(RPRAWRD_UNMET_NEED_OVRDE_IND)	TBD	REPORTING VIEW	AWARD_BY_PERSON	UNMET_NEED_OVERRIDE_DESC
DECODE(RPRLADB_DISBURSE_LOAD)	RPALDSB	REPORTING VIEW	LOAN_DISBURSEMENT	ENROLLMENT_LOAD_DESC
DECODE(RPRLADB_DISBURSE_LOAD_OPT)	RPALDSB	REPORTING VIEW	LOAN_DISBURSEMENT	ENROLLMENT_LOAD_OPTION_DESC
DECODE(RPRLADB_DISB_STATUS)	RPALORG	REPORTING VIEW	LOAN_DISBURSEMENT	DISBURSEMENT_PROC_STATUS_DESC
DECODE(RPRLADB_FEED_IND)	NA	REPORTING VIEW	LOAN_DISBURSEMENT	DISBURSEMENT_FEED_DESC
DECODE(RPRLADB_HOLD_REL_STATUS)	RPAELAP	REPORTING VIEW	LOAN_DISBURSEMENT	HOLD_RELEASE_STATUS_DESC
DECODE(RPRLADB_SERV_TRANS_TYPE)	NA	REPORTING VIEW	LOAN_DISBURSEMENT	TRANSACTION_TYPE_DESC
DECODE(RPRLAPP_COSIGN1_RELATION_IND)	NA	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	LOAN_APPLICATION LOAN_DISBURSEMENT	DEFAULT_IND_DESC DEFAULT_IND_DESC
DECODE(RTVFSRC_IND)	NA				NA
DECODE(RTVFTYP_ATYP_IND)	NA	REPORTING VIEW	AWARD_BY_FUND AWARD_BY_FUND AWARD_BY_PERSON AWARD_BY_PERSON FINAID_FUND FINAID_FUND FINAID_FUND	GIFT_OR_SELF_HELP_AID GIFT_OR_SELF_HELP_AID_DESC GIFT_OR_SELF_HELP_AID GIFT_OR_SELF_HELP_AID_DESC FINANCIAL_AID_TYPE_DESC GIFT_OR_SELF_HELP_AID GIFT_OR_SELF_HELP_AID_DESC	NA
DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME')	SAAADMS	REPORTING VIEW	GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT	INTENDED_TIME_STATUS_DESC INTENDED_TIME_STATUS_DESC	NA
DECODE(SFBETRM_PIDM, NULL, 'N', 'Y')	NA	REPORTING VIEW	ENROLLMENT	ENROLLMENT_EXISTS_IND
DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y')	SFASLST	REPORTING VIEW	STUDENT_COURSE	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	REPORTING VIEW	STUDENT_COURSE	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	REPORTING VIEW	STUDENT_COURSE	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_LEVL_CODE,NULL,'N','Y')	SGASTDN				This function returns an N if the student level code SGBSTDN_LEVL_CODE is null else it returns a Y.
DECODE(SGBSTDN_LEVL_CODE,NULL,'N','Y'), DECODE(SORLCUR_LEVL_CODE,NULL,'N','Y'), 'N')	NA
DECODE(SGBSTDN_LEVL_CODE,NULL,NULL,'01')	SGASTDN				This function returns a null if the student level code SGBSTDN_LEVL_CODE is null else it returns a 01.
DECODE(SGBSTDN_LEVL_CODE_2,NULL,NULL, '02')	SGASTDN				This function returns a null if the student secondary level code SGBSTDN_LEVL_CODE_2 is null else it returns a 02.
DECODE(SGBSTDN_TERM_CODE_ADMIT)	TBD
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL, 'N','Y')	SGASTDN				This function returns an N if the matriculated academic period is null 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	REPORTING VIEW	STUDENT STUDENT_EXTENDED	ACADEMIC_STUDY_MATRIC_IN_COUNT ACADEMIC_STUDY_MATRIC_IN_COUNT	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				DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,N,Y)
DECODE(SHRATTR_PIDM, NULL, 'N', 'Y')	NA	REPORTING VIEW	STUDENT_COURSE_ATTRIBUTE	INSTITUTION_COURSE_IND	NA
DECODE(SHRDGDH_HOND_CODE,NULL,NULL,'D')	SHADEGR				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				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	REPORTING VIEW	GPA GPA_BY_LEVEL	GPA_TYPE_DESC 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	REPORTING VIEW	STUDENT_COURSE_ATTRIBUTE	TRANSFER_COURSE_IND	NA
DECODE(SHRTATT_PIDM, NULL, 'Y', 'N')	NA				NA
DECODE(SHRTGPA_GPA_TYPE_IND,'I', 'INSTITUTION','T','TRANSFER')	NA	REPORTING VIEW	GPA GPA_BY_TERM	GPA_TYPE_DESC 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	REPORTING VIEW	STUDENT_COURSE	TRANSFER_COURSE_IND	This function returns a N if the transfer course record SHRTRCE doesn't exist, else a Y.
DECODE(SHRTTRM_RECORD_STATUS_IND)	NA	REPORTING VIEW	STUDENT STUDENT_EXTENDED	GRADE_MAILER_STATUS_DESC GRADE_MAILER_STATUS_DESC
DECODE(SIBFACD_PRIMARY_ACTIVITY)	TBD	REPORTING VIEW	FACULTY	PRIMARY_ACTIVITY_DESC
DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C', 'CLASS','OTHER')	SLARASG	REPORTING VIEW	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	REPORTING VIEW	CONTACT	INTERVIEWER_NAME	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)	TBD	REPORTING VIEW	INSTITUTION_DEMOGRAPHIC	APPROVED_IND	DECODE(SORBACD_STATE_APPROV_IND,'Y','Y','N')
DECODE(SORDEGR_HONR_CODE)	TBD
DECODE(SORDEGR_SBGI_CODE)	NA	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME	TRANSFER_WORK_EXISTS_IND
DECODE(SORLCUR_ADMT_CODE)	NA				DECODE(SORLCUR_ADMT_CODE,NULL,SGBSTDN_ADMT_CODE,SORLCUR_ADMT_CODE)
DECODE(SORLCUR_LEVL_CODE,NULL,'N','Y')	NA				This function returns an N if the student level code SORLCUR_LEVL_CODE is null else it returns a Y.
DECODE(SORLCUR_SITE_CODE)	NA	REPORTING VIEW	GOVERNMENT_STUDENT	SITE	DECODE(SORLCUR_SITE_CODE,NULL,SGBSTDN_SITE_CODE,SORLCUR_SITE_CODE)
DECODE(SORLCUR_TERM_CODE_ADMIT)	NA	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	NEW_STUDENT_IND NEW_STUDENT_IND	NA
DECODE(SORLCUR_TERM_CODE_MATRIC)	SGASTDN	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	MATRICULATED_IND MATRICULATED_IND	DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,'N','Y')
DECODE(SPBPERS_NAME_PREFIX,NULL,DECODE( SPBPERS_SEX,'M','MR.','F','MS.'), SPBPERS_NAME_PREFIX)	NA	REPORTING VIEW	CONSTITUENT	NAME_PREFIX	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	REPORTING VIEW	GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT PERSON PERSON_DETAIL PERSON_SENSITIVE	GENDER_DESC GENDER_DESC GENDER_DESC GENDER_DESC GENDER_DESC GENDER_DESC 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	REPORTING VIEW	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	REPORTING VIEW	PERSON_VETERAN	VETERAN_CATEGORY_DESC	NA
DECODE(SPBPERS_VERA_IND,NULL,NULL, 'VETERAN')	SPAPERS	REPORTING VIEW	PERSON_DETAIL	VETERAN_CATEGORY_DESC	This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran.
DECODE(SPOUSE_IND)	NA				DECODE(TO_CHAR(MAKFUNC.F_COUNT_RELATION(C.ENTITY_UID, 'S')), '0', 'N', 'Y'),
DECODE(SPRIDEN_ID,NULL,NULL,'BANNER')	NA	REPORTING VIEW	PERSON PERSON_DETAIL	ID_SOURCE ID_SOURCE	This function returns null if the id SPRIDEN_ID is null else it returns BANNER.
DECODE(SPRMEDI_DISB_IND,'Y','Y','N')	SPAMEDI				NA
DECODE(SSRFEES_FEE_IND)	SSADETL	REPORTING VIEW	COURSE_OFFERING_FEES	FEE_METHOD_DESC
DECODE(STVAPDC_APPL_INACT)	TBD	REPORTING VIEW	ADMISSIONS_DECISION	APPLICATION_INACTIVE_IND
DECODE(STVAPDC_INST_ACC_IND)	TBD	REPORTING VIEW	ADMISSIONS_DECISION	INSTITUTION_ADMIT_IND
DECODE(STVAPDC_REJECT_IND)	TBD	REPORTING VIEW	ADMISSIONS_DECISION	INSTITUTION_DENIED_IND
DECODE(STVAPDC_SIGNF_IND)	TBD	REPORTING VIEW	ADMISSIONS_DECISION	APPLICATION_SIGNIF_IND
DECODE(STVAPDC_STDN_ACC_IND)	TBD	REPORTING VIEW	ADMISSIONS_DECISION	APPLICANT_ACCEPT_IND
DECODE(STVEVEN_TRANS_IND	NA
DECODE(STVEVEN_TRANS_IND)	NA	REPORTING VIEW	ACADEMIC_HISTORY_EVENT	TRANSCRIPT_IND
DECODE(STVRRCD_MONTHLY_IND,'Y', 'MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y', 'DAILY','TERMLY'))	SLARASG	REPORTING VIEW	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	REPORTING VIEW	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(TBBCSTU_DEL_IND)	TSACONT	REPORTING VIEW	CONTRACT	STUDENT_INACTIVATED_IND	NA
DECODE(TBBESTU_DEL_IND)	TSAEXPP	REPORTING VIEW	EXEMPTION	EXEMPTION_CANCELLED_IND	NA
DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y')	TSADETC	REPORTING VIEW	RECEIVABLE_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	REPORTING VIEW	RECEIVABLE_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	REPORTING VIEW	RECEIVABLE_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	REPORTING VIEW	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	REPORTING VIEW	MISCELLANEOUS_TRANSACTION	EXTERNAL_IND	This function determines if the entity is external to the system.
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y')	NA	REPORTING VIEW	CONSTITUENT_PLAN	MOVE_COMPLETION_IND	NA
DECODE(TRANSACTION_HISTORY.FUND_POOL, NULL,FUND_HIERARCHY.FUND_POOL_DESC, TRANSACTION_HISTORY.FUND_POOL_DESC)	NA	REPORTING VIEW	TRANSACTION_HISTORY	FUND_POOL_DESC	Population of fund pool description is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
FFRMASA_AMT+FFRMASA_ADJ_AMT- FFRMASA_DEPR_ACCUM_AMT	FFAMAST	REPORTING VIEW	FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_SOURCE	BOOK_VALUE 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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	FGIBDST	REPORTING VIEW	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.
FNBUNTH_NUM_UNITS * FNRUCTR_PUR_PRICE_VAL_UNIT	FNIEBAL				This calculation returns the market value by multiplying the units by the purchase price per unit.
FRRGRNL_XX_ACCTD_BUD - FRRGRNL_XX- 1_ACCTD_BUD	FRIGITD	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	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.
FTVSHIP_PHONE_AREA\|\|FTVSHIP_PHONE_NUM\|\|F TVSHIP_PHONE_EXT	NA	REPORTING VIEW	PURCHASE_ORDER PURCHASE_ORDER_ITEM	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	REPORTING VIEW	VENDOR	PHONE_NUMBER_COMBINED	This calculation formulates the combined phone number by concatenating FTVVEND_PHONE_AREA, FTVVEND_PHONE_NUMBER, and FTVVEND_PHONE_EXT.
IF AGBMGID_AMT_PAID > = AGBMGID_AMT THEN Y, ELSE N	NA	REPORTING VIEW	GIFT_MATCHING_TRANSACTION	MATCH_GIFT_FULLY_PAID_IND	NA
IF AGBMGID_AMT_PAID IS > 0 AND < AGBMGID_AMT THEN Y, ELSE N	NA	REPORTING VIEW	GIFT_MATCHING_TRANSACTION	MATCH_GIFT_PARTIAL_PAID_IND	NA
LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+ RCRAPP2_C_PAR_1_CTRB_FOR_STDT)	NA	REPORTING VIEW	NEED_ANALYSIS	INAS_TFC	LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)
LEVEL	FTMFUND	REPORTING VIEW	ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY FUND_HIERARCHY FUND_HIERARCHY LOCATION_HIERARCHY ORGANIZATION_HIERARCHY PROGRAM_HIERARCHY	ACCOUNT_LEVEL ACCOUNT_TYPE_LEVEL FUND_LEVEL FUND_TYPE_LEVEL LOCATION_LEVEL ORGANIZATION_LEVEL PROGRAM_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.)
MAX(APRACYR_YEAR)	NA	REPORTING VIEW	SPECIAL_ACTIVITY SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT	LAST_YEAR LAST_YEAR1 LAST_YEAR2 LAST_YEAR3	NA
MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE	FNIEBAL	REPORTING VIEW	ENDOWMENT_SUMMARIZED_UNITS	MARKET_VALUE	NA
MFKFUNC.F_QTY_RECEIVED_REJECTED	FPARCVD				Calculates the quantity of items received less items rejected.
MIN(APRACYR_YEAR)	NA	REPORTING VIEW	SPECIAL_ACTIVITY	FIRST_YEAR	NA
MONTHS_BETWEEN	NA				NA
MONTHS_BETWEEN(NVL(APREHIS_TO_DATE, SYSDATE),APREHIS_FROM_DATE)	NA	REPORTING VIEW	CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	MONTHS_IN_POSITION YEARS_MONTHS_IN_POSITION1 YEARS_MONTHS_IN_POSITION2 YEARS_MONTHS_IN_POSITION3 YEARS_MONTHS_IN_POSITION4	NA
MONTHS_BETWEEN(NVL(PPREXPE_END_DATE, SYSDATE),PPREXPE_START_DATE)	NA	REPORTING VIEW	EMPLOYMENT_HISTORY	MONTHS_IN_POSITION
MONTHS_BETWEEN(PPREXPE_END_DATE, PPREXPE_START_DATE)	NA	REPORTING VIEW	CURRENT_EMPLOYMENT	MONTHS_IN_POSITION	NA
NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND	NBAPBUD	REPORTING VIEW	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(AARMEMB_CARD_IND,'N')	NA				NA
NVL(AGBMGID_MG_FORMSENT_IND,'N'),	NA				NA
NVL(AGBPLDG_ADJ_IND,'N'),	NA				NA
NVL(AGBPLDG_MATCH_FORM_IND)	NA	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	MATCHING_GIFT_FORM_IND MATCHING_GIFT_FORM_IND
NVL(AGBPLDG_MATCH_PROCESSED)	NA	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	MATCH_GIFT_FORM_PROCESSED_IND MATCH_GIFT_FORM_PROCESSED_IND
NVL(AGBPLDG_MGFORM_READYTOSEND)	NA	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	MATCHGIFT_FORM_READYTOSEND_IND MATCHGIFT_FORM_READYTOSEND_IND
NVL(AGBPLDG_PACK_IND,'N'),	NA				NA
NVL(AGBPLDG_RECEIPT_IND,'N'),	NA				NA
NVL(AGRGAUX_DEDUCT_FOR_TAXES,'N')	NA	REPORTING VIEW	GIFT_AUXILIARY	DEDUCT_FOR_TAXES_IND	NA
NVL(APREHIS_PRIMARY_IND,'N')	APAEHIS				NA
NVL(ATVEMPS_ACTIVE_IND,'N')	ATVEMPS				NA
NVL(AXBMGID_MGFORM_READYTOSEND)	NA	REPORTING VIEW	PLEDGE_MATCHING PLEDGE_MATCHING_TRANSACTION	MATCH_FORM_SENT_IND MATCH_FORM_SENT_IND
NVL(FARINVA_APPR_AMT,0)+NVL( FARINVA_ADDL_CHRG_AMT,0)+NVL( FARINVA_TAX_AMT,0)-NVL(FARINVA_DISC_AMT, 0)	FAAINVE	REPORTING VIEW	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(FPBPOHD_BLANKET_IND,'N')	FPABLAR	REPORTING VIEW	PURCHASE_ORDER	BLANKET_ORDER_IND
NVL(FPBPOHD_CANCEL_IND,'N')	FPAPURR	REPORTING VIEW	PURCHASE_ORDER	CANCEL_IND
NVL(FPBPOHD_CLOSED_IND,'N')	NA	REPORTING VIEW	PURCHASE_ORDER	CLOSED_IND
NVL(FPBPOHD_EDI_IND,'N')	NA	REPORTING VIEW	PURCHASE_ORDER	EDI_IND
NVL(FPBPOHD_PRINT_IND,'N')	NA	REPORTING VIEW	PURCHASE_ORDER	PRINT_IND
NVL(FPBPOHD_REXP_DATE, FPBPOHD_BLANKET_TERM_DATE)	FPABLAR	REPORTING VIEW	PURCHASE_ORDER	PO_END_DATE	NA
NVL(FPBPOHD_SUSP_IND,'N')	FPAPURR	REPORTING VIEW	PURCHASE_ORDER	SUSPENSE_IND
NVL(FPRPODA_ADDL_CHRG_AMT,0)	FPAPURR
NVL(FPRPODA_AMT,0)	FPAPURR	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	CLOSED_IND
NVL(FPRPODA_CONVERT_ADDL_CHRG_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	CONVERTED_ADDITIONAL_AMOUNT
NVL(FPRPODA_CONVERT_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	CONVERTED_AMOUNT
NVL(FPRPODA_CONVERT_DISC_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	CONVERTED_DISCOUNT_AMOUNT
NVL(FPRPODA_CONVERT_TAX_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	CONVERTED_TAX_AMOUNT
NVL(FPRPODA_DISC_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	DISCOUNT_AMOUNT
NVL(FPRPODA_ENCB_ADJT_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	ENCUMBRANCE_ADJUSTMENT_AMOUNT
NVL(FPRPODA_NSF_OVERRIDE_IND,'N')	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	NSF_OVERRIDE_IND
NVL(FPRPODA_SUSP_IND,'N')	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	SUSPENSE_IND
NVL(FPRPODA_TAX_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING	TAX_AMOUNT
NVL(FPRPODT_ADDL_CHRG_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM	ADDITIONAL_AMOUNT ADDITIONAL_CHARGES_AMOUNT
NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_ADDITNAL_AMOUNT
NVL(FPRPODT_CONVERT_DISC_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_DISCOUNT_AMOUNT
NVL(FPRPODT_CONVERT_TAX_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_TAX_AMOUNT
NVL(FPRPODT_CONVERT_UNIT_PRICE,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	CONVERTED_UNIT_PRICE
NVL(FPRPODT_DESC_CHGE_IND,'N')	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	COMMODITY_DESC_CHANGE_IND
NVL(FPRPODT_DISC_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	DISCOUNT_AMOUNT
NVL(FPRPODT_LIQ_AMT,0)	NA	REPORTING VIEW	PURCHASE_ORDER_ITEM	LIQUIDATION_AMOUNT
NVL(FPRPODT_QTY,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	QUANTITY
NVL(FPRPODT_TAX_AMT,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	TAX_AMOUNT
NVL(FPRPODT_UNIT_PRICE,0)	FPAPURR	REPORTING VIEW	PURCHASE_ORDER_ITEM	UNIT_PRICE
NVL(FPRRCDT_COMM_DESC)	FPARCVD				This calculation returns commodity description from commodity if description not changed, from received item if commodity description was changed.
NVL(FPRRCDT_TOL_OVERRIDE_IND)	FPARCVD	REPORTING VIEW	RECEIVED_ITEM	TOLERANCE_OVERRIDE_IND	Calculations deterimines if the override is set to (Y)es or (N)o.
NVL(FTRACTA_ATTS_CODE,'NONE')	FTMFATA	REPORTING VIEW	ACCOUNT_ATTRIBUTES	SET_CODE	NA
NVL(FTRACVA_ATTS_CODE,'NONE')	FTMFATA	REPORTING VIEW	ACTIVITY_ATTRIBUTES	SET_CODE	NA
NVL(FTRATYA_ATTS_CODE,'NONE')	FTMFATA	REPORTING VIEW	ACCOUNT_TYPE_ATTRIBUTES	SET_CODE	NA
NVL(FTRFNDA_ATTS_CODE,'NONE')	FTMFATA	REPORTING VIEW	FUND_ATTRIBUTES	SET_CODE	NA
NVL(FTRFTYA_ATTS_CODE,'NONE')	FTMFATA	REPORTING VIEW	FUND_TYPE_ATTRIBUTES	SET_CODE	NA
NVL(FTRLCNA_ATTS_CODE,'NONE')	FTMFATA	REPORTING VIEW	LOCATION_ATTRIBUTES	SET_CODE	NA
NVL(FTRORGA_ATTS_CODE,'NONE')	FTMFATA	REPORTING VIEW	ORGANIZATION_ATTRIBUTES	SET_CODE	NA
NVL(FTRPRGA_ATTS_CODE,'NONE')	FTMFATA	REPORTING VIEW	PROGRAM_ATTRIBUTES	SET_CODE	NA
NVL(FTVACCT_ACCT_CODE_POOL, FTVACCT_ACCT_CODE)	FTMACCT	REPORTING VIEW	ACCOUNT_HIERARCHY BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER TRANSACTION_HISTORY	ACCOUNT_POOL ACCOUNT_POOL ACCOUNT_POOL ACCOUNT_POOL ACCOUNT_POOL 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	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER	FUND_POOL FUND_POOL FUND_POOL FUND_POOL 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	REPORTING VIEW	BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL GRANT_LEDGER OPERATING_LEDGER ORGANIZATION_HIERARCHY	ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL	This calculation retrieves the FTVORGN_CODE_NSF if it is not NULL. Otherwise it retrieves the FTVORGN_ORGN_CODE.
NVL(GERATTD_FEES_DESC, GTVFEES_DESC)	TBD	REPORTING VIEW	EVENT_INVITEE	FEE_STATUS_DESC
NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED)	NA	REPORTING VIEW	COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT	DATE_SENT DATE_SENT1 DATE_SENT2 DATE_SENT3 DATE_SENT4 DATE_SENT5	NA
NVL(NBBPOSN_ACCRUE_SENIORITY_IND, NTRPCLS_ACCRUE_SENIORITY_IND)	MULTIPLE	REPORTING VIEW	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				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	REPORTING VIEW	POSITION_DEFINITION	POSITION_REPORTS	NVL(POSITION_REPORTS, SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION,'POSITION'),1,63))
NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE)	TBD	REPORTING VIEW	POSITION_DEFINITION	SALARY_GROUP
NVL(NBBPOSN_STEP,NTRPCLS_STEP)	NA				This function returns NBBPOSN_STEP if it is not null else it returns NTRPCLS_STEP.
NVL(NBBPOSN_TABLE,NTRPCLS_TABLE)	NA				This function returns NBBPOSN_TABLE if it is not null, else it returns NTRPCLS_TABLE.
NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR)	NA	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	SUPERVISOR_UID 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	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	SUPERVISOR_POSITION 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	REPORTING VIEW	EMPLOYEE EMPLOYEE_POSITION	SUPERVISOR_JOB_SUFFIX 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	REPORTING VIEW	APPLICATION_OF_PAYMENT APPL_OF_PAY_DETAIL_ACCOUNTING	APPLIED_DATE APPLIED_DATE	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
NVL(RCRAPP4_PUSH_ISIR_FLAG)	RNIMSXX
NVL(RCRESAR_AUTO_ZERO_EFC_FLAG)	TBD
NVL(RCRESAR_SUB_APP)	RNIMSXX
NVL(RCRESAR_VERIF_CHANGE_IND)	RNARSXX RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_ISIR_SPECIFIC	VERIFICATION_SELECT_CHANGE_IND
NVL(RNROVRD_ADD_BK_HOPE_OPT)	TBD
NVL(RNROVRD_ALLOW_IM_PC_LOWR_FM)	TBD
NVL(RNROVRD_ALLOW_IM_SC_LOWR_FM)	TBD
NVL(RNROVRD_CALC_US_TAX_FM)	TBD
NVL(RNROVRD_NON_CUST_PC_OPT)	TBD
NVL(RNROVRD_PAR_ADD_BK_HOME_OPT)	TBD
NVL(RNROVRD_PAR_CALC_US_TAX_FM)	TBD
NVL(RNROVRD_PAR_EXCL_TUIT_DED)	RNAOVXX	REPORTING VIEW	NEED_ANALYSIS_OVERRIDE	IM_PARENT_EXCL_TUITION_FEE_IND
NVL(RNROVRD_PAR_USE_PROJ_INC_EFM)	TBD
NVL(RNROVRD_SKIP_AGE_EXCL)	TBD
NVL(RNROVRD_USE_PROJ_INC_EFM)	TBD
NVL(RNROVRD_ZERO_LOSS_BUS_FARM)	TBD
NVL(RNROVRD_ZERO_LOSS_OTH)	TBD
NVL(RPRADSB_ALTERNATE_PELL_IND,'N')	ROAPELL
NVL(RPRADSB_CPS_VER_IND,'N')	READIXX	REPORTING VIEW	AWARD_DISBURSEMENT	CPS_VERIFICATION_IND
NVL(RPRADSB_DISB_LOCK_IND,'N')	READIXX	REPORTING VIEW	AWARD_DISBURSEMENT	COD_DISBURSEMENT_LOCK_IND
NVL(RPRADSB_EXCL_FROM_NET_AMT,'N')	READIXX	REPORTING VIEW	AWARD_DISBURSEMENT	COD_NET_AMOUNT_EXCLUSION_IND
NVL(RPRADSB_SHARED_SAR_ID_FLAG,'N')	READIXX
NVL(RPRLAPP_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO)	NA	REPORTING VIEW	LOAN_APPLICATION	FIRST_NAME
NVL(RPRLAPP_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO)	NA	REPORTING VIEW	LOAN_APPLICATION	LAST_NAME
NVL(RPRLAPP_MI, MGKFUNC.F_GET_PERSON_INFO)	NA	REPORTING VIEW	LOAN_APPLICATION	MIDDLE_INITIAL
NVL(RPRLAPP_SSN, MGKFUNC.F_GET_PERSON_INFO)	NA	REPORTING VIEW	LOAN_APPLICATION	TAX_ID
NVL(RPRLATR_EXCLUDE_LNEX_FLAG,'N')	RPALORG RPAELAP RPALAPP
NVL(SARADAP_FEE_IND,'N')	NA	REPORTING VIEW	ADMISSIONS_APPLICATION	APPLICATION_FEE_REQUIRED_IND	NA
NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS( SHRTCKN_PIDM,SHRTCKN_TERM_CODE, SHRTCKN_CRN))	NA				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				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				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(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)	NA	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	GRAD_YEAR_INTENDED 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_ADMT_CODE,SGBSTDN_ADMT_CODE)	MULTIPLE				Retrieve admission population 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	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED FIELD_OF_STUDY	EXPECTED_GRADUATION_DATE EXPECTED_GRADUATION_DATE 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	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	LEAVE_REASON 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	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	LEAVE_DATE_FROM 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	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	LEAVE_DATE_TO 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	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	STUDENT_RATE 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	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	SITE SITE	Use site code from curriculum record and if null use site from student record sgbstdn.
NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE)	MULTIPLE	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	STUDENT_POPULATION STUDENT_POPULATION	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	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	GRAD_ACADEMIC_PERIOD_INTENDED 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	REPORTING VIEW	GOVERNMENT_COURSE INSTRUCTIONAL_ASSIGNMENT INSTRUCT_ASSIGN_SLOT INSTRUCT_ASSIGN_SLOT INSTRUCT_ASSIGN_SLOT SCHEDULE_OFFERING	INSTRUCTOR_LAST_NAME INSTRUCTOR_LAST_NAME INSTRUCTOR_LAST_NAME2 INSTRUCTOR_LAST_NAME3 PRIMARY_INSTRUCTOR_LAST_NAME PRIMARY_INSTRUCTOR_LAST_NAME	This function returns the instructor''s last name SPRIDEN_LAST_NAME if it exists, else STAFF.
NVL(SPRIDEN_MI,'STAFF')	MULTIPLE	REPORTING VIEW	INSTRUCT_ASSIGN_SLOT	PRIMARY_INSTRUCTOR_MIDDLE_NAME	Retrieve the instructor''s last name SPRIDEN_LAST_NAME if it exists, else set to STAFF.
NVL(SSBOVRR_COLL_CODE,SCBCRSE_COLL_CODE)	SSAOVRR				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				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				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	REPORTING VIEW	GOVERNMENT_COURSE	TOTAL_CONTACT_HOURS	NA
NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE)	SCACRSE	REPORTING VIEW	GOVERNMENT_COURSE	COURSE_TITLE_SHORT	NA
NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH)	SCACRSE	REPORTING VIEW	GOVERNMENT_COURSE	LAB_CONTACT_HOURS	NA
NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH)	SCACRSE	REPORTING VIEW	GOVERNMENT_COURSE	LECTURE_CONTACT_HOURS	NA
NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH)	SCACRSE	REPORTING VIEW	GOVERNMENT_COURSE	OTHER_CONTACT_HOURS	NA
NVL(TBRDEPO_AMOUNT-F_ACCD_AMOUNT( TBRDEPO_PIDM,TBRDEPO_TRAN_NUMBER),0)	TSADETL	REPORTING VIEW	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	REPORTING VIEW	DEPOSIT RECEIVABLE_ACCOUNT_DETAIL	OPERATING_DATE 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	REPORTING VIEW	TRANSACTION_HISTORY	FUND_POOL	Population of fund pool is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
PPREXPE_SUPER_PHONE_AREA\|\|PPREXPE_SUPER_ PHONE_NUMBER\|\|PPREXPE_SUPER_PHONE_EXT	NA				NA
PPRREFE_PHONE_AREA\|\|PPRREFE_PHONE_NUMBER \|\|PPRREFE_PHONE_EXT	NA				This function concatenates the phone area code, the phone number and the phone extension from the PPRREFE table.
ROUND(MONTHS_BETWEEN(SYSDATE,BIRTH_DATE) /12,0)	SPAPERS	REPORTING VIEW	PERSON_DETAIL	CURRENT_AGE	This function calculates the person''s current age based on SPBPERS_BIRTH_DATE and SYSDATE.
ROW_NUMBER	TBD	REPORTING VIEW	ACADEMIC_OUTCOME ADMISSIONS_APPLICATION GOVERNMENT_ADMISSIONS RECRUITMENT_INFORMATION	CURRICULUM_ORDER CURRICULUM_ORDER CURRICULUM_ORDER CURRICULUM_ORDER
SCBCRSE_SUBJ_CODE\|\|SCBCRSE_CRSE_NUMB	SCACRSE	REPORTING VIEW	COURSE_CATALOG COURSE_PREREQ GOVERNMENT_COURSE STUDENT_WORK_EXPERIENCE	COURSE_IDENTIFICATION COURSE_IDENTIFICATION_PREREQ COURSE_IDENTIFICATION COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SCBCRSE record.
SCBSUPP_SUBJ_CODE\|\|SCBSUPP_CRSE_NUMB	SCADETL				This concatenates the course subject code with the course number from the SCBSUPP record.
SCRATTR_SUBJ_CODE\|\|SCRATTR_CRSE_NUMB	SCADETL	REPORTING VIEW	COURSE_ATTRIBUTE	COURSE_IDENTIFICATION	NA
SCRCORQ_SUBJ_CODE_CORQ\|\|SCRCORQ_CRSE_NUM B_CORQ	SCADETL	REPORTING VIEW	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	REPORTING VIEW	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				This concatenates the course subject code with the course number from the SGRGMOD record.
SCRLEVL_SUBJ_CODE\|\|SCRLEVL_CRSE_NUMB	SCACRSE	REPORTING VIEW	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	REPORTING VIEW	COURSE_PREREQ COURSE_PREREQ_COMBINED	COURSE_IDENTIFICATION COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SCRRTST record.
SCRSCHD_SUBJ_CODE\|\|SCRSCHD_CRSE_NUMB	SCACRSE	REPORTING VIEW	COURSE_SCHEDULE	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SCRSCHD record.
SFRSTCR_SUBJ_CODE\|\|SFRSTCR_CRSE_NUMB	SFAREGS	REPORTING VIEW	STUDENT_COURSE	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	REPORTING VIEW	STUDENT_WORK_EXPERIENCE	PHONE_NUMBER_COMBINED	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	REPORTING VIEW	STUDENT_COURSE_ATTRIBUTE STUDENT_COURSE_ATT_SLOT	COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_ATTEMPTED_IND,'Y',1,0)	SHATCKS	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE_GRADE_CHANGE	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	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE_GRADE_CHANGE	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	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE_GRADE_CHANGE	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	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE_GRADE_CHANGE	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	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE_GRADE_CHANGE	QUALITY_POINTS QUALITY_POINTS	This calculates the credit hours passed by the student.
SHRTCKN_SUBJ_CODE\|\|SHRTCKN_CRSE_NUMB	SHAINST	REPORTING VIEW	STUDENT_COURSE STUDENT_COURSE_ATTRIBUTE STUDENT_COURSE_GRADE_CHANGE	COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SHRTCKN record.
SHRTRCE_SUBJ_CODE\|\|SHRTRCE_CRSE_NUMB	SHATRNS	REPORTING VIEW	STUDENT_COURSE	COURSE_IDENTIFICATION	This concatenates the course subject code with the course number from the SHRTRCE record.
SHRTRCE_TRIT_SEQ_NO\|\|TO_CHAR( SHRTRCE_TRAM_SEQ_NO,'FM09')\|\|TO_CHAR( NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009') \|\|TO_CHAR(SHRTRCE_SEQ_NO,'FM009')	MULTIPLE	REPORTING VIEW	STUDENT_COURSE	COURSE_REFERENCE_NUMBER
SLBBLDG_PHONE_AREA\|\|SLBBLDG_PHONE_NUMBER \|\|SLBBLDG_PHONE_EXTENSION	SLABLDG	REPORTING VIEW	ROOM_ASSIGNMENT	BUILDING_PHONE_NUM_COMBINED	This concatenates the the area code, the phone number and the phone extension from the SLBBLDG table.
SLBEVNT_PHONE_AREA\|\|SLBEVNT_PHONE\|\|SLBEV NT_PHONE_EXT	NA	REPORTING VIEW	EVENT	PHONE_NUMBER_COMBINED	NA
SLBRDEF_PHONE_AREA\|\|SLBRDEF_PHONE_NUMBER \|\|SLBRDEF_PHONE_EXTENSION	SLARASG	REPORTING VIEW	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	REPORTING VIEW	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	REPORTING VIEW	INSTITUTION	CONTACT_PHONE_NUMBER_COMBINED	NA
SPRADDR_CNTY_CODE	FAAINVE	REPORTING VIEW	INVOICE	REMIT_TO_COUNTY	NA
SPRIDEN_FIRST_NAME \|\| SUBSTR(SPRIDEN_MI, 1,1) \|\| SPRIDEN_LAST_NAME	NA	REPORTING VIEW	PLEDGE_MATCHING_TRANSACTION	MATCH_EMPLOYER_NAME
SPRIDEN_FIRST_NAME\|\|SPRIDEN_MI\|\|SPRIDEN_ LAST_NAME	NA				NA
SPRTELE_INTL_ACCESS \|\| SPRTELE_PHONE_AREA \|\| SPRTELE_PHONE_NUMBER \|\| SPRTELE_PHONE_EXT	NA	REPORTING VIEW	VENDOR VENDOR	ORDER_FROM_PHONE_COMBINED REMIT_TO_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.
SPRTELE_INTL_ACCESS\|\|SPRTELE_PHONE_AREA\| \|SPRTELE_PHONE_NUMBER\|\|SPRTELE_PHONE_EXT	NA	REPORTING VIEW	CONSTITUENT_ENTITY ORGANIZATION_CONTACT REFERENCE ADDRESS_PREFERRED ORGANIZATION_ENTITY PERSON TELEPHONE	PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED	This concatenates the the international code, the area code, the phone number and the phone extension from the SPRTELE table.
SSBSECT_SUBJ_CODE\|\|SSBSECT_CRSE_NUMB	SFAREGS	REPORTING VIEW	COURSE_OFFERING_FEES MEETING_TIME OFFERING_COREQ OFFERING_GRADE_TYPE OFFERING_PREREQ SCHEDULE_OFFERING	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	REPORTING VIEW	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	REPORTING VIEW	PERSON PERSON_DETAIL	MIDDLE_INITIAL MIDDLE_INITIAL	This function returns the middle initial.
SUM(AGRPDES_AMT_PAID)	TBD	REPORTING VIEW	PLEDGE_TRANSACTION	PLEDGE_TRANS_AMOUNT_PAID
SUM(FNBUNTH_TRANS_AMT)	FNIEBAL				SUM(FNBUNTH_TRANS_AMT)
SUM(FPRRCDT_AMT_RCVD)	FPARCVD	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY	RECEIVED_AMOUNT_TO_DATE	NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY)	FPARCVD FPARTRN	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY	QUANTITY_ACCEPTED_TO_DATE	NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD)	FPARCVD	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY RECEIVED_ITEM	QTY_RECEIVED_REJECTED_TO_DATE QUANTITY_RECEIVED_REJECTED	NA
SUM(FPRRCDT_QTY_RCVD)	FPARCVD	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY PURCHASE_ORDER_ITEM_SUMMARY	QUANTITY_RECEIVED_TO_DATE QUANTITY_REJECTED_TO_DATE	NA
SUM(FPRRCDT_QTY_REJD)	FPARCVD				NA
SUM(FPRRTRN_QTY)	FPARCVD	REPORTING VIEW	PURCHASE_ORDER_ITEM_SUMMARY	QUANTITY_RETURNED_TO_DATE	Returns the sum of all quantities returned for a purchase order item.
SUM(PERJTOT_GRS)	NA				This function returns the sum of the hours SUM(PERJTOT_GRS).
SUM(PERJTOT_HRS)	NA				This function returns the sum of the hours SUM(PERJTOT_HRS).
SUM(RPRAWRD_ACCEPT_AMT)	NA	REPORTING VIEW	AWARD_BY_FUND	ACCEPT_AMOUNT	SUM(RPRAWRD_ACCEPT_AMT)
SUM(RPRAWRD_AUTHORIZE_AMT)	NA	REPORTING VIEW	AWARD_BY_FUND	AUTHORIZED_AMOUNT	NA
SUM(RPRAWRD_CANCEL_AMT)	NA	REPORTING VIEW	AWARD_BY_FUND	CANCEL_AMOUNT	NA
SUM(RPRAWRD_DECLINE_AMT)	NA	REPORTING VIEW	AWARD_BY_FUND	DECLINE_AMOUNT	NA
SUM(RPRAWRD_MEMO_AMT)	NA	REPORTING VIEW	AWARD_BY_FUND	MEMO_AMOUNT	NA
SUM(RPRAWRD_OFFER_AMT)	NA	REPORTING VIEW	AWARD_BY_FUND	OFFER_AMOUNT	NA
SUM(RPRAWRD_PAID_AMT)	NA	REPORTING VIEW	AWARD_BY_FUND	PAID_AMOUNT	NA
SYSDATE BETWEEN SPRHOLD_FROM_DATE AND SPRHOLD_TO_DATE	TBD	REPORTING VIEW	HOLD	ACTIVE_HOLD_IND
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE1')	NA	REPORTING VIEW	GOVERNMENT_STUDENT	CENSUS_FTE_1	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	REPORTING VIEW	GOVERNMENT_STUDENT	CENSUS_FTE_2	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	REPORTING VIEW	GOVERNMENT_STUDENT	CENSUS_FTE_3	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	REPORTING VIEW	GOVERNMENT_STUDENT	CENSUS_FTE_4	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(TBRACCD_CSHR_END_DATE)	NA	REPORTING VIEW	GRANT_RECEIVABLE_ACCT_DETAIL MISCELLANEOUS_TRANSACTION	CASHIER_END_TIME CASHIER_END_TIME	This calculation retrieves the 24 hour time from TBRACCD_CSHR_END_DATE.
TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'), 'YYYY')	NA	REPORTING VIEW	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	REPORTING VIEW	TRANSACTION_HISTORY	FISCAL_YEAR_HEADER	This calculation transforms a two digit fiscal year into a 4 digit fiscal year for the transaction history record.

Ver: 8.1