SGHE Banner Operational Data Store
Composite View Source: FUNCTION - NULL
| Source Column |
Business Definition |
Target |
Target Column |
Calculation Formula |
| ACTIVE_HOLD_IND |
|
|
|
|
| AOKODSF.F_GET_PROJ_ASSIGN_PROS_IND( AMRPROP_PIDM, AMRPROP_PROJ_CODE) |
|
AA_PROSPECT_PROPOSAL_PROJECT |
PROJECT_ASSIGNED_PROSPECT_IND |
|
| AOKODSF.F_GET_STAFF_INDICATOR |
|
AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_STAFF_ASSIGNMENT |
PROPOSAL_STAFF_IND PLAN_MANAGER_IND CONTACT_STAFF_IND PROSPECT_STAFF_IND |
|
| CASE WHEN ACADEMIC_TIME_KEY = ACADEMIC_TIME_KET THEN ACADEMIC_STUDY_KEY ELSE 0 |
|
|
|
|
| CASE WHEN AMRINFO_SYS_IND |
|
AA_PROSPECT_INFO |
PROSPECT_AMOUNT_METHOD_DESC |
|
| CASE WHEN BIRTH_DATE IS NULL THEN NULL WHEN TRUNC(MONTH_BETWEEN)<23 THEN 1 ELSE 0 |
|
|
|
|
| CASE WHEN CHANGED_MAJOR_COUNT>0 THEN ACADEMIC_STUDY_CHANGE_IND = 1 ELSE 0 |
|
|
|
|
| CASE WHEN FTVACCT_DATA_ENTRY_IND |
|
AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY |
DATA_ENTRY_PERMITTED_DESC DATA_ENTRY_PERMITTED_DESC |
|
| CASE WHEN FTVFUND_DATA_ENTRY_IND |
|
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY |
DATA_ENTRY_PERMITTED_DESC DATA_ENTRY_PERMITTED_DESC |
|
| CASE WHEN FTVORGN_DATA_ENTRY_IND |
|
AF_ORGN_HIERARCHY_FISCAL AF_ORGANIZATION_HIERARCHY |
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 SSRMEET_OVER_RIDE |
|
|
|
|
| CASE WHEN VETERAN_TYPE <> MTVPARM_DESC AND VETERAN_CATEGORY <> 0 THEN 1 ELSE 0 |
|
|
|
|
| CASE WHEN VISA_TYPE <> MTVPARM_DESC AND DEMOGRAPHIC_KEY <> 0 THEN 1 ELSE 0 |
|
|
|
|
| COUNT(*) FROM WFT_STUDENT_COURSE |
|
|
|
|
| DECODE(DFAS.FM_FULLY_MET_NEED_IND,Y, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DFAS.FM_FULLY_MET_NEED_IND,Y, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DFAS.FM_NEED_ELIGIBLE_IND,Y, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DFAS.FM_NEED_ELIGIBLE_IND,Y, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DFAS.IM_NEED_ELIGIBLE_IND,Y, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DS.HOUSING_IND,Y,S.PERSON_UID, NULL) |
|
|
|
|
| DECODE(DS.HOUSING_IND,Y,S.PERSON_UID, NULL) |
|
|
|
|
| DECODE(DSS.ACAD_HISTORY_EXISTS_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.ACAD_HISTORY_EXISTS_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.COOP_ED_PARTICIPANT_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.COOP_ED_PARTICIPANT_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.ENROLLED_IND,1,S.PERSON_UID, NULL) |
|
|
|
|
| DECODE(DSS.ENROLLED_IND,1,S.PERSON_UID, NULL) |
|
|
|
|
| DECODE(DSS.ENROLL_BY_CENSUS_DATE1_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.ENROLL_BY_CENSUS_DATE1_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.ENROLL_BY_CENSUS_DATE2_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.ENROLL_BY_CENSUS_DATE2_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.GRADUATE_CREDIT_ELIG_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.GRADUATE_CREDIT_ELIG_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.MATRICULATED_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.MATRICULATED_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.NEW_STUDENT_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.NEW_STUDENT_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.PERMIT_REGISTRATION_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.REGISTERED_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.REGISTERED_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.WITHDRAWN_IND,1,S.PERSON_UID, NULL) |
|
|
|
|
| DECODE(DSS.WITHDRAWN_IND,1,S.PERSON_UID, NULL) |
|
|
|
|
| DECODE(FOKODSF.F_GET_REST_IND) |
|
AF_FUND_HIERARCHY_FISCAL |
FUND_BALANCE_RESTRICTION_DESC |
|
| DECODE(MST_RACE.RACE_CATEGORY) |
|
|
|
|
| DECODE(NOT_RETAINED_COLLEGE_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_C |
|
|
|
|
| DECODE(NOT_RETAINED_COLLEGE_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_C |
|
|
|
|
| DECODE(NOT_RETAINED_OVERALL_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_HEADCOUNT |
|
|
|
|
| DECODE(NOT_RETAINED_OVERALL_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT |
|
|
|
|
| DECODE(NOT_RETAINED_PROGRAM_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_P |
|
|
|
|
| DECODE(NOT_RETAINED_PROGRAM_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_P |
|
|
|
|
| DECODE(NOT_RETAINED_STDLEVL_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_S, |
|
|
|
|
| DECODE(NOT_RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_S |
|
|
|
|
| DECODE(RETAINED_COLLEGE_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_C |
|
|
|
|
| DECODE(RETAINED_COLLEGE_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_C |
|
|
|
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_C |
|
|
|
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_P |
|
|
|
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_SXCLUDE_HEADC OUNT_S |
|
|
|
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_C |
|
|
|
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_P |
|
|
|
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_S |
|
|
|
|
| DECODE(RETAINED_PROGRAM_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_P |
|
|
|
|
| DECODE(RETAINED_PROGRAM_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_P |
|
|
|
|
| DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_S |
|
|
|
|
| DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_S |
|
|
|
|
| DECODE(STVRESD_IN_STATE_IND) |
|
|
|
|
| DECODE(YEAR1_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR1_GRAD_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR1_GRADUATION_IND,1,PERSON_IN, NULL) YEAR1_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR1_RETAINED_IND,1,PERSON_IN, NULL) |
|
|
|
|
| DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR2_GRAD_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR2_RET_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR2_GRADUATION_IND,1,PERSON_IN, NULL) YEAR2_GRADUATION_HEADCOUNT |
|
|
|
|
| DECODE(YEAR2_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR2_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR2_RETAINED_IND,1,PERSON_IN, NULL) YEAR2_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR3_GRAD_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR3_RET_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR3_GRADUATION_IND,1,PERSON_IN, NULL) YEAR3_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR3_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR3_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR3_RETAINED_IND,1,PERSON_IN, NULL)YEAR3_REGISTERED_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(YEAR4_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR4_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR4_RETAINED_IND,1,PERSON_IN, NULL)YEAR4_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR5_GRAD_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR5_RET_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR5_GRADUATION_IND,1,PERSON_IN, NULL) YEAR5_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR5_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR5_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR5_RETAINED_IND,1,PERSON_IN, NULL)YEAR5_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_GRAD_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_RET_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR6_GRADUATION_IND,1,PERSON_IN, NULL) YEAR6_GRADUATION_HEADCOUNT |
|
|
|
|
| DECODE(YEAR6_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR6_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR6_RETAINED_IND,1,PERSON_IN, NULL)YEAR6_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR7_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR7_GRAD_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR7_EXCLUDE_IND,1,PERSON_IN, NULL)YEAR7_RET_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR7_GRADUATION_IND,1,PERSON_IN, NULL) YEAR7_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR7_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR7_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR7_RETAINED_IND,1,PERSON_IN, NULL)YEAR7_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR8_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR8_GRAD_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR8_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR8_RET_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR8_GRADUATION_IND,1,PERSON_IN, NULL) YEAR8_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR8_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR8_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR8_RETAINED_IND,1,PERSON_IN, NULL)YEAR8_REGISTERED_HEADCOUNT, |
|
|
|
|
| FOFYCNV |
|
AF_LOCATION_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL |
FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR |
|
| FOFYCNV(FTVFSPD_FSYR_CODE) |
|
AF_FISCAL_PERIOD |
FISCAL_YEAR |
|
| FOKODSF.F_GET_ACCT_HIER |
|
AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL |
ACCOUNT_DESC_1 ACCOUNT_LEVEL_3 ACCOUNT_STATUS_2 ACCOUNT_DESC_2 ACCOUNT_STATUS_1 ACCOUNT_STATUS_3 ACCOUNT_DESC_3 ACCOUNT_LEVEL_2 ACCOUNT_STATUS_4 ACCOUNT_LEVEL_4 ACCOUNT_DESC_4 ACCOUNT_LEVEL_1 ACCOUNT_DESC_1 ACCOUNT_LEVEL_3 ACCOUNT_STATUS_2 ACCOUNT_DESC_2 ACCOUNT_STATUS_1 ACCOUNT_STATUS_3 ACCOUNT_DESC_3 ACCOUNT_LEVEL_2 ACCOUNT_STATUS_4 ACCOUNT_LEVEL_4 ACCOUNT_DESC_4 ACCOUNT_LEVEL_1 |
|
| FOKODSF.F_GET_FINANCE_DESC |
|
AE_ACCOUNTING AE_ACCOUNTING AE_ACCOUNTING AE_ACCOUNTING AE_ACCOUNTING AE_ACCOUNTING |
ACCOUNT_INDEX_DESC PROJECT_DESC CHART_OF_ACCOUNTS_DESC ACCOUNT_INDEX_DESC PROJECT_DESC CHART_OF_ACCOUNTS_DESC |
|
| FOKODSF.F_GET_FUND_HIER |
|
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_FISCAL 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_FISCAL 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_FISCAL 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_FISCAL AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL |
FUND_DESC_4 FUND_LEVEL_3 FUND_DESC_5 FUND_LEVEL_5 FUND_DESC_1 FUND_LEVEL_1 FUND_LEVEL_4 FUND_STATUS_4 FUND_LEVEL_2 FUND_STATUS_1 FUND_STATUS_2 FUND_DESC_2 FUND_DESC_3 FUND_STATUS_3 FUND_STATUS_5 FUND_DESC_4 FUND_LEVEL_3 FUND_DESC_5 FUND_LEVEL_5 FUND_DESC_1 FUND_LEVEL_1 FUND_LEVEL_4 FUND_STATUS_4 FUND_LEVEL_2 FUND_STATUS_1 FUND_STATUS_2 FUND_DESC_2 FUND_DESC_3 FUND_STATUS_3 FUND_STATUS_5 |
|
| FOKODSF.F_GET_LOCN_HIER |
|
AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL AF_LOCATION_HIERARCHY_FISCAL |
LOCATION_DESC_2 LOCATION_STATUS_3 LOCATION_LEVEL_2 LOCATION_STATUS_4 LOCATION_DESC_3 LOCATION_DESC_4 LOCATION_DESC_5 LOCATION_STATUS_2 LOCATION_LEVEL_1 LOCATION_STATUS_1 LOCATION_LEVEL_3 LOCATION_STATUS_5 LOCATION_DESC_1 LOCATION_LEVEL_4 LOCATION_LEVEL_5 LOCATION_DESC_2 LOCATION_STATUS_3 LOCATION_LEVEL_2 LOCATION_STATUS_4 LOCATION_DESC_3 LOCATION_DESC_4 LOCATION_DESC_5 LOCATION_STATUS_2 LOCATION_LEVEL_1 LOCATION_STATUS_1 LOCATION_LEVEL_3 LOCATION_STATUS_5 LOCATION_DESC_1 LOCATION_LEVEL_4 LOCATION_LEVEL_5 |
|
| FOKODSF.F_GET_ORGN_HIER |
|
I
ISCAL_COMP_target.html">AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL
|
C
CAL_COMP_target.html#ORGANIZATION_DESC_2">ORGANIZATION_DESC_2 ORGANIZATION_DESC_4 ORGANIZATION_LEVEL_1 ORGANIZATION_LEVEL_8 ORGANIZATION_LEVEL_6 ORGANIZATION_LEVEL_2 ORGANIZATION_STATUS_8 ORGANIZATION_STATUS_5 ORGANIZATION_DESC_1 ORGANIZATION_DESC_3 ORGANIZATION_DESC_7 ORGANIZATION_DESC_8 ORGANIZATION_LEVEL_5 ORGANIZATION_STATUS_3 ORGANIZATION_DESC_6 ORGANIZATION_STATUS_1
|
|
| FOKODSF.F_GET_PROG_HIER |
|
AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL |
PROGRAM_LEVEL_2 PROGRAM_LEVEL_5 PROGRAM_DESC_4 PROGRAM_LEVEL_1 PROGRAM_LEVEL_3 PROGRAM_DESC_2 PROGRAM_STATUS_3 PROGRAM_LEVEL_4 PROGRAM_STATUS_4 PROGRAM_DESC_1 PROGRAM_STATUS_1 PROGRAM_STATUS_2 PROGRAM_DESC_3 PROGRAM_DESC_5 PROGRAM_STATUS_5 PROGRAM_LEVEL_2 PROGRAM_LEVEL_5 PROGRAM_DESC_4 PROGRAM_LEVEL_1 PROGRAM_LEVEL_3 PROGRAM_DESC_2 PROGRAM_STATUS_3 PROGRAM_LEVEL_4 PROGRAM_STATUS_4 PROGRAM_DESC_1 PROGRAM_STATUS_1 PROGRAM_STATUS_2 PROGRAM_DESC_3 PROGRAM_DESC_5 PROGRAM_STATUS_5 |
|
| FOKODSF.F_GET_REST_IND |
|
AF_FUND_HIERARCHY_FISCAL |
FUND_BALANCE_RESTRICTION |
|
| FOKODSF.F_GET_SDAT_TITLE |
|
AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL |
ACCOUNT_CLASS_DESC INTERNAL_ACCOUNT_TYPE_DESC INTERNAL_FUND_TYPE_DESC ACCOUNT_CLASS_DESC INTERNAL_ACCOUNT_TYPE_DESC INTERNAL_FUND_TYPE_DESC |
|
| FRKIDEN.F_GET_FRBGRNT_STATUS_CODE |
|
AF_FUND_HIERARCHY_FISCAL |
GRANT_STATUS |
|
| FRKIDEN.F_GET_FRBGRNT_TITLE |
|
AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL |
GRANT_DESC GRANT_DESC |
|
| F_CALC_REGISTRATION_HOURS |
|
|
|
|
| F_CLASS_CALC_FNC |
|
|
|
|
| F_ENROLLED_THIS_TERM |
|
|
|
|
| F_FINAID_APPLICANT_IND |
|
|
|
|
| F_FORMAT_NAME |
|
|
|
|
| F_GET_FINANCE_DESC |
|
AF_FISCAL_PERIOD AF_LOCATION_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL AF_PROGRAM_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY_FISCAL AF_ORGN_HIERARCHY_FISCAL |
CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC FUND_POOL_DESC ORGANIZATION_POOL_DESC CHART_OF_ACCOUNTS_DESC ACCOUNT_POOL_DESC CHART_OF_ACCOUNTS_DESC CHART_OF_ACCOUNTS_DESC |
|
| F_GET_FINANCE_STATUS |
|
|
|
|
| F_HOUS_THIS_TERM |
|
|
|
|
| F_INQUIRER_FNC |
|
|
|
|
| F_INST_AID_FNC |
|
|
|
|
| F_LEVEL_ADMITTED_FNC |
|
|
|
|
| F_LEVEL_APPL_FNC |
|
|
|
|
| F_PAID_ADMISSIONS_DEPOSIT |
|
|
|
|
| F_PROSPECT_FNC |
|
|
|
|
| F_REGISTERED_THIS_TERM |
|
|
|
|
| GOKODSF.F_DIRECT_DEPOSIT_IND |
|
AE_PROFILE |
DIRECT_DEPOSIT_IND |
|
| GOKODSF.F_GET_DESC |
|
<
AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORG_FUNDRAISER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORG_FUNDRAISER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORG_FUNDRAISER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORG_FUNDRAISER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORG_FUNDRAISER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORG_FUNDRAISER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_MASTER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORG_FUNDRAISER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORG_FUNDRAISER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ORGANIZATION AA_DESIGNATION AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORG_FUNDRAISER AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT AA_DESIGNATION
|
_
_DESC">PLEDGE_PROGRAM_DESC COMPLETE_DATE_FISCAL_YEAR_DESC EXPEND_FUND_DESC PAYMENT_ACCOUNT_DESC PLEDGE_ACCOUNT_INDEX_DESC EXPEND_LOCATION_DESC EXPEND_PROGRAM_DESC GIFT_FUND_DESC GIFT_PROGRAM_DESC PAYMENT_CHART_OF_ACCOUNTS_DESC PLANNED_MOVE_FISCAL_YEAR_DESC PLEDGE_ACCOUNT_DESC PROPOSAL_PROJECT_DESC PROPOSAL_PROJECT_STATUS_DESC SOLICITATION_TYPE_DESC SOLICITOR_ADDRESS_TYPE_DESC GIFT_CHART_OF_ACCOUNTS_DESC PLEDGE_LOCATION_DESC PROPOSAL_DESC STAFF_TYPE_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ORGRANIZATION_DESC SOLICITOR_ORGANIZATION_NAME START_DATE_FISCAL_YEAR_DESC START_DATE_FISCAL_YEAR_DESC COLLEGE_DESC EXPEND_ACCOUNT_DESC EXPEND_CHART_OF_ACCOUNTS_DESC GIFT_ACCOUNT_INDEX_DESC GIFT_LOCATION_DESC GIVING_VEHICLE_DE
_DESC">PLEDGE_PROGRAM_DESC COMPLETE_DATE_FISCAL_YEAR_DESC EXPEND_FUND_DESC PAYMENT_ACCOUNT_DESC PLEDGE_ACCOUNT_INDEX_DESC EXPEND_LOCATION_DESC EXPEND_PROGRAM_DESC GIFT_FUND_DESC GIFT_PROGRAM_DESC PAYMENT_CHART_OF_ACCOUNTS_DESC PLANNED_MOVE_FISCAL_YEAR_DESC PLEDGE_ACCOUNT_DESC PROPOSAL_PROJECT_DESC PROPOSAL_PROJECT_STATUS_DESC SOLICITATION_TYPE_DESC SOLICITOR_ADDRESS_TYPE_DESC GIFT_CHART_OF_ACCOUNTS_DESC PLEDGE_LOCATION_DESC PROPOSAL_DESC STAFF_TYPE_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ORGRANIZATION_DESC SOLICITOR_ORGANIZATION_NAME START_DATE_FISCAL_YEAR_DESC START_DATE_FISCAL_YEAR_DESC COLLEGE_DESC EXPEND_ACCOUNT_DESC EXPEND_CHART_OF_ACCOUNTS_DESC GIFT_ACCOUNT_INDEX_DESC GIFT_LOCATION_DESC GIVING_VEHICLE_DESC PAYMENT_FUND_DESC PAYMENT_LOCATION_DESC PAYMENT_PROGRAM_DESC PLEDGE_CHART_OF_ACCOUNTS_DESC PROJECT_GIVING_VEHICLE_DESC CONTACT_ADDRESS_TYPE_DESC GIFT_ACTIVITY_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC PLEDGE_ACTIVITY_DESC PLEDGE_PROGRAM_DESC COMPLETE_DATE_FISCAL_YEAR_DESC EXPEND_FUND_DESC PAYMENT_ACCOUNT_DESC PLEDGE_ACCOUNT_INDEX_DESC EXPEND_LOCATION_DESC EXPEND_PROGRAM_DESC GIFT_FUND_DESC GIFT_PROGRAM_DESC PAYMENT_CHART_OF_ACCOUNTS_DESC PLANNED_MOVE_FISCAL_YEAR_DESC PLEDGE_ACCOUNT_DESC PLEDGE_PROGRAM_DESC COMPLETE_DATE_FISCAL_YEAR_DESC EXPEND_FUND_DESC PAYMENT_ACCOUNT_DESC PLEDGE_ACCOUNT_INDEX_DESC EXPEND_LOCATION_DESC EXPEND_PROGRAM_DESC GIFT_FUND_DESC GIFT_PROGRAM_DESC PAYMENT_CHART_OF_ACCOUNTS_DESC PLANNED_MOVE_FISCAL_YEAR_DESC PLEDGE_ACCOUNT_DESC PROPOSAL_PROJECT_DESC PROPOSAL_PROJECT_STATUS_DESC SOLICITATION_TYPE_DESC SOLICITOR_ADDRESS_TYPE_DESC GIFT_CHART_OF_ACCOUNTS_DESC PLEDGE_LOCATION_DESC PROPOSAL_DESC STAFF_TYPE_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ORGRANIZATION_DESC SOLICITOR_ORGANIZATION_NAME START_DATE_FISCAL_YEAR_DESC START_DATE_FISCAL_YEAR_DESC COLLEGE_DESC EXPEND_ACCOUNT_DESC EXPEND_CHART_OF_ACCOUNTS_DESC GIFT_ACCOUNT_INDEX_DESC GIFT_LOCATION_DESC GIVING_VEHICLE_DESC PAYMENT_FUND_DESC PAYMENT_LOCATION_DESC PAYMENT_PROGRAM_DESC PLEDGE_CHART_OF_ACCOUNTS_DESC PROJECT_GIVING_VEHICLE_DESC CONTACT_ADDRESS_TYPE_DESC GIFT_ACTIVITY_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC PLEDGE_ACTIVITY_DESC PLEDGE_PROGRAM_DESC COMPLETE_DATE_FISCAL_YEAR_DESC EXPEND_FUND_DESC PAYMENT_ACCOUNT_DESC PLEDGE_ACCOUNT_INDEX_DESC EXPEND_LOCATION_DESC EXPEND_PROGRAM_DESC GIFT_FUND_DESC GIFT_PROGRAM_DESC PAYMENT_CHART_OF_ACCOUNTS_DESC PLANNED_MOVE_FISCAL_YEAR_DESC PLEDGE_ACCOUNT_DESC PROPOSAL_PROJECT_DESC PROPOSAL_PROJECT_STATUS_DESC SOLICITATION_TYPE_DESC SOLICITOR_ADDRESS_TYPE_DESC GIFT_CHART_OF_ACCOUNTS_DESC PLEDGE_LOCATION_DESC PROPOSAL_DESC STAFF_TYPE_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ORGRANIZATION_DESC SOLICITOR_ORGANIZATION_NAME START_DATE_FISCAL_YEAR_DESC START_DATE_FISCAL_YEAR_DESC COLLEGE_DESC EXPEND_ACCOUNT_DESC EXPEND_CHART_OF_ACCOUNTS_DESC GIFT_ACCOUNT_INDEX_DESC GIFT_LOCATION_DESC GIVING_VEHICLE_DESC PAYMENT_FUND_DESC PAYMENT_LOCATION_DESC PAYMENT_PROGRAM_DESC PLEDGE_CHART_OF_ACCOUNTS_DESC PROJECT_GIVING_VEHICLE_DESC CONTACT_ADDRESS_TYPE_DESC GIFT_ACTIVITY_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRA
_DESC">PLEDGE_PROGRAM_DESC COMPLETE_DATE_FISCAL_YEAR_DESC EXPEND_FUND_DESC PAYMENT_ACCOUNT_DESC PLEDGE_ACCOUNT_INDEX_DESC EXPEND_LOCATION_DESC EXPEND_PROGRAM_DESC GIFT_FUND_DESC GIFT_PROGRAM_DESC PAYMENT_CHART_OF_ACCOUNTS_DESC PLANNED_MOVE_FISCAL_YEAR_DESC PLEDGE_ACCOUNT_DESC PROPOSAL_PROJECT_DESC PROPOSAL_PROJECT_STATUS_DESC SOLICITATION_TYPE_DESC SOLICITOR_ADDRESS_TYPE_DESC GIFT_CHART_OF_ACCOUNTS_DESC PLEDGE_LOCATION_DESC PROPOSAL_DESC STAFF_TYPE_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ORGRANIZATION_DESC SOLICITOR_ORGANIZATION_NAME START_DATE_FISCAL_YEAR_DESC START_DATE_FISCAL_YEAR_DESC COLLEGE_DESC EXPEND_ACCOUNT_DESC EXPEND_CHART_OF_ACCOUNTS_DESC GIFT_ACCOUNT_INDEX_DESC GIFT_LOCATION_DESC GIVING_VEHICLE_DESC PAYMENT_FUND_DESC PAYMENT_LOCATION_DESC PAYMENT_PROGRAM_DESC PLEDGE_CHART_OF_ACCOUNTS_DESC PROJECT_GIVING_VEHICLE_DESC CONTACT_ADDRESS_TYPE_DESC GIFT_ACTIVITY_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC PLEDGE_ACTIVITY_DESC PLEDGE_PROGRAM_DESC COMPLETE_DATE_FISCAL_YEAR_DESC EXPEND_FUND_DESC PAYMENT_ACCOUNT_DESC PLEDGE_ACCOUNT_INDEX_DESC EXPEND_LOCATION_DESC EXPEND_PROGRAM_DESC GIFT_FUND_DESC GIFT_PROGRAM_DESC PAYMENT_CHART_OF_ACCOUNTS_DESC PLANNED_MOVE_FISCAL_YEAR_DESC PLEDGE_ACCOUNT_DESC PROPOSAL_PROJECT_DESC PROPOSAL_PROJECT_STATUS_DESC SOLICITATION_TYPE_DESC SOLICITOR_ADDRESS_TYPE_DESC GIFT_CHART_OF_ACCOUNTS_DESC PLEDGE_LOCATION_DESC PROPOSAL_DESC STAFF_TYPE_DESC GIFT_ACCOUNT_DESC PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ORGRANIZATION_DESC SOLICITOR_ORGANIZATION_NAME START_DATE_FISCAL_YEAR_DESC START_DATE_FISCAL_YEAR_DESC COLLEGE_DESC EXPEND_ACCOUNT_DESC EXPEND_CHART_OF_ACCOUNTS_DESC GIFT_ACCOUNT_INDEX_DESC GIFT_LOCATION_DESC GIVING_VEHICLE_DESC PAYMENT_FUND_DESC PAYMENT_LOCATION_DESC PAYMENT_PROGRAM_DESC PLEDGE_CHART_OF_ACCOUNTS_DESC PROJECT_GIVING_VEHICLE_DESC CONTACT_ADDRESS_TYPE_DESC GIFT_ACTIVITY_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC PLEDGE_ACTIVITY_DESC PLEDGE_PROGRAM_DESC COMPLETE_DATE_FISCAL_YEAR_DESC EXPEND_FUND_DESC PAYMENT_ACCOUNT_DESC PLEDGE_ACCOUNT_INDEX_DESC EXPEND_LOCATION_DESC EXPEND_PROGRAM_DESC GIFT_FUND_DESC GIFT_PROGRAM_DESC PAYMENT_CHART_OF_ACCOUNTS_DESC PLANNED_MOVE_FISCAL_YEAR_DESC PLEDGE_ACCOUNT_DESC PROPOSAL_PROJECT_DESC PROPOSAL_PROJECT_STATUS_DESC SOLICITATION_TYPE_DESC SOLICITOR_ADDRESS_TYPE_DESC GIFT_CHART_OF_ACCOUNTS_DESC PLEDGE_LOCATION_DESC PROPOSAL_DESC STAFF_TYPE_DESC GIFT_ACCOUNT_DESC
|
|
| GOKODSF.F_TRIM_LONGS |
|
AA_CON_ENTITY_CONF_COMMENT AA_DESIGNATION_COMMENT AA_PROSPECT_CONF_COMMENT |
CONSTITUENT_COMMENT DESIGNATION_COMMENT PROSPECT_COMMENT |
|
| 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_GD_COUNT |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_OUTRIGHT_GIFTS |
|
|
|
|
| MAKFUNC.F_CAMP_SOL_OUTRIGHT_GIFT_COUNT |
|
|
|
|
| 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 |
|
|
|
|
| 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 |
|
|
|
|
| MAKFUNC.F_CAMP_TOTAL_PLEDGES |
|
|
|
|
| MAKFUNC.F_DESG_CAMP_GIFT_COUNT |
|
|
|
|
| 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_PROP_ACT_PROJ_AMNT( M.PROPOSAL, M.PROPOSAL_SEQUENCE_NUMBER) |
|
|
|
|
| MAKFUNC.F_GET_PROP_ACT_PROJ_CNT( M.PROPOSAL, M.PROPOSAL_SEQUENCE_NUMBER) |
|
|
|
|
| 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_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_PROS_ASSIGNED_COUNT |
|
|
|
|
| MAKFUNC.F_PROS_COMPLETED_MOVE_COUNT |
|
|
|
|
| MAKFUNC.F_PROS_CONTACTED_COUNT |
|
|
|
|
| MAKFUNC.F_PROS_PLANNED_MOVES_COUNT |
|
|
|
|
| MAKFUNC.F_PROS_UNASSIGNED_COUNT |
|
|
|
|
| MAKFUNC.F_PROS_UNPLANNED_MOVE_COUNT |
|
|
|
|
| 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 |
|
|
|
|
| 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_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') |
|
|
|
|
| MGKFUNC.F_GET_PERSON_INFO |
|
|
|
|
| MGKFUNC.F_SPLIT_FIELDS |
|
|
|
|
| MGKFUNC.F_SPLIT_FIELDS_ID? |
|
|
|
|
| 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. |
| MSKFUNC.F_CHECK_COOP_IND |
|
|
|
|
| MSKFUNC.F_COUNT_ADVISORS |
|
|
|
|
| MSKFUNC.F_COUNT_COHORTS |
|
|
|
|
| MSKFUNC.F_COUNT_HOLDS |
|
|
|
|
| MSKFUNC.F_COUNT_SPORTS |
|
|
|
|
| MSKFUNC.F_DEGR_ENROLLED_IND |
|
|
|
|
| MSKFUNC.F_GET_OUTCOME_AWARDED_IND |
|
|
|
|
| NVL(APBCONS_PREF_FIRST_NAME, SPBPERS_PREF_FIRST_NAME) |
|
|
|
|
| POKODSF.F_GET_COVERAGE_OPTION |
|
|
|
|
| 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(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 = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS |
|
|
|
|
| SGKCLAS.F_CLASS_CODE |
|
|
|
|
| SOKODSF.F_CALCULATE_AGE_ADMIT |
|
|
|
|
| SOKODSF.F_CHECK_FOR_GRADUATE_IND |
|
|
|
|
| SOKODSF.F_COUNT_COMPLETED_OUTCOMES |
|
|
|
|
| SUM(COURSE_CREDITS ) |
|
|
|
|
| SUM(COURSE_CREDITS_ATTEMPTED ) TOTAL_CREDITS_ATTM, |
|
|
|
|
| SUM(COURSE_CREDITS_EARNED ) TOTAL_CREDITS_EARN, |
|
|
|
|
| SUM(COURSE_CREDITS_FOR_GPA ) TOT_CRED_GPA |
|
|
|
|
| SUM(COURSE_CREDITS_PASSED ) TOTAL_CREDITS_PASS, |
|
|
|
|
| SUM(FINAL_GRADE_QUALITY_POINTS ) FINAL_GRD_QLTY_PNTS, |
|
|
|
|
| SUM(NVL(AMRPEXP_EXPN_AMT, 0)) |
|
AA_CONSTITUENT_CONTACT |
TOTAL_EXPENSE |
|
| SYSDATE |
|
AE_REIMBURSEMENT AE_STATUS_HISTORY AE_AUTHORIZATION AE_ACCOUNTING |
CURRENT_DATE CURRENT_DATE CURRENT_DATE CURRENT_DATE |
|
| CASE WHEN (INGRP1.ATVCFAE_TYPE >= 1 AND INGRP1.ATVCFAE_TYPE < 12) THEN 'CURRENT OPERATIONS' WHEN ( INGRP1.ATVCFAE_TYPE IN (20,21,32)) THEN 'CAPITAL PURPOSES' WHEN (INGRP1.ATVCFAE_TYPE >= 22 AND INGRP1.ATVCFAE_TYPE < 32) THEN 'ENDOWMENT RESTRICTED' END |
|
|
|
|
| CASE WHEN (INGRP1.ATVCFAE_TYPE >= 1 AND INGRP1.ATVCFAE_TYPE < 12) THEN'CURRENT OPERATIONS' WHEN ( INGRP1.ATVCFAE_TYPE IN (20,21,32)) THEN'CAPITAL PURPOSES' WHEN (INGRP1.ATVCFAE_TYPE >= 22 AND INGRP1.ATVCFAE_TYPE < 32) THEN'ENDOWMENT RESTRICTED' END |
|
|
|
|
| CASE WHEN INGRP1.ADRFUND_DESG = INGRP1.ADBDESG_DESG THEN 1 ELSE 0 END |
|
|
|
|
| CASE WHEN INGRP1.ADRFUND_DESG = INGRP1.ADBDESG_DESG THEN YES ELSE NO END |
|
|
|
|
| SUM(F.COURSE_CREDITS_ATTEMPTED ) CUMULATIVE_CREDITS_ATTEMPTED, |
|
|
|
|
| SUM(F.COURSE_CREDITS_EARNED ) CUMULATIVE_CREDITS_EARNED, |
|
|
|
|
| SUM(F.COURSE_CREDITS_FOR_GPA ) CUMULATIVE_CREDITS_FOR_GPA |
|
|
|
|
| SUM(F.COURSE_CREDITS_PASSED ) CUMULATIVE_CREDITS_PASSED, |
|
|
|
|
| SUM(F.FINAL_GRADE_QUALITY_POINTS ) CUMULATIVE_QUALITY_POINTS, |
|
|
|
|
| TO BE FILLED IN BY DEVELOPER |
|
AA_SOLICITOR_ORG_FUNDRAISER AA_SOLICITOR_ORG_FUNDRAISER |
PCT_PROG_SOLICITOR_DONOR_GOAL PCT_PROG_SOLICITOR_DONOR_GOAL |
|
| TO BE FILLED IN BY DEVELOPER FROM AA_PROSPECT_MOVES_MANAGEMENT |
|
|
|
|