DWOperations
 dbo.Staged_dbo_DimPayee__New (Table)
Home  Diagrams  Documents  Images  DWOperations  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:  DWOperations   Tables   dbo.Staged_dbo_DimPayee__New
  Properties
Property Value
Name Staged_dbo_DimPayee__New
Schema dbo
Row Count 964429
Data Size 146456 KB
Index Size 16 KB
Create Date 1/28/2014 9:48 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Country
varchar(30)
False
False
False
 
IsMinority
varchar(10)
False
False
False
 
PayeeAK
varchar(14)
False
False
False
 
PayeeId
varchar(9)
False
False
False
 
PayeeName
varchar(50)
False
False
False
 
PayeeNameConsolidated
varchar(50)
False
False
False
 
PayeeSequence
smallint(5, 0)
False
False
False
 
PayeeType
varchar(30)
False
False
False
 
PayeeTypeCode
varchar(3)
False
False
False
 
RowEndDate
datetime(23, 3)
False
False
False
 
RowIsCurrent
char(1)
False
False
False
 
RowStartDate
datetime(23, 3)
False
False
False
 
State
varchar(30)
False
False
False
 
StateCode
varchar(3)
False
False
False
 
ZipCode
varchar(11)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Staged_dbo_DimPayee__New depends on)
Name Type
  Child Dependencies (objects that depend on dbo.Staged_dbo_DimPayee__New)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Staged_dbo_DimPayee__New] Script Date: 03/09/2017 17:21:41 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Staged_dbo_DimPayee__New](
    [PayeeAK] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeSequence] [smallint] NOT NULL,
    [PayeeTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeNameConsolidated] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [IsMinority] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StateCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [State] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ZipCode] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Country] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NOT NULL
) ON [PRIMARY]
  Sample Data
Country IsMinority PayeeAK PayeeId PayeeName PayeeNameConsolidated PayeeSequence PayeeType PayeeTypeCode RowEndDate RowIsCurrent RowStartDate State StateCode ZipCode
United States Unknown SL10017531 L10017531 Gray, Louise Bender Gray, Louise Bender 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33440
United States Unknown SC14429310 C14429310 Jacobs, Connor A Jacobs, Connor A 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33076
United States Unknown SR06204572 R06204572 Daniel, Rulx-Chanie Daniel, Rulx-Chanie 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 32003
United States Unknown SM07438328 M07438328 Gallion, Marvin L Gallion, Marvin L 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33401
United States Unknown SC11307451 C11307451 Cadena, Carlos Cadena, Carlos 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33437
United States Unknown SA11495017 A11495017 Jadotte, Antoine Jadotte, Antoine 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33412
United States Unknown SJ07372840 J07372840 Martin, Joseph Louis Martin, Joseph Louis 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33486
United States Unknown SM07553266 M07553266 Sewell, Morris Sewell, Morris 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33416
United States Unknown ST15392988 T15392988 Lestido, Tatiana Florencia Lestido, Tatiana Florencia 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33411
United States Unknown SS10911568 S10911568 Cutter, Stephen Cutter, Stephen 0 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33480
Powered by BI Documenter