DWStaging
 dbo.SPECIAL_PAYROLL_A (Table)
  Properties
Property Value
Name SPECIAL_PAYROLL_A
Schema dbo
Row Count 0
Data Size 0 KB
Index Size 0 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
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
 
CHECK_TYPE
varchar(2)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INTERNAL_SEQ
int(10, 0)
True
False
False
 
ISN_SPECIAL_PAYROLL_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
 
MISSED_CHECK_DATE
varchar(8)
True
False
False
 
PAY_CHECK_DATE
varchar(8)
True
False
False
 
PAYROLL_PROCESS_DATE
varchar(8)
True
False
False
 
PAYROLL_PROCESS_DATE_9C
int(10, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_SPECIAL_PAYROLL_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.SPECIAL_PAYROLL_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.SPECIAL_PAYROLL_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[SPECIAL_PAYROLL_A] Script Date: 03/09/2017 16:45:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[SPECIAL_PAYROLL_A](
    [ISN_SPECIAL_PAYROLL_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,
    [PAY_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INTERNAL_SEQ] [int] NULL,
    [MISSED_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYROLL_PROCESS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYROLL_PROCESS_DATE_9C] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
Powered by BI Documenter