DWStaging
 dbo.ST_HOLDS_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_HOLDS_A
  Properties
Property Value
Name ST_HOLDS_A
Schema dbo
Row Count 679038
Data Size 67912 KB
Index Size 10176 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
 
HLD_CMNT
varchar(40)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLD_TY
varchar(4)
True
False
False
 
INIT_DT
varchar(8)
True
False
False
 
INITIATORS_SSN
varchar(9)
True
False
False
 
ISN_ST_HOLDS_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
 
OVRD_FLG
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_HOLDS_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_HOLDS_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_HOLDS_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_HOLDS_A] Script Date: 03/09/2017 16:46:08 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_HOLDS_A](
    [ISN_ST_HOLDS_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,
    [INITIATORS_SSN] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INIT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAMP_CNTR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OVRD_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HLD_CMNT] [varchar](40) 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,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CAMP_CNTR HLD_CMNT HOLD_TY INIT_DT INITIATORS_SSN ISN_ST_HOLDS_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OVRD_FLG RowUpdatedOn STUDENT_ID
20001025 STA053N1 0232185 OPER2 ZS 20001025 OPER2 276579 2017-02-06T10:44:48.544-05:00 C07409261
19990308 STA053N1 1755583 OPERTNS 1 ZS 19990308 OPERTNS 153300 20040401 STA053N1 0349348 OPER2 2017-02-06T10:44:40.198-05:00 C10766681
20001025 STA053N1 0207173 OPER2 ZS 20001025 OPER2 259286 2017-02-06T10:44:47.421-05:00 R09297789
20160823 STA053N1 1528592 WEB5 System Generated Enrollment Hold ZO 20160823 WEB 526750 20160824 STA053N1 1009151 E082869 2017-02-06T10:45:05.705-05:00 M15419583
20161108 STA040N3 2044484 WEB5 RH 20161108 AUTO 676791 20161109 STA053N1 1310210 E090567 2017-02-06T10:45:16.001-05:00 J15469687
20161104 STA053N1 0935231 E042646 ZZ 20161104 E042646 673265 2017-02-06T10:45:15.798-05:00 N15460793
20160801 STA040N3 1816408 E090215 RP 20160801 AUTO 570652 2017-02-06T10:45:08.793-05:00 J14964803
20050201 STA053N1 1707132 E020890 System Generated Enrollment Hold ZO 20050201 AUTO 436314 2017-02-06T10:44:59.168-05:00 W10867950
20140827 STA040N3 1413067 WEB5 RH 20140827 AUTO 634777 2017-02-06T10:45:13.161-05:00 J14858468
20051008 STA053N1 0109387 OPER2 ZS 20051008 OPER2 472358 2017-02-06T10:45:01.68-05:00 E08739740
Powered by BI Documenter