DWStaging
 dbo.W2_FORM_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.W2_FORM_LOG_A
  Properties
Property Value
Name W2_FORM_LOG_A
Schema dbo
Row Count 162018
Data Size 55648 KB
Index Size 2448 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
 
BOX1
numeric(11, 2)
True
False
False
 
BOX10
numeric(11, 2)
True
False
False
 
BOX11
numeric(11, 2)
True
False
False
 
BOX13_RET
varchar(1)
True
False
False
 
BOX13_STAT
varchar(1)
True
False
False
 
BOX13_TPS
varchar(1)
True
False
False
 
BOX2
numeric(11, 2)
True
False
False
 
BOX3
numeric(11, 2)
True
False
False
 
BOX4
numeric(11, 2)
True
False
False
 
BOX5
numeric(11, 2)
True
False
False
 
BOX6
numeric(11, 2)
True
False
False
 
BOX7
numeric(11, 2)
True
False
False
 
BOX8
numeric(11, 2)
True
False
False
 
BOX9
numeric(11, 2)
True
False
False
 
BOXA
varchar(9)
True
False
False
 
BOXD
varchar(10)
True
False
False
 
CITY
varchar(25)
True
False
False
 
COUNTRY
varchar(8)
True
False
False
 
DIRECTION
varchar(2)
True
False
False
 
FIRSTNAME
varchar(15)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOUSE_NUMBER
varchar(6)
True
False
False
 
ISN_W2_FORM_LOG_A
int(10, 0)
False
False
False
 
LASTNAME
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
 
MIDDLE
varchar(20)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
POSTAL
varchar(10)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SEQ_NBR
int(10, 0)
True
False
False
 
STATE
varchar(2)
True
False
False
 
STREET
varchar(30)
True
False
False
 
SUITE
varchar(15)
True
False
False
 
W2_TAX_YEAR
varchar(4)
True
False
False
 
ZIP4
varchar(4)
True
False
False
 
ZIP5
varchar(5)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_W2_FORM_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.W2_FORM_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.W2_FORM_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[W2_FORM_LOG_A] Script Date: 03/09/2017 16:46:38 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[W2_FORM_LOG_A](
    [ISN_W2_FORM_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,
    [HOLD] [int] NULL,
    [PERSON_ID] [int] NULL,
    [W2_TAX_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEQ_NBR] [int] 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,
    [SUITE] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DIRECTION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOUSE_NUMBER] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CITY] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ZIP5] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ZIP4] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COUNTRY] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSTAL] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOX1] [numeric](11, 2) NULL,
    [BOX2] [numeric](11, 2) NULL,
    [BOX3] [numeric](11, 2) NULL,
    [BOX4] [numeric](11, 2) NULL,
    [BOX5] [numeric](11, 2) NULL,
    [BOX6] [numeric](11, 2) NULL,
    [BOX7] [numeric](11, 2) NULL,
    [BOX8] [numeric](11, 2) NULL,
    [BOX9] [numeric](11, 2) NULL,
    [BOX10] [numeric](11, 2) NULL,
    [BOX11] [numeric](11, 2) NULL,
    [BOX13_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOX13_RET] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOX13_TPS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOXA] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOXD] [varchar](10) 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 BOX1 BOX13_RET BOX13_STAT BOX13_TPS BOX2 BOX3 BOX4 BOX5 BOX6 BOXA BOXD CITY COUNTRY DIRECTION FIRSTNAME HOLD HOUSE_NUMBER ISN_W2_FORM_LOG_A LASTNAME LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MIDDLE PERSON_ID POSTAL RowUpdatedOn SEQ_NBR STATE STREET SUITE W2_TAX_YEAR ZIP4 ZIP5
20160322 PEY352N1 1359422 E077593 24676.26 X 3066.81 26456.38 1640.26 26456.38 383.70 263866161 LAKE WORTH US KATHLEEN 1045561 143495 ROONEY M 20161025 <notty> 1045561 E077593 20161025 PEY352N1 1045561 E077593 B 6180 2017-02-06T10:52:19.138-05:00 1 FL 7597 CEDAR HURST CT 2016 33467
20160322 PEY352N1 1400067 E077593 14453.53 X 1958.93 14901.12 923.86 14901.12 216.07 594526993 GREENACRES US SHAWN 1139262 117231 ULBRICHT M 20160425 <notty> 1139262 E077593 20160425 PEY352N1 1139262 E077593 E 37535 2017-02-06T10:52:15.799-05:00 1 FL 4463 CONSTANTINE CIRCLE 2016 33463
20120124 PEY352N1 1023304 E001501 31619.60 X 4129.53 31619.60 1327.99 31619.60 458.48 195361140 LAKE WORTH US DWIGHT 1304196 19286 CHAMBERS M 20120126 <notty> 1304196 E001501 20120126 PEY352N1 1304196 E001501 D 23241 2017-02-06T10:52:02.68-05:00 1 FL 2480 LAKE OSBORNE DRIVE #201 #201 2011 33461
20120215 PEY352N1 0859185 E001501 3825.45 X 407.76 3944.01 165.66 3944.01 57.18 077702868 LANTANA US NANCY 859185 22800 CABRERA A 20120215 <notty> 859185 E001501 30775 2017-02-06T10:52:03.132-05:00 1 FL 2815 SAND PINES COURT 2012 33462
20120215 PEY352N1 0859207 E001501 13901.73 X 1614.20 14331.66 601.94 14331.66 207.79 586581807 PALM BEACH GARDENS US VIRAKONE 749119 51022 PHONGSAVATH M 20120821 <notty> 749119 E001501 20120821 PEY352N1 0749119 E001501 37757 2017-02-06T10:52:06.876-05:00 1 FL 9102 DUCALE WAY # 206 2012 33418
20160322 PEY352N1 1401282 E077593 15718.92 X 2200.35 15718.92 974.58 15718.92 227.93 266749490 PAHOKEE US JOHNNIE 1105247 153470 MULLINS M 20161028 <notty> 1105247 E077593 20161028 PEY352N1 1105247 E077593 L 90895 2017-02-06T10:52:20.386-05:00 1 FL 2531 SW 14TH TERR 2016 33476
20120215 PEY352N1 0859206 E001501 1937.05 X 2094.12 30.37 591581201 LAKE WORTH US M-ADRIANNE 950008 53577 CASTROVINCI M 20120918 <notty> 950008 E001501 20120918 PEY352N1 0950008 E001501 37684 2017-02-06T10:52:07.204-05:00 1 FL 6341 STONEHURST CIR. 2012 33467
20120215 PEY352N1 0859309 E001501 4608.64 168.24 597302111 CORAL SPRINGS US STEPHANIE 1540529 56825 FLORES M 20121015 <notty> 1540529 E001501 20121015 PEY352N1 1540529 E001501 P 77704 2017-02-06T10:52:07.625-05:00 1 FL 9930 NW 53RD COURT 2012 33076
20160322 PEY352N1 1359440 E077593 25229.34 X 3116.42 27072.47 1678.49 27072.47 392.53 594443299 RIVIERA BEACH US CHRISTINE 1103446 151079 FOSTER-MCKINNIE M 20161028 <notty> 1103446 E077593 20161028 PEY352N1 1103446 E077593 7427 2017-02-06T10:52:20.089-05:00 1 FL 3601 AVE F 2016 33404
20120124 PEY352N1 1023123 E001501 1393.16 X 2.13 1506.12 21.84 045406367 BOYNTON BEACH US KEITH 947098 14522 CARSON M 20120126 <notty> 947098 E001501 20120126 PEY352N1 0947098 E001501 140 2017-02-06T10:52:02.118-05:00 1 FL 6615 W. BOYNTON BEACH BLVD. #310 2011 33437
Powered by BI Documenter