Banner Operational Data Store
Composite View Source: CALCULATION - NULL
Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
(APPLIED_AMOUNT * (CLGR.PERCENT/100) * ( PLGR.PERCENT/100)) |
NA |
NO |
|
|
|
|
Calculates acutal amount applied to the transaction based upon accounting distribution percentages. |
(FGBOPAL_XX_ADOPT_BUD + FGBOPAL_XX_BUD_ADJT) - ( FGBOPAL_XX_YTD_ACTV + FGBOPAL_XX_ENCUMB + FGBOPAL_XX_BUD_RSRV) - (FGBOPAL_XX- 1_ADOPT_BUD + FGBOPAL_XX-1_BUD_ADJT) - ( FGBOPAL_XX-1_YTD_ACTV + FGBOPAL_XX- 1_ENCUMB + FGBOPAL_XX-1_BUD_RSRV) |
NA |
NO |
|
|
|
|
|
(FGBOPAL_XX_ADOPT_BUD+ FGBOPAL_XX_BUD_ADJT)-( FGBOPAL_XX_YTD_ACTV+FGBOPAL_XX_ENCUMB+ FGBOPAL_XX_BUD_RSRV) |
FGIBDST |
NO |
COMPOSITE VIEW |
AF_OPERATING_LEDGER |
SUM_REMAINING_BALANCE |
NO |
This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes all activity up to and including this period. |
(FRRGRNL_XX_ADOPT_BUD + FRRGRNL_XX_BUD_ADJT - FRRGRNL_XX_YTD_ACTV - FRRGRNL_XX_ENCUMB - FRRGRNL_XX_BUD_RSRV) |
FRIGITD |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
SUM_REMAINING_BALANCE |
NO |
This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes all activity up to and including this period. |
(FRRGRNL_XX_ADOPT_BUD + FRRGRNL_XX_BUD_ADJT) - ( FRRGRNL_XX_YTD_ACTV + FRRGRNL_XX_ENCUMB + FRRGRNL_XX_BUD_RSRV) - (FRRGRNL_XX- 1_ADOPT_BUD + FRRGRNL_XX-1_BUD_ADJT) - ( FRRGRNL_XX-1_YTD_ACTV + FRRGRNL_XX- 1_ENCUMB + FRRGRNL_XX-1_BUD_RSRV) |
FRIGITD |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
CURR_REMAINING_BALANCE |
NO |
This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes only activity in this period. |
(MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES + MAKFUNC.F_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100 |
NA |
NO |
|
|
|
|
|
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100 |
NA |
NO |
|
|
|
|
|
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFRDESG_GOAL * 100 |
NA |
NO |
|
|
|
|
|
(MAKFUNC.F_ORG_TOTAL_GIFTS + MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100 |
NA |
NO |
|
|
|
|
|
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100 |
NA |
NO |
|
|
|
|
|
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFRCSOL_GOAL * 100 |
NA |
NO |
|
|
|
|
|
(MAKFUNC.F_SOL_FR_TOTAL_PLEDGES + MAKFUNC.F_SOL_FR_TOTAL_GIFTS + MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100 |
NA |
NO |
|
|
|
|
|
(NVL(FARINVC_APPR_QTY,0)*NVL( FARINVC_APPR_UNIT_PRICE,0))+NVL( FARINVC_ADDL_CHRG_AMT,0)+NVL( FARINVC_TAX_AMT,0)-NVL(FARINVC_DISC_AMT, 0) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE_ITEM |
APPROVED_ITEM_AMOUNT |
NO |
This calculation returns the approved item amount for the invoice item. The amount is calculated as the approved quantity multiplied by the unit price plus any additional charges and tax amount and then subtracting any discount. |
(NVL(FBVBLDL_BUDG_AMT,0)+NVL( FBVBLDL_ADJT_AMT,0)) |
FBABDMN |
NO |
COMPOSITE VIEW |
AF_BUDGET_DETAIL |
BUDGET_AMOUNT |
NO |
This calculation returns the budgeted amount by adding the original budget to any budget adjustments. |
(NVL(FPRPODT_QTY,0)*NVL( CONVERTED_FPRPODT_UNIT_PRICE,0))+NVL( FPRPODT_CONVERTED_ADDL_CHRG_AMT,0)+NVL( FPRPODT_CONVERTED_TAX_AMT,0)-NVL( FPRPODT_CONVERTED_DISC_AMT,0) |
FPAPURR |
NO |
|
|
|
|
|
(NVL(FPRPODT_QTY,0)*NVL( FPRPODT_UNIT_PRICE,0))+NVL( FPRPODT_ADDL_CHRG_AMT,0)+NVL( FPRPODT_TAX_AMT,0)-NVL(FPRPODT_DISC_AMT, 0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
APPROVED_ITEM_AMOUNT |
NO |
This calculation returns the approved item amount for the purchase order item. The amount is calculated as the approved quantity multiplied by the unit price plus any additional charges and tax amount and then subtracting any discount. |
AARMEMB_AMT_QUALIFY - AOKODSF.F_GET_MEMBER_AMT_PAID |
NA |
NO |
|
|
|
|
|
ACCT.PAY_CURRENCY_AMOUNT - ACCT.PAY_CURRENCY_AMOUNT_NO_TAX |
NA |
NO |
|
|
|
|
|
AFRCSOL_GOAL / AFBCAMP_GOAL * 100 |
NA |
NO |
|
|
|
|
|
AFRDESG_GOAL / AFBCAMP_GOAL * 100 |
NA |
NO |
|
|
|
|
|
AGBMGID_AMT - AGBMGID_AMT_PAID |
NA |
NO |
COMPOSITE VIEW |
AA_GIFT_MATCHING |
MATCH_GIFT_BALANCE |
NO |
NA |
AGRGDES_AMT-F_GIFT_HARD_CREDIT |
NA |
NO |
COMPOSITE VIEW |
AA_GIFT |
GIFT_CREDIT_AMOUNT |
NO |
NA |
AGRPDES_AMT-AGRPDES_AMT_PAID |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
PLEDGE_BALANCE |
NO |
NA |
AGRPDES_AMT-F_PLEDGE_HARD_CREDIT |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
PLEDGE_CREDIT |
NO |
NA |
AGRPDES_AMT_PAID - SUM(AGRPDES_AMT_PAID) |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
PLEDGE_TRANS_BALANCE |
NO |
|
AORCONT_FAX_AREA||AORCONT_FAX_NUMBER||AO RCONT_FAX_EXT |
NA |
NO |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT |
FAX_NUMBER_COMBINED |
NO |
|
AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER ||AORCONT_PHONE_EXT |
NA |
NO |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT |
PHONE_NUMBER_COMBINED |
NO |
|
ASBSORG_UPD_WEB_IND |
NA |
NO |
|
|
|
|
|
ASRSORG_DOLLAR_GOAL / ASBSORG_DOLLAR_GOAL * 100 |
NA |
NO |
|
|
|
|
|
ASRSORG_UPD_WEB_IND |
NA |
NO |
|
|
|
|
|
CASE NBBPOSN_PREMIUM_ROLL_IND |
TBD |
NO |
|
|
|
|
|
CASE NBBPOSN_ROLL_IND |
TBD |
NO |
|
|
|
|
|
CASE SFRFFST_STATUS_CDE WHEN |
TBD |
NO |
|
|
|
|
|
CASE STVFFVA_TYPE WHEN |
NA |
NO |
COMPOSITE VIEW |
AS_FACULTY_FEEDBACK_DETAIL |
FEEDBACK_TYPE_DESC |
NO |
|
CASE STVFFVA_TYPE WHEN 'ISSUE' THEN 'ISSUE' WHEN 'RECOMMEND' THEN 'RECOMMENDATION' END |
TBD |
NO |
|
|
|
|
|
CASE SYS.ANYDATA.GETTYPENAME( GORSDAV_VALUE) |
TBD |
NO |
COMPOSITE VIEW |
AG_SDE_DATA |
ATTRIBUTE_VALUE |
NO |
This calculation retrieves the value from GORSDAV_VALUE based on datatype. |
CASE STATEMENT |
NA |
NO |
|
|
|
|
(CASE WHEN ( SFRSTCR_DUPL_OVER = 'Y' OR SFRSTCR_LINK_OVER = 'Y' OR SFRSTCR_CORQ_OVER = 'Y' OR SFRSTCR_PREQ_OVER = 'Y' OR SFRSTCR_TIME_OVER = 'Y' OR SFRSTCR_CAPC_OVER = 'Y' OR SFRSTCR_LEVL_OVER = 'Y' OR SFRSTCR_COLL_OVER = 'Y' OR SFRSTCR_MAJR_OVER = 'Y' OR SFRSTCR_CLAS_OVER = 'Y' OR SFRSTCR_APPR_OVER = 'Y' OR SFRSTCR_REPT_OVER = 'Y' OR SFRSTCR_RPTH_OVER = 'Y' OR SFRSTCR_TEST_OVER = 'Y' OR SFRSTCR_CAMP_OVER = 'Y' OR SFRSTCR_DEGC_OVER = 'Y' OR SFRSTCR_PROG_OVER = 'Y' OR SFRSTCR_DEPT_OVER = 'Y' OR SFRSTCR_ATTS_OVER = 'Y' OR SFRSTCR_CHRT_OVER = 'Y' OR SFRSTCR_MEXC_OVER = 'Y') THEN 'Y' ELSE 'N' END) |
CASE WHEN (C.DAP_TRANSFER = 'C') AND ( C.DAP_INPROGRESS = 'N') |
NA |
NO |
|
|
|
|
|
CASE WHEN (RCRAPP1_SEQ_NO |
NA |
NO |
|
|
|
|
|
CASE WHEN A.ADVANCE_STATUS = 'O' THEN 'OUTSTANDING' WHEN A.ADVANCE_STATUS = 'R' THEN 'RECONCILED' WHEN A.ADVANCE_STATUS = 'D' THEN 'OVERDUE' ELSE 'UNKNOWN' END |
TBD |
NO |
|
|
|
|
|
CASE WHEN AORCONT_CONT_ORG_IND |
NA |
NO |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT |
CONTACT_ADDRESS_SOURCE_DESC |
NO |
|
CASE WHEN AORCONT_EMAL_SRC_IND |
NA |
NO |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT |
CONTACT_EMAIL_SOURCE_DESC |
NO |
|
CASE WHEN AORCONT_FAX_SRC_IND |
NA |
NO |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT |
CONTACT_FAX_SOURCE_DESC |
NO |
|
CASE WHEN AORCONT_PRIMARY_IND |
NA |
NO |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT |
PRIMARY_CONTACT_IND |
NO |
|
CASE WHEN AORCONT_TELE_SRC_IND |
NA |
NO |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT |
CONTACT_PHONE_SOURCE_DESC |
NO |
|
CASE WHEN APPROVAL_METHOD |
NA |
NO |
|
|
|
|
|
CASE WHEN APPROVAL_STATUS |
NA |
NO |
|
|
|
|
|
CASE WHEN CONTACT_DECEASED_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_AUDIT_TYPE |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_REASON_INSUF |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' AND AUDIT_TYPE = 'PL' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'CLASSNEEDED' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'FALLCLASSAPPLIED' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'FALLNONCRAPPLIED' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'INSUFFCLASSAPPLIED' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' AND AUDIT_TYPE = 'PL' AND SUBSTR(VALUE3,1,2) = 'PN' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'NONCRNEEDED' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_RESULT_TYPE = 'OTLCLASSAPPLIED' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_TRANSFER = 'C' AND DAP_INPROGRESS = 'N' |
NA |
NO |
|
|
|
|
|
CASE WHEN DAP_TRANSFER = 'T' |
NA |
NO |
|
|
|
|
|
CASE WHEN ENCUMBRANCE_NUMBER |
NA |
NO |
COMPOSITE VIEW |
AF_ENCUMBRANCE |
HR_ENCUMBRANCE_IND |
NO |
|
CASE WHEN FABBKTP_RECON_IND |
NA |
NO |
COMPOSITE VIEW |
AF_CHECKS |
BANK_RECONCILIATION_IND_DESC |
NO |
|
CASE WHEN FABCHKS_CHECK_TYPE_IND |
NA |
NO |
COMPOSITE VIEW |
AF_CHECKS |
CHECK_TYPE_DESC |
NO |
|
CASE WHEN FABCHKS_PAY_TYPE |
NA |
NO |
|
|
|
|
Hard code a pay type description based upon the pay_type value CASE WHEN FABCHKS_PAY_TYPE = 'Check' THEN 'Check' WHEN FABCHKS_PAY_TYPE = 'ACH' THEN 'Direct Deposit' WHEN FABCHKS_PAY_TYPE = 'vCard' THEN 'Virtual Card' WHEN FABCHKS_PAY_TYPE = 'PNE' THEN 'Temporary Pay Type' WHEN FABCHKS_PAY_TYPE = 'Wire' THEN 'Wire Transfer' END |
CASE WHEN FABCHKS_RECON_IND |
NA |
NO |
COMPOSITE VIEW |
AF_CHECKS |
RECONCILIATION_IND_DESC |
NO |
|
CASE WHEN FABRUIV_SUB_IND |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REPEATING_FREQUENCY_DESC |
NO |
|
CASE WHEN FGBENCD_CMT_TYPE |
NA |
NO |
|
|
|
|
|
CASE WHEN FGBENCD_FIELD_CODE |
NA |
NO |
|
|
|
|
|
CASE WHEN FTVVEND_CHECK_PIDM IS NULL |
NA |
NO |
|
|
|
|
|
CASE WHEN GROUP_TYPE |
NA |
NO |
|
|
|
|
CASE RTRIM (G.GROUP_TYPE) WHEN 'UN' THEN G$_NLS.GET ('DPVTMCR-0001', 'SQL', 'Union within group') WHEN 'CH' THEN G$_NLS.GET ('DPVTMCR-0002', 'SQL', 'Choice within group') WHEN 'NA' THEN G$_NLS.GET ('DPVTMCR-0003', 'SQL', 'Not applicable') END |
CASE WHEN HR_ENCUMBRANCE_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN NORTRAN_AUBK_CODE = 'SPRIDEN' THEN 'IDEN' |
NA |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_GENERAL |
PAF_TRANSACTION_TYPE |
NO |
|
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = |
NA |
NO |
|
|
|
|
Tests to determine if the detail code is term based or aid year based detail code or neither CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = 'T' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE = 'A' ELSE DESIGNATOR_TYPE = 'N' END CASE; |
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC = |
NA |
NO |
|
|
|
|
Hard code the description based upon the designator type. CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE_DESC = 'Academic period-based' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE_DESC = 'Aid year-based' ELSE DESIGNATOR_TYPE_DESC = 'No designator' END CASE; |
CASE WHEN NVL(TBBEACT_TBDC_IND, 'N') |
NA |
NO |
|
|
|
|
|
CASE WHEN OFFICIAL_TRACKING_STATUS |
NA |
NO |
|
|
|
|
|
CASE WHEN PLAN_SOURCE |
NA |
NO |
|
|
|
|
|
CASE WHEN R.DAP_RESULT_TYPE = 'CLASSNEEDED' THEN 'N' WHEN R.DAP_RESULT_TYPE <> 'CLASSNEEDED' AND R.DAP_AUDIT_TYPE = 'PL' |
NA |
NO |
|
|
|
|
|
CASE WHEN RBRAPBC_SYS_IND = 'S' |
TBD |
NO |
|
|
|
|
|
CASE WHEN RFRASPC_DIRECT_LOAN_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN RFRASPC_EL_LOAN_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN RFRASPC_MANUAL_LOAN_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN RORSTAT_ADDL_PELL_ELIB_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN RORSTAT_DEP_NO_PAR_DATA |
NA |
NO |
|
|
|
|
|
CASE WHEN RRRAREQ_SYS_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN SFRBRDB_COURSE_RESTRICTION |
NA |
NO |
|
|
|
|
IF SFRBRDB_COURSE_RESTRICTION = 'NA THEN Add/Drop Courses Not Available, WHEN SFRBRDB_COURSE_RESTRICTION = NB THEN Add/Drop only Non-Block Courses, WHEN SFRBRDB_COURSE_RESTRICTION = NR THEN Add/Drop Courses with No Restriction |
CASE WHEN SFRSTCR_GRDE_CODE |
NA |
NO |
|
|
|
|
Determines if course was attempted, earned, passed, credit for GPA, considered for repeat, incomplete,or last date of attendance is required. If sfrstcr_grde_code is not null THEN course_attempted_ind = shrgrde_attempted_ind; If sfrstcr_grde_code is not null THEN course_earned_ind = shrgrde_completed_ind; If sfrstcr_grde_code is not null THEN course_passed_ind = shrgrde_passed_ind; If sfrstcr_grde_code is not null THEN course_gpa_ind = shrgrde_gpa_ind; |
CASE WHEN SFRSTCR_GRDE_CODE CASE WHEN SHRGRDE_ATTEMPTED_IND |
NA |
NO |
|
|
|
|
Determines if student passed or failed the course. CASE WHEN SFRSTCR_GRDE_CODE IS NOT NULL THEN CASE WHEN shrgrde_attempted_ind = 'Y' AND shrgrde_passed_ind = 'N' AND shrgrde_gpa_ind = 'Y' THEN 'Y' ELSE 'N |
CASE WHEN SFRSTCR_WAIV_HRS |
NA |
NO |
|
|
|
|
|
CASE WHEN SHRTCKG_GRDE_CODE_FINAL |
NA |
NO |
|
|
|
|
Determines if course was attempted, earned, passed, credit for GPA, considered for repeat, incomplete,or last date of attendance is required. If shrtckg_grde_code_final is not null THEN course_attempted_ind = shrgrde_attempted_ind; If shrtckg_grde_code_final is not null THEN course_earned_ind = shrgrde_completed_ind; If shrtckg_grde_code_final is not null THEN course_passed_ind = shrgrde_passed_ind; If shrtckg_grde_code_final is not null THEN credit_for_gpa_ind = shrgrde_gpa_ind; |
CASE WHEN SHRTCKG_GRDE_CODE_FINAL CASE WHEN SHRGRDE_ATTEMPTED_IND |
NA |
NO |
|
|
|
|
Determines if student passed or failed the course. CASE WHEN SHRTCKG_GRDE_CODE_FINAL IS NOT NULL THEN CASE WHEN shrgrde_attempted_ind = 'Y' AND shrgrde_passed_ind = 'N' AND shrgrde_gpa_ind = 'Y' THEN 'Y' ELSE 'N |
CASE WHEN SHRTRCE_GRDE_CODE |
NA |
NO |
|
|
|
|
Determines if course was attempted, earned, passed, credit for GPA, considered for repeat, incomplete,or last date of attendance is required. If shrtrce_grde_code is not null THEN course_attempted_ind = shrgrde_attempted_ind; If shrtrce_grde_code is not null THEN course_earned_ind = shrgrde_completed_ind; If shrtrce_grde_code is not null THEN course_passed_ind = shrgrde_passed_ind; If shrtrce_grde_code is not null THEN credit_for_gpa_ind = shrgrde_gpa_ind; |
CASE WHEN SHRTRCE_GRDE_CODE CASE WHEN SHRGRDE_ATTEMPTED_IND |
NA |
NO |
|
|
|
|
Determines if student passed or failed the course. CASE WHEN SHRTRCE_GRDE_CODE IS NOT NULL THEN CASE WHEN shrgrde_attempted_ind = 'Y' AND shrgrde_passed_ind = 'N' AND shrgrde_gpa_ind = 'Y' THEN 'Y' ELSE 'N |
CASE WHEN SSBSECT_CENSUS_2_DATE |
NA |
NO |
|
|
|
|
|
CASE WHEN SSBSECT_CENSUS_ENROLL |
NA |
NO |
|
|
|
|
|
CASE WHEN STAFF_ASSIGNMENT_STATUS_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN STATUS_CHANGE_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN STRATEGY_PLAN_STATUS_IND |
NA |
NO |
|
|
|
|
|
CASE WHEN STVESTS_EFF_HEADCOUNT |
NA |
NO |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY AS_ENROLLMENT |
NOT_ENROLLED_IND NOT_ENROLLED_IND |
NO NO |
Determines if the student is not enrolled. |
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID = 0 THEN 'Y' ELSE 'N' |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
PLEDGE_TRANS_FULLY_PAID_IND |
NO |
|
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID > 0 AND SUM( AGRPDES_AMT_PAID) < AGRPDES_AMT_PAID THEN 'Y' ELSE 'N' |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
PLEDGE_TRANS_PARTIAL_PAID_IND |
NO |
|
CASE WHEN SYSDATE BETWEEN EXCLUSION_DATE |
NA |
NO |
|
|
|
|
|
CASE WHEN TAX_DOCUMENT_BOX |
NA |
NO |
|
|
|
|
Determine TAX_DOCUMENT_BOX hard coded descriptions based upon TBRACCD_TAX_REPT_BOX value. |
CASE WHEN TAX_NOTIFICATION_STATUS |
NA |
NO |
|
|
|
|
Determines hard coded descriptions for TAX_NOTIFICATION_STATUS based upon the values in TTBTAXN_STUD_NOTIF_STATUS. |
CASE WHEN TBBDETC_REFUND_IND |
NA |
NO |
COMPOSITE VIEW |
AT_ACCOUNT_DETAIL |
REFUND_DESC |
NO |
Hard code the description based upon the TBBDETC_REFUND_IND Hard code the detail code refund description based upon the refund indicator. CASE WHEN TBBDETC_REFUND_IND = 'Y' THEN REFUND_DESC = 'Refund' WHEN TBBDETC_REFUND_IND = 'M' THEN REFUND_DESC = 'Manual Refund' WHEN TBBDETC_REFUND_IND = 'P' THEN REFUND_DESC = 'Parent PLUS Refund' ELSE REFUND_DESC = 'No Refund' END |
CASE WHEN TBBDETC_TBDC_IND |
NA |
NO |
|
|
|
|
Checks to determine if the detail code is a term based detail code, and if not, then checks to determine if the detail code is an aid year based detail code. CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = 'T' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE = 'A' ELSE DESIGNATOR_TYPE = 'N' END CASE; |
CASE WHEN TBBEACT_TBDC_IND |
NA |
NO |
|
|
|
|
Determines if the detail code is used as a designator detail code. CASE WHEN TBBEACT_TBDC_IND = 'Y' OR TBBEACT_ABDC_IND = 'Y' THEN 'Y' ELSE 'N' END |
CASE WHEN TBBEACT_TBDC_IND = 'Y' |
NA |
NO |
|
|
|
|
|
CASE WHEN TRACKING_STATUS |
NA |
NO |
|
|
|
|
|
CASE WHEN UNOFFICIAL_TRACKING_STATUS |
NA |
NO |
|
|
|
|
|
CASE(AMRCONT_GEN_CONTACT_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_CONSTITUENT_CONTACT |
PROSPECT_CONTACT_IND |
NO |
|
COUNT (*) OVER (PARTITION BY B.PERSON_UID) |
NA |
NO |
|
|
|
|
COUNT (*) OVER (PARTITION BY B.PERSON_UID, B.ACADEMIC_PERIOD, B.SUB_ACADEMIC_PERIOD, B.PLAN_COURSE_SEQUENCE_NUMBER, B.COURSE_IDENTIFICATION, B.COURSE_REFERENCE_NUMBER) |
COUNT (*) OVER (PARTITION BY COURSE_IDENTIFICATION, ACADEMIC_PERIOD, SUB_ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER) |
TBD |
NO |
|
|
|
|
|
COUNT (DISTINCT COURSE_REFERENCE_NUMBER) |
TBD |
NO |
|
|
|
|
|
COUNT (DISTINCT PERSON_UID) |
TBD |
NO |
|
|
|
|
|
COUNT(AMRATTN_PIDM) |
NA |
NO |
|
|
|
|
|
COURSE_DISCIPLINE||COURSE_NUMBER |
NA |
NO |
|
|
|
|
|
DAP_VALUE1 || DAP_VALUE2 |
NA |
NO |
|
|
|
|
|
DAP_VALUE2 || DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID' |
NA |
NO |
|
|
|
|
|
DECODE ( DECODE ( SIGN ( NVL ( TBRACCD_TRANS_DATE, TBRACCD_EFFECTIVE_DATE) |
TSADETL |
NO |
|
|
|
|
|
DECODE (MRVAND0_EFC_IND, 'F', '', RNKNEED.F_CALC_BUDGET_AMT (MRVAND0_PIDM, MRVAND0_AIDY_CODE, 'I')), '999999999D99') |
TBD |
NO |
|
|
|
|
|
DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND) |
NA |
NO |
|
|
|
|
DECODE(NBBPOSN_EXEMPT_IND,'Y',DECODE(NTRPCLS_EXEMPT_IND,'Y','Exemption Position Class and Position Definition','Non-exempt Position Class and Position Definition'),DECODE(NTRPCLS_EXEMPT_IND,'Y','Exempt Class but overridden by the Position Definition','Non-exempt Position Class but overridden by the Position Definition')) |
DECODE (RCRAPP1_WARD_OF_COURT, '1', 'Y', 'N') |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
WARD_OF_COURT_IND |
NO |
|
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND (ENTITY_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION') |
TBD |
NO |
|
|
|
|
|
DECODE (SUBSTR ( MAKFUNC.F_GET_ENTITY_IND ( MATCH_EMPLOYER_UID), 1, 1), 'P', 'PERSON', 'O', 'ORGANIZATION') |
TBD |
NO |
|
|
|
|
|
DECODE(AGBMGID_DELETE_IND,'I','N','Y'), |
NA |
NO |
COMPOSITE VIEW |
AA_GIFT_MATCHING |
ACTIVE_IND |
NO |
NA |
DECODE(AGBMGID_DELETE_IND,NULL, DECODE( AGBMGID_STATUS,NULL,'W','P','P','I','I') ,'N'), |
NA |
NO |
COMPOSITE VIEW |
AA_GIFT_MATCHING |
MATCH_GIFT_STATUS |
NO |
NA |
DECODE(AGBMGID_DELETE_IND,NULL, DECODE( AGBMGID_STATUS,NULL,'WAITING, NO PAYMENT','P','PAID IN FULL','I', 'WAITING, PARTIAL PAYMENT'),'NO PAYMENT EXPECTED'), |
NA |
NO |
COMPOSITE VIEW |
AA_GIFT_MATCHING |
MATCH_GIFT_STATUS_DESC |
NO |
NA |
DECODE(AGRGAUX_ACC_REJ_IND,'A','ACCEPT', 'R','REJECT','NOT APPLICABLE'), |
NA |
NO |
COMPOSITE VIEW |
AA_GIFT_AUXILIARY |
BENEFIT_ACCEPT_REJECT_DESC |
NO |
NA |
DECODE(AGRPAUX_PLDG_ADJ_VOID_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE_AUXILIARY AA_PLEDGE_AUXILIARY |
PLEDGE_VOID_IND PLEDGE_ADJUSTMENT_IND |
NO NO |
|
DECODE(AGRPCON_MET_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE_CONDITIONAL |
CONDITION_MET_DESC |
NO |
|
DECODE(AGRPDES_AMT-AGRPDES_AMT_PAID) |
NA |
NO |
|
|
|
|
NA |
DECODE(AGRPDES_AMT_PAID) |
NA |
NO |
|
|
|
|
NA |
DECODE(AMRPLAN_PROJ_CODE, AMRCONT_PROJ_CODE) |
NA |
NO |
|
|
|
|
|
DECODE(AMRPRRT_RATING_PIDM,NULL, AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM) |
NA |
NO |
COMPOSITE VIEW |
AA_ADVANCEMENT_RATING |
RATER_UID |
NO |
NA |
DECODE(APRADEG_HOND_CODE_1) |
NA |
NO |
|
|
|
|
|
DECODE(APRADEG_HONR_CODE) |
NA |
NO |
|
|
|
|
Determines if this person should be counted in the institutional honors count. |
DECODE(APRADEG_SBGI_CODE, AUBINST_SBGI_CODE,'Y','N') |
NA |
NO |
COMPOSITE VIEW |
AA_DEGREE |
INSTITUTION_IND |
NO |
NA |
DECODE(APRCSPS_MARS_IND,'A','ACTIVE', 'I','INACTIVE') |
APACONS |
NO |
COMPOSITE VIEW |
AA_RELATIONSHIP |
SPOUSE_STATUS_DESC |
NO |
This calculation checks APRCSPS_MARS_IND to derive a description. If 'A' description is 'active'. If 'I' description is 'inactive'. |
DECODE(APRDCLB_DCYR_CODE,'9999','Y','N') |
NA |
NO |
COMPOSITE VIEW |
AA_GIFT_SOCIETY |
LIFETIME_GIFT_SOCIETY_IND |
NO |
NA |
DECODE(APRIGRP_DISPLAY_WEB_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_INTEREST |
DISPLAY_WEB_IND |
NO |
|
DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY', 'S','SECONDARY') |
NA |
NO |
COMPOSITE VIEW |
AA_RELATIONSHIP |
COMBINED_MAILING_PRIORITY_DESC |
NO |
This calculation checks APRXREF_CM_PRI_IND to derive a description. If 'P' description is 'primary'. If 'S' description is 'secondary'. |
DECODE(ATVADJT_DEBIT_CREDIT_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_DESIGNATION_ADJUSTMENT |
ADJUSTMENT_DEBIT_CREDIT_DESC |
NO |
|
DECODE(ATVCFAE_MG_PURPOSE,'A','ALUMNI OR OTHER ASSOCIATIONS','B','RELIGIOUS PURPOSES AT THE INSTITUTION','C', 'POLITICAL PURPOSES AT THE INSTITUTION', 'D','ATHLETIC ACTIVITIES','E','ATHLETIC SCHOLARSHIP FUNDS','F','NON-ATHLETIC SCHOLARSHIP FUNDS',ETC.) |
TBD |
NO |
COMPOSITE VIEW |
AA_DESIGNATION |
MATCHING_GIFT_VSE_PURPOSE_DESC |
NO |
|
DECODE(ATVDONR_CFAE_2) |
NA |
NO |
COMPOSITE VIEW |
AA_DONOR_CATEGORY |
VSE_DESC_2 |
NO |
NA |
DECODE(ATVGIFT_CFAE_GIFT_CATG) |
NA |
NO |
COMPOSITE VIEW |
AA_GIFT |
GIFT_VSE_DESC |
NO |
NA |
DECODE(BENEFICIARY_NAME) |
NA |
NO |
|
|
|
|
DECODE(B.BENEFICIARY_LAST_NAME, NULL, BP.FULL_NAME_LFMI, B.BENEFICIARY_LAST_NAME||', '||B.BENEFICIARY_FIRST_NAME||' '||DECODE(B.BENEFICIARY_MIDDLE_INITIAL,NULL,NULL,SUBSTR(BENEFICIARY_MIDDLE_INITIAL,1,1))|| '.') |
DECODE(C.EXPENSE_TYPE_CODE, '9900ADVC', 'Y','N') |
TBD |
NO |
|
|
|
|
|
DECODE(ENROLLED_IND, 'N', 'Y', 'N') |
NA |
NO |
|
|
|
|
|
DECODE(EXPENSE_TYPE_CODE,'9900ADVC') |
TBD |
NO |
|
|
|
|
|
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REMIT_TO_STREET_LINE1 |
NO |
NA |
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REMIT_TO_STREET_LINE2 |
NO |
NA |
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REMIT_TO_STREET_LINE3 |
NO |
NA |
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_CITY, NULL) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REMIT_TO_CITY |
NO |
NA |
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_NATN, NULL) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REMIT_TO_NATION |
NO |
NA |
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_STATE, NULL) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REMIT_TO_STATE_PROVINCE |
NO |
NA |
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ZIP, NULL) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REMIT_TO_POSTAL_CODE |
NO |
NA |
DECODE(FABINVH_ATYP_CODE, NULL, TO_NUMBER(NULL), FABINVH_ATYP_SEQ_NUM) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REMIT_TO_ADDRESS_TYPE_NUMBER |
NO |
NA |
DECODE(FABINVH_ATYP_CODE,NULL,'Y','N') |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
ONE_TIME_VENDOR_ADDRESS_IND |
NO |
NA |
DECODE(FABINVH_GROUPING_IND) |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE AF_INVOICE |
GROUPING GROUPING_DESC |
NO NO |
|
DECODE(FABINVH_INVOICE_TYPE_IND) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
INVOICE_TYPE_DESC |
NO |
This calculation evaluates the column FABINVH_INVOICE_TYPE_IND. If it is a D, it will return DIRECT. If it is an R, it will return REGULAR. If it is neither D nor R, it will return NULL. |
DECODE(FABINVH_MATCH_REQUIRED) |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
RECEIVING_REQUIRED_DESC |
NO |
|
DECODE(FABINVH_VEND_CHECK_PIDM,NULL,'N', 'Y') |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
THIRD_PARTY_ADDRESS_IND |
NO |
NA |
DECODE(FEEDBACK_COMMENT,NULL,'NO','YES') |
TBD |
NO |
|
|
|
|
|
DECODE(FEEDBACK_ESTIMATED_GRADE,NULL, 'NO','YES') |
TBD |
NO |
|
|
|
|
|
DECODE(FEEDBACK_STATUS,'M','YES','NO') |
TBD |
NO |
|
|
|
|
|
DECODE(FFBMAST_SUBORDINATE_TYPE) |
FFAMAST |
NO |
COMPOSITE VIEW |
AF_FIXED_ASSET_ITEM |
SUBORDINATE_TYPE_DESC |
NO |
This calculation evaulates the column FFBMAST_SUBORDINATE_TYPE. If it is a C, it returns COMPONENT. If it is an A, it returns ATTACHEDTO. If it is neither C nor A, it returns NEITHER. |
DECODE(FFRMASA_DEPR_POST_CODE) |
FFADEPR |
NO |
COMPOSITE VIEW |
AF_FIXED_ASSET_DEPRECIATION |
DEPRECIATION_POSTING_STATUS |
NO |
This calculation evaluates the column FFRMASA_DEPR_POST_CODE. If it is an M, it will return Memo Post. If it is a P, it will return Post. If it is neither M nor P, it will return No Post. |
DECODE(FGBENCD_STATUS) |
FGIENCD |
NO |
COMPOSITE VIEW |
AF_ENCUMBRANCE_ACCOUNTING |
ENCUMBRANCE_STATUS |
NO |
This calculation evaluates the column FGBENCD_STATUS. If it is a C, it will return Closed. Otherwise it will return Open. |
DECODE(FGBENCD_STATUS_IND) |
FGIENCD |
NO |
COMPOSITE VIEW |
AF_ENCUMBRANCE_ACCOUNTING |
POSTABLE_IND |
NO |
This calculation evaluates the column FGBENCD_STATUS_IND. If it is a P, it will return Y. Otherwise, it will return an N. |
DECODE(FGBENCH_SOURCE_IND) |
FGIENCD |
NO |
COMPOSITE VIEW |
AF_ENCUMBRANCE |
ENCUMBRANCE_SOURCE |
NO |
This calculation evaluates the column FGBENCH_SOURCE_IND. If it is an R, it will return Requisition. If it is a P, it will return Purchase Order. If it is an E, it will return Encumbrance. Otherwise, it will return Unknown Source. |
DECODE(FGBENCH_STATUS) |
FGIENCD |
NO |
COMPOSITE VIEW |
AF_ENCUMBRANCE |
COMPLETE_IND |
NO |
This calculation evaluates the column FGBENCH_STATUS. If it is a C, it will return Y. Otherwise, it will return an N. |
DECODE(FGBENCH_STATUS_IND) |
FGIENCD |
NO |
COMPOSITE VIEW |
AF_ENCUMBRANCE |
ENCUMBRANCE_STATUS |
NO |
This calculation will evaluate the column FGBENCH_STATUS_IND. If it is a C, it will return Closed. Otherwise it will return Open. |
DECODE(FNVENDW_REST_TYPE) |
NA |
NO |
COMPOSITE VIEW |
AF_ENDOWMENT |
RESTRICTION_TYPE_DESC |
NO |
This calculation will evaluate the column FNVENDW_REST_TYPE. If it is an R, it will return RESTRICTED. If it is a U, it will return UNRESTRICTED. Otherwise it will return NULL. |
DECODE(FNVPOOL_STATUS_IND) |
FNMPOOL |
NO |
|
|
|
|
This calculation will evaluate the column FNVPOOL_STATUS_IND. If it is an A, it will return ACTIVE. If it is an I, it will return INACTIVE. Otherwise, it will return NULL. |
DECODE(FOKODSF.F_GET_REST_IND) |
NA |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
FUND_BALANCE_RESTRICTION_DESC FUND_BALANCE_RESTRICTION_DESC |
NO NO |
|
DECODE(FORCIRR_DATA_ORIGIN) |
NA |
NO |
|
|
|
|
|
DECODE(FPBPOHD_MATCH_REQUIRED) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
RECEIVING_REQUIRED_DESC |
NO |
|
DECODE(FPBPOHD_PO_TYPE_IND) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
PURCHASE_ORDER_TYPE_DESC |
NO |
This calculation will evaluate the column FPBPOHD_PO_TYPE_IND. If it is an R, it will return REGULAR. If it is an S, it will return STANDING. Otherwise, it will return NULL. |
DECODE(FPBPOHD_REQ_BID_IND) |
FPAPOAS |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
REQUISITION_OR_BID_SOURCE_DESC |
NO |
|
DECODE(FPBPOHD_TEXT_IND) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
REQUISITION_TEXT_DESC |
NO |
|
DECODE(FPBRCDT_ADJUST_RECEIVE_IND) |
FPARCVD |
NO |
COMPOSITE VIEW |
AF_RECEIVED_ITEM |
ADJUSTED_IND |
NO |
This calculation returns a Y or N if the item was adjusted or not adjusted. |
DECODE(FPRPODA_NSF_SUSP_IND) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
NSF_SUSPENSE_DESC |
NO |
|
DECODE(FPRPODT_TEXT_USAGE) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
TEXT_USAGE_DESC |
NO |
|
DECODE(FPRRCDT_PARTIAL_FINAL_IND) |
FPARCVD |
NO |
COMPOSITE VIEW |
AF_RECEIVED_ITEM |
FINAL_RECEIPT_IND |
NO |
Calculation determines if value is set to (P)artial or (F)inal. |
DECODE(FRBEVNG_PMT_METHOD_TYPE_IND) |
NA |
NO |
COMPOSITE VIEW |
AF_GRANT_EVENT |
PAYMENT_METHOD_DESC |
NO |
|
DECODE(FRRBDET_ACCT_CLASS_CODE) |
FRABDCN |
NO |
COMPOSITE VIEW |
AF_GRANT_BILLING_DETAIL |
ACCOUNT_CLASS |
NO |
This calculation will evaluate the column FRRBDET_ACCT_CLASS_CODE. If it is a C, it will return COST SHARE. If it is an I, it will return INDIRECT COST. If it is a D, it will return DIRECT EXPENSE. If it is an F, it will return FIXED ASSETS. If it is a U, it will return UNITIZATION. |
DECODE(FRRBDET_BILL_STATUS) |
FRABDCN |
NO |
COMPOSITE VIEW |
AF_GRANT_BILLING_DETAIL |
BILL_STATUS_DESC |
NO |
This calculation will evaluate the column FRRBDET_BILL_STATUS. If it is a B, it will return BILLED. If it is a U, it will return UNBILLED. If it is an H, it will return HOLD. If it is a W, it will return WITHHOLDING. |
DECODE(FRVBFRM_TYPE_IND) |
NA |
NO |
COMPOSITE VIEW |
AF_GRANT_EVENT AF_GRANT_PERSONNEL |
BILL_FORMAT_TYPE_DESC BILL_FORMAT_TYPE_DESC |
NO NO |
|
DECODE(FTVATTT_STATUS_IND) |
FTMATTT |
NO |
COMPOSITE VIEW |
AF_PROGRAM_ATTRIBUTES_ODS AF_ACCOUNT_ATTRIBUTES_ODS AF_ACCOUNT_TYPE_ATTRIBUTES_ODS AF_ACTIVITY_ATTRIBUTES_ODS AF_CHART_ATTRIBUTES_ODS AF_FUND_ATTRIBUTES_ODS AF_FUND_TYPE_ATTRIBUTES_ODS AF_ATTRIBUTE_SETS_ODS AF_ORGANIZATION_ATTRIBUTES_ODS AF_LOCATION_ATTRIBUTES_ODS |
ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC ATTRIBUTE_TYPE_STATUS_DESC |
NO NO NO NO NO NO NO NO NO NO |
This calculation will evaluate the column FTVATTT_STATUS_IND. If it is an A, it will return Active. Otherwise, it will return Inactive. |
DECODE(FTVBAL_FBAL_IND) |
NA |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL |
FUND_BALANCE_DESC FUND_BALANCE_DESC |
NO NO |
|
DECODE(FTVFSPD_PRD_STATUS_IND) |
NA |
NO |
COMPOSITE VIEW |
AF_FISCAL_PERIOD |
PERIOD_STATUS_DESC |
NO |
|
DECODE(FTVFUND_REST_IND) |
NA |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
FUND_RESTRICTION_DESC FUND_RESTRICTION_DESC |
NO NO |
|
DECODE(FTVVEND_1099_RPT_ID) |
FTMVEND |
NO |
COMPOSITE VIEW |
AF_VENDOR |
FEDERAL_REPORTABLE_TAX_IND |
NO |
This calculation will evaluate the column FTVVEND_1099_RPT_ID. If it is NULL, it will return an N. Otherwise, it will return a Y. |
DECODE(F_DISPOSITION_IND,'H','HIRED', 'N','NO LONGER CONSIDERED','U','UNDER CONSIDERATION') |
NA |
NO |
COMPOSITE VIEW |
AP_HR_APPLICATION |
STATUS_DISPOSITION_DESC |
NO |
This function returns HIRE if the disposition indicator is H, NO LONGER CONSIDERED if it is N or UNDER CONSIDERATION if it is U. |
DECODE(GOREMAL_STATUS_IND) |
NA |
NO |
COMPOSITE VIEW |
AG_INTERNET_ADDRESS |
INTERNET_ADDRESS_STATUS_DESC |
NO |
|
DECODE(GORSGEO_SOURCE_IND,'S','N','Y') |
NA |
NO |
COMPOSITE VIEW |
AG_GEOGRAPHIC_REGION_INST |
GEOGRAPHIC_SOURCE_USER_IND |
NO |
DECODE(GORSGEO_SOURCE_IND,'S','N','Y') |
DECODE(GORSGEO_STATUS_IND,NULL,'A','I') |
NA |
NO |
COMPOSITE VIEW |
AG_GEOGRAPHIC_REGION_INST |
GEOGRAPHIC_REGION_STATUS |
NO |
DECODE(GORSGEO_STATUS_IND,NULL,'A','I') |
DECODE(GORSGEO_STATUS_IND,NULL,'ACTIVE', 'INACTIVE') |
NA |
NO |
COMPOSITE VIEW |
AG_GEOGRAPHIC_REGION_INST |
GEOGRAPHIC_REGION_STATUS_DESC |
NO |
DECODE(GORSGEO_STATUS_IND,NULL,'Active','Inactive') |
DECODE(GROUP_TYPE) |
NA |
NO |
|
|
|
|
|
DECODE(GURMAIL_DATE_PRINTED,NULL,'Y', 'N') |
NA |
NO |
COMPOSITE VIEW |
AG_COMMUNICATION |
PENDING_LETTER_IND |
NO |
NA |
DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL') |
SUAMAIL |
NO |
COMPOSITE VIEW |
AG_COMMUNICATION |
COMMUNICATION_TYPE_DESC |
NO |
NA |
DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE) |
RNIMSXX |
NO |
|
|
|
|
|
DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C', CANCELLED,'F',FROZEN,'I',INACTIVE) |
NA |
NO |
COMPOSITE VIEW |
AN_SUPERVISOR AN_POSITION_DEFINITION |
POSITION_STATUS_DESC POSITION_STATUS_DESC |
NO NO |
This function returns ACTIVE if the status NBBPOSN_STATUS is A, Cancelled if C, FROZEN if F and INACTIVE if I. |
DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD') |
NA |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION AP_EMPLOYEE AN_SUPERVISOR |
POSITION_CONTRACT_TYPE_DESC CONTRACT_TYPE_DESC POSITION_CONTRACT_TYPE_DESC |
NO NO NO |
This function returns Primary if the contract type NBRBJOB_CONTRACT_TYPE is P, Secondary if it is S and Overload if it is O. |
DECODE(NBRJOBS_PERS_PAY_CODE) |
NA |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
PUBLIC_RETIRE_PAY_RATE_DESC |
NO |
SUBSTR(DECODE(P.NBRJOBS_PERS_PAY_CODE, '01', G$_NLS.GET('x','SQL','Monthly Pay Rate'), '02', G$_NLS.GET('x','SQL','Monthly Pay Rate (LA)'), '04', G$_NLS.GET('x','SQL','Hourly Pay Rate'), '08', G$_NLS.GET('x','SQL','Daily Pay Rate'), '09', G$_NLS.GET('x','SQL','Miscellaneous Pay Rate')),1,30), |
DECODE(NBRJOBS_STATUS) |
NA |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
POSITION_STATUS_DESC |
NO |
This function return Active if the employee status NBRJOBS_STATUS is A, Leave withoutpay and with benefit if it is B, Leave without pay and without benefit if it is L, Leave with pay and with benefit if it is F, Leave with part pay and with benefit if it is P, Terminated if it is T. |
DECODE(NBRJOBS_STRS_PAY_CODE) |
NA |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
STATE_RETIREMENT_PAY_RATE_DESC |
NO |
SUBSTR(DECODE(P.NBRJOBS_STRS_PAY_CODE, '0', G$_NLS.GET('x','SQL','Annual or Lump Sum'), '1', G$_NLS.GET('x','SQL','12 Monthly Payments'), '2', G$_NLS.GET('x','SQL','11 Monthly Payments'), '3', G$_NLS.GET('x','SQL','10 Monthly Payments'), '4', G$_NLS.GET('x','SQL','Hourly Rate'), '7', G$_NLS.GET('x','SQL','13 Payments'), '8', G$_NLS.GET('x','SQL','Daily Rate')),1,30), |
DECODE(NBRPTOT_STATUS,'A',APPROVED,'C', CLOSED,'T',TRANSFERRED,'W',WORKING) |
NA |
NO |
COMPOSITE VIEW |
AN_POSITION_BUDGET AN_PAYROLL_DISTRIBUTION |
BUDGET_STATUS_DESC BUDGET_STATUS_DESC |
NO NO |
This function returns APPROVED if the status NBRPTOT_STATUS is A, CLOSED if it is C, TRANSFERRED if it is T and WORKING if it is W. |
DECODE(NHRDIST_HIST_TYPE_IND) |
NA |
NO |
COMPOSITE VIEW |
AN_PAYROLL_DISTRIBUTION |
PAYROLL_EVENT_TYPE_DESC |
NO |
SUBSTR(DECODE(NHRDIST_HIST_TYPE_IND, 'J', G$_NLS.GET('x','SQL','Adjusted'), 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Original'), 'R', G$_NLS.GET('x','SQL','Redistributed'), 'I', G$_NLS.GET('x','SQL','Reissued'), 'V', G$_NLS.GET('x','SQL','Voided')),1,30) |
DECODE(NORMAL_BALANCE) |
NA |
NO |
|
|
|
|
NA |
DECODE(NVL(AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'N', NVL(AGVPLG1_PLEDGE_AMOUNT,0) , 'N','Y') |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
PLEDGE_PARTIAL_PAID_IND |
NO |
NA |
DECODE(PAYROLL_DEDUCTION) |
NA |
NO |
|
|
|
|
SUM(NVL(DECODE(PAYROLL_DEDUCTION_MONTH, 1, EMPLOYEE_CONTRIBUTION_AMOUNT, 2, EMPLOYEE_CONTRIBUTION_AMOUNT, 3, EMPLOYEE_CONTRIBUTION_AMOUNT,0),0)) |
DECODE(PDRDEDN_STATUS,'A','ACTIVE','B', 'EXEMPT','W','WAIVE','T','TERMINATED',') |
NA |
NO |
COMPOSITE VIEW |
AP_BENEFIT_DEDUCTION |
STATUS_DESC |
NO |
This function returns ACTIVE if the status PDRDEDN_STATUS is A, EXEMPT if the status is B WAIVE if the status is W or TERMINATED if the status is T. |
DECODE(PDRDEDN_STATUS,'A','ACTIVE','B', 'EXEMPT','W','WAIVED','T','TERMINATED') |
NA |
NO |
COMPOSITE VIEW |
AP_TAX |
STATUS_DESC |
NO |
NA |
DECODE(PEBEMPL_1042_RECIPIENT_CD) |
NA |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE |
FOREIGN_INCOME_RECIPIENT_DESC |
NO |
This function returns Individual if the 1042 receipient code PEBEMPL_1042_RECIPIENT_CD is 01, Corporation if it is 02, Partnership if it is 03, Fiduciary if it is 04, Nominee if it is 05, Govt or International Organization if iti 06, Tax Exempt Organization if it is 07, Private Foundation if it 08, Artist or athlete if it is 09, Other if it is 19, Type of recipient unknown if it is 20. |
DECODE(PEBEMPL_CALIF_PENSION_IND) |
NA |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE |
PUBLIC_RETIREMENT_MEMBER_DESC |
NO |
|
DECODE(PEBEMPL_EMPL_STATUS) |
NA |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE |
EMPLOYEE_STATUS_DESC |
NO |
This function return Active if the employee status PEBEMPL_EMPL_STATUS is A, Leave withoutpay and with benefit if it is B, Leave without pay and without benefit if it is L, Leave with pay and with benefit if it is F, Leave with part pay and with benefit if it is P, Terminated if it is T. |
DECODE(PEBEMPL_FLSA_IND) |
NA |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE |
FAIR_LABOR_STANDARDS_TYPE_DESC |
NO |
This function return a description based upon the value of fair labor standards for an employee PEBEMPL_FLSA_STATUS. Accrual is A, Cash is C, and No FLSA is N. |
DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED, N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT) |
NA |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE |
IMMIGRATION_STATUS_DESC |
NO |
This function returns RECEIVED if the I9 form indicator PEBEMPL_I9_FORM_IND is R, NOTRECEIVED if it is N, TEMPORARY if it is T, |
DECODE(PERAPPT_DECISION) |
NA |
NO |
|
|
|
|
SUBSTR(DECODE(PERAPPT_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30) |
DECODE(PERBFAC_PRIMARY_ACTIVITY) |
PEAFACT,PEAFACD |
NO |
|
|
|
|
SUBSTR(DECODE(PERBFAC_PRIMARY_ACTIVITY, 'A', G$_NLS.GET('x','SQL','Administrative'), 'I', G$_NLS.GET('x','SQL','Instructional'),'R', G$_NLS.GET('x','SQL','Research')),1,30) |
DECODE(PERJTOT_MONTH,1,1,2,1,3,1,4,2,5, 2,6,2,7,3,8,3,9,3,10,4,11,4,12,4) |
NA |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE_EARNING_CY |
QUARTER |
NO |
This function returns what quarter it is based on the month PERJTOT_MONTH. 1, 2, 3 are the first quarter. 4, 5, 6 are the second quarter. 7, 8, 9 are the third quarter. 10, 11, 12 are the fourth quarter. |
DECODE(PERRANK_DECISION) |
NA |
NO |
|
|
|
|
SUBSTR(DECODE(PERRANK_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30) |
DECODE(PERSABB_DECISION) |
NA |
NO |
|
|
|
|
SUBSTR(DECODE(PERSABB_DECISION, 'N', G$_NLS.GET('x','SQL','None'), 'A', G$_NLS.GET('x','SQL','Approved'), 'D', G$_NLS.GET('x','SQL','Denied'), 'F', G$_NLS.GET('x','SQL','Deferred')),1,30) |
DECODE(PHRACCR_CALC_GEN_IND) |
NA |
NO |
|
|
|
|
SUBSTR(DECODE(PHRACCR_CALC_GEN_IND, 'Y', G$_NLS.GET('x','SQL','Calculated'), 'N', G$_NLS.GET('x','SQL','Manual')),1,30) |
DECODE(PHRATND_TS_ROSTER_IND) |
NA |
NO |
COMPOSITE VIEW |
AP_PAYROLL_ATTENDANCE |
TIMESHEET_METHOD_DESC |
NO |
|
DECODE(PHRDOCM_DOC_TYPE) |
NA |
NO |
|
|
|
|
DECODE(PHRDOCM_DOC_TYPE, 'C', 'N', 'D', 'Y') |
DECODE(PHRELBD_TS_ROSTER_IND) |
NA |
NO |
COMPOSITE VIEW |
AP_PAYROLL_LABOR_DIST_OVERRIDE |
TIMESHEET_METHOD_DESC |
NO |
|
DECODE(PHRHIST_CALC_IND) |
NA |
NO |
|
|
|
|
SUBSTR(DECODE(PHRHIST_CALC_IND, 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Calculated')),1,30) |
DECODE(PHRHIST_PRINT_IND) |
NA |
NO |
|
|
|
|
SUBSTR(DECODE(PHRHIST_PRINT_IND, 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Calculated')),1,30) |
DECODE(PHRHIST_TYPE_IND) |
NA |
NO |
|
|
|
|
|
DECODE(PHRJOBS_TIME_ENTRY_IND) |
NA |
NO |
|
|
|
|
SUBSTR(DECODE(PHRJOBS_TIME_ENTRY_IND, 'P', G$_NLS.GET('x','SQL','Pay Period'), 'F', G$_NLS.GET('x','SQL','FSLA'), 'W', G$_NLS.GET('x','SQL','Weekly'), 'D', G$_NLS.GET('x','SQL','Daily'), 'N', G$_NLS.GET('x','SQL','None')),1,30) |
DECODE(PHRJOBS_TS_ROSTER_IND) |
NA |
NO |
|
|
|
|
SUBSTR(DECODE(PHRJOBS_TS_ROSTER_IND, 'T', G$_NLS.GET('x','SQL','Timesheet'), 'O', G$_NLS.GET('x','SQL','Organization'), 'R', G$_NLS.GET('x','SQL','Roster')),1,30) |
DECODE(PHRJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD') |
NA |
NO |
|
|
|
|
NA |
DECODE(PTRBDCA_CALC_RULE) |
NA |
NO |
|
|
|
|
substr(gokodsf.f_get_null_varchar2,1,6), substr(gokodsf.f_get_desc(null, 'GTVVPDI') ,1,30), substr(gokodsf.f_get_null_varchar2,1,6), substr(gokodsf.f_get_null_varchar2,1,6), |
DECODE(RCRAPP1_ACTIVE_DUTY,'1','Y','N') |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
ACTIVE_DUTY_IND |
NO |
|
DECODE(RCRAPP1_AT_RISK_HOMELESS,'1', 'Y','N') |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
AT_RISK_HOMELESS_IND |
NO |
|
DECODE(RCRAPP1_BORN_BEFORE_1_1_XX) |
RNANAXX RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
OLDER_THAN_24_IND |
NO |
|
DECODE(RCRAPP1_DEGREE_BY_JULY) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
DEGREE_BY_JULY_IND |
NO |
|
DECODE(RCRAPP1_EMANCIPATED_MINOR,'1', 'Y','N') |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
EMANCIPATED_MINOR_IND |
NO |
|
DECODE(RCRAPP1_HAS_LEGAL_DEPEND) |
RNANAXX RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LEGAL_DEPENDENT_IND |
NO |
|
DECODE(RCRAPP1_INS) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
PERM_RESIDENCY_CONFIRMED_IND |
NO |
|
DECODE(RCRAPP1_LEGAL_GUARDIAN,'1', 'Y', 'N') |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LEGAL_GUARDIAN_IND |
NO |
|
DECODE(RCRAPP1_LINE2_RELSHIP) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE2_RELATIONSHIP_DESC |
NO |
|
DECODE(RCRAPP1_LINE3_ATTEND_COLL) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE3_ATTEND_COLLEGE_DESC |
NO |
|
DECODE(RCRAPP1_LINE3_RELSHIP) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE3_RELATIONSHIP_DESC |
NO |
|
DECODE(RCRAPP1_LINE4_ATTEND_COLL) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE4_ATTEND_COLLEGE_DESC |
NO |
|
DECODE(RCRAPP1_LINE4_RELSHIP) |
NA |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE4_RELATIONSHIP_DESC |
NO |
|
DECODE(RCRAPP1_LINE5_ATTEND_COLL) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE5_ATTEND_COLLEGE_DESC |
NO |
|
DECODE(RCRAPP1_LINE5_RELSHIP) |
NA |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE5_RELATIONSHIP_DESC |
NO |
|
DECODE(RCRAPP1_LINE6_ATTEND_COLL) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE6_ATTEND_COLLEGE_DESC |
NO |
|
DECODE(RCRAPP1_LINE6_RELSHIP) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE6_RELATIONSHIP_DESC |
NO |
|
DECODE(RCRAPP1_LINE7_ATTEND_COLL) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE7_ATTEND_COLLEGE_DESC |
NO |
|
DECODE(RCRAPP1_LINE7_RELSHIP) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE7_RELATIONSHIP_DESC |
NO |
|
DECODE(RCRAPP1_LINE8_ATTEND_COLL) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE8_ATTEND_COLLEGE_DESC |
NO |
|
DECODE(RCRAPP1_LINE8_RELSHIP) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
LINE8_RELATIONSHIP_DESC |
NO |
|
DECODE(RCRAPP1_MRTL_STATUS) |
NA |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
MARITAL_STATUS_DESC |
NO |
|
DECODE(RCRAPP1_PAR_DIV_SEP_REM_IND) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
DIVORCED_PARENT_INFO_IND |
NO |
|
DECODE(RCRAPP1_PAR_HOUS_STAT) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
PARENT_HOUSING_STATUS_DESC |
NO |
|
DECODE(RCRAPP1_PAR_TAX_FORM_IND) |
RNAPRXX RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
PARENT_TAX_RETURN_TYPE_DESC |
NO |
|
DECODE(RCRAPP1_PERMIT_DRAFT_REG) |
RNANAXX |
NO |
|
|
|
|
|
DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
REQUESTED_AID_SPRING_DESC |
NO |
|
DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
REQUESTED_AID_NEXT_SUMMER_DESC |
NO |
|
DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
REQUESTED_AID_PREC_SUMMER_DESC |
NO |
|
DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
REQUESTED_AID_WINTER_DESC |
NO |
|
DECODE(RCRAPP1_SIGNED) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
APPLICATION_SIGNED_BY_DESC |
NO |
|
DECODE(RCRAPP1_TAX_FORM_IND) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
TAX_RETURN_TYPE_DESC |
NO |
|
DECODE(RCRAPP1_TITLE) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
NAME_PREFIX |
NO |
|
DECODE(RCRAPP1_UNACCOMP_YOUTH_HUD,'1', 'Y','N') |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
UNACCOMPANIED_YOUTH_HUD_IND |
NO |
|
DECODE(RCRAPP1_UNACCOMP_YOUTH_SCHOOL, '1', 'Y','N') |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
UNACCOMPANIED_YOUTH_SCHOOL_IND |
NO |
|
DECODE(RCRAPP1_US_VET) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
VETERAN_IND |
NO |
|
DECODE(RCRAPP1_VERIFICATION_MSG) |
RNARSXX RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
SELECTED_FOR_VERIFICATION_IND |
NO |
|
DECODE(RCRAPP1_YR_IN_COLL) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION1 |
YEAR_IN_COLLEGE_DESC |
NO |
|
DECODE(RCRAPP2_C_1_ANLY_TYPE) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
FM_ANALYSIS_TYPE_DESC |
NO |
|
DECODE(RCRAPP2_C_1_CTRB_OFFL_EST) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
FM_CONTRIBUTION_OFFICIAL_DESC |
NO |
|
DECODE(RCRAPP2_C_1_VA_BEN_INCL) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
FM_VETERAN_BENEFITS_IND |
NO |
|
DECODE(RCRAPP2_C_2_CTRB_OFFL_EST) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
IM_CONTRIBUTION_OFFICIAL_DESC |
NO |
|
DECODE(RCRAPP2_C_2_VA_BEN_INCL) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
IM_VETERAN_BENEFITS_IND |
NO |
|
DECODE(RCRAPP2_C_DEPEND_STATUS) |
NA |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
DEPENDENCY_STATUS_DESC |
NO |
|
DECODE(RCRAPP2_C_MRTL_STATUS) |
TBD |
NO |
|
|
|
|
|
DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
FM_PARENT_ANALYSIS_TYPE_DESC |
NO |
|
DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
FM_PARENT_CONTRIB_OFF_DESC |
NO |
|
DECODE(RCRAPP2_C_PAR_2_CTRB_FR_ASSET) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
IM_PARENT_CONTRIBUTION_ASSET |
NO |
|
DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
IM_PARENT_CONTRIB_OFF_DESC |
NO |
|
DECODE(RCRAPP2_C_PAR_MRTL_STATUS) |
TBD |
NO |
|
|
|
|
|
DECODE(RCRAPP2_ELIGIBILITY_MSG) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
SAR_C_IND |
NO |
|
DECODE(RCRAPP2_MODEL_CDE) |
ROASTAT |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
DEPENDENCY_INDEPEND_DESC |
NO |
|
DECODE(RCRAPP2_PELL_ANLY_TYPE) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
SIMPLIFIED_NEEDS_TEST_IND |
NO |
|
DECODE(RCRAPP2_PELL_CTRB_OFFL_EST) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
FM_EST_CONTRIB_OFFICIAL_DESC |
NO |
|
DECODE(RCRAPP2_PELL_PGI_OFFL_EST) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
PELL_EFC_OFFICIAL_DESC |
NO |
|
DECODE(RCRAPP2_PELL_P_ANLY_TYPE) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION2 |
FM_PARENT_EST_ANAL_TYPE_DESC |
NO |
|
DECODE(RCRAPP3_C_SIGNED) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
SIGNATURE_IND |
NO |
|
DECODE(RCRAPP3_C_SIGNED_FATH) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
FATHER_SIGNATURE_IND |
NO |
|
DECODE(RCRAPP3_C_SIGNED_MOTH) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
MOTHER_SIGNATURE_IND |
NO |
|
DECODE(RCRAPP3_C_SIGNED_SPS) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
SPOUSE_SIGNATURE_IND |
NO |
|
DECODE(RCRAPP3_DEGREE_TYPE) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
DEGREE_TYPE_DESC |
NO |
|
DECODE(RCRAPP3_FAA_DEP_OVERRIDE) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
DEPENDENCY_OVERRIDE_DESC |
NO |
|
DECODE(RCRAPP3_FATH_SSN_MATCH) |
RNANAXX RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
FATHER_TAX_ID_MATCH_DESC |
NO |
|
DECODE(RCRAPP3_GRAD_OR_PROF) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
GRADUATE_PROFESSIONAL_IND |
NO |
|
DECODE(RCRAPP3_LIVE_ON_FARM) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
RESIDE_FARM_IND |
NO |
|
DECODE(RCRAPP3_MARRIED) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
MARITAL_STATUS_IND |
NO |
|
DECODE(RCRAPP3_MOTH_SSN_MATCH) |
RNANAXX RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
MOTHER_TAX_ID_MATCH_DESC |
NO |
|
DECODE(RCRAPP3_OFFL_UNOFFL_IND) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
OFFICIAL_SOURCE_IND |
NO |
|
DECODE(RCRAPP3_PAR_LIVE_ON_FARM) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_RESIDE_FARM_IND |
NO |
|
DECODE(RCRAPP3_PREPARER_SIGN) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PREPARER_SIGNATURE_IND |
NO |
|
DECODE(RCRAPP3_SOC_SEC) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
TAX_ID_MATCH_STATUS_DESC |
NO |
|
DECODE(RCRAPP3_YR_IN_COLL_2) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
YEAR_IN_COLLEGE2_DESC |
NO |
|
DECODE(RCRAPP4_1040A_ELIG_IND) |
RNAPRXX RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
SHORT_TAX_FORM_IND |
NO |
|
DECODE(RCRAPP4_ADDRESS_CHG_FLAG) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
ADDRESS_CHANGE_DESC |
NO |
|
DECODE(RCRAPP4_CUSTODIAL_PARENT) |
RNASUXX RNINAIQ |
NO |
|
|
|
|
|
DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST) |
RNINAIQ |
NO |
|
|
|
|
|
DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST) |
RNINAIQ |
NO |
|
|
|
|
|
DECODE(RCRAPP4_EFC_CHANGE_IND) |
RNIMSXX |
NO |
|
|
|
|
|
DECODE(RCRAPP4_FEE_WAIVER_IND) |
TBD |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
PROFILE_FEE_WAIVER_IND |
NO |
|
DECODE(RCRAPP4_FORMULA_FOR_CALC) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
FM_FORMULA_DESC |
NO |
|
DECODE(RCRAPP4_HAVE_CHILDREN) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
SUPPORT_CHILDREN_IND |
NO |
|
DECODE(RCRAPP4_HS_GED_RCVD) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
SECONDARY_SCHOOL_DIPLOMA_IND |
NO |
|
DECODE(RCRAPP4_LEGAL_RES_IND) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
LEGAL_RESIDENT_IND |
NO |
|
DECODE(RCRAPP4_NSLDS_MATCH) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
NATIONAL_STUDENT_LOAN_SYS_DESC |
NO |
|
DECODE(RCRAPP4_PAR_1040A_ELIG_IND) |
RNAPRXX RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
PARENT_SHORT_TAX_FORM_IND |
NO |
|
DECODE(RCRAPP4_PAR_LEGAL_RES_IND) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
PARENT_LEGAL_RESIDENT_IND |
NO |
|
DECODE(RCRAPP4_SAR_C_CHANGE_FLAG) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
SAR_C_CHANGE_IND |
NO |
|
DECODE(RCRAPP4_SEC_INS_MATCH_IND) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
PERM_RESIDENCY_VER_STATUS_DESC |
NO |
|
DECODE(RCRAPP4_SOURCE_CORRECTION) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
CORRECTION_SOURCE_DESC |
NO |
|
DECODE(RCRAPP4_SSA_CITIZEN_IND) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
CITIZENSHIP_TYPE_DESC |
NO |
|
DECODE(RCRAPP4_SS_MATCH) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
MILITARY_REGIST_STATUS_DESC |
NO |
|
DECODE(RCRAPP4_SS_REG_FLAG) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
MILITARY_REG_REQ_STATUS_DESC |
NO |
|
DECODE(RCRAPP4_TX_RET_FILED_IND) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
TAX_RETURN_FILED_DESC |
NO |
|
DECODE(RCRAPP4_TYPE_DATA_AVAIL) |
RNINAIQ |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
DATA_TYPE_AVAILABLE_DESC |
NO |
|
DECODE(RCRAPP4_VA_MATCH_FLAG) |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
VETERAN_MATCH_STATUS_DESC |
NO |
|
DECODE(RCRAPP4_VISA_CLASS) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
VISA_CLASSIFICATION_DESC |
NO |
|
DECODE(RCRAPP4_WORK_STUDY) |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
WORK_STUDY_INTEREST_IND |
NO |
|
DECODE(RCRESAR_AUTO_ZERO_EFC_FLAG) |
RNIMSXX |
NO |
|
|
|
|
|
DECODE(RCRESAR_A_BORN_BEFORE_IND) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
OLDER_THAN_24_IND |
NO |
|
DECODE(RCRESAR_A_CITZ_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
ASSUMED_CITIZENSHIP_DESC |
NO |
|
DECODE(RCRESAR_A_MARRIED) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
ASSUMED_MARRIED_IND |
NO |
|
DECODE(RCRESAR_A_MRTL_STATUS_IND) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MARITAL_STATUS_IND |
NO |
|
DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
PARENT_MARITAL_STATUS_IND |
NO |
|
DECODE(RCRESAR_A_PAR_TAX_FILED_IND) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
PARENT_TAX_FILER_IND |
NO |
|
DECODE(RCRESAR_A_S_DEPENDANTS) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
ASSUMED_DEPENDENT_IND |
NO |
|
DECODE(RCRESAR_A_TAX_FILED_IND) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
TAX_FILER_IND |
NO |
|
DECODE(RCRESAR_A_VA_STATUS) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
ASSUMED_VETERAN_IND |
NO |
|
DECODE(RCRESAR_DUP_REQ_IND) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
DUPLICATE_REQUEST_IND |
NO |
|
DECODE(RCRESAR_EDE_ETI_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
ISIR_ELECT_TRANSACTION_DESC |
NO |
|
DECODE(RCRESAR_EDE_INST_IND) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
ELECT_APPL_ENTRY_SOURCE_IND |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_1) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING1_DESC |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_10) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING10_DESC |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_2) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING2_DESC |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_3) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING3_DESC |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_4) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING4_DESC |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_5) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING5_DESC |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_6) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING6_DESC |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_7) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING7_DESC |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_8) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING8_DESC |
NO |
|
DECODE(RCRESAR_FED_HOUS_CDE_9) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
FEDERAL_HOUSING9_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_1) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG1_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_10) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG10_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_2) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG2_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_3) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG3_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_4) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG4_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_5) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG5_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_6) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG6_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_7) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG7_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_8) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG8_DESC |
NO |
|
DECODE(RCRESAR_M_SCHOOL_FLAG_9) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
MULTI_SCHOOL_FLAG9_DESC |
NO |
|
DECODE(RCRESAR_REC_TYPE) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
PROCESSED_RECORD_TYPE_DESC |
NO |
|
DECODE(RCRESAR_SEC_EFC_TYPE) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
SECONDARY_EFC_TYPE_DESC |
NO |
|
DECODE(RCRESAR_SUB_APP) |
RNIMSXX |
NO |
|
|
|
|
|
DECODE(RCRIMP1_AID_STATUS) |
RNASUXX |
NO |
|
|
|
|
|
DECODE(RCRIMP1_APPLIC_TYPE) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
APPLICATION_TYPE_DESC |
NO |
|
DECODE(RCRIMP1_FIN_AID_STATUS) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
FINANCIAL_AID_STATUS_DESC |
NO |
|
DECODE(RCRIMP1_FOREIGN_ADDR_IND) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
FOREIGN_ADDRESS_IND |
NO |
|
DECODE(RCRIMP1_HOUS_CDE_10) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
HOUSING10_DESC |
NO |
|
DECODE(RCRIMP1_HOUS_CDE_9) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
HOUSING9_DESC |
NO |
|
DECODE(RCRIMP1_LINE2_SCHL_TYPE) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
LINE2_SCHOOL_TYPE_DESC |
NO |
|
DECODE(RCRIMP1_LINE3_SCHL_TYPE) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
LINE3_SCHOOL_TYPE_DESC |
NO |
|
DECODE(RCRIMP1_LINE4_SCHL_TYPE) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
LINE4_SCHOOL_TYPE_DESC |
NO |
|
DECODE(RCRIMP1_LINE5_SCHL_TYPE) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
LINE5_SCHOOL_TYPE_DESC |
NO |
|
DECODE(RCRIMP1_LINE6_SCHL_TYPE) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
LINE6_SCHOOL_TYPE_DESC |
NO |
|
DECODE(RCRIMP1_LINE7_SCHL_TYPE) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
LINE7_SCHOOL_TYPE_DESC |
NO |
|
DECODE(RCRIMP1_LINE8_SCHL_TYPE) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
LINE8_SCHOOL_TYPE_DESC |
NO |
|
DECODE(RCRIMP1_LOCATION_COMPUTER) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
PROFILE_COMPUTER_LOCATION_DESC |
NO |
|
DECODE(RCRIMP1_ONLINE_SIG) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
ONLINE_SIGNATURE_IND |
NO |
|
DECODE(RCRIMP1_OWN_BUS_HM_SELF_EMP) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
IM_SELF_EMPLOYED_IND |
NO |
|
DECODE(RCRIMP1_PAR_NTRL_SEP_DIV) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
PARENT_MARIT_STAT_SEP_DIV_DESC |
NO |
|
DECODE(RCRIMP1_PAR_OWN_BUS_FARM) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
PARENT_OWN_BUSINESS_IND |
NO |
|
DECODE(RCRIMP1_PAR_SELF_EMPLOYED) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
IM_PARENT_SELF_EMPLOYED_IND |
NO |
|
DECODE(RCRIMP1_PAR_SMALL_BUSINESS) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
IM_PARENT_LARGE_BUSINESS_IND |
NO |
|
DECODE(RCRIMP1_SMALL_BUSINESS) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
IM_LARGE_BUSINESS_IND |
NO |
|
DECODE(RCRIMP1_STU_MOST_SUPPORT_FROM) |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
PARENT_SUPPORT_PRIMARY_DESC |
NO |
|
DECODE(RCRIMP1_TRUST_AVAIL_IND) |
RNAPRXX RNASUXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
TRUST_AVAILABILITY_IND |
NO |
|
DECODE(RCRIMP1_TRUST_ESTAB_BY) |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_PROFILE_SPEC |
TRUST_ESTABLISHER_DESC |
NO |
|
DECODE(RNROVRD_ADD_BK_HOPE_OPT) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_ALLOW_IM_PC_LOWR_FM) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_ALLOW_IM_SC_LOWR_FM) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_CALC_US_TAX_FM) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_CALC_US_TAX_IM) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_CALC_FEDERAL_TAX_OVR_DESC |
NO |
|
DECODE(RNROVRD_CHG_DEPEND_FM) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_CHANGE_DEPENDENCY_STAT_DESC |
NO |
|
DECODE(RNROVRD_CHG_DEPEND_IM) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_CHANGE_DEPENDENCY_STAT_DESC |
NO |
|
DECODE(RNROVRD_FAMILY_ASSETS) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_ASSET_COMBINED_DESC |
NO |
|
DECODE(RNROVRD_FM_PAR_NUM_COL) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_PARENT_NO_COLLEGE_OVR_IND |
NO |
|
DECODE(RNROVRD_F_SSN_NO_DOB_REJ_OVRD) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_REJECT_S_IND |
NO |
|
DECODE(RNROVRD_F_SSN_NO_NAME_REJ_OVRD) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_REJECT_E_IND |
NO |
|
DECODE(RNROVRD_HOME_VAL_PROJ) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_HOME_VALUE_PROJ_DESC |
NO |
|
DECODE(RNROVRD_INV_PROJ) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_IMPUTE_ASSET_DESC |
NO |
|
DECODE(RNROVRD_LIMIT_PC_BY_BDGT) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
LIMIT_OTHERS_SHARE_PC_DESC |
NO |
|
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD_ |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_REJECT_T_IND |
NO |
|
DECODE(RNROVRD_M_SSN_NO_NAME_REJ_OVRD) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_REJECT_F_IND |
NO |
|
DECODE(RNROVRD_NON_CUST_OPT) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_NONCUS_CONT_CAL_DESC |
NO |
|
DECODE(RNROVRD_NON_CUST_PC_OPT) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_PAR_ADD_BK_HOPE_OPT) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_PAR_AGI_OPT) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_WHICH_AGI_DESC |
NO |
|
DECODE(RNROVRD_PAR_CALC_US_TAX_FM) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_PAR_CALC_US_TAX_IM) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_CALC_FED_TAX_OV_DESC |
NO |
|
DECODE(RNROVRD_PAR_USE_PROJ_INC_EFM) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_SKIP_AGE_EXCL) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_SSN_NO_DOB_REJ_OVRD) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_REJECT_R_IND |
NO |
|
DECODE(RNROVRD_SSN_NO_NAME_REJ_OVRD) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_REJECT_D_IND |
NO |
|
DECODE(RNROVRD_S_HOME_VAL_PROJ) |
NA |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_HOME_VALUE_PROJECT_DESC |
NO |
|
DECODE(RNROVRD_USE_PROJ_INC_EFM) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
USE_PARENT_STATE_PROV_TAX_IND |
NO |
|
DECODE(RNROVRD_ZERO_LOSS_BUS_FARM) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RNROVRD_ZERO_LOSS_OTH) |
RNAOVXX |
NO |
|
|
|
|
|
DECODE(RPRADSB_ALTERNATE_PELL_IND,'N') |
ROAPELL |
NO |
|
|
|
|
|
DECODE(RPRADSB_CONCUR_ENROLL_FLAG) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
COD_CONCURRENT_ENROLLMENT_IND |
NO |
|
DECODE(RPRADSB_DEBIT_CREDIT_IND) |
RPRADSB |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
DEBIT_CREDIT_DESC |
NO |
|
DECODE(RPRADSB_DISBURSE_LOAD) |
RPAAWRD |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
DISBURSEMENT_LOAD_DESC |
NO |
|
DECODE(RPRADSB_DISBURSE_LOAD_OPT) |
RPRADSB |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
DISBURSEMENT_LOAD_OPT_DESC |
NO |
|
DECODE(RPRADSB_DISB_ACPT_DEBIT_CR_IND) |
RPRADSB |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
COD_DEBIT_CREDIT_DESC |
NO |
|
DECODE(RPRADSB_DISB_ACTION_CODE) |
RPRADSB |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
COD_DISBURSEMENT_ACTION_DESC |
NO |
|
DECODE(RPRADSB_PELLC_DISB_LOAD) |
RPAAWRD |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
PELL_CALCULATED_DISB_LOAD_DESC |
NO |
|
DECODE(RPRADSB_PELLC_DISB_LOAD_OPT) |
RPRADSB |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
PELL_CALC_DISB_LOAD_OPT_DESC |
NO |
|
DECODE(RPRADSB_POTENTIAL_OVERPMT_FLAG) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
COD_POTENTIAL_OVERPAYMENT_IND |
NO |
|
DECODE(RPRADSB_SHARED_SAR_ID_FLAG) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
COD_SHARED_SAR_IDENTIFIER_IND |
NO |
|
DECODE(RPRARSC_TYPE_CODE) |
RPAARSC |
NO |
COMPOSITE VIEW |
AR_APPLICANT_RESOURCE |
RESOURCE_TYPE_DESC |
NO |
|
DECODE(RPRATRM_LOCK_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
AWARD_LOCKED_DESC |
NO |
This function returns Locked if the student's lock indicator RPRATRM_LOCK_IND is Y, Locked except for enrollment adjustments during disbursement if the value is E, and Not Locked if the value is N. |
DECODE(RPRATRM_NSLDS_OVRD_IND) |
NA |
NO |
|
|
|
|
This function returns Limit Tests (aggregate) if the student rules have been overridden for the award for the period if the value is L, Default Tests if the value is D, Overpayment Tests if the value is O, and All Tests if the value is A. |
DECODE(RPRATRM_PCKG_LOAD_IND) |
NA |
NO |
|
|
|
|
This function returns Full Time as a time status description if the packaging load indicator for the student RPRATRM_PCKG_LOAD_IND is 1, 3/4 Time if 2, 1/2 Time if 3, Less than 1/2 Time if 4, and Not Enrolled if 5. |
DECODE(RPRATRM_PELL_AWRD_LOAD_OPT) |
NA |
NO |
|
|
|
|
This function returns Full Time as a pell enrollment award option description if the applicant grant award enrollment option for the student RPRATRM_PELL_AWRD_LOAD_OPT is 1, 3/4 Time if 2, 1/2 Time if 3, Less than 1/2 Time if 4, Adjusted Hours if A, Billing hours if B, Defaults if D, Expected enrollment if E, ISIR/FAFSA enrollment if I, and Manual if M. |
DECODE(RPRAWRD_LOCK_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
ANNUAL_AWARD_LOCKED_DESC |
NO |
This function returns Locked as an award locked description if the award has been locked for the student RPRAWRD_LOCK_IND is Y, Locked except for enrollment adjustements during disbursement if E, and Not locked if N. |
DECODE(RPRAWRD_OVERRIDE_YR_IN_COLL) |
NA |
NO |
|
|
|
|
|
DECODE(RPRAWRD_SYS_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_PERSON |
SYSTEM_DESC |
NO |
This function returns Manual as a system description if the system indicator for the applicant RPRAWRD_SYSTEM_IND is M, System if S, and Both if B. |
DECODE(RPRAWRD_UNMET_NEED_OVRDE_IND) |
NA |
NO |
|
|
|
|
This function returns Loan as an unmet need override description if the unmet need override indicator for the applicant RPRAWRD_UNMET_NEED_OVRD_IND is L, No if N, and Yes if Y. |
DECODE(RPRLADB_DISBURSE_LOAD) |
RPALDSB |
NO |
COMPOSITE VIEW |
AR_LOAN_DISBURSEMENT |
ENROLLMENT_LOAD_DESC |
NO |
|
DECODE(RPRLADB_DISBURSE_LOAD_OPT) |
RPALDSB |
NO |
|
|
|
|
|
DECODE(RPRLADB_DISB_STATUS) |
RPALORG |
NO |
|
|
|
|
|
DECODE(RPRLADB_FEED_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_LOAN_DISBURSEMENT |
DISBURSEMENT_FEED_DESC |
NO |
|
DECODE(RPRLADB_HOLD_REL_STATUS) |
RPAELAP |
NO |
COMPOSITE VIEW |
AR_LOAN_DISBURSEMENT |
HOLD_RELEASE_STATUS_DESC |
NO |
|
DECODE(RPRLADB_SERV_TRANS_TYPE) |
NA |
NO |
COMPOSITE VIEW |
AR_LOAN_DISBURSEMENT |
TRANSACTION_TYPE_DESC |
NO |
|
DECODE(RPRLAPP_COSIGN1_RELATION_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
COSIGN1_RELATIONSHIP_DESC |
NO |
DECODE(RPRLAPP_COSIGN1_RELATION_IND,'E','Employer','F','Friend','G','Guardian','O','Other','P','Parent','R','Relative','S','Sibling',NULL) |
DECODE(RPRLAPP_COSIGN2_RELATION_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
COSIGN2_RELATIONSHIP_DESC |
NO |
DECODE(RPRLAPP_COSIGN1_RELATION_IND,'E','Employer','F','Friend','G','Guardian','O','Other','P','Parent','R','Relative','S','Sibling',NULL) |
DECODE(RPRLAPP_IN_DEFAULT) |
RPALORG |
NO |
|
|
|
|
|
DECODE(RTVFSRC_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_FINAID_FUND |
FUND_SOURCE_TYPE_DESC |
NO |
NA |
DECODE(RTVFTYP_ATYP_IND) |
NA |
NO |
COMPOSITE VIEW |
AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND |
FINANCIAL_AID_TYPE_DESC GIFT_OR_SELF_HELP_AID_DESC GIFT_OR_SELF_HELP_AID |
NO NO NO |
NA |
DECODE(RTVFTYP_IND) |
NA |
NO |
|
|
|
|
|
DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME') |
SAAADMS |
NO |
|
|
|
|
NA |
DECODE(SFBETRM_AR_IND) |
TBD |
NO |
|
|
|
|
|
DECODE(SFBETRM_MAXH_SRCE_CDE) |
TBD |
NO |
|
|
|
|
|
DECODE(SFBETRM_MINH_SRCE_CDE) |
TBD |
NO |
|
|
|
|
|
DECODE(SFBETRM_PIDM, NULL, 'N', 'Y') |
NA |
NO |
|
|
|
|
|
DECODE(SFRPLAN_COMMENT) |
NA |
NO |
|
|
|
|
|
DECODE(SFRPLAN_SRC_CDE) |
NA |
NO |
|
|
|
|
|
DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y') |
SFASLST |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY |
FINAL_GRADE_ROLL_IND FINAL_GRADE_ROLL_IND |
NO NO |
This function returns an N if the grade date SFRSTCR_GRDE_DATE is null else it returns a Y. |
DECODE(SFRSTCR_PIDM,NULL,'N','Y') |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
IN_PROGRESS_COURSE_IND |
NO |
This function returns an N if the registration record SFRSTCR does not exist for the specified UID, academic period and course else it returns a Y. |
DECODE(SFRSTCR_PIDM,NULL,'Y','N') |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_IN_PROGRESS |
TRANSFER_COURSE_IND INSTITUTION_COURSE_IND |
NO NO |
This function returns an N if the registration record SFRSTCR does not exist for the specified UID, academic period and course else it returns a Y. |
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1)+DECODE(SGBSTDN_LEVL_CODE_2,NULL,0, DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1)) |
SGASTDN |
NO |
|
|
|
|
This function returns a 0, 1, or 2 based on the matriculated academic period SGBSTDN_TERM_CODE_MATRIC and the secondary level code SGBSTDN_LEVL_CODE_2. If the matriculated academic period is null and the secondary level code is null then this will return a 0. If the matriculated academic period is null and the secondary level code is not null then this will return a 0. If the matriculated academic period is not null and the secondary level code is null then it will return a 1. If both values are not null then it will return a 2. |
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,N, Y) |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
MATRICULATED_IND |
NO |
DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,N,Y) |
DECODE(SHRATTR_PIDM, NULL, 'N', 'Y') |
NA |
NO |
|
|
|
|
NA |
DECODE(SHRDGDH_HOND_CODE,NULL,NULL,'D') |
SHADEGR |
NO |
COMPOSITE VIEW |
AS_OUTCOME_HONOR_DEPT |
HONOR_IND |
NO |
This function returns a null if the honor code SHRDGDH_HOND_CODE is null, else it returns an D. |
DECODE(SHRDGIH_HONR_CODE,NULL,NULL,'I') |
SHADEGR |
NO |
COMPOSITE VIEW |
AS_OUTCOME_HONOR_INST |
HONOR_IND |
NO |
This function returns a null if the honor code SHRDGIH_HONR_CODE is null, else it returns an I. |
DECODE(SHRLGPA_GPA_TYPE_IND,'I', 'INSTITUTION','T','TRANSFER','O', 'OVERALL') |
NA |
NO |
COMPOSITE VIEW |
AS_GPA_LEVEL |
GPA_TYPE_DESC |
NO |
This function returns Institution if the gpa type indicator SHRLGPA_GPA_TYPE_IND is I, it returns Transfer if the gpa type indicator is a T else it returns Overall if the gpa type indicator is an O. |
DECODE(SHRTATT_PIDM, NULL, 'N', 'Y') |
NA |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_ATTR_TRANS |
TRANSFER_COURSE_IND |
NO |
NA |
DECODE(SHRTATT_PIDM, NULL, 'Y', 'N') |
NA |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_ATTR_TRANS |
INSTITUTION_COURSE_IND |
NO |
NA |
DECODE(SHRTGPA_GPA_TYPE_IND,'I', 'INSTITUTION','T','TRANSFER') |
NA |
NO |
COMPOSITE VIEW |
AS_GPA_TERM |
GPA_TYPE_DESC |
NO |
This function returns Institution if the gpa type indicator SHRLGPA_GPA_TYPE_IND is I, else it returns Transfer if the gpa type indicator is a T. |
DECODE(SHRTRCE_PIDM,NULL,'N','Y') |
SHATRNS |
NO |
|
|
|
|
This function returns a N if the transfer course record SHRTRCE doesn't exist, else a Y. |
DECODE(SHRTRCR_ART_IND,NULL,'NO ARTICULATION RULE','N','COURSE HAS NO INSTITUTION EQUIVALENT','Y','COURSE HAS INSTITUTION EQUIVALENT') |
TBD |
NO |
|
|
|
|
|
DECODE(SHRTTRM_RECORD_STATUS_IND) |
NA |
NO |
|
|
|
|
|
DECODE(SIBFACD_PRIMARY_ACTIVITY) |
NA |
NO |
|
|
|
|
This function returns Administrator as primary activity description if the primary activity for the faculty SIBFACD_PRIMARY_ACTIIVTY is A, Instructional if I, and Research if R. |
DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C', 'CLASS','OTHER') |
SLARASG |
NO |
COMPOSITE VIEW |
AS_ROOM_ASSIGNMENT |
ROOM_TYPE_DESC |
NO |
This function returns DORM if the room type SLBRDEF_ROOM_TYPE is D, CLASS if the room type is C else OTHER. |
DECODE(SORAPPT_INTV_PIDM,NULL,NULL, F_FORMAT_NAME(SORAPPT_INTV_PIDM,'LFMI')) |
SOAAPPT |
NO |
|
|
|
|
This function returns null if the pidm is null SORAPPT_INTV_PIDM else it returns the formatted name of the interviewer. |
DECODE(SORBACD_STATE_APPROV_IND) |
NA |
NO |
|
|
|
|
DECODE(SORBACD_STATE_APPROV_IND,'Y','Y','N') |
DECODE(SORDEGR_SBGI_CODE) |
NA |
NO |
|
|
|
|
|
DECODE(SORLCUR_SITE_CODE) |
NA |
NO |
|
|
|
|
DECODE(SORLCUR_SITE_CODE,NULL,SGBSTDN_SITE_CODE,SORLCUR_SITE_CODE) |
DECODE(SORLCUR_TERM_CODE_ADMIT) |
NA |
NO |
|
|
|
|
NA |
DECODE(SORLCUR_TERM_CODE_MATRIC) |
SGASTDN |
NO |
|
|
|
|
DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,'N','Y') |
DECODE(SPBPERS_NAME_PREFIX,NULL,DECODE( SPBPERS_SEX,'M','MR.','F','MS.'), SPBPERS_NAME_PREFIX) |
NA |
NO |
|
|
|
|
This function returns Mr. or Ms. Based on the gender if the name prefix SPBPERS_NAME_PREFIX is null, else it returns the name prefix. |
DECODE(SPBPERS_SEX,'M','MALE','F', 'FEMALE','N','NOT REPORTED') |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON AA_RELATIONSHIP |
GENDER_DESC RELATED_GENDER_DESC |
NO NO |
This calculation returns MALE if the gender SPBPERS_SEX is M else it returns FEMALE if the gender is F else if the gender is N it returns NOT REPORTED. |
DECODE(SPBPERS_VERA_IND) |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
VETERAN_CATEGORY_DESC |
NO |
This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran. |
DECODE(SPBPERS_VERA_IND, NULL, NULL, O, OTHER PROTECTED VETERAN ONLY, V, VIETNAM VETERAN ONLY, B, BOTH - VIETNAM AND OTHER ELIGIBLE VETERAN) |
SPAPERS |
NO |
|
|
|
|
NA |
DECODE(SPBPERS_VERA_IND,NULL,NULL, 'VETERAN') |
SPAPERS |
NO |
|
|
|
|
This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran. |
DECODE(SPRIDEN_ID,NULL,NULL,'BANNER') |
NA |
NO |
COMPOSITE VIEW |
AS_PERSON |
ID_NUMBER_SOURCE |
NO |
This function returns null if the id SPRIDEN_ID is null else it returns BANNER. |
DECODE(SPRMEDI_DISB_IND,'Y','Y','N') |
SPAMEDI |
NO |
COMPOSITE VIEW |
AS_MEDICAL_INFORMATION |
PRIMARY_DISABILITY_IND |
NO |
NA |
DECODE(SSRFEES_FEE_IND) |
SSADETL |
NO |
|
|
|
|
|
DECODE(STVAPDC_APPL_INACT) |
NA |
NO |
COMPOSITE VIEW |
AS_ADMISSIONS_DECISION |
APPLICATION_INACTIVE_IND |
NO |
DECODE (stvapdc_appl_inact, NULL, 'N', stvapdc_appl_inact) |
DECODE(STVAPDC_INST_ACC_IND) |
NA |
NO |
COMPOSITE VIEW |
AS_ADMISSIONS_DECISION |
INSTITUTION_ADMIT_IND |
NO |
DECODE (stvapdc_inst_acc_ind, NULL, 'N', stvapdc_inst_acc_ind) |
DECODE(STVAPDC_REJECT_IND) |
NA |
NO |
COMPOSITE VIEW |
AS_ADMISSIONS_DECISION |
INSTITUTION_DENIED_IND |
NO |
DECODE (stvapdc_reject_ind, NULL, 'N', stvapdc_reject_ind) |
DECODE(STVAPDC_SIGNF_IND) |
NA |
NO |
COMPOSITE VIEW |
AS_ADMISSIONS_DECISION |
APPLICATION_SIGNIF_IND |
NO |
DECODE (stvapdc_signf_ind, NULL, 'N', stvapdc_signf_ind) |
DECODE(STVAPDC_STDN_ACC_IND) |
NA |
NO |
COMPOSITE VIEW |
AS_ADMISSIONS_DECISION |
APPLICANT_ACCEPT_IND |
NO |
This functions returns Applicant when the indicator ro student acceptance indicated by the decision value is Y, Institution with the value for institution acceptance indicated by the decision value is Y, Institution when the decision code is a reject decision, and Indeterminate if either value is null. CASE WHEN stvapdc_stdn_acc_ind = 'Y' THEN 'Applicant' WHEN stvapdc_inst_acc_ind = 'Y' THEN 'Institution' WHEN stvapdc_reject_ind = 'Y' THEN 'Institution' ELSE 'Indeterminate' END |
DECODE(STVEVEN_TRANS_IND) |
NA |
NO |
|
|
|
|
|
DECODE(STVRESD_IN_STATE_IND) |
NA |
NO |
|
|
|
|
|
DECODE(STVRRCD_MONTHLY_IND,'Y', 'MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y', 'DAILY','TERMLY')) |
SLARASG |
NO |
COMPOSITE VIEW |
AS_ROOM_ASSIGNMENT |
ROOM_RATE_TIME |
NO |
This function returns Monthly if the monthly indicator STVRRCD_MONTHLY_IND is Y, it returns Daily if the daily indicator STVRRCD_DAILY_IND is Y, else it returns Termly. |
DECODE(STVSBGI_TYPE_IND,'C','COLLEGE', 'H','HIGHSCHOOL','S','SOURCE-ONLY',NULL) |
SOASBGI |
NO |
COMPOSITE VIEW |
AS_INSTITUTION |
INSTITUTION_TYPE_DESC |
NO |
This function returns COLLEGE when the institution type STVSBGI_TYPE_IND is C, HIGHSCHOOL if the institution type is an H, SOURCE-ONLY if the institution type is S else null. |
DECODE(TBBACCT_REFUND_IND) |
NA |
NO |
|
|
|
|
This function determines the refund indicator description based upon the refund indicator. 'N'= 'No refund' 'Y' = 'Generate Refund' 'P' = 'Refund being processed' or NULL |
DECODE(TBBCSTU_DEL_IND) |
TSACONT |
NO |
COMPOSITE VIEW |
AT_CONTRACT |
STUDENT_INACTIVATED_IND |
NO |
NA |
DECODE(TBBESTU_DEL_IND) |
TSAEXPP |
NO |
COMPOSITE VIEW |
AT_EXEMPTION |
EXEMPTION_CANCELLED |
NO |
NA |
DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y') |
TSADETC |
NO |
COMPOSITE VIEW |
AT_ACCOUNT_DETAIL |
RETURNED_CHECK_IND |
NO |
This function returns a N if the detail code TBBRETC_DETAIL_CODE is null else it return a Y. |
DECODE(TBRACCD_BILL_DATE, NULL, NULL, TBRACCD_AMOUNT) |
TSADETL |
NO |
COMPOSITE VIEW |
AT_ACCOUNT_DETAIL |
BILL_AMOUNT |
NO |
This function returns a null if the billing date TBRACCD_BILL_DATE is null, else it returns the transaction amount TBRACCD_AMOUNT. |
DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_AMOUNT) |
TSADETL |
NO |
COMPOSITE VIEW |
AT_ACCOUNT_DETAIL |
ACCOUNT_POSTED_AMOUNT |
NO |
This function returns null if the feed date TBRACCD_FEED_DATE is null else it returns the transaction amount TBRACCD_AMOUNT. |
DECODE(TBRDEPO_FEED_DATE, NULL, NULL, TBRDEPO_AMOUNT) |
TSADETL |
NO |
COMPOSITE VIEW |
AT_AR_DEPOSIT |
ACCOUNT_POSTED_AMOUNT |
NO |
This function returns null if the feed date TBRDEPO_FEED_DATE is null else it returns the transaction amount TBRDEPO_AMOUNT. |
DECODE(TBRMISD_PIDM) |
TFAMISC |
NO |
|
|
|
|
This function determines if the entity is external to the system. |
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y') |
NA |
NO |
COMPOSITE VIEW |
AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_PLAN |
PLANNED_MOVE_COMPLETE_IND MOVE_COMPLETION_IND |
NO NO |
NA |
DECODE(TRANSACTION_HISTORY.FUND_POOL, NULL,FUND_HIERARCHY.FUND_POOL_DESC, TRANSACTION_HISTORY.FUND_POOL_DESC) |
NA |
NO |
|
|
|
|
Population of fund pool description is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history. |
EARN |
NA |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
PAF_TRANSACTION_TYPE |
NO |
|
FFRMASA_AMT+FFRMASA_ADJ_AMT- FFRMASA_DEPR_ACCUM_AMT |
FFAMAST |
NO |
COMPOSITE VIEW |
AF_FIXED_ASSET_DEPRECIATION |
BOOK_VALUE |
NO |
This calculation returns the book value for an asset by taking its original cost adding any adjustments and then subtracting the accumulated depreciation. |
FGBGENL_SUM_PERIODIC_DR- FGBGENL_SUM_PERIODIC_CR |
FGIGLAC |
NO |
COMPOSITE VIEW |
AF_GENERAL_LEDGER |
CURRENT_ACTUAL |
NO |
This calculation returns the current actual for the general ledger entry by subtracting the credits from the debits. |
FGBOPAL_XX_ACCTD_BUD - FGBOPAL_XX- 1_ACCT_BUD |
FGIBDST |
NO |
COMPOSITE VIEW |
AF_OPERATING_LEDGER |
CURR_ACCUMULATED_BUDGET |
NO |
This calculation returns the accumulated budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FGBOPAL_XX_ADOPT_BUD - FGBOPAL_XX- 1_ADOPT_BUD |
FGIBDST |
NO |
COMPOSITE VIEW |
AF_OPERATING_LEDGER |
CURR_ADOPTED_BUDGET |
NO |
This calculation returns the adopted budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FGBOPAL_XX_BUD_ADJT - FGBOPAL_XX- 1_BUD_ADJT |
FGIBDST |
NO |
COMPOSITE VIEW |
AF_OPERATING_LEDGER |
CURR_BUDGET_ADJUSTMENTS |
NO |
This calculation returns the budget adjustments for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FGBOPAL_XX_BUD_RSRV - FGBOPAL_XX- 1_BUD_RSRV |
FGIBDST |
NO |
COMPOSITE VIEW |
AF_OPERATING_LEDGER |
CURR_BUDGET_RESERVATION |
NO |
This calculation returns the budget reservations for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FGBOPAL_XX_ENCUMB - FGBOPAL_XX-1_ENCUMB |
FGIBDST |
NO |
COMPOSITE VIEW |
AF_OPERATING_LEDGER |
CURR_ENCUMBRANCES |
NO |
This calculation returns the encumbrances for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FGBOPAL_XX_TEMP_BUD - FGBOPAL_XX- 1_TEMP_BUD |
FGIBDST |
NO |
COMPOSITE VIEW |
AF_OPERATING_LEDGER |
CURR_TEMPORARY_BUDGET |
NO |
This calculation returns the temporary budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FGBOPAL_XX_YTD_ACTV - FGBOPAL_XX- 1_YTD_ACTV |
NA |
NO |
COMPOSITE VIEW |
AF_OPERATING_LEDGER |
CURR_YEAR_TO_DATE_ACTIVITY |
NO |
This calculation returns the activity for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FRRGRNL_XX_ACCTD_BUD - FRRGRNL_XX- 1_ACCTD_BUD |
FRIGITD |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
CURR_ACCOUNTED_BUDGET |
NO |
This calculation returns the accounted budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FRRGRNL_XX_ADOPT_BUD - FRRGRNL_XX- 1_ADOPT_BUD |
FRIGITD |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
CURR_ADOPTED_BUDGET |
NO |
This calculation returns the adopted budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FRRGRNL_XX_BUD_ADJT - FRRGRNL_XX- 1_BUD_ADJT |
FRIGITD |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
CURR_BUDGET_ADJUSTMENTS |
NO |
This calculation returns the budget adjustments for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FRRGRNL_XX_BUD_RSRV - FRRGRNL_XX- 1_BUD_RSRV |
FRIGITD |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
CURR_BUDGET_RESERVATIONS |
NO |
This calculation returns the budget reservations for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FRRGRNL_XX_ENCUMB - FRRGRNL_XX-1_ENCUMB |
FRIGITD |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
CURR_ENCUMBRANCES |
NO |
This calculation returns the encumbrances for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FRRGRNL_XX_TEMP_BUD - FRRGRNL_XX- 1_TEMP_BUD |
NA |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
CURR_TEMPORARY_BUDGET |
NO |
This calculation returns the temporary budget for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FRRGRNL_XX_YTD_ACTV - FRRGRNL_XX- 1_YTD_FRRGRNL |
FRIGITD |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
CURR_YEAR_TO_DATE_ACTIVITY |
NO |
This calculation returns the activity for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FRRMEML_XX_YTD_ACTV - FRRMEML_XX- 1_YTD_ACTV |
FRIMEMO |
NO |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
CURR_MEMO_COSTS |
NO |
This calculation returns the memo costs for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative. |
FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVENT_DESC |
NA |
NO |
|
|
|
|
|
FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC |
NA |
NO |
COMPOSITE VIEW |
AF_GRANT_EVENT |
GRANT_EVENT_FULL_DESC |
NO |
|
FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||F TVSHIP_PHONE_EXT |
NA |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM AF_PURCHASE_ORDER |
PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED |
NO NO |
This calculation formulates the combined phone number by concatenating FTVSHIP_PHONE_AREA, FTVSHIP_PHONE_NUM, and FTVSHIP_PHONE_EXT. |
FTVVEND_PHONE_AREA||FTVVEND_PHONE_NUMBER ||FTVVEND_PHONE_EXT |
NA |
NO |
COMPOSITE VIEW |
AF_VENDOR |
PHONE_NUMBER_COMBINED |
NO |
This calculation formulates the combined phone number by concatenating FTVVEND_PHONE_AREA, FTVVEND_PHONE_NUMBER, and FTVVEND_PHONE_EXT. |
F_GET_NORM_BALANCE |
NA |
NO |
|
|
|
|
|
IF AGBMGID_AMT_PAID > = AGBMGID_AMT THEN Y, ELSE N |
NA |
NO |
|
|
|
|
NA |
IF AGBMGID_AMT_PAID IS > 0 AND < AGBMGID_AMT THEN Y, ELSE N |
NA |
NO |
|
|
|
|
NA |
LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+ RCRAPP2_C_PAR_1_CTRB_FOR_STDT) |
NA |
NO |
|
|
|
|
LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT) |
LEVEL |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY AF_ACCOUNT_HIERARCHY AF_FUND_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY AF_FUND_HIERARCHY_FISCAL |
FUND_TYPE_LEVEL ACCOUNT_TYPE_LEVEL FUND_LEVEL PROGRAM_LEVEL ACCOUNT_LEVEL ACCOUNT_LEVEL LOCATION_LEVEL ORGANIZATION_LEVEL ORGANIZATION_LEVEL ACCOUNT_TYPE_LEVEL FUND_LEVEL LOCATION_LEVEL PROGRAM_LEVEL FUND_TYPE_LEVEL |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
This value is retrieved upon formulation of the validation table hierarchy and pertains to what level this code associates to within its hierarchy. (Level 1 being the highest level.) |
MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS - MAKFUNC.F_CAMP_EXPENSES |
NA |
NO |
|
|
|
|
|
MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS |
NA |
NO |
|
|
|
|
|
MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES - MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS |
NA |
NO |
|
|
|
|
|
MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100 |
NA |
NO |
|
|
|
|
|
MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS |
NA |
NO |
|
|
|
|
|
MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS |
NA |
NO |
|
|
|
|
|
MAKFUNC.F_SOL_FR_TOTAL_PLEDGES - MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS |
NA |
NO |
|
|
|
|
|
MAX(APRACYR_YEAR) |
NA |
NO |
COMPOSITE VIEW |
AA_SPECIAL_ACTIVITY |
LAST_YEAR |
NO |
NA |
MEKFUNC.F_AUTHORIZED_TOTAL ( R.PORTFOLIO_KEY, '%', 'Y') + MEKFUNC.F_TOTAL_NOT_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y') |
TBD |
NO |
|
|
|
|
|
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '%', 'Y','Y') |
TBD |
NO |
|
|
|
|
|
MEKFUNC.F_TOTAL_SUBMITTED( R.PORTFOLIO_KEY, '9900ADVC', '%','Y') |
TBD |
NO |
|
|
|
|
|
MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE |
FNIEBAL |
NO |
|
|
|
|
NA |
MIN(APRACYR_YEAR) |
NA |
NO |
COMPOSITE VIEW |
AA_SPECIAL_ACTIVITY |
FIRST_YEAR |
NO |
NA |
MONTHS_BETWEEN |
NA |
NO |
COMPOSITE VIEW |
AP_PAST_EMPLOYMENT |
YEARS_MONTHS_IN_POSITION |
NO |
NA |
MONTHS_BETWEEN(NVL(APREHIS_TO_DATE, SYSDATE),APREHIS_FROM_DATE) |
NA |
NO |
COMPOSITE VIEW |
AA_PREVIOUS_EMPLOYMENT |
MONTHS_IN_POSITION |
NO |
NA |
MONTHS_BETWEEN(NVL(PPREXPE_END_DATE, SYSDATE),PPREXPE_START_DATE) |
NA |
NO |
|
|
|
|
|
MONTHS_BETWEEN(PPREXPE_END_DATE, PPREXPE_START_DATE) |
NA |
NO |
|
|
|
|
NA |
NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND |
NBAPBUD |
NO |
COMPOSITE VIEW |
AN_POSITION_BUDGET |
AMOUNT_REMAINING |
NO |
This function calculates the result of the budget minus the encumbrance and minus the expenditures. NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND. |
NVL (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE) |
NA |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_PCOL |
TRANSCRIPT_RECEIVED_DATE |
NO |
NVL (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE) returns transfer received date and if null, then returns prior college transcript received date. |
NVL(ADBDESG_WEB_GIFT_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AA_DESIGNATION |
ALLOW_WEB_GIFT_IND |
NO |
|
NVL(ADBDESG_WEB_PLDG_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AA_DESIGNATION |
ALLOW_WEB_PLEGE_IND |
NO |
|
NVL(ADRCONF_CONFID_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_DESIGNATION_COMMENT |
COMMENT_CONFIDENTIALITY_IND |
NO |
|
NVL(AFBCAMP_ASSOC_IND,'N') |
NA |
NO |
|
|
|
|
|
NVL(AFRCSOL_GOAL,0) |
NA |
NO |
|
|
|
|
|
NVL(AFRDESG_GOAL,0) |
NA |
NO |
|
|
|
|
|
NVL(AGBPLDG_MATCH_FORM_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
MATCHING_GIFT_FORM_IND |
NO |
|
NVL(AGBPLDG_MATCH_PROCESSED) |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
MATCH_GIFT_FORM_PROCESSED_IND |
NO |
|
NVL(AGBPLDG_MGFORM_READYTOSEND) |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
MATCHGIFT_FORM_READYTOSEND_IND |
NO |
|
NVL(AGBPLDG_PACK_IND,'N'), |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
PLEDGE_ACKNOWLEDGED_IND |
NO |
NA |
NVL(AGBPLDG_RECEIPT_IND,'N'), |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
RECEIPT_REQUIRED_IND |
NO |
NA |
NVL(AGRGAUX_DEDUCT_FOR_TAXES,'N') |
NA |
NO |
COMPOSITE VIEW |
AA_GIFT_AUXILIARY |
DEDUCT_FOR_TAXES_IND |
NO |
NA |
NVL(AMBPLAN_END_DATE,'31-DEC-2099') |
NA |
NO |
|
|
|
|
|
NVL(AMRCONF_CONFID_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_PROSPECT_CONF_COMMENT |
COMMENT_CONFIDENTIALITY_IND |
NO |
|
NVL(AMRCONT_CONFID_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_CONSTITUENT_CONTACT |
TICKLER_CONFIDENTIAL_IND |
NO |
|
NVL(AMRINFO_WEB_GIFT_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AA_PROSPECT_INFO |
ALLOW_WEB_GIFT_IND |
NO |
|
NVL(AMRINFO_WEB_PLDG_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AA_PROSPECT_INFO |
ALLOW_WEB_PLEDGE_IND |
NO |
|
NVL(AMRSTAF_END_DATE,'31-DEC-2099') |
NA |
NO |
|
|
|
|
|
NVL(AMRSTAF_SOLICIT_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AA_PROSPECT_INFO |
SOLICITOR_IND |
NO |
|
NVL(APRCONF_CONFID_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_CON_ENTITY_CONF_COMMENT |
COMMENT_CONFIDENTIALITY_IND |
NO |
|
NVL(APRCONF_DISP_NOTES_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_CON_ENTITY_CONF_COMMENT |
DISPLAYED_IN_NOTE_IND |
NO |
|
NVL(APRCONF_OK_FOR_NOTES_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_CON_ENTITY_CONF_COMMENT |
OK_FOR_NOTE_IND |
NO |
|
NVL(APRCONF_REVIEWED_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_CON_ENTITY_CONF_COMMENT |
WEB_REVIEWED_IND |
NO |
|
NVL(ASBSORG_DOLLAR_GOAL,) |
NA |
NO |
COMPOSITE VIEW |
AA_SOLICITOR_ORGANIZATION |
ORGANIZATION_GOAL |
NO |
|
NVL(ASBSORG_DOLLAR_GOAL,0) |
NA |
NO |
|
|
|
|
|
NVL(ASBSORG_DONOR_COUNT_GOAL,) |
NA |
NO |
COMPOSITE VIEW |
AA_SOLICITOR_ORGANIZATION |
ORGANIZATION_DONOR_COUNT_GOAL |
NO |
|
NVL(ASBSORG_DONOR_COUNT_GOAL,0) |
NA |
NO |
|
|
|
|
|
NVL(ASBSORG_UPD_WEB_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_SOLICITOR_ORGANIZATION |
ALLOW_WEB_UPDATE_IND |
NO |
|
NVL(ASRSORG_UPD_WEB_IND) |
NA |
NO |
COMPOSITE VIEW |
AA_SOLICITOR_ORG_FUNDRAISER AA_CAMPAIGN_FUNDRAISER |
ALLOW_WEB_UPDATE_SOLICITOR_IND ALLOW_WEB_UPDATE_SOLICITOR_IND |
NO NO |
|
NVL(ATVCMPT_CAPITAL_IND,'N') |
NA |
NO |
|
|
|
|
|
NVL(ATVEMPS_ACTIVE_IND,'N') |
ATVEMPS |
NO |
COMPOSITE VIEW |
AA_PREVIOUS_EMPLOYMENT |
EMPLOYMENT_STATUS_ACTIVE_IND |
NO |
NA |
NVL(AXBMGID_MGFORM_READYTOSEND) |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE_MATCHING |
MATCH_FORM_SENT_IND |
NO |
|
NVL(CURR_ADOPTED_BUDGET + CURR_BUDGET_ADJUSTMENTS, 0) |
NA |
NO |
|
|
|
|
Calculates the total current budget as current adopted budget + current budget adjustments. |
NVL(CURR_YEAR_TO_DATE_ACTV + CURR_ENCUMBRANCES + CURR_BUDGET_RESERVATION, 0) |
NA |
NO |
|
|
|
|
Calculates the current commited balance as current year to date activity + current encumbrances + current budget reservations (requisistions). |
NVL(FABINVH_ACH_OVERRIDE_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
DIRECT_DEPOSIT_OVERRIDE_IND |
NO |
|
NVL(FABINVH_DISB_AGENT_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
DISBURSING_AGENT_IND |
NO |
|
NVL(FABINVH_EDIT_DEFER_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
DEFERRED_EDIT_IND |
NO |
|
NVL(FABINVH_INVD_RE_ESTABLISH_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
INVOICE_RE_ESTABLISHED_IND |
NO |
|
NVL(FABINVH_NSF_ON_OFF_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
NSF_ON_OFF_IND |
NO |
|
NVL(FABINVH_RUIV_IND,'N') |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REPEATING_INVOICE_IND |
NO |
|
NVL(FABINVH_RUIV_INSTALLMENT_IND,'N') |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE |
INSTALLMENT_IND |
NO |
|
NVL(FABINVH_SINGLE_ACCTG_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
DOCUMENT_ACCOUNTING_IND |
NO |
|
NVL(FABINVH_TEXT_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
TEXT_EXISTS_IND |
NO |
|
NVL(FABRUIV_MAX_SUB,0) |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
MAXIMUM_NUMBER_SUBMISSIONS |
NO |
|
NVL(FABRUIV_MAX_SUB,0) - NVL( FABRUIV_SUB_TO_DATE,0) |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
REMAINING_SUBMISSIONS |
NO |
|
NVL(FABRUIV_SUB_TO_DATE,0) |
NA |
NO |
COMPOSITE VIEW |
AF_INVOICE |
SUBMISSIONS_TO_DATE |
NO |
|
NVL(FARINVA_APPR_AMT,0)+NVL( FARINVA_ADDL_CHRG_AMT,0)+NVL( FARINVA_TAX_AMT,0)-NVL(FARINVA_DISC_AMT, 0) |
FAAINVE |
NO |
COMPOSITE VIEW |
AF_INVOICE_ACCOUNTING |
APPROVED_CHARGE_AMOUNT |
NO |
This calculation returns the approved charge amount by summing the approved amount, additional charges, and tax amount and subtracting any associated discount. |
NVL(FGBENCD_ABAL_OVERRIDE) |
NA |
NO |
|
|
|
|
|
NVL(FGBENCH_EDIT_DEFERRAL,'N') |
NA |
NO |
|
|
|
|
|
NVL(FGBENCH_NSF_ON_OFF_IND,'N') |
NA |
NO |
|
|
|
|
|
NVL(FPBPOHD_BLANKET_IND,'N') |
FPABLAR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
BLANKET_ORDER_IND |
NO |
|
NVL(FPBPOHD_CANCEL_IND,'N') |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
CANCEL_IND |
NO |
|
NVL(FPBPOHD_CLOSED_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
CLOSED_IND |
NO |
|
NVL(FPBPOHD_EDI_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
EDI_IND |
NO |
|
NVL(FPBPOHD_PRINT_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
PRINT_IND |
NO |
|
NVL(FPBPOHD_REXP_DATE, FPBPOHD_BLANKET_TERM_DATE) |
FPABLAR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
PO_END_DATE |
NO |
NA |
NVL(FPBPOHD_SUSP_IND,'N') |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER |
SUSPENSE_IND |
NO |
|
NVL(FPRPODA_ADDL_CHRG_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
ADDITIONAL_AMOUNT |
NO |
|
NVL(FPRPODA_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
AMOUNT |
NO |
|
NVL(FPRPODA_AMT,0)+NVL( FPRPODA_ADDL_CHRG_AMT,0)+NVL( FPRPODA_TAX_AMT,0)-NVL(FPRPODA_DISC_AMT, 0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
APPROVED_CHARGE_AMOUNT |
NO |
This calculation returns the approved charge amount by summing the approved amount, additional charges, and tax amount and subtracting any associated discount. |
NVL(FPRPODA_CLOSED_IND,'N') |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
CLOSED_IND |
NO |
|
NVL(FPRPODA_CONVERT_ADDL_CHRG_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
CONVERTED_ADDITIONAL_AMOUNT |
NO |
|
NVL(FPRPODA_CONVERT_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
CONVERTED_AMOUNT |
NO |
|
NVL(FPRPODA_CONVERT_DISC_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
CONVERTED_DISCOUNT_AMOUNT |
NO |
|
NVL(FPRPODA_CONVERT_TAX_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
CONVERTED_TAX_AMOUNT |
NO |
|
NVL(FPRPODA_DISC_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
DISCOUNT_AMOUNT |
NO |
|
NVL(FPRPODA_ENCB_ADJT_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
ENCUMBRANCE_ADJUSTMENT_AMOUNT |
NO |
|
NVL(FPRPODA_NSF_OVERRIDE_IND,'N') |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
NSF_OVERRIDE_IND |
NO |
|
NVL(FPRPODA_SUSP_IND,'N') |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
SUSPENSE_IND |
NO |
|
NVL(FPRPODA_TAX_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ACCOUNTING |
TAX_AMOUNT |
NO |
|
NVL(FPRPODT_ADDL_CHRG_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
ADDITIONAL_CHARGES_AMOUNT |
NO |
|
NVL(FPRPODT_CONVERT_ADDL_CHRG_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
CONVERTED_ADDITNAL_AMOUNT |
NO |
|
NVL(FPRPODT_CONVERT_DISC_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
CONVERTED_DISCOUNT_AMOUNT |
NO |
|
NVL(FPRPODT_CONVERT_TAX_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
CONVERTED_TAX_AMOUNT |
NO |
|
NVL(FPRPODT_CONVERT_UNIT_PRICE,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
CONVERTED_UNIT_PRICE |
NO |
|
NVL(FPRPODT_DESC_CHGE_IND,'N') |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
COMMODITY_DESC_CHANGE_IND |
NO |
|
NVL(FPRPODT_DISC_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
DISCOUNT_AMOUNT |
NO |
|
NVL(FPRPODT_LIQ_AMT,0) |
NA |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
LIQUIDATION_AMOUNT |
NO |
|
NVL(FPRPODT_QTY,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
QUANTITY |
NO |
|
NVL(FPRPODT_TAX_AMT,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
TAX_AMOUNT |
NO |
|
NVL(FPRPODT_UNIT_PRICE,0) |
FPAPURR |
NO |
COMPOSITE VIEW |
AF_PURCHASE_ORDER_ITEM |
UNIT_PRICE |
NO |
|
NVL(FPRRCDT_TOL_OVERRIDE_IND) |
FPARCVD |
NO |
|
|
|
|
Calculations deterimines if the override is set to (Y)es or (N)o. |
NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID) |
NA |
NO |
COMPOSITE VIEW |
AE_EXPENSE_ITEM |
PURCHASE_CARD_ID |
NO |
|
NVL(FTRACTA_ATTS_CODE,'NONE') |
FTMFATA |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_ATTRIBUTES_ODS |
SET_CODE |
NO |
NA |
NVL(FTRACVA_ATTS_CODE,'NONE') |
FTMFATA |
NO |
COMPOSITE VIEW |
AF_ACTIVITY_ATTRIBUTES_ODS |
SET_CODE |
NO |
NA |
NVL(FTRATYA_ATTS_CODE,'NONE') |
FTMFATA |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_TYPE_ATTRIBUTES_ODS |
SET_CODE |
NO |
NA |
NVL(FTRFNDA_ATTS_CODE,'NONE') |
FTMFATA |
NO |
COMPOSITE VIEW |
AF_FUND_ATTRIBUTES_ODS |
SET_CODE |
NO |
NA |
NVL(FTRFTYA_ATTS_CODE,'NONE') |
FTMFATA |
NO |
COMPOSITE VIEW |
AF_FUND_TYPE_ATTRIBUTES_ODS |
SET_CODE |
NO |
NA |
NVL(FTRLCNA_ATTS_CODE,'NONE') |
FTMFATA |
NO |
COMPOSITE VIEW |
AF_LOCATION_ATTRIBUTES_ODS |
SET_CODE |
NO |
NA |
NVL(FTRORGA_ATTS_CODE,'NONE') |
FTMFATA |
NO |
COMPOSITE VIEW |
AF_ORGANIZATION_ATTRIBUTES_ODS |
SET_CODE |
NO |
NA |
NVL(FTRPRGA_ATTS_CODE,'NONE') |
FTMFATA |
NO |
COMPOSITE VIEW |
AF_PROGRAM_ATTRIBUTES_ODS |
SET_CODE |
NO |
NA |
NVL(FTVACCT_ACCT_CODE_POOL, FTVACCT_ACCT_CODE) |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL |
ACCOUNT_POOL ACCOUNT_POOL |
NO NO |
This calculation retrieves the FTVACCT_ACCT_CODE_POOL if it is not NULL. Otherwise it retrieves the FTVACCT_ACCT_CODE. |
NVL(FTVFUND_FUND_CODE_BAVL, FTVFUND_FUND_CODE) |
FTMFUND |
NO |
COMPOSITE VIEW |
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
FUND_POOL FUND_POOL |
NO NO |
This calculation retrieves the FTVFUND_FUND_CODE_BAVL if it is not NULL. Otherwise it retrieves the FTVFUND_FUND_CODE. |
NVL(FTVORGN_ORGN_CODE_NSF, FTVORGN_ORGN_CODE) |
FTMORGN |
NO |
COMPOSITE VIEW |
AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY |
ORGANIZATION_POOL ORGANIZATION_POOL |
NO NO |
This calculation retrieves the FTVORGN_CODE_NSF if it is not NULL. Otherwise it retrieves the FTVORGN_ORGN_CODE. |
NVL(FTVVEND_TERM_DATE,'31-DEC-2099') |
NA |
NO |
|
|
|
|
|
NVL(FTVVEND_VEND_CHECK_PIDM, FTVVEND_PIDM) |
NA |
NO |
|
|
|
|
|
NVL(GERATTD_FEES_DESC, GTVFEES_DESC) |
NA |
NO |
COMPOSITE VIEW |
AG_EVENT_INVITEE |
FEE_STATUS_DESC |
NO |
NVL(GERATTD_FEES_DESC, GTVFEES_DESC), returns fee status for the invitee, and if it doesn't exist, then the fee status for the fee. |
NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED) |
NA |
NO |
|
|
|
|
NA |
NVL(NBBPOSN_ACCRUE_SENIORITY_IND, NTRPCLS_ACCRUE_SENIORITY_IND) |
MULTIPLE |
NO |
COMPOSITE VIEW |
AN_POSITION_DEFINITION |
SENIORITY_ACCRUED_IND |
NO |
Retrieves seniority accrual indicator from postion classification rule table if the indicator is null in the position record. |
NVL(NBBPOSN_GRADE,NTRPCLS_GRADE) |
NA |
NO |
COMPOSITE VIEW |
AN_POSITION_DEFINITION |
SALARY_GRADE |
NO |
This function returns NBBPOSN_GRADE if it is not null else it returns NTRPCLS_GRADE. |
NVL(NBBPOSN_POSN_REPORTS, MPKFUNC.F_GET_POSITION_REPORTS) |
MULTIPLE |
NO |
|
|
|
|
NVL(POSITION_REPORTS, SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION,'POSITION'),1,63)) |
NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE) |
NA |
NO |
|
|
|
|
NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE) returns salary group code for the salary group and if null, then returns salary group code for the position class. |
NVL(NBBPOSN_STEP,NTRPCLS_STEP) |
NA |
NO |
COMPOSITE VIEW |
AN_POSITION_DEFINITION |
SALARY_STEP |
NO |
This function returns NBBPOSN_STEP if it is not null else it returns NTRPCLS_STEP. |
NVL(NBBPOSN_TABLE,NTRPCLS_TABLE) |
NA |
NO |
COMPOSITE VIEW |
AN_POSITION_DEFINITION |
SALARY_TABLE |
NO |
This function returns NBBPOSN_TABLE if it is not null, else it returns NTRPCLS_TABLE. |
NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR) |
NA |
NO |
COMPOSITE VIEW |
AN_SUPERVISOR |
SUPERVISOR_UID |
NO |
NVL(P.NBRJOBS_SUPERVISOR_PIDM, TO_NUMBER(NOKODSF.F_GET_SUPERVISOR(B.NBBPOSN_POSN_REPORTS,'PIDM'))) |
NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS) |
NA |
NO |
COMPOSITE VIEW |
AN_SUPERVISOR |
SUPERVISOR_POSITION |
NO |
If the supervisor position in NBRJOBS is null, then retrieve the position reports number and calculate who the supervisor is. |
NVL(NBRJOBS_SUPERVISOR_SUFF, NOKODSF.F_GET_SUPERVISOR) |
NA |
NO |
COMPOSITE VIEW |
AN_SUPERVISOR |
SUPERVISOR_JOB_SUFFIX |
NO |
NVL(NBRJOBS_SUPERVISOR_SUFF, SUBSTR(NOKODSF.F_GET_SUPERVISOR(NBBPOSN_POSN_REPORTS,'SUFFIX'),1,2) |
NVL(PAY.TRANSACTION_DATE, CHG.TRANSACTION_DATE) |
NA |
NO |
|
|
|
|
Applied date is set from the payment transaction date, and if null, then is set to the charge transaction date when the payment is applied to the charge. |
NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL( RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0) |
NA |
NO |
|
|
|
|
NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL(RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0) |
NVL(RCRAPP4_DUP_SSN_IND) |
TBD |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
DUPLICATE_TAX_ID_IND |
NO |
|
NVL(RCRAPP4_PUSH_ISIR_FLAG) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION4 |
CPS_ISIR_PUSHED_IND |
NO |
|
NVL(RCRESAR_AUTO_ZERO_EFC_FLAG) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
AUTOMATIC_ZERO_EFC_IND |
NO |
|
NVL(RCRESAR_SUB_APP) |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
SUBSEQUENT_APPLICATION_IND |
NO |
|
NVL(RCRESAR_VERIF_CHANGE_IND) |
RNARSXX RNIMSXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_ISIR_SPEC |
VERIFICATION_SELECT_CHANGE_IND |
NO |
|
NVL(RNROVRD_ADD_BK_HOPE_OPT) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_ADD_HOPE_LL_IND |
NO |
|
NVL(RNROVRD_ALLOW_IM_PC_LOWR_FM) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_LOWER_THAN_FM_IND |
NO |
|
NVL(RNROVRD_ALLOW_IM_SC_LOWR_FM) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_LOWER_THAN_FM_IND |
NO |
|
NVL(RNROVRD_CALC_US_TAX_FM) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_STUD_CALC_FED_TAX_OVR_IND |
NO |
|
NVL(RNROVRD_NON_CUST_PC_OPT) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_USE_NONCUSTODIAL_PC_IND |
NO |
|
NVL(RNROVRD_PAR_ADD_BK_HOME_OPT) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_ADD_HOPE_LL_IND |
NO |
|
NVL(RNROVRD_PAR_CALC_US_TAX_FM) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
FM_PARENT_CALC_FED_TAX_OVR_IND |
NO |
|
NVL(RNROVRD_PAR_EXCL_TUIT_DED) |
RNAOVXX |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_EXCL_TUITION_FEE_IND |
NO |
|
NVL(RNROVRD_PAR_USE_PROJ_INC_EFM) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_EFM_EST_INCOME_IND |
NO |
|
NVL(RNROVRD_SKIP_AGE_EXCL) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_SKIP_AGE_EXCLUSION_IND |
NO |
|
NVL(RNROVRD_USE_PROJ_INC_EFM) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_EFM_ESTIMATED_INCOME_IND |
NO |
|
NVL(RNROVRD_ZERO_LOSS_BUS_FARM) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_ZERO_LOSS_BUS_IND |
NO |
|
NVL(RNROVRD_ZERO_LOSS_OTH) |
TBD |
NO |
COMPOSITE VIEW |
AR_NEED_ANALYSIS_OVERRIDE |
IM_PARENT_ZERO_LOSS_OTH_IND |
NO |
|
NVL(RPRADSB_ALTERNATE_PELL_IND,'N') |
ROAPELL |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
ALTERNATE_PELL_PAY_SCHED_IND |
NO |
|
NVL(RPRADSB_CPS_VER_IND,'N') |
READIXX |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
CPS_VERIFICATION_IND |
NO |
|
NVL(RPRADSB_DISB_LOCK_IND,'N') |
READIXX |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
COD_DISBURSEMENT_LOCK_IND |
NO |
|
NVL(RPRADSB_EXCL_FROM_NET_AMT,'N') |
READIXX |
NO |
COMPOSITE VIEW |
AR_AWARD_DISBURSEMENT |
COD_NET_AMOUNT_EXCLUSION_IND |
NO |
|
NVL(RPRLAPP_ADDL_STFD_ELIG_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AR_LOAN_APPLICATION |
ADDL_STAFFORD_ELIG_IND |
NO |
|
NVL(RPRLAPP_DEFERMENT_OPT,'N') |
NA |
NO |
|
|
|
|
|
NVL(RPRLAPP_FIRST_NAME, MGKFUNC.F_GET_PERSON_INFO) |
NA |
NO |
|
|
|
|
|
NVL(RPRLAPP_LAST_NAME, MGKFUNC.F_GET_PERSON_INFO) |
NA |
NO |
|
|
|
|
|
NVL(RPRLAPP_MAX_LOAN_IND,'N') |
NA |
NO |
|
|
|
|
|
NVL(RPRLAPP_MI, MGKFUNC.F_GET_PERSON_INFO) |
NA |
NO |
|
|
|
|
|
NVL(RPRLAPP_SSN, MGKFUNC.F_GET_PERSON_INFO) |
NA |
NO |
|
|
|
|
|
NVL(RPRLATR_EXCLUDE_LNEX_FLAG,'N') |
RPALORG RPAELAP RPALAPP |
NO |
COMPOSITE VIEW |
AR_LOAN_DISBURSEMENT |
EXCLUDE_EXCEPTION_REPORT_IND |
NO |
|
NVL(SARADAP_FEE_IND,'N') |
NA |
NO |
COMPOSITE VIEW |
AS_ADMISSIONS_APPLICATION |
APPLICATION_FEE_REQUIRED_IND |
NO |
NA |
NVL(SFRSTCR_APPR_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_ATTS_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_CAMP_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_CAPC_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_CHRT_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_CLAS_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_COLL_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_CORQ_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_DEGC_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_DEPT_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_DUPL_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_LEVL_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_LINK_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_MAJR_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_MEXC_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_PREQ_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_PROG_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_REPT_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_RPTH_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_TEST_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SFRSTCR_TIME_OVER,'N') |
NA |
NO |
|
|
|
|
|
NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS( SHRTCKN_PIDM,SHRTCKN_TERM_CODE, SHRTCKN_CRN)) |
NA |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
EXTENSIONS |
NO |
This calculates the number of extensions SHRTCKN_NUMBER_OF_EXTENSIONS for the specified UID, academic period and course if it exists, else it returns the function which returns the number of extensions MAX(SFRAREG_EXTENSION_NUMBER) a student has been granted to complete the class for the specified UID, academic period and course where the withdrawal indicator is N. |
NVL(SHRTCKN_REG_COMPLETION_DATE, SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM, SHRTCKN_TERM_CODE,SHRTCKN_CRN, SHRTCKN_PTRM_CODE,'E')) |
NA |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY |
END_DATE |
NO |
This function returns the registration start date SHRTCKN_REG_START_DATE if it exists, else it returns the course start date for a specified UID, academic period, course and subacademic period. |
NVL(SHRTCKN_REG_START_DATE, SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM, SHRTCKN_TERM_CODE,SHRTCKN_CRN, SHRTCKN_PTRM_CODE,'S')) |
SFARHST |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
START_DATE |
NO |
This function returns the registration completion date SHRTCKN_REG_COMPLETION_DATE if it exists, else it returns the course end date for a specified UID, academic period, course and subacademic period. |
NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE) |
NA |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_PCOL |
TRANSCRIPT_REVIEWED_DATE |
NO |
NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE) returns transfer acceptance date and if null, then returns prior college transcript reviewed date. |
NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE) |
NA |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS |
GRAD_YEAR_INTENDED |
NO |
Retrieve intended year of graduation from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur. |
NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE) |
MULTIPLE |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS |
EXPECTED_GRADUATION_DATE |
NO |
Retrieve expected graduation date from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur. |
NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE) |
MULTIPLE |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS |
LEAVE_REASON |
NO |
Retrieve leave reason from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur. |
NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE) |
MULTIPLE |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS |
LEAVE_DATE_FROM |
NO |
Retrieve start date of the student leave from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur. |
NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE) |
MULTIPLE |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS |
LEAVE_DATE_TO |
NO |
Retrieve end date of the student leave from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur. |
NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE) |
MULTIPLE |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS |
STUDENT_RATE |
NO |
Retrieve student rate from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur. |
NVL(SORLCUR_SITE_CODE,SGBSTDN_SITE_CODE) |
NA |
NO |
|
|
|
|
Use site code from curriculum record and if null use site from student record sgbstdn. |
NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE) |
MULTIPLE |
NO |
|
|
|
|
Retrieve student population or type from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur. |
NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD) |
MULTIPLE |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS |
GRAD_ACADEMIC_PERIOD_INTENDED |
NO |
Retrieve intended graduation term from the student record sgbstdn if the field is null in the multiple curriculum record sorlcur. |
NVL(SPRIDEN_LAST_NAME,'STAFF') |
SIAASGN |
NO |
COMPOSITE VIEW |
AS_INSTRUCTIONAL_ASSIGNMENT |
INSTRUCTOR_LAST_NAME |
NO |
This function returns the instructor''s last name SPRIDEN_LAST_NAME if it exists, else STAFF. |
NVL(SPRIDEN_MI,'STAFF') |
MULTIPLE |
NO |
|
|
|
|
Retrieve the instructor''s last name SPRIDEN_LAST_NAME if it exists, else set to STAFF. |
NVL(SSBOVRR_COLL_CODE,SCBCRSE_COLL_CODE) |
SSAOVRR |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
COURSE_COLLEGE |
NO |
This function returns the override college SSBOVRR_COLL_CODE if it exists, else it returns the course college SCBCRSE_COLL_CODE. |
NVL(SSBOVRR_DEPT_CODE,SCBCRSE_DEPT_CODE) |
SSAOVRR |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
COURSE_DEPARTMENT |
NO |
This function returns the override department SSBOVRR_DEPT_CODE if it exists, else it returns the department SCBCRSE_DEPT_CODE. |
NVL(SSBOVRR_DIVS_CODE,SCBCRSE_DIVS_CODE) |
SSAOVRR |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
COURSE_DIVISION |
NO |
This function returns the override division SSBOVRR_DIVS_CODE if it exists, else it returns the course division SCBCRSE_DIVS_CODE. |
NVL(SSBSECT_CONT_HR, SCBCRSE_CONT_HR_HIGH) |
SCACRSE |
NO |
|
|
|
|
NA |
NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE) |
SCACRSE |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_IN_PROGRESS |
COURSE_TITLE_SHORT |
NO |
NA |
NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH) |
SCACRSE |
NO |
|
|
|
|
NA |
NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH) |
SCACRSE |
NO |
|
|
|
|
NA |
NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH) |
SCACRSE |
NO |
|
|
|
|
NA |
NVL(SUM_ADOPTED_BUDGET + SUM_BUDGET_ADJUSTMENTS, 0) |
NA |
NO |
|
|
|
|
Calculates total budget as of this period to be the sum of all adopted budget and all budget adjustments up to this period. |
NVL(SUM_YEAR_TO_DATE_ACTV + SUM_ENCUMBRANCES + SUM_BUDGET_RESERVATION, 0) |
NA |
NO |
|
|
|
|
Calculates summary committed balance as of this period to be the sum of all year to date activity plus all year to date encumbrances plue all year to date budget reservations. |
NVL(TBRDEPO_AMOUNT-F_ACCD_AMOUNT( TBRDEPO_PIDM,TBRDEPO_TRAN_NUMBER),0) |
TSADETL |
NO |
COMPOSITE VIEW |
AT_AR_DEPOSIT |
BALANCE_AMOUNT |
NO |
This function returns the difference between the deposit amount TBRDEPO_AMOUNT and the summarized transaction amount SUM(TBRACCD_AMOUNT) for a specified UID and transaction number. |
NVL(TBRDEPO_TRANS_DATE, TBRDEPO_EFFECTIVE_DATE)-NVL( TBRDEPO_FEED_DATE,SYSDATE) |
TSADETL |
NO |
COMPOSITE VIEW |
AT_AR_DEPOSIT |
OPERATING_DATE |
NO |
This function returns the difference between the transaction date TBRDEPO_TRANS_DATE or if null, the effective date TBRDEPO_EFFECTIVE_DATE and the feed date TBRDEPO_FEED_DATE or if null, today's date SYSDATE. |
NVL(TRANSACTION_HISTORY.FUND_POOL, FUND_HIERARCHY.FUND_POOL) |
NA |
NO |
|
|
|
|
Population of fund pool is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history. |
NVL=(ASBSORG_PARTICIPATION_GOAL,0) |
NA |
NO |
COMPOSITE VIEW |
AA_SOLICITOR_ORGANIZATION |
ORG_PARTICIPATION_GOAL |
NO |
|
PPREXPE_SUPER_PHONE_AREA||PPREXPE_SUPER_ PHONE_NUMBER||PPREXPE_SUPER_PHONE_EXT |
NA |
NO |
COMPOSITE VIEW |
AP_PAST_EMPLOYMENT |
SUPERVISOR_COMBINED_PHONE |
NO |
NA |
PPRREFE_PHONE_AREA||PPRREFE_PHONE_NUMBER ||PPRREFE_PHONE_EXT |
NA |
NO |
COMPOSITE VIEW |
AP_REFERENCE |
COMBINED_PHONE |
NO |
This function concatenates the phone area code, the phone number and the phone extension from the PPRREFE table. |
ROW_NUMBER |
TBD |
NO |
|
|
|
|
|
SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB |
SCACRSE |
NO |
COMPOSITE VIEW |
AS_COURSE_CATALOG |
COURSE_IDENTIFICATION |
NO |
This concatenates the course subject code with the course number from the SCBCRSE record. |
SCBSUPP_SUBJ_CODE||SCBSUPP_CRSE_NUMB |
SCADETL |
NO |
COMPOSITE VIEW |
AS_COURSE_SUPPLEMENTAL |
COURSE_IDENTIFICATION |
NO |
This concatenates the course subject code with the course number from the SCBSUPP record. |
SCRATTR_SUBJ_CODE||SCRATTR_CRSE_NUMB |
SCADETL |
NO |
|
|
|
|
NA |
SCRCORQ_SUBJ_CODE_CORQ||SCRCORQ_CRSE_NUM B_CORQ |
SCADETL |
NO |
COMPOSITE VIEW |
AS_COURSE_COREQ |
COURSE_IDENTIFICATION_COREQ |
NO |
This concatenates the course subject code co-requisite with the course number co-requisite from the SCRCORQ record. |
SCRCORQ_SUBJ_CODE||SCRCORQ_CRSE_NUMB |
SCADETL |
NO |
COMPOSITE VIEW |
AS_COURSE_COREQ |
COURSE_IDENTIFICATION |
NO |
This concatenates the course subject code with the course number from the SCRCORQ record. |
SCRGMOD_SUBJ_CODE||SCRGMOD_CRSE_NUMB, |
SSASECT |
NO |
COMPOSITE VIEW |
AS_OFFERING_GRADE_MODE |
COURSE_IDENTIFICATION |
NO |
This concatenates the course subject code with the course number from the SGRGMOD record. |
SCRLEVL_SUBJ_CODE||SCRLEVL_CRSE_NUMB |
SCACRSE |
NO |
COMPOSITE VIEW |
AS_COURSE_LEVEL |
COURSE_IDENTIFICATION |
NO |
This concatenates the course subject code with the course number from the SCRLEVL record. |
SCRRTST_SUBJ_CODE||SCRRTST_CRSE_NUMB |
SCAPREQ |
NO |
COMPOSITE VIEW |
AS_COURSE_PREREQ |
COURSE_IDENTIFICATION |
NO |
This concatenates the course subject code with the course number from the SCRRTST record. |
SCRSCHD_SUBJ_CODE||SCRSCHD_CRSE_NUMB |
SCACRSE |
NO |
COMPOSITE VIEW |
AS_COURSE_SCHEDULE |
COURSE_IDENTIFICATION |
NO |
This concatenates the course subject code with the course number from the SCRSCHD record. |
SEASONS_COMPETITION_AVAILABLE - SEASONS_COMPETITION_USED |
NA |
NO |
|
|
|
|
|
SELECT RORMVAL_DESC FROM RORMVAL WHERE RORMVAL_COLUMN = 'RFRASPC_APPL_MEMO_IND' AND RORMVAL_CODE = RFRASPC_APPL_MEMO_IND |
NA |
NO |
|
|
|
|
|
SFRPLAN_SUBJ_CODE||SFRPLAN_CRSE_NUMB |
NA |
NO |
|
|
|
|
|
SFRSTCR_SUBJ_CODE||SFRSTCR_CRSE_NUMB |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_FACULTY_FEEDBACK |
COURSE_IDENTIFICATION |
NO |
This concatenates the course subject code with the course number from the SFRSTCR record. |
SGRCOOP_PHONE_AREA||SGRCOOP_PHONE_NUMBER ||SGRCOOP_PHONE_EXT |
NA |
NO |
|
|
|
|
NA |
SHRTATT_TRIT_SEQ_NO||TO_CHAR( SHRTATT_TRAM_SEQ_NO,'FM09')||TO_CHAR( NVL(SHRTATT_TRCR_SEQ_NO,0),'FM009') ||TO_CHAR(SHRTATT_TRCE_SEQ_NO,'FM009') |
MULTIPLE |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_ATTR_TRANS |
COURSE_REFERENCE_NUMBER |
NO |
|
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_ATTEMPTED_IND,'Y',1,0) |
SHATCKS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_GRADE_CHG |
CREDITS_ATTEMPTED CREDITS_ATTEMPTED |
NO NO |
This calculates the credit hours attempted by the student. |
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_COMPLETED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1) |
SHATCKS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_GRADE_CHG |
CREDITS_EARNED CREDITS_EARNED |
NO NO |
This calculates the credit hours earned by the student. |
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_GPA_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) |
SHATCKS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY |
CREDITS_FOR_GPA CREDITS_FOR_GPA |
NO NO |
This calculates the credits that are used to calculate the GPA for the student. |
SHRTCKG_CREDIT_HOURS*DECODE( SHRGRDE_PASSED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1) |
SHATCKS |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY |
CREDITS_PASSED CREDITS_PASSED |
NO NO |
This calculates the quality points earned by the student. |
SHRTCKG_CREDIT_HOURS*SHRGRDE_QUALITY_POI NTS*DECODE(SHRGRDE_GPA_IND,'Y',1,0) *DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0, 1) |
SHAINST |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY |
QUALITY_POINTS QUALITY_POINTS |
NO NO |
This calculates the credit hours passed by the student. |
SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB |
SHAINST |
NO |
|
|
|
|
This concatenates the course subject code with the course number from the SHRTCKN record. |
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_ATTEMPTED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) |
TBD |
NO |
|
|
|
|
|
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_EARNED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) |
TBD |
NO |
|
|
|
|
|
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_GPA_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) |
TBD |
NO |
|
|
|
|
|
SHRTRCE_CREDIT_HOURS*DECODE( SHRGRDE_PASSED_IND,'Y',1,0)*DECODE( SHRTCKN_REPEAT_COURSE_IND,'E',0,1) |
TBD |
NO |
|
|
|
|
|
SHRTRCE_CREDIT_HOURS*SHRGRDE_QUALITY_POI NTS*DECODE(SHRGRDE_GPA_IND,'Y',1,0) *DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0, 1) |
TBD |
NO |
|
|
|
|
|
SHRTRCE_SUBJ_CODE||SHRTRCE_CRSE_NUMB |
SHATRNS |
NO |
|
|
|
|
This concatenates the course subject code with the course number from the SHRTRCE record. |
SHRTRCE_TRIT_SEQ_NO||TO_CHAR( SHRTRCE_TRAM_SEQ_NO,'FM09')||TO_CHAR( NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009') ||TO_CHAR(SHRTRCE_SEQ_NO,'FM009') |
TBD |
NO |
COMPOSITE VIEW |
AS_STUDENT_COURSE_TRANSFER AS_STUDENT_TRANSFERRED_COURSE AS_STUDENT_COURSE_TRANSFER AS_STUDENT_TRANSFERRED_COURSE |
COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER |
NO NO NO NO |
|
SHRTRCR_TRANS_COURSE_NAME||SHRTRCR_TRANS _COURSE_NUMBERS |
NA |
NO |
COMPOSITE VIEW |
AS_STUDENT_TRANSFERRED_COURSE |
TRANSFER_COURSE_IDENTIFICATION |
NO |
|
SLBBLDG_PHONE_AREA||SLBBLDG_PHONE_NUMBER ||SLBBLDG_PHONE_EXTENSION |
SLABLDG |
NO |
COMPOSITE VIEW |
AS_ROOM_ASSIGNMENT |
BUILDING_PHONE_NUM_COMBINED |
NO |
This concatenates the area code, the phone number and the phone extension from the SLBBLDG table. |
SLBEVNT_PHONE_AREA||SLBEVNT_PHONE||SLBEV NT_PHONE_EXT |
NA |
NO |
COMPOSITE VIEW |
AG_EVENT |
PHONE_NUMBER_COMBINED |
NO |
NA |
SLBRDEF_PHONE_AREA||SLBRDEF_PHONE_NUMBER ||SLBRDEF_PHONE_EXTENSION |
SLARASG |
NO |
COMPOSITE VIEW |
AS_ROOM_ASSIGNMENT |
ROOM_PHONE_NUM_COMBINED |
NO |
This concatenates the area code, the phone number and the phone extension from the SLBRDEF table. |
SLRPASG_PHONE_AREA||SLRPASG_PHONE_NUMBER ||SLRPASG_PHONE_EXT |
NA |
NO |
COMPOSITE VIEW |
AS_PHONE_ASSIGNMENT |
PHONE_NUMBER_COMBINED |
NO |
This concatenates the area code, the phone number and the phone extension from the SLRPASG table. |
SORBCNT_PHONE_AREA||SORBCNT_PHONE_NUMBER ||SORBCNT_PHONE_EXT |
SOASBGI |
NO |
COMPOSITE VIEW |
AS_INSTITUTION |
CONTACT_PHONE_NUMBER_COMBINED |
NO |
NA |
SPRADDR_CNTY_CODE |
FAAINVE |
NO |
|
|
|
|
NA |
SPRIDEN_FIRST_NAME || SUBSTR(SPRIDEN_MI, 1,1) || SPRIDEN_LAST_NAME |
NA |
NO |
|
|
|
|
|
SPRIDEN_FIRST_NAME||SPRIDEN_MI||SPRIDEN_ LAST_NAME |
NA |
NO |
COMPOSITE VIEW |
AA_PLEDGE_MATCHING |
MATCH_EMPLOYER_NAME |
NO |
NA |
SPRTELE_INTL_ACCESS || SPRTELE_PHONE_AREA || SPRTELE_PHONE_NUMBER || SPRTELE_PHONE_EXT |
NA |
NO |
|
|
|
|
This calculation formulates the combined phone number by concatenating SPRTELE_INTL_ACCESS, SPRTELE_PHONE_AREA, SPRTELE_PHONE_NUMBER, and SPRTELE_PHONE_EXT. |
SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA| |SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT |
NA |
NO |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT AA_ORGANIZATION_CONTACT AS_TELEPHONE |
FAX_NUMBER_COMBINED PHONE_NUMBER_COMBINED PHONE_NUMBER_COMBINED |
NO NO NO |
This calculation formulates the combined phone number by concatenating SPRTELE_INTL_ACCESS, SPRTELE_PHONE_AREA, SPRTELE_PHONE_NUMBER, and SPRTELE_PHONE_EXT. |
SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB |
SFAREGS |
NO |
COMPOSITE VIEW |
AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_COURSE_OFFERING AS_MEETING_TIME AS_OFFERING_COREQ AS_STUDENT_COURSE_IN_PROGRESS |
COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION COURSE_IDENTIFICATION |
NO NO NO NO NO NO |
This concatenates the course subject code with the course number from the SSBSECT record. |
SSRRTST_SUBJ_CODE_PREQ||SSRRTST_CRSE_NUM B_PREQ |
SSAPREQ |
NO |
COMPOSITE VIEW |
AS_OFFERING_PREREQ |
PREREQ_COURSE_IDENTIFICATION |
NO |
This concatenates the prerequisite course subject code with the prerequisite course number from the SSRRTST record. |
SUBSTR(SPRIDEN_MI,1,1) |
NA |
NO |
COMPOSITE VIEW |
AS_PERSON |
MIDDLE_INITIAL |
NO |
This function returns the middle initial. |
SUM(AGRPDES_AMT_PAID) |
TBD |
NO |
COMPOSITE VIEW |
AA_PLEDGE |
PLEDGE_TRANS_AMOUNT_PAID |
NO |
|
SUM(AMOUNT) |
NA |
NO |
|
|
|
|
This summarizes the amount SUM(TBRACCD_AMOUNT) for a given term, category code and detail code. |
SUM(FPRRCDT_AMT_RCVD) |
FPARCVD |
NO |
|
|
|
|
NA |
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY) |
FPARCVD FPARTRN |
NO |
|
|
|
|
NA |
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD) |
FPARCVD |
NO |
COMPOSITE VIEW |
AF_RECEIVED_ITEM |
QUANTITY_RECEIVED_REJECTED |
NO |
NA |
SUM(FPRRCDT_QTY_RCVD) |
FPARCVD |
NO |
|
|
|
|
NA |
SUM(FPRRTRN_QTY) |
FPARCVD |
NO |
|
|
|
|
Returns the sum of all quantities returned for a purchase order item. |
SUM(PERJTOT_GRS) |
NA |
NO |
COMPOSITE VIEW |
AP_EARNING_TOTALS_FY AP_EARNING_TOTALS_CY |
TOTAL_EARNINGS_FISCAL_YEAR TOTAL_GROSS_CALENDAR_YEAR |
NO NO |
This function returns the sum of the hours SUM(PERJTOT_GRS). |
SUM(PERJTOT_HRS) |
NA |
NO |
COMPOSITE VIEW |
AP_EARNING_TOTALS_FY AP_EARNING_TOTALS_CY |
TOTAL_HOURS_FISCAL_YEAR TOTAL_HOURS_CALENDAR_YEAR |
NO NO |
This function returns the sum of the hours SUM(PERJTOT_HRS). |
SUM(RPRAWRD_ACCEPT_AMT) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_FUND |
ACCEPT_AMOUNT |
NO |
SUM(RPRAWRD_ACCEPT_AMT) |
SUM(RPRAWRD_AUTHORIZE_AMT) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_FUND |
AUTHORIZED_AMOUNT |
NO |
NA |
SUM(RPRAWRD_CANCEL_AMT) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_FUND |
CANCEL_AMOUNT |
NO |
NA |
SUM(RPRAWRD_DECLINE_AMT) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_FUND |
DECLINE_AMOUNT |
NO |
NA |
SUM(RPRAWRD_MEMO_AMT) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_FUND |
MEMO_AMOUNT |
NO |
NA |
SUM(RPRAWRD_OFFER_AMT) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_FUND |
OFFER_AMOUNT |
NO |
NA |
SUM(RPRAWRD_PAID_AMT) |
NA |
NO |
COMPOSITE VIEW |
AR_AWARD_BY_FUND |
PAID_AMOUNT |
NO |
NA |
SYSDATE BETWEEN SPRHOLD_FROM_DATE AND SPRHOLD_TO_DATE |
NA |
NO |
|
|
|
|
|
TBD |
NA |
NO |
COMPOSITE VIEW |
AF_OPERATING_LEDGER AF_OPERATING_LEDGER |
SUM_LAST_YEAR_ACTUAL CURR_PERIOD_LAST_YEAR_ACTUAL |
NO NO |
|
TBLD |
NA |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_LABOR_DIST |
PAF_TRANSACTION_TYPE |
NO |
|
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE1') |
NA |
NO |
|
|
|
|
Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student. |
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE2') |
NA |
NO |
|
|
|
|
Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student. |
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE3') |
NA |
NO |
|
|
|
|
Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student. |
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE4') |
NA |
NO |
|
|
|
|
Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student. |
TO_CHAR (TO_DATE (FAB1099_RPT_YR, 'RR'), 'YYYY') |
NA |
NO |
COMPOSITE VIEW |
AF_VENDOR_TAXABLE_REPORTING |
TAX_YEAR |
NO |
|
TO_CHAR (TO_DATE (FRRGRNH_FSYR_CODE, 'RR'), 'YYYY' |
NA |
NO |
COMPOSITE VIEW |
AF_GRANT_DEFERRED_COST |
FISCAL_YEAR |
NO |
|
TO_CHAR(TBRACCD_CSHR_END_DATE, 'HH24:MM:SS') |
NA |
NO |
|
|
|
|
This calculation retrieves the 24 hour time from TBRACCD_CSHR_END_DATE. |
TO_CHAR(TBRDEPO_CSHR_END_DATE, 'HH24:MM:SS') |
NA |
NO |
|
|
|
|
This calculation retrieves the 24 hour time from TBRDEPO_CSHR_END_DATE. |
TO_CHAR(TBRMISD_CSHR_END_DATE, 'HH24:MM:SS') |
NA |
NO |
|
|
|
|
This calculation retrieves the 24 hour time from TBRMISD_CSHR_END_DATE. |
TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'), 'YYYY') |
NA |
NO |
COMPOSITE VIEW |
AF_TRANSACTION_HISTORY |
FISCAL_YEAR |
NO |
This calculation transforms a two digit fiscal year into a 4 digit fiscal year for the transaction detail record. |
TO_CHAR(TO_DATE(FGBTRNH_FSYR_CODE,'RR'), 'YYYY') |
NA |
NO |
COMPOSITE VIEW |
AF_TRANSACTION_HISTORY |
FISCAL_YEAR_HEADER |
NO |
This calculation transforms a two digit fiscal year into a 4 digit fiscal year for the transaction history record. |
TO_CHAR(TRRACCD_CSHR_END_DATE, 'HH24:MM:SS') |
NA |
NO |
|
|
|
|
This calculation retrieves the 24 hour time from TRRACCD_CSHR_END_DATE. |
TTBTAXN_AMOUNT_3 * -1 |
NA |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
PRIOR_YEAR_CHARGES_ADJUSTED |
NO |
|
TTBTAXN_AMOUNT_5 * -1 |
NA |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
PRIOR_YR_SCHOLARSHIP_GRANT_ADJ |
NO |
|
TTBTAXN_AMOUNT_6 * -1 |
NA |
NO |
COMPOSITE VIEW |
AT_STUDENT_TAX_NOTIFICATION |
PRIOR_YEAR_PAYMENT_ADJ |
NO |
|
CASE WHEN RLRDDAS_DISB_SEQ_NO |
NA |
NO |
COMPOSITE VIEW |
AR_LOAN_DISBURSEMENT_DETAIL |
RECORD_SOURCE |
NO |
|
SUBSTR(GORSDAV_PK_PARENTTAB,) |
TBD |
NO |
COMPOSITE VIEW |
AG_SDE_DATA AG_SDE_DATA AG_SDE_DATA AG_SDE_DATA AG_SDE_DATA AG_SDE_DATA |
PARENT_TABLE_PK_COL4 PARENT_TABLE_PK_COL2 PARENT_TABLE_PK_COL3 PARENT_TABLE_PK_COL1 PARENT_TABLE_PK_COL5 PARENT_TABLE_PK_COL6 |
NO NO NO NO NO NO |
This calculation retrieves the portion of the composite primary key-GORSDAV_PK_PARENTTAB. |