DWOperations
 dbo.Verify_dbo_DimEmployee (Table)
Home  Diagrams  Documents  Images  DWOperations  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWOperations   Tables   dbo.Verify_dbo_DimEmployee
  Properties
Property Value
Name Verify_dbo_DimEmployee
Schema dbo
Row Count 17384
Data Size 7432 KB
Index Size 40 KB
Create Date 3/9/2017 10:45 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Citizenship
varchar(30)
False
False
False
 
CitizenshipCode
varchar(3)
False
False
False
 
Country
varchar(30)
False
False
False
 
CountryCode
varchar(3)
False
False
False
 
CountryOfCitizenship
varchar(30)
False
False
False
 
CountryOfCitizenshipCode
varchar(3)
False
False
False
 
County
varchar(45)
False
False
False
 
CountyFIPSCode
varchar(5)
False
False
False
 
DateOfBirth
date(10, 0)
False
False
False
 
EmployeeAK
int(10, 0)
False
False
False
 
EmployeeFulltimeParttime
varchar(10)
False
False
False
 
EmployeeStudentId
varchar(9)
False
False
False
 
EmployeeType
varchar(30)
False
False
False
 
EmployeeTypeCode
varchar(8)
False
False
False
 
Ethnicity
varchar(30)
False
False
False
 
EthnicityCode
varchar(3)
False
False
False
 
FirstName
varchar(30)
False
False
False
 
FullName
varchar(80)
False
False
False
 
FunctionCode
varchar(3)
False
False
False
 
FunctionDesc
varchar(60)
False
False
False
 
Gender
varchar(30)
False
False
False
 
GenderCode
varchar(3)
False
False
False
 
HasActiveAssignment
varchar(3)
False
False
False
 
HasDirectDeposit
varchar(3)
False
False
False
 
HireDate
datetime(23, 3)
False
False
False
 
IsAStudent
varchar(3)
False
False
False
 
LastActiveAssignmentDateRange
varchar(30)
False
False
False
 
LastName
varchar(50)
False
False
False
 
LastPayCheckDateRange
varchar(30)
False
False
False
 
Location
varchar(60)
False
False
False
 
LocationCode
varchar(3)
False
False
False
 
MiddleInitial
varchar(3)
False
False
False
 
NumberOfActiveAssignments
int(10, 0)
True
False
False
 
PersonID
int(10, 0)
False
False
False
 
PositionType
varchar(60)
False
False
False
 
PositionTypeCode
varchar(3)
False
False
False
 
PrimarySalaryAccountNumber
varchar(28)
False
False
False
 
RowIsDuplicate
char(1)
False
False
False
 
RowIsSelected
char(1)
False
False
False
 
State
varchar(30)
False
False
False
 
StateCode
varchar(3)
False
False
False
 
TerminationDate
datetime(23, 3)
False
False
False
 
TerminationDateRange
varchar(30)
False
False
False
 
In Primary Key
VerifyEmployeeSK
int(10, 0)
False
False
False
(1 / 1)
YearsOfServiceToInstitution
smallint(5, 0)
False
False
False
 
ZipCode
varchar(11)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
VerifyEmployeeSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Verify_dbo_DimEmployee depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.Verify_dbo_DimEmployee)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Verify_dbo_DimEmployee] Script Date: 03/09/2017 17:21:47 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Verify_dbo_DimEmployee](
    [VerifyEmployeeSK] [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] 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,
    [RowIsDuplicate] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsSelected] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_DimEmployee] PRIMARY KEY CLUSTERED 
(
    [VerifyEmployeeSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  Sample Data
Citizenship CitizenshipCode Country CountryCode CountryOfCitizenship CountryOfCitizenshipCode County CountyFIPSCode DateOfBirth EmployeeAK EmployeeFulltimeParttime 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 RowIsDuplicate RowIsSelected State StateCode TerminationDate TerminationDateRange VerifyEmployeeSK YearsOfServiceToInstitution ZipCode
U.S. CITIZEN C UNITED STATES US UNITED STATES US BROWARD 011 1952-05-22T00:00:00-04:00 434 Part Time N/A Employee FROMEMPL NOT HISPANIC OR LATINO N RICKY ALLGOOD, RICKY 11 Direct Instruction MALE M No Yes 1994-06-28T00:00:00-04:00 No More than 2 Years ALLGOOD More than 2 Years VICE PRES OF ADMIN & FINANCE 50 0 434 OPS-Instructional, Other Professioanl 56 11172200-172202-50-56000 N Y FLORIDA FL 2014-05-07T00:00:00-04:00 More than 2 Years 7647 19 33322
U.S. CITIZEN C UNITED STATES US UNITED STATES US BROWARD 011 1988-05-22T00:00:00-04:00 57620 Part Time N/A Employee FROMEMPL NOT REPORTED X BRITTNEY CYRISE, BRITTNEY 25 Student Support FEMALE F No Yes 2007-01-02T00:00:00-05:00 No More than 2 Years CYRISE More than 2 Years VICE PRES OF ADMIN & FINANCE 50 0 57620 Stud Employment, Employee Awards 58 25500000-500003-50-58100 N Y FLORIDA FL 2008-05-07T00:00:00-04:00 More than 2 Years 5255 1 33064
U.S. CITIZEN C UNITED STATES US UNITED STATES US BROWARD 011 1954-10-10T00:00:00-04:00 2690 Part Time N/A Employee FROMEMPL NOT REPORTED X MICHAEL ROBINSON, MICHAEL E N/A Unknown MALE M No No 1998-08-20T00:00:00-04:00 No N/A ROBINSON N/A Unknown N/A E 0 2690 Unknown N/A N/A N Y FLORIDA FL 1998-09-15T00:00:00-04:00 More than 2 Years 2380 0 33442
U.S. CITIZEN C UNITED STATES US UNITED STATES US PALM BEACH 099 1957-06-05T00:00:00-04:00 15132 Full Time N/A Employee FROMEMPL NOT HISPANIC OR LATINO N KAREN MOORE, KAREN D 21 Direct Instruction FEMALE F Yes Yes 2002-09-03T00:00:00-04:00 No N/A MOORE 1 to 3 Months VICE PRES/PROVOST MAIN CAMPUS 20 D 1 15132 Personnel Cost-Other Professional 53 21240100-240141-20-53000 N Y FLORIDA FL 1900-01-01T00:00:00-05:00 N/A 17178 14 33412
U.S. CITIZEN C UNITED STATES US UNITED STATES US PALM BEACH 099 1945-08-25T00:00:00-04:00 1781 Full Time N/A Employee FROMEMPL NOT REPORTED X BONNIE DONNELLY, BONNIE 15 Student Support FEMALE F No No 2004-07-01T00:00:00-04:00 No More than 2 Years DONNELLY More than 2 Years Unknown 94 0 1781 Personnel Cost-Technical 54 15800000-580000-94-54000 N Y FLORIDA FL 2006-05-12T00:00:00-04:00 More than 2 Years 4747 8 33463
U.S. CITIZEN C UNITED STATES US UNITED STATES US PALM BEACH 099 1962-12-28T00:00:00-05:00 6214 Part Time N/A Employee FROMEMPL NOT REPORTED X JEFFREY MARCUS, JEFFREY A 11 Direct Instruction MALE M No Yes 2010-06-08T00:00:00-04:00 No 1 to 2 Years MARCUS More than 2 Years PRESIDENT 10 A 0 6214 OPS-Technical 57 11121000-121000-10-57000 N Y FLORIDA FL 2015-12-17T00:00:00-05:00 1 to 2 Years 16902 5 33462
U.S. CITIZEN C UNITED STATES US UNITED STATES US PALM BEACH 099 1952-03-26T00:00:00-05:00 857 Part Time N/A Employee FROMEMPL NOT REPORTED X MARIE BENNINGTON, MARIE A 11 Direct Instruction FEMALE F No No 1995-08-21T00:00:00-04:00 No More than 2 Years BENNINGTON N/A VICE PRES OF ADMIN & FINANCE 50 A 0 857 OPS-Instructional, Other Professioanl 56 11250100-250101-50-56000 N Y FLORIDA FL 2000-11-15T00:00:00-05:00 More than 2 Years 13911 5 33432
LAWFUL PERMANENT RESIDENT P UNITED STATES US N/A N/A PALM BEACH 099 1986-03-09T00:00:00-05:00 82755 Part Time N/A Employee FROMEMPL NOT HISPANIC OR LATINO N NADEGE BELGRAVE, NADEGE 25 Student Support FEMALE F No No 2011-01-05T00:00:00-05:00 No More than 2 Years BELGRAVE More than 2 Years PRESIDENT 10 0 82755 Stud Employment, Employee Awards 58 25500000-500000-10-58100 N Y FLORIDA FL 2011-04-01T00:00:00-04:00 More than 2 Years 8370 0 33463
U.S. CITIZEN C UNITED STATES US UNITED STATES US PALM BEACH 099 1945-06-28T00:00:00-04:00 77847 Part Time N/A Employee FROMEMPL NOT HISPANIC OR LATINO N JUDY HAMBURGER, JUDY L 11 Direct Instruction FEMALE F No Yes 2010-08-23T00:00:00-04:00 No More than 2 Years HAMBURGER More than 2 Years VICE PRES/PROVOST MAIN CAMPUS 20 L 0 77847 OPS-Instructional, Other Professioanl 56 11140800-140803-20-56000 N Y FLORIDA FL 2012-05-15T00:00:00-04:00 More than 2 Years 14069 1 33436
U.S. CITIZEN C UNITED STATES US UNITED STATES US PALM BEACH 099 1957-07-16T00:00:00-04:00 31727 Part Time N/A Employee FROMEMPL NOT REPORTED X TERRELL MARIS, TERRELL W 11 Direct Instruction MALE M No No 2006-04-03T00:00:00-04:00 No More than 2 Years MARIS More than 2 Years Unknown 95 W 0 31727 OPS-Instructional, Other Professioanl 56 11260300-260309-95-56000 N Y FLORIDA FL 2006-10-21T00:00:00-04:00 More than 2 Years 4786 0 33463
Powered by BI Documenter