DWStaging
 dbo.FIG_TABLES_FILE (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.FIG_TABLES_FILE
  Properties
Property Value
Name FIG_TABLES_FILE
Schema dbo
Row Count 2155
Data Size 208 KB
Index Size 64 KB
Create Date 10/24/2012 1:57 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_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FIG_TABLES_FILE
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
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
TABLE_CODE
varchar(8)
True
False
False
 
TABLE_DESC
varchar(195)
True
False
False
 
TABLE_NAME
varchar(8)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIG_TABLES_FILE
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIG_TABLES_FILE depends on)
Name Type
View
View
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.FIG_TABLES_FILE)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
VIEW
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIG_TABLES_FILE] Script Date: 03/09/2017 16:45:21 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIG_TABLES_FILE](
    [ISN_FIG_TABLES_FILE] [int] NOT NULL,
    [TABLE_NAME] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TABLE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TABLE_DESC] [varchar](195) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] 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,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID HOLD ISN_FIG_TABLES_FILE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RowUpdatedOn TABLE_CODE TABLE_DESC TABLE_NAME
20110601 FIG001N2 0702112 WILSON 1595 20110801 FIG001N2 1147243 PACACHA 2017-02-06T11:24:38.714-05:00 EN201106 01913 FIGADM5
20081201 FIG001N2 0837100 AMARO 1318 20081219 FIG001N2 1057196 WILSON 2017-02-06T11:24:38.683-05:00 AP200812 01703 FIGADM5
20080402 FIG001N2 1010080 CASON 488 20080430 FIG001N2 1732481 KIMMELMA 2017-02-06T11:24:38.636-05:00 CO200804 02234 FIGADM5
19990201 FIG904N2 0741462 LAPORTE 1755061 205 19990709 FIG904N2 1755061 LAPORTE 2017-02-06T11:24:38.62-05:00 199905 199911CCCC FIGADM1
2080 2017-02-06T11:24:38.745-05:00 AP201610 02128 FIGADM5
20120228 FIG910N2 1531386 TREFELNE 1531386 1659 2017-02-06T11:24:38.714-05:00 2Q VP/PROVOST MAIN CAMPUS -13 GRANT FIGADM6
20021101 FIG001N2 1013043 FISHER 722 20021127 FIG001N2 2009309 FINSBTCH 2017-02-06T11:24:38.651-05:00 AP200211 02488 FIGADM5
20040412 FIG001N2 1748269 PAYROLLB 867 20040707 FIG001N2 0713495 BATCH 2017-02-06T11:24:38.667-05:00 PR200404 00006 FIGADM5
20101202 FIG001N2 1139198 DICKSON 1540 20110111 FIG001N2 1540410 SMALL 2017-02-06T11:24:38.714-05:00 BT201012 00048 FIGADM5
20101101 FIG001N2 1212466 SMCMILLA 1525 20110111 FIG001N2 0951008 MCGLYNN 2017-02-06T11:24:38.714-05:00 BT201011 00064 FIGADM5
Powered by BI Documenter