DWStaging
 dbo.ORG_CHART_AND_CHILDREN_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.ORG_CHART_AND_CHILDREN_A
  Properties
Property Value
Name ORG_CHART_AND_CHILDREN_A
Schema dbo
Row Count 481128
Data Size 50248 KB
Index Size 7608 KB
Create Date 11/5/2012 9:36 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
 
ENTITY_NAME
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ORG_CHART_AND_CHILDREN_A
int(10, 0)
False
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
 
ORG_CHART_DESCR
varchar(50)
True
False
False
 
ORG_CHART_TYPE
varchar(1)
True
False
False
 
ORG_LEVEL_CODE
varchar(28)
True
False
False
 
ORG_LEVEL_NAME_1
varchar(20)
True
False
False
 
ORG_LEVEL_NAME_2
varchar(20)
True
False
False
 
ORG_LEVEL_NAME_3
varchar(20)
True
False
False
 
ORG_LEVEL_NAME_4
varchar(20)
True
False
False
 
ORG_LEVEL_NAME_5
varchar(20)
True
False
False
 
ORG_LEVEL_NAME_6
varchar(20)
True
False
False
 
ORG_LEVEL_NAME_7
varchar(20)
True
False
False
 
ORG_TYPE_CODE
varchar(8)
True
False
False
 
ORG_TYPE_CODE_ASSOC
varchar(8)
True
False
False
 
RECORD_ID
varchar(30)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ORG_CHART_AND_CHILDREN_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ORG_CHART_AND_CHILDREN_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ORG_CHART_AND_CHILDREN_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ORG_CHART_AND_CHILDREN_A] Script Date: 03/09/2017 16:45:47 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ORG_CHART_AND_CHILDREN_A](
    [ISN_ORG_CHART_AND_CHILDREN_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,
    [ORG_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_TYPE_CODE_ASSOC] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_CHART_DESCR] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_LEVEL_NAME_1] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_LEVEL_NAME_2] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_LEVEL_NAME_3] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_LEVEL_NAME_4] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_LEVEL_NAME_5] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_LEVEL_NAME_6] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_LEVEL_NAME_7] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENTITY_NAME] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECORD_ID] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_LEVEL_CODE] [varchar](28) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_CHART_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ENTITY_NAME HOLD ISN_ORG_CHART_AND_CHILDREN_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID ORG_CHART_DESCR ORG_CHART_TYPE ORG_LEVEL_CODE ORG_LEVEL_NAME_1 ORG_LEVEL_NAME_2 ORG_LEVEL_NAME_3 ORG_LEVEL_NAME_4 ORG_LEVEL_NAME_5 ORG_LEVEL_NAME_6 ORG_LEVEL_NAME_7 ORG_TYPE_CODE ORG_TYPE_CODE_ASSOC RECORD_ID RowUpdatedOn
20090901 PEP262N1 1616449 E000117 ASSIGNME 1616449 249994 45 PAYCHECK 000072500MAT2ADJS001 2017-02-06T10:38:52.425-05:00
20060119 PEP262N1 1613552 E000117 ASSIGNME 1613552 145589 45 PAYCHECK 000000473ECO2ADJS009 2017-02-06T10:38:45.078-05:00
20080904 PEP262N1 0728076 E000117 ASSIGNME 728076 219264 PHY1 TIME/ATT 000002454BIO1ADJS016 2017-02-06T10:38:50.257-05:00
20101213 PEP262N1 1537024 E077683 ASSIGNME 1537024 289547 DNT1 TIME/ATT 000072586DNT1ADJU010 2017-02-06T10:38:55.327-05:00
20041022 PEP262N1 0754454 E000117 ASSIGNME 754454 117249 10 PAYCHECK 000001219AA6044A 005 2017-02-06T10:38:43.284-05:00
20070806 PEP262N1 1041597 E000117 ASSIGNME 1041597 185172 RETN TIME/ATT 000001035CRP1TR01004 2017-02-06T10:38:47.823-05:00
20101213 PEP262N1 1531002 E077683 ASSIGNME 1531002 289534 MAIL PAYCHECK 000004392DNT1ADJU034 2017-02-06T10:38:55.327-05:00
20050617 PEP262N1 0924453 E000117 ASSIGNME 924453 128438 ART2 TIME/ATT 000024279ART2ADJS004 2017-02-06T10:38:43.986-05:00
20150402 PEP262N1 0925175 E000117 ASSIGNME 925175 425482 10 PAYCHECK 000089734CIT1R007002 2017-02-06T10:39:05.186-05:00
20060428 PEP262N1 0921384 E000117 ASSIGNME 921384 149940 FIR1 TIME/ATT 000030723FRT1ADJU015 2017-02-06T10:38:45.359-05:00
Powered by BI Documenter