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

SGHE Banner Operational Data Store
Composite View Target: AA_DESIGNATION_ID

Description Source composite view contains information about contacts, report recipients, and other individuals or organizations associated to a designation.
Key & Frequency One row per designation per designation id.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVE_ID_IND Designation ID status active indicator. Determines if the status is active (Y)es, or incative (N)o.    

ATVDIST

ATVDIST_ACTIVE_IND

 
ACTIVITY_DATE Date that information for this record in the table was entered or last updated.    

ADRDIDS

ADRDIDS_ACTIVITY_DATE

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DESIGNATION User defined code for a designation.    

ADRDIDS

ADRDIDS_DESG

 
DESIGNATION_ID_USER_ID Unique identification code of the user who entered or last touched the designation ID.    

ADRDIDS

ADRDIDS_USER

 
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.    

ADRDIDS

ADRDIDS_PIDM

 
ID_ADDRESS_TYPE Address type of the ID for this designation.    

ADRDIDS

ADRDIDS_ATYP_CODE

 
ID_COMMENT Free-form comments regarding the designation ID.    

ADRDIDS

ADRDIDS_COMMENT

 
ID_END_DATE Date that the ID is no longer active for the designation.    

ADRDIDS

ADRDIDS_END_DATE

 
ID_START_DATE Date that the ID becomes active for the designation.    

ADRDIDS

ADRDIDS_START_DATE

 
ID_STATUS Designation ID status.    

ADRDIDS

ADRDIDS_DIST_CODE

 
ID_STATUS_DESC Designation ID status description.    

ATVDIST

ATVDIST_DESC

 
ID_TYPE Type of designation ID.    

ADRDIDS

ADRDIDS_DITP_CODE

 
ID_TYPE_DESC Designation ID type description.    

ATVDITP

ATVDITP_DESC

 
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

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

NA

NA

 


Ver: 8.3