RETURN TO COMMON META DATA REPORTS |
| Source Name | Data Element | Mapped Target | Mapped Target Column |
|---|---|---|---|
| FUNCTION | 2ND FUNCTION? | RELATED_COMBINED_NAME |
|
| FUNCTION | 3RD FUNCTION? | RELATED_COMBINED_NAME |
|
| FUNCTION | ? | PRIMARY_PROGRAM_IND POST_CODE_ADMIT PRIMARY_PROGRAM_IND BENEFICIARY_NAME PRIOR_YEAR_ACTUAL PRIOR_YEAR_BUDGET PENDING_LETTER_IND CROSS_REFERENCE_COUNT DEGREE_COUNT DONOR_CATEGORY_COUNT EMPLOYMENT_COUNT EXCLUSION_COUNT EXTERNAL_SOURCE_COUNT MAIL_COUNT SPECIAL_ACTIVITY_COUNT SPECIAL_PURPOSE_GROUP_COUNT STAFF_ASSIGNED_COUNT PERSON_FULL_NAME COURSE_IDENTIFICATION GRADE_TYPE_COUNT REPEATABLE_COURSE_IND COURSE_IDENTIFICATION EMPLOYEE_EARNING_COUNT LEAVE_COUNT PROFILE_YEAR REVIEW_COUNT QUARTER CHART_OF_ACCOUNTS LABOR_COST_DISTRIBUTION_COUNT POSITION_LABOR_DIST_COUNT SUPERVISOR_COMBINED_PHONE AR_CHRGS_ACCEPTANCE_IND ASSESSMENT_DATE CONTINUING_EDUCATION_IND CURRENT_TIME_STATUS CURRENT_TIME_STATUS_DATE CURRENT_TIME_STATUS_DESC DEANS_LIST_DATE DEANS_LIST_DESC DEANS_LIST_VALUE ENROLLED_IND GRADUATED_IND PROSPECT_IND REGISTERED_IND PERSON_FULL_NAME GIFT_AUXILIARY_COUNT MATCHING_GIFT_COUNT SOLICITOR_COUNT EMPLOYMENT_HISTORY_COUNT HR_APPLICATION_STATUS_COUNT INTERVIEW_COUNT REFERENCE_COUNT SKILL_COUNT DONOR_CATEGORY_COUNT FUND_COUNT MOST_RECENT_GIFT_NUMBER MOST_RECENT_PLEDGE_NUMBER FULL_NAME_FMIL SALUTATIONS_COUNT MATCHING_PLEDGE_COUNT PLEDGE_BALANCE SOLICITOR_COUNT INTERESTS_COUNT POST_SECONDARY_SCHOOL_COUNT SECONDARY_SCHOOL_COUNT SECONDARY_SUBJECT_COUNT PREF_GEOGRAPHIC_REGION_COUNT NSF_COUNTER TELEPHONE_COUNT SOURCE_COUNT RELATED_COMBINED_NAME RELATION_TYPE_IND COURSE_IDENTIFICATION GENERATED_CREDITS GRADE_TYPE_COUNT INSTRUCTOR_COUNT MEETING_TIME_COUNT OFFERING_COREQ_COUNT OFFERING_PREREQ_COUNT GIFT_PLEDGE_IND CONTINUING_EDUCATION_IND PROSPECT_IND RESIDENCY_IND SPORT_COUNT TOTAL_BILLING TOTAL_CEU_BILLING TOTAL_CEU_CREDITS TOTAL_CREDITS TOTAL_NON_CEU_BILLING TOTAL_NON_CEU_CREDITS COURSE_ATTRIBUTES_COUNT ORDER_FROM_PHONE_COMBINED REMIT_TO_PHONE_NUMBER_COMBINED |
|
| FUNCTION | DECODE | COSIGN1_RELATIONSHIP_DESC COSIGN2_RELATIONSHIP_DESC GENDER_DESC |
|
| FUNCTION | F_ACCOUNT_BALANCE | ACCOUNT_BALANCE |
|
| FUNCTION | F_ACTIVE_COUIRSE_IND | ACTIVE_COURSE_IND |
|
| FUNCTION | F_ACTIVE_SECTION_IND | ACTIVE_OFFERING_IND |
|
| FUNCTION | F_ADMS_APPLICANT_WITHDRAW | APPLICANT_WITHDRAWN_IND |
|
| FUNCTION | F_ADMS_APPLICATION_STATUS | COMPLETE_IND INCOMPLETE_IND |
|
| FUNCTION | F_ADMS_CHECK_STATUS | APPLICANT_DECLINED_IND APPL_ACCEPT_ANY_TIME_IND APPL_ACCEPT_CURRENT_IND CONFIRMED_IND DEFERRED_IND INST_ACCEPTED_CURRENT_IND INST_ADMIT_ANY_TIME_IND INST_DENIED_IND |
|
| FUNCTION | F_AMOUNT_DUE | CURRENT_AMOUNT_DUE |
|
| FUNCTION | F_APPLIED_FOR_DEGREE | APPLIED_FOR_OUTCOME_IND |
|
| FUNCTION | F_BVL_AMT_FNC | CURR_ADOPTED_BUDGET CURR_BUDGET_ADJUSTMENTS CURR_BUDGET_RESERVATION CURR_ENCUMBRANCES CURR_PERCENT_AVAILABLE CURR_REALLOCATED_BUDGET CURR_REMAINING_BALANCE CURR_YEAR_TO_DATE_ACTV |
|
| FUNCTION | F_CALC_COST_OF_ED | COST_OF_EDUCATION |
|
| FUNCTION | F_CALC_FM_GROSS_NEED | FM_GROSS_NEED |
|
| FUNCTION | F_CALC_FM_TFC | FM_TFC |
|
| FUNCTION | F_CALC_FM_UNMET_NEED | FM_UNMET_NEED |
|
| FUNCTION | F_CALC_IM_GROSS_NEED | IM_GROSS_NEED |
|
| FUNCTION | F_CALC_IM_TFC | IM_TFC |
|
| FUNCTION | F_CALC_IM_UNMET_NEED | IM_UNMET_NEED |
|
| FUNCTION | F_CALC_RESOURCE | RESOURCE_AMOUNT |
|
| FUNCTION | F_CALC_STUD_ADJ_HRS | CALC_STUDENT_ADJ_CREDITS |
|
| FUNCTION | F_CALC_TOTAL_BUDGET | TOTAL_BUDGET |
|
| FUNCTION | F_CALC_TOTAL_OFFER | TOTAL_OFFER_AMOUNT |
|
| FUNCTION | F_CAMPAIGN_GIVING | CAMPAIGN_GIVING |
|
| FUNCTION | F_CAMPAIGN_MATCHING_GIFT | AMOUNT_MATCHING_GIFT |
|
| FUNCTION | F_CAMPAIGN_MEMO_CREDIT | AMOUNT_MEMO_CREDIT |
|
| FUNCTION | F_CHECK_FOR_COURSE_COREQS | COURSE_COREQ_COUNT |
|
| FUNCTION | F_CHECK_FOR_COURSE_PREREQS | COURSE_PREREQS_COUNT |
|
| FUNCTION | F_CHECK_FOR_TRANSFER_WORK | TRANSFER_WORK_EXISTS_IND |
|
| FUNCTION | F_CLASS_FNC | GRADUATED_IND STUDENT_CLASSIFICATION |
|
| FUNCTION | F_CONCAT_OP_AMTS | CURRENT_ADOPTED_BUDGET CURRENT_BUDGET CURRENT_BUDGET_ADJUSTMENTS CURRENT_YTD_ACTIVITY PRIOR_YTD_ACTIVITY |
|
| FUNCTION | F_COUNT_ADDRESSES | ADDRESS_COUNT ADDRESS_COUNT ADDRESS_COUNT ADDRESS_COUNT ADDRESS_COUNT ADDRESS_COUNT |
|
| FUNCTION | F_COUNT_ADVISORS | ADVISOR_COUNT ADVISOR_COUNT |
|
| FUNCTION | F_COUNT_COMPLETED_OUTCOMES | ACAD_OUTCOME_COMPLETED_COUNT |
|
| FUNCTION | F_COUNT_GEOGRAPHIC_REGIONS | GEOGRAPHIC_REGION_COUNT GEOGRAPHIC_REGION_COUNT GEOGRAPHIC_REGION_COUNT GEOGRAPHIC_REGION_COUNT GEOGRAPHIC_REGION_COUNT GEOGRAPHIC_REGION_COUNT GEOGRAPHIC_REGION_COUNT |
|
| FUNCTION | F_COUNT_HOLDS | HOLD_COUNT HOLD_COUNT HOLD_COUNT |
|
| FUNCTION | F_COUNT_TELEPHONES | PHONE_COUNT PHONE_COUNT PHONE_COUNT PHONE_COUNT PHONE_COUNT |
|
| FUNCTION | F_COUNT_TESTS | TEST_COUNT |
|
| FUNCTION | F_DEGR_ENROLLED_IND | ACADEMIC_OUTCOME_ENROLLED_IND |
|
| FUNCTION | F_DEPOSIT_BALANCE | DEPOSIT_BALANCE |
|
| FUNCTION | F_DESIGNATION_GIVING | DESIGNATION_GIVING |
|
| FUNCTION | F_DESIGNATION_MATCHING_GIFT | AMOUNT_MATCHING_GIFT |
|
| FUNCTION | F_DESIGNATION_MEMO_CREDIT | AMOUNT_MEMO_CREDIT |
|
| FUNCTION | F_DISPOSITION_IND | STATUS_DISPOSITION STATUS_DISPOSITION_DESC |
|
| FUNCTION | F_DONOR_IND | DONOR_IND DONOR_IND |
|
| FUNCTION | F_ENROLLED_THIS_TERM | ENROLLED_IND |
|
| FUNCTION | F_EPSCCODE | ENRL_PLANNING_SERVICE ENRL_PLANNING_SERVICE ENRL_PLANNING_SERVICE ENRL_PLANNING_SERVICE ENRL_PLANNING_SERVICE ENRL_PLANNING_SERVICE |
|
| FUNCTION | F_FACULTY_ADVISING_IND | ADVISING_THIS_PERIOD_IND |
|
| FUNCTION | F_FACULTY_SCHEDULED_IND | SCHEDULED_THIS_PERIOD_IND |
|
| FUNCTION | F_FINAID_APPLICANT_IND | FIN_AID_APPLICANT_IND FIN_AID_APPLICANT_IND |
|
| FUNCTION | F_FORMAT_NAME | PRIMARY_ADVISOR_NAME_FMIL PRIMARY_ADVISOR_NAME_LFMI FULL_NAME_LFMI |
|
| FUNCTION | F_GET_COST_ACCT | TRANSACTION_TYPE |
|
| FUNCTION | F_GET_DEGREE_GPA_DATA | CREDITS_EARNED CREDITS_PASSED GPA GPA_CREDITS QUALITY_POINTS |
|
| FUNCTION | F_GET_DEGREE_GPA_DATA | CREDITS_ATTEMPTED |
|
| FUNCTION | F_GET_END_SIRDPCL_TERM | ACAD_STANDING_ACAD_PERIOD_DESC |
|
| FUNCTION | F_GET_PCKG_LOAD_IND | AWARD_LOAD_MISMATCH_IND |
|
| FUNCTION | F_GET_PREF_ADDRESS_ROWID | ADDRESS_TYPE |
|
| FUNCTION | F_GET_SPONSOR_ACCT | SPONSOR_ACCOUNT SPONSOR_ACCOUNT_DESC |
|
| FUNCTION | F_GET_SPRIDEN_FIRST_NAME | PRINCIPAL_INVESTIGATOR_FNAME |
|
| FUNCTION | F_GET_SPRIDEN_ID | AGENCY_NUMBER PRINCIPAL_INVESTIGATOR_ID |
|
| FUNCTION | F_GET_SPRIDEN_LAST_NAME | AGENCY_NAME PRINCIPAL_INVESTIGATOR_LNAME |
|
| FUNCTION | F_GET_SPRIDEN_MI | PRINCIPAL_INVESTIGATOR_MNAME |
|
| FUNCTION | F_GRADUATED_FROM_INSTITUTION | GRADUATED_IND |
|
| FUNCTION | F_HIGH_GIFT_AMOUNT_YEAR | HIGHEST_GIFT_AMOUNT HIGHEST_GIFT_AMOUNT_DATE |
|
| FUNCTION | F_HIGH_PLEDGE_AMOUNT_YEAR | HIGHEST_PLEDGE_AMOUNT |
|
| FUNCTION | F_HOUS_THIS_TERM | HOUSING_IND HOUSING_IND |
|
| FUNCTION | F_INQUIRER_FNC | INQUIRER_IND INQUIRER_IND |
|
| FUNCTION | F_INST_AID_FNC | ACADEMIC_YEAR INST_AID_RECIPIENT_IND ACADEMIC_YEAR INST_AID_RECIPIENT_IND |
|
| FUNCTION | F_INTERVIEWER_NAME | INTERVIEWER_NAME |
|
| FUNCTION | F_LEVEL_ADMITTED_FNC | ADMIT_IND ADMIT_IND |
|
| FUNCTION | F_LEVEL_APPL_FNC | APPLICANT_IND APPLICANT_IND |
|
| FUNCTION | F_LIFE_GIFT_SOCIETY | LIFE_GIFT_SOCIETY LIFE_GIFT_SOCIETY_TYPE LIFE_GIFT_SOCIETY LIFE_GIFT_SOCIETY_TYPE |
|
| FUNCTION | F_LIFE_TOTAL_COMMITMENT | LIFE_TOTAL_COMMITMENT LIFE_TOTAL_COMMITMENT |
|
| FUNCTION | F_LIFE_TOTAL_GIVING | LIFE_TOTAL_GIVING LIFE_TOTAL_GIVING |
|
| FUNCTION | F_LIFE_TOTAL_PLEDGED_AMOUNT | LIFE_TOTAL_PLEDGE_AMT LIFE_TOTAL_PLEDGE_AMT |
|
| FUNCTION | F_LIFE_TOTAL_PLEDGE_PAYMENT | LIFE_TOTAL_PLEDGE_PAY LIFE_TOTAL_PLEDGE_PAY |
|
| FUNCTION | F_LOST_AL_IND | LOST_ALUMNUS_IND |
|
| FUNCTION | F_MATCHING_GIFT | MATCHING_GIFT |
|
| FUNCTION | F_MEMO_DETAIL_MATCHING_GIFT | MEMO_MATCH_GIFT_IND MULTIPLE_MATCH_GIFT_IND |
|
| FUNCTION | F_MORE_SPECIFIC_REQUIREMENTS | MORE_SPECIFIC_REQ_IND |
|
| FUNCTION | F_MOST_RECENT_GIFT_AMOUNT | MOST_RECENT_GIFT_AMT MOST_RECENT_GIFT_DATE MOST_RECENT_GIFT_AMT MOST_RECENT_GIFT_DATE |
|
| FUNCTION | F_MOST_RECENT_PLEDGE_AMOUNT | MOST_RECENT_PLEDGE_AMT MOST_RECENT_PLEDGE_DATE MOST_RECENT_PLEDGE_AMT MOST_RECENT_PLEDGE_DATE |
|
| FUNCTION | F_MULTIPLE_RATIOS | MULTIPLE_RATIOS_IND |
|
| FUNCTION | F_NEXT_AUTO_STEP | NEXT_AUTO_STEP_INCREASE |
|
| FUNCTION | F_NUMBER_GIFT_YEAR | TOTAL_NUMBER_OF_GIFTS |
|
| FUNCTION | F_NUMBER_PLEDGE_YEAR | TOTAL_NUMBER_OF_PLEDGES |
|
| FUNCTION | F_OLDEST_EFFECTIVE_DATE | OLDEST_EFFECTIVE_DATE |
|
| FUNCTION | F_PAID_ADMISSIONS_DEPOSIT | DEPOSIT_IND DEPOSIT_IND |
|
| FUNCTION | F_PREFERRED_ADDRESS_IND | PREFERRED_ADDRESS_IND PREFERRED_ADDRESS_IND PREFERRED_ADDRESS_IND |
|
| FUNCTION | F_PROFILE_DATE | COVERAGE_BEGIN_DATE PROFILE_DATE PROFILE_DATE PROFILE_DATE |
|
| FUNCTION | F_PROSPECT_IND | PROSPECT_IND PROSPECT_IND |
|
| FUNCTION | F_QUARTERLY_DEDUCTION_TOTAL | APPLICABLE_GROSS_QTR1 APPLICABLE_GROSS_QTR2 APPLICABLE_GROSS_QTR3 APPLICABLE_GROSS_QTR4 EMPLOYEE_CONTRIBUTION_QTR2 EMPLOYEE_CONTRIBUTION_QTR3 EMPLOYEE_CONTRIBUTION_QTR4 EMPLOYEE_CONTRIBUTION_YTD EMPLOYER_CONTRIBUTION_QTR1 EMPLOYER_CONTRIBUTION_QTR2 EMPLOYER_CONTRIBUTION_QTR3 EMPLOYER_CONTRIBUTION_QTR4 APPLICABLE_GROSS_QTR1 APPLICABLE_GROSS_QTR2 APPLICABLE_GROSS_QTR3 APPLICABLE_GROSS_QTR4 EMPLOYEE_CONTRIBUTION_QTR1 EMPLOYEE_CONTRIBUTION_QTR2 EMPLOYEE_CONTRIBUTION_QTR3 EMPLOYEE_CONTRIBUTION_QTR4 EMPLOYER_CONTRIBUTION_QTR1 EMPLOYER_CONTRIBUTION_QTR2 EMPLOYER_CONTRIBUTION_QTR3 EMPLOYER_CONTRIBUTION_QTR4 |
|
| FUNCTION | F_RANGE_IND | ABOVE_SALARY_RANGE_IND BELOW_SALARY_RANGE_IND IN_SALARY_RANGE_IND |
|
| FUNCTION | F_RBRMIXD_DATA | MIXED_BUDGET_IND |
|
| FUNCTION | F_REGISTERED_THIS_TERM | REGISTERED_IND |
|
| FUNCTION | F_SPLIT_FIELDS | FIRST_QUARTER_BALANCE FOURTH_QUARTER_BALANCE SECOND_QUARTER_BALANCE SUM_ADOPTED_BUDGET SUM_BUDGET_ADJUSTMENTS SUM_BUDGET_RESERVATION SUM_ENCUMBRANCES SUM_PERCENT_AVAILABLE SUM_REALLOCATED_BUDGET SUM_REMAINING_BALANCE SUM_YEAR_TO_DATE_ACTV THIRD_QUARTER_BALANCE |
|
| FUNCTION | F_SPRIDEN_NAME | ADMINISTRATOR_NAME |
|
| FUNCTION | F_STUDENT_CHECK_FOR_MORE | COURSE_LEVEL_COUNT SCHEDULE_COUNT SCHEDULE_COUNT |
|
| FUNCTION | F_SUM_AMOUNT_TERM | AMOUNT |
|
| FUNCTION | F_SUM_BALANCE_TERM | BALANCE |
|
| FUNCTION | F_TOTAL_ANT_MAT_GIFT_ONE_PAY | TOTAL_ANT_MATCH_GIFT_ONE_PAY |
|
| FUNCTION | F_TOTAL_ANT_MAT_GIFT_PAY | TOTAL_ANT_MATCH_GIFT_PAY |
|
| FUNCTION | F_TOTAL_GIVING_YEAR | TOTAL_GIVING |
|
| FUNCTION | F_TOTAL_HOUR_EARNING_CODE | TOTAL_EARNINGS_YTD TOTAL_HOURS_YTD |
|
| FUNCTION | F_TOTAL_NON_MAT_GIFT_MEMO | TOTAL_NON_MATCH_GIFT_MEMO |
|
| FUNCTION | F_TOTAL_PLEDGED_AMOUNT_YEAR | TOTAL_PLEDGE_AMOUNT |
|
| FUNCTION | F_TOTAL_PLEDGE_PAYMENT_YEAR | TOTAL_PLEDGE_PAYMENTS |
|
| FUNCTION | F_TOTAL_RLZ_MAT_GIFT_ONE_PAY | TOTAL_REAL_MATCH_GIFT_ONE_PAY |
|
| FUNCTION | F_TOTAL_RLZ_MAT_GIFT_PAY | TOTAL_REAL_MATCH_GIFT_PAY |
|
| FUNCTION | F_UNSATISFIED_PROM_NOTE | UNSATISFIED_PROM_NOTE_IND |
|
| FUNCTION | F_YEAR | PROFILE_DATE TAX_DEDUCTION_YEAR |
|
| FUNCTION | F_YEARLY_DEDUCTION_TOTAL | EMPLOYER_CONTRIBUTION_YTD GROSS_COMPENSATION_YTD EMPLOYEE_CONTRIBUTION_YTD EMPLOYER_CONTRIBUTION_YTD GROSS_COMPENSATION_YTD |
|
| FUNCTION | NOT AVAILABLE | FUTURE_BUDGET INCEPTION_TO_DATE PROJECT_FISCAL_YEAR_TO_DATE AMOUNT_MULTIPLE_CREDIT SPOUSE_IND SPOUSE_NAME MOVE_COMPLETION_IND MAX_AMOUNT_FROM_THIRD_PARTY PERSON_MAX_AMOUNT_PAID COURSE_IDENTIFICATION COURSE_IDENTIFICATION_COREQ ADDITIONAL_MAJORS_IND ACCOUNT_POSTED_AMOUNT AMOUNT_MULTIPLE_CREDIT MONTHS_IN_POSITION TOTAL_NON_CEU_BILLING BEGINNING_BALANCE CURRENT_ACTUAL ENDING_BALANCE GIFT_CREDIT_AMOUNT PRIMARY_DONOR_CATEGORY LIFETIME_GIFT_SOCIETY_IND CREDITS_ATTEMPTED CREDITS_EARNED CREDITS_PASSED GPA_CREDITS GPA_GROUPING QUALITY_POINTS CREDITS_ATTEMPTED CREDITS_EARNED CREDITS_PASSED GPA GPA_CREDITS QUALITY_POINTS CREDITS_ATTEMPTED CREDITS_EARNED CREDITS_PASSED GPA GPA_CREDITS QUALITY_POINTS TOTAL_APPROVED_ITEM_AMOUNT TOTAL_CONVERTED_AMOUNT CONCEPTION_TO_DATE FUTURE_YEAR_BUDGET GOVERNMENT_REPORTING_CODE GOVERNMENT_REPORTING_DESC LAST_YEAR_ACTUAL PAST_YEAR_BUDGET PROJECT_FYTD_ACTUAL QUARTER_1 QUARTER_2 QUARTER_3 QUARTER_4 REALLOCATED_BUDGET_CURRENT REALLOCATED_BUDGET_SUM PLEDGE_CREDIT PLEDGE_FULLY_PAID_IND PLEDGE_INSTALLMENT_IND PLEDGE_PARTIAL_PAID_IND AMOUNT_REMAINING STAFF_ASSIGNMENT_COUNT PURCHASE_ORDER_TYPE_DESC ACCOUNT_POSTED_AMOUNT PRIMARY_SOURCE RELATED_GENDER_DESC INSTITUTION_COURSE_IND IN_PROGRESS_COURSE_IND TRANSFER_COURSE_IND PERSON_NAME |
|
| FUNCTION | NULL | FTE_DIVISOR FTE_IND STUDENT_FTE |
|
| FUNCTION | SPRIDEN NAME FUNCTION | RATER_NAME |
|
| FUNCTION | SPRIDEN_LAST_NAME | RELATED_MAIDEN_NAME |
|
| FUNCTION | SPRIDEN_MIDDLE_NAME | RELATED_MIDDLE_INITIAL |
|
| FUNCTION | SPRMEDI_MDEQ_CODE | PRIMARY_MEDICAL_EQUIPMENT |
|
| FUNCTION | STUDENT_GRAD_CREDIT_APPR_IND | GRADUATE_CREDIT_ELIG_IND |
|
| FUNCTION | COMBINE SSBSECT COLUMNS | COURSE_IDENTIFICATION |
|
| FUNCTION | F_COUNT_COLLECTIONS | COLLECTION_COUNT |
|
| FUNCTION | F_MEMO_BALANCE | MEMO_BALANCE |