DIM_EDUCATION_STAGE
The Education additional information dimension contains additional information about a constituents educational history.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EDUCATIONSYSTEMID | uniqueidentifier | yes | dbo.[EDUCATIONALHISTORY].[ID] | |
| 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 | char(8) | yes | dbo.[EDUCATIONALHISTORY].[EDUCATIONALSOURCEDATE] | |
| EDUCATIONGRADUATEFUZZYDATE | char(8) | yes | dbo.[EDUCATIONALHISTORY].[DATEGRADUATED] | |
| EDUCATIONLEFTFUZZYDATE | char(8) | yes | dbo.[EDUCATIONALHISTORY].[DATELEFT] | |
| EDUCATIONSTARTFUZZYDATE | char(8) | yes | dbo.[EDUCATIONALHISTORY].[STARTDATE] | |
| EDUCATIONENDFUZZYDATE | char(8) | yes | dbo.[EDUCATIONALHISTORY].[ENDDATE] |