DWStaging
 dbo.ST_DA_BNCHMRKS_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_DA_BNCHMRKS_A
  Properties
Property Value
Name ST_DA_BNCHMRKS_A
Schema dbo
Row Count 1101018
Data Size 198120 KB
Index Size 16448 KB
Create Date 2/2/2017 1:55 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
 
AWD_TY
varchar(3)
True
False
False
 
CC_100PCT_CMPLTD
varchar(1)
True
False
False
 
CC_25PCT_CMPLTD
varchar(1)
True
False
False
 
CC_50PCT_CMPLTD
varchar(1)
True
False
False
 
CC_75PCT_CMPLTD
varchar(1)
True
False
False
 
CC_90PCT_CMPLTD
varchar(1)
True
False
False
 
CC_COLL_PREP
varchar(1)
True
False
False
 
CC_EXIT_TEST
varchar(1)
True
False
False
 
CC_FIN_OBLGTN
varchar(1)
True
False
False
 
CC_GNRL_ED
varchar(1)
True
False
False
 
CC_GPA
varchar(1)
True
False
False
 
CC_GRAD
varchar(1)
True
False
False
 
CC_GRDN_RULE
varchar(1)
True
False
False
 
CC_MATH_REQMNT
varchar(1)
True
False
False
 
CC_PNTNTL_TERM_GRAD
varchar(1)
True
False
False
 
CC_RSDNCY
varchar(1)
True
False
False
 
CNTCT_HRS_ERND
numeric(6, 2)
True
False
False
 
CRED_HRS_ERND
numeric(6, 2)
True
False
False
 
EFF_TRM
varchar(6)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_DA_BNCHMRKS_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
 
PGM_CD
varchar(5)
True
False
False
 
PREP_NOT_REQ
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STDNT_ID
varchar(9)
True
False
False
 
SUS_FRGN_LANG
varchar(1)
True
False
False
 
SUS_IMMUN
varchar(1)
True
False
False
 
SUS_PRE_ADM_CRSES
varchar(1)
True
False
False
 
SUS_REQD_ADM_GPA
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_DA_BNCHMRKS_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_DA_BNCHMRKS_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_DA_BNCHMRKS_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_DA_BNCHMRKS_A] Script Date: 03/09/2017 16:46:03 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_DA_BNCHMRKS_A](
    [ISN_ST_DA_BNCHMRKS_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,
    [PGM_CD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWD_TY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_COLL_PREP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_GRDN_RULE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_GNRL_ED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_RSDNCY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_GPA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_25PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_50PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_75PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_100PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_EXIT_TEST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_PNTNTL_TERM_GRAD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_FIN_OBLGTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_GRAD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUS_PRE_ADM_CRSES] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUS_FRGN_LANG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUS_IMMUN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUS_REQD_ADM_GPA] [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,
    [PREP_NOT_REQ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRED_HRS_ERND] [numeric](6, 2) NULL,
    [CNTCT_HRS_ERND] [numeric](6, 2) NULL,
    [CC_MATH_REQMNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CC_90PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AWD_TY CC_100PCT_CMPLTD CC_25PCT_CMPLTD CC_50PCT_CMPLTD CC_75PCT_CMPLTD CC_90PCT_CMPLTD CC_COLL_PREP CC_EXIT_TEST CC_FIN_OBLGTN CC_GNRL_ED CC_GPA CC_GRAD CC_GRDN_RULE CC_MATH_REQMNT CC_PNTNTL_TERM_GRAD CC_RSDNCY CRED_HRS_ERND EFF_TRM HOLD ISN_ST_DA_BNCHMRKS_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PGM_CD PREP_NOT_REQ RowUpdatedOn STDNT_ID SUS_FRGN_LANG SUS_IMMUN SUS_PRE_ADM_CRSES SUS_REQD_ADM_GPA
20110410 STD325N0 1709261 WEB5 AAS 20113 839015 576052 20110709 STD325N0 0839015 WEB5 A042 2017-02-06T09:51:42.567-05:00 J13786025
20081119 STD325N0 0835113 WEB5 AAS 20091 835113 316948 20081119 STD325N0 0835113 WEB5 A087 2017-02-06T09:51:19.776-05:00 A13065339
20120127 STD325N0 1527112 E002192 TC 20121 1527112 734188 20120127 STD325N0 1527112 E002192 6366 2017-02-06T09:51:56.732-05:00 P13208749
20091014 STD325N0 1212335 E011387 AC X 20093 1212335 501222 20091014 STD325N0 1212335 E011387 4322 2017-02-06T09:51:36.015-05:00 S11688744
20110426 STD325N0 1018478 E052753 AAS X 12.00 20111 1018478 617956 20110426 STD325N0 1018478 E052753 A163 2017-02-06T09:51:46.186-05:00 J12950978
20141021 STD325N0 1718441 WEB5 AS X X X X X X X X X 65.00 20163 1015457 1011543 20161206 STD325N0 1015457 E003976 2345 X 2017-02-06T09:52:22.784-05:00 J13651104
20091014 STD325N0 1119495 E011387 AC 20093 1119495 474759 20091014 STD325N0 1119495 E011387 4322 2017-02-06T09:51:33.738-05:00 A06212559
20161202 STD325N0 1156219 E091980 AA 13.00 20171 1336445 1091390 20161202 STD325N0 1336445 WEB5 1000 2017-02-06T09:52:30.179-05:00 G15342454
20020522 STD325N0 0931389 OPER2 AS X X X 24.00 20061 420050 61252 20060218 STD325N0 0420050 OPER2 2342 2017-02-06T09:50:55.798-05:00 A07980899
20160802 STD325N0 1012071 WEB5 AA X X X X X X X X X X 62.00 20171 257343 1078343 20161220 STD325N0 0257343 OPER2 1000 X 2017-02-06T09:52:28.962-05:00 M14708895 X
Powered by BI Documenter