DWStaging
 dbo.ST_EXTRNL_ENROLLMENT_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_A
  Properties
Property Value
Name ST_EXTRNL_ENROLLMENT_A
Schema dbo
Row Count 82
Data Size 16 KB
Index Size 24 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_A
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
 
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_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_EXTRNL_ENROLLMENT_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_EXTRNL_ENROLLMENT_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_EXTRNL_ENROLLMENT_A] Script Date: 03/09/2017 16:46:06 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_EXTRNL_ENROLLMENT_A](
    [ISN_ST_EXTRNL_ENROLLMENT_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,
    [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_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RECEIVED_DATE RECEIVED_TIME RowUpdatedOn STDNT_ID TRANSIENT_TRM
20131219 STR321N0 0555295 OPER2 555295 001481 P 3 20131219 0555295 2017-02-06T11:32:10.493-05:00 R13802962 20141
20161129 STR321N0 0824171 OPER1 823077 006750 P 77 20161130 STR321N0 0823077 OPER1 20161130 0823077 2017-02-06T11:32:10.493-05:00 A14091912 20162
20161215 STR321N0 0827302 OPER1 821156 006750 P 80 20161216 STR321N0 0821156 OPER1 20161216 0821156 2017-02-06T11:32:10.493-05:00 J14729016 20121
20150520 STR321N0 0854076 OPER2 818547 001500 P 39 20150804 STR321N0 0818547 OPER2 20150804 0818547 2017-02-06T11:32:10.493-05:00 L14147623 20153
20150901 STR321N0 0841055 OPER2 826346 001500 P 48 20151207 STR321N0 0826346 OPER1 20151207 0826346 2017-02-06T11:32:10.493-05:00 N14339089 20161
20160205 STR321N0 0955363 OPER1 820082 001500 P 59 20160502 STR321N0 0820082 OPER1 20160502 0820082 2017-02-06T11:32:10.493-05:00 N14339089 20162
20140102 STR321N0 1022481 OPER2 1022481 006750 P 4 20140102 1022481 2017-02-06T11:32:10.493-05:00 A12489266 20141
20160122 STR321N0 0812284 OPER1 849150 001500 P 53 20160429 STR321N0 0849150 OPER1 20160429 0849150 2017-02-06T11:32:10.493-05:00 C14147243 20162
20140828 STR321N0 2001352 OPER1 833255 001481 P 20 20141218 STR321N0 0833255 OPER2 20141218 0833255 2017-02-06T11:32:10.493-05:00 C14351563 20151
20160122 STR321N0 0812294 OPER1 849176 001519 P 55 20160429 STR321N0 0849176 OPER1 20160429 0849176 2017-02-06T11:32:10.493-05:00 A14496137 20162
Powered by BI Documenter