DWStaging
 dbo.EMPLOYEE_LONG_TERM_LEAVE_LOG_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_LONG_TERM_LEAVE_LOG_A
  Properties
Property Value
Name EMPLOYEE_LONG_TERM_LEAVE_LOG_A
Schema dbo
Row Count 73
Data Size 16 KB
Index Size 24 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
 
APPROVAL_DATE
varchar(8)
True
False
False
 
CALENDAR_CODE
varchar(8)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
INTERNAL_SEQ
int(10, 0)
True
False
False
 
ISN_EMPLOYEE_LONG_TERM_LEAVE_LOG_A
int(10, 0)
False
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
varchar(8)
True
False
False
 
LONG_TERM_LEAVE_STATUS
varchar(8)
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
 
PDB_LEAVE_TYPE
varchar(2)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
START_DATE
varchar(8)
True
False
False
 
START_DATE_9C
int(10, 0)
True
False
False
 
TIME_TYPE_CODE
varchar(4)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_EMPLOYEE_LONG_TERM_LEAVE_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.EMPLOYEE_LONG_TERM_LEAVE_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.EMPLOYEE_LONG_TERM_LEAVE_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[EMPLOYEE_LONG_TERM_LEAVE_LOG_A] Script Date: 03/09/2017 16:45:16 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[EMPLOYEE_LONG_TERM_LEAVE_LOG_A](
    [ISN_EMPLOYEE_LONG_TERM_LEAVE_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [PERSON_ID] [int] NULL,
    [TIME_TYPE_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE_9C] [int] NULL,
    [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPROVAL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LONG_TERM_LEAVE_STATUS] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PDB_LEAVE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CALENDAR_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INTERNAL_SEQ] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID APPROVAL_DATE CALENDAR_CODE END_DATE INTERNAL_SEQ ISN_EMPLOYEE_LONG_TERM_LEAVE_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER LONG_TERM_LEAVE_STATUS MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PDB_LEAVE_TYPE PERSON_ID POSITION_CODE RowUpdatedOn START_DATE START_DATE_9C TIME_TYPE_CODE
20060823 PET180N1 0805035 E001122 20060102 168/24 20061219 9 46 A 20060823 pts/15 805034 E001122 AUTHORZD 1 309 3079A 2017-02-06T11:35:27.881-05:00 20060821 79939178 SABB
20070815 PET180N1 1202069 E001122 20070221 168/24 20080508 9 61 A 20070815 pts/48 1202069 E001122 AUTHORZD 1 1023 3082 2017-02-06T11:35:27.881-05:00 20070821 79929178 SABB
20070814 PET180N1 1415570 E001122 20070221 168 20080508 12 54 A 20070814 pts/249 1415569 E001122 AUTHORZD 1 2630 3106 2017-02-06T11:35:27.881-05:00 20080103 79919896 SABB
20070814 PET180N1 1419303 E001122 20070221 168 20071219 12 57 A 20070814 pts/249 1419302 E001122 AUTHORZD 1 3686 3140 2017-02-06T11:35:27.881-05:00 20070821 79929178 SABB
20030210 PET180N1 1535109 SHILL 20030131 260 DAY 20030415 1 5 M 20030422 0416 1404194 E001122 AUTHORZD 20030422 PET180N1 1404194 E001122 4 9490 AA6033 2017-02-06T11:35:27.881-05:00 20030201 79969798 FMLA
20070815 PET180N1 1026093 E001122 20070221 168 20070831 10 71 M 20070925 pts/14 1631294 E001122 AUTHORZD 20070925 PET180N1 1631294 E001122 1 6168 3209 2017-02-06T11:35:27.881-05:00 20070821 79929178 SABB
20050901 PET180N1 1107336 E001122 20050819 168 20051220 7 42 A 20050901 0018 1107336 E001122 AUTHORZD 3 1276 3204 2017-02-06T11:35:27.881-05:00 20050901 79949098 FMLA
20070814 PET180N1 1415570 E001122 20070221 168 20080508 12 63 P 20070925 pts/14 1554011 E001122 AUTHORZD 1 2630 3106 2017-02-06T11:35:27.881-05:00 20080103 79919896 SABB
20040812 PET180N1 1007298 E001122 20040218 168 20041217 9 25 M 20040812 0024 1007560 E001122 AUTHORZD 20040812 PET180N1 1007560 E001122 1 361 3138 2017-02-06T11:35:27.881-05:00 20040818 79959181 SABB
20040812 PET180N1 0948155 E001122 20040218 168 20050509 4 22 M 20040812 0024 948378 E001122 AUTHORZD 20040812 PET180N1 0948378 E001122 1 1351 3088E 2017-02-06T11:35:27.881-05:00 20040818 79959181 SABB
Powered by BI Documenter