Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: CONSTANT Common
Banner Operational Data Store Composite View Source: CONSTANT - NULL

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_STUDENT_COURSE_TRANSFER

AS_STUDENT_COURSE_TRANSFER

AS_YEAR_TYPE_DEFINITION

AS_GPA_LEVEL

AS_STUDENT_COURSE_HISTORY

AS_ENROLLMENT_HISTORY

AS_STUDENT_COURSE_HISTORY

AA_PROSPECT_STAFF_ASSIGNMENT

AS_STUDENT_COURSE_TRANSFER

AS_STUDENT_COURSE_TRANSFER

AS_YEAR_TYPE_DEFINITION

AS_GPA_LEVEL

AS_STUDENT_COURSE_HISTORY

AS_ENROLLMENT_HISTORY

AS_STUDENT_COURSE_HISTORY

AA_PROSPECT_STAFF_ASSIGNMENT

INSTITUTION_COURSE_IND

IN_PROGRESS_COURSE_IND

YEAR_TYPE

GPA_TIME_IND

IN_PROGRESS_COURSE_IND

ENROLLMENT_EXISTS_IND

TRANSFER_COURSE_IND

SOLICITOR_IND

INSTITUTION_COURSE_IND

IN_PROGRESS_COURSE_IND

YEAR_TYPE

GPA_TIME_IND

IN_PROGRESS_COURSE_IND

ENROLLMENT_EXISTS_IND

TRANSFER_COURSE_IND

SOLICITOR_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

AA_CONSTITUENT

AS_PREVIOUS_EDUCATION_PCOL

AS_GPA_TERM

AS_GPA_TERM

ENTITY_IND

SOURCE_FLAG

GPA_GROUPING

GPA_TIME_IND

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

AS_STUDENT_COURSE_TRANSFER

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_STUDENT_COURSE_HISTORY

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT

AS_STUDENT_COURSE_TRANSFER

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_STUDENT_COURSE_HISTORY

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

ENROLLMENT_EXISTS_IND

TRANSFER_COURSE_IND

ACADEMIC_HISTORY_EXISTS_IND

ENROLLED_IND

INSTITUTION_COURSE_IND

AR_CHGS_ACCEPTANCE_IND

REGISTERED_IND

ENROLLMENT_EXISTS_IND

TRANSFER_COURSE_IND

ACADEMIC_HISTORY_EXISTS_IND

ENROLLED_IND

INSTITUTION_COURSE_IND

AR_CHGS_ACCEPTANCE_IND

REGISTERED_IND

NA
'Y' OR 'N' NA       NA
0 TBD COMPOSITE VIEW

AA_SOLICITOR_ORG_FUNDRAISER

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AA_SOLICITOR_ORG_FUNDRAISER

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

AS_ENROLLMENT_HISTORY

PCT_PROG_SOLICITOR_DONOR_GOAL

TOTAL_BILLING

TOTAL_NON_CEU_BILLING

TOTAL_CEU_BILLING

PCT_PROG_SOLICITOR_DONOR_GOAL

TOTAL_BILLING

TOTAL_NON_CEU_BILLING

TOTAL_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_MOVES_MANAGEMENT

AA_PROSPECT_STAFF_ASSIGNMENT

AA_PROSPECT_MOVES_MANAGEMENT

PLANNED_MOVE_IND

PRIMARY_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


Ver: