EnterpriseDW
 dbo.FactStudentReceiptPayments (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.FactStudentReceiptPayments
  Properties
Property Value
Name FactStudentReceiptPayments
Schema dbo
Row Count 5531636
Data Size 209264 KB
Index Size 82424 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.
ReceiptPaymentAmount
numeric(11, 2)
False
False
False
 
The total amount of the receipt, in dollars used to pay fees, receivables and obligations. This total does not include dollars
Foreign Key
ReceiptPaymentCategorySK
int(10, 0)
False
False
False
 
Key identifier for the type of payment used to pay for items on a receipt. Used to reference the DimPaymentCategory dimension.
In Primary Key
StudentReceiptPaymentsSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key to the Fact.
Foreign Key
StudentReceiptSK
int(10, 0)
False
False
False
 
Key identifier for the Student Receipt, used to reference the student receipt dimension.
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
StudentReceiptPaymentsSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
DateSK
DimDate
DateSK
True
ReceiptPaymentCategorySK
DimReceiptPaymentCategory
ReceiptPaymentCategorySK
True
StudentSK
DimStudent
StudentSK
True
StudentReceiptSK
DimStudentReceipt
StudentReceiptSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactStudentReceiptPayments depends on)
Name Type
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactStudentReceiptPayments)
Name Type
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactStudentReceiptPayments
Display Name
SRPayments
FactStudentReceiptPayments
Table Description
The fact will contain one row per student per completed receipt per payment source from the AR_RECEIPT_A and AR_RECEIPT_PAYMENT_
FactStudentReceiptPayments
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
ReceiptPaymentAmount
Display Name
Receipt Payment Amount
ReceiptPaymentAmount
ETL Rules
Use the PAYMENT_AMOUNT from the AR_RECEIPT_PAYMENT_A or the RECEIPT_OTHER_1 from the AR_RECEIPT_A.
ReceiptPaymentAmount
Example Values
0,50.00,1,290.50,3,225.98
ReceiptPaymentAmount
MS_Description
The total amount of the receipt, in dollars used to pay fees, receivables and obligations. This total does not include dollars
ReceiptPaymentAmount
Source Field Name
ReceiptPaymentAmount
Source System
Derived
ReceiptPaymentAmount
Source Table
ReceiptPaymentCategorySK
Display Name
ReceiptPaymentCategorySK
ReceiptPaymentCategorySK
ETL Rules
Use the PAYMENT_TYPE from the AR_RECEIPT_PAYMENT_A table it should equal the ReceiptPaymentMethodCode on the DimReceiptPaymentCa
ReceiptPaymentCategorySK
Example Values
1,2,3
ReceiptPaymentCategorySK
MS_Description
Key identifier for the type of payment used to pay for items on a receipt. Used to reference the DimPaymentCategory dimension.
ReceiptPaymentCategorySK
Source System
Derived
StudentReceiptPaymentsSK
Display Folder
key
StudentReceiptPaymentsSK
Display Name
StudentReceiptPaymentsSK
StudentReceiptPaymentsSK
ETL Rules
Identity key, assigned by SQL Server.
StudentReceiptPaymentsSK
Example Values
1, 2, 3
StudentReceiptPaymentsSK
MS_Description
Primary Key to the Fact.
StudentReceiptPaymentsSK
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
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].[FactStudentReceiptPayments] Script Date: 03/09/2017 17:14:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactStudentReceiptPayments](
    [StudentReceiptPaymentsSK] [int] IDENTITY(1,1) NOT NULL,
    [StudentReceiptSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [DateSK] [int] NOT NULL,
    [ReceiptPaymentCategorySK] [int] NOT NULL,
    [ReceiptPaymentAmount] [numeric](11, 2) NOT NULL,
 CONSTRAINT [PK_dbo.FactStudentReceiptPayments] PRIMARY KEY NONCLUSTERED 
(
    [StudentReceiptPaymentsSK] 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].[FactStudentReceiptPayments]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentReceiptPayments_DimDate] FOREIGN KEY([DateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactStudentReceiptPayments] CHECK CONSTRAINT [FK_FactStudentReceiptPayments_DimDate]
ALTER TABLE [dbo].[FactStudentReceiptPayments]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentReceiptPayments_DimReceiptPaymentCategory] FOREIGN KEY([ReceiptPaymentCategorySK])
REFERENCES [DimReceiptPaymentCategory] ([ReceiptPaymentCategorySK])
ALTER TABLE [dbo].[FactStudentReceiptPayments] CHECK CONSTRAINT [FK_FactStudentReceiptPayments_DimReceiptPaymentCategory]
ALTER TABLE [dbo].[FactStudentReceiptPayments]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentReceiptPayments_DimStudent] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactStudentReceiptPayments] CHECK CONSTRAINT [FK_FactStudentReceiptPayments_DimStudent]
ALTER TABLE [dbo].[FactStudentReceiptPayments]  WITH CHECK ADD  CONSTRAINT [FK_FactStudentReceiptPayments_DimStudentReceipt] FOREIGN KEY([StudentReceiptSK])
REFERENCES [DimStudentReceipt] ([StudentReceiptSK])
ALTER TABLE [dbo].[FactStudentReceiptPayments] CHECK CONSTRAINT [FK_FactStudentReceiptPayments_DimStudentReceipt]


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


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The fact will contain one row per student per completed receipt per payment source from the AR_RECEIPT_A and AR_RECEIPT_PAYMENT_' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptPayments'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'DateSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptPayments', @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'FactStudentReceiptPayments', @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'FactStudentReceiptPayments', @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'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'DateSK'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Payment Amount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentAmount'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Use the PAYMENT_AMOUNT from the AR_RECEIPT_PAYMENT_A or the RECEIPT_OTHER_1 from the AR_RECEIPT_A.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentAmount'


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'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentAmount'


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'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentAmount'


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Use the PAYMENT_TYPE from the AR_RECEIPT_PAYMENT_A table it should equal the ReceiptPaymentMethodCode on the DimReceiptPaymentCa' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategorySK'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the type of payment used to pay for items on a receipt. Used to reference the DimPaymentCategory dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategorySK'


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


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


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


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'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'StudentReceiptPaymentsSK'


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


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'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'StudentReceiptPaymentsSK'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentReceiptSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptPayments', @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'FactStudentReceiptPayments', @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'FactStudentReceiptPayments', @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'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'StudentReceiptSK'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactStudentReceiptPayments', @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'FactStudentReceiptPayments', @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'FactStudentReceiptPayments', @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'FactStudentReceiptPayments', @level2type=N'COLUMN',@level2name=N'StudentSK'
  Sample Data
DateSK ReceiptPaymentAmount ReceiptPaymentCategorySK StudentReceiptPaymentsSK StudentReceiptSK StudentSK
20000905 500.00 14 5341143 4639262 22708726
20090721 1005.00 10 617082 6209697 22982796
20091109 1025.00 14 2582418 3489929 22931470
20140911 294.75 10 2965395 4537887 23256503
20110107 277.30 3 3186513 6234257 23203219
20121105 451.50 3 2244250 5910567 23045059
19990910 138.42 3 311441 3629873 23117110
20100726 40.00 2 5131615 4116367 23530420
20060609 10.00 10 673946 4039302 22897038
20050103 265.00 2 1762878 4027000 23450224
Powered by BI Documenter