Composite View Source: CONSTANT

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: CONSTANT Common

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

Ver: