DWStaging
 dbo.BENEFIT_HISTORY_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.BENEFIT_HISTORY_A
  Properties
Property Value
Name BENEFIT_HISTORY_A
Schema dbo
Row Count 4762676
Data Size 812648 KB
Index Size 71024 KB
Create Date 11/2/2012 2:42 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCT_INTERNAL_ID
int(10, 0)
True
False
False
 
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_ACCT_LINE_NUMBER
int(10, 0)
True
False
False
 
BENEFIT_HISTORY_TYPE
varchar(2)
True
False
False
 
CHECK_TYPE
varchar(2)
True
False
False
 
COMPONENT_AMOUNT
numeric(17, 2)
True
False
False
 
COVERAGE_AMOUNT
numeric(17, 2)
True
False
False
 
FIRSTNAME
varchar(15)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INTERNAL_SEQ
int(10, 0)
True
False
False
 
ISN_BENEFIT_HISTORY_A
int(10, 0)
False
False
False
 
LASTNAME
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
 
MIDDLE
varchar(1)
True
False
False
 
PAY_CHECK_COMPONENT_TYPE_CODE
varchar(21)
True
False
False
 
PAY_CHECK_DATE
varchar(8)
True
False
False
 
PAY_CHECK_DATE_9C
int(10, 0)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
POST_TITLE
varchar(8)
True
False
False
 
PRE_TITLE
varchar(4)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SENT_TO_GL_DATE
varchar(8)
True
False
False
 
SENT_TO_GL_DATE_9C
int(10, 0)
True
False
False
 
SENT_TO_GL_IND
bit(1, 0)
True
False
False
 
SSN
varchar(9)
True
False
False
 
VENDOR_CODE
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_BENEFIT_HISTORY_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.BENEFIT_HISTORY_A depends on)
Name Type
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.BENEFIT_HISTORY_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[BENEFIT_HISTORY_A] Script Date: 03/09/2017 16:45:07 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[BENEFIT_HISTORY_A](
    [ISN_BENEFIT_HISTORY_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,
    [PAY_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BENEFIT_HISTORY_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_CHECK_COMPONENT_TYPE_CODE] [varchar](21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BENEFIT_ACCT_LINE_NUMBER] [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](1) 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,
    [VENDOR_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INTERNAL_SEQ] [int] NULL,
    [SENT_TO_GL_IND] [bit] NULL,
    [SENT_TO_GL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SENT_TO_GL_DATE_9C] [int] NULL,
    [COMPONENT_AMOUNT] [numeric](17, 2) NULL,
    [COVERAGE_AMOUNT] [numeric](17, 2) NULL,
    [ACCT_INTERNAL_ID] [int] NULL,
    [PAY_CHECK_DATE_9C] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCT_INTERNAL_ID ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BENEFIT_ACCT_LINE_NUMBER BENEFIT_HISTORY_TYPE CHECK_TYPE COMPONENT_AMOUNT COVERAGE_AMOUNT FIRSTNAME HOLD INTERNAL_SEQ ISN_BENEFIT_HISTORY_A LASTNAME MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MIDDLE PAY_CHECK_COMPONENT_TYPE_CODE PAY_CHECK_DATE PAY_CHECK_DATE_9C PERSON_ID POSITION_CODE POST_TITLE PRE_TITLE RowUpdatedOn SENT_TO_GL_DATE SENT_TO_GL_DATE_9C SENT_TO_GL_IND SSN VENDOR_CODE
45524019 20110811 PEY419N1 1443370 OPER2 1 MO 15.68 47508.21 VANGER 1448080 8 2947393 WOLF 20110811 PEY419N1 1448080 OPER2 A 03DISABILIDISABILI001 20110815 79889184 4049 3263 2017-02-06T09:22:58.195-05:00 20110815 79889184 true 820003751 420127290
45660094 20111012 PEY419N1 1416035 OPER2 1 MO 446.00 FREDDIE 1422456 5 2993597 KELLY 20111012 PEY419N1 1422456 OPER2 L 16HEALTHSPHEALTHSP001 20111014 79888985 1298 3092A DR. 2017-02-06T09:23:02.734-05:00 20111014 79888985 true 820001288 592403696
48237096 20141013 PEY419N1 1451241 OPER2 1 PF RG 201.10 JAY HAROLD 1451241 6 3949961 REACH 16SOCSEC 001 20141015 79858984 72928 1259TMP 2017-02-06T09:24:36.912-05:00 false 820012195
6065532 20050427 PEY419N1 1305048 OPER2 3 PF RG 3.46 EDWARD 1305048 9 1173410 REYES R 16MEDICARE 001 20050429 79949570 8178 COM3OVLS 2017-02-06T09:20:03.661-05:00 false 820005056 590155625
1052469 20000502 PEY419N1 1020350 OPER2 1 PF RG 501.00 LISA 1020350 2 207018 BOUSE C 16SOCSEC 001 20000514 79999485 2717 3119 2017-02-06T09:18:27.751-05:00 false 820002619 590155625
28362536 20090512 PEY419N1 1106448 OPER2 1 PF RG 81.98 NANCY 1106448 4 2157247 WILKINS L 16SOCSEC 001 20090514 79909485 42474 8230 2017-02-06T09:21:41.692-05:00 false 820009864
7338836 20060426 PEY419N1 1104402 OPER2 1 PF RG 3.13 MARY 1104402 25 1404174 BRINKER A 16MEDICARE 001 20060428 79939571 3786 CPE1ADJS 2017-02-06T09:20:26.749-05:00 false 820003576 590155625
46016933 20120313 PEY419N1 1322098 OPER2 1 PF RG 237.63 MARY 1322098 3126765 VARTIN E 03ORP ORPTIAA 001 20120315 79879684 197 2017-02-06T09:23:15.994-05:00 false 820000195 131624203
46733362 20130111 PEY419N1 1451084 OPER2 1 MO 8.73 26459.40 CHRISTINE 1458094 4 3395676 FRANCOIS 20130111 PEY419N1 1458094 OPER2 A 16DISABILIDISABILI001 20130115 79869884 42895 AA6072 2017-02-06T09:23:42.592-05:00 20130115 79869884 true 820010067 420127290
2120984 20010727 PEY419N1 1038463 OPERTNS 1 PF RG 21.20 SHEILA 1038463 2 2760814 FERGUSON E 16MEDICARE 001 20010731 79989268 6527 8012 2017-02-06T09:22:39.662-05:00 false 820004585 590155625
Powered by BI Documenter