DWStaging
 dbo.ST_EXTRNL_ENROLLMENT_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.ST_EXTRNL_ENROLLMENT_LOG_A
  Properties
Property Value
Name ST_EXTRNL_ENROLLMENT_LOG_A
Schema dbo
Row Count 3836
Data Size 560 KB
Index Size 104 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
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
 
INST_ID
varchar(8)
True
False
False
 
INST_TY
varchar(1)
True
False
False
 
ISN_ST_EXTRNL_ENROLLMENT_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
 
RECEIVED_DATE
varchar(8)
True
False
False
 
RECEIVED_TIME
varchar(7)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
TRANSIENT_TRM
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_EXTRNL_ENROLLMENT_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_EXTRNL_ENROLLMENT_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_EXTRNL_ENROLLMENT_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_EXTRNL_ENROLLMENT_LOG_A] Script Date: 03/09/2017 16:46:07 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_EXTRNL_ENROLLMENT_LOG_A](
    [ISN_ST_EXTRNL_ENROLLMENT_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_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TID] [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,
    [HOLD] [int] NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANSIENT_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVED_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_TY] [varchar](1) 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 INST_ID INST_TY ISN_ST_EXTRNL_ENROLLMENT_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RECEIVED_DATE RECEIVED_TIME RowUpdatedOn STDNT_ID TRANSIENT_TRM
20150113 STR321N0 1037067 OPER2 832444 001506 P 2148 M 20150421 <notty> 832444 OPER2 20150421 STR321N0 0832444 OPER2 20150421 0832444 2017-02-06T11:32:08.792-05:00 G14130942 20152
20160826 STR321N0 0846210 OPER1 819336 007870 P 3490 M 20161108 <notty> 819336 OPER1 20161108 STR321N0 0819336 OPER1 20161108 0819336 2017-02-06T11:32:08.886-05:00 E13180765 20171
20150113 STR321N0 1037067 OPER2 842312 001506 P 1806 M 20150417 <notty> 842312 OPER2 20150417 STR321N0 0842312 OPER2 20150417 0842312 2017-02-06T11:32:08.761-05:00 G14130942 20152
20160826 STR321N0 0846207 OPER1 824090 001533 P 3415 M 20161021 <notty> 824090 OPER1 20161021 STR321N0 0824090 OPER1 20161021 0824090 2017-02-06T11:32:08.886-05:00 C14305957 20171
20150826 STR321N0 0826448 OPER2 952324 001533 P 2826 M 20151204 <notty> 952324 OPER1 20151204 STR321N0 0952324 OPER1 20151204 0952324 2017-02-06T11:32:08.839-05:00 B13870886 20161
20150113 STR321N0 1037061 OPER2 842243 001500 P 1599 M 20150417 <notty> 842242 OPER2 20150417 STR321N0 0842243 OPER2 20150417 0842242 2017-02-06T11:32:08.745-05:00 O14195002 20152
20160125 STR321N0 0825150 OPER1 907570 001493 P 3121 M 20160412 <notty> 907570 OPER1 20160412 STR321N0 0907570 OPER1 20160412 0907570 2017-02-06T11:32:08.87-05:00 E11745528 20162
20150113 STR321N0 1037061 OPER2 1037062 001500 P 342 M 20150113 <notty> 1037062 OPER2 20150113 STR321N0 1037062 OPER2 20150113 1037062 2017-02-06T11:32:08.636-05:00 O14195002 20152
20140219 STR321N0 1907193 OPER1 2005587 001506 P 43 M 20140310 <notty> 2005587 OPER1 20140310 STR321N0 2005587 OPER1 20140310 2005587 2017-02-06T11:32:08.621-05:00 R14203798 20142
20150113 STR321N0 1037061 OPER2 842204 001500 P 1429 M 20150417 <notty> 842203 OPER2 20150417 STR321N0 0842204 OPER2 20150417 0842203 2017-02-06T11:32:08.714-05:00 O14195002 20152
Powered by BI Documenter