DWStaging
 dbo.EMPLOYEE_A (Table)
Home  Diagrams  Documents  Images  DWStaging  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:  DWStaging   Tables   dbo.EMPLOYEE_A
  Properties
Property Value
Name EMPLOYEE_A
Schema dbo
Row Count 91295
Data Size 22600 KB
Index Size 1408 KB
Create Date 2/26/2016 9:04 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ADD_DATE
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
ADJUSTED_AWARD_DATE
varchar(8)
True
False
False
 
ADJUSTED_HIRE_DATE
varchar(8)
True
False
False
 
AKA_NAME
varchar(15)
True
False
False
 
APT_SUITE_EMERG
varchar(15)
True
False
False
 
BACKGROUND_EXPIRE_DATE
varchar(8)
True
False
False
 
BACKGROUND_RUN_DATE
varchar(8)
True
False
False
 
BARGAINING_UNIT_FLAG
varchar(1)
True
False
False
 
BIRTH_DATE
varchar(8)
True
False
False
 
CHANGE_AWARD_DATE
varchar(1)
True
False
False
 
CHANGED_HIRE_DATE
varchar(1)
True
False
False
 
CITIZEN_COUNTRY_CODE
varchar(8)
True
False
False
 
CITIZEN_TYPE_CODE
varchar(8)
True
False
False
 
CITY_NAME_EMERG
varchar(20)
True
False
False
 
COBRA_DURATION_MONTHS
int(10, 0)
True
False
False
 
COBRA_ELIGIBILITY_DATE
varchar(8)
True
False
False
 
COBRA_END_DATE
varchar(8)
True
False
False
 
COBRA_NOTIFICATION_DATE
varchar(8)
True
False
False
 
COBRA_QUALIFYING_EVENT
varchar(1)
True
False
False
 
COBRA_START_DATE
varchar(8)
True
False
False
 
COBRA_SUSPENSE_DATE
varchar(8)
True
False
False
 
CONTRACT_END_DATE
varchar(8)
True
False
False
 
CONTRACT_START_DATE
varchar(8)
True
False
False
 
CONTRACT_TYPE
varchar(8)
True
False
False
 
COUNTRY_CODE_BIRTH
varchar(8)
True
False
False
 
COUNTRY_CODE_EMERG
varchar(8)
True
False
False
 
DATE_CONSENT_WITHDRAWN
varchar(8)
True
False
False
 
DATE_OF_CONSENT
varchar(8)
True
False
False
 
DIRECTION_EMERG
varchar(2)
True
False
False
 
DISABLED_STATUS_CODE
varchar(8)
True
False
False
 
DISABLITY_MET_IND
bit(1, 0)
True
False
False
 
DROP_END_DATE
varchar(8)
True
False
False
 
DROP_START_DATE
varchar(8)
True
False
False
 
EMPLOYEE_TYPE
varchar(1)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
ETHNIC_CODE
varchar(1)
True
False
False
 
FIRSTNAME
varchar(15)
True
False
False
 
FIRSTNAME_DOC_EMERG
varchar(15)
True
False
False
 
FIRSTNAME_EMERG
varchar(15)
True
False
False
 
FLEX_TIME_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOSPITAL_NAME_EMERG
varchar(30)
True
False
False
 
HOURS_WORKED_ADJ
numeric(7, 2)
True
False
False
 
HOURS_WORKED_TOTAL
numeric(7, 2)
True
False
False
 
HOUSE_NUMBER_EMERG
varchar(6)
True
False
False
 
I_9_INCOMPLETE_IND
bit(1, 0)
True
False
False
 
I_9_RECEIVED_DATE
varchar(8)
True
False
False
 
I_9_WORK_EXP_DATE
varchar(8)
True
False
False
 
ISN_EMPLOYEE_A
int(10, 0)
False
False
False
 
LASTNAME
varchar(50)
True
False
False
 
LASTNAME_DOC_EMERG
varchar(20)
True
False
False
 
LASTNAME_EMERG
varchar(50)
True
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
MARITAL_STATUS_CODE
varchar(1)
True
False
False
 
METHOD_CONSENT_WITHDRAWN
varchar(1)
True
False
False
 
METHOD_OF_CONSENT
varchar(1)
True
False
False
 
MIDDLE
varchar(20)
True
False
False
 
MIDDLE_EMERG
varchar(1)
True
False
False
 
MONTHS_SERVICE_OTHER
int(10, 0)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
PERSON_ID_EC
int(10, 0)
True
False
False
 
PERSON_ID_EOS
int(10, 0)
True
False
False
 
PERSON_ID_ETT
int(10, 0)
True
False
False
 
PERSON_ID_EW2
int(10, 0)
True
False
False
 
PHONE_DOC_EMERG
varchar(10)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
POST_TITLE
varchar(8)
True
False
False
 
POSTAL_CODE_EMERG
varchar(10)
True
False
False
 
PRE_TITLE
varchar(4)
True
False
False
 
REG_PT_HIRE_DATE
varchar(8)
True
False
False
 
RELATIONSHIP_CODE
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SEARCH_NAME
varchar(25)
True
False
False
 
SEQUENCE_NBR
int(10, 0)
True
False
False
 
SEX_CODE
varchar(1)
True
False
False
 
SSN
varchar(9)
True
False
False
 
SSN_EOS
varchar(9)
True
False
False
 
START_DATE
varchar(8)
True
False
False
 
START_DATE_9C
int(10, 0)
True
False
False
 
STATE_CODE_EMERG
varchar(2)
True
False
False
 
STREET_EMERG
varchar(30)
True
False
False
 
STUDENT_IND
bit(1, 0)
True
False
False
 
TAX_ADDITIONAL_AMOUNT
numeric(7, 2)
True
False
False
 
TAX_EXEMPT_IND
bit(1, 0)
True
False
False
 
TAX_EXEMPTION_COUNT
varchar(2)
True
False
False
 
TAX_MARITAL_CODE
varchar(1)
True
False
False
 
TAX_REPLACEMENT_AMOUNT
numeric(7, 2)
True
False
False
 
TAX_TYPE_CODE
varchar(8)
True
False
False
 
TENURED_DATE
varchar(8)
True
False
False
 
TIME_CONSENT_WITHDRAWN
int(10, 0)
True
False
False
 
TIME_OF_CONSENT
int(10, 0)
True
False
False
 
TRANSFER_NONEMP_IND
bit(1, 0)
True
False
False
 
VETERAN_USED_IND
bit(1, 0)
True
False
False
 
VISA_ALIEN_ID
varchar(12)
True
False
False
 
VISA_EXPIRE_DATE
varchar(8)
True
False
False
 
VISA_PORT_ENTRY
varchar(8)
True
False
False
 
VISA_TYPE_CODE
varchar(8)
True
False
False
 
ZIP_EMERG
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_EMPLOYEE_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.EMPLOYEE_A depends on)
Name Type
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.EMPLOYEE_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[EMPLOYEE_A] Script Date: 03/09/2017 16:45:11 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[EMPLOYEE_A](
    [ISN_EMPLOYEE_A] [int] NOT NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [PERSON_ID] [int] NULL,
    [SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LASTNAME] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIRSTNAME] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIDDLE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRE_TITLE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POST_TITLE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AKA_NAME] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEARCH_NAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BIRTH_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEX_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ETHNIC_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MARITAL_STATUS_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COUNTRY_CODE_BIRTH] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [I_9_INCOMPLETE_IND] [bit] NULL,
    [I_9_RECEIVED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [I_9_WORK_EXP_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUSTED_HIRE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUSTED_AWARD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_TYPE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VETERAN_USED_IND] [bit] NULL,
    [TRANSFER_NONEMP_IND] [bit] NULL,
    [STUDENT_IND] [bit] NULL,
    [BARGAINING_UNIT_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISABLITY_MET_IND] [bit] NULL,
    [DISABLED_STATUS_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CITIZEN_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOURS_WORKED_TOTAL] [numeric](7, 2) NULL,
    [VISA_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_ALIEN_ID] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CITIZEN_COUNTRY_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_PORT_ENTRY] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VISA_EXPIRE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LASTNAME_DOC_EMERG] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIRSTNAME_DOC_EMERG] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PHONE_DOC_EMERG] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOSPITAL_NAME_EMERG] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERSON_ID_ETT] [int] NULL,
    [TAX_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE_9C] [int] NULL,
    [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TAX_MARITAL_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TAX_EXEMPT_IND] [bit] NULL,
    [TAX_EXEMPTION_COUNT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TAX_ADDITIONAL_AMOUNT] [numeric](7, 2) NULL,
    [TAX_REPLACEMENT_AMOUNT] [numeric](7, 2) NULL,
    [PERSON_ID_EC] [int] NULL,
    [SEQUENCE_NBR] [int] NULL,
    [LASTNAME_EMERG] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIRSTNAME_EMERG] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIDDLE_EMERG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOUSE_NUMBER_EMERG] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET_EMERG] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DIRECTION_EMERG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APT_SUITE_EMERG] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CITY_NAME_EMERG] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATE_CODE_EMERG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ZIP_EMERG] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COUNTRY_CODE_EMERG] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSTAL_CODE_EMERG] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TENURED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COBRA_DURATION_MONTHS] [int] NULL,
    [COBRA_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COBRA_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COBRA_QUALIFYING_EVENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COBRA_ELIGIBILITY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COBRA_NOTIFICATION_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COBRA_SUSPENSE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOURS_WORKED_ADJ] [numeric](7, 2) NULL,
    [PERSON_ID_EOS] [int] NULL,
    [SSN_EOS] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMPLOYEE_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHANGE_AWARD_DATE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FLEX_TIME_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DROP_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DROP_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REG_PT_HIRE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RELATIONSHIP_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MONTHS_SERVICE_OTHER] [int] NULL,
    [CHANGED_HIRE_DATE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERSON_ID_EW2] [int] NULL,
    [DATE_OF_CONSENT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIME_OF_CONSENT] [int] NULL,
    [METHOD_OF_CONSENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DATE_CONSENT_WITHDRAWN] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIME_CONSENT_WITHDRAWN] [int] NULL,
    [METHOD_CONSENT_WITHDRAWN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BACKGROUND_RUN_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BACKGROUND_EXPIRE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADJUSTED_AWARD_DATE ADJUSTED_HIRE_DATE AKA_NAME APT_SUITE_EMERG BACKGROUND_EXPIRE_DATE BACKGROUND_RUN_DATE BARGAINING_UNIT_FLAG BIRTH_DATE CHANGE_AWARD_DATE CHANGED_HIRE_DATE CITIZEN_COUNTRY_CODE CITIZEN_TYPE_CODE CITY_NAME_EMERG COBRA_ELIGIBILITY_DATE COBRA_END_DATE COBRA_NOTIFICATION_DATE COBRA_QUALIFYING_EVENT COBRA_START_DATE COBRA_SUSPENSE_DATE CONTRACT_END_DATE CONTRACT_START_DATE CONTRACT_TYPE COUNTRY_CODE_BIRTH COUNTRY_CODE_EMERG DATE_CONSENT_WITHDRAWN DATE_OF_CONSENT DIRECTION_EMERG DISABLED_STATUS_CODE DISABLITY_MET_IND DROP_END_DATE DROP_START_DATE EMPLOYEE_TYPE END_DATE ETHNIC_CODE FIRSTNAME FIRSTNAME_DOC_EMERG FIRSTNAME_EMERG FLEX_TIME_IND HOLD HOSPITAL_NAME_EMERG HOUSE_NUMBER_EMERG I_9_INCOMPLETE_IND I_9_RECEIVED_DATE I_9_WORK_EXP_DATE ISN_EMPLOYEE_A LASTNAME LASTNAME_DOC_EMERG LASTNAME_EMERG MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MARITAL_STATUS_CODE METHOD_CONSENT_WITHDRAWN METHOD_OF_CONSENT MIDDLE MIDDLE_EMERG PERSON_ID_EW2 PERSON_ID_EC PERSON_ID_ETT PHONE_DOC_EMERG POSITION_CODE POST_TITLE POSTAL_CODE_EMERG PRE_TITLE REG_PT_HIRE_DATE RELATIONSHIP_CODE RowUpdatedOn SEARCH_NAME SEQUENCE_NBR SEX_CODE SSN SSN_EOS START_DATE START_DATE_9C STATE_CODE_EMERG STREET_EMERG STUDENT_IND TAX_EXEMPT_IND TAX_EXEMPTION_COUNT TAX_MARITAL_CODE TAX_TYPE_CODE TENURED_DATE TIME_CONSENT_WITHDRAWN TIME_OF_CONSENT TRANSFER_NONEMP_IND VETERAN_USED_IND VISA_ALIEN_ID VISA_EXPIRE_DATE VISA_PORT_ENTRY VISA_TYPE_CODE ZIP_EMERG
false 26991231 Z false 10510 8130 2017-02-06T10:50:48.86-05:00 20010222 79989777 false true S SOCSEC false false
false Z BEVERLY 1053219 false 32207 BOSTIC D 13785 2017-02-06T10:50:53.025-05:00 1 false false false false
false 26991231 Z false 21796 7519 2017-02-06T10:50:51.013-05:00 20010116 79989883 false false 02 S WITHHOLD false false
false 20080925 Z false 13626 438 2017-02-06T10:50:49.468-05:00 19990416 80009583 false false 06 M WITHHOLD false false
false 26991231 false 81325 90480 2017-02-06T10:51:02.416-05:00 20150209 79849790 false true S MEDICARE false false
false 26991231 false 87622 91498 2017-02-06T10:51:03.602-05:00 20160523 79839476 false true M SOCSEC false false
20161128 PEY354N1 1331066 WEB5 20161128 20161203 false 2208289 false 90720 20161203 PEY354N1 2208289 WEB5 W W 90138 2017-02-06T10:51:04.164-05:00 false false 1331066 2208289 false false
false Z THERESA 1026384 false 25743 BENIGNO 469 MOTHER 2017-02-06T10:50:51.746-05:00 1 false false false false
false MARLA 1225103 false 78341 NOBLE 89997 SPOUSE 2017-02-06T10:51:01.855-05:00 1 false false false false
false 26991231 false 47004 77732 2017-02-06T10:50:55.818-05:00 20100623 79899376 false false 01 S WITHHOLD false false
Powered by BI Documenter