|
![]() |
Property | Value |
Name | EMPLOYEE_LOG_A |
Schema | dbo |
Row Count | 750911 |
Data Size | 201840 KB |
Index Size | 11248 KB |
Create Date | 2/26/2016 9:04 AM |
Description |
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 |
|||
![]() |
![]() |
CHANGED_VIA_WEB |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
CHANGED_VIA_WEB_EC |
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 |
|||
![]() |
![]() |
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 |
|||
![]() |
![]() |
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_LOG_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 |
|||
![]() |
![]() |
LOG_ACTION |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
LOG_DATE |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
LOG_TID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
LOG_TIME |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
LOG_USER |
varchar(8) |
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_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 |
|||
![]() |
![]() |
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 |
|||
![]() |
![]() |
SURVEY_COMPLETED_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
SURVEY_PERSON_ID |
int(10, 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 |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_EMPLOYEE_LOG_A |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[EMPLOYEE_LOG_A] Script Date: 03/09/2017 16:45:14 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[EMPLOYEE_LOG_A]( [ISN_EMPLOYEE_LOG_A] [int] NOT NULL, [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LOG_DATE] [int] NULL, [LOG_TIME] [int] NULL, [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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, [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, [CHANGE_AWARD_DATE] [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, [CHANGED_VIA_WEB] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHANGED_VIA_WEB_EC] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SURVEY_PERSON_ID] [int] NULL, [SURVEY_COMPLETED_DATE] [varchar](8) 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] |
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 | CHANGED_VIA_WEB | CHANGED_VIA_WEB_EC | 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 | END_DATE | ETHNIC_CODE | FIRSTNAME | FIRSTNAME_DOC_EMERG | FIRSTNAME_EMERG | HOSPITAL_NAME_EMERG | HOUSE_NUMBER_EMERG | I_9_INCOMPLETE_IND | I_9_RECEIVED_DATE | I_9_WORK_EXP_DATE | ISN_EMPLOYEE_LOG_A | LASTNAME | LASTNAME_DOC_EMERG | LASTNAME_EMERG | LOG_ACTION | LOG_DATE | LOG_TID | LOG_TIME | LOG_USER | MAINT_DATE | MAINT_PGM | MAINT_TIME | MAINT_USER_ID | MARITAL_STATUS_CODE | METHOD_CONSENT_WITHDRAWN | METHOD_OF_CONSENT | MIDDLE | MIDDLE_EMERG | PERSON_ID_ETT | PERSON_ID | PHONE_DOC_EMERG | POSITION_CODE | POST_TITLE | POSTAL_CODE_EMERG | PRE_TITLE | REG_PT_HIRE_DATE | RELATIONSHIP_CODE | RowUpdatedOn | SEARCH_NAME | SEX_CODE | SSN | START_DATE | START_DATE_9C | STATE_CODE_EMERG | STREET_EMERG | STUDENT_IND | SURVEY_COMPLETED_DATE | TAX_EXEMPT_IND | TAX_EXEMPTION_COUNT | TAX_MARITAL_CODE | TAX_TYPE_CODE | TENURED_DATE | TRANSFER_NONEMP_IND | VETERAN_USED_IND | VISA_ALIEN_ID | VISA_EXPIRE_DATE | VISA_PORT_ENTRY | VISA_TYPE_CODE | ZIP_EMERG |
20070517 | PED200N | 1007095 | E000117 | N | 19870813 | C | 4 | Z | false | X | ANDREA | false | 273691 | DOWDELL | M | 20080604 | pts/144 | 1452475 | E037566 | 20080604 | PED200N | 1452475 | E037566 | S | C | 42807 | 2017-02-06T10:32:22.017-05:00 | DOWDELL,ANDREA,C | F | 820010023 | false | false | false | false | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
false | 26991231 | false | 422230 | M | 20100816 | <notty> | 1625246 | OPER2 | 57847 | 2017-02-06T10:32:53.904-05:00 | 20080408 | 79919591 | false | true | SOCSEC | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
false | 26991231 | Z | false | 241256 | M | 20071012 | pts/8 | 1139324 | E000117 | 27881 | 2017-02-06T10:32:14.857-05:00 | 20050216 | 79949783 | false | false | S | SOCSEC | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
false | 26991231 | false | 439129 | M | 20101202 | pts/138 | 925432 | E006065 | 26507 | 2017-02-06T10:32:57.82-05:00 | 20041025 | 79958974 | false | false | 03 | M | WITHHOLD | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
false | 20030220 | Z | false | 146970 | M | 20060424 | 0046 | 1411217 | E027936 | 3964 | 2017-02-06T10:31:53.36-05:00 | 19990927 | 80009072 | false | false | 02 | M | WITHHOLD | false | false | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
false | 20030723 | Z | false | 168204 | M | 20060906 | pts/4 | 659542 | E000117 | 4161 | 2017-02-06T10:31:58.196-05:00 | 19991116 | 80008883 | false | true | S | SOCSEC | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
false | 20050615 | Z | false | 297324 | M | 20080917 | <notty> | 1111027 | OPER2 | 16587 | 2017-02-06T10:32:26.775-05:00 | 20030109 | 79969890 | false | true | S | MEDICARE | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
20020122 | PED200N | 1005006 | SSULLIVA | N | 19700608 | P | 4 | Z | false | X | MICHELA | false | 83740 | ADAMS | M | 20040617 | 0157 | 1007515 | E000117 | 20040617 | PED200N | 1007515 | E000117 | M | 11918 | 2017-02-06T10:31:38.524-05:00 | ADAMS,MICHELA | F | 820005849 | false | false | false | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
20081202 | PED200N | 0837593 | E012720 | N | 19480325 | C | 4 | Z | false | X | LARRY | false | 386801 | RANDOLPH | M | 20100216 | <notty> | 926096 | E001579 | 20100216 | ADHOC1 | 926096 | E001579 | D | A | 67520 | 2017-02-06T10:32:46.353-05:00 | RANDOLPH,LARRY,A | M | 820011330 | false | false | false | false | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
false | 26991231 | false | 534981 | M | 20121003 | pts/155 | 830545 | E027036 | 67638 | 2017-02-06T10:33:19.847-05:00 | 20090126 | 79909873 | false | true | S | SOCSEC | false | false |
Powered by BI Documenter |