Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: CALCULATION Travel And Expense
Banner Operational Data Store Composite View Source: CALCULATION - NULL

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
(APPLIED_AMOUNT * (CLGR.PERCENT/100) * ( PLGR.PERCENT/100)) NA NO         Calculates acutal amount applied to the transaction based upon accounting distribution percentages.
(FGBOPAL_XX_ADOPT_BUD + FGBOPAL_XX_BUD_ADJT) - ( FGBOPAL_XX_YTD_ACTV + FGBOPAL_XX_ENCUMB + FGBOPAL_XX_BUD_RSRV) - (FGBOPAL_XX- 1_ADOPT_BUD + FGBOPAL_XX-1_BUD_ADJT) - ( FGBOPAL_XX-1_YTD_ACTV + FGBOPAL_XX- 1_ENCUMB + FGBOPAL_XX-1_BUD_RSRV) NA NO          
(FGBOPAL_XX_ADOPT_BUD+ FGBOPAL_XX_BUD_ADJT)-( FGBOPAL_XX_YTD_ACTV+FGBOPAL_XX_ENCUMB+ FGBOPAL_XX_BUD_RSRV) FGIBDST NO COMPOSITE VIEW

AF_OPERATING_LEDGER

SUM_REMAINING_BALANCE

NO

This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes all activity up to and including this period.
(FRRGRNL_XX_ADOPT_BUD + FRRGRNL_XX_BUD_ADJT - FRRGRNL_XX_YTD_ACTV - FRRGRNL_XX_ENCUMB - FRRGRNL_XX_BUD_RSRV) FRIGITD NO COMPOSITE VIEW

AF_GRANT_LEDGER

SUM_REMAINING_BALANCE

NO

This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes all activity up to and including this period.
(FRRGRNL_XX_ADOPT_BUD + FRRGRNL_XX_BUD_ADJT) - ( FRRGRNL_XX_YTD_ACTV + FRRGRNL_XX_ENCUMB + FRRGRNL_XX_BUD_RSRV) - (FRRGRNL_XX- 1_ADOPT_BUD + FRRGRNL_XX-1_BUD_ADJT) - ( FRRGRNL_XX-1_YTD_ACTV + FRRGRNL_XX- 1_ENCUMB + FRRGRNL_XX-1_BUD_RSRV) FRIGITD NO COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_REMAINING_BALANCE

NO

This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes only activity in this period.
(MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES + MAKFUNC.F_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100 NA NO          
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100 NA NO          
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFRDESG_GOAL * 100 NA NO          
(MAKFUNC.F_ORG_TOTAL_GIFTS + MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100 NA NO          
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100 NA NO          
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFRCSOL_GOAL * 100 NA NO          
(MAKFUNC.F_SOL_FR_TOTAL_PLEDGES + MAKFUNC.F_SOL_FR_TOTAL_GIFTS + MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100 NA NO          
(NVL(FARINVC_APPR_QTY,0)*NVL( FARINVC_APPR_UNIT_PRICE,0))+NVL( FARINVC_ADDL_CHRG_AMT,0)+NVL( FARINVC_TAX_AMT,0)-NVL(FARINVC_DISC_AMT, 0) FAAINVE NO COMPOSITE VIEW

AF_INVOICE_ITEM

APPROVED_ITEM_AMOUNT

NO

This calculation returns the approved item amount for the invoice item. The amount is calculated as the approved quantity multiplied by the unit price plus any additional charges and tax amount and then subtracting any discount.
(NVL(FBVBLDL_BUDG_AMT,0)+NVL( FBVBLDL_ADJT_AMT,0)) FBABDMN NO COMPOSITE VIEW

AF_BUDGET_DETAIL

BUDGET_AMOUNT

NO

This calculation returns the budgeted amount by adding the original budget to any budget adjustments.
(NVL(FPRPODT_QTY,0)*NVL( CONVERTED_FPRPODT_UNIT_PRICE,0))+NVL( FPRPODT_CONVERTED_ADDL_CHRG_AMT,0)+NVL( FPRPODT_CONVERTED_TAX_AMT,0)-NVL( FPRPODT_CONVERTED_DISC_AMT,0) FPAPURR NO          
(NVL(FPRPODT_QTY,0)*NVL( FPRPODT_UNIT_PRICE,0))+NVL( FPRPODT_ADDL_CHRG_AMT,0)+NVL( FPRPODT_TAX_AMT,0)-NVL(FPRPODT_DISC_AMT, 0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

APPROVED_ITEM_AMOUNT

NO

This calculation returns the approved item amount for the purchase order item. The amount is calculated as the approved quantity multiplied by the unit price plus any additional charges and tax amount and then subtracting any discount.
AARMEMB_AMT_QUALIFY - AOKODSF.F_GET_MEMBER_AMT_PAID NA NO          
ACCT.PAY_CURRENCY_AMOUNT - ACCT.PAY_CURRENCY_AMOUNT_NO_TAX NA NO          
AFRCSOL_GOAL / AFBCAMP_GOAL * 100 NA NO          
AFRDESG_GOAL / AFBCAMP_GOAL * 100 NA NO          
AGBMGID_AMT - AGBMGID_AMT_PAID NA NO COMPOSITE VIEW

AA_GIFT_MATCHING

MATCH_GIFT_BALANCE

NO

NA
AGRGDES_AMT-F_GIFT_HARD_CREDIT NA NO COMPOSITE VIEW

AA_GIFT

GIFT_CREDIT_AMOUNT

NO

NA
AGRPDES_AMT-AGRPDES_AMT_PAID NA NO COMPOSITE VIEW

AA_PLEDGE

PLEDGE_BALANCE

NO

NA
AGRPDES_AMT-F_PLEDGE_HARD_CREDIT NA NO COMPOSITE VIEW

AA_PLEDGE

PLEDGE_CREDIT

NO

NA
AGRPDES_AMT_PAID - SUM(AGRPDES_AMT_PAID) NA NO COMPOSITE VIEW

AA_PLEDGE

PLEDGE_TRANS_BALANCE

NO

 
AORCONT_FAX_AREA||AORCONT_FAX_NUMBER||AO RCONT_FAX_EXT NA NO COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

FAX_NUMBER_COMBINED

NO

 
AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER ||AORCONT_PHONE_EXT NA NO COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

PHONE_NUMBER_COMBINED

NO

 
ASBSORG_UPD_WEB_IND NA NO          
ASRSORG_DOLLAR_GOAL / ASBSORG_DOLLAR_GOAL * 100 NA NO          
ASRSORG_UPD_WEB_IND NA NO          
CASE NBBPOSN_PREMIUM_ROLL_IND TBD NO          
CASE NBBPOSN_ROLL_IND TBD NO          
CASE SFRFFST_STATUS_CDE WHEN TBD NO          
CASE STVFFVA_TYPE WHEN NA NO COMPOSITE VIEW

AS_FACULTY_FEEDBACK_DETAIL

FEEDBACK_TYPE_DESC

NO

 
CASE STVFFVA_TYPE WHEN 'ISSUE' THEN 'ISSUE' WHEN 'RECOMMEND' THEN 'RECOMMENDATION' END TBD NO          
CASE SYS.ANYDATA.GETTYPENAME( GORSDAV_VALUE) TBD NO COMPOSITE VIEW

AG_SDE_DATA

ATTRIBUTE_VALUE

NO

This calculation retrieves the value from GORSDAV_VALUE based on datatype.
CASE STATEMENT NA NO         (CASE WHEN ( SFRSTCR_DUPL_OVER = 'Y' OR SFRSTCR_LINK_OVER = 'Y' OR SFRSTCR_CORQ_OVER = 'Y' OR SFRSTCR_PREQ_OVER = 'Y' OR SFRSTCR_TIME_OVER = 'Y' OR SFRSTCR_CAPC_OVER = 'Y' OR SFRSTCR_LEVL_OVER = 'Y' OR SFRSTCR_COLL_OVER = 'Y' OR SFRSTCR_MAJR_OVER = 'Y' OR SFRSTCR_CLAS_OVER = 'Y' OR SFRSTCR_APPR_OVER = 'Y' OR SFRSTCR_REPT_OVER = 'Y' OR SFRSTCR_RPTH_OVER = 'Y' OR SFRSTCR_TEST_OVER = 'Y' OR SFRSTCR_CAMP_OVER = 'Y' OR SFRSTCR_DEGC_OVER = 'Y' OR SFRSTCR_PROG_OVER = 'Y' OR SFRSTCR_DEPT_OVER = 'Y' OR SFRSTCR_ATTS_OVER = 'Y' OR SFRSTCR_CHRT_OVER = 'Y' OR SFRSTCR_MEXC_OVER = 'Y') THEN 'Y' ELSE 'N' END)
CASE WHEN (C.DAP_TRANSFER = 'C') AND ( C.DAP_INPROGRESS = 'N') NA NO          
CASE WHEN (RCRAPP1_SEQ_NO NA NO          
CASE WHEN A.ADVANCE_STATUS = 'O' THEN 'OUTSTANDING' WHEN A.ADVANCE_STATUS = 'R' THEN 'RECONCILED' WHEN A.ADVANCE_STATUS = 'D' THEN 'OVERDUE' ELSE 'UNKNOWN' END TBD NO          
CASE WHEN AORCONT_CONT_ORG_IND NA NO COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_ADDRESS_SOURCE_DESC

NO

 
CASE WHEN AORCONT_EMAL_SRC_IND NA NO COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_EMAIL_SOURCE_DESC

NO

 
CASE WHEN AORCONT_FAX_SRC_IND NA NO COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_FAX_SOURCE_DESC

NO

 
CASE WHEN AORCONT_PRIMARY_IND NA NO COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

PRIMARY_CONTACT_IND

NO

 
CASE WHEN AORCONT_TELE_SRC_IND NA NO COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_PHONE_SOURCE_DESC

NO

 
CASE WHEN APPROVAL_METHOD NA NO          
CASE WHEN APPROVAL_STATUS NA NO          
CASE WHEN CONTACT_DECEASED_IND NA NO          
CASE WHEN DAP_AUDIT_TYPE NA NO          
CASE WHEN DAP_REASON_INSUF NA NO          
CASE WHEN DAP_RESULT_TYPE NA NO          
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' NA NO          
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' AND AUDIT_TYPE = 'PL' NA NO          
CASE WHEN DAP_RESULT_TYPE = 'CLASSNEEDED' NA NO          
CASE WHEN DAP_RESULT_TYPE = 'FALLCLASSAPPLIED' NA NO          
CASE WHEN DAP_RESULT_TYPE = 'FALLNONCRAPPLIED' NA NO          
CASE WHEN DAP_RESULT_TYPE = 'INSUFFCLASSAPPLIED' NA NO          
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' NA NO          
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' AND AUDIT_TYPE = 'PL' AND SUBSTR(VALUE3,1,2) = 'PN' NA NO          
CASE WHEN DAP_RESULT_TYPE = 'NONCRNEEDED' NA NO          
CASE WHEN DAP_RESULT_TYPE = 'OTLCLASSAPPLIED' NA NO          
CASE WHEN DAP_TRANSFER = 'C' AND DAP_INPROGRESS = 'N' NA NO          
CASE WHEN DAP_TRANSFER = 'T' NA NO          
CASE WHEN ENCUMBRANCE_NUMBER NA NO COMPOSITE VIEW

AF_ENCUMBRANCE

HR_ENCUMBRANCE_IND

NO

 
CASE WHEN FABBKTP_RECON_IND NA NO COMPOSITE VIEW

AF_CHECKS

BANK_RECONCILIATION_IND_DESC

NO

 
CASE WHEN FABCHKS_CHECK_TYPE_IND NA NO COMPOSITE VIEW

AF_CHECKS

CHECK_TYPE_DESC

NO

 
CASE WHEN FABCHKS_PAY_TYPE NA NO         Hard code a pay type description based upon the pay_type value CASE WHEN FABCHKS_PAY_TYPE = 'Check' THEN 'Check' WHEN FABCHKS_PAY_TYPE = 'ACH' THEN 'Direct Deposit' WHEN FABCHKS_PAY_TYPE = 'vCard' THEN 'Virtual Card' WHEN FABCHKS_PAY_TYPE = 'PNE' THEN 'Temporary Pay Type' WHEN FABCHKS_PAY_TYPE = 'Wire' THEN 'Wire Transfer' END
CASE WHEN FABCHKS_RECON_IND NA NO COMPOSITE VIEW

AF_CHECKS

RECONCILIATION_IND_DESC

NO

 
CASE WHEN FABRUIV_SUB_IND NA NO COMPOSITE VIEW

AF_INVOICE

REPEATING_FREQUENCY_DESC

NO

 
CASE WHEN FGBENCD_CMT_TYPE NA NO          
CASE WHEN FGBENCD_FIELD_CODE NA NO          
CASE WHEN FTVVEND_CHECK_PIDM IS NULL NA NO          
CASE WHEN GROUP_TYPE NA NO         CASE RTRIM (G.GROUP_TYPE) WHEN 'UN' THEN G$_NLS.GET ('DPVTMCR-0001', 'SQL', 'Union within group') WHEN 'CH' THEN G$_NLS.GET ('DPVTMCR-0002', 'SQL', 'Choice within group') WHEN 'NA' THEN G$_NLS.GET ('DPVTMCR-0003', 'SQL', 'Not applicable') END
CASE WHEN HR_ENCUMBRANCE_IND NA NO          
CASE WHEN NORTRAN_AUBK_CODE = 'SPRIDEN' THEN 'IDEN' NA NO COMPOSITE VIEW

AN_PERSONNEL_ACTION_GENERAL

PAF_TRANSACTION_TYPE

NO

 
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = NA NO         Tests to determine if the detail code is term based or aid year based detail code or neither CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = 'T' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE = 'A' ELSE DESIGNATOR_TYPE = 'N' END CASE;
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC = NA NO         Hard code the description based upon the designator type. CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE_DESC = 'Academic period-based' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE_DESC = 'Aid year-based' ELSE DESIGNATOR_TYPE_DESC = 'No designator' END CASE;
CASE WHEN NVL(TBBEACT_TBDC_IND, 'N') NA NO          
CASE WHEN OFFICIAL_TRACKING_STATUS NA NO          
CASE WHEN PLAN_SOURCE NA NO          
CASE WHEN R.DAP_RESULT_TYPE = 'CLASSNEEDED' THEN 'N' WHEN R.DAP_RESULT_TYPE <> 'CLASSNEEDED' AND R.DAP_AUDIT_TYPE = 'PL' NA NO          
CASE WHEN RBRAPBC_SYS_IND = 'S' TBD NO          
CASE WHEN RFRASPC_DIRECT_LOAN_IND NA NO          
CASE WHEN RFRASPC_EL_LOAN_IND NA NO          
CASE WHEN RFRASPC_MANUAL_LOAN_IND NA NO          
CASE WHEN RORSTAT_ADDL_PELL_ELIB_IND NA NO          
CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND NA NO          
CASE WHEN RORSTAT_DEP_NO_PAR_DATA NA NO          
CASE WHEN RRRAREQ_SYS_IND NA NO          
CASE WHEN SFRBRDB_COURSE_RESTRICTION NA NO         IF SFRBRDB_COURSE_RESTRICTION = 'NA THEN Add/Drop Courses Not Available, WHEN SFRBRDB_COURSE_RESTRICTION = NB THEN Add/Drop only Non-Block Courses, WHEN SFRBRDB_COURSE_RESTRICTION = NR THEN Add/Drop Courses with No Restriction
CASE WHEN SFRSTCR_GRDE_CODE NA NO         Determines if course was attempted, earned, passed, credit for GPA, considered for repeat, incomplete,or last date of attendance is required. If sfrstcr_grde_code is not null THEN course_attempted_ind = shrgrde_attempted_ind; If sfrstcr_grde_code is not null THEN course_earned_ind = shrgrde_completed_ind; If sfrstcr_grde_code is not null THEN course_passed_ind = shrgrde_passed_ind; If sfrstcr_grde_code is not null THEN course_gpa_ind = shrgrde_gpa_ind;
CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRGRDE_ATTEMPTED_IND NA NO         Determines if student passed or failed the course. CASE WHEN SFRSTCR_GRDE_CODE IS NOT NULL THEN CASE WHEN shrgrde_attempted_ind = 'Y' AND shrgrde_passed_ind = 'N' AND shrgrde_gpa_ind = 'Y' THEN 'Y' ELSE 'N
CASE WHEN SFRSTCR_WAIV_HRS NA NO          
CASE WHEN SHRTCKG_GRDE_CODE_FINAL NA NO         Determines if course was attempted, earned, passed, credit for GPA, considered for repeat, incomplete,or last date of attendance is required. If shrtckg_grde_code_final is not null THEN course_attempted_ind = shrgrde_attempted_ind; If shrtckg_grde_code_final is not null THEN course_earned_ind = shrgrde_completed_ind; If shrtckg_grde_code_final is not null THEN course_passed_ind = shrgrde_passed_ind; If shrtckg_grde_code_final is not null THEN credit_for_gpa_ind = shrgrde_gpa_ind;
CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRGRDE_ATTEMPTED_IND NA NO         Determines if student passed or failed the course. CASE WHEN SHRTCKG_GRDE_CODE_FINAL IS NOT NULL THEN CASE WHEN shrgrde_attempted_ind = 'Y' AND shrgrde_passed_ind = 'N' AND shrgrde_gpa_ind = 'Y' THEN 'Y' ELSE 'N
CASE WHEN SHRTRCE_GRDE_CODE NA NO         Determines if course was attempted, earned, passed, credit for GPA, considered for repeat, incomplete,or last date of attendance is required. If shrtrce_grde_code is not null THEN course_attempted_ind = shrgrde_attempted_ind; If shrtrce_grde_code is not null THEN course_earned_ind = shrgrde_completed_ind; If shrtrce_grde_code is not null THEN course_passed_ind = shrgrde_passed_ind; If shrtrce_grde_code is not null THEN credit_for_gpa_ind = shrgrde_gpa_ind;
CASE WHEN SHRTRCE_GRDE_CODE CASE WHEN SHRGRDE_ATTEMPTED_IND NA NO         Determines if student passed or failed the course. CASE WHEN SHRTRCE_GRDE_CODE IS NOT NULL THEN CASE WHEN shrgrde_attempted_ind = 'Y' AND shrgrde_passed_ind = 'N' AND shrgrde_gpa_ind = 'Y' THEN 'Y' ELSE 'N
CASE WHEN SSBSECT_CENSUS_2_DATE NA NO          
CASE WHEN SSBSECT_CENSUS_ENROLL NA NO          
CASE WHEN STAFF_ASSIGNMENT_STATUS_IND NA NO          
CASE WHEN STATUS_CHANGE_IND NA NO          
CASE WHEN STRATEGY_PLAN_STATUS_IND NA NO          
CASE WHEN STVESTS_EFF_HEADCOUNT NA NO COMPOSITE VIEW

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT

NOT_ENROLLED_IND

NOT_ENROLLED_IND

NO

NO

Determines if the student is not enrolled.
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID = 0 THEN 'Y' ELSE 'N' NA NO COMPOSITE VIEW

AA_PLEDGE

PLEDGE_TRANS_FULLY_PAID_IND

NO

 
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID > 0 AND SUM( AGRPDES_AMT_PAID) < AGRPDES_AMT_PAID THEN 'Y' ELSE 'N' NA NO COMPOSITE VIEW

AA_PLEDGE

PLEDGE_TRANS_PARTIAL_PAID_IND

NO

 
CASE WHEN SYSDATE BETWEEN EXCLUSION_DATE NA NO          
CASE WHEN TAX_DOCUMENT_BOX NA NO         Determine TAX_DOCUMENT_BOX hard coded descriptions based upon TBRACCD_TAX_REPT_BOX value.
CASE WHEN TAX_NOTIFICATION_STATUS NA NO         Determines hard coded descriptions for TAX_NOTIFICATION_STATUS based upon the values in TTBTAXN_STUD_NOTIF_STATUS.
CASE WHEN TBBDETC_REFUND_IND NA NO COMPOSITE VIEW

AT_ACCOUNT_DETAIL

REFUND_DESC

NO

Hard code the description based upon the TBBDETC_REFUND_IND Hard code the detail code refund description based upon the refund indicator. CASE WHEN TBBDETC_REFUND_IND = 'Y' THEN REFUND_DESC = 'Refund' WHEN TBBDETC_REFUND_IND = 'M' THEN REFUND_DESC = 'Manual Refund' WHEN TBBDETC_REFUND_IND = 'P' THEN REFUND_DESC = 'Parent PLUS Refund' ELSE REFUND_DESC = 'No Refund' END
CASE WHEN TBBDETC_TBDC_IND NA NO         Checks to determine if the detail code is a term based detail code, and if not, then checks to determine if the detail code is an aid year based detail code. CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = 'T' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE = 'A' ELSE DESIGNATOR_TYPE = 'N' END CASE;
CASE WHEN TBBEACT_TBDC_IND NA NO         Determines if the detail code is used as a designator detail code. CASE WHEN TBBEACT_TBDC_IND = 'Y' OR TBBEACT_ABDC_IND = 'Y' THEN 'Y' ELSE 'N' END
CASE WHEN TBBEACT_TBDC_IND = 'Y' NA NO          
CASE WHEN TRACKING_STATUS NA NO          
CASE WHEN UNOFFICIAL_TRACKING_STATUS NA NO          
CASE(AMRCONT_GEN_CONTACT_IND) NA NO COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

PROSPECT_CONTACT_IND

NO

 
COUNT (*) OVER (PARTITION BY B.PERSON_UID) NA NO         COUNT (*) OVER (PARTITION BY B.PERSON_UID, B.ACADEMIC_PERIOD, B.SUB_ACADEMIC_PERIOD, B.PLAN_COURSE_SEQUENCE_NUMBER, B.COURSE_IDENTIFICATION, B.COURSE_REFERENCE_NUMBER)
COUNT (*) OVER (PARTITION BY COURSE_IDENTIFICATION, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER) TBD NO          
COUNT (DISTINCT COURSE_REFERENCE_NUMBER) TBD NO          
COUNT (DISTINCT PERSON_UID) TBD NO          
COUNT(AMRATTN_PIDM) NA NO          
COURSE_DISCIPLINE||COURSE_NUMBER NA NO          
DAP_VALUE1 || DAP_VALUE2 NA NO          
DAP_VALUE2 || DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID' NA NO          
DECODE ( DECODE ( SIGN ( NVL ( TBRACCD_TRANS_DATE, TBRACCD_EFFECTIVE_DATE) TSADETL NO          
DECODE (MRVAND0_EFC_IND, 'F', '', RNKNEED.F_CALC_BUDGET_AMT (MRVAND0_PIDM, MRVAND0_AIDY_CODE, 'I')), '999999999D99') TBD NO          
DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND) NA NO         DECODE(NBBPOSN_EXEMPT_IND,'Y',DECODE(NTRPCLS_EXEMPT_IND,'Y','Exemption Position Class and Position Definition','Non-exempt Position Class and Position Definition'),DECODE(NTRPCLS_EXEMPT_IND,'Y','Exempt Class but overridden by the Position Definition','Non-exempt Position Class but overridden by the Position Definition'))
DECODE (RCRAPP1_WARD_OF_COURT, '1', 'Y', 'N') RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

WARD_OF_COURT_IND

NO

 
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND (ENTITY_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION') TBD NO          
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND ( MATCH_EMPLOYER_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION') TBD NO          
DECODE(AGBMGID_DELETE_IND,'I','N','Y'), NA NO COMPOSITE VIEW

AA_GIFT_MATCHING

ACTIVE_IND

NO

NA
DECODE(AGBMGID_DELETE_IND,NULL, DECODE( AGBMGID_STATUS,NULL,'W','P','P','I','I') ,'N'), NA NO COMPOSITE VIEW

AA_GIFT_MATCHING

MATCH_GIFT_STATUS

NO

NA
DECODE(AGBMGID_DELETE_IND,NULL, DECODE( AGBMGID_STATUS,NULL,'WAITING, NO PAYMENT','P','PAID IN FULL','I', 'WAITING, PARTIAL PAYMENT'),'NO PAYMENT EXPECTED'), NA NO COMPOSITE VIEW

AA_GIFT_MATCHING

MATCH_GIFT_STATUS_DESC

NO

NA
DECODE(AGRGAUX_ACC_REJ_IND,'A','ACCEPT', 'R','REJECT','NOT APPLICABLE'), NA NO COMPOSITE VIEW

AA_GIFT_AUXILIARY

BENEFIT_ACCEPT_REJECT_DESC

NO

NA
DECODE(AGRPAUX_PLDG_ADJ_VOID_IND) NA NO COMPOSITE VIEW

AA_PLEDGE_AUXILIARY

AA_PLEDGE_AUXILIARY

PLEDGE_VOID_IND

PLEDGE_ADJUSTMENT_IND

NO

NO

 
DECODE(AGRPCON_MET_IND) NA NO COMPOSITE VIEW

AA_PLEDGE_CONDITIONAL

CONDITION_MET_DESC

NO

 
DECODE(AGRPDES_AMT-AGRPDES_AMT_PAID) NA NO         NA
DECODE(AGRPDES_AMT_PAID) NA NO         NA
DECODE(AMRPLAN_PROJ_CODE, AMRCONT_PROJ_CODE) NA NO          
DECODE(AMRPRRT_RATING_PIDM,NULL, AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM) NA NO COMPOSITE VIEW

AA_ADVANCEMENT_RATING

RATER_UID

NO

NA
DECODE(APRADEG_HOND_CODE_1) NA NO          
DECODE(APRADEG_HONR_CODE) NA NO         Determines if this person should be counted in the institutional honors count.
DECODE(APRADEG_SBGI_CODE, AUBINST_SBGI_CODE,'Y','N') NA NO COMPOSITE VIEW

AA_DEGREE

INSTITUTION_IND

NO

NA
DECODE(APRCSPS_MARS_IND,'A','ACTIVE', 'I','INACTIVE') APACONS NO COMPOSITE VIEW

AA_RELATIONSHIP

SPOUSE_STATUS_DESC

NO

This calculation checks APRCSPS_MARS_IND to derive a description. If 'A' description is 'active'. If 'I' description is 'inactive'.
DECODE(APRDCLB_DCYR_CODE,'9999','Y','N') NA NO COMPOSITE VIEW

AA_GIFT_SOCIETY

LIFETIME_GIFT_SOCIETY_IND

NO

NA
DECODE(APRIGRP_DISPLAY_WEB_IND) NA NO COMPOSITE VIEW

AA_INTEREST

DISPLAY_WEB_IND

NO

 
DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY', 'S','SECONDARY') NA NO COMPOSITE VIEW

AA_RELATIONSHIP

COMBINED_MAILING_PRIORITY_DESC

NO

This calculation checks APRXREF_CM_PRI_IND to derive a description. If 'P' description is 'primary'. If 'S' description is 'secondary'.
DECODE(ATVADJT_DEBIT_CREDIT_IND) NA NO COMPOSITE VIEW

AA_DESIGNATION_ADJUSTMENT

ADJUSTMENT_DEBIT_CREDIT_DESC

NO

 
DECODE(ATVCFAE_MG_PURPOSE,'A','ALUMNI OR OTHER ASSOCIATIONS','B','RELIGIOUS PURPOSES AT THE INSTITUTION','C', 'POLITICAL PURPOSES AT THE INSTITUTION', 'D','ATHLETIC ACTIVITIES','E','ATHLETIC SCHOLARSHIP FUNDS','F','NON-ATHLETIC SCHOLARSHIP FUNDS',ETC.) TBD NO COMPOSITE VIEW

AA_DESIGNATION

MATCHING_GIFT_VSE_PURPOSE_DESC

NO

 
DECODE(ATVDONR_CFAE_2) NA NO COMPOSITE VIEW

AA_DONOR_CATEGORY

VSE_DESC_2

NO

NA
DECODE(ATVGIFT_CFAE_GIFT_CATG) NA NO COMPOSITE VIEW

AA_GIFT

GIFT_VSE_DESC

NO

NA
DECODE(BENEFICIARY_NAME) NA NO         DECODE(B.BENEFICIARY_LAST_NAME, NULL, BP.FULL_NAME_LFMI, B.BENEFICIARY_LAST_NAME||', '||B.BENEFICIARY_FIRST_NAME||' '||DECODE(B.BENEFICIARY_MIDDLE_INITIAL,NULL,NULL,SUBSTR(BENEFICIARY_MIDDLE_INITIAL,1,1))|| '.')
DECODE(C.EXPENSE_TYPE_CODE, '9900ADVC', 'Y','N') TBD NO          
DECODE(ENROLLED_IND, 'N', 'Y', 'N') NA NO          
DECODE(EXPENSE_TYPE_CODE,'9900ADVC') TBD NO          
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL) FAAINVE NO COMPOSITE VIEW

AF_INVOICE

REMIT_TO_STREET_LINE1

NO

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL) FAAINVE NO COMPOSITE VIEW

AF_INVOICE

REMIT_TO_STREET_LINE2

NO

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL) FAAINVE NO COMPOSITE VIEW

AF_INVOICE

REMIT_TO_STREET_LINE3

NO

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_CITY, NULL) FAAINVE NO COMPOSITE VIEW

AF_INVOICE

REMIT_TO_CITY

NO

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_NATN, NULL) FAAINVE NO COMPOSITE VIEW

AF_INVOICE

REMIT_TO_NATION

NO

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_STATE, NULL) FAAINVE NO COMPOSITE VIEW

AF_INVOICE

REMIT_TO_STATE_PROVINCE

NO

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ZIP, NULL) FAAINVE NO COMPOSITE VIEW

AF_INVOICE

REMIT_TO_POSTAL_CODE

NO

NA
DECODE(FABINVH_ATYP_CODE, NULL, TO_NUMBER(NULL), FABINVH_ATYP_SEQ_NUM) FAAINVE NO COMPOSITE VIEW

AF_INVOICE

REMIT_TO_ADDRESS_TYPE_NUMBER

NO

NA
DECODE(FABINVH_ATYP_CODE,NULL,'Y','N') FAAINVE NO COMPOSITE VIEW

AF_INVOICE

ONE_TIME_VENDOR_ADDRESS_IND

NO

NA
DECODE(FABINVH_GROUPING_IND) NA NO COMPOSITE VIEW

AF_INVOICE

AF_INVOICE

GROUPING

GROUPING_DESC

NO

NO

 
DECODE(FABINVH_INVOICE_TYPE_IND) FAAINVE NO COMPOSITE VIEW

AF_INVOICE

INVOICE_TYPE_DESC

NO

This calculation evaluates the column FABINVH_INVOICE_TYPE_IND. If it is a D, it will return DIRECT. If it is an R, it will return REGULAR. If it is neither D nor R, it will return NULL.
DECODE(FABINVH_MATCH_REQUIRED) NA NO COMPOSITE VIEW

AF_INVOICE

RECEIVING_REQUIRED_DESC

NO

 
DECODE(FABINVH_VEND_CHECK_PIDM,NULL,'N', 'Y') FAAINVE NO COMPOSITE VIEW

AF_INVOICE

THIRD_PARTY_ADDRESS_IND

NO

NA
DECODE(FEEDBACK_COMMENT,NULL,'NO','YES') TBD NO          
DECODE(FEEDBACK_ESTIMATED_GRADE,NULL, 'NO','YES') TBD NO          
DECODE(FEEDBACK_STATUS,'M','YES','NO') TBD NO          
DECODE(FFBMAST_SUBORDINATE_TYPE) FFAMAST NO COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SUBORDINATE_TYPE_DESC

NO

This calculation evaulates the column FFBMAST_SUBORDINATE_TYPE. If it is a C, it returns COMPONENT. If it is an A, it returns ATTACHEDTO. If it is neither C nor A, it returns NEITHER.
DECODE(FFRMASA_DEPR_POST_CODE) FFADEPR NO COMPOSITE VIEW

AF_FIXED_ASSET_DEPRECIATION

DEPRECIATION_POSTING_STATUS

NO

This calculation evaluates the column FFRMASA_DEPR_POST_CODE. If it is an M, it will return Memo Post. If it is a P, it will return Post. If it is neither M nor P, it will return No Post.
DECODE(FGBENCD_STATUS) FGIENCD NO COMPOSITE VIEW

AF_ENCUMBRANCE_ACCOUNTING

ENCUMBRANCE_STATUS

NO

This calculation evaluates the column FGBENCD_STATUS. If it is a C, it will return Closed. Otherwise it will return Open.
DECODE(FGBENCD_STATUS_IND) FGIENCD NO COMPOSITE VIEW

AF_ENCUMBRANCE_ACCOUNTING

POSTABLE_IND

NO

This calculation evaluates the column FGBENCD_STATUS_IND. If it is a P, it will return Y. Otherwise, it will return an N.
DECODE(FGBENCH_SOURCE_IND) FGIENCD NO COMPOSITE VIEW

AF_ENCUMBRANCE

ENCUMBRANCE_SOURCE

NO

This calculation evaluates the column FGBENCH_SOURCE_IND. If it is an R, it will return Requisition. If it is a P, it will return Purchase Order. If it is an E, it will return Encumbrance. Otherwise, it will return Unknown Source.
DECODE(FGBENCH_STATUS) FGIENCD NO COMPOSITE VIEW

AF_ENCUMBRANCE

COMPLETE_IND

NO

This calculation evaluates the column FGBENCH_STATUS. If it is a C, it will return Y. Otherwise, it will return an N.
DECODE(FGBENCH_STATUS_IND) FGIENCD NO COMPOSITE VIEW

AF_ENCUMBRANCE

ENCUMBRANCE_STATUS

NO

This calculation will evaluate the column FGBENCH_STATUS_IND. If it is a C, it will return Closed. Otherwise it will return Open.
DECODE(FNVENDW_REST_TYPE) NA NO COMPOSITE VIEW

AF_ENDOWMENT

RESTRICTION_TYPE_DESC

NO

This calculation will evaluate the column FNVENDW_REST_TYPE. If it is an R, it will return RESTRICTED. If it is a U, it will return UNRESTRICTED. Otherwise it will return NULL.
DECODE(FNVPOOL_STATUS_IND) FNMPOOL NO         This calculation will evaluate the column FNVPOOL_STATUS_IND. If it is an A, it will return ACTIVE. If it is an I, it will return INACTIVE. Otherwise, it will return NULL.
DECODE(FOKODSF.F_GET_REST_IND) NA NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

FUND_BALANCE_RESTRICTION_DESC

FUND_BALANCE_RESTRICTION_DESC

NO

NO

 
DECODE(FORCIRR_DATA_ORIGIN) NA NO          
DECODE(FPBPOHD_MATCH_REQUIRED) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER

RECEIVING_REQUIRED_DESC

NO

 
DECODE(FPBPOHD_PO_TYPE_IND) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER

PURCHASE_ORDER_TYPE_DESC

NO

This calculation will evaluate the column FPBPOHD_PO_TYPE_IND. If it is an R, it will return REGULAR. If it is an S, it will return STANDING. Otherwise, it will return NULL.
DECODE(FPBPOHD_REQ_BID_IND) FPAPOAS NO COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUISITION_OR_BID_SOURCE_DESC

NO

 
DECODE(FPBPOHD_TEXT_IND) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER

REQUISITION_TEXT_DESC

NO

 
DECODE(FPBRCDT_ADJUST_RECEIVE_IND) FPARCVD NO COMPOSITE VIEW

AF_RECEIVED_ITEM

ADJUSTED_IND

NO

This calculation returns a Y or N if the item was adjusted or not adjusted.
DECODE(FPRPODA_NSF_SUSP_IND) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

NSF_SUSPENSE_DESC

NO

 
DECODE(FPRPODT_TEXT_USAGE) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

TEXT_USAGE_DESC

NO

 
DECODE(FPRRCDT_PARTIAL_FINAL_IND) FPARCVD NO COMPOSITE VIEW

AF_RECEIVED_ITEM

FINAL_RECEIPT_IND

NO

Calculation determines if value is set to (P)artial or (F)inal.
DECODE(FRBEVNG_PMT_METHOD_TYPE_IND) NA NO COMPOSITE VIEW

AF_GRANT_EVENT

PAYMENT_METHOD_DESC

NO

 
DECODE(FRRBDET_ACCT_CLASS_CODE) FRABDCN NO COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

ACCOUNT_CLASS

NO

This calculation will evaluate the column FRRBDET_ACCT_CLASS_CODE. If it is a C, it will return COST SHARE. If it is an I, it will return INDIRECT COST. If it is a D, it will return DIRECT EXPENSE. If it is an F, it will return FIXED ASSETS. If it is a U, it will return UNITIZATION.
DECODE(FRRBDET_BILL_STATUS) FRABDCN NO COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_STATUS_DESC

NO

This calculation will evaluate the column FRRBDET_BILL_STATUS. If it is a B, it will return BILLED. If it is a U, it will return UNBILLED. If it is an H, it will return HOLD. If it is a W, it will return WITHHOLDING.
DECODE(FRVBFRM_TYPE_IND) NA NO COMPOSITE VIEW

AF_GRANT_EVENT

AF_GRANT_PERSONNEL

BILL_FORMAT_TYPE_DESC

BILL_FORMAT_TYPE_DESC

NO

NO

 
DECODE(FTVATTT_STATUS_IND) FTMATTT NO COMPOSITE VIEW

AF_PROGRAM_ATTRIBUTES_ODS

AF_ACCOUNT_ATTRIBUTES_ODS

AF_ACCOUNT_TYPE_ATTRIBUTES_ODS

AF_ACTIVITY_ATTRIBUTES_ODS

AF_CHART_ATTRIBUTES_ODS

AF_FUND_ATTRIBUTES_ODS

AF_FUND_TYPE_ATTRIBUTES_ODS

AF_ATTRIBUTE_SETS_ODS

AF_ORGANIZATION_ATTRIBUTES_ODS

AF_LOCATION_ATTRIBUTES_ODS

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

This calculation will evaluate the column FTVATTT_STATUS_IND. If it is an A, it will return Active. Otherwise, it will return Inactive.
DECODE(FTVBAL_FBAL_IND) NA NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

FUND_BALANCE_DESC

FUND_BALANCE_DESC

NO

NO

 
DECODE(FTVFSPD_PRD_STATUS_IND) NA NO COMPOSITE VIEW

AF_FISCAL_PERIOD

PERIOD_STATUS_DESC

NO

 
DECODE(FTVFUND_REST_IND) NA NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

FUND_RESTRICTION_DESC

FUND_RESTRICTION_DESC

NO

NO

 
DECODE(FTVVEND_1099_RPT_ID) FTMVEND NO COMPOSITE VIEW

AF_VENDOR

FEDERAL_REPORTABLE_TAX_IND

NO

This calculation will evaluate the column FTVVEND_1099_RPT_ID. If it is NULL, it will return an N. Otherwise, it will return a Y.
DECODE(F_DISPOSITION_IND,'H','HIRED', 'N','NO LONGER CONSIDERED','U','UNDER CONSIDERATION') NA NO COMPOSITE VIEW

AP_HR_APPLICATION

STATUS_DISPOSITION_DESC

NO

This function returns HIRE if the disposition indicator is H, NO LONGER CONSIDERED if it is N or UNDER CONSIDERATION if it is U.
DECODE(GOREMAL_STATUS_IND) NA NO COMPOSITE VIEW

AG_INTERNET_ADDRESS

INTERNET_ADDRESS_STATUS_DESC

NO

 
DECODE(GORSGEO_SOURCE_IND,'S','N','Y') NA NO COMPOSITE VIEW

AG_GEOGRAPHIC_REGION_INST

GEOGRAPHIC_SOURCE_USER_IND

NO

DECODE(GORSGEO_SOURCE_IND,'S','N','Y')
DECODE(GORSGEO_STATUS_IND,NULL,'A','I') NA NO COMPOSITE VIEW

AG_GEOGRAPHIC_REGION_INST

GEOGRAPHIC_REGION_STATUS

NO

DECODE(GORSGEO_STATUS_IND,NULL,'A','I')
DECODE(GORSGEO_STATUS_IND,NULL,'ACTIVE', 'INACTIVE') NA NO COMPOSITE VIEW

AG_GEOGRAPHIC_REGION_INST

GEOGRAPHIC_REGION_STATUS_DESC

NO

DECODE(GORSGEO_STATUS_IND,NULL,'Active','Inactive')
DECODE(GROUP_TYPE) NA NO          
DECODE(GURMAIL_DATE_PRINTED,NULL,'Y', 'N') NA NO COMPOSITE VIEW

AG_COMMUNICATION

PENDING_LETTER_IND

NO

NA
DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL') SUAMAIL NO COMPOSITE VIEW

AG_COMMUNICATION

COMMUNICATION_TYPE_DESC

NO

NA
DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE) RNIMSXX NO          
DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C', CANCELLED,'F',FROZEN,'I',INACTIVE) NA NO COMPOSITE VIEW

AN_SUPERVISOR

AN_POSITION_DEFINITION

POSITION_STATUS_DESC

POSITION_STATUS_DESC

NO

NO

This function returns ACTIVE if the status NBBPOSN_STATUS is A, Cancelled if C, FROZEN if F and INACTIVE if I.
DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD') NA NO COMPOSITE VIEW

AN_EMPLOYEE_POSITION

AP_EMPLOYEE

AN_SUPERVISOR

POSITION_CONTRACT_TYPE_DESC

CONTRACT_TYPE_DESC

POSITION_CONTRACT_TYPE_DESC

NO

NO

NO

This function returns Primary if the contract type NBRBJOB_CONTRACT_TYPE is P, Secondary if it is S and Overload if it is O.
DECODE(NBRJOBS_PERS_PAY_CODE) NA NO COMPOSITE VIEW

AN_EMPLOYEE_POSITION

PUBLIC_RETIRE_PAY_RATE_DESC

NO

SUBSTR(DECODE(P.NBRJOBS_PERS_PAY_CODE, '01', G$_NLS.GET('x','SQL','Monthly Pay Rate'), '02', G$_NLS.GET('x','SQL','Monthly Pay Rate (LA)'), '04', G$_NLS.GET('x','SQL','Hourly Pay Rate'), '08', G$_NLS.GET('x','SQL','Daily Pay Rate'), '09', G$_NLS.GET('x','SQL','Miscellaneous Pay Rate')),1,30),
DECODE(NBRJOBS_STATUS) NA NO COMPOSITE VIEW

AN_EMPLOYEE_POSITION

POSITION_STATUS_DESC

NO

This function return Active if the employee status NBRJOBS_STATUS is A, Leave withoutpay and with benefit if it is B, Leave without pay and without benefit if it is L, Leave with pay and with benefit if it is F, Leave with part pay and with benefit if it is P, Terminated if it is T.
DECODE(NBRJOBS_STRS_PAY_CODE) NA NO COMPOSITE VIEW

AN_EMPLOYEE_POSITION

STATE_RETIREMENT_PAY_RATE_DESC

NO

SUBSTR(DECODE(P.NBRJOBS_STRS_PAY_CODE, '0', G$_NLS.GET('x','SQL','Annual or Lump Sum'), '1', G$_NLS.GET('x','SQL','12 Monthly Payments'), '2', G$_NLS.GET('x','SQL','11 Monthly Payments'), '3', G$_NLS.GET('x','SQL','10 Monthly Payments'), '4', G$_NLS.GET('x','SQL','Hourly Rate'), '7', G$_NLS.GET('x','SQL','13 Payments'), '8', G$_NLS.GET('x','SQL','Daily Rate')),1,30),
DECODE(NBRPTOT_STATUS,'A',APPROVED,'C', CLOSED,'T',TRANSFERRED,'W',WORKING) NA NO COMPOSITE VIEW

AN_POSITION_BUDGET

AN_PAYROLL_DISTRIBUTION

BUDGET_STATUS_DESC

BUDGET_STATUS_DESC

NO

NO

This function returns APPROVED if the status NBRPTOT_STATUS is A, CLOSED if it is C, TRANSFERRED if it is T and WORKING if it is W.
DECODE(NHRDIST_HIST_TYPE_IND) NA NO COMPOSITE VIEW

AN_PAYROLL_DISTRIBUTION

PAYROLL_EVENT_TYPE_DESC

NO

SUBSTR(DECODE(NHRDIST_HIST_TYPE_IND, 'J', G$_NLS.GET('x','SQL','Adjusted'), 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Original'), 'R', G$_NLS.GET('x','SQL','Redistributed'), 'I', G$_NLS.GET('x','SQL','Reissued'), 'V', G$_NLS.GET('x','SQL','Voided')),1,30)
DECODE(NORMAL_BALANCE) NA NO         NA
DECODE(NVL(AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'N', NVL(AGVPLG1_PLEDGE_AMOUNT,0) , 'N','Y') NA NO COMPOSITE VIEW

AA_PLEDGE

PLEDGE_PARTIAL_PAID_IND

NO

NA
DECODE(PAYROLL_DEDUCTION) NA NO         SUM(NVL(DECODE(PAYROLL_DEDUCTION_MONTH, 1, EMPLOYEE_CONTRIBUTION_AMOUNT, 2, EMPLOYEE_CONTRIBUTION_AMOUNT, 3, EMPLOYEE_CONTRIBUTION_AMOUNT,0),0))
DECODE(PDRDEDN_STATUS,'A','ACTIVE','B', 'EXEMPT','W','WAIVE','T','TERMINATED',') NA NO COMPOSITE VIEW

AP_BENEFIT_DEDUCTION

STATUS_DESC

NO

This function returns ACTIVE if the status PDRDEDN_STATUS is A, EXEMPT if the status is B WAIVE if the status is W or TERMINATED if the status is T.
DECODE(PDRDEDN_STATUS,'A','ACTIVE','B', 'EXEMPT','W','WAIVED','T','TERMINATED') NA NO COMPOSITE VIEW

AP_TAX

STATUS_DESC

NO

NA
DECODE(PEBEMPL_1042_RECIPIENT_CD) NA NO COMPOSITE VIEW

AP_EMPLOYEE

FOREIGN_INCOME_RECIPIENT_DESC

NO

This function returns Individual if the 1042 receipient code PEBEMPL_1042_RECIPIENT_CD is 01, Corporation if it is 02, Partnership if it is 03, Fiduciary if it is 04, Nominee if it is 05, Govt or International Organization if iti 06, Tax Exempt Organization if it is 07, Private Foundation if it 08, Artist or athlete if it is 09, Other if it is 19, Type of recipient unknown if it is 20.
DECODE(PEBEMPL_CALIF_PENSION_IND) NA NO COMPOSITE VIEW

AP_EMPLOYEE

PUBLIC_RETIREMENT_MEMBER_DESC

NO

 
DECODE(PEBEMPL_EMPL_STATUS) NA NO COMPOSITE VIEW

AP_EMPLOYEE

EMPLOYEE_STATUS_DESC

NO

This function return Active if the employee status PEBEMPL_EMPL_STATUS is A, Leave withoutpay and with benefit if it is B, Leave without pay and without benefit if it is L, Leave with pay and with benefit if it is F, Leave with part pay and with benefit if it is P, Terminated if it is T.
DECODE(PEBEMPL_FLSA_IND) NA NO COMPOSITE VIEW

AP_EMPLOYEE

FAIR_LABOR_STANDARDS_TYPE_DESC

NO

This function return a description based upon the value of fair labor standards for an employee PEBEMPL_FLSA_STATUS. Accrual is A, Cash is C, and No FLSA is N.
DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED, N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT) NA NO COMPOSITE VIEW

AP_EMPLOYEE

IMMIGRATION_STATUS_DESC

NO

This function returns RECEIVED if the I9 form indicator PEBEMPL_I9_FORM_IND is R, NOTRECEIVED if it is N, TEMPORARY if it is T,
DECODE(PERAPPT_DECISION) NA NO         SUBSTR(DECODE(PERAPPT_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30)
DECODE(PERBFAC_PRIMARY_ACTIVITY) PEAFACT,PEAFACD NO         SUBSTR(DECODE(PERBFAC_PRIMARY_ACTIVITY, 'A', G$_NLS.GET('x','SQL','Administrative'), 'I', G$_NLS.GET('x','SQL','Instructional'),'R', G$_NLS.GET('x','SQL','Research')),1,30)
DECODE(PERJTOT_MONTH,1,1,2,1,3,1,4,2,5, 2,6,2,7,3,8,3,9,3,10,4,11,4,12,4) NA NO COMPOSITE VIEW

AP_EMPLOYEE_EARNING_CY

QUARTER

NO

This function returns what quarter it is based on the month PERJTOT_MONTH. 1, 2, 3 are the first quarter. 4, 5, 6 are the second quarter. 7, 8, 9 are the third quarter. 10, 11, 12 are the fourth quarter.
DECODE(PERRANK_DECISION) NA NO         SUBSTR(DECODE(PERRANK_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30)
DECODE(PERSABB_DECISION) NA NO         SUBSTR(DECODE(PERSABB_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30)
DECODE(PHRACCR_CALC_GEN_IND) NA NO         SUBSTR(DECODE(PHRACCR_CALC_GEN_IND, 'Y', G$_NLS.GET('x','SQL','Calculated'), 'N', G$_NLS.GET('x','SQL','Manual')),1,30)
DECODE(PHRATND_TS_ROSTER_IND) NA NO COMPOSITE VIEW

AP_PAYROLL_ATTENDANCE

TIMESHEET_METHOD_DESC

NO

 
DECODE(PHRDOCM_DOC_TYPE) NA NO         DECODE(PHRDOCM_DOC_TYPE, 'C', 'N', 'D', 'Y')
DECODE(PHRELBD_TS_ROSTER_IND) NA NO COMPOSITE VIEW

AP_PAYROLL_LABOR_DIST_OVERRIDE

TIMESHEET_METHOD_DESC

NO

 
DECODE(PHRHIST_CALC_IND) NA NO         SUBSTR(DECODE(PHRHIST_CALC_IND, 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Calculated')),1,30)
DECODE(PHRHIST_PRINT_IND) NA NO         SUBSTR(DECODE(PHRHIST_PRINT_IND, 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Calculated')),1,30)
DECODE(PHRHIST_TYPE_IND) NA NO          
DECODE(PHRJOBS_TIME_ENTRY_IND) NA NO         SUBSTR(DECODE(PHRJOBS_TIME_ENTRY_IND, 'P', G$_NLS.GET('x','SQL','Pay Period'), 'F', G$_NLS.GET('x','SQL','FSLA'), 'W', G$_NLS.GET('x','SQL','Weekly'), 'D', G$_NLS.GET('x','SQL','Daily'), 'N', G$_NLS.GET('x','SQL','None')),1,30)
DECODE(PHRJOBS_TS_ROSTER_IND) NA NO         SUBSTR(DECODE(PHRJOBS_TS_ROSTER_IND, 'T', G$_NLS.GET('x','SQL','Timesheet'), 'O', G$_NLS.GET('x','SQL','Organization'), 'R', G$_NLS.GET('x','SQL','Roster')),1,30)
DECODE(PHRJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD') NA NO         NA
DECODE(PTRBDCA_CALC_RULE) NA NO         substr(gokodsf.f_get_null_varchar2,1,6), substr(gokodsf.f_get_desc(null, 'GTVVPDI') ,1,30), substr(gokodsf.f_get_null_varchar2,1,6), substr(gokodsf.f_get_null_varchar2,1,6),
DECODE(RCRAPP1_ACTIVE_DUTY,'1','Y','N') RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

ACTIVE_DUTY_IND

NO

 
DECODE(RCRAPP1_AT_RISK_HOMELESS,'1', 'Y','N') RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

AT_RISK_HOMELESS_IND

NO

 
DECODE(RCRAPP1_BORN_BEFORE_1_1_XX) RNANAXX RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

OLDER_THAN_24_IND

NO

 
DECODE(RCRAPP1_DEGREE_BY_JULY) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

DEGREE_BY_JULY_IND

NO

 
DECODE(RCRAPP1_EMANCIPATED_MINOR,'1', 'Y','N') RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

EMANCIPATED_MINOR_IND

NO

 
DECODE(RCRAPP1_HAS_LEGAL_DEPEND) RNANAXX RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LEGAL_DEPENDENT_IND

NO

 
DECODE(RCRAPP1_INS) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

PERM_RESIDENCY_CONFIRMED_IND

NO

 
DECODE(RCRAPP1_LEGAL_GUARDIAN,'1', 'Y', 'N') RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LEGAL_GUARDIAN_IND

NO

 
DECODE(RCRAPP1_LINE2_RELSHIP) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE2_RELATIONSHIP_DESC

NO

 
DECODE(RCRAPP1_LINE3_ATTEND_COLL) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE3_ATTEND_COLLEGE_DESC

NO

 
DECODE(RCRAPP1_LINE3_RELSHIP) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE3_RELATIONSHIP_DESC

NO

 
DECODE(RCRAPP1_LINE4_ATTEND_COLL) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE4_ATTEND_COLLEGE_DESC

NO

 
DECODE(RCRAPP1_LINE4_RELSHIP) NA NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE4_RELATIONSHIP_DESC

NO

 
DECODE(RCRAPP1_LINE5_ATTEND_COLL) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE5_ATTEND_COLLEGE_DESC

NO

 
DECODE(RCRAPP1_LINE5_RELSHIP) NA NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE5_RELATIONSHIP_DESC

NO

 
DECODE(RCRAPP1_LINE6_ATTEND_COLL) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE6_ATTEND_COLLEGE_DESC

NO

 
DECODE(RCRAPP1_LINE6_RELSHIP) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE6_RELATIONSHIP_DESC

NO

 
DECODE(RCRAPP1_LINE7_ATTEND_COLL) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE7_ATTEND_COLLEGE_DESC

NO

 
DECODE(RCRAPP1_LINE7_RELSHIP) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE7_RELATIONSHIP_DESC

NO

 
DECODE(RCRAPP1_LINE8_ATTEND_COLL) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE8_ATTEND_COLLEGE_DESC

NO

 
DECODE(RCRAPP1_LINE8_RELSHIP) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

LINE8_RELATIONSHIP_DESC

NO

 
DECODE(RCRAPP1_MRTL_STATUS) NA NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

MARITAL_STATUS_DESC

NO

 
DECODE(RCRAPP1_PAR_DIV_SEP_REM_IND) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

DIVORCED_PARENT_INFO_IND

NO

 
DECODE(RCRAPP1_PAR_HOUS_STAT) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

PARENT_HOUSING_STATUS_DESC

NO

 
DECODE(RCRAPP1_PAR_TAX_FORM_IND) RNAPRXX RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

PARENT_TAX_RETURN_TYPE_DESC

NO

 
DECODE(RCRAPP1_PERMIT_DRAFT_REG) RNANAXX NO          
DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR) RNAPRXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

REQUESTED_AID_SPRING_DESC

NO

 
DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR) RNAPRXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

REQUESTED_AID_NEXT_SUMMER_DESC

NO

 
DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR) RNAPRXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

REQUESTED_AID_PREC_SUMMER_DESC

NO

 
DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR) RNAPRXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

REQUESTED_AID_WINTER_DESC

NO

 
DECODE(RCRAPP1_SIGNED) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

APPLICATION_SIGNED_BY_DESC

NO

 
DECODE(RCRAPP1_TAX_FORM_IND) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

TAX_RETURN_TYPE_DESC

NO

 
DECODE(RCRAPP1_TITLE) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

NAME_PREFIX

NO

 
DECODE(RCRAPP1_UNACCOMP_YOUTH_HUD,'1', 'Y','N') RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

UNACCOMPANIED_YOUTH_HUD_IND

NO

 
DECODE(RCRAPP1_UNACCOMP_YOUTH_SCHOOL, '1', 'Y','N') RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

UNACCOMPANIED_YOUTH_SCHOOL_IND

NO

 
DECODE(RCRAPP1_US_VET) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

VETERAN_IND

NO

 
DECODE(RCRAPP1_VERIFICATION_MSG) RNARSXX RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

SELECTED_FOR_VERIFICATION_IND

NO

 
DECODE(RCRAPP1_YR_IN_COLL) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION1

YEAR_IN_COLLEGE_DESC

NO

 
DECODE(RCRAPP2_C_1_ANLY_TYPE) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

FM_ANALYSIS_TYPE_DESC

NO

 
DECODE(RCRAPP2_C_1_CTRB_OFFL_EST) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

FM_CONTRIBUTION_OFFICIAL_DESC

NO

 
DECODE(RCRAPP2_C_1_VA_BEN_INCL) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

FM_VETERAN_BENEFITS_IND

NO

 
DECODE(RCRAPP2_C_2_CTRB_OFFL_EST) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

IM_CONTRIBUTION_OFFICIAL_DESC

NO

 
DECODE(RCRAPP2_C_2_VA_BEN_INCL) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

IM_VETERAN_BENEFITS_IND

NO

 
DECODE(RCRAPP2_C_DEPEND_STATUS) NA NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

DEPENDENCY_STATUS_DESC

NO

 
DECODE(RCRAPP2_C_MRTL_STATUS) TBD NO          
DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

FM_PARENT_ANALYSIS_TYPE_DESC

NO

 
DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

FM_PARENT_CONTRIB_OFF_DESC

NO

 
DECODE(RCRAPP2_C_PAR_2_CTRB_FR_ASSET) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

IM_PARENT_CONTRIBUTION_ASSET

NO

 
DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

IM_PARENT_CONTRIB_OFF_DESC

NO

 
DECODE(RCRAPP2_C_PAR_MRTL_STATUS) TBD NO          
DECODE(RCRAPP2_ELIGIBILITY_MSG) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

SAR_C_IND

NO

 
DECODE(RCRAPP2_MODEL_CDE) ROASTAT NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

DEPENDENCY_INDEPEND_DESC

NO

 
DECODE(RCRAPP2_PELL_ANLY_TYPE) RNIMSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

SIMPLIFIED_NEEDS_TEST_IND

NO

 
DECODE(RCRAPP2_PELL_CTRB_OFFL_EST) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

FM_EST_CONTRIB_OFFICIAL_DESC

NO

 
DECODE(RCRAPP2_PELL_PGI_OFFL_EST) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

PELL_EFC_OFFICIAL_DESC

NO

 
DECODE(RCRAPP2_PELL_P_ANLY_TYPE) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION2

FM_PARENT_EST_ANAL_TYPE_DESC

NO

 
DECODE(RCRAPP3_C_SIGNED) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

SIGNATURE_IND

NO

 
DECODE(RCRAPP3_C_SIGNED_FATH) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

FATHER_SIGNATURE_IND

NO

 
DECODE(RCRAPP3_C_SIGNED_MOTH) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

MOTHER_SIGNATURE_IND

NO

 
DECODE(RCRAPP3_C_SIGNED_SPS) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

SPOUSE_SIGNATURE_IND

NO

 
DECODE(RCRAPP3_DEGREE_TYPE) RNAPRXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

DEGREE_TYPE_DESC

NO

 
DECODE(RCRAPP3_FAA_DEP_OVERRIDE) RNIMSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

DEPENDENCY_OVERRIDE_DESC

NO

 
DECODE(RCRAPP3_FATH_SSN_MATCH) RNANAXX RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

FATHER_TAX_ID_MATCH_DESC

NO

 
DECODE(RCRAPP3_GRAD_OR_PROF) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

GRADUATE_PROFESSIONAL_IND

NO

 
DECODE(RCRAPP3_LIVE_ON_FARM) RNAPRXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

RESIDE_FARM_IND

NO

 
DECODE(RCRAPP3_MARRIED) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

MARITAL_STATUS_IND

NO

 
DECODE(RCRAPP3_MOTH_SSN_MATCH) RNANAXX RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

MOTHER_TAX_ID_MATCH_DESC

NO

 
DECODE(RCRAPP3_OFFL_UNOFFL_IND) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

OFFICIAL_SOURCE_IND

NO

 
DECODE(RCRAPP3_PAR_LIVE_ON_FARM) RNAPRXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_RESIDE_FARM_IND

NO

 
DECODE(RCRAPP3_PREPARER_SIGN) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

PREPARER_SIGNATURE_IND

NO

 
DECODE(RCRAPP3_SOC_SEC) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

TAX_ID_MATCH_STATUS_DESC

NO

 
DECODE(RCRAPP3_YR_IN_COLL_2) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION3

YEAR_IN_COLLEGE2_DESC

NO

 
DECODE(RCRAPP4_1040A_ELIG_IND) RNAPRXX RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

SHORT_TAX_FORM_IND

NO

 
DECODE(RCRAPP4_ADDRESS_CHG_FLAG) RNIMSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

ADDRESS_CHANGE_DESC

NO

 
DECODE(RCRAPP4_CUSTODIAL_PARENT) RNASUXX RNINAIQ NO          
DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST) RNINAIQ NO          
DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST) RNINAIQ NO          
DECODE(RCRAPP4_EFC_CHANGE_IND) RNIMSXX NO          
DECODE(RCRAPP4_FEE_WAIVER_IND) TBD NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

PROFILE_FEE_WAIVER_IND

NO

 
DECODE(RCRAPP4_FORMULA_FOR_CALC) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

FM_FORMULA_DESC

NO

 
DECODE(RCRAPP4_HAVE_CHILDREN) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

SUPPORT_CHILDREN_IND

NO

 
DECODE(RCRAPP4_HS_GED_RCVD) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

SECONDARY_SCHOOL_DIPLOMA_IND

NO

 
DECODE(RCRAPP4_LEGAL_RES_IND) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

LEGAL_RESIDENT_IND

NO

 
DECODE(RCRAPP4_NSLDS_MATCH) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

NATIONAL_STUDENT_LOAN_SYS_DESC

NO

 
DECODE(RCRAPP4_PAR_1040A_ELIG_IND) RNAPRXX RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_SHORT_TAX_FORM_IND

NO

 
DECODE(RCRAPP4_PAR_LEGAL_RES_IND) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_LEGAL_RESIDENT_IND

NO

 
DECODE(RCRAPP4_SAR_C_CHANGE_FLAG) RNIMSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

SAR_C_CHANGE_IND

NO

 
DECODE(RCRAPP4_SEC_INS_MATCH_IND) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

PERM_RESIDENCY_VER_STATUS_DESC

NO

 
DECODE(RCRAPP4_SOURCE_CORRECTION) RNIMSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

CORRECTION_SOURCE_DESC

NO

 
DECODE(RCRAPP4_SSA_CITIZEN_IND) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

CITIZENSHIP_TYPE_DESC

NO

 
DECODE(RCRAPP4_SS_MATCH) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

MILITARY_REGIST_STATUS_DESC

NO

 
DECODE(RCRAPP4_SS_REG_FLAG) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

MILITARY_REG_REQ_STATUS_DESC

NO

 
DECODE(RCRAPP4_TX_RET_FILED_IND) RNAPRXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

TAX_RETURN_FILED_DESC

NO

 
DECODE(RCRAPP4_TYPE_DATA_AVAIL) RNINAIQ NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

DATA_TYPE_AVAILABLE_DESC

NO

 
DECODE(RCRAPP4_VA_MATCH_FLAG) RNARSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

VETERAN_MATCH_STATUS_DESC

NO

 
DECODE(RCRAPP4_VISA_CLASS) RNASUXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

VISA_CLASSIFICATION_DESC

NO

 
DECODE(RCRAPP4_WORK_STUDY) RNANAXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

WORK_STUDY_INTEREST_IND

NO

 
DECODE(RCRESAR_AUTO_ZERO_EFC_FLAG) RNIMSXX NO          
DECODE(RCRESAR_A_BORN_BEFORE_IND) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

OLDER_THAN_24_IND

NO

 
DECODE(RCRESAR_A_CITZ_IND) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_CITIZENSHIP_DESC

NO

 
DECODE(RCRESAR_A_MARRIED) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_MARRIED_IND

NO

 
DECODE(RCRESAR_A_MRTL_STATUS_IND) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MARITAL_STATUS_IND

NO

 
DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PARENT_MARITAL_STATUS_IND

NO

 
DECODE(RCRESAR_A_PAR_TAX_FILED_IND) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PARENT_TAX_FILER_IND

NO

 
DECODE(RCRESAR_A_S_DEPENDANTS) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_DEPENDENT_IND

NO

 
DECODE(RCRESAR_A_TAX_FILED_IND) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

TAX_FILER_IND

NO

 
DECODE(RCRESAR_A_VA_STATUS) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_VETERAN_IND

NO

 
DECODE(RCRESAR_DUP_REQ_IND) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

DUPLICATE_REQUEST_IND

NO

 
DECODE(RCRESAR_EDE_ETI_IND) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ISIR_ELECT_TRANSACTION_DESC

NO

 
DECODE(RCRESAR_EDE_INST_IND) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ELECT_APPL_ENTRY_SOURCE_IND

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_1) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING1_DESC

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_10) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING10_DESC

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_2) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING2_DESC

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_3) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING3_DESC

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_4) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING4_DESC

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_5) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING5_DESC

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_6) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING6_DESC

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_7) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING7_DESC

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_8) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING8_DESC

NO

 
DECODE(RCRESAR_FED_HOUS_CDE_9) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING9_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_1) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG1_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_10) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG10_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_2) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG2_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_3) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG3_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_4) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG4_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_5) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG5_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_6) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG6_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_7) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG7_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_8) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG8_DESC

NO

 
DECODE(RCRESAR_M_SCHOOL_FLAG_9) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG9_DESC

NO

 
DECODE(RCRESAR_REC_TYPE) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PROCESSED_RECORD_TYPE_DESC

NO

 
DECODE(RCRESAR_SEC_EFC_TYPE) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

SECONDARY_EFC_TYPE_DESC

NO

 
DECODE(RCRESAR_SUB_APP) RNIMSXX NO          
DECODE(RCRIMP1_AID_STATUS) RNASUXX NO          
DECODE(RCRIMP1_APPLIC_TYPE) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

APPLICATION_TYPE_DESC

NO

 
DECODE(RCRIMP1_FIN_AID_STATUS) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

FINANCIAL_AID_STATUS_DESC

NO

 
DECODE(RCRIMP1_FOREIGN_ADDR_IND) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

FOREIGN_ADDRESS_IND

NO

 
DECODE(RCRIMP1_HOUS_CDE_10) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

HOUSING10_DESC

NO

 
DECODE(RCRIMP1_HOUS_CDE_9) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

HOUSING9_DESC

NO

 
DECODE(RCRIMP1_LINE2_SCHL_TYPE) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

LINE2_SCHOOL_TYPE_DESC

NO

 
DECODE(RCRIMP1_LINE3_SCHL_TYPE) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

LINE3_SCHOOL_TYPE_DESC

NO

 
DECODE(RCRIMP1_LINE4_SCHL_TYPE) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

LINE4_SCHOOL_TYPE_DESC

NO

 
DECODE(RCRIMP1_LINE5_SCHL_TYPE) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

LINE5_SCHOOL_TYPE_DESC

NO

 
DECODE(RCRIMP1_LINE6_SCHL_TYPE) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

LINE6_SCHOOL_TYPE_DESC

NO

 
DECODE(RCRIMP1_LINE7_SCHL_TYPE) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

LINE7_SCHOOL_TYPE_DESC

NO

 
DECODE(RCRIMP1_LINE8_SCHL_TYPE) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

LINE8_SCHOOL_TYPE_DESC

NO

 
DECODE(RCRIMP1_LOCATION_COMPUTER) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

PROFILE_COMPUTER_LOCATION_DESC

NO

 
DECODE(RCRIMP1_ONLINE_SIG) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

ONLINE_SIGNATURE_IND

NO

 
DECODE(RCRIMP1_OWN_BUS_HM_SELF_EMP) RNAPRXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

IM_SELF_EMPLOYED_IND

NO

 
DECODE(RCRIMP1_PAR_NTRL_SEP_DIV) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

PARENT_MARIT_STAT_SEP_DIV_DESC

NO

 
DECODE(RCRIMP1_PAR_OWN_BUS_FARM) RNAPRXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

PARENT_OWN_BUSINESS_IND

NO

 
DECODE(RCRIMP1_PAR_SELF_EMPLOYED) RNAPRXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

IM_PARENT_SELF_EMPLOYED_IND

NO

 
DECODE(RCRIMP1_PAR_SMALL_BUSINESS) RNAPRXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

IM_PARENT_LARGE_BUSINESS_IND

NO

 
DECODE(RCRIMP1_SMALL_BUSINESS) RNAPRXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

IM_LARGE_BUSINESS_IND

NO

 
DECODE(RCRIMP1_STU_MOST_SUPPORT_FROM) RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

PARENT_SUPPORT_PRIMARY_DESC

NO

 
DECODE(RCRIMP1_TRUST_AVAIL_IND) RNAPRXX RNASUXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

TRUST_AVAILABILITY_IND

NO

 
DECODE(RCRIMP1_TRUST_ESTAB_BY) RNAPRXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_PROFILE_SPEC

TRUST_ESTABLISHER_DESC

NO

 
DECODE(RNROVRD_ADD_BK_HOPE_OPT) RNAOVXX NO          
DECODE(RNROVRD_ALLOW_IM_PC_LOWR_FM) RNAOVXX NO          
DECODE(RNROVRD_ALLOW_IM_SC_LOWR_FM) RNAOVXX NO          
DECODE(RNROVRD_CALC_US_TAX_FM) RNAOVXX NO          
DECODE(RNROVRD_CALC_US_TAX_IM) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_CALC_FEDERAL_TAX_OVR_DESC

NO

 
DECODE(RNROVRD_CHG_DEPEND_FM) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_CHANGE_DEPENDENCY_STAT_DESC

NO

 
DECODE(RNROVRD_CHG_DEPEND_IM) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_CHANGE_DEPENDENCY_STAT_DESC

NO

 
DECODE(RNROVRD_FAMILY_ASSETS) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_ASSET_COMBINED_DESC

NO

 
DECODE(RNROVRD_FM_PAR_NUM_COL) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_PARENT_NO_COLLEGE_OVR_IND

NO

 
DECODE(RNROVRD_F_SSN_NO_DOB_REJ_OVRD) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_REJECT_S_IND

NO

 
DECODE(RNROVRD_F_SSN_NO_NAME_REJ_OVRD) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_REJECT_E_IND

NO

 
DECODE(RNROVRD_HOME_VAL_PROJ) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_HOME_VALUE_PROJ_DESC

NO

 
DECODE(RNROVRD_INV_PROJ) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_IMPUTE_ASSET_DESC

NO

 
DECODE(RNROVRD_LIMIT_PC_BY_BDGT) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

LIMIT_OTHERS_SHARE_PC_DESC

NO

 
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD) RNAOVXX NO          
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD_ RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_REJECT_T_IND

NO

 
DECODE(RNROVRD_M_SSN_NO_NAME_REJ_OVRD) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_REJECT_F_IND

NO

 
DECODE(RNROVRD_NON_CUST_OPT) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_NONCUS_CONT_CAL_DESC

NO

 
DECODE(RNROVRD_NON_CUST_PC_OPT) RNAOVXX NO          
DECODE(RNROVRD_PAR_ADD_BK_HOPE_OPT) RNAOVXX NO          
DECODE(RNROVRD_PAR_AGI_OPT) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_WHICH_AGI_DESC

NO

 
DECODE(RNROVRD_PAR_CALC_US_TAX_FM) RNAOVXX NO          
DECODE(RNROVRD_PAR_CALC_US_TAX_IM) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_CALC_FED_TAX_OV_DESC

NO

 
DECODE(RNROVRD_PAR_USE_PROJ_INC_EFM) RNAOVXX NO          
DECODE(RNROVRD_SKIP_AGE_EXCL) RNAOVXX NO          
DECODE(RNROVRD_SSN_NO_DOB_REJ_OVRD) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_REJECT_R_IND

NO

 
DECODE(RNROVRD_SSN_NO_NAME_REJ_OVRD) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_REJECT_D_IND

NO

 
DECODE(RNROVRD_S_HOME_VAL_PROJ) NA NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_HOME_VALUE_PROJECT_DESC

NO

 
DECODE(RNROVRD_USE_PROJ_INC_EFM) RNAOVXX NO          
DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

USE_PARENT_STATE_PROV_TAX_IND

NO

 
DECODE(RNROVRD_ZERO_LOSS_BUS_FARM) RNAOVXX NO          
DECODE(RNROVRD_ZERO_LOSS_OTH) RNAOVXX NO          
DECODE(RPRADSB_ALTERNATE_PELL_IND,'N') ROAPELL NO          
DECODE(RPRADSB_CONCUR_ENROLL_FLAG) NA NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

COD_CONCURRENT_ENROLLMENT_IND

NO

 
DECODE(RPRADSB_DEBIT_CREDIT_IND) RPRADSB NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

DEBIT_CREDIT_DESC

NO

 
DECODE(RPRADSB_DISBURSE_LOAD) RPAAWRD NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

DISBURSEMENT_LOAD_DESC

NO

 
DECODE(RPRADSB_DISBURSE_LOAD_OPT) RPRADSB NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

DISBURSEMENT_LOAD_OPT_DESC

NO

 
DECODE(RPRADSB_DISB_ACPT_DEBIT_CR_IND) RPRADSB NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

COD_DEBIT_CREDIT_DESC

NO

 
DECODE(RPRADSB_DISB_ACTION_CODE) RPRADSB NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

COD_DISBURSEMENT_ACTION_DESC

NO

 
DECODE(RPRADSB_PELLC_DISB_LOAD) RPAAWRD NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

PELL_CALCULATED_DISB_LOAD_DESC

NO

 
DECODE(RPRADSB_PELLC_DISB_LOAD_OPT) RPRADSB NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

PELL_CALC_DISB_LOAD_OPT_DESC

NO

 
DECODE(RPRADSB_POTENTIAL_OVERPMT_FLAG) NA NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

COD_POTENTIAL_OVERPAYMENT_IND

NO

 
DECODE(RPRADSB_SHARED_SAR_ID_FLAG) NA NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

COD_SHARED_SAR_IDENTIFIER_IND

NO

 
DECODE(RPRARSC_TYPE_CODE) RPAARSC NO COMPOSITE VIEW

AR_APPLICANT_RESOURCE

RESOURCE_TYPE_DESC

NO

 
DECODE(RPRATRM_LOCK_IND) NA NO COMPOSITE VIEW

AR_AWARD_BY_PERSON

AWARD_LOCKED_DESC

NO

This function returns Locked if the student's lock indicator RPRATRM_LOCK_IND is Y, Locked except for enrollment adjustments during disbursement if the value is E, and Not Locked if the value is N.
DECODE(RPRATRM_NSLDS_OVRD_IND) NA NO         This function returns Limit Tests (aggregate) if the student rules have been overridden for the award for the period if the value is L, Default Tests if the value is D, Overpayment Tests if the value is O, and All Tests if the value is A.
DECODE(RPRATRM_PCKG_LOAD_IND) NA NO         This function returns Full Time as a time status description if the packaging load indicator for the student RPRATRM_PCKG_LOAD_IND is 1, 3/4 Time if 2, 1/2 Time if 3, Less than 1/2 Time if 4, and Not Enrolled if 5.
DECODE(RPRATRM_PELL_AWRD_LOAD_OPT) NA NO         This function returns Full Time as a pell enrollment award option description if the applicant grant award enrollment option for the student RPRATRM_PELL_AWRD_LOAD_OPT is 1, 3/4 Time if 2, 1/2 Time if 3, Less than 1/2 Time if 4, Adjusted Hours if A, Billing hours if B, Defaults if D, Expected enrollment if E, ISIR/FAFSA enrollment if I, and Manual if M.
DECODE(RPRAWRD_LOCK_IND) NA NO COMPOSITE VIEW

AR_AWARD_BY_PERSON

ANNUAL_AWARD_LOCKED_DESC

NO

This function returns Locked as an award locked description if the award has been locked for the student RPRAWRD_LOCK_IND is Y, Locked except for enrollment adjustements during disbursement if E, and Not locked if N.
DECODE(RPRAWRD_OVERRIDE_YR_IN_COLL) NA NO          
DECODE(RPRAWRD_SYS_IND) NA NO COMPOSITE VIEW

AR_AWARD_BY_PERSON

SYSTEM_DESC

NO

This function returns Manual as a system description if the system indicator for the applicant RPRAWRD_SYSTEM_IND is M, System if S, and Both if B.
DECODE(RPRAWRD_UNMET_NEED_OVRDE_IND) NA NO         This function returns Loan as an unmet need override description if the unmet need override indicator for the applicant RPRAWRD_UNMET_NEED_OVRD_IND is L, No if N, and Yes if Y.
DECODE(RPRLADB_DISBURSE_LOAD) RPALDSB NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

ENROLLMENT_LOAD_DESC

NO

 
DECODE(RPRLADB_DISBURSE_LOAD_OPT) RPALDSB NO          
DECODE(RPRLADB_DISB_STATUS) RPALORG NO          
DECODE(RPRLADB_FEED_IND) NA NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

DISBURSEMENT_FEED_DESC

NO

 
DECODE(RPRLADB_HOLD_REL_STATUS) RPAELAP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

HOLD_RELEASE_STATUS_DESC

NO

 
DECODE(RPRLADB_SERV_TRANS_TYPE) NA NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

TRANSACTION_TYPE_DESC

NO

 
DECODE(RPRLAPP_COSIGN1_RELATION_IND) NA NO COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_RELATIONSHIP_DESC

NO

DECODE(RPRLAPP_COSIGN1_RELATION_IND,'E','Employer','F','Friend','G','Guardian','O','Other','P','Parent','R','Relative','S','Sibling',NULL)
DECODE(RPRLAPP_COSIGN2_RELATION_IND) NA NO COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN2_RELATIONSHIP_DESC

NO

DECODE(RPRLAPP_COSIGN1_RELATION_IND,'E','Employer','F','Friend','G','Guardian','O','Other','P','Parent','R','Relative','S','Sibling',NULL)
DECODE(RPRLAPP_IN_DEFAULT) RPALORG NO          
DECODE(RTVFSRC_IND) NA NO COMPOSITE VIEW

AR_FINAID_FUND

FUND_SOURCE_TYPE_DESC

NO

NA
DECODE(RTVFTYP_ATYP_IND) NA NO COMPOSITE VIEW

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

FINANCIAL_AID_TYPE_DESC

GIFT_OR_SELF_HELP_AID_DESC

GIFT_OR_SELF_HELP_AID

NO

NO

NO

NA
DECODE(RTVFTYP_IND) NA NO          
DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME') SAAADMS NO         NA
DECODE(SFBETRM_AR_IND) TBD NO          
DECODE(SFBETRM_MAXH_SRCE_CDE) TBD NO          
DECODE(SFBETRM_MINH_SRCE_CDE) TBD NO          
DECODE(SFBETRM_PIDM, NULL, 'N', 'Y') NA NO          
DECODE(SFRPLAN_COMMENT) NA NO          
DECODE(SFRPLAN_SRC_CDE) NA NO          
DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y') SFASLST NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

AS_STUDENT_COURSE_HISTORY

FINAL_GRADE_ROLL_IND

FINAL_GRADE_ROLL_IND

NO

NO

This function returns an N if the grade date SFRSTCR_GRDE_DATE is null else it returns a Y.
DECODE(SFRSTCR_PIDM,NULL,'N','Y') SFAREGS NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

IN_PROGRESS_COURSE_IND

NO

This function returns an N if the registration record SFRSTCR does not exist for the specified UID, academic period and course else it returns a Y.
DECODE(SFRSTCR_PIDM,NULL,'Y','N') SFAREGS NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

AS_STUDENT_COURSE_IN_PROGRESS

TRANSFER_COURSE_IND

INSTITUTION_COURSE_IND

NO

NO

This function returns an N if the registration record SFRSTCR does not exist for the specified UID, academic period and course else it returns a Y.
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1)+DECODE(SGBSTDN_LEVL_CODE_2,NULL,0, DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1)) SGASTDN NO         This function returns a 0, 1, or 2 based on the matriculated academic period SGBSTDN_TERM_CODE_MATRIC and the secondary level code SGBSTDN_LEVL_CODE_2. If the matriculated academic period is null and the secondary level code is null then this will return a 0. If the matriculated academic period is null and the secondary level code is not null then this will return a 0. If the matriculated academic period is not null and the secondary level code is null then it will return a 1. If both values are not null then it will return a 2.
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,N, Y) SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

MATRICULATED_IND

NO

DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,N,Y)
DECODE(SHRATTR_PIDM, NULL, 'N', 'Y') NA NO         NA
DECODE(SHRDGDH_HOND_CODE,NULL,NULL,'D') SHADEGR NO COMPOSITE VIEW

AS_OUTCOME_HONOR_DEPT

HONOR_IND

NO

This function returns a null if the honor code SHRDGDH_HOND_CODE is null, else it returns an D.
DECODE(SHRDGIH_HONR_CODE,NULL,NULL,'I') SHADEGR NO COMPOSITE VIEW

AS_OUTCOME_HONOR_INST

HONOR_IND

NO

This function returns a null if the honor code SHRDGIH_HONR_CODE is null, else it returns an I.
DECODE(SHRLGPA_GPA_TYPE_IND,'I', 'INSTITUTION','T','TRANSFER','O', 'OVERALL') NA NO COMPOSITE VIEW

AS_GPA_LEVEL

GPA_TYPE_DESC

NO

This function returns Institution if the gpa type indicator SHRLGPA_GPA_TYPE_IND is I, it returns Transfer if the gpa type indicator is a T else it returns Overall if the gpa type indicator is an O.
DECODE(SHRTATT_PIDM, NULL, 'N', 'Y') NA NO COMPOSITE VIEW

AS_STUDENT_COURSE_ATTR_TRANS

TRANSFER_COURSE_IND

NO

NA
DECODE(SHRTATT_PIDM, NULL, 'Y', 'N') NA NO COMPOSITE VIEW

AS_STUDENT_COURSE_ATTR_TRANS

INSTITUTION_COURSE_IND

NO

NA
DECODE(SHRTGPA_GPA_TYPE_IND,'I', 'INSTITUTION','T','TRANSFER') NA NO COMPOSITE VIEW

AS_GPA_TERM

GPA_TYPE_DESC

NO

This function returns Institution if the gpa type indicator SHRLGPA_GPA_TYPE_IND is I, else it returns Transfer if the gpa type indicator is a T.
DECODE(SHRTRCE_PIDM,NULL,'N','Y') SHATRNS NO         This function returns a N if the transfer course record SHRTRCE doesn't exist, else a Y.
DECODE(SHRTRCR_ART_IND,NULL,'NO ARTICULATION RULE','N','COURSE HAS NO INSTITUTION EQUIVALENT','Y','COURSE HAS INSTITUTION EQUIVALENT') TBD NO          
DECODE(SHRTTRM_RECORD_STATUS_IND) NA NO          
DECODE(SIBFACD_PRIMARY_ACTIVITY) NA NO         This function returns Administrator as primary activity description if the primary activity for the faculty SIBFACD_PRIMARY_ACTIIVTY is A, Instructional if I, and Research if R.
DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C', 'CLASS','OTHER') SLARASG NO COMPOSITE VIEW

AS_ROOM_ASSIGNMENT

ROOM_TYPE_DESC

NO

This function returns DORM if the room type SLBRDEF_ROOM_TYPE is D, CLASS if the room type is C else OTHER.
DECODE(SORAPPT_INTV_PIDM,NULL,NULL, F_FORMAT_NAME(SORAPPT_INTV_PIDM,'LFMI')) SOAAPPT NO         This function returns null if the pidm is null SORAPPT_INTV_PIDM else it returns the formatted name of the interviewer.
DECODE(SORBACD_STATE_APPROV_IND) NA NO         DECODE(SORBACD_STATE_APPROV_IND,'Y','Y','N')
DECODE(SORDEGR_SBGI_CODE) NA NO          
DECODE(SORLCUR_SITE_CODE) NA NO         DECODE(SORLCUR_SITE_CODE,NULL,SGBSTDN_SITE_CODE,SORLCUR_SITE_CODE)
DECODE(SORLCUR_TERM_CODE_ADMIT) NA NO         NA
DECODE(SORLCUR_TERM_CODE_MATRIC) SGASTDN NO         DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,'N','Y')
DECODE(SPBPERS_NAME_PREFIX,NULL,DECODE( SPBPERS_SEX,'M','MR.','F','MS.'), SPBPERS_NAME_PREFIX) NA NO         This function returns Mr. or Ms. Based on the gender if the name prefix SPBPERS_NAME_PREFIX is null, else it returns the name prefix.
DECODE(SPBPERS_SEX,'M','MALE','F', 'FEMALE','N','NOT REPORTED') SPAPERS NO COMPOSITE VIEW

AS_PERSON

AA_RELATIONSHIP

GENDER_DESC

RELATED_GENDER_DESC

NO

NO

This calculation returns MALE if the gender SPBPERS_SEX is M else it returns FEMALE if the gender is F else if the gender is N it returns NOT REPORTED.
DECODE(SPBPERS_VERA_IND) SPAPERS NO COMPOSITE VIEW

AS_PERSON

VETERAN_CATEGORY_DESC

NO

This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran.
DECODE(SPBPERS_VERA_IND, NULL, NULL, O, OTHER PROTECTED VETERAN ONLY, V, VIETNAM VETERAN ONLY, B, BOTH - VIETNAM AND OTHER ELIGIBLE VETERAN) SPAPERS NO         NA
DECODE(SPBPERS_VERA_IND,NULL,NULL, 'VETERAN') SPAPERS NO         This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran.
DECODE(SPRIDEN_ID,NULL,NULL,'BANNER') NA NO COMPOSITE VIEW

AS_PERSON

ID_NUMBER_SOURCE

NO

This function returns null if the id SPRIDEN_ID is null else it returns BANNER.
DECODE(SPRMEDI_DISB_IND,'Y','Y','N') SPAMEDI NO COMPOSITE VIEW

AS_MEDICAL_INFORMATION

PRIMARY_DISABILITY_IND

NO

NA
DECODE(SSRFEES_FEE_IND) SSADETL NO          
DECODE(STVAPDC_APPL_INACT) NA NO COMPOSITE VIEW

AS_ADMISSIONS_DECISION

APPLICATION_INACTIVE_IND

NO

DECODE (stvapdc_appl_inact, NULL, 'N', stvapdc_appl_inact)
DECODE(STVAPDC_INST_ACC_IND) NA NO COMPOSITE VIEW

AS_ADMISSIONS_DECISION

INSTITUTION_ADMIT_IND

NO

DECODE (stvapdc_inst_acc_ind, NULL, 'N', stvapdc_inst_acc_ind)
DECODE(STVAPDC_REJECT_IND) NA NO COMPOSITE VIEW

AS_ADMISSIONS_DECISION

INSTITUTION_DENIED_IND

NO

DECODE (stvapdc_reject_ind, NULL, 'N', stvapdc_reject_ind)
DECODE(STVAPDC_SIGNF_IND) NA NO COMPOSITE VIEW

AS_ADMISSIONS_DECISION

APPLICATION_SIGNIF_IND

NO

DECODE (stvapdc_signf_ind, NULL, 'N', stvapdc_signf_ind)
DECODE(STVAPDC_STDN_ACC_IND) NA NO COMPOSITE VIEW

AS_ADMISSIONS_DECISION

APPLICANT_ACCEPT_IND

NO

This functions returns Applicant when the indicator ro student acceptance indicated by the decision value is Y, Institution with the value for institution acceptance indicated by the decision value is Y, Institution when the decision code is a reject decision, and Indeterminate if either value is null. CASE WHEN stvapdc_stdn_acc_ind = 'Y' THEN 'Applicant' WHEN stvapdc_inst_acc_ind = 'Y' THEN 'Institution' WHEN stvapdc_reject_ind = 'Y' THEN 'Institution' ELSE 'Indeterminate' END
DECODE(STVEVEN_TRANS_IND) NA NO          
DECODE(STVRESD_IN_STATE_IND) NA NO          
DECODE(STVRRCD_MONTHLY_IND,'Y', 'MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y', 'DAILY','TERMLY')) SLARASG NO COMPOSITE VIEW

AS_ROOM_ASSIGNMENT

ROOM_RATE_TIME

NO

This function returns Monthly if the monthly indicator STVRRCD_MONTHLY_IND is Y, it returns Daily if the daily indicator STVRRCD_DAILY_IND is Y, else it returns Termly.
DECODE(STVSBGI_TYPE_IND,'C','COLLEGE', 'H','HIGHSCHOOL','S','SOURCE-ONLY',NULL) SOASBGI NO COMPOSITE VIEW

AS_INSTITUTION

INSTITUTION_TYPE_DESC

NO

This function returns COLLEGE when the institution type STVSBGI_TYPE_IND is C, HIGHSCHOOL if the institution type is an H, SOURCE-ONLY if the institution type is S else null.
DECODE(TBBACCT_REFUND_IND) NA NO         This function determines the refund indicator description based upon the refund indicator. 'N'= 'No refund' 'Y' = 'Generate Refund' 'P' = 'Refund being processed' or NULL
DECODE(TBBCSTU_DEL_IND) TSACONT NO COMPOSITE VIEW

AT_CONTRACT

STUDENT_INACTIVATED_IND

NO

NA
DECODE(TBBESTU_DEL_IND) TSAEXPP NO COMPOSITE VIEW

AT_EXEMPTION

EXEMPTION_CANCELLED

NO

NA
DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y') TSADETC NO COMPOSITE VIEW

AT_ACCOUNT_DETAIL

RETURNED_CHECK_IND

NO

This function returns a N if the detail code TBBRETC_DETAIL_CODE is null else it return a Y.
DECODE(TBRACCD_BILL_DATE, NULL, NULL, TBRACCD_AMOUNT) TSADETL NO COMPOSITE VIEW

AT_ACCOUNT_DETAIL

BILL_AMOUNT

NO

This function returns a null if the billing date TBRACCD_BILL_DATE is null, else it returns the transaction amount TBRACCD_AMOUNT.
DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_AMOUNT) TSADETL NO COMPOSITE VIEW

AT_ACCOUNT_DETAIL

ACCOUNT_POSTED_AMOUNT

NO

This function returns null if the feed date TBRACCD_FEED_DATE is null else it returns the transaction amount TBRACCD_AMOUNT.
DECODE(TBRDEPO_FEED_DATE, NULL, NULL, TBRDEPO_AMOUNT) TSADETL NO COMPOSITE VIEW

AT_AR_DEPOSIT

ACCOUNT_POSTED_AMOUNT

NO

This function returns null if the feed date TBRDEPO_FEED_DATE is null else it returns the transaction amount TBRDEPO_AMOUNT.
DECODE(TBRMISD_PIDM) TFAMISC NO         This function determines if the entity is external to the system.
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y') NA NO COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_PLAN

PLANNED_MOVE_COMPLETE_IND

MOVE_COMPLETION_IND

NO

NO

NA
DECODE(TRANSACTION_HISTORY.FUND_POOL, NULL,FUND_HIERARCHY.FUND_POOL_DESC, TRANSACTION_HISTORY.FUND_POOL_DESC) NA NO         Population of fund pool description is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
EARN NA NO COMPOSITE VIEW

AN_PERSONNEL_ACTION_EARNING

PAF_TRANSACTION_TYPE

NO

 
FFRMASA_AMT+FFRMASA_ADJ_AMT- FFRMASA_DEPR_ACCUM_AMT FFAMAST NO COMPOSITE VIEW

AF_FIXED_ASSET_DEPRECIATION

BOOK_VALUE

NO

This calculation returns the book value for an asset by taking its original cost adding any adjustments and then subtracting the accumulated depreciation.
FGBGENL_SUM_PERIODIC_DR- FGBGENL_SUM_PERIODIC_CR FGIGLAC NO COMPOSITE VIEW

AF_GENERAL_LEDGER

CURRENT_ACTUAL

NO

This calculation returns the current actual for the general ledger entry by subtracting the credits from the debits.
FGBOPAL_XX_ACCTD_BUD - FGBOPAL_XX- 1_ACCT_BUD FGIBDST NO COMPOSITE VIEW

AF_OPERATING_LEDGER

CURR_ACCUMULATED_BUDGET

NO

This calculation returns the accumulated budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_ADOPT_BUD - FGBOPAL_XX- 1_ADOPT_BUD FGIBDST NO COMPOSITE VIEW

AF_OPERATING_LEDGER

CURR_ADOPTED_BUDGET

NO

This calculation returns the adopted budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_BUD_ADJT - FGBOPAL_XX- 1_BUD_ADJT FGIBDST NO COMPOSITE VIEW

AF_OPERATING_LEDGER

CURR_BUDGET_ADJUSTMENTS

NO

This calculation returns the budget adjustments for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_BUD_RSRV - FGBOPAL_XX- 1_BUD_RSRV FGIBDST NO COMPOSITE VIEW

AF_OPERATING_LEDGER

CURR_BUDGET_RESERVATION

NO

This calculation returns the budget reservations for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_ENCUMB - FGBOPAL_XX-1_ENCUMB FGIBDST NO COMPOSITE VIEW

AF_OPERATING_LEDGER

CURR_ENCUMBRANCES

NO

This calculation returns the encumbrances for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_TEMP_BUD - FGBOPAL_XX- 1_TEMP_BUD FGIBDST NO COMPOSITE VIEW

AF_OPERATING_LEDGER

CURR_TEMPORARY_BUDGET

NO

This calculation returns the temporary budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FGBOPAL_XX_YTD_ACTV - FGBOPAL_XX- 1_YTD_ACTV NA NO COMPOSITE VIEW

AF_OPERATING_LEDGER

CURR_YEAR_TO_DATE_ACTIVITY

NO

This calculation returns the activity for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_ACCTD_BUD - FRRGRNL_XX- 1_ACCTD_BUD FRIGITD NO COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_ACCOUNTED_BUDGET

NO

This calculation returns the accounted budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_ADOPT_BUD - FRRGRNL_XX- 1_ADOPT_BUD FRIGITD NO COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_ADOPTED_BUDGET

NO

This calculation returns the adopted budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_BUD_ADJT - FRRGRNL_XX- 1_BUD_ADJT FRIGITD NO COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_BUDGET_ADJUSTMENTS

NO

This calculation returns the budget adjustments for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_BUD_RSRV - FRRGRNL_XX- 1_BUD_RSRV FRIGITD NO COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_BUDGET_RESERVATIONS

NO

This calculation returns the budget reservations for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_ENCUMB - FRRGRNL_XX-1_ENCUMB FRIGITD NO COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_ENCUMBRANCES

NO

This calculation returns the encumbrances for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_TEMP_BUD - FRRGRNL_XX- 1_TEMP_BUD NA NO COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_TEMPORARY_BUDGET

NO

This calculation returns the temporary budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRGRNL_XX_YTD_ACTV - FRRGRNL_XX- 1_YTD_FRRGRNL FRIGITD NO COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_YEAR_TO_DATE_ACTIVITY

NO

This calculation returns the activity for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRRMEML_XX_YTD_ACTV - FRRMEML_XX- 1_YTD_ACTV FRIMEMO NO COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_MEMO_COSTS

NO

This calculation returns the memo costs for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVENT_DESC NA NO          
FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC NA NO COMPOSITE VIEW

AF_GRANT_EVENT

GRANT_EVENT_FULL_DESC

NO

 
FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||F TVSHIP_PHONE_EXT NA NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

AF_PURCHASE_ORDER

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

NO

NO

This calculation formulates the combined phone number by concatenating FTVSHIP_PHONE_AREA, FTVSHIP_PHONE_NUM, and FTVSHIP_PHONE_EXT.
FTVVEND_PHONE_AREA||FTVVEND_PHONE_NUMBER ||FTVVEND_PHONE_EXT NA NO COMPOSITE VIEW

AF_VENDOR

PHONE_NUMBER_COMBINED

NO

This calculation formulates the combined phone number by concatenating FTVVEND_PHONE_AREA, FTVVEND_PHONE_NUMBER, and FTVVEND_PHONE_EXT.
F_GET_NORM_BALANCE NA NO          
IF AGBMGID_AMT_PAID > = AGBMGID_AMT THEN Y, ELSE N NA NO         NA
IF AGBMGID_AMT_PAID IS > 0 AND < AGBMGID_AMT THEN Y, ELSE N NA NO         NA
LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+ RCRAPP2_C_PAR_1_CTRB_FOR_STDT) NA NO         LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)
LEVEL FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_FUND_HIERARCHY

AF_PROGRAM_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY

AF_ORGANIZATION_HIERARCHY

AF_ORGN_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_FUND_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

FUND_TYPE_LEVEL

ACCOUNT_TYPE_LEVEL

FUND_LEVEL

PROGRAM_LEVEL

ACCOUNT_LEVEL

ACCOUNT_LEVEL

LOCATION_LEVEL

ORGANIZATION_LEVEL

ORGANIZATION_LEVEL

ACCOUNT_TYPE_LEVEL

FUND_LEVEL

LOCATION_LEVEL

PROGRAM_LEVEL

FUND_TYPE_LEVEL

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

This value is retrieved upon formulation of the validation table hierarchy and pertains to what level this code associates to within its hierarchy. (Level 1 being the highest level.)
MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS - MAKFUNC.F_CAMP_EXPENSES NA NO          
MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS NA NO          
MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES - MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS NA NO          
MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100 NA NO          
MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS NA NO          
MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS NA NO          
MAKFUNC.F_SOL_FR_TOTAL_PLEDGES - MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS NA NO          
MAX(APRACYR_YEAR) NA NO COMPOSITE VIEW

AA_SPECIAL_ACTIVITY

LAST_YEAR

NO

NA
MEKFUNC.F_AUTHORIZED_TOTAL ( R.PORTFOLIO_KEY, '%', 'Y') + MEKFUNC.F_TOTAL_NOT_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y') TBD NO          
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y') TBD NO          
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '9900ADVC', '%','Y') TBD NO          
MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE FNIEBAL NO         NA
MIN(APRACYR_YEAR) NA NO COMPOSITE VIEW

AA_SPECIAL_ACTIVITY

FIRST_YEAR

NO

NA
MONTHS_BETWEEN NA NO COMPOSITE VIEW

AP_PAST_EMPLOYMENT

YEARS_MONTHS_IN_POSITION

NO

NA
MONTHS_BETWEEN(NVL(APREHIS_TO_DATE, SYSDATE),APREHIS_FROM_DATE) NA NO COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

MONTHS_IN_POSITION

NO

NA
MONTHS_BETWEEN(NVL(PPREXPE_END_DATE, SYSDATE),PPREXPE_START_DATE) NA NO          
MONTHS_BETWEEN(PPREXPE_END_DATE, PPREXPE_START_DATE) NA NO         NA
NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND NBAPBUD NO COMPOSITE VIEW

AN_POSITION_BUDGET

AMOUNT_REMAINING

NO

This function calculates the result of the budget minus the encumbrance and minus the expenditures. NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND.
NVL (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE) NA NO COMPOSITE VIEW

AS_PREVIOUS_EDUCATION_PCOL

TRANSCRIPT_RECEIVED_DATE

NO

NVL (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE) returns transfer received date and if null, then returns prior college transcript received date.
NVL(ADBDESG_WEB_GIFT_IND,'N') NA NO COMPOSITE VIEW

AA_DESIGNATION

ALLOW_WEB_GIFT_IND

NO

 
NVL(ADBDESG_WEB_PLDG_IND,'N') NA NO COMPOSITE VIEW

AA_DESIGNATION

ALLOW_WEB_PLEGE_IND

NO

 
NVL(ADRCONF_CONFID_IND) NA NO COMPOSITE VIEW

AA_DESIGNATION_COMMENT

COMMENT_CONFIDENTIALITY_IND

NO

 
NVL(AFBCAMP_ASSOC_IND,'N') NA NO          
NVL(AFRCSOL_GOAL,0) NA NO          
NVL(AFRDESG_GOAL,0) NA NO          
NVL(AGBPLDG_MATCH_FORM_IND) NA NO COMPOSITE VIEW

AA_PLEDGE

MATCHING_GIFT_FORM_IND

NO

 
NVL(AGBPLDG_MATCH_PROCESSED) NA NO COMPOSITE VIEW

AA_PLEDGE

MATCH_GIFT_FORM_PROCESSED_IND

NO

 
NVL(AGBPLDG_MGFORM_READYTOSEND) NA NO COMPOSITE VIEW

AA_PLEDGE

MATCHGIFT_FORM_READYTOSEND_IND

NO

 
NVL(AGBPLDG_PACK_IND,'N'), NA NO COMPOSITE VIEW

AA_PLEDGE

PLEDGE_ACKNOWLEDGED_IND

NO

NA
NVL(AGBPLDG_RECEIPT_IND,'N'), NA NO COMPOSITE VIEW

AA_PLEDGE

RECEIPT_REQUIRED_IND

NO

NA
NVL(AGRGAUX_DEDUCT_FOR_TAXES,'N') NA NO COMPOSITE VIEW

AA_GIFT_AUXILIARY

DEDUCT_FOR_TAXES_IND

NO

NA
NVL(AMBPLAN_END_DATE,'31-DEC-2099') NA NO          
NVL(AMRCONF_CONFID_IND) NA NO COMPOSITE VIEW

AA_PROSPECT_CONF_COMMENT

COMMENT_CONFIDENTIALITY_IND

NO

 
NVL(AMRCONT_CONFID_IND) NA NO COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

TICKLER_CONFIDENTIAL_IND

NO

 
NVL(AMRINFO_WEB_GIFT_IND,'N') NA NO COMPOSITE VIEW

AA_PROSPECT_INFO

ALLOW_WEB_GIFT_IND

NO

 
NVL(AMRINFO_WEB_PLDG_IND,'N') NA NO COMPOSITE VIEW

AA_PROSPECT_INFO

ALLOW_WEB_PLEDGE_IND

NO

 
NVL(AMRSTAF_END_DATE,'31-DEC-2099') NA NO          
NVL(AMRSTAF_SOLICIT_IND,'N') NA NO COMPOSITE VIEW

AA_PROSPECT_INFO

SOLICITOR_IND

NO

 
NVL(APRCONF_CONFID_IND) NA NO COMPOSITE VIEW

AA_CON_ENTITY_CONF_COMMENT

COMMENT_CONFIDENTIALITY_IND

NO

 
NVL(APRCONF_DISP_NOTES_IND) NA NO COMPOSITE VIEW

AA_CON_ENTITY_CONF_COMMENT

DISPLAYED_IN_NOTE_IND

NO

 
NVL(APRCONF_OK_FOR_NOTES_IND) NA NO COMPOSITE VIEW

AA_CON_ENTITY_CONF_COMMENT

OK_FOR_NOTE_IND

NO

 
NVL(APRCONF_REVIEWED_IND) NA NO COMPOSITE VIEW

AA_CON_ENTITY_CONF_COMMENT

WEB_REVIEWED_IND

NO

 
NVL(ASBSORG_DOLLAR_GOAL,) NA NO COMPOSITE VIEW

AA_SOLICITOR_ORGANIZATION

ORGANIZATION_GOAL

NO

 
NVL(ASBSORG_DOLLAR_GOAL,0) NA NO          
NVL(ASBSORG_DONOR_COUNT_GOAL,) NA NO COMPOSITE VIEW

AA_SOLICITOR_ORGANIZATION

ORGANIZATION_DONOR_COUNT_GOAL

NO

 
NVL(ASBSORG_DONOR_COUNT_GOAL,0) NA NO          
NVL(ASBSORG_UPD_WEB_IND) NA NO COMPOSITE VIEW

AA_SOLICITOR_ORGANIZATION

ALLOW_WEB_UPDATE_IND

NO

 
NVL(ASRSORG_UPD_WEB_IND) NA NO COMPOSITE VIEW

AA_SOLICITOR_ORG_FUNDRAISER

AA_CAMPAIGN_FUNDRAISER

ALLOW_WEB_UPDATE_SOLICITOR_IND

ALLOW_WEB_UPDATE_SOLICITOR_IND

NO

NO

 
NVL(ATVCMPT_CAPITAL_IND,'N') NA NO          
NVL(ATVEMPS_ACTIVE_IND,'N') ATVEMPS NO COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYMENT_STATUS_ACTIVE_IND

NO

NA
NVL(AXBMGID_MGFORM_READYTOSEND) NA NO COMPOSITE VIEW

AA_PLEDGE_MATCHING

MATCH_FORM_SENT_IND

NO

 
NVL(CURR_ADOPTED_BUDGET + CURR_BUDGET_ADJUSTMENTS, 0) NA NO         Calculates the total current budget as current adopted budget + current budget adjustments.
NVL(CURR_YEAR_TO_DATE_ACTV + CURR_ENCUMBRANCES + CURR_BUDGET_RESERVATION, 0) NA NO         Calculates the current commited balance as current year to date activity + current encumbrances + current budget reservations (requisistions).
NVL(FABINVH_ACH_OVERRIDE_IND,'N') NA NO COMPOSITE VIEW

AF_INVOICE

DIRECT_DEPOSIT_OVERRIDE_IND

NO

 
NVL(FABINVH_DISB_AGENT_IND,'N') NA NO COMPOSITE VIEW

AF_INVOICE

DISBURSING_AGENT_IND

NO

 
NVL(FABINVH_EDIT_DEFER_IND,'N') NA NO COMPOSITE VIEW

AF_INVOICE

DEFERRED_EDIT_IND

NO

 
NVL(FABINVH_INVD_RE_ESTABLISH_IND,'N') NA NO COMPOSITE VIEW

AF_INVOICE

INVOICE_RE_ESTABLISHED_IND

NO

 
NVL(FABINVH_NSF_ON_OFF_IND,'N') NA NO COMPOSITE VIEW

AF_INVOICE

NSF_ON_OFF_IND

NO

 
NVL(FABINVH_RUIV_IND,'N') FAAINVE NO COMPOSITE VIEW

AF_INVOICE

REPEATING_INVOICE_IND

NO

 
NVL(FABINVH_RUIV_INSTALLMENT_IND,'N') FAAINVE NO COMPOSITE VIEW

AF_INVOICE

INSTALLMENT_IND

NO

 
NVL(FABINVH_SINGLE_ACCTG_IND,'N') NA NO COMPOSITE VIEW

AF_INVOICE

DOCUMENT_ACCOUNTING_IND

NO

 
NVL(FABINVH_TEXT_IND,'N') NA NO COMPOSITE VIEW

AF_INVOICE

TEXT_EXISTS_IND

NO

 
NVL(FABRUIV_MAX_SUB,0) NA NO COMPOSITE VIEW

AF_INVOICE

MAXIMUM_NUMBER_SUBMISSIONS

NO

 
NVL(FABRUIV_MAX_SUB,0) - NVL( FABRUIV_SUB_TO_DATE,0) NA NO COMPOSITE VIEW

AF_INVOICE

REMAINING_SUBMISSIONS

NO

 
NVL(FABRUIV_SUB_TO_DATE,0) NA NO COMPOSITE VIEW

AF_INVOICE

SUBMISSIONS_TO_DATE

NO

 
NVL(FARINVA_APPR_AMT,0)+NVL( FARINVA_ADDL_CHRG_AMT,0)+NVL( FARINVA_TAX_AMT,0)-NVL(FARINVA_DISC_AMT, 0) FAAINVE NO COMPOSITE VIEW

AF_INVOICE_ACCOUNTING

APPROVED_CHARGE_AMOUNT

NO

This calculation returns the approved charge amount by summing the approved amount, additional charges, and tax amount and subtracting any associated discount.
NVL(FGBENCD_ABAL_OVERRIDE) NA NO          
NVL(FGBENCH_EDIT_DEFERRAL,'N') NA NO          
NVL(FGBENCH_NSF_ON_OFF_IND,'N') NA NO          
NVL(FPBPOHD_BLANKET_IND,'N') FPABLAR NO COMPOSITE VIEW

AF_PURCHASE_ORDER

BLANKET_ORDER_IND

NO

 
NVL(FPBPOHD_CANCEL_IND,'N') FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER

CANCEL_IND

NO

 
NVL(FPBPOHD_CLOSED_IND,'N') NA NO COMPOSITE VIEW

AF_PURCHASE_ORDER

CLOSED_IND

NO

 
NVL(FPBPOHD_EDI_IND,'N') NA NO COMPOSITE VIEW

AF_PURCHASE_ORDER

EDI_IND

NO

 
NVL(FPBPOHD_PRINT_IND,'N') NA NO COMPOSITE VIEW

AF_PURCHASE_ORDER

PRINT_IND

NO

 
NVL(FPBPOHD_REXP_DATE, FPBPOHD_BLANKET_TERM_DATE) FPABLAR NO COMPOSITE VIEW

AF_PURCHASE_ORDER

PO_END_DATE

NO

NA
NVL(FPBPOHD_SUSP_IND,'N') FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER

SUSPENSE_IND

NO

 
NVL(FPRPODA_ADDL_CHRG_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

ADDITIONAL_AMOUNT

NO

 
NVL(FPRPODA_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

AMOUNT

NO

 
NVL(FPRPODA_AMT,0)+NVL( FPRPODA_ADDL_CHRG_AMT,0)+NVL( FPRPODA_TAX_AMT,0)-NVL(FPRPODA_DISC_AMT, 0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

APPROVED_CHARGE_AMOUNT

NO

This calculation returns the approved charge amount by summing the approved amount, additional charges, and tax amount and subtracting any associated discount.
NVL(FPRPODA_CLOSED_IND,'N') FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

CLOSED_IND

NO

 
NVL(FPRPODA_CONVERT_ADDL_CHRG_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

CONVERTED_ADDITIONAL_AMOUNT

NO

 
NVL(FPRPODA_CONVERT_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

CONVERTED_AMOUNT

NO

 
NVL(FPRPODA_CONVERT_DISC_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

CONVERTED_DISCOUNT_AMOUNT

NO

 
NVL(FPRPODA_CONVERT_TAX_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

CONVERTED_TAX_AMOUNT

NO

 
NVL(FPRPODA_DISC_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

DISCOUNT_AMOUNT

NO

 
NVL(FPRPODA_ENCB_ADJT_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

ENCUMBRANCE_ADJUSTMENT_AMOUNT

NO

 
NVL(FPRPODA_NSF_OVERRIDE_IND,'N') FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

NSF_OVERRIDE_IND

NO

 
NVL(FPRPODA_SUSP_IND,'N') FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

SUSPENSE_IND

NO

 
NVL(FPRPODA_TAX_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ACCOUNTING

TAX_AMOUNT

NO

 
NVL(FPRPODT_ADDL_CHRG_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

ADDITIONAL_CHARGES_AMOUNT

NO

 
NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

CONVERTED_ADDITNAL_AMOUNT

NO

 
NVL(FPRPODT_CONVERT_DISC_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

CONVERTED_DISCOUNT_AMOUNT

NO

 
NVL(FPRPODT_CONVERT_TAX_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

CONVERTED_TAX_AMOUNT

NO

 
NVL(FPRPODT_CONVERT_UNIT_PRICE,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

CONVERTED_UNIT_PRICE

NO

 
NVL(FPRPODT_DESC_CHGE_IND,'N') FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

COMMODITY_DESC_CHANGE_IND

NO

 
NVL(FPRPODT_DISC_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

DISCOUNT_AMOUNT

NO

 
NVL(FPRPODT_LIQ_AMT,0) NA NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

LIQUIDATION_AMOUNT

NO

 
NVL(FPRPODT_QTY,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

QUANTITY

NO

 
NVL(FPRPODT_TAX_AMT,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

TAX_AMOUNT

NO

 
NVL(FPRPODT_UNIT_PRICE,0) FPAPURR NO COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

UNIT_PRICE

NO

 
NVL(FPRRCDT_TOL_OVERRIDE_IND) FPARCVD NO         Calculations deterimines if the override is set to (Y)es or (N)o.
NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID) NA NO COMPOSITE VIEW

AE_EXPENSE_ITEM

PURCHASE_CARD_ID

NO

 
NVL(FTRACTA_ATTS_CODE,'NONE') FTMFATA NO COMPOSITE VIEW

AF_ACCOUNT_ATTRIBUTES_ODS

SET_CODE

NO

NA
NVL(FTRACVA_ATTS_CODE,'NONE') FTMFATA NO COMPOSITE VIEW

AF_ACTIVITY_ATTRIBUTES_ODS

SET_CODE

NO

NA
NVL(FTRATYA_ATTS_CODE,'NONE') FTMFATA NO COMPOSITE VIEW

AF_ACCOUNT_TYPE_ATTRIBUTES_ODS

SET_CODE

NO

NA
NVL(FTRFNDA_ATTS_CODE,'NONE') FTMFATA NO COMPOSITE VIEW

AF_FUND_ATTRIBUTES_ODS

SET_CODE

NO

NA
NVL(FTRFTYA_ATTS_CODE,'NONE') FTMFATA NO COMPOSITE VIEW

AF_FUND_TYPE_ATTRIBUTES_ODS

SET_CODE

NO

NA
NVL(FTRLCNA_ATTS_CODE,'NONE') FTMFATA NO COMPOSITE VIEW

AF_LOCATION_ATTRIBUTES_ODS

SET_CODE

NO

NA
NVL(FTRORGA_ATTS_CODE,'NONE') FTMFATA NO COMPOSITE VIEW

AF_ORGANIZATION_ATTRIBUTES_ODS

SET_CODE

NO

NA
NVL(FTRPRGA_ATTS_CODE,'NONE') FTMFATA NO COMPOSITE VIEW

AF_PROGRAM_ATTRIBUTES_ODS

SET_CODE

NO

NA
NVL(FTVACCT_ACCT_CODE_POOL, FTVACCT_ACCT_CODE) FTMACCT NO COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY_FISCAL

ACCOUNT_POOL

ACCOUNT_POOL

NO

NO

This calculation retrieves the FTVACCT_ACCT_CODE_POOL if it is not NULL. Otherwise it retrieves the FTVACCT_ACCT_CODE.
NVL(FTVFUND_FUND_CODE_BAVL, FTVFUND_FUND_CODE) FTMFUND NO COMPOSITE VIEW

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

FUND_POOL

FUND_POOL

NO

NO

This calculation retrieves the FTVFUND_FUND_CODE_BAVL if it is not NULL. Otherwise it retrieves the FTVFUND_FUND_CODE.
NVL(FTVORGN_ORGN_CODE_NSF, FTVORGN_ORGN_CODE) FTMORGN NO COMPOSITE VIEW

AF_ORGN_HIERARCHY_FISCAL

AF_ORGANIZATION_HIERARCHY

ORGANIZATION_POOL

ORGANIZATION_POOL

NO

NO

This calculation retrieves the FTVORGN_CODE_NSF if it is not NULL. Otherwise it retrieves the FTVORGN_ORGN_CODE.
NVL(FTVVEND_TERM_DATE,'31-DEC-2099') NA NO          
NVL(FTVVEND_VEND_CHECK_PIDM, FTVVEND_PIDM) NA NO          
NVL(GERATTD_FEES_DESC, GTVFEES_DESC) NA NO COMPOSITE VIEW

AG_EVENT_INVITEE

FEE_STATUS_DESC

NO

NVL(GERATTD_FEES_DESC, GTVFEES_DESC), returns fee status for the invitee, and if it doesn't exist, then the fee status for the fee.
NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED) NA NO         NA
NVL(NBBPOSN_ACCRUE_SENIORITY_IND, NTRPCLS_ACCRUE_SENIORITY_IND) MULTIPLE NO COMPOSITE VIEW

AN_POSITION_DEFINITION

SENIORITY_ACCRUED_IND

NO

Retrieves seniority accrual indicator from postion classification rule table if the indicator is null in the position record.
NVL(NBBPOSN_GRADE,NTRPCLS_GRADE) NA NO COMPOSITE VIEW

AN_POSITION_DEFINITION

SALARY_GRADE

NO

This function returns NBBPOSN_GRADE if it is not null else it returns NTRPCLS_GRADE.
NVL(NBBPOSN_POSN_REPORTS, MPKFUNC.F_GET_POSITION_REPORTS) MULTIPLE NO         NVL(POSITION_REPORTS, SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION,'POSITION'),1,63))
NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE) NA NO         NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE) returns salary group code for the salary group and if null, then returns salary group code for the position class.
NVL(NBBPOSN_STEP,NTRPCLS_STEP) NA NO COMPOSITE VIEW

AN_POSITION_DEFINITION

SALARY_STEP

NO

This function returns NBBPOSN_STEP if it is not null else it returns NTRPCLS_STEP.
NVL(NBBPOSN_TABLE,NTRPCLS_TABLE) NA NO COMPOSITE VIEW

AN_POSITION_DEFINITION

SALARY_TABLE

NO

This function returns NBBPOSN_TABLE if it is not null, else it returns NTRPCLS_TABLE.
NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR) NA NO COMPOSITE VIEW

AN_SUPERVISOR

SUPERVISOR_UID

NO

NVL(P.NBRJOBS_SUPERVISOR_PIDM, TO_NUMBER(NOKODSF.F_GET_SUPERVISOR(B.NBBPOSN_POSN_REPORTS,'PIDM')))
NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS) NA NO COMPOSITE VIEW

AN_SUPERVISOR

SUPERVISOR_POSITION

NO

If the supervisor position in NBRJOBS is null, then retrieve the position reports number and calculate who the supervisor is.
NVL(NBRJOBS_SUPERVISOR_SUFF, NOKODSF.F_GET_SUPERVISOR) NA NO COMPOSITE VIEW

AN_SUPERVISOR

SUPERVISOR_JOB_SUFFIX

NO

NVL(NBRJOBS_SUPERVISOR_SUFF, SUBSTR(NOKODSF.F_GET_SUPERVISOR(NBBPOSN_POSN_REPORTS,'SUFFIX'),1,2)
NVL(PAY.TRANSACTION_DATE, CHG.TRANSACTION_DATE) NA NO         Applied date is set from the payment transaction date, and if null, then is set to the charge transaction date when the payment is applied to the charge.
NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL( RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0) NA NO         NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL(RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0)
NVL(RCRAPP4_DUP_SSN_IND) TBD NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

DUPLICATE_TAX_ID_IND

NO

 
NVL(RCRAPP4_PUSH_ISIR_FLAG) RNIMSXX NO COMPOSITE VIEW

AR_FINAID_APPLICATION4

CPS_ISIR_PUSHED_IND

NO

 
NVL(RCRESAR_AUTO_ZERO_EFC_FLAG) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

AUTOMATIC_ZERO_EFC_IND

NO

 
NVL(RCRESAR_SUB_APP) RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

SUBSEQUENT_APPLICATION_IND

NO

 
NVL(RCRESAR_VERIF_CHANGE_IND) RNARSXX RNIMSXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

VERIFICATION_SELECT_CHANGE_IND

NO

 
NVL(RNROVRD_ADD_BK_HOPE_OPT) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_ADD_HOPE_LL_IND

NO

 
NVL(RNROVRD_ALLOW_IM_PC_LOWR_FM) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_LOWER_THAN_FM_IND

NO

 
NVL(RNROVRD_ALLOW_IM_SC_LOWR_FM) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_LOWER_THAN_FM_IND

NO

 
NVL(RNROVRD_CALC_US_TAX_FM) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_STUD_CALC_FED_TAX_OVR_IND

NO

 
NVL(RNROVRD_NON_CUST_PC_OPT) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_USE_NONCUSTODIAL_PC_IND

NO

 
NVL(RNROVRD_PAR_ADD_BK_HOME_OPT) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_ADD_HOPE_LL_IND

NO

 
NVL(RNROVRD_PAR_CALC_US_TAX_FM) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

FM_PARENT_CALC_FED_TAX_OVR_IND

NO

 
NVL(RNROVRD_PAR_EXCL_TUIT_DED) RNAOVXX NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_EXCL_TUITION_FEE_IND

NO

 
NVL(RNROVRD_PAR_USE_PROJ_INC_EFM) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_EFM_EST_INCOME_IND

NO

 
NVL(RNROVRD_SKIP_AGE_EXCL) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_SKIP_AGE_EXCLUSION_IND

NO

 
NVL(RNROVRD_USE_PROJ_INC_EFM) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_EFM_ESTIMATED_INCOME_IND

NO

 
NVL(RNROVRD_ZERO_LOSS_BUS_FARM) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_ZERO_LOSS_BUS_IND

NO

 
NVL(RNROVRD_ZERO_LOSS_OTH) TBD NO COMPOSITE VIEW

AR_NEED_ANALYSIS_OVERRIDE

IM_PARENT_ZERO_LOSS_OTH_IND

NO

 
NVL(RPRADSB_ALTERNATE_PELL_IND,'N') ROAPELL NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

ALTERNATE_PELL_PAY_SCHED_IND

NO

 
NVL(RPRADSB_CPS_VER_IND,'N') READIXX NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

CPS_VERIFICATION_IND

NO

 
NVL(RPRADSB_DISB_LOCK_IND,'N') READIXX NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

COD_DISBURSEMENT_LOCK_IND

NO

 
NVL(RPRADSB_EXCL_FROM_NET_AMT,'N') READIXX NO COMPOSITE VIEW

AR_AWARD_DISBURSEMENT

COD_NET_AMOUNT_EXCLUSION_IND

NO

 
NVL(RPRLAPP_ADDL_STFD_ELIG_IND,'N') NA NO COMPOSITE VIEW

AR_LOAN_APPLICATION

ADDL_STAFFORD_ELIG_IND

NO

 
NVL(RPRLAPP_DEFERMENT_OPT,'N') NA NO          
NVL(RPRLAPP_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO) NA NO          
NVL(RPRLAPP_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO) NA NO          
NVL(RPRLAPP_MAX_LOAN_IND,'N') NA NO          
NVL(RPRLAPP_MI, MGKFUNC.F_GET_PERSON_INFO) NA NO          
NVL(RPRLAPP_SSN, MGKFUNC.F_GET_PERSON_INFO) NA NO          
NVL(RPRLATR_EXCLUDE_LNEX_FLAG,'N') RPALORG RPAELAP RPALAPP NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT

EXCLUDE_EXCEPTION_REPORT_IND

NO

 
NVL(SARADAP_FEE_IND,'N') NA NO COMPOSITE VIEW

AS_ADMISSIONS_APPLICATION

APPLICATION_FEE_REQUIRED_IND

NO

NA
NVL(SFRSTCR_APPR_OVER,'N') NA NO          
NVL(SFRSTCR_ATTS_OVER,'N') NA NO          
NVL(SFRSTCR_CAMP_OVER,'N') NA NO          
NVL(SFRSTCR_CAPC_OVER,'N') NA NO          
NVL(SFRSTCR_CHRT_OVER,'N') NA NO          
NVL(SFRSTCR_CLAS_OVER,'N') NA NO          
NVL(SFRSTCR_COLL_OVER,'N') NA NO          
NVL(SFRSTCR_CORQ_OVER,'N') NA NO          
NVL(SFRSTCR_DEGC_OVER,'N') NA NO          
NVL(SFRSTCR_DEPT_OVER,'N') NA NO          
NVL(SFRSTCR_DUPL_OVER,'N') NA NO          
NVL(SFRSTCR_LEVL_OVER,'N') NA NO          
NVL(SFRSTCR_LINK_OVER,'N') NA NO          
NVL(SFRSTCR_MAJR_OVER,'N') NA NO          
NVL(SFRSTCR_MEXC_OVER,'N') NA NO          
NVL(SFRSTCR_PREQ_OVER,'N') NA NO          
NVL(SFRSTCR_PROG_OVER,'N') NA NO          
NVL(SFRSTCR_REPT_OVER,'N') NA NO          
NVL(SFRSTCR_RPTH_OVER,'N') NA NO          
NVL(SFRSTCR_TEST_OVER,'N') NA NO          
NVL(SFRSTCR_TIME_OVER,'N') NA NO          
NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS( SHRTCKN_PIDM,SHRTCKN_TERM_CODE, SHRTCKN_CRN)) NA NO COMPOSITE VIEW

AS_STUDENT_COURSE_HISTORY

EXTENSIONS

NO

This calculates the number of extensions SHRTCKN_NUMBER_OF_EXTENSIONS for the specified UID, academic period and course if it exists, else it returns the function which returns the number of extensions MAX(SFRAREG_EXTENSION_NUMBER) a student has been granted to complete the class for the specified UID, academic period and course where the withdrawal indicator is N.
NVL(SHRTCKN_REG_COMPLETION_DATE, SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM, SHRTCKN_TERM_CODE,SHRTCKN_CRN, SHRTCKN_PTRM_CODE,'E')) NA NO COMPOSITE VIEW

AS_STUDENT_COURSE_HISTORY

END_DATE

NO

This function returns the registration start date SHRTCKN_REG_START_DATE if it exists, else it returns the course start date for a specified UID, academic period, course and subacademic period.
NVL(SHRTCKN_REG_START_DATE, SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM, SHRTCKN_TERM_CODE,SHRTCKN_CRN, SHRTCKN_PTRM_CODE,'S')) SFARHST NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

START_DATE

NO

This function returns the registration completion date SHRTCKN_REG_COMPLETION_DATE if it exists, else it returns the course end date for a specified UID, academic period, course and subacademic period.
NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE) NA NO COMPOSITE VIEW

AS_PREVIOUS_EDUCATION_PCOL

TRANSCRIPT_REVIEWED_DATE

NO

NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE) returns transfer acceptance date and if null, then returns prior college transcript reviewed date.
NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE) NA NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

GRAD_YEAR_INTENDED

NO

Retrieve intended year of graduation from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur.
NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE) MULTIPLE NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

EXPECTED_GRADUATION_DATE

NO

Retrieve expected graduation date from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur.
NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE) MULTIPLE NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

LEAVE_REASON

NO

Retrieve leave reason from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur.
NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE) MULTIPLE NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

LEAVE_DATE_FROM

NO

Retrieve start date of the student leave from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE) MULTIPLE NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

LEAVE_DATE_TO

NO

Retrieve end date of the student leave from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE) MULTIPLE NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

STUDENT_RATE

NO

Retrieve student rate from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_SITE_CODE,SGBSTDN_SITE_CODE) NA NO         Use site code from curriculum record and if null use site from student record sgbstdn.
NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE) MULTIPLE NO         Retrieve student population or type from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD) MULTIPLE NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

GRAD_ACADEMIC_PERIOD_INTENDED

NO

Retrieve intended graduation term from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SPRIDEN_LAST_NAME,'STAFF') SIAASGN NO COMPOSITE VIEW

AS_INSTRUCTIONAL_ASSIGNMENT

INSTRUCTOR_LAST_NAME

NO

This function returns the instructor''s last name SPRIDEN_LAST_NAME if it exists, else STAFF.
NVL(SPRIDEN_MI,'STAFF') MULTIPLE NO         Retrieve the instructor''s last name SPRIDEN_LAST_NAME if it exists, else set to STAFF.
NVL(SSBOVRR_COLL_CODE,SCBCRSE_COLL_CODE) SSAOVRR NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

COURSE_COLLEGE

NO

This function returns the override college SSBOVRR_COLL_CODE if it exists, else it returns the course college SCBCRSE_COLL_CODE.
NVL(SSBOVRR_DEPT_CODE,SCBCRSE_DEPT_CODE) SSAOVRR NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

COURSE_DEPARTMENT

NO

This function returns the override department SSBOVRR_DEPT_CODE if it exists, else it returns the department SCBCRSE_DEPT_CODE.
NVL(SSBOVRR_DIVS_CODE,SCBCRSE_DIVS_CODE) SSAOVRR NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

COURSE_DIVISION

NO

This function returns the override division SSBOVRR_DIVS_CODE if it exists, else it returns the course division SCBCRSE_DIVS_CODE.
NVL(SSBSECT_CONT_HR, SCBCRSE_CONT_HR_HIGH) SCACRSE NO         NA
NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE) SCACRSE NO COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

COURSE_TITLE_SHORT

NO

NA
NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH) SCACRSE NO         NA
NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH) SCACRSE NO         NA
NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH) SCACRSE NO         NA
NVL(SUM_ADOPTED_BUDGET + SUM_BUDGET_ADJUSTMENTS, 0) NA NO         Calculates total budget as of this period to be the sum of all adopted budget and all budget adjustments up to this period.
NVL(SUM_YEAR_TO_DATE_ACTV + SUM_ENCUMBRANCES + SUM_BUDGET_RESERVATION, 0) NA NO         Calculates summary committed balance as of this period to be the sum of all year to date activity plus all year to date encumbrances plue all year to date budget reservations.
NVL(TBRDEPO_AMOUNT-F_ACCD_AMOUNT( TBRDEPO_PIDM,TBRDEPO_TRAN_NUMBER),0) TSADETL NO COMPOSITE VIEW

AT_AR_DEPOSIT

BALANCE_AMOUNT

NO

This function returns the difference between the deposit amount TBRDEPO_AMOUNT and the summarized transaction amount SUM(TBRACCD_AMOUNT) for a specified UID and transaction number.
NVL(TBRDEPO_TRANS_DATE, TBRDEPO_EFFECTIVE_DATE)-NVL( TBRDEPO_FEED_DATE,SYSDATE) TSADETL NO COMPOSITE VIEW

AT_AR_DEPOSIT

OPERATING_DATE

NO

This function returns the difference between the transaction date TBRDEPO_TRANS_DATE or if null, the effective date TBRDEPO_EFFECTIVE_DATE and the feed date TBRDEPO_FEED_DATE or if null, today's date SYSDATE.
NVL(TRANSACTION_HISTORY.FUND_POOL, FUND_HIERARCHY.FUND_POOL) NA NO         Population of fund pool is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
NVL=(ASBSORG_PARTICIPATION_GOAL,0) NA NO COMPOSITE VIEW

AA_SOLICITOR_ORGANIZATION

ORG_PARTICIPATION_GOAL

NO

 
PPREXPE_SUPER_PHONE_AREA||PPREXPE_SUPER_ PHONE_NUMBER||PPREXPE_SUPER_PHONE_EXT NA NO COMPOSITE VIEW

AP_PAST_EMPLOYMENT

SUPERVISOR_COMBINED_PHONE

NO

NA
PPRREFE_PHONE_AREA||PPRREFE_PHONE_NUMBER ||PPRREFE_PHONE_EXT NA NO COMPOSITE VIEW

AP_REFERENCE

COMBINED_PHONE

NO

This function concatenates the phone area code, the phone number and the phone extension from the PPRREFE table.
ROW_NUMBER TBD NO          
SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB SCACRSE NO COMPOSITE VIEW

AS_COURSE_CATALOG

COURSE_IDENTIFICATION

NO

This concatenates the course subject code with the course number from the SCBCRSE record.
SCBSUPP_SUBJ_CODE||SCBSUPP_CRSE_NUMB SCADETL NO COMPOSITE VIEW

AS_COURSE_SUPPLEMENTAL

COURSE_IDENTIFICATION

NO

This concatenates the course subject code with the course number from the SCBSUPP record.
SCRATTR_SUBJ_CODE||SCRATTR_CRSE_NUMB SCADETL NO         NA
SCRCORQ_SUBJ_CODE_CORQ||SCRCORQ_CRSE_NUM B_CORQ SCADETL NO COMPOSITE VIEW

AS_COURSE_COREQ

COURSE_IDENTIFICATION_COREQ

NO

This concatenates the course subject code co-requisite with the course number co-requisite from the SCRCORQ record.
SCRCORQ_SUBJ_CODE||SCRCORQ_CRSE_NUMB SCADETL NO COMPOSITE VIEW

AS_COURSE_COREQ

COURSE_IDENTIFICATION

NO

This concatenates the course subject code with the course number from the SCRCORQ record.
SCRGMOD_SUBJ_CODE||SCRGMOD_CRSE_NUMB, SSASECT NO COMPOSITE VIEW

AS_OFFERING_GRADE_MODE

COURSE_IDENTIFICATION

NO

This concatenates the course subject code with the course number from the SGRGMOD record.
SCRLEVL_SUBJ_CODE||SCRLEVL_CRSE_NUMB SCACRSE NO COMPOSITE VIEW

AS_COURSE_LEVEL

COURSE_IDENTIFICATION

NO

This concatenates the course subject code with the course number from the SCRLEVL record.
SCRRTST_SUBJ_CODE||SCRRTST_CRSE_NUMB SCAPREQ NO COMPOSITE VIEW

AS_COURSE_PREREQ

COURSE_IDENTIFICATION

NO

This concatenates the course subject code with the course number from the SCRRTST record.
SCRSCHD_SUBJ_CODE||SCRSCHD_CRSE_NUMB SCACRSE NO COMPOSITE VIEW

AS_COURSE_SCHEDULE

COURSE_IDENTIFICATION

NO

This concatenates the course subject code with the course number from the SCRSCHD record.
SEASONS_COMPETITION_AVAILABLE - SEASONS_COMPETITION_USED NA NO          
SELECT RORMVAL_DESC FROM RORMVAL WHERE RORMVAL_COLUMN = 'RFRASPC_APPL_MEMO_IND' AND RORMVAL_CODE = RFRASPC_APPL_MEMO_IND NA NO          
SFRPLAN_SUBJ_CODE||SFRPLAN_CRSE_NUMB NA NO          
SFRSTCR_SUBJ_CODE||SFRSTCR_CRSE_NUMB SFAREGS NO COMPOSITE VIEW

AS_FACULTY_FEEDBACK

COURSE_IDENTIFICATION

NO

This concatenates the course subject code with the course number from the SFRSTCR record.
SGRCOOP_PHONE_AREA||SGRCOOP_PHONE_NUMBER ||SGRCOOP_PHONE_EXT NA NO         NA
SHRTATT_TRIT_SEQ_NO||TO_CHAR( SHRTATT_TRAM_SEQ_NO,'FM09')||TO_CHAR( NVL(SHRTATT_TRCR_SEQ_NO,0),'FM009') ||TO_CHAR(SHRTATT_TRCE_SEQ_NO,'FM009') MULTIPLE NO COMPOSITE VIEW

AS_STUDENT_COURSE_ATTR_TRANS

COURSE_REFERENCE_NUMBER

NO

 
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_ATTEMPTED_IND,'Y',1,0) SHATCKS NO COMPOSITE VIEW

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_GRADE_CHG

CREDITS_ATTEMPTED

CREDITS_ATTEMPTED

NO

NO

This calculates the credit hours attempted by the student.
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_COMPLETED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1) SHATCKS NO COMPOSITE VIEW

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_GRADE_CHG

CREDITS_EARNED

CREDITS_EARNED

NO

NO

This calculates the credit hours earned by the student.
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_GPA_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) SHATCKS NO COMPOSITE VIEW

AS_STUDENT_COURSE_GRADE_CHG

AS_STUDENT_COURSE_HISTORY

CREDITS_FOR_GPA

CREDITS_FOR_GPA

NO

NO

This calculates the credits that are used to calculate the GPA for the student.
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_PASSED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1) SHATCKS NO COMPOSITE VIEW

AS_STUDENT_COURSE_GRADE_CHG

AS_STUDENT_COURSE_HISTORY

CREDITS_PASSED

CREDITS_PASSED

NO

NO

This calculates the quality points earned by the student.
SHRTCKG_CREDIT_HOURS*SHRGRDE_QUALITY_POI NTS*DECODE(SHRGRDE_GPA_IND,'Y',1,0) *DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0, 1) SHAINST NO COMPOSITE VIEW

AS_STUDENT_COURSE_GRADE_CHG

AS_STUDENT_COURSE_HISTORY

QUALITY_POINTS

QUALITY_POINTS

NO

NO

This calculates the credit hours passed by the student.
SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB SHAINST NO         This concatenates the course subject code with the course number from the SHRTCKN record.
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_ATTEMPTED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) TBD NO          
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_EARNED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) TBD NO          
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_GPA_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) TBD NO          
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_PASSED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) TBD NO          
SHRTRCE_CREDIT_HOURS*SHRGRDE_QUALITY_POI NTS*DECODE(SHRGRDE_GPA_IND,'Y',1,0) *DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0, 1) TBD NO          
SHRTRCE_SUBJ_CODE||SHRTRCE_CRSE_NUMB SHATRNS NO         This concatenates the course subject code with the course number from the SHRTRCE record.
SHRTRCE_TRIT_SEQ_NO||TO_CHAR( SHRTRCE_TRAM_SEQ_NO,'FM09')||TO_CHAR( NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009') ||TO_CHAR(SHRTRCE_SEQ_NO,'FM009') TBD NO COMPOSITE VIEW

AS_STUDENT_COURSE_TRANSFER

AS_STUDENT_TRANSFERRED_COURSE

AS_STUDENT_COURSE_TRANSFER

AS_STUDENT_TRANSFERRED_COURSE

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

NO

NO

NO

NO

 
SHRTRCR_TRANS_COURSE_NAME||SHRTRCR_TRANS _COURSE_NUMBERS NA NO COMPOSITE VIEW

AS_STUDENT_TRANSFERRED_COURSE

TRANSFER_COURSE_IDENTIFICATION

NO

 
SLBBLDG_PHONE_AREA||SLBBLDG_PHONE_NUMBER ||SLBBLDG_PHONE_EXTENSION SLABLDG NO COMPOSITE VIEW

AS_ROOM_ASSIGNMENT

BUILDING_PHONE_NUM_COMBINED

NO

This concatenates the area code, the phone number and the phone extension from the SLBBLDG table.
SLBEVNT_PHONE_AREA||SLBEVNT_PHONE||SLBEV NT_PHONE_EXT NA NO COMPOSITE VIEW

AG_EVENT

PHONE_NUMBER_COMBINED

NO

NA
SLBRDEF_PHONE_AREA||SLBRDEF_PHONE_NUMBER ||SLBRDEF_PHONE_EXTENSION SLARASG NO COMPOSITE VIEW

AS_ROOM_ASSIGNMENT

ROOM_PHONE_NUM_COMBINED

NO

This concatenates the area code, the phone number and the phone extension from the SLBRDEF table.
SLRPASG_PHONE_AREA||SLRPASG_PHONE_NUMBER ||SLRPASG_PHONE_EXT NA NO COMPOSITE VIEW

AS_PHONE_ASSIGNMENT

PHONE_NUMBER_COMBINED

NO

This concatenates the area code, the phone number and the phone extension from the SLRPASG table.
SORBCNT_PHONE_AREA||SORBCNT_PHONE_NUMBER ||SORBCNT_PHONE_EXT SOASBGI NO COMPOSITE VIEW

AS_INSTITUTION

CONTACT_PHONE_NUMBER_COMBINED

NO

NA
SPRADDR_CNTY_CODE FAAINVE NO         NA
SPRIDEN_FIRST_NAME || SUBSTR(SPRIDEN_MI, 1,1) || SPRIDEN_LAST_NAME NA NO          
SPRIDEN_FIRST_NAME||SPRIDEN_MI||SPRIDEN_ LAST_NAME NA NO COMPOSITE VIEW

AA_PLEDGE_MATCHING

MATCH_EMPLOYER_NAME

NO

NA
SPRTELE_INTL_ACCESS || SPRTELE_PHONE_AREA || SPRTELE_PHONE_NUMBER || SPRTELE_PHONE_EXT NA NO         This calculation formulates the combined phone number by concatenating SPRTELE_INTL_ACCESS, SPRTELE_PHONE_AREA, SPRTELE_PHONE_NUMBER, and SPRTELE_PHONE_EXT.
SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA| |SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT NA NO COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AA_ORGANIZATION_CONTACT

AS_TELEPHONE

FAX_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

NO

NO

NO

This calculation formulates the combined phone number by concatenating SPRTELE_INTL_ACCESS, SPRTELE_PHONE_AREA, SPRTELE_PHONE_NUMBER, and SPRTELE_PHONE_EXT.
SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB SFAREGS NO COMPOSITE VIEW

AS_OFFERING_GRADE_TYPE

AS_OFFERING_PREREQ

AS_COURSE_OFFERING

AS_MEETING_TIME

AS_OFFERING_COREQ

AS_STUDENT_COURSE_IN_PROGRESS

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

NO

NO

NO

NO

NO

NO

This concatenates the course subject code with the course number from the SSBSECT record.
SSRRTST_SUBJ_CODE_PREQ||SSRRTST_CRSE_NUM B_PREQ SSAPREQ NO COMPOSITE VIEW

AS_OFFERING_PREREQ

PREREQ_COURSE_IDENTIFICATION

NO

This concatenates the prerequisite course subject code with the prerequisite course number from the SSRRTST record.
SUBSTR(SPRIDEN_MI,1,1) NA NO COMPOSITE VIEW

AS_PERSON

MIDDLE_INITIAL

NO

This function returns the middle initial.
SUM(AGRPDES_AMT_PAID) TBD NO COMPOSITE VIEW

AA_PLEDGE

PLEDGE_TRANS_AMOUNT_PAID

NO

 
SUM(AMOUNT) NA NO         This summarizes the amount SUM(TBRACCD_AMOUNT) for a given term, category code and detail code.
SUM(FPRRCDT_AMT_RCVD) FPARCVD NO         NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY) FPARCVD FPARTRN NO         NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD) FPARCVD NO COMPOSITE VIEW

AF_RECEIVED_ITEM

QUANTITY_RECEIVED_REJECTED

NO

NA
SUM(FPRRCDT_QTY_RCVD) FPARCVD NO         NA
SUM(FPRRTRN_QTY) FPARCVD NO         Returns the sum of all quantities returned for a purchase order item.
SUM(PERJTOT_GRS) NA NO COMPOSITE VIEW

AP_EARNING_TOTALS_FY

AP_EARNING_TOTALS_CY

TOTAL_EARNINGS_FISCAL_YEAR

TOTAL_GROSS_CALENDAR_YEAR

NO

NO

This function returns the sum of the hours SUM(PERJTOT_GRS).
SUM(PERJTOT_HRS) NA NO COMPOSITE VIEW

AP_EARNING_TOTALS_FY

AP_EARNING_TOTALS_CY

TOTAL_HOURS_FISCAL_YEAR

TOTAL_HOURS_CALENDAR_YEAR

NO

NO

This function returns the sum of the hours SUM(PERJTOT_HRS).
SUM(RPRAWRD_ACCEPT_AMT) NA NO COMPOSITE VIEW

AR_AWARD_BY_FUND

ACCEPT_AMOUNT

NO

SUM(RPRAWRD_ACCEPT_AMT)
SUM(RPRAWRD_AUTHORIZE_AMT) NA NO COMPOSITE VIEW

AR_AWARD_BY_FUND

AUTHORIZED_AMOUNT

NO

NA
SUM(RPRAWRD_CANCEL_AMT) NA NO COMPOSITE VIEW

AR_AWARD_BY_FUND

CANCEL_AMOUNT

NO

NA
SUM(RPRAWRD_DECLINE_AMT) NA NO COMPOSITE VIEW

AR_AWARD_BY_FUND

DECLINE_AMOUNT

NO

NA
SUM(RPRAWRD_MEMO_AMT) NA NO COMPOSITE VIEW

AR_AWARD_BY_FUND

MEMO_AMOUNT

NO

NA
SUM(RPRAWRD_OFFER_AMT) NA NO COMPOSITE VIEW

AR_AWARD_BY_FUND

OFFER_AMOUNT

NO

NA
SUM(RPRAWRD_PAID_AMT) NA NO COMPOSITE VIEW

AR_AWARD_BY_FUND

PAID_AMOUNT

NO

NA
SYSDATE BETWEEN SPRHOLD_FROM_DATE AND SPRHOLD_TO_DATE NA NO          
TBD NA NO COMPOSITE VIEW

AF_OPERATING_LEDGER

AF_OPERATING_LEDGER

SUM_LAST_YEAR_ACTUAL

CURR_PERIOD_LAST_YEAR_ACTUAL

NO

NO

 
TBLD NA NO COMPOSITE VIEW

AN_PERSONNEL_ACTION_LABOR_DIST

PAF_TRANSACTION_TYPE

NO

 
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE1') NA NO         Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE2') NA NO         Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE3') NA NO         Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE4') NA NO         Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TO_CHAR (TO_DATE (FAB1099_RPT_YR, 'RR'), 'YYYY') NA NO COMPOSITE VIEW

AF_VENDOR_TAXABLE_REPORTING

TAX_YEAR

NO

 
TO_CHAR (TO_DATE (FRRGRNH_FSYR_CODE, 'RR'), 'YYYY' NA NO COMPOSITE VIEW

AF_GRANT_DEFERRED_COST

FISCAL_YEAR

NO

 
TO_CHAR(TBRACCD_CSHR_END_DATE, 'HH24:MM:SS') NA NO         This calculation retrieves the 24 hour time from TBRACCD_CSHR_END_DATE.
TO_CHAR(TBRDEPO_CSHR_END_DATE, 'HH24:MM:SS') NA NO         This calculation retrieves the 24 hour time from TBRDEPO_CSHR_END_DATE.
TO_CHAR(TBRMISD_CSHR_END_DATE, 'HH24:MM:SS') NA NO         This calculation retrieves the 24 hour time from TBRMISD_CSHR_END_DATE.
TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'), 'YYYY') NA NO COMPOSITE VIEW

AF_TRANSACTION_HISTORY

FISCAL_YEAR

NO

This calculation transforms a two digit fiscal year into a 4 digit fiscal year for the transaction detail record.
TO_CHAR(TO_DATE(FGBTRNH_FSYR_CODE,'RR'), 'YYYY') NA NO COMPOSITE VIEW

AF_TRANSACTION_HISTORY

FISCAL_YEAR_HEADER

NO

This calculation transforms a two digit fiscal year into a 4 digit fiscal year for the transaction history record.
TO_CHAR(TRRACCD_CSHR_END_DATE, 'HH24:MM:SS') NA NO         This calculation retrieves the 24 hour time from TRRACCD_CSHR_END_DATE.
TTBTAXN_AMOUNT_3 * -1 NA NO COMPOSITE VIEW

AT_STUDENT_TAX_NOTIFICATION

PRIOR_YEAR_CHARGES_ADJUSTED

NO

 
TTBTAXN_AMOUNT_5 * -1 NA NO COMPOSITE VIEW

AT_STUDENT_TAX_NOTIFICATION

PRIOR_YR_SCHOLARSHIP_GRANT_ADJ

NO

 
TTBTAXN_AMOUNT_6 * -1 NA NO COMPOSITE VIEW

AT_STUDENT_TAX_NOTIFICATION

PRIOR_YEAR_PAYMENT_ADJ

NO

 
CASE WHEN RLRDDAS_DISB_SEQ_NO NA NO COMPOSITE VIEW

AR_LOAN_DISBURSEMENT_DETAIL

RECORD_SOURCE

NO

 
SUBSTR(GORSDAV_PK_PARENTTAB,) TBD NO COMPOSITE VIEW

AG_SDE_DATA

AG_SDE_DATA

AG_SDE_DATA

AG_SDE_DATA

AG_SDE_DATA

AG_SDE_DATA

PARENT_TABLE_PK_COL4

PARENT_TABLE_PK_COL2

PARENT_TABLE_PK_COL3

PARENT_TABLE_PK_COL1

PARENT_TABLE_PK_COL5

PARENT_TABLE_PK_COL6

NO

NO

NO

NO

NO

NO

This calculation retrieves the portion of the composite primary key-GORSDAV_PK_PARENTTAB.


Ver: