Reporting View Source: CONSTANT

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

**SGHE 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
'ACTIVE'	NA				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-ALUMNI' FOR ADVANCEMENT,'BAN-HR' FOR HR	NA				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 REGISTRATION_PLAN_COURSE	PLAN_SOURCE PLAN_COURSE_SOURCE
'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_BLOCK AUDIT_STUDENT_COURSE AUDIT_STUDENT_BLOCK	BLOCK_VALUE_DESC BLOCK_DESC BLOCK_DESC BLOCK_TYPE_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
'INACTIVE'	NA				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_COURSE AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK	BLOCK_DESC BLOCK_DESC BLOCK_VALUE_DESC BLOCK_TYPE_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 ACTIVITY PROSPECT_STAFF_ASSIGNMENT STUDENT_COURSE PROSPECT_MOVES_MANAGEMENT STUDENT_COURSE ACADEMIC_STUDY_EXTENDED GPA	SOLICITOR_IND ADVANCEMENT_ACTIVITY_IND PRIMARY_IND INSTITUTION_COURSE_IND PLANNED_MOVE_COMPLETE_IND IN_PROGRESS_COURSE_IND PRIMARY_PROGRAM_IND GPA_TIME_IND	NA
'NA'	NA	REPORTING VIEW	REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_NON_COURSE PROJECTED_SEATS_NEEDED REGISTRATION_PLAN_COURSE AUDIT_STUDENT_COURSE REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE PROJECTED_SEATS_NEEDED REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE	a ace="Arial" size="2">PLAN_COURSE_USER_UID PLAN_GROUP_TYPE
'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 REGISTRATION_PLAN_COURSE REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REGISTRATION_PLAN_COURSE	APPROVAL_METHOD_DESC COURSE_DEPARTMENT_DESC APPROVAL_STATUS_DESC SUB_ACADEMIC_PERIOD_DESC PLAN_GROUP_TYPE_DESC
'O'	NA	REPORTING VIEW	GIFT_ASSOCIATED_ENTITY GIFT_AUXILIARY CONSTITUENT_ENTITY FUNDING_INTEREST GIFT_MATCHING DESIGNATION_GIVING_HISTORY GIFT_MATCHING_TRANSACTION GIFT_MULTIPLE PLEDGE_TRANSACTION MEMBERSHIP_INTEREST ANNUAL_GIVING GIFT GIFT_MEMO GIFT_TRANSACTION PLEDGE PROSPECT_INFO CAMPAIGN_GIVING_HISTORY	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_COURSE AUDIT_STUDENT_BLOCK	BLOCK_TYPE_DESC BLOCK_DESC BLOCK_DESC BLOCK_VALUE_DESC
'P'	NA	REPORTING VIEW	GIFT_MEMO GIFT_ASSOCIATED_ENTITY GIFT_MATCHING_TRANSACTION GIFT_TRANSACTION GPA GIFT_MULTIPLE MEMBERSHIP_INTEREST PLEDGE ANNUAL_GIVING DESIGNATION_GIVING_HISTORY FUNDING_INTEREST GIFT_AUXILIARY GIFT GIFT_MATCHING PROSPECT_INFO GPA CAMPAIGN_GIVING_HISTORY PLEDGE_TRANSACTION CONSTITUENT_ENTITY	ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND GPA_TIME_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND ENTITY_IND GPA_GROUPING ENTITY_IND ENTITY_IND ENTITY_IND	NA
'PRIMARY'	NA				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
'SECONDARY'	NA				NA
'STUDENT'	NA	REPORTING VIEW	INTEREST	SOURCE_DESC
'TBLD'	TBD	REPORTING VIEW REPORTING VIEW	PERSONNEL_ACTION_LABOR_DIST PERSONNEL_ACTION_LABOR_DIST	PAF_TRANSACTION_TYPE PAF_TRANSACTION_TYPE
'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 AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK AUDIT_STUDENT_BLOCK REGISTRATION_PLAN	CREDITS_PERCENT_COMPLETE REQUIRE_PERCENT_COMPLETE BLOCK_GPA CREDITS_NEEDED COURSES_NEEDED STUDY_PATH_SEQUENCE
00	NA
01	NA	REPORTING VIEW	ACCOUNT_HIERARCHY OPERATING_LEDGER	CTRL_ADOPTED_BUDGET_SEQUENCE CTRL_ADOPTED_BUDGET_SEQUENCE
02	NA	REPORTING VIEW	ACCOUNT_HIERARCHY OPERATING_LEDGER	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	OPERATING_LEDGER ACCOUNT_HIERARCHY	CTRL_TEMPORARY_BUDGET_SEQUENCE CTRL_TEMPORARY_BUDGET_SEQUENCE
1	NA	REPORTING VIEW	REGISTRATION_PLAN REGISTRATION_PLAN_COURSE	PLAN_VERSION_NUMBER PLAN_COURSE_VERSION_NUMBER
13	NA
14	NA
85	TBD
86	TBD
BAN-ALUMNI FOR ADVANCEMENT, BAN-HR FOR HR	NA				NA
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	DESIGNATION CAMPAIGN_DESIGNATION	DESG_VSE_PURPOSE_TYPE_DESC 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
MALE; FEMALE; NOT REPORTED	SPAPERS				Constants for Gender selection.
N	NA	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME PROSPECT_MOVES_MANAGEMENT	INTERNAL_ACADEMIC_OUTCOME_IND PLANNED_MOVE_IND
NULL	NA	REPORTING VIEW	AUDIT_COURSE_NEEDED INTEREST AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUDIT_STUDENT_BLOCK	STUDENT_CLASSIFICATION_DESC_DW INTEREST_USER_ID STUDENT_CLASSIFICATION_DESC_DW STUDENT_CLASSIFICATION_DESC_DW STUDENT_CLASSIFICATION_DESC_DW	NA
PRIMARY	NA				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
SOURCE APVXREF THEN 'X'; SOURCE APVCSPS THEN 'S';SOURCE APVCHLD THEN 'C'	NA				NA
T	NA	REPORTING VIEW	TRANSCRIPT_COMMENT	COMMENT_TYPE	NA
TBLD	TBD
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.0