DWStaging
 dbo.ADJUSTMENT_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.ADJUSTMENT_A
  Properties
Property Value
Name ADJUSTMENT_A
Schema dbo
Row Count 17841
Data Size 3544 KB
Index Size 312 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
 
ADJUST_TAXABLE_GROSS
bit(1, 0)
True
False
False
 
ADJUSTMENT_AMOUNT
numeric(17, 2)
True
False
False
 
ADJUSTMENT_AMOUNT_BALANCE
numeric(17, 2)
True
False
False
 
ADJUSTMENT_AMOUNT_LIMIT
numeric(17, 2)
True
False
False
 
ADJUSTMENT_COUNT
int(10, 0)
True
False
False
 
ADJUSTMENT_COUNT_LIMIT
int(10, 0)
True
False
False
 
ADJUSTMENT_DATE
varchar(8)
True
False
False
 
ADJUSTMENT_MAKE_UP_TO_AMOUNT_IND
bit(1, 0)
True
False
False
 
ADJUSTMENT_RECORD_CODE
varchar(16)
True
False
False
 
ADJUSTMENT_RECORD_TYPE
varchar(2)
True
False
False
 
ADJUSTMENT_SEQUENCE_NUMBER
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
 
END_DATE
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOURS_USED
numeric(17, 2)
True
False
False
 
INTERNAL_SEQ
int(10, 0)
True
False
False
 
ISN_ADJUSTMENT_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
 
PAY_CHECK_NUMBER
int(10, 0)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
POSITION_CODE
varchar(8)
True
False
False
 
PRIORITY_SEQ_NBR
int(10, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
START_DATE
varchar(8)
True
False
False
 
START_DATE_9C
int(10, 0)
True
False
False
 
TAXABLE_GROSS_ADJ_AMT
numeric(17, 2)
True
False
False
 
UNPROCESSED_IND
bit(1, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ADJUSTMENT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ADJUSTMENT_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ADJUSTMENT_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ADJUSTMENT_A] Script Date: 03/09/2017 16:44:49 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ADJUSTMENT_A](
    [ISN_ADJUSTMENT_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,
    [PERSON_ID] [int] NULL,
    [ADJUSTMENT_RECORD_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUSTMENT_RECORD_CODE] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUSTMENT_SEQUENCE_NUMBER] [int] NULL,
    [ADJUSTMENT_AMOUNT] [numeric](17, 2) NULL,
    [ADJUSTMENT_AMOUNT_BALANCE] [numeric](17, 2) NULL,
    [ADJUSTMENT_AMOUNT_LIMIT] [numeric](17, 2) NULL,
    [ADJUSTMENT_COUNT] [int] NULL,
    [ADJUSTMENT_COUNT_LIMIT] [int] NULL,
    [ADJUSTMENT_MAKE_UP_TO_AMOUNT_IND] [bit] NULL,
    [CALENDAR_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CALENDAR_PERIOD_INTERNAL_ID] [int] NULL,
    [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [START_DATE_9C] [int] NULL,
    [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIORITY_SEQ_NBR] [int] NULL,
    [DESCRIPTION] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNPROCESSED_IND] [bit] NULL,
    [POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INTERNAL_SEQ] [int] NULL,
    [ADJUSTMENT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_CHECK_NUMBER] [int] NULL,
    [ADJUST_TAXABLE_GROSS] [bit] NULL,
    [HOURS_USED] [numeric](17, 2) NULL,
    [TAXABLE_GROSS_ADJ_AMT] [numeric](17, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADJUST_TAXABLE_GROSS ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT_BALANCE ADJUSTMENT_AMOUNT_LIMIT ADJUSTMENT_COUNT ADJUSTMENT_COUNT_LIMIT ADJUSTMENT_DATE ADJUSTMENT_MAKE_UP_TO_AMOUNT_IND ADJUSTMENT_RECORD_CODE ADJUSTMENT_RECORD_TYPE ADJUSTMENT_SEQUENCE_NUMBER CALENDAR_CODE DESCRIPTION END_DATE HOLD HOURS_USED INTERNAL_SEQ ISN_ADJUSTMENT_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAY_CHECK_NUMBER PERSON_ID POSITION_CODE RowUpdatedOn START_DATE UNPROCESSED_IND
20100325 PEY400N 1453015 E005590 false 27.75 27.75 27.75 1 1 20100325 false ASSIGNOTASSIGNOT 02 1 PARTTIME OT ADJ 20100331 1453015 0.00 1 10782 20100329 PEY303B1 1653559 OPER2 892460 72656 SEC5R002 2017-02-06T11:16:16.578-05:00 20100331 false
20140514 PEY400N 1415013 E005590 false 43.35 43.35 43.35 1 1 20140514 false DENTAL DPPOCHIL 08 2 260 DAY PER CK 20140529 1415013 0.00 5 14110 20140527 PEY303B1 1254333 OPER2 1123370 77908 8251 2017-02-06T11:16:16.937-05:00 20140529 false
20120911 PEY400N 1100399 E005590 false 34.76 34.76 34.76 1 1 20120911 false ASSIGNRGASSIGNRG 02 1 PARTTIME OT ADJ 20120914 1100399 0.00 4 12598 20120912 PEY303B1 1103376 OPER2 1023720 72918 TST1R003 2017-02-06T11:16:16.781-05:00 20120914 false
20160302 PEY400N 1203277 E089739 false 1644.66 1644.66 1644.66 1 1 20160302 false ASSIGNRGASSIGNRG 02 10 168 ASSINGMENT NOT LOADING CORRECTLY PER CONTRACT 20160315 1203277 0.00 1 16117 20160303 PEY303B1 1332455 OPER2 1228073 62586 3048TMP 2017-02-06T11:16:17.171-05:00 20160315 false
20130218 PEY400N 1440556 E006065 false 63.90 63.90 63.90 1 1 20130218 false ADJUSTMNADJUSTMN 02 1 168/24 RETROACTIVE PAYMENT FOR SALARY INCR EFF 20130101 20130228 1440556 0.00 2 13071 20130226 PEY303B1 1659168 OPER2 1051326 32504 3103 2017-02-06T11:16:16.827-05:00 20130228 false
20041210 PEY400N 1448155 E005590 false 45.10 45.10 45.10 1 1 20041210 false HEALTH HMOCHILD 08 2 168/24 SEE ADJUSTMENT 20041217 1448155 0.00 1 5987 20041215 PEY303B1 1603568 OPER2 652338 15344 3229 2017-02-06T11:16:16.047-05:00 20041217 false
20060421 PEY400N 0946551 E027936 false -42.40 -42.40 -42.40 1 1 20060421 false ASSIGNRGASSIGNRG 02 7 ADJUNCT ADJ PAY PER HR MEMO 20060428 946551 0.00 6 7363 20060426 PEY303B1 1104388 OPER2 708101 28811 SPE1ADJS 2017-02-06T11:16:16.203-05:00 20060428 false
20150325 PEY400N 0811279 E090324 false 48.73 48.73 48.73 1 1 20150325 false ASSIGNRGASSIGNRG 02 1 PARTTIME 01/22/2015 2.75HRS WORKED AT 17.72HR 20150331 811279 0.00 13 14926 20150327 PEY303B1 1327325 OPER2 1170541 26783 AA1 SUB+ 2017-02-06T11:16:17.015-05:00 20150331 false
20131210 PEY400N 0926359 E005590 false 35.04 35.04 35.04 1 1 20131210 false ASSIGNOTASSIGNOT 02 107 260 DAY OT ADJ 20131213 926359 0.00 14 13734 20131211 PEY303B1 1015025 OPER2 1093871 230 AA6076 2017-02-06T11:16:16.89-05:00 20131213 false
20131018 PEY400N 0910050 E088508 false 4.29 4.29 4.29 1 1 20131018 false DENTAL DHMOCHIL 08 11 260 DAY COVER BENEFITS FEB-MAY 2013 20131031 910050 0.00 6 13679 20131028 PEY303B1 1446388 OPER2 1086342 20483 1149 2017-02-06T11:16:16.89-05:00 20131031 false
Powered by BI Documenter