DWStaging
 dbo.GL_HIERARCHY (Table)
  Properties
Property Value
Name GL_HIERARCHY
Schema dbo
Row Count 5479
Data Size 568 KB
Index Size 128 KB
Create Date 10/24/2012 4:04 PM
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_TERMINAL_ID
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
ALIAS_END_DATE
varchar(8)
True
False
False
 
ALIAS_ID
varchar(16)
True
False
False
 
ALIAS_START_DATE
varchar(8)
True
False
False
 
ALIAS_TRANS_1
varchar(3)
True
False
False
 
ALIAS_TRANS_2
varchar(3)
True
False
False
 
ALIAS_TRANS_3
varchar(3)
True
False
False
 
ALIAS_TRANS_4
varchar(3)
True
False
False
 
ALIAS_TRANS_5
varchar(3)
True
False
False
 
APPROVAL_CONDITION
varchar(3)
True
False
False
 
APPROVAL_VALUE
numeric(17, 2)
True
False
False
 
DETAIL_PRINT_OPTION
varchar(1)
True
False
False
 
GROUP_NAME
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
IDENTIFIER_A
varchar(16)
True
False
False
 
IDENTIFIER_B
varchar(16)
True
False
False
 
ISN_GL_HIERARCHY
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TERMINAL_ID
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
NAME
varchar(30)
True
False
False
 
NEXT_IDENT
varchar(16)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SUMMARY_PRINT_OPTION
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_GL_HIERARCHY
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.GL_HIERARCHY depends on)
Name Type
  Child Dependencies (objects that depend on dbo.GL_HIERARCHY)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[GL_HIERARCHY] Script Date: 03/09/2017 16:45:35 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GL_HIERARCHY](
    [ISN_GL_HIERARCHY] [int] NOT NULL,
    [GROUP_NAME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [IDENTIFIER_A] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPROVAL_CONDITION] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPROVAL_VALUE] [numeric](17, 2) NULL,
    [NEXT_IDENT] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DETAIL_PRINT_OPTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUMMARY_PRINT_OPTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [IDENTIFIER_B] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIAS_ID] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIAS_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIAS_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIAS_TRANS_1] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIAS_TRANS_2] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIAS_TRANS_3] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIAS_TRANS_4] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALIAS_TRANS_5] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TERMINAL_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TERMINAL_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) 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_TERMINAL_ID ADD_TIME ADD_USER_ID ALIAS_END_DATE ALIAS_ID ALIAS_START_DATE ALIAS_TRANS_1 ALIAS_TRANS_2 ALIAS_TRANS_3 ALIAS_TRANS_4 ALIAS_TRANS_5 APPROVAL_CONDITION DETAIL_PRINT_OPTION GROUP_NAME HOLD IDENTIFIER_A IDENTIFIER_B ISN_GL_HIERARCHY MAINT_DATE MAINT_PGM MAINT_TERMINAL_ID MAINT_TIME MAINT_USER_ID NAME NEXT_IDENT RowUpdatedOn SUMMARY_PRINT_OPTION
20000831 FIG039N2 1415321 BBLACK GRP2 1415321 7504006270901090 2194 75040000 00 2017-02-06T11:26:20.005-05:00
20090611 FIG039N2 1547571 E001353 GRP2 1547571 7739006370901090 4370 77390000 00 2017-02-06T11:26:20.177-05:00
19980420 FIG039N2 2142004 MCOOPER GRP2 2142004 7771102670114110 800 77710000 00 2017-02-06T11:26:19.912-05:00
20031211 FIG039N2 1726029 E001353 GRP2 1726029 7798116470103550 165 77980000 00 2017-02-06T11:26:19.865-05:00
19980225 FIG038N2 1845347 MCOOPER GRP1 1706212 1126030026030120 1283 19990112 FIG038N2 1706212 MCOOPER 11260300 00 2017-02-06T11:26:19.943-05:00
20130710 FIG039N2 1126517 E026994 GRP2 1126517 7743101870106220 4898 77430000 00 2017-02-06T11:26:20.208-05:00
20050718 FIG039N2 1624433 E001353 GRP2 1624433 7711211670116220 3448 77110000 00 2017-02-06T11:26:20.099-05:00
20120702 FIG039N2 1305339 E001353 GRP2 1305339 71140000 00 2035 71000000 00 2017-02-06T11:26:20.005-05:00
20020625 FIG038N2 1109139 BBLACK GRP1 1109139 1126030026030695 2764 11260300 00 2017-02-06T11:26:20.036-05:00
20080714 FIG039N2 1229489 E001353 GRP2 1229489 7730001970115110 4097 77300000 00 2017-02-06T11:26:20.161-05:00
Powered by BI Documenter