DWStaging
 dbo.ST_RESTRICTED_INFO_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_RESTRICTED_INFO_A
  Properties
Property Value
Name ST_RESTRICTED_INFO_A
Schema dbo
Row Count 267048
Data Size 21720 KB
Index Size 4008 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
ACCESS_DATE
varchar(8)
True
False
False
 
ACCESS_PGM
varchar(8)
True
False
False
 
ACCESS_REASON
varchar(73)
True
False
False
 
ACCESS_TIME
varchar(7)
True
False
False
 
ADD_DATE
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TERMINAL_ID
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
AUTHORIZED_BY
varchar(9)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_RESTRICTED_INFO_A
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TERMINAL_ID
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
REST_DATE_AUTHORIZED
varchar(8)
True
False
False
 
REST_EXPIRATION_DATE
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
USER_ID
varchar(8)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_RESTRICTED_INFO_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_RESTRICTED_INFO_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_RESTRICTED_INFO_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_RESTRICTED_INFO_A] Script Date: 03/09/2017 16:46:20 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_RESTRICTED_INFO_A](
    [ISN_ST_RESTRICTED_INFO_A] [int] NOT NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REST_DATE_AUTHORIZED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REST_EXPIRATION_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AUTHORIZED_BY] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCESS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCESS_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCESS_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCESS_REASON] [varchar](73) 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_TERMINAL_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_TERMINAL_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCESS_DATE ACCESS_PGM ACCESS_REASON ACCESS_TIME ADD_DATE ADD_PGM ADD_TERMINAL_ID ADD_TIME ADD_USER_ID AUTHORIZED_BY HOLD ISN_ST_RESTRICTED_INFO_A MAINT_DATE MAINT_PGM MAINT_TERMINAL_ID MAINT_TIME MAINT_USER_ID REST_DATE_AUTHORIZED REST_EXPIRATION_DATE RowUpdatedOn STDNT_ID STUDENT_ID USER_ID
20130603 STS810P1 1 074237P 742429 158383 2017-02-06T11:25:35.498-05:00 V12487476 E072817
20111128 STA010P STUDENT RECORDS 160009P 1600137 99143 2017-02-06T11:25:30.818-05:00 L07387186 E072707
20120411 STA000P0 REGISTRATION 093558P 936014 112067 2017-02-06T11:25:31.863-05:00 M06902696 E077765
20100517 STA010P ADN 152551P 1525539 56296 2017-02-06T11:25:27.542-05:00 J12543427 E025006
20100408 STD011P0 GRAD 103151P 1031539 53764 2017-02-06T11:25:27.355-05:00 S06324693 E003976
20160601 STA010P REG 102930P 1029330 250388 2017-02-06T11:25:42.643-05:00 M13248554 E091231
20151218 STS410P1 ADVISING 100902P 1009081 235717 2017-02-06T11:25:41.489-05:00 P12525192 E030781
20110506 STS825N0 0859462 E072707 E072707 859462 80191 20110506 2017-02-06T11:25:29.414-05:00 R13162193
20130624 STR000P0 WEB 123727P 1237295 160461 2017-02-06T11:25:35.67-05:00 M11362811 E000943
20140812 STA000P0 APP 121727P 1217287 202624 2017-02-06T11:25:38.977-05:00 C13197249 E001772
Powered by BI Documenter