DWStaging
 dbo.TIME_TYPE_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.TIME_TYPE_A
  Properties
Property Value
Name TIME_TYPE_A
Schema dbo
Row Count 40
Data Size 8 KB
Index Size 24 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
ACCR_PERC_RATE
numeric(17, 2)
True
False
False
 
ACCRUAL_FREQUENCY
varchar(8)
True
False
False
 
ACCRUAL_IND
bit(1, 0)
True
False
False
 
ACCRUAL_NUMBER_DAYS
int(10, 0)
True
False
False
 
ACCRUAL_UNIT_OF_MEASURE
varchar(8)
True
False
False
 
ACCUMULATED_IND
bit(1, 0)
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
 
ALLOWED_NEGATIVE_BALANCE_IND
bit(1, 0)
True
False
False
 
ALTERNATE_LEAVE_CODE
varchar(4)
True
False
False
 
CARRY_CLEAR_IND
bit(1, 0)
True
False
False
 
CONSIDER_TIME_TYPE_ACCRUAL
bit(1, 0)
True
False
False
 
DESCRIPTION
varchar(50)
True
False
False
 
FMLA_DESIGNATOR
varchar(4)
True
False
False
 
FMLA_IND
bit(1, 0)
True
False
False
 
FROM_LEAVE_TIME_TYPE
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_TIME_TYPE_A
int(10, 0)
False
False
False
 
LEAVE_BALANCE_IND
bit(1, 0)
True
False
False
 
LEAVE_TYPE_IND
bit(1, 0)
True
False
False
 
LONG_TERM_LEAVE_IND
bit(1, 0)
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_CARRY_AMT
numeric(17, 2)
True
False
False
 
MAX_CARRY_DAYS
numeric(17, 2)
True
False
False
 
MAX_LIFETIME_BALANCE
numeric(17, 2)
True
False
False
 
MAX_LIFETIME_DAYS
numeric(17, 2)
True
False
False
 
NON_ACCRUED_MAXIMUM
numeric(17, 2)
True
False
False
 
NON_ACCRUED_MAXIMUM_DAYS
numeric(17, 2)
True
False
False
 
OVERTIME_IND
bit(1, 0)
True
False
False
 
PAID_TIME_IND
bit(1, 0)
True
False
False
 
REDUCE_OTHER_TIME_TYPE_BAL
varchar(4)
True
False
False
 
ROLLOVER_YEAR_IND
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SICK_POOL_IND
bit(1, 0)
True
False
False
 
TAA_ENTRY_OPTION_CODE
varchar(8)
True
False
False
 
TARGET_TIME_TYPE_CODE
varchar(4)
True
False
False
 
TIME_TYPE_CODE
varchar(4)
True
False
False
 
TIME_TYPE_VALUE_RATE
numeric(17, 2)
True
False
False
 
TRANSFER_RATE
numeric(17, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_TIME_TYPE_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.TIME_TYPE_A depends on)
Name Type
StoredProcedure
  Child Dependencies (objects that depend on dbo.TIME_TYPE_A)
Name Type
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[TIME_TYPE_A] Script Date: 03/09/2017 16:46:33 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[TIME_TYPE_A](
    [ISN_TIME_TYPE_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,
    [TIME_TYPE_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCRUAL_IND] [bit] NULL,
    [ALTERNATE_LEAVE_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCRUAL_FREQUENCY] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCR_PERC_RATE] [numeric](17, 2) NULL,
    [ACCUMULATED_IND] [bit] NULL,
    [ALLOWED_NEGATIVE_BALANCE_IND] [bit] NULL,
    [CARRY_CLEAR_IND] [bit] NULL,
    [FROM_LEAVE_TIME_TYPE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LONG_TERM_LEAVE_IND] [bit] NULL,
    [MAX_CARRY_AMT] [numeric](17, 2) NULL,
    [MAX_LIFETIME_BALANCE] [numeric](17, 2) NULL,
    [ROLLOVER_YEAR_IND] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NON_ACCRUED_MAXIMUM] [numeric](17, 2) NULL,
    [PAID_TIME_IND] [bit] NULL,
    [TIME_TYPE_VALUE_RATE] [numeric](17, 2) NULL,
    [TRANSFER_RATE] [numeric](17, 2) NULL,
    [OVERTIME_IND] [bit] NULL,
    [TARGET_TIME_TYPE_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LEAVE_BALANCE_IND] [bit] NULL,
    [LEAVE_TYPE_IND] [bit] NULL,
    [REDUCE_OTHER_TIME_TYPE_BAL] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCRUAL_UNIT_OF_MEASURE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONSIDER_TIME_TYPE_ACCRUAL] [bit] NULL,
    [ACCRUAL_NUMBER_DAYS] [int] NULL,
    [SICK_POOL_IND] [bit] NULL,
    [MAX_CARRY_DAYS] [numeric](17, 2) NULL,
    [MAX_LIFETIME_DAYS] [numeric](17, 2) NULL,
    [NON_ACCRUED_MAXIMUM_DAYS] [numeric](17, 2) NULL,
    [TAA_ENTRY_OPTION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FMLA_IND] [bit] NULL,
    [FMLA_DESIGNATOR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCRUAL_FREQUENCY ACCRUAL_IND ACCRUAL_NUMBER_DAYS ACCRUAL_UNIT_OF_MEASURE ACCUMULATED_IND ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ALLOWED_NEGATIVE_BALANCE_IND ALTERNATE_LEAVE_CODE CARRY_CLEAR_IND CONSIDER_TIME_TYPE_ACCRUAL DESCRIPTION FMLA_DESIGNATOR FMLA_IND FROM_LEAVE_TIME_TYPE HOLD ISN_TIME_TYPE_A LEAVE_BALANCE_IND LEAVE_TYPE_IND LONG_TERM_LEAVE_IND MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAX_CARRY_DAYS MAX_LIFETIME_BALANCE MAX_LIFETIME_DAYS NON_ACCRUED_MAXIMUM_DAYS OVERTIME_IND PAID_TIME_IND REDUCE_OTHER_TIME_TYPE_BAL ROLLOVER_YEAR_IND RowUpdatedOn SICK_POOL_IND TAA_ENTRY_OPTION_CODE TARGET_TIME_TYPE_CODE TIME_TYPE_CODE TIME_TYPE_VALUE_RATE
MONTHLY false 0 false 19980325 PEJ380N1 1052573 CWHITE false true true PAID HOLIDAY false 1526304 4 false true false 20131209 PEJ380N1 1526304 E077593 0.00 0.00 0.00 8.00 false true FISCAL 2017-02-06T11:31:20.541-05:00 false NO-REPT HL 1.00
MONTHLY false 0 false 19980325 PEJ380N1 1059296 CWHITE false true true DUTY SICK/INJURED ON JOB/PAID 1ST 5 DAYS false 1525238 7 true true false 20131209 PEJ380N1 1525238 E077593 0.00 0.00 0.00 5.00 false true CALENDAR 2017-02-06T11:31:20.541-05:00 false USED DS 1.00
MONTHLY false 0 false 19980325 PEJ380N1 1445565 CWHITE false false true SUMMER HOLIDAY/PAID 1 HL, .25X false 933063 19 false true false 20010501 PEJ380N1 0933063 SBURGRD 0.00 0.00 0.00 0.00 false true FISCAL 2017-02-06T11:31:20.541-05:00 false USED HLSM 1.25
MONTHLY false 0 false 19990525 PEJ380N1 1309218 CWHITE false false true 1.125 DAY NORMAL DUTY/SUMMER SCHEDULE/4.5 DAY WK false 1443591 30 true true false 19990525 PEJ380N1 1443591 CWHITE 0.00 0.00 0.00 0.00 false true FISCAL 2017-02-06T11:31:20.541-05:00 false USED NR45 1.12
MONTHLY false 0 true 19980325 PEJ380N1 1231386 CWHITE false false false COMP TIME EARNED false 1552243 15 false true false 20090915 PEJ380N1 1552243 E001501 0.00 0.00 0.00 0.00 false false FISCAL 2017-02-06T11:31:20.541-05:00 false ACCRUED CTE 1.00
MONTHLY false 0 false 19980325 PEJ380N1 1102108 CWHITE false true true PROFESSIONAL LEAVE false 1002214 9 false true false 20140522 PEJ380N1 1002214 E077593 0.00 0.00 0.00 0.00 false true FISCAL 2017-02-06T11:31:20.541-05:00 false NO-REPT PROF 1.00
MONTHLY false 0 false 19980325 PEJ380N1 1102477 CWHITE true true true JURY DUTY/COURT LEAVE/PAID false 1556054 10 false true false 19990608 PEJ380N1 1556054 CWHITE 0.00 0.00 0.00 0.00 false true FISCAL 2017-02-06T11:31:20.541-05:00 false USED JURY 1.00
MONTHLY false 0 false 19980526 PEJ380N1 1521435 CWHITE false false true SUMMER NON DUTY 1 DAY/.25 NORM DUTY false 1521435 25 false false false 0.00 0.00 0.00 0.00 false false 2017-02-06T11:31:20.541-05:00 false USED SMND 1.25
MONTHLY false 0 false 20030512 PEJ380N1 1556141 E001501 false true true FAMILY MEDICAL LEAVE ACT CHARGE TO SICK false 916518 34 true true false 20160809 PEJ380N1 0916518 E077593 0.00 0.00 0.00 60.00 false true SK CALENDAR 2017-02-06T11:31:20.541-05:00 false USED FMSK 1.00
MONTHLY false 0 false 20010621 PEJ380N1 0844343 HMILES true SK false true FROZEN SICK LEAVE false 846396 32 true true false 20060601 PEJ380N1 0846396 E001501 0.00 0.00 0.00 0.00 false true FISCAL 2017-02-06T11:31:20.541-05:00 false USED FRSK 1.00
Powered by BI Documenter