DWStaging
 dbo.ST_HS_COUNSELOR_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_HS_COUNSELOR_A
  Properties
Property Value
Name ST_HS_COUNSELOR_A
Schema dbo
Row Count 10
Data Size 8 KB
Index Size 24 KB
Create Date 3/4/2015 10:09 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
 
CNSLR_ID
int(10, 0)
True
False
False
 
DE_SPCL_DES
varchar(2)
True
False
False
 
EMAIL_ADDR
varchar(40)
True
False
False
 
FAX_NUM
varchar(20)
True
False
False
 
FRST_NM
varchar(20)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INST_ID
varchar(8)
True
False
False
 
ISN_ST_HS_COUNSELOR_A
int(10, 0)
False
False
False
 
LST_NM
varchar(35)
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
 
MDL_NM
varchar(20)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SIGNON_ID
varchar(8)
True
False
False
 
SRCH_NAME
varchar(25)
True
False
False
 
WRK_PHN
varchar(20)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_HS_COUNSELOR_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_HS_COUNSELOR_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_HS_COUNSELOR_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_HS_COUNSELOR_A] Script Date: 03/09/2017 16:46:08 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_HS_COUNSELOR_A](
    [ISN_ST_HS_COUNSELOR_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,
    [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,
    [HOLD] [int] NULL,
    [CNSLR_ID] [int] NULL,
    [SIGNON_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LST_NM] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FRST_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MDL_NM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WRK_PHN] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FAX_NUM] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_ADDR] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SRCH_NAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DE_SPCL_DES] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INST_ID] [varchar](8) 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 CNSLR_ID DE_SPCL_DES EMAIL_ADDR FAX_NUM FRST_NM HOLD INST_ID ISN_ST_HS_COUNSELOR_A LST_NM MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MDL_NM RowUpdatedOn SIGNON_ID SRCH_NAME WRK_PHN
20150122 STV220N0 1052535 E011582 990000202 COUNSELOR12@HETGROUP.ORG B 848462 101923 1 LYON 20170130 STV220N0 0848462 ZCTBK 2017-02-06T11:31:47.982-05:00 BLYON LYON, B (954) 555-1111
20150122 STV220N0 1121354 E011582 990000209 COUNSELOR3@HETGROUP.ORG M 849471 102381 4 HAMMETT 20170130 STV220N0 0849471 ZCTBK 2017-02-06T11:31:47.997-05:00 hetgrp2 HAMMETT, M (954) 555-1111
20150122 STV220N0 1117060 E011582 990000206 COUNSELOR2@HETGROUP.ORG J 849312 101338 3 MARX 20170130 STV220N0 0849312 ZCTBK 2017-02-06T11:31:47.997-05:00 hetgrp1 MARX, J (954) 555-1111
20150123 STV220N0 1508123 E011582 990000215 COUNSELOR7@HETGROUP.ORG H 847405 101994 8 WOEBER 20170130 STV220N0 0847405 ZCTBK 2017-02-06T11:31:47.997-05:00 woeberh WOEBER, H (954) 555-1111
20150126 STV220N0 0838274 E011582 990000217 COUNSELOR9@HETGROUP.ORG A 847509 101982 10 SAMMARCO 20170130 STV220N0 0847509 ZCTBK 2017-02-06T11:31:47.997-05:00 sammaro SAMMARCO, A (954) 555-1111
20150123 STV220N0 1506316 E011582 990000214 COUNSELOR6@HETGROUP.ORG M 847350 101320 7 MARTIN 20170130 STV220N0 0847350 ZCTBK 2017-02-06T11:31:47.997-05:00 martinmm MARTIN, M (954) 555-1111
20150123 STV220N0 1501599 E011582 990000212 COUNSELOR4@HETGROUP.ORG J 847244 100194 5 NULLMAN 20170130 STV220N0 0847244 ZCTBK 2017-02-06T11:31:47.997-05:00 nullmanj NULLMAN, J (954) 555-1111
20150123 STV220N0 1503460 E011582 990000213 COUNSELOR5@HETGROUP.ORG E 847299 100167 6 KURTZ 20170130 STV220N0 0847299 ZCTBK 2017-02-06T11:31:47.997-05:00 kurtze KURTZ, E (954) 555-1111
20150123 STV220N0 1537443 E011582 990000216 COUNSELOR8@HETGROUP.ORG K 847461 101824 9 HOBACK 20170130 STV220N0 0847461 ZCTBK 2017-02-06T11:31:47.997-05:00 hobackk HOBACK, K (954) 555-1111
20150122 STV220N0 1055588 E011582 990000203 COUSELOR1@HETGROUP.ORG R 849179 101923 2 DEWALT 20170130 STV220N0 0849179 ZCTBK 2017-02-06T11:31:47.997-05:00 hetgrp1 DEWALT, R (954) 555-1111
Powered by BI Documenter