DWStaging
 dbo.AR_ACTIVITY_ARCHIVED_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_ACTIVITY_ARCHIVED_A
  Properties
Property Value
Name AR_ACTIVITY_ARCHIVED_A
Schema dbo
Row Count 5161202
Data Size 1089600 KB
Index Size 82848 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
ACCOUNT_NBR
varchar(25)
True
False
False
 
ACTIVITY_AMT
numeric(11, 2)
True
False
False
 
ACTIVITY_DATE
varchar(8)
True
False
False
 
ACTIVITY_NBR
varchar(9)
True
False
False
 
ACTIVITY_SEQ
int(10, 0)
True
False
False
 
ACTIVITY_TYPE
varchar(2)
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
 
CONTRACT_KEY
varchar(16)
True
False
False
 
FEE_GROUP
varchar(26)
True
False
False
 
GL_STATUS
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_AR_ACTIVITY_ARCHIVED_A
int(10, 0)
False
False
False
 
JOURNAL_XREF_NBR
varchar(13)
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
 
OBLIGATION_ID
varchar(9)
True
False
False
 
OTHER_PAYEE_ID
varchar(11)
True
False
False
 
PAYMENT_SEQ
int(10, 0)
True
False
False
 
RECEIPT_KEY
varchar(24)
True
False
False
 
RECV_ADJUST_KEY
varchar(19)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
UNUSED_ALPHA
varchar(1)
True
False
False
 
UNUSED_NUMERIC
numeric(11, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_ACTIVITY_ARCHIVED_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_ACTIVITY_ARCHIVED_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AR_ACTIVITY_ARCHIVED_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_ACTIVITY_ARCHIVED_A] Script Date: 03/09/2017 16:44:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_ACTIVITY_ARCHIVED_A](
    [ISN_AR_ACTIVITY_ARCHIVED_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,
    [ACTIVITY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_NBR] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_SEQ] [int] NULL,
    [ACTIVITY_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVITY_AMT] [numeric](11, 2) NULL,
    [GL_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOURNAL_XREF_NBR] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCOUNT_NBR] [varchar](25) 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,
    [FEE_GROUP] [varchar](26) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OTHER_PAYEE_ID] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIPT_KEY] [varchar](24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_SEQ] [int] NULL,
    [OBLIGATION_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECV_ADJUST_KEY] [varchar](19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNUSED_ALPHA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UNUSED_NUMERIC] [numeric](11, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCOUNT_NBR ACTIVITY_AMT ACTIVITY_DATE ACTIVITY_NBR ACTIVITY_SEQ ACTIVITY_TYPE ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID CONTRACT_KEY FEE_GROUP GL_STATUS HOLD ISN_AR_ACTIVITY_ARCHIVED_A JOURNAL_XREF_NBR MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID OBLIGATION_ID OTHER_PAYEE_ID RECEIPT_KEY RECV_ADJUST_KEY RowUpdatedOn STUDENT_ID UNUSED_ALPHA
2510000010000694408501501 17.16 20150616 010554369 7 FE 20150616 FIC401B1 0319245 OPER2 0000000350000048 20153 MAC1140 200017SRVI 319245 11827774 201506CC00058 2015006367708001018 2017-03-02T10:52:01.399-05:00 M14757488
581251911250099010101 13.77 20150106 010182959 8 FE 20150106 IAS999P1 2241076 WEB1 20152 BUL3130 196486FINI 2241076 7524777 201501CC00017 WEB000012015010600200093 2017-03-02T10:44:20.369-05:00 C11599156
2510000010000694408501501 17.16 20150512 010491178 8 FE 20150512 FIC401B1 0324217 OPER2 0000000350000048 20153 BSC1010 199776SRVI 324217 10988772 201505CC00038 2015006368381001004 2017-03-02T10:50:32.665-05:00 N14111496
10000000 0022500 -423.25 20150216 010362445 2 AP 20150216 FIC488B1 0247417 OPER2 0000000350000047 20152 247417 9523315 201502CC00052 2015006321202001024 2017-03-02T10:47:54.075-05:00 C14161822
10000000 00408701501 3.15 20150107 010189143 6 FE 20150107 IAS999P1 1353168 WEB4 0000000350000047 20152 ENC1101L 194720TECH 1353168 7634668 201501CC00019 2015006316403001024 2017-03-02T10:44:31.258-05:00 M14788954
5812510012500990408001501 -11.52 20150109 010204167 5 FE 20150109 NATSRVD 0830057 WEB5 0000000880000055 20152 PLA1273 194989FINI 830057 7898622 201501CC00034 ITS103NR2015010900100005 2015006340973001005 2017-03-02T10:44:59.4-05:00 D14332811
2510000010000694408501501 17.16 20150213 010360158 25 FE 20150213 STR904B0 0600537 OPER2 0000000350000047 20152 MAT1033 195194SRVI 600537 9480845 201502CC00048 2015006326905001058 2017-03-02T10:47:50.643-05:00 M14184550
10000000 0010101 5.00 20150506 010475060 2 FE 20150506 NATSRVD 1723360 WEB00005 20153 9999999999999999REGI 1723360 10760147 201505CC00022 WEB000052015050600100204 2017-03-02T10:50:07.331-05:00 T14023436
10000000 0010101 230.76 20150505 010472512 10 FE 20150505 NATSRVD 1016100 E000925 20153 ARH1000 199765MATR 1016100 10728202 201505CC00015 E000925 2015050500100005 2017-03-02T10:50:03.665-05:00 N14456529
531251002250019068001 750.00 20150213 010329160 1 FA 20150213 FIC401B2 0300469 OPER2 0000000680000042 20152 300469 9384465 201502CC00045 2015006360016001 2017-03-02T10:47:40.627-05:00 M14798136
Powered by BI Documenter