DWStaging
 dbo.ST_COURSE_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_COURSE_A
  Properties
Property Value
Name ST_COURSE_A
Schema dbo
Row Count 30757
Data Size 6928 KB
Index Size 504 KB
Create Date 2/18/2014 11:32 AM
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
 
BOOK_MATERIALS_POPLT
varchar(1)
True
False
False
 
BOOK_MATERIALS_REQ
varchar(1)
True
False
False
 
BOOK_MATERIALS_TERM
varchar(6)
True
False
False
 
CE_UNITS
numeric(4, 1)
True
False
False
 
CEU_APRVD
varchar(1)
True
False
False
 
CLS_ROLL_PRNT
varchar(1)
True
False
False
 
COLL_PREP_TIMES
int(10, 0)
True
False
False
 
CRED_TY
varchar(2)
True
False
False
 
CRNT_CRS
varchar(10)
True
False
False
 
CRNT_CRS_EFF_TRM
varchar(6)
True
False
False
 
CRNT_CRS_END_TRM
varchar(6)
True
False
False
 
CRS_ID
varchar(10)
True
False
False
 
CRS_LOAD_VALUE
numeric(5, 2)
True
False
False
 
CRS_STAT_CD
varchar(1)
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
 
DSCPLN_ID
varchar(4)
True
False
False
 
EFF_TRM
varchar(6)
True
False
False
 
EFF_TRM_9S_COMP
varchar(6)
True
False
False
 
END_TRM
varchar(6)
True
False
False
 
EXTRNL_CRED_HRS
numeric(4, 2)
True
False
False
 
FRGV_ELIG
varchar(1)
True
False
False
 
FRGV_TIMES
varchar(2)
True
False
False
 
FRST_TRM_MADE
varchar(6)
True
False
False
 
GL_ACCT_NUM
varchar(25)
True
False
False
 
GORDON_RULE
varchar(1)
True
False
False
 
GORDON_RULE_WRD_CNT
int(10, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ICS_NUM
varchar(5)
True
False
False
 
INIT_RETAKE_TST
varchar(1)
True
False
False
 
INSTR_PRMSN
varchar(1)
True
False
False
 
ISN_ST_COURSE_A
int(10, 0)
False
False
False
 
LAST_REVIEW_DATE
varchar(8)
True
False
False
 
LST_TRM_MADE
varchar(6)
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_CLNCL_HRS
numeric(6, 2)
True
False
False
 
MAX_CLS_SIZE
int(10, 0)
True
False
False
 
MAX_CNTCT_HRS
numeric(6, 2)
True
False
False
 
MAX_CRED_HRS
numeric(4, 2)
True
False
False
 
MAX_LAB_HRS
numeric(6, 2)
True
False
False
 
MAX_LECTR_HRS
numeric(6, 2)
True
False
False
 
MAX_OTHER_HRS
numeric(6, 2)
True
False
False
 
MIN_CLNCL_HRS
numeric(6, 2)
True
False
False
 
MIN_CLS_SIZE
int(10, 0)
True
False
False
 
MIN_CNTCT_HRS
numeric(6, 2)
True
False
False
 
MIN_CRED_HRS
numeric(4, 2)
True
False
False
 
MIN_ERND_CRED_HRS
numeric(7, 2)
True
False
False
 
MIN_GRD_REQD_ADV
varchar(2)
True
False
False
 
MIN_LAB_HRS
numeric(6, 2)
True
False
False
 
MIN_LECTR_HRS
numeric(6, 2)
True
False
False
 
MIN_OTHER_HRS
numeric(6, 2)
True
False
False
 
NEXT_REVIEW_DATE
varchar(8)
True
False
False
 
OVRD_CRS_TTL_IN_CLS
varchar(1)
True
False
False
 
PGM_ID
varchar(5)
True
False
False
 
PLCMNT_RSTR
varchar(1)
True
False
False
 
PREV_CRS
varchar(10)
True
False
False
 
PREV_CRS_EFF_TRM
varchar(6)
True
False
False
 
PREV_CRS_END_TRM
varchar(6)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SCNS_APRVD
varchar(1)
True
False
False
 
TIMES_FOR_CRED
varchar(3)
True
False
False
 
USED_FOR_AA_ELECTIVE
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_COURSE_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_COURSE_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.ST_COURSE_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_COURSE_A] Script Date: 03/09/2017 16:46:00 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_COURSE_A](
    [ISN_ST_COURSE_A] [int] NOT 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,
    [CE_UNITS] [numeric](4, 1) NULL,
    [CEU_APRVD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLS_ROLL_PRNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLL_PREP_TIMES] [int] NULL,
    [CRED_TY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRNT_CRS] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRNT_CRS_EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRNT_CRS_END_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_STAT_CD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_TTL] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_TY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DIV_DEPT_CD] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DSCPLN_ID] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_9S_COMP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXTRNL_CRED_HRS] [numeric](4, 2) NULL,
    [FRGV_ELIG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FRGV_TIMES] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FRST_TRM_MADE] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_ACCT_NUM] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GORDON_RULE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GORDON_RULE_WRD_CNT] [int] NULL,
    [HOLD] [int] NULL,
    [ICS_NUM] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INIT_RETAKE_TST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INSTR_PRMSN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LST_TRM_MADE] [varchar](6) 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,
    [MAX_CLNCL_HRS] [numeric](6, 2) NULL,
    [MAX_CLS_SIZE] [int] NULL,
    [MAX_CNTCT_HRS] [numeric](6, 2) NULL,
    [MAX_CRED_HRS] [numeric](4, 2) NULL,
    [MAX_LAB_HRS] [numeric](6, 2) NULL,
    [MAX_LECTR_HRS] [numeric](6, 2) NULL,
    [MIN_CLNCL_HRS] [numeric](6, 2) NULL,
    [MIN_CLS_SIZE] [int] NULL,
    [MIN_CNTCT_HRS] [numeric](6, 2) NULL,
    [MIN_CRED_HRS] [numeric](4, 2) NULL,
    [MIN_ERND_CRED_HRS] [numeric](7, 2) NULL,
    [MIN_LAB_HRS] [numeric](6, 2) NULL,
    [MIN_LECTR_HRS] [numeric](6, 2) NULL,
    [OVRD_CRS_TTL_IN_CLS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREV_CRS] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREV_CRS_EFF_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PREV_CRS_END_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SCNS_APRVD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TIMES_FOR_CRED] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRS_LOAD_VALUE] [numeric](5, 2) NULL,
    [LAST_REVIEW_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NEXT_REVIEW_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIN_OTHER_HRS] [numeric](6, 2) NULL,
    [MAX_OTHER_HRS] [numeric](6, 2) NULL,
    [USED_FOR_AA_ELECTIVE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOOK_MATERIALS_REQ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOOK_MATERIALS_POPLT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOOK_MATERIALS_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PLCMNT_RSTR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIN_GRD_REQD_ADV] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BOOK_MATERIALS_POPLT BOOK_MATERIALS_REQ BOOK_MATERIALS_TERM CE_UNITS CEU_APRVD CLS_ROLL_PRNT CRED_TY CRNT_CRS CRNT_CRS_EFF_TRM CRNT_CRS_END_TRM CRS_ID CRS_LOAD_VALUE CRS_STAT_CD CRS_TTL CRS_TY DIV_DEPT_CD DSCPLN_ID EFF_TRM EFF_TRM_9S_COMP END_TRM EXTRNL_CRED_HRS FRGV_ELIG FRGV_TIMES FRST_TRM_MADE GL_ACCT_NUM GORDON_RULE HOLD ICS_NUM INIT_RETAKE_TST INSTR_PRMSN ISN_ST_COURSE_A LAST_REVIEW_DATE LST_TRM_MADE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAX_CLS_SIZE MAX_CRED_HRS MAX_LAB_HRS MAX_LECTR_HRS MIN_CLS_SIZE MIN_CRED_HRS MIN_GRD_REQD_ADV MIN_LAB_HRS MIN_LECTR_HRS NEXT_REVIEW_DATE OVRD_CRS_TTL_IN_CLS PGM_ID PLCMNT_RSTR PREV_CRS PREV_CRS_EFF_TRM PREV_CRS_END_TRM RowUpdatedOn SCNS_APRVD TIMES_FOR_CRED USED_FOR_AA_ELECTIVE
19981117 STC110N0 1600519 DWORKMN 1.0 Y Y 05 MTS0211 2 19961 19961 MTS0211 2 5.29 I ANATOMY &PHYSIOL 01 CTE MO 19961 800389 19961 N 99 19961 11230200 N 1600519 12302 12626 19961 1.00 1.00 N 2017-02-06T11:10:26.746-05:00 Y 0
20100223 STC110N0 1152359 E000235 Y Y 04 YCO0093 20102 20153 YCO0093 1.06 I SPORTS ZONE 01 CTE SYC 1 20102 798979 20153 Y 99 11420000420105 N 1122129 14200 28084 20103 20150717 STC110N0 1122129 E000235 100 6.00 1 6.00 N 2017-02-06T11:10:29.663-05:00 N 0
19981117 STC110N0 1555036 DWORKMN 1.0 Y Y 06 CPO0037 19943 19952 CPO0037 2.65 I WP FOR WINDOWS 01 CTE CCTE 19943 800569 19952 N 99 19943 11250300 N 1555036 12503 7769 19952 15.00 15.00 N 2017-02-06T11:10:25.856-05:00 Y 0
20041028 STC110N0 1352243 E000781 Y Y 04 TGO0154 20053 20063 TGO0154 2.12 I INTRO TO PHOTOSHOP 7 01 CTE LU 20043 799569 20052 Y 99 11420000420100 N 1030540 14200 3964 20052 20050510 STC110N0 1030540 E000781 100 12.00 1 12.00 N 2017-02-06T11:10:25.123-05:00 N 0
19981117 STC110N0 1556437 DWORKMN Y Y 05 EVO0019 A 19912 19912 EVO0019 A 6.01 I FWPCOA-ADV WW 01 99 99 19912 800879 19912 N 99 19912 19999100 N 1556437 99991 9319 19912 36.00 36.00 N 2017-02-06T11:10:26.106-05:00 Y 0
20000718 STC110N0 1107469 NBUHL Y Y 05 PRN0021 20061 20161 PRN0021 6.00 I GROWTH/DEV & NURTRIT 01 CTE PN 3 20002 799979 20053 Y 99 20012 11230200230203 N 1428216 12302 21723 20052 20060613 STC110N0 1428216 E000235 100 96.00 1 96.00 N 2017-02-06T11:10:28.462-05:00 N 1
19981117 STC110N0 1608002 DWORKMN Y Y 05 SSO0040 F 19801 19801 SSO0040 F 16.03 I CONT LVNG ADPTN 01 99 99 19801 801989 19801 N 99 19801 19999300 N 1608002 99993 17589 19801 96.00 96.00 N 2017-02-06T11:10:27.697-05:00 Y 0
20151201 STC110N0 1434575 E000235 N Y 01 ISM4117 20171 ISM4117 9.00 A DATA MIN & DATA WHSE 01 BAS INFO 20171 798289 3.00 Y 02 11160791116710 N 809226 11607 30411 20171 20161207 STC110N0 0809226 E002073 100 3.00 48.00 1 3.00 48.00 N ISM4117 20111 20163 2017-02-06T11:10:30.068-05:00 Y 1
19980409 STC110N0 1259021 NSIMMNS N Y 01 MVB2221 R 20071 20113 MVB2221 R 4.00 I AP TRUMPET PRN SEC S 01 DEG MUS 19973 800269 20063 1.00 Y 12 19973 11121000121002 N 1039392 11210 2868 20053 20061031 STC110N0 1039392 E000235 100 1.00 32.00 1 1.00 32.00 N 2017-02-06T11:10:24.905-05:00 Y 9
19981117 STC110N0 1555217 DWORKMN Y Y 06 CPO0171 19963 19971 CPO0171 2.12 I WORD WIND INTRO 01 CTE CCTE 19963 800369 19971 N 99 19963 11250300 N 1555217 12503 8051 19971 12.00 12.00 N 2017-02-06T11:10:25.919-05:00 Y 0
Powered by BI Documenter