|
![]() |
Property | Value |
Name | UTILITIES_A_PAYROLL_ATTENDANCE_ORG_DATA |
Schema | dbo |
Row Count | 1064 |
Data Size | 24 KB |
Index Size | 48 KB |
Create Date | 11/5/2012 9:58 AM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
ISN_UTILITIES_A |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
ORG_ID_ATTENDANCE |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
ORG_LEVEL_ATTENDANCE |
varchar(28) |
True |
False |
False |
|||
![]() |
![]() |
PAYROLL_ATTENDANCE_ORG_DATA_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_UTILITIES_A, cnxarraycolumn |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[UTILITIES_A_PAYROLL_ATTENDANCE_ORG_DATA] Script Date: 03/09/2017 16:46:36 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[UTILITIES_A_PAYROLL_ATTENDANCE_ORG_DATA]( [ISN_UTILITIES_A] [int] NOT NULL, [PAYROLL_ATTENDANCE_ORG_DATA_COUNT] [smallint] NOT NULL, [ORG_ID_ATTENDANCE] [int] NULL, [ORG_LEVEL_ATTENDANCE] [varchar](28) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
cnxarraycolumn | ISN_UTILITIES_A | ORG_LEVEL_ATTENDANCE | PAYROLL_ATTENDANCE_ORG_DATA_COUNT | RowUpdatedOn |
5 | 168 | FACM | 9 | 2017-02-06T11:30:15.801-05:00 |
6 | 71 | TRIO | 11 | 2017-02-06T11:30:15.77-05:00 |
2 | 92 | COM2 | 9 | 2017-02-06T11:30:15.77-05:00 |
2 | 115 | DOLL | 7 | 2017-02-06T11:30:15.801-05:00 |
1 | 171 | LIB1 | 2 | 2017-02-06T11:30:15.801-05:00 |
1 | 133 | CEH1 | 6 | 2017-02-06T11:30:15.801-05:00 |
3 | 89 | PE5 | 6 | 2017-02-06T11:30:15.77-05:00 |
0 | 162 | DAA1 | 5 | 2017-02-06T11:30:15.801-05:00 |
12 | 61 | FIR1 | 17 | 2017-02-06T11:30:15.77-05:00 |
0 | 167 | AV5 | 2 | 2017-02-06T11:30:15.801-05:00 |
Powered by BI Documenter |