DWStaging
 dbo.ST_STDNT_ADV_HIST_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_A
  Properties
Property Value
Name ST_STDNT_ADV_HIST_A
Schema dbo
Row Count 585459
Data Size 69248 KB
Index Size 8760 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_EFF_TRM
varchar(6)
True
False
False
 
ADV_END_TRM
varchar(6)
True
False
False
 
ADV_ID
varchar(9)
True
False
False
 
ADV_LOCATION
varchar(8)
True
False
False
 
ADV_NAME
varchar(40)
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
 
ADV_PHONE
varchar(20)
True
False
False
 
ADV_TY
varchar(1)
True
False
False
 
APPL_TRM
varchar(6)
True
False
False
 
APPROVED_BY_INS_YN
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INT_ADV_ID
varchar(9)
True
False
False
 
ISN_ST_STDNT_ADV_HIST_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
 
MAJOR
varchar(5)
True
False
False
 
MAX_CRED
int(10, 0)
True
False
False
 
MAX_STUDENTS
int(10, 0)
True
False
False
 
MIN_CRED
int(10, 0)
True
False
False
 
OPTIONAL
bit(1, 0)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
PRIMARY_DSO_YN
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SEVIS_ADVISOR_ID
varchar(15)
True
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_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_A depends on)
Name Type
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_STDNT_ADV_HIST_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_ADV_HIST_A] Script Date: 03/09/2017 16:46:23 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_ADV_HIST_A](
    [ISN_ST_STDNT_ADV_HIST_A] [int] NOT 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,
    [ADV_EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_END_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_LOCATION] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADV_PHONE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STD_PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INT_ADV_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPROVED_BY_INS_YN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIMARY_DSO_YN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEVIS_ADVISOR_ID] [varchar](15) 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,
    [ADV_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAX_STUDENTS] [int] NULL,
    [PERSON_ID] [int] 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_EFF_TRM ADV_END_TRM ADV_ID ADV_LOCATION ADV_NAME ADV_ORIENT_DT ADV_ORIENT_TM ADV_ORIENT_TY ADV_PHONE ADV_TY APPL_TRM APPROVED_BY_INS_YN HOLD INT_ADV_ID ISN_ST_STDNT_ADV_HIST_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAJOR OPTIONAL PRIMARY_DSO_YN RowUpdatedOn SEVIS_ADVISOR_ID STATUS_IND STD_PGM_ID STDNT_ID TRANSIENT_INST TRNSFR_INST TRNSFR_MJR
20080716 STV200N0 1621593 SWAINK M E006230 M 20091 1621593 85073 true 2017-02-06T10:41:17.85-05:00 AD 1000 B12941746
20120817 STV200N0 1600196 E032515 M E032515 M 20131 1600196 305361 true 2017-02-06T10:41:41.811-05:00 AD 1000 S13247168
20150507 STV200N0 1221183 E047554 M E021193 M 20161 903584 470631 20150723 STV200N0 0903584 E021193 true 2017-02-06T10:42:00.719-05:00 AD 1000 L13551833 OU0001 510000
20120509 STV200N0 0929120 E006162 M E006162 M 20123 929120 282219 true 2017-02-06T10:41:39.206-05:00 AD 1000 N12932877
20160104 STV200N0 1308499 E007293 M E007293 M 20162 841087 517181 20160105 STV200N0 0841087 E007293 true 2017-02-06T10:42:06.241-05:00 AD 1000 A14924807
20150219 STV200N0 1517063 E026173 M E007293 M 20153 1234223 457534 20150617 STV200N0 1234223 E007293 true 2017-02-06T10:41:59.252-05:00 AD 1000 S14205561 032553 420000
20000621 STV200N0 1900430 TJOINSON 20000621 1900430 E000436 20011 1900430 7468 false 2017-02-06T10:41:09.566-05:00 1000 S08906505
20160322 STV200N0 1420418 E000282 M E000282 M 20163 1420418 526512 true 2017-02-06T10:42:07.364-05:00 AD 1000 B15062417
20161109 STV200N0 1813201 E027623 M ORIENT M 20172 1813201 574624 false 2017-02-06T10:42:13.058-05:00 AD 1000 C15439516
20121129 STV200N0 1007262 E011761 M E011761 M 20132 857183 321058 20121206 STV200N0 0857183 E011761 true 2017-02-06T10:41:43.714-05:00 AD 1000 C11619939
Powered by BI Documenter