Banner Operational Data Store
Composite View Source: FUNCTION - NULL
| Source Column |
Business Definition |
Target |
Target Column |
Calculation Formula |
| (MAKFUNC.F_SOL_FR_TOTAL_PLEDGES + MAKFUNC.F_SOL_FR_TOTAL_GIFTS + MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS) / SOLICITOR_GOAL * 100 |
|
|
|
|
| (SELECT COUNT(DISTINCT ACADEMIC_PERIOD) FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY) |
|
|
|
|
| (SELECT COUNT(DISTINCT ACADEMIC_YEAR) FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY) |
|
|
|
|
| (SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE =PAF_TRANSACTION_STATUS) |
|
|
|
|
| AOKODSF.F_CAMPAIGN_MULT_CREDIT |
|
AA_CAMPAIGN_GIVING_HISTORY |
AMOUNT_MULTIPLE_CREDIT |
This function returns a summarized total of the AGRGMLT_CREDIT field for the parameter supplied PIDM, Campaign and Fiscal Code. In addition, the cannot be any AGRMGIF record where the AGBGIFT_GIFT_NO field matches the AGRMGIF_EMPR_GIFT_NO field. |
| AOKODSF.F_CHECK_FOR_MORE_MAJORS |
|
AA_DEGREE |
ADDITIONAL_MAJORS_IND |
This function returns a Y or N indicator that reflects if there are more than 3 distinct occurances of the APRAMAJ record for the specified PIDM and Degree Sequence Number. |
| AOKODSF.F_DESIGNATION_MULT_CREDIT |
|
AA_DESIGNATION_GIVING_HISTORY |
AMOUNT_MULTIPLE_CREDIT |
This function returns a summarized total of the AGRGMLT_CREDIT field for the parameter supplied PIDM, Designation and Fiscal Code. In addition, the cannot be any AGRMGIF record where the AGBGIFT_GIFT_NO field matches the AGRMGIF_EMPR_GIFT_NO field. |
| AOKODSF.F_GET_ACTIVITY_YEAR_COUNT |
|
AA_SPECIAL_ACTIVITY |
TOTAL_YEARS |
This function returns one of three fields based on the specified PIDM and Activity Code. Based on the WHICH_COUNT parameter, the function retrieves and returns either the earliest, the most recent, or the total count of the occurances of the APRACYR record. |
| AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR |
|
AA_ANNUAL_GIVING AA_ANNUAL_GIVING |
HIGHEST_GIFT_AMOUNT HIGHEST_GIFT_AMOUNT_DATE |
This function returns either a Gift Amount or a Gift Date based on the specified field, along with the PIDM and Fiscal Code. The function returns either the Highest Gift Amount Highest Gift Amount Date by retrieving the AGBGIFT_AMT_TOT and AGBGIFT_GIFT_DATE fields in descending sequence by the AGBGIFT_AMT_TOT and the AGBGIFT_GIFT_NO fields for the specified PIDM and Fiscal Code. Then, based on the parameter field requested, returns either the Date or the Amount field. |
| AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR |
|
AA_ANNUAL_GIVING |
HIGHEST_PLEDGE_AMOUNT |
This function returns the highest occurance of the AGBPLDG_AMT_PLEDGED field from the AGBPLDG record for the specified PIDM and Fiscal Code by retrieving the record in descending sequence of the AGBPLDG_AMT_PLEDGED field. |
| AOKODSF.F_GET_INSTALL_PAY |
Calculating installment paid amount. |
|
|
AOKODSF.F_GET_INSTALL_PAY(AGRPINS_PIDM, AGRPINS_PLEDGE_NO, AGRPINS_INSTALLMENT_NO, AGRPINS_AMT) |
| AOKODSF.F_GET_MEMB_AMT_PAID |
Calculation membership dues amount paid. |
AA_MEMBERSHIP |
MEMBERSHIP_DUES_AMOUNT_PAID |
AOKODSF.F_GET_MEMB_AMT_PAID(AARMEMB_PIDM) |
| AOKODSF.F_GET_PROJ_ASSIGN_PROS_IND( AMRPROP_PIDM, AMRPROP_PROJ_CODE) |
|
AA_PROSPECT_PROPOSAL_PROJECT |
PROJECT_ASSIGNED_PROSPECT_IND |
|
| AOKODSF.F_GET_SESSION_NUMBER |
|
AA_GIFT |
POST_CASHIER_SESSION_NUMBER |
NA |
| AOKODSF.F_GET_STAFF_INDICATOR |
|
AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_STAFF_ASSIGNMENT |
CONTACT_STAFF_IND PLAN_MANAGER_IND PROSPECT_STAFF_IND PROPOSAL_STAFF_IND |
|
| AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY |
|
AA_ANNUAL_GIVING |
TOTAL_ANT_MATCH_GIFT_ONE_PAY |
This function returns a summarized total of the AGBMGID_AMT field for all AGBMGID that match the AGBGIFT and AGRGDES records selected by using the specified PIDM and Fiscal Code fields. In addition, the AGRGDES_PLEDGE_NO field must equal 0000000. |
| AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY |
|
AA_ANNUAL_GIVING |
TOTAL_ANT_MATCH_GIFT_PAY |
This function returns a summarized total of the AGBMGID_AMT field for all AGBMGID records where the field AGBMGID_EMPL_GIFT_NO is in the Gift List view (AGVGLST) for the specified PIDM and Fiscal Code, and where the Pledge Number does not equal 0000000. |
| AOKODSF.F_GET_TOT_GIVING_YEAR |
|
AA_ANNUAL_GIVING |
TOTAL_GIVING |
This function returns a sumarized total of the APRCHIS_AMT_PLEDGED_PAID field added to the summarized total of the APRCHIS_AMT_GIFT FIELD and substracts the total of AGRGMMO_3PP_TOT_AMT for the specified PIDM and Fiscal Code. |
| AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO |
|
AA_ANNUAL_GIVING |
TOTAL_NON_MATCH_GIFT_MEMO |
This function returns a summarized total of the AGRGMMO_CREDIT field for the specified Cross Reference PIDM and the Fiscal Code. In addition, there cannot be any AGRMGIF record existing where the AGRGMMO_GIFT_NO field matches the AGRMGIF_GIFT_NO field. |
| AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR |
|
AA_ANNUAL_GIVING |
TOTAL_NUMBER_OF_GIFTS |
This function returns a count of the number of AGBGIFT records for the assocaited PIDM and Fiscal Code. |
| AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR |
|
AA_ANNUAL_GIVING |
TOTAL_NUMBER_OF_PLEDGES |
This function returns a count of the number of AGBPLDG records for the speficied PIDM and Fiscal Code. |
| AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR |
|
AA_ANNUAL_GIVING |
TOTAL_PLEDGE_AMOUNT |
This function returns a summarized total of the APRCHIS_AMT_PLEDGED field for the specified PIDM and Fiscal Code. |
| AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR |
|
AA_ANNUAL_GIVING |
TOTAL_PLEDGE_PAYMENTS |
This function returns a summarized total of the APRCHIS_AMT_PLEDGED_PAID field for the specified PIDM and Fiscal Code. |
| AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY |
|
AA_ANNUAL_GIVING |
TOTAL_REAL_MATCH_GIFT_ONE_PAY |
This function returns a summarized total of the AGRGMMO_CREDIT field from the column AGVGMEM_CREDIT in the Gift Memo Credit view (AGVGMEM) for the specified Cross Reference PIDM (AGVMEM_PIDM) and Fiscal Code. In addition, a record must exist in the AGRMGIF table where the AGRMGIF_EMPR_GIFT_NO matches the AGVGMEM_GIFT_NO column and there exists a entry in the Gift List view (AGVGLST) for the AGRMGIF_GIFT_NO that does have a value of 0000000 in the column AGVGLST_PLEDGE_NO. |
| AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY |
|
AA_ANNUAL_GIVING |
TOTAL_REAL_MATCH_GIFT_PAY |
This function returns a summarized total of the AGRGMMO_CREDIT field from the column AGVGMEM_CREDIT in the Gift Memo Credit view (AGVGMEM) for the specified Cross Reference PIDM (AGVMEM_PIDM) and Fiscal Code. In addition, a record must exist in the AGRMGIF table where the AGRMGIF_EMPR_GIFT_NO matches the AGVGMEM_GIFT_NO column and there exists a entry in the Gift List view (AGVGLST) for the AGRMGIF_GIFT_NO that does not have a value of 0000000 in the column AGVGLST_PLEDGE_NO. |
| AOKODSF.F_GET_VOID_IND |
|
AA_GIFT_ASSOCIATED_ENTITY |
GIFT_VOID_IND |
NA |
| AOKODSF.F_GIFT_MATCH_PAID |
|
AA_GIFT_MATCHING AA_GIFT_MATCHING |
MATCH_GIFT_FULLY_PAID_IND MATCH_GIFT_PARTIAL_PAID_IND |
NA |
| AOKODSF.F_LIFE_GIFT_SOCIETY |
|
AA_CONSTITUENT AA_CONSTITUENT AA_ORGANIZATIONAL_CONSTITUENT AA_ORGANIZATIONAL_CONSTITUENT |
LIFE_GIFT_SOCIETY LIFE_GIFT_SOCIETY_TYPE LIFE_GIFT_SOCIETY_TYPE LIFE_GIFT_SOCIETY |
Extracts Gift Society Type or Gift Society from the gift society table (aprdclb) for a given donor. |
| AOKODSF.F_MATCH_GIFT |
|
AA_GIFT AA_GIFT |
MATCHING_GIFT_PAYMENT_IND MATCHING_GIFT_IND |
NA |
| AOKODSF.F_MATCH_GIFT_PAY |
|
|
|
NA |
| AOKODSF.F_PLEDGE_MATCH |
|
AA_PLEDGE |
MATCHING_PLEDGE_IND |
NA |
| ATVCTYP_DESC |
|
AA_PLEDGE_CONDITIONAL |
CONDITION_TYPE_DESC |
|
| CASE PROGRAM_NUMBER WHEN 1 THEN 'Y' ELSE 'N' END |
|
|
|
This function returns a 'Y' if the program number is 1, otherwise it returns an 'N'. |
| CASE WHEN AMRINFO_SYS_IND |
|
AA_PROSPECT_INFO |
PROSPECT_AMOUNT_METHOD_DESC |
|
| CASE WHEN DAP_VALUE4 |
|
|
|
|
| CASE WHEN EXISTS FTOBDLGT |
|
|
|
|
| CASE WHEN FTVACCT_DATA_ENTRY_IND |
|
AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY |
DATA_ENTRY_PERMITTED_DESC DATA_ENTRY_PERMITTED_DESC |
|
| CASE WHEN FTVEVND_COLLECT_TAX |
|
|
|
|
| CASE WHEN FTVFUND_DATA_ENTRY_IND |
|
AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL |
DATA_ENTRY_PERMITTED_DESC DATA_ENTRY_PERMITTED_DESC |
|
| CASE WHEN FTVORGN_DATA_ENTRY_IND |
|
AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL |
DATA_ENTRY_PERMITTED_DESC DATA_ENTRY_PERMITTED_DESC |
|
| CASE WHEN FTVPROG_DATA_ENTRY_IND |
|
AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL |
DATA_ENTRY_PERMITTED_DESC DATA_ENTRY_PERMITTED_DESC |
|
| CASE WHEN FTVVEND_CARRIER_IND |
|
|
|
|
| CASE WHEN FTVVEND_GROUPING_IND |
|
|
|
|
| CASE WHEN FTVVEND_IN_ST_IND |
|
|
|
|
| CASE WHEN PROPOSAL_RESULT_PLEDGE_NUMBER |
|
|
|
|
| CASE WHEN REGISTERED_IND = 1 OR WITHDRAWN_IND = 1 THEN NULL ELSE PERSON_UID |
|
|
|
|
| CASE WHEN SSRMEET_OVER_RIDE |
|
|
|
|
| CASE WHEN STUDENT_COURSE_REC.IN_PROGRESS_COURSE_IN D = 1 THEN RET_ROW.COURSE_INTREGISTERED_HEADCOUNT := STUDENT_COURSE_REC.WAREHOUSE_ENTITY_UID; WHEN STUDENT_COURSE_REC.INSTITUTION_COURSE_IN D = 1 THEN RET_ROW.COURSE_INTREGISTERED_HEADCOUNT := ST |
|
|
|
|
| CASE WHEN STUDENT_COURSE_REC.COURSE_REGISTER_IND ='Y' THEN |
|
|
|
|
| COUNT OF WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UI D WHERE THAT PERSON HAS A RECORD IN MST_ENROLLMENT AND MST_ACADEMIC_OUTCOME JOIN PERSON_UID AND ACADEMIC_YEAR ( ACADEMIC_YEAR_GRADUATION) |
|
|
|
SELECT COUNT(*) FROM MST_ENROLLMENT WHERE PERSON_UID = MST_ACADEMIC_OUTCOME.PERSON_UID AND ACADEMIC_YEAR = MST_ACADEMIC_OUTCOME.ACADEMIC_YEAR_GRADUATION |
| DECODE((SELECT COUNT (*) FROM MST_FACULTY_FEEDBACK_DETAIL FD WHERE FD.PERSON_UID = F.PERSON_UID AND FD.ACADEMIC_PERIOD = F.ACADEMIC_PERIOD AND FD.COURSE_REFERENCE_NUMBER = F.COURSE_REFERENCE_NUMBER),0, 'N','Y') |
|
|
|
|
| DECODE(AGRGAUX_GIFT_ADJ_VOID_IND,'A', 'Y','N') |
|
AA_GIFT_AUXILIARY |
GIFT_ADJUSTMENT_IND |
NA |
| DECODE(AGRGAUX_GIFT_ADJ_VOID_IND,'V', 'Y','N') |
|
AA_GIFT_AUXILIARY |
GIFT_VOID_IND |
NA |
| DECODE(ATVPCAT_COND_IND) |
|
AA_PLEDGE |
PLEDGE_CONDITIONAL_IND |
|
| DECODE(DSS.ACAD_HISTORY_EXISTS_IND,1, S.PERSON_UID, NULL |
|
|
|
|
| DECODE(DSS.COOP_ED_PARTICIPANT_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.GRADUATE_CREDIT_ELIG_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(FRBEVNG_PMT_METHOD_TYPE_IND) |
|
|
|
|
| DECODE(GOKODSF.F_GET_DESC) |
|
AS_ADMISSIONS_DECISION |
DECISION_SOURCE |
DECODE(SUBSTR(GOKODSF.F_GET_DESC(SARAPPD_APDC_CODE,'STVAPDC','STVTERM_STDN_ACC_IND'),1,1),'Y','Applicant','Institution') |
| DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_S |
|
|
|
|
| DECODE(SARCHKL_RECEIVE_DATE) |
|
|
|
Determines if the admissions requirement was completed by the presence of the receive date. |
| DECODE(SHRATTR_PIDM) |
|
AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_ATTRIBUTE |
TRANSFER_COURSE_IND INSTITUTION_COURSE_IND |
|
| DECODE(SHRTCKN_PIDM) |
|
AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_ATTRIBUTE |
TRANSFER_COURSE_IND INSTITUTION_COURSE_IND |
|
| DECODE(SOKODSF.F_GET_SORMAJR_DATA) |
|
|
|
|
| DECODE(SORDEGR_HONR_CODE, NULL, 0, 1), |
|
|
|
|
| DECODE(SORLCUR_TERM_CODE_MATRIC,NULL, 'N','Y') |
|
AS_LEARNER_CURRICULUM_FOS |
MATRICULATED_IND |
NA |
| DECODE(STVDEGS_AWARD_STATUS_IND,'A','Y', 'N') |
|
AS_ACADEMIC_OUTCOME |
GRADUATED_IND |
Determines if the student graduated by checking the degree award status. If the status is awarded, then the student has graduated. |
| DECODE(STVRESD_IN_STATE_IND) |
|
AS_GENERAL_STUDENT |
RESIDENCY_IND |
Determines if the student is a resident by checking the residency state indicator. |
| DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR2_RET_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR3_RET_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR4_GRAD_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR4_RET_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR4_GRADUATION_IND,1,PERSON_IN, NULL) YEAR4_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR5_GRAD_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR5_GRADUATION_IND,1,PERSON_IN, NULL) YEAR5_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_GRAD_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR6_GRADUATION_IND,1,PERSON_IN, NULL) YEAR6_GRADUATION_HEADCOUNT, |
|
|
|
|
| DOKODSF.F_GET_PLAN_CMNT_EXST_IND |
|
|
|
|
| DOKODSF.F_GET_SHP_SETTINGS_TEXT |
|
|
|
|
| FBKBUDG.F_GETLOCKSTATUS |
|
AF_BUDGET_DETAIL |
ORGANIZATION_LOCK_STATUS |
This function returns the lock status of a budget from FBBLOCK for a specified chart of accounts, budget identifier, budget phase and organization code. |
| FOFYCNV |
|
AF_INVOICE_ACCOUNTING AF_OPERATING_LEDGER AF_PROGRAM_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_FIXED_ASSET_ADJUSTMENT AF_GENERAL_LEDGER AF_PROPOSAL AF_PURCHASE_ORDER_ACCOUNTING AF_FUND_HIERARCHY_FISCAL AF_GRANT AF_GRANT_LEDGER AF_BUDGET_DETAIL AF_LOCATION_HIERARCHY_FISCAL AF_BUDGET_AVAILABILITY_LEDGER AF_ORGN_HIERARCHY_FISCAL AF_PROPOSAL AF_PROPOSAL AF_PROPOSAL AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_LEDGER |
FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR SUBMISSION_FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR STATUS_FISCAL_YEAR GRANT_YEAR BUDGET_YEAR FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR ORIGINATION_FISCAL_YEAR AWARD_FISCAL_YEAR DECLINE_FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR |
NA |
| FOFYCNV(FTVFSPD_FSYR_CODE) |
|
AF_FISCAL_PERIOD |
FISCAL_YEAR |
|
| FOKODSF.F_AGCY_HIER |
|
AF_GRANT AF_GRANT AF_GRANT AF_GRANT AF_PROPOSAL AF_PROPOSAL AF_PROPOSAL AF_PROPOSAL |
AGENCY_UID_LEVEL_2 AGENCY_UID_LEVEL_1 AGENCY_UID_LEVEL_3 AGENCY_UID_LEVEL_4 AGENCY_UID_LEVEL_2 AGENCY_UID_LEVEL_3 AGENCY_UID_LEVEL_1 AGENCY_UID_LEVEL_4 |
|
| FOKODSF.F_CALC_BLANKET_ORDER_BAL |
|
AF_PURCHASE_ORDER |
TOTAL_BLANKET_ORDER_BAL |
This function returns the sum of the FPRPODT_BO_REMAIN_BAL from FPRPODT for the specified purchase order and change sequence number. |
| FOKODSF.F_CALC_GL_ACTIVITY |
|
AF_GENERAL_LEDGER AF_GENERAL_LEDGER |
BEGINNING_BALANCE ENDING_BALANCE |
This function returns the periodic debits and periodic credits as well as the year to date debits and the year to date credits from FGBGENL for the specified chart of accounts, fiscal year, fiscal period, fund and account. |
| FOKODSF.F_CALC_TOT_APPROV_ITEM_AMT |
|
AF_PURCHASE_ORDER |
TOTAL_APPROVED_ITEM_AMOUNT |
This function returns the total approved item amount from FPRPODT for the specified purchase order and change sequence number. Total approved item amount is calculated as the sum of the following: (FPRPODT_UNIT_PRICE * FPRPODT_QTY ) + FPRPODT_TAX_AMT + FPRPODT_ADDL_CHRG_AMT - FPRPODT_DISC_AMT. |
| FOKODSF.F_CALC_TOT_CONVERT_ITEM_AMT |
|
AF_PURCHASE_ORDER |
TOTAL_CONVERTED_AMOUNT |
This function returns the total converted item amount from FPRPODT for the specified purchase order and change sequence number. Total converted item amount is calculated as the sum of the following: FPRPODT_CONVERT_UNIT_PRICE * FPRPODT_QTY ) + FPRPODT_CONVERT_TAX_AMT + FPRPODT_CONVERT_ADDL_CHRG_AMT - FPRPODT_CONVERT_DISC_AMT. |
| FOKODSF.F_CAPITALIZED_AMT |
|
AF_FIXED_ASSET_ITEM |
ORIGINAL_CAPITALIZED_AMOUNT |
This function returns the sum of the FFRMASA_AMT from FFRMASA where the FFRMASA_OTAG_CODE matches the specified asset for the latest FFRMASA_CHANGE_SEQ_NUM and the FFRMASA_OTAG_CODE_ATTACHMENT is NULL. |
| FOKODSF.F_CONCAT_OP_AMTS |
|
AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_BUDGET_DETAIL |
CURRENT_ADOPTED_BUDGET CURRENT_BUDGET PRIOR_YTD_ACTIVITY CURRENT_BUDGET_ADJUSTMENTS CURRENT_YTD_ACTIVITY |
This function is used to return the operating ledger amounts from FGBOPAL for a given fiscal year, period, FOAPAL, and commitment type combination. The data is concatenated together and separated by the character {. |
| FOKODSF.F_COST_AMT |
|
AF_FIXED_ASSET_ITEM |
ORIGINAL_COST_AMOUNT |
This function will return the original cost of the asset excluding attachment costs. It will atempt to retrieve the amount from FFRMASF for a the specified asset. If it does not exist in FFRMASF, it will then retrieve the amount from FFRMASA for the specified asset and latest change sequence number. |
| FOKODSF.F_GET_ACCT_HIER |
|
R
RARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL
|
s
size="2">ACCOUNT_LEVEL_3 ACCOUNT_LEVEL_4 ACCOUNT_STATUS_4 ACCOUNT_LEVEL_2 ACCOUNT_DESC_4 ACCOUNT_LEVEL_1 ACCOUNT_LEVEL_3 ACCOUNT_STATUS_1 ACCOUNT_DESC_2 ACCOUNT_STATUS_1 ACCOUNT_DESC_1 ACCOUNT_DESC_3 ACCOUNT_STATUS_3 ACCOUNT_STATUS_4
|
|
| FOKODSF.F_GET_BVL_AMTS |
|
AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER |
SUM_REMAINING_BALANCE CURR_ENCUMBRANCES CURR_PERCENT_AVAILABLE CURR_REMAINING_BALANCE CURR_BUDGET_RESERVATION SUM_BUDGET_RESERVATION SUM_ENCUMBRANCES CURR_BUDGET_ADJUSTMENTS SUM_BUDGET_ADJUSTMENTS SUM_ADOPTED_BUDGET SUM_YEAR_TO_DATE_ACTV CURR_ADOPTED_BUDGET CURR_YEAR_TO_DATE_ACTV SUM_PERCENT_AVAILABLE |
Extracts each of the budget availability amounts for the current period and totals each amount for the as of period. |
| FOKODSF.F_GET_FINANCE_DESC |
|
AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AE_ACCOUNTING AE_ACCOUNTING AE_ACCOUNTING AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AN_PAYROLL_DISTRIBUTION AF_GRANT_DEFERRED_COST AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AF_FIXED_ASSET_FUNDING_SOURCE AF_PURCHASE_ORDER_ACCOUNTING AP_EMPLOYEE AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING |
CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC PROJECT_DESC ACCOUNT_INDEX_DESC CHART_OF_ACCOUNTS_DESC PROJECT_DESC ORGANIZATION_DESC LOCATION_DESC PROGRAM_DESC PROJECT_DESC CHART_OF_ACCOUNTS_DESC ACCOUNT_DESC FUND_DESC PROJECT_CODE_DESC ACTIVITY_DESC HOME_ORGANIZATION_CHART_DESC ACCOUNT_INDEX_DESC ORGANIZATION_DESC |
|
| FOKODSF.F_GET_FINANCE_STATUS |
|
AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AF_GRANT_DEFERRED_COST AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING |
ACCOUNT_STATUS PROGRAM_STATUS ORGANIZATION_STATUS ACCOUNT_INDEX_STATUS LOCATION_STATUS FUND_STATUS CHART_OF_ACCOUNTS_STATUS ACTIVITY_STATUS CHART_OF_ACCOUNTS_STATUS |
|
| FOKODSF.F_GET_FTVCRSN_DESC |
|
AF_PURCHASE_ORDER |
CANCEL_REASON_DESC |
This function returns the description of the cancellation based upon a specified cancellation code and cancel date. |
| FOKODSF.F_GET_FUND_HIER |
|
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL |
FUND_STATUS_2 FUND_STATUS_4 FUND_STATUS_5 FUND_DESC_1 FUND_DESC_4 FUND_LEVEL_1 FUND_LEVEL_3 FUND_LEVEL_4 FUND_STATUS_4 FUND_DESC_5 FUND_STATUS_1 FUND_STATUS_2 FUND_LEVEL_5 FUND_LEVEL_1 FUND_LEVEL_3 FUND_LEVEL_4 FUND_STATUS_5 FUND_LEVEL_5 FUND_STATUS_3 FUND_DESC_1 FUND_DESC_2 FUND_DESC_4 FUND_DESC_2 FUND_LEVEL_2 FUND_DESC_3 FUND_DESC_5 FUND_LEVEL_2 FUND_DESC_3 FUND_STATUS_1 FUND_STATUS_3 |
Extracts the finance fund or fund description, fund status and fund level for each level of the fund hierarchy for a given chart of accounts and fund code. |
| FOKODSF.F_GET_LOCN_HIER |
|
AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL |
LOCATION_DESC_2 LOCATION_DESC_5 LOCATION_STATUS_4 LOCATION_DESC_5 LOCATION_STATUS_3 LOCATION_STATUS_4 LOCATION_LEVEL_3 LOCATION_STATUS_3 LOCATION_LEVEL_5 LOCATION_STATUS_5 LOCATION_STATUS_2 LOCATION_LEVEL_4 LOCATION_STATUS_1 LOCATION_STATUS_5 LOCATION_DESC_1 LOCATION_DESC_3 LOCATION_LEVEL_5 LOCATION_DESC_1 LOCATION_LEVEL_2 LOCATION_LEVEL_3 LOCATION_LEVEL_1 LOCATION_LEVEL_2 LOCATION_DESC_3 LOCATION_DESC_4 LOCATION_DESC_4 LOCATION_DESC_2 LOCATION_LEVEL_1 LOCATION_LEVEL_4 LOCATION_STATUS_1 LOCATION_STATUS_2 |
Extracts the finance location or location description, location status and location level for each level of the location hierarchy for a given chart of accounts and location code. |
| FOKODSF.F_GET_MIN_QUANTITY |
|
AF_PURCHASE_ORDER_ITEM |
AGREEMENT_MINIMUM_QUANTITY |
|
| FOKODSF.F_GET_ORGN_HIER |
|
>
> AF_ORGANIZATION_HIERARCHY AF_ORGANIZATION_HIERARCHY AF_ORGANIZATION_HIERARCHY AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY AF_ORGANIZATION_HIERARCHY AF_ORGANIZATION_HIERARCHY AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL
|
E
ERARCHY_COMP_target.html#ORGANIZATION_LEVEL_4">ORGANIZATION_LEVEL_4 ORGANIZATION_LEVEL_5 ORGANIZATION_STATUS_2 ORGANIZATION_LEVEL_5 ORGANIZATION_DESC_1 ORGANIZATION_DESC_4 ORGANIZATION_DESC_6 ORGANIZATION_STATUS_8 ORGANIZATION_LEVEL_4 ORGANIZATION_DESC_3 ORGANIZATION_LEVEL_6 ORGANIZATION_LEVEL_8 ORGANIZATION_STATUS_3 ORGANIZATION_STATUS_2 ORGANIZATION_STATUS_7 ORGANIZATION_STATUS_8
|
Extracts the finance organization or organization description, organization status and organization level for each level of the organization hierarchy for a given chart of accounts and organization code. |
| FOKODSF.F_GET_PROG_HIER |
|
AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL |
PROGRAM_STATUS_1 PROGRAM_STATUS_2 PROGRAM_LEVEL_3 PROGRAM_STATUS_5 PROGRAM_DESC_3 PROGRAM_STATUS_1 PROGRAM_STATUS_2 PROGRAM_DESC_1 PROGRAM_DESC_2 PROGRAM_DESC_3 PROGRAM_DESC_4 PROGRAM_LEVEL_3 PROGRAM_LEVEL_5 PROGRAM_LEVEL_2 PROGRAM_LEVEL_4 PROGRAM_LEVEL_1 PROGRAM_STATUS_4 PROGRAM_STATUS_5 PROGRAM_LEVEL_1 PROGRAM_LEVEL_5 PROGRAM_LEVEL_4 PROGRAM_DESC_4 PROGRAM_DESC_5 PROGRAM_DESC_1 PROGRAM_DESC_2 PROGRAM_STATUS_3 PROGRAM_STATUS_4 PROGRAM_DESC_5 PROGRAM_LEVEL_2 PROGRAM_STATUS_3 |
Extracts the finance program or program description, program status and program level for each level of the program hierarchy for a given chart of accounts and program code. |
| FOKODSF.F_GET_REST_IND |
|
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
FUND_BALANCE_RESTRICTION FUND_BALANCE_RESTRICTION |
|
| FOKODSF.F_GET_SDAT_TITLE |
|
AF_ACCOUNT_HIERARCHY_FISCAL AF_GRANT_BILLING_DETAIL AF_ACCOUNT_HIERARCHY_FISCAL AF_FIXED_ASSET_ITEM AF_FUND_HIERARCHY_FISCAL AF_GRANT AF_ACCOUNT_HIERARCHY AF_FIXED_ASSET_ITEM AF_GRANT AF_PROPOSAL AF_ACCOUNT_HIERARCHY AF_FUND_HIERARCHY AF_GRANT_PERSONNEL AF_TRANSACTION_HISTORY AF_ACCOUNT_HIERARCHY AF_ENDOWMENT AF_GRANT_LEDGER AF_ACCOUNT_HIERARCHY AF_GRANT AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_GRANT AF_ACCOUNT_HIERARCHY |
ACCOUNT_CLASS_DESC ACCOUNT_CLASS_DESC INTERNAL_ACCOUNT_TYPE_DESC ASSET_STATUS_DESC INTERNAL_FUND_TYPE_DESC STATUS_DESC INTERNAL_ACCOUNT_TYPE_DESC USER_STATUS_DESC SUBCATEGORY_DESC PROPOSAL_TYPE_DESC CTRL_ACTUAL_ACTIVITY_SEQ_DESC INTERNAL_FUND_TYPE_DESC PERSONNEL_TYPE_DESC DETAIL_POSTING_PROCESS_DESC CTRL_ADOPTED_BUDGET_SEQ_DESC ENDOWMENT_TYPE_DESC ACCOUNT_CLASS_DESC CTRL_ENCUMBRANCE_SEQ_DESC CATEGORY_DESC CTRL_BUDGET_ADJUST_SEQ_DESC CTRL_BUDGET_RESERVE_SEQ_DESC CTRL_TEMPORARY_BUDGET_SEQ_DESC GRANT_TYPE_DESC ACCOUNT_CLASS_DESC |
NA |
| FOKODSF.F_GET_SPONSOR_ACCT |
|
AF_GRANT_LEDGER |
SPONSOR_ACCOUNT |
Extracts the granting agency sponsor's equivalent account for a given grant. |
| FOKODSF.F_GRANT_TO_FISCAL_YEAR |
|
AF_GRANT_LEDGER AF_GRANT_LEDGER |
FISCAL_YEAR FISCAL_PERIOD |
This function will return the fiscal year and fiscal period concatenated for a specified grant id, chart of accounts, grant year and grant period. |
| FOKODSF.F_INV_TOT_APPROV_ITEM_AMT |
|
AF_INVOICE |
TOTAL_APPROVED_ITEM_AMOUNT |
This function returns the total approved item amount for a specified invoice code. Total approved item amount is calculated as FARINVA_APPR_AMT + FARINVA_TAX_AMT+ FARINVA_ADDL_CHRG_AMT - FARINVA_DISC_AMOUNT from FARINVA minus any FARINTX_REBATE_AMT from FARINTX. |
| FOKODSF.F_INV_TOT_CONVERT_ITEM_AMT |
|
AF_INVOICE |
TOTAL_CONVERTED_AMOUNT |
This function returns the total converted item amount for a specified invoice code. Total converted item amount is calculated as FARINVA_CONVERT_AMT + FARINVA_CONVERT_TAX_AMT+ FARINVA_CONVERT_ADDL_CHRG_AMT - FARINVA_CONVERT_DISC_AMOUNT from FARINVA minus any FARINTX_CONVERT_REBATE_AMT from FARINTX. |
| FOKODSF.F_NET_BOOK_AMT |
|
AF_FIXED_ASSET_ITEM |
NET_BOOK_VALUE_AMOUNT |
This function will return the net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the latest change sequence number of the specified asset not including attachment costs. |
| FOKODSF.F_PO_DISC_PCT |
|
AF_PURCHASE_ORDER_ITEM |
DISCOUNT_PERCENT |
This function returns the discount percentage for a discount code associated with a specified purchase order. |
| FOKODSF.F_PO_ITEM_LAST_CHANGE_SEQNO |
|
AF_PURCHASE_ORDER_ITEM |
ITEM_CHANGE_ORDER |
|
| FOKODSF.F_PO_LAST_CHANGE_DATE |
|
AF_PURCHASE_ORDER |
PO_CHANGE_DATE |
NA |
| FOKODSF.F_PO_LAST_CHANGE_SEQNO |
|
AF_PURCHASE_ORDER |
PO_CHANGE_ORDER |
NA |
| FOKODSF.F_REMAINING_LIFE |
|
AF_FIXED_ASSET_ITEM AF_FIXED_ASSET_ITEM AF_FIXED_ASSET_ITEM AF_FIXED_ASSET_ITEM |
REMAINING_LIFE_YEARS REMAINING_LIFE_QUARTERS REMAINING_LIFE_MONTHS REMAINING_LIFE_SEMI_ANNUAL |
This function will return the remaining life based on the depreciation frequency (Quarterly, Semi-Annually, or Yearly). |
| FOKODSF.F_TOTAL_BOOK_AMT |
|
AF_FIXED_ASSET_ITEM |
TOTAL_NET_BOOK_VALUE_AMOUNT |
This function will return the net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the latest change sequence number of the specified asset including attachment costs. |
| FOKODSF.F_TOTAL_COST_AMT |
|
AF_FIXED_ASSET_ITEM |
TOTAL_ORIGINAL_COST_AMOUNT |
This function will return the original cost of the asset including attachment costs. It will atempt to retrieve the amount from FFRMASF for a the specified asset. If it does not exist in FFRMASF, it will then retrieve the amount from FFRMASA for the specified asset and latest change sequence number. |
| FRKIDEN.F_GET_FRBGRNT_STATUS_CODE |
|
AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL |
GRANT_STATUS GRANT_STATUS |
This function retrieves the FRBGRNT_STATUS_CODE from FRBGRNT for a specified grant. |
| FRKIDEN.F_GET_FRBGRNT_TITLE |
|
AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL |
GRANT_DESC GRANT_DESC |
This function retrieves the FRBGRNT_TITLE from FRBGRNT for a specified grant. |
| FRKIDEN.F_GET_SPRIDEN_ENTITY_IND |
|
|
|
This function retrieves the SPRIDEN_ENTITY_IND from SPRIDEN for a specified entity. |
| FRKIDEN.F_GET_SPRIDEN_LAST_NAME |
|
AF_INVOICE_ACCOUNTING |
BANK_DESC |
This function retrieves the SPRIDEN_LAST_NAME from SPRIDEN for a specified entity. |
| FTVORGN_FMGR_CODE_PIDM |
|
|
|
|
| F_ACTIVE_COURSE_IND |
|
AS_COURSE_CATALOG |
ACTIVE_COURSE_IND |
This function retrieves the column STVCSTA_ACTIVE_IND from STVCSTA for a specified course status code. It then queries the GTVSDAX table to determine whether it matches the rule where the GTVSDAX_INTERNAL_CODE = ACTIVE, and the GTVSDAX_INTERNAL_CODE_GROUP = COURSE STATUS. |
| F_ACTIVE_SECTION_IND |
|
AS_COURSE_OFFERING |
ACTIVE_OFFERING_IND |
This function retrieves the column STVSSTS_ACTIVE_IND from STVSSTS for a specified section status code. It then queries the GTVSDAX table to determine whether it matches the rule where the GTVSDAX_INTERNAL_CODE = ACTIVE, and the GTVSDAX_INTERNAL_CODE_GROUP = SECTION STATUS. |
| F_ADMS_APPLICANT_WITHDRAWN |
|
AS_ADMISSIONS_APPLICATION |
APPLICANT_WITHDRAWN_IND |
This function returns a Y if a record exists in the SARADAP table for the specified person, academic period, and application number where the withdrawal reason is not NULL. |
| F_ADMS_APPLICATION_STATUS |
|
AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION |
COMPLETE_IND INCOMPLETE_IND |
This function retrieves the application status from SARADAP for a specified combination of person, academic period, and application number. It then determines whether the application status matches the defined rule within GTVSDAX with the GTVSDAX_INTERNAL_CODE_GROUP = APPLICATION STATUS and a GTVSDAX_INTERNAL_CODE matching the specified status and returns a Y if found. The two possible statuses that can be passed are APPLCMPL for a status of complete and APPLINCM for a status for incomplete. |
| F_AGCY_HIER |
|
|
|
This function takes a specified agency pidm and level as input and returns the agency pidm that exists at the specified level within the hierarchy for the specified agency. |
| F_APPLIED_FOR_DEGREE |
|
AS_ACADEMIC_OUTCOME |
APPLIED_FOR_OUTCOME_IND |
This function evaluates the SHRDGMR and STVDEGS tables to determine if the degree status code associated with the specified individual has a STVDEGS_AWARD_STATUS_IND = P. If it does, then the function returns a Y. Otherwise, an N is returned. |
| F_CALCULATE_AGE |
|
|
|
This function calculates age for a specified as of date, birth date, admit academic period start date and date of death. The age is not calculated beyond any specified, not null, deceased date. |
| F_CALC_REGISTRATION_HOURS |
|
AS_ENROLLMENT AS_ENROLLMENT AS_ENROLLMENT AS_ENROLLMENT AS_ENROLLMENT AS_ENROLLMENT |
TOTAL_CEU_BILLING TOTAL_CEU_CREDITS TOTAL_NON_CEU_CREDITS TOTAL_BILLING TOTAL_CREDITS TOTAL_NON_CEU_BILLING |
This function will summarize credit or billing hours (CREDIT or BILL) for either total, ceu, or non ceu courses (TOTAL, CEU, or NONCEU) by either a specified academic period or combination of entity and academic period. |
| F_CALC_TOTAL_BUDGET |
|
AR_FINAID_BUDGET_COMPONENT AR_FINAID_BUDGET_COMPONENT |
TOTAL_BUDGET TOTAL_BUDGET |
|
| F_CALC_TOTAL_OFFER |
|
AR_APPLICANT_NEED |
TOTAL_OFFER_AMOUNT |
This function returns the total offer amount from RPRAWRD for a specified entity and aid year. |
| F_CAMPAIGN_GIVING |
|
AA_CAMPAIGN_GIVING_HISTORY |
CAMPAIGN_GIVING |
This function adds the APRCHIS_AMT_PLEDGED_PAID and APRCHIS_AMT_GIFT in APRCHIS and substracts the total of AGRGMMO_3PP_TOT_AMT for the specified entity, fiscal year and campaign. |
| F_CAMPAIGN_MATCHING_GIFT |
|
AA_CAMPAIGN_GIVING_HISTORY |
AMOUNT_MATCHING_GIFT |
This function returns the summarized AGRMMO_CREDIT for all matching gifts for the specified entity, fiscal year and campaign. |
| F_CAMPAIGN_MEMO_CREDIT |
|
AA_CAMPAIGN_GIVING_HISTORY |
AMOUNT_MEMO_CREDIT |
This function returns the summarized AGRMMO_CREDIT for all non-matching gifts for the specified entity, fiscal year and campaign. |
| F_CHECK_FOR_COURSE_PREREQS |
|
|
|
This function returns the course pre-requisite indicator from SCRRTST for the specified subject, course, effective academic period, and pre-requisite type. |
| F_CHECK_FOR_TRANSFER_WORK |
|
AS_ACADEMIC_OUTCOME |
TRANSFER_WORK_EXISTS_IND |
This function returns a Y if a record is found in the SHRTRIT table for the specified entity. |
| F_CLASS_CALC_FNC |
|
|
|
This function returns the class code based upon the hours earned for a specified combination of entity, student level, and academic period. |
| F_DESIGNATION_GIVING |
|
AA_DESIGNATION_GIVING_HISTORY |
DESIGNATION_GIVING |
This function returns the APRDHIS_AMT_PLEDGED_PAID added to the APRDHIS_AMT_GIFT and substracts the total of AGRGMMO_3PP_TOT_AMT for the specified combination of entity, fiscal year, and designation. |
| F_DESIGNATION_MATCHING_GIFT |
|
AA_DESIGNATION_GIVING_HISTORY |
AMOUNT_MATCHING_GIFT |
This function returns the summarized AGRMMO_CREDIT for all matching gifts for the specified entity, fiscal year and designation. |
| F_DESIGNATION_MEMO_CREDIT |
|
AA_DESIGNATION_GIVING_HISTORY |
AMOUNT_MEMO_CREDIT |
This function returns the summarized AGRMMO_CREDIT for all non-matching gifts for the specified entity, fiscal year and designation. |
| F_DISPOSITION_IND |
|
AP_HR_APPLICATION |
STATUS_DISPOSITION |
This function selects disposition indicator from the applicant status rule table (PTRAPPS) based on the specified entity, requisition number, position, position class, and application date. |
| F_DONOR_IND |
|
AA_CONSTITUENT AA_ORGANIZATIONAL_CONSTITUENT |
DONOR_IND DONOR_IND |
This function retrieves a 'Y' for a person passed if a record exists in the gift history table. |
| F_ENROLLED_THIS_TERM |
|
AS_ENROLLMENT |
ENROLLED_IND |
This function retrieves the enrollment status code for a person and academic period passed. If no records exists, an 'N' is returned. |
| F_EPSCCODE |
|
AS_ADDRESS AS_INSTITUTION |
ENRL_PLANNING_SERVICE EPS_CODE |
This function retrieves the enrollment planning sevices code for an address. |
| F_FACULTY_ADVISING_IND |
|
|
|
This function retrieves a 'Y' or 'N' based on the person and academic period that is passed. If a record exists in the advisor table then a 'Y' is returned. Otherwise, an 'N' is returned. |
| F_FACULTY_SCHEDULED_IND |
|
|
|
This function retrieves a 'Y' or 'N' based on the person and academic period that is passed. If a record exists in the instructional assignment table then a 'Y' is returned. Otherwise, an 'N' is returned. |
| F_FINAID_APPLICANT_IND |
|
AR_FINAID_APPLICANT_STATUS |
FINAID_APPLICANT_IND |
This function retrieves a 'Y' or 'N' based on the person and aid year that is passed. If a record exists in the applicant status table then a 'Y' is returned. Otherwise, an 'N' is returned. |
| F_FORMAT_MAILING_ADDRESS |
|
|
|
This function retrieves the formatted mailing address based on the person, address type, sequence number, status indicator and specified code tpye of either 'US' or 'OTHER'. |
| F_FORMAT_NAME |
|
AP_INTERVIEW AS_FACULTY_FEEDBACK AT_ACCOUNT AS_PERSON AS_PERSON AS_FACULTY_FEEDBACK |
INTERVIEWER_NAME NAME NAME FULL_NAME_FMIL FULL_NAME_LFMI INSTRUCTOR_NAME |
This function returns an entity's name based upon a specified pidm and name type. The possible name types are as follows: (LF30) Last name, first name for 30 characters; (L30) Last name for 30 characters; (FL30) First name, last name for 30 characters; (FL) Last name, first name; (FMIL) First name, middle initial, last name; (FML) First name, middle name, last name; (LFMI) Last name, first name, middle initial. |
| F_GET_CIPC_DESC |
|
AR_AWARD_DISBURSEMENT |
PROGRAM_CLASSIFICATION_DESC |
|
| F_GET_DATE_PREV_EDUCATION |
|
|
|
|
| F_GET_FINANCE_DESC |
|
l
l">AF_FIXED_ASSET_FUNDING_SOURCE AF_GENERAL_LEDGER AF_GRANT AF_GRANT_BILLING_DETAIL AF_GRANT_LEDGER AF_INVOICE_ACCOUNTING AT_GRANT_ACCOUNT_DETAIL AF_ACCOUNT_HIERARCHY_FISCAL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_UNITS AF_ENDOWMENT_UNITS AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_ITEM AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_GRANT_BILLING_DETAIL AF_OPERATING_LEDGER AF_TRANSACTION_HISTORY AF_ACCOUNT_INDEX AF_ACCOUNT_INDEX AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_DIST AF_FIXED_ASSET_FUNDING_SOURCE AF_GRANT_BILLING_DETAIL AF_GRANT_FUND AF_GRANT_LEDGER AF_FIXED_ASSET_FUNDING_SOURCE AF_GENERAL_LEDGER AF_GRANT AF_GRANT_BILLING_DETAIL AF_GRANT_LEDGER AF_INVOICE_ACCOUNTING AT_GRANT_ACCOUNT_DETAIL AF_ACCOUNT_HIERARCHY_FISCAL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_UNITS AF_ENDOWMENT_UNITS AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_ITEM AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_GRANT_BILLING_DETAIL AF_OPERATING_LEDGER AF_TRANSACTION_HISTORY AF_ACCOUNT_INDEX AF_ACCOUNT_INDEX AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_DIST AF_FIXED_ASSET_FUNDING_SOURCE AF_GRANT_BILLING_DETAIL AF_GRANT_FUND AF_GRANT_LEDGER AF_INVOICE_ACCOUNTING AF_INVOICE_ACCOUNTING AF_ORGANIZATION_HIERARCHY AF_ACCOUNT_INDEX AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_FISCAL_PERIOD AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_DEPRECIATION AF_FUND_HIERARCHY_FISCAL AF_GENERAL_LEDGER AF_GRANT AF_GRANT_BILLING_DETAIL AF_OPERATING_LEDGER AF_OPERATING_LEDGER AF_PROGRAM_HIERARCHY_FISCAL AF_TRANSACTION_HISTORY AP_EMPLOYEE AF_ACCOUNT_HIERARCHY AF_ACCOUNT_INDEX AF_ACCOUNT_INDEX AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_FIXED_ASSET_ADJUSTMENT AF_FIXED_ASSET_FUNDING_SOURCE AF_FUND_HIERARCHY_FISCAL AF_GENERAL_LEDGER AF_GRANT_BILLING_DETAIL AF_GRANT
l">AF_FIXED_ASSET_FUNDING_SOURCE AF_GENERAL_LEDGER AF_GRANT AF_GRANT_BILLING_DETAIL AF_GRANT_LEDGER AF_INVOICE_ACCOUNTING AT_GRANT_ACCOUNT_DETAIL AF_ACCOUNT_HIERARCHY_FISCAL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_UNITS AF_ENDOWMENT_UNITS AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_ITEM AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_GRANT_BILLING_DETAIL AF_OPERATING_LEDGER AF_TRANSACTION_HISTORY AF_ACCOUNT_INDEX AF_ACCOUNT_INDEX AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_DIST AF_FIXED_ASSET_FUNDING_SOURCE AF_GRANT_BILLING_DETAIL AF_GRANT_FUND AF_GRANT_LEDGER AF_INVOICE_ACCOUNTING AF_INVOICE_ACCOUNTING AF_ORGANIZATION_HIERARCHY AF_ACCOUNT_INDEX AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_FISCAL_PERIOD AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_DEPRECIATION AF_FUND_HIERARCHY_FISCAL AF_GENERAL_LEDGER AF_GRANT AF_GRANT_BILLING_DETAIL AF_OPERATING_LEDGER AF_OPERATING_LEDGER AF_PROGRAM_HIERARCHY_FISCAL AF_TRANSACTION_HISTORY AP_EMPLOYEE AF_ACCOUNT_HIERARCHY AF_ACCOUNT_INDEX AF_ACCOUNT_INDEX AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_FIXED_ASSET_ADJUSTMENT AF_FIXED_ASSET_FUNDING_SOURCE AF_FUND_HIERARCHY_FISCAL AF_GENERAL_LEDGER AF_GRANT_BILLING_DETAIL AF_GRANT_BILLING_DETAIL AF_GRANT_FUND AF_GRANT_FUND AF_GRANT_FUND AF_ORGANIZATION_HIERARCHY AF_ACCOUNT_INDEX AF_BUDGET_DETAIL AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_ATTRIBUTES AF_ENDOWMENT_UNITS AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_FIXED_ASSET_ITEM AF_GRANT AF_GRANT_LEDGER AF_GRANT_LEDGER AF_INVOICE_ACCOUNTING AF_INVOICE_ACCOUNTING AF_LOCATION_HIERARCHY_FISCAL AF_OPERATING_LEDGER AF_ORGN_HIERARCHY_FISCAL AF_PROPOSAL AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENTAF_FIXED_ASSET_FUNDING_SOURCE AF_GENERAL_LEDGER AF_GRANT AF_GRANT_BILLING_DETAIL AF_GRANT_LEDGER AF_INVOICE_ACCOUNTING AT_GRANT_ACCOUNT_DETAIL AF_ACCOUNT_HIERARCHY_FISCAL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_UNITS AF_ENDOWMENT_UNITS AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_ITEM AF_FUND_HIERARCHY AF_FUND_HIERARCHY AF_GRANT_BILLING_DETAIL AF_OPERATING_LEDGER AF_TRANSACTION_HISTORY AF_ACCOUNT_INDEX AF_ACCOUNT_INDEX AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_DIST AF_FIXED_ASSET_FUNDING_SOURCE AF_GRANT_BILLING_DETAIL AF_GRANT_FUND AF_GRANT_LEDGER AF_INVOICE_ACCOUNTING AF_INVOICE_ACCOUNTING AF_ORGANIZATION_HIERARCHY AF_ACCOUNT_INDEX AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_BUDGET_DETAIL AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_FISCAL_PERIOD AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_DEPRECIATION AF_FUND_HIERARCHY_FISCAL AF_GENERAL_LEDGER AF_GRANT AF_GRANT_BILLING_DETAIL AF_OPERATING_LEDGER AF_OPERATING_LEDGER AF_PROGRAM_HIERARCHY_FISCAL AF_TRANSACTION_HISTORY AP_EMPLOYEE AF_ACCOUNT_HIERARCHY AF_ACCOUNT_INDEX AF_ACCOUNT_INDEX AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_FIXED_ASSET_ADJUSTMENT AF_FIXED_ASSET_FUNDING_SOURCE AF_FUND_HIERARCHY_FISCAL AF_GENERAL_LEDGER AF_GRANT_BILLING_DETAIL AF_GRANT_BILLING_DETAIL AF_GRANT_FUND AF_GRANT_FUND AF_GRANT_FUND AF_ORGANIZATION_HIERARCHY AF_ACCOUNT_INDEX AF_BUDGET_DETAIL AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_ATTRIBUTES AF_ENDOWMENT_UNITS AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_FIXED_ASSET_ITEM AF_GRANT AF_GRANT_LEDGER AF_GRANT_LEDGER AF_INVOICE_ACCOUNTING AF_INVOICE_ACCOUNTING AF_LOCATION_HIERARCHY_FISCAL AF_OPERATING_LEDGER AF_ORGN_HIERARCHY_FISCAL AF_PROPOSAL AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_AVAILABILITY_LEDGER AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT AF_ENDOWMENT_UNITS AF_ENDOWMENT_UNITS AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_FIXED_ASSET_ITEM AF_GRANT_BILLING_DETAIL AF_GRANT_BILLING_DETAIL AF_GRANT_BILLING_DETAIL AF_GRANT_FUND AF_GRANT_FUND AF_GRANT_LEDGER AF_OPERATING_LEDGER AF_OPERATING_LEDGER AF_OPERATING_LEDGER AF_PROGRAM_HIERARCHY AF_PROPOSAL AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ACCOUNTING AP_EMPLOYEE
|
l
lor="#000000" face="Arial" size="2">INCOME_CR_ACCOUNT_DESC INCOME_CR_CHART_DESC INCOME_CR_PROGRAM_DESC UNREAL_GAIN_LOSS_INDEX_DESC FUND_DESC PROGRAM_DESC ACTIVITY_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC BILL_ACTIVITY_DESC ACTIVITY_DESC ACCOUNT_DESC ACCOUNT_FUND_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC GAIN_LOSS_DR_ACCT_POOL_DESC GAIN_LOSS_DR_ACTV_POOL_DESC INCOME_CR_FUND_DESC INCOME_DR_ACCOUNT_INDEX_DESC UNREAL_GAIN_LOSS_DR_LOCN_DESC VARIANCE_DR_FUND_POOL_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ORGANIZATION_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC FUND_POOL_DESC BILL_ACCOUNT_INDEX_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC ORGANIZATION_DESC ORGANIZATION_DESC FUND_DESC PROGRAM
lor="#000000" face="Arial" size="2">INCOME_CR_ACCOUNT_DESC INCOME_CR_CHART_DESC INCOME_CR_PROGRAM_DESC UNREAL_GAIN_LOSS_INDEX_DESC FUND_DESC PROGRAM_DESC ACTIVITY_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC BILL_ACTIVITY_DESC ACTIVITY_DESC ACCOUNT_DESC ACCOUNT_FUND_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC GAIN_LOSS_DR_ACCT_POOL_DESC GAIN_LOSS_DR_ACTV_POOL_DESC INCOME_CR_FUND_DESC INCOME_DR_ACCOUNT_INDEX_DESC UNREAL_GAIN_LOSS_DR_LOCN_DESC VARIANCE_DR_FUND_POOL_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ORGANIZATION_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC FUND_POOL_DESC BILL_ACCOUNT_INDEX_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC ORGANIZATION_DESC ORGANIZATION_DESC FUND_DESC PROGRAM_DESC GAIN_LOSS_ACCOUNT_INDEX_DESC INCOME_CR_ACCOUNT_POOL_DESC INCOME_CR_CHART_POOL_DESC UNREAL_GAIN_LOSS_DR_CHART_DESC VARIANCE_DR_LOCN_POOL_DESC VARIANCE_SPEND_DR_CHART_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC BILL_ALTERNATE_FUND_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ACTIVITY_DESC LOCATION_DESC ORGANIZATION_POOL_DESC ACTIVITY_DESC ACCOUNT_DESC ACCOUNT_DESC ACTIVITY_DESC LOCATION_DESC INCOME_CR_ACTIVITY_DESC INCOME_DR_FUND_POOL_DESC INCOME_DR_PROG_POOL_DESC UNREAL_GAIN_LOSS_CR_ACCT_DESC UNREAL_GAIN_LOSS_DR_FUND_DESC VARIANCE_DR_ORGN_POOL_DESC CHART_OF_ACCOUNTS_DESC ASSET_ACCOUNT_DESC LOCATION_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC LOCATION_DESC BILL_FUND_DESC FUND_DESC INCOME_CR_ACCOUNT_DESC INCOME_CR_CHART_DESC INCOME_CR_PROGRAM_DESC UNREAL_GAIN_LOSS_INDEX_DESC FUND_DESC PROGRAM_DESC ACTIVITY_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC BILL_ACTIVITY_DESC ACTIVITY_DESC ACCOUNT_DESC ACCOUNT_FUND_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC GAIN_LOSS_DR_ACCT_POOL_DESC GAIN_LOSS_DR_ACTV_POOL_DESC INCOME_CR_FUND_DESC INCOME_DR_ACCOUNT_INDEX_DESC UNREAL_GAIN_LOSS_DR_LOCN_DESC VARIANCE_DR_FUND_POOL_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ORGANIZATION_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC FUND_POOL_DESC BILL_ACCOUNT_INDEX_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC ORGANIZATION_DESC ORGANIZATION_DESC FUND_DESC PROGRAM_DESC GAIN_LOSS_ACCOUNT_INDEX_DESC INCOME_CR_ACCOUNT_POOL_DESC INCOME_CR_CHART_POOL_DESC UNREAL_GAIN_LOSS_DR_CHART_DESC VARIANCE_DR_LOCN_POOL_DESC VARIANCE_SPEND_DR_CHART_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC BILL_ALTERNATE_FUND_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ACTIVITY_DESC LOCATION_DESC ORGANIZATION_POOL_DESC ACTIVITY_DESC ACCOUNT_DESC ACCOUNT_DESC ACTIVITY_DESC LOCATION_DESC INCOME_CR_ACTIVITY_DESC INCOME_DR_FUND_POOL_DESC INCOME_DR_PROG_POOL_DESC UNREAL_GAIN_LOSS_CR_ACCT_DESC UNREAL_GAIN_LOSS_DR_FUND_DESC VARIANCE_DR_ORGN_POOL_DESC CHART_OF_ACCOUNTS_DESC ASSET_ACCOUNT_DESC LOCATION_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC LOCATION_DESC BILL_FUND_DESC FUND_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC ACTIVITY_DESC CHECK_DISTRIBUTION_CHART_DESC ACCOUNT_POOL_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ACTIVITY_DESC PROGRAM_DESC GAIN_LOSS_DR_LOCN_POOL_DESC INCOME_DR_ACCT_POOL_DESC INCOME_DR_ACTV_POOL_DESC EQUITY_ACCOUNT_DESC ORGANIZATION_DESC FUND_POOL_DESC CHART_OF_ACCOUNTS_DESC BILL_CHART_OF_ACCOUNTS_DESC BILL_PROGRAM_DESC CONSTR_IN_PROGR_ACCOUNT_DESC FUND_PREDECESSOR_DESC WITHHOLDING_AR_ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC ACCOUNT_DESC ORGANIZATION_DESC FUND_DESC LOCATION_DESC GAIN_LOSS_DR_CHART_POOL_DESC GAIN_LOSS_DR_ORGN_POOL_DESC INCOME_CR_ORGANIZATION_DESC UNREAL_GAIN_LOSS_DR_ACTV_DESC VARIANCE_CR_ACCT_POOL_DESC VARIANCE_DR_ACCT_POOL_DESC CHART_OF_ACCOUNTS_DESC ORGANIZATION_DESC INCOME_CR_ACCOUNT_DESC INCOME_CR_CHART_DESC INCOME_CR_PROGRAM_DESC UNREAL_GAIN_LOSS_INDEX_DESC FUND_DESC PROGRAM_DESC ACTIVITY_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC BILL_ACTIVITY_DESC ACTIVITY_DESC ACCOUNT_DESC ACCOUNT_FUND_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC GAIN_LOSS_DR_ACCT_POOL_DESC GAIN_LOSS_DR_ACTV_POOL_DESC INCOME_CR_FUND_DESC INCOME_DR_ACCOUNT_INDEX_DESC UNREAL_GAIN_LOSS_DR_LOCN_DESC VARIANCE_DR_FUND_POOL_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ORGANIZATION_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC FUND_POOL_DESC BILL_ACCOUNT_INDEX_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC ORGANIZATION_DESC ORGANIZATION_DESC FUND_DESC PROGRAM_DESC GAIN_LOSS_ACCOUNT_INDEX_DESC INCOME_CR_ACCOUNT_POOL_DESC INCOME_CR_CHART_POOL_DESC UNREAL_GAIN_LOSS_DR_CHART_DESC VARIANCE_DR_LOCN_POOL_DESC VARIANCE_SPEND_DR_CHART_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC BILL_ALTERNATE_FUND_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ACTIVITY_DESC LOCATION_DESC ORGANIZATION_POOL_DESC ACTIVITY_DESC ACCOUNT_DESC ACCOUNT_DESC ACTIVITY_DESC LOCATION_DESC INCOME_CR_ACTIVITY_DESC INCOME_DR_FUND_POOL_DESC INCOME_DR_PROG_POOL_DESC UNREAL_GAIN_LOSS_CR_ACCT_DESC UNREAL_GAIN_LOSS_DR_FUND_DESC VARIANCE_DR_ORGN_POOL_DESC CHART_OF_ACCOUNTS_DESC ASSET_ACCOUNT_DESC LOCATION_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC LOCATION_DESC BILL_FUND_DESC FUND_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC ACTIVITY_DESC CHECK_DISTRIBUTION_CHART_DESC ACCOUNT_POOL_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ACTIVITY_DESC PROGRAM_DESC GAIN_LOSS_DR_LOCN_POOL_DESC INCOME_DR_ACCT_POOL_DESC INCOME_DR_ACTV_POOL_DESC EQUITY_ACCOUNT_DESC ORGANIZATION_DESC FUND_POOL_DESC CHART_OF_ACCOUNTS_DESC BILL_CHART_OF_ACCOUNTS_DESC BILL_PROGRAM_DESC CONSTR_IN_PROGR_ACCOUNT_DESC FUND_PREDECESSOR_DESC WITHHOLDING_AR_ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC ACCOUNT_DESC ORGANIZATION_DESC FUND_DESC LOCATION_DESC GAIN_LOSS_DR_CHART_POOL_DESC GAIN_LOSS_DR_ORGN_POOL_DESC INCOME_CR_ORGANIZATION_DESC UNREAL_GAIN_LOSS_DR_ACTV_DESC VARIANCE_CR_ACCT_POOL_DESC VARIANCE_DR_ACCT_POOL_DESC CHART_OF_ACCOUNTS_DESC ORGANIZATION_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC CHART_OF_ACCOUNTS_DESC RESPONSIBLE_ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC ORGANIZATION_POOL_DESC CHART_OF_ACCOUNTS_DESC RULE_CLASS_DESC TAX_RULE_CLASS_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC GAIN_LOSS_DR_PROG_POOL_DESC INCOME_DR_CHART_POOL_DESC INCOME_DR_LOCN_POOL_DESC INCOME_DR_ORGN_POOL_DESC UNREAL_GAIN_LOSS_DR_ORGN_DESC UNREAL_GAIN_LOSS_DR_PROG_DESC VARIANCE_DR_PROG_POOL_DESC ACCOUNT_DESC FUND_DESC EQUITY_ACCOUNT_DESC LOCATION_DESC LOCATION_DESC BILL_ACCOUNT_DESC BILL_LOCATION_DESC INCOME_CR_ACCOUNT_DESC INCOME_CR_CHART_DESC INCOME_CR_PROGRAM_DESC UNREAL_GAIN_LOSS_INDEX_DESC FUND_DESC PROGRAM_DESC ACTIVITY_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC BILL_ACTIVITY_DESC ACTIVITY_DESC ACCOUNT_DESC ACCOUNT_FUND_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC GAIN_LOSS_DR_ACCT_POOL_DESC GAIN_LOSS_DR_ACTV_POOL_DESC INCOME_CR_FUND_DESC INCOME_DR_ACCOUNT_INDEX_DESC UNREAL_GAIN_LOSS_DR_LOCN_DESC VARIANCE_DR_FUND_POOL_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ORGANIZATION_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC FUND_POOL_DESC BILL_ACCOUNT_INDEX_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC ORGANIZATION_DESC ORGANIZATION_DESC FUND_DESC PROGRAM_DESC GAIN_LOSS_ACCOUNT_INDEX_DESC INCOME_CR_ACCOUNT_POOL_DESC INCOME_CR_CHART_POOL_DESC UNREAL_GAIN_LOSS_DR_CHART_DESC VARIANCE_DR_LOCN_POOL_DESC VARIANCE_SPEND_DR_CHART_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC BILL_ALTERNATE_FUND_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ACTIVITY_DESC LOCATION_DESC ORGANIZATION_POOL_DESC ACTIVITY_DESC ACCOUNT_DESC ACCOUNT_DESC ACTIVITY_DESC LOCATION_DESC INCOME_CR_ACTIVITY_DESC INCOME_DR_FUND_POOL_DESC INCOME_DR_PROG_POOL_DESC UNREAL_GAIN_LOSS_CR_ACCT_DESC UNREAL_GAIN_LOSS_DR_FUND_DESC VARIANCE_DR_ORGN_POOL_DESC CHART_OF_ACCOUNTS_DESC ASSET_ACCOUNT_DESC LOCATION_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC LOCATION_DESC BILL_FUND_DESC FUND_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC ACTIVITY_DESC CHECK_DISTRIBUTION_CHART_DESC ACCOUNT_POOL_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC ACTIVITY_DESC PROGRAM_DESC GAIN_LOSS_DR_LOCN_POOL_DESC INCOME_DR_ACCT_POOL_DESC INCOME_DR_ACTV_POOL_DESC EQUITY_ACCOUNT_DESC ORGANIZATION_DESC FUND_POOL_DESC CHART_OF_ACCOUNTS_DESC BILL_CHART_OF_ACCOUNTS_DESC BILL_PROGRAM_DESC CONSTR_IN_PROGR_ACCOUNT_DESC FUND_PREDECESSOR_DESC WITHHOLDING_AR_ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC ACCOUNT_DESC ORGANIZATION_DESC FUND_DESC LOCATION_DESC GAIN_LOSS_DR_CHART_POOL_DESC GAIN_LOSS_DR_ORGN_POOL_DESC INCOME_CR_ORGANIZATION_DESC UNREAL_GAIN_LOSS_DR_ACTV_DESC VARIANCE_CR_ACCT_POOL_DESC VARIANCE_DR_ACCT_POOL_DESC CHART_OF_ACCOUNTS_DESC ORGANIZATION_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC CHART_OF_ACCOUNTS_DESC RESPONSIBLE_ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC ORGANIZATION_DESC CHART_OF_ACCOUNTS_DESC PROGRAM_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC ORGANIZATION_POOL_DESC CHART_OF_ACCOUNTS_DESC RULE_CLASS_DESC TAX_RULE_CLASS_DESC CHART_OF_ACCOUNTS_DESC FUND_DESC ACCOUNT_DESC CHART_OF_ACCOUNTS_DESC GAIN_LOSS_DR_PROG_POOL_DESC INCOME_DR_CHART_POOL_DESC INCOME_DR_LOCN_POOL_DESC INCOME_DR_ORGN_POOL_DESC UNREAL_GAIN_LOSS_DR_ORGN_DESC UNREAL_GAIN_LOSS_DR_PROG_DESC VARIANCE_DR_PROG_POOL_DESC ACCOUNT_DESC FUND_DESC EQUITY_ACCOUNT_DESC LOCATION_DESC LOCATION_DESC BILL_ACCOUNT_DESC BILL_LOCATION_DESC BILL_ORGANIZATION_DESC BILLED_AR_ACCOUNT_DESC SOURCE_FUND_DESC ACCOUNT_DESC ACTIVITY_DESC LOCATION_DESC PROGRAM_DESC CHART_OF_ACCOUNTS_DESC ORGANIZATION_DESC ADDITIONAL_AMT_RULE_CLASS_DESC DISCOUNT_RULE_CLASS_DESC LIQUIDATION_RULE_CLASS_DESC HOME_ORGANIZATION_DESC
|
This function will return the description of the passed validation or rule code up to the parameter value characters. Parameters include which_table, chart of accounts code, the code for the table specified, and how many characters the returned value should be. |
| F_GET_FINANCE_STATUS |
|
N
NG_COMP_target.html">AF_ENCUMBRANCE_ACCOUNTING AF_FIXED_ASSET_ADJUSTMENT AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_FIXED_ASSET_FUNDING_SOURCE AF_INVOICE_ACCOUNTING AF_OPERATING_LEDGER AF_OPERATING_LEDGER AF_ACCOUNT_INDEX AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_GENERAL_LEDGER AF_GRANT AF_GRANT_BILLING_DETAIL AF_GRANT_BILLING_DETAIL AF_INVOICE_ACCOUNTING AF_OPERATING_LEDGER AF_TRANSACTION_HISTORY AF_BUDGET_DETAIL AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_FIXED_ASSET_DEPRECIATION AF_GRANT_BILLING_DETAIL AF_GRANT_BILLING_DETAIL AF_INVOICE_ACCOUNTING AF_OPERATING_LEDGER AF_TRANSACTION_HISTORY AF_ACCOUNT_INDEX AF_FUND_HIERARCHY AF_GENERAL_LEDGER AF_GRANT_BILLING_DETAIL AF_INVOICE_ACCOUNTING AF_INVOICE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_FIXED_ASSET_ADJUSTMENT AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_FIXED_ASSET_FUNDING_SOURCE AF_INVOICE_ACCOUNTING AF_OPERATING_LEDGER AF_OPERATING_LEDGER AF_ACCOUNT_INDEX AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_GENERAL_LEDGER AF_GRANT AF_GRANT_BILLING_DETAIL AF_GRANT_BILLING_DETAIL AF_INVOICE_ACCOUNTING AF_OPERATING_LEDGER AF_TRANSACTION_HISTORY AF_BUDGET_DETAIL AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING AF_FIXED_ASSET_DEPRECIATION AF_GRANT_BILLING_DETAIL AF_GRANT_BILLING_DETAIL AF_INVOICE_ACCOUNTING AF_OPERATING_LEDGER AF_TRANSACTION_HISTORY AF_ACCOUNT_INDEX AF_FUND_HIERARCHY AF_GENERAL_LEDGER AF_GRANT_BILLING_DETAIL AF_INVOICE_ACCOUNTING AF_INVOICE_ACCOUNTING AF_TRANSACTION_HISTORY
|
S
S PROGRAM_STATUS ORGANIZATION_STATUS ACCOUNT_STATUS ORGANIZATION_STATUS EQUITY_ACCOUNT_STATUS ASSET_ACCOUNT_STATUS EQUITY_ACCOUNT_STATUS LOCATION_STATUS ACCOUNT_STATUS FUND_STATUS ACCOUNT_STATUS LOCATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS FUND_STATUS FUND_STATUS ORGANIZATION_STATUS CHART_OF_ACCOUNTS_STATUS RESPONSIBLE_ORGN_STATUS BILL_ALTERNATE_FUND_STATUS BILL_LOCATION_STATUS ACTIVITY_STATUS ACTIVITY_STATUS ACTIVITY_STATUS CHART_OF_ACCOUNTS_STATUS LOCATION_STATUS PROGRAM_STATUS PROGRAM_STATUS BILL_ACTIVITY_STATUS BILL_FUND_STATUS CHART_OF_ACCOUNTS_STATUS FUND_STATUS PROGRAM_STATUS ORGANIZATION_STATUS ACCOUNT_STATUS ORGANIZATION_STATUS EQUITY_ACCOUNT_STATUS ASSET_ACCOUNT_STATUS EQUITY_ACCOUNT_STATUS LOCATION_STATUS ACCOUNT_STATUS FUND_STATUS ACCOUNT_STATUS LOCATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS ORGANIZATION_STATUS FUND_STATUS FUND_STATUS ORGANIZATION_STATUS CHART_OF_ACCOUNTS_STATUS RESPONSIBLE_ORGN_STATUS BILL_ALTERNATE_FUND_STATUS BILL_LOCATION_STATUS ACTIVITY_STATUS ACTIVITY_STATUS ACTIVITY_STATUS CHART_OF_ACCOUNTS_STATUS LOCATION_STATUS PROGRAM_STATUS PROGRAM_STATUS BILL_ACTIVITY_STATUS BILL_FUND_STATUS CHART_OF_ACCOUNTS_STATUS FUND_STATUS CHART_OF_ACCOUNTS_POOL_STATUS ACTIVITY_STATUS CHART_OF_ACCOUNTS_STATUS ACCOUNT_STATUS BILL_ORGANIZATION_STATUS FUND_STATUS ORGANIZATION_STATUS FUND_POOL_STATUS
|
This function will return the status indicator of the specified validation or rule code for the length specified. |
| F_GET_FISCAL_PERIOD |
|
AF_GRANT |
STATUS_FISCAL_PERIOD |
This function retrieves the fiscal period based on fiscal year and chart of accounts passed. |
| F_GET_NORM_BALANCE |
|
|
|
|
| F_GET_SPONSOR_ACCT |
|
AF_GRANT_LEDGER |
SPONSOR_ACCOUNT_DESC |
This function retrieves the sponsor account for either a grant or a proposal based on either the code indicator passed ('GRNT' or 'PROP'), code passed (grant or prop code), chart of account and account code or code indicator, code, chart of accounts and account type passed. |
| F_GET_STATUS_DATE |
|
AF_PROPOSAL AF_PROPOSAL AF_PROPOSAL AF_PROPOSAL |
DECLINE_DATE SUBMISSION_DATE ORIGINATION_DATE AWARD_DATE |
This function retrieves the date for a particular status based on status code, proposal code and chart of accounts. |
| F_GET_STATUS_INFO |
|
AF_PROPOSAL AF_PROPOSAL AF_PROPOSAL AF_PROPOSAL |
ORIGINATION_FISCAL_PERIOD DECLINE_FISCAL_PERIOD SUBMISSION_FISCAL_PERIOD AWARD_FISCAL_PERIOD |
This function retrieves the fiscal year or fiscal period based on a particalar status, proposal and chart of accounts. |
| F_GET_SUM_TOTAL_CREDITS_BY_AEP |
|
|
|
|
| F_GET_TENURE |
|
|
|
|
| F_HOUS_THIS_TERM |
|
AS_ENROLLMENT AS_ENROLLMENT_HISTORY |
HOUSING_IND HOUSING_IND |
This function retrieves a 'Y' or 'N' depending on whether or not the person and academic period being passed has a record in the room assignment table. |
| F_INQUIRER_FNC |
|
AS_CURRICULUM_FOS |
INQUIRER_IND |
This function retrieves a 'Y' or 'N' depending on whether or not the person academic period and level being passed has a record in the recruitment table. |
| F_INST_AID_FNC |
|
AR_AWARD_BY_PERSON |
INSTITUTION_AID_IND |
This function retrieves a 'Y' or 'N' based on the sum of the acceptance amount for a person and aid year where the fund source code has a value of 'INST'. The sum of the acceptance amount must be greater than 0 to return a 'Y'. |
| F_LEVEL_ADMITTED_FNC |
|
AS_CURRICULUM_FOS |
ADMIT_IND |
This function retrieves a 'Y' or 'N' based on a person, academic period and level code having a record in the admissions application table. |
| F_LEVEL_APPL_FNC |
|
AS_CURRICULUM_FOS |
APPLICANT_IND |
This function retrieves a 'Y' or 'N' based on a person, academic period and level code having a record in the admissions application table. |
| F_LIFE_TOTAL_COMMITMENT |
|
AA_CONSTITUENT AA_ORGANIZATIONAL_CONSTITUENT |
LIFE_TOTAL_COMMITMENT LIFE_TOTAL_COMMITMENT |
This function retrieves the sum of the giving history pledged amount and gift amount based on the person passed. |
| F_LIFE_TOTAL_GIVING |
|
AA_CONSTITUENT AA_ORGANIZATIONAL_CONSTITUENT |
LIFE_TOTAL_GIVING LIFE_TOTAL_GIVING |
This function retrieves the sum of the giving history pledged amount paid and gift amount and substracts the total of AGRGMMO_3PP_TOT_AMT based on the person passed. |
| F_LIFE_TOTAL_PLEDGED_AMOUNT |
|
AA_CONSTITUENT AA_ORGANIZATIONAL_CONSTITUENT |
LIFE_TOTAL_PLEDGE_AMT LIFE_TOTAL_PLEDGE_AMT |
This function retrieves the sum of the giving history pledged amount based on the person passed. |
| F_LIFE_TOTAL_PLEDGE_PAYMENT |
|
AA_CONSTITUENT AA_ORGANIZATIONAL_CONSTITUENT |
LIFE_TOTAL_PLEDGE_PAY LIFE_TOTAL_PLEDGE_PAY |
This function retrieves the sum of the giving history pledged amount paid based on the person passed. |
| F_LOST_AL_IND |
|
AA_CONSTITUENT |
LOST_ALUMNUS_IND |
This function retrieves a 'N' if the person passed has a record in the address table and the address end date is greater than or equal to the current date and the address status is active or null OR the address start date is null abd the address status is active or is null. |
| F_MATCHING_GIFT |
|
AA_GIFT |
MATCHING_GIFT |
This function returns a P if the matching gift status indicator AGBMGID_STATUS_IND is P, it returns a W if the matching gift status indicator is W else N for a specified gift number. |
| F_MEMO_DETAIL_MATCHING_GIFT |
|
AA_GIFT_MEMO AA_GIFT_MULTIPLE |
MEMO_MATCH_GIFT_IND MULTIPLE_MATCH_GIFT_IND |
This function returns a Y if the memo detail matching gift AGRMGIF exists for a specified gift number else N. |
| F_MORE_SPECIFIC_REQUIREMENTS |
|
AR_FINAID_TRACKING_REQUIREMENT |
MORE_SPECIFIC_REQ_IND |
This function returns a Y if there exists the special requirements RRRAREQ for a specified UID, aid year, tracking requirement and sat indicator else it returns a N. |
| F_MOST_RECENT_GIFT_AMOUNT |
|
|
|
This function returns the most recent gift record - gift amount AGBGIFT_AMT_TOT or gift date AGBGIFT_GIFT_DATE for a specified UID. |
| F_MOST_RECENT_PLEDGE_AMOUNT |
|
|
|
This function returns the most recent pledge record - pledge amount AGBPLDG_AMT_PLEDGED or pledge date AGBPLDG_PLEDGE_DATE for a specified UID. |
| F_MULTIPLE_RATIOS |
|
AA_ORGANIZATIONAL_CONSTITUENT |
MULTIPLE_RATIOS_IND |
This function return a Y if this organization has multiple ratios AORMRTO else a N for a specified UID. |
| F_PAID_ADMISSIONS_DEPOSIT |
|
AS_CURRICULUM_FOS |
DEPOSIT_IND |
This function returns a Y if there exists a paid admissions deposit based on the SARAPPD_APDC_CODEs as defined in GTVSDAX where GTVSDAX_INTERNAL_CODE = 'DEPOPAID' AND GTVSDAX_INTERNAL_CODE_GROUP = 'DEPOSIT' else N for a specified UID and academic period. |
| F_PROFILE_DATE |
|
AP_EMPLOYEE AP_TAX |
PROFILE_DATE PROFILE_DATE |
This function checks for reporting date in gtvsdax table if not found then it returns the sysdate. |
| F_PROSPECT_FNC |
|
AS_CURRICULUM_FOS |
PROSPECT_IND |
This function always returns a N. |
| F_PROSPECT_IND |
|
AA_CONSTITUENT AA_ORGANIZATIONAL_CONSTITUENT |
PROSPECT_IND PROSPECT_IND |
This function returns a Y where the prospect record AMRINFO exists for a specified UID. |
| F_QUATERLY_DEDUCTION_TOTAL |
|
|
|
This function calculates quarterly deduction total SUM(PERDTOT_EMPL_AMT) for a particular year for a specified UID. |
| F_RBRMIXD_DATA |
|
AR_FINAID_BUDGET_COMPONENT |
MIXED_BUDGET_IND |
This function returns a Y if the RBRMIXD record exists else it returns a N for a specified UID, aid year and budget group. |
| F_REGISTERED_THIS_TERM |
|
AS_ENROLLMENT |
REGISTERED_IND |
This function checks to see if the student is registered this term STVRSTS_INCL_SECT_ENRL = Y for a specified UID and academic period. |
| F_SUM_BALANCE_TERM |
|
|
|
This function calculates the balance SUM(TBRACCD_BALANCE) for a given term, category code and detail code. |
| F_TOTAL_HOUR_EARNING_CODE |
|
|
|
This function calculates total hours or earning PERJTOT_EARN_CODE for an employee for a specified year and earn code as defined in GTVSDAX where GTVSDAX_INTERNAL_CODE = 'PAYREARN' AND GTVSDAX_INTERNAL_CODE_GROUP = 'EARNING' |
| F_UNSATISFIED_PROM_NOTE |
|
AR_FINAID_TRACKING_REQUIREMENT |
UNSATISFIED_PROM_NOTE_IND |
This function return a Y if the RFRPROM record exists for a specified UID and aid year where the RFRPROM_SAT_IND = N else N. |
| F_YEAR |
|
AP_BENEFIT_DEDUCTION AP_TAX |
PROFILE_DATE TAX_DEDUCTION_YEAR |
This function retrieves the Banner/concept code from gtvsdax table based on internal_code and internal_code_group. |
| F_YEARLY_DEDUCTION_TOTAL |
|
AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION |
EMPLOYER_CONTRIBUTION_YTD GROSS_COMPENSATION_YTD EMPLOYEE_CONTRIBUTION_YTD |
This function will calculate yearly deduction total PERDTOT based on the UID. |
| GOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC |
|
AN_PAYROLL_DISTRIBUTION |
ACTIVITY_DESC |
|
| GOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS |
|
AN_PAYROLL_DISTRIBUTION |
ACTIVITY_STATUS |
|
| GOKODSF.F_DIRECT_DEPOSIT_IND |
|
AE_PROFILE |
DIRECT_DEPOSIT_IND |
|
| GOKODSF.F_FORMAT_MAILING_ADDRESS |
|
|
|
This function returns the formatted address with concatenated fields seperated by carriage returns SPRADDR for a specified UID, address type, sequence number, status indicator and the type of format, US or Other. |
| GOKODSF.F_FORMAT_NAME |
|
|
|
This function returns an entity's name based upon a specified pidm and name type. The possible name types are as follows: (LF30) Last name, first name for 30 characters; (L30) Last name for 30 characters; (FL30) First name, last name for 30 characters; (FL) Last name, first name; (FMIL) First name, middle initial, last name; (FML) First name, middle name, last name; (LFMI) Last name, first name, middle initial. |
| GOKODSF.F_FORMAT_PREFERRED_NAME |
|
|
|
This function retrieves a name based upon a specified person and format. The format can be 'FORMAL', 'INFORMAL', or 'PREFERRED'. |
| GOKODSF.F_GET_DESC |
|
c
ce="Arial" size="2">AS_COURSE_OFFERING AS_COURSE_PREREQ AS_COURSE_SCHEDULE AS_COURSE_SCHEDULE AS_ENROLLMENT_HISTORY AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_FEEDBACK AS_FIELD_OF_STUDY AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_OUTCOME_HONOR_INST AS_RECRUITMENT_COHORT AS_SPORT AS_STUDENT_ATTRIBUTE AS_STUDENT_COURSE_ATTR_TRANS AS_STUDENT_COURSE_ATTR_TRANS AT_LEDGER_ACCOUNTING AG_GEOGRAPHIC_REGION_INST AS_INTEREST AS_PREVIOUS_EDUCATION_PCOL AS_SECONDARY_SCHOOL_SUBJECT AS_TELEPHONE AS_VISA AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_FUNDING_INTEREST AA_FUNDING_INTEREST AA_GIFT_SOCIETY AA_PROJECT_INTEREST AA_PROSPECT_INFO AA_PROSPECT_INFO AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL AF_INVOICE AF_INVOICE <
ce="Arial" size="2">AS_COURSE_OFFERING AS_COURSE_PREREQ AS_COURSE_SCHEDULE AS_COURSE_SCHEDULE AS_ENROLLMENT_HISTORY AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_FEEDBACK AS_FIELD_OF_STUDY AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_OUTCOME_HONOR_INST AS_RECRUITMENT_COHORT AS_SPORT AS_STUDENT_ATTRIBUTE AS_STUDENT_COURSE_ATTR_TRANS AS_STUDENT_COURSE_ATTR_TRANS AT_LEDGER_ACCOUNTING AG_GEOGRAPHIC_REGION_INST AS_INTEREST AS_PREVIOUS_EDUCATION_PCOL AS_SECONDARY_SCHOOL_SUBJECT AS_TELEPHONE AS_VISA AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_FUNDING_INTEREST AA_FUNDING_INTEREST AA_GIFT_SOCIETY AA_PROJECT_INTEREST AA_PROSPECT_INFO AA_PROSPECT_INFO AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL AF_INVOICE AF_INVOICE AF_ORGANIZATION_HIERARCHY AN_EMPLOYEE_POSITION AN_PAYROLL_DISTRIBUTION AP_EMPLOYEE_EARNING_FY AP_HR_APPLICATION_STATUS AP_HR_APPLICATION_STATUS AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_LABOR_DIST_OVERRIDE AP_TAX AR_FINAID_ENROLLMENT AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_STUDENT_PERIOD_DEFINITION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_DECISION AS_ADMISSIONS_SOURCE AS_COURSE_COREQ AS_COURSE_SCHEDULE AS_COURSE_SUPPLEMENTAL AS_FACULTY AS_GPA_TERM AS_INSTRUCTIONAL_ASSIGNMENT AS_OFFERING_PREREQ AS_RECRUITMENT_SOURCE AT_LEDGER_ACCOUNTING AA_MAIL AG_COMMUNICATION AP_PAST_EMPLOYMENT AP_SKILL AS_ADDRESS AS_DISABILITY_INFORMATION AS_HOLD AS_MEDICAL_INFORMATION AS_YEAR_TYPE_DEFINITION AA_DESIGNATION AS_COURSE_OFFERING AS_COURSE_PREREQ AS_COURSE_SCHEDULE AS_COURSE_SCHEDULE AS_ENROLLMENT_HISTORY AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_FEEDBACK AS_FIELD_OF_STUDY AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_OUTCOME_HONOR_INST AS_RECRUITMENT_COHORT AS_SPORT AS_STUDENT_ATTRIBUTE AS_STUDENT_COURSE_ATTR_TRANS AS_STUDENT_COURSE_ATTR_TRANS AT_LEDGER_ACCOUNTING AG_GEOGRAPHIC_REGION_INST AS_INTEREST AS_PREVIOUS_EDUCATION_PCOL AS_SECONDARY_SCHOOL_SUBJECT AS_TELEPHONE AS_VISA AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_FUNDING_INTEREST AA_FUNDING_INTEREST AA_GIFT_SOCIETY AA_PROJECT_INTEREST AA_PROSPECT_INFO AA_PROSPECT_INFO AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL AF_INVOICE AF_INVOICE AF_ORGANIZATION_HIERARCHY AN_EMPLOYEE_POSITION AN_PAYROLL_DISTRIBUTION AP_EMPLOYEE_EARNING_FY AP_HR_APPLICATION_STATUS AP_HR_APPLICATION_STATUS AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_LABOR_DIST_OVERRIDE AP_TAX AR_FINAID_ENROLLMENT AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_STUDENT_PERIOD_DEFINITION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_DECISION AS_ADMISSIONS_SOURCE AS_COURSE_COREQ AS_COURSE_SCHEDULE AS_COURSE_SUPPLEMENTAL AS_FACULTY AS_GPA_TERM AS_INSTRUCTIONAL_ASSIGNMENT AS_OFFERING_PREREQ AS_RECRUITMENT_SOURCE AT_LEDGER_ACCOUNTING AA_MAIL AG_COMMUNICATION AP_PAST_EMPLOYMENT AP_SKILL AS_ADDRESS AS_DISABILITY_INFORMATION AS_HOLD AS_MEDICAL_INFORMATION AS_YEAR_TYPE_DEFINITION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_GIFT AA_MEMBERSHIP_INTEREST AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ASSIGNMENT AF_GRANT_FUND AF_GRANT_FUND AF_GRANT_FUND AF_INVOICE_ITEM AN_PAYROLL_DISTRIBUTION AN_PERSONNEL_ACTION_LABOR_DIST AP_BENEFICIARY_DEPENDENT AP_BENEFIT_DEDUCTION AP_EMPLOYEE_EARNING_CY AP_MONTHLY_DEDUCTION AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_TIMESHEET AR_FINAID_ENROLLMENT AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AS_ADMINISTRATOR AS_ADMINISTRATOR AS_ADMISSIONS_ATTRIBUTE AS_ADMISSIONS_DECISION AS_ADVISOR AS_COURSE_LEVEL AS_COURSE_PREREQ AS_COURSE_SUPPLEMENTAL AS_COURSE_SUPPLEMENTAL AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AS_FACULTY AS_FACULTY_CONTRACT AS_FACULTY_DEPARTMENT_COLLEGE AS_GPA_LEVEL AS_COURSE_OFFERING AS_COURSE_PREREQ AS_COURSE_SCHEDULE AS_COURSE_SCHEDULE AS_ENROLLMENT_HISTORY AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_FEEDBACK AS_FIELD_OF_STUDY AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_OUTCOME_HONOR_INST AS_RECRUITMENT_COHORT AS_SPORT AS_STUDENT_ATTRIBUTE AS_STUDENT_COURSE_ATTR_TRANS AS_STUDENT_COURSE_ATTR_TRANS AT_LEDGER_ACCOUNTING AG_GEOGRAPHIC_REGION_INST AS_INTEREST AS_PREVIOUS_EDUCATION_PCOL AS_SECONDARY_SCHOOL_SUBJECT AS_TELEPHONE AS_VISA AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_FUNDING_INTEREST AA_FUNDING_INTEREST AA_GIFT_SOCIETY AA_PROJECT_INTEREST AA_PROSPECT_INFO AA_PROSPECT_INFO AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL AF_INVOICE AF_INVOICE AF_ORGANIZATION_HIERARCHY AN_EMPLOYEE_POSITION AN_PAYROLL_DISTRIBUTION AP_EMPLOYEE_EARNING_FY AP_HR_APPLICATION_STATUS AP_HR_APPLICATION_STATUS AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_LABOR_DIST_OVERRIDE AP_TAX AR_FINAID_ENROLLMENT AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_STUDENT_PERIOD_DEFINITION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_DECISION AS_ADMISSIONS_SOURCE AS_COURSE_COREQ AS_COURSE_SCHEDULE AS_COURSE_SUPPLEMENTAL AS_FACULTY AS_GPA_TERM AS_INSTRUCTIONAL_ASSIGNMENT AS_OFFERING_PREREQ AS_RECRUITMENT_SOURCE AT_LEDGER_ACCOUNTING AA_MAIL AG_COMMUNICATION AP_PAST_EMPLOYMENT AP_SKILL AS_ADDRESS AS_DISABILITY_INFORMATION AS_HOLD AS_MEDICAL_INFORMATION AS_YEAR_TYPE_DEFINITION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_GIFT AA_MEMBERSHIP_INTEREST AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ASSIGNMENT AF_GRANT_FUND AF_GRANT_FUND AF_GRANT_FUND AF_INVOICE_ITEM AN_PAYROLL_DISTRIBUTION AN_PERSONNEL_ACTION_LABOR_DIST AP_BENEFICIARY_DEPENDENT AP_BENEFIT_DEDUCTION AP_EMPLOYEE_EARNING_CY AP_MONTHLY_DEDUCTION AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_TIMESHEET AR_FINAID_ENROLLMENT AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AS_ADMINISTRATOR AS_ADMINISTRATOR AS_ADMISSIONS_ATTRIBUTE AS_ADMISSIONS_DECISION AS_ADVISOR AS_COURSE_LEVEL AS_COURSE_PREREQ AS_COURSE_SUPPLEMENTAL AS_COURSE_SUPPLEMENTAL AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AS_FACULTY AS_FACULTY_CONTRACT AS_FACULTY_DEPARTMENT_COLLEGE AS_GPA_LEVEL AS_NONINSTRUCTIONAL_ASSIGNMENT AS_NONINSTRUCTIONAL_ASSIGNMENT AS_NONINSTRUCTIONAL_ASSIGNMENT AS_OFFERING_COREQ AS_OFFERING_COREQ AS_OUTCOME_HONOR_DEPT AS_RECRUITMENT_COHORT AS_RECRUITMENT_COHORT AS_SPORT AS_SPORT AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_REG_AUDIT AS_VETERAN_CERTIFICATION AT_GRANT_ACCOUNT_DETAIL AT_LEDGER_ACCOUNTING AT_LEDGER_ACCOUNTING AT_LEDGER_ACCOUNTING AR_YEAR_TYPE_DEFINITION AS_CONTACT AS_DISABILITY_INFORMATION AS_DISABILITY_INFORMATION AS_INSTITUTION AS_MEDICAL_INFORMATION AS_MEDICAL_INFORMATION AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_HSCH AS_PREVIOUS_EDUCATION_HSCH AS_VISA AS_YEAR_TYPE_DEFINITION AA_GIFT_ASSOCIATED_ENTITY AA_GIFT_MEMO AA_MEMBERSHIP AA_PLEDGE_INSTALLMENT AA_PROJECT_INTEREST AA_PROSPECT_INFO AA_PROSPECT_PROPOSAL AA_SOLICITOR_ASSIGNMENT AS_COURSE_OFFERING AS_COURSE_PREREQ AS_COURSE_SCHEDULE AS_COURSE_SCHEDULE AS_ENROLLMENT_HISTORY AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_FEEDBACK AS_FIELD_OF_STUDY AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_OUTCOME_HONOR_INST AS_RECRUITMENT_COHORT AS_SPORT AS_STUDENT_ATTRIBUTE AS_STUDENT_COURSE_ATTR_TRANS AS_STUDENT_COURSE_ATTR_TRANS AT_LEDGER_ACCOUNTING AG_GEOGRAPHIC_REGION_INST AS_INTEREST AS_PREVIOUS_EDUCATION_PCOL AS_SECONDARY_SCHOOL_SUBJECT AS_TELEPHONE AS_VISA AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_FUNDING_INTEREST AA_FUNDING_INTEREST AA_GIFT_SOCIETY AA_PROJECT_INTEREST AA_PROSPECT_INFO AA_PROSPECT_INFO AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL AF_INVOICE AF_INVOICE AF_ORGANIZATION_HIERARCHY AN_EMPLOYEE_POSITION AN_PAYROLL_DISTRIBUTION AP_EMPLOYEE_EARNING_FY AP_HR_APPLICATION_STATUS AP_HR_APPLICATION_STATUS AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_LABOR_DIST_OVERRIDE AP_TAX AR_FINAID_ENROLLMENT AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AR_STUDENT_PERIOD_DEFINITION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_DECISION AS_ADMISSIONS_SOURCE AS_COURSE_COREQ AS_COURSE_SCHEDULE AS_COURSE_SUPPLEMENTAL AS_FACULTY AS_GPA_TERM AS_INSTRUCTIONAL_ASSIGNMENT AS_OFFERING_PREREQ AS_RECRUITMENT_SOURCE AT_LEDGER_ACCOUNTING AA_MAIL AG_COMMUNICATION AP_PAST_EMPLOYMENT AP_SKILL AS_ADDRESS AS_DISABILITY_INFORMATION AS_HOLD AS_MEDICAL_INFORMATION AS_YEAR_TYPE_DEFINITION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_GIFT AA_MEMBERSHIP_INTEREST AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ASSIGNMENT AF_GRANT_FUND AF_GRANT_FUND AF_GRANT_FUND AF_INVOICE_ITEM AN_PAYROLL_DISTRIBUTION AN_PERSONNEL_ACTION_LABOR_DIST AP_BENEFICIARY_DEPENDENT AP_BENEFIT_DEDUCTION AP_EMPLOYEE_EARNING_CY AP_MONTHLY_DEDUCTION AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_TIMESHEET AR_FINAID_ENROLLMENT AR_LOAN_AGGREGATES AR_LOAN_AGGREGATES AS_ADMINISTRATOR AS_ADMINISTRATOR AS_ADMISSIONS_ATTRIBUTE AS_ADMISSIONS_DECISION AS_ADVISOR AS_COURSE_LEVEL AS_COURSE_PREREQ AS_COURSE_SUPPLEMENTAL AS_COURSE_SUPPLEMENTAL AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AS_FACULTY AS_FACULTY_CONTRACT AS_FACULTY_DEPARTMENT_COLLEGE AS_GPA_LEVEL AS_NONINSTRUCTIONAL_ASSIGNMENT AS_NONINSTRUCTIONAL_ASSIGNMENT AS_NONINSTRUCTIONAL_ASSIGNMENT AS_OFFERING_COREQ AS_OFFERING_COREQ AS_OUTCOME_HONOR_DEPT AS_RECRUITMENT_COHORT AS_RECRUITMENT_COHORT AS_SPORT AS_SPORT AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_REG_AUDIT AS_VETERAN_CERTIFICATION AT_GRANT_ACCOUNT_DETAIL AT_LEDGER_ACCOUNTING AT_LEDGER_ACCOUNTING AT_LEDGER_ACCOUNTING AR_YEAR_TYPE_DEFINITION AS_CONTACT AS_DISABILITY_INFORMATION AS_DISABILITY_INFORMATION AS_INSTITUTION AS_MEDICAL_INFORMATION AS_MEDICAL_INFORMATION AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_HSCH AS_PREVIOUS_EDUCATION_HSCH AS_VISA AS_YEAR_TYPE_DEFINITION AA_GIFT_ASSOCIATED_ENTITY AA_GIFT_MEMO AA_MEMBERSHIP AA_PLEDGE_INSTALLMENT AA_PROJECT_INTEREST AA_PROSPECT_INFO AA_PROSPECT_PROPOSAL AA_SOLICITOR_ASSIGNMENT AA_SOLICITOR_ORGANIZATION AF_INVOICE AF_PURCHASE_ORDER_ITEM AN_EMPLOYEE_POSITION AN_PAYROLL_DISTRIBUTION AP_PAYROLL_ATTENDANCE AR_AWARD_BY_AID_YEAR (More Targets -- list too long to display currently.) AA_CONSTITUENT_CONTACT (More Targets -- list too long to display currently.) AA_CONSTITUENT_CONTACT (More Targets -- list too long to display currently.)
|
T
TING_COMP_target.html#ACADEMIC_PERIOD_DESC">ACADEMIC_PERIOD_DESC ACADEMIC_YEAR_DESC REQUIREMENT_DESC ACADEMIC_PERIOD_END_DESC SUBJECT_DESC TAXONOMY_OF_PROGRAM_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC SUBJECT_DESC VETERAN_TYPE_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR CURRENT_TIME_STATUS_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC OUTCOME_DESC ACADEMIC_YEAR_DESC ACTIVITY_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC A_RULE_CLASS_DESC1 GEOGRAPHIC_DIVISION_DESC INTEREST_DESC AWARD_CATEGORY_DESC SUBJECT_DESC PHONE_ADDRESS_TYPE_DESC VISA_ISSUING_NATION_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_CHART_OF_ACCOUNTS_DESC EXPEND_FUND_DESC GIFT_FUND_DESC GIFT_LOCATION_DESC
TING_COMP_target.html#ACADEMIC_PERIOD_DESC">ACADEMIC_PERIOD_DESC ACADEMIC_YEAR_DESC REQUIREMENT_DESC ACADEMIC_PERIOD_END_DESC SUBJECT_DESC TAXONOMY_OF_PROGRAM_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC SUBJECT_DESC VETERAN_TYPE_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR CURRENT_TIME_STATUS_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC OUTCOME_DESC ACADEMIC_YEAR_DESC ACTIVITY_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC A_RULE_CLASS_DESC1 GEOGRAPHIC_DIVISION_DESC INTEREST_DESC AWARD_CATEGORY_DESC SUBJECT_DESC PHONE_ADDRESS_TYPE_DESC VISA_ISSUING_NATION_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_CHART_OF_ACCOUNTS_DESC EXPEND_FUND_DESC GIFT_FUND_DESC GIFT_LOCATION_DESC PAYMENT_PROGRAM_DESC GIVING_VEHICLE_DESC PROJECT_STATUS_DESC GIFT_SOCIETY_END_YEAR_DESC GIVING_VEHICLE_DESC PREF_GEO_REGION_ADDR_TYPE_DESC PRIMARY_STAFF_ASSIGN_IDEN_DESC PROPOSAL_PROJECT_DESC PROPOSAL_STATUS_DESC REMIT_TO_ADDRESS_TYPE_DESC REMIT_TO_STATE_PROVINCE_DESC FMGR_ADDRESS_TYPE_DESC LEAVE_REPORT_ENTRY_METHOD_DESC COST_TYPE_DESC EMPLOYER_DESC POSITION_CLASS_DESC STATUS_DESC COST_TYPE_SHORT_DESC TIMESHEET_CHART_DESC TAX_DEDUCTION_LONG_DESC AID_YEAR_DESC ACG_OVERPAYMENT_DESC LOAN_REPAYMENT_CHANGE_DESC PERKINS_OVERPAYMENT_DESC SMART_PAYMENT_CHANGE_DESC SUBSIDIZED_LOAN_LIMIT_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC RESIDENCY_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR ACADEMIC_PERIOD_END_DESC SCHEDULE_DESCACADEMIC_PERIOD_DESC ACADEMIC_YEAR_DESC REQUIREMENT_DESC ACADEMIC_PERIOD_END_DESC SUBJECT_DESC TAXONOMY_OF_PROGRAM_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC SUBJECT_DESC VETERAN_TYPE_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR CURRENT_TIME_STATUS_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC OUTCOME_DESC ACADEMIC_YEAR_DESC ACTIVITY_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC A_RULE_CLASS_DESC1 GEOGRAPHIC_DIVISION_DESC INTEREST_DESC AWARD_CATEGORY_DESC SUBJECT_DESC PHONE_ADDRESS_TYPE_DESC VISA_ISSUING_NATION_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_CHART_OF_ACCOUNTS_DESC EXPEND_FUND_DESC GIFT_FUND_DESC GIFT_LOCATION_DESC PAYMENT_PROGRAM_DESC GIVING_VEHICLE_DESC PROJECT_STATUS_DESC GIFT_SOCIETY_END_YEAR_DESC GIVING_VEHICLE_DESC PREF_GEO_REGION_ADDR_TYPE_DESC PRIMARY_STAFF_ASSIGN_IDEN_DESC PROPOSAL_PROJECT_DESC PROPOSAL_STATUS_DESC REMIT_TO_ADDRESS_TYPE_DESC REMIT_TO_STATE_PROVINCE_DESC FMGR_ADDRESS_TYPE_DESC LEAVE_REPORT_ENTRY_METHOD_DESC COST_TYPE_DESC EMPLOYER_DESC POSITION_CLASS_DESC STATUS_DESC COST_TYPE_SHORT_DESC TIMESHEET_CHART_DESC TAX_DEDUCTION_LONG_DESC AID_YEAR_DESC ACG_OVERPAYMENT_DESC LOAN_REPAYMENT_CHANGE_DESC PERKINS_OVERPAYMENT_DESC SMART_PAYMENT_CHANGE_DESC SUBSIDIZED_LOAN_LIMIT_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC RESIDENCY_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR ACADEMIC_PERIOD_END_DESC SCHEDULE_DESC ACADEMIC_PERIOD_END_DESC CONTRACT_RULE_DESC ACADEMIC_STUDY_VALUE_DESC ACADEMIC_YEAR_DESC LEVEL_DESC ACADEMIC_YEAR_DESC B_CHART_OF_ACCOUNTS_DESC MAIL_DESC AID_YEAR_DESC NATION_DESC SKILL_DESC ENRL_PLANNING_SERVICE_DESC MEDICAL_TYPE_DESC HOLD_ORIGINATING_OFFICE_DESC MEDICAL_EQUIPMENT_TYPE_DESC ACADEMIC_PERIOD_DESC EXPEND_ACCOUNT_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ACTIVITY_DESC PLEDGE_PROGRAM_DESC GIFT_RULE_CLASS_DESC INTEREST_COLLEGE_DESC START_DATE_FISCAL_YEAR_DESC SOLICITATION_TYPE_DESC FUND_COST_SHARE_BASE_DESC FUND_COST_SHARE_DISTRIB_DESC FUND_INDIRECT_COST_BASE_DESC COMMODITY_DESC SOURCE_DESC CHART_OF_ACCOUNTS_DESC CARRIER_SHORT_DESC ACADEMIC_PERIOD_DESC ACADEMIC_YEAR_DESC REQUIREMENT_DESC ACADEMIC_PERIOD_END_DESC SUBJECT_DESC TAXONOMY_OF_PROGRAM_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC SUBJECT_DESC VETERAN_TYPE_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR CURRENT_TIME_STATUS_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC OUTCOME_DESC ACADEMIC_YEAR_DESC ACTIVITY_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC A_RULE_CLASS_DESC1 GEOGRAPHIC_DIVISION_DESC INTEREST_DESC AWARD_CATEGORY_DESC SUBJECT_DESC PHONE_ADDRESS_TYPE_DESC VISA_ISSUING_NATION_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_CHART_OF_ACCOUNTS_DESC EXPEND_FUND_DESC GIFT_FUND_DESC GIFT_LOCATION_DESC PAYMENT_PROGRAM_DESC GIVING_VEHICLE_DESC PROJECT_STATUS_DESC GIFT_SOCIETY_END_YEAR_DESC GIVING_VEHICLE_DESC PREF_GEO_REGION_ADDR_TYPE_DESC PRIMARY_STAFF_ASSIGN_IDEN_DESC PROPOSAL_PROJECT_DESC PROPOSAL_STATUS_DESC REMIT_TO_ADDRESS_TYPE_DESC REMIT_TO_STATE_PROVINCE_DESC FMGR_ADDRESS_TYPE_DESC LEAVE_REPORT_ENTRY_METHOD_DESC COST_TYPE_DESC EMPLOYER_DESC POSITION_CLASS_DESC STATUS_DESC COST_TYPE_SHORT_DESC TIMESHEET_CHART_DESC TAX_DEDUCTION_LONG_DESC AID_YEAR_DESC ACG_OVERPAYMENT_DESC LOAN_REPAYMENT_CHANGE_DESC PERKINS_OVERPAYMENT_DESC SMART_PAYMENT_CHANGE_DESC SUBSIDIZED_LOAN_LIMIT_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC RESIDENCY_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR ACADEMIC_PERIOD_END_DESC SCHEDULE_DESC ACADEMIC_PERIOD_END_DESC CONTRACT_RULE_DESC ACADEMIC_STUDY_VALUE_DESC ACADEMIC_YEAR_DESC LEVEL_DESC ACADEMIC_YEAR_DESC B_CHART_OF_ACCOUNTS_DESC MAIL_DESC AID_YEAR_DESC NATION_DESC SKILL_DESC ENRL_PLANNING_SERVICE_DESC MEDICAL_TYPE_DESC HOLD_ORIGINATING_OFFICE_DESC MEDICAL_EQUIPMENT_TYPE_DESC ACADEMIC_PERIOD_DESC EXPEND_ACCOUNT_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ACTIVITY_DESC PLEDGE_PROGRAM_DESC GIFT_RULE_CLASS_DESC INTEREST_COLLEGE_DESC START_DATE_FISCAL_YEAR_DESC SOLICITATION_TYPE_DESC FUND_COST_SHARE_BASE_DESC FUND_COST_SHARE_DISTRIB_DESC FUND_INDIRECT_COST_BASE_DESC COMMODITY_DESC SOURCE_DESC CHART_OF_ACCOUNTS_DESC CARRIER_SHORT_DESC BENEFIT_DEDUCTION_TYPE_DESC EARNINGS_DESC CARRIER_LONG_DESC COST_TYPE_LONG_DESC PAYROLL_IDENTIFIER_DESC ACADEMIC_PERIOD_DESC DIRECT_LOAN_MPN_DESC SEOG_OVERPAYMENT_DESC ACADEMIC_PERIOD_DESC ACADEMIC_YEAR ADMISSIONS_ATTRIBUTE_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_END_DESC OCCUPATIONAL_COURSE_DESC TAXONOMY_OF_PROGRAM_DESC DEANS_LIST_DESC TRANSFER_TO_INSTITUTION_DESC FACULTY_MEMBER_CATEGORY_DESC CONTRACT_TYPE_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_STUDY_VALUE_DESC ACADEMIC_YEAR_DESC COLLEGE_DESC DEPARTMENT_DESC COREQ_SUBJECT_DESC SUBJECT_DESC HONOR_DESC ACADEMIC_PERIOD_START_DESC COHORT_DESC ACTIVITY_TYPE_DESC ELIGIBILITY_DESC SUBJECT_DESCACADEMIC_PERIOD_DESC ACADEMIC_YEAR_DESC REQUIREMENT_DESC ACADEMIC_PERIOD_END_DESC SUBJECT_DESC TAXONOMY_OF_PROGRAM_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC SUBJECT_DESC VETERAN_TYPE_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR CURRENT_TIME_STATUS_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC OUTCOME_DESC ACADEMIC_YEAR_DESC ACTIVITY_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC A_RULE_CLASS_DESC1 GEOGRAPHIC_DIVISION_DESC INTEREST_DESC AWARD_CATEGORY_DESC SUBJECT_DESC PHONE_ADDRESS_TYPE_DESC VISA_ISSUING_NATION_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_CHART_OF_ACCOUNTS_DESC EXPEND_FUND_DESC GIFT_FUND_DESC GIFT_LOCATION_DESC PAYMENT_PROGRAM_DESC GIVING_VEHICLE_DESC PROJECT_STATUS_DESC GIFT_SOCIETY_END_YEAR_DESC GIVING_VEHICLE_DESC PREF_GEO_REGION_ADDR_TYPE_DESC PRIMARY_STAFF_ASSIGN_IDEN_DESC PROPOSAL_PROJECT_DESC PROPOSAL_STATUS_DESC REMIT_TO_ADDRESS_TYPE_DESC REMIT_TO_STATE_PROVINCE_DESC FMGR_ADDRESS_TYPE_DESC LEAVE_REPORT_ENTRY_METHOD_DESC COST_TYPE_DESC EMPLOYER_DESC POSITION_CLASS_DESC STATUS_DESC COST_TYPE_SHORT_DESC TIMESHEET_CHART_DESC TAX_DEDUCTION_LONG_DESC AID_YEAR_DESC ACG_OVERPAYMENT_DESC LOAN_REPAYMENT_CHANGE_DESC PERKINS_OVERPAYMENT_DESC SMART_PAYMENT_CHANGE_DESC SUBSIDIZED_LOAN_LIMIT_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC RESIDENCY_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR ACADEMIC_PERIOD_END_DESC SCHEDULE_DESC ACADEMIC_PERIOD_END_DESC CONTRACT_RULE_DESC ACADEMIC_STUDY_VALUE_DESC ACADEMIC_YEAR_DESC LEVEL_DESC ACADEMIC_YEAR_DESC B_CHART_OF_ACCOUNTS_DESC MAIL_DESC AID_YEAR_DESC NATION_DESC SKILL_DESC ENRL_PLANNING_SERVICE_DESC MEDICAL_TYPE_DESC HOLD_ORIGINATING_OFFICE_DESC MEDICAL_EQUIPMENT_TYPE_DESC ACADEMIC_PERIOD_DESC EXPEND_ACCOUNT_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ACTIVITY_DESC PLEDGE_PROGRAM_DESC GIFT_RULE_CLASS_DESC INTEREST_COLLEGE_DESC START_DATE_FISCAL_YEAR_DESC SOLICITATION_TYPE_DESC FUND_COST_SHARE_BASE_DESC FUND_COST_SHARE_DISTRIB_DESC FUND_INDIRECT_COST_BASE_DESC COMMODITY_DESC SOURCE_DESC CHART_OF_ACCOUNTS_DESC CARRIER_SHORT_DESC BENEFIT_DEDUCTION_TYPE_DESC EARNINGS_DESC CARRIER_LONG_DESC COST_TYPE_LONG_DESC PAYROLL_IDENTIFIER_DESC ACADEMIC_PERIOD_DESC DIRECT_LOAN_MPN_DESC SEOG_OVERPAYMENT_DESC ACADEMIC_PERIOD_DESC ACADEMIC_YEAR ADMISSIONS_ATTRIBUTE_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_END_DESC OCCUPATIONAL_COURSE_DESC TAXONOMY_OF_PROGRAM_DESC DEANS_LIST_DESC TRANSFER_TO_INSTITUTION_DESC FACULTY_MEMBER_CATEGORY_DESC CONTRACT_TYPE_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_STUDY_VALUE_DESC ACADEMIC_YEAR_DESC COLLEGE_DESC DEPARTMENT_DESC COREQ_SUBJECT_DESC SUBJECT_DESC HONOR_DESC ACADEMIC_PERIOD_START_DESC COHORT_DESC ACTIVITY_TYPE_DESC ELIGIBILITY_DESC SUBJECT_DESC SUB_ACADEMIC_PERIOD_DESC REGISTRATION_STATUS_DESC VETERAN_TYPE_DESC SOURCE_DESC A_ACCOUNT_DESC A_ACCOUNT_INDEX_DESC A_LOCATION_DESC AID_PERIOD_DESC APPOINTMENT_RECRUITER_DESC ACADEMIC_PERIOD_DESC DISABILITY_SERVICES_DESC EPS_DESC DISABILITY_DESC DISABILITY_SERVICES_DESC AWARD_CATEGORY_DESC INSTITUTION_DESC SECONDARY_DIPLOMA_DESC POINT_OF_ENTRY_DESC YEAR_CODE_DESC ASSOCIATED_ADDRESS_TYPE_DESC FISCAL_YEAR_DESC MEMBERSHIP_PROG_TYPE_DESC PLEDGE_DURATION_DESC PROJECT_STATUS_DESC REFERENCE_DESC PROPOSAL_DESC SOLICITOR_ORGANIZATION_NAME COLLEGE_DESC REMIT_TO_NATION_DESC COMMODITY_DESC CHART_OF_ACCOUNTS_DESC CATEGORY_DESC TIMESHEET_ORGANIZATION_DESC ACADEMIC_PERIOD_DESC ACADEMIC_YEAR_DESC REQUIREMENT_DESC ACADEMIC_PERIOD_END_DESC SUBJECT_DESC TAXONOMY_OF_PROGRAM_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC SUBJECT_DESC VETERAN_TYPE_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR CURRENT_TIME_STATUS_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC OUTCOME_DESC ACADEMIC_YEAR_DESC ACTIVITY_DESC ACADEMIC_PERIOD_END_DESC ACADEMIC_YEAR_DESC SUBJECT_DESC A_RULE_CLASS_DESC1 GEOGRAPHIC_DIVISION_DESC INTEREST_DESC AWARD_CATEGORY_DESC SUBJECT_DESC PHONE_ADDRESS_TYPE_DESC VISA_ISSUING_NATION_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_CHART_OF_ACCOUNTS_DESC EXPEND_FUND_DESC GIFT_FUND_DESC GIFT_LOCATION_DESC PAYMENT_PROGRAM_DESC GIVING_VEHICLE_DESC PROJECT_STATUS_DESC GIFT_SOCIETY_END_YEAR_DESC GIVING_VEHICLE_DESC PREF_GEO_REGION_ADDR_TYPE_DESC PRIMARY_STAFF_ASSIGN_IDEN_DESC PROPOSAL_PROJECT_DESC PROPOSAL_STATUS_DESC REMIT_TO_ADDRESS_TYPE_DESC REMIT_TO_STATE_PROVINCE_DESC FMGR_ADDRESS_TYPE_DESC LEAVE_REPORT_ENTRY_METHOD_DESC COST_TYPE_DESC EMPLOYER_DESC POSITION_CLASS_DESC STATUS_DESC COST_TYPE_SHORT_DESC TIMESHEET_CHART_DESC TAX_DEDUCTION_LONG_DESC AID_YEAR_DESC ACG_OVERPAYMENT_DESC LOAN_REPAYMENT_CHANGE_DESC PERKINS_OVERPAYMENT_DESC SMART_PAYMENT_CHANGE_DESC SUBSIDIZED_LOAN_LIMIT_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR_DESC RESIDENCY_DESC ACADEMIC_YEAR_DESC ACADEMIC_YEAR ACADEMIC_PERIOD_END_DESC SCHEDULE_DESC ACADEMIC_PERIOD_END_DESC CONTRACT_RULE_DESC ACADEMIC_STUDY_VALUE_DESC ACADEMIC_YEAR_DESC LEVEL_DESC ACADEMIC_YEAR_DESC B_CHART_OF_ACCOUNTS_DESC MAIL_DESC AID_YEAR_DESC NATION_DESC SKILL_DESC ENRL_PLANNING_SERVICE_DESC MEDICAL_TYPE_DESC HOLD_ORIGINATING_OFFICE_DESC MEDICAL_EQUIPMENT_TYPE_DESC ACADEMIC_PERIOD_DESC EXPEND_ACCOUNT_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ACTIVITY_DESC PLEDGE_PROGRAM_DESC GIFT_RULE_CLASS_DESC INTEREST_COLLEGE_DESC START_DATE_FISCAL_YEAR_DESC SOLICITATION_TYPE_DESC FUND_COST_SHARE_BASE_DESC FUND_COST_SHARE_DISTRIB_DESC FUND_INDIRECT_COST_BASE_DESC COMMODITY_DESC SOURCE_DESC CHART_OF_ACCOUNTS_DESC CARRIER_SHORT_DESC BENEFIT_DEDUCTION_TYPE_DESC EARNINGS_DESC CARRIER_LONG_DESC COST_TYPE_LONG_DESC PAYROLL_IDENTIFIER_DESC ACADEMIC_PERIOD_DESC DIRECT_LOAN_MPN_DESC SEOG_OVERPAYMENT_DESC ACADEMIC_PERIOD_DESC ACADEMIC_YEAR ADMISSIONS_ATTRIBUTE_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_PERIOD_END_DESC OCCUPATIONAL_COURSE_DESC TAXONOMY_OF_PROGRAM_DESC DEANS_LIST_DESC TRANSFER_TO_INSTITUTION_DESC FACULTY_MEMBER_CATEGORY_DESC CONTRACT_TYPE_DESC ACADEMIC_PERIOD_START_DESC ACADEMIC_STUDY_VALUE_DESC ACADEMIC_YEAR_DESC COLLEGE_DESC DEPARTMENT_DESC COREQ_SUBJECT_DESC SUBJECT_DESC HONOR_DESC ACADEMIC_PERIOD_START_DESC COHORT_DESC ACTIVITY_TYPE_DESC ELIGIBILITY_DESC SUBJECT_DESC SUB_ACADEMIC_PERIOD_DESC REGISTRATION_STATUS_DESC VETERAN_TYPE_DESC SOURCE_DESC A_ACCOUNT_DESC A_ACCOUNT_INDEX_DESC A_LOCATION_DESC AID_PERIOD_DESC APPOINTMENT_RECRUITER_DESC ACADEMIC_PERIOD_DESC DISABILITY_SERVICES_DESC EPS_DESC DISABILITY_DESC DISABILITY_SERVICES_DESC AWARD_CATEGORY_DESC INSTITUTION_DESC SECONDARY_DIPLOMA_DESC POINT_OF_ENTRY_DESC YEAR_CODE_DESC ASSOCIATED_ADDRESS_TYPE_DESC FISCAL_YEAR_DESC MEMBERSHIP_PROG_TYPE_DESC PLEDGE_DURATION_DESC PROJECT_STATUS_DESC REFERENCE_DESC PROPOSAL_DESC SOLICITOR_ORGANIZATION_NAME COLLEGE_DESC REMIT_TO_NATION_DESC COMMODITY_DESC CHART_OF_ACCOUNTS_DESC CATEGORY_DESC TIMESHEET_ORGANIZATION_DESC SYSTEM_IND_DESC (More Target Columns -- list too long to display currently.) START_DATE_FISCAL_YEAR_DESC (More Target Columns -- list too long to display currently.) START_DATE_FISCAL_YEAR_DESC (More Target Columns -- list too long to display currently.)
|
This function returns the description field for the specified validation table for the specified code from the validation table. |
| GOKODSF.F_GET_DESC(CASE WHEN FTVVEND_VEND_CHECK_PIDM IS NULL) |
|
|
|
|
| GOKODSF.F_GET_NULL_VARCHAR2 |
|
AS_DISABILITY_INFORMATION AS_DISABILITY_INFORMATION |
SUB_ACADEMIC_PERIOD_DESC SUB_ACADEMIC_PERIOD |
NA |
| GOKODSF.F_GET_PREFERRED_DATA |
|
|
|
|
| GOKODSF.F_GURMAIL_MODULE_CODE_DESC |
|
|
|
NA |
| GOKODSF.F_PREFERRED_ADDRESS_IND |
|
AS_ADDRESS |
PREFERRED_ADDRESS_IND |
This function retrieves the a 'Y' if the address type being passed matches the address type set up in the GTVSDAX tablewith an internal code of 'PREFADDR' and an internal code group od 'ADDRESS'. |
| GOKODSF.F_TRIM_LONGS |
|
AG_EVENT_INVITEE AA_PREVIOUS_EMPLOYMENT AA_DESIGNATION_COMMENT AA_PLEDGE_AUXILIARY AA_CON_ENTITY_CONF_COMMENT AA_PLEDGE_CONDITIONAL AA_PROSPECT_CONF_COMMENT |
INVITEE_COMMENT EMPLOYER_COMMENT DESIGNATION_COMMENT AUXILIARY_COMMENT CONSTITUENT_COMMENT CONDITION_COMMENT PROSPECT_COMMENT |
NA |
| IF ADV_GIFT_REC.ACTIVE_CONSTITUENT_TMP ='Y' AND PERS_DEMO_REC.DECEASED_IND ='Y' THEN RET_ROW.ACTIVE_CONSTITUENT_IND :='N'; ELSE RET_ROW.ACTIVE_CONSTITUENT_IND := ADV_GIFT_REC.ACTIVE_CONSTITUENT_TMP; END IF |
|
|
|
|
| IF STUDENT_COURSE_REC.COURSE_REGISTER_IND ='Y' THEN RET_ROW.COURSE_REGISTERED_HEADCOUNT := STUDENT_COURSE_REC.WAREHOUSE_ENTITY_UID |
|
|
|
|
| LISTAGG (ACTIVITY, '-') |
|
|
|
|
| LISTAGG (ACTIVITY_DESC, '-') |
|
|
|
|
| LISTAGG (ADVISOR_NAME_LFMI, '-') |
|
|
|
|
| LISTAGG (BLOCK_REGISTRATION, '-') |
|
|
|
|
| LISTAGG (BLOCK_REGISTRATION_DESC, '-') |
|
|
|
|
| LISTAGG (COHORT, '-') |
|
|
|
|
| LISTAGG (COHORT_DESC, '-') |
|
|
|
|
| LISTAGG (HOLD, '-') |
|
|
|
|
| LISTAGG (HOLD_DESC, '-') |
|
|
|
|
| LISTAGG (HOLD_ORIGINATING_OFFICE, '-') |
|
|
|
|
| LISTAGG (HOLD_ORIGINATING_OFFICE_DESC, '-') |
|
|
|
|
| LISTAGG (STUDENT_ATTRIBUTE, '-') |
|
|
|
|
| LISTAGG (STUDENT_ATTRIBUTE_DESC, '-') |
|
|
|
|
| LOAD_MGT_CALENDAR_DATE |
|
|
|
|
| MAKFUNC.F_ADVANCEMENT_RATING_COUNT |
|
|
|
This function retrieves a count of advancement ratings associated with a person. |
| MAKFUNC.F_CAMP_EXPENSES |
|
|
|
|
| MAKFUNC.F_CAMP_MATCH_GIFTS_ANTICIPATED |
|
|
|
|
| MAKFUNC.F_CAMP_MATCH_GIFTS_PAID |
|
|
|
|
| MAKFUNC.F_CAMP_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_OUTRIGHT_GC_COUNT |
|
|
|
This function counts the total number of outright gifts made to this campaign solicitor combination. |
| MAKFUNC.F_CAMP_SOL_OUTRIGHT_GD_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_OUTRIGHT_GIFTS |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PD_NP_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PD_PAID_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_TOTAL_GIFT_COUNT |
|
|
|
This function counts the total number of gifts made to this campaign solicitor combination. |
| MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES - MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_CAMP_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_CAMP_TOTAL_GIFT_COUNT |
|
|
|
Calculate the total gift count for a given campaign. |
| MAKFUNC.F_CAMP_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_COUNT_ADVANCEMENT_RATING |
|
|
|
This function returns a count of the MAT_ADVANCEMENT_RATING records for the parameter supplied UID. In addition, an optional parameter can be provided to return a sub-count of the ratings are either internal (from the AMRPRRT) or external (from AMREXRT). |
| MAKFUNC.F_COUNT_CONS_CONTACT |
|
|
|
This function returns a count of the MAT_CONSTITUENT_CONTACT records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_DEGREES |
|
|
|
This function returns a count of the MAT_DEGREE records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_DONOR_CATEGORY |
|
|
|
This function returns a count of the MAT_DONOR_CATEGORY records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_EXCLUSION |
|
|
|
This function returns a count of the MAT_EXCLUSION records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_FUNDING_INT |
|
|
|
This function returns a count of the MAT_FUNDING_INTEREST records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_GIFT_ASSOCIATED_ENTITY |
|
|
|
NA |
| MAKFUNC.F_COUNT_GIFT_AUXILIARY |
|
|
|
This function returns a count of the MAT_GIFT_AUXILIARY records for the parameter supplied UID and Gift Number. |
| MAKFUNC.F_COUNT_GIFT_SOCIETY |
|
|
|
This function retrieves a count of gift societies with whom a particular identification is associated for a specified year. |
| MAKFUNC.F_COUNT_GIFT_SOLICITOR |
|
|
|
This function returns a distinct count of all MAT_GIFT_SOCIETY records for the parameter supplied UID where either the parameter Gift year matches or the lifetime gift society indicator = Y. |
| MAKFUNC.F_COUNT_MAIL |
|
|
|
This function returns a count of the MAT_MAIL records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_MATCH_GIFT |
|
|
|
This function returns a count of the MAT_GIFT_MATCHING records for the parameter supplied UID and Gift Number. |
| MAKFUNC.F_COUNT_MATCH_PLEDGE |
|
|
|
This function returns a count of the MAT_PLEDGE_MATCHING records for the parameter supplied UID and Pledge Number. |
| MAKFUNC.F_COUNT_ORGN_CONTACT |
|
|
|
This function returns a count of the MAT_ORGANIZATION_CONTACT records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_PLEDGE_SOLICITOR |
|
|
|
This function returns a count of the MAT_SOLICITOR records for the parameter supplied UID and Pledge Number where the Gift Pledge Indicator = P. |
| MAKFUNC.F_COUNT_PREV_EMPLOYMENT |
|
|
|
This function returns a count of the MAT_previous_employment records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_RELATION |
|
|
|
This function returns a count of the MAT_RELATION records for the parameter supplied UID and Relation Type Indicator. |
| MAKFUNC.F_COUNT_SPECIAL_ACTIVITY |
|
|
|
This function returns a count of the MAT_SPECIAL_ACTIVITY records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_SPECIAL_PURP |
|
|
|
This function returns a count of the MAT_SPECIAL_PURPOSE_GROUP records for the parameter supplied UID. |
| MAKFUNC.F_COUNT_STAFF_ASSIGNMENT |
|
|
|
This function returns a count of the number of MAT_CONSTITUENT_STAFF_ASSIGN records for the parameter supplied UID. |
| MAKFUNC.F_DESG_CAMP_GIFT_COUNT |
|
|
|
Calculates the total number of gifts for a given campaign's designation. |
| MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED |
|
|
|
|
| MAKFUNC.F_DESG_MATCH_GIFTS_PAID |
|
|
|
|
| MAKFUNC.F_DESG_OUTRIGHT_GIFTS |
|
|
|
|
| MAKFUNC.F_DESG_OUTRIGHT_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_OUTRIGHT_GIFT_DONOR_CNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_BALANCE |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_DONOR_NO_PAY_CNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_DONOR_PAID_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_PLEDGE_PAYMENT |
|
|
|
|
| MAKFUNC.F_DESG_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_DESG_TOTAL_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_DESG_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_GET_ENTITY_IND |
|
|
|
|
| MAKFUNC.F_GET_PERSON_INFO |
|
|
|
|
| MAKFUNC.F_GET_PLEDGE_INSTALL_IND |
|
|
|
SUBSTR(MAKFUNC.F_GET_PLEDGE_INSTALL_IND(MAT_PLEDGE.ENTITY_UID, PLEDGE_NUMBER),1,1) |
| MAKFUNC.F_GET_PROP_ACTIVE_PROJ_AMOUNT |
|
|
|
|
| MAKFUNC.F_GET_PROP_ACTIVE_PROJ_COUNT |
|
|
|
|
| MAKFUNC.F_GET_SPOUSE_IND |
|
|
|
Returns a Y/N indicator for active spouses with whom a particular ID is associated. |
| MAKFUNC.F_GET_SPOUSE_NAME |
Returns the spouses name LFM. |
|
|
SUBSTR(MAKFUNC.F_GET_SPOUSE_NAME(C.ENTITY_UID),1,100), |
| MAKFUNC.F_ORG_OUTRIGHT_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_OUTRIGHT_GIFTS |
|
|
|
|
| MAKFUNC.F_ORG_OUTRIGHT_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_PLEDGE_DONOR_NP_COUNT |
|
|
|
Function returns the number of constituents that have not paid toward their pledge for this solicitor organization. |
| MAKFUNC.F_ORG_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_ORG_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_ORG_TOTAL_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_ORG_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_PROPOSAL_RESULT_EXISTS |
|
|
|
|
| MAKFUNC.F_SOLG_CAMP_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_SOLP_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_SOLP_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_SOLP_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_OUTRIGHT_GD_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_OUTRIGHT_GIFTS |
|
|
|
|
| MAKFUNC.F_SOL_FR_OUTRIGHT_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PD_NP_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PD_PAID_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PLEDGE_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PLEDGE_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT/ORGAN IZATION_DONOR_COUNT_GOAL |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT/SOLIC ITOR_DONOR_COUNT_GOAL |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_GIFTS |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_GIFT_COUNT |
|
|
|
|
| MAKFUNC.F_SOL_FR_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_SUM_PROPOSAL_RESULT |
|
|
|
|
| MAKFUNC.F_TOTAL_CAMP_DESG_GOAL |
|
|
|
|
| MAX(MST_TEST.TEST_SCORE) WHERE [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_LEVEL_GROUP_TESTS'] AND [MTVPARM_INTERNAL_CODE = 'TEST' AND MTVPARM_EXTERNAL_CODE = MST_TEST.TEST] |
|
|
|
|
| MDKFUNC.F_GET_THIRD_PARY_PLAN_IND |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_REMAINING |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_TOTAL |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_TOTAL( PORTFOLIO_KEY, '%', '%') |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_TOTAL( PORTFOLIO_KEY, '%', 'N') |
|
|
|
|
| MEKFUNC.F_AUTHORIZED_TOTAL( PORTFOLIO_KEY, '%', 'Y') |
|
|
|
|
| MEKFUNC.F_GET_TAX_AMOUNT( E.EXPENSE_ITEM_KEY,'A') |
|
|
|
|
| MEKFUNC.F_GET_TAX_AMOUNT( E.EXPENSE_ITEM_KEY,'C') |
|
|
|
|
| MEKFUNC.F_GET_TAX_AMOUNT( E.EXPENSE_ITEM_KEY,'P') |
|
|
|
|
| MEKFUNC.F_ITINERARY_DATE |
|
|
|
|
| MEKFUNC.F_LIFE_TOTAL_REIMBURSE_PAID |
|
|
|
|
| MEKFUNC.F_NOTIFICATION_CHANGE_HOURS |
|
|
|
|
| MEKFUNC.F_STATUS_CHANGE_HOURS( AUTHORIZATION_KEY, STATUS_DATE, 'A', 'L') |
|
|
|
|
| MEKFUNC.F_STATUS_CHANGE_HOURS( AUTHORIZATION_KEY, STATUS_DATE, 'A', 'T') |
|
|
|
|
| MEKFUNC.F_STATUS_CHANGE_HOURS( REIMBURSEMENT_KEY, STATUS_DATE, 'R', 'L') |
|
|
|
|
| MEKFUNC.F_STATUS_CHANGE_HOURS( REIMBURSEMENT_KEY, STATUS_DATE, 'R', 'T') |
|
|
|
|
| MEKFUNC.F_TOTAL_NOT_SUBMITTED |
|
|
|
|
| MEKFUNC.F_TOTAL_NOT_SUBMITTED( PORTFOLIO_KEY, '%', '%') |
|
|
|
|
| MEKFUNC.F_TOTAL_NOT_SUBMITTED( PORTFOLIO_KEY, '%', 'N') |
|
|
|
|
| MEKFUNC.F_TOTAL_NOT_SUBMITTED( PORTFOLIO_KEY, '%', 'Y') |
|
|
|
|
| MEKFUNC.F_TOTAL_REIMBURSE_NOT_PAID |
|
|
|
|
| MEKFUNC.F_TOTAL_REIMBURSE_NOT_PAID( PORTFOLIO_KEY, '%') |
|
|
|
|
| MEKFUNC.F_TOTAL_REIMBURSE_PAID |
|
|
|
|
| MEKFUNC.F_TOTAL_REIMBURSE_PAID( PORTFOLIO_KEY, '%') |
|
|
|
|
| MEKFUNC.F_TOTAL_SUBMITTED |
|
|
|
|
| MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', '%') |
|
|
|
|
| MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'N') |
|
|
|
|
| MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'Y') |
|
|
|
|
| MFKFUNC.F_GET_BOOK_AMOUNT |
|
|
|
NA |
| MFKFUNC.F_GET_LEDGER_ENCUMBERED_AMOUNT |
|
|
|
|
| MFKFUNC.F_GET_LEDGER_REMAINING_BALANCE |
|
|
|
|
| MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID |
|
|
|
This function extracts the LAST row of return information for the purchase order and item. MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID(PURCHASE_ORDER,ITEM) |
| MFKFUNC.F_GET_UNITS_PURCHASED |
|
|
|
NA |
| MFKFUNC.F_GET_VENDOR_FIELDS |
|
|
|
This function returns the ID_NUMBER and name information for an entity based upon their UID and the entity indicator that is passed. If the entity indicator passed = C, then the ID_NUMBER and NAME are returned from MST_ORGANIZATION_ENTITY. Otherwise, the ID_NUMBER and a concatenation of FIRST_NAME, MIDDLE_NAME and LAST_NAME are returned from MST_PERSON. |
| MFKFUNC.F_QTY_ACCEPTED |
|
|
|
This function returns the total number of quantity accepted in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_ACCEPTED(PI.PURCHASE_ORDER, PI.ITEM),0) |
| MFKFUNC.F_QTY_RECEIVED |
|
|
|
This function returns the total number of quantity received in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_RECEIVED(PI.PURCHASE_ORDER, PI.ITEM),0) |
| MFKFUNC.F_QTY_RECEIVED_REJECTED |
|
|
|
This function returns the total number of quantity received and rejected in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_RECEIVED_REJECTED(PI.PURCHASE_ORDER, PI.ITEM),0) |
| MFKFUNC.F_QTY_REJECTED |
|
|
|
This function returns the total number of quantity rejected in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_ACCEPTED(PI.PURCHASE_ORDER, PI.ITEM),0) |
| MFKFUNC.F_QTY_RETURNED |
|
|
|
This function returns the total number of quantity returned in receiving for a specified purchase order and item number. NVL(MFKFUNC.F_QTY_ACCEPTED(PI.PURCHASE_ORDER, PI.ITEM),0) |
| MFKFUNC.F_RECEIVED_AMOUNT |
|
|
|
This function returns the total received amount in receiving for a specified purchase order and item numberof standing orders. NVL(MFKFUNC.F_RECEIVED_AMOUNT(PI.PURCHASE_ORDER, PI.ITEM),0) |
| MFKFUNC.F_SUM_BOOK_AMOUNT |
|
|
|
NA |
| MFKFUNC.F_SUM_UNITS_PURCHASED |
|
|
|
NA |
| MFKFUNC.F_VENDOR_TYPE_COUNT( VENDOR.VENDOR_UID) |
|
|
|
NA |
| MGKFUNC.F_CALCULATE_AGE(SYSDATE, BIRTH_DATE, DECEASED_DATE), |
|
|
|
Calculates the current age of a person based upon today's date. |
| MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS |
|
|
|
|
| MGKFUNC.F_COUNT_MAILING |
|
|
|
This function counts the number of MGT_COMMUNICATION records for the parameter supplied UID, academic period and application number. |
| MGKFUNC.F_COUNT_RACE |
Number of regulatory races selected by this person. |
|
|
SELECT COUNT(*) FROM MST_RACE WHERE PERSON_UID = IDEN |
| MGKFUNC.F_COUNT_RACE_CATEGORY |
Number of unique regulatory races selected by this person. |
|
|
SELECT COUNT(DISTINCT RACE_CATEGORY) FROM MST_RACE WHERE PERSON_UID = IDEN |
| MGKFUNC.F_FORMAT_NAME |
|
|
|
|
| MGKFUNC.F_GET_PERSON_INFO |
|
|
|
This function returns a column value from MST_PERSON based on the value in ColumnRequested. When the UID is not found on MST_PERSON, either NULL is returned or, if a value is given for AlternateSource, an alternate view is read for the column value. |
| MGKFUNC.F_GET_UID |
|
|
|
|
| MPKFUNC.F_CHECK_SUPERVISOR |
Returns a Y when the PERSON_UID exists as a SUPERVISOR_UID in MPT_SUPERVISOR. |
|
|
SELECT 'Y' FROM MPT_SUPERVISOR WHERE SUPERVISOR_UID = IDEN; |
| MPKFUNC.F_COUNT_ACTIVE_JOBS |
Counts the number of records in MPT_EMPL_POSITION where POSITION_STATUS is not equal to T. |
|
|
SELECT COUNT(*) FROM MPT_EMPL_POSITION WHERE PERSON_UID = IDEN AND POSITION_STATUS <> 'T'; |
| MPKFUNC.F_COUNT_BARG_UNIT |
|
|
|
This function returns the count of the MPT_BARG_UNIT records for a specified UID. |
| MPKFUNC.F_COUNT_BENEFICIARY |
|
|
|
This function returns the count of the MPT_BENEFICIARY records for a specified UID. |
| MPKFUNC.F_COUNT_CERTIFICATION |
|
|
|
This function returns the count of the MPT_CERTIFICATION records for a specified UID. |
| MPKFUNC.F_COUNT_DIRECT_REPORT |
Counts the number of people that have this person's SUPERVISOR_UID in MPT_SUPERVISOR. |
|
|
SELECT COUNT(*) FROM MPT_SUPERVISOR WHERE SUPERVISOR_UID = IDEN AND POSITION_STATUS <> 'T'; |
| MPKFUNC.F_COUNT_EMPL_EARN |
|
|
|
This function returns the count of the MPT_EMPL_EARN_CY records for a specified UID. |
| MPKFUNC.F_COUNT_HR_APPL_STAT |
|
|
|
This function returns the count of the MPT_HR_APPL_STAT records for a specified UID, requisition number, position applied for and position class. |
| MPKFUNC.F_COUNT_INTERVIEW |
|
|
|
This function returns the count of the MPT_INTERVIEW records for a specified UID. |
| MPKFUNC.F_COUNT_LABOR_COST |
|
|
|
This function returns the count of the MPT_LABOR_COST_DIST records for a specified position. |
| MPKFUNC.F_COUNT_LABOR_DIST |
|
|
|
This function retrieves the count of records in MPT_LABOR_COST_DIST for the position passed. |
| MPKFUNC.F_COUNT_LEAVE |
|
|
|
This function returns the count of the MPT_LEAVE_BALANCE records for a specified UID. |
| MPKFUNC.F_COUNT_PAST_EMPL |
|
|
|
This function returns the count of the MPT_PAST_EMPLOYMENT records for a specified UID. |
| MPKFUNC.F_COUNT_POSN_LABOR |
|
|
|
This function returns the count of the MPT_POSN_LABOR_DIST records for a specified position. |
| MPKFUNC.F_COUNT_REFERENCE |
|
|
|
This function returns the count of the MPT_REFERENCE records for a specified UID. |
| MPKFUNC.F_COUNT_REVIEW |
|
|
|
This function returns the count of the MPT_REVIEW records for a specified UID. |
| MPKFUNC.F_COUNT_SKILL |
|
|
|
This function returns the count of the MPT_SKILL records for a specified UID. |
| MPKFUNC.F_GET_EMPL_POSITION_INFO |
|
|
|
|
| MPKFUNC.F_GET_PERSONNEL_ACTION_IND |
|
|
|
|
| MPKFUNC.F_GET_POSITION_REPORTS |
|
AN_POSITION_DEFINITION |
POSITION_REPORTS_TITLE |
DECODE(POSITION_REPORTS, NULL, SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION,'POSITION_TITLE'),1,255), SUBSTR(MPKFUNC.F_GET_POSITION_REPORTS(POSITION_REPORTS,'POSITION_TITLE'),1,255)) |
| MPKFUNC.F_NEW_EMPLOYEE_IND |
Identifies the person as a new employee based on the value in service years. |
|
|
SELECT TO_NUMBER(MGRSDAX_EXTERNAL_CODE) FROM MGRSDAX WHERE MGRSDAX_PROFILE_CODE = 'INSTITUTION' AND MGRSDAX_INTERNAL_CODE = 'SERVICE_YEARS' AND MGRSDAX_INTERNAL_CODE_GROUP = 'NEW_EMPLOYEE' |
| MPKFUNC.F_NUMBER_INCUMB |
|
|
|
This function retrieves the sum of full_time_equivelancy_pct from MPT_EMPL_POSITION based on position and date. |
| MPKFUNC.F_POSITION_CURRENT_IND |
|
|
|
This function returns an 'N' or 'Y' depending on if the position is current based on the current date. |
| MPKFUNC.F_POSITION_DEF_DATA |
|
|
|
|
| MPKFUNC.F_SERVICE_YEARS |
Calculates the length of service in years for active employees based on the difference between today's date and the adjusted service date; for terminated employees based on the difference between termination date and adjusted service date. |
|
|
DECODE(EMPL_STATUS,'T',ROUND((TERM_DATE-ADJ_SERVICE_DATE)/365.25,2),ROUND((SYSDATE-ADJ_SERVICE_DATE)/365.25,2)) |
| MRKFUNC.F_CHECK_FOR_ACTIVE_HOLD |
|
|
|
|
| MRKFUNC.F_GET_ACADEMIC_PERIOD |
|
|
|
Extracts academic period or academic period description from mrt_satisfactory_acad_progress for a person and given aid year. |
| MRKFUNC.F_GET_AID_ENROLL_PERIOD |
|
|
|
Extracts the aid year, aid year description, aid enrollment period, or aid enrollment period description for a student and a given term. |
| MRKFUNC.F_GET_AID_PERIOD |
|
|
|
Extracts aid period or aid description from mrt_finaid_applicant_status table by giving the student uid and aid year. |
| MRKFUNC.F_GET_FIN_AID_AWARDED_IND |
|
|
|
|
| MRKFUNC.F_GET_FIN_AID_DISBURSED_IND |
|
|
|
|
| MRKFUNC.F_GET_FIN_AID_LOAN_IND |
|
|
|
|
| MSKFUNC.F_ADDRESS_ROWID |
|
|
|
This function retrieves the rowid from the address table based on the current date being between the address start and end date. |
| MSKFUNC.F_CALC_TRANSFER_CREDITS |
|
|
|
|
| MSKFUNC.F_CHECK_COOP_IND |
|
|
|
F_CHECK_COOP_IND (UID NUMBER, ACAD_PERIOD VARCHAR2, LEVL VARCHAR2) |
| MSKFUNC.F_COUNT_ADDRESSES |
|
|
|
|
| MSKFUNC.F_COUNT_ADMINISTRATOR |
|
|
|
This function counts the number of MST_ADMINISTRATOR records for the parameter supplied UID. |
| MSKFUNC.F_COUNT_ADMISSIONS_ATTRIBUTE |
|
|
|
This function counts the number of MST_ADMISSIONS_ATTRIBUTE records for the parameter supplied UID, academic period and application number. |
| MSKFUNC.F_COUNT_ADMISSIONS_COHORT |
|
|
|
This function counts the number of MST_ADMISSIONS_COHORT records for the parameter supplied UID, academic period and application number. |
| MSKFUNC.F_COUNT_ADMISSIONS_DECISION |
|
|
|
This function counts the number of MST_ADMISSIONS_DECISION records for the parameter supplied UID, academic period and application number. |
| MSKFUNC.F_COUNT_ADMISSIONS_RATING |
|
|
|
This function counts the number of MST_ADMISSIONS_RATING records for the parameter supplied UID, academic period and application number. |
| MSKFUNC.F_COUNT_ADMISSIONS_REQUIREMENT |
|
|
|
This function counts the number of MST_ADMISSIONS_REQUIREMENT records for the parameter supplied UID, academic period and application number. |
| MSKFUNC.F_COUNT_ADMISSIONS_SOURCE |
|
|
|
This function counts the number of MST_ADMISSIONS_SOURCE records for the parameter supplied UID, academic period and application number. |
| MSKFUNC.F_COUNT_ADVISORS |
|
|
|
This function counts the number of MST_ADVISORS records for the parameter supplied UID and academic period. |
| MSKFUNC.F_COUNT_COHORTS |
|
|
|
This function counts the number of MST_STUDENT_COHORT records for the parameter supplied UID and academic period. |
| MSKFUNC.F_COUNT_CONTACTS |
|
|
|
This function counts the number of MST_CONTACT records for the parameter supplied UID. |
| MSKFUNC.F_COUNT_COURSE_ATTRIBUTES |
|
|
|
|
| MSKFUNC.F_COUNT_COURSE_COREQ |
|
|
|
This function counts the number of MST_COURSE_COREQ records for the parameter supplied subject, course and academic period. |
| MSKFUNC.F_COUNT_COURSE_LEVEL |
|
|
|
This function returns the count of course levels based on the subject, course number and academic period passed. |
| MSKFUNC.F_COUNT_COURSE_SCHEDULE |
|
|
|
|
| MSKFUNC.F_COUNT_FACULTY_ATTRIBUTE |
|
|
|
This function counts the number of MST_FACULTY_ATTRIBUTE records for the parameter supplied UID and academic period. |
| MSKFUNC.F_COUNT_FACULTY_CONTRACT |
|
|
|
This function counts the number of MST_FACULTY_CONTRACT records for the parameter supplied UID and academic period. |
| MSKFUNC.F_COUNT_FACULTY_DEPT_COLL |
|
|
|
This function counts the number of MST_FACULTY_DEPT_COLLEGE records for the parameter supplied UID and academic period. |
| MSKFUNC.F_COUNT_GRADE_CHANGE |
|
|
|
NA |
| MSKFUNC.F_COUNT_GRADE_TYPE |
|
|
|
|
| MSKFUNC.F_COUNT_HOLDS |
|
|
|
This function counts the number of active MST_HOLD records for the parameter supplied UID. |
| MSKFUNC.F_COUNT_HONORS |
|
|
|
This function counts the number of MST_OUTCOME_HONOR records for the parameter supplied UID, outcome and honor code. |
| MSKFUNC.F_COUNT_INSTITUTION_TYPES |
|
|
|
This function counts the number of MST_PREVIOUS_EDUCATION records for the parameter supplied UID and institution type. |
| MSKFUNC.F_COUNT_INSTRUCTOR |
|
|
|
This function counts the number of MST_INSTRUCTIONAL_ASSIGNMENT records for the parameter supplied academic period. |
| MSKFUNC.F_COUNT_INST_ASSIGNMENT |
|
|
|
This function counts the number of MST_INSTRUCTIONAL_ASSIGNMENT records for the parameter supplied academic period and course. |
| MSKFUNC.F_COUNT_INTERESTS |
|
|
|
This function counts the number of MST_INTERESTS records for the parameter supplied UID. |
| MSKFUNC.F_COUNT_MEDICAL_INFORMATION |
|
|
|
This function counts the number of MST_MEDICAL_INFORMATION records for the parameter supplied UID. |
| MSKFUNC.F_COUNT_MEETING_TIME |
|
|
|
This function counts the number of MST_MEETING_TIME records for the parameter supplied academic period and course. |
| MSKFUNC.F_COUNT_NONINST_ASSIGNMENT |
|
|
|
This function counts the number of MST_NONINSTRUCTIONAL_ASGNMNT records for the parameter supplied UID and academic period. |
| MSKFUNC.F_COUNT_OFFERING_COREQ |
|
|
|
This function counts the number of MST_OFFERING_COREQ records for the parameter supplied academic period and course. |
| MSKFUNC.F_COUNT_OFFERING_PREREQ |
|
|
|
This function counts the number of MST_OFFERING_PREREQ records for the parameter supplied academic period and course. |
| MSKFUNC.F_COUNT_RECRUITMENT_ATTRIBUTES |
|
|
|
This function counts the number of MST_RECRUITMENT_ATTRIBUTE records for the parameter supplied UID, academic period and recruitment number. |
| MSKFUNC.F_COUNT_RECRUITMENT_SOURCES |
|
|
|
This function counts the number of MST_RECRUITMENT_SOURCE records for the parameter supplied UID, academic period and recruitment number. |
| MSKFUNC.F_COUNT_SECONDARY_SUBJECTS |
|
|
|
This function counts the number of MST_SECONDARY_SCHOOL_SUBJECT records for the parameter supplied UID and institution. |
| MSKFUNC.F_COUNT_SPORTS |
|
|
|
This function counts the number of MST_SPORTS records for the parameter supplied UID and academic period. |
| MSKFUNC.F_COUNT_STUDENT_COURSE_ATTR |
|
|
|
NA |
| MSKFUNC.F_COUNT_TELEPHONES |
|
|
|
|
| MSKFUNC.F_COUNT_TESTS |
|
|
|
This function counts the number of MST_TEST records for the parameter supplied UID. |
| MSKFUNC.F_DEGR_ENROLLED_IND |
|
|
|
This function returns a Y/N indicator based on enrollment in a degree category for a specified UID and academic period. |
| MSKFUNC.F_ENROLLED_IND |
|
|
|
This function retrieves the enrollment indicator from the enrollment table for a person and academic period passed. If no records exists, an 'N' is returned. |
| MSKFUNC.F_FORMAT_NAME |
|
|
|
This function returns the formatted name of the specified UID and format (for example, FMIL or LFMI). |
| MSKFUNC.F_GET_BLOCK_REG_CNT |
|
|
|
|
| MSKFUNC.F_GET_CONTINUING_ED_IND |
|
|
|
|
| MSKFUNC.F_GET_DEGREE_IND |
|
|
|
|
| MSKFUNC.F_GET_DIVISOR_FTE |
|
|
|
This function retrieves either the full time equivalency of a student for a term, or the divisor used to determine the full time equivalency of a student for a term. |
| MSKFUNC.F_GET_ENROLL_WITHDRAW_DATE |
|
|
|
|
| MSKFUNC.F_GET_LAST_ACADEMIC_PERIOD |
|
|
|
This function retrieves the maximum academic period from MST_STUDENT_COURSE for a given person where the gradable indicator is set to 'Y'. |
| MSKFUNC.F_GET_LATEST_DECISION |
|
|
|
|
| MSKFUNC.F_GET_OUTCOME_AWARDED_IND |
|
|
|
Determines if program has outcome awarded to the student. |
| MSKFUNC.F_GET_PREF_ADDRESS_ROWID |
|
|
|
This function retrieves the rowid from the address table based on the current date being between the address start and end date. The address must also have an active or null status and also be a preferred address. |
| MSKFUNC.F_GET_REG_PLAN_CNT |
|
|
|
|
| MSKFUNC.F_GET_REG_PLAN_IND |
|
|
|
|
| MSKFUNC.F_GET_SALUTATIONS_COUNT |
|
|
|
This function counts the number of MAT_SALUTATION records for the parameter supplied UID. |
| MSKFUNC.F_GET_STDNT_ATTR_CNT |
|
|
|
|
| MSKFUNC.F_GET_TEST_PERCENTILE_COUNT |
|
|
|
|
| MTKFUNC.F_AMOUNT_DUE |
|
|
|
This function will calculate the amount due from TBRACCD for a specified entity. It formulates a sum of the TBRACCD_BALANCE for all transactions whose TBRACCD_EFFECTIVE_DATE is before or equal to the date contained in the GTVSDAX rule where GTVSDAX_INTERNAL_CODE_GROUP = AR ENTITY DATE. |
| MTKFUNC.F_MEMO_BALANCE |
|
|
|
This function calculates the sum of the memo balance on unexpired memos for a specified UID and detail code where the expiration date TBRMEMO_EXPIRATION_DATE is null or greater than yesterday. The function is nvl(sum(decode(tbbdetc_type_ind, 'P',tbrmemo_amount*-1,tbrmemo_amount)),0) |
| NA |
|
|
|
|
| NOKODSF.F_GET_END_NBRJFTE_FTE_DATE |
|
AN_JOB_FTE_TRACKING |
ANNUALIZED_FTE_END_DATE |
This function returns an end date for the employee fte assignment effective date for the specified UID, Position, Suffix and Effective Date. |
| NOKODSF.F_GET_END_NBRJFTE_JOB_DATE |
|
AN_JOB_FTE_TRACKING |
JOB_END_DATE |
This function returns an end date for employee job assignment effective date for the specified UID, Position, Suffix and Effective Date. |
| NOKODSF.F_GET_END_NBRJLBD_DATE |
|
AN_LABOR_COST_DISTRIBUTION |
EFFECTIVE_END_DATE |
This function returns an end date for job labor distribution effective date for the specified UID, Position, Suffix and Effective Date. |
| NOKODSF.F_GET_END_NBRJOBS_DATE |
|
AN_EMPLOYEE_POSITION |
EFFECTIVE_END_DATE |
This function returns an end date for employee assignment effective date for the specified UID, Position, Suffix and Effective Date. |
| NOKODSF.F_GET_END_NBRPTOT_DATE |
|
AN_POSITION_BUDGET |
EFFECTIVE_END_DATE |
This function returns an end date for position budget effective date for the specified position, fiscal year, organization, budget and budget phase. |
| NOKODSF.F_GET_LAST_PAID_DATE |
|
AN_EMPLOYEE_POSITION |
LAST_PAID_DATE |
|
| NOKODSF.F_GET_PAF_COMMENT_COUNT |
|
AN_PERSONNEL_ACTION |
PAF_COMMENT_COUNT |
|
| NOKODSF.F_GET_SUPERVISOR |
Returns the NBRJOBS_DESC based on the SUPERVISOR_POSITION in MPT_SUPERVISOR. |
AN_EMPLOYEE_POSITION AN_SUPERVISOR |
SUPERVISOR_TITLE SUPERVISOR_TITLE |
TO_NUMBER(NOKODSF.F_GET_SUPERVISOR(B.NBBPOSN_POSN_REPORTS,'PIDM'))) |
| NOKODSF.F_NEXT_AUTO_STEP |
|
AN_EMPLOYEE_POSITION |
NEXT_AUTO_STEP_INCREASE |
This function finds the next step for the table, grade, group and step for the specified assignment table, assignment grade, assignment salary group and assignment step. |
| NOKODSF.F_SALARY_RANGE_IND |
|
AN_EMPLOYEE_POSITION AN_EMPLOYEE_POSITION AN_EMPLOYEE_POSITION |
BELOW_SALARY_RANGE_IND IN_SALARY_RANGE_IND ABOVE_SALARY_RANGE_IND |
This function identifies low, midpoint and high salary range for the specified the assignment salary, regular rate, which field (HIGH, LOW, MIDPOINT), assignment salary group, salary table, and assignment salary grade. |
| NVL((SELECT MIN(ACADEMIC_YEAR) FROM MST_SPORT SPORT WHERE SPORT.PERSON_UID = A.PERSON_UID AND SPORT.ACTIVITY = A.ACTIVITY),'1900') |
|
|
|
|
| NVL((SELECT NVL(MAX(ACADEMIC_YEAR), '2099') FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY), 2099) |
|
|
|
|
| NVL((SELECT NVL(MIN(ACADEMIC_YEAR), '1900') FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY), 1900) |
|
|
|
|
| NVL(ACADEMIC_PERIOD, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''ACADEMIC_STANDING_ACAD_PERIOD'') |
|
|
|
|
| NVL(ACADEMIC_STANDING, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL,''ACADEMIC_STANDING'') |
|
|
|
|
| NVL(ACADEMIC_STANDING_DATE, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''ACADEMIC_STANDING_DATE'') |
|
|
|
|
| NVL(ACADEMIC_STANDING_DESC, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''ACADEMIC_STANDING_DESC'') |
|
|
|
|
| NVL(AXBMGID_MGFORM_READYTOSEND,'N') |
|
|
|
|
| NVL(COMBINED_ACAD_STANDING, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''COMBINED_ACAD_STANDING'') |
|
|
|
|
| NVL(COMBINED_ACAD_STANDING_DATE, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''COMBINED_ACAD_STANDING_DATE'') |
|
|
|
|
| NVL(COMBINED_ACAD_STANDING_DESC, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''COMBINED_ACAD_STANDING_DESC'') |
|
|
|
|
| NVL(PROGRESS_EVALUATION, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL,''PROGRESS_EVALUATION'') |
|
|
|
|
| NVL(PROGRESS_EVALUATION_DATE, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''PROGRESS_EVALUATION_DATE'') |
|
|
|
|
| NVL(PROGRESS_EVALUATION_DESC, MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_UID,ACADEMIC_PERIOD, PROGRAM_LEVEL, ''PROGRESS_EVALUATION_DESC'') |
|
|
|
|
| NVL(RPRADSB_SCHEDULE_AMT, ROKODSF.F_GET_RPRADSB_SCHEDULE_AMT |
|
|
|
|
| NVL(SORLCUR_SITE_CODE, SGBSTDN_SITE_CODE) |
|
AS_LEARNER_CURRICULUM_FOS |
SITE |
NA |
| NVL(SORLCUR_STYP_CODE, SGBSTDN_STYP_CODE) |
|
AS_LEARNER_CURRICULUM_FOS |
STUDENT_POPULATION |
NA |
| NVL(SORLCUR_TERM_CODE_END,'999999') |
|
AS_LEARNER_CURRICULUM_FOS |
LAST_ACTIVE_ACADEMIC_PERIOD |
|
| NVL(MSKFUNC.F_GET_INQUIRER_IND( A.PERSON_UID, A.ACADEMIC_PERIOD),'N') |
|
|
|
|
| POKODSF.F_CALC_DEDN_AMT |
|
|
|
This function calculates the deduction amount from PHRDEDN for a given person, year, pict code, payroll number and sequence number. |
| POKODSF.F_CALC_DEDUCTIONS_FYTD |
|
AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION |
EMPLOYEE_CONTRIBUTION_FYTD EMPLOYER_CONTRIBUTION_FYTD GROSS_COMPENSATION_FYTD |
This function will calculate the sum of EMPLOYEE_CONTRIBUTION_FYTD, EMPLOYER_CONTRIBUTION_FYTD, and GROSS_COMPENSATION_FYTD for a UID, fiscal year and carrier. |
| POKODSF.F_CALC_EARNING_TOTALS_YTD |
|
AP_EMPLOYEE_EARNING_CY AP_EMPLOYEE_EARNING_CY |
TOTAL_HOUR_YTD TOTAL_EARNING_YTD |
This function will calculate year to date hours or earning for an employee for a specific UID, year, month, year type, chart of accounts and earning code. |
| POKODSF.F_GET_COVERAGE_OPTION |
|
AP_MONTHLY_DEDUCTION |
COVERAGE_OPTION |
|
| POKODSF.F_GET_COVERAGE_OPTION_DESC |
|
AP_MONTHLY_DEDUCTION |
COVERAGE_OPTION_DESC |
|
| POKODSF.F_GET_DEDUCTION_AMOUNTS |
|
AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_TAX AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_TAX AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_TAX AP_TAX AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_BENEFIT_DEDUCTION AP_TAX AP_TAX |
EMPLOYEE_BOND_PURCHASE_AMOUNT EMPLOYEE_DEDUCTION_AMOUNT LIFE_INSURANCE_SALARY LIFE_INSURANE_COVERAGE_AMOUNT EMPLOYEE_ADD_WITHHOLDING_AMT EMPLOYEE_DEDN_LTD_LIMIT LIFE_INSURANCE_OVERRIDE_AMOUNT LIFE_INSURANCE_PREMIUM STATE_INCOME_TAX_EXEMPTION_AMT EMPLOYEE_MINIMUM_YTD_GROSS EMPLOYER_DEDUCTION_AMOUNT EMPLOYEE_ALT_WAGE_BASE_MAX EMPLOYEE_ANNUALWAGE_DEDUCTIONS EMPLOYEE_DEDN_MTD_LIMIT EMPLOYEE_ANNUAL_DEDN_LIMIT EMPLOYEE_DEDUCTION_PERCENT EMPLOYEE_MINIMUM_EARNINGS EMPLOYEE_NET_CLAIM_AMT EMPLOYEE_TAX_CREDITS |
This function extracts amounts 1-4 from pdrdedn based on a specified UID, carrier and effective date. |
| POKODSF.F_GET_DEDUCTION_OPTIONS |
|
AP_TAX AP_BENEFIT_DEDUCTION AP_TAX AP_TAX AP_BENEFIT_DEDUCTION AP_TAX AP_TAX AP_TAX |
EMPLOYEE_AGE_OVER_65_IND LIFE_INSURANCE_TYPE_IND EMPLOYEE_AREA_CREDIT EMPLOYEE_NUMBER_OF_DEPENDENTS BENEFIT_DEDUCTION_IND EMPLOYEE_NUMBER_OF_EXEMPTIONS EMPLOYEE_DEPENDENTS_UNDER_19 EMPLOYEE_FILING_STATUS |
This function extracts options 1-5 from pdrdedn based on a specified UID, carrier and effective date. |
| POKODSF.F_GET_END_PDRDEDN_DATE |
|
AP_BENEFIT_DEDUCTION AP_TAX |
EFFECTIVE_END_DATE EFFECTIVE_END_DATE |
This function returns an end date for employee deduction effective date for the specified UID, carrier and effective date. |
| POKODSF.F_GET_FISCAL_QUARTER |
|
AP_EMPLOYEE_EARNING_FY |
QUARTER |
This function returns the appropriate quarter associated with a given month within a fiscal year. |
| POKODSF.F_NEXT_REVIEW_DATE |
|
AP_REVIEW |
NEXT_REVIEW_DATE |
This function returns the next review date for a specified UID, review code and review date. |
| POKODSF.F_QUARTERLY_DEDUCTION_TOTAL |
|
AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION AP_MONTHLY_DEDUCTION |
APPLICABLE_GROSS_QTR1 EMPLOYEE_CONTRIBUTION_QRT3 EMPLOYER_CONTRIBUTION_QTR2 APPLICABLE_GROSS_QTR3 EMPLOYER_CONTRIBUTION_QTR3 APPLICABLE_GROSS_QTR2 EMPLOYEE_CONTRIBUTION_QRT4 EMPLOYER_CONTRIBUTION_QTR1 APPLICABLE_GROSS_QTR4 EMPLOYEE_CONTRIBUTION_QRT1 EMPLOYEE_CONTRIBUTION_QRT2 EMPLOYER_CONTRIBUTION_QTR4 |
|
| RNKNEED.F_CALC_BUDGET_AMT |
|
AR_APPLICANT_NEED |
COST_OF_EDUCATION |
This function returns any non-Pell budget from RBBABUD, if present based upon a specified entity and aid year. If no non-Pell budget exists, it will return the Pell budget instead. |
| RNKNEED.F_CALC_BUDGET_AMT (RORSTAT_PIDM, RORSTAT_AIDY_CODE, 'F') |
|
|
|
|
| RNKNEED.F_CALC_EFC |
|
AR_APPLICANT_NEED |
FM_TFC |
This function calculates the total family contribution from RCRAPP4 and RCRAPP1 for a specified entity and aid year. It uses the federal methodology. |
| RNKNEED.F_CALC_IM_TFC |
|
AR_APPLICANT_NEED |
IM_TFC |
This function calculates the total family contribution from RCRAPP2 and RCRAPP1 for a specified entity and aid year. It uses the institutional methodology. |
| RNKNEED.F_CALC_NEED_DATA |
|
AR_APPLICANT_NEED AR_APPLICANT_NEED AR_APPLICANT_NEED AR_APPLICANT_NEED |
FM_GROSS_NEED FM_UNMET_NEED IM_GROSS_NEED IM_UNMET_NEED |
This function calculates either the unmet or gross need for a specified entity and aid year. It uses either the federal methodology or the institutional methodology based upon which is specified. |
| RNKNEED.F_CALC_RESOURCE |
|
AR_APPLICANT_NEED |
RESOURCE_AMOUNT |
This function formulates the resource amount for a specified entity and aid year by adding exemptions, contracts and other resources. |
| ROKODSF.F_CALCULATE_DISB_AMTS |
|
AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND AR_FINAID_FUND |
FEDERAL_LOAN_DISBURSED STATE_GRANT_DISBURSED FEDERAL_SCHOLARSHIP_DISBURSED INST_WORK_DISBURSED OTHER_WORK_DISBURSED OTHER_GRANT_DISBURSED STATE_LOAN_DISBURSED FEDERAL_GRANT_DISBURSED INST_GRANT_DISBURSED FEDERAL_WORK_DISBURSED INST_LOAN_DISBURSED OTHER_SCHOLARSHIP_DISBURSED INST_SCHOLARSHIP_DISBURSED OTHER_LOAN_DISBURSED STATE_SCHOLARSHIP_DISBURSED |
This function retrieves the displays the actual disbursed amount of the FUND indicated in this record for the student. |
| ROKODSF.F_GET_CALC_DISBURSE_AMT |
|
AR_LOAN_DISBURSEMENT |
CALC_EXPECTED_DISBURSEMENT_AMT |
|
| ROKODSF.F_GET_CIPC_DESC |
|
AR_AWARD_BY_PERSON |
PROGRAM_CLASS_OVR_DESC |
|
| ROKODSF.F_GET_COMMENT_DESC |
|
AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_ISIR_SPEC |
COMMENT15_DESC COMMENT4_DESC COMMENT18_DESC COMMENT20_DESC COMMENT7_DESC COMMENT9_DESC COMMENT11_DESC COMMENT2_DESC COMMENT3_DESC COMMENT8_DESC COMMENT17_DESC COMMENT16_DESC COMMENT1_DESC COMMENT6_DESC COMMENT10_DESC COMMENT12_DESC COMMENT13_DESC COMMENT19_DESC COMMENT14_DESC COMMENT5_DESC |
|
| ROKODSF.F_GET_FINAID_PROC_YEAR |
|
AR_FINAID_ENROLLMENT AR_SATISFACTORY_ACAD_PROGRESS |
AID_YEAR AID_YEAR |
|
| ROKODSF.F_GET_PCKG_LOAD_IND |
|
AR_AWARD_BY_PERSON |
AWARD_LOAD_MISMATCH_IND |
This function retrieves a 'Y' or 'N' for a given person, aid year and term code. This function returns a 'Y' if a persons has a record in RPRATRM where the package load indicator does not exist in the RPRADSB table. |
| ROKODSF.F_GET_RORMVAL_DESC |
|
|
|
|
| ROKODSF.F_GET_RORMVAL_DESC( RPRLAPP_LOAN_TYPE,RPRLAPP_AIDY_CODE, RPRLAPP_INFC_CODE,RPRLAPP_LOAN_TYPE) |
|
|
|
|
| ROKODSF.F_GET_TOTAL_DISBURSED |
|
|
|
|
| ROKODSF.F_SUM_CALC_STUD_ADJ_HRS |
|
AR_AWARD_BY_PERSON |
CALC_STUDENT_ADJ_CREDITS |
This function retrieves the sum of adjusted hours from the student course registration table for a given person and aid enrollment period by passing all terms associated to the aid enrollmennt period to the function ROKODSF.F_CALC_STUD_ADJ_HRS. |
| ROKODSF.F_SUM_CALC_STUD_BILL_HRS |
|
AR_AWARD_BY_PERSON |
CALC_STUDENT_BILLING_HOURS |
Calculates a students billing hrs from course registration table (sfrstcr) where the course is not excluded and not listed in course sections unavailable for aid (rorsect) for a given person and aid enrollment period by passing all terms associated to the aid enrollmennt period to the function ROKODSF.F_CALC_STUD_BILL_HRS. |
| ROW_NUMBER() OVER (PARTITION BY DRIVER.PERSON_UID ORDER BY DRIVER.POST_SECONDARY_DEGREE_DATE DESC NULLS LAST, DRIVER.AWARD_CATEGORY DESC NULLS LAST, DRIVER.POST_SECONDARY_ATTEND_FROM DESC N |
|
|
|
|
| ROW_NUMBER() OVER (PARTITION BY SORLCUR_PIDM, SGBSTDN_TERM_CODE_EFF ORDER BY SORLCUR_PRIORITY_NO) |
|
|
|
This Oracle analytic function assigns a unique number to each current and active curriculum for the student and academic period, beginning with 1. |
| SB_CURRICULUM.F_FIND_CURRENT_ALL_IND |
This function set the current and acitive indicators on the curriculum record. |
|
|
SUBSTR(SB_CURRICULUM.F_FIND_CURRENT_ALL_IND( SORLCUR_PIDM, SORLCUR_LMOD_CODE, SORLCUR_TERM_CODE, SORLCUR_KEY_SEQNO, SORLCUR_PRIORITY_NO, SORLCUR_SEQNO, SGBSTDN_TERM_CODE_EFF),1,1) |
| SELECT DISTINCT(SUBSTR(FISCAL_PERIOD1, 63)) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE |
|
|
|
|
| SELECT DISTINCT(SUBSTR(FISCAL_YEAR,1,63) ) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE = PAF_TRANSACTION_STATUS |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'ACCOUNT_POSTING_STATUS' AND VALUE = AP.ACCOUNT_POSTING_STATUS |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'DIRECT_PAYMENT_TYPE' AND VALUE = AP.DIRECT_PAYMENT_TYPE |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'DURATION_DESIGNATION' AND VALUE = F.DURATION_DESIGNATION |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_ACTUAL_TIME_STATUS' AND VALUE = F.FMLA_ACTUAL_TIME_STATUS |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_SCHEDULE_TIME_STATUS' AND VALUE = F.FMLA_SCHEDULE_TIME_STATUS |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_UNIT' AND VALUE = F.FMLA_UNIT |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_YEAR_TYPE' AND VALUE = F.FMLA_YEAR_TYPE |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'MILITARY_RECIPROCAL_TYPE' AND VALUE = F.MILITARY_RECIPROCAL_TYPE |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'MILITARY_RELATE_TYPE' AND VALUE = F.MILITARY_RELATE_TYPE |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS' AND VALUE =PAF_APPLY_STATUS |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS'AND VALUE =PAF_APPLY_STATUS |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE |
|
|
|
|
| SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255)FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE |
|
|
|
|
| SELECT SUBSTR(FISCAL_PERIOD,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE |
|
|
|
|
| SELECT SUBSTR(FISCAL_YEAR,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'PRIMARY_FUNCTION' AND VALUE = A.PRIMARY_FUNCTION |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'ENCUMBRANCE_TYPE' AND VALUE = ENCUMBRANCE_TYPE |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRBEVNG_BEG_DATE_IND' AND VALUE = BEGIN_EVENT_RULE |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRBEVNG_FREQ_IND' AND VALUE = EVENT_FREQUENCY |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRREVNG_STATUS_IND' AND VALUE = GRANT_EVENT_STATUS |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRVEVNT_TYPE_IND' AND VALUE = GRANT_EVENT_TYPE |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_DOCUMENT_BOX' AND VALUE = TAX_DOCUMENT_BOX_NUMBER |
|
|
|
Hard coded values are stored in MGT_VALIDATION for TAX_DOCUMENT_BOX |
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_NOTIFICATION_STATUS' AND VALUE = FEDERAL_REPORT_STATUS |
|
|
|
|
| SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_NOTIFICATION_STATUS' AND VALUE = NOTIFICATION_STATUS |
|
|
|
|
| SELECT COUNT(*) COUNT_NO FROM MST_STUDENT_COURSE_GRADE_CHG WHERE PERSON_UID = PERSON_IN AND ACADEMIC_PERIOD = ACADEMIC_PERIOD_IN AND COURSE_REFERENCE_NUMBER = COURSE_REFERENCE_NUMBER_IN AND NVL( MIF_VALUE, DEF_MULT |
|
|
|
|
| SELECT'Y' TUITION_DEPOSITED_IND FROM MTT_AR_DEPOSIT WHERE ACCOUNT_UID = PERSON_IN AND ACADEMIC_PERIOD = ACADEMIC_PERIOD_IN -- AND DEPOSIT_TYPE ='TUI' AND NVL(MIF_VALUE, DEF_MULTI_SOURCE_IN) = MULTI_SRC_IN |
|
|
|
|
| SGKCLAS.F_CLASS_CODE |
|
|
|
This packaged function is created to allow student classification to be retrieved for ad-hoc reporting. |
| SOKODSF.F_ADMS_CHECK_STATUS |
|
AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION |
INST_ACCEPTED_CURRENT_IND APPL_ACCEPT_CURRENT_IND INST_ADMIT_ANY_TIME_IND INST_DENIED_IND APPL_ACCEPT_ANY_TIME_IND |
|
| SOKODSF.F_BUILD_PREREQ_PARSE |
|
AS_COURSE_PREREQ |
PREREQUISITE_TEXT |
This function retrieves all columns from the SCRRTST table for a given subject, course number and effective academic period. |
| SOKODSF.F_CALCULATE_AGE_ADMIT |
|
AS_LEARNER_CURRICULUM_FOS AS_CURRICULUM |
AGE_ADMITTED AGE_ADMITTED |
This function returns the hours attempted for a PIDM, history term, and optional CEU indicator. |
| SOKODSF.F_CALC_HISTORY_HOURS |
|
AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY |
TOTAL_CREDITS TOTAL_NON_CEU_CREDITS TOTAL_CEU_CREDITS |
This function returns the hours attempted for a PIDM, history term, and optional CEU indicator. |
| SOKODSF.F_CALC_SEASONS_USED |
|
|
|
|
| SOKODSF.F_CALC_TRANSFER_CREDITS |
|
AS_PREVIOUS_EDUCATION_PCOL |
TOTAL_TRANSFER_CREDITS |
This function calculates the total transfer credits SUM(SHRTRCE_CREDIT_HOURS) by transfer institution for the person for the given UID and institution. |
| SOKODSF.F_CHECK_FOR_ACAD_HISTORY_DATA |
|
AS_ENROLLMENT |
ACADEMIC_HISTORY_EXISTS_IND |
This function returns a Y/N indicator that indicates if Academic History (SHRTTRM) data exists based on the PIDM and TERM parameters passed. |
| SOKODSF.F_CHECK_FOR_GRADUATE_IND |
|
|
|
This function returns a Y/N indicator if the student has graduated previous to this term by having a award status on their SHRDGMR record with a term completed greater than the given academic period. |
| SOKODSF.F_CLASS_CALC_FNC |
|
|
|
|
| SOKODSF.F_COUNT_COMPLETED_OUTCOMES |
|
AS_GENERAL_STUDENT |
ACAD_OUTCOME_COMPLETED_COUNT |
This function counts SHRDGMR records with an awarded status for a given UID where the award status is A. |
| SOKODSF.F_ENROLLED_THIS_TERM |
|
|
|
|
| SOKODSF.F_GET_BANNER_PIDM |
|
|
|
Function extracts the Banner Pidm from spriden using a passed user_id as the spriden_id. |
| SOKODSF.F_GET_COURSE_DATES |
|
AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS |
FINALIZED_COMPLETION_DATE END_DATE START_DATE FINALIZED_COMPLETION_DATE |
This function returns the start and/or end dates of the registered class for a given UID, academic period, course and subacademic period. |
| SOKODSF.F_GET_COURSE_EXTENSIONS |
|
AS_STUDENT_COURSE_IN_PROGRESS |
EXTENSIONS |
This function returns the number of extensions a student has been granted to complete the class for a given term and crn. |
| SOKODSF.F_GET_CRSE_LONG_TITLE |
|
AS_STUDENT_COURSE_IN_PROGRESS AS_MEETING_TIME |
COURSE_TITLE_LONG TITLE_LONG_DESC |
This function returns the long title for a specified academic period and course. |
| SOKODSF.F_GET_CURR_VETC_CODE |
|
AS_ENROLLMENT AS_ENROLLMENT_HISTORY |
VETERAN_TYPE VETERAN_TYPE |
This function returns the most current veterans code SGRVETN_VETC_CODE for the specified UID. |
| SOKODSF.F_GET_DEGREE_GPA_DATA |
|
AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME AS_ACADEMIC_OUTCOME |
A
ANSFER_GPA">TRANSFER_GPA CREDITS_EARNED CREDITS_ATTEMPTED
|
|
| SOKODSF.F_GET_END_COHORT_TERM |
|
AS_STUDENT_COHORT |
ACADEMIC_PERIOD_END |
This function returns the end term SGRCHRT_TERM_CODE_EFF for the students cohort for the given UID and effective date. |
| SOKODSF.F_GET_END_SCBCRSE_TERM |
|
AS_COURSE_CATALOG |
ACADEMIC_PERIOD_END |
This function returns the end term SCBCRSE_EFF_TERM for the course catalog for the specified subject, course number and effective term. |
| SOKODSF.F_GET_END_SCBSUPP_TERM |
|
AS_COURSE_SUPPLEMENTAL |
ACADEMIC_PERIOD_END |
This function returns the end term SCBSUPP_EFF_TERM for the course supplemental information for the specified subject, course number and effective term. |
| SOKODSF.F_GET_END_SCRCORQ_TERM |
|
AS_COURSE_COREQ |
ACADEMIC_PERIOD_END |
This function returns the end term SCRCORQ_EFF_TERM for a course co-requisite for the specified subject, course number and effective term. |
| SOKODSF.F_GET_END_SCRGMOD_TERM |
|
AS_OFFERING_GRADE_MODE |
ACADEMIC_PERIOD_END |
This function returns the end term SCRGMOD_EFF_TERM for course grade type for the specified subject, course number and effective term. |
| SOKODSF.F_GET_END_SCRLEVL_TERM |
|
AS_COURSE_LEVEL |
ACADEMIC_PERIOD_END |
This function returns the end term SCRLEVL_EFF_TERM for course level for the specified subject, course number and effective term. |
| SOKODSF.F_GET_END_SCRRTST_TERM |
|
AS_COURSE_PREREQ AS_COURSE_SCHEDULE |
ACADEMIC_PERIOD_END ACADEMIC_PERIOD_END |
This function returns the end term SCRRTST_TERM_CODE_EFF for a course prerequisite for the specified subject, course number and effective term. |
| SOKODSF.F_GET_END_SGBSTDN_TERM |
|
AS_GENERAL_STUDENT AS_LEARNER_CURRICULUM_FOS |
ACADEMIC_PERIOD_END ACADEMIC_PERIOD_END |
This function returns the end term SGBSTDN_TERM_CODE_EFF for the student for the given UID and effective date. |
| SOKODSF.F_GET_END_SGRADVR_TERM |
|
AS_COURSE_ATTRIBUTE AS_ADVISOR |
ACADEMIC_PERIOD_END ACADEMIC_PERIOD_END |
This function returns the end term SGRADVR_TERM_CODE_EFF for the students advisor for the given UID. |
| SOKODSF.F_GET_END_SGRSATT_TERM |
|
AS_STUDENT_ATTRIBUTE |
ACADEMIC_PERIOD_END |
This function returns the end term SGRSATT_TERM_CODE_EFF for course attributes for the specified UID and effective date. |
| SOKODSF.F_GET_END_SIBINST_TERM |
|
AS_FACULTY |
ACADEMIC_PERIOD_END |
This function returns the end term SIBINST_TERM_CODE_EFF for a faculty member for the specified UID and effective date. |
| SOKODSF.F_GET_END_SIRATTR_TERM |
|
AS_FACULTY_ATTRIBUTE |
ACADEMIC_PERIOD_END |
This function returns the end term SIRATTR_TERM_CODE_EFF for a faculty members attributes for the specified UID and effective date. |
| SOKODSF.F_GET_END_SIRDPCL_TERM |
|
AS_FACULTY_DEPARTMENT_COLLEGE |
ACADEMIC_PERIOD_END |
This function retrieves the end term associated with the effective term for the faculty department and college. |
| SOKODSF.F_GET_END_SIRICNT_TERM |
|
AS_FACULTY_CONTRACT |
ACADEMIC_PERIOD_END |
This function returns the end term SIRICNT_TERM_CODE_EFF for faculty member for the specified UID and effective date. |
| SOKODSF.F_GET_ENROLL_CENSUS_IND |
|
AS_ENROLLMENT_HISTORY AS_ENROLLMENT AS_ENROLLMENT AS_ENROLLMENT_HISTORY |
ENROLL_CENSUS_DATE2_IND ENROLL_CENSUS_DATE2_IND ENROLL_CENSUS_DATE1_IND ENROLL_CENSUS_DATE1_IND |
|
| SOKODSF.F_GET_SCBCRSE_LONG_TITLE |
|
AS_COURSE_CATALOG |
TITLE_LONG_DESC |
|
| SOKODSF.F_GET_SORCONC_DATA |
|
AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE |
FIRST_CONCENTRATION_DESC FOURTH_CONCENTRATION_DESC SECOND_CONCENTRATION_DESC THIRD_CONCENTRATION THIRD_CONCENTRATION_DESC FIRST_CONCENTRATION FOURTH_CONCENTRATION SECOND_CONCENTRATION |
|
| SOKODSF.F_GET_SORMAJR_DATA |
|
AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_EDUCATION_PCOL |
FIRST_MAJOR THIRD_PROGRAM_CLASSIF_DESC POST_SECONDARY_MAJOR_DESC1 PROGRAM_CLASSIFICATION3 PROGRAM_CLASSIFICATION_DESC2 PROGRAM_CLASSIFICATION_DESC3 FIRST_MAJOR_DESC SECOND_PROGRAM_CLASSIF_DESC THIRD_MAJOR_DESC POST_SECONDARY_MAJOR_DESC3 FOURTH_MAJOR THIRD_PROGRAM_CLASSIFICATION POST_SECONDARY_MAJOR2 POST_SECONDARY_MAJOR3 FOURTH_PROGRAM_CLASSIF_DESC FIRST_PROGRAM_CLASSIFICATION FOURTH_MAJOR_DESC FIRST_PROGRAM_CLASSIF_DESC SECOND_MAJOR_DESC SECOND_PROGRAM_CLASSIFICATION THIRD_MAJOR PROGRAM_CLASSIFICATION2 PROGRAM_CLASSIFICATION_DESC1 FOURTH_PROGRAM_CLASSIFICATION SECOND_MAJOR POST_SECONDARY_MAJOR1 POST_SECONDARY_MAJOR_DESC2 PROGRAM_CLASSIFICATION1 |
|
| SOKODSF.F_GET_SORMINR_DATA |
|
AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE AS_PREVIOUS_DEGREE |
FOURTH_MINOR_DESC SECOND_MINOR THIRD_MINOR_DESC FIRST_MINOR_DESC FOURTH_MINOR THIRD_MINOR FIRST_MINOR SECOND_MINOR_DESC |
|
| SOKODSF.F_REGISTERED_THIS_TERM |
|
|
|
|
| SOKODSF.F_SARAPPD_INFO |
|
AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_APPLICATION |
LATEST_DECISION LATEST_DECISION_DATE |
|
| SOKODSF.F_SCRSYLO_LEARNING_OBJ |
|
AS_COURSE_CATALOG |
LEARNING_OBJECTIVES |
|
| SOKODSF.F_SITE |
|
AS_CURRICULUM AS_CURRICULUM AS_CURRICULUM AS_CURRICULUM AS_CURRICULUM AS_CURRICULUM AS_CURRICULUM AS_CURRICULUM AS_CURRICULUM AS_CURRICULUM |
SITE_NATION SITE_POSTAL_CODE SITE_STREET_LINE1 SITE_STREET_LINE2 SITE_DESC SITE_NATION_DESC SITE_STATE_PROVINCE_DESC SITE_STREET_LINE3 SITE_CITY SITE_STATE_PROVINCE |
|
| SOKODSF.F_SORPCOL_INFO |
|
AS_PRE_STUDENT AS_PRE_STUDENT AS_PRE_STUDENT AS_PRE_STUDENT AS_PRE_STUDENT AS_PRE_STUDENT |
LATEST_POST_SECONDARY_SCHOOL PS_TRANSCRIPT_RECEIVED_DATE PS_ATTEND_FROM_DATE PS_ATTEND_TO_DATE PS_GPA_TRANSFERRED PS_TRANSCRIPT_REVIEWED_DATE |
|
| SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''ASTD'',''C'') |
|
AS_ACADEMIC_STANDING |
ACADEMIC_STANDING |
|
| SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''ASTD'',''D'') |
|
AS_ACADEMIC_STANDING |
ACADEMIC_STANDING_DATE |
|
| SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''CAST'',''C'') |
|
AS_ACADEMIC_STANDING |
COMBINED_ACAD_STANDING |
|
| SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''CAST'',''D'') |
|
AS_ACADEMIC_STANDING |
COMBINED_ACAD_STANDING_DATE |
|
| SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''PREV'',''C'') |
|
AS_ACADEMIC_STANDING |
PROGRESS_EVALUATION |
|
| SOKODSF.F_START_ACAD_STAND_DATA (PIDM, TERM,''PREV'',''D'') |
|
AS_ACADEMIC_STANDING |
PROGRESS_EVALUATION_DATE |
|
| SUBSTR (MAKFUNC.F_DESG_FINAID_FUND_IND |
|
|
|
Determines if the fund is used in an advancement designation. |
| SUM (CURRENT_YTD_ACTIVITY WHEN INTERNAL_ACCOUNT_TYPE = '50') |
|
|
|
|
| SUM (CURRENT_YTD_ACTIVITY WHEN INTERNAL_ACCOUNT_TYPE IN ('60','70', '80')) |
|
|
|
|
| SUM(CASE WHEN INTERNAL_ACCOUNT_TYPE = '50' THEN CURR_YEAR_TO_DATE_ACTIVITY ELSE 0 END) |
|
|
|
|
| SUM(CASE WHEN INTERNAL_ACCOUNT_TYPE IN ( '60','70','80') THEN CURR_YEAR_TO_DATE_ACTIVITY ELSE 0 END) |
|
|
|
|
| SUM(EEC.GROSS) |
|
|
|
|
| SUM(EMPLOYEE_CONTRIBUTION_AMOUNT) |
|
|
|
|
| SUM(EMPLOYER_CONTRIBUTION_AMOUNT) |
|
|
|
|
| SUM(NVL(AMRPEXP_EXPN_AMT, 0)) |
|
AA_CONSTITUENT_CONTACT |
TOTAL_EXPENSE |
|
| SUM(NVL(CURR_BUDGET_ADJUSTMENTS, 0)) |
|
|
|
|
| SUM(NVL(DECODE(FISCAL_PERIOD, FISCAL_PERIOD_IN,CURRENT_ACTUAL,0),0)) |
|
|
|
|
| SUM(NVL(DECODE(SIGN(12-FISCAL_PERIOD),- 1,0,CURRENT_ACTUAL),0)) |
|
|
|
|
| SUM(NVL(DECODE(SIGN(12-FISCAL_PERIOD),- 1,0,SUM_PERIODIC_CREDITS),0)) |
|
|
|
|
| SUM(NVL(DECODE(SIGN(12-FISCAL_PERIOD),- 1,0,SUM_PERIODIC_DEBITS),0)) |
|
|
|
|
| SUM(NVL(DECODE(SIGN(FISCAL_PERIOD- FISCAL_PERIOD_IN),-1,CURRENT_ACTUAL,0), 0) + (NVL(DECODE(FISCAL_PERIOD, FISCAL_PERIOD_IN,CURRENT_ACTUAL,0),0)) |
|
|
|
|
| SUM(NVL(DECODE(SIGN(FISCAL_PERIOD_IN- FISCAL_PERIOD),-1,0,CURRENT_ACTUAL),0)) |
|
|
|
|
| SUM(NVL(DECODE(SIGN(FISCAL_PERIOD_IN- FISCAL_PERIOD),-1,0, SUM_PERIODIC_CREDITS),0)) |
|
|
|
|
| SUM(NVL(DECODE(SIGN(FISCAL_PERIOD_IN- FISCAL_PERIOD),-1,0,SUM_PERIODIC_DEBITS) ,0)) |
|
|
|
|
| SUM(NVL(GL.SUM_YEAR_TO_DATE_ACTIVITY,0)) |
|
|
|
|
| SYSDATE |
|
AE_AUTHORIZATION AE_ACCOUNTING AE_REIMBURSEMENT AE_STATUS_HISTORY |
CURRENT_DATE CURRENT_DATE CURRENT_DATE CURRENT_DATE |
|
| T = TEMPORARY, P = PERMANENT, C = CASUAL AND N = NONE |
|
|
|
|
| TBD |
|
AP_FAMILY_MEDICAL_LEAVE_HIST AP_FAMILY_MEDICAL_LEAVE_HIST AS_FACULTY_FEEDBACK AP_FAMILY_MEDICAL_LEAVE_HIST AP_FAMILY_MEDICAL_LEAVE_HIST AT_APPLICATION_OF_PAYMENT AS_FACULTY_FEEDBACK AP_FAMILY_MEDICAL_LEAVE_HIST AP_FAMILY_MEDICAL_LEAVE_HIST AS_FACULTY_FEEDBACK AN_PERSONNEL_ACTION_GENERAL AP_FAMILY_MEDICAL_LEAVE_HIST AP_FAMILY_MEDICAL_LEAVE_HIST AS_FACULTY_FEEDBACK AT_APPLICATION_OF_PAYMENT |
MILITARY_RELATE_TYPE_DESC FMLA_YEAR_TYPE_DESC STUDENT_MONITOR_IND DURATION_DESIGNATION_DESC FMLA_YEAR ACCOUNT_POSTING_STATUS_DESC FEEDBACK_TYPE_DESC FMLA_SCHEDULE_TIME_STATUS_DESC MILITARY_RECIPROCAL_TYPE_DESC FEEDBACK_ESTIMATED_GRADE_IND PAF_APPLY_STATUS_DESC FMLA_ACTUAL_TIME_STATUS_DESC FMLA_UNIT_DESC FEEDBACK_COMMENT_IND DIRECT_PAYMENT_TYPE_DESC |
|
| TBD?? |
|
|
|
|
| TOKODSF.F_ACCOUNT_BALANCE |
|
|
|
This function returns the account balance from TBRACCD for a specified entity. |
| TOKODSF.F_AMOUNT_PAID |
|
AT_CONTRACT AT_EXEMPTION |
AMOUNT_PAID AMOUNT_PAID |
This function returns the summarized amount SUM(TBRACCD_AMOUNT) for contact or exemption for a specified UID and academic period. |
| TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC |
|
AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION |
CHARGE_ACTIVITY_DESC PAYMENT_ACTIVITY_DESC PAYMENT_ORGANIZATION_DESC CHARGE_ACCOUNT_INDEX_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_CHART_OF_ACCOUNTS_DESC PAYMENT_LOCATION_DESC PAYMENT_PROGRAM_DESC CHARGE_ACCOUNT_DESC CHARGE_CHART_OF_ACCOUNTS_DESC CHARGE_ORGANIZATION_DESC PAYMENT_FUND_DESC CHARGE_FUND_DESC CHARGE_LOCATION_DESC CHARGE_PROGRAM_DESC PAYMENT_ACCOUNT_DESC |
substr(f_get_finance_desc('FTVCOAS',TBRMISD_CHARGE_COAS,NULL,35),1,35) |
| TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS |
|
AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION AT_MISCELLANEOUS_TRANSACTION |
CHARGE_ACCOUNT_STATUS CHARGE_ACTIVITY_STATUS PAYMENT_FUND_STATUS PAYMENT_PROGRAM_STATUS CHARGE_ORGANIZATION_STATUS PAYMENT_ACTIVITY_STATUS CHARGE_LOCATION_STATUS PAYMENT_CHART_STATUS CHARGE_ACCOUNT_INDEX_STATUS PAYMENT_ACCOUNT_STATUS CHARGE_CHART_STATUS CHARGE_FUND_STATUS CHARGE_PROGRAM_STATUS PAYMENT_ACCOUNT_INDEX_STATUS PAYMENT_LOCATION_STATUS PAYMENT_ORGANIZATION_STATUS |
substr(f_get_finance_desc('FTVCOAS',TBRMISD_CHARGE_COAS,NULL,1),1,1) |
| TOKODSF.F_COUNT_COLLECTIONS |
|
AT_ACCOUNT |
COLLECTION_COUNT |
This function return a count of rows existing in the collection table (TBRCOLC) for a UID. |
| TOKODSF.F_COUNT_NSF |
|
|
|
|
| TOKODSF.F_DEPOSIT_BALANCE |
|
|
|
This function calculates the deposit balance for a specified entity by subtracting the TBRACCD_AMOUNT from TBRACCD, where the TBRACCD_SRCE_CODE = D, from the TBRDEPO_AMOUNT. |
| TOKODSF.F_OLDEST_EFFECTIVE_DATE |
|
|
|
This function returns the oldest effective date TBRACCD_EFFECTIVE_DATE based on a specified pidm where the balance is not equal to 0. |
| TOKODSF.F_PLAN_AMOUNT |
|
AT_INSTALLMENT_PLAN |
PLAN_AMOUNT |
This function returns the automated plan amount SUM(TBRACCD_AMOUNT) for the specified UID, reference number and detail code where the source indicator is I. |
| TOKODSF.F_TERM_CODE_TBDS |
|
|
|
This function returns a term-based detail code TBBTBDS_TBDS_CODE designator from TBBTBDS table for a specified academic period. |
| TO_CHAR (PERFMLA_BEGIN_DATE, 'YYYY') |
|
|
|
|
| TO_DATE(MSKFUNC.F_ACADEMIC_STAND_DATA( PERSON_IN, Y.ACADEMIC_PERIOD, LEVEL_IN, 'ACADEMIC_STANDING_END_DT'),'YYYYMMDD') |
|
|
|
|
| TO BE FILLED IN BY DEVELOPER |
|
AA_SOLICITOR_ORG_FUNDRAISER |
PCT_PROG_SOLICITOR_DONOR_GOAL |
|