EnterpriseDW
 dbo.DimTimeType (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  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:  EnterpriseDW   Tables   dbo.DimTimeType
  Properties
Property Value
Name DimTimeType
Schema dbo
Row Count 41
Data Size 8 KB
Index Size 8 KB
Create Date 3/9/2017 10:43 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
AccruedTime
varchar(3)
False
False
False
 
An indication that the time reported under the current time type will be proccessed by both the accural functions and will bein
EarnedTime
varchar(3)
False
False
False
 
An indication that the time reported under the current time type will be accumlated, to be used later.
LeaveTime
varchar(3)
False
False
False
 
An indication that any time reported under the current time type will be concidered a type of Leave and will adhere to the leave
LongTermTime
varchar(3)
False
False
False
 
An indication that any time reported under the current time type will be concidered a type of Leave and will adhere to the leave
OvertimeTime
varchar(3)
False
False
False
 
An indication that any time reported under the current time type will be concidered overtime and will adhere to the overtime rat
PaidTime
varchar(3)
False
False
False
 
An indication that any time reported under the current time type will be Paid.
RegularTime
varchar(3)
False
False
False
 
An indication that the current time type is concidered regular paid hourly time or referred to a 'normal' time.
RowEndDate
datetime(23, 3)
False
False
False
 
('12/31/9999')
When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent
nchar(1)
False
False
False
 
Is this the current row for this member (Y/N)?
RowStartDate
datetime(23, 3)
False
False
False
 
When did this row become valid for this member?
SickPoolTime
varchar(3)
False
False
False
 
An indication that any time reported under the current time type will be concidered for Sick Pool processing.
TimeAttendReportingOption
varchar(60)
False
False
False
 
Descriptive name of the time and attendance reporting options, which indicates how the current time type balance will be reporte
TimeAttendReportingOptionCode
varchar(8)
False
False
False
 
An Identifier that will indicate how the time type balance will be processed.
TimeType
varchar(50)
False
False
False
 
Descriptive name for the time type, used by the employee to report time from a timesheet or leave request.
TimeTypeAK
varchar(4)
False
False
False
 
Business key for the position, this will contain the Time Type Code.
TimeTypeCode
varchar(4)
False
False
False
 
Time Type identifier assigned by the source application. Represents type of time reported on timesheets or on leave requests.
In Primary Key
TimeTypeSK
int(10, 0)
False
False
False
(1 / 1)
Surrogate primary key
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
TimeTypeSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimTimeType depends on)
Name Type
Table
Table
  Child Dependencies (objects that depend on dbo.DimTimeType)
Name Type
TABLE
TABLE
  Extended Properties
Object Property Value
DimTimeType
Display Name
TimeType
DimTimeType
Table Description
The dimension will contain one row per Time Type and will include descriptive, status and categorization information about the t
DimTimeType
Table Type
Dimension
AccruedTime
MS_Description
An indication that the time reported under the current time type will be proccessed by both the accural functions and will bein
EarnedTime
MS_Description
An indication that the time reported under the current time type will be accumlated, to be used later.
LeaveTime
MS_Description
An indication that any time reported under the current time type will be concidered a type of Leave and will adhere to the leave
LongTermTime
MS_Description
An indication that any time reported under the current time type will be concidered a type of Leave and will adhere to the leave
OvertimeTime
MS_Description
An indication that any time reported under the current time type will be concidered overtime and will adhere to the overtime rat
PaidTime
MS_Description
An indication that any time reported under the current time type will be Paid.
RegularTime
MS_Description
An indication that the current time type is concidered regular paid hourly time or referred to a 'normal' time.
RowEndDate
MS_Description
When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent
MS_Description
Is this the current row for this member (Y/N)?
RowStartDate
MS_Description
When did this row become valid for this member?
SickPoolTime
MS_Description
An indication that any time reported under the current time type will be concidered for Sick Pool processing.
TimeAttendReportingOption
MS_Description
Descriptive name of the time and attendance reporting options, which indicates how the current time type balance will be reporte
TimeAttendReportingOptionCode
MS_Description
An Identifier that will indicate how the time type balance will be processed.
TimeType
MS_Description
Descriptive name for the time type, used by the employee to report time from a timesheet or leave request.
TimeTypeAK
MS_Description
Business key for the position, this will contain the Time Type Code.
TimeTypeCode
MS_Description
Time Type identifier assigned by the source application. Represents type of time reported on timesheets or on leave requests.
TimeTypeSK
MS_Description
Surrogate primary key
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimTimeType] Script Date: 03/09/2017 17:14:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimTimeType](
    [TimeTypeSK] [int] IDENTITY(1,1) NOT NULL,
    [TimeTypeAK] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TimeTypeCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TimeType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RegularTime] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaidTime] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OvertimeTime] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LeaveTime] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LongTermTime] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AccruedTime] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [EarnedTime] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SickPoolTime] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TimeAttendReportingOptionCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TimeAttendReportingOption] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.DimTimeType] PRIMARY KEY CLUSTERED 
(
    [TimeTypeSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[DimTimeType] ADD  DEFAULT ('12/31/9999') FOR [RowEndDate]


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'TimeType' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The dimension will contain one row per Time Type and will include descriptive, status and categorization information about the t' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType'


EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication that the time reported under the current time type will be proccessed by both the accural functions and will bein' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'AccruedTime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication that the time reported under the current time type will be accumlated, to be used later. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'EarnedTime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication that any time reported under the current time type will be concidered a type of Leave and will adhere to the leave' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'LeaveTime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication that any time reported under the current time type will be concidered a type of Leave and will adhere to the leave' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'LongTermTime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication that any time reported under the current time type will be concidered overtime and will adhere to the overtime rat' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'OvertimeTime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication that any time reported under the current time type will be Paid.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'PaidTime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication that the current time type is concidered regular paid hourly time or referred to a ''normal'' time.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'RegularTime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become invalid? (12/31/9999 if current row)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Is this the current row for this member (Y/N)?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become valid for this member?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'RowStartDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication that any time reported under the current time type will be concidered for Sick Pool processing.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'SickPoolTime'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the time and attendance reporting options, which indicates how the current time type balance will be reporte' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'TimeAttendReportingOption'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An Identifier that will indicate how the time type balance will be processed.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'TimeAttendReportingOptionCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the time type, used by the employee to report time from a timesheet or leave request.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'TimeType'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key for the position, this will contain the Time Type Code.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'TimeTypeAK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Time Type identifier assigned by the source application. Represents type of time reported on timesheets or on leave requests.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'TimeTypeCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimTimeType', @level2type=N'COLUMN',@level2name=N'TimeTypeSK'
  Sample Data
AccruedTime EarnedTime LeaveTime LongTermTime OvertimeTime PaidTime RegularTime RowEndDate RowIsCurrent RowStartDate SickPoolTime TimeAttendReportingOption TimeAttendReportingOptionCode TimeType TimeTypeAK TimeTypeCode TimeTypeSK
No No Yes No No Yes No 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:15:00-05:00 No Hours Reported To This Time-Type Will Apply To Used Balance USED 1.125 Day Normal Duty/Summer Schedule/4.5 Day Wk NR45 NR45 25
No No Yes No No No No 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:15:00-05:00 No Hours Reported To This Time-Type Will Apply To Used Balance USED Leave Without Pay LWOP LWOP 19
No No Yes No No Yes No 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:15:00-05:00 No Time Is Not Allowed To Be Reported On A Timesheet NO-REPT Paid Closed Day CL CL 4
No No Yes Yes No Yes No 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:15:00-05:00 No Hours Reported To This Time-Type Will Apply To Used Balance USED Point Banking PB PB 28
No No Yes No No Yes No 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:15:00-05:00 No Hours Reported To This Time-Type Will Apply To Used Balance USED Family Medical Leave Act Charge To Vacation FMVA FMVA 14
No No Yes No No Yes No 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:15:00-05:00 No Hours Reported To This Time-Type Will Apply To Used Balance USED 1 1/4 Day Normal Duty/Summer Schedule NM25 NM25 23
N/A N/A N/A N/A N/A N/A N/A 9999-12-31T00:00:00-05:00 Y 1899-12-31T00:00:00-05:00 N/A N/A N/A N/A N/A N/A -1
No No No No No No No 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:15:00-05:00 No Time Is Not Allowed To Be Reported On A Timesheet NO-REPT Weekend WEND WEND 40
No No Yes No No Yes No 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:15:00-05:00 No Hours Reported To This Time-Type Will Apply To Used Balance USED Summer Holiday/Paid 1 Hl, .25X HLSM HLSM 17
No No Yes Yes No No No 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:15:00-05:00 No Time Is Not Allowed To Be Reported On A Timesheet NO-REPT Family Medical Leave Act FMLA FMLA 10
Powered by BI Documenter