DWStaging
 dbo.FLEID_INFO_LOG_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.FLEID_INFO_LOG_A
  Properties
Property Value
Name FLEID_INFO_LOG_A
Schema dbo
Row Count 1934958
Data Size 262400 KB
Index Size 28920 KB
Create Date 2/26/2016 9:04 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
 
ASSIGNED_ID
varchar(9)
True
False
False
 
ASSIGNED_ID_TYPE
varchar(1)
True
False
False
 
DATE_RECEIVED
varchar(8)
True
False
False
 
DATE_REQUESTED
varchar(8)
True
False
False
 
FLEID_ID
varchar(14)
True
False
False
 
ISN_FLEID_INFO_LOG_A
int(10, 0)
False
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
varchar(8)
True
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
 
RESPONSE_FIELD
varchar(253)
True
False
False
 
RESPONSE_MESSAGE
varchar(253)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STATUS
varchar(2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FLEID_INFO_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FLEID_INFO_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FLEID_INFO_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FLEID_INFO_LOG_A] Script Date: 03/09/2017 16:45:33 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FLEID_INFO_LOG_A](
    [ISN_FLEID_INFO_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [ASSIGNED_ID_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ASSIGNED_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FLEID_ID] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DATE_REQUESTED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DATE_RECEIVED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESPONSE_MESSAGE] [varchar](253) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESPONSE_FIELD] [varchar](253) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ASSIGNED_ID ASSIGNED_ID_TYPE DATE_RECEIVED DATE_REQUESTED FLEID_ID ISN_FLEID_INFO_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RESPONSE_FIELD RESPONSE_MESSAGE RowUpdatedOn STATUS
20160303 ST300FX1 1428055 E002346 R12115622 S 1235214 M 20160315 <notty> 1445008 OPER1 20160315 UTL060N0 1445008 OPER1 2017-02-06T09:50:05.691-05:00 RQ
20160303 ST300FX1 1431526 E002346 T06344188 S 805796 A 20160303 <notty> 1431526 E002346 2017-02-06T09:49:32.416-05:00
20160303 ST300FX1 1404272 E002346 D12081212 S 20160315 1338268 M 20160315 <notty> 1509210 OPER1 20160315 UTL060N0 1509210 OPER1 2017-02-06T09:50:14.052-05:00 SE
20160303 ST300FX1 1433101 E002346 T13771746 S 834016 A 20160303 <notty> 1433101 E002346 2017-02-06T09:49:34.6-05:00
20160303 ST300FX1 1356101 E002346 A12274833 S 1055498 M 20160315 <notty> 1422330 OPER1 20160315 UTL060N0 1422330 OPER1 2017-02-06T09:49:51.604-05:00 RQ
20160303 ST300FX1 1422396 E002346 M13020862 S 602978 A 20160303 <notty> 1422396 E002346 2017-02-06T09:49:17.252-05:00
20160303 ST300FX1 1356581 E002346 A14175244 S 20160315 1303179 M 20160315 <notty> 1502301 OPER1 20160315 UTL060N0 1502301 OPER1 2017-02-06T09:50:11.213-05:00 SE
20160303 ST300FX1 1434548 E002346 Y11510807 S 1914529 M 20161213 <notty> 1444452 OPER1 20161213 UTL060N0 1444452 OPER1 2017-02-06T09:50:58.669-05:00
20160303 ST300FX1 1402320 E002346 D07064595 S 174487 A 20160303 <notty> 1402320 E002346 2017-02-06T09:48:45.459-05:00
20160303 ST300FX1 1405324 E002346 E07237449 S 233616 A 20160303 <notty> 1405324 E002346 2017-02-06T09:48:49.827-05:00
Powered by BI Documenter