DWStaging
 dbo.ST_CLASS_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_CLASS_A
  Properties
Property Value
Name ST_CLASS_A
Schema dbo
Row Count 223587
Data Size 48880 KB
Index Size 3744 KB
Create Date 3/31/2014 12:56 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACT_CNTCT_HRS
numeric(17, 2)
True
False
False
 
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
 
AUDIT
varchar(1)
True
False
False
 
BEG_TM_1ST_SCHD
varchar(7)
True
False
False
 
CANCEL_DATE
varchar(8)
True
False
False
 
CE_UNITS
numeric(17, 1)
True
False
False
 
CEU_APRVD
varchar(1)
True
False
False
 
CLASS_KEY
varchar(25)
True
False
False
 
CLS_ROLL_PRNT
varchar(1)
True
False
False
 
CLS_STAT
varchar(1)
True
False
False
 
CLS_TM_BLK
varchar(1)
True
False
False
 
CNTCT_HRS
numeric(17, 2)
True
False
False
 
CONTRACT_ENRLD_CNT
int(10, 0)
True
False
False
 
CONTRACT_ENRLD_DATE
varchar(8)
True
False
False
 
CRDNTR_CD
varchar(3)
True
False
False
 
CRNT_ENRLD
int(10, 0)
True
False
False
 
CRNT_HNRS_ENRLD
int(10, 0)
True
False
False
 
CRNT_PAID
int(10, 0)
True
False
False
 
CRNT_WRTNG_ENRLD
int(10, 0)
True
False
False
 
CRS_GRD_MTHD
varchar(2)
True
False
False
 
CRS_TTL
varchar(20)
True
False
False
 
CRS_TY
varchar(2)
True
False
False
 
DIV_DEPT_CD
varchar(8)
True
False
False
 
EVAL_CRED_HRS
numeric(17, 2)
True
False
False
 
FEE_TYPE_IND
varchar(1)
True
False
False
 
GL_ACCT_NUM
varchar(25)
True
False
False
 
GRADES_ROLLED_AH
varchar(1)
True
False
False
 
GRD_RSTR_PRNT_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INSTR_CRED_HRS
numeric(17, 2)
True
False
False
 
ISN_ST_CLASS_A
int(10, 0)
False
False
False
 
LATE_FEE_EXMPTN
varchar(1)
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
 
MAX_CLS_SIZE
int(10, 0)
True
False
False
 
MAX_HNRS_STDNT
int(10, 0)
True
False
False
 
MAX_WRTNG_STDNT
int(10, 0)
True
False
False
 
MIN_CLS_SIZE
int(10, 0)
True
False
False
 
NA_COMPLETED
varchar(1)
True
False
False
 
PHN_RGSTRTN
varchar(1)
True
False
False
 
REF_NUM
int(10, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SCHD_PRNT
varchar(1)
True
False
False
 
SESSION_CD
varchar(4)
True
False
False
 
STCKD_MAX_ROOM_SIZE
int(10, 0)
True
False
False
 
STDNT_USE_EMAIL_CODE
varchar(2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_CLASS_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_CLASS_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_CLASS_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_CLASS_A] Script Date: 03/09/2017 16:45:58 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_CLASS_A](
    [ISN_ST_CLASS_A] [int] NOT NULL,
    [CLASS_KEY] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_NUM] [int] NULL,
    [ACT_CNTCT_HRS] [numeric](17, 2) NULL,
    [AUDIT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BEG_TM_1ST_SCHD] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CE_UNITS] [numeric](17, 1) NULL,
    [CEU_APRVD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_TM_BLK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTCT_HRS] [numeric](17, 2) NULL,
    [CRNT_ENRLD] [int] NULL,
    [CRNT_HNRS_ENRLD] [int] NULL,
    [CRNT_PAID] [int] NULL,
    [EVAL_CRED_HRS] [numeric](17, 2) NULL,
    [CRS_GRD_MTHD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_TY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_TTL] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRD_RSTR_PRNT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_ACCT_NUM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DIV_DEPT_CD] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [LATE_FEE_EXMPTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAX_CLS_SIZE] [int] NULL,
    [MAX_HNRS_STDNT] [int] NULL,
    [MIN_CLS_SIZE] [int] NULL,
    [PHN_RGSTRTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_ROLL_PRNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCHD_PRNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESSION_CD] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRDNTR_CD] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INSTR_CRED_HRS] [numeric](17, 2) 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,
    [CONTRACT_ENRLD_CNT] [int] NULL,
    [CONTRACT_ENRLD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAX_WRTNG_STDNT] [int] NULL,
    [CRNT_WRTNG_ENRLD] [int] NULL,
    [CANCEL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STCKD_MAX_ROOM_SIZE] [int] NULL,
    [FEE_TYPE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRADES_ROLLED_AH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NA_COMPLETED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_USE_EMAIL_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACT_CNTCT_HRS ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AUDIT BEG_TM_1ST_SCHD CANCEL_DATE CE_UNITS CEU_APRVD CLASS_KEY CLS_ROLL_PRNT CLS_STAT CLS_TM_BLK CNTCT_HRS CONTRACT_ENRLD_DATE CRDNTR_CD CRNT_ENRLD CRNT_PAID CRS_GRD_MTHD CRS_TTL CRS_TY DIV_DEPT_CD EVAL_CRED_HRS FEE_TYPE_IND GL_ACCT_NUM GRADES_ROLLED_AH GRD_RSTR_PRNT_IND HOLD INSTR_CRED_HRS ISN_ST_CLASS_A LATE_FEE_EXMPTN MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAX_CLS_SIZE MIN_CLS_SIZE NA_COMPLETED PHN_RGSTRTN REF_NUM RowUpdatedOn SCHD_PRNT SESSION_CD STDNT_USE_EMAIL_CODE
48.00 20131114 STC210N0 0901297 E002073 Y 1230000 N CBSC2085 20151 1 004 Y U D 48.00 33 33 AW ANATOMY-PHYSIOLOGY 1 01 DEG BIO 3.00 S 1111040011040010 R Y 905563 9.00 172692 N 20140204 STC210N0 1636587 E052846 36 1 Y Y 186915 2017-02-06T10:40:59.051-05:00 Y 1 IN
48.00 20091213 STC210N0 2220133 E002073 Y 1600000 N CMUL1010 20111 5 001 Y U D 48.00 36 36 AW MUSIC APPRECIATION 01 DEG MUS 3.00 S 1112100012100250 R Y 337319 9.00 124745 N 20100705 STC210N0 1624481 E057792 36 1 Y 137457 2017-02-06T10:40:52.39-05:00 Y 1 IN
50.40 20101117 STC210N0 1959587 E002073 Y 1600000 N CSPC1017 20122 1 032 Y U D 48.00 25 25 AW FUND SPEECH COMMUNIC 01 DEG SPCH 3.00 S 1113150013150210 R Y 31066 9.00 140993 N 20111005 STC210N0 1313516 E023968 26 1 Y Y 154478 2017-02-06T10:40:54.59-05:00 Y 3 IN
140.00 20120816 STC210N0 1139583 E004093 Y 0830000 14.0 Y NCSP0011 20132 1 001 Y U D 120.00 TD 18 18 AN SALON PRACTICE LAB 2 01 CTE COSM S 1126020026020510 R N 901494 21.18 158667 N 20120910 STC210N0 1344082 E004093 20 1 Y Y 172587 2017-02-06T10:40:57.117-05:00 Y NC5 IN
52.50 20050927 STC210N0 0422085 OPER2 Y 1400000 N CSTA2023 20072 5 007 Y U D 48.00 37 37 AW STATISTICS 01 DEG MATH 3.00 S 1116170016170050 R Y 937328 9.00 80886 N 20080329 STZ210B1 2307121 OPER2 35 1 Y 92091 2017-02-06T10:40:46.275-05:00 Y 3 PR
2.00 20090818 STC210N0 1429308 E003672 Y 1400000 20100208 0.2 Y NLUO0100 20102 2 001 Y C D 2.00 CP NG MEDICARE HEALTH PLAN 01 CTE LU S 1142000042010220 N 1233258 0.35 121335 N 20100208 STC210N0 1451381 E003672 15 1 Y 133710 2017-02-06T10:40:51.969-05:00 Y NC1 PR
48.00 20050831 STC210N0 0400390 OPER2 Y 0930000 N CPOS1001 20071 2 005 Y U D 48.00 35 35 AW INTRODUC POLITICL SC 01 DEG SOCS 3.00 S 1117220017220520 R Y 19265 9.00 77241 N 20080329 STZ210B1 2307110 OPER2 35 1 Y 88063 2017-02-06T10:40:45.791-05:00 Y 1 PR
15.00 20140701 STC210N0 1328421 E002976 Y 1830000 1.5 Y NHEO0240 20151 1 001 Y U E 15.00 KDA 17 17 SU MATH THROUGH GOLD 01 CTE CDA S 1124030024030010 R N 1133190 2.65 183053 N 20140805 STC210N0 1337588 E002976 20 1 Y 197741 2017-02-06T10:41:00.487-05:00 Y NC5 IN
48.00 20130301 STC210N0 0906311 E002073 Y 0930000 N CMAT0018 20141 2 008 Y U D 48.00 24 23 AN DEVELOPMENTAL MATH 1 01 DEG CPI 3.00 S 1131010031010220 R Y 1116178 9.00 162592 N 20130729 STC210N0 0903385 E000968 27 1 Y Y 176374 2017-02-06T10:40:57.663-05:00 Y 1 IN
52.50 20130301 STC210N0 1433189 E002073 Y 0800000 N CCGS1100 20142 5 021 Y U D 48.00 6 6 AW MICROCOMPUTER APPLIC 01 DEG CPTR 3.00 S 1116070016070050 R Y 931156 9.00 166797 N 20131009 STC210N0 1613404 E077483 24 1 Y Y 181195 2017-02-06T10:40:58.225-05:00 Y 3 IN
Powered by BI Documenter