EnterpriseDW
 dbo.DimPurchaseOrder (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.DimPurchaseOrder
  Properties
Property Value
Name DimPurchaseOrder
Schema dbo
Row Count 120588
Data Size 18480 KB
Index Size 88 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
Buyer
varchar(30)
False
False
False
 
The name of the buyer
BuyerId
varchar(3)
False
False
False
 
The userid of the Buyer responsible for this Purchase Order
FiscalYear
varchar(4)
False
False
False
 
The fiscal year associated with the purchase Order
PayStatus
varchar(30)
False
False
False
 
The description of the Pay Status Code
PayStatusCode
varchar(3)
False
False
False
 
The Pay Status code of the purchase order
PoStatus
varchar(30)
False
False
False
 
The description of the Status Code
PoStatusCode
varchar(4)
False
False
False
 
The Status code of the purchase order
PoType
varchar(30)
False
False
False
 
The description of the Purchase Order Type
PoTypeCode
varchar(4)
False
False
False
 
The type of the Purchase Order
PurchaseOrderAK
varchar(12)
False
False
False
 
Business Key for the Purchase Order This will be a combination of FiscalYear and Purchase Order Number
PurchaseOrderNumber
varchar(8)
False
False
False
 
The purchase order number
In Primary Key
PurchaseOrderSK
int(10, 0)
False
False
False
(1 / 1)
Surrogate primary key
ReceivingStatus
varchar(30)
False
False
False
 
The description of the Receiving Status Code
ReceivingStatusCode
varchar(3)
False
False
False
 
The Receiving Status code of the purchase order
RowEndDate
datetime(23, 3)
True
False
False
 
When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent
char(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
PurchaseOrderSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimPurchaseOrder depends on)
Name Type
Table
  Child Dependencies (objects that depend on dbo.DimPurchaseOrder)
Name Type
TABLE
  Extended Properties
Object Property Value
DimPurchaseOrder
Display Name
PurchaseOrder
DimPurchaseOrder
Table Description
This table will contain a row for each purchase Order header in the system
DimPurchaseOrder
Table Type
Dimension
Buyer
Display Name
Buyer
Buyer
ETL Rules
Extracted from FIP-TABLES
Buyer
Example Values
Don Windham
Buyer
MS_Description
The name of the buyer
Buyer
SCD Type
1
Buyer
Source Field Name
BUYER_NAME
Buyer
Source System
DWStaging
Buyer
Source Table
FIP_TABLES
BuyerId
Display Name
BuyerId
BuyerId
Example Values
DLW
BuyerId
MS_Description
The userid of the Buyer responsible for this Purchase Order
BuyerId
SCD Type
1
BuyerId
Source Field Name
BUYER_ID
BuyerId
Source System
DWStaging
BuyerId
Source Table
FIP_PO_HDR
FiscalYear
Display Name
FiscalYear
FiscalYear
Example Values
2012
FiscalYear
MS_Description
The fiscal year associated with the purchase Order
FiscalYear
SCD Type
1
FiscalYear
Source Field Name
FISCAL_YEAR
FiscalYear
Source System
DWStaging
FiscalYear
Source Table
FIP_PO_HDR
PayStatus
Display Name
PayStatus
PayStatus
ETL Rules
Extracted from the FIP_STATUS_TBL_V STATUS_DESC Convert to Upper/Lower case
PayStatus
Example Values
Paid, Payable
PayStatus
MS_Description
The description of the Pay Status Code
PayStatus
SCD Type
1
PayStatus
Source Field Name
STATUS_DESC
PayStatus
Source System
DWStaging
PayStatus
Source Table
FIP_TABLES
PayStatusCode
Display Name
PayStatusCode
PayStatusCode
Example Values
PD, PY
PayStatusCode
MS_Description
The Pay Status code of the purchase order
PayStatusCode
SCD Type
1
PayStatusCode
Source Field Name
PAY_STATUS
PayStatusCode
Source System
DWStaging
PayStatusCode
Source Table
FIP_PO_HDR
PoStatus
Display Name
PoStatus
PoStatus
ETL Rules
Extracted from the FIP_STATUS_TBL_V STATUS_DESC Convert to Upper/Lower case
PoStatus
Example Values
Credit Memo, Student, Travel Payment Request
PoStatus
MS_Description
The description of the Status Code
PoStatus
SCD Type
1
PoStatus
Source Field Name
STATUS_DESC
PoStatus
Source System
DWStaging
PoStatus
Source Table
FIP_TABLES
PoStatusCode
Display Name
PoStatusCode
PoStatusCode
Example Values
OP, CL,
PoStatusCode
MS_Description
The Status code of the purchase order
PoStatusCode
SCD Type
1
PoStatusCode
Source Field Name
STATUS
PoStatusCode
Source System
DWStaging
PoStatusCode
Source Table
FIP_PO_HDR
PoType
Display Name
PoType
PoType
ETL Rules
Extracted from the UTL_CODE_TABLE_FILE, table name REF-TYPES. Convert to Upper/Lower case
PoType
Example Values
Blanket Order, Construction
PoType
MS_Description
The description of the Purchase Order Type
PoType
SCD Type
1
PoType
Source Field Name
DESCRIPTION
PoType
Source System
DWStaging
PoType
Source Table
UTL_CODE_TABLE_FILE Table Name REF-TYPES
PoTypeCode
Display Name
PoTypeCode
PoTypeCode
Example Values
BO, EM, RQ
PoTypeCode
MS_Description
The type of the Purchase Order
PoTypeCode
SCD Type
1
PoTypeCode
Source Field Name
REF_TYPE
PoTypeCode
Source System
DWStaging
PoTypeCode
Source Table
FIP_PO_HDR
PurchaseOrderAK
Display Name
PurchaseOrderAK
PurchaseOrderAK
ETL Rules
Concatenate FISCAL_YEAR and REF_NBR
PurchaseOrderAK
Example Values
201200004786
PurchaseOrderAK
MS_Description
Business Key for the Purchase Order This will be a combination of FiscalYear and Purchase Order Number
PurchaseOrderAK
SCD Type
key
PurchaseOrderAK
Source Field Name
FISCAL_YEAR, REF_NBR
PurchaseOrderAK
Source System
DWStaging
PurchaseOrderAK
Source Table
FIP_PO_HDR
PurchaseOrderNumber
Display Name
PurchaseOrderNumber
PurchaseOrderNumber
Example Values
2345
PurchaseOrderNumber
MS_Description
The purchase order number
PurchaseOrderNumber
SCD Type
1
PurchaseOrderNumber
Source Field Name
REF_NBR
PurchaseOrderNumber
Source System
DWStaging
PurchaseOrderNumber
Source Table
FIP_PO_HDR
PurchaseOrderSK
Display Name
PurchaseOrderSK
PurchaseOrderSK
Example Values
1, 2, 3?
PurchaseOrderSK
MS_Description
Surrogate primary key
PurchaseOrderSK
SCD Type
key
PurchaseOrderSK
Source System
Derived
ReceivingStatus
Display Name
ReceivingStatus
ReceivingStatus
ETL Rules
Extracted from the FIP_STATUS_TBL_V STATUS_DESC Convert to Upper/Lower case
ReceivingStatus
Example Values
Received, Partially Received
ReceivingStatus
MS_Description
The description of the Receiving Status Code
ReceivingStatus
SCD Type
1
ReceivingStatus
Source Field Name
STATUS_DESC
ReceivingStatus
Source System
DWStaging
ReceivingStatus
Source Table
FIP_TABLES
ReceivingStatusCode
Display Name
ReceivingStatusCode
ReceivingStatusCode
Example Values
RC, PC
ReceivingStatusCode
MS_Description
The Receiving Status code of the purchase order
ReceivingStatusCode
SCD Type
1
ReceivingStatusCode
Source Field Name
REC_STATUS
ReceivingStatusCode
Source System
DWStaging
ReceivingStatusCode
Source Table
FIP_PO_HDR
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].[DimPurchaseOrder] Script Date: 03/09/2017 17:14:56 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimPurchaseOrder](
    [PurchaseOrderSK] [int] IDENTITY(1,1) NOT NULL,
    [PurchaseOrderAK] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FiscalYear] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PurchaseOrderNumber] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PoStatusCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PoStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReceivingStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReceivingStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PoTypeCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PoType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BuyerId] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Buyer] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
 CONSTRAINT [PK_dbo.DimPurchaseOrder] PRIMARY KEY CLUSTERED 
(
    [PurchaseOrderSK] 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'PurchaseOrder' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'This table will contain a row for each purchase Order header in the system' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder'


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from FIP-TABLES' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'Buyer'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Don Windham' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'Buyer'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the buyer ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'Buyer'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'DLW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'BuyerId'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The userid of the Buyer responsible for this Purchase Order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'BuyerId'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'2012' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'FiscalYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The fiscal year associated with the purchase Order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'FiscalYear'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from the FIP_STATUS_TBL_V STATUS_DESC Convert to Upper/Lower case' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PayStatus'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Paid, Payable' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PayStatus'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Pay Status Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PayStatus'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'PD, PY' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PayStatusCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Pay Status code of the purchase order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PayStatusCode'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from the FIP_STATUS_TBL_V STATUS_DESC Convert to Upper/Lower case' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoStatus'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Credit Memo, Student, Travel Payment Request' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoStatus'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Status Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoStatus'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'OP, CL, ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoStatusCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Status code of the purchase order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoStatusCode'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from the UTL_CODE_TABLE_FILE, table name REF-TYPES. Convert to Upper/Lower case' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoType'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Blanket Order, Construction' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoType'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Purchase Order Type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoType'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE Table Name REF-TYPES' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoType'


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'BO, EM, RQ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoTypeCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The type of the Purchase Order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PoTypeCode'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Concatenate FISCAL_YEAR and REF_NBR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PurchaseOrderAK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'201200004786' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PurchaseOrderAK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business Key for the Purchase Order This will be a combination of FiscalYear and Purchase Order Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PurchaseOrderAK'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'2345' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PurchaseOrderNumber'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The purchase order number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'PurchaseOrderNumber'


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


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


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


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


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


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from the FIP_STATUS_TBL_V STATUS_DESC Convert to Upper/Lower case' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'ReceivingStatus'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Received, Partially Received' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'ReceivingStatus'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Receiving Status Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'ReceivingStatus'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'RC, PC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'ReceivingStatusCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Receiving Status code of the purchase order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'ReceivingStatusCode'


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @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'DimPurchaseOrder', @level2type=N'COLUMN',@level2name=N'RowStartDate'
  Sample Data
Buyer BuyerId FiscalYear PayStatus PayStatusCode PoStatus PoStatusCode PoType PoTypeCode PurchaseOrderAK PurchaseOrderNumber PurchaseOrderSK ReceivingStatus ReceivingStatusCode RowEndDate RowIsCurrent RowStartDate
Don Windham DLW 2000 Completed CM Closed CL Standard Purchase Order PO 200000204782 00204782 65224 Complete Receiv RC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
Don Windham DLW 2001 Completed CM Closed CL Prepaid Order PP 200100208195 00208195 59075 Pending PE 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
Tranetta Rutherford TLR 2017 Completed CM Closed CL Standard Purchase Order PO 201700001262 00001262 158870 Complete Receiv RC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
Karen Windham KRW 2015 Completed CM Closed CL Blanket Order BO 201500002279 00002279 159533 Complete Receiv RC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
Don Windham DLW 2000 Completed CM Closed CL Standard Purchase Order PO 200000204630 00204630 64974 Complete Receiv RC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
Don Windham DLW 1999 Completed CM Closed CL Standard Purchase Order PO 199900195646 00195646 51287 Complete Receiv RC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
N/A FNS 2003 Pending PE Cancelled CA Blanket Order BO 200300226070 00226070 78632 Complete Receiv RC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
N/A FNS 2002 Partial Receive PT Closed CL Standard Purchase Order PO 200200216794 00216794 73132 Partial Receive PT 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
Karen Windham KRW 2015 Partial Receive PT Closed CL Construction Order CO 201500003607 00003607 160955 Complete Receiv RC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
Don Windham DLW 1999 Partial Receive PT Closed CL Blanket Order BO 199900193619 00193619 48678 Complete Receiv RC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:09:00-05:00
Powered by BI Documenter