DWStaging
 dbo.ST_OVRD_A (Table)
  Properties
Property Value
Name ST_OVRD_A
Schema dbo
Row Count 1515196
Data Size 159960 KB
Index Size 22656 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
 
CAMP_CNTR
varchar(5)
True
False
False
 
CLS_REF_NUM
int(10, 0)
True
False
False
 
CRS_DSTNC_LRN_IND
varchar(1)
True
False
False
 
CRS_ID
varchar(10)
True
False
False
 
DATE_EXPIRED
varchar(8)
True
False
False
 
EFF_TRM
varchar(6)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLD_TY
varchar(4)
True
False
False
 
INIT_DT
varchar(8)
True
False
False
 
INIT_SSN
varchar(9)
True
False
False
 
ISN_ST_OVRD_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
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SEQ_NO
int(10, 0)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_OVRD_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_OVRD_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_OVRD_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_OVRD_A] Script Date: 03/09/2017 16:46:12 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_OVRD_A](
    [ISN_ST_OVRD_A] [int] NOT NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD_TY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INIT_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INIT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DATE_EXPIRED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_REF_NUM] [int] NULL,
    [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMP_CNTR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEQ_NO] [int] 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,
    [CRS_DSTNC_LRN_IND] [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 CAMP_CNTR CLS_REF_NUM CRS_DSTNC_LRN_IND CRS_ID DATE_EXPIRED EFF_TRM HOLD HOLD_TY INIT_DT INIT_SSN ISN_ST_OVRD_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RowUpdatedOn SEQ_NO STUDENT_ID
20010405 STA041N1 1738023 PSTEEN 24423 BSC1086L 20012 1738023 1056 20010405 PSTEEN 162610 2017-02-06T10:24:30.083-05:00 2 T06174551
20080826 STA041N1 1617426 E062497 2 MCB2010L 20091 1617426 1030 20080826 E062497 872840 2017-02-06T10:25:23.872-05:00 1 S06367320
20040830 STA041N1 1158408 E023997 1 BCV0942 R 20040829 20051 1158408 1139 20040830 E023997 512217 2017-02-06T10:24:56.556-05:00 2 G11291275
20040426 STA041N1 1521424 E019847 2 20043 1521424 ZO 20040426 E019847 469758 2017-02-06T10:24:53.358-05:00 1 R06947691
20050315 STA052N1 0920233 E005859 2 HSC1000L 20053 1044 20050315 E005859 558705 20050315 STA052N1 0920487 E005859 2017-02-06T10:25:00.207-05:00 2 L11880721
20110728 STA041N1 1400584 E006160 5 20110727 20121 1400584 ZQ 20110728 E006160 1133146 2017-02-06T10:25:43.981-05:00 1 S13584347
20060323 STA052N1 1558566 E015802 1 BSC1085 20063 805096 TRAN 20060323 E015802 653479 2017-02-06T10:25:07.539-05:00 1 R11547288
20120807 STA052N1 1251383 E082925 HUN1201 20131 1438316 DUAL 20120807 E082925 1204183 2017-02-06T10:25:49.425-05:00 1 R13616800
20070625 STA041N1 1113222 E003003 1 POO0326 20073 1113222 1082 20070625 E003003 765441 2017-02-06T10:25:16.119-05:00 1 D07779671
1 19993 RH 19990624 BGRAY 11351 2017-02-06T10:24:19.194-05:00 1 M11046646
Powered by BI Documenter