| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
|---|
| 'A' |
NA |
COMPOSITE VIEW |
AA_INTEREST |
SOURCE |
|
| 'ACCOUNT' |
NA |
|
|
|
NA |
| 'ACYR' |
NA |
|
|
|
NA |
| 'AIDY' |
NA |
|
|
|
NA |
| 'ATYP' |
NA |
|
|
|
NA |
| 'ACADEMIC YEAR' |
NA |
COMPOSITE VIEW |
AS_YEAR_TYPE_DEFINITION |
YEAR_TYPE_DESC |
NA |
| 'ADVANCEMENT' |
NA |
COMPOSITE VIEW |
AA_INTEREST |
SOURCE_DESC |
|
| 'AID YEAR' |
NA |
COMPOSITE VIEW |
AR_YEAR_TYPE_DEFINITION |
YEAR_TYPE_DESC |
NA |
| 'BAN-ALUMNI' |
NA |
|
|
|
NA |
| 'BAN-HR' |
NA |
|
|
|
NA |
| 'C' |
NA |
COMPOSITE VIEW |
AS_GPA_LEVEL |
GPA_GROUPING |
NA |
| 'COLLEGE' |
NA |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_PCOL |
INSTITUTION_TYPE_DESC |
NA |
| 'CUMULATIVE VALUES' |
NA |
COMPOSITE VIEW |
AS_GPA_LEVEL |
GPA_GROUPING_DESC |
NA |
| 'D' |
NA |
|
|
|
|
| 'EXCEPTION' |
NA |
|
|
|
|
| 'FA_PROC_YR' |
NA |
COMPOSITE VIEW |
AS_YEAR_TYPE_DEFINITION |
YEAR_TYPE |
NA |
| 'FTYP' |
NA |
|
|
|
NA |
| 'FUND' |
NA |
|
|
|
NA |
| 'FALL-THROUGH COURSES' |
FALLCLASSAPPLIED |
|
|
|
|
| 'FALL-THROUGH NON-COURSES' |
FALLNONCRAPPLIED |
|
|
|
|
| 'FINANCIAL AID PROCESSING YEAR FOR AN ACADEMIC PERIOD' |
NA |
COMPOSITE VIEW |
AS_YEAR_TYPE_DEFINITION |
YEAR_TYPE_DESC |
NA |
| 'HIGHSCHOOL' |
NA |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_HSCH |
INSTITUTION_TYPE_DESC |
NA |
| 'INST_AIDY' |
NA |
|
|
|
NA |
| 'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD' |
NA |
COMPOSITE VIEW |
AR_YEAR_TYPE_DEFINITION |
YEAR_TYPE_DESC |
NA |
| 'INSUFFICIENT COURSES' |
INSUFFCLASSAPPLIED |
|
|
|
|
| 'LEVEL' |
NA |
COMPOSITE VIEW |
AS_GPA_LEVEL |
ACADEMIC_STUDY_AREA |
This indicates the academic study area is LEVEL. |
| 'LOCATION' |
NA |
|
|
|
NA |
| 'N' |
NA |
COMPOSITE VIEW |
AS_GPA_LEVEL AA_PROSPECT_STAFF_ASSIGNMENT AS_STUDENT_COURSE_TRANSFER AS_YEAR_TYPE_DEFINITION AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_HISTORY AS_ENROLLMENT_HISTORY AS_STUDENT_COURSE_TRANSFER |
GPA_TIME_IND SOLICITOR_IND INSTITUTION_COURSE_IND YEAR_TYPE IN_PROGRESS_COURSE_IND TRANSFER_COURSE_IND ENROLLMENT_EXISTS_IND IN_PROGRESS_COURSE_IND |
NA |
| 'NA' |
NA |
|
|
|
|
| 'NOTAPPLICABLE' |
NA |
|
|
|
|
| 'NON-TIME BASED' |
NA |
COMPOSITE VIEW |
AS_GPA_LEVEL |
GPA_TIME_IND_DESC |
NA |
| 'NOT APPLICABLE' |
NA |
|
|
|
|
| 'O' |
NA |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
ENTITY_IND |
NA |
| 'ORGN' |
NA |
|
|
|
NA |
| 'OVER-THE-LIMIT COURSES' |
OTLCLASSAPPLIED |
|
|
|
|
| 'P' |
NA |
COMPOSITE VIEW |
AS_GPA_TERM AS_PREVIOUS_EDUCATION_PCOL AA_CONSTITUENT AS_GPA_TERM |
GPA_TIME_IND SOURCE_FLAG ENTITY_IND GPA_GROUPING |
NA |
| 'PROGRAM' |
NA |
|
|
|
NA |
| 'PERIOD BASED VALUES' |
NA |
COMPOSITE VIEW |
AS_GPA_TERM |
GPA_GROUPING_DESC |
NA |
| 'PERIOD' |
NA |
COMPOSITE VIEW |
AS_GPA_TERM |
GPA_TIME_IND_DESC |
NA |
| 'S' |
NA |
COMPOSITE VIEW |
AS_INTEREST |
SOURCE |
|
| 'STUDENT' |
NA |
COMPOSITE VIEW |
AS_INTEREST |
SOURCE_DESC |
|
| 'TBLD' |
NA |
|
|
|
NA |
| 'Y' |
SHATCKS |
COMPOSITE VIEW |
AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AS_ENROLLMENT AS_STUDENT_COURSE_TRANSFER AS_STUDENT_COURSE_HISTORY |
ACADEMIC_HISTORY_EXISTS_IND AR_CHGS_ACCEPTANCE_IND ENROLLED_IND REGISTERED_IND ENROLLMENT_EXISTS_IND TRANSFER_COURSE_IND INSTITUTION_COURSE_IND |
NA |
| 'Y' OR 'N' |
NA |
|
|
|
NA |
| 0 |
FALLCRCL |
COMPOSITE VIEW |
AA_SOLICITOR_ORG_FUNDRAISER AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY |
PCT_PROG_SOLICITOR_DONOR_GOAL TOTAL_BILLING TOTAL_CEU_BILLING TOTAL_NON_CEU_BILLING |
|
| 00 |
NA |
COMPOSITE VIEW |
AF_FISCAL_PERIOD |
FISCAL_PERIOD |
|
| 01 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_ADOPTED_BUDGET_SEQUENCE |
|
| 02 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_BUDGET_ADJUST_SEQUENCE |
|
| 03 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_ACTUAL_ACTIVITY_SEQUENCE |
|
| 04 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_ENCUMBRANCE_SEQUENCE |
|
| 05 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_BUDGET_RESERVE_SEQUENCE |
|
| 07 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_TEMPORARY_BUDGET_SEQUENCE |
|
| 1 |
NA |
|
|
|
|
| 13 |
NA |
COMPOSITE VIEW |
AF_FISCAL_PERIOD |
FISCAL_PERIOD |
|
| 14 |
NA |
COMPOSITE VIEW |
AF_FISCAL_PERIOD |
FISCAL_PERIOD |
|
| 85 |
TBD |
COMPOSITE VIEW |
AE_APPROVAL_HISTORY |
DOC_TYPE |
|
| 86 |
TBD |
COMPOSITE VIEW |
AE_APPROVAL_HISTORY |
DOC_TYPE |
|
| COLLEGE |
NA |
|
|
|
|
| COLLEGE |
NA |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
INSTITUTION_TYPE_DESC |
|
| DATA SOURCE IS AMRPRRT THEN 'Y'; DATA SOURCE IS AMREXRT THEN 'N' |
NA |
COMPOSITE VIEW |
AA_ADVANCEMENT_RATING |
INTERNAL_IND |
NA |
| HIGH SCHOOL |
NA |
|
|
|
|
| HARCODED DESCRIPTIONS. SEE THE ONLINE HELP FOR BANNER FORM ATVVSER FOR A COMPLETE LIST OF VALUES. |
NA |
COMPOSITE VIEW |
AA_DESIGNATION |
DESG_VSE_PURPOSE_TYPE_DESC |
|
| HARD CODED VALUES '00' THROUGH '14' |
NA |
COMPOSITE VIEW |
AF_GRANT_LEDGER |
GRANT_PERIOD |
NA |
| HARD CODED VALUES '01' THROUGH '14' |
FGIBDST |
COMPOSITE VIEW |
AF_OPERATING_LEDGER |
FISCAL_PERIOD |
NA |
| HARDCODED DESCRIPTIONS |
TBD |
|
|
|
|
| L |
NA |
COMPOSITE VIEW |
AS_TRANSCRIPT_LEVEL_COMMENT |
COMMENT_TYPE |
NA |
| LEVEL |
NA |
COMPOSITE VIEW |
AS_TRANSCRIPT_LEVEL_COMMENT |
COMMENT_TYPE_DESC |
NA |
| N |
NA |
COMPOSITE VIEW |
AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_MOVES_MANAGEMENT AA_PROSPECT_MOVES_MANAGEMENT |
PRIMARY_IND PLANNED_MOVE_IND PLANNED_MOVE_COMPLETE_IND |
|
| NULL |
NA |
COMPOSITE VIEW |
AS_INTEREST |
INTEREST_USER_ID |
NA |
| PLANNED MOVE |
NA |
COMPOSITE VIEW |
AA_PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_IND_DESC |
|
| SOURCE AGRGSOL THEN 'G'; SOURCE AGRPSOL THEN 'P' |
NA |
COMPOSITE VIEW |
AA_SOLICITOR |
GIFT_PLEDGE_IND |
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 |
COMPOSITE VIEW |
AA_RELATIONSHIP |
RELATION_SOURCE_DESC |
|
| 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 |
COMPOSITE VIEW |
AA_RELATIONSHIP |
RELATION_SOURCE |
|
| T |
NA |
COMPOSITE VIEW |
AS_TRANSCRIPT_TERM_COMMENT |
COMMENT_TYPE |
NA |
| TERM |
NA |
COMPOSITE VIEW |
AS_TRANSCRIPT_TERM_COMMENT |
COMMENT_TYPE_DESC |
NA |
| UNPLANNED MOVE |
NA |
COMPOSITE VIEW |
AA_PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_IND_DESC |
NA |
| Y |
NA |
COMPOSITE VIEW |
AA_PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_IND |
NA |