Banner Operational Data Store
Reporting View Source: CALCULATION - NULL
Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
(APPLIED_AMOUNT * (CLGR.PERCENT/100) * ( PLGR.PERCENT/100)) |
NA |
REPORTING VIEW |
APPL_OF_PAY_DETAIL_ACCOUNTING |
APPLIED_AMOUNT |
Calculates acutal amount applied to the transaction based upon accounting distribution percentages. |
(FGBOPAL_XX_ADOPT_BUD + FGBOPAL_XX_BUD_ADJT) - ( FGBOPAL_XX_YTD_ACTV + FGBOPAL_XX_ENCUMB + FGBOPAL_XX_BUD_RSRV) - (FGBOPAL_XX- 1_ADOPT_BUD + FGBOPAL_XX-1_BUD_ADJT) - ( FGBOPAL_XX-1_YTD_ACTV + FGBOPAL_XX- 1_ENCUMB + FGBOPAL_XX-1_BUD_RSRV) |
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_SUMMARY PURCHASE_ORDER_ITEM |
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 |
AUTHORIZATION_ACCOUNTING REIMBURSEMENT_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 |
FINANCIAL_AID_APPLICATION_IND FM_APPLICATION_IND IM_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_NON_COURSE AUDIT_COURSE_NEEDED EXCEPTION_APPLIED AUDIT_STUDENT_COURSE 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 |
ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING |
COMMITMENT_TYPE_DESC COMMITMENT_TYPE_DESC |
|
CASE WHEN FGBENCD_FIELD_CODE |
NA |
REPORTING VIEW |
AF_ENCUMBRANCE_ACCOUNTING |
FIELD_CODE_DESC |
|
CASE WHEN FTVVEND_CHECK_PIDM IS NULL |
NA |
REPORTING VIEW |
VENDOR AF_VENDOR AF_VENDOR |
REMIT_TO_ADDRESS_NUMBER 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_ACCOUNTING RECEIVABLE_ACCOUNT_DETAIL |
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 |
PLAN_TRACK_STATUS_DESC OFFICIAL_TRACKING_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 |
COURSE_PASSED_IND CREDIT_FOR_GPA_IND COURSE_ATTEMPTED_IND INCOMPLETE_GRADE_IND LAST_DATE_ATTEND_REQUIRED_IND COURSE_EARNED_IND REPEAT_EVALUATE_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 |
INCOMPLETE_GRADE_IND LAST_DATE_ATTEND_REQUIRED_IND COURSE_ATTEMPTED_IND COURSE_EARNED_IND CREDIT_FOR_GPA_IND REPEAT_EVALUATE_IND COURSE_PASSED_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 REPEAT_EVALUATE_IND CREDIT_FOR_GPA_IND COURSE_EARNED_IND COURSE_PASSED_IND COURSE_ATTEMPTED_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 RECEIVABLE_ACCOUNT_DETAIL RECEIVABLE_ACCOUNT_DETAIL |
TAX_DOCUMENT_BOX_NUMBER_PR_DESC TAX_DOCUMENT_BOX_NUMBER_SG_DESC 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 |
RECEIVABLE_ACCOUNTING APPLICATION_OF_PAYMENT APPLICATION_OF_PAYMENT |
DESIGNATOR_IND PAY_OPERATING_DESIGNATOR CHARGE_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 |
|
DAP_VALUE1 || DAP_VALUE2 |
NA |
REPORTING VIEW |
AUDIT_STUDENT_COURSE AUDIT_COURSE_NEEDED |
COURSE_IDENTIFICATION COURSE_IDENTIFICATION |
|
DAP_VALUE2 || DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID' |
NA |
REPORTING VIEW |
AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_COURSE AUDIT_COURSE_NEEDED |
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 EMPLOYEE_POSITION |
EXEMPTION_TYPE_DESC EXEMPTION_TYPE_DESC |
DECODE(NBBPOSN_EXEMPT_IND,'Y',DECODE(NTRPCLS_EXEMPT_IND,'Y','Exemption Position Class and Position Definition','Non-exempt Position Class and Position Definition'),DECODE(NTRPCLS_EXEMPT_IND,'Y','Exempt Class but overridden by the Position Definition','Non-exempt Position Class but overridden by the Position Definition')) |
DECODE (RCRAPP1_WARD_OF_COURT, '1', 'Y', 'N') |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
WARD_OF_COURT_IND |
|
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_TRANSACTION GIFT_MATCHING |
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_ADJUSTMENT_IND PLEDGE_VOID_IND |
|
DECODE(AGRPCON_MET_IND) |
NA |
REPORTING VIEW |
PLEDGE_CONDITIONAL |
CONDITION_MET_DESC |
|
DECODE(AGRPDES_AMT-AGRPDES_AMT_PAID) |
NA |
REPORTING VIEW |
PLEDGE |
PLEDGE_FULLY_PAID_IND |
NA |
DECODE(AGRPDES_AMT_PAID) |
NA |
REPORTING VIEW |
PLEDGE |
PLEDGE_PARTIAL_PAID_IND |
NA |
DECODE(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 GROUPING_DESC |
|
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_HISTORY FIXED_ASSET_ACCOUNTING_SOURCE |
DEPRECIATION_POSTING_STATUS DEPRECIATION_POSTING_STATUS |
This calculation evaluates the column FFRMASA_DEPR_POST_CODE. If it is an M, it will return Memo Post. If it is a P, it will return Post. If it is neither M nor P, it will return No Post. |
DECODE(FGBENCD_STATUS) |
FGIENCD |
REPORTING VIEW |
ENCUMBRANCE_ACCOUNTING |
ENCUMBRANCE_STATUS |
This calculation evaluates the column FGBENCD_STATUS. If it is a C, it will return Closed. Otherwise it will return Open. |
DECODE(FGBENCD_STATUS_IND) |
FGIENCD |
REPORTING VIEW |
ENCUMBRANCE_ACCOUNTING |
POSTABLE_IND |
This calculation evaluates the column FGBENCD_STATUS_IND. If it is a P, it will return Y. Otherwise, it will return an N. |
DECODE(FGBENCH_SOURCE_IND) |
FGIENCD |
REPORTING VIEW |
ENCUMBRANCE |
ENCUMBRANCE_SOURCE |
This calculation evaluates the column FGBENCH_SOURCE_IND. If it is an R, it will return Requisition. If it is a P, it will return Purchase Order. If it is an E, it will return Encumbrance. Otherwise, it will return Unknown Source. |
DECODE(FGBENCH_STATUS) |
FGIENCD |
REPORTING VIEW |
ENCUMBRANCE |
COMPLETE_IND |
This calculation evaluates the column FGBENCH_STATUS. If it is a C, it will return Y. Otherwise, it will return an N. |
DECODE(FGBENCH_STATUS_IND) |
FGIENCD |
REPORTING VIEW |
ENCUMBRANCE ENCUMBRANCE_ACCOUNTING |
ENCUMBRANCE_STATUS DOCUMENT_ENCUMBRANCE_STATUS |
This calculation will evaluate the column FGBENCH_STATUS_IND. If it is a C, it will return Closed. Otherwise it will return Open. |
DECODE(FNVENDW_REST_TYPE) |
NA |
REPORTING VIEW |
ENDOWMENT_UNITS ENDOWMENT_DISTRIBUTION |
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_UNITS ENDOWMENT_DISTRIBUTION |
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_FISCAL FUND_HIERARCHY |
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_EVENT GRANT_PERSONNEL |
BILL_FORMAT_TYPE_DESC BILL_FORMAT_TYPE_DESC |
|
DECODE(FTVATTT_STATUS_IND) |
FTMATTT |
REPORTING VIEW |
PROGRAM_ATTRIBUTES FUND_ATTRIBUTES ATTRIBUTE_SETS CHART_ATTRIBUTES LOCATION_ATTRIBUTES ORGANIZATION_ATTRIBUTES ACTIVITY_ATTRIBUTES ACCOUNT_ATTRIBUTES ACCOUNT_TYPE_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_FISCAL FUND_HIERARCHY |
FUND_BALANCE_DESC FUND_BALANCE_DESC |
|
DECODE(FTVFSPD_PRD_STATUS_IND) |
NA |
REPORTING VIEW |
BUDGET_AVAILABILITY_LEDGER OPERATING_LEDGER GENERAL_LEDGER |
FISCAL_PERIOD_STATUS_DESC FISCAL_PERIOD_STATUS_DESC FISCAL_PERIOD_STATUS_DESC |
|
DECODE(FTVFUND_REST_IND) |
NA |
REPORTING VIEW |
FUND_HIERARCHY_FISCAL FUND_HIERARCHY |
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_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT |
PENDING_LETTER_IND1 PENDING_LETTER_IND2 PENDING_LETTER_IND5 PENDING_LETTER_IND PENDING_LETTER_IND3 PENDING_LETTER_IND4 |
NA |
DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL') |
SUAMAIL |
REPORTING VIEW |
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT |
COMMUNICATION_TYPE_DESC4 COMMUNICATION_TYPE_DESC1 COMMUNICATION_TYPE_DESC5 COMMUNICATION_TYPE_DESC COMMUNICATION_TYPE_DESC2 COMMUNICATION_TYPE_DESC3 |
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 EMPLOYEE_POSITION |
POSITION_CONTRACT_TYPE_DESC POSITION_CONTRACT_TYPE_DESC |
This function returns Primary if the contract type NBRBJOB_CONTRACT_TYPE is P, Secondary if it is S and Overload if it is O. |
DECODE(NBRJOBS_PERS_PAY_CODE) |
NA |
REPORTING VIEW |
EMPLOYEE_POSITION |
PUBLIC_RETIRE_PAY_RATE_DESC |
SUBSTR(DECODE(P.NBRJOBS_PERS_PAY_CODE, '01', G$_NLS.GET('x','SQL','Monthly Pay Rate'), '02', G$_NLS.GET('x','SQL','Monthly Pay Rate (LA)'), '04', G$_NLS.GET('x','SQL','Hourly Pay Rate'), '08', G$_NLS.GET('x','SQL','Daily Pay Rate'), '09', G$_NLS.GET('x','SQL','Miscellaneous Pay Rate')),1,30), |
DECODE(NBRJOBS_STATUS) |
NA |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET EMPLOYEE |
POSITION_STATUS_DESC POSITION_STATUS_DESC POSITION_STATUS_DESC |
This function return Active if the employee status NBRJOBS_STATUS is A, Leave withoutpay and with benefit if it is B, Leave without pay and without benefit if it is L, Leave with pay and with benefit if it is F, Leave with part pay and with benefit if it is P, Terminated if it is T. |
DECODE(NBRJOBS_STRS_PAY_CODE) |
NA |
REPORTING VIEW |
EMPLOYEE_POSITION |
STATE_RETIREMENT_PAY_RATE_DESC |
SUBSTR(DECODE(P.NBRJOBS_STRS_PAY_CODE, '0', G$_NLS.GET('x','SQL','Annual or Lump Sum'), '1', G$_NLS.GET('x','SQL','12 Monthly Payments'), '2', G$_NLS.GET('x','SQL','11 Monthly Payments'), '3', G$_NLS.GET('x','SQL','10 Monthly Payments'), '4', G$_NLS.GET('x','SQL','Hourly Rate'), '7', G$_NLS.GET('x','SQL','13 Payments'), '8', G$_NLS.GET('x','SQL','Daily Rate')),1,30), |
DECODE(NBRPTOT_STATUS,'A',APPROVED,'C', CLOSED,'T',TRANSFERRED,'W',WORKING) |
NA |
REPORTING VIEW |
PAYROLL_DISTRIBUTION POSITION_BUDGET |
BUDGET_STATUS_DESC BUDGET_STATUS_DESC |
This function returns APPROVED if the status NBRPTOT_STATUS is A, CLOSED if it is C, TRANSFERRED if it is T and WORKING if it is W. |
DECODE(NHRDIST_HIST_TYPE_IND) |
NA |
REPORTING VIEW |
PAYROLL_DISTRIBUTION |
PAYROLL_EVENT_TYPE_DESC |
SUBSTR(DECODE(NHRDIST_HIST_TYPE_IND, 'J', G$_NLS.GET('x','SQL','Adjusted'), 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Original'), 'R', G$_NLS.GET('x','SQL','Redistributed'), 'I', G$_NLS.GET('x','SQL','Reissued'), 'V', G$_NLS.GET('x','SQL','Voided')),1,30) |
DECODE(NORMAL_BALANCE) |
NA |
REPORTING VIEW |
PAYROLL_DISTRIBUTION |
NORMALIZED_TRANSACTION_AMOUNT |
NA |
DECODE(NVL(AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'N', NVL(AGVPLG1_PLEDGE_AMOUNT,0) , 'N','Y') |
NA |
|
|
|
NA |
DECODE(NVL(RCRIMP1_TRUST_AVAIL_IND, RCRTRUS_AVAILABLE)) |
NA |
|
|
|
|
DECODE(PAYROLL_DEDUCTION) |
NA |
REPORTING VIEW |
YEARLY_DEDUCTION YEARLY_DEDUCTION |
EMPLOYER_CONTRIBUTION_YTD GROSS_COMPENSATION_YTD |
SUM(NVL(DECODE(PAYROLL_DEDUCTION_MONTH, 1, EMPLOYEE_CONTRIBUTION_AMOUNT, 2, EMPLOYEE_CONTRIBUTION_AMOUNT, 3, EMPLOYEE_CONTRIBUTION_AMOUNT,0),0)) |
DECODE(PDRDEDN_STATUS,'A','ACTIVE','B', 'EXEMPT','W','WAIVE','T','TERMINATED',') |
NA |
REPORTING VIEW |
BENEFIT_DEDUCTION |
STATUS_DESC |
This function returns ACTIVE if the status PDRDEDN_STATUS is A, EXEMPT if the status is B WAIVE if the status is W or TERMINATED if the status is T. |
DECODE(PDRDEDN_STATUS,'A','ACTIVE','B', 'EXEMPT','W','WAIVED','T','TERMINATED') |
NA |
REPORTING VIEW |
TAX |
STATUS_DESC |
NA |
DECODE(PEBEMPL_1042_RECIPIENT_CD) |
NA |
REPORTING VIEW |
EMPLOYEE |
FOREIGN_INCOME_RECIPIENT_DESC |
This function returns Individual if the 1042 receipient code PEBEMPL_1042_RECIPIENT_CD is 01, Corporation if it is 02, Partnership if it is 03, Fiduciary if it is 04, Nominee if it is 05, Govt or International Organization if iti 06, Tax Exempt Organization if it is 07, Private Foundation if it 08, Artist or athlete if it is 09, Other if it is 19, Type of recipient unknown if it is 20. |
DECODE(PEBEMPL_CALIF_PENSION_IND) |
NA |
REPORTING VIEW |
EMPLOYEE |
PUBLIC_RETIREMENT_MEMBER_DESC |
|
DECODE(PEBEMPL_EMPL_STATUS) |
NA |
REPORTING VIEW |
EMPLOYEE |
EMPLOYEE_STATUS_DESC |
This function return Active if the employee status PEBEMPL_EMPL_STATUS is A, Leave withoutpay and with benefit if it is B, Leave without pay and without benefit if it is L, Leave with pay and with benefit if it is F, Leave with part pay and with benefit if it is P, Terminated if it is T. |
DECODE(PEBEMPL_FLSA_IND) |
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(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_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
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_POSITION_TIMESHEET PAYROLL_EARNING |
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_ACTIVE_DUTY,'1','Y','N') |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ACTIVE_DUTY_IND |
|
DECODE(RCRAPP1_AT_RISK_HOMELESS,'1', 'Y','N') |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
AT_RISK_HOMELESS_IND |
|
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_EMANCIPATED_MINOR,'1', 'Y','N') |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
EMANCIPATED_MINOR_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_LEGAL_GUARDIAN,'1', 'Y', 'N') |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
LEGAL_GUARDIAN_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_DESC APPLICATION_SIGNED_BY |
|
DECODE(RCRAPP1_TAX_FORM_IND) |
RNANAXX |
|
|
|
|
DECODE(RCRAPP1_TITLE) |
RNASUXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
NAME_PREFIX |
|
DECODE(RCRAPP1_UNACCOMP_YOUTH_HUD,'1', 'Y','N') |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
UNACCOMPANIED_YOUTH_HUD_IND |
|
DECODE(RCRAPP1_UNACCOMP_YOUTH_SCHOOL, '1', 'Y','N') |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
UNACCOMPANIED_YOUTH_SCHOOL_IND |
|
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_FEDERAL_METHOD NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS NEED_ANALYSIS |
FM_FAMILY_SIZE FAMILY_IN_COLLEGE 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_DEMOGRAPHIC NEED_ANALYSIS |
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_10) |
NA |
|
|
|
|
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_FED_HOUS_CDE_7) |
NA |
|
|
|
|
DECODE(RCRESAR_FED_HOUS_CDE_8) |
NA |
|
|
|
|
DECODE(RCRESAR_FED_HOUS_CDE_9) |
NA |
|
|
|
|
DECODE(RCRESAR_M_SCHOOL_FLAG_1) |
NA |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MULTI_SCHOOL_FLAG1_DESC |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_10) |
NA |
|
|
|
|
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_M_SCHOOL_FLAG_7) |
NA |
|
|
|
|
DECODE(RCRESAR_M_SCHOOL_FLAG_8) |
NA |
|
|
|
|
DECODE(RCRESAR_M_SCHOOL_FLAG_9) |
NA |
|
|
|
|
DECODE(RCRESAR_REC_TYPE) |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PROCESSED_RECORD_TYPE_DESC |
|
DECODE(RCRESAR_SEC_EFC_TYPE) |
NA |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
SECONDARY_EFC_TYPE_DESC |
|
DECODE(RCRESAR_SUB_APP) |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
SUBSEQUENT_APPLICATION_IND |
|
DECODE(RCRIMP1_AID_STATUS) |
RNASUXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
FINANCIAL_AID_STATUS_DESC |
|
DECODE(RCRIMP1_APPLIC_TYPE) |
RNASUXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_PROFILE_SPECIFIC |
APPLICATION_TYPE_DESC APPLICATION_TYPE_DESC |
|
DECODE(RCRIMP1_FIN_AID_STATUS) |
RNASUXX |
|
|
|
|
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(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_PERSON FINAID_FUND AWARD_BY_FUND AWARD_BY_PERSON FINAID_FUND AWARD_BY_FUND FINAID_FUND |
GIFT_OR_SELF_HELP_AID FINANCIAL_AID_TYPE_DESC GIFT_OR_SELF_HELP_AID_DESC GIFT_OR_SELF_HELP_AID_DESC GIFT_OR_SELF_HELP_AID 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_ADMISSIONS GOVERNMENT_STUDENT |
INTENDED_TIME_STATUS_DESC INTENDED_TIME_STATUS_DESC |
NA |
DECODE(SFBETRM_AR_IND) |
TBD |
REPORTING VIEW |
ENROLLMENT STUDENT |
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 STUDENT STUDENT_EXTENDED ACADEMIC_STUDY_EXTENDED VETERAN_CERTIFICATION ENROLLMENT |
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_BY_TERM GPA |
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 ACADEMIC_STUDY_EXTENDED |
MATRICULATED_IND MATRICULATED_IND |
DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,'N','Y') |
DECODE(SPBPERS_NAME_PREFIX,NULL,DECODE( SPBPERS_SEX,'M','MR.','F','MS.'), SPBPERS_NAME_PREFIX) |
NA |
REPORTING VIEW |
CONSTITUENT |
NAME_PREFIX |
This function returns Mr. or Ms. Based on the gender if the name prefix SPBPERS_NAME_PREFIX is null, else it returns the name prefix. |
DECODE(SPBPERS_SEX,'M','MALE','F', 'FEMALE','N','NOT REPORTED') |
SPAPERS |
REPORTING VIEW |
PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_FINANCIAL_AID PERSON PERSON_SENSITIVE GOVERNMENT_STUDENT |
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 PERSON_DETAIL |
ID_SOURCE ID_SOURCE |
This function returns null if the id SPRIDEN_ID is null else it returns BANNER. |
DECODE(SPRMEDI_DISB_IND,'Y','Y','N') |
SPAMEDI |
|
|
|
NA |
DECODE(SSRFEES_FEE_IND) |
SSADETL |
REPORTING VIEW |
COURSE_OFFERING_FEES |
FEE_METHOD_DESC |
|
DECODE(STVAPDC_APPL_INACT) |
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 |
GOVERNMENT_ADMISSIONS ADMISSIONS_DECISION |
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 ADMISSIONS_SOURCE RECRUITMENT_SOURCE |
INSTITUTION_TYPE_DESC INSTITUTION_TYPE_DESC ADMISSIONS_SOURCE_TYPE_DESC RECRUIT_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. |
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 |
LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+ RCRAPP2_C_PAR_1_CTRB_FOR_STDT) |
NA |
|
|
|
LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT) |
LEVEL |
FTMFUND |
REPORTING VIEW |
FUND_HIERARCHY_FISCAL ORGANIZATION_HIERARCHY ACCOUNT_HIERARCHY FUND_HIERARCHY ACCOUNT_HIERARCHY_FISCAL PROGRAM_HIERARCHY_FISCAL LOCATION_HIERARCHY_FISCAL PROGRAM_HIERARCHY ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL FUND_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL FUND_HIERARCHY_FISCAL LOCATION_HIERARCHY |
FUND_TYPE_LEVEL ORGANIZATION_LEVEL ACCOUNT_TYPE_LEVEL FUND_LEVEL ACCOUNT_LEVEL PROGRAM_LEVEL LOCATION_LEVEL PROGRAM_LEVEL ACCOUNT_LEVEL ACCOUNT_TYPE_LEVEL FUND_TYPE_LEVEL ORGANIZATION_LEVEL FUND_LEVEL LOCATION_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_SLOT SPECIAL_ACTIVITY |
LAST_YEAR2 LAST_YEAR3 LAST_YEAR1 LAST_YEAR |
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 PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT |
YEARS_MONTHS_IN_POSITION3 YEARS_MONTHS_IN_POSITION1 YEARS_MONTHS_IN_POSITION4 YEARS_MONTHS_IN_POSITION2 MONTHS_IN_POSITION |
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 (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE) |
NA |
REPORTING VIEW |
PREVIOUS_EDUCATION_ATTENDANCE |
TRANSCRIPT_RECEIVED_DATE |
NVL (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE) returns transfer received date and if null, then returns prior college transcript received date. |
NVL(ADBDESG_WEB_GIFT_IND,'N') |
NA |
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_TRANSACTION PLEDGE |
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 |
CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT |
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_TRANSACTION PLEDGE_MATCHING |
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_ITEM_ACCOUNTING INVOICE_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_ACCOUNTING PURCHASE_ORDER_ITEM_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_ITEM_ACCOUNTING PURCHASE_ORDER_ACCOUNTING |
CONVERTED_TAX_AMOUNT CONVERTED_TAX_AMOUNT |
|
NVL(FPRPODA_DISC_AMT,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING PURCHASE_ORDER_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_ACCOUNTING PURCHASE_ORDER_ITEM_ACCOUNTING |
TAX_AMOUNT TAX_AMOUNT |
|
NVL(FPRPODT_ADDL_CHRG_AMT,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM |
ADDITIONAL_AMOUNT ADDITIONAL_AMOUNT ADDITIONAL_CHARGES_AMOUNT |
|
NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
CONVERTED_ADDITNAL_AMOUNT |
|
NVL(FPRPODT_CONVERT_DISC_AMT,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
CONVERTED_DISCOUNT_AMOUNT |
|
NVL(FPRPODT_CONVERT_TAX_AMT,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
CONVERTED_TAX_AMOUNT |
|
NVL(FPRPODT_CONVERT_UNIT_PRICE,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
CONVERTED_UNIT_PRICE |
|
NVL(FPRPODT_DESC_CHGE_IND,'N') |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
COMMODITY_DESC_CHANGE_IND |
|
NVL(FPRPODT_DISC_AMT,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
DISCOUNT_AMOUNT |
|
NVL(FPRPODT_LIQ_AMT,0) |
NA |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
LIQUIDATION_AMOUNT |
|
NVL(FPRPODT_QTY,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
QUANTITY |
|
NVL(FPRPODT_TAX_AMT,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
TAX_AMOUNT |
|
NVL(FPRPODT_UNIT_PRICE,0) |
FPAPURR |
REPORTING VIEW |
PURCHASE_ORDER_ITEM |
UNIT_PRICE |
|
NVL(FPRRCDT_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 |
BUDGET_AVAILABILITY_LEDGER BUDGET_AVAILABILITY_LEDGER GRANT_LEDGER ACCOUNT_HIERARCHY OPERATING_LEDGER BUDGET_DETAIL TRANSACTION_HISTORY GRANT_LEDGER ACCOUNT_HIERARCHY_FISCAL GENERAL_LEDGER GENERAL_LEDGER OPERATING_LEDGER TRANSACTION_HISTORY |
ACCOUNT_POOL ORIG_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 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 |
FUND_HIERARCHY_FISCAL GENERAL_LEDGER BUDGET_DETAIL FUND_HIERARCHY OPERATING_LEDGER OPERATING_LEDGER BUDGET_AVAILABILITY_LEDGER BUDGET_AVAILABILITY_LEDGER GRANT_LEDGER GENERAL_LEDGER GRANT_LEDGER TRANSACTION_HISTORY |
FUND_POOL FUND_POOL FUND_POOL FUND_POOL FUND_POOL ORIG_FUND_POOL FUND_POOL ORIG_FUND_POOL ORIG_FUND_POOL ORIG_FUND_POOL FUND_POOL ORIG_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 |
ORGANIZATION_HIERARCHY_FISCAL OPERATING_LEDGER OPERATING_LEDGER TRANSACTION_HISTORY GRANT_LEDGER ORGANIZATION_HIERARCHY BUDGET_AVAILABILITY_LEDGER BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL |
ORGANIZATION_POOL ORGANIZATION_POOL ORIG_ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL ORGANIZATION_POOL ORIG_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 |
VENDOR AF_VENDOR |
VENDOR_TERMINATION_DATE VENDOR_TERMINATION_DATE |
|
NVL(FTVVEND_VEND_CHECK_PIDM, FTVVEND_PIDM) |
NA |
REPORTING VIEW |
VENDOR AF_VENDOR |
REMIT_TO_VENDOR_UID 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_SLOT COMMUNICATION_SLOT COMMUNICATION |
DATE_SENT3 DATE_SENT1 DATE_SENT5 DATE_SENT4 DATE_SENT2 DATE_SENT |
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_POSITION EMPLOYEE |
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(RCRAPP1_EXP_ACYR_INC, RCRSARI_EXP_ACYR_INC) |
NA |
|
|
|
|
NVL(RCRAPP1_EXP_ACYR_OTH_TAX_INC, RCRSARI_EXP_ACYR_OTH_TAX_INC) |
NA |
|
|
|
|
NVL(RCRAPP1_EXP_ACYR_UNTAX_INC, RCRSARI_EXP_ACYR_UNTAX_INC) |
NA |
|
|
|
|
NVL(RCRAPP1_EXP_SMR_INC, RCRSARI_EXP_SUMMER_INC) |
NA |
|
|
|
|
NVL(RCRAPP1_EXP_SMR_OTH_TAX_INC, RCRSARI_EXP_SMR_OTH_TAX_INC) |
NA |
|
|
|
|
NVL(RCRAPP1_EXP_SMR_UNTAX_INC, RCRSARI_EXP_SMR_UNTAX_INC) |
NA |
|
|
|
|
NVL(RCRAPP1_HME_DBT,RCRHOME_DEBT) |
NA |
|
|
|
|
NVL(RCRAPP1_HME_VAL,RCRHOME_VALUE) |
NA |
|
|
|
|
NVL(RCRAPP1_PAR_HME_DBT, RCRHOME_PAR_DEBT) |
NA |
|
|
|
|
NVL(RCRAPP1_PAR_HME_PURCH_AMT, RCRHOME_PAR_PURCHASE_AMOUNT) |
NA |
|
|
|
|
NVL(RCRAPP1_PAR_HME_VAL, RCRHOME_PAR_VALUE) |
NA |
|
|
|
|
NVL(RCRAPP1_PAR_HME_YR_PURCH, RCRHOME_PAR_YEAR_PURCHASE) |
NA |
|
|
|
|
NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL( RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0) |
NA |
REPORTING VIEW |
NEED_ANALYSIS |
INAS_TFC |
NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL(RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0) |
NVL(RCRAPP3_IRS_AGI_FLAG, RCRIRSF_IRS_AGI_FLAG) |
NA |
|
|
|
|
NVL(RCRAPP3_IRS_DISPLAY_FLAG, RCRIRSF_IRS_DISPLAY_FLAG) |
NA |
|
|
|
|
NVL(RCRAPP3_IRS_FIT_FLAG, RCRIRSF_IRS_FIT_FLAG) |
NA |
|
|
|
|
NVL(RCRAPP3_IRS_REQUEST_FLAG, RCRIRSF_IRS_REQUEST_FLAG) |
NA |
|
|
|
|
NVL(RCRAPP3_PAR_IRS_AGI_FLAG, RCRIRSF_PAR_IRS_AGI_FLAG) |
NA |
|
|
|
|
NVL(RCRAPP3_PAR_IRS_DISPLAY_FLAG, RCRIRSF_PAR_IRS_DISPLAY_FLAG) |
NA |
|
|
|
|
NVL(RCRAPP3_PAR_IRS_FIT_FLAG, RCRIRSF_PAR_IRS_FIT_FLAG) |
NA |
|
|
|
|
NVL(RCRAPP3_PAR_IRS_REQUEST_FLAG, RCRIRSF_PAR_IRS_REQUEST_FLAG) |
NA |
|
|
|
|
NVL(RCRAPP4_DUP_SSN_IND) |
TBD |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
DUPLICATE_TAX_ID_IND |
|
NVL(RCRAPP4_HME_PURCH_AMT, RCRHOME_PURCHASE_AMOUNT) |
NA |
|
|
|
|
NVL(RCRAPP4_HME_YR_PURCH, RCRHOME_YEAR_PURCHASE) |
NA |
|
|
|
|
NVL(RCRAPP4_PUSH_ISIR_FLAG) |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
CPS_ISIR_PUSHED_IND |
|
NVL(RCRESAR_AGENCY_IND,SUBSTR((SELECT RCRLOAD_TEXT_VALUE FROM RCRLOAD WHERE RCRLOAD_FIELD_CODE = 'APPLICATION_SOURCE' |
TBD |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
APPLICATION_SOURCE_SITE |
|
NVL(RCRESAR_AUTO_ZERO_EFC_FLAG) |
TBD |
|
|
|
|
NVL(RCRESAR_MDE_SITE_CD, SUBSTR((SELECT RCRLOAD_TEXT_VALUE FROM RCRLOAD WHERE RCRLOAD_FIELD_CODE = 'TRANSACTION_SOURCE' |
TBD |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
TRANSACTION_SITE_SOURCE |
|
NVL(RCRESAR_SUB_APP) |
RNIMSXX |
|
|
|
|
NVL(RCRESAR_VERIF_CHANGE_IND) |
RNARSXX RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
VERIFICATION_SELECT_CHANGE_IND |
|
NVL(RCRIMP1_EXP_GRANT_SCHLRSHP, RCRSARI_EXP_GRANT_SCHOLARSHIP) |
NA |
|
|
|
|
NVL(RCRIMP1_EXP_OTH_CTRB, RCRSARI_EXP_OTH_CTRB) |
NA |
|
|
|
|
NVL(RCRIMP1_EXP_PAR_CTRB, RCRSARI_EXP_PAR_CTRB) |
NA |
|
|
|
|
NVL(RCRIMP1_EXP_TUIT_BENE, RCRSARI_EXP_TUITION_BENEFITS) |
NA |
|
|
|
|
NVL(RCRIMP1_TRUST_AMT,RCRTRUS_AMOUNT) |
NA |
|
|
|
|
NVL(RCRIMP1_TRUST_ESTAB_BY, RCRTRUS_ESTABLISHED_BY) |
NA |
|
|
|
|
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_EXTENDED ACADEMIC_STUDY |
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_EXTENDED ACADEMIC_STUDY |
LEAVE_DATE_TO LEAVE_DATE_TO |
Retrieve end date of the student leave from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur. |
NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE) |
MULTIPLE |
REPORTING VIEW |
ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED |
STUDENT_RATE STUDENT_RATE |
Retrieve student rate from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur. |
NVL(SORLCUR_SITE_CODE,SGBSTDN_SITE_CODE) |
NA |
REPORTING VIEW |
ACADEMIC_STUDY_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 ACADEMIC_STUDY_EXTENDED |
GRAD_ACADEMIC_PERIOD_INTENDED GRAD_ACADEMIC_PERIOD_INTENDED |
Retrieve intended graduation term from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur. |
NVL(SPRIDEN_LAST_NAME,'STAFF') |
SIAASGN |
REPORTING VIEW |
GOVERNMENT_COURSE INSTRUCT_ASSIGN_SLOT INSTRUCTIONAL_ASSIGNMENT INSTRUCT_ASSIGN_SLOT SCHEDULE_OFFERING INSTRUCT_ASSIGN_SLOT |
INSTRUCTOR_LAST_NAME INSTRUCTOR_LAST_NAME2 INSTRUCTOR_LAST_NAME INSTRUCTOR_LAST_NAME3 PRIMARY_INSTRUCTOR_LAST_NAME PRIMARY_INSTRUCTOR_LAST_NAME |
This function returns the instructor''s last name SPRIDEN_LAST_NAME if it exists, else STAFF. |
NVL(SPRIDEN_MI,'STAFF') |
MULTIPLE |
REPORTING VIEW |
INSTRUCT_ASSIGN_SLOT |
PRIMARY_INSTRUCTOR_MIDDLE_NAME |
Retrieve the instructor''s last name SPRIDEN_LAST_NAME if it exists, else set to STAFF. |
NVL(SSBOVRR_COLL_CODE,SCBCRSE_COLL_CODE) |
SSAOVRR |
|
|
|
This function returns the override college SSBOVRR_COLL_CODE if it exists, else it returns the course college SCBCRSE_COLL_CODE. |
NVL(SSBOVRR_DEPT_CODE,SCBCRSE_DEPT_CODE) |
SSAOVRR |
|
|
|
This function returns the override department SSBOVRR_DEPT_CODE if it exists, else it returns the department SCBCRSE_DEPT_CODE. |
NVL(SSBOVRR_DIVS_CODE,SCBCRSE_DIVS_CODE) |
SSAOVRR |
|
|
|
This function returns the override division SSBOVRR_DIVS_CODE if it exists, else it returns the course division SCBCRSE_DIVS_CODE. |
NVL(SSBSECT_CONT_HR, SCBCRSE_CONT_HR_HIGH) |
SCACRSE |
REPORTING VIEW |
GOVERNMENT_COURSE |
TOTAL_CONTACT_HOURS |
NA |
NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE) |
SCACRSE |
REPORTING VIEW |
GOVERNMENT_COURSE |
COURSE_TITLE_SHORT |
NA |
NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH) |
SCACRSE |
REPORTING VIEW |
GOVERNMENT_COURSE |
LAB_CONTACT_HOURS |
NA |
NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH) |
SCACRSE |
REPORTING VIEW |
GOVERNMENT_COURSE |
LECTURE_CONTACT_HOURS |
NA |
NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH) |
SCACRSE |
REPORTING VIEW |
GOVERNMENT_COURSE |
OTHER_CONTACT_HOURS |
NA |
NVL(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 |
GOVERNMENT_ADMISSIONS ACADEMIC_OUTCOME ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION |
CURRICULUM_ORDER CURRICULUM_ORDER CURRICULUM_ORDER CURRICULUM_ORDER |
|
SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB |
SCACRSE |
REPORTING VIEW |
COURSE_CATALOG COURSE_PREREQ STUDENT_WORK_EXPERIENCE REGISTRATION_PLAN_COURSE |
COURSE_IDENTIFICATION COURSE_IDENTIFICATION_PREREQ COURSE_IDENTIFICATION COURSE_IDENTIFICATION |
This concatenates the course subject code with the course number from the SCBCRSE record. |
SCBSUPP_SUBJ_CODE||SCBSUPP_CRSE_NUMB |
SCADETL |
|
|
|
This concatenates the course subject code with the course number from the SCBSUPP record. |
SCRATTR_SUBJ_CODE||SCRATTR_CRSE_NUMB |
SCADETL |
REPORTING VIEW |
COURSE_ATTRIBUTE |
COURSE_IDENTIFICATION |
NA |
SCRCORQ_SUBJ_CODE_CORQ||SCRCORQ_CRSE_NUM B_CORQ |
SCADETL |
REPORTING VIEW |
COURSE_COREQ |
COURSE_IDENTIFICATION_COREQ |
This concatenates the course subject code co-requisite with the course number co-requisite from the SCRCORQ record. |
SCRCORQ_SUBJ_CODE||SCRCORQ_CRSE_NUMB |
SCADETL |
REPORTING VIEW |
COURSE_COREQ |
COURSE_IDENTIFICATION |
This concatenates the course subject code with the course number from the SCRCORQ record. |
SCRGMOD_SUBJ_CODE||SCRGMOD_CRSE_NUMB, |
SSASECT |
|
|
|
This concatenates the course subject code with the course number from the SGRGMOD record. |
SCRLEVL_SUBJ_CODE||SCRLEVL_CRSE_NUMB |
SCACRSE |
REPORTING VIEW |
COURSE_LEVEL |
COURSE_IDENTIFICATION |
This concatenates the course subject code with the course number from the SCRLEVL record. |
SCRRTST_SUBJ_CODE||SCRRTST_CRSE_NUMB |
SCAPREQ |
REPORTING VIEW |
COURSE_PREREQ_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_DETAIL STUDENT_COURSE FACULTY_FEEDBACK |
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_ATT_SLOT STUDENT_COURSE_ATTRIBUTE |
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_GRADE_CHANGE STUDENT_COURSE |
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 STUDENT_COURSE_GRADE_CHANGE |
QUALITY_POINTS QUALITY_POINTS |
This calculates the credit hours passed by the student. |
SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB |
SHAINST |
REPORTING VIEW |
STUDENT_COURSE_GRADE_CHANGE GOVERNMENT_COURSE STUDENT_COURSE STUDENT_COURSE_ATTRIBUTE |
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 |
REMIT_TO_PHONE_NUMBER_COMBINED ORDER_FROM_PHONE_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 ORGANIZATION_CONTACT ORGANIZATION_ENTITY REFERENCE CONSTITUENT_ENTITY GRANT_PERSONNEL ADDRESS_PREFERRED PERSON TELEPHONE TELEPHONE_CURRENT |
PHONE_NUMBER_COMBINED FAX_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED |
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 |
OFFERING_COREQ STUDENT_COURSE_REG_AUDIT COURSE_OFFERING_FEES GOVERNMENT_COURSE BLOCK_REGISTRATION_COURSE MEETING_TIME OFFERING_GRADE_TYPE OFFERING_PREREQ 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_REJECTED_TO_DATE QUANTITY_RECEIVED_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 |
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 |
|
TTBTAXN_AMOUNT_6 * -1 |
NA |
REPORTING VIEW |
STUDENT_TAX_NOTIFICATION |
PRIOR_YEAR_PAYMENT_ADJ |
|
CASE WHEN RLRDDAS_DISB_SEQ_NO |
NA |
REPORTING VIEW |
LOAN_DISBURSEMENT_DETAIL |
RECORD_SOURCE |
|
SUBSTR(GORSDAV_PK_PARENTTAB,) |
TBD |
REPORTING VIEW |
SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA_SLOT
SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA_SLOT
SUPPLEMENTAL_DATA_SLOT SUPPLEMENTAL_DATA
SUPPLEMENTAL_DATA_SLOT SUPPLEMENTAL_DATA_SLOT
SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA_SLOT
|
PARENT_TABLE_PK_COL4 PARENT_TABLE_PK_COL3
PARENT_TABLE_PK_COL1 PARENT_TABLE_PK_COL3
PARENT_TABLE_PK_COL5 PARENT_TABLE_PK_COL1
PARENT_TABLE_PK_COL2 PARENT_TABLE_PK_COL2
PARENT_TABLE_PK_COL6 PARENT_TABLE_PK_COL5
PARENT_TABLE_PK_COL6 PARENT_TABLE_PK_COL4
|
This calculation retrieves the portion of the composite primary key-GORSDAV_PK_PARENTTAB. |