|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | DimReceiptPaymentCategory |
| Schema | dbo |
| Row Count | 14 |
| Data Size | 8 KB |
| Index Size | 8 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 |
||
 |
|
ReceiptPaymentCategory |
varchar(60) |
False |
False |
False |
A descriptive name for the category of a receipt payment used by a student to make a payment via a receipt. Examples are Cash |
||
|
|
ReceiptPaymentCategoryAK |
varchar(18) |
False |
False |
False |
Business key. |
||
|
|
ReceiptPaymentCategoryCode |
varchar(15) |
False |
False |
False |
Code for the category of a receipt payment used by a student to make a payment via a receipt. Examples are Cash Payments or Ch |
||
 |
|
ReceiptPaymentCategorySK |
int(10, 0) |
False |
False |
False |
(1 / 1) |
Surrogate primary key |
|
|
|
ReceiptPaymentMethod |
varchar(60) |
False |
False |
False |
A descriptive name for the method of a receipt payment used by a student to make a payment via a receipt. Examples are Cash Pay |
||
|
|
ReceiptPaymentMethodCode |
varchar(3) |
False |
False |
False |
Code for the method of a receipt payment used by a student to make a payment via a receipt. Examples are Cash Payment, Interna |
||
|
|
RowEndDate |
datetime(23, 3) |
True |
False |
False |
When did this row become invalid? (12/31/9999 if current row) |
||
|
|
RowIsCurrent |
nchar(1) |
False |
False |
False |
Is this the current row for this member (Y/N)? |
||
|
|
RowStartDate |
datetime(23, 3) |
False |
False |
False |
When did this row become valid for this member? |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
True |
ReceiptPaymentCategorySK |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.DimReceiptPaymentCategory depends on)
| Name | Type |
Table |
Child Dependencies (objects that depend on dbo.DimReceiptPaymentCategory)
| Name | Type |
TABLE |
Extended Properties
| Object | Property | Value |
DimReceiptPaymentCategory |
Display Name |
RPaymentCategory |
DimReceiptPaymentCategory |
Table Description |
Payment category and method for receipts, represents type of dollars used to pay for items and services. |
DimReceiptPaymentCategory |
Table Type |
Dimension |
ReceiptPaymentCategory |
Display Name |
Receipt Payment Category |
ReceiptPaymentCategory |
ETL Rules |
Load via script |
ReceiptPaymentCategory |
Example Values |
Cash Payments, Check Payments, Point of Purchase Payments |
ReceiptPaymentCategory |
MS_Description |
A descriptive name for the category of a receipt payment used by a student to make a payment via a receipt. Examples are Cash |
ReceiptPaymentCategory |
SCD Type |
1 |
ReceiptPaymentCategory |
Source System |
Derived |
ReceiptPaymentCategoryAK |
Display Name |
ReceiptPaymentCategoryAK |
ReceiptPaymentCategoryAK |
ETL Rules |
Load via script |
ReceiptPaymentCategoryAK |
Example Values |
Cash CA, Check CK, Check CC |
ReceiptPaymentCategoryAK |
MS_Description |
Business key. |
ReceiptPaymentCategoryAK |
SCD Type |
key |
ReceiptPaymentCategoryAK |
Source System |
Derived |
ReceiptPaymentCategoryCode |
Display Name |
Receipt Payment Category Code |
ReceiptPaymentCategoryCode |
ETL Rules |
Load via script |
ReceiptPaymentCategoryCode |
Example Values |
Cash, Bank, Check, CreditCard, Coverage |
ReceiptPaymentCategoryCode |
MS_Description |
Code for the category of a receipt payment used by a student to make a payment via a receipt. Examples are Cash Payments or Ch |
ReceiptPaymentCategoryCode |
SCD Type |
1 |
ReceiptPaymentCategoryCode |
Source System |
Derived |
ReceiptPaymentCategorySK |
Display Name |
ReceiptPaymentCategorySK |
ReceiptPaymentCategorySK |
Example Values |
1, 2, 3? |
ReceiptPaymentCategorySK |
MS_Description |
Surrogate primary key |
ReceiptPaymentCategorySK |
SCD Type |
key |
ReceiptPaymentCategorySK |
Source System |
Derived |
ReceiptPaymentMethod |
Display Name |
Receipt Payment Method |
ReceiptPaymentMethod |
ETL Rules |
Load via script |
ReceiptPaymentMethod |
Example Values |
Cash Payment, Deposit from Receivable, Debit Card Payment |
ReceiptPaymentMethod |
MS_Description |
A descriptive name for the method of a receipt payment used by a student to make a payment via a receipt. Examples are Cash Pay |
ReceiptPaymentMethod |
SCD Type |
1 |
ReceiptPaymentMethod |
Source Field Name |
|
ReceiptPaymentMethod |
Source System |
Derived |
ReceiptPaymentMethod |
Source Table |
|
ReceiptPaymentMethodCode |
Display Name |
Receipt Payment Method Code |
ReceiptPaymentMethodCode |
ETL Rules |
Load via script |
ReceiptPaymentMethodCode |
Example Values |
CA, OC, DP, DB |
ReceiptPaymentMethodCode |
MS_Description |
Code for the method of a receipt payment used by a student to make a payment via a receipt. Examples are Cash Payment, Interna |
ReceiptPaymentMethodCode |
SCD Type |
1 |
ReceiptPaymentMethodCode |
Source System |
Derived |
RowEndDate |
Display Folder |
Exclude from cube |
RowEndDate |
Display Name |
Row End Date |
RowEndDate |
ETL Rules |
Standard SCD-2 |
RowEndDate |
Example Values |
1/14/1998, 12/31/9999 |
RowEndDate |
MS_Description |
When did this row become invalid? (12/31/9999 if current row) |
RowEndDate |
SCD Type |
n/a |
RowEndDate |
Source System |
Derived |
RowIsCurrent |
Display Folder |
Exclude from cube |
RowIsCurrent |
Display Name |
Row Is Current |
RowIsCurrent |
ETL Rules |
Standard SCD-2 |
RowIsCurrent |
Example Values |
Y, N |
RowIsCurrent |
MS_Description |
Is this the current row for this member (Y/N)? |
RowIsCurrent |
SCD Type |
n/a |
RowIsCurrent |
Source System |
Derived |
RowStartDate |
Display Folder |
Exclude from cube |
RowStartDate |
Display Name |
Row Start Date |
RowStartDate |
ETL Rules |
Standard SCD-2 |
RowStartDate |
Example Values |
1/24/2011 |
RowStartDate |
MS_Description |
When did this row become valid for this member? |
RowStartDate |
SCD Type |
n/a |
RowStartDate |
Source System |
Derived |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[DimReceiptPaymentCategory] Script Date: 03/09/2017 17:14:56 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[DimReceiptPaymentCategory]( [ReceiptPaymentCategorySK] [int] IDENTITY(1,1) NOT NULL, [ReceiptPaymentCategoryAK] [varchar](18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ReceiptPaymentCategoryCode] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ReceiptPaymentCategory] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ReceiptPaymentMethodCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ReceiptPaymentMethod] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [RowIsCurrent] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [RowStartDate] [datetime] NOT NULL, [RowEndDate] [datetime] NULL, CONSTRAINT [PK_dbo.DimReceiptPaymentCategory] PRIMARY KEY CLUSTERED ( [ReceiptPaymentCategorySK] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'RPaymentCategory' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory' EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'Payment category and method for receipts, represents type of dollars used to pay for items and services. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory' EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory' EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Payment Category ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategory' EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategory' EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Cash Payments, Check Payments, Point of Purchase Payments' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategory' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive name for the category of a receipt payment used by a student to make a payment via a receipt. Examples are Cash ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategory' EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategory' EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategory' EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'ReceiptPaymentCategoryAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryAK' EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryAK' EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Cash CA, Check CK, Check CC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryAK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryAK' EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryAK' EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryAK' EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Payment Category Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryCode' EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryCode' EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Cash, Bank, Check, CreditCard, Coverage' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the category of a receipt payment used by a student to make a payment via a receipt. Examples are Cash Payments or Ch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryCode' EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryCode' EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategoryCode' EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'ReceiptPaymentCategorySK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @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'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategorySK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategorySK' EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @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'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentCategorySK' EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Payment Method' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethod' EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethod' EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Cash Payment, Deposit from Receivable, Debit Card Payment' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethod' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive name for the method of a receipt payment used by a student to make a payment via a receipt. Examples are Cash Pay' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethod' EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethod' EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethod' EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethod' EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethod' EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Payment Method Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethodCode' EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethodCode' EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'CA, OC, DP, DB' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethodCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the method of a receipt payment used by a student to make a payment via a receipt. Examples are Cash Payment, Interna' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethodCode' EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethodCode' EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'ReceiptPaymentMethodCode' EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowEndDate' EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row End Date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowEndDate' EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Standard SCD-2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowEndDate' EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/14/1998, 12/31/9999' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowEndDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become invalid? (12/31/9999 if current row)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowEndDate' EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowEndDate' EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowEndDate' EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowIsCurrent' EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row Is Current' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowIsCurrent' EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Standard SCD-2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowIsCurrent' EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Y, N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowIsCurrent' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Is this the current row for this member (Y/N)?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowIsCurrent' EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowIsCurrent' EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowIsCurrent' EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowStartDate' EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row Start Date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowStartDate' EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Standard SCD-2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowStartDate' EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/24/2011' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowStartDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become valid for this member?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowStartDate' EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowStartDate' EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimReceiptPaymentCategory', @level2type=N'COLUMN',@level2name=N'RowStartDate' |
Sample Data
| ReceiptPaymentCategory | ReceiptPaymentCategoryAK | ReceiptPaymentCategoryCode | ReceiptPaymentCategorySK | ReceiptPaymentMethod | ReceiptPaymentMethodCode | RowEndDate | RowIsCurrent | RowStartDate |
| Check Payments | Check CI | Check | 7 | International Check | CI | Y | 1900-01-01T00:00:00-05:00 | |
| N/A | N/A | N/A | -1 | N/A | N/A | 9999-12-31T00:00:00-05:00 | Y | 1899-12-31T00:00:00-05:00 |
| Credit Card Payments | CreditCard DB | CreditCard | 11 | Debit Card Payment | DB | Y | 1900-01-01T00:00:00-05:00 | |
| Check Payments | Check CK | Check | 5 | Check Payment | CK | Y | 1900-01-01T00:00:00-05:00 | |
| Wire Transfer Payments | WireTransfer WT | WireTransfer | 12 | Wire Transfer | WT | Y | 1900-01-01T00:00:00-05:00 | |
| Check Payments | Check CC | Check | 6 | College Issued Check | CC | Y | 1900-01-01T00:00:00-05:00 | |
| Bank or Overpayments | Bank OC | Bank | 3 | Bank or Overpayment | OC | Y | 1900-01-01T00:00:00-05:00 | |
| Cash Payments | Cash CA | Cash | 2 | Cash Payment | CA | Y | 1900-01-01T00:00:00-05:00 | |
| Check Payments | Check CO | Check | 8 | Out of Town/State Check | CO | Y | 1900-01-01T00:00:00-05:00 | |
| Point of Purchase Payments | POP CP | POP | 13 | Point of Purchase | CP | Y | 1900-01-01T00:00:00-05:00 |
| Powered by BI Documenter |
