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

Source Column Source Form Target Type Target Target Column Calculation Formula
DECODE(ROW_NUMBER() OVER (PARTITION BY PERSON_UID ORDER BY A.DATE_INITIATED DESC),1,1,0) DEL BASELINE MAPPING TBD        
" IF PREV_EDUCATION_REC.PERSON_UID IS NULL THEN RET_ROW.FINAL_DEGREE_IND := 0; ELSE RET_ROW.FINAL_DEGREE_IND := 1; END IF; " TBD        
(APPLIED_AMOUNT * (CLGR.PERCENT/100) * ( PLGR.PERCENT/100)) NA

REPORTING VIEW

APPL_OF_PAY_DETAIL_ACCOUNTING

APPLIED_AMOUNT

Calculates acutal amount applied to the transaction based upon accounting distribution percentages.
(FGBOPAL_XX_ADOPT_BUD + FGBOPAL_XX_BUD_ADJT) - ( FGBOPAL_XX_YTD_ACTV + FGBOPAL_XX_ENCUMB + FGBOPAL_XX_BUD_RSRV) - (FGBOPAL_XX- 1_ADOPT_BUD + FGBOPAL_XX-1_BUD_ADJT) - ( FGBOPAL_XX-1_YTD_ACTV + FGBOPAL_XX- 1_ENCUMB + FGBOPAL_XX-1_BUD_RSRV) NA

REPORTING VIEW

OPERATING_LEDGER

CURR_REMAINING_BALANCE

 
(FGBOPAL_XX_ADOPT_BUD+ FGBOPAL_XX_BUD_ADJT)-( FGBOPAL_XX_YTD_ACTV+FGBOPAL_XX_ENCUMB+ FGBOPAL_XX_BUD_RSRV) FGIBDST

REPORTING VIEW

OPERATING_LEDGER

SUM_REMAINING_BALANCE

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

REPORTING VIEW

GRANT_LEDGER

SUM_REMAINING_BALANCE

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

REPORTING VIEW

GRANT_LEDGER

CURR_REMAINING_BALANCE

This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes only activity in this period.
(MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES + MAKFUNC.F_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100 NA

REPORTING VIEW

CAMPAIGN

PCT_PROGRESS_CAMPAIGN_GOAL

 
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100 NA

REPORTING VIEW

CAMPAIGN_DESIGNATION

PCT_DESG_PROGRESS_CAMP_GOAL

 
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFRDESG_GOAL * 100 NA

REPORTING VIEW

CAMPAIGN_DESIGNATION

PCT_PROGRESS_DESIGNATION_GOAL

 
(MAKFUNC.F_ORG_TOTAL_GIFTS + MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100 NA

REPORTING VIEW

SOLICITOR_ORGANIZATION

PCT_PROGRESS_ORGANIZATION_GOAL

 
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100 NA

REPORTING VIEW

CAMPAIGN_SOLICITATION

PCT_SOLT_PROGRESS_CAMP_GOAL

 
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFRCSOL_GOAL * 100 NA

REPORTING VIEW

CAMPAIGN_SOLICITATION

PCT_PROGRESS_SOLT_GOAL

 
(MAKFUNC.F_SOL_FR_TOTAL_PLEDGES + MAKFUNC.F_SOL_FR_TOTAL_GIFTS + MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100 NA

REPORTING VIEW

SOLICITOR_ORG_FUNDRAISER

PCT_SOLICITOR_PROG_ORG_GOAL

 
(NVL(FARINVC_APPR_QTY,0)*NVL( FARINVC_APPR_UNIT_PRICE,0))+NVL( FARINVC_ADDL_CHRG_AMT,0)+NVL( FARINVC_TAX_AMT,0)-NVL(FARINVC_DISC_AMT, 0) FAAINVE

REPORTING VIEW

INVOICE_ITEM

APPROVED_ITEM_AMOUNT

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

REPORTING VIEW

BUDGET_DETAIL

BUDGET_AMOUNT

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

REPORTING VIEW

PURCHASE_ORDER_ITEM

CONVERTED_APPROVED_ITEM_AMOUNT

 
(NVL(FPRPODT_QTY,0)*NVL( FPRPODT_UNIT_PRICE,0))+NVL( FPRPODT_ADDL_CHRG_AMT,0)+NVL( FPRPODT_TAX_AMT,0)-NVL(FPRPODT_DISC_AMT, 0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

PURCHASE_ORDER_ITEM_SUMMARY

APPROVED_ITEM_AMOUNT

APPROVED_ITEM_AMOUNT

This calculation returns the approved item amount for the purchase order item. The amount is calculated as the approved quantity multiplied by the unit price plus any additional charges and tax amount and then subtracting any discount.
AARMEMB_AMT_QUALIFY - AOKODSF.F_GET_MEMBER_AMT_PAID NA

REPORTING VIEW

MEMBERSHIP

MEMBERSHIP_DUES_AMOUNT_OWED

 
ACCT.PAY_CURRENCY_AMOUNT - ACCT.PAY_CURRENCY_AMOUNT_NO_TAX NA

REPORTING VIEW

REIMBURSEMENT_ACCOUNTING

AUTHORIZATION_ACCOUNTING

PAY_CURRENCY_TAX_AMOUNT

PAY_CURRENCY_TAX_AMOUNT

 
AFRCSOL_GOAL / AFBCAMP_GOAL * 100 NA

REPORTING VIEW

CAMPAIGN_SOLICITATION

SOLT_PERCENT_OF_CAMPAIGN_GOAL

 
AFRDESG_GOAL / AFBCAMP_GOAL * 100 NA

REPORTING VIEW

CAMPAIGN_DESIGNATION

DESG_PERCENT_OF_CAMPAIGN_GOAL

 
AGBMGID_AMT - AGBMGID_AMT_PAID NA

REPORTING VIEW

GIFT_MATCHING_TRANSACTION

MATCH_GIFT_BALANCE

NA
AGRGDES_AMT-F_GIFT_HARD_CREDIT NA

REPORTING VIEW

GIFT

GIFT_CREDIT_AMOUNT

NA
AGRPDES_AMT-AGRPDES_AMT_PAID NA

REPORTING VIEW

PLEDGE

PLEDGE_BALANCE

NA
AGRPDES_AMT-F_PLEDGE_HARD_CREDIT NA

REPORTING VIEW

PLEDGE

PLEDGE_CREDIT

NA
AGRPDES_AMT_PAID - SUM(AGRPDES_AMT_PAID) NA

REPORTING VIEW

PLEDGE_TRANSACTION

PLEDGE_TRANS_BALANCE

 
AORCONT_FAX_AREA||AORCONT_FAX_NUMBER||AO RCONT_FAX_EXT NA

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_NUMBER_COMBINED

 
AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER ||AORCONT_PHONE_EXT NA

REPORTING VIEW

ORGANIZATION_CONTACT

PHONE_NUMBER_COMBINED

 
ASBSORG_UPD_WEB_IND NA

REPORTING VIEW

SOLICITOR_ORGANIZATION

ALLOW_WEB_UPDATE_IND

 
ASRSORG_DOLLAR_GOAL / ASBSORG_DOLLAR_GOAL * 100 NA

REPORTING VIEW

SOLICITOR_ORG_FUNDRAISER

SOLICITOR_PCT_OF_ORG_GOAL

 
ASRSORG_UPD_WEB_IND NA

REPORTING VIEW

CAMPAIGN_FUNDRAISER

ALLOW_WEB_UPDATE_SOLICITOR_IND

 
CASE NBBPOSN_PREMIUM_ROLL_IND TBD

REPORTING VIEW

POSITION_DEFINITION

PREMIUM_EARNINGS_ROLL_IND_DESC

 
CASE NBBPOSN_ROLL_IND TBD

REPORTING VIEW

POSITION_DEFINITION

BUDGET_ROLL_IND_DESC

 
CASE SFRFFST_STATUS_CDE WHEN TBD

REPORTING VIEW

FACULTY_FEEDBACK

FEEDBACK_STATUS_DESC

 
CASE STVFFVA_TYPE WHEN NA        
CASE STVFFVA_TYPE WHEN 'ISSUE' THEN 'ISSUE' WHEN 'RECOMMEND' THEN 'RECOMMENDATION' END TBD

REPORTING VIEW

FACULTY_FEEDBACK_DETAIL

FEEDBACK_TYPE_DESC

 
CASE SYS.ANYDATA.GETTYPENAME( GORSDAV_VALUE) TBD

REPORTING VIEW

SUPPLEMENTAL_DATA

ATTRIBUTE_VALUE

This calculation retrieves the value from GORSDAV_VALUE based on datatype.
CASE STATEMENT NA

REPORTING VIEW

STUDENT_COURSE

REGISTRATION_OVERRIDE_IND

(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

REPORTING VIEW

AUDIT_STUDENT_COURSE

AUDIT_STUDENT_COURSE

COURSE_SOURCE_DESC

COURSE_SOURCE

 
CASE WHEN (RCRAPP1_SEQ_NO NA

REPORTING VIEW

FINAID_APPLICANT_STATUS

FINAID_APPLICANT_STATUS

FINAID_APPLICANT_STATUS

FM_APPLICATION_IND

IM_APPLICATION_IND

FINANCIAL_AID_APPLICATION_IND

 
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

REPORTING VIEW

AUTHORIZATION

ADVANCE_STATUS_DESC

 
CASE WHEN AORCONT_CONT_ORG_IND NA

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_ADDRESS_SOURCE_DESC

 
CASE WHEN AORCONT_EMAL_SRC_IND NA

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_EMAIL_SOURCE_DESC

 
CASE WHEN AORCONT_FAX_SRC_IND NA

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_FAX_SOURCE_DESC

 
CASE WHEN AORCONT_PRIMARY_IND NA

REPORTING VIEW

ORGANIZATION_CONTACT

PRIMARY_CONTACT_IND

 
CASE WHEN AORCONT_TELE_SRC_IND NA

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_PHONE_SOURCE_DESC

 
CASE WHEN APPROVAL_METHOD NA

REPORTING VIEW

REGISTRATION_PLAN

APPROVAL_METHOD_DESC

 
CASE WHEN APPROVAL_STATUS NA

REPORTING VIEW

REGISTRATION_PLAN

APPROVAL_STATUS_DESC

 
CASE WHEN CONTACT_DECEASED_IND NA

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_DECEASED_IND_DESC

 
CASE WHEN DAP_AUDIT_TYPE NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

EXCEPTION_APPLIED

AUDIT_STUDENT_NON_COURSE

AUDIT_COURSE_NEEDED

AUDIT_STUDENT_BLOCK

AUDIT_TYPE_DESC

AUDIT_TYPE_DESC

AUDIT_TYPE_DESC

AUDIT_TYPE_DESC

AUDIT_TYPE_DESC

 
CASE WHEN DAP_REASON_INSUF NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

INSUFFICIENT_REASON_DESC

 
CASE WHEN DAP_RESULT_TYPE NA

REPORTING VIEW

AUDIT_STUDENT_NON_COURSE

AUDIT_STUDENT_COURSE

AUDIT_RESULT_TYPE_DESC

AUDIT_RESULT_TYPE_DESC

 
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

COURSE_APPLIED_IND

 
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' AND AUDIT_TYPE = 'PL' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

PLANNED_COURSE_IND

 
CASE WHEN DAP_RESULT_TYPE = 'CLASSNEEDED' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

COURSE_NEEDED_IND

 
CASE WHEN DAP_RESULT_TYPE = 'FALLCLASSAPPLIED' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

COURSE_FALLTHROUGH_IND

 
CASE WHEN DAP_RESULT_TYPE = 'FALLNONCRAPPLIED' NA

REPORTING VIEW

AUDIT_STUDENT_NON_COURSE

NONCOURSE_FALLTHROUGH_IND

 
CASE WHEN DAP_RESULT_TYPE = 'INSUFFCLASSAPPLIED' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

COURSE_INSUFFICIENT_IND

 
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' NA

REPORTING VIEW

AUDIT_STUDENT_NON_COURSE

NONCOURSE_APPLIED_IND

 
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' AND AUDIT_TYPE = 'PL' AND SUBSTR(VALUE3,1,2) = 'PN' NA

REPORTING VIEW

AUDIT_STUDENT_NON_COURSE

PLANNED_NON_COURSE_IND

 
CASE WHEN DAP_RESULT_TYPE = 'NONCRNEEDED' NA

REPORTING VIEW

AUDIT_STUDENT_NON_COURSE

NONCOURSE_NEEDED_IND

 
CASE WHEN DAP_RESULT_TYPE = 'OTLCLASSAPPLIED' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

COURSE_OVER_THE_LIMIT_IND

 
CASE WHEN DAP_TRANSFER = 'C' AND DAP_INPROGRESS = 'N' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

INSTITUTION_COURSE_IND

 
CASE WHEN DAP_TRANSFER = 'T' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

TRANSFER_COURSE_IND

 
CASE WHEN ENCUMBRANCE_NUMBER NA

REPORTING VIEW

ENCUMBRANCE_ACCOUNTING

ENCUMBRANCE

HR_ENCUMBRANCE_IND

HR_ENCUMBRANCE_IND

 
CASE WHEN FABBKTP_RECON_IND NA

REPORTING VIEW

INVOICE_CHECK

BANK_RECONCILIATION_IND_DESC

 
CASE WHEN FABCHKS_CHECK_TYPE_IND NA

REPORTING VIEW

INVOICE_CHECK

CHECK_TYPE_DESC

 
CASE WHEN FABCHKS_PAY_TYPE NA

REPORTING VIEW

INVOICE_CHECK

PAY_TYPE_DESC

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

REPORTING VIEW

INVOICE_CHECK

RECONCILIATION_IND_DESC

 
CASE WHEN FABRUIV_SUB_IND NA

REPORTING VIEW

INVOICE

REPEATING_FREQUENCY_DESC

 
CASE WHEN FGBENCD_CMT_TYPE NA

REPORTING VIEW

AF_ENCUMBRANCE_ACCOUNTING

COMMITMENT_TYPE_DESC

 
CASE WHEN FGBENCD_FIELD_CODE NA

REPORTING VIEW

ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

FIELD_CODE_DESC

FIELD_CODE_DESC

 
CASE WHEN FTVVEND_CHECK_PIDM IS NULL NA

REPORTING VIEW

VENDOR

VENDOR

AF_VENDOR

AF_VENDOR

REMIT_TO_ADDRESS_NUMBER

REMIT_TO_ADDRESS_TYPE

REMIT_TO_ADDRESS_NUMBER

REMIT_TO_ADDRESS_TYPE

 
CASE WHEN GROUP_TYPE NA

REPORTING VIEW

PLAN_TEMPLATE_COURSE

TEMPLATE_GROUP_TYPE_DESC

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

REPORTING VIEW

ENCUMBRANCE_ACCOUNTING

ENCUMBRANCE_ACCOUNTING

ENCUMBRANCE_ACCOUNTING

LABOR_ITEM_TYPE

HR_ENCUMBRANCE_PERIOD_DESC

HR_ENCUMBRANCE_PERIOD

 
CASE WHEN NORTRAN_AUBK_CODE = 'SPRIDEN' THEN 'IDEN' NA

REPORTING VIEW

PERSONNEL_ACTION_GENERAL

PAF_TRANSACTION_TYPE

 
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = NA

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

RECEIVABLE_ACCOUNTING

DESIGNATOR_TYPE

DESIGNATOR_TYPE

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

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

RECEIVABLE_ACCOUNTING

DESIGNATOR_TYPE_DESC

DESIGNATOR_TYPE_DESC

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

REPORTING VIEW

RECEIVABLE_ACCOUNTING

DESIGNATOR

 
CASE WHEN OFFICIAL_TRACKING_STATUS NA

REPORTING VIEW

REGISTRATION_PLAN

REGISTRATION_PLAN

OFFICIAL_TRACKING_STATUS_DESC

PLAN_TRACK_STATUS_DESC

 
CASE WHEN PLAN_SOURCE NA

REPORTING VIEW

REGISTRATION_PLAN

PLAN_SOURCE_DESC

 
CASE WHEN R.DAP_RESULT_TYPE = 'CLASSNEEDED' THEN 'N' WHEN R.DAP_RESULT_TYPE <> 'CLASSNEEDED' AND R.DAP_AUDIT_TYPE = 'PL' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

IN_PROGRESS_COURSE_IND

 
CASE WHEN RBRAPBC_SYS_IND = 'S' TBD

REPORTING VIEW

PERIOD_BUDGET_COMPONENT

COMPONENT_SOURCE_DESC

 
CASE WHEN RFRASPC_DIRECT_LOAN_IND NA

REPORTING VIEW

FINAID_FUND

DIRECT_LOAN_TYPE_DESC

 
CASE WHEN RFRASPC_EL_LOAN_IND NA

REPORTING VIEW

FINAID_FUND

ELECTRONIC_LOAN_TYPE_DESC

 
CASE WHEN RFRASPC_MANUAL_LOAN_IND NA

REPORTING VIEW

FINAID_FUND

MANUAL_LOAN_TYPE_DESC

 
CASE WHEN RORSTAT_ADDL_PELL_ELIB_IND NA

REPORTING VIEW

FINAID_APPLICANT_STATUS

ADDITIONAL_PELL_AWARDS_DESC

 
CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND NA

REPORTING VIEW

FINAID_APPLICANT_STATUS

ADDITIONAL_STAFFORD_AWRDS_DESC

 
CASE WHEN RORSTAT_DEP_NO_PAR_DATA NA

REPORTING VIEW

FINAID_APPLICANT_STATUS

DEPENDENT_NO_PARENT_DATA_DESC

 
CASE WHEN RRRAREQ_SYS_IND NA

REPORTING VIEW

FINAID_TRACKING_REQUIREMENT

REQUIREMENT_SOURCE_DESC

 
CASE WHEN SFRBRDB_COURSE_RESTRICTION NA

REPORTING VIEW

BLOCK_REGISTRATION_COURSE

BLOCK_COURSE_RESTRICTION_DESC

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

REPORTING VIEW

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

INCOMPLETE_GRADE_IND

COURSE_EARNED_IND

COURSE_PASSED_IND

COURSE_ATTEMPTED_IND

REPEAT_EVALUATE_IND

CREDIT_FOR_GPA_IND

LAST_DATE_ATTEND_REQUIRED_IND

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

REPORTING VIEW

STUDENT_COURSE

COURSE_FAILED_IND

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

REPORTING VIEW

STUDENT_COURSE

CHARGES_WAIVED_IND

 
CASE WHEN SHRTCKG_GRDE_CODE_FINAL NA

REPORTING VIEW

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

COURSE_EARNED_IND

REPEAT_EVALUATE_IND

COURSE_PASSED_IND

CREDIT_FOR_GPA_IND

INCOMPLETE_GRADE_IND

LAST_DATE_ATTEND_REQUIRED_IND

COURSE_ATTEMPTED_IND

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

REPORTING VIEW

STUDENT_COURSE

COURSE_FAILED_IND

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

REPORTING VIEW

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

STUDENT_COURSE

INCOMPLETE_GRADE_IND

COURSE_ATTEMPTED_IND

CREDIT_FOR_GPA_IND

COURSE_EARNED_IND

COURSE_PASSED_IND

REPEAT_EVALUATE_IND

LAST_DATE_ATTEND_REQUIRED_IND

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

REPORTING VIEW

STUDENT_COURSE

COURSE_FAILED_IND

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

REPORTING VIEW

STUDENT_COURSE

REGISTER_CENSUS_DATE2_IND

 
CASE WHEN SSBSECT_CENSUS_ENROLL NA

REPORTING VIEW

STUDENT_COURSE

REGISTER_CENSUS_DATE1_IND

 
CASE WHEN STAFF_ASSIGNMENT_STATUS_IND NA

REPORTING VIEW

PROSPECT_STAFF_ASSIGNMENT

ACTIVE_STAFF_ASSIGNMENT_IND

 
CASE WHEN STATUS_CHANGE_IND NA

REPORTING VIEW

PROSPECT_CONTACT_STAFF

CONTACT_ORIGINATOR_IND_DESC

 
CASE WHEN STRATEGY_PLAN_STATUS_IND NA

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

CONSTITUENT_CONTACT

ACTIVE_PROSPECT_STRATEGY_IND

ACTIVE_PROSPECT_STRATEGY_IND

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

REPORTING VIEW

PLEDGE_TRANSACTION

PLEDGE_TRANS_FULLY_PAID_IND

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

REPORTING VIEW

PLEDGE_TRANSACTION

PLEDGE_TRANS_PARTIAL_PAID_IND

 
CASE WHEN SYSDATE BETWEEN EXCLUSION_DATE NA

REPORTING VIEW

EXCLUSION

ACTIVE_EXCLUSION_IND

 
CASE WHEN TAX_DOCUMENT_BOX NA

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TAX_DOCUMENT_BOX_NUMBER_DESC

Determine TAX_DOCUMENT_BOX hard coded descriptions based upon TBRACCD_TAX_REPT_BOX value.
CASE WHEN TAX_NOTIFICATION_STATUS NA

REPORTING VIEW

STUDENT_TAX_NOTIFICATION

FEDERAL_REPORT_STATUS_DESC

Determines hard coded descriptions for TAX_NOTIFICATION_STATUS based upon the values in TTBTAXN_STUD_NOTIF_STATUS.
CASE WHEN TBBDETC_REFUND_IND NA

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

REFUND_DESC

Hard code the description based upon the TBBDETC_REFUND_IND Hard code the detail code refund description based upon the refund indicator. CASE WHEN TBBDETC_REFUND_IND = 'Y' THEN REFUND_DESC = 'Refund' WHEN TBBDETC_REFUND_IND = 'M' THEN REFUND_DESC = 'Manual Refund' WHEN TBBDETC_REFUND_IND = 'P' THEN REFUND_DESC = 'Parent PLUS Refund' ELSE REFUND_DESC = 'No Refund' END
CASE WHEN TBBDETC_TBDC_IND NA

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

LEDGER_DESIGNATOR

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

REPORTING VIEW

APPLICATION_OF_PAYMENT

RECEIVABLE_ACCOUNTING

APPLICATION_OF_PAYMENT

CHARGE_OPERATING_DESIGNATOR

DESIGNATOR_IND

PAY_OPERATING_DESIGNATOR

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

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

OPERATING_DESIGNATOR

 
CASE WHEN TRACKING_STATUS NA

REPORTING VIEW

REGISTRATION_PLAN_COURSE

TRACKING_STATUS_DESC

 
CASE WHEN UNOFFICIAL_TRACKING_STATUS NA

REPORTING VIEW

REGISTRATION_PLAN

REGISTRATION_PLAN

UNOFFICIAL_TRACK_STATUS_DESC

PLAN_UNOFF_TRACK_STATUS_DESC

 
CASE(AMRCONT_GEN_CONTACT_IND) NA

REPORTING VIEW

CONSTITUENT_CONTACT

PROSPECT_CONTACT_IND

 
COUNT (*) OVER (PARTITION BY B.PERSON_UID) NA

REPORTING VIEW

REGISTRATION_PLAN_COURSE

PROJECTED_SEAT_NEEDED

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

REPORTING VIEW

PROJECTED_SEATS_NEEDED

SEATS_NEEDED

 
COUNT (DISTINCT COURSE_REFERENCE_NUMBER) TBD

REPORTING VIEW

PROJECTED_SEATS_NEEDED

SCHEDULE_OFFERING_COUNT

 
COUNT (DISTINCT PERSON_UID) TBD

REPORTING VIEW

PROJECTED_SEATS_NEEDED

STUDENT_HEADCOUNT

 
COUNT(AMRATTN_PIDM) NA

REPORTING VIEW

CONSTITUENT_CONTACT

TOTAL_STAFF_COUNT

 
COURSE_DISCIPLINE||COURSE_NUMBER NA

REPORTING VIEW

PLAN_TEMPLATE_COURSE

COURSE_IDENTIFICATION

 
COURSE_REFERENCE_NUMBER_KEY * 1000000 + ACADEMIC_TIME_KEY * 100 + MULTI_SOURCE_KEY TBD        
DAP_VALUE1 || DAP_VALUE2 NA

REPORTING VIEW

AUDIT_COURSE_NEEDED

AUDIT_STUDENT_COURSE

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

 
DAP_VALUE2 || DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

AUDIT_COURSE_NEEDED

AUDIT_STUDENT_NON_COURSE

AUDIT_RUN_DATE

AUDIT_RUN_DATE

AUDIT_RUN_DATE

 
DECODE ( DECODE ( SIGN ( NVL ( TBRACCD_TRANS_DATE, TBRACCD_EFFECTIVE_DATE) TSADETL

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

OPERATING_DATE

 
DECODE (MRVAND0_EFC_IND, 'F', '', RNKNEED.F_CALC_BUDGET_AMT (MRVAND0_PIDM, MRVAND0_AIDY_CODE, 'I')), '999999999D99') TBD

REPORTING VIEW

APPLICANT_NEED

IM_COST_OF_EDUCATION

 
DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND) NA

REPORTING VIEW

EMPLOYEE_POSITION

EMPLOYEE

EXEMPTION_TYPE_DESC

EXEMPTION_TYPE_DESC

DECODE(NBBPOSN_EXEMPT_IND,'Y',DECODE(NTRPCLS_EXEMPT_IND,'Y','Exemption Position Class and Position Definition','Non-exempt Position Class and Position Definition'),DECODE(NTRPCLS_EXEMPT_IND,'Y','Exempt Class but overridden by the Position Definition','Non-exempt Position Class but overridden by the Position Definition'))
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND (ENTITY_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION') TBD

REPORTING VIEW

GIFT_MATCHING_DETAIL

ENTITY_IND_DESC

 
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND ( MATCH_EMPLOYER_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION') TBD

REPORTING VIEW

GIFT_MATCHING_DETAIL

MATCH_ENTITY_IND_DESC

 
DECODE(AGBMGID_DELETE_IND,'I','N','Y'), NA

REPORTING VIEW

GIFT_MATCHING

ACTIVE_IND

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

REPORTING VIEW

GIFT_MATCHING_TRANSACTION

GIFT_MATCHING

MATCH_GIFT_STATUS

MATCH_GIFT_STATUS

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

REPORTING VIEW

GIFT_MATCHING

GIFT_MATCHING_TRANSACTION

MATCH_GIFT_STATUS_DESC

MATCH_GIFT_STATUS_DESC

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

REPORTING VIEW

GIFT_AUXILIARY

BENEFIT_ACCEPT_REJECT_DESC

NA
DECODE(AGRPAUX_PLDG_ADJ_VOID_IND) NA

REPORTING VIEW

PLEDGE_AUXILIARY

PLEDGE_AUXILIARY

PLEDGE_VOID_IND

PLEDGE_ADJUSTMENT_IND

 
DECODE(AGRPCON_MET_IND) NA

REPORTING VIEW

PLEDGE_CONDITIONAL

CONDITION_MET_DESC

 
DECODE(AGRPDES_AMT-AGRPDES_AMT_PAID) NA

REPORTING VIEW

PLEDGE

PLEDGE_FULLY_PAID_IND

NA
DECODE(AGRPDES_AMT_PAID) NA

REPORTING VIEW

PLEDGE

PLEDGE_PARTIAL_PAID_IND

NA
DECODE(AMRPLAN_PROJ_CODE, AMRCONT_PROJ_CODE) NA

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

PRIMARY_PROJECT_IND

 
DECODE(AMRPRRT_RATING_PIDM,NULL, AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM) NA

REPORTING VIEW

ADVANCEMENT_RATING

RATER_UID

NA
DECODE(APRADEG_HOND_CODE_1) NA

REPORTING VIEW

COMBINED_ACADEMIC_OUTCOME

DEPARTMENT_HONORS_COUNT

 
DECODE(APRADEG_HONR_CODE) NA

REPORTING VIEW

COMBINED_ACADEMIC_OUTCOME

INSTITUTIONAL_HONORS_COUNT

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

REPORTING VIEW

DEGREE_SLOT

DEGREE

INSTITUTION_IND

INSTITUTION_IND

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

REPORTING VIEW

RELATIONSHIP

SPOUSE_STATUS_DESC

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

REPORTING VIEW

GIFT_SOCIETY

LIFETIME_GIFT_SOCIETY_IND

NA
DECODE(APRIGRP_DISPLAY_WEB_IND) NA        
DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY', 'S','SECONDARY') NA

REPORTING VIEW

RELATIONSHIP

COMBINED_MAILING_PRIORITY_DESC

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

REPORTING VIEW

DESIGNATION_ADJUSTMENT

ADJUSTMENT_DEBIT_CREDIT_DESC

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

REPORTING VIEW

CAMPAIGN_DESIGNATION

MATCHING_GIFT_VSE_PURPOSE_DESC

 
DECODE(ATVDONR_CFAE_2) NA       NA
DECODE(ATVGIFT_CFAE_GIFT_CATG) NA

REPORTING VIEW

GIFT

GIFT_TRANSACTION

GIFT_VSE_DESC

GIFT_VSE_DESC

NA
DECODE(BENEFICIARY_NAME) NA

REPORTING VIEW

BENEFICIARY_DEPENDENT

BENEFICIARY_NAME

DECODE(B.BENEFICIARY_LAST_NAME, NULL, BP.FULL_NAME_LFMI, B.BENEFICIARY_LAST_NAME||', '||B.BENEFICIARY_FIRST_NAME||' '||DECODE(B.BENEFICIARY_MIDDLE_INITIAL,NULL,NULL,SUBSTR(BENEFICIARY_MIDDLE_INITIAL,1,1))|| '.')
DECODE(C.EXPENSE_TYPE_CODE, '9900ADVC', 'Y','N') TBD

REPORTING VIEW

REIMBURSEMENT_ACCOUNTING

REIMBURSEMENT_ITEM

EXPENSE_ADVANCE_CLEARED_IND

EXPENSE_ADVANCE_CLEARED_IND

 
DECODE(ENROLLED_IND, 'N', 'Y', 'N') NA

REPORTING VIEW

ENROLLMENT

NOT_ENROLLED_IND

 
DECODE(EXPENSE_TYPE_CODE,'9900ADVC') TBD

REPORTING VIEW

PORTFOLIO_SUMMARY

EXPENSE_ADVANCE_CLEARED_IND

 
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL) FAAINVE

REPORTING VIEW

INVOICE

REMIT_TO_STREET_LINE1

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL) FAAINVE

REPORTING VIEW

INVOICE

REMIT_TO_STREET_LINE2

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL) FAAINVE

REPORTING VIEW

INVOICE

REMIT_TO_STREET_LINE3

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_CITY, NULL) FAAINVE

REPORTING VIEW

INVOICE

REMIT_TO_CITY

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_NATN, NULL) FAAINVE

REPORTING VIEW

INVOICE

REMIT_TO_NATION

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_STATE, NULL) FAAINVE

REPORTING VIEW

INVOICE

REMIT_TO_STATE_PROVINCE

NA
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ZIP, NULL) FAAINVE

REPORTING VIEW

INVOICE

REMIT_TO_POSTAL_CODE

NA
DECODE(FABINVH_ATYP_CODE, NULL, TO_NUMBER(NULL), FABINVH_ATYP_SEQ_NUM) FAAINVE

REPORTING VIEW

INVOICE

REMIT_TO_ADDRESS_TYPE_NUMBER

NA
DECODE(FABINVH_ATYP_CODE,NULL,'Y','N') FAAINVE

REPORTING VIEW

INVOICE

ONE_TIME_VENDOR_ADDRESS_IND

NA
DECODE(FABINVH_GROUPING_IND) NA

REPORTING VIEW

INVOICE

INVOICE

GROUPING_DESC

GROUPING

 
DECODE(FABINVH_INVOICE_TYPE_IND) FAAINVE

REPORTING VIEW

INVOICE

INVOICE_TYPE_DESC

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

REPORTING VIEW

INVOICE

RECEIVING_REQUIRED_DESC

 
DECODE(FABINVH_VEND_CHECK_PIDM,NULL,'N', 'Y') FAAINVE

REPORTING VIEW

INVOICE

THIRD_PARTY_ADDRESS_IND

NA
DECODE(FEEDBACK_COMMENT,NULL,'NO','YES') TBD

REPORTING VIEW

FACULTY_FEEDBACK_DETAIL

FEEDBACK_COMMENT_IND

 
DECODE(FEEDBACK_ESTIMATED_GRADE,NULL, 'NO','YES') TBD

REPORTING VIEW

FACULTY_FEEDBACK_DETAIL

FEEDBACK_ESTIMATED_GRADE_IND

 
DECODE(FEEDBACK_STATUS,'M','YES','NO') TBD

REPORTING VIEW

FACULTY_FEEDBACK_DETAIL

STUDENT_MONITOR_IND

 
DECODE(FFBMAST_SUBORDINATE_TYPE) FFAMAST

REPORTING VIEW

FIXED_ASSET_ITEM

SUBORDINATE_TYPE_DESC

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

REPORTING VIEW

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_HISTORY

DEPRECIATION_POSTING_STATUS

DEPRECIATION_POSTING_STATUS

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

REPORTING VIEW

ENCUMBRANCE_ACCOUNTING

ENCUMBRANCE_STATUS

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

REPORTING VIEW

ENCUMBRANCE_ACCOUNTING

POSTABLE_IND

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

REPORTING VIEW

ENCUMBRANCE

ENCUMBRANCE_SOURCE

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

REPORTING VIEW

ENCUMBRANCE

COMPLETE_IND

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

REPORTING VIEW

ENCUMBRANCE_ACCOUNTING

ENCUMBRANCE

DOCUMENT_ENCUMBRANCE_STATUS

ENCUMBRANCE_STATUS

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

REPORTING VIEW

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

RESTRICTION_TYPE_DESC

RESTRICTION_TYPE_DESC

This calculation will evaluate the column FNVENDW_REST_TYPE. If it is an R, it will return RESTRICTED. If it is a U, it will return UNRESTRICTED. Otherwise it will return NULL.
DECODE(FNVPOOL_STATUS_IND) FNMPOOL

REPORTING VIEW

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

POOL_STATUS_DESC

POOL_STATUS_DESC

This calculation will evaluate the column FNVPOOL_STATUS_IND. If it is an A, it will return ACTIVE. If it is an I, it will return INACTIVE. Otherwise, it will return NULL.
DECODE(FOKODSF.F_GET_REST_IND) NA

REPORTING VIEW

FUND_HIERARCHY

FUND_HIERARCHY_FISCAL

FUND_BALANCE_RESTRICTION_DESC

FUND_BALANCE_RESTRICTION_DESC

 
DECODE(FORCIRR_DATA_ORIGIN) NA

REPORTING VIEW

AUTHORIZATION_APPROVAL_HISTORY

REIMBURSEMENT_APPROVAL_HISTORY

ADDITIONAL_APPROVER_IND

ADDITIONAL_APPROVER_IND

 
DECODE(FPBPOHD_MATCH_REQUIRED) FPAPURR

REPORTING VIEW

PURCHASE_ORDER

RECEIVING_REQUIRED_DESC

 
DECODE(FPBPOHD_PO_TYPE_IND) FPAPURR

REPORTING VIEW

PURCHASE_ORDER

PURCHASE_ORDER_TYPE_DESC

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

REPORTING VIEW

PURCHASE_ORDER

REQUISITION_OR_BID_SOURCE_DESC

 
DECODE(FPBPOHD_TEXT_IND) FPAPURR

REPORTING VIEW

PURCHASE_ORDER

REQUISITION_TEXT_DESC

 
DECODE(FPBRCDT_ADJUST_RECEIVE_IND) FPARCVD

REPORTING VIEW

RECEIVED_ITEM

ADJUSTED_IND

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

REPORTING VIEW

PURCHASE_ORDER_ITEM_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

NSF_SUSPENSE_DESC

NSF_SUSPENSE_DESC

 
DECODE(FPRPODT_TEXT_USAGE) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

TEXT_USAGE_DESC

 
DECODE(FPRRCDT_PARTIAL_FINAL_IND) FPARCVD

REPORTING VIEW

RECEIVED_ITEM

FINAL_RECEIPT_IND

Calculation determines if value is set to (P)artial or (F)inal.
DECODE(FRBEVNG_PMT_METHOD_TYPE_IND) NA        
DECODE(FRRBDET_ACCT_CLASS_CODE) FRABDCN

REPORTING VIEW

GRANT_BILLING_DETAIL

ACCOUNT_CLASS

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

REPORTING VIEW

GRANT_BILLING_DETAIL

BILL_STATUS_DESC

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

REPORTING VIEW

GRANT_PERSONNEL

GRANT_EVENT

BILL_FORMAT_TYPE_DESC

BILL_FORMAT_TYPE_DESC

 
DECODE(FTVATTT_STATUS_IND) FTMATTT

REPORTING VIEW

ACCOUNT_ATTRIBUTES

PROGRAM_ATTRIBUTES

CHART_ATTRIBUTES

LOCATION_ATTRIBUTES

ORGANIZATION_ATTRIBUTES

ACCOUNT_TYPE_ATTRIBUTES

ACTIVITY_ATTRIBUTES

ATTRIBUTE_SETS

FUND_ATTRIBUTES

FUND_TYPE_ATTRIBUTES

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

ATTRIBUTE_TYPE_STATUS_DESC

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

REPORTING VIEW

FUND_HIERARCHY

FUND_HIERARCHY_FISCAL

FUND_BALANCE_DESC

FUND_BALANCE_DESC

 
DECODE(FTVFSPD_PRD_STATUS_IND) NA

REPORTING VIEW

OPERATING_LEDGER

BUDGET_AVAILABILITY_LEDGER

GENERAL_LEDGER

FISCAL_PERIOD_STATUS_DESC

FISCAL_PERIOD_STATUS_DESC

FISCAL_PERIOD_STATUS_DESC

 
DECODE(FTVFUND_REST_IND) NA

REPORTING VIEW

FUND_HIERARCHY

FUND_HIERARCHY_FISCAL

FUND_RESTRICTION_DESC

FUND_RESTRICTION_DESC

 
DECODE(FTVVEND_1099_RPT_ID) FTMVEND

REPORTING VIEW

VENDOR

FEDERAL_REPORTABLE_TAX_IND

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

REPORTING VIEW

HR_APPLICATION

STATUS_DISPOSITION_DESC

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

REPORTING VIEW

INTERNET_ADDRESS

INTERNET_ADDRESS_STATUS_DESC

 
DECODE(GORSGEO_SOURCE_IND,'S','N','Y') NA

REPORTING VIEW

GEOGRAPHIC_REGION_INSTITUTION

GEOGRAPHIC_SOURCE_USER_IND

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

REPORTING VIEW

GEOGRAPHIC_REGION_INSTITUTION

GEOGRAPHIC_REGION_STATUS

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

REPORTING VIEW

GEOGRAPHIC_REGION_INSTITUTION

GEOGRAPHIC_REGION_STATUS_DESC

DECODE(GORSGEO_STATUS_IND,NULL,'Active','Inactive')
DECODE(GROUP_TYPE) NA

REPORTING VIEW

REGISTRATION_PLAN_COURSE

PLAN_GROUP_TYPE_DESC

 
DECODE(GURMAIL_DATE_PRINTED,NULL,'Y', 'N') NA

REPORTING VIEW

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

PENDING_LETTER_IND

PENDING_LETTER_IND2

PENDING_LETTER_IND3

PENDING_LETTER_IND4

PENDING_LETTER_IND5

PENDING_LETTER_IND1

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

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_TYPE_DESC2

COMMUNICATION_TYPE_DESC3

COMMUNICATION_TYPE_DESC1

COMMUNICATION_TYPE_DESC5

COMMUNICATION_TYPE_DESC

COMMUNICATION_TYPE_DESC4

NA
DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

DEPENDENCY_OVERRIDE_DESC

 
DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C', CANCELLED,'F',FROZEN,'I',INACTIVE) NA

REPORTING VIEW

POSITION_DEFINITION

POSITION_STATUS_DESC

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

REPORTING VIEW

EMPLOYEE_POSITION

EMPLOYEE

POSITION_CONTRACT_TYPE_DESC

POSITION_CONTRACT_TYPE_DESC

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

REPORTING VIEW

EMPLOYEE_POSITION

PUBLIC_RETIRE_PAY_RATE_DESC

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

REPORTING VIEW

EMPLOYEE

PAYROLL_EMPLOYEE_POSITION

PAYROLL_POSITION_TIMESHEET

POSITION_STATUS_DESC

POSITION_STATUS_DESC

POSITION_STATUS_DESC

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

REPORTING VIEW

EMPLOYEE_POSITION

STATE_RETIREMENT_PAY_RATE_DESC

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

REPORTING VIEW

POSITION_BUDGET

PAYROLL_DISTRIBUTION

BUDGET_STATUS_DESC

BUDGET_STATUS_DESC

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

REPORTING VIEW

PAYROLL_DISTRIBUTION

PAYROLL_EVENT_TYPE_DESC

SUBSTR(DECODE(NHRDIST_HIST_TYPE_IND, 'J', G$_NLS.GET('x','SQL','Adjusted'), 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Original'), 'R', G$_NLS.GET('x','SQL','Redistributed'), 'I', G$_NLS.GET('x','SQL','Reissued'), 'V', G$_NLS.GET('x','SQL','Voided')),1,30)
DECODE(NORMAL_BALANCE) NA

REPORTING VIEW

PAYROLL_DISTRIBUTION

NORMALIZED_TRANSACTION_AMOUNT

NA
DECODE(NVL(AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'N', NVL(AGVPLG1_PLEDGE_AMOUNT,0) , 'N','Y') NA       NA
DECODE(PAYROLL_DEDUCTION) NA

REPORTING VIEW

YEARLY_DEDUCTION

YEARLY_DEDUCTION

GROSS_COMPENSATION_YTD

EMPLOYER_CONTRIBUTION_YTD

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

REPORTING VIEW

BENEFIT_DEDUCTION

STATUS_DESC

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

REPORTING VIEW

TAX

STATUS_DESC

NA
DECODE(PEBEMPL_1042_RECIPIENT_CD) NA

REPORTING VIEW

EMPLOYEE

FOREIGN_INCOME_RECIPIENT_DESC

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

REPORTING VIEW

EMPLOYEE

PUBLIC_RETIREMENT_MEMBER_DESC

 
DECODE(PEBEMPL_EMPL_STATUS) NA

REPORTING VIEW

EMPLOYEE

EMPLOYEE_STATUS_DESC

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

REPORTING VIEW

EMPLOYEE

FAIR_LABOR_STANDARDS_TYPE_DESC

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

REPORTING VIEW

EMPLOYEE

IMMIGRATION_STATUS_DESC

This function returns RECEIVED if the I9 form indicator PEBEMPL_I9_FORM_IND is R, NOTRECEIVED if it is N, TEMPORARY if it is T,
DECODE(PENDING_LETTER_IND,'Y',1,0) TBD        
DECODE(PERAPPT_DECISION) NA

REPORTING VIEW

FACULTY_TRACKING

FACULTY_APPOINTMENT_HISTORY

APPOINTMENT_DECISION_DESC

APPOINTMENT_DECISION_DESC

SUBSTR(DECODE(PERAPPT_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30)
DECODE(PERBFAC_PRIMARY_ACTIVITY) PEAFACT,PEAFACD

REPORTING VIEW

FACULTY_TRACKING

PRIMARY_ACTIVITY_DESC

SUBSTR(DECODE(PERBFAC_PRIMARY_ACTIVITY, 'A', G$_NLS.GET('x','SQL','Administrative'), 'I', G$_NLS.GET('x','SQL','Instructional'),'R', G$_NLS.GET('x','SQL','Research')),1,30)
DECODE(PERJTOT_MONTH,1,1,2,1,3,1,4,2,5, 2,6,2,7,3,8,3,9,3,10,4,11,4,12,4) NA

REPORTING VIEW

EMPLOYEE_EARNING_CY

QUARTER

This function returns what quarter it is based on the month PERJTOT_MONTH. 1, 2, 3 are the first quarter. 4, 5, 6 are the second quarter. 7, 8, 9 are the third quarter. 10, 11, 12 are the fourth quarter.
DECODE(PERRANK_DECISION) NA

REPORTING VIEW

FACULTY_TRACKING

RANK_DECISION_DESC

SUBSTR(DECODE(PERRANK_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30)
DECODE(PERSABB_DECISION) NA

REPORTING VIEW

FACULTY_TRACKING

SABBATICAL_DECISION_DESC

SUBSTR(DECODE(PERSABB_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30)
DECODE(PHRACCR_CALC_GEN_IND) NA

REPORTING VIEW

LEAVE_ACCRUAL

PAYROLL_CALCULATION_TYPE_DESC

SUBSTR(DECODE(PHRACCR_CALC_GEN_IND, 'Y', G$_NLS.GET('x','SQL','Calculated'), 'N', G$_NLS.GET('x','SQL','Manual')),1,30)
DECODE(PHRATND_TS_ROSTER_IND) NA

REPORTING VIEW

PAYROLL_ATTENDANCE

TIMESHEET_METHOD_DESC

 
DECODE(PHRDOCM_DOC_TYPE) NA

REPORTING VIEW

PAYROLL_DOCUMENT

DIRECT_DEPOSIT_IND

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

REPORTING VIEW

PAYROLL_LABOR_DIST_OVERRIDE

TIMESHEET_METHOD_DESC

 
DECODE(PHRHIST_CALC_IND) NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PAYROLL_POSITION_TIMESHEET

PAYROLL_CALCULATION_TYPE_DESC

PAYROLL_CALCULATION_TYPE_DESC

SUBSTR(DECODE(PHRHIST_CALC_IND, 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Calculated')),1,30)
DECODE(PHRHIST_PRINT_IND) NA

REPORTING VIEW

PAYROLL_POSITION_TIMESHEET

PAYROLL_EMPLOYEE_POSITION

DOCUMENT_PRINT_METHOD_DESC

DOCUMENT_PRINT_METHOD_DESC

SUBSTR(DECODE(PHRHIST_PRINT_IND, 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Calculated')),1,30)
DECODE(PHRHIST_TYPE_IND) NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PAYROLL_EVENT_TYPE_DESC

 
DECODE(PHRJOBS_TIME_ENTRY_IND) NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PAYROLL_POSITION_TIMESHEET

TIME_ENTRY_TYPE_DESC

TIME_ENTRY_TYPE_DESC

SUBSTR(DECODE(PHRJOBS_TIME_ENTRY_IND, 'P', G$_NLS.GET('x','SQL','Pay Period'), 'F', G$_NLS.GET('x','SQL','FSLA'), 'W', G$_NLS.GET('x','SQL','Weekly'), 'D', G$_NLS.GET('x','SQL','Daily'), 'N', G$_NLS.GET('x','SQL','None')),1,30)
DECODE(PHRJOBS_TS_ROSTER_IND) NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PAYROLL_EARNING

PAYROLL_POSITION_TIMESHEET

TIMESHEET_METHOD_DESC

TIMESHEET_METHOD_DESC

TIMESHEET_METHOD_DESC

SUBSTR(DECODE(PHRJOBS_TS_ROSTER_IND, 'T', G$_NLS.GET('x','SQL','Timesheet'), 'O', G$_NLS.GET('x','SQL','Organization'), 'R', G$_NLS.GET('x','SQL','Roster')),1,30)
DECODE(PHRJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD') NA

REPORTING VIEW

PAYROLL_EMPLOYEE_POSITION

PAYROLL_POSITION_TIMESHEET

POSITION_CONTRACT_TYPE_DESC

POSITION_CONTRACT_TYPE_DESC

NA
DECODE(PTRBDCA_CALC_RULE) NA

REPORTING VIEW

PAYROLL_DEDUCTION

TAX_DEDUCTION_IND

substr(gokodsf.f_get_null_varchar2,1,6), substr(gokodsf.f_get_desc(null, 'GTVVPDI') ,1,30), substr(gokodsf.f_get_null_varchar2,1,6), substr(gokodsf.f_get_null_varchar2,1,6),
DECODE(RCRAPP1_BORN_BEFORE_1_1_XX) RNANAXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

OLDER_THAN_24_IND

 
DECODE(RCRAPP1_DEGREE_BY_JULY) RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

DEGREE_BY_JULY_IND

 
DECODE(RCRAPP1_HAS_LEGAL_DEPEND) RNANAXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

LEGAL_DEPENDENT_IND

 
DECODE(RCRAPP1_INS) RNARSXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

PERM_RESIDENCY_CONFIRMED_IND

 
DECODE(RCRAPP1_LINE2_RELSHIP) RNASUXX        
DECODE(RCRAPP1_LINE3_ATTEND_COLL) RNASUXX        
DECODE(RCRAPP1_LINE3_RELSHIP) RNASUXX        
DECODE(RCRAPP1_LINE4_ATTEND_COLL) RNASUXX        
DECODE(RCRAPP1_LINE4_RELSHIP) NA        
DECODE(RCRAPP1_LINE5_ATTEND_COLL) RNASUXX        
DECODE(RCRAPP1_LINE5_RELSHIP) NA        
DECODE(RCRAPP1_LINE6_ATTEND_COLL) RNASUXX        
DECODE(RCRAPP1_LINE6_RELSHIP) RNASUXX        
DECODE(RCRAPP1_LINE7_ATTEND_COLL) RNASUXX        
DECODE(RCRAPP1_LINE7_RELSHIP) RNASUXX        
DECODE(RCRAPP1_LINE8_ATTEND_COLL) RNASUXX        
DECODE(RCRAPP1_LINE8_RELSHIP) RNASUXX        
DECODE(RCRAPP1_MRTL_STATUS) NA        
DECODE(RCRAPP1_PAR_DIV_SEP_REM_IND) RNASUXX        
DECODE(RCRAPP1_PAR_HOUS_STAT) RNASUXX        
DECODE(RCRAPP1_PAR_TAX_FORM_IND) RNAPRXX RNANAXX        
DECODE(RCRAPP1_PERMIT_DRAFT_REG) RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

PERMIT_DRAFT_REGISTRATION_IND

 
DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR) RNAPRXX        
DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR) RNAPRXX        
DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR) RNAPRXX        
DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR) RNAPRXX        
DECODE(RCRAPP1_SIGNED) RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS_DEMOGRAPHIC

APPLICATION_SIGNED_BY

APPLICATION_SIGNED_BY_DESC

 
DECODE(RCRAPP1_TAX_FORM_IND) RNANAXX        
DECODE(RCRAPP1_TITLE) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NAME_PREFIX

 
DECODE(RCRAPP1_US_VET) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

VETERAN_IND

 
DECODE(RCRAPP1_VERIFICATION_MSG) RNARSXX RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

SELECTED_FOR_VERIFICATION_IND

 
DECODE(RCRAPP1_YR_IN_COLL) RNASUXX        
DECODE(RCRAPP2_C_1_ANLY_TYPE) RNARSXX

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_ANALYSIS_TYPE_DESC

 
DECODE(RCRAPP2_C_1_CTRB_OFFL_EST) RNARSXX

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_CONTRIBUTION_OFFICIAL_DESC

 
DECODE(RCRAPP2_C_1_VA_BEN_INCL) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_VETERAN_BENEFITS_IND

 
DECODE(RCRAPP2_C_2_CTRB_OFFL_EST) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_INST_METHOD

IM_CONTRIBUTION_OFFICIAL_DESC

 
DECODE(RCRAPP2_C_2_VA_BEN_INCL) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_INST_METHOD

IM_VETERAN_BENEFITS_IND

 
DECODE(RCRAPP2_C_DEPEND_STATUS) NA

REPORTING VIEW

NEED_ANALYSIS

DEPENDENCY_STATUS_DESC

 
DECODE(RCRAPP2_C_MRTL_STATUS) TBD

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_MARITAL_STATUS_DESC

 
DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_PARENT_ANALYSIS_TYPE_DESC

 
DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST) RNARSXX        
DECODE(RCRAPP2_C_PAR_2_CTRB_FR_ASSET) RNINAIQ        
DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_INST_METHOD

IM_PARENT_CONTRIB_OFF_DESC

 
DECODE(RCRAPP2_C_PAR_MRTL_STATUS) TBD

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_PARENT_MARITAL_STATUS_DESC

 
DECODE(RCRAPP2_ELIGIBILITY_MSG) RNARSXX

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

SAR_C_IND

SAR_C_IND

 
DECODE(RCRAPP2_MODEL_CDE) ROASTAT

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

NEED_ANALYSIS_FEDERAL_METHOD

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

FAMILY_IN_COLLEGE

FAMILY_SIZE

FM_FAMILY_SIZE

FAMILY_IN_COLLEGE

FAMILY_SIZE

 
DECODE(RCRAPP2_PELL_ANLY_TYPE) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

SIMPLIFIED_NEEDS_TEST_IND

 
DECODE(RCRAPP2_PELL_CTRB_OFFL_EST) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_EST_CONTRIB_OFFICIAL_DESC

 
DECODE(RCRAPP2_PELL_PGI_OFFL_EST) RNARSXX

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

PELL_EFC_OFFICIAL_DESC

 
DECODE(RCRAPP2_PELL_P_ANLY_TYPE) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_PARENT_EST_ANAL_TYPE_DESC

 
DECODE(RCRAPP3_C_SIGNED) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

SIGNATURE_IND

 
DECODE(RCRAPP3_C_SIGNED_FATH) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

FATHER_SIGNATURE_IND

 
DECODE(RCRAPP3_C_SIGNED_MOTH) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

MOTHER_SIGNATURE_IND

 
DECODE(RCRAPP3_C_SIGNED_SPS) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

SPOUSE_SIGNATURE_IND

 
DECODE(RCRAPP3_DEGREE_TYPE) RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

DEGREE_TYPE_DESC

 
DECODE(RCRAPP3_FAA_DEP_OVERRIDE) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS

DEPENDENCY_OVERRIDE_DESC

 
DECODE(RCRAPP3_FATH_SSN_MATCH) RNANAXX RNARSXX        
DECODE(RCRAPP3_GRAD_OR_PROF) RNANAXX

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

GRADUATE_PROFESSIONAL_IND

GRADUATE_PROFESSIONAL_IND

 
DECODE(RCRAPP3_LIVE_ON_FARM) RNAPRXX        
DECODE(RCRAPP3_MARRIED) RNANAXX

REPORTING VIEW

NEED_ANALYSIS

MARITAL_STATUS_IND

 
DECODE(RCRAPP3_MOTH_SSN_MATCH) RNANAXX RNARSXX        
DECODE(RCRAPP3_OFFL_UNOFFL_IND) RNARSXX

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

OFFICIAL_SOURCE_IND

OFFICIAL_SOURCE_IND

 
DECODE(RCRAPP3_PAR_LIVE_ON_FARM) RNAPRXX        
DECODE(RCRAPP3_PREPARER_SIGN) RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

PREPARER_SIGNATURE_IND

 
DECODE(RCRAPP3_SOC_SEC) RNARSXX        
DECODE(RCRAPP3_YR_IN_COLL_2) RNASUXX        
DECODE(RCRAPP4_1040A_ELIG_IND) RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

SHORT_TAX_FORM_IND

 
DECODE(RCRAPP4_ADDRESS_CHG_FLAG) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

ADDRESS_CHANGE_DESC

 
DECODE(RCRAPP4_CUSTODIAL_PARENT) RNASUXX RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_INST_METHOD

IM_CUSTODIAL_PARENT_DESC

 
DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

PELL_EFC_OFFICIAL_EST_DESC

 
DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_PARENT_CONTRIB_OFF_EST_DESC

 
DECODE(RCRAPP4_EFC_CHANGE_IND) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

EFC_CHANGE_FLAG_DESC

 
DECODE(RCRAPP4_FEE_WAIVER_IND) TBD        
DECODE(RCRAPP4_FORMULA_FOR_CALC) RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_FEDERAL_METHOD

FM_FORMULA_DESC

 
DECODE(RCRAPP4_HAVE_CHILDREN) RNANAXX

REPORTING VIEW

NEED_ANALYSIS

SUPPORT_CHILDREN_IND

 
DECODE(RCRAPP4_HS_GED_RCVD) RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

SECONDARY_SCHOOL_DIPLOMA_IND

 
DECODE(RCRAPP4_LEGAL_RES_IND) RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

LEGAL_RESIDENT_IND

 
DECODE(RCRAPP4_NSLDS_MATCH) RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NATIONAL_STUDENT_LOAN_SYS_DESC

 
DECODE(RCRAPP4_PAR_1040A_ELIG_IND) RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

PARENT_SHORT_TAX_FORM_IND

 
DECODE(RCRAPP4_PAR_LEGAL_RES_IND) RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

PARENT_LEGAL_RESIDENT_IND

 
DECODE(RCRAPP4_SAR_C_CHANGE_FLAG) RNIMSXX        
DECODE(RCRAPP4_SEC_INS_MATCH_IND) RNARSXX        
DECODE(RCRAPP4_SOURCE_CORRECTION) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

CORRECTION_SOURCE_DESC

 
DECODE(RCRAPP4_SSA_CITIZEN_IND) RNARSXX        
DECODE(RCRAPP4_SS_MATCH) RNARSXX        
DECODE(RCRAPP4_SS_REG_FLAG) RNARSXX        
DECODE(RCRAPP4_TX_RET_FILED_IND) RNAPRXX        
DECODE(RCRAPP4_TYPE_DATA_AVAIL) RNINAIQ        
DECODE(RCRAPP4_VA_MATCH_FLAG) RNARSXX        
DECODE(RCRAPP4_VISA_CLASS) RNASUXX        
DECODE(RCRAPP4_WORK_STUDY) RNANAXX        
DECODE(RCRESAR_AUTO_ZERO_EFC_FLAG) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

AUTOMATIC_ZERO_EFC_IND

 
DECODE(RCRESAR_A_BORN_BEFORE_IND) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

OLDER_THAN_24_IND

 
DECODE(RCRESAR_A_CITZ_IND) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

ASSUMED_CITIZENSHIP_DESC

 
DECODE(RCRESAR_A_MARRIED) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

ASSUMED_MARRIED_IND

 
DECODE(RCRESAR_A_MRTL_STATUS_IND) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

MARITAL_STATUS_IND

 
DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

PARENT_MARITAL_STATUS_IND

 
DECODE(RCRESAR_A_PAR_TAX_FILED_IND) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

PARENT_TAX_FILER_IND

 
DECODE(RCRESAR_A_S_DEPENDANTS) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

ASSUMED_DEPENDENT_IND

 
DECODE(RCRESAR_A_TAX_FILED_IND) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

TAX_FILER_IND

 
DECODE(RCRESAR_A_VA_STATUS) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

ASSUMED_VETERAN_IND

 
DECODE(RCRESAR_DUP_REQ_IND) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

DUPLICATE_REQUEST_IND

 
DECODE(RCRESAR_EDE_ETI_IND) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

ISIR_ELECT_TRANSACTION_DESC

 
DECODE(RCRESAR_EDE_INST_IND) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

ELECT_APPL_ENTRY_SOURCE_IND

 
DECODE(RCRESAR_FED_HOUS_CDE_1) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

FEDERAL_HOUSING1_DESC

 
DECODE(RCRESAR_FED_HOUS_CDE_2) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

FEDERAL_HOUSING2_DESC

 
DECODE(RCRESAR_FED_HOUS_CDE_3) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

FEDERAL_HOUSING3_DESC

 
DECODE(RCRESAR_FED_HOUS_CDE_4) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

FEDERAL_HOUSING4_DESC

 
DECODE(RCRESAR_FED_HOUS_CDE_5) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

FEDERAL_HOUSING5_DESC

 
DECODE(RCRESAR_FED_HOUS_CDE_6) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

FEDERAL_HOUSING6_DESC

 
DECODE(RCRESAR_M_SCHOOL_FLAG_1) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

MULTI_SCHOOL_FLAG1_DESC

 
DECODE(RCRESAR_M_SCHOOL_FLAG_2) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

MULTI_SCHOOL_FLAG2_DESC

 
DECODE(RCRESAR_M_SCHOOL_FLAG_3) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

MULTI_SCHOOL_FLAG3_DESC

 
DECODE(RCRESAR_M_SCHOOL_FLAG_4) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

MULTI_SCHOOL_FLAG4_DESC

 
DECODE(RCRESAR_M_SCHOOL_FLAG_5) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

MULTI_SCHOOL_FLAG5_DESC

 
DECODE(RCRESAR_M_SCHOOL_FLAG_6) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

MULTI_SCHOOL_FLAG6_DESC

 
DECODE(RCRESAR_REC_TYPE) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

PROCESSED_RECORD_TYPE_DESC

 
DECODE(RCRESAR_SEC_EFC_TYPE) NA

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

SECONDARY_EFC_TYPE_DESC

 
DECODE(RCRESAR_SUB_APP) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

SUBSEQUENT_APPLICATION_IND

 
DECODE(RCRIMP1_AID_STATUS) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

FINANCIAL_AID_STATUS_DESC

 
DECODE(RCRIMP1_APPLIC_TYPE) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_PROFILE_SPECIFIC

NEED_ANALYSIS_DEMOGRAPHIC

APPLICATION_TYPE_DESC

APPLICATION_TYPE_DESC

 
DECODE(RCRIMP1_FIN_AID_STATUS) RNASUXX        
DECODE(RCRIMP1_FOREIGN_ADDR_IND) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS_PROFILE_SPECIFIC

FOREIGN_ADDRESS_IND

FOREIGN_ADDRESS_IND

 
DECODE(RCRIMP1_HOUS_CDE_10) RNASUXX        
DECODE(RCRIMP1_HOUS_CDE_9) RNASUXX        
DECODE(RCRIMP1_LINE2_SCHL_TYPE) RNASUXX        
DECODE(RCRIMP1_LINE3_SCHL_TYPE) RNASUXX        
DECODE(RCRIMP1_LINE4_SCHL_TYPE) RNASUXX        
DECODE(RCRIMP1_LINE5_SCHL_TYPE) RNASUXX        
DECODE(RCRIMP1_LINE6_SCHL_TYPE) RNASUXX        
DECODE(RCRIMP1_LINE7_SCHL_TYPE) RNASUXX        
DECODE(RCRIMP1_LINE8_SCHL_TYPE) RNASUXX        
DECODE(RCRIMP1_LOCATION_COMPUTER) RNASUXX        
DECODE(RCRIMP1_ONLINE_SIG) RNASUXX

REPORTING VIEW

NEED_ANALYSIS_PROFILE_SPECIFIC

ONLINE_SIGNATURE_IND

 
DECODE(RCRIMP1_OWN_BUS_HM_SELF_EMP) RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_PROFILE_SPECIFIC

IM_SELF_EMPLOYED_IND

 
DECODE(RCRIMP1_PAR_NTRL_SEP_DIV) RNASUXX        
DECODE(RCRIMP1_PAR_OWN_BUS_FARM) RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_PROFILE_SPECIFIC

PARENT_OWN_BUSINESS_IND

 
DECODE(RCRIMP1_PAR_SELF_EMPLOYED) RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_PROFILE_SPECIFIC

IM_PARENT_SELF_EMPLOYED_IND

 
DECODE(RCRIMP1_PAR_SMALL_BUSINESS) RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_PROFILE_SPECIFIC

IM_PARENT_LARGE_BUSINESS_IND

 
DECODE(RCRIMP1_SMALL_BUSINESS) RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_PROFILE_SPECIFIC

IM_LARGE_BUSINESS_IND

 
DECODE(RCRIMP1_STU_MOST_SUPPORT_FROM) RNASUXX        
DECODE(RCRIMP1_TRUST_AVAIL_IND) RNAPRXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS_PROFILE_SPECIFIC

TRUST_AVAILABILITY_IND

 
DECODE(RCRIMP1_TRUST_ESTAB_BY) RNAPRXX        
DECODE(RNROVRD_ADD_BK_HOPE_OPT) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_ADD_HOPE_LL_IND

 
DECODE(RNROVRD_ALLOW_IM_PC_LOWR_FM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_LOWER_THAN_FM_IND

 
DECODE(RNROVRD_ALLOW_IM_SC_LOWR_FM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_LOWER_THAN_FM_IND

 
DECODE(RNROVRD_CALC_US_TAX_FM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_STUD_CALC_FED_TAX_OVR_IND

 
DECODE(RNROVRD_CALC_US_TAX_IM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_CALC_FEDERAL_TAX_OVR_DESC

 
DECODE(RNROVRD_CHG_DEPEND_FM) NA

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_CHANGE_DEPENDENCY_STAT_DESC

 
DECODE(RNROVRD_CHG_DEPEND_IM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_CHANGE_DEPENDENCY_STAT_DESC

 
DECODE(RNROVRD_FAMILY_ASSETS) NA

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_ASSET_COMBINED_DESC

 
DECODE(RNROVRD_FM_PAR_NUM_COL) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_PARENT_NO_COLLEGE_OVR_IND

 
DECODE(RNROVRD_F_SSN_NO_DOB_REJ_OVRD) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_REJECT_S_IND

 
DECODE(RNROVRD_F_SSN_NO_NAME_REJ_OVRD) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_REJECT_E_IND

 
DECODE(RNROVRD_HOME_VAL_PROJ) NA

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_HOME_VALUE_PROJ_DESC

 
DECODE(RNROVRD_INV_PROJ) NA

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_IMPUTE_ASSET_DESC

 
DECODE(RNROVRD_LIMIT_PC_BY_BDGT) NA

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

LIMIT_OTHERS_SHARE_PC_DESC

 
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_REJECT_T_IND

 
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD_ RNAOVXX        
DECODE(RNROVRD_M_SSN_NO_NAME_REJ_OVRD) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_REJECT_F_IND

 
DECODE(RNROVRD_NON_CUST_OPT) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_NONCUS_CONT_CAL_DESC

 
DECODE(RNROVRD_NON_CUST_PC_OPT) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_USE_NONCUSTODIAL_PC_IND

 
DECODE(RNROVRD_PAR_ADD_BK_HOPE_OPT) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_ADD_HOPE_LL_IND

 
DECODE(RNROVRD_PAR_AGI_OPT) NA

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_WHICH_AGI_DESC

 
DECODE(RNROVRD_PAR_CALC_US_TAX_FM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_PARENT_CALC_FED_TAX_OVR_IND

 
DECODE(RNROVRD_PAR_CALC_US_TAX_IM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_CALC_FED_TAX_OV_DESC

 
DECODE(RNROVRD_PAR_USE_PROJ_INC_EFM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_EFM_EST_INCOME_IND

 
DECODE(RNROVRD_SKIP_AGE_EXCL) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_SKIP_AGE_EXCLUSION_IND

 
DECODE(RNROVRD_SSN_NO_DOB_REJ_OVRD) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_REJECT_R_IND

 
DECODE(RNROVRD_SSN_NO_NAME_REJ_OVRD) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

FM_REJECT_D_IND

 
DECODE(RNROVRD_S_HOME_VAL_PROJ) NA

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_HOME_VALUE_PROJECT_DESC

 
DECODE(RNROVRD_USE_PROJ_INC_EFM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_EFM_ESTIMATED_INCOME_IND

 
DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

USE_PARENT_STATE_PROV_TAX_IND

 
DECODE(RNROVRD_ZERO_LOSS_BUS_FARM) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_ZERO_LOSS_BUS_IND

 
DECODE(RNROVRD_ZERO_LOSS_OTH) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_ZERO_LOSS_OTH_IND

 
DECODE(ROW_NUMBER() OVER (PARTITION BY A.PERSON_UID ORDER BY DATE_INITIATED ASC),1,1,0) TBD        
DECODE(RPRADSB_ALTERNATE_PELL_IND,'N') ROAPELL

REPORTING VIEW

AWARD_DISBURSEMENT

ALTERNATE_PELL_PAY_SCHED_IND

 
DECODE(RPRADSB_CONCUR_ENROLL_FLAG) NA

REPORTING VIEW

AWARD_DISBURSEMENT

COD_CONCURRENT_ENROLLMENT_IND

 
DECODE(RPRADSB_DEBIT_CREDIT_IND) RPRADSB

REPORTING VIEW

AWARD_DISBURSEMENT

DEBIT_CREDIT_DESC

 
DECODE(RPRADSB_DISBURSE_LOAD) RPAAWRD

REPORTING VIEW

AWARD_DISBURSEMENT

DISBURSEMENT_LOAD_DESC

 
DECODE(RPRADSB_DISBURSE_LOAD_OPT) RPRADSB

REPORTING VIEW

AWARD_DISBURSEMENT

DISBURSEMENT_LOAD_OPT_DESC

 
DECODE(RPRADSB_DISB_ACPT_DEBIT_CR_IND) RPRADSB

REPORTING VIEW

AWARD_DISBURSEMENT

COD_DEBIT_CREDIT_DESC

 
DECODE(RPRADSB_DISB_ACTION_CODE) RPRADSB

REPORTING VIEW

AWARD_DISBURSEMENT

COD_DISBURSEMENT_ACTION_DESC

 
DECODE(RPRADSB_PELLC_DISB_LOAD) RPAAWRD

REPORTING VIEW

AWARD_DISBURSEMENT

PELL_CALCULATED_DISB_LOAD_DESC

 
DECODE(RPRADSB_PELLC_DISB_LOAD_OPT) RPRADSB

REPORTING VIEW

AWARD_DISBURSEMENT

PELL_CALC_DISB_LOAD_OPT_DESC

 
DECODE(RPRADSB_POTENTIAL_OVERPMT_FLAG) NA

REPORTING VIEW

AWARD_DISBURSEMENT

COD_POTENTIAL_OVERPAYMENT_IND

 
DECODE(RPRADSB_SHARED_SAR_ID_FLAG) NA

REPORTING VIEW

AWARD_DISBURSEMENT

COD_SHARED_SAR_IDENTIFIER_IND

 
DECODE(RPRARSC_TYPE_CODE) RPAARSC

REPORTING VIEW

APPLICANT_RESOURCE

RESOURCE_TYPE_DESC

 
DECODE(RPRATRM_LOCK_IND) NA

REPORTING VIEW

AWARD_BY_PERSON

AWARD_LOCKED_DESC

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

REPORTING VIEW

AWARD_BY_PERSON

ANNUAL_AWARD_LOCKED_DESC

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

REPORTING VIEW

AWARD_BY_PERSON

SYSTEM_DESC

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

REPORTING VIEW

LOAN_DISBURSEMENT

ENROLLMENT_LOAD_DESC

 
DECODE(RPRLADB_DISBURSE_LOAD_OPT) RPALDSB        
DECODE(RPRLADB_DISB_STATUS) RPALORG        
DECODE(RPRLADB_FEED_IND) NA

REPORTING VIEW

LOAN_DISBURSEMENT

DISBURSEMENT_FEED_DESC

 
DECODE(RPRLADB_HOLD_REL_STATUS) RPAELAP

REPORTING VIEW

LOAN_DISBURSEMENT

HOLD_RELEASE_STATUS_DESC

 
DECODE(RPRLADB_SERV_TRANS_TYPE) NA

REPORTING VIEW

LOAN_DISBURSEMENT

TRANSACTION_TYPE_DESC

 
DECODE(RPRLAPP_COSIGN1_RELATION_IND) NA

REPORTING VIEW

LOAN_APPLICATION

COSIGN1_RELATIONSHIP_DESC

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

REPORTING VIEW

LOAN_APPLICATION

COSIGN2_RELATIONSHIP_DESC

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

REPORTING VIEW

DESIGNATION_FINAID_FUND

FUND_SOURCE_TYPE_DESC

NA
DECODE(RTVFTYP_ATYP_IND) NA

REPORTING VIEW

AWARD_BY_FUND

AWARD_BY_FUND

AWARD_BY_PERSON

FINAID_FUND

AWARD_BY_PERSON

FINAID_FUND

FINAID_FUND

GIFT_OR_SELF_HELP_AID

GIFT_OR_SELF_HELP_AID_DESC

GIFT_OR_SELF_HELP_AID

FINANCIAL_AID_TYPE_DESC

GIFT_OR_SELF_HELP_AID_DESC

GIFT_OR_SELF_HELP_AID

GIFT_OR_SELF_HELP_AID_DESC

NA
DECODE(RTVFTYP_IND) NA

REPORTING VIEW

DESIGNATION_FINAID_FUND

FINANCIAL_AID_TYPE_DESC

 
DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME') SAAADMS

REPORTING VIEW

GOVERNMENT_STUDENT

GOVERNMENT_ADMISSIONS

INTENDED_TIME_STATUS_DESC

INTENDED_TIME_STATUS_DESC

NA
DECODE(SFBETRM_AR_IND) TBD

REPORTING VIEW

STUDENT

ENROLLMENT

AR_CHARGES_ACCEPT_IND_DESC

AR_CHARGES_ACCEPT_IND_DESC

 
DECODE(SFBETRM_MAXH_SRCE_CDE) TBD

REPORTING VIEW

ENROLLMENT

MAXIMUM_REQUIRED_SOURCE_DESC

 
DECODE(SFBETRM_MINH_SRCE_CDE) TBD

REPORTING VIEW

ENROLLMENT

MINIMUM_REQUIRED_SOURCE_DESC

 
DECODE(SFBETRM_PIDM, NULL, 'N', 'Y') NA

REPORTING VIEW

ACADEMIC_STUDY

ENROLLMENT

VETERAN_CERTIFICATION

STUDENT_EXTENDED

STUDENT

ACADEMIC_STUDY_EXTENDED

ENROLLMENT_EXISTS_IND

ENROLLMENT_EXISTS_IND

ENROLLMENT_EXISTS_IND

ENROLLMENT_EXISTS_IND

ENROLLMENT_EXISTS_IND

ENROLLMENT_EXISTS_IND

 
DECODE(SFRPLAN_COMMENT) NA

REPORTING VIEW

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN

PLAN_COMMENT_EXISTS_IND

PLAN_COMMENT_EXISTS_IND

 
DECODE(SFRPLAN_SRC_CDE) NA

REPORTING VIEW

REGISTRATION_PLAN_COURSE

PLAN_COURSE_SOURCE_DESC

 
DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y') SFASLST

REPORTING VIEW

STUDENT_COURSE

FINAL_GRADE_ROLL_IND

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

REPORTING VIEW

STUDENT_COURSE

IN_PROGRESS_COURSE_IND

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

REPORTING VIEW

STUDENT_COURSE

INSTITUTION_COURSE_IND

This function returns an N if the registration record SFRSTCR does not exist for the specified UID, academic period and course else it returns a Y.
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1)+DECODE(SGBSTDN_LEVL_CODE_2,NULL,0, DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1)) SGASTDN

REPORTING VIEW

STUDENT

STUDENT_EXTENDED

ACADEMIC_STUDY_MATRIC_IN_COUNT

ACADEMIC_STUDY_MATRIC_IN_COUNT

This function returns a 0, 1, or 2 based on the matriculated academic period SGBSTDN_TERM_CODE_MATRIC and the secondary level code SGBSTDN_LEVL_CODE_2. If the matriculated academic period is null and the secondary level code is null then this will return a 0. If the matriculated academic period is null and the secondary level code is not null then this will return a 0. If the matriculated academic period is not null and the secondary level code is null then it will return a 1. If both values are not null then it will return a 2.
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,N, Y) SGASTDN       DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,N,Y)
DECODE(SHRATTR_PIDM, NULL, 'N', 'Y') NA

REPORTING VIEW

STUDENT_COURSE_ATTRIBUTE

INSTITUTION_COURSE_IND

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

REPORTING VIEW

GPA_BY_LEVEL

GPA

GPA_TYPE_DESC

GPA_TYPE_DESC

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

REPORTING VIEW

STUDENT_COURSE_ATTRIBUTE

TRANSFER_COURSE_IND

NA
DECODE(SHRTATT_PIDM, NULL, 'Y', 'N') NA       NA
DECODE(SHRTGPA_GPA_TYPE_IND,'I', 'INSTITUTION','T','TRANSFER') NA

REPORTING VIEW

GPA

GPA_BY_TERM

GPA_TYPE_DESC

GPA_TYPE_DESC

This function returns Institution if the gpa type indicator SHRLGPA_GPA_TYPE_IND is I, else it returns Transfer if the gpa type indicator is a T.
DECODE(SHRTRCE_PIDM,NULL,'N','Y') SHATRNS

REPORTING VIEW

STUDENT_COURSE

TRANSFER_COURSE_IND

This function returns a N if the transfer course record SHRTRCE doesn't exist, else a Y.
DECODE(SHRTRCR_ART_IND,NULL,'NO ARTICULATION RULE','N','COURSE HAS NO INSTITUTION EQUIVALENT','Y','COURSE HAS INSTITUTION EQUIVALENT') TBD

REPORTING VIEW

STUDENT_TRANSFERRED_COURSE

TRANS_ARTICULATION_RULE_DESC

 
DECODE(SHRTTRM_RECORD_STATUS_IND) NA

REPORTING VIEW

STUDENT_EXTENDED

STUDENT

GRADE_MAILER_STATUS_DESC

GRADE_MAILER_STATUS_DESC

 
DECODE(SIBFACD_PRIMARY_ACTIVITY) NA

REPORTING VIEW

FACULTY

PRIMARY_ACTIVITY_DESC

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

REPORTING VIEW

ROOM_ASSIGNMENT

ROOM_TYPE_DESC

This function returns DORM if the room type SLBRDEF_ROOM_TYPE is D, CLASS if the room type is C else OTHER.
DECODE(SORAPPT_INTV_PIDM,NULL,NULL, F_FORMAT_NAME(SORAPPT_INTV_PIDM,'LFMI')) SOAAPPT

REPORTING VIEW

CONTACT

INTERVIEWER_NAME

This function returns null if the pidm is null SORAPPT_INTV_PIDM else it returns the formatted name of the interviewer.
DECODE(SORBACD_STATE_APPROV_IND) NA

REPORTING VIEW

INSTITUTION_DEMOGRAPHIC

APPROVED_IND

DECODE(SORBACD_STATE_APPROV_IND,'Y','Y','N')
DECODE(SORDEGR_SBGI_CODE) NA

REPORTING VIEW

COMBINED_ACADEMIC_OUTCOME

TRANSFER_WORK_EXISTS_IND

 
DECODE(SORLCUR_SITE_CODE) NA

REPORTING VIEW

GOVERNMENT_STUDENT

SITE

DECODE(SORLCUR_SITE_CODE,NULL,SGBSTDN_SITE_CODE,SORLCUR_SITE_CODE)
DECODE(SORLCUR_TERM_CODE_ADMIT) NA

REPORTING VIEW

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

NEW_STUDENT_IND

NEW_STUDENT_IND

NA
DECODE(SORLCUR_TERM_CODE_MATRIC) SGASTDN

REPORTING VIEW

ACADEMIC_STUDY_EXTENDED

ACADEMIC_STUDY

MATRICULATED_IND

MATRICULATED_IND

DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,'N','Y')
DECODE(SPBPERS_NAME_PREFIX,NULL,DECODE( SPBPERS_SEX,'M','MR.','F','MS.'), SPBPERS_NAME_PREFIX) NA

REPORTING VIEW

CONSTITUENT

NAME_PREFIX

This function returns Mr. or Ms. Based on the gender if the name prefix SPBPERS_NAME_PREFIX is null, else it returns the name prefix.
DECODE(SPBPERS_SEX,'M','MALE','F', 'FEMALE','N','NOT REPORTED') SPAPERS

REPORTING VIEW

PERSON_DETAIL

GOVERNMENT_ACADEMIC_OUTCOME

PERSON

GOVERNMENT_STUDENT

GOVERNMENT_FINANCIAL_AID

PERSON_SENSITIVE

GOVERNMENT_ADMISSIONS

GENDER_DESC

GENDER_DESC

GENDER_DESC

GENDER_DESC

GENDER_DESC

GENDER_DESC

GENDER_DESC

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

REPORTING VIEW

PERSON

VETERAN_CATEGORY_DESC

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

REPORTING VIEW

PERSON_VETERAN

VETERAN_CATEGORY_DESC

NA
DECODE(SPBPERS_VERA_IND,NULL,NULL, 'VETERAN') SPAPERS

REPORTING VIEW

PERSON_DETAIL

VETERAN_CATEGORY_DESC

This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran.
DECODE(SPRIDEN_ID,NULL,NULL,'BANNER') NA

REPORTING VIEW

PERSON_DETAIL

PERSON

ID_SOURCE

ID_SOURCE

This function returns null if the id SPRIDEN_ID is null else it returns BANNER.
DECODE(SPRMEDI_DISB_IND,'Y','Y','N') SPAMEDI       NA
DECODE(SSRFEES_FEE_IND) SSADETL

REPORTING VIEW

COURSE_OFFERING_FEES

FEE_METHOD_DESC

 
DECODE(STVAPDC_APPL_INACT) NA

REPORTING VIEW

ADMISSIONS_DECISION

GOVERNMENT_ADMISSIONS

APPLICATION_INACTIVE_IND

APPLICATION_INACTIVE_IND

DECODE (stvapdc_appl_inact, NULL, 'N', stvapdc_appl_inact)
DECODE(STVAPDC_INST_ACC_IND) NA

REPORTING VIEW

ADMISSIONS_DECISION

GOVERNMENT_ADMISSIONS

INSTITUTION_ADMIT_IND

INSTITUTION_ADMIT_IND

DECODE (stvapdc_inst_acc_ind, NULL, 'N', stvapdc_inst_acc_ind)
DECODE(STVAPDC_REJECT_IND) NA

REPORTING VIEW

ADMISSIONS_DECISION

GOVERNMENT_ADMISSIONS

INSTITUTION_DENIED_IND

INSTITUTION_DENIED_IND

DECODE (stvapdc_reject_ind, NULL, 'N', stvapdc_reject_ind)
DECODE(STVAPDC_SIGNF_IND) NA

REPORTING VIEW

ADMISSIONS_DECISION

GOVERNMENT_ADMISSIONS

APPLICATION_SIGNIF_IND

APPLICATION_SIGNIF_IND

DECODE (stvapdc_signf_ind, NULL, 'N', stvapdc_signf_ind)
DECODE(STVAPDC_STDN_ACC_IND) NA

REPORTING VIEW

ADMISSIONS_DECISION

GOVERNMENT_ADMISSIONS

APPLICANT_ACCEPT_IND

APPLICANT_ACCEPT_IND

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

REPORTING VIEW

ACADEMIC_HISTORY_EVENT

TRANSCRIPT_IND

 
DECODE(STVRESD_IN_STATE_IND) NA

REPORTING VIEW

STUDENT_EXTENDED

RESIDENCY_IND

 
DECODE(STVRRCD_MONTHLY_IND,'Y', 'MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y', 'DAILY','TERMLY')) SLARASG

REPORTING VIEW

ROOM_ASSIGNMENT

ROOM_RATE_TIME

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

REPORTING VIEW

FINAID_TRACKING_REQUIREMENT

INSTITUTION

RECRUITMENT_SOURCE

ADMISSIONS_SOURCE

INSTITUTION_TYPE_DESC

INSTITUTION_TYPE_DESC

RECRUIT_SOURCE_TYPE_DESC

ADMISSIONS_SOURCE_TYPE_DESC

This function returns COLLEGE when the institution type STVSBGI_TYPE_IND is C, HIGHSCHOOL if the institution type is an H, SOURCE-ONLY if the institution type is S else null.
DECODE(TBBACCT_REFUND_IND) NA

REPORTING VIEW

RECEIVABLE_ACCOUNT

REFUND_IND_DESC

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

REPORTING VIEW

CONTRACT

STUDENT_INACTIVATED_IND

NA
DECODE(TBBESTU_DEL_IND) TSAEXPP

REPORTING VIEW

EXEMPTION

EXEMPTION_CANCELLED_IND

NA
DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y') TSADETC

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

RETURNED_CHECK_IND

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

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

BILL_AMOUNT

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

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

ACCOUNT_POSTED_AMOUNT

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

REPORTING VIEW

DEPOSIT

ACCOUNT_POSTED_AMOUNT

This function returns null if the feed date TBRDEPO_FEED_DATE is null else it returns the transaction amount TBRDEPO_AMOUNT.
DECODE(TBRMISD_PIDM) TFAMISC

REPORTING VIEW

MISCELLANEOUS_TRANSACTION

EXTERNAL_IND

This function determines if the entity is external to the system.
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y') NA

REPORTING VIEW

CONSTITUENT_PLAN

PROSPECT_MOVES_MANAGEMENT

MOVE_COMPLETION_IND

PLANNED_MOVE_COMPLETE_IND

NA
DECODE(TRANSACTION_HISTORY.FUND_POOL, NULL,FUND_HIERARCHY.FUND_POOL_DESC, TRANSACTION_HISTORY.FUND_POOL_DESC) NA

REPORTING VIEW

TRANSACTION_HISTORY

FUND_POOL_DESC

Population of fund pool description is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
EARN NA

REPORTING VIEW

PERSONNEL_ACTION_EARNING

PAF_TRANSACTION_TYPE

 
FFRMASA_AMT+FFRMASA_ADJ_AMT- FFRMASA_DEPR_ACCUM_AMT FFAMAST

REPORTING VIEW

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_HISTORY

BOOK_VALUE

BOOK_VALUE

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

REPORTING VIEW

GENERAL_LEDGER

CURRENT_ACTUAL

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

REPORTING VIEW

OPERATING_LEDGER

CURR_ACCUMULATED_BUDGET

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

REPORTING VIEW

OPERATING_LEDGER

CURR_ADOPTED_BUDGET

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

REPORTING VIEW

OPERATING_LEDGER

CURR_BUDGET_ADJUSTMENTS

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

REPORTING VIEW

OPERATING_LEDGER

CURR_BUDGET_RESERVATION

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

REPORTING VIEW

OPERATING_LEDGER

CURR_ENCUMBRANCES

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

REPORTING VIEW

OPERATING_LEDGER

CURR_TEMPORARY_BUDGET

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

REPORTING VIEW

OPERATING_LEDGER

CURR_YEAR_TO_DATE_ACTIVITY

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

REPORTING VIEW

GRANT_LEDGER

CURR_ACCOUNTED_BUDGET

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

REPORTING VIEW

GRANT_LEDGER

CURR_ADOPTED_BUDGET

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

REPORTING VIEW

GRANT_LEDGER

CURR_BUDGET_ADJUSTMENTS

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

REPORTING VIEW

GRANT_LEDGER

CURR_BUDGET_RESERVATIONS

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

REPORTING VIEW

GRANT_LEDGER

CURR_ENCUMBRANCES

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

REPORTING VIEW

GRANT_LEDGER

CURR_TEMPORARY_BUDGET

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

REPORTING VIEW

GRANT_LEDGER

CURR_YEAR_TO_DATE_ACTIVITY

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

REPORTING VIEW

GRANT_LEDGER

CURR_MEMO_COSTS

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

REPORTING VIEW

GRANT_EVENT

GRANT_EVENT_FULL_DESC

 
FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC NA

REPORTING VIEW

GRANT_EVENT_STATUS

GRANT_EVENT_FULL_DESC

 
FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||F TVSHIP_PHONE_EXT NA

REPORTING VIEW

PURCHASE_ORDER_ITEM

PURCHASE_ORDER

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

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

REPORTING VIEW

VENDOR

PHONE_NUMBER_COMBINED

This calculation formulates the combined phone number by concatenating FTVVEND_PHONE_AREA, FTVVEND_PHONE_NUMBER, and FTVVEND_PHONE_EXT.
FUNCTION TBD        
F_GET_NORM_BALANCE NA

REPORTING VIEW

GRANT_DEFERRED_COST

ORIG_CALC_TRANSACTION_AMOUNT

 
IF AGBMGID_AMT_PAID > = AGBMGID_AMT THEN Y, ELSE N NA

REPORTING VIEW

GIFT_MATCHING_TRANSACTION

MATCH_GIFT_FULLY_PAID_IND

NA
IF AGBMGID_AMT_PAID IS > 0 AND < AGBMGID_AMT THEN Y, ELSE N NA

REPORTING VIEW

GIFT_MATCHING_TRANSACTION

MATCH_GIFT_PARTIAL_PAID_IND

NA
INSTRUCTOR_KEY * 1000000 + ACADEMIC_TIME_KEY * 100 + MULTI_SOURCE_KEY TBD        
LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+ RCRAPP2_C_PAR_1_CTRB_FOR_STDT) NA

REPORTING VIEW

NEED_ANALYSIS

INAS_TFC

LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)
LEVEL FTMFUND

REPORTING VIEW

ACCOUNT_HIERARCHY_FISCAL

FUND_HIERARCHY_FISCAL

PROGRAM_HIERARCHY_FISCAL

FUND_HIERARCHY

ACCOUNT_HIERARCHY

FUND_HIERARCHY_FISCAL

ACCOUNT_HIERARCHY_FISCAL

LOCATION_HIERARCHY_FISCAL

ORGANIZATION_HIERARCHY_FISCAL

ACCOUNT_HIERARCHY

FUND_HIERARCHY

PROGRAM_HIERARCHY

LOCATION_HIERARCHY

ORGANIZATION_HIERARCHY

ACCOUNT_LEVEL

FUND_LEVEL

PROGRAM_LEVEL

FUND_TYPE_LEVEL

ACCOUNT_TYPE_LEVEL

FUND_TYPE_LEVEL

ACCOUNT_TYPE_LEVEL

LOCATION_LEVEL

ORGANIZATION_LEVEL

ACCOUNT_LEVEL

FUND_LEVEL

PROGRAM_LEVEL

LOCATION_LEVEL

ORGANIZATION_LEVEL

This value is retrieved upon formulation of the validation table hierarchy and pertains to what level this code associates to within its hierarchy. (Level 1 being the highest level.)
MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS - MAKFUNC.F_CAMP_EXPENSES NA

REPORTING VIEW

CAMPAIGN

CAMPAIGN_VALUE

 
MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS NA

REPORTING VIEW

CAMPAIGN

CAMPAIGN_PLEDGE_BALANCE

 
MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES - MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS NA

REPORTING VIEW

CAMPAIGN_DESIGNATION

CAMP_DESG_PLEDGE_BALANCE

 
MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100 NA

REPORTING VIEW

SOLICITOR_ORGANIZATION

PCT_PROGRESS_DONOR_COUNT_GOAL

 
MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS NA

REPORTING VIEW

SOLICITOR_ORGANIZATION

ORGANIZATION_PLEDGE_BALANCE

 
MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS NA

REPORTING VIEW

CAMPAIGN_SOLICITATION

SOLICITATION_PLEDGE_BALANCE

 
MAKFUNC.F_SOL_FR_TOTAL_PLEDGES - MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS NA

REPORTING VIEW

SOLICITOR_ORG_FUNDRAISER

SOLICITOR_PLEDGE_BALANCE

 
MAX(APRACYR_YEAR) NA

REPORTING VIEW

SPECIAL_ACTIVITY_SLOT

SPECIAL_ACTIVITY_SLOT

SPECIAL_ACTIVITY

SPECIAL_ACTIVITY_SLOT

LAST_YEAR2

LAST_YEAR3

LAST_YEAR

LAST_YEAR1

NA
MEKFUNC.F_AUTHORIZED_TOTAL ( R.PORTFOLIO_KEY, '%', 'Y') + MEKFUNC.F_TOTAL_NOT_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y') TBD

REPORTING VIEW

REIMBURSEMENT

PAY_AMOUNT_NOT_SUBMITTED

 
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y') TBD

REPORTING VIEW

REIMBURSEMENT

PAY_AMOUNT_SUBMITTED

 
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '9900ADVC', '%','Y') TBD

REPORTING VIEW

REIMBURSEMENT

ADVANCE_CLEARED

 
MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE FNIEBAL

REPORTING VIEW

ENDOWMENT_SUMMARIZED_UNITS

MARKET_VALUE

NA
MIN(APRACYR_YEAR) NA

REPORTING VIEW

SPECIAL_ACTIVITY

FIRST_YEAR

NA
MONTHS_BETWEEN NA       NA
MONTHS_BETWEEN(NVL(APREHIS_TO_DATE, SYSDATE),APREHIS_FROM_DATE) NA

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

CURRENT_EMPLOYMENT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

YEARS_MONTHS_IN_POSITION4

MONTHS_IN_POSITION

YEARS_MONTHS_IN_POSITION3

YEARS_MONTHS_IN_POSITION1

YEARS_MONTHS_IN_POSITION2

NA
MONTHS_BETWEEN(NVL(PPREXPE_END_DATE, SYSDATE),PPREXPE_START_DATE) NA

REPORTING VIEW

EMPLOYMENT_HISTORY

MONTHS_IN_POSITION

 
MONTHS_BETWEEN(PPREXPE_END_DATE, PPREXPE_START_DATE) NA

REPORTING VIEW

CURRENT_EMPLOYMENT

MONTHS_IN_POSITION

NA
NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND NBAPBUD

REPORTING VIEW

POSITION_BUDGET

AMOUNT_REMAINING

This function calculates the result of the budget minus the encumbrance and minus the expenditures. NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND.
NVL(ADBDESG_WEB_GIFT_IND,'N') NA

REPORTING VIEW

DESIGNATION

ALLOW_WEB_GIFT_IND

 
NVL(ADBDESG_WEB_PLDG_IND,'N') NA

REPORTING VIEW

DESIGNATION

ALLOW_WEB_PLEGE_IND

 
NVL(ADRCONF_CONFID_IND) NA

REPORTING VIEW

DESIGNATION_COMMENT

COMMENT_CONFIDENTIALITY_IND

 
NVL(AFBCAMP_ASSOC_IND,'N') NA

REPORTING VIEW

CAMPAIGN

COUNT_IN_GIVING_IND

 
NVL(AFRCSOL_GOAL,0) NA

REPORTING VIEW

CAMPAIGN_SOLICITATION

CAMPAIGN_SOLICITATION_GOAL

 
NVL(AFRDESG_GOAL,0) NA

REPORTING VIEW

CAMPAIGN_DESIGNATION

CAMPAIGN_DESIGNATION_GOAL

 
NVL(AGBPLDG_MATCH_FORM_IND) NA

REPORTING VIEW

PLEDGE_TRANSACTION

PLEDGE

MATCHING_GIFT_FORM_IND

MATCHING_GIFT_FORM_IND

 
NVL(AGBPLDG_MATCH_PROCESSED) NA

REPORTING VIEW

PLEDGE

PLEDGE_TRANSACTION

MATCH_GIFT_FORM_PROCESSED_IND

MATCH_GIFT_FORM_PROCESSED_IND

 
NVL(AGBPLDG_MGFORM_READYTOSEND) NA

REPORTING VIEW

PLEDGE

PLEDGE_TRANSACTION

MATCHGIFT_FORM_READYTOSEND_IND

MATCHGIFT_FORM_READYTOSEND_IND

 
NVL(AGBPLDG_PACK_IND,'N'), NA       NA
NVL(AGBPLDG_RECEIPT_IND,'N'), NA       NA
NVL(AGRGAUX_DEDUCT_FOR_TAXES,'N') NA

REPORTING VIEW

GIFT_AUXILIARY

DEDUCT_FOR_TAXES_IND

NA
NVL(AMBPLAN_END_DATE,'31-DEC-2099') NA

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

CONSTITUENT_CONTACT

STRATEGY_PLAN_END_DATE

STRATEGY_PLAN_END_DATE

 
NVL(AMRCONF_CONFID_IND) NA

REPORTING VIEW

PROSPECT_CONFIDENTIAL_COMMENT

COMMENT_CONFIDENTIALITY_IND

 
NVL(AMRCONT_CONFID_IND) NA

REPORTING VIEW

CONSTITUENT_CONTACT

TICKLER_CONFIDENTIAL_IND

 
NVL(AMRINFO_WEB_GIFT_IND,'N') NA

REPORTING VIEW

PROSPECT_INFO

ALLOW_WEB_GIFT_IND

 
NVL(AMRINFO_WEB_PLDG_IND,'N') NA

REPORTING VIEW

PROSPECT_INFO

ALLOW_WEB_PLEDGE_IND

 
NVL(AMRSTAF_END_DATE,'31-DEC-2099') NA

REPORTING VIEW

PROSPECT_STAFF_ASSIGNMENT

STAFF_ASSIGNMENT_END_DATE

 
NVL(AMRSTAF_SOLICIT_IND,'N') NA

REPORTING VIEW

PROSPECT_INFO

SOLICITOR_IND

 
NVL(APRCONF_CONFID_IND) NA

REPORTING VIEW

CONSTITUENT_CONF_COMMENT

COMMENT_CONFIDENTIALITY_IND

 
NVL(APRCONF_DISP_NOTES_IND) NA

REPORTING VIEW

CONSTITUENT_CONF_COMMENT

DISPLAYED_IN_NOTE_IND

 
NVL(APRCONF_OK_FOR_NOTES_IND) NA

REPORTING VIEW

CONSTITUENT_CONF_COMMENT

OK_FOR_NOTE_IND

 
NVL(APRCONF_REVIEWED_IND) NA

REPORTING VIEW

CONSTITUENT_CONF_COMMENT

WEB_REVIEWED_IND

 
NVL(ASBSORG_DOLLAR_GOAL,) NA        
NVL(ASBSORG_DOLLAR_GOAL,0) NA

REPORTING VIEW

SOLICITOR_ORGANIZATION

ORGANIZATION_GOAL

 
NVL(ASBSORG_DONOR_COUNT_GOAL,) NA        
NVL(ASBSORG_DONOR_COUNT_GOAL,0) NA

REPORTING VIEW

SOLICITOR_ORGANIZATION

ORGANIZATION_DONOR_COUNT_GOAL

 
NVL(ASBSORG_UPD_WEB_IND) NA        
NVL(ASRSORG_UPD_WEB_IND) NA

REPORTING VIEW

SOLICITOR_ORG_FUNDRAISER

ALLOW_WEB_UPDATE_SOLICITOR_IND

 
NVL(ATVCMPT_CAPITAL_IND,'N') NA

REPORTING VIEW

CAMPAIGN

CAPITAL_CAMPAIGN_IND

 
NVL(ATVEMPS_ACTIVE_IND,'N') ATVEMPS       NA
NVL(AXBMGID_MGFORM_READYTOSEND) NA

REPORTING VIEW

PLEDGE_MATCHING

PLEDGE_MATCHING_TRANSACTION

MATCH_FORM_SENT_IND

MATCH_FORM_SENT_IND

 
NVL(CURR_ADOPTED_BUDGET + CURR_BUDGET_ADJUSTMENTS, 0) NA

REPORTING VIEW

BUDGET_AVAILABILITY_LEDGER

CURR_TOTAL_BUDGET

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

REPORTING VIEW

BUDGET_AVAILABILITY_LEDGER

CURR_COMMITTED_BALANCE

Calculates the current commited balance as current year to date activity + current encumbrances + current budget reservations (requisistions).
NVL(FABINVH_ACH_OVERRIDE_IND,'N') NA

REPORTING VIEW

INVOICE

DIRECT_DEPOSIT_OVERRIDE_IND

 
NVL(FABINVH_DISB_AGENT_IND,'N') NA

REPORTING VIEW

INVOICE

DISBURSING_AGENT_IND

 
NVL(FABINVH_EDIT_DEFER_IND,'N') NA

REPORTING VIEW

INVOICE

DEFERRED_EDIT_IND

 
NVL(FABINVH_INVD_RE_ESTABLISH_IND,'N') NA

REPORTING VIEW

INVOICE

INVOICE_RE_ESTABLISHED_IND

 
NVL(FABINVH_NSF_ON_OFF_IND,'N') NA

REPORTING VIEW

INVOICE

NSF_ON_OFF_IND

 
NVL(FABINVH_RUIV_IND,'N') FAAINVE

REPORTING VIEW

INVOICE

REPEATING_INVOICE_IND

 
NVL(FABINVH_RUIV_INSTALLMENT_IND,'N') FAAINVE

REPORTING VIEW

INVOICE

INSTALLMENT_IND

 
NVL(FABINVH_SINGLE_ACCTG_IND,'N') NA

REPORTING VIEW

INVOICE

DOCUMENT_ACCOUNTING_IND

 
NVL(FABINVH_TEXT_IND,'N') NA

REPORTING VIEW

INVOICE

TEXT_EXISTS_IND

 
NVL(FABRUIV_MAX_SUB,0) NA

REPORTING VIEW

INVOICE

MAXIMUM_NUMBER_SUBMISSIONS

 
NVL(FABRUIV_MAX_SUB,0) - NVL( FABRUIV_SUB_TO_DATE,0) NA

REPORTING VIEW

INVOICE

REMAINING_SUBMISSIONS

 
NVL(FABRUIV_SUB_TO_DATE,0) NA

REPORTING VIEW

INVOICE

SUBMISSIONS_TO_DATE

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

REPORTING VIEW

INVOICE_ACCOUNTING

INVOICE_ITEM_ACCOUNTING

APPROVED_CHARGE_AMOUNT

APPROVED_CHARGE_AMOUNT

This calculation returns the approved charge amount by summing the approved amount, additional charges, and tax amount and subtracting any associated discount.
NVL(FGBENCD_ABAL_OVERRIDE) NA

REPORTING VIEW

AF_ENCUMBRANCE_ACCOUNTING

AVAILABLE_BALANCE_OVERRIDE_IND

 
NVL(FGBENCH_EDIT_DEFERRAL,'N') NA

REPORTING VIEW

ENCUMBRANCE

DEFERRED_EDIT_IND

 
NVL(FGBENCH_NSF_ON_OFF_IND,'N') NA

REPORTING VIEW

ENCUMBRANCE

NSF_ON_OFF_IND

 
NVL(FPBPOHD_BLANKET_IND,'N') FPABLAR

REPORTING VIEW

PURCHASE_ORDER

BLANKET_ORDER_IND

 
NVL(FPBPOHD_CANCEL_IND,'N') FPAPURR

REPORTING VIEW

PURCHASE_ORDER

CANCEL_IND

 
NVL(FPBPOHD_CLOSED_IND,'N') NA

REPORTING VIEW

PURCHASE_ORDER

CLOSED_IND

 
NVL(FPBPOHD_EDI_IND,'N') NA

REPORTING VIEW

PURCHASE_ORDER

EDI_IND

 
NVL(FPBPOHD_PRINT_IND,'N') NA

REPORTING VIEW

PURCHASE_ORDER

PRINT_IND

 
NVL(FPBPOHD_REXP_DATE, FPBPOHD_BLANKET_TERM_DATE) FPABLAR

REPORTING VIEW

PURCHASE_ORDER

PO_END_DATE

NA
NVL(FPBPOHD_SUSP_IND,'N') FPAPURR

REPORTING VIEW

PURCHASE_ORDER

SUSPENSE_IND

 
NVL(FPRPODA_ADDL_CHRG_AMT,0) FPAPURR        
NVL(FPRPODA_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ITEM_ACCOUNTING

AMOUNT

AMOUNT

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

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ITEM_ACCOUNTING

APPROVED_CHARGE_AMOUNT

APPROVED_CHARGE_AMOUNT

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

REPORTING VIEW

PURCHASE_ORDER_ITEM_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

CLOSED_IND

CLOSED_IND

 
NVL(FPRPODA_CONVERT_ADDL_CHRG_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ITEM_ACCOUNTING

CONVERTED_ADDITIONAL_AMOUNT

CONVERTED_ADDITIONAL_AMOUNT

 
NVL(FPRPODA_CONVERT_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

CONVERTED_AMOUNT

CONVERTED_AMOUNT

 
NVL(FPRPODA_CONVERT_DISC_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

CONVERTED_DISCOUNT_AMOUNT

CONVERTED_DISCOUNT_AMOUNT

 
NVL(FPRPODA_CONVERT_TAX_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ITEM_ACCOUNTING

CONVERTED_TAX_AMOUNT

CONVERTED_TAX_AMOUNT

 
NVL(FPRPODA_DISC_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ITEM_ACCOUNTING

DISCOUNT_AMOUNT

DISCOUNT_AMOUNT

 
NVL(FPRPODA_ENCB_ADJT_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

ENCUMBRANCE_ADJUSTMENT_AMOUNT

ENCUMBRANCE_ADJUSTMENT_AMOUNT

 
NVL(FPRPODA_NSF_OVERRIDE_IND,'N') FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ITEM_ACCOUNTING

NSF_OVERRIDE_IND

NSF_OVERRIDE_IND

 
NVL(FPRPODA_SUSP_IND,'N') FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ITEM_ACCOUNTING

SUSPENSE_IND

SUSPENSE_IND

 
NVL(FPRPODA_TAX_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

TAX_AMOUNT

TAX_AMOUNT

 
NVL(FPRPODT_ADDL_CHRG_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ITEM

PURCHASE_ORDER_ITEM_ACCOUNTING

ADDITIONAL_AMOUNT

ADDITIONAL_CHARGES_AMOUNT

ADDITIONAL_AMOUNT

 
NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

CONVERTED_ADDITNAL_AMOUNT

 
NVL(FPRPODT_CONVERT_DISC_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

CONVERTED_DISCOUNT_AMOUNT

 
NVL(FPRPODT_CONVERT_TAX_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

CONVERTED_TAX_AMOUNT

 
NVL(FPRPODT_CONVERT_UNIT_PRICE,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

CONVERTED_UNIT_PRICE

 
NVL(FPRPODT_DESC_CHGE_IND,'N') FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

COMMODITY_DESC_CHANGE_IND

 
NVL(FPRPODT_DISC_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

DISCOUNT_AMOUNT

 
NVL(FPRPODT_LIQ_AMT,0) NA

REPORTING VIEW

PURCHASE_ORDER_ITEM

LIQUIDATION_AMOUNT

 
NVL(FPRPODT_QTY,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

QUANTITY

 
NVL(FPRPODT_TAX_AMT,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

TAX_AMOUNT

 
NVL(FPRPODT_UNIT_PRICE,0) FPAPURR

REPORTING VIEW

PURCHASE_ORDER_ITEM

UNIT_PRICE

 
NVL(FPRRCDT_TOL_OVERRIDE_IND) FPARCVD

REPORTING VIEW

RECEIVED_ITEM

TOLERANCE_OVERRIDE_IND

Calculations deterimines if the override is set to (Y)es or (N)o.
NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID) NA        
NVL(FTRACTA_ATTS_CODE,'NONE') FTMFATA

REPORTING VIEW

ACCOUNT_ATTRIBUTES

SET_CODE

NA
NVL(FTRACVA_ATTS_CODE,'NONE') FTMFATA

REPORTING VIEW

ACTIVITY_ATTRIBUTES

SET_CODE

NA
NVL(FTRATYA_ATTS_CODE,'NONE') FTMFATA

REPORTING VIEW

ACCOUNT_TYPE_ATTRIBUTES

SET_CODE

NA
NVL(FTRFNDA_ATTS_CODE,'NONE') FTMFATA

REPORTING VIEW

FUND_ATTRIBUTES

SET_CODE

NA
NVL(FTRFTYA_ATTS_CODE,'NONE') FTMFATA

REPORTING VIEW

FUND_TYPE_ATTRIBUTES

SET_CODE

NA
NVL(FTRLCNA_ATTS_CODE,'NONE') FTMFATA

REPORTING VIEW

LOCATION_ATTRIBUTES

SET_CODE

NA
NVL(FTRORGA_ATTS_CODE,'NONE') FTMFATA

REPORTING VIEW

ORGANIZATION_ATTRIBUTES

SET_CODE

NA
NVL(FTRPRGA_ATTS_CODE,'NONE') FTMFATA

REPORTING VIEW

PROGRAM_ATTRIBUTES

SET_CODE

NA
NVL(FTVACCT_ACCT_CODE_POOL, FTVACCT_ACCT_CODE) FTMACCT

REPORTING VIEW

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY_FISCAL

TRANSACTION_HISTORY

BUDGET_DETAIL

OPERATING_LEDGER

TRANSACTION_HISTORY

BUDGET_AVAILABILITY_LEDGER

GRANT_LEDGER

BUDGET_AVAILABILITY_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

GENERAL_LEDGER

ACCOUNT_POOL

ACCOUNT_POOL

ACCOUNT_POOL

ACCOUNT_POOL

ACCOUNT_POOL

ORIG_ACCOUNT_POOL

ORIG_ACCOUNT_POOL

ACCOUNT_POOL

ACCOUNT_POOL

ORIG_ACCOUNT_POOL

ORIG_ACCOUNT_POOL

ORIG_ACCOUNT_POOL

ACCOUNT_POOL

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

REPORTING VIEW

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

BUDGET_AVAILABILITY_LEDGER

FUND_HIERARCHY_FISCAL

TRANSACTION_HISTORY

OPERATING_LEDGER

BUDGET_DETAIL

BUDGET_AVAILABILITY_LEDGER

FUND_HIERARCHY

GRANT_LEDGER

ORIG_FUND_POOL

FUND_POOL

ORIG_FUND_POOL

ORIG_FUND_POOL

ORIG_FUND_POOL

FUND_POOL

ORIG_FUND_POOL

FUND_POOL

FUND_POOL

FUND_POOL

FUND_POOL

FUND_POOL

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

REPORTING VIEW

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

OPERATING_LEDGER

OPERATING_LEDGER

BUDGET_AVAILABILITY_LEDGER

ORGANIZATION_HIERARCHY_FISCAL

TRANSACTION_HISTORY

GRANT_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_POOL

ORGANIZATION_POOL

ORIG_ORGANIZATION_POOL

ORGANIZATION_POOL

ORIG_ORGANIZATION_POOL

ORGANIZATION_POOL

ORGANIZATION_POOL

ORGANIZATION_POOL

ORGANIZATION_POOL

This calculation retrieves the FTVORGN_CODE_NSF if it is not NULL. Otherwise it retrieves the FTVORGN_ORGN_CODE.
NVL(FTVVEND_TERM_DATE,'31-DEC-2099') NA

REPORTING VIEW

AF_VENDOR

VENDOR_TERMINATION_DATE

 
NVL(FTVVEND_VEND_CHECK_PIDM, FTVVEND_PIDM) NA

REPORTING VIEW

AF_VENDOR

REMIT_TO_VENDOR_UID

 
NVL(GERATTD_FEES_DESC, GTVFEES_DESC) NA

REPORTING VIEW

EVENT_INVITEE

FEE_STATUS_DESC

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

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

DATE_SENT3

DATE_SENT5

DATE_SENT4

DATE_SENT

DATE_SENT2

DATE_SENT1

NA
NVL(NBBPOSN_ACCRUE_SENIORITY_IND, NTRPCLS_ACCRUE_SENIORITY_IND) MULTIPLE

REPORTING VIEW

POSITION_DEFINITION

SENIORITY_ACCRUED_IND

Retrieves seniority accrual indicator from postion classification rule table if the indicator is null in the position record.
NVL(NBBPOSN_GRADE,NTRPCLS_GRADE) NA       This function returns NBBPOSN_GRADE if it is not null else it returns NTRPCLS_GRADE.
NVL(NBBPOSN_POSN_REPORTS, MPKFUNC.F_GET_POSITION_REPORTS) MULTIPLE

REPORTING VIEW

POSITION_DEFINITION

POSITION_REPORTS

NVL(POSITION_REPORTS, SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION,'POSITION'),1,63))
NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE) NA

REPORTING VIEW

POSITION_DEFINITION

SALARY_GROUP

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       This function returns NBBPOSN_STEP if it is not null else it returns NTRPCLS_STEP.
NVL(NBBPOSN_TABLE,NTRPCLS_TABLE) NA       This function returns NBBPOSN_TABLE if it is not null, else it returns NTRPCLS_TABLE.
NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR) NA

REPORTING VIEW

EMPLOYEE

EMPLOYEE_POSITION

SUPERVISOR_UID

SUPERVISOR_UID

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

REPORTING VIEW

EMPLOYEE

EMPLOYEE_POSITION

SUPERVISOR_POSITION

SUPERVISOR_POSITION

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

REPORTING VIEW

EMPLOYEE

EMPLOYEE_POSITION

SUPERVISOR_JOB_SUFFIX

SUPERVISOR_JOB_SUFFIX

NVL(NBRJOBS_SUPERVISOR_SUFF, SUBSTR(NOKODSF.F_GET_SUPERVISOR(NBBPOSN_POSN_REPORTS,'SUFFIX'),1,2)
NVL(PAY.TRANSACTION_DATE, CHG.TRANSACTION_DATE) NA

REPORTING VIEW

APPL_OF_PAY_DETAIL_ACCOUNTING

APPLICATION_OF_PAYMENT

APPLIED_DATE

APPLIED_DATE

Applied date is set from the payment transaction date, and if null, then is set to the charge transaction date when the payment is applied to the charge.
NVL(RCRAPP4_DUP_SSN_IND) TBD

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

DUPLICATE_TAX_ID_IND

 
NVL(RCRAPP4_PUSH_ISIR_FLAG) RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

CPS_ISIR_PUSHED_IND

 
NVL(RCRESAR_AUTO_ZERO_EFC_FLAG) TBD        
NVL(RCRESAR_SUB_APP) RNIMSXX        
NVL(RCRESAR_VERIF_CHANGE_IND) RNARSXX RNIMSXX

REPORTING VIEW

NEED_ANALYSIS_ISIR_SPECIFIC

VERIFICATION_SELECT_CHANGE_IND

 
NVL(RNROVRD_ADD_BK_HOPE_OPT) TBD        
NVL(RNROVRD_ALLOW_IM_PC_LOWR_FM) TBD        
NVL(RNROVRD_ALLOW_IM_SC_LOWR_FM) TBD        
NVL(RNROVRD_CALC_US_TAX_FM) TBD        
NVL(RNROVRD_NON_CUST_PC_OPT) TBD        
NVL(RNROVRD_PAR_ADD_BK_HOME_OPT) TBD        
NVL(RNROVRD_PAR_CALC_US_TAX_FM) TBD        
NVL(RNROVRD_PAR_EXCL_TUIT_DED) RNAOVXX

REPORTING VIEW

NEED_ANALYSIS_OVERRIDE

IM_PARENT_EXCL_TUITION_FEE_IND

 
NVL(RNROVRD_PAR_USE_PROJ_INC_EFM) TBD        
NVL(RNROVRD_SKIP_AGE_EXCL) TBD        
NVL(RNROVRD_USE_PROJ_INC_EFM) TBD        
NVL(RNROVRD_ZERO_LOSS_BUS_FARM) TBD        
NVL(RNROVRD_ZERO_LOSS_OTH) TBD        
NVL(RPRADSB_ALTERNATE_PELL_IND,'N') ROAPELL        
NVL(RPRADSB_CPS_VER_IND,'N') READIXX

REPORTING VIEW

AWARD_DISBURSEMENT

CPS_VERIFICATION_IND

 
NVL(RPRADSB_DISB_LOCK_IND,'N') READIXX

REPORTING VIEW

AWARD_DISBURSEMENT

COD_DISBURSEMENT_LOCK_IND

 
NVL(RPRADSB_EXCL_FROM_NET_AMT,'N') READIXX

REPORTING VIEW

AWARD_DISBURSEMENT

COD_NET_AMOUNT_EXCLUSION_IND

 
NVL(RPRLAPP_ADDL_STFD_ELIG_IND,'N') NA

REPORTING VIEW

LOAN_APPLICATION

LOAN_APPLICATION

ADDITIONAL_STAFFORD_ELIG_IND

ADDL_UNSUBSIDIZED_ELIG_IND

 
NVL(RPRLAPP_DEFERMENT_OPT,'N') NA

REPORTING VIEW

LOAN_APPLICATION

DEFERRED_PAYMENT_IND

 
NVL(RPRLAPP_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO) NA

REPORTING VIEW

LOAN_APPLICATION

FIRST_NAME

 
NVL(RPRLAPP_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO) NA

REPORTING VIEW

LOAN_APPLICATION

LAST_NAME

 
NVL(RPRLAPP_MAX_LOAN_IND,'N') NA

REPORTING VIEW

LOAN_APPLICATION

MAXIMUM_LOAN_REQUESTED_IND

 
NVL(RPRLAPP_MI, MGKFUNC.F_GET_PERSON_INFO) NA

REPORTING VIEW

LOAN_APPLICATION

MIDDLE_INITIAL

 
NVL(RPRLAPP_SSN, MGKFUNC.F_GET_PERSON_INFO) NA

REPORTING VIEW

LOAN_APPLICATION

TAX_ID

 
NVL(RPRLATR_EXCLUDE_LNEX_FLAG,'N') RPALORG RPAELAP RPALAPP        
NVL(SARADAP_FEE_IND,'N') NA

REPORTING VIEW

ADMISSIONS_APPLICATION

APPLICATION_FEE_REQUIRED_IND

NA
NVL(SFRSTCR_APPR_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

SPECIAL_APPROVAL_OVERRIDE_IND

 
NVL(SFRSTCR_ATTS_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

STUDENT_ATTRIBUTE_OVERRIDE_IND

 
NVL(SFRSTCR_CAMP_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

CAMPUS_RESTRICT_OVERRIDE_IND

 
NVL(SFRSTCR_CAPC_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

CAPACITY_OVERRIDE_IND

 
NVL(SFRSTCR_CHRT_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

STUDENT_COHORT_OVERRIDE_IND

 
NVL(SFRSTCR_CLAS_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

CLASS_RESTRICT_OVERRIDE_IND

 
NVL(SFRSTCR_COLL_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

COLLEGE_RESTRICT_OVERRIDE_IND

 
NVL(SFRSTCR_CORQ_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

COREQUISITE_OVERRIDE_IND

 
NVL(SFRSTCR_DEGC_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

DEGREE_RESTRICT_OVERRIDE_IND

 
NVL(SFRSTCR_DEPT_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

DEPARTMENT_RESTRICT_OVER_IND

 
NVL(SFRSTCR_DUPL_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

DUPLICATE_COURSE_OVERRIDE_IND

 
NVL(SFRSTCR_LEVL_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

LEVEL_RESTRICT_OVERRIDE_IND

 
NVL(SFRSTCR_LINK_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

LINK_OVERRIDE_IND

 
NVL(SFRSTCR_MAJR_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

MAJOR_RESTRICT_OVERRIDE_IND

 
NVL(SFRSTCR_MEXC_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

MUTUTAL_EXCLUSION_OVERRIDE_IND

 
NVL(SFRSTCR_PREQ_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

PREREQUISITE_OVERRIDE_IND

 
NVL(SFRSTCR_PROG_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

PROGRAM_RESTRICT_OVERRIDE_IND

 
NVL(SFRSTCR_REPT_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

REPEAT_COURSE_OVERRIDE_IND

 
NVL(SFRSTCR_RPTH_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

REPEAT_COURSE_CREDIT_OVER_IND

 
NVL(SFRSTCR_TEST_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

TEST_SCORE_OVERRIDE_IND

 
NVL(SFRSTCR_TIME_OVER,'N') NA

REPORTING VIEW

STUDENT_COURSE

TIME_CONFLICT_OVERRIDE_IND

 
NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS( SHRTCKN_PIDM,SHRTCKN_TERM_CODE, SHRTCKN_CRN)) NA       This calculates the number of extensions SHRTCKN_NUMBER_OF_EXTENSIONS for the specified UID, academic period and course if it exists, else it returns the function which returns the number of extensions MAX(SFRAREG_EXTENSION_NUMBER) a student has been granted to complete the class for the specified UID, academic period and course where the withdrawal indicator is N.
NVL(SHRTCKN_REG_COMPLETION_DATE, SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM, SHRTCKN_TERM_CODE,SHRTCKN_CRN, SHRTCKN_PTRM_CODE,'E')) NA       This function returns the registration start date SHRTCKN_REG_START_DATE if it exists, else it returns the course start date for a specified UID, academic period, course and subacademic period.
NVL(SHRTCKN_REG_START_DATE, SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM, SHRTCKN_TERM_CODE,SHRTCKN_CRN, SHRTCKN_PTRM_CODE,'S')) SFARHST       This function returns the registration completion date SHRTCKN_REG_COMPLETION_DATE if it exists, else it returns the course end date for a specified UID, academic period, course and subacademic period.
NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE) NA

REPORTING VIEW

PREVIOUS_EDUCATION_ATTENDANCE

TRANSCRIPT_REVIEWED_DATE

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

REPORTING VIEW

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

GRAD_YEAR_INTENDED

GRAD_YEAR_INTENDED

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

REPORTING VIEW

ACADEMIC_STUDY

FIELD_OF_STUDY

ACADEMIC_STUDY_EXTENDED

EXPECTED_GRADUATION_DATE

EXPECTED_GRADUATION_DATE

EXPECTED_GRADUATION_DATE

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

REPORTING VIEW

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

LEAVE_REASON

LEAVE_REASON

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

REPORTING VIEW

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

LEAVE_DATE_FROM

LEAVE_DATE_FROM

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

REPORTING VIEW

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

LEAVE_DATE_TO

LEAVE_DATE_TO

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

REPORTING VIEW

ACADEMIC_STUDY_EXTENDED

ACADEMIC_STUDY

STUDENT_RATE

STUDENT_RATE

Retrieve student rate from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_SITE_CODE,SGBSTDN_SITE_CODE) NA

REPORTING VIEW

ACADEMIC_STUDY_EXTENDED

ACADEMIC_STUDY

SITE

SITE

Use site code from curriculum record and if null use site from student record sgbstdn.
NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE) MULTIPLE

REPORTING VIEW

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

STUDENT_POPULATION

STUDENT_POPULATION

Retrieve student population or type from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur.
NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD) MULTIPLE

REPORTING VIEW

ACADEMIC_STUDY_EXTENDED

ACADEMIC_STUDY

GRAD_ACADEMIC_PERIOD_INTENDED

GRAD_ACADEMIC_PERIOD_INTENDED

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

REPORTING VIEW

INSTRUCT_ASSIGN_SLOT

INSTRUCTIONAL_ASSIGNMENT

INSTRUCT_ASSIGN_SLOT

GOVERNMENT_COURSE

INSTRUCT_ASSIGN_SLOT

SCHEDULE_OFFERING

INSTRUCTOR_LAST_NAME2

INSTRUCTOR_LAST_NAME

PRIMARY_INSTRUCTOR_LAST_NAME

INSTRUCTOR_LAST_NAME

INSTRUCTOR_LAST_NAME3

PRIMARY_INSTRUCTOR_LAST_NAME

This function returns the instructor''s last name SPRIDEN_LAST_NAME if it exists, else STAFF.
NVL(SPRIDEN_MI,'STAFF') MULTIPLE

REPORTING VIEW

INSTRUCT_ASSIGN_SLOT

PRIMARY_INSTRUCTOR_MIDDLE_NAME

Retrieve the instructor''s last name SPRIDEN_LAST_NAME if it exists, else set to STAFF.
NVL(SSBOVRR_COLL_CODE,SCBCRSE_COLL_CODE) SSAOVRR       This function returns the override college SSBOVRR_COLL_CODE if it exists, else it returns the course college SCBCRSE_COLL_CODE.
NVL(SSBOVRR_DEPT_CODE,SCBCRSE_DEPT_CODE) SSAOVRR       This function returns the override department SSBOVRR_DEPT_CODE if it exists, else it returns the department SCBCRSE_DEPT_CODE.
NVL(SSBOVRR_DIVS_CODE,SCBCRSE_DIVS_CODE) SSAOVRR       This function returns the override division SSBOVRR_DIVS_CODE if it exists, else it returns the course division SCBCRSE_DIVS_CODE.
NVL(SSBSECT_CONT_HR, SCBCRSE_CONT_HR_HIGH) SCACRSE

REPORTING VIEW

GOVERNMENT_COURSE

TOTAL_CONTACT_HOURS

NA
NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE) SCACRSE

REPORTING VIEW

GOVERNMENT_COURSE

COURSE_TITLE_SHORT

NA
NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH) SCACRSE

REPORTING VIEW

GOVERNMENT_COURSE

LAB_CONTACT_HOURS

NA
NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH) SCACRSE

REPORTING VIEW

GOVERNMENT_COURSE

LECTURE_CONTACT_HOURS

NA
NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH) SCACRSE

REPORTING VIEW

GOVERNMENT_COURSE

OTHER_CONTACT_HOURS

NA
NVL(SUM_ADOPTED_BUDGET + SUM_BUDGET_ADJUSTMENTS, 0) NA

REPORTING VIEW

BUDGET_AVAILABILITY_LEDGER

SUM_TOTAL_BUDGET

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

REPORTING VIEW

BUDGET_AVAILABILITY_LEDGER

SUM_COMMITTED_BALANCE

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

REPORTING VIEW

DEPOSIT

BALANCE_AMOUNT

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

REPORTING VIEW

DEPOSIT

OPERATING_DATE

This function returns the difference between the transaction date TBRDEPO_TRANS_DATE or if null, the effective date TBRDEPO_EFFECTIVE_DATE and the feed date TBRDEPO_FEED_DATE or if null, today's date SYSDATE.
NVL(TRANSACTION_HISTORY.FUND_POOL, FUND_HIERARCHY.FUND_POOL) NA

REPORTING VIEW

TRANSACTION_HISTORY

FUND_POOL

Population of fund pool is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
NVL=(ASBSORG_PARTICIPATION_GOAL,0) NA

REPORTING VIEW

SOLICITOR_ORGANIZATION

ORG_PARTICIPATION_GOAL

 
PPREXPE_SUPER_PHONE_AREA||PPREXPE_SUPER_ PHONE_NUMBER||PPREXPE_SUPER_PHONE_EXT NA       NA
PPRREFE_PHONE_AREA||PPRREFE_PHONE_NUMBER ||PPRREFE_PHONE_EXT NA       This function concatenates the phone area code, the phone number and the phone extension from the PPRREFE table.
ROW_NUMBER TBD

REPORTING VIEW

ADMISSIONS_APPLICATION

ACADEMIC_OUTCOME

GOVERNMENT_ADMISSIONS

RECRUITMENT_INFORMATION

CURRICULUM_ORDER

CURRICULUM_ORDER

CURRICULUM_ORDER

CURRICULUM_ORDER

 
SALARY_GROUP||SALARY_TABLE||SALARY_GRADE TBD        
SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB SCACRSE

REPORTING VIEW

COURSE_PREREQ

COURSE_CATALOG

REGISTRATION_PLAN_COURSE

STUDENT_WORK_EXPERIENCE

COURSE_IDENTIFICATION_PREREQ

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

This concatenates the course subject code with the course number from the SCBCRSE record.
SCBSUPP_SUBJ_CODE||SCBSUPP_CRSE_NUMB SCADETL       This concatenates the course subject code with the course number from the SCBSUPP record.
SCRATTR_SUBJ_CODE||SCRATTR_CRSE_NUMB SCADETL

REPORTING VIEW

COURSE_ATTRIBUTE

COURSE_IDENTIFICATION

NA
SCRCORQ_SUBJ_CODE_CORQ||SCRCORQ_CRSE_NUM B_CORQ SCADETL

REPORTING VIEW

COURSE_COREQ

COURSE_IDENTIFICATION_COREQ

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

REPORTING VIEW

COURSE_COREQ

COURSE_IDENTIFICATION

This concatenates the course subject code with the course number from the SCRCORQ record.
SCRGMOD_SUBJ_CODE||SCRGMOD_CRSE_NUMB, SSASECT       This concatenates the course subject code with the course number from the SGRGMOD record.
SCRLEVL_SUBJ_CODE||SCRLEVL_CRSE_NUMB SCACRSE

REPORTING VIEW

COURSE_LEVEL

COURSE_IDENTIFICATION

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

REPORTING VIEW

COURSE_PREREQ_COMBINED

COURSE_PREREQ

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

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

REPORTING VIEW

COURSE_SCHEDULE

COURSE_IDENTIFICATION

This concatenates the course subject code with the course number from the SCRSCHD record.
SEASONS_COMPETITION_AVAILABLE - SEASONS_COMPETITION_USED NA

REPORTING VIEW

SPORT

SEASONS_COMPETITION_REMAINING

 
SELECT RORMVAL_DESC FROM RORMVAL WHERE RORMVAL_COLUMN = 'RFRASPC_APPL_MEMO_IND' AND RORMVAL_CODE = RFRASPC_APPL_MEMO_IND NA

REPORTING VIEW

FINAID_FUND

MEMO_AWARD_ALLOWED_DESC

 
SFRPLAN_SUBJ_CODE||SFRPLAN_CRSE_NUMB NA

REPORTING VIEW

PROJECTED_SEATS_NEEDED

COURSE_IDENTIFICATION

 
SFRSTCR_SUBJ_CODE||SFRSTCR_CRSE_NUMB SFAREGS

REPORTING VIEW

FACULTY_FEEDBACK

FACULTY_FEEDBACK_DETAIL

STUDENT_COURSE

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

This concatenates the course subject code with the course number from the SFRSTCR record.
SGRCOOP_PHONE_AREA||SGRCOOP_PHONE_NUMBER ||SGRCOOP_PHONE_EXT NA

REPORTING VIEW

STUDENT_WORK_EXPERIENCE

PHONE_NUMBER_COMBINED

NA
SHRTATT_TRIT_SEQ_NO||TO_CHAR( SHRTATT_TRAM_SEQ_NO,'FM09')||TO_CHAR( NVL(SHRTATT_TRCR_SEQ_NO,0),'FM009') ||TO_CHAR(SHRTATT_TRCE_SEQ_NO,'FM009') MULTIPLE

REPORTING VIEW

STUDENT_COURSE_ATTRIBUTE

STUDENT_COURSE_ATT_SLOT

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

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

REPORTING VIEW

STUDENT_COURSE

STUDENT_COURSE_GRADE_CHANGE

CREDITS_ATTEMPTED

CREDITS_ATTEMPTED

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

REPORTING VIEW

STUDENT_COURSE

STUDENT_COURSE_GRADE_CHANGE

CREDITS_EARNED

CREDITS_EARNED

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

REPORTING VIEW

STUDENT_COURSE_GRADE_CHANGE

STUDENT_COURSE

CREDITS_FOR_GPA

CREDITS_FOR_GPA

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

REPORTING VIEW

STUDENT_COURSE_GRADE_CHANGE

STUDENT_COURSE

CREDITS_PASSED

CREDITS_PASSED

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

REPORTING VIEW

STUDENT_COURSE_GRADE_CHANGE

STUDENT_COURSE

QUALITY_POINTS

QUALITY_POINTS

This calculates the credit hours passed by the student.
SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB SHAINST

REPORTING VIEW

GOVERNMENT_COURSE

STUDENT_COURSE

STUDENT_COURSE_ATTRIBUTE

STUDENT_COURSE_GRADE_CHANGE

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

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

REPORTING VIEW

STUDENT_TRANSFERRED_COURSE

CREDITS_ATTEMPTED

 
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_EARNED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) TBD

REPORTING VIEW

STUDENT_TRANSFERRED_COURSE

CREDITS_EARNED

 
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_GPA_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) TBD

REPORTING VIEW

STUDENT_TRANSFERRED_COURSE

CREDITS_FOR_GPA

 
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_PASSED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) TBD

REPORTING VIEW

STUDENT_TRANSFERRED_COURSE

CREDITS_PASSED

 
SHRTRCE_CREDIT_HOURS*SHRGRDE_QUALITY_POI NTS*DECODE(SHRGRDE_GPA_IND,'Y',1,0) *DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0, 1) TBD

REPORTING VIEW

STUDENT_TRANSFERRED_COURSE

QUALITY_POINTS

 
SHRTRCE_SUBJ_CODE||SHRTRCE_CRSE_NUMB SHATRNS

REPORTING VIEW

STUDENT_COURSE

COURSE_IDENTIFICATION

This concatenates the course subject code with the course number from the SHRTRCE record.
SHRTRCE_TRIT_SEQ_NO||TO_CHAR( SHRTRCE_TRAM_SEQ_NO,'FM09')||TO_CHAR( NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009') ||TO_CHAR(SHRTRCE_SEQ_NO,'FM009') TBD

REPORTING VIEW



REPORTING VIEW

STUDENT_TRANSFERRED_COURSE

STUDENT_COURSE

STUDENT_TRANSFERRED_COURSE

STUDENT_COURSE

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

COURSE_REFERENCE_NUMBER

 
SHRTRCR_TRANS_COURSE_NAME||SHRTRCR_TRANS _COURSE_NUMBERS NA

REPORTING VIEW

STUDENT_TRANSFERRED_COURSE

STUDENT_TRANSFERRED_COURSE

COURSE_IDENTIFICATION

TRANSFER_COURSE_IDENTIFICATION

 
SLBBLDG_PHONE_AREA||SLBBLDG_PHONE_NUMBER ||SLBBLDG_PHONE_EXTENSION SLABLDG

REPORTING VIEW

ROOM_ASSIGNMENT

BUILDING_PHONE_NUM_COMBINED

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

REPORTING VIEW

EVENT

PHONE_NUMBER_COMBINED

NA
SLBRDEF_PHONE_AREA||SLBRDEF_PHONE_NUMBER ||SLBRDEF_PHONE_EXTENSION SLARASG

REPORTING VIEW

ROOM_ASSIGNMENT

ROOM_PHONE_NUM_COMBINED

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

REPORTING VIEW

PHONE_ASSIGNMENT

PHONE_NUMBER_COMBINED

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

REPORTING VIEW

INSTITUTION

CONTACT_PHONE_NUMBER_COMBINED

NA
SPRADDR_CNTY_CODE FAAINVE

REPORTING VIEW

INVOICE

REMIT_TO_COUNTY

NA
SPRIDEN_FIRST_NAME || SUBSTR(SPRIDEN_MI, 1,1) || SPRIDEN_LAST_NAME NA

REPORTING VIEW

PLEDGE_MATCHING_TRANSACTION

MATCH_EMPLOYER_NAME

 
SPRIDEN_FIRST_NAME||SPRIDEN_MI||SPRIDEN_ LAST_NAME NA       NA
SPRTELE_INTL_ACCESS || SPRTELE_PHONE_AREA || SPRTELE_PHONE_NUMBER || SPRTELE_PHONE_EXT NA

REPORTING VIEW

VENDOR

VENDOR

ORDER_FROM_PHONE_COMBINED

REMIT_TO_PHONE_NUMBER_COMBINED

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

REPORTING VIEW

ORGANIZATION_CONTACT

TELEPHONE_CURRENT

ORGANIZATION_CONTACT

ADDRESS_PREFERRED

PERSON

CONSTITUENT_ENTITY

GRANT_PERSONNEL

TELEPHONE

REFERENCE

ORGANIZATION_ENTITY

FAX_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

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

REPORTING VIEW

MEETING_TIME

STUDENT_COURSE_REG_AUDIT

OFFERING_COREQ

GOVERNMENT_COURSE

COURSE_OFFERING_FEES

OFFERING_PREREQ

BLOCK_REGISTRATION_COURSE

OFFERING_GRADE_TYPE

SCHEDULE_OFFERING

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

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

REPORTING VIEW

OFFERING_PREREQ

PREREQ_COURSE_IDENTIFICATION

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

REPORTING VIEW

PERSON

PERSON_DETAIL

MIDDLE_INITIAL

MIDDLE_INITIAL

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

REPORTING VIEW

PLEDGE_TRANSACTION

PLEDGE_TRANS_AMOUNT_PAID

 
SUM(AMOUNT) NA

REPORTING VIEW

RECEIVABLE_SUMMARY

AMOUNT

This summarizes the amount SUM(TBRACCD_AMOUNT) for a given term, category code and detail code.
SUM(FPRRCDT_AMT_RCVD) FPARCVD

REPORTING VIEW

PURCHASE_ORDER_ITEM_SUMMARY

RECEIVED_AMOUNT_TO_DATE

NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY) FPARCVD FPARTRN

REPORTING VIEW

PURCHASE_ORDER_ITEM_SUMMARY

QUANTITY_ACCEPTED_TO_DATE

NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD) FPARCVD

REPORTING VIEW

RECEIVED_ITEM

PURCHASE_ORDER_ITEM_SUMMARY

QUANTITY_RECEIVED_REJECTED

QTY_RECEIVED_REJECTED_TO_DATE

NA
SUM(FPRRCDT_QTY_RCVD) FPARCVD

REPORTING VIEW

PURCHASE_ORDER_ITEM_SUMMARY

PURCHASE_ORDER_ITEM_SUMMARY

QUANTITY_RECEIVED_TO_DATE

QUANTITY_REJECTED_TO_DATE

NA
SUM(FPRRTRN_QTY) FPARCVD

REPORTING VIEW

PURCHASE_ORDER_ITEM_SUMMARY

QUANTITY_RETURNED_TO_DATE

Returns the sum of all quantities returned for a purchase order item.
SUM(PERJTOT_GRS) NA       This function returns the sum of the hours SUM(PERJTOT_GRS).
SUM(PERJTOT_HRS) NA       This function returns the sum of the hours SUM(PERJTOT_HRS).
SUM(RPRAWRD_ACCEPT_AMT) NA

REPORTING VIEW

AWARD_BY_FUND

ACCEPT_AMOUNT

SUM(RPRAWRD_ACCEPT_AMT)
SUM(RPRAWRD_AUTHORIZE_AMT) NA

REPORTING VIEW

AWARD_BY_FUND

AUTHORIZED_AMOUNT

NA
SUM(RPRAWRD_CANCEL_AMT) NA

REPORTING VIEW

AWARD_BY_FUND

CANCEL_AMOUNT

NA
SUM(RPRAWRD_DECLINE_AMT) NA

REPORTING VIEW

AWARD_BY_FUND

DECLINE_AMOUNT

NA
SUM(RPRAWRD_MEMO_AMT) NA

REPORTING VIEW

AWARD_BY_FUND

MEMO_AMOUNT

NA
SUM(RPRAWRD_OFFER_AMT) NA

REPORTING VIEW

AWARD_BY_FUND

OFFER_AMOUNT

NA
SUM(RPRAWRD_PAID_AMT) NA

REPORTING VIEW

AWARD_BY_FUND

PAID_AMOUNT

NA
SUM_ADOPTED_BUDGET + SUM_BUDGET_ADJUSTMENTS TBD        
SYSDATE BETWEEN SPRHOLD_FROM_DATE AND SPRHOLD_TO_DATE NA

REPORTING VIEW

HOLD

ACTIVE_HOLD_IND

 
TBD NA        
TBLD NA        
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE1') NA

REPORTING VIEW

GOVERNMENT_STUDENT

CENSUS_FTE_1

Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE2') NA

REPORTING VIEW

GOVERNMENT_STUDENT

CENSUS_FTE_2

Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE3') NA

REPORTING VIEW

GOVERNMENT_STUDENT

CENSUS_FTE_3

Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE4') NA

REPORTING VIEW

GOVERNMENT_STUDENT

CENSUS_FTE_4

Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TO_CHAR (TO_DATE (FAB1099_RPT_YR, 'RR'), 'YYYY') NA

REPORTING VIEW

VENDOR_TAXABLE_REPORTING

TAX_YEAR

 
TO_CHAR (TO_DATE (FRRGRNH_FSYR_CODE, 'RR'), 'YYYY' NA

REPORTING VIEW

GRANT_DEFERRED_COST

FISCAL_YEAR

 
TO_CHAR(TBRACCD_CSHR_END_DATE, 'HH24:MM:SS') NA

REPORTING VIEW

APPLICATION_OF_PAYMENT

RECEIVABLE_ACCOUNT_DETAIL

CASHIER_END_TIME

CASHIER_END_TIME

This calculation retrieves the 24 hour time from TBRACCD_CSHR_END_DATE.
TO_CHAR(TBRDEPO_CSHR_END_DATE, 'HH24:MM:SS') NA

REPORTING VIEW

DEPOSIT

CASHIER_END_TIME

This calculation retrieves the 24 hour time from TBRDEPO_CSHR_END_DATE.
TO_CHAR(TBRMISD_CSHR_END_DATE, 'HH24:MM:SS') NA

REPORTING VIEW

MISCELLANEOUS_TRANSACTION

CASHIER_END_TIME

This calculation retrieves the 24 hour time from TBRMISD_CSHR_END_DATE.
TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'), 'YYYY') NA

REPORTING VIEW

TRANSACTION_HISTORY

FISCAL_YEAR

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

REPORTING VIEW

TRANSACTION_HISTORY

FISCAL_YEAR_HEADER

This calculation transforms a two digit fiscal year into a 4 digit fiscal year for the transaction history record.
TO_CHAR(TRRACCD_CSHR_END_DATE, 'HH24:MM:SS') NA

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

CASHIER_END_TIME

This calculation retrieves the 24 hour time from TRRACCD_CSHR_END_DATE.
TTBTAXN_AMOUNT_3 * -1 NA

REPORTING VIEW

STUDENT_TAX_NOTIFICATION

PRIOR_YEAR_CHARGES_ADJUSTED

 
TTBTAXN_AMOUNT_5 * -1 NA

REPORTING VIEW

STUDENT_TAX_NOTIFICATION

PRIOR_YR_SCHOLARSHIP_GRANT_ADJ

 
COURSE_IDENTIFICATION ||'_' || NVL( OFFERING_NUMBER, PARM_REC.MTVPARM_EXTERNAL_CODE); NA        
SUBSTR(GORSDAV_PK_PARENTTAB,) TBD

REPORTING VIEW

SUPPLEMENTAL_DATA

SUPPLEMENTAL_DATA

SUPPLEMENTAL_DATA

SUPPLEMENTAL_DATA

SUPPLEMENTAL_DATA_SLOT

SUPPLEMENTAL_DATA_SLOT

SUPPLEMENTAL_DATA_SLOT

SUPPLEMENTAL_DATA_SLOT

SUPPLEMENTAL_DATA_SLOT

SUPPLEMENTAL_DATA

SUPPLEMENTAL_DATA

SUPPLEMENTAL_DATA_SLOT

PARENT_TABLE_PK_COL1

PARENT_TABLE_PK_COL3

PARENT_TABLE_PK_COL4

PARENT_TABLE_PK_COL5

PARENT_TABLE_PK_COL3

PARENT_TABLE_PK_COL1

PARENT_TABLE_PK_COL6

PARENT_TABLE_PK_COL2

PARENT_TABLE_PK_COL5

PARENT_TABLE_PK_COL2

PARENT_TABLE_PK_COL6

PARENT_TABLE_PK_COL4

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


Ver: 9.1