|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_FINANCIAL_AID_AWARD_A_DISBURSEMENT_ACTIVITY |
| Schema | dbo |
| Row Count | 1204548 |
| Data Size | 64976 KB |
| Index Size | 20464 KB |
| Create Date | 11/7/2012 11:53 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
DISBURSEMENT_ACTIVITY_AMOUNT |
numeric(17, 2) |
True |
False |
False |
|||
|
|
DISBURSEMENT_ACTIVITY_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
DISBURSEMENT_ACTIVITY_DATE |
varchar(8) |
True |
False |
False |
|||
|
|
DISBURSEMENT_ACTIVITY_TIME |
varchar(7) |
True |
False |
False |
|||
|
|
DISBURSEMENT_ACTIVITY_TYPE |
varchar(1) |
True |
False |
False |
|||
|
|
DISBURSEMENT_OBLIGATION_ID |
varchar(9) |
True |
False |
False |
|||
|
|
DISBURSEMENT_RECV_ADJUST_KEY |
varchar(19) |
True |
False |
False |
|||
|
|
ISN_AR_FINANCIAL_AID_AWARD_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_AR_FINANCIAL_AID_AWARD_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AR_FINANCIAL_AID_AWARD_A_DISBURSEMENT_ACTIVITY depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.AR_FINANCIAL_AID_AWARD_A_DISBURSEMENT_ACTIVITY)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_FINANCIAL_AID_AWARD_A_DISBURSEMENT_ACTIVITY] Script Date: 03/09/2017 16:45:00 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_FINANCIAL_AID_AWARD_A_DISBURSEMENT_ACTIVITY]( [ISN_AR_FINANCIAL_AID_AWARD_A] [int] NOT NULL, [DISBURSEMENT_ACTIVITY_COUNT] [smallint] NOT NULL, [DISBURSEMENT_RECV_ADJUST_KEY] [varchar](19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DISBURSEMENT_OBLIGATION_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DISBURSEMENT_ACTIVITY_AMOUNT] [numeric](17, 2) NULL, [DISBURSEMENT_ACTIVITY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DISBURSEMENT_ACTIVITY_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DISBURSEMENT_ACTIVITY_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| cnxarraycolumn | DISBURSEMENT_ACTIVITY_AMOUNT | DISBURSEMENT_ACTIVITY_COUNT | DISBURSEMENT_ACTIVITY_DATE | DISBURSEMENT_ACTIVITY_TIME | DISBURSEMENT_ACTIVITY_TYPE | DISBURSEMENT_OBLIGATION_ID | DISBURSEMENT_RECV_ADJUST_KEY | ISN_AR_FINANCIAL_AID_AWARD_A | RowUpdatedOn |
| 1 | 704.00 | 3 | 20050923 | 0216217 | S | 164601 | 2017-02-06T10:25:13.327-05:00 | ||
| 0 | 910.00 | 1 | 20080918 | 0021320 | F | 2009002175551001011 | 270165 | 2017-02-06T10:25:23.669-05:00 | |
| 0 | 244.50 | 2 | 20160301 | 0656304 | B | 2016006480178001003 | 782753 | 2017-02-06T10:26:13.98-05:00 | |
| 2 | 447.74 | 3 | 20100121 | 0059406 | S | 339873 | 2017-02-06T10:25:30.986-05:00 | ||
| 2 | 301.95 | 4 | 20140124 | 0212013 | S | 641516 | 2017-02-06T10:26:00.829-05:00 | ||
| 1 | 1484.00 | 2 | 20150710 | 0013182 | S | 726617 | 2017-02-06T10:26:08.364-05:00 | ||
| 0 | 375.00 | 2 | 20120914 | 0053226 | S | 539449 | 2017-02-06T10:25:51.469-05:00 | ||
| 1 | 592.65 | 3 | 20100121 | 0031576 | B | 2010003955550001002 | 337480 | 2017-02-06T10:25:30.643-05:00 | |
| 3 | 882.57 | 4 | 20100910 | 0042415 | S | 394798 | 2017-02-06T10:25:36.82-05:00 | ||
| 0 | 550.00 | 1 | 20160205 | 0500316 | S | 743941 | 2017-02-06T10:26:09.939-05:00 |
| Powered by BI Documenter |
