DWStaging
 dbo.ST_CLASS_LOG_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_LOG_A
  Properties
Property Value
Name ST_CLASS_LOG_A
Schema dbo
Row Count 1929911
Data Size 458640 KB
Index Size 28808 KB
Create Date 8/15/2012 12:45 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_LOG_A
int(10, 0)
False
False
False
 
LATE_FEE_EXMPTN
varchar(1)
True
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
varchar(8)
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
 
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
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_CLASS_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_CLASS_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_CLASS_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_CLASS_LOG_A] Script Date: 03/09/2017 16:45:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_CLASS_LOG_A](
    [ISN_ST_CLASS_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [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_LOG_A LATE_FEE_EXMPTN LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAX_CLS_SIZE MIN_CLS_SIZE PHN_RGSTRTN REF_NUM RowUpdatedOn SCHD_PRNT SESSION_CD
67.20 20100120 STC210N0 1553078 E032742 Y 0930000 N CHIM1000C 20111 1 001 Y O D 64.00 7 4 AW INTR TO HLTH INF MGT 03 DEG HIM 3.00 S 1123010023011610 Y 1524461 10.50 1279819 N M 20100818 pts/137 1524461 E032742 20100818 STC210N0 1524461 E032742 30 1 Y 143464 2017-02-06T10:01:49.505-05:00 Y 1
20050831 STC210N0 0357267 OPER2 Y TBA N CHUN1201 20071 1 001 Y O O 48.00 32 26 AW ELEMENT OF NUTRITION 01 DEG HLTH 3.00 S 1114080014080210 Y 2316452 9.00 795865 N M 20060817 <notty> 900299 WEB4 20060331 STC210N0 0941244 E000209 36 12 Y 87318 2017-02-06T10:00:40.693-05:00 Y 1
20050831 STC210N0 0403567 OPER2 Y 0800000 Y NARR0242 20071 1 001 Y O D 120.00 LT SU AUTOBODY REPAIR-INT 01 CTE BI S 1126020026020910 N 403567 21.18 232172 N A 20050831 STEP10 403568 OPER2 15 4 Y 88620 2017-02-06T09:59:16.343-05:00 Y NC5
6.00 20060831 STC210N0 1546567 E015633 Y 0900000 0.6 Y NHEV0118 20072 3 001 Y U W 6.00 SL 14 14 SU RULE/REG FMLY CHLDCR 01 CTE CDA S 1124020024020130 R N 1249519 1.06 932445 N M 20070319 <notty> 343382 OPER2 20070316 STC210N0 1133195 E015633 13 13 Y 97526 2017-02-06T10:01:01.316-05:00 Y NC1
20050831 STC210N0 0406014 OPER2 Y TBA Y NOTA0423 20071 1 001 Y O O 90.00 GN 10 4 AN BS OFFICE OPERATIONS 01 CTE OFC S 1125020025020810 N 1415593 15.88 771031 N M 20060809 <notty> 1313274 WEB4 20060615 STC210N0 1000012 E015640 100 1 Y 88991 2017-02-06T10:00:37.12-05:00 Y NLAB
52.80 20080116 STC210N0 2007179 E002073 Y 1830000 N CMAT0012 20091 1 014 Y O E 48.00 AN BASIC ALGEBRA 1 01 DEG CPI 3.00 S 1131010031010210 R Y 1450206 9.00 1036279 N M 20080325 pts/274 1450206 E000515 20080325 STC210N0 1450206 E000515 27 1 Y 111909 2017-02-06T10:01:16.167-05:00 Y 1
15.00 20091214 STC210N0 1951533 E002073 Y 1300000 N CDEH1800 20112 1 001 Y U D 16.00 24 24 AW DENTAL HYGIENE 1 01 DEG DH 1.00 S 1123010023010010 R Y 158172 3.00 1347859 N M 20110506 <notty> 1743335 OPER2 20100224 STC210N0 1010449 E001156 25 1 Y 138670 2017-02-06T10:01:58.771-05:00 Y 1
52.80 20050315 STC210N0 1622408 E007269 Y 1830000 N CECO2023 20062 5 003 Y O E 48.00 9 2 AW PRIN MICROECONOMICS 01 DEG SOCS 3.00 S 1117220017220250 Y 1337287 9.00 322470 N M 20051117 NATB0102 958537 WEB4 20050331 STC210N0 1505319 OPER2 35 1 Y 81567 2017-02-06T09:59:30.009-05:00 Y 1
49.50 20050204 STC210N0 1552289 E002589 Y 0930000 N CPSY2012 20061 1 007 Y O D 48.00 13 1 AW GENERAL PSYCHOLOGY 01 DEG PSY 3.00 S 1117200017200010 Y 2131482 9.00 47978 N M 20050710 NATB0102 1314278 WEB2 20050331 STC210N0 1724208 E002049 35 1 Y 78123 2017-02-06T09:58:48.715-05:00 Y 1
52.80 20050204 STC210N0 1453583 E002073 Y 1830000 N CACG2071 20062 1 004 Y O E 48.00 23 10 AW MANAGERIAL ACCOUNTNG 01 DEG ACC 3.00 S 1115050015050110 Y 1656464 9.00 411337 N M 20060101 NATB0102 1255262 WEB1 20051220 STC210N0 1220367 E015640 35 1 Y 77847 2017-02-06T09:59:43.175-05:00 Y 1
Powered by BI Documenter