DWStaging
 dbo.ST_E_LEARNING_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.ST_E_LEARNING_A
  Properties
Property Value
Name ST_E_LEARNING_A
Schema dbo
Row Count 1579391
Data Size 183792 KB
Index Size 23688 KB
Create Date 8/15/2012 1:36 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACTION
varchar(1)
True
False
False
 
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
 
CREATE_PROCESS
varchar(8)
True
False
False
 
EFF_TRM
varchar(6)
True
False
False
 
FIRST_NAME
varchar(20)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_E_LEARNING_A
int(10, 0)
False
False
False
 
LAST_NAME
varchar(35)
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
 
PROCESSED_DATE
varchar(8)
True
False
False
 
PROCESSED_IND
varchar(1)
True
False
False
 
PROCESSED_TIME
varchar(7)
True
False
False
 
REASON_IND
varchar(1)
True
False
False
 
RECORD_SEQ
numeric(17, 0)
True
False
False
 
REF_NUM
int(10, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STGEN_FLAG
varchar(1)
True
False
False
 
TRANSACTION_TYPE
varchar(5)
True
False
False
 
USER_ID
varchar(16)
True
False
False
 
WEBCT_FLAG
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_E_LEARNING_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_E_LEARNING_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_E_LEARNING_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_E_LEARNING_A] Script Date: 03/09/2017 16:46:04 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_E_LEARNING_A](
    [ISN_ST_E_LEARNING_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,
    [RECORD_SEQ] [numeric](17, 0) NULL,
    [ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANSACTION_TYPE] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROCESSED_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_ID] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LAST_NAME] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIRST_NAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_NUM] [int] NULL,
    [PROCESSED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROCESSED_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REASON_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CREATE_PROCESS] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WEBCT_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STGEN_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACTION ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CREATE_PROCESS EFF_TRM FIRST_NAME HOLD ISN_ST_E_LEARNING_A LAST_NAME MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PROCESSED_DATE PROCESSED_IND PROCESSED_TIME REASON_IND RECORD_SEQ REF_NUM RowUpdatedOn STGEN_FLAG TRANSACTION_TYPE USER_ID WEBCT_FLAG
A 20160311 STZ100N0 1554142 WEB3 STR100N0 20162 1554142 348474 20160311 Y 1624150 13267730 215585 2017-02-06T10:54:00.679-05:00 Y STDNT M15137052
A 20160731 STZ100N0 1250328 WEB8 STR100N0 20171 1250328 855615 20160731 Y 1320362 13779910 218805 2017-02-06T10:54:45.95-05:00 Y STDNT J14790869 Y
D 20161124 STZ100N0 1208372 WEB3 STR100N0 20172 1208372 1249990 20161124 Y 1238421 14181025 222314 2017-02-06T10:55:21.472-05:00 Y STDNT W15071616 Y
M 20161110 STZ100N0 1424462 WEB3 IAS002N0 YOLANDA DEL CARMEN 1424462 1223764 VAZQUEZ 20161110 Y 1454505 P 14154650 2017-02-06T10:55:19.116-05:00 STDNT Y12018396 Y
D 20160125 STZ100N0 0026341 OPER2 ITS200N1 20162 26341 225819 20160125 Y 0126561 13145706 209569 2017-02-06T10:53:50.398-05:00 STDNT K14596027 Y
A 20160503 STZ100N0 1552109 WEB7 STR100N0 20171 1552109 570586 20160503 Y 1622123 13492108 218160 2017-02-06T10:54:21.146-05:00 Y STDNT S15191463 Y
A 20160808 STZ100N0 2145205 WEB7 STR100N0 20171 2145205 912465 20160808 Y 2215224 13838161 219677 2017-02-06T10:54:50.864-05:00 Y STDNT B14815922 Y
A 20160815 STZ100N0 1740368 WEB7 STR100N0 20171 1740368 959590 20160815 Y 1810389 13886622 220742 2017-02-06T10:54:54.733-05:00 Y STDNT A12614186 Y
M 20160725 STZ100N0 1425209 E062722 STA710N0 SARAH 1425209 835457 PETIT 20160725 Y 1455231 O 13759497 2017-02-06T10:54:44.203-05:00 Y STDNT S14567168
A 20170109 STZ100N0 1557311 WEB1 STR100N0 20172 1557311 1424120 20170109 Y 1627344 14357242 222288 2017-02-06T10:55:37.103-05:00 Y STDNT S15251929 Y
Powered by BI Documenter