|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | Verify_dbo_DimTimeType |
| Schema | dbo |
| Row Count | 40 |
| Data Size | 8 KB |
| Index Size | 8 KB |
| Create Date | 3/9/2017 10:45 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
AccruedTime |
varchar(3) |
False |
False |
False |
|||
|
|
EarnedTime |
varchar(3) |
False |
False |
False |
|||
|
|
LeaveTime |
varchar(3) |
False |
False |
False |
|||
|
|
LongTermTime |
varchar(3) |
False |
False |
False |
|||
|
|
OvertimeTime |
varchar(3) |
False |
False |
False |
|||
|
|
PaidTime |
varchar(3) |
False |
False |
False |
|||
|
|
RegularTime |
varchar(3) |
False |
False |
False |
|||
|
|
RowIsDuplicate |
char(1) |
False |
False |
False |
|||
|
|
RowIsSelected |
char(1) |
False |
False |
False |
|||
|
|
SickPoolTime |
varchar(3) |
False |
False |
False |
|||
|
|
TimeAttendReportingOption |
varchar(60) |
False |
False |
False |
|||
|
|
TimeAttendReportingOptionCode |
varchar(8) |
False |
False |
False |
|||
|
|
TimeType |
varchar(50) |
False |
False |
False |
|||
|
|
TimeTypeAK |
varchar(4) |
False |
False |
False |
|||
|
|
TimeTypeCode |
varchar(4) |
False |
False |
False |
|||
 |
|
VerifyTimeTypeSK |
int(10, 0) |
False |
False |
False |
(1 / 1) |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
True |
VerifyTimeTypeSK |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.Verify_dbo_DimTimeType depends on)
| Name | Type |
StoredProcedure |
Child Dependencies (objects that depend on dbo.Verify_dbo_DimTimeType)
| Name | Type |
STOREDPROCEDURE |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[Verify_dbo_DimTimeType] Script Date: 03/09/2017 17:21:48 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Verify_dbo_DimTimeType]( [VerifyTimeTypeSK] [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, [RowIsDuplicate] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [RowIsSelected] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_DimTimeType] PRIMARY KEY CLUSTERED ( [VerifyTimeTypeSK] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] |
Sample Data
| AccruedTime | EarnedTime | LeaveTime | LongTermTime | OvertimeTime | PaidTime | RegularTime | RowIsDuplicate | RowIsSelected | SickPoolTime | TimeAttendReportingOption | TimeAttendReportingOptionCode | TimeType | TimeTypeAK | TimeTypeCode | VerifyTimeTypeSK |
| No | No | Yes | No | No | Yes | No | N | Y | 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 | 30 |
| No | No | Yes | No | No | Yes | No | N | Y | No | TIME IS NOT ALLOWED TO BE REPORTED ON A TIMESHEET | NO-REPT | PROFESSIONAL LEAVE | PROF | PROF | 9 |
| No | No | Yes | No | No | Yes | No | N | Y | No | HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE | USED | MILITARY LEAVE/PAID | ML | ML | 11 |
| No | No | Yes | Yes | No | No | No | N | Y | No | TIME IS NOT ALLOWED TO BE REPORTED ON A TIMESHEET | NO-REPT | FAMILY MEDICAL LEAVE ACT CHARGE LWOP | FMLW | FMLW | 36 |
| No | No | Yes | No | No | No | No | N | Y | No | HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE | USED | LEAVE WITHOUT PAY | LWOP | LWOP | 22 |
| No | No | Yes | No | No | Yes | No | N | Y | No | HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE | USED | SUMMER HOLIDAY/PAID 1 HL, .25X | HLSM | HLSM | 19 |
| No | No | Yes | No | No | Yes | No | N | Y | No | HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE | USED | FAMILY MEDICAL LEAVE ACT CHARGE TO VACATION | FMVA | FMVA | 35 |
| No | No | No | No | No | Yes | No | N | Y | No | HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE | USED | OVERTIME PAID AS STRAIGHT TIME/< 40 HRS | OTST | OTST | 17 |
| No | No | No | No | Yes | Yes | No | N | Y | No | HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE | USED | STRAIGHT TIME OVERTIME (LESS THAN 40 HOURS) | STOT | STOT | 29 |
| No | No | Yes | No | No | Yes | No | N | Y | Yes | HOURS REPORTED TO THIS TIME-TYPE WILL APPLY TO USED BALANCE | USED | SICK POOL | POOL | POOL | 24 |
| Powered by BI Documenter |
