RETURN TO DIMENSION TABLE 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 attending code which represents the institution the student decided to attend rather than the home 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 of the recruit which is flagged as the primary source. VARCHAR2(63)

RECRUITMENT_INFORMATION

PRIMARY_SOURCE

NO

NO ADMISSIONS RECRUITMENT
PRIMARY_SOURCE_LD Name of the source/background institution. VARCHAR2(255)

RECRUITMENT_INFORMATION

PRIMARY_SOURCE_DESC

NO

NO ADMISSIONS RECRUITMENT
PRIMARY_SOURCE_SD Name of the source/background 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 Reason the prospect withdraws interest in the institution. VARCHAR2(63)

RECRUITMENT_INFORMATION

WITHDRAWAL_REASON

NO

NO ADMISSIONS RECRUITMENT
WITHDRAWAL_REASON_LD Reason for withdrawal description. VARCHAR2(255)

RECRUITMENT_INFORMATION

WITHDRAWAL_REASON_DESC

NO

NO ADMISSIONS RECRUITMENT
WITHDRAWAL_REASON_SD Reason for withdrawal description. VARCHAR2(255)

RECRUITMENT_INFORMATION

WITHDRAWAL_REASON_DESC

NO

NO ADMISSIONS RECRUITMENT


Ver: 8.1