Go To View:  RETURN TO COMPOSITE VIEW 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.

Target Column Business Definition Database Data Type Source Name Source Column
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

NA

NA

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

AMREXRT

AMRPRRT

AMREXRT_PIDM

AMRPRRT_PIDM

INTERNAL_IND Identifies whether the person rating the donor is internal. VARCHAR2(1)

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. VARCHAR2(30)

NA

NA

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

NA

NA

PRIMARY_IND Indicates which rate code is primary. VARCHAR2(1)

AMRPRRT

AMRPRRT_PRIMARY_IND

RATER_NAME Name of the individual doing the Advancement rating. VARCHAR2(60)

GURIDEN

GURIDEN_DESC

RATER_UID Internal identification number of the person associated with the rating. VARCHAR2(40)

CALCULATION

DECODE(AMRPRRT_RATING_PIDM,NULL,AMRPRRT_IDEN_CODE,AMRPRRT_RATING_PIDM)

RATING Rate code. VARCHAR2(4)

AMREXRT

AMRPRRT

AMREXRT_EXT_VALUE

AMRPRRT_RATE_CODE

RATING_AMOUNT Rate amount of the rate code. VARCHAR2(40)

AMREXRT

ATVRATE

AMREXRT_EXT_SCORE

ATVRATE_RATE_AMT

RATING_DATE Date this record was created or updated. DATE

AMREXRT

AMRPRRT

AMREXRT_ACTIVITY_DATE

AMRPRRT_ACTIVITY_DATE

RATING_DESC Rate description. VARCHAR2(30)

ATVRATE

ATVRATE_DESC

RATING_LEVEL Matching level of external source code. VARCHAR2(4)

AMREXRT

AMREXRT_EXT_LEVEL

RATING_TYPE Rating type code. VARCHAR2(5)

AMREXRT

AMRPRRT

AMREXRT_EXRS_CODE

AMRPRRT_RTGT_CODE

RATING_TYPE_DESC Rate type description. VARCHAR2(30)

ATVEXRS

ATVRTGT

ATVEXRS_DESC

ATVRTGT_DESC

SCREENING Screening code. VARCHAR2(5)

AMRPRRT

AMRPRRT_RSCR_CODE

SCREENING_DESC Rating screen description. VARCHAR2(30)

ATVRSCR

ATVRSCR_DESC

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

NA

NA



Ver: 8.0