DWStaging
 dbo.EMPLOYEE_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.EMPLOYEE_TRAINING_ACTIVITY_A
  Properties
Property Value
Name EMPLOYEE_TRAINING_ACTIVITY_A
Schema dbo
Row Count 58272
Data Size 7008 KB
Index Size 912 KB
Create Date 11/2/2012 3:07 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACTIVITY_CODE
varchar(10)
True
False
False
 
ACTIVITY_STATUS
varchar(10)
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
 
CURRENT_STATUS_DATE
varchar(8)
True
False
False
 
CURRENT_STATUS_TIME
varchar(7)
True
False
False
 
DEVELOPMENT_HOURS_APPLIED
numeric(17, 2)
True
False
False
 
DEVELOPMENT_HOURS_AWARDED
numeric(17, 2)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_EMPLOYEE_TRAINING_ACTIVITY_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
 
PERSON_ID
int(10, 0)
True
False
False
 
RECERT_HOURS_APPLIED
numeric(17, 2)
True
False
False
 
RECERT_HOURS_AWARDED
numeric(17, 2)
True
False
False
 
REIMBURSE_AMOUNT_APPLIED
numeric(17, 2)
True
False
False
 
REIMBURSE_AMOUNT_AWARDED
numeric(17, 2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SEQ
int(10, 0)
True
False
False
 
START_DATE
varchar(8)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_EMPLOYEE_TRAINING_ACTIVITY_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.EMPLOYEE_TRAINING_ACTIVITY_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.EMPLOYEE_TRAINING_ACTIVITY_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[EMPLOYEE_TRAINING_ACTIVITY_A] Script Date: 03/09/2017 16:45:17 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[EMPLOYEE_TRAINING_ACTIVITY_A](
    [ISN_EMPLOYEE_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,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERSON_ID] [int] NULL,
    [DEVELOPMENT_HOURS_APPLIED] [numeric](17, 2) NULL,
    [DEVELOPMENT_HOURS_AWARDED] [numeric](17, 2) NULL,
    [RECERT_HOURS_APPLIED] [numeric](17, 2) NULL,
    [RECERT_HOURS_AWARDED] [numeric](17, 2) NULL,
    [REIMBURSE_AMOUNT_APPLIED] [numeric](17, 2) NULL,
    [REIMBURSE_AMOUNT_AWARDED] [numeric](17, 2) NULL,
    [SEQ] [int] NULL,
    [CURRENT_STATUS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CURRENT_STATUS_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACTIVITY_CODE ACTIVITY_STATUS ACTIVITY_TYPE ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CURRENT_STATUS_DATE CURRENT_STATUS_TIME DEVELOPMENT_HOURS_APPLIED DEVELOPMENT_HOURS_AWARDED HOLD ISN_EMPLOYEE_TRAINING_ACTIVITY_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PERSON_ID RowUpdatedOn SEQ START_DATE
SF FALPROT CM SAFETY 20150715 PED285N1 1550315 E028726 20150715 1550315 1550315 50178 88288 2017-02-06T11:31:29.745-05:00 1 20140101
FERPA CM PROFGROWTH 20130508 PED285N1 1354416 E088844 20130508 1354416 0.25 0.25 1354416 40072 88925 2017-02-06T11:31:28.856-05:00 1 20120701
SF HANDSAF CM SAFETY 20150715 PED285N1 1525475 E028726 20150715 1525475 1525475 50125 28883 2017-02-06T11:31:29.745-05:00 2 20141101
INFOSECURE CM PROFGROWTH 20151123 PED285N1 1028030 E091137 20151123 1028030 0.25 0.25 1028030 52516 88923 2017-02-06T11:31:29.948-05:00 1 20150701
FERPA CM PROFGROWTH 20111014 PED285N1 1159169 E077683 20111014 1159169 0.25 0.25 1159169 31432 67837 2017-02-06T11:31:28.06-05:00 1 20110701
LESSONBLDR EN INSTRTECHN 20091025 PED285N1 1857250 WEB5 20091025 1857250 1857250 23276 6720 2017-02-06T11:31:27.234-05:00 1 20091030
SPANISH CM PROFGROWTH 20081103 PED285N1 1642258 E062792 20081105 1411087 3.00 3.00 1411087 16192 20081105 PED285N1 1411087 E062792 52557 2017-02-06T11:31:26.516-05:00 1 20081104
AWARENESS CM PROFGROWTH 20120801 PED285N1 0925002 E077683 20120801 0925002 1.00 1.00 925002 33709 87948 2017-02-06T11:31:28.294-05:00 1 20110701
PTLCPAPERS CM PTLC 20160503 PED285N1 1338276 E007059 20160503 1338276 1.25 1.25 1338276 54658 90775 2017-02-06T11:31:30.166-05:00 1 20160428
AC040403P CM AC 20081205 1645166 4.00 4.00 1645166 3185 20081205 PED285N1 1645166 E062792 9585 2017-02-06T11:31:25.408-05:00 1 20030404
Powered by BI Documenter