DWStaging
 dbo.UTILITIES_A_PAYROLL_ATTENDANCE_ORG_DATA (Table)
  Properties
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
  Columns
 
 
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
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_UTILITIES_A, cnxarraycolumn
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.UTILITIES_A_PAYROLL_ATTENDANCE_ORG_DATA depends on)
Name Type
  Child Dependencies (objects that depend on dbo.UTILITIES_A_PAYROLL_ATTENDANCE_ORG_DATA)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** 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
)
  Sample Data
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