DWStaging
 dbo.ATTENDANCE_AND_DAY_A (Table)
Home  Diagrams  Documents  Images  DWStaging  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:  DWStaging   Tables   dbo.ATTENDANCE_AND_DAY_A
  Properties
Property Value
Name ATTENDANCE_AND_DAY_A
Schema dbo
Row Count 4334460
Data Size 709120 KB
Index Size 64640 KB
Create Date 10/25/2012 3:55 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ADD_DATE
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
ADJUSTMENT_IND
bit(1, 0)
True
False
False
 
ALL_TIME_COMPLETE_IND
bit(1, 0)
True
False
False
 
ALT_AUTHORIZING_IND
bit(1, 0)
True
False
False
 
ASSIGNMENT_INTERNAL_SEQ
int(10, 0)
True
False
False
 
ATTENDANCE_DAY_DATE
varchar(8)
True
False
False
 
ATTENDANCE_DAY_DATE_9C
int(10, 0)
True
False
False
 
ATTENDANCE_DAY_INTERNAL_ID
int(10, 0)
True
False
False
 
ATTENDANCE_END_DATE
varchar(8)
True
False
False
 
ATTENDANCE_INTERNAL_ID
int(10, 0)
True
False
False
 
ATTENDANCE_INTERNAL_ID_TD
int(10, 0)
True
False
False
 
ATTENDANCE_START_DATE
varchar(8)
True
False
False
 
ATTENDANCE_START_DATE_9C
int(10, 0)
True
False
False
 
CALENDAR_CODE
varchar(8)
True
False
False
 
CALENDAR_PERIOD_INTERNAL_ID
int(10, 0)
True
False
False
 
DESCRIPTION
varchar(50)
True
False
False
 
EXCEPTIONS_FLAG
varchar(1)
True
False
False
 
FMLA_IND
bit(1, 0)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOURS_ACCRUED
numeric(17, 2)
True
False
False
 
HOURS_USED
numeric(17, 2)
True
False
False
 
ISN_ATTENDANCE_AND_DAY_A
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
PAID_AMOUNT
numeric(17, 4)
True
False
False
 
PAID_IND
bit(1, 0)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
PERSON_ID_TD
int(10, 0)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
POSITION_CODE_TD
varchar(8)
True
False
False
 
PROCESSED_DATE
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SEARCH_NAME
varchar(5)
True
False
False
 
TIME_TYPE_CODE
varchar(4)
True
False
False
 
TOTAL_NORMAL_HOURS
numeric(17, 2)
True
False
False
 
TOTAL_OVERTIME_HOURS
numeric(17, 2)
True
False
False
 
UNAUTHORIZED_IND
bit(1, 0)
True
False
False
 
UNPROCESSED_IND
bit(1, 0)
True
False
False
 
USER_ID_ALT_AUTHORIZING
varchar(8)
True
False
False
 
USER_ID_AUTHORIZING
varchar(8)
True
False
False
 
USER_ID_REPORTING
varchar(8)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ATTENDANCE_AND_DAY_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ATTENDANCE_AND_DAY_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ATTENDANCE_AND_DAY_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ATTENDANCE_AND_DAY_A] Script Date: 03/09/2017 16:45:03 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ATTENDANCE_AND_DAY_A](
    [ISN_ATTENDANCE_AND_DAY_A] [int] NOT NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [CALENDAR_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTENDANCE_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTENDANCE_START_DATE_9C] [int] NULL,
    [ATTENDANCE_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNPROCESSED_IND] [bit] NULL,
    [PERSON_ID] [int] NULL,
    [SEARCH_NAME] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ASSIGNMENT_INTERNAL_SEQ] [int] NULL,
    [CALENDAR_PERIOD_INTERNAL_ID] [int] NULL,
    [ATTENDANCE_INTERNAL_ID] [int] NULL,
    [USER_ID_REPORTING] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_ID_AUTHORIZING] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_ID_ALT_AUTHORIZING] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNAUTHORIZED_IND] [bit] NULL,
    [ALT_AUTHORIZING_IND] [bit] NULL,
    [ALL_TIME_COMPLETE_IND] [bit] NULL,
    [EXCEPTIONS_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOTAL_NORMAL_HOURS] [numeric](17, 2) NULL,
    [TOTAL_OVERTIME_HOURS] [numeric](17, 2) NULL,
    [ATTENDANCE_INTERNAL_ID_TD] [int] NULL,
    [ATTENDANCE_DAY_INTERNAL_ID] [int] NULL,
    [PERSON_ID_TD] [int] NULL,
    [POSITION_CODE_TD] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTENDANCE_DAY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTENDANCE_DAY_DATE_9C] [int] NULL,
    [TIME_TYPE_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAID_AMOUNT] [numeric](17, 4) NULL,
    [HOURS_USED] [numeric](17, 2) NULL,
    [HOURS_ACCRUED] [numeric](17, 2) NULL,
    [PAID_IND] [bit] NULL,
    [ADJUSTMENT_IND] [bit] NULL,
    [DESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROCESSED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FMLA_IND] [bit] NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADJUSTMENT_IND ALL_TIME_COMPLETE_IND ALT_AUTHORIZING_IND ASSIGNMENT_INTERNAL_SEQ ATTENDANCE_DAY_DATE ATTENDANCE_DAY_DATE_9C ATTENDANCE_DAY_INTERNAL_ID ATTENDANCE_END_DATE ATTENDANCE_INTERNAL_ID ATTENDANCE_INTERNAL_ID_TD ATTENDANCE_START_DATE ATTENDANCE_START_DATE_9C CALENDAR_CODE CALENDAR_PERIOD_INTERNAL_ID DESCRIPTION EXCEPTIONS_FLAG FMLA_IND HOLD HOURS_USED ISN_ATTENDANCE_AND_DAY_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAID_IND PERSON_ID PERSON_ID_TD POSITION_CODE POSITION_CODE_TD PROCESSED_DATE RowUpdatedOn SEARCH_NAME TIME_TYPE_CODE TOTAL_NORMAL_HOURS UNAUTHORIZED_IND UNPROCESSED_IND USER_ID_ALT_AUTHORIZING USER_ID_AUTHORIZING USER_ID_REPORTING
20010604 PET020N 1552278 ENOBLE false false false 3 20010531 79989468 231301 20010606 143942 20010523 79989476 PARTTIME false 1552279 10.50 399789 20010612 PET010N 1829541 OPER2 false 2221 CPM1OPRF 2017-02-06T10:05:10.918-05:00 NORM false false
20021211 PET020N 0934384 SEENATHL false false false 1 20021206 79978793 451595 20021211 266755 20021206 79978793 PARTTIME false 934384 3.75 725575 20021216 PET010N 1547044 OPER2 false 15371 CEWSWKST 2017-02-06T10:05:52.43-05:00 NORM false false
20040205 PET020N 1250014 E002589 false false false 2 20040127 79959872 613510 20040205 358753 20040123 79959876 PARTTIME false 1251191 8.00 973391 20040211 PET010N 1703333 OPER2 false 16491 PHY1STAS 2017-02-06T10:06:23.973-05:00 NORM false false
20150901 PET010N 0916325 E030445 false false false 5 20150915 6367784 20150821 79849178 ADJUNCT 5617 N false 1426344 3947480 20150911 PET010N 1426344 OPER2 false 31363 PIL1ADJS 20150915 2017-02-06T10:12:26.457-05:00 TURNT false false E087528 E030445
20041208 PET020N 0936081 E000878 false false false 3 20041207 79958792 742454 20041207 430620 20041123 79958876 PARTTIME false 936081 5.50 1164778 20041210 PET010N 1420395 OPER2 false 13579 GOVRZE01 2017-02-06T10:06:48.574-05:00 NORM false false
20041122 PET020N 1416342 E001676 false false false 1 20041112 79958887 736105 20041115 426882 20041101 79958898 260 DAY false 1416342 5.50 1153493 20041124 PET010N 1318091 OPER2 false 7762 6216 2017-02-06T10:06:47.186-05:00 VA false false
20031119 PET020N 1052219 E002974 false false false 2 20031107 79968892 588588 20031118 342962 20031107 79968892 PARTTIME false 1052219 8.00 933923 20031124 PET010N 1527350 OPER2 false 16154 SA1_STAS 2017-02-06T10:06:19.355-05:00 NORM false false
20020806 PET010N 1028012 NDICKINS false false false 5 20020807 236876 20020724 79979275 PARTTIME 1710 Y false 1654089 641983 20020813 PET010N 1654089 OPER2 false 6033 DP6 STAS 20020815 2017-02-06T10:05:42.196-05:00 POTTK 75.50 false false E001273 E000882
20100302 PET020N 0910498 E005246 false false false 5 20100223 79899776 6588193 20100301 4318688 20100219 79899780 PARTTIME false 910498 7.25 2434736 20100304 PET010N 1219240 OPER2 false 62736 CPI2OPRF 2017-02-06T10:09:24.825-05:00 NORM false false
20150318 PET010N 1325558 E090324 true false false 42 20150301 6319108 20150220 79849779 PARTTIME 5252 Y false 1346368 3824338 20150327 PET010N 1346368 OPER2 false 767 CJTCADJU 20150331 2017-02-06T10:12:12.027-05:00 ORWIT 16.00 false false E089739 E090324
Powered by BI Documenter