SGHE Banner Operational Data Store
Composite View Source: FUNCTION - NULL
| Source Column |
Business Definition |
Target |
Target Column |
Calculation Formula |
| DECODE( DFAS.FM_NEED_ELIGIBLE_IND,Y, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE( DFAS.IM_NEED_ELIGIBLE_IND,Y, 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.ENROLL_BY_CENSUS_DATE2_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE( DSS.GRADUATE_CREDIT_ELIG_IND,1, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE( DSS.NEW_STUDENT_IND,1,S.PERSON_UID,NULL) |
|
|
|
|
| DECODE( DSS.REGISTERED_IND,0,S.PERSON_UID,NULL) |
|
|
|
|
| DECODE( DSS.REGISTERED_IND,1,S.PERSON_UID,NULL) |
|
|
|
|
| DECODE( DSS.WITHDRAWN_IND,1,S.PERSON_UID,NULL) |
|
|
|
|
| SUM( COURSE_CREDITS_ATTEMPTED ) TOTAL_CREDITS_ATTM, |
|
|
|
|
| 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( F.COURSE_CREDITS_ATTEMPTED ) CUMULATIVE_CREDITS_ATTEMPTED, |
|
|
|
|
| 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, |
|
|
|
|
| DECODE(YEAR1_EXCLUDE_IND,1, PERSON_IN,NULL) YEAR1_GRAD_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR2_EXCLUDE_IND,1, PERSON_IN,NULL) YEAR2_RET_EXCLUDE_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR2_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR2_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR3_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR3_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR4_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR4_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR5_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR5_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR6_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR6_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR7_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR7_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR8_NOT_RETAINED_IND,1, PERSON_IN,NULL) YEAR8_NOT_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR8_GRADUATION_IND,1, PERSON_IN,NULL) YEAR8_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(DS.HOUSING_IND,Y,S.PERSON_UID, NULL) |
|
|
|
|
| DECODE(NOT_RETAINED_COLLEGE_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_C |
|
|
|
|
| DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_C |
|
|
|
|
| DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_S |
|
|
|
|
| DECODE(YEAR2_GRADUATION_IND,1, PERSON_IN,NULL) YEAR2_GRADUATION_HEADCOUNT |
|
|
|
|
| DECODE(YEAR4_RETAINED_IND,1,PERSON_IN, NULL)YEAR4_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR5_GRADUATION_IND,1, PERSON_IN,NULL) YEAR5_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_RET_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR8_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR8_GRAD_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(DFAS.FM_FULLY_MET_NEED_IND,Y, S.PERSON_UID,NULL) |
|
|
|
|
| DECODE(DSS.ENROLL_BY_CENSUS_DATE1_IND, 1,S.PERSON_UID,NULL) |
|
|
|
|
| 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_PROGRAM_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_P |
|
|
|
|
| DECODE(YEAR1_GRADUATION_IND,1, PERSON_IN,NULL) YEAR1_GRADUATION_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR2_GRAD_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_RETAINED_IND,1,PERSON_IN, NULL)YEAR5_REGISTERED_HEADCOUNT, |
|
|
|
|
| DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN, NULL) YEAR6_GRAD_EXCLUDE_HEADCOUNT |
|
|
|
|
| DECODE(YEAR8_RETAINED_IND,1,PERSON_IN, NULL)YEAR8_REGISTERED_HEADCOUNT, |
|
|
|
|
| SUM(COURSE_CREDITS ) |
|
|
|
|
| SUM(COURSE_CREDITS_EARNED ) TOTAL_CREDITS_EARN, |
|
|
|
|
| (SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_STATUS' AND VALUE =PAF_TRANSACTION_STATUS) |
|
|
|
|
| ??? |
|
|
|
|
| ???? |
|
|
|
|
| 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 |
|
| CALC_SCHEDULE_AMT?? |
|
|
|
|
| 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 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_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 FTVVEND_CARRIER_IND |
|
|
|
|
| CASE WHEN FTVVEND_GROUPING_IND |
|
|
|
|
| CASE WHEN FTVVEND_IN_ST_IND |
|
|
|
|
| CASE WHEN PROPOSAL_RESULT_PLEDGE_NUMBER |
|
|
|
|
| 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 XXXX |
|
|
|
|
| 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.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(FRBEVNG_PMT_METHOD_TYPE_IND) |
|
|
|
|
| DECODE(GOKODSF.F_GET_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_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_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_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_SEQ_HEADCOUNT_P |
|
|
|
|
| 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_SEQ_HEADCOUNT_S |
|
|
|
|
| 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_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_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_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_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_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_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, |
|
|
|
|
| DECODE??? |
|
|
|
|
| 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 AF_GRANT_DEFERRED_COST AE_ACCOUNTING AE_ACCOUNTING AE_ACCOUNTING AF_GRANT_DEFERRED_COST AE_ACCOUNTING AE_ACCOUNTING |
ACCOUNT_INDEX_DESC CHART_OF_ACCOUNTS_DESC PROJECT_DESC CHART_OF_ACCOUNTS_DESC ACCOUNT_INDEX_DESC CHART_OF_ACCOUNTS_DESC PROJECT_DESC CHART_OF_ACCOUNTS_DESC |
|
| FOKODSF.F_GET_FINANCE_STATUS |
|
AF_GRANT_DEFERRED_COST |
CHART_OF_ACCOUNTS_STATUS |
|
| 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 AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_GRANT_PERSONNEL AF_ACCOUNT_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY AF_GRANT_PERSONNEL AF_ACCOUNT_HIERARCHY_FISCAL AF_FUND_HIERARCHY_FISCAL |
CTRL_ACTUAL_ACTIVITY_SEQ_DESC CTRL_BUDGET_ADJUST_SEQ_DESC ACCOUNT_CLASS_DESC CTRL_BUDGET_RESERVE_SEQ_DESC CTRL_TEMPORARY_BUDGET_SEQ_DESC CTRL_ADOPTED_BUDGET_SEQ_DESC CTRL_ENCUMBRANCE_SEQ_DESC PERSONNEL_TYPE_DESC INTERNAL_ACCOUNT_TYPE_DESC INTERNAL_FUND_TYPE_DESC CTRL_ACTUAL_ACTIVITY_SEQ_DESC CTRL_BUDGET_ADJUST_SEQ_DESC ACCOUNT_CLASS_DESC CTRL_BUDGET_RESERVE_SEQ_DESC CTRL_TEMPORARY_BUDGET_SEQ_DESC CTRL_ADOPTED_BUDGET_SEQ_DESC CTRL_ENCUMBRANCE_SEQ_DESC PERSONNEL_TYPE_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 |
|
| FTVORGN_FMGR_CODE_PIDM |
|
|
|
|
| F_CALC_REGISTRATION_HOURS |
|
|
|
|
| F_CALC_TOTAL_BUDGET?? |
|
|
|
|
| F_CLASS_CALC_FNC |
|
|
|
|
| F_ENROLLED_THIS_TERM |
|
|
|
|
| F_FINAID_APPLICANT_IND |
|
|
|
|
| F_FORMAT_NAME |
|
AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK |
INSTRUCTOR_NAME 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_GET_NORM_BALANCE |
|
|
|
|
| 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_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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 AS_ENROLLMENT_WITHDRAWAL AS_FACULTY_FEEDBACK_DETAIL AN_PERSONNEL_ACTION_LABOR_DIST AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_PROJECT AA_SOLICITOR_ASSIGNMENT_RESULT
AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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 AS_ENROLLMENT_WITHDRAWAL AS_FACULTY_FEEDBACK_DETAIL AN_PERSONNEL_ACTION_LABOR_DIST AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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 AS_ENROLLMENT_WITHDRAWAL AS_FACULTY_FEEDBACK_DETAIL AN_PERSONNEL_ACTION_LABOR_DIST AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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 AS_ENROLLMENT_WITHDRAWAL AS_FACULTY_FEEDBACK_DETAIL AN_PERSONNEL_ACTION_LABOR_DIST AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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 AS_ENROLLMENT_WITHDRAWAL AS_FACULTY_FEEDBACK_DETAIL AN_PERSONNEL_ACTION_LABOR_DIST AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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 AS_ENROLLMENT_WITHDRAWAL AS_FACULTY_FEEDBACK_DETAIL AN_PERSONNEL_ACTION_LABOR_DIST AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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 AS_ENROLLMENT_WITHDRAWAL AS_FACULTY_FEEDBACK_DETAIL AN_PERSONNEL_ACTION_LABOR_DIST AA_DESIGNATION AA_PROJECT_INTEREST AA_PROSPECT_PROPOSAL_MASTER AA_SOLICITOR_ASSIGNMENT_RESULT AA_DESIGNATION AF_ORGN_HIERARCHY_FISCAL AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_SOLICITOR_ASSIGNMENT AA_CONSTITUENT_CONTACT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AA_DESIGNATION AA_DESIGNATION AA_PROSPECT_MOVES_MANAGEMENT AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AA_DESIGNATION AS_VETERAN_CERTIFICATION AS_FACULTY_FEEDBACK 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 AS_VETERAN_CERTIFICATION 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 (More Targets -- list too long to display currently.)
|
F
FONT COLOR="#000000" FACE="Arial" SIZE="2">CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR PAYMENT_ACCOUNT_INDEX_DESC PAYMENT_ORGRANIZATION_DESC PLEDGE_ORGRANIZATION_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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 ACADEMIC_YEAR ACADEMIC_YEAR CHART_OF_ACCOUNTS_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC ACADEMIC_YEAR_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC
FONT COLOR="#000000" FACE="Arial" SIZE="2">CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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 ACADEMIC_YEAR ACADEMIC_YEAR CHART_OF_ACCOUNTS_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC ACADEMIC_YEAR_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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 CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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 ACADEMIC_YEAR ACADEMIC_YEAR CHART_OF_ACCOUNTS_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC ACADEMIC_YEAR_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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 ACADEMIC_YEAR ACADEMIC_YEAR CHART_OF_ACCOUNTS_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC ACADEMIC_YEAR_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_DESC PLEDGE_ACTIVITY_DESC PLEDGE_PROGRAM_DESC COMPLETE_DATE_FISCAL_YEAR_DESC EXPEND_FUND_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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 ACADEMIC_YEAR ACADEMIC_YEAR CHART_OF_ACCOUNTS_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC ACADEMIC_YEAR_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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 ACADEMIC_YEAR ACADEMIC_YEAR CHART_OF_ACCOUNTS_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC ACADEMIC_YEAR_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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_
FONT COLOR="#000000" FACE="Arial" SIZE="2">CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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 ACADEMIC_YEAR ACADEMIC_YEAR CHART_OF_ACCOUNTS_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC ACADEMIC_YEAR_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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 ACADEMIC_YEAR ACADEMIC_YEAR CHART_OF_ACCOUNTS_DESC PAYMENT_ACTIVITY_DESC PROJECT_STATUS_DESC PROPOSAL_STATUS_DESC SOLICITOR_ORGANIZATION_NAME EXPEND_ORGRANIZATION_DESC FMGR_ADDRESS_TYPE_DESC ACADEMIC_YEAR_DESC PLEDGE_FUND_DESC SOLICITATION_TYPE_DESC CONTACT_DATE_FISCAL_YEAR_DESC EXPEND_ACCOUNT_INDEX_DESC EXPEND_ACTIVITY_DESC GIFT_ORGRANIZATION_DESC ACADEMIC_PERIOD_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 VETERAN_TYPE_DESC ACADEMIC_YEAR 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 ACADEMIC_YEAR 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_
|
|
| GOKODSF.F_GET_DESC(CASE WHEN FTVVEND_VEND_CHECK_PIDM IS NULL) |
|
|
|
|
| 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_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_LEDGER_ENCUMBERED_AMOUNT |
|
|
|
|
| MFKFUNC.F_GET_LEDGER_REMAINING_BALANCE |
|
|
|
|
| MFKFUNC.F_GET_VENDOR_FIELDS |
|
|
|
|
| MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS |
|
|
|
|
| MGKFUNC.F_GET_PERSON_INFO |
|
|
|
|
| MGKFUNC.F_SPLIT_FIELDS |
|
|
|
|
| MGKFUNC.F_SPLIT_FIELDS_ID? |
|
|
|
|
| MPKFUNC.F_GET_EMPL_POSITION_INFO |
|
|
|
|
| MPKFUNC.F_GET_PERSONNEL_ACTION_IND |
|
|
|
|
| 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_ENROLL_WITHDRAW_DATE |
|
|
|
|
| MSKFUNC.F_CHECK_COOP_IND |
|
|
|
|
| MSKFUNC.F_COUNT_ADDRESSES |
|
|
|
|
| MSKFUNC.F_COUNT_ADVISORS |
|
|
|
|
| MSKFUNC.F_COUNT_COHORTS |
|
|
|
|
| MSKFUNC.F_COUNT_HOLDS |
|
|
|
|
| MSKFUNC.F_COUNT_SPORTS |
|
|
|
|
| MSKFUNC.F_COUNT_STUDENT_COURSE_ATTR |
|
|
|
|
| MSKFUNC.F_COUNT_TELEPHONES |
|
|
|
|
| MSKFUNC.F_DEGR_ENROLLED_IND |
|
|
|
|
| MSKFUNC.F_GET_OUTCOME_AWARDED_IND |
|
|
|
|
| NOKODSF.F_GET_PAF_COMMENT_COUNT |
|
AN_PERSONNEL_ACTION |
PAF_COMMENT_COUNT |
|
| NVL(APBCONS_PREF_FIRST_NAME, SPBPERS_PREF_FIRST_NAME) |
|
|
|
|
| POKODSF.F_GET_COVERAGE_OPTION |
|
|
|
|
| RCRAPP1_SEQ_NO |
|
|
|
|
| ROKODSF.F_GET_RORMVAL_DESC( RPRLAPP_LOAN_TYPE,RPRLAPP_AIDY_CODE, RPRLAPP_INFC_CODE,RPRLAPP_LOAN_TYPE) |
|
|
|
|
| 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_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 = '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 |
|
|
|
|
| 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 |
|
|
|
|
| SGKCLAS.F_CLASS_CODE |
|
|
|
|
| SOKODSF.F_CALCULATE_AGE_ADMIT |
|
|
|
|
| SOKODSF.F_CHECK_FOR_GRADUATE_IND |
|
|
|
|
| SOKODSF.F_COUNT_COMPLETED_OUTCOMES |
|
|
|
|
| SOKODSF.F_GET_ASTD_DEFAULT |
|
|
|
|
| SOKODSF.F_GET_CAST_DEFAULT |
|
|
|
|
| SOKODSF.F_GET_PREV_DEFAULT |
|
|
|
|
| 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 |
|
| TBD |
|
E
E="2">AP_FAMILY_MEDICAL_LEAVE_HIST AP_FAMILY_MEDICAL_LEAVE_HIST AN_PERSONNEL_ACTION_GENERAL AT_APPLICATION_OF_PAYMENT AP_FAMILY_MEDICAL_LEAVE_HIST AP_FAMILY_MEDICAL_LEAVE_HIST AT_APPLICATION_OF_PAYMENT AP_FAMILY_MEDICAL_LEAVE_HIST AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK
|
>
>FEEDBACK_TYPE_DESC FMLA_SCHEDULE_TIME_STATUS_DESC FMLA_YEAR_TYPE_DESC STUDENT_MONITOR_IND FMLA_UNIT_DESC MILITARY_RECIPROCAL_TYPE_DESC PAF_APPLY_STATUS_DESC DIRECT_PAYMENT_TYPE_DESC FMLA_ACTUAL_TIME_STATUS_DESC FMLA_YEAR ACCOUNT_POSTING_STATUS_DESC DURATION_DESIGNATION_DESC FEEDBACK_COMMENT_IND FEEDBACK_ESTIMATED_GRADE_IND
|
|
| TBD?? |
|
|
|
|
| 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_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 |
|
|
|
|