RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: CALCULATION Common Composite View Reports
SGHE Operational Data Store Composite View Source: CALCULATION

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

AF_OPERATING_LEDGER

CURR_REMAINING_BALANCE

This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes only activity in this period.
(FGBOPAL_XX_ADOPT_BUD+ FGBOPAL_XX_BUD_ADJT)-( FGBOPAL_XX_YTD_ACTV+FGBOPAL_XX_ENCUMB+ FGBOPAL_XX_BUD_RSRV) FGIBDST COMPOSITE VIEW

AF_OPERATING_LEDGER

SUM_REMAINING_BALANCE

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

AF_GRANT_LEDGER

SUM_REMAINING_BALANCE

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

AF_GRANT_LEDGER

CURR_REMAINING_BALANCE

This calculation returns the remaining balance by adding the budget and budget adjustment amounts and then subtracting any activity, encumbrances and budget reservations. It includes only activity in this period.
(NVL(FARINVC_APPR_QTY,0)*NVL( FARINVC_APPR_UNIT_PRICE,0))+NVL( FARINVC_ADDL_CHRG_AMT,0)+NVL( FARINVC_TAX_AMT,0)-NVL(FARINVC_DISC_AMT, 0) FAAINVE COMPOSITE VIEW

AF_INVOICE_ITEM

APPROVED_ITEM_AMOUNT

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

AF_BUDGET_DETAIL

BUDGET_AMOUNT

This calculation returns the budgeted amount by adding the original budget to any budget adjustments.
(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 COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

APPROVED_ITEM_AMOUNT

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

AA_MEMBERSHIP

MEMBERSHIP_DUES_AMOUNT_OWED

NA
AARMEMB_STATUS_OVERRIDE_IND NA COMPOSITE VIEW

AA_MEMBERSHIP

AUTO_STATUS_UPDATE_IND

NA
ADD_MONTHS NBAFISC COMPOSITE VIEW

AN_FISCAL_YEAR

AN_FISCAL_YEAR

AN_FISCAL_YEAR

AN_FISCAL_YEAR

QUARTER2_START

QUARTER4_START

QUARTER1_START

QUARTER3_START

This function returns the specified date NBBFISC_BEGIN_DATE plus the specified number of months.
AGBMGID_AMT - AGBMGID_AMT_PAID NA COMPOSITE VIEW

AA_GIFT_MATCHING

MATCH_GIFT_BALANCE

NA
AGRGDES_AMT-F_GIFT_HARD_CREDIT NA       NA
AGRGPAY_AMT + A$_3RD_PARTY_CREDIT NOT TO EXCEED AGRPINS_AMT NA COMPOSITE VIEW

AA_PLEDGE_INSTALLMENT

INSTALLMENT_PAID_AMOUNT

NA
AGRPDES_AMT-AGRPDES_AMT_PAID NA COMPOSITE VIEW

AA_PLEDGE

PLEDGE_BALANCE

NA
AGRPDES_AMT-F_PLEDGE_HARD_CREDIT NA COMPOSITE VIEW

AA_PLEDGE

PLEDGE_CREDIT

NA
AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER ||AORCONT_PHONE_EXT NA COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

PHONE_NUMBER_COMBINED

AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER||AORCONT_PHONE_EXT
DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND) NA       DECODE(NBBPOSN_EXEMPT_IND,'Y',DECODE(NTRPCLS_EXEMPT_IND,'Y','Exemption Position Class and Position Definition','Non-exempt Position Class and Position Definition'),DECODE(NTRPCLS_EXEMPT_IND,'Y','Exempt Class but overridden by the Position Definition','Non-exempt Position Class but overridden by the Position Definition'))
DECODE('AIDY','AIDY','AIDY',NULL) NA COMPOSITE VIEW

AR_YEAR_TYPE_DEFINITION

YEAR_TYPE

NA
DECODE('INST_AIDY','INST_AIDY', 'INST_AIDY',NULL) NA COMPOSITE VIEW

AR_YEAR_TYPE_DEFINITION

YEAR_TYPE

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

AA_GIFT_MATCHING

ACTIVE_IND

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

AA_GIFT_MATCHING

MATCH_GIFT_STATUS

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

AA_GIFT_MATCHING

MATCH_GIFT_STATUS_DESC

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

AA_GIFT_AUXILIARY

BENEFIT_ACCEPT_REJECT_DESC

NA
DECODE(AGRPDES_AMT-AGRPDES_AMT_PAID) NA       NA
DECODE(AGRPDES_AMT_PAID) NA       NA
DECODE(AMBPROP_STAFF_PIDM) NA COMPOSITE VIEW

AA_PROSPECT_PROPOSAL

AA_PROSPECT_PROPOSAL

PROPOSAL_STAFF_ID

PROPOSAL_STAFF_NAME

This calculation checks whether the AMBPROP_STAFF_PIDM is NULL. If it is, it retrieves information based upon the AMBPROP_STAFF_IDEN_CODE. Otherwise, it uses the AMBPROP_STAFF_PIDM to retrieve the information.
DECODE(AMRPRRT_RATING_PIDM,NULL, AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM) NA COMPOSITE VIEW

AA_ADVANCEMENT_RATING

RATER_UID

NA
DECODE(APRADEG_HOND_CODE_1) TBD        
DECODE(APRADEG_HONR_CODE) TBD        
DECODE(APRADEG_SBGI_CODE, AUBINST_SBGI_CODE,'Y','N') NA COMPOSITE VIEW

AA_DEGREE

INSTITUTION_IND

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

AA_RELATIONSHIP

SPOUSE_STATUS_DESC

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

AA_GIFT_SOCIETY

LIFETIME_GIFT_SOCIETY_IND

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

AA_RELATIONSHIP

COMBINED_MAILING_PRIORITY_DESC

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

AA_DONOR_CATEGORY

VSE_DESC_1

NA
DECODE(ATVDONR_CFAE_2) NA COMPOSITE VIEW

AA_DONOR_CATEGORY

VSE_DESC_2

NA
DECODE(ATVGIFT_CFAE_GIFT_CATG) NA COMPOSITE VIEW

AA_GIFT

GIFT_VSE_DESC

NA
DECODE(BENEFICIARY_NAME) NA       DECODE(B.BENEFICIARY_LAST_NAME, NULL, BP.FULL_NAME_LFMI, B.BENEFICIARY_LAST_NAME||', '||B.BENEFICIARY_FIRST_NAME||' '||DECODE(B.BENEFICIARY_MIDDLE_INITIAL,NULL,NULL,SUBSTR(BENEFICIARY_MIDDLE_INITIAL,1,1))|| '.')
DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL) FAAINVE COMPOSITE VIEW

AF_INVOICE

REMIT_TO_STREET_LINE1

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

AF_INVOICE

REMIT_TO_STREET_LINE2

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

AF_INVOICE

REMIT_TO_STREET_LINE3

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

AF_INVOICE

REMIT_TO_CITY

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

AF_INVOICE

REMIT_TO_NATION

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

AF_INVOICE

REMIT_TO_STATE_PROVINCE

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

AF_INVOICE

REMIT_TO_POSTAL_CODE

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

AF_INVOICE

REMIT_TO_ADDRESS_TYPE_NUMBER

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

AF_INVOICE

ONE_TIME_VENDOR_ADDRESS_IND

NA
DECODE(FABINVH_INVOICE_TYPE_IND) FAAINVE COMPOSITE VIEW

AF_INVOICE

INVOICE_TYPE_DESC

This calculation evaluates the column FABINVH_INVOICE_TYPE_IND. If it is a D, it will return DIRECT. If it is an R, it will return REGULAR. If it is neither D nor R, it will return NULL.
DECODE(FABINVH_VEND_CHECK_PIDM,NULL,'N', 'Y') FAAINVE COMPOSITE VIEW

AF_INVOICE

THIRD_PARTY_ADDRESS_IND

NA
DECODE(FABINVH_VEND_PIDM, NULL, FABINVH_ONE_TIME_VEND_NAME, NULL) FAAINVE COMPOSITE VIEW

AF_INVOICE

VENDOR_NAME

NA
DECODE(FFBMAST_SUBORDINATE_TYPE) FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SUBORDINATE_TYPE_DESC

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

AF_FIXED_ASSET_DEPRECIATION

DEPRECIATION_POSTING_STATUS

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

AF_ENCUMBRANCE_ACCOUNTING

ENCUMBRANCE_STATUS

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

AF_ENCUMBRANCE_ACCOUNTING

POSTABLE_IND

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

AF_ENCUMBRANCE

ENCUMBRANCE_SOURCE

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

AF_ENCUMBRANCE

COMPLETE_IND

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

AF_ENCUMBRANCE

ENCUMBRANCE_STATUS

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

AF_ENDOWMENT

RESTRICTION_TYPE_DESC

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

AF_ENDOWMENT

POOL_STATUS_DESC

This calculation will evaluate the column FNVPOOL_STATUS_IND. If it is an A, it will return ACTIVE. If it is an I, it will return INACTIVE. Otherwise, it will return NULL.
DECODE(FNVPOOL_STATUS_IND) FNMPOOL       This calculation will evaluate the column FNVPOOL_STATUS_IND. If it is an A, it will return ACTIVE. If it is an I, it will return INACTIVE. Otherwise, it will return NULL.
DECODE(FPBPOHD_PO_TYPE_IND) FPAPURR COMPOSITE VIEW

AF_PURCHASE_ORDER

PURCHASE_ORDER_TYPE_DESC

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

AF_RECEIVED_ITEM

ADJUSTED_IND

This calculation returns a Y or N if the item was adjusted or not adjusted.
DECODE(FPRRCDT_PARTIAL_FINAL_IND) FPARCVD COMPOSITE VIEW

AF_RECEIVED_ITEM

FINAL_RECEIPT_IND

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

AF_RECEIVED_ITEM

TOLERANCE_OVERRIDE_IND

NA
DECODE(FRRBDET_ACCT_CLASS_CODE) FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

ACCOUNT_CLASS

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

AF_GRANT_BILLING_DETAIL

BILL_STATUS_DESC

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

AF_LOCATION_ATTRIBUTES_ODS

AF_ORGANIZATION_ATTRIBUTES_ODS

AF_PROGRAM_ATTRIBUTES_ODS

AF_ATTRIBUTE_SETS_ODS

AF_FUND_ATTRIBUTES_ODS

AF_ACCOUNT_TYPE_ATTRIBUTES_ODS

AF_CHART_ATTRIBUTES_ODS

AF_ACCOUNT_ATTRIBUTES_ODS

AF_FUND_TYPE_ATTRIBUTES_ODS

AF_ACTIVITY_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

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

AF_VENDOR

FEDERAL_REPORTABLE_TAX_IND

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

AP_HR_APPLICATION

STATUS_DISPOSITION_DESC

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

AG_GEOGRAPHIC_REGION_INST

GEOGRAPHIC_SOURCE_USER_IND

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

AG_GEOGRAPHIC_REGION_INST

GEOGRAPHIC_REGION_STATUS

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

AG_GEOGRAPHIC_REGION_INST

GEOGRAPHIC_REGION_STATUS_DESC

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

AG_COMMUNICATION

PENDING_LETTER_IND

NA
DECODE(GURMAIL_MISC_DATE,NULL, GURMAIL_DATE_PRINTED) NA COMPOSITE VIEW

AG_COMMUNICATION

DATE_SENT

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

AG_COMMUNICATION

COMMUNICATION_TYPE_DESC

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

AN_POSITION_DEFINITION

POSITION_STATUS_DESC

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

AP_EMPLOYEE

AN_EMPLOYEE_POSITION

CONTRACT_TYPE_DESC

POSITION_CONTRACT_TYPE_DESC

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

AN_EMPLOYEE_POSITION

PUBLIC_RETIRE_PAY_RATE_DESC

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

AN_EMPLOYEE_POSITION

POSITION_STATUS_DESC

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

AN_EMPLOYEE_POSITION

STATE_RETIREMENT_PAY_RATE_DESC

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

AN_POSITION_BUDGET

AN_PAYROLL_DISTRIBUTION

BUDGET_STATUS_DESC

BUDGET_STATUS_DESC

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

AN_PAYROLL_DISTRIBUTION

PAYROLL_EVENT_TYPE_DESC

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

AA_PLEDGE

PLEDGE_FULLY_PAID_IND

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

AA_PLEDGE

PLEDGE_PARTIAL_PAID_IND

NA
DECODE(PAYROLL_DEDUCTION) NA       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 COMPOSITE VIEW

AP_BENEFIT_DEDUCTION

STATUS_DESC

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

AP_TAX

STATUS_DESC

NA
DECODE(PEBEMPL_1042_RECIPIENT_CD) NA COMPOSITE VIEW

AP_EMPLOYEE

FOREIGN_INCOME_RECIPIENT_DESC

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

AP_EMPLOYEE

EMPLOYEE_STATUS_DESC

This function return Active if the employee status PEBEMPL_EMPL_STATUS is A, Leave withoutpay and with benefit if it is B, Leave without pay and without benefit if it is L, Leave with pay and with benefit if it is F, Leave with part pay and with benefit if it is P, Terminated if it is T.
DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED, N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT) NA COMPOSITE VIEW

AP_EMPLOYEE

IMMIGRATION_STATUS_DESC

This function returns RECEIVED if the I9 form indicator PEBEMPL_I9_FORM_IND is R, NOTRECEIVED if it is N, TEMPORARY if it is T,
DECODE(PERAPPT_DECISION) NA       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       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 COMPOSITE VIEW

AP_EMPLOYEE_EARNING_CY

QUARTER

This function returns what quarter it is based on the month PERJTOT_MONTH. 1, 2, 3 are the first quarter. 4, 5, 6 are the second quarter. 7, 8, 9 are the third quarter. 10, 11, 12 are the fourth quarter.
DECODE(PERRANK_DECISION) NA       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       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       SUBSTR(DECODE(PHRACCR_CALC_GEN_IND, 'Y', G$_NLS.GET('x','SQL','Calculated'), 'N', G$_NLS.GET('x','SQL','Manual')),1,30)
DECODE(PHRDOCM_DOC_TYPE) NA       DECODE(PHRDOCM_DOC_TYPE, 'C', 'N', 'D', 'Y')
DECODE(PHRHIST_CALC_IND) NA       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       SUBSTR(DECODE(PHRHIST_PRINT_IND, 'M', G$_NLS.GET('x','SQL','Manual'), 'C', G$_NLS.GET('x','SQL','Calculated')),1,30)
DECODE(PHRJOBS_TIME_ENTRY_IND) NA       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       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       NA
DECODE(POSITION_CLASS_EXEMPTION_IND) NA        
DECODE(PTRBDCA_CALC_RULE) NA       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(RPRLAPP_COSIGN1_RELATION_IND) NA COMPOSITE VIEW

AR_LOAN_APPLICATION

COSIGN1_RELATIONSHIP_DESC

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

AR_LOAN_APPLICATION

COSIGN2_RELATIONSHIP_DESC

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

AR_FINAID_FUND

FUND_SOURCE_TYPE_DESC

NA
DECODE(RTVFTYP_ATYP_IND) NA COMPOSITE VIEW

AR_FINAID_FUND

FINANCIAL_AID_TYPE_DESC

NA
DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME') SAAADMS       NA
DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y') SFASLST COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

AS_STUDENT_COURSE_HISTORY

FINAL_GRADE_ROLL_IND

FINAL_GRADE_ROLL_IND

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

AS_STUDENT_COURSE_IN_PROGRESS

IN_PROGRESS_COURSE_IND

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

AS_STUDENT_COURSE_IN_PROGRESS

AS_STUDENT_COURSE_IN_PROGRESS

INSTITUTION_COURSE_IND

TRANSFER_COURSE_IND

This function returns an N if the registration record SFRSTCR does not exist for the specified UID, academic period and course else it returns a Y.
DECODE(SGBSTDN_LEVL_CODE,NULL,'N','Y') SGASTDN       This function returns an N if the student level code SGBSTDN_LEVL_CODE is null else it returns a Y.
DECODE(SGBSTDN_LEVL_CODE,NULL,'N','Y'), DECODE(SORLCUR_LEVL_CODE,NULL,'N','Y'), 'N') NA        
DECODE(SGBSTDN_LEVL_CODE,NULL,NULL,'01') SGASTDN       This function returns a null if the student level code SGBSTDN_LEVL_CODE is null else it returns a 01.
DECODE(SGBSTDN_LEVL_CODE_2,NULL,NULL, '02') SGASTDN       This function returns a null if the student secondary level code SGBSTDN_LEVL_CODE_2 is null else it returns a 02.
DECODE(SGBSTDN_TERM_CODE_ADMIT) TBD        
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL, 'N','Y') SGASTDN       This function returns an N if the matriculated academic period is null else it returns a Y.
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1)+DECODE(SGBSTDN_LEVL_CODE_2,NULL,0, DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0, 1)) SGASTDN       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 COMPOSITE VIEW

AS_CURRICULUM

MATRICULATED_IND

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

AS_OUTCOME_HONOR_DEPT

HONOR_IND

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 COMPOSITE VIEW

AS_OUTCOME_HONOR_INST

HONOR_IND

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 COMPOSITE VIEW

AS_GPA_LEVEL

GPA_TYPE_DESC

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

AS_STUDENT_COURSE_ATTR_TRANS

TRANSFER_COURSE_IND

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

AS_STUDENT_COURSE_ATTR_TRANS

INSTITUTION_COURSE_IND

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

AS_GPA_TERM

GPA_TYPE_DESC

This function returns Institution if the gpa type indicator SHRLGPA_GPA_TYPE_IND is I, else it returns Transfer if the gpa type indicator is a T.
DECODE(SHRTRCE_PIDM,NULL,'N','Y') SHATRNS       This function returns a N if the transfer course record SHRTRCE doesn't exist, else a Y.
DECODE(SIBFACD_PRIMARY_ACTIVITY) TBD        
DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C', 'CLASS','OTHER') SLARASG COMPOSITE VIEW

AS_ROOM_ASSIGNMENT

ROOM_TYPE_DESC

This function returns DORM if the room type SLBRDEF_ROOM_TYPE is D, CLASS if the room type is C else OTHER.
DECODE(SORAPPT_INTV_PIDM,NULL,NULL, F_FORMAT_NAME(SORAPPT_INTV_PIDM,'LFMI')) SOAAPPT       This function returns null if the pidm is null SORAPPT_INTV_PIDM else it returns the formatted name of the interviewer.
DECODE(SORBACD_STATE_APPROV_IND) TBD       DECODE(SORBACD_STATE_APPROV_IND,'Y','Y','N')
DECODE(SORDEGR_HONR_CODE) TBD        
DECODE(SORLCUR_ADMT_CODE) NA       DECODE(SORLCUR_ADMT_CODE,NULL,SGBSTDN_ADMT_CODE,SORLCUR_ADMT_CODE)
DECODE(SORLCUR_LEVL_CODE,NULL,'N','Y') NA       This function returns an N if the student level code SORLCUR_LEVL_CODE is null else it returns a Y.
DECODE(SORLCUR_SITE_CODE) NA       DECODE(SORLCUR_SITE_CODE,NULL,SGBSTDN_SITE_CODE,SORLCUR_SITE_CODE)
DECODE(SORLCUR_TERM_CODE_ADMIT) NA       NA
DECODE(SORLCUR_TERM_CODE_MATRIC) SGASTDN       DECODE(SORLCUR_TERM_CODE_MATRIC,NULL,'N','Y')
DECODE(SPBPERS_NAME_PREFIX,NULL,DECODE( SPBPERS_SEX,'M','MR.','F','MS.'), SPBPERS_NAME_PREFIX) NA COMPOSITE VIEW

AS_PERSON

NAME_PREFIX

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

AA_RELATIONSHIP

AS_PERSON

RELATED_GENDER_DESC

GENDER_DESC

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

AS_PERSON

VETERAN_CATEGORY_DESC

This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran.
DECODE(SPBPERS_VERA_IND, NULL, NULL, O, OTHER PROTECTED VETERAN ONLY, V, VIETNAM VETERAN ONLY, B, BOTH - VIETNAM AND OTHER ELIGIBLE VETERAN) SPAPERS       NA
DECODE(SPBPERS_VERA_IND,NULL,NULL, 'VETERAN') SPAPERS       This function returns null if the veteran category SPBPERS_VERA_IND is null else it returns Veteran.
DECODE(SPOUSE_IND) NA       DECODE(TO_CHAR(MAKFUNC.F_COUNT_RELATION(C.ENTITY_UID, 'S')), '0', 'N', 'Y'),
DECODE(SPRIDEN_ID,NULL,NULL,'BANNER') NA COMPOSITE VIEW

AS_PERSON

ID_NUMBER_SOURCE

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

AS_MEDICAL_INFORMATION

PRIMARY_DISABILITY_IND

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

AS_ROOM_ASSIGNMENT

ROOM_RATE_TIME

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

AS_INSTITUTION

INSTITUTION_TYPE_DESC

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

AT_CONTRACT

STUDENT_INACTIVATED_IND

NA
DECODE(TBBESTU_DEL_IND) TSAEXPP COMPOSITE VIEW

AT_EXEMPTION

EXEMPTION_CANCELLED

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

AT_ACCOUNT_DETAIL

RETURNED_CHECK_IND

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

AT_ACCOUNT_DETAIL

BILL_AMOUNT

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

AT_ACCOUNT_DETAIL

ACCOUNT_POSTED_AMOUNT

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

AT_AR_DEPOSIT

ACCOUNT_POSTED_AMOUNT

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

AA_CONSTITUENT_PLAN

MOVE_COMPLETION_IND

NA
DECODE(TRANSACTION_HISTORY.FUND_POOL, NULL,FUND_HIERARCHY.FUND_POOL_DESC, TRANSACTION_HISTORY.FUND_POOL_DESC) NA       Population of fund pool description is from the fund pool on fund_hierarchy if fund_pool is originally null on transaction history.
FFRMASA_AMT+FFRMASA_ADJ_AMT- FFRMASA_DEPR_ACCUM_AMT FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_DEPRECIATION

BOOK_VALUE

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

AF_GENERAL_LEDGER

CURRENT_ACTUAL

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

AF_OPERATING_LEDGER

CURR_ACCUMULATED_BUDGET

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

AF_OPERATING_LEDGER

CURR_ADOPTED_BUDGET

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

AF_OPERATING_LEDGER

CURR_BUDGET_ADJUSTMENTS

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

AF_OPERATING_LEDGER

CURR_BUDGET_RESERVATION

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

AF_OPERATING_LEDGER

CURR_ENCUMBRANCES

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

AF_OPERATING_LEDGER

CURR_TEMPORARY_BUDGET

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

AF_OPERATING_LEDGER

CURR_YEAR_TO_DATE_ACTIVITY

This calculation returns the activity for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FNBUNTH_NUM_UNITS * FNRUCTR_PUR_PRICE_VAL_UNIT FNIEBAL       This calculation returns the market value by multiplying the units by the purchase price per unit.
FRRGRNL_XX_ACCTD_BUD - FRRGRNL_XX- 1_ACCTD_BUD FRIGITD COMPOSITE VIEW

AF_GRANT_LEDGER

CURR_ACCOUNTED_BUDGET

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

AF_GRANT_LEDGER

CURR_ADOPTED_BUDGET

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

AF_GRANT_LEDGER

CURR_BUDGET_ADJUSTMENTS

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

AF_GRANT_LEDGER

CURR_BUDGET_RESERVATIONS

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

AF_GRANT_LEDGER

CURR_ENCUMBRANCES

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

AF_GRANT_LEDGER

CURR_TEMPORARY_BUDGET

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

AF_GRANT_LEDGER

CURR_YEAR_TO_DATE_ACTIVITY

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

AF_GRANT_LEDGER

CURR_MEMO_COSTS

This calculation returns the memo costs for only this period. It subtracts the previous period from the current period in that the amounts stored are cumulative.
FTVSHIP_PHONE_AREA||FTVSHIP_PHONE_NUM||F TVSHIP_PHONE_EXT NA COMPOSITE VIEW

AF_PURCHASE_ORDER_ITEM

AF_PURCHASE_ORDER

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

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

AF_VENDOR

PHONE_NUMBER_COMBINED

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

AR_NEED_ANALYSIS

INAS_TFC

LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)
LEVEL FTMFUND COMPOSITE VIEW

AF_LOCATION_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_FUND_HIERARCHY

AF_ORGANIZATION_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_FUND_HIERARCHY

LOCATION_LEVEL

ACCOUNT_LEVEL

FUND_LEVEL

ORGANIZATION_LEVEL

ACCOUNT_TYPE_LEVEL

PROGRAM_LEVEL

FUND_TYPE_LEVEL

This value is retrieved upon formulation of the validation table hierarchy and pertains to what level this code associates to within its hierarchy. (Level 1 being the highest level.)
MAX(APRACYR_YEAR) NA COMPOSITE VIEW

AA_SPECIAL_ACTIVITY

LAST_YEAR

NA
MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE FNIEBAL       NA
MFKFUNC.F_QTY_RECEIVED_REJECTED FPARCVD       Calculates the quantity of items received less items rejected.
MIN(APRACYR_YEAR) NA COMPOSITE VIEW

AA_SPECIAL_ACTIVITY

FIRST_YEAR

NA
MONTHS_BETWEEN NA COMPOSITE VIEW

AP_PAST_EMPLOYMENT

YEARS_MONTHS_IN_POSITION

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

AA_PREVIOUS_EMPLOYMENT

MONTHS_IN_POSITION

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

AN_POSITION_BUDGET

AMOUNT_REMAINING

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

AA_MEMBERSHIP

MEMBERSHIP_CARD_IND

NA
NVL(AGBMGID_MG_FORMSENT_IND,'N'), NA COMPOSITE VIEW

AA_GIFT_MATCHING

MATCH_FORM_SENT_IND

NA
NVL(AGBPLDG_ADJ_IND,'N'), NA COMPOSITE VIEW

AA_PLEDGE

PLEDGE_ADJUSTMENT_IND

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

AA_PLEDGE

PLEDGE_ACKNOWLEDGED_IND

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

AA_PLEDGE

RECEIPT_REQUIRED_IND

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

AA_GIFT_AUXILIARY

DEDUCT_FOR_TAXES_IND

NA
NVL(APREHIS_PRIMARY_IND,'N') APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

PRIMARY_EMPLOYMENT_IND

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

AA_PREVIOUS_EMPLOYMENT

EMPLOYMENT_STATUS_ACTIVE_IND

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

AF_INVOICE_ACCOUNTING

APPROVED_CHARGE_AMOUNT

This calculation returns the approved charge amount by summing the approved amount, additional charges, and tax amount and subtracting any associated discount.
NVL(FPBPOHD_REXP_DATE, FPBPOHD_BLANKET_TERM_DATE) FPABLAR COMPOSITE VIEW

AF_PURCHASE_ORDER

PO_END_DATE

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

AF_PURCHASE_ORDER_ACCOUNTING

APPROVED_CHARGE_AMOUNT

This calculation returns the approved charge amount by summing the approved amount, additional charges, and tax amount and subtracting any associated discount.
NVL(FPRRCDT_COMM_DESC) FPARCVD       This calculation returns commodity description from commodity if description not changed, from received item if commodity description was changed.
NVL(FPRRCDT_TOL_OVERRIDE_IND) FPARCVD       Calculations deterimines if the override is set to (Y)es or (N)o.
NVL(FTRACTA_ATTS_CODE,'NONE') FTMFATA COMPOSITE VIEW

AF_ACCOUNT_ATTRIBUTES_ODS

SET_CODE

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

AF_ACTIVITY_ATTRIBUTES_ODS

SET_CODE

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

AF_ACCOUNT_TYPE_ATTRIBUTES_ODS

SET_CODE

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

AF_FUND_ATTRIBUTES_ODS

SET_CODE

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

AF_FUND_TYPE_ATTRIBUTES_ODS

SET_CODE

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

AF_LOCATION_ATTRIBUTES_ODS

SET_CODE

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

AF_ORGANIZATION_ATTRIBUTES_ODS

SET_CODE

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

AF_PROGRAM_ATTRIBUTES_ODS

SET_CODE

NA
NVL(FTVACCT_ACCT_CODE_POOL, FTVACCT_ACCT_CODE) FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY

ACCOUNT_POOL

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

AF_FUND_HIERARCHY

FUND_POOL

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

AF_ORGANIZATION_HIERARCHY

ORGANIZATION_POOL

This calculation retrieves the FTVORGN_CODE_NSF if it is not NULL. Otherwise it retrieves the FTVORGN_ORGN_CODE.
NVL(GURMAIL_MISC_DATE, GURMAIL_DATE_PRINTED) NA       NA
NVL(NBBPOSN_ACCRUE_SENIORITY_IND, NTRPCLS_ACCRUE_SENIORITY_IND) MULTIPLE COMPOSITE VIEW

AN_POSITION_DEFINITION

SENIORITY_ACCRUED_IND

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

AN_POSITION_DEFINITION

SALARY_GRADE

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       NVL(POSITION_REPORTS, SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION,'POSITION'),1,63))
NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE) TBD        
NVL(NBBPOSN_STEP,NTRPCLS_STEP) NA COMPOSITE VIEW

AN_POSITION_DEFINITION

SALARY_STEP

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

AN_POSITION_DEFINITION

SALARY_TABLE

This function returns NBBPOSN_TABLE if it is not null, else it returns NTRPCLS_TABLE.
NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR) NA       NVL(P.NBRJOBS_SUPERVISOR_PIDM, TO_NUMBER(NOKODSF.F_GET_SUPERVISOR(B.NBBPOSN_POSN_REPORTS,'PIDM')))
NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS) NA       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       NVL(NBRJOBS_SUPERVISOR_SUFF, SUBSTR(NOKODSF.F_GET_SUPERVISOR(NBBPOSN_POSN_REPORTS,'SUFFIX'),1,2)
NVL(PAY.TRANSACTION_DATE, CHG.TRANSACTION_DATE) NA       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(SARADAP_FEE_IND,'N') NA COMPOSITE VIEW

AS_ADMISSIONS_APPLICATION

APPLICATION_FEE_REQUIRED_IND

NA
NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS( SHRTCKN_PIDM,SHRTCKN_TERM_CODE, SHRTCKN_CRN)) NA COMPOSITE VIEW

AS_STUDENT_COURSE_HISTORY

EXTENSIONS

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 COMPOSITE VIEW

AS_STUDENT_COURSE_HISTORY

END_DATE

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 COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

START_DATE

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

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

GRAD_YEAR_INTENDED

GRAD_YEAR_INTENDED

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

AS_CURRICULUM

ADMISSIONS_POPULATION

Retrieve admission population from student record sgbstdn if the field is null in the new multiple curriculum record sorlcur.
NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE) MULTIPLE COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

EXPECTED_GRADUATION_DATE

EXPECTED_GRADUATION_DATE

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

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

LEAVE_REASON

LEAVE_REASON

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

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

LEAVE_DATE_FROM

LEAVE_DATE_FROM

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

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

LEAVE_DATE_TO

LEAVE_DATE_TO

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

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

STUDENT_RATE

STUDENT_RATE

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

AS_CURRICULUM

SITE

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

AS_CURRICULUM

STUDENT_POPULATION

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

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

GRAD_ACADEMIC_PERIOD_INTENDED

GRAD_ACADEMIC_PERIOD_INTENDED

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

AS_INSTRUCTIONAL_ASSIGNMENT

INSTRUCTOR_LAST_NAME

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

AS_STUDENT_COURSE_IN_PROGRESS

COURSE_COLLEGE

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 COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

COURSE_DEPARTMENT

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 COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

COURSE_DIVISION

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       NA
NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE) SCACRSE COMPOSITE VIEW

AS_STUDENT_COURSE_IN_PROGRESS

COURSE_TITLE_SHORT

NA
NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH) SCACRSE       NA
NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH) SCACRSE       NA
NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH) SCACRSE       NA
NVL(TBRDEPO_AMOUNT-F_ACCD_AMOUNT( TBRDEPO_PIDM,TBRDEPO_TRAN_NUMBER),0) TSADETL COMPOSITE VIEW

AT_AR_DEPOSIT

BALANCE_AMOUNT

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

AT_AR_DEPOSIT

AT_ACCOUNT_DETAIL

OPERATING_DATE

OPERATING_DATE

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

AP_PAST_EMPLOYMENT

SUPERVISOR_COMBINED_PHONE

NA
PPRREFE_PHONE_AREA||PPRREFE_PHONE_NUMBER ||PPRREFE_PHONE_EXT NA COMPOSITE VIEW

AP_REFERENCE

COMBINED_PHONE

This function concatenates the phone area code, the phone number and the phone extension from the PPRREFE table.
ROUND(MONTHS_BETWEEN(SYSDATE,BIRTH_DATE) /12,0) SPAPERS       This function calculates the person''s current age based on SPBPERS_BIRTH_DATE and SYSDATE.
SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB SCACRSE COMPOSITE VIEW

AS_COURSE_CATALOG

COURSE_IDENTIFICATION

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

AS_COURSE_SUPPLEMENTAL

COURSE_IDENTIFICATION

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

AS_COURSE_COREQ

COURSE_IDENTIFICATION_COREQ

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

AS_COURSE_COREQ

COURSE_IDENTIFICATION

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

AS_OFFERING_GRADE_MODE

COURSE_IDENTIFICATION

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

AS_COURSE_LEVEL

COURSE_IDENTIFICATION

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

AS_COURSE_PREREQ

COURSE_IDENTIFICATION

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

AS_COURSE_SCHEDULE

COURSE_IDENTIFICATION

This concatenates the course subject code with the course number from the SCRSCHD record.
SFRSTCR_SUBJ_CODE||SFRSTCR_CRSE_NUMB SFAREGS       This concatenates the course subject code with the course number from the SFRSTCR record.
SGRCOOP_PHONE_AREA||SGRCOOP_PHONE_NUMBER ||SGRCOOP_PHONE_EXT NA       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 COMPOSITE VIEW

AS_STUDENT_COURSE_ATTR_TRANS

COURSE_REFERENCE_NUMBER

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

AS_STUDENT_COURSE_GRADE_CHG

AS_STUDENT_COURSE_HISTORY

CREDITS_ATTEMPTED

CREDITS_ATTEMPTED

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

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_GRADE_CHG

CREDITS_EARNED

CREDITS_EARNED

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

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_GRADE_CHG

CREDITS_FOR_GPA

CREDITS_FOR_GPA

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

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_GRADE_CHG

CREDITS_PASSED

CREDITS_PASSED

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

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_GRADE_CHG

QUALITY_POINTS

QUALITY_POINTS

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

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_ATTRIBUTE

AS_STUDENT_COURSE_GRADE_CHG

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

This concatenates the course subject code with the course number from the SHRTCKN record.
SHRTRCE_SUBJ_CODE||SHRTRCE_CRSE_NUMB SHATRNS COMPOSITE VIEW

AS_STUDENT_COURSE_ATTR_TRANS

AS_STUDENT_COURSE_TRANSFER

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

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

AS_STUDENT_COURSE_TRANSFER

COURSE_REFERENCE_NUMBER

 
SLBBLDG_PHONE_AREA||SLBBLDG_PHONE_NUMBER ||SLBBLDG_PHONE_EXTENSION SLABLDG COMPOSITE VIEW

AS_ROOM_ASSIGNMENT

BUILDING_PHONE_NUM_COMBINED

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

AG_EVENT

PHONE_NUMBER_COMBINED

NA
SLBRDEF_PHONE_AREA||SLBRDEF_PHONE_NUMBER ||SLBRDEF_PHONE_EXTENSION SLARASG COMPOSITE VIEW

AS_ROOM_ASSIGNMENT

ROOM_PHONE_NUM_COMBINED

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

AS_PHONE_ASSIGNMENT

PHONE_NUMBER_COMBINED

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

AS_INSTITUTION

CONTACT_PHONE_NUMBER_COMBINED

NA
SPRADDR_CNTY_CODE FAAINVE       NA
SPRIDEN_FIRST_NAME||SPRIDEN_MI||SPRIDEN_ LAST_NAME NA COMPOSITE VIEW

AA_PLEDGE_MATCHING

MATCH_EMPLOYER_NAME

NA
SPRTELE_INTL_ACCESS || SPRTELE_PHONE_AREA || SPRTELE_PHONE_NUMBER || SPRTELE_PHONE_EXT NA       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 COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_TELEPHONE

PHONE_NUMBER_COMBINED

PHONE_NUMBER_COMBINED

This concatenates the the international code, the area code, the phone number and the phone extension from the SPRTELE table.
SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB SFAREGS COMPOSITE VIEW

AS_OFFERING_PREREQ

AS_STUDENT_COURSE_IN_PROGRESS

AS_OFFERING_COREQ

AS_OFFERING_GRADE_TYPE

AS_COURSE_OFFERING

AS_MEETING_TIME

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

COURSE_IDENTIFICATION

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

AS_OFFERING_PREREQ

PREREQ_COURSE_IDENTIFICATION

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

AS_PERSON

MIDDLE_INITIAL

This function returns the middle initial.
SUM(FNBUNTH_TRANS_AMT) FNIEBAL       SUM(FNBUNTH_TRANS_AMT)
SUM(FPRRCDT_AMT_RCVD) FPARCVD       NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY) FPARCVD FPARTRN       NA
SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD) FPARCVD COMPOSITE VIEW

AF_RECEIVED_ITEM

QUANTITY_RECEIVED_REJECTED

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

AP_EARNING_TOTALS_FY

AP_EARNING_TOTALS_CY

TOTAL_EARNINGS_FISCAL_YEAR

TOTAL_GROSS_CALENDAR_YEAR

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

AP_EARNING_TOTALS_CY

AP_EARNING_TOTALS_FY

TOTAL_HOURS_CALENDAR_YEAR

TOTAL_HOURS_FISCAL_YEAR

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

AR_AWARD_BY_FUND

ACCEPT_AMOUNT

SUM(RPRAWRD_ACCEPT_AMT)
SUM(RPRAWRD_AUTHORIZE_AMT) NA COMPOSITE VIEW

AR_AWARD_BY_FUND

AUTHORIZED_AMOUNT

NA
SUM(RPRAWRD_CANCEL_AMT) NA COMPOSITE VIEW

AR_AWARD_BY_FUND

CANCEL_AMOUNT

NA
SUM(RPRAWRD_DECLINE_AMT) NA COMPOSITE VIEW

AR_AWARD_BY_FUND

DECLINE_AMOUNT

NA
SUM(RPRAWRD_MEMO_AMT) NA COMPOSITE VIEW

AR_AWARD_BY_FUND

MEMO_AMOUNT

NA
SUM(RPRAWRD_OFFER_AMT) NA COMPOSITE VIEW

AR_AWARD_BY_FUND

OFFER_AMOUNT

NA
SUM(RPRAWRD_PAID_AMT) NA COMPOSITE VIEW

AR_AWARD_BY_FUND

PAID_AMOUNT

NA
TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE1') NA       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       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       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       Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.
TO_CHAR(TBRACCD_CSHR_END_DATE) NA COMPOSITE VIEW

AT_MISCELLANEOUS_TRANSACTION

AT_GRANT_ACCOUNT_DETAIL

CASHIER_END_TIME

CASHIER_END_TIME

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

AF_TRANSACTION_HISTORY

FISCAL_YEAR

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

AF_TRANSACTION_HISTORY

FISCAL_YEAR_HEADER

This calculation transforms a two digit fiscal year into a 4 digit fiscal year for the transaction history record.


Ver: 3.1