DWStaging
 dbo.UTL_ERROR_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.UTL_ERROR_LOG_A
  Properties
Property Value
Name UTL_ERROR_LOG_A
Schema dbo
Row Count 443337
Data Size 37456 KB
Index Size 6648 KB
Create Date 11/7/2012 3:39 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
 
CONTRACT_ID
int(10, 0)
True
False
False
 
CUSTOMER_ID
varchar(9)
True
False
False
 
DBID
int(10, 0)
True
False
False
 
ERROR_LINE_NR
int(10, 0)
True
False
False
 
ERROR_NR
int(10, 0)
True
False
False
 
ERROR_PROGRAM
varchar(8)
True
False
False
 
ERROR_PROGRAM_LEVEL
int(10, 0)
True
False
False
 
ERROR_STATUS
varchar(1)
True
False
False
 
FILE_NUMBER
int(10, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_UTL_ERROR_LOG_A
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
SUB_CODE
varchar(4)
True
False
False
 
TERM
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_UTL_ERROR_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.UTL_ERROR_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.UTL_ERROR_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[UTL_ERROR_LOG_A] Script Date: 03/09/2017 16:46:37 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[UTL_ERROR_LOG_A](
    [ISN_UTL_ERROR_LOG_A] [int] NOT NULL,
    [ERROR_PROGRAM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ERROR_NR] [int] NULL,
    [ERROR_LINE_NR] [int] NULL,
    [ERROR_PROGRAM_LEVEL] [int] NULL,
    [ERROR_STATUS] [varchar](1) 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,
    [HOLD] [int] NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_ID] [int] NULL,
    [SUB_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DBID] [int] NULL,
    [FILE_NUMBER] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CUSTOMER_ID DBID ERROR_LINE_NR ERROR_NR ERROR_PROGRAM ERROR_PROGRAM_LEVEL ERROR_STATUS FILE_NUMBER HOLD ISN_UTL_ERROR_LOG_A RowUpdatedOn STUDENT_ID SUB_CODE TERM
20091021 UTL500N2 1619335 E000627 13 1650 3009 USERMENU 1 O 214 1619335 245267 2017-02-06T11:22:50.122-05:00 2005
20091002 UTL500N2 1113298 E001256 4420 3009 STC200P0 1 O 1113298 242450 2017-02-06T11:22:49.95-05:00 0
20160329 UTL500N2 1024063 E001049 13 280 3009 SECUTLN6 2 O 215 1024063 432271 2017-02-06T11:23:02.274-05:00 K12205811 TT
20070828 UTL500N2 1341528 E011534 3140 3009 UTL656N0 4 O 124 1341528 130341 2017-02-06T11:22:42.945-05:00 H10567584 2158 20081
20091124 UTL500N2 1046464 E002960 13 1020 3009 PET100N2 2 O 20 1046464 250657 2017-02-06T11:22:50.48-05:00 2005
20100809 UTL500N2 1530536 E003561 13 280 3009 SECUTLN6 2 O 215 1530536 290459 2017-02-06T11:22:53.257-05:00 RG8-04-68 2158
20110810 UTL500N2 0921022 E077839 290 82 CDNCPX 4 O 921022 350583 2017-02-06T11:22:56.908-05:00 J13824966
20010504 UTL500N2 1429255 WDEBEE 7030 3009 STS412N1 2 O 1429255 5747 2017-02-06T11:22:35.333-05:00 A11284965
20091023 UTL500N2 0934517 E018354 13 280 3009 SECUTLN6 2 O 215 934517 245572 2017-02-06T11:22:50.153-05:00 2005
20020513 UTL500N2 1843124 PSOUZA 3490 1009 STA046H1 3 O 1843124 43418 2017-02-06T11:22:37.844-05:00 V09572553 20023
Powered by BI Documenter