EnterpriseDW
 dbo.FactStudentReceiptTotals (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  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:  EnterpriseDW   Tables   dbo.FactStudentReceiptTotals
  Properties
Property Value
Name FactStudentReceiptTotals
Schema dbo
Row Count 5042351
Data Size 355200 KB
Index Size 75144 KB
Create Date 1/28/2014 9:47 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Foreign Key
DateSK
int(10, 0)
False
False
False
 
Key identifier for the date the receipt was generated, used to reference the date dimension.
ReceiptFeesPaid
numeric(11, 2)
True
False
False
 
The total amount of class and registration fees paid for on a receipt.
ReceiptObligationsPaid
numeric(11, 2)
True
False
False
 
The total amount of obligations paid for on a receipt.
ReceiptReceivablesPaid
numeric(11, 2)
True
False
False
 
The total amount of receivables paid for on a receipt.
ReceiptTotal
numeric(11, 2)
True
False
False
 
The total amount of the receipt, in dollars used to pay fees, receivables and obligations. This total does not include dollars
ReceiptTotalPlusCoverage
numeric(11, 2)
True
False
False
 
The total amount of the receipt plus any dollars used from coverage contracts to pay fees, receivables and obligations.
Foreign Key
StudentReceiptSK
int(10, 0)
False
False
False
 
Key identifier for the Student Receipt, used to reference the student receipt dimension.
In Primary Key
StudentReceiptTotalsSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key to the Fact.
Foreign Key
StudentSK
int(10, 0)
False
False
False
 
Key identifier for the student, used to reference the student dimension.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
StudentReceiptTotalsSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
DateSK
DimDate
DateSK
True
StudentSK
DimStudent
StudentSK
True
StudentReceiptSK
DimStudentReceipt
StudentReceiptSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactStudentReceiptTotals depends on)
Name Type
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactStudentReceiptTotals)
Name Type
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactStudentReceiptTotals
Display Name
SRTotals
FactStudentReceiptTotals
Table Description
The fact will contain one row per student per completed receipt from the AR_RECEIPT_A table. The information will include the r
FactStudentReceiptTotals
Table Type
Fact
DateSK
Display Name
DateSK
DateSK
Example Values
1,2,3
DateSK
MS_Description
Key identifier for the date the receipt was generated, used to reference the date dimension.
DateSK
Source System
Derived
ReceiptFeesPaid
Display Name
Receipt Fees Paid
ReceiptFeesPaid
Example Values
0,50.00,1,290.50,3,225.98
ReceiptFeesPaid
MS_Description
The total amount of class and registration fees paid for on a receipt.
ReceiptFeesPaid
Source Field Name
RECEIPT_OTHER_2
ReceiptFeesPaid
Source System
DWStaging
ReceiptFeesPaid
Source Table
AR_RECEIPT_A
ReceiptObligationsPaid
Display Name
Receipt Obligations Paid
ReceiptObligationsPaid
Example Values
0,50.00,1,290.50,3,225.98
ReceiptObligationsPaid
MS_Description
The total amount of obligations paid for on a receipt.
ReceiptObligationsPaid
Source Field Name
TOTAL_OBLIG_PAID
ReceiptObligationsPaid
Source System
DWStaging
ReceiptObligationsPaid
Source Table
AR_RECEIPT_A
ReceiptReceivablesPaid
Display Name
Receipt Receivables Paid
ReceiptReceivablesPaid
Example Values
0,50.00,1,290.50,3,225.98
ReceiptReceivablesPaid
MS_Description
The total amount of receivables paid for on a receipt.
ReceiptReceivablesPaid
Source Field Name
TOTAL_RECV_PAID
ReceiptReceivablesPaid
Source System
DWStaging
ReceiptReceivablesPaid
Source Table
AR_RECEIPT_A
ReceiptTotal
Display Name
Receipt Total
ReceiptTotal
Example Values
0,50.00,1,290.50,3,225.98
ReceiptTotal
MS_Description
The total amount of the receipt, in dollars used to pay fees, receivables and obligations. This total does not include dollars
ReceiptTotal
Source Field Name
RECEIPT_AMOUNT
ReceiptTotal
Source System
DWStaging
ReceiptTotal
Source Table
AR_RECEIPT_A
ReceiptTotalPlusCoverage
Display Name
Receipt Total Plus Coverage
ReceiptTotalPlusCoverage
ETL Rules
The sum of the RECEIPT_AMOUNT and the RECEIPT_OTHER_1 amount.
ReceiptTotalPlusCoverage
Example Values
0,50.00,1,290.50,3,225.98
ReceiptTotalPlusCoverage
MS_Description
The total amount of the receipt plus any dollars used from coverage contracts to pay fees, receivables and obligations.
ReceiptTotalPlusCoverage
Source System
Derived
StudentReceiptSK
Display Name
StudentReceiptSK
StudentReceiptSK
Example Values
1,2,3
StudentReceiptSK
MS_Description
Key identifier for the Student Receipt, used to reference the student receipt dimension.
StudentReceiptSK
Source System
Derived
StudentReceiptTotalsSK
Display Folder
key
StudentReceiptTotalsSK
Display Name
StudentReceiptTotalsSK
StudentReceiptTotalsSK
ETL Rules
Identity key, assigned by SQL Server.
StudentReceiptTotalsSK
Example Values
1, 2, 3
StudentReceiptTotalsSK
MS_Description
Primary Key to the Fact.
StudentReceiptTotalsSK
Source System
Derived
StudentSK
Display Name
StudentSK
StudentSK
Example Values
1,2,3
StudentSK
MS_Description
Key identifier for the student, used to reference the student dimension.
StudentSK
Source System
Derived
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactStudentReceiptTotals] Script Date: 03/09/2017 17:14:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactStudentReceiptTotals](
    [StudentReceiptTotalsSK] [int] IDENTITY(1,1) NOT NULL,
    [StudentReceiptSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [DateSK] [int] NOT NULL,
    [ReceiptTotal] [numeric](11, 2) NULL,
    [ReceiptTotalPlusCoverage] [numeric](11, 2) NULL,
    [ReceiptFeesPaid] [numeric](11, 2) NULL,
    [ReceiptReceivablesPaid] [numeric](11, 2) NULL,
    [ReceiptObligationsPaid] [numeric](11, 2) NULL,
 CONSTRAINT [PK_dbo.FactStudentReceiptTotals] PRIMARY KEY NONCLUSTERED 
(
    [StudentReceiptTotalsSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[FactStudentReceiptTotals]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentReceiptTotals_DimDate] FOREIGN KEY([DateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactStudentReceiptTotals] CHECK CONSTRAINT [FK_FactStudentReceiptTotals_DimDate]
ALTER TABLE [dbo].[FactStudentReceiptTotals]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentReceiptTotals_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactStudentReceiptTotals] CHECK CONSTRAINT [FK_FactStudentReceiptTotals_DimStudent]
ALTER TABLE [dbo].[FactStudentReceiptTotals]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentReceiptTotals_DimStudentReceipt] FOREIGN KEY([StudentReceiptSK])
REFERENCES [DimStudentReceipt] ([StudentReceiptSK])
ALTER TABLE [dbo].[FactStudentReceiptTotals] CHECK CONSTRAINT [FK_FactStudentReceiptTotals_DimStudentReceipt]


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'SRTotals' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The fact will contain one row per student per completed receipt from the AR_RECEIPT_A table. The information will include the r' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals'


EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Fact' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'DateSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'DateSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,2,3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'DateSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the date the receipt was generated, used to reference the date dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'DateSK'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'DateSK'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Fees Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,50.00,1,290.50,3,225.98' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total amount of class and registration fees paid for on a receipt.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'RECEIPT_OTHER_2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AR_RECEIPT_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptFeesPaid'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Obligations Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptObligationsPaid'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,50.00,1,290.50,3,225.98' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptObligationsPaid'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total amount of obligations paid for on a receipt.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptObligationsPaid'


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'TOTAL_OBLIG_PAID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptObligationsPaid'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptObligationsPaid'


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AR_RECEIPT_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptObligationsPaid'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Receivables Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptReceivablesPaid'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,50.00,1,290.50,3,225.98' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptReceivablesPaid'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total amount of receivables paid for on a receipt.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptReceivablesPaid'


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'TOTAL_RECV_PAID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptReceivablesPaid'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptReceivablesPaid'


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AR_RECEIPT_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptReceivablesPaid'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Total' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotal'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,50.00,1,290.50,3,225.98' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotal'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total amount of the receipt, in dollars used to pay fees, receivables and obligations. This total does not include dollars ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotal'


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'RECEIPT_AMOUNT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotal'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotal'


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'AR_RECEIPT_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotal'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Total Plus Coverage' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotalPlusCoverage'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The sum of the RECEIPT_AMOUNT and the RECEIPT_OTHER_1 amount.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotalPlusCoverage'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,50.00,1,290.50,3,225.98' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotalPlusCoverage'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The total amount of the receipt plus any dollars used from coverage contracts to pay fees, receivables and obligations.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotalPlusCoverage'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'ReceiptTotalPlusCoverage'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentReceiptSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,2,3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Student Receipt, used to reference the student receipt dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptSK'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptSK'


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptTotalsSK'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentReceiptTotalsSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptTotalsSK'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Identity key, assigned by SQL Server. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptTotalsSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1, 2, 3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptTotalsSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key to the Fact.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptTotalsSK'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentReceiptTotalsSK'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,2,3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the student, used to reference the student dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentSK'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptTotals', @level2type=N'COLUMN',@level2name=N'StudentSK'
  Sample Data
DateSK ReceiptObligationsPaid ReceiptFeesPaid ReceiptTotal ReceiptTotalPlusCoverage StudentReceiptSK StudentReceiptTotalsSK StudentSK
20070409 971.60 971.60 971.60 6380360 1628905 23324805
20030731 715.00 715.00 3272178 932220 23621805
20121107 1214.00 1214.00 2700069 3559427 22763448
20120625 30.00 30.00 30.00 3776901 3302584 22875016
19990511 537.08 537.08 537.08 3621724 13699 23031923
20140825 40.00 40.00 40.00 6469303 4157838 23348786
20091105 802.50 802.50 2247304 2317782 23373942
20100205 505.00 255.00 505.00 4885555 2407707 22747934
20080903 714.76 714.76 4285779 1967486 23549062
20040505 440.00 440.00 1953496 1067064 23179713
Powered by BI Documenter