Composite View Source: CONSTANT

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
'A'	NA	COMPOSITE VIEW	AA_INTEREST	SOURCE
'ACCOUNT'	NA				NA
'ACTIVE'	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-ALUMNI' FOR ADVANCEMENT,'BAN-HR' FOR HR	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
'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
'INACTIVE'	NA				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_STUDENT_COURSE_HISTORY AA_PROSPECT_STAFF_ASSIGNMENT AS_GPA_LEVEL AS_ENROLLMENT_HISTORY AS_STUDENT_COURSE_TRANSFER AS_YEAR_TYPE_DEFINITION AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_TRANSFER	IN_PROGRESS_COURSE_IND SOLICITOR_IND GPA_TIME_IND ENROLLMENT_EXISTS_IND IN_PROGRESS_COURSE_IND YEAR_TYPE TRANSFER_COURSE_IND INSTITUTION_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_PREVIOUS_EDUCATION_PCOL AS_GPA_TERM AA_CONSTITUENT AS_GPA_TERM	SOURCE_FLAG GPA_GROUPING ENTITY_IND GPA_TIME_IND	NA
'PRIMARY'	NA				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
'SECONDARY'	NA				NA
'STUDENT'	NA	COMPOSITE VIEW	AS_INTEREST	SOURCE_DESC
'TBLD'	TBD
'Y'	SHATCKS	COMPOSITE VIEW	AS_ENROLLMENT_HISTORY AS_STUDENT_COURSE_TRANSFER AS_STUDENT_COURSE_HISTORY AS_ENROLLMENT AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY	AR_CHGS_ACCEPTANCE_IND TRANSFER_COURSE_IND INSTITUTION_COURSE_IND ENROLLMENT_EXISTS_IND REGISTERED_IND ACADEMIC_HISTORY_EXISTS_IND ENROLLED_IND	NA
'Y' OR 'N'	NA				NA
0	FALLCRCL	COMPOSITE VIEW	AS_ENROLLMENT_HISTORY AS_ENROLLMENT_HISTORY AA_SOLICITOR_ORG_FUNDRAISER AS_ENROLLMENT_HISTORY	TOTAL_BILLING TOTAL_CEU_BILLING PCT_PROG_SOLICITOR_DONOR_GOAL 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
BAN-ALUMNI FOR ADVANCEMENT, BAN-HR FOR HR	NA				NA
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
MALE; FEMALE; NOT REPORTED	SPAPERS				Constants for Gender selection.
N	NA	COMPOSITE VIEW	AA_PROSPECT_MOVES_MANAGEMENT AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_MOVES_MANAGEMENT	PLANNED_MOVE_COMPLETE_IND PRIMARY_IND PLANNED_MOVE_IND
NULL	NA	COMPOSITE VIEW	AS_INTEREST	INTEREST_USER_ID	NA
PRIMARY	NA				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
SOURCE APVXREF THEN 'X'; SOURCE APVCSPS THEN 'S';SOURCE APVCHLD THEN 'C'	NA				NA
T	NA	COMPOSITE VIEW	AS_TRANSCRIPT_TERM_COMMENT	COMMENT_TYPE	NA
TBLD	TBD
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

Ver: