DWStaging
 dbo.ACCT_DISTRIBUTION_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.ACCT_DISTRIBUTION_A
  Properties
Property Value
Name ACCT_DISTRIBUTION_A
Schema dbo
Row Count 11185317
Data Size 1828512 KB
Index Size 166696 KB
Create Date 3/2/2017 10:59 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCOUNT_AMOUNT
numeric(9, 2)
True
False
False
 
ACCOUNT_PERC
numeric(7, 4)
True
False
False
 
ACCOUNT_PRIMARY_IND
bit(1, 0)
True
False
False
 
ACCT_DISTRIBUTION_CODE
varchar(1)
True
False
False
 
ACCT_INTERNAL_ID
int(10, 0)
True
False
False
 
ACCT_SENT_TO_GL_DATE
varchar(8)
True
False
False
 
ACCT_SENT_TO_GL_DATE_9C
int(10, 0)
True
False
False
 
ACCT_SENT_TO_GL_IND
bit(1, 0)
True
False
False
 
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
 
BENEFIT_IND
bit(1, 0)
True
False
False
 
CHECK_NAME
varchar(78)
True
False
False
 
GL_ACCT_NO
varchar(25)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_ACCT_DISTRIBUTION_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
 
OVERTIME_IND
bit(1, 0)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
REDIST_EFFECTIVE_DATE
varchar(8)
True
False
False
 
REDIST_EFFECTIVE_DATE_9C
int(10, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ACCT_DISTRIBUTION_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ACCT_DISTRIBUTION_A depends on)
Name Type
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.ACCT_DISTRIBUTION_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ACCT_DISTRIBUTION_A] Script Date: 03/09/2017 16:44:49 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ACCT_DISTRIBUTION_A](
    [ISN_ACCT_DISTRIBUTION_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,
    [ACCT_INTERNAL_ID] [int] NULL,
    [ACCT_DISTRIBUTION_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_NAME] [varchar](78) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERSON_ID] [int] NULL,
    [GL_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_PERC] [numeric](7, 4) NULL,
    [ACCOUNT_PRIMARY_IND] [bit] NULL,
    [OVERTIME_IND] [bit] NULL,
    [BENEFIT_IND] [bit] NULL,
    [ACCOUNT_AMOUNT] [numeric](9, 2) NULL,
    [ACCT_SENT_TO_GL_IND] [bit] NULL,
    [ACCT_SENT_TO_GL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCT_SENT_TO_GL_DATE_9C] [int] NULL,
    [REDIST_EFFECTIVE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REDIST_EFFECTIVE_DATE_9C] [int] NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
  Sample Data
ACCOUNT_AMOUNT ACCOUNT_PERC ACCOUNT_PRIMARY_IND ACCT_DISTRIBUTION_CODE ACCT_INTERNAL_ID ACCT_SENT_TO_GL_DATE ACCT_SENT_TO_GL_IND ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BENEFIT_IND CHECK_NAME GL_ACCT_NO HOLD ISN_ACCT_DISTRIBUTION_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OVERTIME_IND PERSON_ID REDIST_EFFECTIVE_DATE RowUpdatedOn
10.01 100.0000 false O 46261899 false 20120626 PEY417N1 1047048 OPER2 false DALEY-FOSTER GREG J 10000000 0022201 1047048 7603700 false 57743 2017-03-02T11:11:14.745-05:00
8.33 100.0000 false O 45242568 false 20110712 PEY417N1 1456418 OPER2 true GOLDING SAMANTHA K 10000000 0022422 1456418 6905760 false 32559 2017-03-02T11:10:14.701-05:00
457.40 100.0000 true O 473283 false 19990727 PEY417N1 1551192 OPERTNS false BLACKBURN JAMES A 111104001104001056000 1551192 219274 false 1175 2017-03-02T11:00:40.804-05:00
17.14 80.0000 true O 39682770 false 20101110 PEY417N1 1134422 OPER2 false PEREZ-PIZARRO DAVID B 212401002401202059101 1134422 6419112 false 47868 2017-03-02T11:09:32.892-05:00
125.00 100.0000 false O 3721991 false 20030226 PEY417N1 1254552 OPER2 false SCALA ALAN I 10000000 0022411 1254552 1851291 false 2884 2017-03-02T11:02:58.194-05:00
5.00 100.0000 false O 5045063 false 20040526 PEY417N1 1244141 OPER2 false HOLLIS ROBERT H 10000000 0022327 1244141 2505941 false 2542 2017-03-02T11:03:55.946-05:00
70.29 100.0000 false O 9713873 false 20060927 PEY417N1 1234073 OPER2 false HINDLE KISSOONDATH 10000000 0022202 1234073 3803559 false 3971 2017-03-02T11:05:47.705-05:00
5.88 100.0000 true O 206299 false 19990329 PEY417N1 2030365 OPERTNS false MCFARLANE MCCALLA EVELYN YMS. 113101003101005059101 2030365 88859 false 319 2017-03-02T11:00:30.149-05:00
24.54 100.0000 true O 47003077 false 20130513 PEY417N1 1323590 OPER2 false LIU EVA M 147010004701039359101 1323590 8264384 false 18461 2017-03-02T11:12:11.904-05:00
158.09 100.0000 false O 5323611 false 20040916 PEY417N1 1122395 OPER2 false BAXLEY LATSY I 10000000 0022300 1122395 2648877 false 2019 2017-03-02T11:04:08.161-05:00
Powered by BI Documenter