DWStaging
 dbo.ST_STDNT_ADV_HIST_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_STDNT_ADV_HIST_LOG_A
  Properties
Property Value
Name ST_STDNT_ADV_HIST_LOG_A
Schema dbo
Row Count 1124262
Data Size 155688 KB
Index Size 16792 KB
Create Date 8/15/2012 2:10 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
 
ADV_APPT_DT
varchar(8)
True
False
False
 
ADV_APPT_TM
varchar(7)
True
False
False
 
ADV_APPT_TY
varchar(1)
True
False
False
 
ADV_ID
varchar(9)
True
False
False
 
ADV_ORIENT_DT
varchar(8)
True
False
False
 
ADV_ORIENT_TM
varchar(7)
True
False
False
 
ADV_ORIENT_TY
varchar(1)
True
False
False
 
APPL_TRM
varchar(6)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_STDNT_ADV_HIST_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
 
MAJOR
varchar(5)
True
False
False
 
MAX_CRED
int(10, 0)
True
False
False
 
MIN_CRED
int(10, 0)
True
False
False
 
OPTIONAL
bit(1, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STATUS_IND
varchar(2)
True
False
False
 
STD_PGM_ID
varchar(5)
True
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
SUGGESTED_CRED
int(10, 0)
True
False
False
 
TRANSIENT_INST
varchar(8)
True
False
False
 
TRNSFR_INST
varchar(8)
True
False
False
 
TRNSFR_MJR
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_STDNT_ADV_HIST_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_STDNT_ADV_HIST_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_STDNT_ADV_HIST_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_ADV_HIST_LOG_A] Script Date: 03/09/2017 16:46:24 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_ADV_HIST_LOG_A](
    [ISN_ST_STDNT_ADV_HIST_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,
    [ADV_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_APPT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_APPT_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPL_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAX_CRED] [int] NULL,
    [MIN_CRED] [int] NULL,
    [TRNSFR_MJR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSFR_INST] [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,
    [STD_PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OPTIONAL] [bit] NULL,
    [STATUS_IND] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_APPT_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_ORIENT_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_ORIENT_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_ORIENT_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUGGESTED_CRED] [int] NULL,
    [MAJOR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANSIENT_INST] [varchar](8) 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 ADV_APPT_DT ADV_APPT_TM ADV_APPT_TY ADV_ID ADV_ORIENT_DT ADV_ORIENT_TM ADV_ORIENT_TY APPL_TRM HOLD ISN_ST_STDNT_ADV_HIST_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAJOR OPTIONAL RowUpdatedOn STATUS_IND STD_PGM_ID STDNT_ID TRANSIENT_INST TRNSFR_INST TRNSFR_MJR
20150116 STV200N0 1222322 E006318 M E006318 M 20152 846459 866643 M 20150303 <notty> 846459 ROOT 20150303 STV200N0 0846459 E006318 true 2017-02-06T10:27:56.114-05:00 AD 8384 S14309595
20070219 STV200N0 1448182 E002039 M E014724 M 20072 1448182 61909 A 20070219 pts/5133 1448182 E002039 true 2017-02-06T10:26:29.829-05:00 PE 1000 M07214083
20120529 STV200N0 1559563 WEB1 M ADV-DEPT 20120605 0900000 S 20123 1559563 507026 A 20120529 <notty> 1559563 ROOT true 2017-02-06T10:27:18.127-05:00 PE 8384 A14147920
20160728 STV200N0 1726310 E000395 M E000395 20161219 0600000 S 20171 1508368 1064507 M 20160802 <notty> 1508368 ROOT 20160802 STV200N0 1508368 WEB3 true 2017-02-06T10:28:16.987-05:00 AD 1000 M15005911
20160113 STV200N0 1508257 E088761 M E088761 M 20163 1508257 992499 A 20160113 <notty> 1508257 ROOT true 2017-02-06T10:28:09.342-05:00 AD 1000 N14514186
20110426 STV200N0 1121144 E006318 M E006318 M 20113 756260 379896 M 20110607 <notty> 756260 ROOT 20110607 STV200N0 0756260 E006318 true 2017-02-06T10:27:04.243-05:00 AD 6368 C12793444
20040803 STV200N0 1245235 E014724 M E014724 M 20051 1245235 26787 A 20040803 0403 1245234 E014724 true 2017-02-06T10:26:26.054-05:00 PE 1000 595198945
20160831 STV200N0 1649571 WEB3 M E082932 S 20171 1533243 1091989 M 20160928 <notty> 1533243 ROOT 20160928 STV200N0 1533243 E082932 true 2017-02-06T10:28:19.81-05:00 PE 1000 M13833322
20110714 STV200N0 1100538 E001605 M E001605 M 20121 1100538 396193 A 20110714 <notty> 1100538 ROOT true 2017-02-06T10:27:06.115-05:00 AD 1000 A13423553
20111214 STV200N0 1610565 E006162 M E011761 M 20122 924418 480859 M 20120222 <notty> 924418 ROOT 20120222 STV200N0 0924418 E011761 true 2017-02-06T10:27:15.226-05:00 AD 1000 M13989215
Powered by BI Documenter