DIM_EDUCATIONADDITIONALINFORMATION_STAGE
Intermediate storage table for DIM_EDUCATIONADDITIONALINFORMATION
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EDUCATIONADDITIONALINFORMATIONSYSTEMID | uniqueidentifier | yes | dbo.[EDUCATIONADDITIONALINFORMATION].[ID] | |
| EDUCATIONSYSTEMID | uniqueidentifier | yes | dbo.[EDUCATIONADDITIONALINFORMATION].[EDUCATIONALHISTORYID] | |
| ACADEMICCATALOGCOLLEGE | nvarchar(150) | yes | dbo.[ACADEMICCATALOGCOLLEGE].[NAME] | |
| ACADEMICCATALOGDIVISION | nvarchar(150) | yes | dbo.[ACADEMICCATALOGDIVISION].[NAME] | |
| ACADEMICCATALOGDEPARTMENT | nvarchar(150) | yes | dbo.[ACADEMICCATALOGDEPARTMENT].[NAME] | |
| ACADEMICCATALOGSUBDEPARTMENT | nvarchar(150) | yes | dbo.[ACADEMICCATALOGSUBDEPARTMENT].[NAME] | |
| ACADEMICCATALOGDEGREETYPE | nvarchar(100) | yes | dbo.[ACADEMICCATALOGDEGREETYPECODE].[DESCRIPTION] | |
| EDUCATIONALCOLLEGE | nvarchar(100) | yes | dbo.[EDUCATIONALCOLLEGECODE].[DESCRIPTION] | |
| EDUCATIONALDIVISION | nvarchar(100) | yes | dbo.[EDUCATIONALDIVISIONCODE].[DESCRIPTION] | |
| EDUCATIONALDEPARTMENT | nvarchar(100) | yes | dbo.[EDUCATIONALDEPARTMENTCODE].[DESCRIPTION] | |
| EDUCATIONALSUBDEPARTMENT | nvarchar(100) | yes | dbo.[EDUCATIONALSUBDEPARTMENTCODE].[DESCRIPTION] | |
| EDUCATIONALDEGREETYPE | nvarchar(100) | yes | dbo.[EDUCATIONALDEGREETYPECODE].[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 |