|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | ATTENDANCE_REQUEST_A_LEAVE_REQUEST_INFO |
| Schema | dbo |
| Row Count | 106990 |
| Data Size | 6592 KB |
| Index Size | 1840 KB |
| Create Date | 2/26/2016 9:04 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
END_TIME |
numeric(4, 2) |
True |
False |
False |
|||
|
|
ISN_ATTENDANCE_REQUEST_A |
int(10, 0) |
False |
False |
False |
|||
|
|
LEAVE_ADJUSTMENT_IND |
bit(1, 0) |
True |
False |
False |
|||
|
|
LEAVE_DATE |
varchar(8) |
True |
False |
False |
|||
|
|
LEAVE_HOURS |
numeric(4, 2) |
True |
False |
False |
|||
|
|
LEAVE_REQUEST_INFO_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
PERSON_ID |
int(10, 0) |
True |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
START_TIME |
numeric(4, 2) |
True |
False |
False |
|||
|
|
TIME_TYPE_CODE |
varchar(4) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_ATTENDANCE_REQUEST_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.ATTENDANCE_REQUEST_A_LEAVE_REQUEST_INFO depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.ATTENDANCE_REQUEST_A_LEAVE_REQUEST_INFO)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[ATTENDANCE_REQUEST_A_LEAVE_REQUEST_INFO] Script Date: 03/09/2017 16:45:04 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ATTENDANCE_REQUEST_A_LEAVE_REQUEST_INFO]( [ISN_ATTENDANCE_REQUEST_A] [int] NOT NULL, [LEAVE_REQUEST_INFO_COUNT] [smallint] NOT NULL, [PERSON_ID] [int] NULL, [TIME_TYPE_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LEAVE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [LEAVE_HOURS] [numeric](4, 2) NULL, [START_TIME] [numeric](4, 2) NULL, [END_TIME] [numeric](4, 2) NULL, [LEAVE_ADJUSTMENT_IND] [bit] NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] |
Sample Data
| cnxarraycolumn | END_TIME | ISN_ATTENDANCE_REQUEST_A | LEAVE_ADJUSTMENT_IND | LEAVE_DATE | LEAVE_HOURS | LEAVE_REQUEST_INFO_COUNT | PERSON_ID | RowUpdatedOn | START_TIME | TIME_TYPE_CODE |
| 0 | 17.00 | 32013 | false | 20140923 | 8.00 | 1 | 3447 | 2017-02-06T11:01:43.939-05:00 | 8.00 | SK |
| 1 | 16.00 | 51873 | false | 20160330 | 3.50 | 2 | 21248 | 2017-02-06T11:01:46.123-05:00 | 12.50 | SK |
| 0 | 11.00 | 42977 | false | 20150810 | 4.00 | 1 | 77783 | 2017-02-06T11:01:45.172-05:00 | 7.00 | SK |
| 0 | 20.00 | 45695 | false | 20151021 | 8.00 | 1 | 90594 | 2017-02-06T11:01:45.484-05:00 | 12.00 | TDE |
| 1 | 17.00 | 740 | false | 20160621 | 10.00 | 4 | 88614 | 2017-02-06T11:01:40.601-05:00 | 7.00 | SK |
| 0 | 7140 | false | 20101025 | 2.00 | 1 | 37615 | 2017-02-06T11:01:41.256-05:00 | SK | ||
| 0 | 17.00 | 46731 | false | 20151113 | 1.50 | 1 | 22111 | 2017-02-06T11:01:45.609-05:00 | 9.50 | SK |
| 2 | 15.00 | 12884 | false | 20111209 | 3.00 | 3 | 2374 | 2017-02-06T11:01:41.88-05:00 | 13.00 | VA |
| 2 | 33426 | false | 20141124 | 8.00 | 11 | 77674 | 2017-02-06T11:01:44.08-05:00 | VA | ||
| 2 | 16.50 | 41506 | false | 20170119 | 8.00 | 4 | 32211 | 2017-02-06T11:01:45-05:00 | 7.50 | VA |
| Powered by BI Documenter |
