Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: FUNCTION Common Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: FUNCTION - NULL

Source Column Business Definition Target Target Column Calculation Formula
AOKODSF.F_CAMPAIGN_MULT_CREDIT  

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  

DEGREE

COMBINED_ACADEMIC_OUTCOME

ADDITIONAL_MAJORS_IND

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  

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  

SPECIAL_ACTIVITY

ACTIVITY

SPECIAL_ACTIVITY

SPECIAL_ACTIVITY_SLOT

ACTIVITY

SPECIAL_ACTIVITY_SLOT

SPECIAL_ACTIVITY

SPECIAL_ACTIVITY_SLOT

ACTIVITY

TOTAL_YEARS

TOTAL_YEARS

FIRST_YEAR

TOTAL_YEARS3

FIRST_YEAR

TOTAL_YEARS1

LAST_YEAR

TOTAL_YEARS2

LAST_YEAR

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  

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

HIGHEST_GIFT_AMOUNT_DATE3

HIGHEST_GIFT_AMOUNT_DATE

HIGHEST_GIFT_AMOUNT1

HIGHEST_GIFT_AMOUNT_DATE1

HIGHEST_GIFT_AMOUNT6

HIGHEST_GIFT_AMOUNT_DATE6

HIGHEST_GIFT_AMOUNT

HIGHEST_GIFT_AMOUNT2

HIGHEST_GIFT_AMOUNT5

HIGHEST_GIFT_AMOUNT_DATE2

HIGHEST_GIFT_AMOUNT_DATE4

HIGHEST_GIFT_AMOUNT_DATE5

HIGHEST_GIFT_AMOUNT3

HIGHEST_GIFT_AMOUNT4

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  

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

HIGHEST_PLEDGE_AMOUNT6

HIGHEST_PLEDGE_AMOUNT3

HIGHEST_PLEDGE_AMOUNT

HIGHEST_PLEDGE_AMOUNT2

HIGHEST_PLEDGE_AMOUNT5

HIGHEST_PLEDGE_AMOUNT1

HIGHEST_PLEDGE_AMOUNT4

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.

PLEDGE_INSTALLMENT

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.     AOKODSF.F_GET_MEMB_AMT_PAID(AARMEMB_PIDM)
AOKODSF.F_GET_SESSION_NUMBER  

GIFT

GIFT_TRANSACTION

POST_CASHIER_SESSION_NUMBER

POST_CASHIER_SESSION_NUMBER

NA
AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY  

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

TOTAL_ANT_MATCH_GIFT_ONE_PAY

TOTAL_ANT_MATCH_GIFT_ONE_PAY2

TOTAL_ANT_MATCH_GIFT_ONE_PAY6

TOTAL_ANT_MATCH_GIFT_ONE_PAY4

TOTAL_ANT_MATCH_GIFT_ONE_PAY3

TOTAL_ANT_MATCH_GIFT_ONE_PAY5

TOTAL_ANT_MATCH_GIFT_ONE_PAY1

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  

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

TOTAL_ANT_MATCH_GIFT_PAY5

TOTAL_ANT_MATCH_GIFT_PAY3

TOTAL_ANT_MATCH_GIFT_PAY2

TOTAL_ANT_MATCH_GIFT_PAY6

TOTAL_ANT_MATCH_GIFT_PAY1

TOTAL_ANT_MATCH_GIFT_PAY

TOTAL_ANT_MATCH_GIFT_PAY4

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  

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

TOTAL_GIVING4

TOTAL_GIVING1

TOTAL_GIVING3

TOTAL_GIVING

TOTAL_GIVING2

TOTAL_GIVING5

TOTAL_GIVING6

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

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

TOTAL_NON_MATCH_GIFT_MEMO6

TOTAL_NON_MATCH_GIFT_MEMO3

TOTAL_NON_MATCH_GIFT_MEMO1

TOTAL_NON_MATCH_GIFT_MEMO5

TOTAL_NON_MATCH_GIFT_MEMO4

TOTAL_NON_MATCH_GIFT_MEMO

TOTAL_NON_MATCH_GIFT_MEMO2

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  

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

TOTAL_NUMBER_OF_GIFTS3

TOTAL_NUMBER_OF_GIFTS5

TOTAL_NUMBER_OF_GIFTS4

TOTAL_NUMBER_OF_GIFTS2

TOTAL_NUMBER_OF_GIFTS

TOTAL_NUMBER_OF_GIFTS1

TOTAL_NUMBER_OF_GIFTS6

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  

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

TOTAL_NUMBER_OF_PLEDGES

TOTAL_NUMBER_OF_PLEDGES2

TOTAL_NUMBER_OF_PLEDGES3

TOTAL_NUMBER_OF_PLEDGES5

TOTAL_NUMBER_OF_PLEDGES6

TOTAL_NUMBER_OF_PLEDGES4

TOTAL_NUMBER_OF_PLEDGES1

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  

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

TOTAL_PLEDGE_AMOUNT

TOTAL_PLEDGE_AMOUNT1

TOTAL_PLEDGE_AMOUNT3

TOTAL_PLEDGE_AMOUNT2

TOTAL_PLEDGE_AMOUNT5

TOTAL_PLEDGE_AMOUNT4

TOTAL_PLEDGE_AMOUNT6

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  

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

TOTAL_PLEDGE_PAYMENTS5

TOTAL_PLEDGE_PAYMENTS2

TOTAL_PLEDGE_PAYMENTS

TOTAL_PLEDGE_PAYMENTS4

TOTAL_PLEDGE_PAYMENTS1

TOTAL_PLEDGE_PAYMENTS3

TOTAL_PLEDGE_PAYMENTS6

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  

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

TOTAL_REAL_MATCH_GIFT_ONE_PAY

TOTAL_REAL_MATCH_GIFT_ONE_PAY1

TOTAL_REAL_MATCH_GIFT_ONE_PAY3

TOTAL_REAL_MATCH_GIFT_ONE_PAY6

TOTAL_REAL_MATCH_GIFT_ONE_PAY4

TOTAL_REAL_MATCH_GIFT_ONE_PAY2

TOTAL_REAL_MATCH_GIFT_ONE_PAY5

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  

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

TOTAL_REAL_MATCH_GIFT_PAY1

TOTAL_REAL_MATCH_GIFT_PAY3

TOTAL_REAL_MATCH_GIFT_PAY2

TOTAL_REAL_MATCH_GIFT_PAY5

TOTAL_REAL_MATCH_GIFT_PAY

TOTAL_REAL_MATCH_GIFT_PAY4

TOTAL_REAL_MATCH_GIFT_PAY6

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  

GIFT_ASSOCIATED_ENTITY

GIFT_VOID_IND

NA
AOKODSF.F_GIFT_MATCH_PAID       NA
AOKODSF.F_LIFE_GIFT_SOCIETY  

CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

LIFE_GIFT_SOCIETY_TYPE

LIFE_GIFT_SOCIETY_TYPE

LIFE_GIFT_SOCIETY

LIFE_GIFT_SOCIETY

 
AOKODSF.F_MATCH_GIFT  

GIFT

GIFT_TRANSACTION

MATCHING_GIFT_IND

MATCHING_GIFT_IND

NA
AOKODSF.F_MATCH_GIFT_PAY  

GIFT

GIFT_TRANSACTION

MATCHING_GIFT_PAYMENT_IND

MATCHING_GIFT_PAYMENT_IND

NA
AOKODSF.F_PLEDGE_BALANCE,       NA
AOKODSF.F_PLEDGE_FULL_PAID,       NA
AOKODSF.F_PLEDGE_MATCH  

PLEDGE_TRANSACTION

PLEDGE

MATCHING_PLEDGE_IND

MATCHING_PLEDGE_IND

NA
AOKODSF.F_PLEDGE_PAID,       NA
AOKODSF.F_PLEDGE_PART_PAID,       NA
ATVCTYP_DESC  

PLEDGE_CONDITIONAL

CONDITION_TYPE_DESC

 
CASE WHEN ROWID = MSKFUNC.F_GET_PREF_ADDRESS_ROWID( ENTITY_UID) THEN 'Y' ELSE 'N' END       This function returns a 'Y' if this address has the highest sequence number of all of the preferred and active addresses for the person or entity based on the current date.
CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID > 0 AND SUM( AGRPDES_AMT_PAID) < AGRPDES_AMT_PAID THEN 'Y' ELSE 'N'        
DECODE(AGRGAUX_GIFT_ADJ_VOID_IND,'A', 'Y','N')  

GIFT_AUXILIARY

GIFT_ADJUSTMENT_IND

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

GIFT_AUXILIARY

GIFT_VOID_IND

NA
DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY', 'SECONDARY')        
DECODE(FOKODSF.F_GET_REST_IND)  

FUND_HIERARCHY

FUND_BALANCE_RESTRICTION_DESC

 
DECODE(GOKODSF.F_GET_DESC)  

ADMISSIONS_DECISION

DECISION_SOURCE

DECODE(SUBSTR(GOKODSF.F_GET_DESC(SARAPPD_APDC_CODE,'STVAPDC','STVTERM_STDN_ACC_IND'),1,1),'Y','Applicant','Institution')
DECODE(SARCHKL_RECEIVE_DATE)  

ADMISSIONS_REQUIREMENT

COMPLETED_IND

 
DECODE(SHRATTR_PIDM)        
DECODE(SHRTCKN_PIDM)        
DECODE(SORLCUR_TERM_CODE_MATRIC,NULL, 'N','Y')       NA
DECODE(STVDEGS_AWARD_STATUS_IND,'A','Y', 'N')  

ACADEMIC_OUTCOME

GRADUATED_IND

 
DECODE(STVRESD_IN_STATE_IND)  

STUDENT

RESIDENCY_IND

 
FBKBUDG.F_GETLOCKSTATUS  

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  

GENERAL_LEDGER

GRANT_FUND

GRANT_VIEW

PROPOSAL

ENCUMBRANCE_ACCOUNTING

GRANT_LEDGER

BUDGET_DETAIL

ENCUMBRANCE_LEDGER

BUDGET_DETAIL

OPERATING_LEDGER

FIXED_ASSET_ADJUSTMENT

PURCHASE_ORDER_ACCOUNTING

BUDGET_AVAILABILITY_LEDGER

PROPOSAL

PROPOSAL

PROPOSAL

INVOICE_ACCOUNTING

FISCAL_YEAR

STATUS_FISCAL_YEAR

STATUS_FISCAL_YEAR

ORIGINATION_FISCAL_YEAR

FISCAL_YEAR

GRANT_YEAR

BUDGET_YEAR

FISCAL_YEAR

BASE_FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

AWARD_FISCAL_YEAR

DECLINE_FISCAL_YEAR

SUBMISSION_FISCAL_YEAR

FISCAL_YEAR

NA
FOKODSF.F_AGCY_HIER  

PROPOSAL

PROPOSAL

PROPOSAL

PROPOSAL

AGENCY_UID_LEVEL_2

AGENCY_UID_LEVEL_1

AGENCY_UID_LEVEL_4

AGENCY_UID_LEVEL_3

 
FOKODSF.F_CALC_BLANKET_ORDER_BAL  

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  

GENERAL_LEDGER

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  

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  

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  

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_ACCT_HIER       This function returns the accounts, account titles, and account statuses within the hierarchy of a specified chart of accounts, account, and date. The data is concatenated together and separated by the character {.
FOKODSF.F_CONCAT_BVL_AMTS       This function is used to return the budget availability amounts from FGBBAVL for a given fiscal year, period, FOAPAL, and commitment type combination. The time indicator specifies whether cumulative amounts should be returned (S) or only current amounts (C). The data is concatenated together and separated by the character {.
FOKODSF.F_CONCAT_FUND_HIER       This function returns the funds, fund titles, and fund statuses within the hierarchy of a specified chart of accounts, fund and date. The data is concatenated together and separated by the character {.
FOKODSF.F_CONCAT_LOCN_HIER       This function returns the locations, location titles, and location statuses within the hierarchy of a specified chart of accounts, location and date. The data is concatenated together and separated by the character {.
FOKODSF.F_CONCAT_OP_AMTS  

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

CURRENT_BUDGET_ADJUSTMENTS

PRIOR_YTD_ACTIVITY

CURRENT_ADOPTED_BUDGET

CURRENT_BUDGET

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_CONCAT_ORGN_HIER       This function returns the organizations, organization titles, and organization statuses within the hierarchy of a specified chart of accounts, organization and date. The data is concatenated together and separated by the character {.
FOKODSF.F_CONCAT_PROG_HIER       This function returns the programs, program titles, and program statuses within the hierarchy of a specified chart of accounts, program and date. The data is concatenated together and separated by the character {.
FOKODSF.F_COST_AMT  

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   0 0" FACE="Arial" SIZE="2">PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

GENERAL_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

ACCOUNT_HI 0" FACE="Arial" SIZE="2">PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

GENERAL_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

GENERAL_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

ACCOUNT_HIERARCHY

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

C COLOR="#000000" FACE="Arial" SIZE="2">ACCOUNT_DESC_3

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_3

ACCOUNT_DESC_2

ACCOUNT_LEVEL_1

ACCOUNT_LEVEL_4

ACCOUNT_TYPE_STATUS_1

ACCOUNT_STATUS_2

ACCOUNT_STATUS_2

ACCOUNT_DESC_2

ACCOUNT_LEVEL_1

ACTUAL_ACCOUNT_DESC_2

ACTUAL_ACCOUNT_DESC_3

ACCOUNT_STATUS_3

ACCOUNT_DESC_1

ACCOUNT_LEVEL_1

ACCOUNT_STATUS_4

ACCOUNT_DESC_4

ACCOUNT_LEVEL_1

ACCOUNT_STATUS_1

ACCOUNT_STATUS_4

ACCOUNT_DESC_4

ACCOUNT_DESC_1

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_3

ACCOUNT_DESC_4

ACCOUNT_DESC_4

ACCOUNT_DESC_3

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_3

ACCOUNT_LEVEL_1

ACCOUNT_DESC_4

ACCOUNT_STATUS_4

ACCOUNT_DESC_1

ACCOUNT_DESC_2

ACCOUNT_LEVEL_1

ACCOUNT_DESC_3

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_3

ACCOUNT_DESC_2

ACCOUNT_LEVEL_1

ACCOUNT_LEVEL_4

ACCOUNT_TYPE_STATUS_1

ACCOUNT_STATUS_2

ACCOUNT_STATUS_2

ACCOUNT_DESC_2

ACCOUNT_LEVEL_1

ACTUAL_ACCOUNT_DESC_2

ACTUAL_ACCOUNT_DESC_3

ACCOUNT_STATUS_3

ACCOUNT_DESC_1

ACCOUNT_LEVEL_1

ACCOUNT_STATUS_4

ACCOUNT_DESC_4

ACCOUNT_LEVEL_1

ACCOUNT_STATUS_1

ACCOUNT_STATUS_4

ACCOUNT_DESC_4

ACCOUNT_DESC_1

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_3

ACCOUNT_DESC_4

ACCOUNT_DESC_4

ACCOUNT_DESC_3

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_3

ACCOUNT_LEVEL_1

ACCOUNT_DESC_4

ACCOUNT_STATUS_4

ACCOUNT_DESC_1

ACCOUNT_DESC_2

ACCOUNT_LEVEL_1

ACCOUNT_LEVEL_1

ACCOUNT_LEVEL_3

ACCOUNT_STATUS_1

ACCOUNT_STATUS_3

ACCOUNT_STATUS_2

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_1

ACCOUNT_STATUS_3

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_1

ACCOUNT_DESC_1

ACCOUNT_LEVEL_2

ACCOUNT_LEVEL_3

ACCOUNT_LEVEL_3

ACCOUNT_DESC_4

ACCOUNT_LEVEL_3

ACCOUNT_DESC_2

ACCOUNT_DESC_3

ACCOUNT_DESC_4

ACCOUNT_LEVEL_3

ACCOUNT_STATUS_2

ACCOUNT_STATUS_4ACCOUNT_DESC_3

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_3

ACCOUNT_DESC_2

ACCOUNT_LEVEL_1

ACCOUNT_LEVEL_4

ACCOUNT_TYPE_STATUS_1

ACCOUNT_STATUS_2

ACCOUNT_STATUS_2

ACCOUNT_DESC_2

ACCOUNT_LEVEL_1

ACTUAL_ACCOUNT_DESC_2

ACTUAL_ACCOUNT_DESC_3

ACCOUNT_STATUS_3

ACCOUNT_DESC_1

ACCOUNT_LEVEL_1

ACCOUNT_STATUS_4

ACCOUNT_DESC_4

ACCOUNT_LEVEL_1

ACCOUNT_STATUS_1

ACCOUNT_STATUS_4

ACCOUNT_DESC_4

ACCOUNT_DESC_1

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_3

ACCOUNT_DESC_4

ACCOUNT_DESC_4

ACCOUNT_DESC_3

ACCOUNT_LEVEL_4

ACCOUNT_LEVEL_3

ACCOUNT_LEVEL_1

ACCOUNT_DESC_4

ACCOUNT_STATUS_4

ACCOUNT_DESC_1

ACCOUNT_DESC_2

ACCOUNT_LEVEL_1

ACCOUNT_LEVEL_1

ACCOUNT_LEVEL_3

ACCOUNT_STATUS_1

ACCOUNT_STATUS_3

ACCOUNT_STATUS_2

ACCOUNT_TYPE_LEVEL_2

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_1

ACCOUNT_STATUS_3

ACCOUNT_LEVEL_2

ACCOUNT_STATUS_1

ACCOUNT_DESC_1

ACCOUNT_LEVEL_2

ACCOUNT_LEVEL_3

ACCOUNT_LEVEL_3

ACCOUNT_DESC_4

ACCOUNT_LEVEL_3

ACCOUNT_DESC_2

ACCOUNT_DESC_3

ACCOUNT_DESC_4

ACCOUNT_LEVEL_3

ACCOUNT_STATUS_2

ACCOUNT_STATUS_4

 
FOKODSF.F_GET_BVL_AMTS  

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

SUM_ENCUMBRANCES

SUM_YEAR_TO_DATE_ACTV

CURR_YEAR_TO_DATE_ACTV

SUM_REMAINING_BALANCE

CURR_REMAINING_BALANCE

CURR_ADOPTED_BUDGET

CURR_BUDGET_RESERVATION

SUM_PERCENT_AVAILABLE

SUM_BUDGET_ADJUSTMENTS

CURR_BUDGET_ADJUSTMENTS

CURR_ENCUMBRANCES

CURR_PERCENT_AVAILABLE

SUM_ADOPTED_BUDGET

SUM_BUDGET_RESERVATION

 
FOKODSF.F_GET_FINANCE_DESC  

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

FIXED_ASSET_FUNDING_SOURCE

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER

PURCHASE_ORDER

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

PROJECT_CODE_DESC

ACCOUNT_INDEX_DESC

FUND_DESC

PROJECT_DESC

ORGANIZATION_DESC

PROJECT_DESC

ACCOUNT_DESC

ACTIVITY_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

ORGANIZATION_DESC

 
FOKODSF.F_GET_FINANCE_STATUS  

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

FUND_STATUS

ACCOUNT_STATUS

ORGANIZATION_STATUS

PROGRAM_STATUS

ACTIVITY_STATUS

LOCATION_STATUS

CHART_OF_ACCOUNTS_STATUS

ACCOUNT_INDEX_STATUS

 
FOKODSF.F_GET_FTVCRSN_DESC  

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   g get.html">BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

INVOICE_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

INVOICE_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

INVOICE_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

INVOICE_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

FUND_HIERARCHY

FUND_HIERARCHY

GENERAL_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

C COLOR="#000000" FACE="Arial" SIZE="2">FUND_DESC_3

FUND_TYPE_LEVEL_2

FUND_LEVEL_3

FUND_LEVEL_4

FUND_STATUS_2

FUND_LEVEL_5

FUND_LEVEL_5

FUND_STATUS_5

FUND_DESC_5

FUND_LEVEL_1

FUND_LEVEL_2

FUND_STATUS_3

FUND_DESC_4

FUND_DESC_3

FUND_DESC_4

FUND_DESC_5

FUND_LEVEL_2

FUND_STATUS_4

FUND_TYPE_STATUS_2

FUND_DESC_2

FUND_LEVEL_1

FUND_STATUS_3

FUND_DESC_1

FUND_DESC_2

FUND_DESC_3

FUND_DESC_5

FUND_LEVEL_4

FUND_DESC_1

FUND_DESC_5

FUND_STATUS_1

FUND_STATUS_4

FUND_LEVEL_3

FUND_STATUS_4

FUND_DESC_1

FUND_DESC_2

FUND_DESC_5

FUND_STATUS_2

FUND_DESC_3

FUND_TYPE_LEVEL_2

FUND_LEVEL_3

FUND_LEVEL_4

FUND_STATUS_2

FUND_LEVEL_5

FUND_LEVEL_5

FUND_STATUS_5

FUND_DESC_5

FUND_LEVEL_1

FUND_LEVEL_2

FUND_STATUS_3

FUND_DESC_4

FUND_DESC_3

FUND_DESC_4

FUND_DESC_5

FUND_LEVEL_2

FUND_STATUS_4

FUND_TYPE_STATUS_2

FUND_DESC_2

FUND_LEVEL_1

FUND_STATUS_3

FUND_DESC_1

FUND_DESC_2

FUND_DESC_3

FUND_DESC_5

FUND_LEVEL_4

FUND_DESC_1

FUND_DESC_5

FUND_STATUS_1

FUND_STATUS_4

FUND_LEVEL_3

FUND_STATUS_4

FUND_DESC_1

FUND_DESC_2

FUND_DESC_5

FUND_STATUS_2

FUND_DESC_4

FUND_LEVEL_5

FUND_STATUS_3

FUND_LEVEL_5

ACTUAL_FUND_DESC_3

ACTUAL_FUND_DESC_4

FUND_STATUS_3

FUND_TYPE_LEVEL_1

FUND_TYPE_STATUS_1

FUND_DESC_1

FUND_LEVEL_3

FUND_STATUS_1

FUND_STATUS_2

FUND_STATUS_4

FUND_DESC_4

FUND_LEVEL_4

FUND_LEVEL_5

FUND_DESC_2

FUND_DESC_3

FUND_LEVEL_3

FUND_DESC_2

FUND_LEVEL_5

FUND_LEVEL_1

FUND_STATUS_1

FUND_DESC_3

FUND_TYPE_LEVEL_2

FUND_LEVEL_3

FUND_LEVEL_4

FUND_STATUS_2

FUND_LEVEL_5

FUND_LEVEL_5

FUND_STATUS_5

FUND_DESC_5

FUND_LEVEL_1

FUND_LEVEL_2

FUND_STATUS_3

FUND_DESC_4

FUND_DESC_3

FUND_DESC_4

FUND_DESC_5

FUND_LEVEL_2

FUND_STATUS_4

FUND_TYPE_STATUS_2

FUND_DESC_2

FUND_LEVEL_1

FUND_STATUS_3

FUND_DESC_1

FUND_DESC_2

FUND_DESC_3

FUND_DESC_5

FUND_LEVEL_4

FUND_DESC_1

FUND_DESC_5

FUND_STATUS_1

FUND_STATUS_4

FUND_LEVEL_3

FUND_STATUS_4

FUND_DESC_1

FUND_DESC_2

FUND_DESC_5

FUND_STATUS_2

FUND_DESC_4

FUND_LEVEL_5

FUND_STATUS_3

FUND_LEVEL_5

ACTUAL_FUND_DESC_3

ACTUAL_FUND_DESC_4

FUND_STATUS_3

FUND_TYPE_LEVEL_1

FUND_TYPE_STATUS_1

FUND_DESC_1

FUND_LEVEL_3

FUND_STATUS_1

FUND_STATUS_2

FUND_STATUS_4

FUND_DESC_4

FUND_LEVEL_4

FUND_LEVEL_5

FUND_DESC_2

FUND_DESC_3

FUND_LEVEL_3

FUND_DESC_2

FUND_LEVEL_5

FUND_LEVEL_1

FUND_STATUS_1

FUND_DESC_3

FUND_TYPE_LEVEL_2

FUND_LEVEL_3

FUND_LEVEL_4

FUND_STATUS_2

FUND_LEVEL_5

FUND_LEVEL_5

FUND_STATUS_5

FUND_DESC_5

FUND_LEVEL_1

FUND_LEVEL_2

FUND_STATUS_3

FUND_DESC_4

FUND_DESC_3

FUND_DESC_4

FUND_DESC_5

FUND_LEVEL_2

FUND_STATUS_4

FUND_TYPE_STATUS_2

FUND_DESC_2

FUND_LEVEL_1

FUND_STATUS_3

FUND_DESC_1

FUND_DESC_2

FUND_DESC_3

FUND_DESC_5

FUND_LEVEL_4

FUND_DESC_1

FUND_DESC_5

FUND_STATUS_1

FUND_STATUS_4

FUND_LEVEL_3

FUND_STATUS_4

FUND_DESC_1

FUND_DESC_2

FUND_DESC_5

FUND_STATUS_2

FUND_DESC_4

FUND_LEVEL_5

FUND_STATUS_3

FUND_LEVEL_5

ACTUAL_FUND_DESC_3

ACTUAL_FUND_DESC_4

FUND_STATUS_3

FUND_TYPE_LEVEL_1

FUND_TYPE_STATUS_1

FUND_DESC_1

FUND_LEVEL_3

FUND_STATUS_1

FUND_STATUS_2

FUND_STATUS_4

FUND_DESC_4

FUND_LEVEL_4

FUND_LEVEL_5

FUND_DESC_2

FUND_DESC_3

FUND_LEVEL_3

FUND_DESC_2

FUND_LEVEL_5

FUND_LEVEL_1

FUND_STATUS_1

 

FOKODSF.F_GET_LOCN_HIER   B BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

LOCATION_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

I BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

LOCATION_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

LOCATION_HIERARCHY

LOCATION_HIERARCHY

OPERATING_LEDGER

OPERATING_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

LOCATION_HIERARCHY

LOCATION_HIERARCHY

LOCATION_HIERARCHY

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

LOCATION_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

LOCATION_HIERARCHY

LOCATION_HIERARCHY

OPERATING_LEDGER

OPERATING_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

LOCATION_HIERARCHY

LOCATION_HIERARCHY

LOCATION_HIERARCHY

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

p p>LOCATION_DESC_1

LOCATION_DESC_5

LOCATION_LEVEL_2

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_DESC_2

LOCATION_DESC_3

LOCATION_LEVEL_2

LOCATION_DESC_1

LOCATION_STATUS_5

LOCATION_DESC_1

LOCATION_LEVEL_1

LOCATION_STATUS_2

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_DESC_4

LOCATION_DESC_5

LOCATION_STATUS_4

LOCATION_DESC_4

LOCATION_LEVEL_5

LOCATION_STATUS_5

LOCATION_STATUS_4

LOCATION_DESC_4

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_STATUS_1

LOCATION_STATUS_4

LOCATION_DESC_1

LOCATION_DESC_5

LOCATION_LEVEL_1

ACTUAL_LOCATION_DESC_2

ACTUAL_LOCATION_DESC_3

ACTUAL_LOCATION_DESC_5

LOCATION_DESC_3

LOCATION_DESC_3

LOCATION_DESC_1

LOCATION_DESC_5

LOCATION_LEVEL_2

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_DESC_2

LOCATION_DESC_3

LOCATION_LEVEL_2

LOCATION_DESC_1

LOCATION_STATUS_5

LOCATION_DESC_1

LOCATION_LEVEL_1

LOCATION_STATUS_2

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_DESC_4

LOCATION_DESC_5

LOCATION_STATUS_4

LOCATION_DESC_4

LOCATION_LEVEL_5

LOCATION_STATUS_5

LOCATION_STATUS_4

LOCATION_DESC_4

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_STATUS_1

LOCATION_STATUS_4

LOCATION_DESC_1

LOCATION_DESC_5

LOCATION_LEVEL_1

ACTUAL_LOCATION_DESC_2

ACTUAL_LOCATION_DESC_3

ACTUAL_LOCATION_DESC_5

LOCATION_DESC_3

LOCATION_DESC_3

LOCATION_LEVEL_1

LOCATION_STATUS_1

LOCATION_DESC_5

LOCATION_LEVEL_3

LOCATION_DESC_5

LOCATION_LEVEL_5

LOCATION_STATUS_3

LOCATION_DESC_5

LOCATION_LEVEL_3

LOCATION_DESC_1

LOCATION_LEVEL_5

LOCATION_DESC_2

LOCATION_LEVEL_2

LOCATION_STATUS_2

LOCATION_DESC_3

LOCATION_DESC_2

LOCATION_LEVEL_1

LOCATION_LEVEL_3

LOCATION_DESC_3

LOCATION_STATUS_1

LOCATION_LEVEL_1

LOCATION_STATUS_1

LOCATION_STATUS_5

LOCATION_DESC_1

LOCATION_DESC_5

LOCATION_LEVEL_2

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_DESC_2

LOCATION_DESC_3

LOCATION_LEVEL_2

LOCATION_DESC_1

LOCATION_STATUS_5

LOCATION_DESC_1

LOCATION_LEVEL_1

LOCATION_STATUS_2

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_DESC_4

LOCATION_DESC_5

LOCATION_STATUS_4

LOCATION_DESC_4

LOCATION_LEVEL_5

LOCATION_STATUS_5

LOCATION_STATUS_4

LOCATION_DESC_4

LOCATION_STATUS_3

LOCATION_STATUS_4

LOCATION_STATUS_1

LOCATION_STATUS_4

LOCATION_DESC_1

LOCATION_DESC_5

LOCATION_LEVEL_1

ACTUAL_LOCATION_DESC_2

ACTUAL_LOCATION_DESC_3

ACTUAL_LOCATION_DESC_5

LOCATION_DESC_3

LOCATION_DESC_3

LOCATION_LEVEL_1

LOCATION_STATUS_1

LOCATION_DESC_5

LOCATION_LEVEL_3

LOCATION_DESC_5

LOCATION_LEVEL_5

LOCATION_STATUS_3

LOCATION_DESC_5

LOCATION_LEVEL_3

LOCATION_DESC_1

LOCATION_LEVEL_5

LOCATION_DESC_2

LOCATION_LEVEL_2

LOCATION_STATUS_2

LOCATION_DESC_3

LOCATION_DESC_2

LOCATION_LEVEL_1

LOCATION_LEVEL_3

LOCATION_DESC_3

LOCATION_STATUS_1

LOCATION_LEVEL_1

LOCATION_STATUS_1

LOCATION_STATUS_5

 

FOKODSF.F_GET_MIN_QUANTITY        
FOKODSF.F_GET_ORGN_HIER   l l" SIZE="2">ORGANIZATION_HIERARCHY

PROPOSAL

PROPOSAL

PROPOSAL

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_VIEW

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

ORGANIZATION_HIERARCHY

PROPOSAL

PROPOSAL

PROPOSAL

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_VIEW

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

l" SIZE="2">ORGANIZATION_HIERARCHY

PROPOSAL

PROPOSAL

PROPOSAL

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_VIEW

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

l" SIZE="2">ORGANIZATION_HIERARCHY

PROPOSAL

PROPOSAL

PROPOSAL

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_VIEW

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

l" SIZE="2">ORGANIZATION_HIERARCHY

PROPOSAL

PROPOSAL

PROPOSAL

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_VIEW

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

PURCHASE_ORDER

PURCHASE_ORDER

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

0 00000" FACE="Arial" SIZE="2">ORGANIZATION_DESC_8

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_5

ORGANIZATION_LEVEL_7

ORGANIZATION_STATUS_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_2

ORGANIZATION_DESC_4

ORGANIZATION_STATUS_6

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_6

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_6

ORGANIZATION_STATUS_8

ACTUAL_ORGANIZATION_DESC_1

ACTUAL_ORGANIZATION_DESC_2

ORGANIZATION_LEVEL_2

ORGANIZATION_STATUS_8

ORGANIZATION_STATUS_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_5

ORGANIZATION_STATUS_8

ORGANIZATION_DESC_5

ORGANIZATION_DESC_7

ORGANIZATION_STATUS_6

ORGANIZATION_STATUS_7

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_DESC_1

ORGANIZATION_DESC_5

ORGANIZATION_DESC_8

ORGANIZATION_DESC_8

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_5

ORGANIZATION_LEVEL_7

ORGANIZATION_STATUS_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_2

ORGANIZATION_DESC_4

ORGANIZATION_STATUS_6

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_6

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_6

ORGANIZATION_STATUS_8

ACTUAL_ORGANIZATION_DESC_1

ACTUAL_ORGANIZATION_DESC_2

ORGANIZATION_LEVEL_2

ORGANIZATION_STATUS_8

ORGANIZATION_STATUS_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_5

ORGANIZATION_STATUS_8

ORGANIZATION_DESC_5

ORGANIZATION_DESC_7

ORGANIZATION_STATUS_6

ORGANIZATION_STATUS_7

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_DESC_1

ORGANIZATION_DESC_5

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_LEVEL_5

ORGANIZATION_DESC_6

ORGANIZATION_STATUS_2

ORGANIZATION_STATUS_7

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_3

ORGANIZATION_LEVEL_2

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_5

ORGANIZATION_STATUS_5

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_8

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_5

ORGANIZATION_LEVEL_7

ORGANIZATION_STATUS_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_2

ORGANIZATION_DESC_4

ORGANIZATION_STATUS_6

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_6

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_6

ORGANIZATION_STATUS_8

ACTUAL_ORGANIZATION_DESC_1

ACTUAL_ORGANIZATION_DESC_2

ORGANIZATION_LEVEL_2

ORGANIZATION_STATUS_8

ORGANIZATION_STATUS_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_5

ORGANIZATION_STATUS_8

ORGANIZATION_DESC_5

ORGANIZATION_DESC_7

ORGANIZATION_STATUS_6

ORGANIZATION_STATUS_7

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_DESC_1

ORGANIZATION_DESC_5

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_LEVEL_5

ORGANIZATION_DESC_6

ORGANIZATION_STATUS_2

ORGANIZATION_STATUS_7

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_3

ORGANIZATION_LEVEL_2

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_5

ORGANIZATION_STATUS_5

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_8

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_5

ORGANIZATION_LEVEL_7

ORGANIZATION_STATUS_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_2

ORGANIZATION_DESC_4

ORGANIZATION_STATUS_6

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_6

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_6

ORGANIZATION_STATUS_8

ACTUAL_ORGANIZATION_DESC_1

ACTUAL_ORGANIZATION_DESC_2

ORGANIZATION_LEVEL_2

ORGANIZATION_STATUS_8

ORGANIZATION_STATUS_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_5

ORGANIZATION_STATUS_8

ORGANIZATION_DESC_5

ORGANIZATION_DESC_7

ORGANIZATION_STATUS_6

ORGANIZATION_STATUS_7

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_DESC_1

ORGANIZATION_DESC_5

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_LEVEL_5

ORGANIZATION_DESC_6

ORGANIZATION_STATUS_2

ORGANIZATION_STATUS_7

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_3

ORGANIZATION_LEVEL_2

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_5

ORGANIZATION_STATUS_5

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_8

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_5

ORGANIZATION_LEVEL_7

ORGANIZATION_STATUS_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_2

ORGANIZATION_DESC_4

ORGANIZATION_STATUS_6

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_6

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_6

ORGANIZATION_STATUS_8

ACTUAL_ORGANIZATION_DESC_1

ACTUAL_ORGANIZATION_DESC_2

ORGANIZATION_LEVEL_2

ORGANIZATION_STATUS_8

ORGANIZATION_STATUS_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_5

ORGANIZATION_STATUS_8

ORGANIZATION_DESC_5

ORGANIZATION_DESC_7

ORGANIZATION_STATUS_6

ORGANIZATION_STATUS_7

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_DESC_1

ORGANIZATION_DESC_5

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_LEVEL_5

ORGANIZATION_DESC_6

ORGANIZATION_STATUS_2

ORGANIZATION_STATUS_7

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_3

ORGANIZATION_LEVEL_2

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_5

ORGANIZATION_STATUS_5

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_8

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_5

ORGANIZATION_LEVEL_7

ORGANIZATION_STATUS_5

ORGANIZATION_LEVEL_7

ORGANIZATION_DESC_2

ORGANIZATION_DESC_4

ORGANIZATION_STATUS_6

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_6

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_6

ORGANIZATION_STATUS_8

ACTUAL_ORGANIZATION_DESC_1

ACTUAL_ORGANIZATION_DESC_2

ORGANIZATION_LEVEL_2

ORGANIZATION_STATUS_8

ORGANIZATION_STATUS_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_5

ORGANIZATION_STATUS_8

ORGANIZATION_DESC_5

ORGANIZATION_DESC_7

ORGANIZATION_STATUS_6

ORGANIZATION_STATUS_7

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_DESC_1

ORGANIZATION_DESC_5

ORGANIZATION_DESC_8

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_LEVEL_5

ORGANIZATION_DESC_6

ORGANIZATION_STATUS_2

ORGANIZATION_STATUS_7

ORGANIZATION_DESC_3

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_2

ORGANIZATION_DESC_3

ORGANIZATION_LEVEL_2

ORGANIZATION_LEVEL_4

ORGANIZATION_LEVEL_8

ORGANIZATION_STATUS_2

ORGANIZATION_LEVEL_3

ORGANIZATION_LEVEL_5

ORGANIZATION_STATUS_5

ORGANIZATION_DESC_5

ORGANIZATION_LEVEL_7

 
FOKODSF.F_GET_PROG_HIER   G G

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

< G

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

< G

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

GRANT_LEDGER

INVOICE_ACCOUNTING

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

BUDGET_AVAILABILITY_LEDGER

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_LEDGER

GRANT_LEDGER

PROGRAM_HIERARCHY

PROGRAM_HIERARCHY

<

C CE="Arial" SIZE="2">PROGRAM_STATUS_3

PROGRAM_DESC_3

PROGRAM_DESC_5

PROGRAM_DESC_5

PROGRAM_DESC_2

PROGRAM_LEVEL_1

PROGRAM_LEVEL_3

PROGRAM_LEVEL_4

PROGRAM_STATUS_1

PROGRAM_STATUS_5

ACTUAL_PROGRAM_DESC_2

ACTUAL_PROGRAM_DESC_5

PROGRAM_LEVEL_2

PROGRAM_DESC_3

PROGRAM_LEVEL_2

PROGRAM_LEVEL_1

PROGRAM_LEVEL_5

PROGRAM_STATUS_4

PROGRAM_LEVEL_3

PROGRAM_LEVEL_4

PROGRAM_DESC_1

PROGRAM_STATUS_4

PROGRAM_LEVEL_2

PROGRAM_LEVEL_4

PROGRAM_LEVEL_5

PROGRAM_STATUS_2

PROGRAM_LEVEL_2

PROGRAM_STATUS_5

PROGRAM_DESC_1

PROGRAM_DESC_2

PROGRAM_DESC_1

PROGRAM_DESC_3

PROGRAM_LEVEL_5

PROGRAM_DESC_1

PROGRAM_DESC_4

PROGRAM_STATUS_3

PROGRAM_STATUS_3

PROGRAM_DESC_3

PROGRAM_DESC_5

PROGRAM_DESC_5

PROGRAM_DESC_2

PROGRAM_LEVEL_1

PROGRAM_LEVEL_3

PROGRAM_LEVEL_4

PROGRAM_STATUS_1

PROGRAM_STATUS_5

ACTUAL_PROGRAM_DESC_2

ACTUAL_PROGRAM_DESC_5

PROGRAM_LEVEL_2

PROGRAM_DESC_3

PROGRAM_LEVEL_2

PROGRAM_LEVEL_1

PROGRAM_LEVEL_5

PROGRAM_STATUS_4

PROGRAM_LEVEL_3

PROGRAM_LEVEL_4

PROGRAM_DESC_1

PROGRAM_STATUS_4

PROGRAM_LEVEL_2

PROGRAM_LEVEL_4

PROGRAM_LEVEL_5

PROGRAM_STATUS_2

PROGRAM_LEVEL_2

PROGRAM_STATUS_5

PROGRAM_DESC_1

PROGRAM_DESC_2

PROGRAM_DESC_1

PROGRAM_DESC_3

PROGRAM_LEVEL_5

PROGRAM_DESC_1

PROGRAM_DESC_4

PROGRAM_STATUS_3

PROGRAM_STATUS_5

PROGRAM_STATUS_2

PROGRAM_STATUS_1

PROGRAM_STATUS_2

PROGRAM_STATUS_5

PROGRAM_LEVEL_4

PROGRAM_LEVEL_5

PROGRAM_DESC_3

PROGRAM_LEVEL_2

PROGRAM_STATUS_2

PROGRAM_DESC_2

PROGRAM_LEVEL_1

PROGRAM_DESC_3

PROGRAM_LEVEL_4

PROGRAM_STATUS_3

ACTUAL_PROGRAM_DESC_4

PROGRAM_LEVEL_4

PROGRAM_STATUS_4

PROGRAM_STATUS_5

PROGRAM_STATUS_2

PROGRAM_DESC_2

PROGRAM_LEVEL_2

PROGRAM_STATUS_1

CE="Arial" SIZE="2">PROGRAM_STATUS_3

PROGRAM_DESC_3

PROGRAM_DESC_5

PROGRAM_DESC_5

PROGRAM_DESC_2

PROGRAM_LEVEL_1

PROGRAM_LEVEL_3

PROGRAM_LEVEL_4

PROGRAM_STATUS_1

PROGRAM_STATUS_5

ACTUAL_PROGRAM_DESC_2

ACTUAL_PROGRAM_DESC_5

PROGRAM_LEVEL_2

PROGRAM_DESC_3

PROGRAM_LEVEL_2

PROGRAM_LEVEL_1

PROGRAM_LEVEL_5

PROGRAM_STATUS_4

PROGRAM_LEVEL_3

PROGRAM_LEVEL_4

PROGRAM_DESC_1

PROGRAM_STATUS_4

PROGRAM_LEVEL_2

PROGRAM_LEVEL_4

PROGRAM_LEVEL_5

PROGRAM_STATUS_2

PROGRAM_LEVEL_2

PROGRAM_STATUS_5

PROGRAM_DESC_1

PROGRAM_DESC_2

PROGRAM_DESC_1

PROGRAM_DESC_3

PROGRAM_LEVEL_5

PROGRAM_DESC_1

PROGRAM_DESC_4

PROGRAM_STATUS_3

PROGRAM_STATUS_5

PROGRAM_STATUS_2

PROGRAM_STATUS_1

PROGRAM_STATUS_2

PROGRAM_STATUS_5

PROGRAM_LEVEL_4

PROGRAM_LEVEL_5

PROGRAM_DESC_3

PROGRAM_LEVEL_2

PROGRAM_STATUS_2

PROGRAM_DESC_2

PROGRAM_LEVEL_1

PROGRAM_DESC_3

PROGRAM_LEVEL_4

PROGRAM_STATUS_3

ACTUAL_PROGRAM_DESC_4

PROGRAM_LEVEL_4

PROGRAM_STATUS_4

PROGRAM_STATUS_5

PROGRAM_STATUS_2

PROGRAM_DESC_2

PROGRAM_LEVEL_2

PROGRAM_STATUS_1

CE="Arial" SIZE="2">PROGRAM_STATUS_3

PROGRAM_DESC_3

PROGRAM_DESC_5

PROGRAM_DESC_5

PROGRAM_DESC_2

PROGRAM_LEVEL_1

PROGRAM_LEVEL_3

PROGRAM_LEVEL_4

PROGRAM_STATUS_1

PROGRAM_STATUS_5

ACTUAL_PROGRAM_DESC_2

ACTUAL_PROGRAM_DESC_5

PROGRAM_LEVEL_2

PROGRAM_DESC_3

PROGRAM_LEVEL_2

PROGRAM_LEVEL_1

PROGRAM_LEVEL_5

PROGRAM_STATUS_4

PROGRAM_LEVEL_3

PROGRAM_LEVEL_4

PROGRAM_DESC_1

PROGRAM_STATUS_4

PROGRAM_LEVEL_2

PROGRAM_LEVEL_4

PROGRAM_LEVEL_5

PROGRAM_STATUS_2

PROGRAM_LEVEL_2

PROGRAM_STATUS_5

PROGRAM_DESC_1

PROGRAM_DESC_2

PROGRAM_DESC_1

PROGRAM_DESC_3

PROGRAM_LEVEL_5

PROGRAM_DESC_1

PROGRAM_DESC_4

PROGRAM_STATUS_3

PROGRAM_STATUS_5

PROGRAM_STATUS_2

PROGRAM_STATUS_1

PROGRAM_STATUS_2

PROGRAM_STATUS_5

PROGRAM_LEVEL_4

PROGRAM_LEVEL_5

PROGRAM_DESC_3

PROGRAM_LEVEL_2

PROGRAM_STATUS_2

PROGRAM_DESC_2

PROGRAM_LEVEL_1

PROGRAM_DESC_3

PROGRAM_LEVEL_4

PROGRAM_STATUS_3

ACTUAL_PROGRAM_DESC_4

PROGRAM_LEVEL_4

PROGRAM_STATUS_4

PROGRAM_STATUS_5

PROGRAM_STATUS_2

PROGRAM_DESC_2

PROGRAM_LEVEL_2

PROGRAM_STATUS_1

 
FOKODSF.F_GET_REST_IND  

FUND_HIERARCHY

FUND_BALANCE_RESTRICTION

 
FOKODSF.F_GET_SDAT_TITLE  

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

GENERAL_LEDGER

TRANSACTION_HISTORY

ENDOWMENT_DISTRIBUTION

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

ACCOUNT_HIERARCHY

FIXED_ASSET_ITEM

GRANT_FUND

GRANT_VIEW

OPERATING_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

FIXED_ASSET_ITEM

GRANT_FUND

GRANT_LEDGER

ACCOUNT_HIERARCHY

BUDGET_DETAIL

GRANT_FUND

GRANT_VIEW

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

GENERAL_LEDGER

GRANT_LEDGER

GRANT_VIEW

ENDOWMENT_UNITS

GRANT_BILLING_DETAIL

PROPOSAL

TRANSACTION_HISTORY

BUDGET_DETAIL

FUND_HIERARCHY

GRANT_FUND

l l#CATEGORY_DESC">CATEGORY_DESC

NA
FOKODSF.F_GET_SPONSOR_ACCT  

GRANT_LEDGER

SPONSOR_ACCOUNT

 
FOKODSF.F_GRANT_TO_FISCAL_YEAR  

GRANT_LEDGER

GRANT_LEDGER

FISCAL_PERIOD

FISCAL_YEAR

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  

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  

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  

FIXED_ASSET_DEPRECIATED_ITEM

FIXED_ASSET_ITEM

NET_BOOK_VALUE_AMOUNT

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  

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  

PURCHASE_ORDER_ITEM

ITEM_CHANGE_ORDER

 
FOKODSF.F_PO_LAST_CHANGE_DATE  

PURCHASE_ORDER

PO_CHANGE_DATE

NA
FOKODSF.F_PO_LAST_CHANGE_SEQNO  

PURCHASE_ORDER

PO_CHANGE_ORDER

NA
FOKODSF.F_REMAINING_LIFE  

FIXED_ASSET_DEPRECIATED_ITEM

FIXED_ASSET_DEPRECIATED_ITEM

FIXED_ASSET_DEPRECIATED_ITEM

FIXED_ASSET_DEPRECIATED_ITEM

REMAINING_LIFE_MONTHS

REMAINING_LIFE_YEARS

REMAINING_LIFE_SEMI_ANNUAL

REMAINING_LIFE_QUARTERS

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

FIXED_ASSET_DEPRECIATED_ITEM

FIXED_ASSET_ITEM

TOTAL_NET_BOOK_VALUE_AMOUNT

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  

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.
FORMAT_NAME       NA
FRKIDEN.F_GET_FRBGRNT_STATUS_CODE  

TRANSACTION_HISTORY

INVOICE_ACCOUNTING

OPERATING_LEDGER

GENERAL_LEDGER

FUND_HIERARCHY

GRANT_STATUS

GRANT_STATUS

GRANT_STATUS

GRANT_STATUS

GRANT_STATUS

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

GRANT_LEDGER

INVOICE_ACCOUNTING

OPERATING_LEDGER

FUND_HIERARCHY

GENERAL_LEDGER

TRANSACTION_HISTORY

GRANT_TITLE

GRANT_DESC

GRANT_DESC

GRANT_DESC

GRANT_DESC

GRANT_DESC

This function retrieves the FRBGRNT_TITLE from FRBGRNT for a specified grant.
FRKIDEN.F_GET_SPRIDEN_ENTITY_IND  

INVOICE

INVOICE

VENDOR_ENTITY_IND

THIRD_PARTY_ENTITY_IND

This function retrieves the SPRIDEN_ENTITY_IND from SPRIDEN for a specified entity.
FRKIDEN.F_GET_SPRIDEN_FIRST_NAME       This function retrieves the SPRIDEN_FIRST_NAME from SPRIDEN for a specified entity.
FRKIDEN.F_GET_SPRIDEN_ID       This function retrieves the SPRIDEN_ID from SPRIDEN for a specified entity.
FRKIDEN.F_GET_SPRIDEN_LAST_NAME  

TRANSACTION_HISTORY

BANK_NAME

This function retrieves the SPRIDEN_LAST_NAME from SPRIDEN for a specified entity.
FRKIDEN.F_GET_SPRIDEN_MI_NAME       This function retrieves the SPRIDEN_MI_NAME from SPRIDEN for a specified entity.
F_ACCOUNT_BALANCE  

RECEIVABLE_ACCOUNT

ACCOUNT_BALANCE

This function returns the account balance from TBRACCD for a specified entity.
F_ACTIVE_COURSE_IND  

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  

SCHEDULE_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  

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  

ADMISSIONS_APPLICATION

ADMISSIONS_APPLICATION

INCOMPLETE_IND

COMPLETE_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_ADMS_CHECK_STATUS       This function provides the functionality to return a specified status for a the decision based upon a specified combination of person, academic period, and application number. Based upon a parameter of I, S, or R the function will return whether the decision pertains to an (I)nsitutional accept, a (S)tudent accept, or a (R)ejection. It allows to for an additional parameter to specify whether the criteria should relate to (C)urrent accepts/reject or (A)ny accepts/rejects.
F_AGCY_HIER  

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

AGENCY_UID_LEVEL_1

AGENCY_UID_LEVEL_4

AGENCY_UID_LEVEL_2

AGENCY_UID_LEVEL_3

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_AMOUNT_DUE  

RECEIVABLE_ACCOUNT

CURRENT_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.
F_APPLIED_FOR_DEGREE  

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  

CONSTITUENT

GOVERNMENT_FINANCIAL_AID

GOVERNMENT_ADMISSIONS

GOVERNMENT_ACADEMIC_OUTCOME

PERSON_SENSITIVE

GOVERNMENT_STUDENT

CURRENT_AGE

AGE

AGE

AGE

AGE

AGE

This function calculates age for a specified as of date, birth date, and date of death. The age is not calculated beyond any specified, not null, deceased date.
F_CALC_REGISTRATION_HOURS  

STUDENT

STUDENT

STUDENT

GOVERNMENT_STUDENT

ENROLLMENT

ENROLLMENT

ENROLLMENT

STUDENT

GOVERNMENT_STUDENT

STUDENT

ENROLLMENT

STUDENT

GOVERNMENT_FINANCIAL_AID

ENROLLMENT

ENROLLMENT

TOTAL_CREDITS

TOTAL_NON_CEU_CREDITS

TOTAL_NON_CEU_BILLING

TOTAL_CREDITS

TOTAL_CEU_CREDITS

TOTAL_NON_CEU_BILLING

TOTAL_CEU_BILLING

TOTAL_BILLING

CEU_CREDITS_IND

TOTAL_CEU_CREDITS

TOTAL_NON_CEU_CREDITS

TOTAL_CEU_BILLING

TOTAL_CREDITS

TOTAL_BILLING

TOTAL_CREDITS

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  

FINAID_BUDGET_COMP_SLOT

FINAID_BUDGET_COMPONENT

BUDGET_TYPE_TOTAL_BUDGET

TOTAL_BUDGET

This function returns the summarized total of RBRACMP_AMT for the specified combination of entity, aid year, and budget type.
F_CALC_TOTAL_OFFER  

APPLICANT_NEED

TOTAL_OFFER_AMOUNT

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

CAMPAIGN_GIVING_HISTORY

CAMPAIGN_GIVING

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

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  

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  

COURSE_CATALOG

COURSE_PREREQS_COUNT

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  

COMBINED_ACADEMIC_OUTCOME

ACADEMIC_OUTCOME

TRANSFER_WORK_EXISTS_IND

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  

ACADEMIC_STUDY

GOVERNMENT_STUDENT

ENROLLMENT

STUDENT

STUDENT_CLASSIFICATION

STUDENT_CLASSIFICATION

STUDENT_CLASSIFICATION

STUDENT_CLASSIFICATION

This function returns the class code based upon the hours earned for a specified combination of entity, student level, and academic period.
F_CONCAT_SARAPPD       This function will concatenate up to five of an admissions applicant's most recent decisions including the decision (SARAPPD_APDC_CODE) and the decision date (SARAPPD_APDC_DATE).
F_CONCAT_SORPCOL       This function will concatenate prior college information for a specified entity. It will return data for up to three different prior colleges.
F_DEPOSIT_BALANCE  

RECEIVABLE_ACCOUNT

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.
F_DESIGNATION_GIVING  

DESIGNATION_GIVING_HISTORY

DESIGNATION_GIVING

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

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  

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  

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  

CONSTITUENT

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  

ACADEMIC_STUDY

ENROLLMENT

ENROLLED_IND

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  

ADDRESS

ADDRESS_BY_RULE

ADDRESS_CURRENT

PERSON

ORGANIZATION_ENTITY

ADDRESS_PREFERRED

INSTITUTION

ENRL_PLANNING_SERVICE

ENRL_PLANNING_SERVICE

ENRL_PLANNING_SERVICE

ENRL_PLANNING_SERVICE

ENRL_PLANNING_SERVICE

ENRL_PLANNING_SERVICE

ENRL_PLANNING_SERVICE

This function retrieves the enrollment planning sevices code for an address.
F_FACULTY_ADVISING_IND  

FACULTY

FACULTY

ELIGIBLE_TO_ADVISE_IND

ADVISING_THIS_PERIOD_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  

FACULTY

FACULTY

SCHEDULED_THIS_PERIOD_IND

ELIGIBLE_TO_BE_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  

STUDENT

ENROLLMENT

ADMISSIONS_APPLICATION

FINAID_APPLICANT_STATUS

FIN_AID_APPLICANT_IND

FIN_AID_APPLICANT_IND

FINAID_APPLICANT_IND

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  

PERSON_ADDRESS

PERSON_ADDRESS

PERSON_ADDRESS

PERSON_ADDRESS

MAILING_FORMAL_COUNTY

MAILING_INFORMAL

MAILING_INFORMAL_COUNTY

MAILING_FORMAL

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  

PERSON_VETERAN

INTERVIEW

INTERVIEW_SLOT

RECEIVABLE_ACCOUNT

PERSON_DETAIL

PERSON_INTERNATIONAL

INTERVIEW_SLOT

EVENT

PERSON_DETAIL

INTERVIEW_SLOT

PERSON

CONSTITUENT

PLEDGE_AUXILIARY

PLEDGE_AUXILIARY

LOAN_APPLICATION

ORGANIZATION_CONTACT

LOAN_APPLICATION

CONTACT

GIFT

TRANSACTION_HISTORY

STUDENT

ORGANIZATIONAL_CONSTITUENT

INTERVIEW_SLOT

LOAN_APPLICATION

COMMUNICATION

EVENT

MEDICAL_INFORMATION

PERSON

PERSON_SENSITIVE

FULL_NAME_LFMI

INTERVIEWER_NAME

INTERVIEWER_NAME2

NAME

FULL_NAME_LFMI

FULL_NAME_LFMI

INTERVIEWER_NAME4

AGENCY_DESC

FULL_NAME_FMIL

INTERVIEWER_NAME3

FULL_NAME_FMIL

NAME

ENTITY_IND

NAME

GUARANTOR_NAME

NAME

AGENCY_RETURN_NAME

NAME

NAME

VENDOR_NAME

NAME

NAME

INTERVIEWER_NAME1

LENDER_NAME

NAME

CONTACT_DESC

NAME

FULL_NAME_LFMI

FULL_NAME_LFMI

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  

AWARD_DISBURSEMENT

PROGRAM_CLASSIFICATION_DESC

 
F_GET_COST_ACCT       This function returns a 'D' for Direct Cost accounts, an 'I' for indirect cost accounts and a 'C' for Cost Share Accounts based on chart of accounts, account code and effective date.
F_GET_DATE_PREV_EDUCATION  

PREVIOUS_EDUCATION

TRANSCRIPT_REVIEWED_DATE

 
F_GET_FINANCE_DESC   N NITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_ITEM

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_FUND

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

ACCOUNT_INDEX

ACCOUNT_INDEX

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

ENCUMBRANCE_ACCOUNTING

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_ITEM

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_FUND

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

ACCOUNT_INDEX

ACCOUNT_INDEX

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

ENCUMBRANCE_ACCOUNTING

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ATTRIBUTES

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

GENERAL_LEDGER

GRANT_FUND

GRANT_FUND

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACCOUNT_INDEX

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_ITEM

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_FUND

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

ACCOUNT_INDEX

ACCOUNT_INDEX

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

ENCUMBRANCE_ACCOUNTING

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ATTRIBUTES

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

GENERAL_LEDGER

GRANT_FUND

GRANT_FUND

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACCOUNT_INDEX

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_ITEM

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_FUND

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

ACCOUNT_INDEX

ACCOUNT_INDEX

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

ENCUMBRANCE_ACCOUNTING

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ATTRIBUTES

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

GENERAL_LEDGER

GRANT_FUND

GRANT_FUND

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACCOUNT_INDEX

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_ITEM

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_FUND

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

OPERATING_LEDGER

PURCHASE_ORDER_ACCOUNTING

TRANSACTION_HISTORY

ACCOUNT_INDEX

ACCOUNT_INDEX

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

ENCUMBRANCE_ACCOUNTING

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

ENDOWMENT_UNITS

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ATTRIBUTES

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FUND_HIERARCHY

GENERAL_LEDGER

GRANT_FUND

GRANT_FUND

GRANT_FUND

GRANT_FUND_SLOT

GRANT_FUND_SLOT

GRANT_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACCOUNT_INDEX

ENDOWMENT_DISTRIBUTION

ENDOWMENT_DISTRIBUTION

C CCOUNTS_DESC">CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

FUND_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_DR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_ACTV_DESC

VARIANCE_DR_ORGN_POOL_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

LOCATION_DESC

BILL_ALTERNATE_FUND_DESC

BILL_FUND_DESC

BILL_LOCATION_DESC

FUND_PREDECESSOR_DESC

REVENUE_ACCRUAL_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC2

CHART_OF_ACCOUNTS_DESC8

FUND_POOL_DESC

LOCATION_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

DISCOUNT_RULE_CLASS_DESC

ACCOUNT_DESC

ACTIVITY_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

ACCOUNT_POOL_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

FUND_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_DR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_ACTV_DESC

VARIANCE_DR_ORGN_POOL_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

LOCATION_DESC

BILL_ALTERNATE_FUND_DESC

BILL_FUND_DESC

BILL_LOCATION_DESC

FUND_PREDECESSOR_DESC

REVENUE_ACCRUAL_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC2

CHART_OF_ACCOUNTS_DESC8

FUND_POOL_DESC

LOCATION_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

DISCOUNT_RULE_CLASS_DESC

ACCOUNT_DESC

ACTIVITY_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

ORGANIZATION_POOL_DESC

FUND_POOL_DESC

LOCATION_DESC

ORGANIZATION_POOL_DESC

ACTIVITY_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_LOCATION_DESC

UNREAL_GAIN_LOSS_DR_CHART_DESC

VARIANCE_SPEND_DR_CHART_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_ACCOUNT_DESC

INCOME_DR_CHART_POOL_DESC

UNREAL_GAIN_LOSS_DR_PROG_DESC

VARIANCE_DR_ACTV_POOL_DESC

ACCOUNT_DESC

EQUITY_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

FUND_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_DR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_ACTV_DESC

VARIANCE_DR_ORGN_POOL_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

LOCATION_DESC

BILL_ALTERNATE_FUND_DESC

BILL_FUND_DESC

BILL_LOCATION_DESC

FUND_PREDECESSOR_DESC

REVENUE_ACCRUAL_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC2

CHART_OF_ACCOUNTS_DESC8

FUND_POOL_DESC

LOCATION_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

DISCOUNT_RULE_CLASS_DESC

ACCOUNT_DESC

ACTIVITY_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

ORGANIZATION_POOL_DESC

FUND_POOL_DESC

LOCATION_DESC

ORGANIZATION_POOL_DESC

ACTIVITY_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_LOCATION_DESC

UNREAL_GAIN_LOSS_DR_CHART_DESC

VARIANCE_SPEND_DR_CHART_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_ACCOUNT_DESC

INCOME_DR_CHART_POOL_DESC

UNREAL_GAIN_LOSS_DR_PROG_DESC

VARIANCE_DR_ACTV_POOL_DESC

ACCOUNT_DESC

EQUITY_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

FUND_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_DR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_ACTV_DESC

VARIANCE_DR_ORGN_POOL_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

LOCATION_DESC

BILL_ALTERNATE_FUND_DESC

BILL_FUND_DESC

BILL_LOCATION_DESC

FUND_PREDECESSOR_DESC

REVENUE_ACCRUAL_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC2

CHART_OF_ACCOUNTS_DESC8

FUND_POOL_DESC

LOCATION_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

DISCOUNT_RULE_CLASS_DESC

ACCOUNT_DESC

ACTIVITY_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

ORGANIZATION_POOL_DESC

FUND_POOL_DESC

LOCATION_DESC

ORGANIZATION_POOL_DESC

ACTIVITY_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_LOCATION_DESC

UNREAL_GAIN_LOSS_DR_CHART_DESC

VARIANCE_SPEND_DR_CHART_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_ACCOUNT_DESC

INCOME_DR_CHART_POOL_DESC

UNREAL_GAIN_LOSS_DR_PROG_DESC

VARIANCE_DR_ACTV_POOL_DESC

ACCOUNT_DESC

EQUITY_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

FUND_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_DR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_ACTV_DESC

VARIANCE_DR_ORGN_POOL_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

LOCATION_DESC

BILL_ALTERNATE_FUND_DESC

BILL_FUND_DESC

BILL_LOCATION_DESC

FUND_PREDECESSOR_DESC

REVENUE_ACCRUAL_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC2

CHART_OF_ACCOUNTS_DESC8

FUND_POOL_DESC

LOCATION_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

DISCOUNT_RULE_CLASS_DESC

ACCOUNT_DESC

ACTIVITY_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

ORGANIZATION_POOL_DESC

FUND_POOL_DESC

LOCATION_DESC

ORGANIZATION_POOL_DESC

ACTIVITY_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_LOCATION_DESC

UNREAL_GAIN_LOSS_DR_CHART_DESC

VARIANCE_SPEND_DR_CHART_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_ACCOUNT_DESC

INCOME_DR_CHART_POOL_DESC

UNREAL_GAIN_LOSS_DR_PROG_DESC

VARIANCE_DR_ACTV_POOL_DESC

ACCOUNT_DESC

EQUITY_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

CHART_OF_ACCOUNTS_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

CHART_OF_ACCOUNTS_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_ACTV_POOL_DESC

FUND_DESC

GAIN_LOSS_CR_ACCT_POOL_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

INCOME_CR_FUND_DESC

INCOME_DR_PROG_POOL_DESC

UNREAL_GAIN_LOSS_DR_ACCT_DESC

UNREAL_GAIN_LOSS_DR_ACTV_DESC

VARIANCE_DR_ORGN_POOL_DESC

ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

LOCATION_DESC

LOCATION_DESC

BILL_ALTERNATE_FUND_DESC

BILL_FUND_DESC

BILL_LOCATION_DESC

FUND_PREDECESSOR_DESC

REVENUE_ACCRUAL_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC2

CHART_OF_ACCOUNTS_DESC8

FUND_POOL_DESC

LOCATION_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

DISCOUNT_RULE_CLASS_DESC

ACCOUNT_DESC

ACTIVITY_DESC

CHART_OF_ACCOUNTS_DESC

ACCOUNT_DESC

ACCOUNT_POOL_DESC

FUND_POOL_DESC

ORGANIZATION_POOL_DESC

FUND_POOL_DESC

LOCATION_DESC

ORGANIZATION_POOL_DESC

ACTIVITY_DESC

GAIN_LOSS_DR_LOCN_POOL_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_LOCATION_DESC

UNREAL_GAIN_LOSS_DR_CHART_DESC

VARIANCE_SPEND_DR_CHART_DESC

GAIN_LOSS_DR_ORGN_POOL_DESC

INCOME_CR_ACCOUNT_DESC

INCOME_DR_CHART_POOL_DESC

UNREAL_GAIN_LOSS_DR_PROG_DESC

VARIANCE_DR_ACTV_POOL_DESC

ACCOUNT_DESC

EQUITY_ACCOUNT_DESC

CHART_OF_ACCOUNTS_DESC

PROGRAM_DESC

CHART_OF_ACCOUNTS_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 NT>

FIXED_ASSET_FUNDING_SOURCE

GENERAL_LEDGER

GRANT_BILLING_DETAIL

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACCOUNT_INDEX

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_FUND

GRANT_RECEIVABLE_ACCT_DETAIL

INVOICE_ACCOUNTING

ACCOUNT_INDEX

ACCOUNT_INDEX

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

ENCUMBRANCE_ACCOUNTING

ENCUMBRANCE_ACCOUNTING

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FUND_HIERARCHY

OPERATING_LEDGER

TRANSACTION_HISTORY

ACCOUNT_INDEX

ACCOUNT_INDEX

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ NT>

FIXED_ASSET_FUNDING_SOURCE

GENERAL_LEDGER

GRANT_BILLING_DETAIL

INVOICE_ACCOUNTING

OPERATING_LEDGER

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

TRANSACTION_HISTORY

ACCOUNT_INDEX

BUDGET_AVAILABILITY_LEDGER

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

GRANT_BILLING_DETAIL

GRANT_BILLING_DETAIL

GRANT_FUND

GRANT_RECEIVABLE_ACCT_DETAIL

INVOICE_ACCOUNTING

ACCOUNT_INDEX

ACCOUNT_INDEX

BUDGET_AVAILABILITY_LEDGER

BUDGET_DETAIL

ENCUMBRANCE_ACCOUNTING

ENCUMBRANCE_ACCOUNTING

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_ACCOUNTING_SOURCE

FUND_HIERARCHY

OPERATING_LEDGER

TRANSACTION_HISTORY

ACCOUNT_INDEX

ACCOUNT_INDEX

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ADJUSTMENT

FIXED_ASSET_FUNDING_SOURCE

INVOICE_ACCOUNTING

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

BUDGET_DETAIL

ENCUMBRANCE_ACCOUNTING

FIXED_ASSET_ACCOUNTING_HISTORY

FIXED_ASSET_ACCOUNTING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

FIXED_ASSET_FUNDING_SOURCE

OPERATING_LEDGER

TRANSACTION_HISTORY

TRANSACTION_HISTORY

PAYROLL_DISTRIBUTION

HREF="BUDGET_AVAILABILITY_LEDGER_ODS_target.html#ORGANIZATION_STATUS">ORGANIZATION_STATUS

FUND_STATUS

ACCUMULATED_DEPR_ACCT_STATUS

EQUITY_ACCOUNT_STATUS

ORGANIZATION_STATUS

CHART_OF_ACCOUNTS_STATUS

BILL_FUND_STATUS

PROGRAM_STATUS

CHART_OF_ACCOUNTS_STATUS

FUND_STATUS

ACCOUNT_INDEX_STATUS

ORGANIZATION_STATUS

PROGRAM_STATUS

PROGRAM_STATUS

FUND_STATUS

PROGRAM_STATUS

ACCOUNT_STATUS

ASSET_ACCOUNT_STATUS

EQUITY_ACCOUNT_STATUS

LOCATION_STATUS

BILL_ACCOUNT_STATUS

BILL_ACTIVITY_STATUS

RESPONSIBLE_ORGN_STATUS

ACCOUNT_FUND_STATUS

CHART_OF_ACCOUNTS_STATUS

ACCOUNT_STATUS

FUND_STATUS

ACCOUNT_STATUS

ACTIVITY_STATUS

ACCOUNT_STATUS

CHART_OF_ACCOUNTS_STATUS

LOCATION_STATUS

ORGANIZATION_STATUS

CHART_OF_ACCOUNTS_STATUS

ORGANIZATION_STATUS

FUND_STATUS

ACCUMULATED_DEPR_ACCT_STATUS

EQUITY_ACCOUNT_STATUS

ORGANIZATION_STATUS

CHART_OF_ACCOUNTS_STATUS

BILL_FUND_STATUS

PROGRAM_STATUS

CHART_OF_ACCOUNTS_STATUS

FUND_STATUS

ACCOUNT_INDEX_STATUS

ORGANIZATION_STATUS

PROGRAM_STATUS

PROGRAM_STATUS

FUND_STATUS

PROGRAM_STATUS

ACCOUNT_STATUS

ASSET_ACCOUNT_STATUS

EQUITY_ACCOUNT_STATUS

LOCATION_STATUS

BILL_ACCOUNT_STATUS

BILL_ACTIVITY_STATUS

RESPONSIBLE_ORGN_STATUS

ACCOUNT_FUND_STATUS

CHART_OF_ACCOUNTS_STATUS

ACCOUNT_STATUS

FUND_STATUS

ACCOUNT_STATUS

ACTIVITY_STATUS

ACCOUNT_STATUS

CHART_OF_ACCOUNTS_STATUS

LOCATION_STATUS

ORGANIZATION_STATUS

CHART_OF_ACCOUNTS_STATUS

LOCATION_STATUS

ACTIVITY_STATUS

ACTIVITY_STATUS

ORGANIZATION_STATUS

LOCATION_STATUS

PROGRAM_STATUS

ACCOUNT_STATUS

LOCATION_STATUS

EQUITY_ACCOUNT_STATUS

PROGRAM_STATUS

FUND_STATUS

ORGANIZATION_STATUS

FUND_STATUS

LOCATION_STATUS

ORGANIZATION_STATUS

ORGANIZATION_STATUS

FUND_STATUS

ACCOUNT_STATUS

ACCOUNT_STATUS

FUND_STATUS

ACTIVITY_STATUS

ACCOUNT_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  

GRANT_FUND

GRANT_VIEW

STATUS_FISCAL_PERIOD

STATUS_FISCAL_PERIOD

This function retrieves the fiscal period based on fiscal year and chart of accounts passed.
F_GET_FISCAL_YEAR       This function retrieves the fiscal year based on chart of accounts and date passed.
F_GET_FSPD_STATUS  

BUDGET_AVAILABILITY_LEDGER

OPERATING_LEDGER

GENERAL_LEDGER

FISCAL_PERIOD_STATUS

FISCAL_PERIOD_STATUS

FISCAL_PERIOD_STATUS

This function retrieves the fiscal periods status for a given chart of accounts, fiscal year and fiscal period.
F_GET_PCKG_LOAD_IND  

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.
F_GET_SPONSOR_ACCT  

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  

PROPOSAL

PROPOSAL

PROPOSAL

PROPOSAL

ORIGINATION_DATE

AWARD_DATE

SUBMISSION_DATE

DECLINE_DATE

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

PROPOSAL

PROPOSAL

PROPOSAL

PROPOSAL

AWARD_FISCAL_PERIOD

DECLINE_FISCAL_PERIOD

ORIGINATION_FISCAL_PERIOD

SUBMISSION_FISCAL_PERIOD

This function retrieves the fiscal year or fiscal period based on a particalar status, proposal and chart of accounts.
F_GRADUATED_FROM_INSTITUTION       This function retrieves a 'Y' or 'N' based on the whether or not the person has graduated. This is determined by checking if the award status for this person is 'A' for Awarded.
F_HOUS_THIS_TERM  

STUDENT

ENROLLMENT

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  

ENROLLMENT

STUDENT

INQUIRER_IND

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  

STUDENT

ENROLLMENT

AWARD_BY_PERSON

INST_AID_RECIPIENT_IND

INST_AID_RECIPIENT_IND

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  

ENROLLMENT

STUDENT

ADMIT_IND

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  

ENROLLMENT

STUDENT

APPLICANT_IND

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_GIFT_SOCIETY       This function retrieves a gift society code or code type based on a person passed.
F_LIFE_TOTAL_COMMITMENT  

ORGANIZATIONAL_CONSTITUENT

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  

ORGANIZATIONAL_CONSTITUENT

CONSTITUENT

LIFE_TOTAL_GIVING

LIFE_TOTAL_GIVING

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

ORGANIZATIONAL_CONSTITUENT

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  

ORGANIZATIONAL_CONSTITUENT

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  

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       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_BALANCE  

RECEIVABLE_ACCOUNT

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)
F_MEMO_DETAIL_MATCHING_GIFT  

GIFT_MEMO

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  

TRACKING_REQUIREMENT_SLOT

FINAID_TRACKING_REQUIREMENT

TRACKING_REQUIREMENT_SLOT

TRACKING_REQUIREMENT_SLOT

MORE_SPECIFIC_REQ_IND2

MORE_SPECIFIC_REQ_IND

MORE_SPECIFIC_REQ_IND1

MORE_SPECIFIC_REQ_IND3

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  

ORGANIZATIONAL_CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

CONSTITUENT

CONSTITUENT

MOST_RECENT_GIFT_DATE

MOST_RECENT_GIFT_AMT

MOST_RECENT_GIFT_AMT

MOST_RECENT_GIFT_DATE

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  

CONSTITUENT

CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

MOST_RECENT_PLEDGE_AMT

MOST_RECENT_PLEDGE_DATE

MOST_RECENT_PLEDGE_DATE

MOST_RECENT_PLEDGE_AMT

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  

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_OLDEST_EFFECTIVE_DATE  

RECEIVABLE_ACCOUNT

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.
F_PAID_ADMISSIONS_DEPOSIT  

STUDENT

ENROLLMENT

DEPOSIT_IND

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  

TAX

EMPLOYEE

EMPLOYEE_POSITION

PROFILE_DATE

PROFILE_DATE

PROFILE_DATE

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

ENROLLMENT

STUDENT

PROSPECT_IND

PROSPECT_IND

This function always returns a N.
F_PROSPECT_IND  

CONSTITUENT

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  

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

EMPLOYER_CONTRIBUTION_QTR1

EMPLOYER_CONTRIBUTION_QTR4

APPLICABLE_GROSS_QTR2

APPLICABLE_GROSS_QTR4

EMPLOYEE_CONTRIBUTION_QRT1

EMPLOYEE_CONTRIBUTION_QRT4

EMPLOYER_CONTRIBUTION_QTR2

EMPLOYER_CONTRIBUTION_QTR3

EMPLOYEE_CONTRIBUTION_QRT3

APPLICABLE_GROSS_QTR1

APPLICABLE_GROSS_QTR3

EMPLOYEE_CONTRIBUTION_QRT2

This function calculates quarterly deduction total SUM(PERDTOT_EMPL_AMT) for a particular year for a specified UID.
F_RBRMIXD_DATA  

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  

ACADEMIC_STUDY

ENROLLMENT

REGISTERED_IND

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_AMOUNT_TERM  

RECEIVABLE_SUMMARY

AMOUNT

This function calculates the amount SUM(TBRACCD_AMOUNT) for a given term, category code and detail code.
F_SUM_BALANCE_TERM  

RECEIVABLE_SUMMARY

BALANCE

This function calculates the balance SUM(TBRACCD_BALANCE) for a given term, category code and detail code.
F_TERM_CODE_TBDS  

RECEIVABLE_ACCOUNT_DETAIL

RECEIVABLE_ACCOUNT_DETAIL

DEPOSIT

APPL_OF_PAY_DETAIL_ACCOUNTING

APPLICATION_OF_PAYMENT

APPLICATION_OF_PAYMENT

APPL_OF_PAY_DETAIL_ACCOUNTING

DEPOSIT

LEDGER_DESIGNATOR

OPERATING_DESIGNATOR

LEDGER_DESIGNATOR

CHARGE_OPERATING_DESIGNATOR

CHARGE_OPERATING_DESIGNATOR

PAY_OPERATING_DESIGNATOR

PAY_OPERATING_DESIGNATOR

OPERATING_DESIGNATOR

This function returns a term-based detail code TBBTBDS_TBDS_CODE designator from TBBTBDS table for a specified academic period.
F_TOTAL_HOUR_EARNING_CODE  

EMPLOYEE_EARNING_CY

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

EMPLOYEE_EARNING_CY

EMPL_EARN_CY_SLOT

EMPL_EARN_CY_SLOT

TOTAL_EARNINGS_YTD

TOTAL_EARNING_YTD7

TOTAL_HOUR_YTD4

TOTAL_HOUR_YTD7

TOTAL_EARNING_YTD

TOTAL_EARNING_YTD1

TOTAL_EARNING_YTD2

TOTAL_EARNING_YTD4

TOTAL_EARNING_YTD5

TOTAL_HOUR_YTD

TOTAL_HOUR_YTD2

TOTAL_HOUR_YTD6

TOTAL_HOUR_YTD8

TOTAL_HOUR_YTD3

TOTAL_HOUR_YTD5

TOTAL_EARNING_YTD6

TOTAL_EARNING_YTD8

TOTAL_EARNING_YTD_OTHER

TOTAL_HOUR_YTD1

TOTAL_HOURS_YTD

TOTAL_EARNING_YTD3

TOTAL_HOUR_YTD_OTHER

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  

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  

BENEFIT_DEDUCTION

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  

YEARLY_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCT_SLOT

BENEFIT_DEDUCTION

TAX

TAX

TAX

EMPLOYEE_CONTRIBUTION_YTD

EMPLOYEE_CONTRIBUTION_YTD

EMPLOYER_CONTRIBUTION_YTD

EMPLOYEE_CONTRIBUTION_YTD

EMPLOYER_CONTRIBUTION_YTD

GROSS_COMPENSATION_YTD

EMPLOYEE_CONTRIBUTION_YTD

EMPLOYER_CONTRIBUTION_YTD

GROSS_COMPENSATION_YTD

This function will calculate yearly deduction total PERDTOT based on the UID.
GOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC        
GOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS        
GOKODSF.F_DYNAMIC_GET_FNC       SUBSTR(GOKODSF.F_GET_DESC(TBBMISC_STAT_CODE,'STVSTAT'),1,30)
GOKODSF.F_FIND_CURRENT_ALL_IND        
GOKODSF.F_FORMAT_MAILING_ADDRESS  

ADDRESS

ADDRESS_CURRENT

ORGANIZATION_ENTITY_ADDRESS

ADDRESS_CURRENT

ADDRESS_BY_RULE

ADDRESS_PREFERRED

ORGANIZATION_ENTITY_ADDRESS

ADDRESS

ADDRESS_BY_RULE

ADDRESS_PREFERRED

MAILING_ADDRESS

MAILING_ADDRESS_COUNTY

MAILING_ADDRESS

MAILING_ADDRESS

MAILING_ADDRESS_COUNTY

MAILING_ADDRESS

MAILING_ADDRESS_COUNTY

MAILING_ADDRESS_COUNTY

MAILING_ADDRESS

MAILING_ADDRESS_COUNTY

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_PREFERRED_NAME  

PERSON

PERSON_ADDRESS

PERSON

PERSON_ADDRESS

PERSON_ADDRESS

PERSON

MAILING_NAME_PREFERRED

MAILING_NAME_INFORMAL

MAILING_NAME_FORMAL

MAILING_NAME_FORMAL

MAILING_NAME_PREFERRED

MAILING_NAME_INFORMAL

This function retrieves a name based upon a specified person and format. The format can be 'FORMAL', 'INFORMAL', or 'PREFERRED'.
GOKODSF.F_GET_DESC   A ACADEMIC_OUTCOME_ODS_target.html">GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_COURSE

GOVERNMENT_STUDENT

GOVERNMENT_STUDENT

GPA

MEETING_TIME_SLOT

MEETING_TIME_SLOT

NONINSTRUCT_ASSIGN_SLOT

NONINSTRUCT_ASSIGN_SLOT

NON_INSTRUCTIONAL_ASSIGNMENT

OUTCOME_DEPARTMENTAL_HONOR

OUTCOME_HONOR

PRE_STUDENT

SPORT_SLOT

STUDENT

STUDENT

STUDENT_ATTRIBUTE

STUDENT_COHORT

STUDENT_COHORT

STUDENT_COURSE_ATTRIBUTE

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

RECEIVABLE_ACCOUNTING

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_COURSE

GOVERNMENT_STUDENT

GOVERNMENT_STUDENT

GPA

MEETING_TIME_SLOT

MEETING_TIME_SLOT

NONINSTRUCT_ASSIGN_SLOT

NONINSTRUCT_ASSIGN_SLOT

NON_INSTRUCTIONAL_ASSIGNMENT

OUTCOME_DEPARTMENTAL_HONOR

OUTCOME_HONOR

PRE_STUDENT

SPORT_SLOT

STUDENT

STUDENT

STUDENT_ATTRIBUTE

STUDENT_COHORT

STUDENT_COHORT

STUDENT_COURSE_ATTRIBUTE

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

RECEIVABLE_ACCOUNTING

RECEIVABLE_ACCOUNTING

RECEIVABLE_ACCOUNTING

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

INTEREST_SLOT

INTEREST_SLOT

MEDICAL_INFORMATION

MEDICAL_INFORMATION_SLOT

PAST_EMPLOYMENT_SLOT

PERSON

PERSON_INTERNATIONAL

PERSON_SENSITIVE

PERSON_SENSITIVE

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

SECONDARY_SCHOOL_SUBJECT

VISA

VISA

YEAR_TYPE_DEFINITION

YEAR_TYPE_DEFINITION

DEGREE_SLOT

DEGREE_SLOT

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_COURSE

GOVERNMENT_STUDENT

GOVERNMENT_STUDENT

GPA

MEETING_TIME_SLOT

MEETING_TIME_SLOT

NONINSTRUCT_ASSIGN_SLOT

NONINSTRUCT_ASSIGN_SLOT

NON_INSTRUCTIONAL_ASSIGNMENT

OUTCOME_DEPARTMENTAL_HONOR

OUTCOME_HONOR

PRE_STUDENT

SPORT_SLOT

STUDENT

STUDENT

STUDENT_ATTRIBUTE

STUDENT_COHORT

STUDENT_COHORT

STUDENT_COURSE_ATTRIBUTE

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

RECEIVABLE_ACCOUNTING

RECEIVABLE_ACCOUNTING

RECEIVABLE_ACCOUNTING

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

INTEREST_SLOT

INTEREST_SLOT

MEDICAL_INFORMATION

MEDICAL_INFORMATION_SLOT

PAST_EMPLOYMENT_SLOT

PERSON

PERSON_INTERNATIONAL

PERSON_SENSITIVE

PERSON_SENSITIVE

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

SECONDARY_SCHOOL_SUBJECT

VISA

VISA

YEAR_TYPE_DEFINITION

YEAR_TYPE_DEFINITION

DEGREE_SLOT

DEGREE_SLOT

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_COURSE

GOVERNMENT_STUDENT

GOVERNMENT_STUDENT

GPA

MEETING_TIME_SLOT

MEETING_TIME_SLOT

NONINSTRUCT_ASSIGN_SLOT

NONINSTRUCT_ASSIGN_SLOT

NON_INSTRUCTIONAL_ASSIGNMENT

OUTCOME_DEPARTMENTAL_HONOR

OUTCOME_HONOR

PRE_STUDENT

SPORT_SLOT

STUDENT

STUDENT

STUDENT_ATTRIBUTE

STUDENT_COHORT

STUDENT_COHORT

STUDENT_COURSE_ATTRIBUTE

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

RECEIVABLE_ACCOUNTING

RECEIVABLE_ACCOUNTING

RECEIVABLE_ACCOUNTING

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

INTEREST_SLOT

INTEREST_SLOT

MEDICAL_INFORMATION

MEDICAL_INFORMATION_SLOT

PAST_EMPLOYMENT_SLOT

PERSON

PERSON_INTERNATIONAL

PERSON_SENSITIVE

PERSON_SENSITIVE

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

SECONDARY_SCHOOL_SUBJECT

VISA

VISA

YEAR_TYPE_DEFINITION

YEAR_TYPE_DEFINITION

DEGREE_SLOT

DEGREE_SLOT

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_ADMISSIONS

GOVERNMENT_COURSE

GOVERNMENT_STUDENT

GOVERNMENT_STUDENT

GPA

MEETING_TIME_SLOT

MEETING_TIME_SLOT

NONINSTRUCT_ASSIGN_SLOT

NONINSTRUCT_ASSIGN_SLOT

NON_INSTRUCTIONAL_ASSIGNMENT

OUTCOME_DEPARTMENTAL_HONOR

OUTCOME_HONOR

PRE_STUDENT

SPORT_SLOT

STUDENT

STUDENT

STUDENT_ATTRIBUTE

STUDENT_COHORT

STUDENT_COHORT

STUDENT_COURSE_ATTRIBUTE

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

APPL_OF_PAY_DETAIL_ACCOUNTING

RECEIVABLE_ACCOUNTING

RECEIVABLE_ACCOUNTING

RECEIVABLE_ACCOUNTING

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

INTEREST_SLOT

INTEREST_SLOT

MEDICAL_INFORMATION

MEDICAL_INFORMATION_SLOT

PAST_EMPLOYMENT_SLOT

PERSON

PERSON_INTERNATIONAL

PERSON_SENSITIVE

PERSON_SENSITIVE

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

SECONDARY_SCHOOL_SUBJECT

VISA

VISA

YEAR_TYPE_DEFINITION

YEAR_TYPE_DEFINITION

DEGREE_SLOT

DEGREE_SLOT

U ULE_ODS_target.html#SUBJECT_DESC">SUBJECT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

WORKLOAD_DESC

ACADEMIC_PERIOD_DESC

PROGRAM_CLASSIFICATION_DESC

ACTIVITY_DESC2

ACTIVITY_DESC4

ACTIVITY_DESC5

COUNTY_DESC

FIRST_MINOR_DESC

FOURTH_PROGRAM_CLASSIF_DESC

PRIMARY_ETHNICITY_DESC

PROGRAM_DESC

SECOND_PROGRAM_CLASSIFICATION

SPORT_STATUS_DESC2

STATE_PROVINCE_DESC

POST_SECONDARY_HONORS_DESC

TEST_DESC1

TEST_DESC7

TAXONOMY_OF_PROGRAM_DESC

ACTIVITY_DESC3

ACTIVITY_DESC4

ACADEMIC_YEAR

BUILDING_DESC10

SCHEDULE_DESC3

COLLEGE_DESC1

DEPARTMENT_DESC4

COLLEGE_DESC

DEGREE_DESC

DEGREE_DESC

POST_SECONDARY_DEGREE_DESC1

ELIGIBILITY_DESC4

ACADEMIC_YEAR_DESC

VETERAN_TYPE_DESC

SUBJECT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

WORKLOAD_DESC

ACADEMIC_PERIOD_DESC

PROGRAM_CLASSIFICATION_DESC

ACTIVITY_DESC2

ACTIVITY_DESC4

ACTIVITY_DESC5

COUNTY_DESC

FIRST_MINOR_DESC

FOURTH_PROGRAM_CLASSIF_DESC

PRIMARY_ETHNICITY_DESC

PROGRAM_DESC

SECOND_PROGRAM_CLASSIFICATION

SPORT_STATUS_DESC2

STATE_PROVINCE_DESC

POST_SECONDARY_HONORS_DESC

TEST_DESC1

TEST_DESC7

TAXONOMY_OF_PROGRAM_DESC

ACTIVITY_DESC3

ACTIVITY_DESC4

ACADEMIC_YEAR

BUILDING_DESC10

SCHEDULE_DESC3

COLLEGE_DESC1

DEPARTMENT_DESC4

COLLEGE_DESC

DEGREE_DESC

DEGREE_DESC

POST_SECONDARY_DEGREE_DESC1

ELIGIBILITY_DESC4

ACADEMIC_YEAR_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

COHORT_INACTIVE_REASON_DESC

ACADEMIC_YEAR

CHARGE_FUND_DESC

CHARGE_ORGANIZATION_DESC

PAY_ACCOUNT_DESC

PAY_FUND_DESC

A_ACCOUNT_DESC

A_ACTIVITY_DESC

A_RULE_CLASS_DESC1

COMMUNICATION_DESC1

MATERIAL_DESC2

SYSTEM_DESC4

INTEREST_DESC2

INTEREST_DESC5

ACADEMIC_PERIOD_DESC

DISABILITY_SERVICES_DESC3

EMPLOYER_TYPE_DESC3

NATION_OF_BIRTH_DESC

VISA_ISSUING_AUTHORITY_DESC

PRIMARY_MEDICAL_CONDITION_DESC< ULE_ODS_target.html#SUBJECT_DESC">SUBJECT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

WORKLOAD_DESC

ACADEMIC_PERIOD_DESC

PROGRAM_CLASSIFICATION_DESC

ACTIVITY_DESC2

ACTIVITY_DESC4

ACTIVITY_DESC5

COUNTY_DESC

FIRST_MINOR_DESC

FOURTH_PROGRAM_CLASSIF_DESC

PRIMARY_ETHNICITY_DESC

PROGRAM_DESC

SECOND_PROGRAM_CLASSIFICATION

SPORT_STATUS_DESC2

STATE_PROVINCE_DESC

POST_SECONDARY_HONORS_DESC

TEST_DESC1

TEST_DESC7

TAXONOMY_OF_PROGRAM_DESC

ACTIVITY_DESC3

ACTIVITY_DESC4

ACADEMIC_YEAR

BUILDING_DESC10

SCHEDULE_DESC3

COLLEGE_DESC1

DEPARTMENT_DESC4

COLLEGE_DESC

DEGREE_DESC

DEGREE_DESC

POST_SECONDARY_DEGREE_DESC1

ELIGIBILITY_DESC4

ACADEMIC_YEAR_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

COHORT_INACTIVE_REASON_DESC

ACADEMIC_YEAR

CHARGE_FUND_DESC

CHARGE_ORGANIZATION_DESC

PAY_ACCOUNT_DESC

PAY_FUND_DESC

A_ACCOUNT_DESC

A_ACTIVITY_DESC

A_RULE_CLASS_DESC1

COMMUNICATION_DESC1

MATERIAL_DESC2

SYSTEM_DESC4

INTEREST_DESC2

INTEREST_DESC5

ACADEMIC_PERIOD_DESC

DISABILITY_SERVICES_DESC3

EMPLOYER_TYPE_DESC3

NATION_OF_BIRTH_DESC

VISA_ISSUING_AUTHORITY_DESC

PRIMARY_MEDICAL_CONDITION_DESC< ULE_ODS_target.html#SUBJECT_DESC">SUBJECT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

WORKLOAD_DESC

ACADEMIC_PERIOD_DESC

PROGRAM_CLASSIFICATION_DESC

ACTIVITY_DESC2

ACTIVITY_DESC4

ACTIVITY_DESC5

COUNTY_DESC

FIRST_MINOR_DESC

FOURTH_PROGRAM_CLASSIF_DESC

PRIMARY_ETHNICITY_DESC

PROGRAM_DESC

SECOND_PROGRAM_CLASSIFICATION

SPORT_STATUS_DESC2

STATE_PROVINCE_DESC

POST_SECONDARY_HONORS_DESC

TEST_DESC1

TEST_DESC7

TAXONOMY_OF_PROGRAM_DESC

ACTIVITY_DESC3

ACTIVITY_DESC4

ACADEMIC_YEAR

BUILDING_DESC10

SCHEDULE_DESC3

COLLEGE_DESC1

DEPARTMENT_DESC4

COLLEGE_DESC

DEGREE_DESC

DEGREE_DESC

POST_SECONDARY_DEGREE_DESC1

ELIGIBILITY_DESC4

ACADEMIC_YEAR_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

COHORT_INACTIVE_REASON_DESC

ACADEMIC_YEAR

CHARGE_FUND_DESC

CHARGE_ORGANIZATION_DESC

PAY_ACCOUNT_DESC

PAY_FUND_DESC

A_ACCOUNT_DESC

A_ACTIVITY_DESC

A_RULE_CLASS_DESC1

COMMUNICATION_DESC1

MATERIAL_DESC2

SYSTEM_DESC4

INTEREST_DESC2

INTEREST_DESC5

ACADEMIC_PERIOD_DESC

DISABILITY_SERVICES_DESC3

EMPLOYER_TYPE_DESC3

NATION_OF_BIRTH_DESC

VISA_ISSUING_AUTHORITY_DESC

PRIMARY_MEDICAL_CONDITION_DESC< ULE_ODS_target.html#SUBJECT_DESC">SUBJECT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

WORKLOAD_DESC

ACADEMIC_PERIOD_DESC

PROGRAM_CLASSIFICATION_DESC

ACTIVITY_DESC2

ACTIVITY_DESC4

ACTIVITY_DESC5

COUNTY_DESC

FIRST_MINOR_DESC

FOURTH_PROGRAM_CLASSIF_DESC

PRIMARY_ETHNICITY_DESC

PROGRAM_DESC

SECOND_PROGRAM_CLASSIFICATION

SPORT_STATUS_DESC2

STATE_PROVINCE_DESC

POST_SECONDARY_HONORS_DESC

TEST_DESC1

TEST_DESC7

TAXONOMY_OF_PROGRAM_DESC

ACTIVITY_DESC3

ACTIVITY_DESC4

ACADEMIC_YEAR

BUILDING_DESC10

SCHEDULE_DESC3

COLLEGE_DESC1

DEPARTMENT_DESC4

COLLEGE_DESC

DEGREE_DESC

DEGREE_DESC

POST_SECONDARY_DEGREE_DESC1

ELIGIBILITY_DESC4

ACADEMIC_YEAR_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

COHORT_INACTIVE_REASON_DESC

ACADEMIC_YEAR

CHARGE_FUND_DESC

CHARGE_ORGANIZATION_DESC

PAY_ACCOUNT_DESC

PAY_FUND_DESC

A_ACCOUNT_DESC

A_ACTIVITY_DESC

A_RULE_CLASS_DESC1

COMMUNICATION_DESC1

MATERIAL_DESC2

SYSTEM_DESC4

INTEREST_DESC2

INTEREST_DESC5

ACADEMIC_PERIOD_DESC

DISABILITY_SERVICES_DESC3

EMPLOYER_TYPE_DESC3

NATION_OF_BIRTH_DESC

VISA_ISSUING_AUTHORITY_DESC

PRIMARY_MEDICAL_CONDITION_DESC< ULE_ODS_target.html#SUBJECT_DESC">SUBJECT_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

WORKLOAD_DESC

ACADEMIC_PERIOD_DESC

PROGRAM_CLASSIFICATION_DESC

ACTIVITY_DESC2

ACTIVITY_DESC4

ACTIVITY_DESC5

COUNTY_DESC

FIRST_MINOR_DESC

FOURTH_PROGRAM_CLASSIF_DESC

PRIMARY_ETHNICITY_DESC

PROGRAM_DESC

SECOND_PROGRAM_CLASSIFICATION

SPORT_STATUS_DESC2

STATE_PROVINCE_DESC

POST_SECONDARY_HONORS_DESC

TEST_DESC1

TEST_DESC7

TAXONOMY_OF_PROGRAM_DESC

ACTIVITY_DESC3

ACTIVITY_DESC4

ACADEMIC_YEAR

BUILDING_DESC10

SCHEDULE_DESC3

COLLEGE_DESC1

DEPARTMENT_DESC4

COLLEGE_DESC

DEGREE_DESC

DEGREE_DESC

POST_SECONDARY_DEGREE_DESC1

ELIGIBILITY_DESC4

ACADEMIC_YEAR_DESC

VETERAN_TYPE_DESC

ACADEMIC_PERIOD_DESC

ACADEMIC_YEAR

COHORT_INACTIVE_REASON_DESC

ACADEMIC_YEAR

CHARGE_FUND_DESC

CHARGE_ORGANIZATION_DESC

PAY_ACCOUNT_DESC

PAY_FUND_DESC

A_ACCOUNT_DESC

A_ACTIVITY_DESC

A_RULE_CLASS_DESC1

COMMUNICATION_DESC1

MATERIAL_DESC2

SYSTEM_DESC4

INTEREST_DESC2

INTEREST_DESC5

ACADEMIC_PERIOD_DESC

DISABILITY_SERVICES_DESC3

EMPLOYER_TYPE_DESC3

NATION_OF_BIRTH_DESC

VISA_ISSUING_AUTHORITY_DESC

PRIMARY_MEDICAL_CONDITION_DESC<

This function returns the description field for the specified validation table for the specified code from the validation table.
GOKODSF.F_GET_NULL_VARCHAR2  

ACADEMIC_STUDY

ACADEMIC_STUDY

ACADEMIC_STUDY

ACADEMIC_STUDY

ACADEMIC_STUDY

MISCELLANEOUS_TRANSACTION

ACADEMIC_STUDY

MISCELLANEOUS_TRANSACTION

ACADEMIC_STUDY

SITE_CARRIER_ROUTE

SITE_COUNTY_CODE_DESC

SITE_COUNTY_CODE

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD_DESC

PAYMENT_RULE_CLASS_DESC

SITE_CORRECTION_DIGIT

CHARGE_RULE_CLASS_DESC

SITE_DELIVERY_POINT

NA
GOKODSF.F_GURMAIL_MODULE_CODE_DESC  

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SOURCE_DESC2

COMMUNICATION_SOURCE_DESC5

COMMUNICATION_SOURCE_DESC

COMMUNICATION_SOURCE_DESC3

COMMUNICATION_SOURCE_DESC4

COMMUNICATION_SOURCE_DESC1

NA
GOKODSF.F_PREFERRED_ADDRESS_IND  

ADDRESS_BY_RULE

ADDRESS

ADDRESS_CURRENT

PREFERRED_ADDRESS_IND

PREFERRED_ADDRESS_IND

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  

PLEDGE_CONDITIONAL

PLEDGE_AUXILIARY

EVENT_INVITEE

CONDITION_COMMENT

AUXILIARY_COMMENT

INVITEE_COMMENT

NA
GTVEMAL_DESC        
LOAD_MGT_CALENDAR_DATE  

CALENDAR_DATE_HIERARCHY

CALENDAR_DATE_HIERARCHY

CALENDAR_DATE_HIERARCHY

CALENDAR_DATE_HIERARCHY

CALENDAR_DATE_HIERARCHY

CALENDAR_DATE_HIERARCHY

CALENDAR_DATE_HIERARCHY

CALENDAR_DAY

CALENDAR_DAY_OF_WEEK

CALENDAR_MONTH

CALENDAR_MONTH_ABBREV

CALENDAR_YEAR

CALENDAR_DATE

CALENDAR_MONTH_DESC

 
MAKFUNC.F_ADVANCEMENT_RATING_COUNT  

PROSPECT_INFO

ADVANCEMENT_RATING_COUNT

This function retrieves a count of advancement ratings associated with a person.
MAKFUNC.F_COUNT_ADVANCEMENT_RATING  

CONSTITUENT

EXTERNAL_SOURCE_COUNT

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  

PROSPECT_INFO

CONSTITUENT_CONTACT_COUNT

This function returns a count of the MAT_CONSTITUENT_CONTACT records for the parameter supplied UID.
MAKFUNC.F_COUNT_DEGREES  

CONSTITUENT

DEGREE_COUNT

This function returns a count of the MAT_DEGREE records for the parameter supplied UID.
MAKFUNC.F_COUNT_DONOR_CATEGORY  

ORGANIZATIONAL_CONSTITUENT

CONSTITUENT

DONOR_CATEGORY_COUNT

DONOR_CATEGORY_COUNT

This function returns a count of the MAT_DONOR_CATEGORY records for the parameter supplied UID.
MAKFUNC.F_COUNT_EXCLUSION  

CONSTITUENT

EXCLUSION_COUNT

This function returns a count of the MAT_EXCLUSION records for the parameter supplied UID.
MAKFUNC.F_COUNT_FUNDING_INT  

ORGANIZATIONAL_CONSTITUENT

FUND_COUNT

This function returns a count of the MAT_FUNDING_INTEREST records for the parameter supplied UID.
MAKFUNC.F_COUNT_GIFT_ASSOCIATED_ENTITY  

GIFT_TRANSACTION

GIFT

GIFT_ASSOCIATED_ENTITY_COUNT

GIFT_ASSOCIATED_ENTITY_COUNT

NA
MAKFUNC.F_COUNT_GIFT_AUXILIARY  

GIFT_TRANSACTION

GIFT

GIFT_AUXILIARY_COUNT

GIFT_AUXILIARY_COUNT

This function returns a count of the MAT_GIFT_AUXILIARY records for the parameter supplied UID and Gift Number.
MAKFUNC.F_COUNT_GIFT_SOCIETY  

ANNUAL_GIVING

GIFT_SOCIETY_COUNT

This function retrieves a count of gift societies with whom a particular identification is associated for a specified year.
MAKFUNC.F_COUNT_GIFT_SOLICITOR  

GIFT

GIFT_TRANSACTION

SOLICITATION_COUNT

SOLICITOR_COUNT

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  

CONSTITUENT

MAIL_COUNT

This function returns a count of the MAT_MAIL records for the parameter supplied UID.
MAKFUNC.F_COUNT_MATCH_GIFT  

GIFT_TRANSACTION

GIFT

MATCHING_GIFT_COUNT

MATCHING_GIFT_COUNT

This function returns a count of the MAT_GIFT_MATCHING records for the parameter supplied UID and Gift Number.
MAKFUNC.F_COUNT_MATCH_PLEDGE  

PLEDGE_TRANSACTION

PLEDGE

MATCHING_PLEDGE_COUNT

MATCHING_PLEDGE_COUNT

This function returns a count of the MAT_PLEDGE_MATCHING records for the parameter supplied UID and Pledge Number.
MAKFUNC.F_COUNT_ORGN_CONTACT  

ORGANIZATIONAL_CONSTITUENT

CONSTITUENT_ENTITY

CONTACT_COUNT

CONTACT_COUNT

This function returns a count of the MAT_ORGANIZATION_CONTACT records for the parameter supplied UID.
MAKFUNC.F_COUNT_PLEDGE_SOLICITOR  

PLEDGE_TRANSACTION

PLEDGE

SOLICITOR_COUNT

SOLICITATION_COUNT

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  

CONSTITUENT

EMPLOYMENT_COUNT

This function returns a count of the MAT_previous_employment records for the parameter supplied UID.
MAKFUNC.F_COUNT_RELATION  

CONSTITUENT

CONSTITUENT

CHILD_COUNT

CROSS_REFERENCE_COUNT

This function returns a count of the MAT_RELATION records for the parameter supplied UID and Relation Type Indicator.
MAKFUNC.F_COUNT_SPECIAL_ACTIVITY  

CONSTITUENT

SPECIAL_ACTIVITY_COUNT

This function returns a count of the MAT_SPECIAL_ACTIVITY records for the parameter supplied UID.
MAKFUNC.F_COUNT_SPECIAL_PURP  

CONSTITUENT

SPECIAL_PURPOSE_GROUP_COUNT

This function returns a count of the MAT_SPECIAL_PURPOSE_GROUP records for the parameter supplied UID.
MAKFUNC.F_COUNT_STAFF_ASSIGNMENT  

CONSTITUENT_CONTACT

PROSPECT_INFO

STAFF_ASSIGNED_COUNT

STAFF_ASSIGNMENT_COUNT

This function returns a count of the number of MAT_CONSTITUENT_STAFF_ASSIGN records for the parameter supplied UID.
MAKFUNC.F_GET_ENTITY_IND  

PLEDGE_MATCHING

PLEDGE_MATCHING_TRANSACTION

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_CONDITIONAL

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_IND

 
MAKFUNC.F_GET_PLEDGE_INSTALL_IND  

PLEDGE_TRANSACTION

PLEDGE

PLEDGE_INSTALLMENT_IND

PLEDGE_INSTALLMENT_IND

SUBSTR(MAKFUNC.F_GET_PLEDGE_INSTALL_IND(MAT_PLEDGE.ENTITY_UID, PLEDGE_NUMBER),1,1)
MAKFUNC.F_GET_SPOUSE_IND  

CONSTITUENT

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.

CONSTITUENT

SPOUSE_NAME

SUBSTR(MAKFUNC.F_GET_SPOUSE_NAME(C.ENTITY_UID),1,100),
MFKFUNC.F_GET_BOOK_AMOUNT  

ENDOWMENT_SUMMARIZED_UNITS

AGGREGATE_BOOK_AMOUNT

NA
MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID  

RECEIVED_ITEM

RECEIVED_ITEM

RECEIVED_ITEM

RECEIVED_ITEM

RECEIVED_ITEM

RECEIVED_ITEM

RECEIVED_ITEM

RETURN_SEQUENCE_NUMBER

RETURN_UNIT_OF_MEASURE

QUANTITY_RETURNED

RETURN_REASON

RETURN_REASON_DESC

RETURN_DOCUMENT

RETURN_UNIT_OF_MEASURE_DESC

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  

ENDOWMENT_SUMMARIZED_UNITS

AGGREGATE_UNITS_PURCHASED

NA
MFKFUNC.F_GET_VENDOR_FIELDS  

INVOICE

RECEIVED_ITEM

RETURNED_ITEM

RECEIVED_ITEM

RETURNED_ITEM

VENDOR

INVOICE

PURCHASE_ORDER_ITEM_SUMMARY

RETURNED_ITEM

INVOICE

INVOICE

RECEIVED_ITEM

RETURNED_ITEM

VENDOR_TYPE

PURCHASE_ORDER

PURCHASE_ORDER_ITEM

PURCHASE_ORDER_ITEM_SUMMARY

RETURNED_ITEM

VENDOR

RETURNED_ITEM

VENDOR_TYPE

PURCHASE_ORDER

PURCHASE_ORDER_ITEM

PURCHASE_ORDER_ITEM_SUMMARY

VENDOR_ID

CARRIER_NAME

CARRIER_NAME

CARRIER_ENTITY_IND

VENDOR_ID

ID

THIRD_PARTY_NAME

VENDOR_ENTITY_IND

CARRIER_ENTITY_IND

THIRD_PARTY_ID

VENDOR_NAME

CARRIER_ID

VENDOR_NAME

ID

VENDOR_NAME

VENDOR_ID

VENDOR_NAME

VENDOR_ENTITY_IND

NAME

CARRIER_ID

NAME

VENDOR_ID_NUMBER

VENDOR_NAME

VENDOR_ID

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  

PURCHASE_ORDER_ITEM_SUMMARY

QUANTITY_ACCEPTED_TO_DATE

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  

PURCHASE_ORDER_ITEM_SUMMARY

QUANTITY_RECEIVED_TO_DATE

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  

PURCHASE_ORDER_ITEM_SUMMARY

QTY_RECEIVED_REJECTED_TO_DATE

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  

PURCHASE_ORDER_ITEM_SUMMARY

QUANTITY_REJECTED_TO_DATE

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  

PURCHASE_ORDER_ITEM_SUMMARY

QUANTITY_RETURNED_TO_DATE

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  

PURCHASE_ORDER_ITEM_SUMMARY

RECEIVED_AMOUNT_TO_DATE

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  

ENDOWMENT_SUMMARIZED_UNITS

BOOK_AMOUNT

NA
MFKFUNC.F_SUM_UNITS_PURCHASED  

ENDOWMENT_SUMMARIZED_UNITS

UNITS_PURCHASED

NA
MFKFUNC.F_VENDOR_TYPE_COUNT( VENDOR.VENDOR_UID)  

VENDOR

VENDOR_TYPE_COUNT

NA
MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS  

INSTITUTION

ORGANIZATION_ENTITY

ADDRESS

ADDRESS_CURRENT

ORGANIZATION_CONTACT

PROSPECT_INFO

ADDRESS_PREFERRED

PERSON

ADDRESS_BY_RULE

GEOGRAPHIC_REGION_COUNT

GEOGRAPHIC_REGION_COUNT

GEOGRAPHIC_REGION_COUNT

GEOGRAPHIC_REGION_COUNT

GEOGRAPHIC_REGION_COUNT

PREF_GEOGRAPHIC_REGION_COUNT

GEOGRAPHIC_REGION_COUNT

GEOGRAPHIC_REGION_COUNT

GEOGRAPHIC_REGION_COUNT

This function counts the number of MGT_GEOGRAPHIC_REGION records for the parameter supplied UID, Address Type and Address Sequence Number.
MGKFUNC.F_COUNT_MAILING  

ADMISSIONS_APPLICATION

MAILING_COUNT

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.

PERSON

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_STUDENT

PERSON_SENSITIVE

GOVERNMENT_FINANCIAL_AID

GOVERNMENT_ADMISSIONS

PERSON_DETAIL

RACE_COUNT

RACE_COUNT

RACE_COUNT

RACE_COUNT

RACE_COUNT

RACE_COUNT

RACE_COUNT

SELECT COUNT(*) FROM MST_RACE WHERE PERSON_UID = IDEN
MGKFUNC.F_COUNT_RACE_CATEGORY Number of unique regulatory races selected by this person.

GOVERNMENT_FINANCIAL_AID

GOVERNMENT_ADMISSIONS

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_STUDENT

PERSON_DETAIL

PERSON_SENSITIVE

PERSON

RACE_CATEGORY_COUNT

RACE_CATEGORY_COUNT

RACE_CATEGORY_COUNT

RACE_CATEGORY_COUNT

RACE_CATEGORY_COUNT

RACE_CATEGORY_COUNT

RACE_CATEGORY_COUNT

SELECT COUNT(DISTINCT RACE_CATEGORY) FROM MST_RACE WHERE PERSON_UID = IDEN
MGKFUNC.F_GET_PERSON_INFO   > >ADMINISTRATOR

ADMISSIONS_DECISION

ADVISOR

ADVISOR

ADVISOR_SLOT

FIELD_OF_STUDY

GPA_BY_LEVEL

GPA_BY_TERM

MEAL_ASSIGNMENT

NON_INSTRUCTIONAL_ASSIGNMENT

STUDENT_ACTIVITY

MEMO

MEMO

ADDRESS_CURRENT

COMBINED_ACADEMIC_OUTCOME

GEOGRAPHIC_REGION

RELATIONSHIP

DEGREE

FUNDING_INTEREST

GIFT_ASSOCIATED_ENTITY

GIFT_AUXILIARY

GIFT_MATCHING_TRANSACTION

GIFT_MEMO

GIFT_MEMO

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_INSTALLMENT

PLEDGE_MATCHING

PLEDGE_MATCHING

PLEDGE_TRANSACTION

PROSPECT_INFO

SPECIAL_ACTIVITY

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

GENERAL_LEDGER

GRANT_FUND

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

ADMINISTRATOR

ADMISSIONS_DECISION

ADVISOR

ADVISOR

ADVISOR_SLOT

FIELD_OF_STUDY

GPA_BY_LEVEL

GPA_BY_TERM

MEAL_ASSIGNMENT

NON_INSTRUCTIONAL_ASSIGNMENT

STUDENT_ACTIVITY

MEMO

MEMO

ADDRESS_CURRENT

COMBINED_ACADEMIC_OUTCOME

GEOGRAPHIC_REGION

RELATIONSHIP

DEGREE

FUNDING_INTEREST

GIFT_ASSOCIATED_ENTITY

GIFT_AUXILIARY

GIFT_MATCHING_TRANSACTION

GIFT_MEMO

GIFT_MEMO

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_INSTALLMENT

PLEDGE_MATCHING

PLEDGE_MATCHING

PLEDGE_TRANSACTION

PROSPECT_INFO

SPECIAL_ACTIVITY

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

GENERAL_LEDGER

GRANT_FUND

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

INVOICE_ACCOUNTING

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

FACULTY_RANK_HISTORY

HR_APPLICATION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_EARNING

PAYROLL_LABOR_DIST_OVERRIDE

PAYROLL_TIMESHEET

AWARD_BY_PERSON

FINAID_APPLICANT_STATUS

FINAID_ENROLLMENT

FINAID_ENROLLMENT

FINAID_TRACKING_REQUIREMENT

NEED_ANALYSIS_PROFILE_SPECIFIC

ADMINISTRATOR

ADMISSIONS_APPLICATION

FACULTY

GPA_BY_LEVEL

STUDENT_WORK_EXPERIENCE

APPLICATION_OF_PAYMENT

APPL_OF_PAY_DETAIL_ACCOUNTING

CONTRACT

ADMINISTRATOR

ADMISSIONS_DECISION

ADVISOR

ADVISOR

ADVISOR_SLOT

FIELD_OF_STUDY

GPA_BY_LEVEL

GPA_BY_TERM

MEAL_ASSIGNMENT

NON_INSTRUCTIONAL_ASSIGNMENT

STUDENT_ACTIVITY

MEMO

MEMO

ADDRESS_CURRENT

COMBINED_ACADEMIC_OUTCOME

GEOGRAPHIC_REGION

RELATIONSHIP

DEGREE

FUNDING_INTEREST

GIFT_ASSOCIATED_ENTITY

GIFT_AUXILIARY

GIFT_MATCHING_TRANSACTION

GIFT_MEMO

GIFT_MEMO

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_INSTALLMENT

PLEDGE_MATCHING

PLEDGE_MATCHING

PLEDGE_TRANSACTION

PROSPECT_INFO

SPECIAL_ACTIVITY

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

GENERAL_LEDGER

GRANT_FUND

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

INVOICE_ACCOUNTING

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

FACULTY_RANK_HISTORY

HR_APPLICATION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_EARNING

PAYROLL_LABOR_DIST_OVERRIDE

PAYROLL_TIMESHEET

AWARD_BY_PERSON

FINAID_APPLICANT_STATUS

FINAID_ENROLLMENT

FINAID_ENROLLMENT

FINAID_TRACKING_REQUIREMENT

NEED_ANALYSIS_PROFILE_SPECIFIC

ADMINISTRATOR

ADMISSIONS_APPLICATION

FACULTY

GPA_BY_LEVEL

STUDENT_WORK_EXPERIENCE

APPLICATION_OF_PAYMENT

APPL_OF_PAY_DETAIL_ACCOUNTING

CONTRACT

ADMINISTRATOR

ADMISSIONS_DECISION

ADVISOR

ADVISOR

ADVISOR_SLOT

FIELD_OF_STUDY

GPA_BY_LEVEL

GPA_BY_TERM

MEAL_ASSIGNMENT

NON_INSTRUCTIONAL_ASSIGNMENT

STUDENT_ACTIVITY

MEMO

MEMO

ADDRESS_CURRENT

COMBINED_ACADEMIC_OUTCOME

GEOGRAPHIC_REGION

RELATIONSHIP

DEGREE

FUNDING_INTEREST

GIFT_ASSOCIATED_ENTITY

GIFT_AUXILIARY

GIFT_MATCHING_TRANSACTION

GIFT_MEMO

GIFT_MEMO

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_INSTALLMENT

PLEDGE_MATCHING

PLEDGE_MATCHING

PLEDGE_TRANSACTION

PROSPECT_INFO

SPECIAL_ACTIVITY

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

GENERAL_LEDGER

GRANT_FUND

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

INVOICE_ACCOUNTING

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

FACULTY_RANK_HISTORY

HR_APPLICATION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_EARNING

PAYROLL_LABOR_DIST_OVERRIDE

PAYROLL_TIMESHEET

AWARD_BY_PERSON

FINAID_APPLICANT_STATUS

FINAID_ENROLLMENT

FINAID_ENROLLMENT

FINAID_TRACKING_REQUIREMENT

NEED_ANALYSIS_PROFILE_SPECIFIC

ADMINISTRATOR

ADMISSIONS_APPLICATION

FACULTY

GPA_BY_LEVEL

STUDENT_WORK_EXPERIENCE

APPLICATION_OF_PAYMENT

APPL_OF_PAY_DETAIL_ACCOUNTING

CONTRACT

ADMINISTRATOR

ADMISSIONS_DECISION

ADVISOR

ADVISOR

ADVISOR_SLOT

FIELD_OF_STUDY

GPA_BY_LEVEL

GPA_BY_TERM

MEAL_ASSIGNMENT

NON_INSTRUCTIONAL_ASSIGNMENT

STUDENT_ACTIVITY

MEMO

MEMO

ADDRESS_CURRENT

COMBINED_ACADEMIC_OUTCOME

GEOGRAPHIC_REGION

RELATIONSHIP

DEGREE

FUNDING_INTEREST

GIFT_ASSOCIATED_ENTITY

GIFT_AUXILIARY

GIFT_MATCHING_TRANSACTION

GIFT_MEMO

GIFT_MEMO

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_ASSOCIATED_ENTITY

PLEDGE_INSTALLMENT

PLEDGE_MATCHING

PLEDGE_MATCHING

PLEDGE_TRANSACTION

PROSPECT_INFO

SPECIAL_ACTIVITY

BUDGET_DETAIL

BUDGET_DETAIL

BUDGET_DETAIL

FIXED_ASSET_ACCOUNTING_SOURCE

GENERAL_LEDGER

GRANT_FUND

GRANT_VIEW

GRANT_VIEW

GRANT_VIEW

INVOICE_ACCOUNTING

ORGANIZATION_HIERARCHY

ORGANIZATION_HIERARCHY

PURCHASE_ORDER_ACCOUNTING

FACULTY_RANK_HISTORY

HR_APPLICATION

PAYROLL_DISTRIBUTION

PAYROLL_DISTRIBUTION

PAYROLL_EARNING

PAYROLL_LABOR_DIST_OVERRIDE

PAYROLL_TIMESHEET

AWARD_BY_PERSON

FINAID_APPLICANT_STATUS

FINAID_ENROLLMENT

FINAID_ENROLLMENT

FINAID_TRACKING_REQUIREMENT

NEED_ANALYSIS_PROFILE_SPECIFIC

ADMINISTRATOR

ADMISSIONS_APPLICATION

FACULTY

GPA_BY_LEVEL

STUDENT_WORK_EXPERIENCE

APPLICATION_OF_PAYMENT

APPL_OF_PAY_DETAIL_ACCOUNTING

CONTRACT

" ">NAME

NAME

ADMINISTRATOR_LAST_NAME

ID

ADVISOR_FIRST_NAME

ADVISOR_LAST_NAME

ADVISOR_FIRST_NAME2

NAME

NAME

ID

NAME

NAME

NAME

ID

NAME

NAME

NAME

NAME

RELATED_MATCHING_GIFT_NAME

NAME

NAME

NAME

ID

MATCH_SPOUSE_ID

ID

MEMO_ID

ASSOCIATED_NAME_PREFIX

ASSOCIATED_NAME_SUFFIX

ID

ID

MATCH_EMPLOYER_ID

NAME

DECEASED_STATUS

NAME

ID

FUND_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_NAME

ORGN_FINANCIAL_MANAGER_ID

FUND_FINANCIAL_MANAGER_NAME

NAME

NAME

ADMINISTRATOR_LAST_NAME

ID

ADVISOR_FIRST_NAME

ADVISOR_LAST_NAME

ADVISOR_FIRST_NAME2

NAME

NAME

ID

NAME

NAME

NAME

ID

NAME

NAME

NAME

NAME

RELATED_MATCHING_GIFT_NAME

NAME

NAME

NAME

ID

MATCH_SPOUSE_ID

ID

MEMO_ID

ASSOCIATED_NAME_PREFIX

ASSOCIATED_NAME_SUFFIX

ID

ID

MATCH_EMPLOYER_ID

NAME

DECEASED_STATUS

NAME

ID

FUND_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_NAME

ORGN_FINANCIAL_MANAGER_ID

FUND_FINANCIAL_MANAGER_NAME

FUND_FMGR_MIDDLE_NAME

PRINCIPAL_INVESTIGATOR_LNAME

PRINCIPAL_INVESTIGATOR_MNAME

PRINCIPAL_INVESTIGATOR_NAME

FUND_FINANCIAL_MANAGER_NAME

FINANCIAL_MANAGER_ID

FMGR_LAST_NAME

ORGN_FINANCIAL_MANAGER_NAME

NAME

NAME

ID

NAME

ID

NAME

ID

NAME

NAME

ID

NAME

ID

ID

ID

PRIMARY_ADVISOR_ID

ID

ID

NAME

NAME

ADMINISTRATOR_LAST_NAME

ID

ADVISOR_FIRST_NAME

ADVISOR_LAST_NAME

ADVISOR_FIRST_NAME2

NAME

NAME

ID

NAME

NAME

NAME

ID

NAME

NAME

NAME

NAME

RELATED_MATCHING_GIFT_NAME

NAME

NAME

NAME

ID

MATCH_SPOUSE_ID

ID

MEMO_ID

ASSOCIATED_NAME_PREFIX

ASSOCIATED_NAME_SUFFIX

ID

ID

MATCH_EMPLOYER_ID

NAME

DECEASED_STATUS

NAME

ID

FUND_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_NAME

ORGN_FINANCIAL_MANAGER_ID

FUND_FINANCIAL_MANAGER_NAME

FUND_FMGR_MIDDLE_NAME

PRINCIPAL_INVESTIGATOR_LNAME

PRINCIPAL_INVESTIGATOR_MNAME

PRINCIPAL_INVESTIGATOR_NAME

FUND_FINANCIAL_MANAGER_NAME

FINANCIAL_MANAGER_ID

FMGR_LAST_NAME

ORGN_FINANCIAL_MANAGER_NAME

NAME

NAME

ID

NAME

ID

NAME

ID

NAME

NAME

ID

NAME

ID

ID

ID

PRIMARY_ADVISOR_ID

ID

ID

NAME

NAME

ADMINISTRATOR_LAST_NAME

ID

ADVISOR_FIRST_NAME

ADVISOR_LAST_NAME

ADVISOR_FIRST_NAME2

NAME

NAME

ID

NAME

NAME

NAME

ID

NAME

NAME

NAME

NAME

RELATED_MATCHING_GIFT_NAME

NAME

NAME

NAME

ID

MATCH_SPOUSE_ID

ID

MEMO_ID

ASSOCIATED_NAME_PREFIX

ASSOCIATED_NAME_SUFFIX

ID

ID

MATCH_EMPLOYER_ID

NAME

DECEASED_STATUS

NAME

ID

FUND_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_NAME

ORGN_FINANCIAL_MANAGER_ID

FUND_FINANCIAL_MANAGER_NAME

FUND_FMGR_MIDDLE_NAME

PRINCIPAL_INVESTIGATOR_LNAME

PRINCIPAL_INVESTIGATOR_MNAME

PRINCIPAL_INVESTIGATOR_NAME

FUND_FINANCIAL_MANAGER_NAME

FINANCIAL_MANAGER_ID

FMGR_LAST_NAME

ORGN_FINANCIAL_MANAGER_NAME

NAME

NAME

ID

NAME

ID

NAME

ID

NAME

NAME

ID

NAME

ID

ID

ID

PRIMARY_ADVISOR_ID

ID

ID

NAME

NAME

ADMINISTRATOR_LAST_NAME

ID

ADVISOR_FIRST_NAME

ADVISOR_LAST_NAME

ADVISOR_FIRST_NAME2

NAME

NAME

ID

NAME

NAME

NAME

ID

NAME

NAME

NAME

NAME

RELATED_MATCHING_GIFT_NAME

NAME

NAME

NAME

ID

MATCH_SPOUSE_ID

ID

MEMO_ID

ASSOCIATED_NAME_PREFIX

ASSOCIATED_NAME_SUFFIX

ID

ID

MATCH_EMPLOYER_ID

NAME

DECEASED_STATUS

NAME

ID

FUND_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_NAME

ORGN_FINANCIAL_MANAGER_ID

FUND_FINANCIAL_MANAGER_NAME

FUND_FMGR_MIDDLE_NAME

PRINCIPAL_INVESTIGATOR_LNAME

PRINCIPAL_INVESTIGATOR_MNAME

PRINCIPAL_INVESTIGATOR_NAME

FUND_FINANCIAL_MANAGER_NAME

FINANCIAL_MANAGER_ID

FMGR_LAST_NAME

ORGN_FINANCIAL_MANAGER_NAME

NAME

NAME

ID

NAME

ID

NAME

ID

NAME

NAME

ID

NAME

ID

ID

ID

PRIMARY_ADVISOR_ID

ID

ID

NAME

NAME

ADMINISTRATOR_LAST_NAME

ID

ADVISOR_FIRST_NAME

ADVISOR_LAST_NAME

ADVISOR_FIRST_NAME2

NAME

NAME

ID

NAME

NAME

NAME

ID

NAME

NAME

NAME

NAME

RELATED_MATCHING_GIFT_NAME

NAME

NAME

NAME

ID

MATCH_SPOUSE_ID

ID

MEMO_ID

ASSOCIATED_NAME_PREFIX

ASSOCIATED_NAME_SUFFIX

ID

ID

MATCH_EMPLOYER_ID

NAME

DECEASED_STATUS

NAME

ID

FUND_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_ID

ORGN_FINANCIAL_MANAGER_NAME

ORGN_FINANCIAL_MANAGER_ID

FUND_FINANCIAL_MANAGER_NAME

FUND_FMGR_MIDDLE_NAME

PRINCIPAL_INVESTIGATOR_LNAME

PRINCIPAL_INVESTIGATOR_MNAME

PRINCIPAL_INVESTIGATOR_NAME

FUND_FINANCIAL_MANAGER_NAME

FINANCIAL_MANAGER_ID

FMGR_LAST_NAME

ORGN_FINANCIAL_MANAGER_NAME

NAME

NAME

ID

NAME

ID

NAME

ID

NAME

NAME

ID

NAME

ID

ID

ID

PRIMARY_ADVISOR_ID

ID

ID

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.

MPKFUNC.F_CHECK_SUPERVISOR Returns a Y when the PERSON_UID exists as a SUPERVISOR_UID in MPT_SUPERVISOR.

EMPLOYEE

SUPERVISOR_IND

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.

EMPLOYEE

ACTIVE_JOBS_COUNT

SELECT COUNT(*) FROM MPT_EMPL_POSITION WHERE PERSON_UID = IDEN AND POSITION_STATUS <> 'T';
MPKFUNC.F_COUNT_BARG_UNIT  

EMPLOYEE

BARGAINING_UNIT_COUNT

This function returns the count of the MPT_BARG_UNIT records for a specified UID.
MPKFUNC.F_COUNT_BENEFICIARY  

BENEFIT_DEDUCTION

BENEFICIARY_COUNT

This function returns the count of the MPT_BENEFICIARY records for a specified UID.
MPKFUNC.F_COUNT_CERTIFICATION  

HR_APPLICATION

CERTIFICATION_COUNT

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.

EMPLOYEE

DIRECT_REPORT_COUNT

SELECT COUNT(*) FROM MPT_SUPERVISOR WHERE SUPERVISOR_UID = IDEN AND POSITION_STATUS <> 'T';
MPKFUNC.F_COUNT_EMPL_EARN  

EMPLOYEE

EMPLOYEE_EARNING_COUNT

This function returns the count of the MPT_EMPL_EARN_CY records for a specified UID.
MPKFUNC.F_COUNT_HR_APPL_STAT  

HR_APPLICATION

HR_APPLICATION_STATUS_COUNT

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  

HR_APPLICATION

INTERVIEW_COUNT

This function returns the count of the MPT_INTERVIEW records for a specified UID.
MPKFUNC.F_COUNT_LABOR_COST  

EMPLOYEE_POSITION

LABOR_COST_DISTRIBUTION_COUNT

This function returns the count of the MPT_LABOR_COST_DIST records for a specified position.
MPKFUNC.F_COUNT_LABOR_DIST  

POSITION_BUDGET

LABOR_DISTRIBUTION_COUNT

This function retrieves the count of records in MPT_LABOR_COST_DIST for the position passed.
MPKFUNC.F_COUNT_LEAVE  

EMPLOYEE

LEAVE_COUNT

This function returns the count of the MPT_LEAVE_BALANCE records for a specified UID.
MPKFUNC.F_COUNT_PAST_EMPL  

HR_APPLICATION

EMPLOYMENT_HISTORY_COUNT

This function returns the count of the MPT_PAST_EMPLOYMENT records for a specified UID.
MPKFUNC.F_COUNT_POSN_LABOR  

EMPLOYEE_POSITION

POSITION_LABOR_DIST_COUNT

This function returns the count of the MPT_POSN_LABOR_DIST records for a specified position.
MPKFUNC.F_COUNT_REFERENCE  

HR_APPLICATION

REFERENCE_COUNT

This function returns the count of the MPT_REFERENCE records for a specified UID.
MPKFUNC.F_COUNT_REVIEW  

EMPLOYEE

REVIEW_COUNT

This function returns the count of the MPT_REVIEW records for a specified UID.
MPKFUNC.F_COUNT_SKILL  

HR_APPLICATION

SKILL_COUNT

This function returns the count of the MPT_SKILL records for a specified UID.
MPKFUNC.F_GET_POSITION_REPORTS  

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.

EMPLOYEE

NEW_EMPLOYEE_IND

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  

POSITION_BUDGET

POSITION_BUDGET

NUMBER_INCUMB_END_YEAR

NUMBER_INCUMB_BEGIN_YEAR

This function retrieves the sum of full_time_equivelancy_pct from MPT_EMPL_POSITION based on position and date.
MPKFUNC.F_POSITION_CURRENT_IND  

EMPLOYEE_POSITION

POSITION_CURRENT_IND

This function returns an 'N' or 'Y' depending on if the position is current based on the current date.
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.

EMPLOYEE

SERVICE_YEARS

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  

AWARD_BY_AID_YEAR

ACTIVE_FINAID_HOLD_IND

 
MRKFUNC.F_GET_ACADEMIC_PERIOD  

APPLICANT_NEED

FINAID_BUDGET_COMPONENT

FINAID_BUDGET_COMPONENT

FINAID_TRACKING_REQUIREMENT

FINAID_TRACKING_REQUIREMENT

APPLICANT_NEED

ACADEMIC_PERIOD

ACADEMIC_PERIOD

ACADEMIC_PERIOD_DESC

ACADEMIC_PERIOD

ACADEMIC_PERIOD_DESC

ACADEMIC_PERIOD_DESC

 
MRKFUNC.F_GET_AID_PERIOD  

FINAID_ENROLLMENT

FINAID_TRACKING_REQUIREMENT

AWARD_DISBURSEMENT

AWARD_DISBURSEMENT

FINAID_ENROLLMENT

FINAID_TRACKING_REQUIREMENT

AID_PERIOD

AID_PERIOD_DESC

AID_PERIOD

AID_PERIOD_DESC

AID_PERIOD_DESC

AID_PERIOD

 
MSKFUNC.F_ACAD_STUDY_MATRIC_IN_COUNT       This function returns the count of terms that a student has been matriculated.
MSKFUNC.F_ADDRESS_ROWID  

ADDRESS_BY_RULE

ADDRESS_RULE

This function retrieves the rowid from the address table based on the current date being between the address start and end date.
MSKFUNC.F_CHECK_COOP_IND  

ACADEMIC_STUDY

COOPERATIVE_EDUCATION_IND

F_CHECK_COOP_IND (UID NUMBER, ACAD_PERIOD VARCHAR2, LEVL VARCHAR2)
MSKFUNC.F_COUNT_ADDRESSES  

CONSTITUENT

ORGANIZATION_ENTITY

ORGANIZATIONAL_CONSTITUENT

PERSON

ORGANIZATION_CONTACT

INSTITUTION

RECEIVABLE_ACCOUNT

ADDRESS_COUNT

ADDRESS_COUNT

ADDRESS_COUNT

ADDRESS_COUNT

ADDRESS_COUNT

ADDRESS_COUNT

ADDRESS_COUNT

This function counts the number of active MST_ADDRESS records for the parameter supplied UID.
MSKFUNC.F_COUNT_ADMINISTRATOR  

ADMISSIONS_APPLICATION

ADMINISTATOR_COUNT

This function counts the number of MST_ADMINISTRATOR records for the parameter supplied UID.
MSKFUNC.F_COUNT_ADMISSIONS_ATTRIBUTE  

ADMISSIONS_APPLICATION

ATTRIBUTE_COUNT

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  

ADMISSIONS_APPLICATION

COHORT_COUNT

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  

ADMISSIONS_APPLICATION

DECISION_COUNT

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  

ADMISSIONS_APPLICATION

RATING_COUNT

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  

ADMISSIONS_APPLICATION

REQUIREMENT_COUNT

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  

ADMISSIONS_APPLICATION

SOURCE_COUNT

This function counts the number of MST_ADMISSIONS_SOURCE records for the parameter supplied UID, academic period and application number.
MSKFUNC.F_COUNT_ADVISORS  

ACADEMIC_STUDY

STUDENT

ADVISOR_COUNT

ADVISOR_COUNT

This function counts the number of MST_ADVISORS records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_COHORTS  

STUDENT

RECRUITMENT_INFORMATION

COHORT_COUNT

COHORT_COUNT

This function counts the number of MST_STUDENT_COHORT records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_CONTACTS  

PRE_STUDENT

CONTACTS_COUNT

This function counts the number of MST_CONTACT records for the parameter supplied UID.
MSKFUNC.F_COUNT_COURSE_ATTRIBUTES  

COURSE_CATALOG

SCHEDULE_OFFERING

STUDENT_COURSE

ATTRIBUTE_COUNT

ATTRIBUTE_COUNT

COURSE_ATTRIBUTES_COUNT

This function counts the number of MST_COURSE_ATTRIBUTE records for the parameter supplied subject, course and academic period.
MSKFUNC.F_COUNT_COURSE_COREQ  

COURSE_CATALOG

COURSE_COREQ_COUNT

This function counts the number of MST_COURSE_COREQ records for the parameter supplied subject, course and academic period.
MSKFUNC.F_COUNT_COURSE_LEVEL  

COURSE_CATALOG

COURSE_LEVEL_COUNT

This function returns the count of course levels based on the subject, course number and academic period passed.
MSKFUNC.F_COUNT_COURSE_SCHEDULE  

COURSE_CATALOG

SCHEDULE_OFFERING

SCHEDULE_COUNT

SCHEDULE_COUNT

This function counts the number of MST_COURSE_SCHEDULE records for the parameter supplied subject, course and academic period.
MSKFUNC.F_COUNT_FACULTY_ATTRIBUTE  

FACULTY

ATTRIBUTE_COUNT

This function counts the number of MST_FACULTY_ATTRIBUTE records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_FACULTY_CONTRACT  

FACULTY

CONTRACT_RULE_COUNT

This function counts the number of MST_FACULTY_CONTRACT records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_FACULTY_DEPT_COLL  

FACULTY

COLLEGE_DEPT_ASSIGN_COUNT

This function counts the number of MST_FACULTY_DEPT_COLLEGE records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_GRADE_CHANGE  

STUDENT_COURSE

GRADE_CHANGE_COUNT

NA
MSKFUNC.F_COUNT_GRADE_TYPE  

COURSE_CATALOG

SCHEDULE_OFFERING

GRADE_TYPE_COUNT

GRADE_TYPE_COUNT

This function counts the number of MST_OFFERING_GRADE_MODE records for the parameter supplied subject, course and academic period.
MSKFUNC.F_COUNT_HOLDS  

STUDENT

PRE_STUDENT

RECEIVABLE_ACCOUNT

HOLD_COUNT

HOLD_COUNT

HOLD_COUNT

This function counts the number of active MST_HOLD records for the parameter supplied UID.
MSKFUNC.F_COUNT_HONORS  

ACADEMIC_OUTCOME

ACADEMIC_OUTCOME

ACADEMIC_OUTCOME

COMBINED_ACADEMIC_OUTCOME

COMBINED_ACADEMIC_OUTCOME

COMBINED_ACADEMIC_OUTCOME

DEPARTMENTAL_HONORS_COUNT

INSTITUTIONAL_HONORS_COUNT

HONORS_COUNT

INSTITUTIONAL_HONORS_COUNT

HONORS_COUNT

DEPARTMENT_HONORS_COUNT

This function counts the number of MST_OUTCOME_HONOR records for the parameter supplied UID, outcome and honor code.
MSKFUNC.F_COUNT_INSTITUTION_TYPES  

PRE_STUDENT

PRE_STUDENT

SECONDARY_SCHOOL_COUNT

POST_SECONDARY_SCHOOL_COUNT

This function counts the number of MST_PREVIOUS_EDUCATION records for the parameter supplied UID and institution type.
MSKFUNC.F_COUNT_INSTRUCTOR  

GOVERNMENT_COURSE

SCHEDULE_OFFERING

INSTRUCTOR_COUNT

INSTRUCTOR_COUNT

This function counts the number of MST_INSTRUCTIONAL_ASSIGNMENT records for the parameter supplied academic period.
MSKFUNC.F_COUNT_INST_ASSIGNMENT  

FACULTY

INST_ASSIGNMENT_COUNT

This function counts the number of MST_INSTRUCTIONAL_ASSIGNMENT records for the parameter supplied academic period and course.
MSKFUNC.F_COUNT_INTERESTS  

PRE_STUDENT

INTERESTS_COUNT

This function counts the number of MST_INTERESTS records for the parameter supplied UID.
MSKFUNC.F_COUNT_MEDICAL_INFORMATION  

PERSON

PERSON_SENSITIVE

PERSON_DETAIL

MEDICAL_INFORMATION_COUNT

MEDICAL_INFORMATION_COUNT

MEDICAL_INFORMATION_COUNT

This function counts the number of MST_MEDICAL_INFORMATION records for the parameter supplied UID.
MSKFUNC.F_COUNT_MEETING_TIME  

GOVERNMENT_COURSE

SCHEDULE_OFFERING

MEETING_TIME_COUNT

MEETING_TIME_COUNT

This function counts the number of MST_MEETING_TIME records for the parameter supplied academic period and course.
MSKFUNC.F_COUNT_NONINST_ASSIGNMENT  

FACULTY

NONINST_ASSIGNMENT_COUNT

This function counts the number of MST_NONINSTRUCTIONAL_ASGNMNT records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_OFFERING_COREQ  

SCHEDULE_OFFERING

OFFERING_COREQ_COUNT

This function counts the number of MST_OFFERING_COREQ records for the parameter supplied academic period and course.
MSKFUNC.F_COUNT_OFFERING_PREREQ  

SCHEDULE_OFFERING

OFFERING_PREREQ_COUNT

This function counts the number of MST_OFFERING_PREREQ records for the parameter supplied academic period and course.
MSKFUNC.F_COUNT_RECRUITMENT_ATTRIBUTES  

RECRUITMENT_INFORMATION

ATTRIBUTE_COUNT

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  

RECRUITMENT_INFORMATION

SOURCE_COUNT

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  

PRE_STUDENT

SECONDARY_SUBJECT_COUNT

This function counts the number of MST_SECONDARY_SCHOOL_SUBJECT records for the parameter supplied UID and institution.
MSKFUNC.F_COUNT_SPORTS  

STUDENT

SPORT_COUNT

This function counts the number of MST_SPORTS records for the parameter supplied UID and academic period.
MSKFUNC.F_COUNT_STUDENT_COURSE_ATTR  

STUDENT_COURSE

COURSE_ATTRIBUTES_COUNT

NA
MSKFUNC.F_COUNT_TELEPHONES  

ORGANIZATION_ENTITY

ORGANIZATIONAL_CONSTITUENT

PERSON

CONSTITUENT

INSTITUTION

ORGANIZATION_CONTACT

RECEIVABLE_ACCOUNT

PHONE_COUNT

PHONE_COUNT

PHONE_COUNT

PHONE_COUNT

PHONE_COUNT

PHONE_COUNT

TELEPHONE_COUNT

This function counts the number of MST_TELEPHONE records for the parameter supplied UID.
MSKFUNC.F_COUNT_TESTS  

PRE_STUDENT

TEST_COUNT

This function counts the number of MST_TEST records for the parameter supplied UID.
MSKFUNC.F_DEGR_ENROLLED_IND  

ENROLLMENT

STUDENT

ACADEMIC_OUTCOME_ENROLLED_IND

ACADEMIC_OUTCOME_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  

ADMISSIONS_APPLICATION

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  

FIXED_ASSET_ITEM

FIXED_ASSET_ITEM

FULL_NAME_FMIL

FULL_NAME_LFMI

This function returns the formatted name of the specified UID and format (for example, FMIL or LFMI).
MSKFUNC.F_GET_ACADEMIC_PERIOD        
MSKFUNC.F_GET_DIVISOR_FTE  

ENROLLMENT

ENROLLMENT

STUDENT_FTE

FTE_DIVISOR

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_LAST_ACADEMIC_PERIOD  

GOVERNMENT_FINANCIAL_AID

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  

ADMISSIONS_DECISION

LATEST_DECISION_IND

 
MSKFUNC.F_GET_NICKNAME  

PERSON

NICKNAME

This function retrieves the nickname for a constituent.
MSKFUNC.F_GET_OUTCOME_AWARDED_IND  

ACADEMIC_STUDY

OUTCOME_AWARDED_IND

Determines if program has outcome awarded to the student.
MSKFUNC.F_GET_PREF_ADDRESS_ROWID  

PERSON

ADDRESS_TYPE

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_SALUTATIONS_COUNT  

PERSON_DETAIL

PERSON

SALUTATIONS_COUNT

SALUTATIONS_COUNT

This function counts the number of MAT_SALUTATION records for the parameter supplied UID.
NOKODSF.F_GET_END_NBRJFTE_FTE_DATE  

EMPLOYEE_POSITION

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

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  

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  

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_SUPERVISOR Returns the NBRJOBS_DESC based on the SUPERVISOR_POSITION in MPT_SUPERVISOR.

EMPLOYEE_POSITION

EMPLOYEE

SUPERVISOR_TITLE

SUPERVISOR_TITLE

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

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  

EMPLOYEE_POSITION

EMPLOYEE_POSITION

EMPLOYEE_POSITION

ABOVE_SALARY_RANGE_IND

IN_SALARY_RANGE_IND

BELOW_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(AXBMGID_MGFORM_READYTOSEND,'N')  

PLEDGE_MATCHING_TRANSACTION

MATCH_SPOUSE_ID

 
NVL(SORLCUR_SITE_CODE, SGBSTDN_SITE_CODE)       NA
NVL(SORLCUR_STYP_CODE, SGBSTDN_STYP_CODE)  

GOVERNMENT_STUDENT

STUDENT_POPULATION

NA
NVL(SORLCUR_TERM_CODE_END,'999999')        
PERAPPT_COAS_CODE  

FACULTY_APPOINTMENT_HISTORY

FACULTY_TRACKING

TIMESHEET_CHART_OF_ACCOUNTS

APPOINTMENT_TIMESHEET_CHART

NA
PERAPPT_ORGN  

FACULTY_TRACKING

FACULTY_APPOINTMENT_HISTORY

APPOINTMENT_ORGANIZATION_CODE

ORGANIZATION_CODE

NA
PERAPPT_POSN  

FACULTY_APPOINTMENT_HISTORY

FACULTY_TRACKING

POSITION

APPOINTMENT_POSITION

NA
PERAPPT_SUFF  

FACULTY_TRACKING

FACULTY_APPOINTMENT_HISTORY

APPOINTMENT_JOB_SUFFIX

JOB_SUFFIX

NA
POKODSF.F_CALC_DEDN_AMT  

PAYROLL_EMPLOYEE_POSITION

PAYROLL_POSITION_TIMESHEET

DEDUCTIONS_AMOUNT

DEDUCTIONS_AMOUNT

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  

MONTHLY_DEDUCTION

MONTHLY_DEDUCTION

MONTHLY_DEDUCT_SLOT

MONTHLY_DEDUCTION

EMPLOYER_CONTRIBUTION_FYTD

GROSS_COMPENSATION_FYTD

GROSS_COMPENSATION_YTD

EMPLOYEE_CONTRIBUTION_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       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_DEDUCTION_AMOUNTS  

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

EMPLOYEE_DEDN_LTD_LIMIT

EMPLOYEE_BOND_PURCHASE_AMOUNT

EMPLOYEE_DEDUCTION_PERCENT

EMPLOYEE_MINIMUM_EARNINGS

LIFE_INSURANCE_OVERRIDE_AMOUNT

LIFE_INSURANCE_PREMIUM

EMPLOYEE_ANNUAL_DEDN_LIMIT

EMPLOYEE_MINIMUM_YTD_GROSS

LIFE_INSURANE_COVERAGE_AMOUNT

EMPLOYEE_DEDN_MTD_LIMIT

EMPLOYEE_DEDUCTION_AMOUNT

EMPLOYER_DEDUCTION_AMOUNT

LIFE_INSURANCE_SALARY

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

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

TAX

BENEFIT_DEDUCTION_IND

LIFE_INSURANCE_TYPE_IND

EMPLOYEE_DEPENDENTS_UNDER_19

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

BENEFIT_DEDUCTION

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  

EMPLOYEE_EARNING_FY

QUARTER

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

EMPLOYEE_POSITION

LAST_PAID_DATE

 
POKODSF.F_NEXT_REVIEW_DATE  

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  

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

TAX

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

YEARLY_DEDUCTION

YEARLY_DEDUCTION

YEARLY_DEDUCTION

YEARLY_DEDUCTION

YEARLY_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

TAX

BENEFIT_DEDUCTION

TAX

TAX

TAX

BENEFIT_DEDUCTION

BENEFIT_DEDUCTION

TAX

TAX

YEARLY_DEDUCTION

BENEFIT_DEDUCTION

TAX

YEARLY_DEDUCTION

YEARLY_DEDUCTION

TAX

TAX

TAX

YEARLY_DEDUCTION

YEARLY_DEDUCTION

TAX

YEARLY_DEDUCTION

YEARLY_DEDUCTION

O OYER_CONTRIBUTION_QTR2">EMPLOYER_CONTRIBUTION_QTR2

EMPLOYEE_CONTRIBUTION_QTR1

EMPLOYER_CONTRIBUTION_QTR4

 
RNKNEED.F_CALC_BUDGET_AMT  

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_EFC  

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  

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  

APPLICANT_NEED

APPLICANT_NEED

APPLICANT_NEED

APPLICANT_NEED

IM_UNMET_NEED

FM_UNMET_NEED

FM_GROSS_NEED

IM_GROSS_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  

APPLICANT_NEED

RESOURCE_AMOUNT

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

AWARD_BY_PERSON

CALC_STUDENT_ADJ_CREDITS

This function retrieves the sum of bill hours from the student registration view for a given person and academic period.
ROKMISC.F_CALC_STUD_BILL_HRS  

AWARD_BY_PERSON

CALC_STUDENT_BILLING_HOURS

 
ROKODSF.F_CALCULATE_DISB_AMTS  

FINAID_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FINANCIAL_AID

FINAID_FUND

FINAID_FUND

GOVERNMENT_FA_FUND

FINAID_FUND

FINAID_FUND

FINAID_FUND

GOVERNMENT_FA_FUND

FINAID_FUND

GOVERNMENT_FA_FUND

FINAID_FUND

FINAID_FUND

FINAID_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FA_FUND

FINAID_FUND

FINAID_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FA_FUND

FINAID_FUND

FINAID_FUND

FINAID_FUND

FINAID_FUND

GOVERNMENT_FA_FUND

GOVERNMENT_FA_FUND

OTHER_LOAN_DISBURSED

INST_LOAN_DISBURSED

OTHER_SCHOLARSHIP_DISBURSED

OTHER_WORK_DISBURSED

STATE_WORK_DISBURSED

DISBURSED_AMT

OTHER_SCHOLARSHIP_DISBURSED

OTHER_WORK_DISBURSED

STATE_SCHOLARSHIP_DISBURSED

FEDERAL_WORK_DISBURSED

STATE_GRANT_DISBURSED

STATE_LOAN_DISBURSED

FEDERAL_SCHOLARSHIP_DISBURSED

INST_GRANT_DISBURSED

INST_GRANT_DISBURSED

INST_LOAN_DISBURSED

INST_WORK_DISBURSED

STATE_SCHOLARSHIP_DISBURSED

INST_WORK_DISBURSED

OTHER_GRANT_DISBURSED

FEDERAL_SCHOLARSHIP_DISBURSED

INST_SCHOLARSHIP_DISBURSED

FEDERAL_GRANT_DISBURSED

FEDERAL_LOAN_DISBURSED

OTHER_LOAN_DISBURSED

STATE_LOAN_DISBURSED

FEDERAL_GRANT_DISBURSED

STATE_WORK_DISBURSED

FEDERAL_LOAN_DISBURSED

OTHER_GRANT_DISBURSED

FEDERAL_WORK_DISBURSED

STATE_GRANT_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  

LOAN_DISBURSEMENT

CALC_EXPECTED_DISBURSEMENT_AMT

 
ROKODSF.F_GET_CIPC_DESC  

AWARD_BY_PERSON

PROGRAM_CLASS_OVR_DESC

 
ROKODSF.F_GET_COMMENT_DESC  

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_ISIR_SPECIFIC

COMMENT14_DESC

COMMENT15_DESC

COMMENT16_DESC

COMMENT1_DESC

COMMENT8_DESC

COMMENT12_DESC

COMMENT10_DESC

COMMENT17_DESC

COMMENT13_DESC

COMMENT18_DESC

COMMENT2_DESC

COMMENT3_DESC

COMMENT6_DESC

COMMENT11_DESC

COMMENT20_DESC

COMMENT4_DESC

COMMENT7_DESC

COMMENT19_DESC

COMMENT5_DESC

COMMENT9_DESC

 
ROKODSF.F_GET_FINAID_PROC_YEAR  

FINAID_ENROLLMENT

AID_YEAR

This function returns the Financial Aid Processing Year from the STVTERM table using the parameter supplied Term Code.
RPRADSB_DISBURSE_AMT  

GOVERNMENT_FA_FUND

INST_SCHOLARSHIP_DISBURSED

This function retrieves the total disbursed amount where financial aid fund represents institutional scholarship awards.
SB_CURRICULUM.F_FIND_CURRENT_ALL_IND This function set the current and acitive indicators on the curriculum record.

FIELD_OF_STUDY

CURRICULUM_CURRENT_IND

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)
SB_CURRICULUM.F_LCUR_ORDER       NA
SB_FIELDOFSTUDY.F_FIND_CURRENT_ALL_IND This function sets the current and active indicators on the field of study record.

FIELD_OF_STUDY

CURRENT_IND

SUBSTR(SB_FIELDOFSTUDY.F_FIND_CURRENT_ALL_IND( SORLFOS_PIDM, SORLFOS_LCUR_SEQNO, SORLFOS_SEQNO, SORLFOS_LFST_CODE, SORLFOS_PRIORITY_NO),1,1)
SGKCLAS.F_CLASS_CODE  

ENROLLMENT

ACADEMIC_STUDY

GOVERNMENT_STUDENT

STUDENT

STUDENT_CLASSIFICATION_BOAP

STUDENT_CLASSIFICATION_BOAP

STUDENT_CLASSIFICATION_BOAP

STUDENT_CLASSIFICATION_BOAP

This packaged function is created to allow student classification to be retrieved for ad-hoc reporting.
SOKODSF.F_ADMS_CHECK_STATUS  

ADMISSIONS_APPLICATION

ADMISSIONS_APPLICATION

ADMISSIONS_APPLICATION

ADMISSIONS_APPLICATION

ADMISSIONS_APPLICATION

ADMISSIONS_APPLICATION

APPL_ACCEPT_CURRENT_IND

INST_DENIED_IND

APPL_ACCEPT_ANY_TIME_IND

INST_ACCEPTED_CURRENT_IND

INST_ADMIT_ANY_TIME_IND

APPLICANT_DECLINED_IND

 
SOKODSF.F_BUILD_PREREQ_PARSE  

COURSE_PREREQ_COMBINED

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  

ACADEMIC_STUDY

AGE_ADMITTED

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

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

TOTAL_TRANSFER_CREDITS

TOTAL_TRANSFER_CREDITS

TRANSFER_CREDITS_ATTENDANCE

POST_SECONDARY_TRANS_CREDITS_1

POST_SECONDARY_TRANS_CREDITS_2

POST_SECONDARY_TRANS_CREDITS_3

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  

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_ENROLLMENT_DATA       This function returns a Y/N indicator that indicates if Enrollment (SFBETRM) data exists based on the PIDM and TERM parameters passed.
SOKODSF.F_CHECK_FOR_GRADUATE_IND