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

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_BLOCK

AUDIT_STUDENT_COURSE

AUDIT_STUDENT_BLOCK

BLOCK_DESC

BLOCK_VALUE_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
'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_TYPE_DESC

BLOCK_VALUE_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

STUDENT_COURSE

PROSPECT_MOVES_MANAGEMENT

PROSPECT_STAFF_ASSIGNMENT

GPA

STUDENT_COURSE

PROSPECT_STAFF_ASSIGNMENT

ACTIVITY

INSTITUTION_COURSE_IND

PLANNED_MOVE_COMPLETE_IND

PRIMARY_IND

GPA_TIME_IND

IN_PROGRESS_COURSE_IND

SOLICITOR_IND

ADVANCEMENT_ACTIVITY_IND

NA
'NA' NA

REPORTING VIEW

AUDIT_STUDENT_COURSE

REGISTRATION_PLAN

REGISTRATION_PLAN

REGISTRATION_PLAN

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

AUDIT_STUDENT_COURSE

PROJECTED_SEATS_NEEDED

REGISTRATION_PLAN

REGISTRATION_PLAN

REGISTRATION_PLAN

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

AUDIT_STUDENT_NON_COURSE

REGISTRATION_PLAN

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

AUDIT_STUDENT_NON_COURSE

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

PROJECTED_SEATS_NEEDED

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN_COURSE

REGISTRATION_PLAN

REGISTRATION_PLAN

l l" size="2">PLAN_COMMENT

TRACKING_STATUS_CURRENT_IND

 
'NOTAPPLICABLE' NA

REPORTING VIEW

REGISTRATION_PLAN

REGISTRATION_PLAN

REGISTRATION_PLAN

UNOFFICIAL_TRACKING_STATUS

PLAN_TRACK_STATUS

OFFICIAL_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

PLAN_GROUP_TYPE_DESC

APPROVAL_STATUS_DESC

COURSE_DEPARTMENT_DESC

SUB_ACADEMIC_PERIOD_DESC

 
'O' NA

REPORTING VIEW

FUNDING_INTEREST

GIFT_ASSOCIATED_ENTITY

MEMBERSHIP_INTEREST

GIFT_MATCHING

GIFT_MULTIPLE

GIFT_TRANSACTION

PLEDGE

ANNUAL_GIVING

GIFT

GIFT_MEMO

DESIGNATION_GIVING_HISTORY

PLEDGE_TRANSACTION

CAMPAIGN_GIVING_HISTORY

PROSPECT_INFO

CONSTITUENT_ENTITY

GIFT_AUXILIARY

GIFT_MATCHING_TRANSACTION

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_COURSE

AUDIT_STUDENT_BLOCK

AUDIT_STUDENT_BLOCK

BLOCK_TYPE_DESC

BLOCK_DESC

BLOCK_DESC

BLOCK_VALUE_DESC

 
'P' NA

REPORTING VIEW

GIFT

GIFT_MATCHING

GIFT_MEMO

FUNDING_INTEREST

PLEDGE_TRANSACTION

GPA

DESIGNATION_GIVING_HISTORY

GIFT_ASSOCIATED_ENTITY

GIFT_AUXILIARY

GIFT_TRANSACTION

ANNUAL_GIVING

CAMPAIGN_GIVING_HISTORY

GIFT_MATCHING_TRANSACTION

GPA

CONSTITUENT_ENTITY

PLEDGE

GIFT_MULTIPLE

PROSPECT_INFO

MEMBERSHIP_INTEREST

ENTITY_IND

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

GPA_GROUPING

ENTITY_IND

ENTITY_IND

ENTITY_IND

ENTITY_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

ACTIVITY

STUDENT_COURSE

FINAID_BUDGET_COMP_SLOT

ADVANCEMENT_ACTIVITY_IND

INSTITUTION_COURSE_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

REGISTRATION_PLAN

AUDIT_STUDENT_BLOCK

AUDIT_STUDENT_BLOCK

REQUIRE_PERCENT_COMPLETE

CREDITS_NEEDED

COURSES_NEEDED

STUDY_PATH_SEQUENCE

BLOCK_GPA

CREDITS_PERCENT_COMPLETE

 
00 NA        
01 NA

REPORTING VIEW

OPERATING_LEDGER

ACCOUNT_HIERARCHY

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

OPERATING_LEDGER

ACCOUNT_HIERARCHY

CTRL_ACTUAL_ACTIVITY_SEQUENCE

CTRL_ACTUAL_ACTIVITY_SEQUENCE

 
04 NA

REPORTING VIEW

ACCOUNT_HIERARCHY

OPERATING_LEDGER

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

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_DEGREE

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
N NA

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

COMBINED_ACADEMIC_OUTCOME

PLANNED_MOVE_IND

INTERNAL_ACADEMIC_OUTCOME_IND

 
NULL NA

REPORTING VIEW

AUDIT_STUDENT_BLOCK

AUDIT_STUDENT_COURSE

AUDIT_STUDENT_NON_COURSE

AUDIT_COURSE_NEEDED

INTEREST

STUDENT_CLASSIFICATION_DESC_DW

STUDENT_CLASSIFICATION_DESC_DW

STUDENT_CLASSIFICATION_DESC_DW

STUDENT_CLASSIFICATION_DESC_DW

INTEREST_USER_ID

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