DWStaging
 dbo.AR_CUSTOMER_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.AR_CUSTOMER_A
  Properties
Property Value
Name AR_CUSTOMER_A
Schema dbo
Row Count 506408
Data Size 69856 KB
Index Size 7944 KB
Create Date 11/7/2012 8:27 AM
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
 
BANK_CODE
varchar(9)
True
False
False
 
BANKING_INSTITUTION_ACCT_NBR
varchar(20)
True
False
False
 
BILL_TYPE_CODE
varchar(2)
True
False
False
 
COLLEGE_AUTHORIZATION
varchar(2)
True
False
False
 
COMMENT_IND
varchar(1)
True
False
False
 
CUSTOMER_ID
varchar(9)
True
False
False
 
CUSTOMER_NAME
varchar(40)
True
False
False
 
CUSTOMER_TYPE
varchar(2)
True
False
False
 
EFT_BANK_ACCT_TYPE
varchar(1)
True
False
False
 
EFT_TESTED_SUCCESSFULLY_IND
varchar(1)
True
False
False
 
EMAIL_ADDR
varchar(40)
True
False
False
 
FA_CUSTOMER_IND
varchar(1)
True
False
False
 
FOUNDATION_CUSTOMER_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLD_DUNNING_LETTERS
varchar(1)
True
False
False
 
ISN_AR_CUSTOMER_A
int(10, 0)
False
False
False
 
LOCK_DATE
varchar(8)
True
False
False
 
LOCK_IND
varchar(1)
True
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
 
ONE_BILL_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STATUS
varchar(2)
True
False
False
 
STATUS_DATE
varchar(8)
True
False
False
 
T1098_EXCLUDE_IND
varchar(1)
True
False
False
 
USE_EFT_FOR_PAYMENTS_IND
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_CUSTOMER_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_CUSTOMER_A depends on)
Name Type
View
View
View
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.AR_CUSTOMER_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
STOREDPROCEDURE
VIEW
VIEW
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_CUSTOMER_A] Script Date: 03/09/2017 16:44:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_CUSTOMER_A](
    [ISN_AR_CUSTOMER_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,
    [CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLLEGE_AUTHORIZATION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMMENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ONE_BILL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_TYPE_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD_DUNNING_LETTERS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOCK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOCK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANK_CODE] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANKING_INSTITUTION_ACCT_NBR] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USE_EFT_FOR_PAYMENTS_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_TESTED_SUCCESSFULLY_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_BANK_ACCT_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_CUSTOMER_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOUNDATION_CUSTOMER_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [T1098_EXCLUDE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EMAIL_ADDR] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID BANK_CODE BANKING_INSTITUTION_ACCT_NBR BILL_TYPE_CODE COLLEGE_AUTHORIZATION COMMENT_IND CUSTOMER_ID CUSTOMER_NAME CUSTOMER_TYPE EFT_BANK_ACCT_TYPE EFT_TESTED_SUCCESSFULLY_IND EMAIL_ADDR FA_CUSTOMER_IND FOUNDATION_CUSTOMER_IND HOLD HOLD_DUNNING_LETTERS ISN_AR_CUSTOMER_A LOCK_DATE LOCK_IND MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID ONE_BILL_IND RowUpdatedOn STATUS STATUS_DATE T1098_EXCLUDE_IND USE_EFT_FOR_PAYMENTS_IND
20041123 FIC200N1 1015076 WEB2 NA NA S08007700 OGILVIE, STUART W ST 1427506 182410 20070918 FIC200N1 1427506 E027940 N 2017-02-06T10:34:27.224-05:00 AC 20041123
20161216 FIC200N1 1337382 WEB5 NA NA P15491475 NASH, PAULINE ST 1337382 505022 N 2017-02-06T10:34:55.975-05:00 AC 20161216
20110524 FIC200N1 1150167 FACTS1 NA NA B13875273 JONES, BRADLEY TYLER ST 1150167 359965 N 2017-02-06T10:34:43.089-05:00 AC 20110524
20070508 FIC200N1 1624096 E004483 NA NA B12595351 PEREL, BLAIRE ST 1518139 372253 20111012 FIC200N1 1518139 WEB3 N 2017-02-06T10:34:44.181-05:00 AC 20070508
20010103 FIC200N1 1617338 SLAMIE NA NA D07532559 HEDMAN, DONNA KAY ST 1625450 67603 20010103 FIC202N1 1625450 LLOCKETT N 2017-02-06T10:34:16.881-05:00 AC 20010103
20030905 FIC200N1 1610320 FACTS1 NA NA S11837895 SOLTANI, SHANNA MIRIAM ST 939007 144904 20070409 FIC200N1 0939007 E037629 N 2017-02-06T10:34:23.776-05:00 AC 20030905
20000103 FIC200N1 1704148 BLEVY NA NA C11126166 MOORE, CHRISTINE ELIZABETH ST 1017481 38504 20090727 FIC202N1 1017481 E037629 N 2017-02-06T10:34:14.26-05:00 AC 20000105
20030723 FIC200N1 0905110 E006160 NA NA C11752102 HORNE, CHRISTOPHER CORTEZ ST 1141084 138570 20120919 FIC202N1 1141084 E002402 N 2017-02-06T10:34:23.214-05:00 AC 20030723
20120103 FIC200N1 1327144 WEB5 NA NA C14041271 DISBURY, CODY ST 1327144 376917 N 2017-02-06T10:34:44.587-05:00 AC 20120103
20160128 FIC200N1 0852159 WEB5 NA NA C15228513 SWEATT, COY AUSTIN ST 852159 481258 N 2017-02-06T10:34:53.837-05:00 AC 20160128
Powered by BI Documenter