| EDUCATIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[EDUCATIONALHISTORY].[ID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[EDUCATIONALHISTORY].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[EDUCATIONALHISTORY].[CONSTITUENTID] |
| EDUCATIONINSTITUTION |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALINSTITUTION].[NAME] |
| EDUCATIONINSTITUTIONISAFFLIATED |
bit |
yes |
|
dbo.[EDUCATIONALINSTITUTION].[ISAFFILIATED] |
| EDUCATIONINSTITUTIONFICECODE |
nvarchar(50) |
yes |
|
dbo.[EDUCATIONALINSTITUTION].[FICECODE] |
| ISPRIMARYRECORD |
bit |
yes |
|
dbo.[EDUCATIONALHISTORY].[ISPRIMARYRECORD] |
| EDUCATIONTYPE |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALHISTORYTYPECODE].[DESCRIPTION] |
| EDUCATIONSTATUS |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALHISTORYSTATUSCODE].[DESCRIPTION] |
| EDUCATIONCONSTITUENCYSTATUS |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALHISTORYSTATUS].[DESCRIPTION] |
| EDUCATIONSTARTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[EDUCATIONALHISTORY].[STARTDATE] |
| EDUCATIONENDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[EDUCATIONALHISTORY].[ENDDATE] |
| CLASSOF |
int |
yes |
|
dbo.[EDUCATIONALHISTORY].[CLASSOF] |
| EDUCATIONDEGREE |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALDEGREECODE].[DESCRIPTION] |
| EDUCATIONPROGRAM |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALPROGRAMCODE].[DESCRIPTION] |
| ACADEMICCATALOGDEGREE |
nvarchar(150) |
yes |
|
dbo.[ACADEMICCATALOGDEGREE].[NAME] |
| ACADEMICCATALOGPROGRAM |
nvarchar(50) |
yes |
|
dbo.[ACADEMICCATALOGPROGRAM].[PROGRAM] |
| EDUCATIONAWARD |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALAWARDCODE].[DESCRIPTION] |
| PREFERREDCLASSYEAR |
int |
yes |
|
dbo.[EDUCATIONALHISTORY].[PREFERREDCLASSYEAR] |
| EDUCATIONINFORMATIONSOURCE |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALSOURCECODE].[DESCRIPTION] |
| EDUCATIONINFORMATIONSOURCEDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[EDUCATIONALHISTORY].[EDUCATIONALSOURCEDATE] |
| EDUCATIONLEVEL |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALHISTORYLEVELCODE].[DESCRIPTION] |
| EDUCATIONGRADUATEDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[EDUCATIONALHISTORY].[DATEGRADUATE] |
| EDUCATIONLEFTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[EDUCATIONALHISTORY].[DATELEFT] |
| EDUCATIONREASON |
nvarchar(100) |
yes |
|
dbo.[EDUCATIONALHISTORYREASONCODE].[DESCRIPTION] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process |
| SOURCEDIMID |
int |
yes |
|
Source system used |
| CONSTITUENCYIMPLIEDCODE |
tinyint |
yes |
|
dbo.[EDUCATIONALHISTORYSTATUS].[CONSTITUENCYIMPLIEDCODE] |
| EDUCATIONINFORMATIONSOURCEFUZZYDATE |
UDT_FUZZYDATE |
|
|
dbo.[EDUCATIONALHISTORY].[EDUCATIONALSOURCEDATE] |
| EDUCATIONGRADUATEFUZZYDATE |
UDT_FUZZYDATE |
|
|
dbo.[EDUCATIONALHISTORY].[DATEGRADUATED] |
| EDUCATIONLEFTFUZZYDATE |
UDT_FUZZYDATE |
|
|
dbo.[EDUCATIONALHISTORY].[DATELEFT] |
| EDUCATIONSTARTFUZZYDATE |
UDT_FUZZYDATE |
|
|
dbo.[EDUCATIONALHISTORY].[STARTDATE] |
| EDUCATIONENDFUZZYDATE |
UDT_FUZZYDATE |
|
|
dbo.[EDUCATIONALHISTORY].[ENDDATE] |
| EDUCATIONINFORMATIONSOURCEDATE |
datetime |
yes |
|
Derived from BBDW.[DIM_EDUCATION].[EDUCATIONINFORMATIONSOURCEFUZZYDATE] by using first day of month and/or year if not specified |
| EDUCATIONGRADUATEDATE |
datetime |
yes |
|
Derived from BBDW.[DIM_EDUCATION].[EDUCATIONGRADUATEFUZZYDATE] by using first day of month and/or year if not specified |
| EDUCATIONLEFTDATE |
datetime |
yes |
|
Derived from BBDW.[DIM_EDUCATION].[EDUCATIONLEFTFUZZYDATE] by using first day of month and/or year if not specified |
| EDUCATIONSTARTDATE |
datetime |
yes |
|
Derived from BBDW.[DIM_EDUCATION].[EDUCATIONSTARTFUZZYDATE] by using first day of month and/or year if not specified |
| EDUCATIONENDDATE |
datetime |
yes |
|
Derived from BBDW.[DIM_EDUCATION].[EDUCATIONENDFUZZYDATE] by using first day of month and/or year if not specified |