DWStaging
 dbo.EMPLOYEE_DEVELOPMENT_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_DEVELOPMENT_A
  Properties
Property Value
Name EMPLOYEE_DEVELOPMENT_A
Schema dbo
Row Count 28387
Data Size 3968 KB
Index Size 464 KB
Create Date 11/2/2012 2:56 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
 
AWARD_AMOUNT
numeric(17, 2)
True
False
False
 
AWARD_CODE
varchar(8)
True
False
False
 
AWARD_END_DATE
varchar(8)
True
False
False
 
AWARD_PAID_IND
bit(1, 0)
True
False
False
 
AWARD_START_DATE
varchar(8)
True
False
False
 
AWARD_START_DATE_9COMP
int(10, 0)
True
False
False
 
CONTACT_HOURS
int(10, 0)
True
False
False
 
COURSE_CODE
varchar(8)
True
False
False
 
COURSE_GRADE_CODE
varchar(8)
True
False
False
 
COURSE_START_DATE
varchar(8)
True
False
False
 
COURSE_START_DATE_9COMP
int(10, 0)
True
False
False
 
CREDIT_HOURS
int(10, 0)
True
False
False
 
DESCRIPTION
varchar(50)
True
False
False
 
DEVELOP_HOURS
int(10, 0)
True
False
False
 
GRADE_CODE
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_EMPLOYEE_DEVELOPMENT_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
 
NEXT_REVIEW_DATE
varchar(8)
True
False
False
 
PAID_DATE
varchar(8)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
PERSON_ID_AWARD
int(10, 0)
True
False
False
 
PERSON_ID_COURSE
int(10, 0)
True
False
False
 
POSITION_REVIEWED
varchar(8)
True
False
False
 
PROCESSED_DATE
varchar(8)
True
False
False
 
PROCESSED_DATE_9C
int(10, 0)
True
False
False
 
RECERT_HOURS
int(10, 0)
True
False
False
 
RECOMMEND_ACTION_CODE
varchar(8)
True
False
False
 
REGISTRATION_AMOUNT
numeric(17, 2)
True
False
False
 
REVIEW_CODE
varchar(8)
True
False
False
 
REVIEW_DATE
varchar(8)
True
False
False
 
REVIEW_DATE_9COMP
int(10, 0)
True
False
False
 
REVIEW_FROM_DATE
varchar(8)
True
False
False
 
REVIEW_RATING
varchar(8)
True
False
False
 
REVIEW_RECEIVED_IND
bit(1, 0)
True
False
False
 
REVIEW_TO_DATE
varchar(8)
True
False
False
 
REVIEWER_NAME
varchar(50)
True
False
False
 
REVIEWER_POSITION
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SECOND_SIX_MONTHS
varchar(1)
True
False
False
 
SEND_REVIEW_DATE
varchar(8)
True
False
False
 
VENDOR_CODE
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_EMPLOYEE_DEVELOPMENT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.EMPLOYEE_DEVELOPMENT_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.EMPLOYEE_DEVELOPMENT_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[EMPLOYEE_DEVELOPMENT_A] Script Date: 03/09/2017 16:45:13 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[EMPLOYEE_DEVELOPMENT_A](
    [ISN_EMPLOYEE_DEVELOPMENT_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,
    [PERSON_ID] [int] NULL,
    [REVIEW_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REVIEW_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REVIEW_DATE_9COMP] [int] NULL,
    [REVIEWER_NAME] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NEXT_REVIEW_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REVIEW_RECEIVED_IND] [bit] NULL,
    [RECOMMEND_ACTION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRADE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERSON_ID_AWARD] [int] NULL,
    [AWARD_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWARD_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWARD_START_DATE_9COMP] [int] NULL,
    [AWARD_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWARD_AMOUNT] [numeric](17, 2) NULL,
    [AWARD_PAID_IND] [bit] NULL,
    [DESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAID_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROCESSED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROCESSED_DATE_9C] [int] NULL,
    [PERSON_ID_COURSE] [int] NULL,
    [COURSE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COURSE_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COURSE_START_DATE_9COMP] [int] NULL,
    [VENDOR_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_HOURS] [int] NULL,
    [CREDIT_HOURS] [int] NULL,
    [RECERT_HOURS] [int] NULL,
    [DEVELOP_HOURS] [int] NULL,
    [REGISTRATION_AMOUNT] [numeric](17, 2) NULL,
    [COURSE_GRADE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REVIEW_FROM_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REVIEW_TO_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEND_REVIEW_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REVIEW_RATING] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SECOND_SIX_MONTHS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_REVIEWED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REVIEWER_POSITION] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AWARD_CODE AWARD_END_DATE AWARD_PAID_IND AWARD_START_DATE COURSE_CODE COURSE_GRADE_CODE COURSE_START_DATE DESCRIPTION GRADE_CODE HOLD ISN_EMPLOYEE_DEVELOPMENT_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NEXT_REVIEW_DATE PAID_DATE PERSON_ID POSITION_REVIEWED PROCESSED_DATE RECOMMEND_ACTION_CODE REVIEW_CODE REVIEW_DATE REVIEW_DATE_9COMP REVIEW_FROM_DATE REVIEW_RATING REVIEW_RECEIVED_IND REVIEW_TO_DATE REVIEWER_NAME REVIEWER_POSITION RowUpdatedOn SECOND_SIX_MONTHS SEND_REVIEW_DATE VENDOR_CODE
20110207 PED710N 1103310 E027036 false 1103310 15809 82830 Unknown PROBAT 20110501 79889498 false Not Assigned 2017-02-06T11:22:26.347-05:00
20120604 PED710N 1702226 E005940 false 1702259 18987 20120604 PED710N 1702259 E005940 20130630 26380 AA1528A RETAIN YEARLY 20120530 79879469 20110701 BEXMT true 20120630 SEYLER, CATHERINE 2017-02-06T11:22:26.768-05:00 N
20050419 PED710N 0920346 E026518 false 920346 6656 28294 Unknown PROBAT 20050730 79949269 false Not Assigned 2017-02-06T11:22:25.208-05:00
20160602 PED710N 1259394 E005940 false 1300057 26716 20160602 PED710N 1300057 E005940 20170509 2745 3111 RETAIN YEARLY 20160426 79839573 20150816 M. EXP. true 20160509 ALLEN, KIMBERLY 2017-02-06T11:22:27.829-05:00 N
20000216 PED710N 1521444 SSULLIVA false 1521444 1267 4494 PROBAT 20000404 79999595 false 2017-02-06T11:22:24.459-05:00
20110607 PED710N 1020113 E023242 false 1020113 17323 87506 Unknown PROBAT 20110830 79889169 false Not Assigned 2017-02-06T11:22:26.55-05:00
20091007 PED710N 1546032 E000117 false 1546032 14635 20120630 1774 4212 RETAIN YEARLY 20090429 79909570 20080701 CAR2 true 20090630 DAVID PENA AA0215 2017-02-06T11:22:26.207-05:00 N
20061102 PED710N 1628426 E005940 false 1628426 9624 20070630 2057 AA5002 RETAIN YEARLY 20061003 79938996 20050701 M. EXP. true 20060630 JOHN WASUKANIS AA0203 2017-02-06T11:22:25.645-05:00 N
20041208 PED710N 1556492 E000117 false 1558393 5904 20041208 PED710N 1558393 E000117 20050630 1605 4003A INRANGE YEARLY 20040603 79959396 20030701 CAR2 true 20040630 LONG,RONALD,A 2017-02-06T11:22:25.083-05:00 N
19990608 PED710N 1628499 CZUCCARO false 1628499 605 3469 PROBAT 19990907 80009092 false 2017-02-06T11:22:24.397-05:00
Powered by BI Documenter