DWStaging
 dbo.BEN_DED_RATE_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.BEN_DED_RATE_A
  Properties
Property Value
Name BEN_DED_RATE_A
Schema dbo
Row Count 216
Data Size 32 KB
Index Size 24 KB
Create Date 11/2/2012 2:41 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
 
ADMIN_FEE_MAX
numeric(17, 2)
True
False
False
 
BEN_DED_RATE_CODE
varchar(8)
True
False
False
 
CALCULATION_PGM
varchar(8)
True
False
False
 
CCPA_RULE_CODE
varchar(10)
True
False
False
 
DESCRIPTION
varchar(65)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_BEN_DED_RATE_A
int(10, 0)
False
False
False
 
JURISDICTION
varchar(40)
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_PCT_DISP_INCOME
numeric(17, 2)
True
False
False
 
MIN_WAGE_AMT
numeric(17, 2)
True
False
False
 
NEAREST_DOLLAR_INCREMENT
numeric(17, 4)
True
False
False
 
NUM_WEEKS_FROM
int(10, 0)
True
False
False
 
NUM_WEEKS_TO
int(10, 0)
True
False
False
 
PAY_FREQUENCY_CODE
varchar(8)
True
False
False
 
ROUND_FACTOR_INCREMENT
numeric(17, 4)
True
False
False
 
ROUND_FACTOR_IND
bit(1, 0)
True
False
False
 
ROUNDING_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
STATE_CODE
varchar(2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_BEN_DED_RATE_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.BEN_DED_RATE_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.BEN_DED_RATE_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[BEN_DED_RATE_A] Script Date: 03/09/2017 16:45:06 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[BEN_DED_RATE_A](
    [ISN_BEN_DED_RATE_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,
    [BEN_DED_RATE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DESCRIPTION] [varchar](65) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_FREQUENCY_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NEAREST_DOLLAR_INCREMENT] [numeric](17, 4) NULL,
    [ROUND_FACTOR_IND] [bit] NULL,
    [ROUND_FACTOR_INCREMENT] [numeric](17, 4) NULL,
    [CALCULATION_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ROUNDING_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CCPA_RULE_CODE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATE_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JURISDICTION] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAX_PCT_DISP_INCOME] [numeric](17, 2) NULL,
    [NUM_WEEKS_FROM] [int] NULL,
    [NUM_WEEKS_TO] [int] NULL,
    [MIN_WAGE_AMT] [numeric](17, 2) NULL,
    [ADMIN_FEE_MAX] [numeric](17, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BEN_DED_RATE_CODE CALCULATION_PGM CCPA_RULE_CODE DESCRIPTION HOLD ISN_BEN_DED_RATE_A JURISDICTION MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NEAREST_DOLLAR_INCREMENT PAY_FREQUENCY_CODE ROUND_FACTOR_INCREMENT ROUND_FACTOR_IND ROUNDING_IND RowUpdatedOn STATE_CODE
20120814 PEB450N 1024051 E003651 DHMODUAL DHMO DEDUCTION FOR DUAL 1129033 199 20141212 PEB450N 1129033 E077593 1.0000 SEMI-MON 1.0000 false N 2017-02-06T11:30:05.458-05:00
19980526 PEB450N 1017184 CWHITE DTLSING DENTAL/DEDUCTION FOR SINGLE 809535 10 20081212 PEB450N 0809535 E001501 1.0000 SEMI-MON 1.0000 false N 2017-02-06T11:30:05.458-05:00
20110526 PEB450N 1453347 E001501 FLRET PEY340N1 FRS DEDUCTION 1453347 174 1.0000 SEMI-MON 1.0000 false N 2017-02-06T11:30:05.458-05:00
20140506 PEB450N 1148137 E029662 PPOSR DP HEALTH/DEDUCTION FOR PARTNER/SR MANAGEMENT 1523375 206 20161214 PEB450N 1523375 E023997 1.0000 SEMI-MON 1.0000 false N 2017-02-06T11:30:05.473-05:00
20111110 PEB450N 1115156 E029662 HRASBU HEALTH INS HRA BARG UNIT - COLLEGE PORTION EE+1 957000 185 20111212 PEB450N 0957000 E029662 1.0000 MONTHLY 1.0000 false N 2017-02-06T11:30:05.458-05:00
20111110 PEB450N 1248321 E001501 HRABU+FM HEALTH DEDUCTION FOR HRA BU NOT AVAIL FOR 2014 756383 197 20131212 PEB450N 0756383 E077593 1.0000 SEMI-MON 1.0000 false N 2017-02-06T11:30:05.458-05:00
20010621 PEB450N 1407414 SHILL HLTHSPOU HMO PORTION INCL.EMPL.+SPOUSE PD.COLLEGE 1319566 59 20161214 PEB450N 1319566 E023997 1.0000 MONTHLY 1.0000 false N 2017-02-06T11:30:05.458-05:00
20111110 PEB450N 1110501 E029662 HLTHFBU HEALTH INS HMO BARG UNIT - COLLEGE PORTION FAM 1319035 179 20161214 PEB450N 1319035 E023997 1.0000 MONTHLY 1.0000 false N 2017-02-06T11:30:05.458-05:00
20111110 PEB450N 1244395 E001501 HMOBU CH HEALTH DEDUCTION FOR BARG UNIT EMPLOYEE + CHILD 1322045 189 20161214 PEB450N 1322045 E023997 1.0000 SEMI-MON 1.0000 false N 2017-02-06T11:30:05.458-05:00
20100203 PEB450N 0716599 E029662 DPPODBL DENTAL COLLEGE PORTION DPPO EMPLOYEE + EMPLOYEE 1107515 160 20141212 PEB450N 1107515 E077593 1.0000 MONTHLY 1.0000 false N 2017-02-06T11:30:05.458-05:00
Powered by BI Documenter