DWStaging
 dbo.ST_STDNT_DA_SUBSTN_WVR_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_DA_SUBSTN_WVR_A
  Properties
Property Value
Name ST_STDNT_DA_SUBSTN_WVR_A
Schema dbo
Row Count 7192
Data Size 816 KB
Index Size 152 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_ID
varchar(9)
True
False
False
 
ATHRZD_ID
varchar(9)
True
False
False
 
CAT_YR
varchar(4)
True
False
False
 
CORE_QLFYING_RESD
varchar(1)
True
False
False
 
CORE_RES_CNTCT_HRS
numeric(17, 2)
True
False
False
 
CORE_RES_CRED_HRS
numeric(17, 2)
True
False
False
 
CORE_RES_RQMNT
varchar(1)
True
False
False
 
CRD_HNRS_PGM
numeric(17, 2)
True
False
False
 
CUMM_GPA
numeric(17, 2)
True
False
False
 
EFF_TRM
varchar(6)
True
False
False
 
EFF_TRM_A
varchar(6)
True
False
False
 
EXIT_TEST
varchar(4)
True
False
False
 
FEE_GRP
varchar(2)
True
False
False
 
FEE_GRP_DLR_AMT
numeric(17, 2)
True
False
False
 
GRDN_RULE
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_STDNT_DA_SUBSTN_WVR_A
int(10, 0)
False
False
False
 
LIM_ACCEL_MECH_HRS_ALL
numeric(17, 2)
True
False
False
 
LIM_ENS_HRS
numeric(17, 2)
True
False
False
 
LIM_MUS_SPC_DRA_HRS
numeric(17, 2)
True
False
False
 
LIM_PE_DANCE
numeric(17, 2)
True
False
False
 
LIM_TV_HRS
numeric(17, 2)
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
 
MIN_CNTCT_HRS
numeric(17, 2)
True
False
False
 
MIN_CRED_HRS
numeric(17, 2)
True
False
False
 
MIN_GEN_ED_HRS
numeric(17, 2)
True
False
False
 
MIN_GRD_HNRS_PGM
varchar(2)
True
False
False
 
PGM_CD
varchar(5)
True
False
False
 
QLFYNG_RESD
varchar(1)
True
False
False
 
RES_CNTCT_HRS
numeric(17, 2)
True
False
False
 
RES_CRED_HRS
numeric(17, 2)
True
False
False
 
RES_RQMNT
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
TRNFR_CRD_EVL
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_STDNT_DA_SUBSTN_WVR_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_STDNT_DA_SUBSTN_WVR_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_STDNT_DA_SUBSTN_WVR_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_DA_SUBSTN_WVR_A] Script Date: 03/09/2017 16:46:25 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_DA_SUBSTN_WVR_A](
    [ISN_ST_STDNT_DA_SUBSTN_WVR_A] [int] NOT NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_CD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CAT_YR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [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,
    [ADV_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_RQMNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_CRED_HRS] [numeric](17, 2) NULL,
    [RES_CNTCT_HRS] [numeric](17, 2) NULL,
    [CUMM_GPA] [numeric](17, 2) NULL,
    [MIN_CRED_HRS] [numeric](17, 2) NULL,
    [MIN_CNTCT_HRS] [numeric](17, 2) NULL,
    [MIN_GEN_ED_HRS] [numeric](17, 2) NULL,
    [LIM_TV_HRS] [numeric](17, 2) NULL,
    [LIM_ENS_HRS] [numeric](17, 2) NULL,
    [LIM_MUS_SPC_DRA_HRS] [numeric](17, 2) NULL,
    [EXIT_TEST] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LIM_PE_DANCE] [numeric](17, 2) NULL,
    [LIM_ACCEL_MECH_HRS_ALL] [numeric](17, 2) NULL,
    [GRDN_RULE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_A] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATHRZD_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [QLFYNG_RESD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRD_HNRS_PGM] [numeric](17, 2) NULL,
    [MIN_GRD_HNRS_PGM] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_GRP] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_GRP_DLR_AMT] [numeric](17, 2) NULL,
    [TRNFR_CRD_EVL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CORE_RES_RQMNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CORE_QLFYING_RESD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CORE_RES_CRED_HRS] [numeric](17, 2) NULL,
    [CORE_RES_CNTCT_HRS] [numeric](17, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADV_ID ATHRZD_ID CAT_YR CORE_QLFYING_RESD CORE_RES_RQMNT EFF_TRM EFF_TRM_A EXIT_TEST FEE_GRP GRDN_RULE HOLD ISN_ST_STDNT_DA_SUBSTN_WVR_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MIN_GRD_HNRS_PGM PGM_CD QLFYNG_RESD RES_RQMNT RowUpdatedOn STDNT_ID TRNFR_CRD_EVL
20070911 STD205N1 1636292 E003976 E003976 20062 1637572 2469 20070911 STD205N1 1637572 E003976 A309 2017-02-06T11:16:24.799-05:00 D11671807
20151123 STD205N1 1152265 E003976 E003976 20162 905165 7004 20160804 STD205N1 0905165 E003976 T705A 2017-02-06T11:16:25.361-05:00 T12255675
20000810 STD205N1 1550190 SORTIZ AMORROW 20003 1023534 21 20000814 STD205N1 1023534 SORTIZ 1000 2017-02-06T11:16:24.518-05:00 T11176179
20030912 STD205N1 1526273 E002594 E002594 20033 1526284 740 20030912 STD205N1 1526284 E002594 B526 2017-02-06T11:16:24.596-05:00 S08407801
20040113 STD205N1 1543569 E002594 E002594 20022 1549018 860 20040113 STD205N1 1549018 E002594 2449 2017-02-06T11:16:24.612-05:00 J11058682
20081118 STD205N1 1208348 E062483 E062483 20071 1208348 2955 A087 2017-02-06T11:16:24.861-05:00 D12221453
20020819 STD205N1 1100058 MHEBERT MHEBERT 20002 1101532 301 20020819 STD205N1 1101532 MHEBERT 2191 2017-02-06T11:16:24.549-05:00 M07422058
20061007 STD205N1 1350282 E006419 E006419 20071 1350282 1765 2345 2017-02-06T11:16:24.721-05:00 J07600117
20150116 STD205N1 0840429 E003976 E003976 20152 843120 6237 20150116 STD205N1 0843120 E003976 2611 2017-02-06T11:16:25.251-05:00 J13657093
20050919 STD205N1 0951165 E002039 E006419 20052 839263 1622 20051123 STD205N1 0839263 E006419 2191 2017-02-06T11:16:24.721-05:00 C11984069
Powered by BI Documenter