Table - dbo.DimEmployee

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
Citizenship	varchar(30)	False	False	False			Descriptive name for the United States citizenshil status of the employee.
CitizenshipCode	varchar(3)	False	False	False			Indication of the United States citizenship status of the employee.
Country	varchar(30)	False	False	False			Descriptive name for the country where a student was born.
CountryCode	varchar(3)	False	False	False			Indication of the country where the student was born.
CountryOfCitizenship	varchar(30)	False	False	False			Descriptive name for the country where a student has citizenship.
CountryOfCitizenshipCode	varchar(3)	False	False	False			Indication of the country where the student has citizenship.
County	varchar(45)	False	False	False			Descriptive name for the county where the employee resides.
CountyFIPSCode	varchar(5)	False	False	False			The assigned FIPS code for the county, based on the zip code of where the employee resides.
DateOfBirth	date(10, 0)	False	False	False
EmployeeAK	int(10, 0)	False	False	False			Business key for the Employee, this will contain the Person ID assigned by the source system.
EmployeeFulltimeParttime	varchar(10)	False	False	False			Indication as to the most recent employment status of the employee based on their employment data.
EmployeeSK	int(10, 0)	False	False	False	(1 / 1)		Surrogate primary key
EmployeeStudentId	varchar(9)	False	False	False			The unique number assigned to the employee by the student system, to be used by the employee for registration and enrollment.
EmployeeType	varchar(30)	False	False	False			Descriptive name for the type of employee.
EmployeeTypeCode	varchar(8)	False	False	False			An indication of the type of employee.
Ethnicity	varchar(30)	False	False	False			Descriptive name for the ethnicity of a Employee.
EthnicityCode	varchar(3)	False	False	False			Code indicating the ethnicity of a Employee.
FirstName	varchar(30)	False	False	False			Current first name of a Employee.
FullName	varchar(80)	False	False	False			Current full name for the Employee in Last Name, comma, First Name and Middle Name format.
FunctionCode	varchar(3)	False	False	False			Code to indicate the function of position based on the primary salary account number assigned to the most recent assignment for
FunctionDesc	varchar(60)	False	False	False			Descriptive name for the function of position for the most recent assignment for the employee. This will include Management, In
Gender	varchar(30)	False	False	False			Descriptive name for the gender of a Employee.
GenderCode	varchar(3)	False	False	False			Code for the gender of a Employee.
HasActiveAssignment	varchar(3)	False	False	False			Indication that the employee has a currently active assignment at the institution.
HasDirectDeposit	varchar(3)	False	False	False			Indication that the employee currently uses direct deposit for their payroll processing.
HireDate	datetime(23, 3)	False	False	False			The most recent hire date of the employee by the institution.
IsAStudent	varchar(3)	False	False	False			Indication that the employee is or has been a student at the institution.
LastActiveAssignmentDateRange	varchar(30)	False	False	False			An indication how long the employee has not had an active assignment at the instiution. The values include 1 to 3 Months, 4 to
LastName	varchar(50)	False	False	False			Current last name of a Employee.
LastPayCheckDateRange	varchar(30)	False	False	False			An indication by range
Location	varchar(60)	False	False	False
LocationCode	varchar(3)	False	False	False
MiddleInitial	varchar(3)	False	False	False			Current middle initial of a Employee.
NumberOfActiveAssignments	int(10, 0)	False	False	False			The number of Active assignments this employee has
PersonID	int(10, 0)	False	False	False			Unique identifier assigned to each employee by the source system.
PositionType	varchar(60)	False	False	False			Descriptive name for the type of position for the most recent assignment for the employee. This will include Management, Instru
PositionTypeCode	varchar(3)	False	False	False			Code to indicate the type of position based on the primary salary account number assigned to the most recent assignment for the
PrimarySalaryAccountNumber	varchar(28)	False	False	False			The current primary salary expense account for the position for the most recent assignment for the employee.
RowEndDate	datetime(23, 3)	False	False	False		('12/31/9999')	When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent	nchar(1)	False	False	False			Is this the current row for this member (Y/N)?
RowStartDate	datetime(23, 3)	False	False	False			When did this row become valid for this member?
State	varchar(30)	False	False	False			Descriptive name for the state where the employee is residing.
StateCode	varchar(3)	False	False	False			Indicator for the state where the employee is residing.
TerminationDate	datetime(23, 3)	False	False	False			The most recent termination date of the employee by the institution, if the employee is currently separated from the institution
TerminationDateRange	varchar(30)	False	False	False			An indication how long the employee has been separated from the instiution. The values include 1 to 3 Months, 4 to 6 Months, 7
YearsOfServiceToInstitution	smallint(5, 0)	False	False	False			The number of years the employees has worked for the institution, based on their employment data.
ZipCode	varchar(11)	False	False	False			The zip code for where the employee is residing.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_dbo.DimEmployee	True	EmployeeSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name	Type
dbo.FactCheckComponent	Table
dbo.FactCheckSummary	Table
dbo.FactHoursReportedByDay	Table
dbo.FactHoursWorkedByWeek	Table
dbo.FactPositionExpense	Table

Name	Type
dbo.FactCheckComponent	TABLE
dbo.FactCheckSummary	TABLE
dbo.FactHoursReportedByDay	TABLE
dbo.FactHoursWorkedByWeek	TABLE
dbo.FactPositionExpense	TABLE

Object	Property	Value
DimEmployee	Display Name	Employee
DimEmployee	Table Description	The dimension will contain one row per Employee and Non-Employee at the institution and will include demographic, descriptives
DimEmployee	Table Type	Dimension
Citizenship	MS_Description	Descriptive name for the United States citizenshil status of the employee.
CitizenshipCode	MS_Description	Indication of the United States citizenship status of the employee.
Country	MS_Description	Descriptive name for the country where a student was born.
CountryCode	MS_Description	Indication of the country where the student was born.
CountryOfCitizenship	MS_Description	Descriptive name for the country where a student has citizenship.
CountryOfCitizenshipCode	MS_Description	Indication of the country where the student has citizenship.
County	MS_Description	Descriptive name for the county where the employee resides.
CountyFIPSCode	MS_Description	The assigned FIPS code for the county, based on the zip code of where the employee resides.
EmployeeAK	MS_Description	Business key for the Employee, this will contain the Person ID assigned by the source system.
EmployeeFulltimeParttime	MS_Description	Indication as to the most recent employment status of the employee based on their employment data.
EmployeeSK	MS_Description	Surrogate primary key
EmployeeStudentId	MS_Description	The unique number assigned to the employee by the student system, to be used by the employee for registration and enrollment.
EmployeeType	MS_Description	Descriptive name for the type of employee.
EmployeeTypeCode	MS_Description	An indication of the type of employee.
Ethnicity	MS_Description	Descriptive name for the ethnicity of a Employee.
EthnicityCode	MS_Description	Code indicating the ethnicity of a Employee.
FirstName	MS_Description	Current first name of a Employee.
FullName	MS_Description	Current full name for the Employee in Last Name, comma, First Name and Middle Name format.
FunctionCode	MS_Description	Code to indicate the function of position based on the primary salary account number assigned to the most recent assignment for
FunctionDesc	MS_Description	Descriptive name for the function of position for the most recent assignment for the employee. This will include Management, In
Gender	MS_Description	Descriptive name for the gender of a Employee.
GenderCode	MS_Description	Code for the gender of a Employee.
HasActiveAssignment	MS_Description	Indication that the employee has a currently active assignment at the institution.
HasDirectDeposit	MS_Description	Indication that the employee currently uses direct deposit for their payroll processing.
HireDate	MS_Description	The most recent hire date of the employee by the institution.
IsAStudent	MS_Description	Indication that the employee is or has been a student at the institution.
LastActiveAssignmentDateRange	MS_Description	An indication how long the employee has not had an active assignment at the instiution. The values include 1 to 3 Months, 4 to
LastName	MS_Description	Current last name of a Employee.
LastPayCheckDateRange	MS_Description	An indication by range
MiddleInitial	MS_Description	Current middle initial of a Employee.
NumberOfActiveAssignments	MS_Description	The number of Active assignments this employee has
PersonID	MS_Description	Unique identifier assigned to each employee by the source system.
PositionType	MS_Description	Descriptive name for the type of position for the most recent assignment for the employee. This will include Management, Instru
PositionTypeCode	MS_Description	Code to indicate the type of position based on the primary salary account number assigned to the most recent assignment for the
PrimarySalaryAccountNumber	MS_Description	The current primary salary expense account for the position for the most recent assignment for the employee.
RowEndDate	MS_Description	When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent	MS_Description	Is this the current row for this member (Y/N)?
RowStartDate	MS_Description	When did this row become valid for this member?
State	MS_Description	Descriptive name for the state where the employee is residing.
StateCode	MS_Description	Indicator for the state where the employee is residing.
TerminationDate	MS_Description	The most recent termination date of the employee by the institution, if the employee is currently separated from the institution
TerminationDateRange	MS_Description	An indication how long the employee has been separated from the instiution. The values include 1 to 3 Months, 4 to 6 Months, 7
YearsOfServiceToInstitution	MS_Description	The number of years the employees has worked for the institution, based on their employment data.
ZipCode	MS_Description	The zip code for where the employee is residing.

Object

Property

Value

/****** Object: Table [dbo].[DimEmployee] Script Date: 03/09/2017 17:14:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimEmployee](
    [EmployeeSK] [int] IDENTITY(1,1) NOT NULL,
    [EmployeeAK] [int] NOT NULL,
    [PersonID] [int] NOT NULL,
    [EmployeeTypeCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EmployeeType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FullName] [varchar](80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LastName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FirstName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [MiddleInitial] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GenderCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Gender] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EthnicityCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Ethnicity] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StateCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [State] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ZipCode] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CountyFIPSCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [County] [varchar](45) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CountryCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Country] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CitizenshipCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Citizenship] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CountryOfCitizenshipCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CountryOfCitizenship] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HasActiveAssignment] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [NumberOfActiveAssignments] [int] NOT NULL,
    [LastActiveAssignmentDateRange] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LastPayCheckDateRange] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PositionTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PositionType] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionDesc] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LocationCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Location] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrimarySalaryAccountNumber] [varchar](28) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [IsAStudent] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EmployeeStudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HasDirectDeposit] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HireDate] [datetime] NOT NULL,
    [EmployeeFulltimeParttime] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TerminationDate] [datetime] NOT NULL,
    [TerminationDateRange] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [YearsOfServiceToInstitution] [smallint] NOT NULL,
    [DateOfBirth] [date] NOT NULL,
    [RowIsCurrent] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NOT NULL,
CONSTRAINT [PK_dbo.DimEmployee] PRIMARY KEY CLUSTERED
(
    [EmployeeSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[DimEmployee] ADD  CONSTRAINT [DF__DimEmploy__RowEn__297722B6]  DEFAULT ('12/31/9999') FOR [RowEndDate]

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Employee' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee'

EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The dimension will contain one row per Employee and Non-Employee at the institution and will include demographic, descriptives' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee'

EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the United States citizenshil status of the employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'Citizenship'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the United States citizenship status of the employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'CitizenshipCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the country where a student was born.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'Country'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the country where the student was born.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'CountryCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the country where a student has citizenship.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'CountryOfCitizenship'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the country where the student has citizenship.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'CountryOfCitizenshipCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the county where the employee resides.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'County'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The assigned FIPS code for the county, based on the zip code of where the employee resides.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'CountyFIPSCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key for the Employee, this will contain the Person ID assigned by the source system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'EmployeeAK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication as to the most recent employment status of the employee based on their employment data.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'EmployeeFulltimeParttime'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'EmployeeSK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The unique number assigned to the employee by the student system, to be used by the employee for registration and enrollment.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'EmployeeStudentId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'EmployeeType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of the type of employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'EmployeeTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the ethnicity of a Employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'Ethnicity'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the ethnicity of a Employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'EthnicityCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current first name of a Employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'FirstName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current full name for the Employee in Last Name, comma, First Name and Middle Name format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'FullName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code to indicate the function of position based on the primary salary account number assigned to the most recent assignment for ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'FunctionCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the function of position for the most recent assignment for the employee. This will include Management, In' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'FunctionDesc'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the gender of a Employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'Gender'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the gender of a Employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'GenderCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the employee has a currently active assignment at the institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'HasActiveAssignment'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the employee currently uses direct deposit for their payroll processing.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'HasDirectDeposit'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The most recent hire date of the employee by the institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'HireDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication that the employee is or has been a student at the institution.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'IsAStudent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication how long the employee has not had an active assignment at the instiution. The values include 1 to 3 Months, 4 to ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'LastActiveAssignmentDateRange'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current last name of a Employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'LastName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication by range ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'LastPayCheckDateRange'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current middle initial of a Employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'MiddleInitial'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number of Active assignments this employee has' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'NumberOfActiveAssignments'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique identifier assigned to each employee by the source system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'PersonID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of position for the most recent assignment for the employee. This will include Management, Instru' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'PositionType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code to indicate the type of position based on the primary salary account number assigned to the most recent assignment for the ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'PositionTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The current primary salary expense account for the position for the most recent assignment for the employee.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'PrimarySalaryAccountNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become invalid? (12/31/9999 if current row)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Is this the current row for this member (Y/N)?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become valid for this member?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the state where the employee is residing.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'State'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicator for the state where the employee is residing.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'StateCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The most recent termination date of the employee by the institution, if the employee is currently separated from the institution' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'TerminationDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication how long the employee has been separated from the instiution. The values include 1 to 3 Months, 4 to 6 Months, 7 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'TerminationDateRange'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number of years the employees has worked for the institution, based on their employment data.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'YearsOfServiceToInstitution'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The zip code for where the employee is residing.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimEmployee', @level2type=N'COLUMN',@level2name=N'ZipCode'

Citizenship

CitizenshipCode

Country

CountryCode

CountryOfCitizenship

CountryOfCitizenshipCode

County

CountyFIPSCode

DateOfBirth

EmployeeAK

EmployeeFulltimeParttime

EmployeeSK

EmployeeStudentId

EmployeeType

EmployeeTypeCode

Ethnicity

EthnicityCode

FirstName

FullName

FunctionCode

FunctionDesc

Gender

GenderCode

HasActiveAssignment

HasDirectDeposit

HireDate

IsAStudent

LastActiveAssignmentDateRange

LastName

LastPayCheckDateRange

Location

LocationCode

MiddleInitial

NumberOfActiveAssignments

PersonID

PositionType

PositionTypeCode

PrimarySalaryAccountNumber

RowEndDate

RowIsCurrent

RowStartDate

State

StateCode

TerminationDate

TerminationDateRange

YearsOfServiceToInstitution

ZipCode

U.S. Citizen

United States

Palm Beach

099

1989-05-25T00:00:00-04:00

89598

Part Time

15045

N/A

Employee

FROMEMPL

Not Hispanic Or Latino

Brendon

Despeignes, Brendon J

Student Support

Male

Yes

2014-01-14T00:00:00-05:00

N/A

Despeignes

1 to 3 Months

President

89598

Ops-Technical

15102000-510213-10-57001

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

1900-01-01T00:00:00-05:00

N/A

33410

U.S. Citizen

United States

Palm Beach

099

1978-05-31T00:00:00-04:00

10895

Part Time

9731

N/A

Employee

FROMEMPL

Not Reported

Claudia

Ferrieri, Claudia J

Institutional Support

Female

2003-01-28T00:00:00-05:00

More than 2 Years

Ferrieri

More than 2 Years

Unknown

10895

Ops-Technical

16720000-672001-93-57000

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

2003-03-13T00:00:00-05:00

More than 2 Years

33405

U.S. Citizen

United States

Palm Beach

099

1967-07-22T00:00:00-04:00

2110

Part Time

2466

N/A

Employee

FROMEMPL

Not Reported

Mark

Wallace, Mark P

N/A

Unknown

Male

1997-05-12T00:00:00-04:00

N/A

Wallace

N/A

Unknown

N/A

2110

Unknown

N/A

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

2000-11-15T00:00:00-05:00

More than 2 Years

33402

U.S. Citizen

United States

Palm Beach

099

1965-11-21T00:00:00-05:00

77838

Part Time

11792

N/A

Employee

FROMEMPL

Not Hispanic Or Latino

Marisa

Taylor, Marisa S

Direct Instruction

Female

Yes

2010-07-14T00:00:00-04:00

1 to 3 Months

Taylor

1 to 3 Months

President

77838

Ops-Instructional, Other Professioanl

11230100-230105-10-56000

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

1900-01-01T00:00:00-05:00

N/A

33414

U.S. Citizen

United States

Palm Beach

099

1972-06-02T00:00:00-04:00

87795

Full Time

12849

N/A

Employee

FROMEMPL

Hispanic Or Latino

Ricardo

Rosales, Ricardo

Academic Support

Male

Yes

2011-10-17T00:00:00-04:00

N/A

Rosales

1 to 3 Months

President

87795

Personnel Cost-Other Professional

14102000-410200-10-53000

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

1900-01-01T00:00:00-05:00

N/A

33405

U.S. Citizen

United States

Palm Beach

099

1977-03-13T00:00:00-05:00

3056

Part Time

3206

N/A

Employee

FROMEMPL

Not Reported

Tanisha

Kavekos, Tanisha L

Student Support

Female

1998-10-20T00:00:00-04:00

More than 2 Years

Kavekos

N/A

President

3056

Stud Employment, Employee Awards

25500000-500001-10-58100

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

2000-11-15T00:00:00-05:00

More than 2 Years

33476

U.S. Citizen

United States

Palm Beach

099

1959-05-20T00:00:00-04:00

57788

Full Time

10417

N/A

Employee

FROMEMPL

Not Hispanic Or Latino

Bonnie

Fazio, Bonnie L

Academic Support

Female

Yes

2008-03-17T00:00:00-04:00

N/A

Fazio

1 to 3 Months

Vice Pres/Provost Main Campus

57788

Personnel Cost-Technical

14603000-460300-20-54000

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

1900-01-01T00:00:00-05:00

N/A

33478

U.S. Citizen

United States

Polk

105

1984-09-13T00:00:00-04:00

37860

Part Time

9074

N/A

Employee

FROMEMPL

Not Reported

Magdala

Cox, Magdala

Student Support

Female

2007-01-22T00:00:00-05:00

More than 2 Years

Cox

More than 2 Years

Vice Pres Of Admin & Finance

37860

Stud Employment, Employee Awards

25500000-500003-50-58100

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

2007-05-08T00:00:00-04:00

More than 2 Years

33859

U.S. Citizen

United States

Palm Beach

099

1971-08-25T00:00:00-04:00

2912

Part Time

2823

N/A

Employee

FROMEMPL

Not Reported

Michael

Goldberg, Michael P

Physical Plant Operational And Maintenance

Male

1998-08-27T00:00:00-04:00

More than 2 Years

Goldberg

N/A

Martin County Psav Prgms

2912

Ops-Technical

17200000-720004-80-57000

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

1998-12-31T00:00:00-05:00

More than 2 Years

33458

U.S. Citizen

United States

Palm Beach

099

1943-07-25T00:00:00-04:00

2703

Part Time

1991

N/A

Employee

FROMEMPL

Not Reported

Harriet

Mccormes-Ballou, Harriet A

Direct Instruction

Female

1998-08-20T00:00:00-04:00

More than 2 Years

Mccormes-Ballou

More than 2 Years

President

2703

Ops-Instructional, Other Professioanl

11180600-180600-10-56000

9999-12-31T23:59:00-05:00

2017-03-09T12:13:00-05:00

Florida

1999-05-16T00:00:00-04:00

More than 2 Years

33401

Property	Value
Name	DimEmployee
Schema	dbo
Row Count	17385
Data Size	7704 KB
Index Size	48 KB
Create Date	3/9/2017 10:43 AM
Description