DWStaging
 dbo.TRAINING_ACTIVITY_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.TRAINING_ACTIVITY_A
  Properties
Property Value
Name TRAINING_ACTIVITY_A
Schema dbo
Row Count 6375
Data Size 1440 KB
Index Size 136 KB
Create Date 11/5/2012 9:58 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACTIVITY_AMOUNT
numeric(17, 2)
True
False
False
 
ACTIVITY_APPROVAL_CODE
varchar(10)
True
False
False
 
ACTIVITY_CODE
varchar(10)
True
False
False
 
ACTIVITY_HOURS
numeric(17, 2)
True
False
False
 
ACTIVITY_REQUIRED_CODE
varchar(10)
True
False
False
 
ACTIVITY_STATUS
varchar(10)
True
False
False
 
ACTIVITY_TITLE
varchar(50)
True
False
False
 
ACTIVITY_TYPE
varchar(10)
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
 
COURSE_PROVIDER_NAME
varchar(50)
True
False
False
 
DATE_REMINDER_EMAIL
varchar(8)
True
False
False
 
DISPLAY_ON_WEB
varchar(1)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
END_TIME
varchar(7)
True
False
False
 
FACILITY_LOCAL_NUM
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_TRAINING_ACTIVITY_A
int(10, 0)
False
False
False
 
LAST_DATE_DROPPED
varchar(8)
True
False
False
 
LOCATION_NUM
varchar(4)
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_CLASS_CAPACITY
int(10, 0)
True
False
False
 
MIN_CLASS_CAPACITY
int(10, 0)
True
False
False
 
PRE_APPROVED_HOURS
numeric(17, 2)
True
False
False
 
ROOM_NUM
varchar(6)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SEQ
int(10, 0)
True
False
False
 
SITE_LOCAL_NUM
varchar(1)
True
False
False
 
START_DATE
varchar(8)
True
False
False
 
START_DATE_9C
int(10, 0)
True
False
False
 
START_TIME
varchar(7)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_TRAINING_ACTIVITY_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.TRAINING_ACTIVITY_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.TRAINING_ACTIVITY_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[TRAINING_ACTIVITY_A] Script Date: 03/09/2017 16:46:33 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[TRAINING_ACTIVITY_A](
    [ISN_TRAINING_ACTIVITY_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,
    [ACTIVITY_TYPE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_CODE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_STATUS] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_TITLE] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SITE_LOCAL_NUM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOCATION_NUM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FACILITY_LOCAL_NUM] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROOM_NUM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_AMOUNT] [numeric](17, 2) NULL,
    [ACTIVITY_APPROVAL_CODE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_HOURS] [numeric](17, 2) NULL,
    [PRE_APPROVED_HOURS] [numeric](17, 2) NULL,
    [COURSE_PROVIDER_NAME] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIN_CLASS_CAPACITY] [int] NULL,
    [MAX_CLASS_CAPACITY] [int] NULL,
    [SEQ] [int] NULL,
    [LAST_DATE_DROPPED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_REQUIRED_CODE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISPLAY_ON_WEB] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DATE_REMINDER_EMAIL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE_9C] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACTIVITY_AMOUNT ACTIVITY_APPROVAL_CODE ACTIVITY_CODE ACTIVITY_HOURS ACTIVITY_REQUIRED_CODE ACTIVITY_STATUS ACTIVITY_TITLE ACTIVITY_TYPE ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID COURSE_PROVIDER_NAME DATE_REMINDER_EMAIL DISPLAY_ON_WEB END_DATE END_TIME FACILITY_LOCAL_NUM HOLD ISN_TRAINING_ACTIVITY_A LAST_DATE_DROPPED LOCATION_NUM MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAX_CLASS_CAPACITY MIN_CLASS_CAPACITY PRE_APPROVED_HOURS ROOM_NUM RowUpdatedOn SEQ SITE_LOCAL_NUM START_DATE START_DATE_9C START_TIME
BBTOOLS 1.00 CM Blackboard Tool: Assignment Tool DISTLEARN 20120501 PED280N1 1203009 E005890 Sid Beiter/ Jeannine Burgess 20120521 Y 20120522 1500000 ITB 2024067 3128 20120521 0000 20120603 PED280N1 2024067 E005890 19 4 00206 2017-02-06T11:32:45.094-05:00 2 1 20120522 79879477 1400000
BBTOOLS 1.00 OP BLACKBOARD TOOL: Gradebook Basics DISTLEARN 20150109 PED280N1 0820291 E005890 Sid Beitler / Jeannine Burgess 20150125 Y 20150126 1530000 ITB 820291 5290 20150125 0000 15 4 00206 2017-02-06T11:32:45.328-05:00 2 1 20150126 79849873 1430000
BBTOOLS 1.00 CM Blackboard Tool: Using Lesson Builder DISTLEARN 20120124 PED280N1 1700295 E005890 Sid Beiter/ Jeannine Burgess 20120221 Y 20120222 1430000 LL 2303015 2996 20120221 0000 20120223 PED280N1 2303015 E005890 1 4 00103 2017-02-06T11:32:45.063-05:00 1 1 20120222 79879777 1330000
DESKSIDE 1.50 CM Deskside Computer Coaching COMPUTER 20070813 PED280N1 0919104 E032243 Kara McKenney 20070921 Y 20070925 1430000 UK01 822029 1225 20070924 0000 20070927 PED280N1 0822029 E027036 1 1 1.50 UK001 2017-02-06T11:32:44.844-05:00 3 5 20070925 79929074 1300000
E-FROG 3.50 CM Eat That Frog! LEADERSHIP 20061206 PED280N1 1139333 E020563 George Ahmani 20070209 Y 20070214 1200000 AH 1327154 957 20070213 0000 20070220 PED280N1 1327154 E027036 24 1 3.50 00302 2017-02-06T11:32:44.797-05:00 1 1 20070214 79929785 0830000
BBTOOLS 1.00 CM Blackboard Tool: Grade Center DISTLEARN 20120803 PED280N1 1132438 E005890 Sid Beiter/ Jeannine Burgess 20120827 Y 20120828 1400000 SC 1018406 3399 20120827 0000 20130115 PED280N1 1018406 E005890 15 4 00109 2017-02-06T11:32:45.109-05:00 2 2 20120828 79879171 1300000
MSOFFICE07 2.00 CM MICROSOFT OFFICE 2007 COMPUTER 20070612 PED280N1 1213260 E006065 DEB FORSTEN 20070625 Y 20070627 1215000 TC 950567 1098 20070626 0000 20070629 PED280N1 0950567 E027036 24 1 2.00 00405 2017-02-06T11:32:44.829-05:00 2 1 20070627 79929372 1030000
1.00 PS_BASICS 1.00 CA Adobe Photoshop Basics INSTRTECHN 20150326 PED280N1 0838355 E001855 Jeannine Burgess 20150406 Y 20150407 1500000 ITB 914345 5373 0000 20150406 PED280N1 0914345 E001855 19 1 1.00 00206 2017-02-06T11:32:45.328-05:00 1 1 20150407 79849592 1400000
FSA L2072403A 3.50 CM MANAGERIAL COURAGE & DECISION L2 DR. ROBERT C. PREZIOSI 20030724 1200000 HIST 1245085 230 0000 3.50 00205 2017-02-06T11:32:44.719-05:00 1 1 20030724 79969275 0830000
DESKSIDE 1.50 CM Deskside Computer Coaching COMPUTER 20120813 PED280N1 1533380 E077683 Gina Parsons-Raines 20120819 N 20120821 1000000 UK01 1103064 3409 20120820 0000 20120822 PED280N1 1103064 E087669 1 1 1.50 UK001 2017-02-06T11:32:45.109-05:00 1 3 20120821 79879178 0830000
Powered by BI Documenter