| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| 'A' |
NA |
NO |
REPORTING VIEW |
INTEREST |
SOURCE |
NO |
|
| 'ACCOUNT' |
NA |
NO |
REPORTING VIEW |
FOAPAL_NO_ATTRIBUTES |
FOAPAL_ELEMENT_TYPE |
NO |
NA |
| 'ACYR' |
NA |
NO |
REPORTING VIEW |
YEAR_TYPE_DEFINITION |
YEAR_TYPE |
NO |
NA |
| 'AIDY' |
NA |
NO |
REPORTING VIEW |
YEAR_TYPE_DEFINITION |
YEAR_TYPE |
NO |
NA |
| 'ATYP' |
NA |
NO |
REPORTING VIEW |
FOAPAL_NO_ATTRIBUTES |
FOAPAL_ELEMENT_TYPE |
NO |
NA |
| 'ACADEMIC YEAR' |
NA |
NO |
REPORTING VIEW |
YEAR_TYPE_DEFINITION |
YEAR_TYPE_DESC |
NO |
NA |
| 'ADVANCEMENT' |
NA |
NO |
REPORTING VIEW |
INTEREST |
SOURCE_DESC |
NO |
|
| 'AID YEAR' |
NA |
NO |
REPORTING VIEW |
YEAR_TYPE_DEFINITION |
YEAR_TYPE_DESC |
NO |
NA |
| 'BAN-ALUMNI' |
NA |
NO |
REPORTING VIEW |
CURRENT_EMPLOYMENT |
ID_SOURCE |
NO |
NA |
| 'BAN-HR' |
NA |
NO |
REPORTING VIEW |
CURRENT_EMPLOYMENT |
ID_SOURCE |
NO |
NA |
| 'C' |
NA |
NO |
REPORTING VIEW |
GPA |
GPA_GROUPING |
NO |
NA |
| 'COLLEGE' |
NA |
NO |
REPORTING VIEW |
PREVIOUS_EDUCATION |
INSTITUTION_TYPE_DESC |
NO |
NA |
| 'CUMULATIVE VALUES' |
NA |
NO |
REPORTING VIEW |
GPA |
GPA_GROUPING_DESC |
NO |
NA |
| 'D' |
NA |
NO |
REPORTING VIEW |
REGISTRATION_PLAN_COURSE REGISTRATION_PLAN |
PLAN_COURSE_SOURCE PLAN_SOURCE |
NO NO |
|
| 'EXCEPTION' |
NA |
NO |
REPORTING VIEW |
EXCEPTION_DETAIL |
BLOCK_DESC |
NO |
|
| 'FA_PROC_YR' |
NA |
NO |
REPORTING VIEW |
YEAR_TYPE_DEFINITION |
YEAR_TYPE |
NO |
NA |
| 'FTYP' |
NA |
NO |
REPORTING VIEW |
FOAPAL_NO_ATTRIBUTES |
FOAPAL_ELEMENT_TYPE |
NO |
NA |
| 'FUND' |
NA |
NO |
REPORTING VIEW |
FOAPAL_NO_ATTRIBUTES |
FOAPAL_ELEMENT_TYPE |
NO |
NA |
| 'FALL-THROUGH COURSES' |
FALLCLASSAPPLIED |
NO |
REPORTING VIEW |
AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK |
BLOCK_DESC BLOCK_DESC BLOCK_TYPE_DESC BLOCK_VALUE_DESC |
NO NO NO NO |
|
| 'FALL-THROUGH NON-COURSES' |
FALLNONCRAPPLIED |
NO |
REPORTING VIEW |
AUDIT_STUDENT_NON_COURSE |
BLOCK_DESC |
NO |
|
| 'FINANCIAL AID PROCESSING YEAR FOR AN ACADEMIC PERIOD' |
NA |
NO |
REPORTING VIEW |
YEAR_TYPE_DEFINITION |
YEAR_TYPE_DESC |
NO |
NA |
| 'HIGHSCHOOL' |
NA |
NO |
REPORTING VIEW |
PREVIOUS_EDUCATION |
INSTITUTION_TYPE_DESC |
NO |
NA |
| 'INST_AIDY' |
NA |
NO |
REPORTING VIEW |
YEAR_TYPE_DEFINITION |
YEAR_TYPE |
NO |
NA |
| 'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD' |
NA |
NO |
REPORTING VIEW |
YEAR_TYPE_DEFINITION |
YEAR_TYPE_DESC |
NO |
NA |
| 'INSUFFICIENT COURSES' |
INSUFFCLASSAPPLIED |
NO |
REPORTING VIEW |
AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE |
BLOCK_VALUE_DESC BLOCK_TYPE_DESC BLOCK_DESC BLOCK_DESC |
NO NO NO NO |
|
| 'LEVEL' |
NA |
NO |
REPORTING VIEW |
GPA |
ACADEMIC_STUDY_AREA |
NO |
This indicates the academic study area is LEVEL. |
| 'LOCATION' |
NA |
NO |
REPORTING VIEW |
FOAPAL_NO_ATTRIBUTES |
FOAPAL_ELEMENT_TYPE |
NO |
NA |
| 'N' |
NA |
NO |
REPORTING VIEW |
PROSPECT_STAFF_ASSIGNMENT PROSPECT_STAFF_ASSIGNMENT STUDENT_COURSE STUDENT_COURSE PROSPECT_MOVES_MANAGEMENT ACTIVITY GPA |
PRIMARY_IND SOLICITOR_IND IN_PROGRESS_COURSE_IND INSTITUTION_COURSE_IND PLANNED_MOVE_COMPLETE_IND ADVANCEMENT_ACTIVITY_IND GPA_TIME_IND |
NO NO NO NO NO NO NO |
NA |
| 'NA' |
NA |
NO |
REPORTING VIEW |
REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE AUDIT_STUDENT_NON_COURSE REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN_COURSE AUDIT_STUDENT_NON_COURSE PROJECTED_SEATS_NEEDED REGISTRATION_PLAN REGISTRATION_PLAN_COURSE AUDIT_STUDENT_COURSE AUDIT_STUDENT_COURSE REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE PROJECTED_SEATS_NEEDED REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE |
size="2">COURSE_END_DATE COURSE_REFERENCE_NUMBER
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
|
| 'NOTAPPLICABLE' |
NA |
NO |
REPORTING VIEW |
REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN |
OFFICIAL_TRACKING_STATUS PLAN_TRACK_STATUS UNOFFICIAL_TRACKING_STATUS |
NO NO NO |
|
| 'NON-TIME BASED' |
NA |
NO |
REPORTING VIEW |
GPA |
GPA_TIME_IND_DESC |
NO |
NA |
| 'NOT APPLICABLE' |
NA |
NO |
REPORTING VIEW |
REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN_COURSE |
COURSE_DEPARTMENT_DESC SUB_ACADEMIC_PERIOD_DESC APPROVAL_METHOD_DESC APPROVAL_STATUS_DESC PLAN_GROUP_TYPE_DESC |
NO NO NO NO NO |
|
| 'O' |
NA |
NO |
REPORTING VIEW |
GIFT_TRANSACTION PROSPECT_INFO ANNUAL_GIVING DESIGNATION_GIVING_HISTORY GIFT GIFT_MATCHING FUNDING_INTEREST GIFT_AUXILIARY GIFT_MULTIPLE CONSTITUENT_ENTITY GIFT_ASSOCIATED_ENTITY GIFT_MATCHING_TRANSACTION PLEDGE PLEDGE_TRANSACTION CAMPAIGN_GIVING_HISTORY GIFT_MEMO MEMBERSHIP_INTEREST |
ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| 'ORGN' |
NA |
NO |
REPORTING VIEW |
FOAPAL_NO_ATTRIBUTES |
FOAPAL_ELEMENT_TYPE |
NO |
NA |
| 'OVER-THE-LIMIT COURSES' |
OTLCLASSAPPLIED |
NO |
REPORTING VIEW |
AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE |
BLOCK_TYPE_DESC BLOCK_VALUE_DESC BLOCK_DESC BLOCK_DESC |
NO NO NO NO |
|
| 'P' |
NA |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION DESIGNATION_GIVING_HISTORY FUNDING_INTEREST GIFT_TRANSACTION GIFT_MATCHING_TRANSACTION PLEDGE GPA CAMPAIGN_GIVING_HISTORY GIFT_MATCHING GIFT_MEMO GIFT_MULTIPLE MEMBERSHIP_INTEREST PROSPECT_INFO GIFT ANNUAL_GIVING GIFT_AUXILIARY CONSTITUENT_ENTITY GPA GIFT_ASSOCIATED_ENTITY |
ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND GPA_GROUPING ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND GPA_TIME_IND ENTITY_IND |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| 'PROGRAM' |
NA |
NO |
REPORTING VIEW |
FOAPAL_NO_ATTRIBUTES |
FOAPAL_ELEMENT_TYPE |
NO |
NA |
| 'PERIOD BASED VALUES' |
NA |
NO |
REPORTING VIEW |
GPA |
GPA_GROUPING_DESC |
NO |
NA |
| 'PERIOD' |
NA |
NO |
REPORTING VIEW |
GPA |
GPA_TIME_IND_DESC |
NO |
NA |
| 'S' |
NA |
NO |
REPORTING VIEW |
INTEREST |
SOURCE |
NO |
|
| 'STUDENT' |
NA |
NO |
REPORTING VIEW |
INTEREST |
SOURCE_DESC |
NO |
|
| 'TBLD' |
NA |
NO |
REPORTING VIEW |
PERSONNEL_ACTION_LABOR_DIST |
PAF_TRANSACTION_TYPE |
NO |
NA |
| 'Y' |
SHATCKS |
NO |
REPORTING VIEW |
STUDENT_COURSE ACTIVITY FINAID_BUDGET_COMP_SLOT |
INSTITUTION_COURSE_IND ADVANCEMENT_ACTIVITY_IND PERIOD_BUDGET_IND |
NO NO NO |
NA |
| 'Y' OR 'N' |
NA |
NO |
REPORTING VIEW |
FINAID_BUDGET_COMPONENT |
PERIOD_BUDGET_IND |
NO |
NA |
| 0 |
FALLCRCL |
NO |
REPORTING VIEW |
AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK REGISTRATION_PLAN AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK |
CREDITS_PERCENT_COMPLETE REQUIRE_PERCENT_COMPLETE STUDY_PATH_SEQUENCE CREDITS_NEEDED BLOCK_GPA COURSES_NEEDED |
NO NO NO NO NO NO |
|
| 00 |
NA |
NO |
|
|
|
|
|
| 01 |
NA |
NO |
REPORTING VIEW |
OPERATING_LEDGER ACCOUNT_HIERARCHY |
CTRL_ADOPTED_BUDGET_SEQUENCE CTRL_ADOPTED_BUDGET_SEQUENCE |
NO NO |
|
| 02 |
NA |
NO |
REPORTING VIEW |
OPERATING_LEDGER ACCOUNT_HIERARCHY |
CTRL_BUDGET_ADJUST_SEQUENCE CTRL_BUDGET_ADJUST_SEQUENCE |
NO NO |
|
| 03 |
NA |
NO |
REPORTING VIEW |
ACCOUNT_HIERARCHY OPERATING_LEDGER |
CTRL_ACTUAL_ACTIVITY_SEQUENCE CTRL_ACTUAL_ACTIVITY_SEQUENCE |
NO NO |
|
| 04 |
NA |
NO |
REPORTING VIEW |
OPERATING_LEDGER ACCOUNT_HIERARCHY |
CTRL_ENCUMBRANCE_SEQUENCE CTRL_ENCUMBRANCE_SEQUENCE |
NO NO |
|
| 05 |
NA |
NO |
REPORTING VIEW |
OPERATING_LEDGER ACCOUNT_HIERARCHY |
CTRL_BUDGET_RESERVE_SEQUENCE CTRL_BUDGET_RESERVE_SEQUENCE |
NO NO |
|
| 07 |
NA |
NO |
REPORTING VIEW |
ACCOUNT_HIERARCHY OPERATING_LEDGER |
CTRL_TEMPORARY_BUDGET_SEQUENCE CTRL_TEMPORARY_BUDGET_SEQUENCE |
NO NO |
|
| 1 |
NA |
NO |
REPORTING VIEW |
REGISTRATION_PLAN_COURSE REGISTRATION_PLAN |
PLAN_COURSE_VERSION_NUMBER PLAN_VERSION_NUMBER |
NO NO |
|
| 13 |
NA |
NO |
|
|
|
|
|
| 14 |
NA |
NO |
|
|
|
|
|
| 85 |
TBD |
NO |
|
|
|
|
|
| 86 |
TBD |
NO |
|
|
|
|
|
| COLLEGE |
NA |
NO |
REPORTING VIEW |
PREVIOUS_EDUCATION_ATTENDANCE |
INSTITUTION_TYPE_DESC |
NO |
|
| COLLEGE |
NA |
NO |
REPORTING VIEW |
PREVIOUS_DEGREE COMBINED_ACADEMIC_OUTCOME |
INSTITUTION_TYPE_DESC INSTITUTION_TYPE_DESC |
NO NO |
|
| DATA SOURCE IS AMRPRRT THEN 'Y'; DATA SOURCE IS AMREXRT THEN 'N' |
NA |
NO |
REPORTING VIEW |
ADVANCEMENT_RATING |
INTERNAL_IND |
NO |
NA |
| HIGH SCHOOL |
NA |
NO |
REPORTING VIEW |
PREVIOUS_EDUCATION_ATTENDANCE |
INSTITUTION_TYPE_DESC |
NO |
|
| HARCODED DESCRIPTIONS. SEE THE ONLINE HELP FOR BANNER FORM ATVVSER FOR A COMPLETE LIST OF VALUES. |
NA |
NO |
REPORTING VIEW |
CAMPAIGN_DESIGNATION |
DESG_VSE_PURPOSE_TYPE_DESC |
NO |
|
| HARD CODED VALUES '00' THROUGH '14' |
NA |
NO |
REPORTING VIEW |
GRANT_LEDGER |
GRANT_PERIOD |
NO |
NA |
| HARD CODED VALUES '01' THROUGH '14' |
FGIBDST |
NO |
REPORTING VIEW |
OPERATING_LEDGER |
FISCAL_PERIOD |
NO |
NA |
| HARDCODED DESCRIPTIONS |
TBD |
NO |
REPORTING VIEW |
PORTFOLIO |
AUTHORIZATION_STATUS_DESC |
NO |
|
| L |
NA |
NO |
REPORTING VIEW |
TRANSCRIPT_COMMENT |
COMMENT_TYPE |
NO |
NA |
| LEVEL |
NA |
NO |
REPORTING VIEW |
TRANSCRIPT_COMMENT |
COMMENT_TYPE_DESC |
NO |
NA |
| N |
NA |
NO |
REPORTING VIEW |
COMBINED_ACADEMIC_OUTCOME PROSPECT_MOVES_MANAGEMENT |
INTERNAL_ACADEMIC_OUTCOME_IND PLANNED_MOVE_IND |
NO NO |
|
| NULL |
NA |
NO |
REPORTING VIEW |
AUDIT_COURSE_NEEDED AUDIT_STUDENT_BLOCK AUDIT_STUDENT_NON_COURSE INTEREST AUDIT_STUDENT_COURSE |
STUDENT_CLASSIFICATION_DESC_DW STUDENT_CLASSIFICATION_DESC_DW STUDENT_CLASSIFICATION_DESC_DW INTEREST_USER_ID STUDENT_CLASSIFICATION_DESC_DW |
NO NO NO NO NO |
NA |
| PLANNED MOVE |
NA |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_IND_DESC |
NO |
|
| SOURCE AGRGSOL THEN 'G'; SOURCE AGRPSOL THEN 'P' |
NA |
NO |
REPORTING VIEW |
SOLICITATION |
GIFT_PLEDGE_IND |
NO |
NA |
| SOURCE APRCHLD AND APRXREF THEN 'CHILD/CROSS REFERENCE'; APRCHLD THEN 'CHILD'; APRCSPS AND APRXREF THEN 'SPOUSE/CROSS REFERENCE'; APRCSPS THEN 'SPOUSE'; APRXREF THEN 'CROSS REFERENCE' |
TBD |
NO |
REPORTING VIEW |
RELATIONSHIP |
RELATION_SOURCE_DESC |
NO |
|
| SOURCE APRCHLD AND APRXREF THEN 'CX'; SOURCE APRCHLD THEN 'C'; SOURCE APRCSPS AND APRXREF THEN 'SX'; SOURCE APRCSPS THEN 'S'; SOURCE APRXREF THEN 'X' |
TBD |
NO |
REPORTING VIEW |
RELATIONSHIP |
RELATION_SOURCE |
NO |
|
| T |
NA |
NO |
REPORTING VIEW |
TRANSCRIPT_COMMENT |
COMMENT_TYPE |
NO |
NA |
| TERM |
NA |
NO |
REPORTING VIEW |
TRANSCRIPT_COMMENT |
COMMENT_TYPE_DESC |
NO |
NA |
| UNPLANNED MOVE |
NA |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_IND_DESC |
NO |
NA |
| Y |
NA |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_IND |
NO |
NA |