|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | IT_R2T4_A_FUNDS |
| Schema | dbo |
| Row Count | 32782 |
| Data Size | 1456 KB |
| Index Size | 592 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 |
|||
|
|
DISB_DATE |
varchar(8) |
True |
False |
False |
|||
|
|
FA_ACCEPTED |
decimal(7, 2) |
True |
False |
False |
|||
|
|
FA_DISBURSED |
decimal(7, 2) |
True |
False |
False |
|||
|
|
FA_OFFERED |
decimal(7, 2) |
True |
False |
False |
|||
|
|
FUND_ID |
varchar(9) |
True |
False |
False |
|||
|
|
FUND_TYPE |
varchar(1) |
True |
False |
False |
|||
|
|
FUNDS_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_IT_R2T4_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_IT_R2T4_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.IT_R2T4_A_FUNDS depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.IT_R2T4_A_FUNDS)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[IT_R2T4_A_FUNDS] Script Date: 03/09/2017 16:45:40 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[IT_R2T4_A_FUNDS]( [ISN_IT_R2T4_A] [int] NOT NULL, [FUNDS_COUNT] [smallint] NOT NULL, [FUND_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FUND_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DISB_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FA_OFFERED] [decimal](7, 2) NULL, [FA_ACCEPTED] [decimal](7, 2) NULL, [FA_DISBURSED] [decimal](7, 2) NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| cnxarraycolumn | DISB_DATE | FA_ACCEPTED | FA_DISBURSED | FA_OFFERED | FUND_ID | FUND_TYPE | FUNDS_COUNT | ISN_IT_R2T4_A | RowUpdatedOn |
| 0 | 1750.00 | FEDDLSUB | L | 2 | 13005 | 2017-02-06T11:19:31.376-05:00 | |||
| 1 | 20150923 | 2166.00 | 2166.00 | 2166.00 | FEDPELL | P | 2 | 21104 | 2017-02-06T11:19:32.25-05:00 |
| 0 | 20140123 | 1412.00 | 1412.00 | 1412.00 | FEDPELL | P | 1 | 16341 | 2017-02-06T11:19:31.766-05:00 |
| 0 | 20151015 | 1444.00 | 1444.00 | 1444.00 | FEDPELL | P | 1 | 20738 | 2017-02-06T11:19:32.203-05:00 |
| 2 | 20130918 | 2117.00 | 2117.00 | 2117.00 | FEDPELL | P | 3 | 15576 | 2017-02-06T11:19:31.688-05:00 |
| 0 | 20090122 | 818.00 | 818.00 | 818.00 | FEDPELL | P | 2 | 3881 | 2017-02-06T11:19:30.347-05:00 |
| 0 | 507.00 | 507.00 | FEDPELL | P | 1 | 1429 | 2017-02-06T11:19:30.035-05:00 | ||
| 0 | 20110125 | 2081.00 | 2081.00 | 2081.00 | FEDPELL | P | 1 | 7904 | 2017-02-06T11:19:30.815-05:00 |
| 0 | 20150923 | 2000.00 | 2000.00 | 2000.00 | FEDDLSUB | L | 2 | 21603 | 2017-02-06T11:19:32.297-05:00 |
| 0 | 20130123 | 687.00 | 687.00 | 687.00 | FEDPELL | P | 1 | 13558 | 2017-02-06T11:19:31.439-05:00 |
| Powered by BI Documenter |
