DWStaging
 dbo.W2_FORM_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_A
  Properties
Property Value
Name W2_FORM_A
Schema dbo
Row Count 26486
Data Size 8496 KB
Index Size 440 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
 
DATE_CREATED
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_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(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
 
W3_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_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.W2_FORM_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.W2_FORM_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[W2_FORM_A] Script Date: 03/09/2017 16:46:37 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[W2_FORM_A](
    [ISN_W2_FORM_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,
    [W2_TAX_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [W3_TAX_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEQ_NBR] [int] NULL,
    [DATE_CREATED] [varchar](8) 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,
    [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 BOX5 BOX6 BOX2 BOX3 BOX4 BOXA BOXD CITY COUNTRY DATE_CREATED DIRECTION FIRSTNAME HOLD HOUSE_NUMBER ISN_W2_FORM_A LASTNAME MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MIDDLE PERSON_ID POSTAL RowUpdatedOn SEQ_NBR STATE STREET SUITE W2_TAX_YEAR W3_TAX_YEAR ZIP4 ZIP5
20160121 PEY352N1 1410317 E077593 2825.99 205.80 772482211 WEST PALM BEACH US ERICA 1438089 21874 TIODACE 20160121 PEY352N1 1438089 E077593 C 90931 2017-02-06T11:17:51.161-05:00 1 FL 5400 NORTH FLAGLER DR APT A 7 2015 33407
20160121 PEY352N1 1408364 E077593 1214.01 X 1312.45 19.03 267432340 WELLINGTON US SALLIE 1436143 19514 HUGGINS 20160121 PEY352N1 1436143 E077593 G 21588 2017-02-06T11:17:50.927-05:00 1 FL 13334 NORTHUMBERLAND CIRCLE 2015 33414
20150121 PEY352N1 1018468 E077593 5945.63 395.54 542392161 COCONUT CREEK US NICOLE 1043454 17503 RICHARDS 20150121 PEY352N1 1043454 E077593 R 89285 2017-02-06T11:17:50.693-05:00 1 FL 4109 NORTH WEST 41ST DRIVE 2014 33073
20110121 PEY352N1 1132120 OPER1 2287.94 X 2473.46 35.87 317608814 BOYNTON BEACH US ANGELA 1132120 931 GIRTMAN D 8858 2017-02-06T11:17:48.79-05:00 1 FL 1920 NE 1ST LANE 2010 33435
20120215 PEY352N1 0859271 E001501 590.50 X 608.76 8.83 34.42 608.76 25.56 031647093 GREENACRES US JONATHAN 1013407 8767 FAY 20130114 PEY352N1 1013407 E001501 F 67853 2017-02-06T11:17:49.726-05:00 1 FL 1209 HATTERAS CIRCLE 2012 33413
20160121 PEY352N1 1408588 E077593 5176.61 X 5596.32 81.17 25.72 766483994 ROYAL PALM BEACH US AMUTHA 1436371 22234 SRINIVASAN 20160121 PEY352N1 1436371 E077593 52911 2017-02-06T11:17:51.208-05:00 1 FL 1262 GEMBROOK COURT 2015 33411
20140117 PEY352N1 0920329 E077593 29465.09 X 31071.47 450.50 2708.19 16327.47 1012.31 595989641 ROYAL PALM BEACH US JOSHUA 1131468 13463 MAGWOOD 20140117 PEY352N1 1131468 E077593 J 87956 2017-02-06T11:17:50.272-05:00 1 FL 11678 42RD NORTH 2013 33411
20110121 PEY352N1 1132217 OPER1 848.24 X 917.04 13.29 3.53 593929545 LAKE WORTH US ALEX 1132217 1889 SHERMAN J 37651 2017-02-06T11:17:48.899-05:00 1 FL 624 1/2 SOUTH K STREET 2010 33460
20160322 PEY352N1 1401005 E077593 35827.61 X 36956.93 535.89 3357.15 36956.93 2291.35 123901813 WEST PALM BEACH US EDISON 1144375 24361 MEJIA 20161220 PEY352N1 1144375 E077593 89572 2017-02-06T11:17:51.458-05:00 1 FL 1551 NORTH FLAGLER DRIVE 1004 2016 33401
20110121 PEY352N1 1132207 OPER1 55475.46 X 55475.46 804.40 8961.77 55475.46 3439.51 158529485 PLANTATION US SAMANTHA 1132207 1798 SALZINGER K 32559 2017-02-06T11:17:48.899-05:00 1 FL 1740 SW 55 AVENUE 2010 33317
Powered by BI Documenter