RETURN TO BANNER EDW META DATA REPORTS LIST
Admissions Recruitment Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_STUDENT_RECRUITMENT

Description Student Recruitment dimension table provides data specific to an admissions recruitment record. For example, the recruit status and the primary source for the recruit number.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
INSTITUTION_ATTENDING Institution the student is attending if the withdrawal was to attend a different institution. VARCHAR2(63)

RECRUITMENT_INFORMATION

OTHER_INSTITUTION

NO

NO ADMISSIONS RECRUITMENT
INSTITUTION_ATTENDING_LD Source/background institution name. VARCHAR2(255)

RECRUITMENT_INFORMATION

OTHER_INSTITUTION_DESC

NO

NO ADMISSIONS RECRUITMENT
INSTITUTION_ATTENDING_SD Source/background institution name. VARCHAR2(255)

RECRUITMENT_INFORMATION

OTHER_INSTITUTION_DESC

NO

NO ADMISSIONS RECRUITMENT
PRIMARY_SOURCE Source identified by the person at their first contact with the institution as having referred the person to this institution. Usually either the secondary or post-secondary school or newspaper advertisement. VARCHAR2(63)

RECRUITMENT_INFORMATION

PRIMARY_SOURCE

NO

NO ADMISSIONS RECRUITMENT
PRIMARY_SOURCE_LD Long description or name of the primary source of referral to the institution. VARCHAR2(255)

RECRUITMENT_INFORMATION

PRIMARY_SOURCE_DESC

NO

NO ADMISSIONS RECRUITMENT
PRIMARY_SOURCE_SD Short description or name of the primary source of referral to the institution. VARCHAR2(255)

RECRUITMENT_INFORMATION

PRIMARY_SOURCE_DESC

NO

NO ADMISSIONS RECRUITMENT
RECRUITER Recruiter assigned to the prospect's recruiting record. VARCHAR2(63)

RECRUITMENT_INFORMATION

RECRUITER

NO

NO ADMISSIONS RECRUITMENT
RECRUITER_LD Recruiter assigned to the prospect's recruiting record. VARCHAR2(255)

RECRUITMENT_INFORMATION

RECRUITER_DESC

NO

NO ADMISSIONS RECRUITMENT
RECRUITER_SD Recruiter assigned to the prospect's recruiting record. VARCHAR2(255)

RECRUITMENT_INFORMATION

RECRUITER_DESC

NO

NO ADMISSIONS RECRUITMENT
RECRUIT_STATUS Current status of this recruitment record, whether the status is determined by the institution or prospective student. VARCHAR2(63)

RECRUITMENT_INFORMATION

RECRUIT_STATUS

NO

NO ADMISSIONS RECRUITMENT
RECRUIT_STATUS_LD Long description recruit status. VARCHAR2(255)

RECRUITMENT_INFORMATION

RECRUIT_STATUS_DESC

NO

NO ADMISSIONS RECRUITMENT
RECRUIT_STATUS_SD Short description recruit status. VARCHAR2(255)

RECRUITMENT_INFORMATION

RECRUIT_STATUS_DESC

NO

NO ADMISSIONS RECRUITMENT
RECRUIT_TYPE Identifies the type of recruit used to classify this prospect. VARCHAR2(63)

RECRUITMENT_INFORMATION

RECRUIT_TYPE

NO

NO ADMISSIONS RECRUITMENT
RECRUIT_TYPE_LD Recruit type description. VARCHAR2(255)

RECRUITMENT_INFORMATION

RECRUIT_TYPE_DESC

NO

NO ADMISSIONS RECRUITMENT
RECRUIT_TYPE_SD Recruit type description. VARCHAR2(255)

RECRUITMENT_INFORMATION

RECRUIT_TYPE_DESC

NO

NO ADMISSIONS RECRUITMENT
STUDENT_RECRUITMENT_KEY Key for the student recruitment dimension. NUMBER

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

NO

NO ADMISSIONS RECRUITMENT
WITHDRAWAL_REASON If the student withdraws for the institution this identifies the major reason for the student withdrawal defined by institution values. VARCHAR2(63)

RECRUITMENT_INFORMATION

WITHDRAWAL_REASON

NO

NO ADMISSIONS RECRUITMENT
WITHDRAWAL_REASON_LD Long description for the withdrawal reason. VARCHAR2(255)

RECRUITMENT_INFORMATION

WITHDRAWAL_REASON_DESC

NO

NO ADMISSIONS RECRUITMENT
WITHDRAWAL_REASON_SD Short description for the withdrawal reason. VARCHAR2(255)

RECRUITMENT_INFORMATION

WITHDRAWAL_REASON_DESC

NO

NO ADMISSIONS RECRUITMENT


Ver: 9.0