Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FUNCTION Student
Banner Operational Data Store Composite View Source: FUNCTION - NULL

Source Column Business Definition Target Target Column Calculation Formula
(MAKFUNC.F_SOL_FR_TOTAL_PLEDGES + MAKFUNC.F_SOL_FR_TOTAL_GIFTS + MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS) / SOLICITOR_GOAL * 100        
(SELECT COUNT(DISTINCT ACADEMIC_PERIOD) FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY)        
(SELECT COUNT(DISTINCT ACADEMIC_YEAR) FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY)        
(SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE =PAF_TRANSACTION_STATUS)        
AOKODSF.F_CAMPAIGN_MULT_CREDIT  

AA_CAMPAIGN_GIVING_HISTORY

AMOUNT_MULTIPLE_CREDIT

This function returns a summarized total of the AGRGMLT_CREDIT field for the parameter supplied PIDM, Campaign and Fiscal Code. In addition, the cannot be any AGRMGIF record where the AGBGIFT_GIFT_NO field matches the AGRMGIF_EMPR_GIFT_NO field.
AOKODSF.F_CHECK_FOR_MORE_MAJORS  

AA_DEGREE

ADDITIONAL_MAJORS_IND

This function returns a Y or N indicator that reflects if there are more than 3 distinct occurances of the APRAMAJ record for the specified PIDM and Degree Sequence Number.
AOKODSF.F_DESIGNATION_MULT_CREDIT  

AA_DESIGNATION_GIVING_HISTORY

AMOUNT_MULTIPLE_CREDIT

This function returns a summarized total of the AGRGMLT_CREDIT field for the parameter supplied PIDM, Designation and Fiscal Code. In addition, the cannot be any AGRMGIF record where the AGBGIFT_GIFT_NO field matches the AGRMGIF_EMPR_GIFT_NO field.
AOKODSF.F_GET_ACTIVITY_YEAR_COUNT  

AA_SPECIAL_ACTIVITY

TOTAL_YEARS

This function returns one of three fields based on the specified PIDM and Activity Code. Based on the WHICH_COUNT parameter, the function retrieves and returns either the earliest, the most recent, or the total count of the occurances of the APRACYR record.
AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR  

AA_ANNUAL_GIVING

AA_ANNUAL_GIVING

HIGHEST_GIFT_AMOUNT

HIGHEST_GIFT_AMOUNT_DATE

This function returns either a Gift Amount or a Gift Date based on the specified field, along with the PIDM and Fiscal Code. The function returns either the Highest Gift Amount Highest Gift Amount Date by retrieving the AGBGIFT_AMT_TOT and AGBGIFT_GIFT_DATE fields in descending sequence by the AGBGIFT_AMT_TOT and the AGBGIFT_GIFT_NO fields for the specified PIDM and Fiscal Code. Then, based on the parameter field requested, returns either the Date or the Amount field.
AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR  

AA_ANNUAL_GIVING

HIGHEST_PLEDGE_AMOUNT

This function returns the highest occurance of the AGBPLDG_AMT_PLEDGED field from the AGBPLDG record for the specified PIDM and Fiscal Code by retrieving the record in descending sequence of the AGBPLDG_AMT_PLEDGED field.
AOKODSF.F_GET_INSTALL_PAY Calculating installment paid amount.     AOKODSF.F_GET_INSTALL_PAY(AGRPINS_PIDM, AGRPINS_PLEDGE_NO, AGRPINS_INSTALLMENT_NO, AGRPINS_AMT)
AOKODSF.F_GET_MEMB_AMT_PAID Calculation membership dues amount paid.

AA_MEMBERSHIP

MEMBERSHIP_DUES_AMOUNT_PAID

AOKODSF.F_GET_MEMB_AMT_PAID(AARMEMB_PIDM)
AOKODSF.F_GET_PROJ_ASSIGN_PROS_IND( AMRPROP_PIDM, AMRPROP_PROJ_CODE)  

AA_PROSPECT_PROPOSAL_PROJECT

PROJECT_ASSIGNED_PROSPECT_IND

 
AOKODSF.F_GET_SESSION_NUMBER  

AA_GIFT

POST_CASHIER_SESSION_NUMBER

NA
AOKODSF.F_GET_STAFF_INDICATOR  

AA_PROSPECT_STAFF_ASSIGNMENT

AA_PROSPECT_STAFF_ASSIGNMENT

AA_PROSPECT_STAFF_ASSIGNMENT

AA_PROSPECT_STAFF_ASSIGNMENT

CONTACT_STAFF_IND

PLAN_MANAGER_IND

PROSPECT_STAFF_IND

PROPOSAL_STAFF_IND

 
AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY  

AA_ANNUAL_GIVING

TOTAL_ANT_MATCH_GIFT_ONE_PAY

This function returns a summarized total of the AGBMGID_AMT field for all AGBMGID that match the AGBGIFT and AGRGDES records selected by using the specified PIDM and Fiscal Code fields. In addition, the AGRGDES_PLEDGE_NO field must equal 0000000.
AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY  

AA_ANNUAL_GIVING

TOTAL_ANT_MATCH_GIFT_PAY

This function returns a summarized total of the AGBMGID_AMT field for all AGBMGID records where the field AGBMGID_EMPL_GIFT_NO is in the Gift List view (AGVGLST) for the specified PIDM and Fiscal Code, and where the Pledge Number does not equal 0000000.
AOKODSF.F_GET_TOT_GIVING_YEAR  

AA_ANNUAL_GIVING

TOTAL_GIVING

This function returns a sumarized total of the APRCHIS_AMT_PLEDGED_PAID field added to the summarized total of the APRCHIS_AMT_GIFT FIELD and substracts the total of AGRGMMO_3PP_TOT_AMT for the specified PIDM and Fiscal Code.
AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO  

AA_ANNUAL_GIVING

TOTAL_NON_MATCH_GIFT_MEMO

This function returns a summarized total of the AGRGMMO_CREDIT field for the specified Cross Reference PIDM and the Fiscal Code. In addition, there cannot be any AGRMGIF record existing where the AGRGMMO_GIFT_NO field matches the AGRMGIF_GIFT_NO field.
AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR  

AA_ANNUAL_GIVING

TOTAL_NUMBER_OF_GIFTS

This function returns a count of the number of AGBGIFT records for the assocaited PIDM and Fiscal Code.
AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR  

AA_ANNUAL_GIVING

TOTAL_NUMBER_OF_PLEDGES

This function returns a count of the number of AGBPLDG records for the speficied PIDM and Fiscal Code.
AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR  

AA_ANNUAL_GIVING

TOTAL_PLEDGE_AMOUNT

This function returns a summarized total of the APRCHIS_AMT_PLEDGED field for the specified PIDM and Fiscal Code.
AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR  

AA_ANNUAL_GIVING

TOTAL_PLEDGE_PAYMENTS

This function returns a summarized total of the APRCHIS_AMT_PLEDGED_PAID field for the specified PIDM and Fiscal Code.
AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY  

AA_ANNUAL_GIVING

TOTAL_REAL_MATCH_GIFT_ONE_PAY

This function returns a summarized total of the AGRGMMO_CREDIT field from the column AGVGMEM_CREDIT in the Gift Memo Credit view (AGVGMEM) for the specified Cross Reference PIDM (AGVMEM_PIDM) and Fiscal Code. In addition, a record must exist in the AGRMGIF table where the AGRMGIF_EMPR_GIFT_NO matches the AGVGMEM_GIFT_NO column and there exists a entry in the Gift List view (AGVGLST) for the AGRMGIF_GIFT_NO that does have a value of 0000000 in the column AGVGLST_PLEDGE_NO.
AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY  

AA_ANNUAL_GIVING

TOTAL_REAL_MATCH_GIFT_PAY

This function returns a summarized total of the AGRGMMO_CREDIT field from the column AGVGMEM_CREDIT in the Gift Memo Credit view (AGVGMEM) for the specified Cross Reference PIDM (AGVMEM_PIDM) and Fiscal Code. In addition, a record must exist in the AGRMGIF table where the AGRMGIF_EMPR_GIFT_NO matches the AGVGMEM_GIFT_NO column and there exists a entry in the Gift List view (AGVGLST) for the AGRMGIF_GIFT_NO that does not have a value of 0000000 in the column AGVGLST_PLEDGE_NO.
AOKODSF.F_GET_VOID_IND  

AA_GIFT_ASSOCIATED_ENTITY

GIFT_VOID_IND

NA
AOKODSF.F_GIFT_MATCH_PAID  

AA_GIFT_MATCHING

AA_GIFT_MATCHING

MATCH_GIFT_FULLY_PAID_IND

MATCH_GIFT_PARTIAL_PAID_IND

NA
AOKODSF.F_LIFE_GIFT_SOCIETY  

AA_CONSTITUENT

AA_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

LIFE_GIFT_SOCIETY

LIFE_GIFT_SOCIETY_TYPE

LIFE_GIFT_SOCIETY_TYPE

LIFE_GIFT_SOCIETY

Extracts Gift Society Type or Gift Society from the gift society table (aprdclb) for a given donor.
AOKODSF.F_MATCH_GIFT  

AA_GIFT

AA_GIFT

MATCHING_GIFT_PAYMENT_IND

MATCHING_GIFT_IND

NA
AOKODSF.F_MATCH_GIFT_PAY       NA
AOKODSF.F_PLEDGE_MATCH  

AA_PLEDGE

MATCHING_PLEDGE_IND

NA
ATVCTYP_DESC  

AA_PLEDGE_CONDITIONAL

CONDITION_TYPE_DESC

 
CASE PROGRAM_NUMBER WHEN 1 THEN 'Y' ELSE 'N' END       This function returns a 'Y' if the program number is 1, otherwise it returns an 'N'.
CASE WHEN AMRINFO_SYS_IND  

AA_PROSPECT_INFO

PROSPECT_AMOUNT_METHOD_DESC

 
CASE WHEN DAP_VALUE4        
CASE WHEN EXISTS FTOBDLGT        
CASE WHEN FTVACCT_DATA_ENTRY_IND  

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY

DATA_ENTRY_PERMITTED_DESC

DATA_ENTRY_PERMITTED_DESC

 
CASE WHEN FTVEVND_COLLECT_TAX        
CASE WHEN FTVFUND_DATA_ENTRY_IND  

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

DATA_ENTRY_PERMITTED_DESC

DATA_ENTRY_PERMITTED_DESC

 
CASE WHEN FTVORGN_DATA_ENTRY_IND  

AF_ORGANIZATION_HIERARCHY

AF_ORGN_HIERARCHY_FISCAL

DATA_ENTRY_PERMITTED_DESC

DATA_ENTRY_PERMITTED_DESC

 
CASE WHEN FTVPROG_DATA_ENTRY_IND  

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY_FISCAL

DATA_ENTRY_PERMITTED_DESC

DATA_ENTRY_PERMITTED_DESC

 
CASE WHEN FTVVEND_CARRIER_IND        
CASE WHEN FTVVEND_GROUPING_IND        
CASE WHEN FTVVEND_IN_ST_IND        
CASE WHEN PROPOSAL_RESULT_PLEDGE_NUMBER        
CASE WHEN REGISTERED_IND = 1 OR WITHDRAWN_IND = 1 THEN NULL ELSE PERSON_UID        
CASE WHEN SSRMEET_OVER_RIDE        
CASE WHEN STUDENT_COURSE_REC.IN_PROGRESS_COURSE_IN D = 1 THEN RET_ROW.COURSE_INTREGISTERED_HEADCOUNT := STUDENT_COURSE_REC.WAREHOUSE_ENTITY_UID; WHEN STUDENT_COURSE_REC.INSTITUTION_COURSE_IN D = 1 THEN RET_ROW.COURSE_INTREGISTERED_HEADCOUNT := ST        
CASE WHEN STUDENT_COURSE_REC.COURSE_REGISTER_IND ='Y' THEN        
COUNT OF WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UI D WHERE THAT PERSON HAS A RECORD IN MST_ENROLLMENT AND MST_ACADEMIC_OUTCOME JOIN PERSON_UID AND ACADEMIC_YEAR ( ACADEMIC_YEAR_GRADUATION)       SELECT COUNT(*) FROM MST_ENROLLMENT WHERE PERSON_UID = MST_ACADEMIC_OUTCOME.PERSON_UID AND ACADEMIC_YEAR = MST_ACADEMIC_OUTCOME.ACADEMIC_YEAR_GRADUATION
DECODE((SELECT COUNT (*) FROM MST_FACULTY_FEEDBACK_DETAIL FD WHERE FD.PERSON_UID = F.PERSON_UID AND FD.ACADEMIC_PERIOD = F.ACADEMIC_PERIOD AND FD.COURSE_REFERENCE_NUMBER = F.COURSE_REFERENCE_NUMBER),0, 'N','Y')        
DECODE(AGRGAUX_GIFT_ADJ_VOID_IND,'A', 'Y','N')  

AA_GIFT_AUXILIARY

GIFT_ADJUSTMENT_IND

NA
DECODE(AGRGAUX_GIFT_ADJ_VOID_IND,'V', 'Y','N')  

AA_GIFT_AUXILIARY

GIFT_VOID_IND

NA
DECODE(ATVPCAT_COND_IND)  

AA_PLEDGE

PLEDGE_CONDITIONAL_IND

 
DECODE(DSS.ACAD_HISTORY_EXISTS_IND,1, S.PERSON_UID, NULL        
DECODE(DSS.COOP_ED_PARTICIPANT_IND,1, S.PERSON_UID,NULL)        
DECODE(DSS.GRADUATE_CREDIT_ELIG_IND,1, S.PERSON_UID,NULL)        
DECODE(FRBEVNG_PMT_METHOD_TYPE_IND)        
DECODE(GOKODSF.F_GET_DESC)  

AS_ADMISSIONS_DECISION

DECISION_SOURCE

DECODE(SUBSTR(GOKODSF.F_GET_DESC(SARAPPD_APDC_CODE,'STVAPDC','STVTERM_STDN_ACC_IND'),1,1),'Y','Applicant','Institution')
DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_S        
DECODE(SARCHKL_RECEIVE_DATE)       Determines if the admissions requirement was completed by the presence of the receive date.
DECODE(SHRATTR_PIDM)  

AS_STUDENT_COURSE_ATTRIBUTE

AS_STUDENT_COURSE_ATTRIBUTE

TRANSFER_COURSE_IND

INSTITUTION_COURSE_IND

 
DECODE(SHRTCKN_PIDM)  

AS_STUDENT_COURSE_ATTRIBUTE

AS_STUDENT_COURSE_ATTRIBUTE

TRANSFER_COURSE_IND

INSTITUTION_COURSE_IND

 
DECODE(SOKODSF.F_GET_SORMAJR_DATA)        
DECODE(SORDEGR_HONR_CODE, NULL, 0, 1),        
DECODE(SORLCUR_TERM_CODE_MATRIC,NULL, 'N','Y')  

AS_LEARNER_CURRICULUM_FOS

MATRICULATED_IND

NA
DECODE(STVDEGS_AWARD_STATUS_IND,'A','Y', 'N')  

AS_ACADEMIC_OUTCOME

GRADUATED_IND

Determines if the student graduated by checking the degree award status. If the status is awarded, then the student has graduated.
DECODE(STVRESD_IN_STATE_IND)  

AS_GENERAL_STUDENT

RESIDENCY_IND

Determines if the student is a resident by checking the residency state indicator.
DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR2_RET_EXCLUDE_HEADCOUNT        
DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR3_RET_EXCLUDE_HEADCOUNT        
DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR4_GRAD_EXCLUDE_HEADCOUNT,        
DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR4_RET_EXCLUDE_HEADCOUNT        
DECODE(YEAR4_GRADUATION_IND,1,PERSON_IN, NULL) YEAR4_GRADUATION_HEADCOUNT,        
DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR5_GRAD_EXCLUDE_HEADCOUNT,        
DECODE(YEAR5_GRADUATION_IND,1,PERSON_IN, NULL) YEAR5_GRADUATION_HEADCOUNT,        
DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_GRAD_EXCLUDE_HEADCOUNT,        
DECODE(YEAR6_GRADUATION_IND,1,PERSON_IN, NULL) YEAR6_GRADUATION_HEADCOUNT,        
DOKODSF.F_GET_PLAN_CMNT_EXST_IND        
DOKODSF.F_GET_SHP_SETTINGS_TEXT        
FBKBUDG.F_GETLOCKSTATUS  

AF_BUDGET_DETAIL

ORGANIZATION_LOCK_STATUS

This function returns the lock status of a budget from FBBLOCK for a specified chart of accounts, budget identifier, budget phase and organization code.
FOFYCNV  

AF_INVOICE_ACCOUNTING

AF_OPERATING_LEDGER

AF_PROGRAM_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_FIXED_ASSET_ADJUSTMENT

AF_GENERAL_LEDGER

AF_PROPOSAL

AF_PURCHASE_ORDER_ACCOUNTING

AF_FUND_HIERARCHY_FISCAL

AF_GRANT

AF_GRANT_LEDGER

AF_BUDGET_DETAIL

AF_LOCATION_HIERARCHY_FISCAL

AF_BUDGET_AVAILABILITY_LEDGER

AF_ORGN_HIERARCHY_FISCAL

AF_PROPOSAL

AF_PROPOSAL

AF_PROPOSAL

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_LEDGER

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

SUBMISSION_FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

STATUS_FISCAL_YEAR

GRANT_YEAR

BUDGET_YEAR

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

ORIGINATION_FISCAL_YEAR

AWARD_FISCAL_YEAR

DECLINE_FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

NA
FOFYCNV(FTVFSPD_FSYR_CODE)  

AF_FISCAL_PERIOD

FISCAL_YEAR

 
FOKODSF.F_AGCY_HIER  

AF_GRANT

AF_GRANT

AF_GRANT

AF_GRANT

AF_PROPOSAL

AF_PROPOSAL

AF_PROPOSAL

AF_PROPOSAL

AGENCY_UID_LEVEL_2

AGENCY_UID_LEVEL_1

AGENCY_UID_LEVEL_3

AGENCY_UID_LEVEL_4

AGENCY_UID_LEVEL_2

AGENCY_UID_LEVEL_3

AGENCY_UID_LEVEL_1

AGENCY_UID_LEVEL_4

 
FOKODSF.F_CALC_BLANKET_ORDER_BAL  

AF_PURCHASE_ORDER

TOTAL_BLANKET_ORDER_BAL

This function returns the sum of the FPRPODT_BO_REMAIN_BAL from FPRPODT for the specified purchase order and change sequence number.
FOKODSF.F_CALC_GL_ACTIVITY  

AF_GENERAL_LEDGER

AF_GENERAL_LEDGER

BEGINNING_BALANCE

ENDING_BALANCE

This function returns the periodic debits and periodic credits as well as the year to date debits and the year to date credits from FGBGENL for the specified chart of accounts, fiscal year, fiscal period, fund and account.
FOKODSF.F_CALC_TOT_APPROV_ITEM_AMT  

AF_PURCHASE_ORDER

TOTAL_APPROVED_ITEM_AMOUNT

This function returns the total approved item amount from FPRPODT for the specified purchase order and change sequence number. Total approved item amount is calculated as the sum of the following: (FPRPODT_UNIT_PRICE * FPRPODT_QTY ) + FPRPODT_TAX_AMT + FPRPODT_ADDL_CHRG_AMT - FPRPODT_DISC_AMT.
FOKODSF.F_CALC_TOT_CONVERT_ITEM_AMT  

AF_PURCHASE_ORDER

TOTAL_CONVERTED_AMOUNT

This function returns the total converted item amount from FPRPODT for the specified purchase order and change sequence number. Total converted item amount is calculated as the sum of the following: FPRPODT_CONVERT_UNIT_PRICE * FPRPODT_QTY ) + FPRPODT_CONVERT_TAX_AMT + FPRPODT_CONVERT_ADDL_CHRG_AMT - FPRPODT_CONVERT_DISC_AMT.
FOKODSF.F_CAPITALIZED_AMT  

AF_FIXED_ASSET_ITEM

ORIGINAL_CAPITALIZED_AMOUNT

This function returns the sum of the FFRMASA_AMT from FFRMASA where the FFRMASA_OTAG_CODE matches the specified asset for the latest FFRMASA_CHANGE_SEQ_NUM and the FFRMASA_OTAG_CODE_ATTACHMENT is NULL.
FOKODSF.F_CONCAT_OP_AMTS  

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

CURRENT_ADOPTED_BUDGET

CURRENT_BUDGET

PRIOR_YTD_ACTIVITY

CURRENT_BUDGET_ADJUSTMENTS

CURRENT_YTD_ACTIVITY

This function is used to return the operating ledger amounts from FGBOPAL for a given fiscal year, period, FOAPAL, and commitment type combination. The data is concatenated together and separated by the character {.
FOKODSF.F_COST_AMT  

AF_FIXED_ASSET_ITEM

ORIGINAL_COST_AMOUNT

This function will return the original cost of the asset excluding attachment costs. It will atempt to retrieve the amount from FFRMASF for a the specified asset. If it does not exist in FFRMASF, it will then retrieve the amount from FFRMASA for the specified asset and latest change sequence number.
FOKODSF.F_GET_ACCT_HIER   R RARCHY

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY_FISCAL

s size="2">ACCOUNT_LEVEL_3

ACCOUNT_LEVEL_4

ACCOUNT_STATUS_4

ACCOUNT_LEVEL_2

ACCOUNT_DESC_4

ACCOUNT_LEVEL_1

ACCOUNT_LEVEL_3

ACCOUNT_STATUS_1

ACCOUNT_DESC_2

ACCOUNT_STATUS_1

ACCOUNT_DESC_1

ACCOUNT_DESC_3

ACCOUNT_STATUS_3

ACCOUNT_STATUS_4

 
FOKODSF.F_GET_BVL_AMTS  

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

SUM_REMAINING_BALANCE

CURR_ENCUMBRANCES

CURR_PERCENT_AVAILABLE

CURR_REMAINING_BALANCE

CURR_BUDGET_RESERVATION

SUM_BUDGET_RESERVATION

SUM_ENCUMBRANCES

CURR_BUDGET_ADJUSTMENTS

SUM_BUDGET_ADJUSTMENTS

SUM_ADOPTED_BUDGET

SUM_YEAR_TO_DATE_ACTV

CURR_ADOPTED_BUDGET

CURR_YEAR_TO_DATE_ACTV

SUM_PERCENT_AVAILABLE

Extracts each of the budget availability amounts for the current period and totals each amount for the as of period.
FOKODSF.F_GET_FINANCE_DESC  

AF_PURCHASE_ORDER

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AE_ACCOUNTING

AE_ACCOUNTING

AE_ACCOUNTING

AF_PURCHASE_ORDER

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AN_PAYROLL_DISTRIBUTION

AF_GRANT_DEFERRED_COST

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AF_FIXED_ASSET_FUNDING_SOURCE

AF_PURCHASE_ORDER_ACCOUNTING

AP_EMPLOYEE

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

PROJECT_DESC

ACCOUNT_INDEX_DESC

CHART_OF_ACCOUNTS_DESC

PROJECT_DESC

ORGANIZATION_DESC

LOCATION_DESC

PROGRAM_DESC

PROJECT_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

FUND_DESC

PROJECT_CODE_DESC

ACTIVITY_DESC

HOME_ORGANIZATION_CHART_DESC

ACCOUNT_INDEX_DESC

ORGANIZATION_DESC

 
FOKODSF.F_GET_FINANCE_STATUS  

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AF_GRANT_DEFERRED_COST

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

ACCOUNT_STATUS

PROGRAM_STATUS

ORGANIZATION_STATUS

ACCOUNT_INDEX_STATUS

LOCATION_STATUS

FUND_STATUS

CHART_OF_ACCOUNTS_STATUS

ACTIVITY_STATUS

CHART_OF_ACCOUNTS_STATUS

 
FOKODSF.F_GET_FTVCRSN_DESC  

AF_PURCHASE_ORDER

CANCEL_REASON_DESC

This function returns the description of the cancellation based upon a specified cancellation code and cancel date.
FOKODSF.F_GET_FUND_HIER  

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY_FISCAL

FUND_STATUS_2

FUND_STATUS_4

FUND_STATUS_5

FUND_DESC_1

FUND_DESC_4

FUND_LEVEL_1

FUND_LEVEL_3

FUND_LEVEL_4

FUND_STATUS_4

FUND_DESC_5

FUND_STATUS_1

FUND_STATUS_2

FUND_LEVEL_5

FUND_LEVEL_1

FUND_LEVEL_3

FUND_LEVEL_4

FUND_STATUS_5

FUND_LEVEL_5

FUND_STATUS_3

FUND_DESC_1

FUND_DESC_2

FUND_DESC_4

FUND_DESC_2

FUND_LEVEL_2

FUND_DESC_3

FUND_DESC_5

FUND_LEVEL_2

FUND_DESC_3

FUND_STATUS_1

FUND_STATUS_3

Extracts the finance fund or fund description, fund status and fund level for each level of the fund hierarchy for a given chart of accounts and fund code.
FOKODSF.F_GET_LOCN_HIER  

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY

AF_LOCATION_HIERARCHY_FISCAL

LOCATION_DESC_2

LOCATION_DESC_5

LOCATION_STATUS_4

LOCATION_DESC_5

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_LEVEL_3

LOCATION_STATUS_3

LOCATION_LEVEL_5

LOCATION_STATUS_5

LOCATION_STATUS_2

LOCATION_LEVEL_4

LOCATION_STATUS_1

LOCATION_STATUS_5

LOCATION_DESC_1

LOCATION_DESC_3

LOCATION_LEVEL_5

LOCATION_DESC_1

LOCATION_LEVEL_2

LOCATION_LEVEL_3

LOCATION_LEVEL_1

LOCATION_LEVEL_2

LOCATION_DESC_3

LOCATION_DESC_4

LOCATION_DESC_4

LOCATION_DESC_2

LOCATION_LEVEL_1

LOCATION_LEVEL_4

LOCATION_STATUS_1

LOCATION_STATUS_2

Extracts the finance location or location description, location status and location level for each level of the location hierarchy for a given chart of accounts and location code.
FOKODSF.F_GET_MIN_QUANTITY  

AF_PURCHASE_ORDER_ITEM

AGREEMENT_MINIMUM_QUANTITY

 
FOKODSF.F_GET_ORGN_HIER   > >

AF_ORGANIZATION_HIERARCHY

AF_ORGANIZATION_HIERARCHY

AF_ORGANIZATION_HIERARCHY

AF_ORGANIZATION_HIERARCHY

AF_ORGN_HIERARCHY_FISCAL

AF_ORGANIZATION_HIERARCHY

AF_ORGANIZATION_HIERARCHY

AF_ORGANIZATION_HIERARCHY

AF_ORGANIZATION_HIERARCHY

AF_ORGN_HIERARCHY_FISCAL

AF_ORGN_HIERARCHY_FISCAL

AF_ORGN_HIERARCHY_FISCAL

E ERARCHY_COMP_target.html#ORGANIZATION_LEVEL_4">ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_5

ORGANIZATION_STATUS_2

ORGANIZATION_LEVEL_5

ORGANIZATION_DESC_1

ORGANIZATION_DESC_4

ORGANIZATION_DESC_6

ORGANIZATION_STATUS_8

ORGANIZATION_LEVEL_4

ORGANIZATION_DESC_3

ORGANIZATION_LEVEL_6

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_3

ORGANIZATION_STATUS_2

ORGANIZATION_STATUS_7

ORGANIZATION_STATUS_8

Extracts the finance organization or organization description, organization status and organization level for each level of the organization hierarchy for a given chart of accounts and organization code.
FOKODSF.F_GET_PROG_HIER  

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY_FISCAL

AF_PROGRAM_HIERARCHY_FISCAL

PROGRAM_STATUS_1

PROGRAM_STATUS_2

PROGRAM_LEVEL_3

PROGRAM_STATUS_5

PROGRAM_DESC_3

PROGRAM_STATUS_1

PROGRAM_STATUS_2

PROGRAM_DESC_1

PROGRAM_DESC_2

PROGRAM_DESC_3

PROGRAM_DESC_4

PROGRAM_LEVEL_3

PROGRAM_LEVEL_5

PROGRAM_LEVEL_2

PROGRAM_LEVEL_4

PROGRAM_LEVEL_1

PROGRAM_STATUS_4

PROGRAM_STATUS_5

PROGRAM_LEVEL_1

PROGRAM_LEVEL_5

PROGRAM_LEVEL_4

PROGRAM_DESC_4

PROGRAM_DESC_5

PROGRAM_DESC_1

PROGRAM_DESC_2

PROGRAM_STATUS_3

PROGRAM_STATUS_4

PROGRAM_DESC_5

PROGRAM_LEVEL_2

PROGRAM_STATUS_3

Extracts the finance program or program description, program status and program level for each level of the program hierarchy for a given chart of accounts and program code.
FOKODSF.F_GET_REST_IND  

AF_FUND_HIERARCHY_FISCAL

AF_FUND_HIERARCHY

FUND_BALANCE_RESTRICTION

FUND_BALANCE_RESTRICTION

 
FOKODSF.F_GET_SDAT_TITLE  

AF_ACCOUNT_HIERARCHY_FISCAL

AF_GRANT_BILLING_DETAIL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_FIXED_ASSET_ITEM

AF_FUND_HIERARCHY_FISCAL

AF_GRANT

AF_ACCOUNT_HIERARCHY

AF_FIXED_ASSET_ITEM

AF_GRANT

AF_PROPOSAL

AF_ACCOUNT_HIERARCHY

AF_FUND_HIERARCHY

AF_GRANT_PERSONNEL

AF_TRANSACTION_HISTORY

AF_ACCOUNT_HIERARCHY

AF_ENDOWMENT

AF_GRANT_LEDGER

AF_ACCOUNT_HIERARCHY

AF_GRANT

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_GRANT

AF_ACCOUNT_HIERARCHY

ACCOUNT_CLASS_DESC

ACCOUNT_CLASS_DESC

INTERNAL_ACCOUNT_TYPE_DESC

ASSET_STATUS_DESC

INTERNAL_FUND_TYPE_DESC

STATUS_DESC

INTERNAL_ACCOUNT_TYPE_DESC

USER_STATUS_DESC

SUBCATEGORY_DESC

PROPOSAL_TYPE_DESC

CTRL_ACTUAL_ACTIVITY_SEQ_DESC

INTERNAL_FUND_TYPE_DESC

PERSONNEL_TYPE_DESC

DETAIL_POSTING_PROCESS_DESC

CTRL_ADOPTED_BUDGET_SEQ_DESC

ENDOWMENT_TYPE_DESC

ACCOUNT_CLASS_DESC

CTRL_ENCUMBRANCE_SEQ_DESC

CATEGORY_DESC

CTRL_BUDGET_ADJUST_SEQ_DESC

CTRL_BUDGET_RESERVE_SEQ_DESC

CTRL_TEMPORARY_BUDGET_SEQ_DESC

GRANT_TYPE_DESC

ACCOUNT_CLASS_DESC

NA
FOKODSF.F_GET_SPONSOR_ACCT  

AF_GRANT_LEDGER

SPONSOR_ACCOUNT

Extracts the granting agency sponsor's equivalent account for a given grant.
FOKODSF.F_GRANT_TO_FISCAL_YEAR  

AF_GRANT_LEDGER

AF_GRANT_LEDGER

FISCAL_YEAR

FISCAL_PERIOD

This function will return the fiscal year and fiscal period concatenated for a specified grant id, chart of accounts, grant year and grant period.
FOKODSF.F_INV_TOT_APPROV_ITEM_AMT  

AF_INVOICE

TOTAL_APPROVED_ITEM_AMOUNT

This function returns the total approved item amount for a specified invoice code. Total approved item amount is calculated as FARINVA_APPR_AMT + FARINVA_TAX_AMT+ FARINVA_ADDL_CHRG_AMT - FARINVA_DISC_AMOUNT from FARINVA minus any FARINTX_REBATE_AMT from FARINTX.
FOKODSF.F_INV_TOT_CONVERT_ITEM_AMT  

AF_INVOICE

TOTAL_CONVERTED_AMOUNT

This function returns the total converted item amount for a specified invoice code. Total converted item amount is calculated as FARINVA_CONVERT_AMT + FARINVA_CONVERT_TAX_AMT+ FARINVA_CONVERT_ADDL_CHRG_AMT - FARINVA_CONVERT_DISC_AMOUNT from FARINVA minus any FARINTX_CONVERT_REBATE_AMT from FARINTX.
FOKODSF.F_NET_BOOK_AMT  

AF_FIXED_ASSET_ITEM

NET_BOOK_VALUE_AMOUNT

This function will return the net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the latest change sequence number of the specified asset not including attachment costs.
FOKODSF.F_PO_DISC_PCT  

AF_PURCHASE_ORDER_ITEM

DISCOUNT_PERCENT

This function returns the discount percentage for a discount code associated with a specified purchase order.
FOKODSF.F_PO_ITEM_LAST_CHANGE_SEQNO  

AF_PURCHASE_ORDER_ITEM

ITEM_CHANGE_ORDER

 
FOKODSF.F_PO_LAST_CHANGE_DATE  

AF_PURCHASE_ORDER

PO_CHANGE_DATE

NA
FOKODSF.F_PO_LAST_CHANGE_SEQNO  

AF_PURCHASE_ORDER

PO_CHANGE_ORDER

NA
FOKODSF.F_REMAINING_LIFE  

AF_FIXED_ASSET_ITEM

AF_FIXED_ASSET_ITEM

AF_FIXED_ASSET_ITEM

AF_FIXED_ASSET_ITEM

REMAINING_LIFE_YEARS

REMAINING_LIFE_QUARTERS

REMAINING_LIFE_MONTHS

REMAINING_LIFE_SEMI_ANNUAL

This function will return the remaining life based on the depreciation frequency (Quarterly, Semi-Annually, or Yearly).
FOKODSF.F_TOTAL_BOOK_AMT  

AF_FIXED_ASSET_ITEM

TOTAL_NET_BOOK_VALUE_AMOUNT

This function will return the net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the latest change sequence number of the specified asset including attachment costs.
FOKODSF.F_TOTAL_COST_AMT  

AF_FIXED_ASSET_ITEM

TOTAL_ORIGINAL_COST_AMOUNT

This function will return the original cost of the asset including attachment costs. It will atempt to retrieve the amount from FFRMASF for a the specified asset. If it does not exist in FFRMASF, it will then retrieve the amount from FFRMASA for the specified asset and latest change sequence number.
FRKIDEN.F_GET_FRBGRNT_STATUS_CODE  

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

GRANT_STATUS

GRANT_STATUS

This function retrieves the FRBGRNT_STATUS_CODE from FRBGRNT for a specified grant.
FRKIDEN.F_GET_FRBGRNT_TITLE  

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY_FISCAL

GRANT_DESC

GRANT_DESC

This function retrieves the FRBGRNT_TITLE from FRBGRNT for a specified grant.
FRKIDEN.F_GET_SPRIDEN_ENTITY_IND       This function retrieves the SPRIDEN_ENTITY_IND from SPRIDEN for a specified entity.
FRKIDEN.F_GET_SPRIDEN_LAST_NAME  

AF_INVOICE_ACCOUNTING

BANK_DESC

This function retrieves the SPRIDEN_LAST_NAME from SPRIDEN for a specified entity.
FTVORGN_FMGR_CODE_PIDM        
F_ACTIVE_COURSE_IND  

AS_COURSE_CATALOG

ACTIVE_COURSE_IND

This function retrieves the column STVCSTA_ACTIVE_IND from STVCSTA for a specified course status code. It then queries the GTVSDAX table to determine whether it matches the rule where the GTVSDAX_INTERNAL_CODE = ACTIVE, and the GTVSDAX_INTERNAL_CODE_GROUP = COURSE STATUS.
F_ACTIVE_SECTION_IND  

AS_COURSE_OFFERING

ACTIVE_OFFERING_IND

This function retrieves the column STVSSTS_ACTIVE_IND from STVSSTS for a specified section status code. It then queries the GTVSDAX table to determine whether it matches the rule where the GTVSDAX_INTERNAL_CODE = ACTIVE, and the GTVSDAX_INTERNAL_CODE_GROUP = SECTION STATUS.
F_ADMS_APPLICANT_WITHDRAWN  

AS_ADMISSIONS_APPLICATION

APPLICANT_WITHDRAWN_IND

This function returns a Y if a record exists in the SARADAP table for the specified person, academic period, and application number where the withdrawal reason is not NULL.
F_ADMS_APPLICATION_STATUS  

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

COMPLETE_IND

INCOMPLETE_IND

This function retrieves the application status from SARADAP for a specified combination of person, academic period, and application number. It then determines whether the application status matches the defined rule within GTVSDAX with the GTVSDAX_INTERNAL_CODE_GROUP = APPLICATION STATUS and a GTVSDAX_INTERNAL_CODE matching the specified status and returns a Y if found. The two possible statuses that can be passed are APPLCMPL for a status of complete and APPLINCM for a status for incomplete.
F_AGCY_HIER       This function takes a specified agency pidm and level as input and returns the agency pidm that exists at the specified level within the hierarchy for the specified agency.
F_APPLIED_FOR_DEGREE  

AS_ACADEMIC_OUTCOME

APPLIED_FOR_OUTCOME_IND

This function evaluates the SHRDGMR and STVDEGS tables to determine if the degree status code associated with the specified individual has a STVDEGS_AWARD_STATUS_IND = P. If it does, then the function returns a Y. Otherwise, an N is returned.
F_CALCULATE_AGE       This function calculates age for a specified as of date, birth date, admit academic period start date and date of death. The age is not calculated beyond any specified, not null, deceased date.
F_CALC_REGISTRATION_HOURS  

AS_ENROLLMENT

AS_ENROLLMENT

AS_ENROLLMENT

AS_ENROLLMENT

AS_ENROLLMENT

AS_ENROLLMENT

TOTAL_CEU_BILLING

TOTAL_CEU_CREDITS

TOTAL_NON_CEU_CREDITS

TOTAL_BILLING

TOTAL_CREDITS

TOTAL_NON_CEU_BILLING

This function will summarize credit or billing hours (CREDIT or BILL) for either total, ceu, or non ceu courses (TOTAL, CEU, or NONCEU) by either a specified academic period or combination of entity and academic period.
F_CALC_TOTAL_BUDGET  

AR_FINAID_BUDGET_COMPONENT

AR_FINAID_BUDGET_COMPONENT

TOTAL_BUDGET

TOTAL_BUDGET

 
F_CALC_TOTAL_OFFER  

AR_APPLICANT_NEED

TOTAL_OFFER_AMOUNT

This function returns the total offer amount from RPRAWRD for a specified entity and aid year.
F_CAMPAIGN_GIVING  

AA_CAMPAIGN_GIVING_HISTORY

CAMPAIGN_GIVING

This function adds the APRCHIS_AMT_PLEDGED_PAID and APRCHIS_AMT_GIFT in APRCHIS and substracts the total of AGRGMMO_3PP_TOT_AMT for the specified entity, fiscal year and campaign.
F_CAMPAIGN_MATCHING_GIFT  

AA_CAMPAIGN_GIVING_HISTORY

AMOUNT_MATCHING_GIFT

This function returns the summarized AGRMMO_CREDIT for all matching gifts for the specified entity, fiscal year and campaign.
F_CAMPAIGN_MEMO_CREDIT  

AA_CAMPAIGN_GIVING_HISTORY

AMOUNT_MEMO_CREDIT

This function returns the summarized AGRMMO_CREDIT for all non-matching gifts for the specified entity, fiscal year and campaign.
F_CHECK_FOR_COURSE_PREREQS       This function returns the course pre-requisite indicator from SCRRTST for the specified subject, course, effective academic period, and pre-requisite type.
F_CHECK_FOR_TRANSFER_WORK  

AS_ACADEMIC_OUTCOME

TRANSFER_WORK_EXISTS_IND

This function returns a Y if a record is found in the SHRTRIT table for the specified entity.
F_CLASS_CALC_FNC       This function returns the class code based upon the hours earned for a specified combination of entity, student level, and academic period.
F_DESIGNATION_GIVING  

AA_DESIGNATION_GIVING_HISTORY

DESIGNATION_GIVING

This function returns the APRDHIS_AMT_PLEDGED_PAID added to the APRDHIS_AMT_GIFT and substracts the total of AGRGMMO_3PP_TOT_AMT for the specified combination of entity, fiscal year, and designation.
F_DESIGNATION_MATCHING_GIFT  

AA_DESIGNATION_GIVING_HISTORY

AMOUNT_MATCHING_GIFT

This function returns the summarized AGRMMO_CREDIT for all matching gifts for the specified entity, fiscal year and designation.
F_DESIGNATION_MEMO_CREDIT  

AA_DESIGNATION_GIVING_HISTORY

AMOUNT_MEMO_CREDIT

This function returns the summarized AGRMMO_CREDIT for all non-matching gifts for the specified entity, fiscal year and designation.
F_DISPOSITION_IND  

AP_HR_APPLICATION

STATUS_DISPOSITION

This function selects disposition indicator from the applicant status rule table (PTRAPPS) based on the specified entity, requisition number, position, position class, and application date.
F_DONOR_IND  

AA_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

DONOR_IND

DONOR_IND

This function retrieves a 'Y' for a person passed if a record exists in the gift history table.
F_ENROLLED_THIS_TERM  

AS_ENROLLMENT

ENROLLED_IND

This function retrieves the enrollment status code for a person and academic period passed. If no records exists, an 'N' is returned.
F_EPSCCODE  

AS_ADDRESS

AS_INSTITUTION

ENRL_PLANNING_SERVICE

EPS_CODE

This function retrieves the enrollment planning sevices code for an address.
F_FACULTY_ADVISING_IND       This function retrieves a 'Y' or 'N' based on the person and academic period that is passed. If a record exists in the advisor table then a 'Y' is returned. Otherwise, an 'N' is returned.
F_FACULTY_SCHEDULED_IND       This function retrieves a 'Y' or 'N' based on the person and academic period that is passed. If a record exists in the instructional assignment table then a 'Y' is returned. Otherwise, an 'N' is returned.
F_FINAID_APPLICANT_IND  

AR_FINAID_APPLICANT_STATUS

FINAID_APPLICANT_IND

This function retrieves a 'Y' or 'N' based on the person and aid year that is passed. If a record exists in the applicant status table then a 'Y' is returned. Otherwise, an 'N' is returned.
F_FORMAT_MAILING_ADDRESS       This function retrieves the formatted mailing address based on the person, address type, sequence number, status indicator and specified code tpye of either 'US' or 'OTHER'.
F_FORMAT_NAME  

AP_INTERVIEW

AS_FACULTY_FEEDBACK

AT_ACCOUNT

AS_PERSON

AS_PERSON

AS_FACULTY_FEEDBACK

INTERVIEWER_NAME

NAME

NAME

FULL_NAME_FMIL

FULL_NAME_LFMI

INSTRUCTOR_NAME

This function returns an entity's name based upon a specified pidm and name type. The possible name types are as follows: (LF30) Last name, first name for 30 characters; (L30) Last name for 30 characters; (FL30) First name, last name for 30 characters; (FL) Last name, first name; (FMIL) First name, middle initial, last name; (FML) First name, middle name, last name; (LFMI) Last name, first name, middle initial.
F_GET_CIPC_DESC  

AR_AWARD_DISBURSEMENT

PROGRAM_CLASSIFICATION_DESC

 
F_GET_DATE_PREV_EDUCATION        
F_GET_FINANCE_DESC   l l">AF_FIXED_ASSET_FUNDING_SOURCE

AF_GENERAL_LEDGER

AF_GRANT

AF_GRANT_BILLING_DETAIL

AF_GRANT_LEDGER

AF_INVOICE_ACCOUNTING

AT_GRANT_ACCOUNT_DETAIL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_UNITS

AF_ENDOWMENT_UNITS

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_ITEM

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_GRANT_BILLING_DETAIL

AF_OPERATING_LEDGER

AF_TRANSACTION_HISTORY

AF_ACCOUNT_INDEX

AF_ACCOUNT_INDEX

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_DIST

AF_FIXED_ASSET_FUNDING_SOURCE

AF_GRANT_BILLING_DETAIL

AF_GRANT_FUND

AF_GRANT_LEDGER

AF_FIXED_ASSET_FUNDING_SOURCE

AF_GENERAL_LEDGER

AF_GRANT

AF_GRANT_BILLING_DETAIL

AF_GRANT_LEDGER

AF_INVOICE_ACCOUNTING

AT_GRANT_ACCOUNT_DETAIL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_UNITS

AF_ENDOWMENT_UNITS

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_ITEM

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_GRANT_BILLING_DETAIL

AF_OPERATING_LEDGER

AF_TRANSACTION_HISTORY

AF_ACCOUNT_INDEX

AF_ACCOUNT_INDEX

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_DIST

AF_FIXED_ASSET_FUNDING_SOURCE

AF_GRANT_BILLING_DETAIL

AF_GRANT_FUND

AF_GRANT_LEDGER

AF_INVOICE_ACCOUNTING

AF_INVOICE_ACCOUNTING

AF_ORGANIZATION_HIERARCHY

AF_ACCOUNT_INDEX

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_FISCAL_PERIOD

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_DEPRECIATION

AF_FUND_HIERARCHY_FISCAL

AF_GENERAL_LEDGER

AF_GRANT

AF_GRANT_BILLING_DETAIL

AF_OPERATING_LEDGER

AF_OPERATING_LEDGER

AF_PROGRAM_HIERARCHY_FISCAL

AF_TRANSACTION_HISTORY

AP_EMPLOYEE

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_INDEX

AF_ACCOUNT_INDEX

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_FIXED_ASSET_ADJUSTMENT

AF_FIXED_ASSET_FUNDING_SOURCE

AF_FUND_HIERARCHY_FISCAL

AF_GENERAL_LEDGER

AF_GRANT_BILLING_DETAIL

AF_GRANT l">AF_FIXED_ASSET_FUNDING_SOURCE

AF_GENERAL_LEDGER

AF_GRANT

AF_GRANT_BILLING_DETAIL

AF_GRANT_LEDGER

AF_INVOICE_ACCOUNTING

AT_GRANT_ACCOUNT_DETAIL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_UNITS

AF_ENDOWMENT_UNITS

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_ITEM

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_GRANT_BILLING_DETAIL

AF_OPERATING_LEDGER

AF_TRANSACTION_HISTORY

AF_ACCOUNT_INDEX

AF_ACCOUNT_INDEX

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_DIST

AF_FIXED_ASSET_FUNDING_SOURCE

AF_GRANT_BILLING_DETAIL

AF_GRANT_FUND

AF_GRANT_LEDGER

AF_INVOICE_ACCOUNTING

AF_INVOICE_ACCOUNTING

AF_ORGANIZATION_HIERARCHY

AF_ACCOUNT_INDEX

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_FISCAL_PERIOD

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_DEPRECIATION

AF_FUND_HIERARCHY_FISCAL

AF_GENERAL_LEDGER

AF_GRANT

AF_GRANT_BILLING_DETAIL

AF_OPERATING_LEDGER

AF_OPERATING_LEDGER

AF_PROGRAM_HIERARCHY_FISCAL

AF_TRANSACTION_HISTORY

AP_EMPLOYEE

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_INDEX

AF_ACCOUNT_INDEX

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_FIXED_ASSET_ADJUSTMENT

AF_FIXED_ASSET_FUNDING_SOURCE

AF_FUND_HIERARCHY_FISCAL

AF_GENERAL_LEDGER

AF_GRANT_BILLING_DETAIL

AF_GRANT_BILLING_DETAIL

AF_GRANT_FUND

AF_GRANT_FUND

AF_GRANT_FUND

AF_ORGANIZATION_HIERARCHY

AF_ACCOUNT_INDEX

AF_BUDGET_DETAIL

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_ATTRIBUTES

AF_ENDOWMENT_UNITS

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_FUNDING_SOURCE

AF_FIXED_ASSET_ITEM

AF_GRANT

AF_GRANT_LEDGER

AF_GRANT_LEDGER

AF_INVOICE_ACCOUNTING

AF_INVOICE_ACCOUNTING

AF_LOCATION_HIERARCHY_FISCAL

AF_OPERATING_LEDGER

AF_ORGN_HIERARCHY_FISCAL

AF_PROPOSAL

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENTAF_FIXED_ASSET_FUNDING_SOURCE

AF_GENERAL_LEDGER

AF_GRANT

AF_GRANT_BILLING_DETAIL

AF_GRANT_LEDGER

AF_INVOICE_ACCOUNTING

AT_GRANT_ACCOUNT_DETAIL

AF_ACCOUNT_HIERARCHY_FISCAL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_UNITS

AF_ENDOWMENT_UNITS

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_ITEM

AF_FUND_HIERARCHY

AF_FUND_HIERARCHY

AF_GRANT_BILLING_DETAIL

AF_OPERATING_LEDGER

AF_TRANSACTION_HISTORY

AF_ACCOUNT_INDEX

AF_ACCOUNT_INDEX

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_DIST

AF_FIXED_ASSET_FUNDING_SOURCE

AF_GRANT_BILLING_DETAIL

AF_GRANT_FUND

AF_GRANT_LEDGER

AF_INVOICE_ACCOUNTING

AF_INVOICE_ACCOUNTING

AF_ORGANIZATION_HIERARCHY

AF_ACCOUNT_INDEX

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_BUDGET_DETAIL

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_FISCAL_PERIOD

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_DEPRECIATION

AF_FUND_HIERARCHY_FISCAL

AF_GENERAL_LEDGER

AF_GRANT

AF_GRANT_BILLING_DETAIL

AF_OPERATING_LEDGER

AF_OPERATING_LEDGER

AF_PROGRAM_HIERARCHY_FISCAL

AF_TRANSACTION_HISTORY

AP_EMPLOYEE

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_INDEX

AF_ACCOUNT_INDEX

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_FIXED_ASSET_ADJUSTMENT

AF_FIXED_ASSET_FUNDING_SOURCE

AF_FUND_HIERARCHY_FISCAL

AF_GENERAL_LEDGER

AF_GRANT_BILLING_DETAIL

AF_GRANT_BILLING_DETAIL

AF_GRANT_FUND

AF_GRANT_FUND

AF_GRANT_FUND

AF_ORGANIZATION_HIERARCHY

AF_ACCOUNT_INDEX

AF_BUDGET_DETAIL

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_ATTRIBUTES

AF_ENDOWMENT_UNITS

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_FUNDING_SOURCE

AF_FIXED_ASSET_ITEM

AF_GRANT

AF_GRANT_LEDGER

AF_GRANT_LEDGER

AF_INVOICE_ACCOUNTING

AF_INVOICE_ACCOUNTING

AF_LOCATION_HIERARCHY_FISCAL

AF_OPERATING_LEDGER

AF_ORGN_HIERARCHY_FISCAL

AF_PROPOSAL

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_AVAILABILITY_LEDGER

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT

AF_ENDOWMENT_UNITS

AF_ENDOWMENT_UNITS

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_FUNDING_SOURCE

AF_FIXED_ASSET_ITEM

AF_GRANT_BILLING_DETAIL

AF_GRANT_BILLING_DETAIL

AF_GRANT_BILLING_DETAIL

AF_GRANT_FUND

AF_GRANT_FUND

AF_GRANT_LEDGER

AF_OPERATING_LEDGER

AF_OPERATING_LEDGER

AF_OPERATING_LEDGER

AF_PROGRAM_HIERARCHY

AF_PROPOSAL

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AF_PURCHASE_ORDER_ACCOUNTING

AP_EMPLOYEE

l lor="#000000" face="Arial" size="2">INCOME_CR_ACCOUNT_DESC

INCOME_CR_CHART_DESC

INCOME_CR_PROGRAM_DESC

UNREAL_GAIN_LOSS_INDEX_DESC

FUND_DESC

PROGRAM_DESC

ACTIVITY_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

BILL_ACTIVITY_DESC

ACTIVITY_DESC

ACCOUNT_DESC

ACCOUNT_FUND_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_DR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_ACCOUNT_INDEX_DESC

UNREAL_GAIN_LOSS_DR_LOCN_DESC

VARIANCE_DR_FUND_POOL_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

FUND_POOL_DESC

BILL_ACCOUNT_INDEX_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

FUND_DESC

PROGRAM lor="#000000" face="Arial" size="2">INCOME_CR_ACCOUNT_DESC

INCOME_CR_CHART_DESC

INCOME_CR_PROGRAM_DESC

UNREAL_GAIN_LOSS_INDEX_DESC

FUND_DESC

PROGRAM_DESC

ACTIVITY_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

BILL_ACTIVITY_DESC

ACTIVITY_DESC

ACCOUNT_DESC

ACCOUNT_FUND_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_DR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_ACCOUNT_INDEX_DESC

UNREAL_GAIN_LOSS_DR_LOCN_DESC

VARIANCE_DR_FUND_POOL_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

FUND_POOL_DESC

BILL_ACCOUNT_INDEX_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

FUND_DESC

PROGRAM_DESC

GAIN_LOSS_ACCOUNT_INDEX_DESC

INCOME_CR_ACCOUNT_POOL_DESC

INCOME_CR_CHART_POOL_DESC

UNREAL_GAIN_LOSS_DR_CHART_DESC

VARIANCE_DR_LOCN_POOL_DESC

VARIANCE_SPEND_DR_CHART_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

BILL_ALTERNATE_FUND_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ACTIVITY_DESC

LOCATION_DESC

ORGANIZATION_POOL_DESC

ACTIVITY_DESC

ACCOUNT_DESC

ACCOUNT_DESC

ACTIVITY_DESC

LOCATION_DESC

INCOME_CR_ACTIVITY_DESC

INCOME_DR_FUND_POOL_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_CR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_FUND_DESC

VARIANCE_DR_ORGN_POOL_DESC

CHART_OF_ACCOUNTS_DESC

ASSET_ACCOUNT_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

LOCATION_DESC

BILL_FUND_DESC

FUND_DESC

INCOME_CR_ACCOUNT_DESC

INCOME_CR_CHART_DESC

INCOME_CR_PROGRAM_DESC

UNREAL_GAIN_LOSS_INDEX_DESC

FUND_DESC

PROGRAM_DESC

ACTIVITY_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

BILL_ACTIVITY_DESC

ACTIVITY_DESC

ACCOUNT_DESC

ACCOUNT_FUND_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_DR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_ACCOUNT_INDEX_DESC

UNREAL_GAIN_LOSS_DR_LOCN_DESC

VARIANCE_DR_FUND_POOL_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

FUND_POOL_DESC

BILL_ACCOUNT_INDEX_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

FUND_DESC

PROGRAM_DESC

GAIN_LOSS_ACCOUNT_INDEX_DESC

INCOME_CR_ACCOUNT_POOL_DESC

INCOME_CR_CHART_POOL_DESC

UNREAL_GAIN_LOSS_DR_CHART_DESC

VARIANCE_DR_LOCN_POOL_DESC

VARIANCE_SPEND_DR_CHART_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

BILL_ALTERNATE_FUND_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ACTIVITY_DESC

LOCATION_DESC

ORGANIZATION_POOL_DESC

ACTIVITY_DESC

ACCOUNT_DESC

ACCOUNT_DESC

ACTIVITY_DESC

LOCATION_DESC

INCOME_CR_ACTIVITY_DESC

INCOME_DR_FUND_POOL_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_CR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_FUND_DESC

VARIANCE_DR_ORGN_POOL_DESC

CHART_OF_ACCOUNTS_DESC

ASSET_ACCOUNT_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

LOCATION_DESC

BILL_FUND_DESC

FUND_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

ACTIVITY_DESC

CHECK_DISTRIBUTION_CHART_DESC

ACCOUNT_POOL_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ACTIVITY_DESC

PROGRAM_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

INCOME_DR_ACCT_POOL_DESC

INCOME_DR_ACTV_POOL_DESC

EQUITY_ACCOUNT_DESC

ORGANIZATION_DESC

FUND_POOL_DESC

CHART_OF_ACCOUNTS_DESC

BILL_CHART_OF_ACCOUNTS_DESC

BILL_PROGRAM_DESC

CONSTR_IN_PROGR_ACCOUNT_DESC

FUND_PREDECESSOR_DESC

WITHHOLDING_AR_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

ORGANIZATION_DESC

FUND_DESC

LOCATION_DESC

GAIN_LOSS_DR_CHART_POOL_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_ORGANIZATION_DESC

UNREAL_GAIN_LOSS_DR_ACTV_DESC

VARIANCE_CR_ACCT_POOL_DESC

VARIANCE_DR_ACCT_POOL_DESC

CHART_OF_ACCOUNTS_DESC

ORGANIZATION_DESC

INCOME_CR_ACCOUNT_DESC

INCOME_CR_CHART_DESC

INCOME_CR_PROGRAM_DESC

UNREAL_GAIN_LOSS_INDEX_DESC

FUND_DESC

PROGRAM_DESC

ACTIVITY_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

BILL_ACTIVITY_DESC

ACTIVITY_DESC

ACCOUNT_DESC

ACCOUNT_FUND_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_DR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_ACCOUNT_INDEX_DESC

UNREAL_GAIN_LOSS_DR_LOCN_DESC

VARIANCE_DR_FUND_POOL_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

FUND_POOL_DESC

BILL_ACCOUNT_INDEX_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

FUND_DESC

PROGRAM_DESC

GAIN_LOSS_ACCOUNT_INDEX_DESC

INCOME_CR_ACCOUNT_POOL_DESC

INCOME_CR_CHART_POOL_DESC

UNREAL_GAIN_LOSS_DR_CHART_DESC

VARIANCE_DR_LOCN_POOL_DESC

VARIANCE_SPEND_DR_CHART_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

BILL_ALTERNATE_FUND_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ACTIVITY_DESC

LOCATION_DESC

ORGANIZATION_POOL_DESC

ACTIVITY_DESC

ACCOUNT_DESC

ACCOUNT_DESC

ACTIVITY_DESC

LOCATION_DESC

INCOME_CR_ACTIVITY_DESC

INCOME_DR_FUND_POOL_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_CR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_FUND_DESC

VARIANCE_DR_ORGN_POOL_DESC

CHART_OF_ACCOUNTS_DESC

ASSET_ACCOUNT_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

LOCATION_DESC

BILL_FUND_DESC

FUND_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

ACTIVITY_DESC

CHECK_DISTRIBUTION_CHART_DESC

ACCOUNT_POOL_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ACTIVITY_DESC

PROGRAM_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

INCOME_DR_ACCT_POOL_DESC

INCOME_DR_ACTV_POOL_DESC

EQUITY_ACCOUNT_DESC

ORGANIZATION_DESC

FUND_POOL_DESC

CHART_OF_ACCOUNTS_DESC

BILL_CHART_OF_ACCOUNTS_DESC

BILL_PROGRAM_DESC

CONSTR_IN_PROGR_ACCOUNT_DESC

FUND_PREDECESSOR_DESC

WITHHOLDING_AR_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

ORGANIZATION_DESC

FUND_DESC

LOCATION_DESC

GAIN_LOSS_DR_CHART_POOL_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_ORGANIZATION_DESC

UNREAL_GAIN_LOSS_DR_ACTV_DESC

VARIANCE_CR_ACCT_POOL_DESC

VARIANCE_DR_ACCT_POOL_DESC

CHART_OF_ACCOUNTS_DESC

ORGANIZATION_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

CHART_OF_ACCOUNTS_DESC

RESPONSIBLE_ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

ORGANIZATION_POOL_DESC

CHART_OF_ACCOUNTS_DESC

RULE_CLASS_DESC

TAX_RULE_CLASS_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_DR_PROG_POOL_DESC

INCOME_DR_CHART_POOL_DESC

INCOME_DR_LOCN_POOL_DESC

INCOME_DR_ORGN_POOL_DESC

UNREAL_GAIN_LOSS_DR_ORGN_DESC

UNREAL_GAIN_LOSS_DR_PROG_DESC

VARIANCE_DR_PROG_POOL_DESC

ACCOUNT_DESC

FUND_DESC

EQUITY_ACCOUNT_DESC

LOCATION_DESC

LOCATION_DESC

BILL_ACCOUNT_DESC

BILL_LOCATION_DESC

INCOME_CR_ACCOUNT_DESC

INCOME_CR_CHART_DESC

INCOME_CR_PROGRAM_DESC

UNREAL_GAIN_LOSS_INDEX_DESC

FUND_DESC

PROGRAM_DESC

ACTIVITY_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

BILL_ACTIVITY_DESC

ACTIVITY_DESC

ACCOUNT_DESC

ACCOUNT_FUND_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_DR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_ACCOUNT_INDEX_DESC

UNREAL_GAIN_LOSS_DR_LOCN_DESC

VARIANCE_DR_FUND_POOL_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

FUND_POOL_DESC

BILL_ACCOUNT_INDEX_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

ORGANIZATION_DESC

ORGANIZATION_DESC

FUND_DESC

PROGRAM_DESC

GAIN_LOSS_ACCOUNT_INDEX_DESC

INCOME_CR_ACCOUNT_POOL_DESC

INCOME_CR_CHART_POOL_DESC

UNREAL_GAIN_LOSS_DR_CHART_DESC

VARIANCE_DR_LOCN_POOL_DESC

VARIANCE_SPEND_DR_CHART_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

BILL_ALTERNATE_FUND_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ACTIVITY_DESC

LOCATION_DESC

ORGANIZATION_POOL_DESC

ACTIVITY_DESC

ACCOUNT_DESC

ACCOUNT_DESC

ACTIVITY_DESC

LOCATION_DESC

INCOME_CR_ACTIVITY_DESC

INCOME_DR_FUND_POOL_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_CR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_FUND_DESC

VARIANCE_DR_ORGN_POOL_DESC

CHART_OF_ACCOUNTS_DESC

ASSET_ACCOUNT_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

LOCATION_DESC

BILL_FUND_DESC

FUND_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

ACTIVITY_DESC

CHECK_DISTRIBUTION_CHART_DESC

ACCOUNT_POOL_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

ACTIVITY_DESC

PROGRAM_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

INCOME_DR_ACCT_POOL_DESC

INCOME_DR_ACTV_POOL_DESC

EQUITY_ACCOUNT_DESC

ORGANIZATION_DESC

FUND_POOL_DESC

CHART_OF_ACCOUNTS_DESC

BILL_CHART_OF_ACCOUNTS_DESC

BILL_PROGRAM_DESC

CONSTR_IN_PROGR_ACCOUNT_DESC

FUND_PREDECESSOR_DESC

WITHHOLDING_AR_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

ORGANIZATION_DESC

FUND_DESC

LOCATION_DESC

GAIN_LOSS_DR_CHART_POOL_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_ORGANIZATION_DESC

UNREAL_GAIN_LOSS_DR_ACTV_DESC

VARIANCE_CR_ACCT_POOL_DESC

VARIANCE_DR_ACCT_POOL_DESC

CHART_OF_ACCOUNTS_DESC

ORGANIZATION_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

CHART_OF_ACCOUNTS_DESC

RESPONSIBLE_ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

ORGANIZATION_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

ORGANIZATION_POOL_DESC

CHART_OF_ACCOUNTS_DESC

RULE_CLASS_DESC

TAX_RULE_CLASS_DESC

CHART_OF_ACCOUNTS_DESC

FUND_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_DR_PROG_POOL_DESC

INCOME_DR_CHART_POOL_DESC

INCOME_DR_LOCN_POOL_DESC

INCOME_DR_ORGN_POOL_DESC

UNREAL_GAIN_LOSS_DR_ORGN_DESC

UNREAL_GAIN_LOSS_DR_PROG_DESC

VARIANCE_DR_PROG_POOL_DESC

ACCOUNT_DESC

FUND_DESC

EQUITY_ACCOUNT_DESC

LOCATION_DESC

LOCATION_DESC

BILL_ACCOUNT_DESC

BILL_LOCATION_DESC

BILL_ORGANIZATION_DESC

BILLED_AR_ACCOUNT_DESC

SOURCE_FUND_DESC

ACCOUNT_DESC

ACTIVITY_DESC

LOCATION_DESC

PROGRAM_DESC

CHART_OF_ACCOUNTS_DESC

ORGANIZATION_DESC

ADDITIONAL_AMT_RULE_CLASS_DESC

DISCOUNT_RULE_CLASS_DESC

LIQUIDATION_RULE_CLASS_DESC

HOME_ORGANIZATION_DESC

This function will return the description of the passed validation or rule code up to the parameter value characters. Parameters include which_table, chart of accounts code, the code for the table specified, and how many characters the returned value should be.
F_GET_FINANCE_STATUS   N NG_COMP_target.html">AF_ENCUMBRANCE_ACCOUNTING

AF_FIXED_ASSET_ADJUSTMENT

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_FUNDING_SOURCE

AF_FIXED_ASSET_FUNDING_SOURCE

AF_INVOICE_ACCOUNTING

AF_OPERATING_LEDGER

AF_OPERATING_LEDGER

AF_ACCOUNT_INDEX

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_DETAIL

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_FUNDING_SOURCE

AF_GENERAL_LEDGER

AF_GRANT

AF_GRANT_BILLING_DETAIL

AF_GRANT_BILLING_DETAIL

AF_INVOICE_ACCOUNTING

AF_OPERATING_LEDGER

AF_TRANSACTION_HISTORY

AF_BUDGET_DETAIL

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_FIXED_ASSET_DEPRECIATION

AF_GRANT_BILLING_DETAIL

AF_GRANT_BILLING_DETAIL

AF_INVOICE_ACCOUNTING

AF_OPERATING_LEDGER

AF_TRANSACTION_HISTORY

AF_ACCOUNT_INDEX

AF_FUND_HIERARCHY

AF_GENERAL_LEDGER

AF_GRANT_BILLING_DETAIL

AF_INVOICE_ACCOUNTING

AF_INVOICE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_FIXED_ASSET_ADJUSTMENT

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_FUNDING_SOURCE

AF_FIXED_ASSET_FUNDING_SOURCE

AF_INVOICE_ACCOUNTING

AF_OPERATING_LEDGER

AF_OPERATING_LEDGER

AF_ACCOUNT_INDEX

AF_BUDGET_AVAILABILITY_LEDGER

AF_BUDGET_DETAIL

AF_FIXED_ASSET_DEPRECIATION

AF_FIXED_ASSET_FUNDING_SOURCE

AF_GENERAL_LEDGER

AF_GRANT

AF_GRANT_BILLING_DETAIL

AF_GRANT_BILLING_DETAIL

AF_INVOICE_ACCOUNTING

AF_OPERATING_LEDGER

AF_TRANSACTION_HISTORY

AF_BUDGET_DETAIL

AF_ENCUMBRANCE_ACCOUNTING

AF_ENCUMBRANCE_ACCOUNTING

AF_FIXED_ASSET_DEPRECIATION

AF_GRANT_BILLING_DETAIL

AF_GRANT_BILLING_DETAIL

AF_INVOICE_ACCOUNTING

AF_OPERATING_LEDGER

AF_TRANSACTION_HISTORY

AF_ACCOUNT_INDEX

AF_FUND_HIERARCHY

AF_GENERAL_LEDGER

AF_GRANT_BILLING_DETAIL

AF_INVOICE_ACCOUNTING

AF_INVOICE_ACCOUNTING

AF_TRANSACTION_HISTORY

S S

PROGRAM_STATUS

ORGANIZATION_STATUS

ACCOUNT_STATUS

ORGANIZATION_STATUS

EQUITY_ACCOUNT_STATUS

ASSET_ACCOUNT_STATUS

EQUITY_ACCOUNT_STATUS

LOCATION_STATUS

ACCOUNT_STATUS

FUND_STATUS

ACCOUNT_STATUS

LOCATION_STATUS

ORGANIZATION_STATUS

ORGANIZATION_STATUS

ORGANIZATION_STATUS

FUND_STATUS

FUND_STATUS

ORGANIZATION_STATUS

CHART_OF_ACCOUNTS_STATUS

RESPONSIBLE_ORGN_STATUS

BILL_ALTERNATE_FUND_STATUS

BILL_LOCATION_STATUS

ACTIVITY_STATUS

ACTIVITY_STATUS

ACTIVITY_STATUS

CHART_OF_ACCOUNTS_STATUS

LOCATION_STATUS

PROGRAM_STATUS

PROGRAM_STATUS

BILL_ACTIVITY_STATUS

BILL_FUND_STATUS

CHART_OF_ACCOUNTS_STATUS

FUND_STATUS

PROGRAM_STATUS

ORGANIZATION_STATUS

ACCOUNT_STATUS

ORGANIZATION_STATUS

EQUITY_ACCOUNT_STATUS

ASSET_ACCOUNT_STATUS

EQUITY_ACCOUNT_STATUS

LOCATION_STATUS

ACCOUNT_STATUS

FUND_STATUS

ACCOUNT_STATUS

LOCATION_STATUS

ORGANIZATION_STATUS

ORGANIZATION_STATUS

ORGANIZATION_STATUS

FUND_STATUS

FUND_STATUS

ORGANIZATION_STATUS

CHART_OF_ACCOUNTS_STATUS

RESPONSIBLE_ORGN_STATUS

BILL_ALTERNATE_FUND_STATUS

BILL_LOCATION_STATUS

ACTIVITY_STATUS

ACTIVITY_STATUS

ACTIVITY_STATUS

CHART_OF_ACCOUNTS_STATUS

LOCATION_STATUS

PROGRAM_STATUS

PROGRAM_STATUS

BILL_ACTIVITY_STATUS

BILL_FUND_STATUS

CHART_OF_ACCOUNTS_STATUS

FUND_STATUS

CHART_OF_ACCOUNTS_POOL_STATUS

ACTIVITY_STATUS

CHART_OF_ACCOUNTS_STATUS

ACCOUNT_STATUS

BILL_ORGANIZATION_STATUS

FUND_STATUS

ORGANIZATION_STATUS

FUND_POOL_STATUS

This function will return the status indicator of the specified validation or rule code for the length specified.
F_GET_FISCAL_PERIOD  

AF_GRANT

STATUS_FISCAL_PERIOD

This function retrieves the fiscal period based on fiscal year and chart of accounts passed.
F_GET_NORM_BALANCE        
F_GET_SPONSOR_ACCT  

AF_GRANT_LEDGER

SPONSOR_ACCOUNT_DESC

This function retrieves the sponsor account for either a grant or a proposal based on either the code indicator passed ('GRNT' or 'PROP'), code passed (grant or prop code), chart of account and account code or code indicator, code, chart of accounts and account type passed.
F_GET_STATUS_DATE  

AF_PROPOSAL

AF_PROPOSAL

AF_PROPOSAL

AF_PROPOSAL

DECLINE_DATE

SUBMISSION_DATE

ORIGINATION_DATE

AWARD_DATE

This function retrieves the date for a particular status based on status code, proposal code and chart of accounts.
F_GET_STATUS_INFO  

AF_PROPOSAL

AF_PROPOSAL

AF_PROPOSAL

AF_PROPOSAL

ORIGINATION_FISCAL_PERIOD

DECLINE_FISCAL_PERIOD

SUBMISSION_FISCAL_PERIOD

AWARD_FISCAL_PERIOD

This function retrieves the fiscal year or fiscal period based on a particalar status, proposal and chart of accounts.
F_GET_SUM_TOTAL_CREDITS_BY_AEP        
F_GET_TENURE        
F_HOUS_THIS_TERM  

AS_ENROLLMENT

AS_ENROLLMENT_HISTORY

HOUSING_IND

HOUSING_IND

This function retrieves a 'Y' or 'N' depending on whether or not the person and academic period being passed has a record in the room assignment table.
F_INQUIRER_FNC  

AS_CURRICULUM_FOS

INQUIRER_IND

This function retrieves a 'Y' or 'N' depending on whether or not the person academic period and level being passed has a record in the recruitment table.
F_INST_AID_FNC  

AR_AWARD_BY_PERSON

INSTITUTION_AID_IND

This function retrieves a 'Y' or 'N' based on the sum of the acceptance amount for a person and aid year where the fund source code has a value of 'INST'. The sum of the acceptance amount must be greater than 0 to return a 'Y'.
F_LEVEL_ADMITTED_FNC  

AS_CURRICULUM_FOS

ADMIT_IND

This function retrieves a 'Y' or 'N' based on a person, academic period and level code having a record in the admissions application table.
F_LEVEL_APPL_FNC  

AS_CURRICULUM_FOS

APPLICANT_IND

This function retrieves a 'Y' or 'N' based on a person, academic period and level code having a record in the admissions application table.
F_LIFE_TOTAL_COMMITMENT  

AA_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

LIFE_TOTAL_COMMITMENT

LIFE_TOTAL_COMMITMENT

This function retrieves the sum of the giving history pledged amount and gift amount based on the person passed.
F_LIFE_TOTAL_GIVING  

AA_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

LIFE_TOTAL_GIVING

LIFE_TOTAL_GIVING

This function retrieves the sum of the giving history pledged amount paid and gift amount and substracts the total of AGRGMMO_3PP_TOT_AMT based on the person passed.
F_LIFE_TOTAL_PLEDGED_AMOUNT  

AA_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

LIFE_TOTAL_PLEDGE_AMT

LIFE_TOTAL_PLEDGE_AMT

This function retrieves the sum of the giving history pledged amount based on the person passed.
F_LIFE_TOTAL_PLEDGE_PAYMENT  

AA_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

LIFE_TOTAL_PLEDGE_PAY

LIFE_TOTAL_PLEDGE_PAY

This function retrieves the sum of the giving history pledged amount paid based on the person passed.
F_LOST_AL_IND  

AA_CONSTITUENT

LOST_ALUMNUS_IND

This function retrieves a 'N' if the person passed has a record in the address table and the address end date is greater than or equal to the current date and the address status is active or null OR the address start date is null abd the address status is active or is null.
F_MATCHING_GIFT  

AA_GIFT

MATCHING_GIFT

This function returns a P if the matching gift status indicator AGBMGID_STATUS_IND is P, it returns a W if the matching gift status indicator is W else N for a specified gift number.
F_MEMO_DETAIL_MATCHING_GIFT  

AA_GIFT_MEMO

AA_GIFT_MULTIPLE

MEMO_MATCH_GIFT_IND

MULTIPLE_MATCH_GIFT_IND

This function returns a Y if the memo detail matching gift AGRMGIF exists for a specified gift number else N.
F_MORE_SPECIFIC_REQUIREMENTS  

AR_FINAID_TRACKING_REQUIREMENT

MORE_SPECIFIC_REQ_IND

This function returns a Y if there exists the special requirements RRRAREQ for a specified UID, aid year, tracking requirement and sat indicator else it returns a N.
F_MOST_RECENT_GIFT_AMOUNT       This function returns the most recent gift record - gift amount AGBGIFT_AMT_TOT or gift date AGBGIFT_GIFT_DATE for a specified UID.
F_MOST_RECENT_PLEDGE_AMOUNT       This function returns the most recent pledge record - pledge amount AGBPLDG_AMT_PLEDGED or pledge date AGBPLDG_PLEDGE_DATE for a specified UID.
F_MULTIPLE_RATIOS  

AA_ORGANIZATIONAL_CONSTITUENT

MULTIPLE_RATIOS_IND

This function return a Y if this organization has multiple ratios AORMRTO else a N for a specified UID.
F_PAID_ADMISSIONS_DEPOSIT  

AS_CURRICULUM_FOS

DEPOSIT_IND

This function returns a Y if there exists a paid admissions deposit based on the SARAPPD_APDC_CODEs as defined in GTVSDAX where GTVSDAX_INTERNAL_CODE = 'DEPOPAID' AND GTVSDAX_INTERNAL_CODE_GROUP = 'DEPOSIT' else N for a specified UID and academic period.
F_PROFILE_DATE  

AP_EMPLOYEE

AP_TAX

PROFILE_DATE

PROFILE_DATE

This function checks for reporting date in gtvsdax table if not found then it returns the sysdate.
F_PROSPECT_FNC  

AS_CURRICULUM_FOS

PROSPECT_IND

This function always returns a N.
F_PROSPECT_IND  

AA_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

PROSPECT_IND

PROSPECT_IND

This function returns a Y where the prospect record AMRINFO exists for a specified UID.
F_QUATERLY_DEDUCTION_TOTAL       This function calculates quarterly deduction total SUM(PERDTOT_EMPL_AMT) for a particular year for a specified UID.
F_RBRMIXD_DATA  

AR_FINAID_BUDGET_COMPONENT

MIXED_BUDGET_IND

This function returns a Y if the RBRMIXD record exists else it returns a N for a specified UID, aid year and budget group.
F_REGISTERED_THIS_TERM  

AS_ENROLLMENT

REGISTERED_IND

This function checks to see if the student is registered this term STVRSTS_INCL_SECT_ENRL = Y for a specified UID and academic period.
F_SUM_BALANCE_TERM       This function calculates the balance SUM(TBRACCD_BALANCE) for a given term, category code and detail code.
F_TOTAL_HOUR_EARNING_CODE       This function calculates total hours or earning PERJTOT_EARN_CODE for an employee for a specified year and earn code as defined in GTVSDAX where GTVSDAX_INTERNAL_CODE = 'PAYREARN' AND GTVSDAX_INTERNAL_CODE_GROUP = 'EARNING'
F_UNSATISFIED_PROM_NOTE  

AR_FINAID_TRACKING_REQUIREMENT

UNSATISFIED_PROM_NOTE_IND

This function return a Y if the RFRPROM record exists for a specified UID and aid year where the RFRPROM_SAT_IND = N else N.
F_YEAR  

AP_BENEFIT_DEDUCTION

AP_TAX

PROFILE_DATE

TAX_DEDUCTION_YEAR

This function retrieves the Banner/concept code from gtvsdax table based on internal_code and internal_code_group.
F_YEARLY_DEDUCTION_TOTAL  

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

EMPLOYER_CONTRIBUTION_YTD

GROSS_COMPENSATION_YTD

EMPLOYEE_CONTRIBUTION_YTD

This function will calculate yearly deduction total PERDTOT based on the UID.
GOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC  

AN_PAYROLL_DISTRIBUTION

ACTIVITY_DESC

 
GOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS  

AN_PAYROLL_DISTRIBUTION

ACTIVITY_STATUS

 
GOKODSF.F_DIRECT_DEPOSIT_IND  

AE_PROFILE

DIRECT_DEPOSIT_IND

 
GOKODSF.F_FORMAT_MAILING_ADDRESS       This function returns the formatted address with concatenated fields seperated by carriage returns SPRADDR for a specified UID, address type, sequence number, status indicator and the type of format, US or Other.
GOKODSF.F_FORMAT_NAME       This function returns an entity's name based upon a specified pidm and name type. The possible name types are as follows: (LF30) Last name, first name for 30 characters; (L30) Last name for 30 characters; (FL30) First name, last name for 30 characters; (FL) Last name, first name; (FMIL) First name, middle initial, last name; (FML) First name, middle name, last name; (LFMI) Last name, first name, middle initial.
GOKODSF.F_FORMAT_PREFERRED_NAME       This function retrieves a name based upon a specified person and format. The format can be 'FORMAL', 'INFORMAL', or 'PREFERRED'.
GOKODSF.F_GET_DESC   c ce="Arial" size="2">AS_COURSE_OFFERING

AS_COURSE_PREREQ

AS_COURSE_SCHEDULE

AS_COURSE_SCHEDULE

AS_ENROLLMENT_HISTORY

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_FEEDBACK

AS_FIELD_OF_STUDY

AS_OFFERING_GRADE_TYPE

AS_OFFERING_PREREQ

AS_OUTCOME_HONOR_INST

AS_RECRUITMENT_COHORT

AS_SPORT

AS_STUDENT_ATTRIBUTE

AS_STUDENT_COURSE_ATTR_TRANS

AS_STUDENT_COURSE_ATTR_TRANS

AT_LEDGER_ACCOUNTING

AG_GEOGRAPHIC_REGION_INST

AS_INTEREST

AS_PREVIOUS_EDUCATION_PCOL

AS_SECONDARY_SCHOOL_SUBJECT

AS_TELEPHONE

AS_VISA

AA_CONSTITUENT_CONTACT

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_FUNDING_INTEREST

AA_FUNDING_INTEREST

AA_GIFT_SOCIETY

AA_PROJECT_INTEREST

AA_PROSPECT_INFO

AA_PROSPECT_INFO

AA_PROSPECT_PROPOSAL

AA_PROSPECT_PROPOSAL

AF_INVOICE

AF_INVOICE

< ce="Arial" size="2">AS_COURSE_OFFERING

AS_COURSE_PREREQ

AS_COURSE_SCHEDULE

AS_COURSE_SCHEDULE

AS_ENROLLMENT_HISTORY

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_FEEDBACK

AS_FIELD_OF_STUDY

AS_OFFERING_GRADE_TYPE

AS_OFFERING_PREREQ

AS_OUTCOME_HONOR_INST

AS_RECRUITMENT_COHORT

AS_SPORT

AS_STUDENT_ATTRIBUTE

AS_STUDENT_COURSE_ATTR_TRANS

AS_STUDENT_COURSE_ATTR_TRANS

AT_LEDGER_ACCOUNTING

AG_GEOGRAPHIC_REGION_INST

AS_INTEREST

AS_PREVIOUS_EDUCATION_PCOL

AS_SECONDARY_SCHOOL_SUBJECT

AS_TELEPHONE

AS_VISA

AA_CONSTITUENT_CONTACT

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_FUNDING_INTEREST

AA_FUNDING_INTEREST

AA_GIFT_SOCIETY

AA_PROJECT_INTEREST

AA_PROSPECT_INFO

AA_PROSPECT_INFO

AA_PROSPECT_PROPOSAL

AA_PROSPECT_PROPOSAL

AF_INVOICE

AF_INVOICE

AF_ORGANIZATION_HIERARCHY

AN_EMPLOYEE_POSITION

AN_PAYROLL_DISTRIBUTION

AP_EMPLOYEE_EARNING_FY

AP_HR_APPLICATION_STATUS

AP_HR_APPLICATION_STATUS

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_TAX

AR_FINAID_ENROLLMENT

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_STUDENT_PERIOD_DEFINITION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_DECISION

AS_ADMISSIONS_SOURCE

AS_COURSE_COREQ

AS_COURSE_SCHEDULE

AS_COURSE_SUPPLEMENTAL

AS_FACULTY

AS_GPA_TERM

AS_INSTRUCTIONAL_ASSIGNMENT

AS_OFFERING_PREREQ

AS_RECRUITMENT_SOURCE

AT_LEDGER_ACCOUNTING

AA_MAIL

AG_COMMUNICATION

AP_PAST_EMPLOYMENT

AP_SKILL

AS_ADDRESS

AS_DISABILITY_INFORMATION

AS_HOLD

AS_MEDICAL_INFORMATION

AS_YEAR_TYPE_DEFINITION

AA_DESIGNATION

AS_COURSE_OFFERING

AS_COURSE_PREREQ

AS_COURSE_SCHEDULE

AS_COURSE_SCHEDULE

AS_ENROLLMENT_HISTORY

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_FEEDBACK

AS_FIELD_OF_STUDY

AS_OFFERING_GRADE_TYPE

AS_OFFERING_PREREQ

AS_OUTCOME_HONOR_INST

AS_RECRUITMENT_COHORT

AS_SPORT

AS_STUDENT_ATTRIBUTE

AS_STUDENT_COURSE_ATTR_TRANS

AS_STUDENT_COURSE_ATTR_TRANS

AT_LEDGER_ACCOUNTING

AG_GEOGRAPHIC_REGION_INST

AS_INTEREST

AS_PREVIOUS_EDUCATION_PCOL

AS_SECONDARY_SCHOOL_SUBJECT

AS_TELEPHONE

AS_VISA

AA_CONSTITUENT_CONTACT

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_FUNDING_INTEREST

AA_FUNDING_INTEREST

AA_GIFT_SOCIETY

AA_PROJECT_INTEREST

AA_PROSPECT_INFO

AA_PROSPECT_INFO

AA_PROSPECT_PROPOSAL

AA_PROSPECT_PROPOSAL

AF_INVOICE

AF_INVOICE

AF_ORGANIZATION_HIERARCHY

AN_EMPLOYEE_POSITION

AN_PAYROLL_DISTRIBUTION

AP_EMPLOYEE_EARNING_FY

AP_HR_APPLICATION_STATUS

AP_HR_APPLICATION_STATUS

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_TAX

AR_FINAID_ENROLLMENT

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_STUDENT_PERIOD_DEFINITION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_DECISION

AS_ADMISSIONS_SOURCE

AS_COURSE_COREQ

AS_COURSE_SCHEDULE

AS_COURSE_SUPPLEMENTAL

AS_FACULTY

AS_GPA_TERM

AS_INSTRUCTIONAL_ASSIGNMENT

AS_OFFERING_PREREQ

AS_RECRUITMENT_SOURCE

AT_LEDGER_ACCOUNTING

AA_MAIL

AG_COMMUNICATION

AP_PAST_EMPLOYMENT

AP_SKILL

AS_ADDRESS

AS_DISABILITY_INFORMATION

AS_HOLD

AS_MEDICAL_INFORMATION

AS_YEAR_TYPE_DEFINITION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_GIFT

AA_MEMBERSHIP_INTEREST

AA_PROSPECT_MOVES_MANAGEMENT

AA_SOLICITOR_ASSIGNMENT

AF_GRANT_FUND

AF_GRANT_FUND

AF_GRANT_FUND

AF_INVOICE_ITEM

AN_PAYROLL_DISTRIBUTION

AN_PERSONNEL_ACTION_LABOR_DIST

AP_BENEFICIARY_DEPENDENT

AP_BENEFIT_DEDUCTION

AP_EMPLOYEE_EARNING_CY

AP_MONTHLY_DEDUCTION

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_PAYROLL_TIMESHEET

AR_FINAID_ENROLLMENT

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AS_ADMINISTRATOR

AS_ADMINISTRATOR

AS_ADMISSIONS_ATTRIBUTE

AS_ADMISSIONS_DECISION

AS_ADVISOR

AS_COURSE_LEVEL

AS_COURSE_PREREQ

AS_COURSE_SUPPLEMENTAL

AS_COURSE_SUPPLEMENTAL

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_FACULTY

AS_FACULTY_CONTRACT

AS_FACULTY_DEPARTMENT_COLLEGE

AS_GPA_LEVEL

AS_COURSE_OFFERING

AS_COURSE_PREREQ

AS_COURSE_SCHEDULE

AS_COURSE_SCHEDULE

AS_ENROLLMENT_HISTORY

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_FEEDBACK

AS_FIELD_OF_STUDY

AS_OFFERING_GRADE_TYPE

AS_OFFERING_PREREQ

AS_OUTCOME_HONOR_INST

AS_RECRUITMENT_COHORT

AS_SPORT

AS_STUDENT_ATTRIBUTE

AS_STUDENT_COURSE_ATTR_TRANS

AS_STUDENT_COURSE_ATTR_TRANS

AT_LEDGER_ACCOUNTING

AG_GEOGRAPHIC_REGION_INST

AS_INTEREST

AS_PREVIOUS_EDUCATION_PCOL

AS_SECONDARY_SCHOOL_SUBJECT

AS_TELEPHONE

AS_VISA

AA_CONSTITUENT_CONTACT

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_FUNDING_INTEREST

AA_FUNDING_INTEREST

AA_GIFT_SOCIETY

AA_PROJECT_INTEREST

AA_PROSPECT_INFO

AA_PROSPECT_INFO

AA_PROSPECT_PROPOSAL

AA_PROSPECT_PROPOSAL

AF_INVOICE

AF_INVOICE

AF_ORGANIZATION_HIERARCHY

AN_EMPLOYEE_POSITION

AN_PAYROLL_DISTRIBUTION

AP_EMPLOYEE_EARNING_FY

AP_HR_APPLICATION_STATUS

AP_HR_APPLICATION_STATUS

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_TAX

AR_FINAID_ENROLLMENT

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_STUDENT_PERIOD_DEFINITION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_DECISION

AS_ADMISSIONS_SOURCE

AS_COURSE_COREQ

AS_COURSE_SCHEDULE

AS_COURSE_SUPPLEMENTAL

AS_FACULTY

AS_GPA_TERM

AS_INSTRUCTIONAL_ASSIGNMENT

AS_OFFERING_PREREQ

AS_RECRUITMENT_SOURCE

AT_LEDGER_ACCOUNTING

AA_MAIL

AG_COMMUNICATION

AP_PAST_EMPLOYMENT

AP_SKILL

AS_ADDRESS

AS_DISABILITY_INFORMATION

AS_HOLD

AS_MEDICAL_INFORMATION

AS_YEAR_TYPE_DEFINITION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_GIFT

AA_MEMBERSHIP_INTEREST

AA_PROSPECT_MOVES_MANAGEMENT

AA_SOLICITOR_ASSIGNMENT

AF_GRANT_FUND

AF_GRANT_FUND

AF_GRANT_FUND

AF_INVOICE_ITEM

AN_PAYROLL_DISTRIBUTION

AN_PERSONNEL_ACTION_LABOR_DIST

AP_BENEFICIARY_DEPENDENT

AP_BENEFIT_DEDUCTION

AP_EMPLOYEE_EARNING_CY

AP_MONTHLY_DEDUCTION

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_PAYROLL_TIMESHEET

AR_FINAID_ENROLLMENT

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AS_ADMINISTRATOR

AS_ADMINISTRATOR

AS_ADMISSIONS_ATTRIBUTE

AS_ADMISSIONS_DECISION

AS_ADVISOR

AS_COURSE_LEVEL

AS_COURSE_PREREQ

AS_COURSE_SUPPLEMENTAL

AS_COURSE_SUPPLEMENTAL

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_FACULTY

AS_FACULTY_CONTRACT

AS_FACULTY_DEPARTMENT_COLLEGE

AS_GPA_LEVEL

AS_NONINSTRUCTIONAL_ASSIGNMENT

AS_NONINSTRUCTIONAL_ASSIGNMENT

AS_NONINSTRUCTIONAL_ASSIGNMENT

AS_OFFERING_COREQ

AS_OFFERING_COREQ

AS_OUTCOME_HONOR_DEPT

AS_RECRUITMENT_COHORT

AS_RECRUITMENT_COHORT

AS_SPORT

AS_SPORT

AS_STUDENT_COURSE_ATTRIBUTE

AS_STUDENT_COURSE_ATTRIBUTE

AS_STUDENT_COURSE_REG_AUDIT

AS_VETERAN_CERTIFICATION

AT_GRANT_ACCOUNT_DETAIL

AT_LEDGER_ACCOUNTING

AT_LEDGER_ACCOUNTING

AT_LEDGER_ACCOUNTING

AR_YEAR_TYPE_DEFINITION

AS_CONTACT

AS_DISABILITY_INFORMATION

AS_DISABILITY_INFORMATION

AS_INSTITUTION

AS_MEDICAL_INFORMATION

AS_MEDICAL_INFORMATION

AS_PREVIOUS_DEGREE

AS_PREVIOUS_EDUCATION_HSCH

AS_PREVIOUS_EDUCATION_HSCH

AS_VISA

AS_YEAR_TYPE_DEFINITION

AA_GIFT_ASSOCIATED_ENTITY

AA_GIFT_MEMO

AA_MEMBERSHIP

AA_PLEDGE_INSTALLMENT

AA_PROJECT_INTEREST

AA_PROSPECT_INFO

AA_PROSPECT_PROPOSAL

AA_SOLICITOR_ASSIGNMENT

AS_COURSE_OFFERING

AS_COURSE_PREREQ

AS_COURSE_SCHEDULE

AS_COURSE_SCHEDULE

AS_ENROLLMENT_HISTORY

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_DEPARTMENT_COLLEGE

AS_FACULTY_FEEDBACK

AS_FIELD_OF_STUDY

AS_OFFERING_GRADE_TYPE

AS_OFFERING_PREREQ

AS_OUTCOME_HONOR_INST

AS_RECRUITMENT_COHORT

AS_SPORT

AS_STUDENT_ATTRIBUTE

AS_STUDENT_COURSE_ATTR_TRANS

AS_STUDENT_COURSE_ATTR_TRANS

AT_LEDGER_ACCOUNTING

AG_GEOGRAPHIC_REGION_INST

AS_INTEREST

AS_PREVIOUS_EDUCATION_PCOL

AS_SECONDARY_SCHOOL_SUBJECT

AS_TELEPHONE

AS_VISA

AA_CONSTITUENT_CONTACT

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_FUNDING_INTEREST

AA_FUNDING_INTEREST

AA_GIFT_SOCIETY

AA_PROJECT_INTEREST

AA_PROSPECT_INFO

AA_PROSPECT_INFO

AA_PROSPECT_PROPOSAL

AA_PROSPECT_PROPOSAL

AF_INVOICE

AF_INVOICE

AF_ORGANIZATION_HIERARCHY

AN_EMPLOYEE_POSITION

AN_PAYROLL_DISTRIBUTION

AP_EMPLOYEE_EARNING_FY

AP_HR_APPLICATION_STATUS

AP_HR_APPLICATION_STATUS

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_TAX

AR_FINAID_ENROLLMENT

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AR_STUDENT_PERIOD_DEFINITION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_DECISION

AS_ADMISSIONS_SOURCE

AS_COURSE_COREQ

AS_COURSE_SCHEDULE

AS_COURSE_SUPPLEMENTAL

AS_FACULTY

AS_GPA_TERM

AS_INSTRUCTIONAL_ASSIGNMENT

AS_OFFERING_PREREQ

AS_RECRUITMENT_SOURCE

AT_LEDGER_ACCOUNTING

AA_MAIL

AG_COMMUNICATION

AP_PAST_EMPLOYMENT

AP_SKILL

AS_ADDRESS

AS_DISABILITY_INFORMATION

AS_HOLD

AS_MEDICAL_INFORMATION

AS_YEAR_TYPE_DEFINITION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_DESIGNATION

AA_GIFT

AA_MEMBERSHIP_INTEREST

AA_PROSPECT_MOVES_MANAGEMENT

AA_SOLICITOR_ASSIGNMENT

AF_GRANT_FUND

AF_GRANT_FUND

AF_GRANT_FUND

AF_INVOICE_ITEM

AN_PAYROLL_DISTRIBUTION

AN_PERSONNEL_ACTION_LABOR_DIST

AP_BENEFICIARY_DEPENDENT

AP_BENEFIT_DEDUCTION

AP_EMPLOYEE_EARNING_CY

AP_MONTHLY_DEDUCTION

AP_PAYROLL_LABOR_DIST_OVERRIDE

AP_PAYROLL_TIMESHEET

AR_FINAID_ENROLLMENT

AR_LOAN_AGGREGATES

AR_LOAN_AGGREGATES

AS_ADMINISTRATOR

AS_ADMINISTRATOR

AS_ADMISSIONS_ATTRIBUTE

AS_ADMISSIONS_DECISION

AS_ADVISOR

AS_COURSE_LEVEL

AS_COURSE_PREREQ

AS_COURSE_SUPPLEMENTAL

AS_COURSE_SUPPLEMENTAL

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_FACULTY

AS_FACULTY_CONTRACT

AS_FACULTY_DEPARTMENT_COLLEGE

AS_GPA_LEVEL

AS_NONINSTRUCTIONAL_ASSIGNMENT

AS_NONINSTRUCTIONAL_ASSIGNMENT

AS_NONINSTRUCTIONAL_ASSIGNMENT

AS_OFFERING_COREQ

AS_OFFERING_COREQ

AS_OUTCOME_HONOR_DEPT

AS_RECRUITMENT_COHORT

AS_RECRUITMENT_COHORT

AS_SPORT

AS_SPORT

AS_STUDENT_COURSE_ATTRIBUTE

AS_STUDENT_COURSE_ATTRIBUTE

AS_STUDENT_COURSE_REG_AUDIT

AS_VETERAN_CERTIFICATION

AT_GRANT_ACCOUNT_DETAIL

AT_LEDGER_ACCOUNTING

AT_LEDGER_ACCOUNTING

AT_LEDGER_ACCOUNTING

AR_YEAR_TYPE_DEFINITION

AS_CONTACT

AS_DISABILITY_INFORMATION

AS_DISABILITY_INFORMATION

AS_INSTITUTION

AS_MEDICAL_INFORMATION

AS_MEDICAL_INFORMATION

AS_PREVIOUS_DEGREE

AS_PREVIOUS_EDUCATION_HSCH

AS_PREVIOUS_EDUCATION_HSCH

AS_VISA

AS_YEAR_TYPE_DEFINITION

AA_GIFT_ASSOCIATED_ENTITY

AA_GIFT_MEMO

AA_MEMBERSHIP

AA_PLEDGE_INSTALLMENT

AA_PROJECT_INTEREST

AA_PROSPECT_INFO

AA_PROSPECT_PROPOSAL

AA_SOLICITOR_ASSIGNMENT

AA_SOLICITOR_ORGANIZATION

AF_INVOICE

AF_PURCHASE_ORDER_ITEM

AN_EMPLOYEE_POSITION

AN_PAYROLL_DISTRIBUTION

AP_PAYROLL_ATTENDANCE

AR_AWARD_BY_AID_YEAR

(More Targets -- list too long to display currently.)

AA_CONSTITUENT_CONTACT

(More Targets -- list too long to display currently.)

AA_CONSTITUENT_CONTACT

(More Targets -- list too long to display currently.)

T TING_COMP_target.html#ACADEMIC_PERIOD_DESC">ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR_DESC

REQUIREMENT_DESC

ACADEMIC_PERIOD_END_DESC

SUBJECT_DESC

TAXONOMY_OF_PROGRAM_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

SUBJECT_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

CURRENT_TIME_STATUS_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

OUTCOME_DESC

ACADEMIC_YEAR_DESC

ACTIVITY_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

A_RULE_CLASS_DESC1

GEOGRAPHIC_DIVISION_DESC

INTEREST_DESC

AWARD_CATEGORY_DESC

SUBJECT_DESC

PHONE_ADDRESS_TYPE_DESC

VISA_ISSUING_NATION_DESC

CONTACT_DATE_FISCAL_YEAR_DESC

EXPEND_CHART_OF_ACCOUNTS_DESC

EXPEND_FUND_DESC

GIFT_FUND_DESC

GIFT_LOCATION_DESC

TING_COMP_target.html#ACADEMIC_PERIOD_DESC">ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR_DESC

REQUIREMENT_DESC

ACADEMIC_PERIOD_END_DESC

SUBJECT_DESC

TAXONOMY_OF_PROGRAM_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

SUBJECT_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

CURRENT_TIME_STATUS_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

OUTCOME_DESC

ACADEMIC_YEAR_DESC

ACTIVITY_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

A_RULE_CLASS_DESC1

GEOGRAPHIC_DIVISION_DESC

INTEREST_DESC

AWARD_CATEGORY_DESC

SUBJECT_DESC

PHONE_ADDRESS_TYPE_DESC

VISA_ISSUING_NATION_DESC

CONTACT_DATE_FISCAL_YEAR_DESC

EXPEND_CHART_OF_ACCOUNTS_DESC

EXPEND_FUND_DESC

GIFT_FUND_DESC

GIFT_LOCATION_DESC

PAYMENT_PROGRAM_DESC

GIVING_VEHICLE_DESC

PROJECT_STATUS_DESC

GIFT_SOCIETY_END_YEAR_DESC

GIVING_VEHICLE_DESC

PREF_GEO_REGION_ADDR_TYPE_DESC

PRIMARY_STAFF_ASSIGN_IDEN_DESC

PROPOSAL_PROJECT_DESC

PROPOSAL_STATUS_DESC

REMIT_TO_ADDRESS_TYPE_DESC

REMIT_TO_STATE_PROVINCE_DESC

FMGR_ADDRESS_TYPE_DESC

LEAVE_REPORT_ENTRY_METHOD_DESC

COST_TYPE_DESC

EMPLOYER_DESC

POSITION_CLASS_DESC

STATUS_DESC

COST_TYPE_SHORT_DESC

TIMESHEET_CHART_DESC

TAX_DEDUCTION_LONG_DESC

AID_YEAR_DESC

ACG_OVERPAYMENT_DESC

LOAN_REPAYMENT_CHANGE_DESC

PERKINS_OVERPAYMENT_DESC

SMART_PAYMENT_CHANGE_DESC

SUBSIDIZED_LOAN_LIMIT_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

RESIDENCY_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

ACADEMIC_PERIOD_END_DESC

SCHEDULE_DESCACADEMIC_PERIOD_DESC

ACADEMIC_YEAR_DESC

REQUIREMENT_DESC

ACADEMIC_PERIOD_END_DESC

SUBJECT_DESC

TAXONOMY_OF_PROGRAM_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

SUBJECT_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

CURRENT_TIME_STATUS_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

OUTCOME_DESC

ACADEMIC_YEAR_DESC

ACTIVITY_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

A_RULE_CLASS_DESC1

GEOGRAPHIC_DIVISION_DESC

INTEREST_DESC

AWARD_CATEGORY_DESC

SUBJECT_DESC

PHONE_ADDRESS_TYPE_DESC

VISA_ISSUING_NATION_DESC

CONTACT_DATE_FISCAL_YEAR_DESC

EXPEND_CHART_OF_ACCOUNTS_DESC

EXPEND_FUND_DESC

GIFT_FUND_DESC

GIFT_LOCATION_DESC

PAYMENT_PROGRAM_DESC

GIVING_VEHICLE_DESC

PROJECT_STATUS_DESC

GIFT_SOCIETY_END_YEAR_DESC

GIVING_VEHICLE_DESC

PREF_GEO_REGION_ADDR_TYPE_DESC

PRIMARY_STAFF_ASSIGN_IDEN_DESC

PROPOSAL_PROJECT_DESC

PROPOSAL_STATUS_DESC

REMIT_TO_ADDRESS_TYPE_DESC

REMIT_TO_STATE_PROVINCE_DESC

FMGR_ADDRESS_TYPE_DESC

LEAVE_REPORT_ENTRY_METHOD_DESC

COST_TYPE_DESC

EMPLOYER_DESC

POSITION_CLASS_DESC

STATUS_DESC

COST_TYPE_SHORT_DESC

TIMESHEET_CHART_DESC

TAX_DEDUCTION_LONG_DESC

AID_YEAR_DESC

ACG_OVERPAYMENT_DESC

LOAN_REPAYMENT_CHANGE_DESC

PERKINS_OVERPAYMENT_DESC

SMART_PAYMENT_CHANGE_DESC

SUBSIDIZED_LOAN_LIMIT_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

RESIDENCY_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

ACADEMIC_PERIOD_END_DESC

SCHEDULE_DESC

ACADEMIC_PERIOD_END_DESC

CONTRACT_RULE_DESC

ACADEMIC_STUDY_VALUE_DESC

ACADEMIC_YEAR_DESC

LEVEL_DESC

ACADEMIC_YEAR_DESC

B_CHART_OF_ACCOUNTS_DESC

MAIL_DESC

AID_YEAR_DESC

NATION_DESC

SKILL_DESC

ENRL_PLANNING_SERVICE_DESC

MEDICAL_TYPE_DESC

HOLD_ORIGINATING_OFFICE_DESC

MEDICAL_EQUIPMENT_TYPE_DESC

ACADEMIC_PERIOD_DESC

EXPEND_ACCOUNT_DESC

GIFT_ACCOUNT_DESC

PAYMENT_ACCOUNT_INDEX_DESC

PAYMENT_ORGRANIZATION_DESC

PLEDGE_ACTIVITY_DESC

PLEDGE_PROGRAM_DESC

GIFT_RULE_CLASS_DESC

INTEREST_COLLEGE_DESC

START_DATE_FISCAL_YEAR_DESC

SOLICITATION_TYPE_DESC

FUND_COST_SHARE_BASE_DESC

FUND_COST_SHARE_DISTRIB_DESC

FUND_INDIRECT_COST_BASE_DESC

COMMODITY_DESC

SOURCE_DESC

CHART_OF_ACCOUNTS_DESC

CARRIER_SHORT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR_DESC

REQUIREMENT_DESC

ACADEMIC_PERIOD_END_DESC

SUBJECT_DESC

TAXONOMY_OF_PROGRAM_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

SUBJECT_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

CURRENT_TIME_STATUS_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

OUTCOME_DESC

ACADEMIC_YEAR_DESC

ACTIVITY_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

A_RULE_CLASS_DESC1

GEOGRAPHIC_DIVISION_DESC

INTEREST_DESC

AWARD_CATEGORY_DESC

SUBJECT_DESC

PHONE_ADDRESS_TYPE_DESC

VISA_ISSUING_NATION_DESC

CONTACT_DATE_FISCAL_YEAR_DESC

EXPEND_CHART_OF_ACCOUNTS_DESC

EXPEND_FUND_DESC

GIFT_FUND_DESC

GIFT_LOCATION_DESC

PAYMENT_PROGRAM_DESC

GIVING_VEHICLE_DESC

PROJECT_STATUS_DESC

GIFT_SOCIETY_END_YEAR_DESC

GIVING_VEHICLE_DESC

PREF_GEO_REGION_ADDR_TYPE_DESC

PRIMARY_STAFF_ASSIGN_IDEN_DESC

PROPOSAL_PROJECT_DESC

PROPOSAL_STATUS_DESC

REMIT_TO_ADDRESS_TYPE_DESC

REMIT_TO_STATE_PROVINCE_DESC

FMGR_ADDRESS_TYPE_DESC

LEAVE_REPORT_ENTRY_METHOD_DESC

COST_TYPE_DESC

EMPLOYER_DESC

POSITION_CLASS_DESC

STATUS_DESC

COST_TYPE_SHORT_DESC

TIMESHEET_CHART_DESC

TAX_DEDUCTION_LONG_DESC

AID_YEAR_DESC

ACG_OVERPAYMENT_DESC

LOAN_REPAYMENT_CHANGE_DESC

PERKINS_OVERPAYMENT_DESC

SMART_PAYMENT_CHANGE_DESC

SUBSIDIZED_LOAN_LIMIT_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

RESIDENCY_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

ACADEMIC_PERIOD_END_DESC

SCHEDULE_DESC

ACADEMIC_PERIOD_END_DESC

CONTRACT_RULE_DESC

ACADEMIC_STUDY_VALUE_DESC

ACADEMIC_YEAR_DESC

LEVEL_DESC

ACADEMIC_YEAR_DESC

B_CHART_OF_ACCOUNTS_DESC

MAIL_DESC

AID_YEAR_DESC

NATION_DESC

SKILL_DESC

ENRL_PLANNING_SERVICE_DESC

MEDICAL_TYPE_DESC

HOLD_ORIGINATING_OFFICE_DESC

MEDICAL_EQUIPMENT_TYPE_DESC

ACADEMIC_PERIOD_DESC

EXPEND_ACCOUNT_DESC

GIFT_ACCOUNT_DESC

PAYMENT_ACCOUNT_INDEX_DESC

PAYMENT_ORGRANIZATION_DESC

PLEDGE_ACTIVITY_DESC

PLEDGE_PROGRAM_DESC

GIFT_RULE_CLASS_DESC

INTEREST_COLLEGE_DESC

START_DATE_FISCAL_YEAR_DESC

SOLICITATION_TYPE_DESC

FUND_COST_SHARE_BASE_DESC

FUND_COST_SHARE_DISTRIB_DESC

FUND_INDIRECT_COST_BASE_DESC

COMMODITY_DESC

SOURCE_DESC

CHART_OF_ACCOUNTS_DESC

CARRIER_SHORT_DESC

BENEFIT_DEDUCTION_TYPE_DESC

EARNINGS_DESC

CARRIER_LONG_DESC

COST_TYPE_LONG_DESC

PAYROLL_IDENTIFIER_DESC

ACADEMIC_PERIOD_DESC

DIRECT_LOAN_MPN_DESC

SEOG_OVERPAYMENT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

ADMISSIONS_ATTRIBUTE_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_END_DESC

OCCUPATIONAL_COURSE_DESC

TAXONOMY_OF_PROGRAM_DESC

DEANS_LIST_DESC

TRANSFER_TO_INSTITUTION_DESC

FACULTY_MEMBER_CATEGORY_DESC

CONTRACT_TYPE_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_STUDY_VALUE_DESC

ACADEMIC_YEAR_DESC

COLLEGE_DESC

DEPARTMENT_DESC

COREQ_SUBJECT_DESC

SUBJECT_DESC

HONOR_DESC

ACADEMIC_PERIOD_START_DESC

COHORT_DESC

ACTIVITY_TYPE_DESC

ELIGIBILITY_DESC

SUBJECT_DESCACADEMIC_PERIOD_DESC

ACADEMIC_YEAR_DESC

REQUIREMENT_DESC

ACADEMIC_PERIOD_END_DESC

SUBJECT_DESC

TAXONOMY_OF_PROGRAM_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

SUBJECT_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

CURRENT_TIME_STATUS_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

OUTCOME_DESC

ACADEMIC_YEAR_DESC

ACTIVITY_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

A_RULE_CLASS_DESC1

GEOGRAPHIC_DIVISION_DESC

INTEREST_DESC

AWARD_CATEGORY_DESC

SUBJECT_DESC

PHONE_ADDRESS_TYPE_DESC

VISA_ISSUING_NATION_DESC

CONTACT_DATE_FISCAL_YEAR_DESC

EXPEND_CHART_OF_ACCOUNTS_DESC

EXPEND_FUND_DESC

GIFT_FUND_DESC

GIFT_LOCATION_DESC

PAYMENT_PROGRAM_DESC

GIVING_VEHICLE_DESC

PROJECT_STATUS_DESC

GIFT_SOCIETY_END_YEAR_DESC

GIVING_VEHICLE_DESC

PREF_GEO_REGION_ADDR_TYPE_DESC

PRIMARY_STAFF_ASSIGN_IDEN_DESC

PROPOSAL_PROJECT_DESC

PROPOSAL_STATUS_DESC

REMIT_TO_ADDRESS_TYPE_DESC

REMIT_TO_STATE_PROVINCE_DESC

FMGR_ADDRESS_TYPE_DESC

LEAVE_REPORT_ENTRY_METHOD_DESC

COST_TYPE_DESC

EMPLOYER_DESC

POSITION_CLASS_DESC

STATUS_DESC

COST_TYPE_SHORT_DESC

TIMESHEET_CHART_DESC

TAX_DEDUCTION_LONG_DESC

AID_YEAR_DESC

ACG_OVERPAYMENT_DESC

LOAN_REPAYMENT_CHANGE_DESC

PERKINS_OVERPAYMENT_DESC

SMART_PAYMENT_CHANGE_DESC

SUBSIDIZED_LOAN_LIMIT_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

RESIDENCY_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

ACADEMIC_PERIOD_END_DESC

SCHEDULE_DESC

ACADEMIC_PERIOD_END_DESC

CONTRACT_RULE_DESC

ACADEMIC_STUDY_VALUE_DESC

ACADEMIC_YEAR_DESC

LEVEL_DESC

ACADEMIC_YEAR_DESC

B_CHART_OF_ACCOUNTS_DESC

MAIL_DESC

AID_YEAR_DESC

NATION_DESC

SKILL_DESC

ENRL_PLANNING_SERVICE_DESC

MEDICAL_TYPE_DESC

HOLD_ORIGINATING_OFFICE_DESC

MEDICAL_EQUIPMENT_TYPE_DESC

ACADEMIC_PERIOD_DESC

EXPEND_ACCOUNT_DESC

GIFT_ACCOUNT_DESC

PAYMENT_ACCOUNT_INDEX_DESC

PAYMENT_ORGRANIZATION_DESC

PLEDGE_ACTIVITY_DESC

PLEDGE_PROGRAM_DESC

GIFT_RULE_CLASS_DESC

INTEREST_COLLEGE_DESC

START_DATE_FISCAL_YEAR_DESC

SOLICITATION_TYPE_DESC

FUND_COST_SHARE_BASE_DESC

FUND_COST_SHARE_DISTRIB_DESC

FUND_INDIRECT_COST_BASE_DESC

COMMODITY_DESC

SOURCE_DESC

CHART_OF_ACCOUNTS_DESC

CARRIER_SHORT_DESC

BENEFIT_DEDUCTION_TYPE_DESC

EARNINGS_DESC

CARRIER_LONG_DESC

COST_TYPE_LONG_DESC

PAYROLL_IDENTIFIER_DESC

ACADEMIC_PERIOD_DESC

DIRECT_LOAN_MPN_DESC

SEOG_OVERPAYMENT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

ADMISSIONS_ATTRIBUTE_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_END_DESC

OCCUPATIONAL_COURSE_DESC

TAXONOMY_OF_PROGRAM_DESC

DEANS_LIST_DESC

TRANSFER_TO_INSTITUTION_DESC

FACULTY_MEMBER_CATEGORY_DESC

CONTRACT_TYPE_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_STUDY_VALUE_DESC

ACADEMIC_YEAR_DESC

COLLEGE_DESC

DEPARTMENT_DESC

COREQ_SUBJECT_DESC

SUBJECT_DESC

HONOR_DESC

ACADEMIC_PERIOD_START_DESC

COHORT_DESC

ACTIVITY_TYPE_DESC

ELIGIBILITY_DESC

SUBJECT_DESC

SUB_ACADEMIC_PERIOD_DESC

REGISTRATION_STATUS_DESC

VETERAN_TYPE_DESC

SOURCE_DESC

A_ACCOUNT_DESC

A_ACCOUNT_INDEX_DESC

A_LOCATION_DESC

AID_PERIOD_DESC

APPOINTMENT_RECRUITER_DESC

ACADEMIC_PERIOD_DESC

DISABILITY_SERVICES_DESC

EPS_DESC

DISABILITY_DESC

DISABILITY_SERVICES_DESC

AWARD_CATEGORY_DESC

INSTITUTION_DESC

SECONDARY_DIPLOMA_DESC

POINT_OF_ENTRY_DESC

YEAR_CODE_DESC

ASSOCIATED_ADDRESS_TYPE_DESC

FISCAL_YEAR_DESC

MEMBERSHIP_PROG_TYPE_DESC

PLEDGE_DURATION_DESC

PROJECT_STATUS_DESC

REFERENCE_DESC

PROPOSAL_DESC

SOLICITOR_ORGANIZATION_NAME

COLLEGE_DESC

REMIT_TO_NATION_DESC

COMMODITY_DESC

CHART_OF_ACCOUNTS_DESC

CATEGORY_DESC

TIMESHEET_ORGANIZATION_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR_DESC

REQUIREMENT_DESC

ACADEMIC_PERIOD_END_DESC

SUBJECT_DESC

TAXONOMY_OF_PROGRAM_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

SUBJECT_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

CURRENT_TIME_STATUS_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

OUTCOME_DESC

ACADEMIC_YEAR_DESC

ACTIVITY_DESC

ACADEMIC_PERIOD_END_DESC

ACADEMIC_YEAR_DESC

SUBJECT_DESC

A_RULE_CLASS_DESC1

GEOGRAPHIC_DIVISION_DESC

INTEREST_DESC

AWARD_CATEGORY_DESC

SUBJECT_DESC

PHONE_ADDRESS_TYPE_DESC

VISA_ISSUING_NATION_DESC

CONTACT_DATE_FISCAL_YEAR_DESC

EXPEND_CHART_OF_ACCOUNTS_DESC

EXPEND_FUND_DESC

GIFT_FUND_DESC

GIFT_LOCATION_DESC

PAYMENT_PROGRAM_DESC

GIVING_VEHICLE_DESC

PROJECT_STATUS_DESC

GIFT_SOCIETY_END_YEAR_DESC

GIVING_VEHICLE_DESC

PREF_GEO_REGION_ADDR_TYPE_DESC

PRIMARY_STAFF_ASSIGN_IDEN_DESC

PROPOSAL_PROJECT_DESC

PROPOSAL_STATUS_DESC

REMIT_TO_ADDRESS_TYPE_DESC

REMIT_TO_STATE_PROVINCE_DESC

FMGR_ADDRESS_TYPE_DESC

LEAVE_REPORT_ENTRY_METHOD_DESC

COST_TYPE_DESC

EMPLOYER_DESC

POSITION_CLASS_DESC

STATUS_DESC

COST_TYPE_SHORT_DESC

TIMESHEET_CHART_DESC

TAX_DEDUCTION_LONG_DESC

AID_YEAR_DESC

ACG_OVERPAYMENT_DESC

LOAN_REPAYMENT_CHANGE_DESC

PERKINS_OVERPAYMENT_DESC

SMART_PAYMENT_CHANGE_DESC

SUBSIDIZED_LOAN_LIMIT_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR_DESC

RESIDENCY_DESC

ACADEMIC_YEAR_DESC

ACADEMIC_YEAR

ACADEMIC_PERIOD_END_DESC

SCHEDULE_DESC

ACADEMIC_PERIOD_END_DESC

CONTRACT_RULE_DESC

ACADEMIC_STUDY_VALUE_DESC

ACADEMIC_YEAR_DESC

LEVEL_DESC

ACADEMIC_YEAR_DESC

B_CHART_OF_ACCOUNTS_DESC

MAIL_DESC

AID_YEAR_DESC

NATION_DESC

SKILL_DESC

ENRL_PLANNING_SERVICE_DESC

MEDICAL_TYPE_DESC

HOLD_ORIGINATING_OFFICE_DESC

MEDICAL_EQUIPMENT_TYPE_DESC

ACADEMIC_PERIOD_DESC

EXPEND_ACCOUNT_DESC

GIFT_ACCOUNT_DESC

PAYMENT_ACCOUNT_INDEX_DESC

PAYMENT_ORGRANIZATION_DESC

PLEDGE_ACTIVITY_DESC

PLEDGE_PROGRAM_DESC

GIFT_RULE_CLASS_DESC

INTEREST_COLLEGE_DESC

START_DATE_FISCAL_YEAR_DESC

SOLICITATION_TYPE_DESC

FUND_COST_SHARE_BASE_DESC

FUND_COST_SHARE_DISTRIB_DESC

FUND_INDIRECT_COST_BASE_DESC

COMMODITY_DESC

SOURCE_DESC

CHART_OF_ACCOUNTS_DESC

CARRIER_SHORT_DESC

BENEFIT_DEDUCTION_TYPE_DESC

EARNINGS_DESC

CARRIER_LONG_DESC

COST_TYPE_LONG_DESC

PAYROLL_IDENTIFIER_DESC

ACADEMIC_PERIOD_DESC

DIRECT_LOAN_MPN_DESC

SEOG_OVERPAYMENT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

ADMISSIONS_ATTRIBUTE_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_PERIOD_END_DESC

OCCUPATIONAL_COURSE_DESC

TAXONOMY_OF_PROGRAM_DESC

DEANS_LIST_DESC

TRANSFER_TO_INSTITUTION_DESC

FACULTY_MEMBER_CATEGORY_DESC

CONTRACT_TYPE_DESC

ACADEMIC_PERIOD_START_DESC

ACADEMIC_STUDY_VALUE_DESC

ACADEMIC_YEAR_DESC

COLLEGE_DESC

DEPARTMENT_DESC

COREQ_SUBJECT_DESC

SUBJECT_DESC

HONOR_DESC

ACADEMIC_PERIOD_START_DESC

COHORT_DESC

ACTIVITY_TYPE_DESC

ELIGIBILITY_DESC

SUBJECT_DESC

SUB_ACADEMIC_PERIOD_DESC

REGISTRATION_STATUS_DESC

VETERAN_TYPE_DESC

SOURCE_DESC

A_ACCOUNT_DESC

A_ACCOUNT_INDEX_DESC

A_LOCATION_DESC

AID_PERIOD_DESC

APPOINTMENT_RECRUITER_DESC

ACADEMIC_PERIOD_DESC

DISABILITY_SERVICES_DESC

EPS_DESC

DISABILITY_DESC

DISABILITY_SERVICES_DESC

AWARD_CATEGORY_DESC

INSTITUTION_DESC

SECONDARY_DIPLOMA_DESC

POINT_OF_ENTRY_DESC

YEAR_CODE_DESC

ASSOCIATED_ADDRESS_TYPE_DESC

FISCAL_YEAR_DESC

MEMBERSHIP_PROG_TYPE_DESC

PLEDGE_DURATION_DESC

PROJECT_STATUS_DESC

REFERENCE_DESC

PROPOSAL_DESC

SOLICITOR_ORGANIZATION_NAME

COLLEGE_DESC

REMIT_TO_NATION_DESC

COMMODITY_DESC

CHART_OF_ACCOUNTS_DESC

CATEGORY_DESC

TIMESHEET_ORGANIZATION_DESC

SYSTEM_IND_DESC

(More Target Columns -- list too long to display currently.)

START_DATE_FISCAL_YEAR_DESC

(More Target Columns -- list too long to display currently.)

START_DATE_FISCAL_YEAR_DESC

(More Target Columns -- list too long to display currently.)

This function returns the description field for the specified validation table for the specified code from the validation table.
GOKODSF.F_GET_DESC(CASE WHEN FTVVEND_VEND_CHECK_PIDM IS NULL)        
GOKODSF.F_GET_NULL_VARCHAR2  

AS_DISABILITY_INFORMATION

AS_DISABILITY_INFORMATION

SUB_ACADEMIC_PERIOD_DESC

SUB_ACADEMIC_PERIOD

NA
GOKODSF.F_GET_PREFERRED_DATA        
GOKODSF.F_GURMAIL_MODULE_CODE_DESC       NA
GOKODSF.F_PREFERRED_ADDRESS_IND  

AS_ADDRESS

PREFERRED_ADDRESS_IND

This function retrieves the a 'Y' if the address type being passed matches the address type set up in the GTVSDAX tablewith an internal code of 'PREFADDR' and an internal code group od 'ADDRESS'.
GOKODSF.F_TRIM_LONGS  

AG_EVENT_INVITEE

AA_PREVIOUS_EMPLOYMENT

AA_DESIGNATION_COMMENT

AA_PLEDGE_AUXILIARY

AA_CON_ENTITY_CONF_COMMENT

AA_PLEDGE_CONDITIONAL

AA_PROSPECT_CONF_COMMENT

INVITEE_COMMENT

EMPLOYER_COMMENT

DESIGNATION_COMMENT

AUXILIARY_COMMENT

CONSTITUENT_COMMENT

CONDITION_COMMENT

PROSPECT_COMMENT

NA
IF ADV_GIFT_REC.ACTIVE_CONSTITUENT_TMP ='Y' AND PERS_DEMO_REC.DECEASED_IND ='Y' THEN RET_ROW.ACTIVE_CONSTITUENT_IND :='N'; ELSE RET_ROW.ACTIVE_CONSTITUENT_IND := ADV_GIFT_REC.ACTIVE_CONSTITUENT_TMP; END IF        
IF STUDENT_COURSE_REC.COURSE_REGISTER_IND ='Y' THEN RET_ROW.COURSE_REGISTERED_HEADCOUNT := STUDENT_COURSE_REC.WAREHOUSE_ENTITY_UID        
LISTAGG (ACTIVITY, '-')        
LISTAGG (ACTIVITY_DESC, '-')        
LISTAGG (ADVISOR_NAME_LFMI, '-')        
LISTAGG (BLOCK_REGISTRATION, '-')        
LISTAGG (BLOCK_REGISTRATION_DESC, '-')        
LISTAGG (COHORT, '-')        
LISTAGG (COHORT_DESC, '-')        
LISTAGG (HOLD, '-')        
LISTAGG (HOLD_DESC, '-')        
LISTAGG (HOLD_ORIGINATING_OFFICE, '-')        
LISTAGG (HOLD_ORIGINATING_OFFICE_DESC, '-')        
LISTAGG (STUDENT_ATTRIBUTE, '-')        
LISTAGG (STUDENT_ATTRIBUTE_DESC, '-')        
LOAD_MGT_CALENDAR_DATE        
MAKFUNC.F_ADVANCEMENT_RATING_COUNT       This function retrieves a count of advancement ratings associated with a person.
MAKFUNC.F_CAMP_EXPENSES        
MAKFUNC.F_CAMP_MATCH_GIFTS_ANTICIPATED        
MAKFUNC.F_CAMP_MATCH_GIFTS_PAID        
MAKFUNC.F_CAMP_PLEDGE_COUNT        
MAKFUNC.F_CAMP_PLEDGE_DONOR_COUNT        
MAKFUNC.F_CAMP_PLEDGE_PAYMENTS        
MAKFUNC.F_CAMP_SOL_OUTRIGHT_GC_COUNT       This function counts the total number of outright gifts made to this campaign solicitor combination.
MAKFUNC.F_CAMP_SOL_OUTRIGHT_GD_COUNT        
MAKFUNC.F_CAMP_SOL_OUTRIGHT_GIFTS        
MAKFUNC.F_CAMP_SOL_PD_NP_COUNT        
MAKFUNC.F_CAMP_SOL_PD_PAID_COUNT        
MAKFUNC.F_CAMP_SOL_PLEDGE_COUNT        
MAKFUNC.F_CAMP_SOL_PLEDGE_DONOR_COUNT        
MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS        
MAKFUNC.F_CAMP_SOL_TOTAL_DONOR_COUNT        
MAKFUNC.F_CAMP_SOL_TOTAL_GIFTS        
MAKFUNC.F_CAMP_SOL_TOTAL_GIFT_COUNT       This function counts the total number of gifts made to this campaign solicitor combination.
MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES        
MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES - MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS        
MAKFUNC.F_CAMP_TOTAL_DONOR_COUNT        
MAKFUNC.F_CAMP_TOTAL_GIFTS        
MAKFUNC.F_CAMP_TOTAL_GIFT_COUNT       Calculate the total gift count for a given campaign.
MAKFUNC.F_CAMP_TOTAL_PLEDGES        
MAKFUNC.F_COUNT_ADVANCEMENT_RATING       This function returns a count of the MAT_ADVANCEMENT_RATING records for the parameter supplied UID. In addition, an optional parameter can be provided to return a sub-count of the ratings are either internal (from the AMRPRRT) or external (from AMREXRT).
MAKFUNC.F_COUNT_CONS_CONTACT       This function returns a count of the MAT_CONSTITUENT_CONTACT records for the parameter supplied UID.
MAKFUNC.F_COUNT_DEGREES       This function returns a count of the MAT_DEGREE records for the parameter supplied UID.
MAKFUNC.F_COUNT_DONOR_CATEGORY       This function returns a count of the MAT_DONOR_CATEGORY records for the parameter supplied UID.
MAKFUNC.F_COUNT_EXCLUSION       This function returns a count of the MAT_EXCLUSION records for the parameter supplied UID.
MAKFUNC.F_COUNT_FUNDING_INT       This function returns a count of the MAT_FUNDING_INTEREST records for the parameter supplied UID.
MAKFUNC.F_COUNT_GIFT_ASSOCIATED_ENTITY       NA
MAKFUNC.F_COUNT_GIFT_AUXILIARY       This function returns a count of the MAT_GIFT_AUXILIARY records for the parameter supplied UID and Gift Number.
MAKFUNC.F_COUNT_GIFT_SOCIETY       This function retrieves a count of gift societies with whom a particular identification is associated for a specified year.
MAKFUNC.F_COUNT_GIFT_SOLICITOR       This function returns a distinct count of all MAT_GIFT_SOCIETY records for the parameter supplied UID where either the parameter Gift year matches or the lifetime gift society indicator = Y.
MAKFUNC.F_COUNT_MAIL       This function returns a count of the MAT_MAIL records for the parameter supplied UID.
MAKFUNC.F_COUNT_MATCH_GIFT       This function returns a count of the MAT_GIFT_MATCHING records for the parameter supplied UID and Gift Number.
MAKFUNC.F_COUNT_MATCH_PLEDGE       This function returns a count of the MAT_PLEDGE_MATCHING records for the parameter supplied UID and Pledge Number.
MAKFUNC.F_COUNT_ORGN_CONTACT       This function returns a count of the MAT_ORGANIZATION_CONTACT records for the parameter supplied UID.
MAKFUNC.F_COUNT_PLEDGE_SOLICITOR       This function returns a count of the MAT_SOLICITOR records for the parameter supplied UID and Pledge Number where the Gift Pledge Indicator = P.
MAKFUNC.F_COUNT_PREV_EMPLOYMENT       This function returns a count of the MAT_previous_employment records for the parameter supplied UID.
MAKFUNC.F_COUNT_RELATION       This function returns a count of the MAT_RELATION records for the parameter supplied UID and Relation Type Indicator.
MAKFUNC.F_COUNT_SPECIAL_ACTIVITY       This function returns a count of the MAT_SPECIAL_ACTIVITY records for the parameter supplied UID.
MAKFUNC.F_COUNT_SPECIAL_PURP       This function returns a count of the MAT_SPECIAL_PURPOSE_GROUP records for the parameter supplied UID.
MAKFUNC.F_COUNT_STAFF_ASSIGNMENT       This function returns a count of the number of MAT_CONSTITUENT_STAFF_ASSIGN records for the parameter supplied UID.
MAKFUNC.F_DESG_CAMP_GIFT_COUNT       Calculates the total number of gifts for a given campaign's designation.
MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS        
MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS        
MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES        
MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED        
MAKFUNC.F_DESG_MATCH_GIFTS_PAID        
MAKFUNC.F_DESG_OUTRIGHT_GIFTS        
MAKFUNC.F_DESG_OUTRIGHT_GIFT_COUNT        
MAKFUNC.F_DESG_OUTRIGHT_GIFT_DONOR_CNT        
MAKFUNC.F_DESG_PLEDGE_BALANCE        
MAKFUNC.F_DESG_PLEDGE_COUNT        
MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT        
MAKFUNC.F_DESG_PLEDGE_DONOR_NO_PAY_CNT        
MAKFUNC.F_DESG_PLEDGE_DONOR_PAID_COUNT        
MAKFUNC.F_DESG_PLEDGE_PAYMENT        
MAKFUNC.F_DESG_TOTAL_DONOR_COUNT        
MAKFUNC.F_DESG_TOTAL_GIFTS        
MAKFUNC.F_DESG_TOTAL_GIFT_COUNT        
MAKFUNC.F_DESG_TOTAL_PLEDGES        
MAKFUNC.F_GET_ENTITY_IND        
MAKFUNC.F_GET_PERSON_INFO        
MAKFUNC.F_GET_PLEDGE_INSTALL_IND       SUBSTR(MAKFUNC.F_GET_PLEDGE_INSTALL_IND(MAT_PLEDGE.ENTITY_UID, PLEDGE_NUMBER),1,1)
MAKFUNC.F_GET_PROP_ACTIVE_PROJ_AMOUNT        
MAKFUNC.F_GET_PROP_ACTIVE_PROJ_COUNT        
MAKFUNC.F_GET_SPOUSE_IND       Returns a Y/N indicator for active spouses with whom a particular ID is associated.
MAKFUNC.F_GET_SPOUSE_NAME Returns the spouses name LFM.     SUBSTR(MAKFUNC.F_GET_SPOUSE_NAME(C.ENTITY_UID),1,100),
MAKFUNC.F_ORG_OUTRIGHT_DONOR_COUNT        
MAKFUNC.F_ORG_OUTRIGHT_GIFTS        
MAKFUNC.F_ORG_OUTRIGHT_GIFT_COUNT        
MAKFUNC.F_ORG_PLEDGE_COUNT        
MAKFUNC.F_ORG_PLEDGE_DONOR_COUNT        
MAKFUNC.F_ORG_PLEDGE_DONOR_NP_COUNT       Function returns the number of constituents that have not paid toward their pledge for this solicitor organization.
MAKFUNC.F_ORG_PLEDGE_PAYMENTS        
MAKFUNC.F_ORG_TOTAL_DONOR_COUNT        
MAKFUNC.F_ORG_TOTAL_GIFTS        
MAKFUNC.F_ORG_TOTAL_GIFT_COUNT        
MAKFUNC.F_ORG_TOTAL_PLEDGES        
MAKFUNC.F_PROPOSAL_RESULT_EXISTS        
MAKFUNC.F_SOLG_CAMP_GIFT_COUNT        
MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS        
MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS        
MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES        
MAKFUNC.F_SOLP_PLEDGE_COUNT        
MAKFUNC.F_SOLP_PLEDGE_DONOR_COUNT        
MAKFUNC.F_SOLP_TOTAL_DONOR_COUNT        
MAKFUNC.F_SOL_FR_OUTRIGHT_GD_COUNT        
MAKFUNC.F_SOL_FR_OUTRIGHT_GIFTS        
MAKFUNC.F_SOL_FR_OUTRIGHT_GIFT_COUNT        
MAKFUNC.F_SOL_FR_PD_NP_COUNT        
MAKFUNC.F_SOL_FR_PD_PAID_COUNT        
MAKFUNC.F_SOL_FR_PLEDGE_COUNT        
MAKFUNC.F_SOL_FR_PLEDGE_DONOR_COUNT        
MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS        
MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT        
MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT/ORGAN IZATION_DONOR_COUNT_GOAL        
MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT/SOLIC ITOR_DONOR_COUNT_GOAL        
MAKFUNC.F_SOL_FR_TOTAL_GIFTS        
MAKFUNC.F_SOL_FR_TOTAL_GIFT_COUNT        
MAKFUNC.F_SOL_FR_TOTAL_PLEDGES        
MAKFUNC.F_SUM_PROPOSAL_RESULT        
MAKFUNC.F_TOTAL_CAMP_DESG_GOAL        
MAX(MST_TEST.TEST_SCORE) WHERE [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_LEVEL_GROUP_TESTS'] AND [MTVPARM_INTERNAL_CODE = 'TEST' AND MTVPARM_EXTERNAL_CODE = MST_TEST.TEST]        
MDKFUNC.F_GET_THIRD_PARY_PLAN_IND        
MEKFUNC.F_AUTHORIZED_REMAINING        
MEKFUNC.F_AUTHORIZED_TOTAL        
MEKFUNC.F_AUTHORIZED_TOTAL( PORTFOLIO_KEY, '%', '%')        
MEKFUNC.F_AUTHORIZED_TOTAL( PORTFOLIO_KEY, '%', 'N')        
MEKFUNC.F_AUTHORIZED_TOTAL( PORTFOLIO_KEY, '%', 'Y')        
MEKFUNC.F_GET_TAX_AMOUNT( E.EXPENSE_ITEM_KEY,'A')        
MEKFUNC.F_GET_TAX_AMOUNT( E.EXPENSE_ITEM_KEY,'C')        
MEKFUNC.F_GET_TAX_AMOUNT( E.EXPENSE_ITEM_KEY,'P')        
MEKFUNC.F_ITINERARY_DATE        
MEKFUNC.F_LIFE_TOTAL_REIMBURSE_PAID        
MEKFUNC.F_NOTIFICATION_CHANGE_HOURS        
MEKFUNC.F_STATUS_CHANGE_HOURS( AUTHORIZATION_KEY, STATUS_DATE, 'A', 'L')        
MEKFUNC.F_STATUS_CHANGE_HOURS( AUTHORIZATION_KEY, STATUS_DATE, 'A', 'T')        
MEKFUNC.F_STATUS_CHANGE_HOURS( REIMBURSEMENT_KEY, STATUS_DATE, 'R', 'L')        
MEKFUNC.F_STATUS_CHANGE_HOURS( REIMBURSEMENT_KEY, STATUS_DATE, 'R', 'T')        
MEKFUNC.F_TOTAL_NOT_SUBMITTED        
MEKFUNC.F_TOTAL_NOT_SUBMITTED( PORTFOLIO_KEY, '%', '%')        
MEKFUNC.F_TOTAL_NOT_SUBMITTED( PORTFOLIO_KEY, '%', 'N')        
MEKFUNC.F_TOTAL_NOT_SUBMITTED( PORTFOLIO_KEY, '%', 'Y')        
MEKFUNC.F_TOTAL_REIMBURSE_NOT_PAID        
MEKFUNC.F_TOTAL_REIMBURSE_NOT_PAID( PORTFOLIO_KEY, '%')        
MEKFUNC.F_TOTAL_REIMBURSE_PAID        
MEKFUNC.F_TOTAL_REIMBURSE_PAID( PORTFOLIO_KEY, '%')        
MEKFUNC.F_TOTAL_SUBMITTED        
MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', '%')        
MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'N')        
MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'Y')        
MFKFUNC.F_GET_BOOK_AMOUNT       NA
MFKFUNC.F_GET_LEDGER_ENCUMBERED_AMOUNT        
MFKFUNC.F_GET_LEDGER_REMAINING_BALANCE        
MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID       This function extracts the LAST row of return information for the purchase order and item. MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID(PURCHASE_ORDER,ITEM)
MFKFUNC.F_GET_UNITS_PURCHASED       NA
MFKFUNC.F_GET_VENDOR_FIELDS       This function returns the ID_NUMBER and name information for an entity based upon their UID and the entity indicator that is passed. If the entity indicator passed = C, then the ID_NUMBER and NAME are returned from MST_ORGANIZATION_ENTITY. Otherwise, the ID_NUMBER and a concatenation of FIRST_NAME, MIDDLE_NAME and LAST_NAME are returned from MST_PERSON.
MFKFUNC.F_QTY_ACCEPTED       This function returns the total number of quantity accepted in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_ACCEPTED(PI.PURCHASE_ORDER, PI.ITEM),0)
MFKFUNC.F_QTY_RECEIVED       This function returns the total number of quantity received in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_RECEIVED(PI.PURCHASE_ORDER, PI.ITEM),0)
MFKFUNC.F_QTY_RECEIVED_REJECTED       This function returns the total number of quantity received and rejected in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_RECEIVED_REJECTED(PI.PURCHASE_ORDER, PI.ITEM),0)
MFKFUNC.F_QTY_REJECTED       This function returns the total number of quantity rejected in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_ACCEPTED(PI.PURCHASE_ORDER, PI.ITEM),0)
MFKFUNC.F_QTY_RETURNED       This function returns the total number of quantity returned in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_ACCEPTED(PI.PURCHASE_ORDER, PI.ITEM),0)
MFKFUNC.F_RECEIVED_AMOUNT       This function returns the total received amount in receiving for a specified purchase order and item numberof standing orders. NVL(MFKFUNC.F_RECEIVED_AMOUNT(PI.PURCHASE_ORDER, PI.ITEM),0)
MFKFUNC.F_SUM_BOOK_AMOUNT       NA
MFKFUNC.F_SUM_UNITS_PURCHASED       NA
MFKFUNC.F_VENDOR_TYPE_COUNT( VENDOR.VENDOR_UID)       NA
MGKFUNC.F_CALCULATE_AGE(SYSDATE, BIRTH_DATE, DECEASED_DATE),       Calculates the current age of a person based upon today's date.
MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS        
MGKFUNC.F_COUNT_MAILING       This function counts the number of MGT_COMMUNICATION records for the parameter supplied UID, academic period and application number.
MGKFUNC.F_COUNT_RACE Number of regulatory races selected by this person.     SELECT COUNT(*) FROM MST_RACE WHERE PERSON_UID = IDEN
MGKFUNC.F_COUNT_RACE_CATEGORY Number of unique regulatory races selected by this person.     SELECT COUNT(DISTINCT RACE_CATEGORY) FROM MST_RACE WHERE PERSON_UID = IDEN
MGKFUNC.F_FORMAT_NAME        
MGKFUNC.F_GET_PERSON_INFO       This function returns a column value from MST_PERSON based on the value in ColumnRequested. When the UID is not found on MST_PERSON, either NULL is returned or, if a value is given for AlternateSource, an alternate view is read for the column value.
MGKFUNC.F_GET_UID        
MPKFUNC.F_CHECK_SUPERVISOR Returns a Y when the PERSON_UID exists as a SUPERVISOR_UID in MPT_SUPERVISOR.     SELECT 'Y' FROM MPT_SUPERVISOR WHERE SUPERVISOR_UID = IDEN;
MPKFUNC.F_COUNT_ACTIVE_JOBS Counts the number of records in MPT_EMPL_POSITION where POSITION_STATUS is not equal to T.     SELECT COUNT(*) FROM MPT_EMPL_POSITION WHERE PERSON_UID = IDEN AND POSITION_STATUS <> 'T';
MPKFUNC.F_COUNT_BARG_UNIT       This function returns the count of the MPT_BARG_UNIT records for a specified UID.
MPKFUNC.F_COUNT_BENEFICIARY       This function returns the count of the MPT_BENEFICIARY records for a specified UID.
MPKFUNC.F_COUNT_CERTIFICATION       This function returns the count of the MPT_CERTIFICATION records for a specified UID.
MPKFUNC.F_COUNT_DIRECT_REPORT Counts the number of people that have this person's SUPERVISOR_UID in MPT_SUPERVISOR.     SELECT COUNT(*) FROM MPT_SUPERVISOR WHERE SUPERVISOR_UID = IDEN AND POSITION_STATUS <> 'T';
MPKFUNC.F_COUNT_EMPL_EARN       This function returns the count of the MPT_EMPL_EARN_CY records for a specified UID.
MPKFUNC.F_COUNT_HR_APPL_STAT       This function returns the count of the MPT_HR_APPL_STAT records for a specified UID, requisition number, position applied for and position class.
MPKFUNC.F_COUNT_INTERVIEW       This function returns the count of the MPT_INTERVIEW records for a specified UID.
MPKFUNC.F_COUNT_LABOR_COST       This function returns the count of the MPT_LABOR_COST_DIST records for a specified position.
MPKFUNC.F_COUNT_LABOR_DIST       This function retrieves the count of records in MPT_LABOR_COST_DIST for the position passed.
MPKFUNC.F_COUNT_LEAVE       This function returns the count of the MPT_LEAVE_BALANCE records for a specified UID.
MPKFUNC.F_COUNT_PAST_EMPL       This function returns the count of the MPT_PAST_EMPLOYMENT records for a specified UID.
MPKFUNC.F_COUNT_POSN_LABOR       This function returns the count of the MPT_POSN_LABOR_DIST records for a specified position.
MPKFUNC.F_COUNT_REFERENCE       This function returns the count of the MPT_REFERENCE records for a specified UID.
MPKFUNC.F_COUNT_REVIEW       This function returns the count of the MPT_REVIEW records for a specified UID.
MPKFUNC.F_COUNT_SKILL       This function returns the count of the MPT_SKILL records for a specified UID.
MPKFUNC.F_GET_EMPL_POSITION_INFO        
MPKFUNC.F_GET_PERSONNEL_ACTION_IND        
MPKFUNC.F_GET_POSITION_REPORTS  

AN_POSITION_DEFINITION

POSITION_REPORTS_TITLE

DECODE(POSITION_REPORTS, NULL, SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION,'POSITION_TITLE'),1,255), SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION_REPORTS,'POSITION_TITLE'),1,255))
MPKFUNC.F_NEW_EMPLOYEE_IND Identifies the person as a new employee based on the value in service years.     SELECT TO_NUMBER(MGRSDAX_EXTERNAL_CODE) FROM MGRSDAX WHERE MGRSDAX_PROFILE_CODE = 'INSTITUTION' AND MGRSDAX_INTERNAL_CODE = 'SERVICE_YEARS' AND MGRSDAX_INTERNAL_CODE_GROUP = 'NEW_EMPLOYEE'
MPKFUNC.F_NUMBER_INCUMB       This function retrieves the sum of full_time_equivelancy_pct from MPT_EMPL_POSITION based on position and date.
MPKFUNC.F_POSITION_CURRENT_IND       This function returns an 'N' or 'Y' depending on if the position is current based on the current date.
MPKFUNC.F_POSITION_DEF_DATA        
MPKFUNC.F_SERVICE_YEARS Calculates the length of service in years for active employees based on the difference between today's date and the adjusted service date; for terminated employees based on the difference between termination date and adjusted service date.     DECODE(EMPL_STATUS,'T',ROUND((TERM_DATE-ADJ_SERVICE_DATE)/365.25,2),ROUND((SYSDATE-ADJ_SERVICE_DATE)/365.25,2))
MRKFUNC.F_CHECK_FOR_ACTIVE_HOLD        
MRKFUNC.F_GET_ACADEMIC_PERIOD       Extracts academic period or academic period description from mrt_satisfactory_acad_progress for a person and given aid year.
MRKFUNC.F_GET_AID_ENROLL_PERIOD       Extracts the aid year, aid year description, aid enrollment period, or aid enrollment period description for a student and a given term.
MRKFUNC.F_GET_AID_PERIOD       Extracts aid period or aid description from mrt_finaid_applicant_status table by giving the student uid and aid year.
MRKFUNC.F_GET_FIN_AID_AWARDED_IND        
MRKFUNC.F_GET_FIN_AID_DISBURSED_IND        
MRKFUNC.F_GET_FIN_AID_LOAN_IND        
MSKFUNC.F_ADDRESS_ROWID       This function retrieves the rowid from the address table based on the current date being between the address start and end date.
MSKFUNC.F_CALC_TRANSFER_CREDITS        
MSKFUNC.F_CHECK_COOP_IND       F_CHECK_COOP_IND (UID NUMBER, ACAD_PERIOD VARCHAR2, LEVL VARCHAR2)
MSKFUNC.F_COUNT_ADDRESSES        
MSKFUNC.F_COUNT_ADMINISTRATOR       This function counts the number of MST_ADMINISTRATOR records for the parameter supplied UID.
MSKFUNC.F_COUNT_ADMISSIONS_ATTRIBUTE       This function counts the number of MST_ADMISSIONS_ATTRIBUTE records for the parameter supplied UID, academic period and application number.
MSKFUNC.F_COUNT_ADMISSIONS_COHORT       This function counts the number of MST_ADMISSIONS_COHORT records for the parameter supplied UID, academic period and application number.
MSKFUNC.F_COUNT_ADMISSIONS_DECISION       This function counts the number of MST_ADMISSIONS_DECISION records for the parameter supplied UID, academic period and application number.
MSKFUNC.F_COUNT_ADMISSIONS_RATING       This function counts the number of MST_ADMISSIONS_RATING records for the parameter supplied UID, academic period and application number.
MSKFUNC.F_COUNT_ADMISSIONS_REQUIREMENT       This function counts the number of MST_ADMISSIONS_REQUIREMENT records for the parameter supplied UID, academic period and application number.
MSKFUNC.F_COUNT_ADMISSIONS_SOURCE       This function counts the number of MST_ADMISSIONS_SOURCE records for the parameter supplied UID, academic period and application number.
MSKFUNC.F_COUNT_ADVISORS       This function counts the number of MST_ADVISORS records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_COHORTS       This function counts the number of MST_STUDENT_COHORT records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_CONTACTS       This function counts the number of MST_CONTACT records for the parameter supplied UID.
MSKFUNC.F_COUNT_COURSE_ATTRIBUTES        
MSKFUNC.F_COUNT_COURSE_COREQ       This function counts the number of MST_COURSE_COREQ records for the parameter supplied subject, course and academic period.
MSKFUNC.F_COUNT_COURSE_LEVEL       This function returns the count of course levels based on the subject, course number and academic period passed.
MSKFUNC.F_COUNT_COURSE_SCHEDULE        
MSKFUNC.F_COUNT_FACULTY_ATTRIBUTE       This function counts the number of MST_FACULTY_ATTRIBUTE records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_FACULTY_CONTRACT       This function counts the number of MST_FACULTY_CONTRACT records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_FACULTY_DEPT_COLL       This function counts the number of MST_FACULTY_DEPT_COLLEGE records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_GRADE_CHANGE       NA
MSKFUNC.F_COUNT_GRADE_TYPE        
MSKFUNC.F_COUNT_HOLDS       This function counts the number of active MST_HOLD records for the parameter supplied UID.
MSKFUNC.F_COUNT_HONORS       This function counts the number of MST_OUTCOME_HONOR records for the parameter supplied UID, outcome and honor code.
MSKFUNC.F_COUNT_INSTITUTION_TYPES       This function counts the number of MST_PREVIOUS_EDUCATION records for the parameter supplied UID and institution type.
MSKFUNC.F_COUNT_INSTRUCTOR       This function counts the number of MST_INSTRUCTIONAL_ASSIGNMENT records for the parameter supplied academic period.
MSKFUNC.F_COUNT_INST_ASSIGNMENT       This function counts the number of MST_INSTRUCTIONAL_ASSIGNMENT records for the parameter supplied academic period and course.
MSKFUNC.F_COUNT_INTERESTS       This function counts the number of MST_INTERESTS records for the parameter supplied UID.
MSKFUNC.F_COUNT_MEDICAL_INFORMATION       This function counts the number of MST_MEDICAL_INFORMATION records for the parameter supplied UID.
MSKFUNC.F_COUNT_MEETING_TIME       This function counts the number of MST_MEETING_TIME records for the parameter supplied academic period and course.
MSKFUNC.F_COUNT_NONINST_ASSIGNMENT       This function counts the number of MST_NONINSTRUCTIONAL_ASGNMNT records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_OFFERING_COREQ       This function counts the number of MST_OFFERING_COREQ records for the parameter supplied academic period and course.
MSKFUNC.F_COUNT_OFFERING_PREREQ       This function counts the number of MST_OFFERING_PREREQ records for the parameter supplied academic period and course.
MSKFUNC.F_COUNT_RECRUITMENT_ATTRIBUTES       This function counts the number of MST_RECRUITMENT_ATTRIBUTE records for the parameter supplied UID, academic period and recruitment number.
MSKFUNC.F_COUNT_RECRUITMENT_SOURCES       This function counts the number of MST_RECRUITMENT_SOURCE records for the parameter supplied UID, academic period and recruitment number.
MSKFUNC.F_COUNT_SECONDARY_SUBJECTS       This function counts the number of MST_SECONDARY_SCHOOL_SUBJECT records for the parameter supplied UID and institution.
MSKFUNC.F_COUNT_SPORTS       This function counts the number of MST_SPORTS records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_STUDENT_COURSE_ATTR       NA
MSKFUNC.F_COUNT_TELEPHONES        
MSKFUNC.F_COUNT_TESTS       This function counts the number of MST_TEST records for the parameter supplied UID.
MSKFUNC.F_DEGR_ENROLLED_IND       This function returns a Y/N indicator based on enrollment in a degree category for a specified UID and academic period.
MSKFUNC.F_ENROLLED_IND       This function retrieves the enrollment indicator from the enrollment table for a person and academic period passed. If no records exists, an 'N' is returned.
MSKFUNC.F_FORMAT_NAME       This function returns the formatted name of the specified UID and format (for example, FMIL or LFMI).
MSKFUNC.F_GET_BLOCK_REG_CNT        
MSKFUNC.F_GET_CONTINUING_ED_IND        
MSKFUNC.F_GET_DEGREE_IND        
MSKFUNC.F_GET_DIVISOR_FTE       This function retrieves either the full time equivalency of a student for a term, or the divisor used to determine the full time equivalency of a student for a term.
MSKFUNC.F_GET_ENROLL_WITHDRAW_DATE        
MSKFUNC.F_GET_LAST_ACADEMIC_PERIOD       This function retrieves the maximum academic period from MST_STUDENT_COURSE for a given person where the gradable indicator is set to 'Y'.
MSKFUNC.F_GET_LATEST_DECISION        
MSKFUNC.F_GET_OUTCOME_AWARDED_IND       Determines if program has outcome awarded to the student.
MSKFUNC.F_GET_PREF_ADDRESS_ROWID       This function retrieves the rowid from the address table based on the current date being between the address start and end date. The address must also have an active or null status and also be a preferred address.
MSKFUNC.F_GET_REG_PLAN_CNT        
MSKFUNC.F_GET_REG_PLAN_IND        
MSKFUNC.F_GET_SALUTATIONS_COUNT       This function counts the number of MAT_SALUTATION records for the parameter supplied UID.
MSKFUNC.F_GET_STDNT_ATTR_CNT        
MSKFUNC.F_GET_TEST_PERCENTILE_COUNT        
MTKFUNC.F_AMOUNT_DUE       This function will calculate the amount due from TBRACCD for a specified entity. It formulates a sum of the TBRACCD_BALANCE for all transactions whose TBRACCD_EFFECTIVE_DATE is before or equal to the date contained in the GTVSDAX rule where GTVSDAX_INTERNAL_CODE_GROUP = AR ENTITY DATE.
MTKFUNC.F_MEMO_BALANCE       This function calculates the sum of the memo balance on unexpired memos for a specified UID and detail code where the expiration date TBRMEMO_EXPIRATION_DATE is null or greater than yesterday. The function is nvl(sum(decode(tbbdetc_type_ind, 'P',tbrmemo_amount*-1,tbrmemo_amount)),0)
NA        
NOKODSF.F_GET_END_NBRJFTE_FTE_DATE  

AN_JOB_FTE_TRACKING

ANNUALIZED_FTE_END_DATE

This function returns an end date for the employee fte assignment effective date for the specified UID, Position, Suffix and Effective Date.
NOKODSF.F_GET_END_NBRJFTE_JOB_DATE  

AN_JOB_FTE_TRACKING

JOB_END_DATE

This function returns an end date for employee job assignment effective date for the specified UID, Position, Suffix and Effective Date.
NOKODSF.F_GET_END_NBRJLBD_DATE  

AN_LABOR_COST_DISTRIBUTION

EFFECTIVE_END_DATE

This function returns an end date for job labor distribution effective date for the specified UID, Position, Suffix and Effective Date.
NOKODSF.F_GET_END_NBRJOBS_DATE  

AN_EMPLOYEE_POSITION

EFFECTIVE_END_DATE

This function returns an end date for employee assignment effective date for the specified UID, Position, Suffix and Effective Date.
NOKODSF.F_GET_END_NBRPTOT_DATE  

AN_POSITION_BUDGET

EFFECTIVE_END_DATE

This function returns an end date for position budget effective date for the specified position, fiscal year, organization, budget and budget phase.
NOKODSF.F_GET_LAST_PAID_DATE  

AN_EMPLOYEE_POSITION

LAST_PAID_DATE

 
NOKODSF.F_GET_PAF_COMMENT_COUNT  

AN_PERSONNEL_ACTION

PAF_COMMENT_COUNT

 
NOKODSF.F_GET_SUPERVISOR Returns the NBRJOBS_DESC based on the SUPERVISOR_POSITION in MPT_SUPERVISOR.

AN_EMPLOYEE_POSITION

AN_SUPERVISOR

SUPERVISOR_TITLE

SUPERVISOR_TITLE

TO_NUMBER(NOKODSF.F_GET_SUPERVISOR(B.NBBPOSN_POSN_REPORTS,'PIDM')))
NOKODSF.F_NEXT_AUTO_STEP  

AN_EMPLOYEE_POSITION

NEXT_AUTO_STEP_INCREASE

This function finds the next step for the table, grade, group and step for the specified assignment table, assignment grade, assignment salary group and assignment step.
NOKODSF.F_SALARY_RANGE_IND  

AN_EMPLOYEE_POSITION

AN_EMPLOYEE_POSITION

AN_EMPLOYEE_POSITION

BELOW_SALARY_RANGE_IND

IN_SALARY_RANGE_IND

ABOVE_SALARY_RANGE_IND

This function identifies low, midpoint and high salary range for the specified the assignment salary, regular rate, which field (HIGH, LOW, MIDPOINT), assignment salary group, salary table, and assignment salary grade.
NVL((SELECT MIN(ACADEMIC_YEAR) FROM MST_SPORT SPORT WHERE SPORT.PERSON_UID = A.PERSON_UID AND SPORT.ACTIVITY = A.ACTIVITY),'1900')        
NVL((SELECT NVL(MAX(ACADEMIC_YEAR), '2099') FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY), 2099)        
NVL((SELECT NVL(MIN(ACADEMIC_YEAR), '1900') FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY), 1900)        
NVL(ACADEMIC_PERIOD, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''ACADEMIC_STANDING_ACAD_PERIOD'')        
NVL(ACADEMIC_STANDING, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL,''ACADEMIC_STANDING'')        
NVL(ACADEMIC_STANDING_DATE, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''ACADEMIC_STANDING_DATE'')        
NVL(ACADEMIC_STANDING_DESC, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''ACADEMIC_STANDING_DESC'')        
NVL(AXBMGID_MGFORM_READYTOSEND,'N')        
NVL(COMBINED_ACAD_STANDING, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''COMBINED_ACAD_STANDING'')        
NVL(COMBINED_ACAD_STANDING_DATE, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''COMBINED_ACAD_STANDING_DATE'')        
NVL(COMBINED_ACAD_STANDING_DESC, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''COMBINED_ACAD_STANDING_DESC'')        
NVL(PROGRESS_EVALUATION, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL,''PROGRESS_EVALUATION'')        
NVL(PROGRESS_EVALUATION_DATE, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''PROGRESS_EVALUATION_DATE'')        
NVL(PROGRESS_EVALUATION_DESC, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''PROGRESS_EVALUATION_DESC'')        
NVL(RPRADSB_SCHEDULE_AMT, ROKODSF.F_GET_RPRADSB_SCHEDULE_AMT        
NVL(SORLCUR_SITE_CODE, SGBSTDN_SITE_CODE)  

AS_LEARNER_CURRICULUM_FOS

SITE

NA
NVL(SORLCUR_STYP_CODE, SGBSTDN_STYP_CODE)  

AS_LEARNER_CURRICULUM_FOS

STUDENT_POPULATION

NA
NVL(SORLCUR_TERM_CODE_END,'999999')  

AS_LEARNER_CURRICULUM_FOS

LAST_ACTIVE_ACADEMIC_PERIOD

 
NVL(MSKFUNC.F_GET_INQUIRER_IND( A.PERSON_UID, A.ACADEMIC_PERIOD),'N')        
POKODSF.F_CALC_DEDN_AMT       This function calculates the deduction amount from PHRDEDN for a given person, year, pict code, payroll number and sequence number.
POKODSF.F_CALC_DEDUCTIONS_FYTD  

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

EMPLOYEE_CONTRIBUTION_FYTD

EMPLOYER_CONTRIBUTION_FYTD

GROSS_COMPENSATION_FYTD

This function will calculate the sum of EMPLOYEE_CONTRIBUTION_FYTD, EMPLOYER_CONTRIBUTION_FYTD, and GROSS_COMPENSATION_FYTD for a UID, fiscal year and carrier.
POKODSF.F_CALC_EARNING_TOTALS_YTD  

AP_EMPLOYEE_EARNING_CY

AP_EMPLOYEE_EARNING_CY

TOTAL_HOUR_YTD

TOTAL_EARNING_YTD

This function will calculate year to date hours or earning for an employee for a specific UID, year, month, year type, chart of accounts and earning code.
POKODSF.F_GET_COVERAGE_OPTION  

AP_MONTHLY_DEDUCTION

COVERAGE_OPTION

 
POKODSF.F_GET_COVERAGE_OPTION_DESC  

AP_MONTHLY_DEDUCTION

COVERAGE_OPTION_DESC

 
POKODSF.F_GET_DEDUCTION_AMOUNTS  

AP_BENEFIT_DEDUCTION

AP_BENEFIT_DEDUCTION

AP_BENEFIT_DEDUCTION

AP_BENEFIT_DEDUCTION

AP_TAX

AP_BENEFIT_DEDUCTION

AP_BENEFIT_DEDUCTION

AP_BENEFIT_DEDUCTION

AP_TAX

AP_BENEFIT_DEDUCTION

AP_BENEFIT_DEDUCTION

AP_TAX

AP_TAX

AP_BENEFIT_DEDUCTION

AP_BENEFIT_DEDUCTION

AP_BENEFIT_DEDUCTION

AP_BENEFIT_DEDUCTION

AP_TAX

AP_TAX

EMPLOYEE_BOND_PURCHASE_AMOUNT

EMPLOYEE_DEDUCTION_AMOUNT

LIFE_INSURANCE_SALARY

LIFE_INSURANE_COVERAGE_AMOUNT

EMPLOYEE_ADD_WITHHOLDING_AMT

EMPLOYEE_DEDN_LTD_LIMIT

LIFE_INSURANCE_OVERRIDE_AMOUNT

LIFE_INSURANCE_PREMIUM

STATE_INCOME_TAX_EXEMPTION_AMT

EMPLOYEE_MINIMUM_YTD_GROSS

EMPLOYER_DEDUCTION_AMOUNT

EMPLOYEE_ALT_WAGE_BASE_MAX

EMPLOYEE_ANNUALWAGE_DEDUCTIONS

EMPLOYEE_DEDN_MTD_LIMIT

EMPLOYEE_ANNUAL_DEDN_LIMIT

EMPLOYEE_DEDUCTION_PERCENT

EMPLOYEE_MINIMUM_EARNINGS

EMPLOYEE_NET_CLAIM_AMT

EMPLOYEE_TAX_CREDITS

This function extracts amounts 1-4 from pdrdedn based on a specified UID, carrier and effective date.
POKODSF.F_GET_DEDUCTION_OPTIONS  

AP_TAX

AP_BENEFIT_DEDUCTION

AP_TAX

AP_TAX

AP_BENEFIT_DEDUCTION

AP_TAX

AP_TAX

AP_TAX

EMPLOYEE_AGE_OVER_65_IND

LIFE_INSURANCE_TYPE_IND

EMPLOYEE_AREA_CREDIT

EMPLOYEE_NUMBER_OF_DEPENDENTS

BENEFIT_DEDUCTION_IND

EMPLOYEE_NUMBER_OF_EXEMPTIONS

EMPLOYEE_DEPENDENTS_UNDER_19

EMPLOYEE_FILING_STATUS

This function extracts options 1-5 from pdrdedn based on a specified UID, carrier and effective date.
POKODSF.F_GET_END_PDRDEDN_DATE  

AP_BENEFIT_DEDUCTION

AP_TAX

EFFECTIVE_END_DATE

EFFECTIVE_END_DATE

This function returns an end date for employee deduction effective date for the specified UID, carrier and effective date.
POKODSF.F_GET_FISCAL_QUARTER  

AP_EMPLOYEE_EARNING_FY

QUARTER

This function returns the appropriate quarter associated with a given month within a fiscal year.
POKODSF.F_NEXT_REVIEW_DATE  

AP_REVIEW

NEXT_REVIEW_DATE

This function returns the next review date for a specified UID, review code and review date.
POKODSF.F_QUARTERLY_DEDUCTION_TOTAL  

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

AP_MONTHLY_DEDUCTION

APPLICABLE_GROSS_QTR1

EMPLOYEE_CONTRIBUTION_QRT3

EMPLOYER_CONTRIBUTION_QTR2

APPLICABLE_GROSS_QTR3

EMPLOYER_CONTRIBUTION_QTR3

APPLICABLE_GROSS_QTR2

EMPLOYEE_CONTRIBUTION_QRT4

EMPLOYER_CONTRIBUTION_QTR1

APPLICABLE_GROSS_QTR4

EMPLOYEE_CONTRIBUTION_QRT1

EMPLOYEE_CONTRIBUTION_QRT2

EMPLOYER_CONTRIBUTION_QTR4

 
RNKNEED.F_CALC_BUDGET_AMT  

AR_APPLICANT_NEED

COST_OF_EDUCATION

This function returns any non-Pell budget from RBBABUD, if present based upon a specified entity and aid year. If no non-Pell budget exists, it will return the Pell budget instead.
RNKNEED.F_CALC_BUDGET_AMT (RORSTAT_PIDM, RORSTAT_AIDY_CODE, 'F')        
RNKNEED.F_CALC_EFC  

AR_APPLICANT_NEED

FM_TFC

This function calculates the total family contribution from RCRAPP4 and RCRAPP1 for a specified entity and aid year. It uses the federal methodology.
RNKNEED.F_CALC_IM_TFC  

AR_APPLICANT_NEED

IM_TFC

This function calculates the total family contribution from RCRAPP2 and RCRAPP1 for a specified entity and aid year. It uses the institutional methodology.
RNKNEED.F_CALC_NEED_DATA  

AR_APPLICANT_NEED

AR_APPLICANT_NEED

AR_APPLICANT_NEED

AR_APPLICANT_NEED

FM_GROSS_NEED

FM_UNMET_NEED

IM_GROSS_NEED

IM_UNMET_NEED

This function calculates either the unmet or gross need for a specified entity and aid year. It uses either the federal methodology or the institutional methodology based upon which is specified.
RNKNEED.F_CALC_RESOURCE  

AR_APPLICANT_NEED

RESOURCE_AMOUNT

This function formulates the resource amount for a specified entity and aid year by adding exemptions, contracts and other resources.
ROKODSF.F_CALCULATE_DISB_AMTS  

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

AR_FINAID_FUND

FEDERAL_LOAN_DISBURSED

STATE_GRANT_DISBURSED

FEDERAL_SCHOLARSHIP_DISBURSED

INST_WORK_DISBURSED

OTHER_WORK_DISBURSED

OTHER_GRANT_DISBURSED

STATE_LOAN_DISBURSED

FEDERAL_GRANT_DISBURSED

INST_GRANT_DISBURSED

FEDERAL_WORK_DISBURSED

INST_LOAN_DISBURSED

OTHER_SCHOLARSHIP_DISBURSED

INST_SCHOLARSHIP_DISBURSED

OTHER_LOAN_DISBURSED

STATE_SCHOLARSHIP_DISBURSED

This function retrieves the displays the actual disbursed amount of the FUND indicated in this record for the student.
ROKODSF.F_GET_CALC_DISBURSE_AMT  

AR_LOAN_DISBURSEMENT

CALC_EXPECTED_DISBURSEMENT_AMT

 
ROKODSF.F_GET_CIPC_DESC  

AR_AWARD_BY_PERSON

PROGRAM_CLASS_OVR_DESC

 
ROKODSF.F_GET_COMMENT_DESC  

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT15_DESC

COMMENT4_DESC

COMMENT18_DESC

COMMENT20_DESC

COMMENT7_DESC

COMMENT9_DESC

COMMENT11_DESC

COMMENT2_DESC

COMMENT3_DESC

COMMENT8_DESC

COMMENT17_DESC

COMMENT16_DESC

COMMENT1_DESC

COMMENT6_DESC

COMMENT10_DESC

COMMENT12_DESC

COMMENT13_DESC

COMMENT19_DESC

COMMENT14_DESC

COMMENT5_DESC

 
ROKODSF.F_GET_FINAID_PROC_YEAR  

AR_FINAID_ENROLLMENT

AR_SATISFACTORY_ACAD_PROGRESS

AID_YEAR

AID_YEAR

 
ROKODSF.F_GET_PCKG_LOAD_IND  

AR_AWARD_BY_PERSON

AWARD_LOAD_MISMATCH_IND

This function retrieves a 'Y' or 'N' for a given person, aid year and term code. This function returns a 'Y' if a persons has a record in RPRATRM where the package load indicator does not exist in the RPRADSB table.
ROKODSF.F_GET_RORMVAL_DESC        
ROKODSF.F_GET_RORMVAL_DESC( RPRLAPP_LOAN_TYPE,RPRLAPP_AIDY_CODE, RPRLAPP_INFC_CODE,RPRLAPP_LOAN_TYPE)        
ROKODSF.F_GET_TOTAL_DISBURSED        
ROKODSF.F_SUM_CALC_STUD_ADJ_HRS  

AR_AWARD_BY_PERSON

CALC_STUDENT_ADJ_CREDITS

This function retrieves the sum of adjusted hours from the student course registration table for a given person and aid enrollment period by passing all terms associated to the aid enrollmennt period to the function ROKODSF.F_CALC_STUD_ADJ_HRS.
ROKODSF.F_SUM_CALC_STUD_BILL_HRS  

AR_AWARD_BY_PERSON

CALC_STUDENT_BILLING_HOURS

Calculates a students billing hrs from course registration table (sfrstcr) where the course is not excluded and not listed in course sections unavailable for aid (rorsect) for a given person and aid enrollment period by passing all terms associated to the aid enrollmennt period to the function ROKODSF.F_CALC_STUD_BILL_HRS.
ROW_NUMBER() OVER (PARTITION BY DRIVER.PERSON_UID ORDER BY DRIVER.POST_SECONDARY_DEGREE_DATE DESC NULLS LAST, DRIVER.AWARD_CATEGORY DESC NULLS LAST, DRIVER.POST_SECONDARY_ATTEND_FROM DESC N        
ROW_NUMBER() OVER (PARTITION BY SORLCUR_PIDM, SGBSTDN_TERM_CODE_EFF ORDER BY SORLCUR_PRIORITY_NO)       This Oracle analytic function assigns a unique number to each current and active curriculum for the student and academic period, beginning with 1.
SB_CURRICULUM.F_FIND_CURRENT_ALL_IND This function set the current and acitive indicators on the curriculum record.     SUBSTR(SB_CURRICULUM.F_FIND_CURRENT_ALL_IND( SORLCUR_PIDM, SORLCUR_LMOD_CODE, SORLCUR_TERM_CODE, SORLCUR_KEY_SEQNO, SORLCUR_PRIORITY_NO, SORLCUR_SEQNO, SGBSTDN_TERM_CODE_EFF),1,1)
SELECT DISTINCT(SUBSTR(FISCAL_PERIOD1, 63)) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE        
SELECT DISTINCT(SUBSTR(FISCAL_YEAR,1,63) ) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE = PAF_TRANSACTION_STATUS        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'ACCOUNT_POSTING_STATUS' AND VALUE = AP.ACCOUNT_POSTING_STATUS        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'DIRECT_PAYMENT_TYPE' AND VALUE = AP.DIRECT_PAYMENT_TYPE        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'DURATION_DESIGNATION' AND VALUE = F.DURATION_DESIGNATION        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_ACTUAL_TIME_STATUS' AND VALUE = F.FMLA_ACTUAL_TIME_STATUS        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_SCHEDULE_TIME_STATUS' AND VALUE = F.FMLA_SCHEDULE_TIME_STATUS        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_UNIT' AND VALUE = F.FMLA_UNIT        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_YEAR_TYPE' AND VALUE = F.FMLA_YEAR_TYPE        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'MILITARY_RECIPROCAL_TYPE' AND VALUE = F.MILITARY_RECIPROCAL_TYPE        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'MILITARY_RELATE_TYPE' AND VALUE = F.MILITARY_RELATE_TYPE        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS' AND VALUE =PAF_APPLY_STATUS        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS'AND VALUE =PAF_APPLY_STATUS        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE        
SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255)FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE        
SELECT SUBSTR(FISCAL_PERIOD,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE        
SELECT SUBSTR(FISCAL_YEAR,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE        
SELECT SUBSTR(VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'PRIMARY_FUNCTION' AND VALUE = A.PRIMARY_FUNCTION        
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'ENCUMBRANCE_TYPE' AND VALUE = ENCUMBRANCE_TYPE        
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRBEVNG_BEG_DATE_IND' AND VALUE = BEGIN_EVENT_RULE        
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRBEVNG_FREQ_IND' AND VALUE = EVENT_FREQUENCY        
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRREVNG_STATUS_IND' AND VALUE = GRANT_EVENT_STATUS        
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRVEVNT_TYPE_IND' AND VALUE = GRANT_EVENT_TYPE        
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS        
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_DOCUMENT_BOX' AND VALUE = TAX_DOCUMENT_BOX_NUMBER       Hard coded values are stored in MGT_VALIDATION for TAX_DOCUMENT_BOX
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_NOTIFICATION_STATUS' AND VALUE = FEDERAL_REPORT_STATUS        
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_NOTIFICATION_STATUS' AND VALUE = NOTIFICATION_STATUS        
SELECT COUNT(*) COUNT_NO FROM MST_STUDENT_COURSE_GRADE_CHG WHERE PERSON_UID = PERSON_IN AND ACADEMIC_PERIOD = ACADEMIC_PERIOD_IN AND COURSE_REFERENCE_NUMBER = COURSE_REFERENCE_NUMBER_IN AND NVL( MIF_VALUE, DEF_MULT        
SELECT'Y' TUITION_DEPOSITED_IND FROM MTT_AR_DEPOSIT WHERE ACCOUNT_UID = PERSON_IN AND ACADEMIC_PERIOD = ACADEMIC_PERIOD_IN -- AND DEPOSIT_TYPE ='TUI' AND NVL(MIF_VALUE, DEF_MULTI_SOURCE_IN) = MULTI_SRC_IN        
SGKCLAS.F_CLASS_CODE       This packaged function is created to allow student classification to be retrieved for ad-hoc reporting.
SOKODSF.F_ADMS_CHECK_STATUS  

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

INST_ACCEPTED_CURRENT_IND

APPL_ACCEPT_CURRENT_IND

INST_ADMIT_ANY_TIME_IND

INST_DENIED_IND

APPL_ACCEPT_ANY_TIME_IND

 
SOKODSF.F_BUILD_PREREQ_PARSE  

AS_COURSE_PREREQ

PREREQUISITE_TEXT

This function retrieves all columns from the SCRRTST table for a given subject, course number and effective academic period.
SOKODSF.F_CALCULATE_AGE_ADMIT  

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

AGE_ADMITTED

AGE_ADMITTED

This function returns the hours attempted for a PIDM, history term, and optional CEU indicator.
SOKODSF.F_CALC_HISTORY_HOURS  

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

TOTAL_CREDITS

TOTAL_NON_CEU_CREDITS

TOTAL_CEU_CREDITS

This function returns the hours attempted for a PIDM, history term, and optional CEU indicator.
SOKODSF.F_CALC_SEASONS_USED        
SOKODSF.F_CALC_TRANSFER_CREDITS  

AS_PREVIOUS_EDUCATION_PCOL

TOTAL_TRANSFER_CREDITS

This function calculates the total transfer credits SUM(SHRTRCE_CREDIT_HOURS) by transfer institution for the person for the given UID and institution.
SOKODSF.F_CHECK_FOR_ACAD_HISTORY_DATA  

AS_ENROLLMENT

ACADEMIC_HISTORY_EXISTS_IND

This function returns a Y/N indicator that indicates if Academic History (SHRTTRM) data exists based on the PIDM and TERM parameters passed.
SOKODSF.F_CHECK_FOR_GRADUATE_IND       This function returns a Y/N indicator if the student has graduated previous to this term by having a award status on their SHRDGMR record with a term completed greater than the given academic period.
SOKODSF.F_CLASS_CALC_FNC        
SOKODSF.F_COUNT_COMPLETED_OUTCOMES  

AS_GENERAL_STUDENT

ACAD_OUTCOME_COMPLETED_COUNT

This function counts SHRDGMR records with an awarded status for a given UID where the award status is A.
SOKODSF.F_ENROLLED_THIS_TERM        
SOKODSF.F_GET_BANNER_PIDM       Function extracts the Banner Pidm from spriden using a passed user_id as the spriden_id.
SOKODSF.F_GET_COURSE_DATES  

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_IN_PROGRESS

AS_STUDENT_COURSE_HISTORY

AS_STUDENT_COURSE_IN_PROGRESS

FINALIZED_COMPLETION_DATE

END_DATE

START_DATE

FINALIZED_COMPLETION_DATE

This function returns the start and/or end dates of the registered class for a given UID, academic period, course and subacademic period.
SOKODSF.F_GET_COURSE_EXTENSIONS  

AS_STUDENT_COURSE_IN_PROGRESS

EXTENSIONS

This function returns the number of extensions a student has been granted to complete the class for a given term and crn.
SOKODSF.F_GET_CRSE_LONG_TITLE  

AS_STUDENT_COURSE_IN_PROGRESS

AS_MEETING_TIME

COURSE_TITLE_LONG

TITLE_LONG_DESC

This function returns the long title for a specified academic period and course.
SOKODSF.F_GET_CURR_VETC_CODE  

AS_ENROLLMENT

AS_ENROLLMENT_HISTORY

VETERAN_TYPE

VETERAN_TYPE

This function returns the most current veterans code SGRVETN_VETC_CODE for the specified UID.
SOKODSF.F_GET_DEGREE_GPA_DATA  

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

AS_ACADEMIC_OUTCOME

A ANSFER_GPA">TRANSFER_GPA

CREDITS_EARNED

CREDITS_ATTEMPTED

 
SOKODSF.F_GET_END_COHORT_TERM  

AS_STUDENT_COHORT

ACADEMIC_PERIOD_END

This function returns the end term SGRCHRT_TERM_CODE_EFF for the students cohort for the given UID and effective date.
SOKODSF.F_GET_END_SCBCRSE_TERM  

AS_COURSE_CATALOG

ACADEMIC_PERIOD_END

This function returns the end term SCBCRSE_EFF_TERM for the course catalog for the specified subject, course number and effective term.
SOKODSF.F_GET_END_SCBSUPP_TERM  

AS_COURSE_SUPPLEMENTAL

ACADEMIC_PERIOD_END

This function returns the end term SCBSUPP_EFF_TERM for the course supplemental information for the specified subject, course number and effective term.
SOKODSF.F_GET_END_SCRCORQ_TERM  

AS_COURSE_COREQ

ACADEMIC_PERIOD_END

This function returns the end term SCRCORQ_EFF_TERM for a course co-requisite for the specified subject, course number and effective term.
SOKODSF.F_GET_END_SCRGMOD_TERM  

AS_OFFERING_GRADE_MODE

ACADEMIC_PERIOD_END

This function returns the end term SCRGMOD_EFF_TERM for course grade type for the specified subject, course number and effective term.
SOKODSF.F_GET_END_SCRLEVL_TERM  

AS_COURSE_LEVEL

ACADEMIC_PERIOD_END

This function returns the end term SCRLEVL_EFF_TERM for course level for the specified subject, course number and effective term.
SOKODSF.F_GET_END_SCRRTST_TERM  

AS_COURSE_PREREQ

AS_COURSE_SCHEDULE

ACADEMIC_PERIOD_END

ACADEMIC_PERIOD_END

This function returns the end term SCRRTST_TERM_CODE_EFF for a course prerequisite for the specified subject, course number and effective term.
SOKODSF.F_GET_END_SGBSTDN_TERM  

AS_GENERAL_STUDENT

AS_LEARNER_CURRICULUM_FOS

ACADEMIC_PERIOD_END

ACADEMIC_PERIOD_END

This function returns the end term SGBSTDN_TERM_CODE_EFF for the student for the given UID and effective date.
SOKODSF.F_GET_END_SGRADVR_TERM  

AS_COURSE_ATTRIBUTE

AS_ADVISOR

ACADEMIC_PERIOD_END

ACADEMIC_PERIOD_END

This function returns the end term SGRADVR_TERM_CODE_EFF for the students advisor for the given UID.
SOKODSF.F_GET_END_SGRSATT_TERM  

AS_STUDENT_ATTRIBUTE

ACADEMIC_PERIOD_END

This function returns the end term SGRSATT_TERM_CODE_EFF for course attributes for the specified UID and effective date.
SOKODSF.F_GET_END_SIBINST_TERM  

AS_FACULTY

ACADEMIC_PERIOD_END

This function returns the end term SIBINST_TERM_CODE_EFF for a faculty member for the specified UID and effective date.
SOKODSF.F_GET_END_SIRATTR_TERM  

AS_FACULTY_ATTRIBUTE

ACADEMIC_PERIOD_END

This function returns the end term SIRATTR_TERM_CODE_EFF for a faculty members attributes for the specified UID and effective date.
SOKODSF.F_GET_END_SIRDPCL_TERM  

AS_FACULTY_DEPARTMENT_COLLEGE

ACADEMIC_PERIOD_END

This function retrieves the end term associated with the effective term for the faculty department and college.
SOKODSF.F_GET_END_SIRICNT_TERM  

AS_FACULTY_CONTRACT

ACADEMIC_PERIOD_END

This function returns the end term SIRICNT_TERM_CODE_EFF for faculty member for the specified UID and effective date.
SOKODSF.F_GET_ENROLL_CENSUS_IND  

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT

AS_ENROLLMENT

AS_ENROLLMENT_HISTORY

ENROLL_CENSUS_DATE2_IND

ENROLL_CENSUS_DATE2_IND

ENROLL_CENSUS_DATE1_IND

ENROLL_CENSUS_DATE1_IND

 
SOKODSF.F_GET_SCBCRSE_LONG_TITLE  

AS_COURSE_CATALOG

TITLE_LONG_DESC

 
SOKODSF.F_GET_SORCONC_DATA  

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

FIRST_CONCENTRATION_DESC

FOURTH_CONCENTRATION_DESC

SECOND_CONCENTRATION_DESC

THIRD_CONCENTRATION

THIRD_CONCENTRATION_DESC

FIRST_CONCENTRATION

FOURTH_CONCENTRATION

SECOND_CONCENTRATION

 
SOKODSF.F_GET_SORMAJR_DATA  

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_EDUCATION_PCOL

AS_PREVIOUS_EDUCATION_PCOL

FIRST_MAJOR

THIRD_PROGRAM_CLASSIF_DESC

POST_SECONDARY_MAJOR_DESC1

PROGRAM_CLASSIFICATION3

PROGRAM_CLASSIFICATION_DESC2

PROGRAM_CLASSIFICATION_DESC3

FIRST_MAJOR_DESC

SECOND_PROGRAM_CLASSIF_DESC

THIRD_MAJOR_DESC

POST_SECONDARY_MAJOR_DESC3

FOURTH_MAJOR

THIRD_PROGRAM_CLASSIFICATION

POST_SECONDARY_MAJOR2

POST_SECONDARY_MAJOR3

FOURTH_PROGRAM_CLASSIF_DESC

FIRST_PROGRAM_CLASSIFICATION

FOURTH_MAJOR_DESC

FIRST_PROGRAM_CLASSIF_DESC

SECOND_MAJOR_DESC

SECOND_PROGRAM_CLASSIFICATION

THIRD_MAJOR

PROGRAM_CLASSIFICATION2

PROGRAM_CLASSIFICATION_DESC1

FOURTH_PROGRAM_CLASSIFICATION

SECOND_MAJOR

POST_SECONDARY_MAJOR1

POST_SECONDARY_MAJOR_DESC2

PROGRAM_CLASSIFICATION1

 
SOKODSF.F_GET_SORMINR_DATA  

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

AS_PREVIOUS_DEGREE

FOURTH_MINOR_DESC

SECOND_MINOR

THIRD_MINOR_DESC

FIRST_MINOR_DESC

FOURTH_MINOR

THIRD_MINOR

FIRST_MINOR

SECOND_MINOR_DESC

 
SOKODSF.F_REGISTERED_THIS_TERM        
SOKODSF.F_SARAPPD_INFO  

AS_ADMISSIONS_APPLICATION

AS_ADMISSIONS_APPLICATION

LATEST_DECISION

LATEST_DECISION_DATE

 
SOKODSF.F_SCRSYLO_LEARNING_OBJ  

AS_COURSE_CATALOG

LEARNING_OBJECTIVES

 
SOKODSF.F_SITE  

AS_CURRICULUM

AS_CURRICULUM

AS_CURRICULUM

AS_CURRICULUM

AS_CURRICULUM

AS_CURRICULUM

AS_CURRICULUM

AS_CURRICULUM

AS_CURRICULUM

AS_CURRICULUM

SITE_NATION

SITE_POSTAL_CODE

SITE_STREET_LINE1

SITE_STREET_LINE2

SITE_DESC

SITE_NATION_DESC

SITE_STATE_PROVINCE_DESC

SITE_STREET_LINE3

SITE_CITY

SITE_STATE_PROVINCE

 
SOKODSF.F_SORPCOL_INFO  

AS_PRE_STUDENT

AS_PRE_STUDENT

AS_PRE_STUDENT

AS_PRE_STUDENT

AS_PRE_STUDENT

AS_PRE_STUDENT

LATEST_POST_SECONDARY_SCHOOL

PS_TRANSCRIPT_RECEIVED_DATE

PS_ATTEND_FROM_DATE

PS_ATTEND_TO_DATE

PS_GPA_TRANSFERRED

PS_TRANSCRIPT_REVIEWED_DATE

 
SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''ASTD'',''C'')  

AS_ACADEMIC_STANDING

ACADEMIC_STANDING

 
SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''ASTD'',''D'')  

AS_ACADEMIC_STANDING

ACADEMIC_STANDING_DATE

 
SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''CAST'',''C'')  

AS_ACADEMIC_STANDING

COMBINED_ACAD_STANDING

 
SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''CAST'',''D'')  

AS_ACADEMIC_STANDING

COMBINED_ACAD_STANDING_DATE

 
SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''PREV'',''C'')  

AS_ACADEMIC_STANDING

PROGRESS_EVALUATION

 
SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''PREV'',''D'')  

AS_ACADEMIC_STANDING

PROGRESS_EVALUATION_DATE

 
SUBSTR (MAKFUNC.F_DESG_FINAID_FUND_IND       Determines if the fund is used in an advancement designation.
SUM (CURRENT_YTD_ACTIVITY WHEN INTERNAL_ACCOUNT_TYPE = '50')        
SUM (CURRENT_YTD_ACTIVITY WHEN INTERNAL_ACCOUNT_TYPE IN ('60','70', '80'))        
SUM(CASE WHEN INTERNAL_ACCOUNT_TYPE = '50' THEN CURR_YEAR_TO_DATE_ACTIVITY ELSE 0 END)        
SUM(CASE WHEN INTERNAL_ACCOUNT_TYPE IN ( '60','70','80') THEN CURR_YEAR_TO_DATE_ACTIVITY ELSE 0 END)        
SUM(EEC.GROSS)        
SUM(EMPLOYEE_CONTRIBUTION_AMOUNT)        
SUM(EMPLOYER_CONTRIBUTION_AMOUNT)        
SUM(NVL(AMRPEXP_EXPN_AMT, 0))  

AA_CONSTITUENT_CONTACT

TOTAL_EXPENSE

 
SUM(NVL(CURR_BUDGET_ADJUSTMENTS, 0))        
SUM(NVL(DECODE(FISCAL_PERIOD, FISCAL_PERIOD_IN,CURRENT_ACTUAL,0),0))        
SUM(NVL(DECODE(SIGN(12-FISCAL_PERIOD),- 1,0,CURRENT_ACTUAL),0))        
SUM(NVL(DECODE(SIGN(12-FISCAL_PERIOD),- 1,0,SUM_PERIODIC_CREDITS),0))        
SUM(NVL(DECODE(SIGN(12-FISCAL_PERIOD),- 1,0,SUM_PERIODIC_DEBITS),0))        
SUM(NVL(DECODE(SIGN(FISCAL_PERIOD- FISCAL_PERIOD_IN),-1,CURRENT_ACTUAL,0), 0) + (NVL(DECODE(FISCAL_PERIOD, FISCAL_PERIOD_IN,CURRENT_ACTUAL,0),0))        
SUM(NVL(DECODE(SIGN(FISCAL_PERIOD_IN- FISCAL_PERIOD),-1,0,CURRENT_ACTUAL),0))        
SUM(NVL(DECODE(SIGN(FISCAL_PERIOD_IN- FISCAL_PERIOD),-1,0, SUM_PERIODIC_CREDITS),0))        
SUM(NVL(DECODE(SIGN(FISCAL_PERIOD_IN- FISCAL_PERIOD),-1,0,SUM_PERIODIC_DEBITS) ,0))        
SUM(NVL(GL.SUM_YEAR_TO_DATE_ACTIVITY,0))        
SYSDATE  

AE_AUTHORIZATION

AE_ACCOUNTING

AE_REIMBURSEMENT

AE_STATUS_HISTORY

CURRENT_DATE

CURRENT_DATE

CURRENT_DATE

CURRENT_DATE

 
T = TEMPORARY, P = PERMANENT, C = CASUAL AND N = NONE        
TBD  

AP_FAMILY_MEDICAL_LEAVE_HIST

AP_FAMILY_MEDICAL_LEAVE_HIST

AS_FACULTY_FEEDBACK

AP_FAMILY_MEDICAL_LEAVE_HIST

AP_FAMILY_MEDICAL_LEAVE_HIST

AT_APPLICATION_OF_PAYMENT

AS_FACULTY_FEEDBACK

AP_FAMILY_MEDICAL_LEAVE_HIST

AP_FAMILY_MEDICAL_LEAVE_HIST

AS_FACULTY_FEEDBACK

AN_PERSONNEL_ACTION_GENERAL

AP_FAMILY_MEDICAL_LEAVE_HIST

AP_FAMILY_MEDICAL_LEAVE_HIST

AS_FACULTY_FEEDBACK

AT_APPLICATION_OF_PAYMENT

MILITARY_RELATE_TYPE_DESC

FMLA_YEAR_TYPE_DESC

STUDENT_MONITOR_IND

DURATION_DESIGNATION_DESC

FMLA_YEAR

ACCOUNT_POSTING_STATUS_DESC

FEEDBACK_TYPE_DESC

FMLA_SCHEDULE_TIME_STATUS_DESC

MILITARY_RECIPROCAL_TYPE_DESC

FEEDBACK_ESTIMATED_GRADE_IND

PAF_APPLY_STATUS_DESC

FMLA_ACTUAL_TIME_STATUS_DESC

FMLA_UNIT_DESC

FEEDBACK_COMMENT_IND

DIRECT_PAYMENT_TYPE_DESC

 
TBD??        
TOKODSF.F_ACCOUNT_BALANCE       This function returns the account balance from TBRACCD for a specified entity.
TOKODSF.F_AMOUNT_PAID  

AT_CONTRACT

AT_EXEMPTION

AMOUNT_PAID

AMOUNT_PAID

This function returns the summarized amount SUM(TBRACCD_AMOUNT) for contact or exemption for a specified UID and academic period.
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC  

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

CHARGE_ACTIVITY_DESC

PAYMENT_ACTIVITY_DESC

PAYMENT_ORGANIZATION_DESC

CHARGE_ACCOUNT_INDEX_DESC

PAYMENT_ACCOUNT_INDEX_DESC

PAYMENT_CHART_OF_ACCOUNTS_DESC

PAYMENT_LOCATION_DESC

PAYMENT_PROGRAM_DESC

CHARGE_ACCOUNT_DESC

CHARGE_CHART_OF_ACCOUNTS_DESC

CHARGE_ORGANIZATION_DESC

PAYMENT_FUND_DESC

CHARGE_FUND_DESC

CHARGE_LOCATION_DESC

CHARGE_PROGRAM_DESC

PAYMENT_ACCOUNT_DESC

substr(f_get_finance_desc('FTVCOAS',TBRMISD_CHARGE_COAS,NULL,35),1,35)
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS  

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

AT_MISCELLANEOUS_TRANSACTION

CHARGE_ACCOUNT_STATUS

CHARGE_ACTIVITY_STATUS

PAYMENT_FUND_STATUS

PAYMENT_PROGRAM_STATUS

CHARGE_ORGANIZATION_STATUS

PAYMENT_ACTIVITY_STATUS

CHARGE_LOCATION_STATUS

PAYMENT_CHART_STATUS

CHARGE_ACCOUNT_INDEX_STATUS

PAYMENT_ACCOUNT_STATUS

CHARGE_CHART_STATUS

CHARGE_FUND_STATUS

CHARGE_PROGRAM_STATUS

PAYMENT_ACCOUNT_INDEX_STATUS

PAYMENT_LOCATION_STATUS

PAYMENT_ORGANIZATION_STATUS

substr(f_get_finance_desc('FTVCOAS',TBRMISD_CHARGE_COAS,NULL,1),1,1)
TOKODSF.F_COUNT_COLLECTIONS  

AT_ACCOUNT

COLLECTION_COUNT

This function return a count of rows existing in the collection table (TBRCOLC) for a UID.
TOKODSF.F_COUNT_NSF        
TOKODSF.F_DEPOSIT_BALANCE       This function calculates the deposit balance for a specified entity by subtracting the TBRACCD_AMOUNT from TBRACCD, where the TBRACCD_SRCE_CODE = D, from the TBRDEPO_AMOUNT.
TOKODSF.F_OLDEST_EFFECTIVE_DATE       This function returns the oldest effective date TBRACCD_EFFECTIVE_DATE based on a specified pidm where the balance is not equal to 0.
TOKODSF.F_PLAN_AMOUNT  

AT_INSTALLMENT_PLAN

PLAN_AMOUNT

This function returns the automated plan amount SUM(TBRACCD_AMOUNT) for the specified UID, reference number and detail code where the source indicator is I.
TOKODSF.F_TERM_CODE_TBDS       This function returns a term-based detail code TBBTBDS_TBDS_CODE designator from TBBTBDS table for a specified academic period.
TO_CHAR (PERFMLA_BEGIN_DATE, 'YYYY')        
TO_DATE(MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_IN, Y.ACADEMIC_PERIOD, LEVEL_IN, 'ACADEMIC_STANDING_END_DT'),'YYYYMMDD')        
TO BE FILLED IN BY DEVELOPER  

AA_SOLICITOR_ORG_FUNDRAISER

PCT_PROG_SOLICITOR_DONOR_GOAL

 


Ver: