DWStaging
 dbo.ST_STDNT_CLS_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_CLS_A
  Properties
Property Value
Name ST_STDNT_CLS_A
Schema dbo
Row Count 4587736
Data Size 623376 KB
Index Size 68472 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
 
AH_ROLLED
varchar(1)
True
False
False
 
BEG_DT
varchar(8)
True
False
False
 
CAMP_CNTR
varchar(5)
True
False
False
 
CLS_OPTN
varchar(1)
True
False
False
 
CLS_SECT
varchar(3)
True
False
False
 
CNTRL_NUM
varchar(8)
True
False
False
 
CRED_TY
varchar(2)
True
False
False
 
CRNT_CRS_ID
varchar(10)
True
False
False
 
CRS_ID
varchar(10)
True
False
False
 
EFF_TRM
varchar(6)
True
False
False
 
END_DT
varchar(8)
True
False
False
 
GRADE
varchar(2)
True
False
False
 
GRD_DT
varchar(8)
True
False
False
 
GRD_RSTR_PG
int(10, 0)
True
False
False
 
HNRS_FLG
bit(1, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_STDNT_CLS_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
 
NOT_PAID_FLG
bit(1, 0)
True
False
False
 
OVRD_FLG
varchar(1)
True
False
False
 
PAID_DATE
varchar(8)
True
False
False
 
REF_NUM
int(10, 0)
True
False
False
 
REF_NUM@V2
int(10, 0)
True
False
False
 
REPEAT_CRS_FEES_FLG
bit(1, 0)
True
False
False
 
RFND_REASON
varchar(1)
True
False
False
 
RGSTRTN_CAMP
varchar(1)
True
False
False
 
RGSTRTN_MTHD
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
RPRTD_HNRS
varchar(1)
True
False
False
 
RPRTD_WRTNG
varchar(1)
True
False
False
 
RSN_DRP
varchar(2)
True
False
False
 
SDB_REPORTED
varchar(1)
True
False
False
 
SEQ_NUM
int(10, 0)
True
False
False
 
SRCH_NAME
varchar(25)
True
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
STDNT_ID@V2
varchar(9)
True
False
False
 
TRNSCTN_DT
varchar(8)
True
False
False
 
TRNSCTN_TM
varchar(7)
True
False
False
 
TRNSCTN_TY
varchar(1)
True
False
False
 
WRTNG_FLG
bit(1, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_STDNT_CLS_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_STDNT_CLS_A depends on)
Name Type
View
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_STDNT_CLS_A)
Name Type
VIEW
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_STDNT_CLS_A] Script Date: 03/09/2017 16:46:25 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_CLS_A](
    [ISN_ST_STDNT_CLS_A] [int] NOT NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_NUM] [int] NULL,
    [CAMP_CNTR] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_OPTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_SECT] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRL_NUM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRED_TY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRNT_CRS_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRADE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRD_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRD_RSTR_PG] [int] NULL,
    [HNRS_FLG] [bit] NULL,
    [NOT_PAID_FLG] [bit] NULL,
    [OVRD_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RFND_REASON] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RGSTRTN_CAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RGSTRTN_MTHD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RSN_DRP] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REPEAT_CRS_FEES_FLG] [bit] NULL,
    [SEQ_NUM] [int] NULL,
    [SRCH_NAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCTN_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCTN_TM] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRNSCTN_TY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WRTNG_FLG] [bit] NULL,
    [BEG_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_NUM@V2] [int] NULL,
    [STDNT_ID@V2] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RPRTD_HNRS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RPRTD_WRTNG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AH_ROLLED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SDB_REPORTED] [varchar](1) 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,
    [PAID_DATE] [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 AH_ROLLED BEG_DT CAMP_CNTR CLS_OPTN CLS_SECT CNTRL_NUM CRED_TY CRNT_CRS_ID CRS_ID EFF_TRM END_DT GRADE GRD_DT GRD_RSTR_PG HNRS_FLG HOLD ISN_ST_STDNT_CLS_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NOT_PAID_FLG OVRD_FLG PAID_DATE REF_NUM REF_NUM@V2 REPEAT_CRS_FEES_FLG RFND_REASON RGSTRTN_CAMP RGSTRTN_MTHD RowUpdatedOn RPRTD_HNRS RPRTD_WRTNG RSN_DRP SDB_REPORTED SEQ_NUM SRCH_NAME STDNT_ID STDNT_ID@V2 TRNSCTN_DT TRNSCTN_TM TRNSCTN_TY WRTNG_FLG
19991209 STS972N0 2136199 OPERTNS 19990823 2 19991217 A 1 false 1927296 191860 19991216 STS972N0 1927296 OPER2 false 10280 false 2017-02-06T09:18:40.138-05:00 1 J10235257 false
Y 1 001 06 POO0476 POO0476 20091 L false 2699153 false X 20090113 129610 false 1 O 2017-02-06T09:23:25.464-05:00 LILLIE,LISA,K L06409171 20090113 1213004 A false
Y 3 003 05 COS0200 COS0200 20141 A 20131015 false 3762677 false 20130808 185104 false W 2017-02-06T09:25:27.566-05:00 BUTLER,LATERIA,QUINTELLA L12680450 20130725 2016406 A false
Y 1 004 01 PHY2048L PHY2048L 20132 A 20130508 false 3631860 false 20121212 167789 false W 2017-02-06T09:25:12.652-05:00 DIMITROV,VOLEN,I V13166327 20121130 2134118 A false
Y 5 002 01 ENC1101 ENC1101 20113 B 20110621 false 3229388 false 20110509 142514 false W 2017-02-06T09:24:26.46-05:00 MACOMBER,MICHAEL,WILLIAM M13835301 20110509 1405589 A false
Y 1 005 03 REA0010 REA0010 20013 P 20010621 false 604212 false 20010510 29181 false 1 O 2017-02-06T09:19:27.266-05:00 MARTIN,MOSASHY,O M11156882 20010510 0843266 A false
Y 5 001 01 INR2002 INR2002 20161 C 20151217 false 4244484 false 20150804 204053 false W 2017-02-06T09:26:22.54-05:00 CHONG,MARILYN, M14580120 20150727 1058182 A false
5 002 03 ENC0017 ENC0017 20172 false 4549544 false 20161222 223919 false W 2017-02-08T10:34:35.878-05:00 VELEZ,EDWIN, E15234479 20161221 0715083 A false
Y 2 001 05 RMI0092 RMI0092 20022 S 20020418 false 851653 false 20020220 39525 false 2 O 2017-02-06T09:19:55.892-05:00 HASSAM,NASREEN,K N06387237 20020418 1740523 A false
20001128 STS972N0 0159063 OPER2 20000823 1 20001218 F 1 false 1525326 447993 20001218 STS972N0 1525326 OPER2 false 21651 false 2017-02-06T09:19:09.419-05:00 8 W06201115 false
Powered by BI Documenter