DWStaging
 dbo.EMPLOYEE_BENEFIT_LOG_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_BENEFIT_LOG_A
  Properties
Property Value
Name EMPLOYEE_BENEFIT_LOG_A
Schema dbo
Row Count 32075
Data Size 3984 KB
Index Size 520 KB
Create Date 11/2/2012 2:55 PM
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
 
BENEFIT_CODE
varchar(8)
True
False
False
 
BENEFIT_PAID_OUT
bit(1, 0)
True
False
False
 
DEDUCTION_CODE
varchar(8)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
ISN_EMPLOYEE_BENEFIT_LOG_A
int(10, 0)
False
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
 
ORIG_END_DATE_LOCKED_IND
bit(1, 0)
True
False
False
 
ORIGINAL_END_DATE
varchar(8)
True
False
False
 
PAY_CHECK_DATE
varchar(8)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
REFUSED
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
START_DATE
varchar(8)
True
False
False
 
START_DATE_9C
int(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_EMPLOYEE_BENEFIT_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.EMPLOYEE_BENEFIT_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.EMPLOYEE_BENEFIT_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[EMPLOYEE_BENEFIT_LOG_A] Script Date: 03/09/2017 16:45:12 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[EMPLOYEE_BENEFIT_LOG_A](
    [ISN_EMPLOYEE_BENEFIT_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,
    [REFUSED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BENEFIT_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERSON_ID] [int] 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,
    [PAY_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEDUCTION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BENEFIT_PAID_OUT] [bit] NULL,
    [ORIGINAL_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORIG_END_DATE_LOCKED_IND] [bit] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BENEFIT_CODE BENEFIT_PAID_OUT DEDUCTION_CODE END_DATE ISN_EMPLOYEE_BENEFIT_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID ORIG_END_DATE_LOCKED_IND ORIGINAL_END_DATE PAY_CHECK_DATE PERSON_ID REFUSED RowUpdatedOn START_DATE START_DATE_9C
20130416 PEB100N 1042372 E001501 FLRETHA false FLRETHA 20897 A 20130416 pts/2 1042372 E001501 false 20130416 72567 N 2017-02-06T11:18:18.383-05:00 20130416 79869583
20050823 PEB100N 0922348 E001676 FLRETHA false FLRETHA 20130131 20682 M 20130128 pts/9 957105 E001501 20130128 PEB100N 0957106 E001501 false 20050808 6162 N 2017-02-06T11:18:18.368-05:00 20050808 79949191
20050524 PEB100N 1431420 E001501 DISABILI false 20070331 8708 M 20070302 pts/1 902331 E001501 20070302 PEB100N 0902331 E001501 false 20050701 28646 N 2017-02-06T11:18:17.432-05:00 20050701 79949298
20121206 PEB100N 1511057 E003651 DTLSRSP false 20391 A 20121206 pts/52 1511056 E003651 false 20130101 3827 N 2017-02-06T11:18:18.352-05:00 20130101 79869898
20150828 PEB100N 1435340 E088645 LIFEXSAL false 20160531 29737 M 20160504 pts/183 951434 E088645 20160504 PEB100N 0951434 E088645 false 20150901 82477 N 2017-02-06T11:18:19.007-05:00 20150901 79849098
20150112 PEB100N 1613240 E077593 FLRETHA false FLRETHA 20150228 26809 M 20150305 pts/206 1534333 E077593 20150305 PEB100N 1534333 E077593 false 20150105 90353 N 2017-02-06T11:18:18.82-05:00 20150105 79849894
20160328 PEB100N 1216049 E077593 FLRETHA false FLRETHA 20160331 29491 M 20160412 pts/254 1041270 E089739 20160412 PEB100N 1041270 E089739 false 20160316 91383 N 2017-02-06T11:18:18.992-05:00 20160316 79839683
20140806 PEB100N 0838100 E003651 PLAN CDP false 23693 A 20140806 pts/111 838100 E003651 false 20140801 89903 N 2017-02-06T11:18:18.571-05:00 20140801 79859198
20010626 PEB100N 1556259 OPER2 HELTHFAM false HMOFAM 20111231 18175 M 20111117 pts/30 952344 E003651 20111117 PEB100N 0952346 E003651 false 20010629 365 N 2017-02-06T11:18:18.134-05:00 20010701 79989298
20061129 PEB100N 1027415 E001501 HLTHHMO false 8791 P 20070329 pts/4 1403183 E001501 false 20070101 23554 N 2017-02-06T11:18:17.432-05:00 20070101 79929898
Powered by BI Documenter