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

Ver: 9.2