DWStaging
 dbo.AR_OBLIGATION_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_OBLIGATION_A
  Properties
Property Value
Name AR_OBLIGATION_A
Schema dbo
Row Count 542040
Data Size 93120 KB
Index Size 8120 KB
Create Date 2/17/2014 2:21 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCOUNT_NUMBER
varchar(25)
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
 
AMOUNT
numeric(11, 2)
True
False
False
 
AMOUNT_CASHIER
numeric(11, 2)
True
False
False
 
AMOUNT_DUE
numeric(11, 2)
True
False
False
 
AMOUNT_PAID
numeric(11, 2)
True
False
False
 
COLLECTION_FLAG
varchar(2)
True
False
False
 
COMMENT_IND
varchar(1)
True
False
False
 
CUSTOMER_ID
varchar(9)
True
False
False
 
EFFECTIVE_DATE
varchar(8)
True
False
False
 
EFFECTIVE_DATE_9COMP
varchar(8)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLD_TYPE
varchar(2)
True
False
False
 
ISN_AR_OBLIGATION_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
 
OBLIGATION_ID
varchar(9)
True
False
False
 
OBLIGATION_TYPE
varchar(2)
True
False
False
 
PAY_WITH_FINANCIAL_AID
varchar(1)
True
False
False
 
REFERENCE
varchar(30)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
STATUS
varchar(2)
True
False
False
 
STATUS_DATE
varchar(8)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_OBLIGATION_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_OBLIGATION_A depends on)
Name Type
View
  Child Dependencies (objects that depend on dbo.AR_OBLIGATION_A)
Name Type
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_OBLIGATION_A] Script Date: 03/09/2017 16:45:00 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_OBLIGATION_A](
    [ISN_AR_OBLIGATION_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,
    [OBLIGATION_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFFECTIVE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFFECTIVE_DATE_9COMP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OBLIGATION_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,
    [CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REFERENCE] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMMENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AMOUNT] [numeric](11, 2) NULL,
    [AMOUNT_CASHIER] [numeric](11, 2) NULL,
    [AMOUNT_PAID] [numeric](11, 2) NULL,
    [AMOUNT_DUE] [numeric](11, 2) NULL,
    [ACCOUNT_NUMBER] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_WITH_FINANCIAL_AID] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLLECTION_FLAG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCOUNT_NUMBER ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AMOUNT AMOUNT_DUE AMOUNT_PAID COLLECTION_FLAG COMMENT_IND CUSTOMER_ID EFFECTIVE_DATE EFFECTIVE_DATE_9COMP HOLD HOLD_TYPE ISN_AR_OBLIGATION_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OBLIGATION_ID OBLIGATION_TYPE PAY_WITH_FINANCIAL_AID REFERENCE RowUpdatedOn STATUS STATUS_DATE
10000000 0040500 20140530 FIC110N1 0143373 WEB5 40.00 40.00 K14780985 20140530 79859469 1734144 450116 20140610 FIC110N1 1734144 WEB2 001830960 AP A 1000 2017-02-06T11:08:52.1-05:00 PD 20140610
163400006340009248700 20131101 FIC110N1 0711399 E005840 141.54 141.54 D14162481 20131101 79868898 711399 FI 429769 001810582 CC A 2, FO, 006144522, 1 2017-02-06T11:08:50.228-05:00 AC 20131101
10000000 0040500 20160816 FIC110N1 0954436 WEB5 40.00 40.00 S15083348 20160816 79839183 1002597 524325 20160816 FIC110N1 1002597 E089132 001904051 AP A 1000 2017-02-06T11:08:58.745-05:00 PD 20160816
10000000 2048710 20071023 FIC110N1 1259214 E004287 10.00 10.00 V06017834 20071023 79928976 1559247 196590 20071213 FIC110N1 1559247 E037566 000532671 PN A 0FF40593 2017-02-06T11:08:28.762-05:00 PD 20071213
10000000 1048710 20110411 FIC110N1 0926422 E007370 20.00 20.00 R12958013 20110411 79889588 2024245 297631 20110711 FIC110N1 2024245 WEB2 001552570 PC A 0CT02470 2017-02-06T11:08:38.184-05:00 PD 20110711
10000000 2048710 20141125 FIC110N1 1800453 E082905 20.00 20.00 N11111572 20141125 79858874 614051 465485 20141210 FIC110N1 0614051 WEB6 001846031 PN A 0PG11614 2017-02-06T11:08:53.332-05:00 PD 20141210
10000000 0040500 20020729 FIC110N1 1421022 PSTEEN 20.00 20.00 S11552478 20020729 79979270 1349112 72553 20021004 FIC110N1 1349112 GCOOPER 000069236 AP N 2017-02-06T11:08:17.702-05:00 PD 20021004
10000000 0040500 20080711 FIC110N1 2147256 FACTS1 20.00 20.00 J12973541 20080711 79919288 1335258 217670 20080728 FIC110N1 1335258 E001650 000752433 AP A 2017-02-06T11:08:30.774-05:00 PD 20080728
10000000 0040500 20060719 FIC110N1 1133202 E015802 20.00 20.00 F12388054 20060719 79939280 914218 160804 20060815 FIC110N1 0914218 E002402 000172326 AP A 2017-02-06T11:08:25.517-05:00 PD 20060815
10000000 0040500 20080614 FIC110N1 1418511 FACTS1 20.00 20.00 B12941704 20080614 79919385 1303491 215456 20080617 FIC110N1 1303491 E002402 000727677 AP A 2017-02-06T11:08:30.556-05:00 PD 20080617
Powered by BI Documenter