Table - dbo.DimStudentReceipt

Property	Value
Name	DimStudentReceipt
Schema	dbo
Row Count	5042352
Data Size	825568 KB
Index Size	3088 KB
Create Date	1/28/2014 9:47 AM
Description

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
MiscellaneousReceiptCatecoryCode	varchar(3)	False	False	False			A identification code for the type of miscellaneous receipt.
MiscellaneousReceiptCategory	varchar(30)	False	False	False			A descriptive name for the type of miscellaneous receipt. Examples are Library Fine, Parking Fine, Graduation Fees or Ticket Sa
PrintedReceiptNumber	int(10, 0)	False	False	False			Number assigned to receipts which produce printable or displayable objects and are assigned a print number.
ReceiptCategory	varchar(15)	False	False	False			An indication as to the location or where the receipt was generated. The values are at the Cashier Session, Student in the WEB,
ReceiptProcesser	varchar(50)	False	False	False			The descriptive name for the person or process which created the receipt.
ReceiptProcesserCode	varchar(8)	False	False	False			The identification code for the person or process which created the receipt.
ReceiptReference	varchar(30)	False	False	False			The institutional reference information entered on the receipt to identify the charge to an originating system or document.
ReceiptSequenceNumber	int(10, 0)	False	False	False			A sequence number assigned to each receipt within a session on a day for the receipt processer.
ReceiptType	varchar(30)	False	False	False			A descriptive name for the type of receipt that was generated. Examples are Automatic, Student or Miscellaneous.
ReceiptTypeCode	varchar(3)	False	False	False			The identification code for the type of receipt generated.
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?
SessionDate	date(10, 0)	False	False	False			The date the session was created.
SessionSequenceNumber	int(10, 0)	False	False	False			A sequence number assigned to each session initiated on a day for the same receipt processer.
StudentId	varchar(9)	False	False	False			Student identifier assigned by the source application and used by the Data Warehouse as the Business Key
StudentReceiptAK	varchar(24)	False	False	False			Business key for a receipt, consists of the Cashier Session Key plus the Receipt Sequence number.
StudentReceiptSK	int(10, 0)	False	False	False	(1 / 1)		Surrogate primary key

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_dbo.DimStudentReceipt	True	StudentReceiptSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.FactStudentReceiptPayments	Table
dbo.FactStudentReceiptTotals	Table

Name	Type
dbo.FactStudentReceiptPayments	TABLE
dbo.FactStudentReceiptTotals	TABLE

Object	Property	Value
DimStudentReceipt	Display Name	STReceipt
DimStudentReceipt	Table Description	Receipt information for Students, including the type of receipt, the receipt category and the origin of the receipt.
DimStudentReceipt	Table Type	Dimension
MiscellaneousReceiptCatecoryCode	Display Name	Miscellaneous Receipt Category Code
MiscellaneousReceiptCatecoryCode	Example Values	BK, CL, LF, PK
MiscellaneousReceiptCatecoryCode	MS_Description	A identification code for the type of miscellaneous receipt.
MiscellaneousReceiptCatecoryCode	SCD Type	1
MiscellaneousReceiptCatecoryCode	Source Field Name	MISC_RECEIPT_CAT
MiscellaneousReceiptCatecoryCode	Source System	DWStaging
MiscellaneousReceiptCatecoryCode	Source Table	AR_RECEIPT_A
MiscellaneousReceiptCategory	Display Name	Miscellaneous Receipt Category
MiscellaneousReceiptCategory	ETL Rules	Pull from UTL_CODE_TABLE called RCPT-MISC. Convert to upper/lower case.
MiscellaneousReceiptCategory	Example Values	Library Fine, Graduation Fees
MiscellaneousReceiptCategory	MS_Description	A descriptive name for the type of miscellaneous receipt. Examples are Library Fine, Parking Fine, Graduation Fees or Ticket Sa
MiscellaneousReceiptCategory	SCD Type	1
MiscellaneousReceiptCategory	Source System	DWStaging
MiscellaneousReceiptCategory	Source Table	UTL_CODE_TABLE
PrintedReceiptNumber	Display Name	Printed Receipt Number
PrintedReceiptNumber	Example Values	0, 1001, 85377, 855017
PrintedReceiptNumber	MS_Description	Number assigned to receipts which produce printable or displayable objects and are assigned a print number.
PrintedReceiptNumber	SCD Type	1
PrintedReceiptNumber	Source Field Name	PRINTED_RECEIPT_NUM
PrintedReceiptNumber	Source System	DWStaging
PrintedReceiptNumber	Source Table	AR_RECEIPT_A
ReceiptCategory	Display Name	Receipt Category
ReceiptCategory	ETL Rules	The value of this field to be determined as follows and the checks should be preformed in the sequence listed. The first eight
ReceiptCategory	Example Values	Casher, Web , Registration and Function
ReceiptCategory	MS_Description	An indication as to the location or where the receipt was generated. The values are at the Cashier Session, Student in the WEB,
ReceiptCategory	SCD Type	1
ReceiptCategory	Source System	Derived
ReceiptCategory	Source Table
ReceiptProcesser	Display Name	Receipt Processer
ReceiptProcesser	ETL Rules	Based on the ReceiptCategory, pull the appropriate name, convert literals to upper/lower case as needed. As follows: 1. If the
ReceiptProcesser	Example Values	Jennifer Brown, Winter Haven Administration, WEB001 Session, FIC401N2 Process
ReceiptProcesser	MS_Description	The descriptive name for the person or process which created the receipt.
ReceiptProcesser	SCD Type	1
ReceiptProcesser	Source System	Derived
ReceiptProcesser	Source Table
ReceiptProcesserCode	Display Name	Receipt Processer Code
ReceiptProcesserCode	ETL Rules	The first eight charcters of the CASHIER_SESSION_KEY.
ReceiptProcesserCode	Example Values	JBROWN, WADM, WEB001, FIC401N2
ReceiptProcesserCode	MS_Description	The identification code for the person or process which created the receipt.
ReceiptProcesserCode	SCD Type	1
ReceiptProcesserCode	Source Field Name	CASHIER_SESSION_KEY
ReceiptProcesserCode	Source System	DWStaging
ReceiptProcesserCode	Source Table	AR_RECEIPT_A
ReceiptReference	Display Name	Receipt Reference Identifier
ReceiptReference	Example Values	Ticket ABC123, 20130512 Charge, Summer Camp
ReceiptReference	MS_Description	The institutional reference information entered on the receipt to identify the charge to an originating system or document.
ReceiptReference	SCD Type	1
ReceiptReference	Source Field Name	RECEIPT_REFERENCE_NUM
ReceiptReference	Source System	DWStaging
ReceiptReference	Source Table	AR_RECEIPT_A
ReceiptSequenceNumber	Display Name	Receipt Sequence Number
ReceiptSequenceNumber	Example Values	1,16, 44,101
ReceiptSequenceNumber	MS_Description	A sequence number assigned to each receipt within a session on a day for the receipt processer.
ReceiptSequenceNumber	SCD Type	1
ReceiptSequenceNumber	Source Field Name	RECEIPT_SEQ
ReceiptSequenceNumber	Source System	DWStaging
ReceiptSequenceNumber	Source Table	AR_RECEIPT_A
ReceiptType	Display Name	Receipt Type
ReceiptType	ETL Rules	Pull from UTL_CODE_TABLE called RCPT-TYPE. Convert to upper/lower case.
ReceiptType	Example Values	Automatic, Student, Miscellaneous
ReceiptType	MS_Description	A descriptive name for the type of receipt that was generated. Examples are Automatic, Student or Miscellaneous.
ReceiptType	Source System	DWStaging
ReceiptType	Source Table	UTL_CODE_TABLE
ReceiptTypeCode	Display Name	Receipt Type Code
ReceiptTypeCode	Example Values	AU, MR, SR, CR
ReceiptTypeCode	MS_Description	The identification code for the type of receipt generated.
ReceiptTypeCode	SCD Type	1
ReceiptTypeCode	Source Field Name	RECEIPT_TYPE
ReceiptTypeCode	Source System	DWStaging
ReceiptTypeCode	Source Table	AR_RECEIPT_A
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
SessionDate	Display Name	Session Date
SessionDate	ETL Rules	Pull the date from positions 9 through 16 of the CASHIER_SESSION_KEY.
SessionDate	Example Values	1/24/2011, 08/13/2013
SessionDate	MS_Description	The date the session was created.
SessionDate	SCD Type	1
SessionDate	Source Field Name	CASHER_SESSION_KEY
SessionDate	Source System	DWStaging
SessionDate	Source Table	AR_RECEIPT_A
SessionSequenceNumber	Display Name	Session Sequence Number
SessionSequenceNumber	ETL Rules	Pull the sequence number from positions 17 through 19 of the CASHIER_SESSION_KEY.
SessionSequenceNumber	Example Values	1,12,55
SessionSequenceNumber	MS_Description	A sequence number assigned to each session initiated on a day for the same receipt processer.
SessionSequenceNumber	SCD Type	1
SessionSequenceNumber	Source Field Name	CASHER_SESSION_KEY
SessionSequenceNumber	Source System	DWStaging
SessionSequenceNumber	Source Table	AR_RECEIPT_A
StudentId	Display Name	Student ID
StudentId	Example Values	A100223312, R09034412
StudentId	MS_Description	Student identifier assigned by the source application and used by the Data Warehouse as the Business Key
StudentId	SCD Type	1
StudentId	Source Field Name	STUDENT_ID
StudentId	Source System	DWStaging
StudentId	Source Table	AR_RECEIPT_A
StudentReceiptAK	Display Name	StudentReceiptAK
StudentReceiptAK	ETL Rules	The business key will consists of the CASHIER_SESSION_KEY from the AR_RECEIPT_A concatinated with the five digit, with leading z
StudentReceiptAK	Example Values	WHEELER 2002101700100008, WEB000012012070200200043, 41 2012070200100023, ITS103NR2012070200100008
StudentReceiptAK	MS_Description	Business key for a receipt, consists of the Cashier Session Key plus the Receipt Sequence number.
StudentReceiptAK	SCD Type	1
StudentReceiptAK	Source Field Name	CASHIER_SESSION_KEY = RECEPIT_SEQ
StudentReceiptAK	Source System	DWStaging
StudentReceiptAK	Source Table	AR_RECEIPT_A
StudentReceiptSK	Display Name	PaymentSourceSK
StudentReceiptSK	ETL Rules	Assigned by SQL.
StudentReceiptSK	Example Values	1, 2, 3?
StudentReceiptSK	MS_Description	Surrogate primary key
StudentReceiptSK	SCD Type	key
StudentReceiptSK	Source System	Derived

Object

Property

Value

/****** Object: Table [dbo].[DimStudentReceipt] Script Date: 03/09/2017 17:14:56 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimStudentReceipt](
    [StudentReceiptSK] [int] IDENTITY(1,1) NOT NULL,
    [StudentReceiptAK] [varchar](24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrintedReceiptNumber] [int] NOT NULL,
    [ReceiptCategory] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReceiptProcesserCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReceiptProcesser] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SessionDate] [date] NOT NULL,
    [SessionSequenceNumber] [int] NOT NULL,
    [ReceiptSequenceNumber] [int] NOT NULL,
    [ReceiptTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReceiptType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [MiscellaneousReceiptCatecoryCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [MiscellaneousReceiptCategory] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReceiptReference] [varchar](30) 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.DimStudentReceipt] PRIMARY KEY CLUSTERED
(
    [StudentReceiptSK] 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'STReceipt' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt'

EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'Receipt information for Students, including the type of receipt, the receipt category and the origin of the receipt.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt'

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Miscellaneous Receipt Category Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'MiscellaneousReceiptCatecoryCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'BK, CL, LF, PK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'MiscellaneousReceiptCatecoryCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A identification code for the type of miscellaneous receipt.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'MiscellaneousReceiptCatecoryCode'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Miscellaneous Receipt Category' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'MiscellaneousReceiptCategory'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Pull from UTL_CODE_TABLE called RCPT-MISC. Convert to upper/lower case.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'MiscellaneousReceiptCategory'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Library Fine, Graduation Fees' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'MiscellaneousReceiptCategory'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive name for the type of miscellaneous receipt. Examples are Library Fine, Parking Fine, Graduation Fees or Ticket Sa' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'MiscellaneousReceiptCategory'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Printed Receipt Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'PrintedReceiptNumber'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0, 1001, 85377, 855017' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'PrintedReceiptNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number assigned to receipts which produce printable or displayable objects and are assigned a print number.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'PrintedReceiptNumber'

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

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The value of this field to be determined as follows and the checks should be preformed in the sequence listed. The first eight ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptCategory'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Casher, Web , Registration and Function' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptCategory'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication as to the location or where the receipt was generated. The values are at the Cashier Session, Student in the WEB,' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptCategory'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Based on the ReceiptCategory, pull the appropriate name, convert literals to upper/lower case as needed. As follows: 1. If the ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptProcesser'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Jennifer Brown, Winter Haven Administration, WEB001 Session, FIC401N2 Process' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptProcesser'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The descriptive name for the person or process which created the receipt.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptProcesser'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Processer Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptProcesserCode'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The first eight charcters of the CASHIER_SESSION_KEY.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptProcesserCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'JBROWN, WADM, WEB001, FIC401N2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptProcesserCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The identification code for the person or process which created the receipt.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptProcesserCode'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Reference Identifier' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptReference'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Ticket ABC123, 20130512 Charge, Summer Camp' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptReference'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The institutional reference information entered on the receipt to identify the charge to an originating system or document.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptReference'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Sequence Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptSequenceNumber'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,16, 44,101' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptSequenceNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A sequence number assigned to each receipt within a session on a day for the receipt processer.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptSequenceNumber'

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

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Pull from UTL_CODE_TABLE called RCPT-TYPE. Convert to upper/lower case.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptType'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Automatic, Student, Miscellaneous' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive name for the type of receipt that was generated. Examples are Automatic, Student or Miscellaneous.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptType'

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Receipt Type Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'AU, MR, SR, CR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The identification code for the type of receipt generated. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'ReceiptTypeCode'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @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'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Session Date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'SessionDate'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Pull the date from positions 9 through 16 of the CASHIER_SESSION_KEY.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'SessionDate'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/24/2011, 08/13/2013' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'SessionDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date the session was created.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'SessionDate'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Session Sequence Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'SessionSequenceNumber'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Pull the sequence number from positions 17 through 19 of the CASHIER_SESSION_KEY.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'SessionSequenceNumber'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,12,55' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'SessionSequenceNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A sequence number assigned to each session initiated on a day for the same receipt processer.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'SessionSequenceNumber'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Student ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'A100223312, R09034412' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student identifier assigned by the source application and used by the Data Warehouse as the Business Key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'StudentId'

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

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The business key will consists of the CASHIER_SESSION_KEY from the AR_RECEIPT_A concatinated with the five digit, with leading z' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'StudentReceiptAK'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'WHEELER 2002101700100008, WEB000012012070200200043, 41 2012070200100023, ITS103NR2012070200100008' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'StudentReceiptAK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key for a receipt, consists of the Cashier Session Key plus the Receipt Sequence number.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'StudentReceiptAK'

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

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Assigned by SQL.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimStudentReceipt', @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'DimStudentReceipt', @level2type=N'COLUMN',@level2name=N'StudentReceiptSK'

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

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

MiscellaneousReceiptCatecoryCode

MiscellaneousReceiptCategory

PrintedReceiptNumber

ReceiptCategory

ReceiptProcesser

ReceiptProcesserCode

ReceiptReference

ReceiptSequenceNumber

ReceiptType

ReceiptTypeCode

RowIsCurrent

RowStartDate

SessionDate

SessionSequenceNumber

StudentId

StudentReceiptAK

StudentReceiptSK

N/A

1

Registration

Lake Worth Campus

1

N/A

47

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2008-10-15T00:00:00-04:00

2

B12200614

1 2008101500200047

2237491

N/A

842677

Web

Student Generated On The Web

WEB

N/A

8

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2006-03-03T00:00:00-05:00

2

L07084189

WEB 2006030300200008

6152222

N/A

1258334

Web

Student Generated On The Web

WEB00003

N/A

43

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2009-05-08T00:00:00-04:00

2

P08371999

WEB000032009050800200043

6412725

N/A

1

Registration

Boca Raton Campus

5

N/A

6

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2004-09-23T00:00:00-04:00

1

W11741972

5 2004092300100006

3446152

N/A

1

Registration

Boca Raton Campus

5

N/A

6

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2013-07-22T00:00:00-04:00

1

J13922539

5 2013072200100006

3478053

N/A

1

Registration

Lake Worth Campus

1

N/A

44

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2016-10-10T00:00:00-04:00

4

E14346308

1 2016101000400044

3183425

N/A

1

Function

Generated By Fic402n2 Function

FIC402N2

N/A

37

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2012-04-09T00:00:00-04:00

2

K13638085

FIC402N22012040900200037

5019806

N/A

1

Function

Generated By Its103nr Function

ITS103NR

N/A

50

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2012-08-16T00:00:00-04:00

2

N14195358

ITS103NR2012081600200050

5448867

N/A

1

Function

Generated By Fic402n2 Function

FIC402N2

N/A

41

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2013-12-06T00:00:00-05:00

1

C14298806

FIC402N22013120600100041

5144218

N/A

2042476

Web

Student Generated On The Web

WEB00001

N/A

70

Auto Receipt

AU

Y

2017-03-09T11:57:00-05:00

2014-12-16T00:00:00-05:00

2

M12684353

WEB000012014121600200070

6271267