|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | FactStudentTotalFeesForClass_Staging |
| Schema | dbo |
| Row Count | 3508613 |
| Data Size | 277416 KB |
| Index Size | 24 KB |
| Create Date | 1/28/2014 9:48 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ClassTotalFeesAssessed |
numeric(11, 2) |
True |
False |
False |
|||
|
|
ClassTotalFeesExempted |
numeric(11, 2) |
True |
False |
False |
|||
|
|
ClassTotalFeesNotPaid |
numeric(11, 2) |
True |
False |
False |
|||
|
|
ClassTotalFeesPaid |
numeric(11, 2) |
True |
False |
False |
|||
|
|
PaymentSourceAK |
varchar(20) |
False |
False |
False |
|||
|
|
ReferenceNumberAK |
int(10, 0) |
False |
False |
False |
|||
|
|
StudentTermAK |
varchar(15) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.FactStudentTotalFeesForClass_Staging depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.FactStudentTotalFeesForClass_Staging)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[FactStudentTotalFeesForClass_Staging] Script Date: 03/09/2017 17:21:34 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FactStudentTotalFeesForClass_Staging]( [StudentTermAK] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ReferenceNumberAK] [int] NOT NULL, [PaymentSourceAK] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ClassTotalFeesAssessed] [numeric](11, 2) NULL, [ClassTotalFeesPaid] [numeric](11, 2) NULL, [ClassTotalFeesNotPaid] [numeric](11, 2) NULL, [ClassTotalFeesExempted] [numeric](11, 2) NULL ) ON [PRIMARY] |
Sample Data
| ClassTotalFeesAssessed | ClassTotalFeesExempted | ClassTotalFeesNotPaid | ClassTotalFeesPaid | PaymentSourceAK | ReferenceNumberAK | StudentTermAK |
| 247.50 | 0.00 | 0.00 | 247.50 | 4CO 1COPAY | 123169 | C1119137620101 |
| 165.00 | 0.00 | 0.00 | 165.00 | 2ST 1STPAID | 55720 | A1133664120041 |
| 97.50 | 0.00 | 0.00 | 97.50 | 2ST 1STPAID | 118790 | C0924804820091 |
| 211.77 | 0.00 | 0.00 | 211.77 | 1FA 4STATE | 101489 | A1263588420082 |
| 160.20 | 0.00 | 0.00 | 160.20 | 1FA 1PELL | 69060 | R1160884120051 |
| 199.50 | 0.00 | 0.00 | 199.50 | 1FA 5INSTS | 96681 | M1258636820073 |
| 3.00 | 0.00 | 0.00 | 3.00 | 1FA 4STATE | 34332 | P0954246520013 |
| 72.00 | 0.00 | 0.00 | 72.00 | 1FA 3OTHF | 85345 | F0756536920053 |
| 294.75 | 0.00 | 0.00 | 294.75 | 1FA 1PELL | 167897 | N1395097720132 |
| 795.00 | 0.00 | 0.00 | 795.00 | 1FA 4STATE | 193075 | D0925444220143 |
| Powered by BI Documenter |
