EnterpriseDW
 dbo.DimPaymentSource (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.DimPaymentSource
  Properties
Property Value
Name DimPaymentSource
Schema dbo
Row Count 17
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
PaymentCategory
varchar(60)
False
False
False
 
Descriptive name for the category of funds used by a student to pay for academic and institutional fees. Examples are Pell, Loa
PaymentCategoryCode
varchar(10)
False
False
False
 
Code for the category of funds used by a student to pay for academic and institutional fees. Examples are Pell, Loans and Tuiti
PaymentCategoryLabel
varchar(30)
False
False
False
 
Short descriptive title for the category of funds used by a student to pay for academic and institutional fees. Examples are Pe
PaymentCategoryShort
varchar(15)
False
False
False
 
Shortened descriptive title for the category of funds used by a student to pay for academic and institutional fees. Examples ar
PaymentSource
varchar(60)
False
False
False
 
Descriptive name for the source of payment used by a student to pay for academic and institutional fees. Examples are Financial
PaymentSourceAK
varchar(20)
False
False
False
 
Business key.
PaymentSourceCode
varchar(10)
False
False
False
 
Code for the source of payment used by a student to pay for academic and institutional fees. Examples are Financial Aid, Stude
PaymentSourceLabel
varchar(30)
False
False
False
 
Short descriptive title for the payment source used by a student to pay for academic and institutional fees. Examples are Finan
In Primary Key
PaymentSourceSK
int(10, 0)
False
False
False
(1 / 1)
Surrogate primary key
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
PaymentSourceSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimPaymentSource depends on)
Name Type
Table
Table
Table
  Child Dependencies (objects that depend on dbo.DimPaymentSource)
Name Type
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
DimPaymentSource
Display Name
PaySource
DimPaymentSource
Table Description
Payment sources and categories for reporting of Student payments for classes and other academic charges. These categories will
DimPaymentSource
Table Type
Dimension
PaymentCategory
Display Name
Payment Category
PaymentCategory
ETL Rules
Load via script
PaymentCategory
Example Values
Fees Paid 100% By Pell, Fees Paid 100% By State Grants, Fees Paid by Cash, No Fees are Paid
PaymentCategory
MS_Description
Descriptive name for the category of funds used by a student to pay for academic and institutional fees. Examples are Pell, Loa
PaymentCategory
SCD Type
1
PaymentCategory
Source Field Name
PaymentCategory
Source System
Derived
PaymentCategory
Source Table
PaymentCategoryCode
Display Name
Payment Category Code
PaymentCategoryCode
ETL Rules
Load via script
PaymentCategoryCode
Example Values
1PELL, 4STATE, 1STPAID, 1COPAY
PaymentCategoryCode
MS_Description
Code for the category of funds used by a student to pay for academic and institutional fees. Examples are Pell, Loans and Tuiti
PaymentCategoryCode
SCD Type
1
PaymentCategoryCode
Source System
Derived
PaymentCategoryLabel
Display Name
Payment Category Label
PaymentCategoryLabel
ETL Rules
Load via script
PaymentCategoryLabel
Example Values
Pell, State Grants, Cash, Not Paid
PaymentCategoryLabel
MS_Description
Short descriptive title for the category of funds used by a student to pay for academic and institutional fees. Examples are Pe
PaymentCategoryLabel
SCD Type
1
PaymentCategoryLabel
Source Field Name
PaymentCategoryLabel
Source System
Derived
PaymentCategoryLabel
Source Table
PaymentCategoryShort
Display Name
Payment Category Short
PaymentCategoryShort
ETL Rules
Load via script
PaymentCategoryShort
Example Values
Pell, State, Cash, Not Paid
PaymentCategoryShort
MS_Description
Shortened descriptive title for the category of funds used by a student to pay for academic and institutional fees. Examples ar
PaymentCategoryShort
SCD Type
1
PaymentCategoryShort
Source Field Name
PaymentCategoryShort
Source System
Derived
PaymentCategoryShort
Source Table
PaymentSource
Display Name
Payment Source
PaymentSource
ETL Rules
Load via script
PaymentSource
Example Values
Fees Paid 100% By Financial Aid, Fees Paid 100% By the Student, Fees Not 100% Paid
PaymentSource
MS_Description
Descriptive name for the source of payment used by a student to pay for academic and institutional fees. Examples are Financial
PaymentSource
SCD Type
1
PaymentSource
Source System
Derived
PaymentSourceAK
Display Name
PaymentSourceAK
PaymentSourceAK
ETL Rules
load via script
PaymentSourceAK
Example Values
1FA 1PELL, 2ST 2TPP, 5NP 2NOTP
PaymentSourceAK
MS_Description
Business key.
PaymentSourceAK
SCD Type
key
PaymentSourceAK
Source System
Derived
PaymentSourceCode
Display Name
Payment Source Code
PaymentSourceCode
ETL Rules
Load via script
PaymentSourceCode
Example Values
1FA, 2ST, 3TP, 4CO, 5NP
PaymentSourceCode
MS_Description
Code for the source of payment used by a student to pay for academic and institutional fees. Examples are Financial Aid, Stude
PaymentSourceCode
SCD Type
1
PaymentSourceCode
Source System
Derived
PaymentSourceLabel
Display Name
Payment Source Label
PaymentSourceLabel
ETL Rules
Load via script
PaymentSourceLabel
Example Values
100% Financial Aid, 100% Student Paid, Fees Not Paid
PaymentSourceLabel
MS_Description
Short descriptive title for the payment source used by a student to pay for academic and institutional fees. Examples are Finan
PaymentSourceLabel
SCD Type
1
PaymentSourceLabel
Source System
Derived
PaymentSourceSK
Display Name
PaymentSourceSK
PaymentSourceSK
Example Values
1, 2, 3?
PaymentSourceSK
MS_Description
Surrogate primary key
PaymentSourceSK
SCD Type
key
PaymentSourceSK
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].[DimPaymentSource] Script Date: 03/09/2017 17:14:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimPaymentSource](
    [PaymentSourceSK] [int] IDENTITY(1,1) NOT NULL,
    [PaymentSourceAK] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentSourceCode] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentSource] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentSourceLabel] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentCategoryCode] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentCategory] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentCategoryLabel] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PaymentCategoryShort] [varchar](15) 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.DimPaymentSource] PRIMARY KEY CLUSTERED 
(
    [PaymentSourceSK] 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'PaySource' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'Payment sources and categories for reporting of Student payments for classes and other academic charges. These categories will ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Payment Category ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategory'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategory'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Fees Paid 100% By Pell, Fees Paid 100% By State Grants, Fees Paid by Cash, No Fees are Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategory'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the category of funds used by a student to pay for academic and institutional fees. Examples are Pell, Loa' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategory'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategory'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Payment Category Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryCode'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryCode'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1PELL, 4STATE, 1STPAID, 1COPAY' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the category of funds used by a student to pay for academic and institutional fees. Examples are Pell, Loans and Tuiti' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryCode'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryCode'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Payment Category Label' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryLabel'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryLabel'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Pell, State Grants, Cash, Not Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryLabel'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short descriptive title for the category of funds used by a student to pay for academic and institutional fees. Examples are Pe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryLabel'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryLabel'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Payment Category Short' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryShort'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryShort'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Pell, State, Cash, Not Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryShort'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shortened descriptive title for the category of funds used by a student to pay for academic and institutional fees. Examples ar' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryShort'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentCategoryShort'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Payment Source' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSource'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSource'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Fees Paid 100% By Financial Aid, Fees Paid 100% By the Student, Fees Not 100% Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSource'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the source of payment used by a student to pay for academic and institutional fees. Examples are Financial' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSource'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSource'


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceAK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1FA 1PELL, 2ST 2TPP, 5NP 2NOTP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceAK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceAK'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceAK'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Payment Source Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceCode'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceCode'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1FA, 2ST, 3TP, 4CO, 5NP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the source of payment used by a student to pay for academic and institutional fees. Examples are Financial Aid, Stude' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceCode'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceCode'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Payment Source Label' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceLabel'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Load via script' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceLabel'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'100% Financial Aid, 100% Student Paid, Fees Not Paid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceLabel'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short descriptive title for the payment source used by a student to pay for academic and institutional fees. Examples are Finan' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceLabel'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceLabel'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'PaymentSourceSK'


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


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @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'DimPaymentSource', @level2type=N'COLUMN',@level2name=N'RowStartDate'
  Sample Data
PaymentCategory PaymentCategoryCode PaymentCategoryLabel PaymentCategoryShort PaymentSource PaymentSourceAK PaymentSourceCode PaymentSourceLabel PaymentSourceSK RowIsCurrent RowStartDate
Fees Paid by Other Federal Grants 3OTHF Federal Grants Federal Fees Paid By Financial Aid 1FA 3OTHF 1FA 100% Financial Aid 4 Y 1900-01-01T00:00:00-05:00
N/A N/A N/A N/A N/A N/A N/A N/A -1 Y 1900-01-01T00:00:00-05:00
Fees are Partially Paid 1PARTP Partial Payment Partial Fees Not Paid 5NP 1PARTP 5NP Fees Not Paid 15 Y 1900-01-01T00:00:00-05:00
Fees Paid by Student 1STPAID Student Paid Student Fees Paid by the Student 2ST 1STPAID 2ST 100% Student Paid 9 Y 1900-01-01T00:00:00-05:00
Fees Paid by a Multiple Sources 1COPAY Combo Paid Combo Fees Paid by a Combination of Sources 4CO 1COPAY 4CO Paid by Multiple Sources 14 Y 1900-01-01T00:00:00-05:00
Fees Paid by Tuition Payment Plan 2TPP Tuition Payment Plan Student Fees Paid by the Student 2ST 2TPP 2ST 100% Student Paid 10 Y 1900-01-01T00:00:00-05:00
Fees Paid by State Grants 4STATE State Grants State Fees Paid By Financial Aid 1FA 4STATE 1FA 100% Financial Aid 5 Y 1900-01-01T00:00:00-05:00
Fees Paid by a Combination of Student Paid 4STCOM Combo Student Paid Student Fees Paid by the Student 2ST 4STCOM 2ST 100% Student Paid 12 Y 1900-01-01T00:00:00-05:00
Fees Paid by a Combination of Financial Aid 7FACOM Combo Financial Aid FinAid Fees Paid By Financial Aid 1FA 7FACOM 1FA 100% Financial Aid 8 Y 1900-01-01T00:00:00-05:00
Fees Paid by Pell 1PELL Pell Pell Fees Paid By Financial Aid 1FA 1PELL 1FA 100% Financial Aid 2 Y 1900-01-01T00:00:00-05:00
Powered by BI Documenter