DWStaging
 dbo.WF_COM399_1718 (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.WF_COM399_1718
  Properties
Property Value
Name WF_COM399_1718
Schema dbo
Row Count 1047
Data Size 152 KB
Index Size 40 KB
Create Date 2/13/2017 3:59 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ISN_WF_COM399_1718
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
WF_CO_399_SET
varchar(1)
True
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WF_IS_C_DEP
varchar(1)
True
False
False
 
WF_IS_C_FC1
varchar(6)
True
False
False
 
WF_IS_C_IRSREQ_PAR
varchar(2)
True
False
False
 
WF_IS_C_IRSREQ_STU
varchar(2)
True
False
False
 
WF_IS_C_ORIG_DATE
varchar(8)
True
False
False
 
WF_IS_C_PELL_ELIG
varchar(1)
True
False
False
 
WF_IS_C_PROC_DATE
varchar(8)
True
False
False
 
WF_IS_C_VER
varchar(1)
True
False
False
 
WF_IS_F_DEP_OVR
varchar(1)
True
False
False
 
WF_IS_F_PROF_JUDG
varchar(1)
True
False
False
 
WF_IS_FED_ID
varchar(13)
True
False
False
 
WF_IS_NM_FIRST
varchar(12)
True
False
False
 
WF_IS_NM_LAST
varchar(16)
True
False
False
 
WF_IS_NM_MI
varchar(1)
True
False
False
 
WF_IS_SSN
varchar(9)
True
False
False
 
WF_TRAN_NO
varchar(2)
True
False
False
 
WF_VE_VER_STAT
varchar(1)
True
False
False
 
WW_CDATE
date(10, 0)
True
False
False
 
WW_HOLD
int(10, 0)
True
False
False
 
WW_MDATE
date(10, 0)
True
False
False
 
WW_ST_SSN
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_WF_COM399_1718
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_COM399_1718 depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_COM399_1718)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_COM399_1718] Script Date: 03/09/2017 16:46:40 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_COM399_1718](
    [ISN_WF_COM399_1718] [int] NOT NULL,
    [WF_FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_ST_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_TRAN_NO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_IS_C_ORIG_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_C_PROC_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_FED_ID] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_NM_LAST] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_NM_FIRST] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_NM_MI] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_C_VER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_C_IRSREQ_STU] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_C_IRSREQ_PAR] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_C_FC1] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_C_PELL_ELIG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_C_DEP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_F_DEP_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_IS_F_PROF_JUDG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_VE_VER_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CO_399_SET] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
  Sample Data
ISN_WF_COM399_1718 RowUpdatedOn WF_CO_399_SET WF_FAO WF_IS_C_DEP WF_IS_C_FC1 WF_IS_C_IRSREQ_PAR WF_IS_C_IRSREQ_STU WF_IS_C_ORIG_DATE WF_IS_C_PELL_ELIG WF_IS_C_PROC_DATE WF_IS_C_VER WF_IS_F_DEP_OVR WF_IS_F_PROF_JUDG WF_IS_FED_ID WF_IS_NM_FIRST WF_IS_NM_LAST WF_IS_NM_MI WF_IS_SSN WF_TRAN_NO WF_VE_VER_STAT WW_CDATE WW_HOLD WW_ST_SSN
234 2017-02-13T16:00:09.901-05:00 PB D 000000 01 00 20161001 Y 20161003 N 593797537DA01 NATHALIA DAROCHA S 985021869 01 2017-02-01T00:00:00-05:00 1105179 985021869
993 2017-02-13T16:00:09.979-05:00 PB D 000000 05 00 20161018 Y 20161019 Y 593737641MI01 NICOLE MILLER 985025480 01 2017-02-01T00:00:00-05:00 1105245 985025480
663 2017-02-13T16:00:09.963-05:00 PB I 000000 00 01 20161007 Y 20161011 Y 770289469CE01 ROODINA CELIUS 900803121 01 2017-02-01T00:00:00-05:00 1105217 900803121
532 2017-02-13T16:00:09.963-05:00 PB X 00 00 20161010 20161011 Y 592757624VA01 JOSE VANEGAS E 900884548 01 2017-02-01T00:00:00-05:00 1105205 900884548
452 2017-02-13T16:00:09.916-05:00 PB D 002445 02 02 20161009 Y 20161011 N 589676627FI01 A'LIYAH FIELDS J 900912046 01 2017-02-01T00:00:00-05:00 1105198 900912046
2 2017-02-13T16:00:09.885-05:00 PB D 020641 02 00 20161002 20161003 N 011827247WI01 JAMIE WILLETT A 900838530 01 2017-02-01T00:00:00-05:00 1105152 900838530
304 2017-02-13T16:00:09.901-05:00 PB D 000000 00 00 20161001 Y 20161003 N 602080109NA01 SANDRA NAVAS 985025350 01 2017-02-01T00:00:00-05:00 1105184 985025350
924 2017-02-13T16:00:09.979-05:00 PB I 000000 00 05 20161018 Y 20161019 N 099829773AR01 FRECHELLE ARIAS 900786074 01 2017-02-01T00:00:00-05:00 1105239 900786074
638 2017-02-13T16:00:09.963-05:00 PB I 000710 00 01 20161007 20161011 N 766142446FI01 JUAN FIGUEROA C 900743939 01 2017-02-01T00:00:00-05:00 1105215 900743939
1021 2017-02-13T16:00:10.01-05:00 PB D 000000 02 00 20161018 Y 20161019 N 595855554ME01 BERNISHA MEDOR 985025482 01 2017-02-01T00:00:00-05:00 1105247 985025482
Powered by BI Documenter