RETURN TO BANNER EDW META DATA REPORTS LIST
Hold Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_HOLD

Description Hold dimension provides relevant data on holds.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
APPLICATION_HOLD_IND Indicates if this hold restriction prevents the creation of an admissions application. VARCHAR2(63)

HOLD

APPLICATION_HOLD_IND

NO

NO HOLD
AR_HOLD_IND Indicates if this is an accounts receivable hold and all activity is prohibited to the account. VARCHAR2(63)

HOLD

AR_HOLD_IND

NO

NO HOLD
COMPLIANCE_HOLD_IND Indicates if this hold restriction prevents the degree requirement compliance process being performed. VARCHAR2(63)

HOLD

COMPLIANCE_HOLD_IND

NO

NO HOLD
ENRL_VERIFICATION_HOLD_IND Indicates if this hold restriction prohibits the release of an enrollment verification. VARCHAR2(63)

HOLD

ENRL_VERIFICATION_HOLD_IND

NO

NO HOLD
GRADE_REPORT_HOLD_IND Indicates if this hold restriction prohibits the release of grades. VARCHAR2(63)

HOLD

GRADE_REPORT_HOLD_IND

NO

NO HOLD
GRADUATION_HOLD_IND Indicates if this hold restriction prohibits graduation. VARCHAR2(63)

HOLD

GRADUATION_HOLD_IND

NO

NO HOLD
HOLD Hold type. VARCHAR2(63)

HOLD

HOLD

NO

NO HOLD
HOLD_KEY Key for the hold dimension. NUMBER

ETL GENERATED

NA

NO

NO HOLD
HOLD_LD Long description for the type of hold. VARCHAR2(255)

HOLD

HOLD_DESC

NO

NO HOLD
HOLD_ORIGINATING_OFFICE Office/department that originated the hold. VARCHAR2(63)

HOLD

HOLD_ORIGINATING_OFFICE

NO

NO HOLD
HOLD_ORIGINATING_OFFICE_LD Long description of the originating office/department. VARCHAR2(255)

HOLD

HOLD_ORIGINATING_OFFICE_DESC

NO

NO HOLD
HOLD_ORIGINATING_OFFICE_SD Short description of the originating office/department. VARCHAR2(255)

HOLD

HOLD_ORIGINATING_OFFICE_DESC

NO

NO HOLD
HOLD_SD Short description for the type of hold. VARCHAR2(255)

HOLD

HOLD_DESC

NO

NO HOLD
REGISTRATION_HOLD_IND Indicates if this hold restriction prohibits registration activity. VARCHAR2(63)

HOLD

REGISTRATION_HOLD_IND

NO

NO HOLD
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO HOLD
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO HOLD
TRANSCRIPT_HOLD_IND Indicates if this hold restriction prohibits the release of an official academic transcript. VARCHAR2(63)

HOLD

TRANSCRIPT_HOLD_IND

NO

NO HOLD


Ver: 9.0