DWStaging
 dbo.AR_BILL_DET_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_BILL_DET_A
  Properties
Property Value
Name AR_BILL_DET_A
Schema dbo
Row Count 451677
Data Size 82040 KB
Index Size 7144 KB
Create Date 11/5/2012 3:48 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
 
AMOUNT
numeric(17, 2)
True
False
False
 
AMOUNT_ADJUST
numeric(17, 2)
True
False
False
 
AMOUNT_BILLED
numeric(17, 2)
True
False
False
 
AMOUNT_DUE
numeric(17, 2)
True
False
False
 
AMOUNT_PAID
numeric(17, 2)
True
False
False
 
BILL_ADJUST_AMOUNT
numeric(17, 2)
True
False
False
 
BILL_AMOUNT_DUE
numeric(17, 2)
True
False
False
 
BILL_AMOUNT_PAID
numeric(17, 2)
True
False
False
 
BILL_INSTALL_NUM
int(10, 0)
True
False
False
 
BILL_KEY
varchar(13)
True
False
False
 
BILL_SEQ
int(10, 0)
True
False
False
 
CONTRACT_KEY
varchar(16)
True
False
False
 
CONTRACT_NAME
varchar(40)
True
False
False
 
CONTRACT_TYPE
varchar(2)
True
False
False
 
DATE_CREATED
varchar(8)
True
False
False
 
EXTERNAL_DOCUMENT_ID
varchar(20)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_AR_BILL_DET_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
 
RECEIVABLE_KEY
varchar(16)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
STUDENT_NAME
varchar(40)
True
False
False
 
STUDENT_REFERENCE
varchar(20)
True
False
False
 
TERM
varchar(6)
True
False
False
 
TOTAL_AMOUNT_DUE
numeric(17, 2)
True
False
False
 
TRANSFER_DATA
varchar(32)
True
False
False
 
TYPE
varchar(2)
True
False
False
 
TYPE_BILL_LINE
varchar(2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_BILL_DET_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_BILL_DET_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AR_BILL_DET_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_BILL_DET_A] Script Date: 03/09/2017 16:44:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_BILL_DET_A](
    [ISN_AR_BILL_DET_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,
    [BILL_KEY] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_SEQ] [int] NULL,
    [TYPE_BILL_LINE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_KEY] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVABLE_KEY] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OBLIGATION_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXTERNAL_DOCUMENT_ID] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DATE_CREATED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_INSTALL_NUM] [int] NULL,
    [AMOUNT] [numeric](17, 2) NULL,
    [AMOUNT_ADJUST] [numeric](17, 2) NULL,
    [AMOUNT_PAID] [numeric](17, 2) NULL,
    [AMOUNT_DUE] [numeric](17, 2) NULL,
    [STUDENT_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOTAL_AMOUNT_DUE] [numeric](17, 2) NULL,
    [STUDENT_REFERENCE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_ADJUST_AMOUNT] [numeric](17, 2) NULL,
    [AMOUNT_BILLED] [numeric](17, 2) NULL,
    [BILL_AMOUNT_PAID] [numeric](17, 2) NULL,
    [BILL_AMOUNT_DUE] [numeric](17, 2) NULL,
    [TRANSFER_DATA] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AMOUNT AMOUNT_BILLED AMOUNT_DUE BILL_AMOUNT_PAID BILL_AMOUNT_DUE BILL_KEY BILL_SEQ CONTRACT_KEY CONTRACT_NAME CONTRACT_TYPE DATE_CREATED EXTERNAL_DOCUMENT_ID HOLD ISN_AR_BILL_DET_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OBLIGATION_ID RECEIVABLE_KEY RowUpdatedOn STUDENT_ID STUDENT_NAME STUDENT_REFERENCE TERM TOTAL_AMOUNT_DUE TRANSFER_DATA TYPE TYPE_BILL_LINE
20150407 FIC610N1 0600394 OPER2 637.90 637.90 637.90 637.90 2015000361294 2 E080710450000001 600394 402021 20150407 FIC610N1 0600394 OPER2 2015006371246001 2017-02-06T10:28:34.318-05:00 E08071045 PIERCE, ELAINE 20152 637.90 FD SR
20030714 FIC610N1 1525321 E001978 140.22 140.22 2004000006408 664 0000000270000023 1525321 20707 2003000233633001 2017-02-06T10:27:47.378-05:00 593729664 VASILE, GINA RENEE 20033 140.22 ST SR
20090924 FIC610N1 1220387 E031488 103.68 103.68 103.68 103.68 2010000187100 202 0000009690000060 1558509 215282 20090930 FIC610N1 1558509 E002402 2010003505533001 2017-02-06T10:28:10.7-05:00 M10436087 EDWARDS, MATILDA E 20101 103.68 CC SR
20061106 FIC610N1 0953075 OPER2 500.00 500.00 2007000032048 161 0000001580000026 20071 FINANCIAL AID DISBURSEMENT 953075 121593 2007000685499001 2017-02-06T10:27:59.327-05:00 V11562535 NOEL, VERNITHE 20071 500.00 ST SR
20140515 FIC610N1 0826128 E031488 362.55 362.55 362.55 362.55 2014000356121 8 0000000280000337 853578 376756 20140515 FIC610N1 0853578 E031488 2014006221596001 2017-02-06T10:28:30.902-05:00 A11525482 CAMILO, ANGEL 20142 362.55 WE SR
20031104 FIC610N1 0114240 OPER2 2004000008963 1 J097775250000001 VET DEF 2002-1 FR 114240 30480 2017-02-06T10:27:48.594-05:00 CO
20060501 FIC610N1 1355540 E031488 120.00 120.00 2006000020875 393 XII0000000000098 1355540 109087 2003000202218001 2017-02-06T10:27:57.752-05:00 W07563976 GALE, WILLIAM CHARLES 20031 120.00 GC SR
20121106 FIC610N1 1011373 E002402 200.00 200.00 200.00 200.00 2013000345415 27 XII0000000000530 1021420 327748 20121106 FIC610N1 1021420 E002402 2013006052414001 2017-02-06T10:28:24.568-05:00 P13096029 READ, PAUL WILLIAM 20131 200.00 GC SR
20120926 FIC610N1 1507540 E031488 1792.75 1792.75 1792.75 1792.75 2013000344889 1012 0000005730000010 1352263 325204 20120927 FIC610N1 1352263 E031488 2013006016970001 2017-02-06T10:28:24.209-05:00 J12564720 LORA, JORDANNY EDILIO 20131 1792.75 TP SR
20050328 FIC610N1 1536369 E001978 695.50 695.50 2005000015545 1295 0000000270000036 1536369 74444 2005000360849001 2017-02-06T10:27:53.415-05:00 591385678 VOET, JUSTIN STEVEN 20052 695.50 FP SR
Powered by BI Documenter