Reporting View Source: CONSTANT

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: CONSTANT Common Reporting View Meta Data Reports

**Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
'A'	NA	REPORTING VIEW	INTEREST	SOURCE
'ACCOUNT'	NA	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES	FOAPAL_ELEMENT_TYPE	NA
'ACYR'	NA	REPORTING VIEW	YEAR_TYPE_DEFINITION	YEAR_TYPE	NA
'AIDY'	NA	REPORTING VIEW	YEAR_TYPE_DEFINITION	YEAR_TYPE	NA
'ATYP'	NA	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES	FOAPAL_ELEMENT_TYPE	NA
'ACADEMIC YEAR'	NA	REPORTING VIEW	YEAR_TYPE_DEFINITION	YEAR_TYPE_DESC	NA
'ADVANCEMENT'	NA	REPORTING VIEW	INTEREST	SOURCE_DESC
'AID YEAR'	NA	REPORTING VIEW	YEAR_TYPE_DEFINITION	YEAR_TYPE_DESC	NA
'BAN-ALUMNI'	NA	REPORTING VIEW	CURRENT_EMPLOYMENT	ID_SOURCE	NA
'BAN-HR'	NA	REPORTING VIEW	CURRENT_EMPLOYMENT	ID_SOURCE	NA
'C'	NA	REPORTING VIEW	GPA	GPA_GROUPING	NA
'COLLEGE'	NA	REPORTING VIEW	PREVIOUS_EDUCATION	INSTITUTION_TYPE_DESC	NA
'CUMULATIVE VALUES'	NA	REPORTING VIEW	GPA	GPA_GROUPING_DESC	NA
'D'	NA	REPORTING VIEW	REGISTRATION_PLAN_COURSE REGISTRATION_PLAN	PLAN_COURSE_SOURCE PLAN_SOURCE
'EXCEPTION'	NA	REPORTING VIEW	EXCEPTION_DETAIL	BLOCK_DESC
'FA_PROC_YR'	NA	REPORTING VIEW	YEAR_TYPE_DEFINITION	YEAR_TYPE	NA
'FTYP'	NA	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES	FOAPAL_ELEMENT_TYPE	NA
'FUND'	NA	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES	FOAPAL_ELEMENT_TYPE	NA
'FALL-THROUGH COURSES'	FALLCLASSAPPLIED	REPORTING VIEW	AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK	BLOCK_DESC BLOCK_DESC BLOCK_TYPE_DESC BLOCK_VALUE_DESC
'FALL-THROUGH NON-COURSES'	FALLNONCRAPPLIED	REPORTING VIEW	AUDIT_STUDENT_NON_COURSE	BLOCK_DESC
'FINANCIAL AID PROCESSING YEAR FOR AN ACADEMIC PERIOD'	NA	REPORTING VIEW	YEAR_TYPE_DEFINITION	YEAR_TYPE_DESC	NA
'HIGHSCHOOL'	NA	REPORTING VIEW	PREVIOUS_EDUCATION	INSTITUTION_TYPE_DESC	NA
'INST_AIDY'	NA	REPORTING VIEW	YEAR_TYPE_DEFINITION	YEAR_TYPE	NA
'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD'	NA	REPORTING VIEW	YEAR_TYPE_DEFINITION	YEAR_TYPE_DESC	NA
'INSUFFICIENT COURSES'	INSUFFCLASSAPPLIED	REPORTING VIEW	AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE	BLOCK_VALUE_DESC BLOCK_TYPE_DESC BLOCK_DESC BLOCK_DESC
'LEVEL'	NA	REPORTING VIEW	GPA	ACADEMIC_STUDY_AREA	This indicates the academic study area is LEVEL.
'LOCATION'	NA	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES	FOAPAL_ELEMENT_TYPE	NA
'N'	NA	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	NA
'NA'	NA	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
'NOTAPPLICABLE'	NA	REPORTING VIEW	REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN	OFFICIAL_TRACKING_STATUS PLAN_TRACK_STATUS UNOFFICIAL_TRACKING_STATUS
'NON-TIME BASED'	NA	REPORTING VIEW	GPA	GPA_TIME_IND_DESC	NA
'NOT APPLICABLE'	NA	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
'O'	NA	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	NA
'ORGN'	NA	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES	FOAPAL_ELEMENT_TYPE	NA
'OVER-THE-LIMIT COURSES'	OTLCLASSAPPLIED	REPORTING VIEW	AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE	BLOCK_TYPE_DESC BLOCK_VALUE_DESC BLOCK_DESC BLOCK_DESC
'P'	NA	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	NA
'PROGRAM'	NA	REPORTING VIEW	FOAPAL_NO_ATTRIBUTES	FOAPAL_ELEMENT_TYPE	NA
'PERIOD BASED VALUES'	NA	REPORTING VIEW	GPA	GPA_GROUPING_DESC	NA
'PERIOD'	NA	REPORTING VIEW	GPA	GPA_TIME_IND_DESC	NA
'S'	NA	REPORTING VIEW	INTEREST	SOURCE
'STUDENT'	NA	REPORTING VIEW	INTEREST	SOURCE_DESC
'TBLD'	NA	REPORTING VIEW	PERSONNEL_ACTION_LABOR_DIST	PAF_TRANSACTION_TYPE	NA
'Y'	SHATCKS	REPORTING VIEW	STUDENT_COURSE ACTIVITY FINAID_BUDGET_COMP_SLOT	INSTITUTION_COURSE_IND ADVANCEMENT_ACTIVITY_IND PERIOD_BUDGET_IND	NA
'Y' OR 'N'	NA	REPORTING VIEW	FINAID_BUDGET_COMPONENT	PERIOD_BUDGET_IND	NA
0	FALLCRCL	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
00	NA
01	NA	REPORTING VIEW	OPERATING_LEDGER ACCOUNT_HIERARCHY	CTRL_ADOPTED_BUDGET_SEQUENCE CTRL_ADOPTED_BUDGET_SEQUENCE
02	NA	REPORTING VIEW	OPERATING_LEDGER ACCOUNT_HIERARCHY	CTRL_BUDGET_ADJUST_SEQUENCE CTRL_BUDGET_ADJUST_SEQUENCE
03	NA	REPORTING VIEW	ACCOUNT_HIERARCHY OPERATING_LEDGER	CTRL_ACTUAL_ACTIVITY_SEQUENCE CTRL_ACTUAL_ACTIVITY_SEQUENCE
04	NA	REPORTING VIEW	OPERATING_LEDGER ACCOUNT_HIERARCHY	CTRL_ENCUMBRANCE_SEQUENCE CTRL_ENCUMBRANCE_SEQUENCE
05	NA	REPORTING VIEW	OPERATING_LEDGER ACCOUNT_HIERARCHY	CTRL_BUDGET_RESERVE_SEQUENCE CTRL_BUDGET_RESERVE_SEQUENCE
07	NA	REPORTING VIEW	ACCOUNT_HIERARCHY OPERATING_LEDGER	CTRL_TEMPORARY_BUDGET_SEQUENCE CTRL_TEMPORARY_BUDGET_SEQUENCE
1	NA	REPORTING VIEW	REGISTRATION_PLAN_COURSE REGISTRATION_PLAN	PLAN_COURSE_VERSION_NUMBER PLAN_VERSION_NUMBER
13	NA
14	NA
85	TBD
86	TBD
COLLEGE	NA	REPORTING VIEW	PREVIOUS_EDUCATION_ATTENDANCE	INSTITUTION_TYPE_DESC
COLLEGE	NA	REPORTING VIEW	PREVIOUS_DEGREE COMBINED_ACADEMIC_OUTCOME	INSTITUTION_TYPE_DESC INSTITUTION_TYPE_DESC
DATA SOURCE IS AMRPRRT THEN 'Y'; DATA SOURCE IS AMREXRT THEN 'N'	NA	REPORTING VIEW	ADVANCEMENT_RATING	INTERNAL_IND	NA
HIGH SCHOOL	NA	REPORTING VIEW	PREVIOUS_EDUCATION_ATTENDANCE	INSTITUTION_TYPE_DESC
HARCODED DESCRIPTIONS. SEE THE ONLINE HELP FOR BANNER FORM ATVVSER FOR A COMPLETE LIST OF VALUES.	NA	REPORTING VIEW	CAMPAIGN_DESIGNATION	DESG_VSE_PURPOSE_TYPE_DESC
HARD CODED VALUES '00' THROUGH '14'	NA	REPORTING VIEW	GRANT_LEDGER	GRANT_PERIOD	NA
HARD CODED VALUES '01' THROUGH '14'	FGIBDST	REPORTING VIEW	OPERATING_LEDGER	FISCAL_PERIOD	NA
HARDCODED DESCRIPTIONS	TBD	REPORTING VIEW	PORTFOLIO	AUTHORIZATION_STATUS_DESC
L	NA	REPORTING VIEW	TRANSCRIPT_COMMENT	COMMENT_TYPE	NA
LEVEL	NA	REPORTING VIEW	TRANSCRIPT_COMMENT	COMMENT_TYPE_DESC	NA
N	NA	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME PROSPECT_MOVES_MANAGEMENT	INTERNAL_ACADEMIC_OUTCOME_IND PLANNED_MOVE_IND
NULL	NA	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	NA
PLANNED MOVE	NA	REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT	PLANNED_MOVE_IND_DESC
SOURCE AGRGSOL THEN 'G'; SOURCE AGRPSOL THEN 'P'	NA	REPORTING VIEW	SOLICITATION	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	REPORTING VIEW	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	REPORTING VIEW	RELATIONSHIP	RELATION_SOURCE
T	NA	REPORTING VIEW	TRANSCRIPT_COMMENT	COMMENT_TYPE	NA
TERM	NA	REPORTING VIEW	TRANSCRIPT_COMMENT	COMMENT_TYPE_DESC	NA
UNPLANNED MOVE	NA	REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT	PLANNED_MOVE_IND_DESC	NA
Y	NA	REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT	PLANNED_MOVE_IND	NA

Ver: 9.2