Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_ADVANCEMENT_RATING

Description Source composite view of all internal and external advancement ratings associated with a prospect person or organization. Contains one row per rating per entity.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity.    

AMREXRT

AMRPRRT

AMREXRT_PIDM

AMRPRRT_PIDM

 
INTERNAL_IND Identifies whether the person rating the donor is internal.    

CONSTANT

DATA SOURCE IS AMRPRRT THEN 'Y'; DATA SOURCE IS AMREXRT THEN 'N'

 
MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
PRIMARY_IND Indicates which rate code is primary.    

AMRPRRT

AMRPRRT_PRIMARY_IND

 
RATER_NAME Name of the individual doing the Advancement rating.    

GURIDEN

GURIDEN_DESC

 
RATER_UID Internal identification number of the person associated with the rating.    

CALCULATION

DECODE(AMRPRRT_RATING_PIDM,NULL,AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM)

 
RATING Rate code.    

AMREXRT

AMRPRRT

AMREXRT_EXT_VALUE

AMRPRRT_RATE_CODE

 
RATING_AMOUNT Rate amount of the rate code.    

AMREXRT

ATVRATE

AMREXRT_EXT_SCORE

ATVRATE_RATE_AMT

 
RATING_DATE Date this record was created or updated.    

AMREXRT

AMRPRRT

AMREXRT_ACTIVITY_DATE

AMRPRRT_ACTIVITY_DATE

 
RATING_DESC Rate description.    

ATVRATE

ATVRATE_DESC

 
RATING_LEVEL Matching level of external source code.    

AMREXRT

AMREXRT_EXT_LEVEL

 
RATING_TYPE Rating type code.    

AMREXRT

AMRPRRT

AMREXRT_EXRS_CODE

AMRPRRT_RTGT_CODE

 
RATING_TYPE_DESC Rate type description.    

ATVEXRS

ATVRTGT

ATVEXRS_DESC

ATVRTGT_DESC

 
SCREENING Screening code.    

AMRPRRT

AMRPRRT_RSCR_CODE

 
SCREENING_DESC Rating screen description.    

ATVRSCR

ATVRSCR_DESC

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3