EnterpriseDW
 dbo.DimPayee (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.DimPayee
  Properties
Property Value
Name DimPayee
Schema dbo
Row Count 964430
Data Size 149960 KB
Index Size 576 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
Country
varchar(30)
False
False
False
 
The country that is associated with the Payee Address
IsMinority
varchar(10)
False
False
False
 
Indicate if the Payee has indicated they are a minority
PayeeAK
varchar(14)
False
False
False
 
Business Key for the Payee. This will be a combination of Payee Type, Payee Id and Payee Seq
PayeeId
varchar(9)
False
False
False
 
The Payee Id Number
PayeeName
varchar(50)
False
False
False
 
The name of the Payee
PayeeNameConsolidated
varchar(50)
False
False
False
 
The name of the Payee. In case of Vendors, this will be the Vendor Name, not the name on the Address Sequence
PayeeSequence
smallint(5, 0)
False
False
False
 
The sequence number of payees that are vendors
In Primary Key
PayeeSK
int(10, 0)
False
False
False
(1 / 1)
Surrogate primary key
PayeeType
varchar(30)
False
False
False
 
The type of Payee
PayeeTypeCode
varchar(3)
False
False
False
 
The code associated with the Payee Type
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?
State
varchar(30)
False
False
False
 
The state associated with the Payee Address
StateCode
varchar(3)
False
False
False
 
The state abbreviation of the Payee Address
ZipCode
varchar(11)
False
False
False
 
The zip code associated with the Payee Address
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
PayeeSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimPayee depends on)
Name Type
Table
Table
  Child Dependencies (objects that depend on dbo.DimPayee)
Name Type
TABLE
TABLE
  Extended Properties
Object Property Value
DimPayee
Display Name
Payee
DimPayee
Table Description
This table will contain a row for each possible Payee in the system. Data will be extracted from ST-STDNT, EMPLOYEE-A, NON-EMPLO
DimPayee
Table Type
Dimension
Country
Display Name
Country
Country
ETL Rules
Follow the same rules as for StateCode, Use COUNTRY-ST table on UTL_CODE_TABLE to get country name
Country
Example Values
United States, Canada
Country
MS_Description
The country that is associated with the Payee Address
Country
SCD Type
1
Country
Source Field Name
Derived for CUSTOMER, COUNTRY_CODE, CNTRY, VA_COUNTRY
Country
Source System
DWStaging
Country
Source Table
EMPLOYEE_A_ADDRESS_INFO, NON_EMPLOYEE_A_ADDRESS_INFO, FIP_VENDOR_VA_ADDRESS_LINE, ST_ADDRESSES_A, AR_CUSTOMER_A_ADDRESS_DETAILS
IsMinority
Display Name
IsMinority
IsMinority
ETL Rules
Extracted from Vendor Only, set to Unkown for Student, Employee, Customer and Non-Employees. For Vendors, Join the Vendor Addres
IsMinority
Example Values
Yes, No, Unknown
IsMinority
MS_Description
Indicate if the Payee has indicated they are a minority
IsMinority
SCD Type
1
IsMinority
Source Field Name
MINORITY_CODE
IsMinority
Source System
DWStaging
IsMinority
Source Table
FIP_VENDOR_MINORITY_CODE
PayeeAK
Display Name
PayeeAK
PayeeAK
ETL Rules
This field should be concatenated with the PayeeTypeCode. For Employees this will be E and the PersonId with 0's added before
PayeeAK
Example Values
V FIR516000001
PayeeAK
MS_Description
Business Key for the Payee. This will be a combination of Payee Type, Payee Id and Payee Seq
PayeeAK
SCD Type
key
PayeeAK
Source Field Name
PERSON_ID STUDENT_ID CUSTOMER_ID VA_VENDOR_CODE contactenated with PayeeTypeCode and PayeeSeqeunce for a Vendor
PayeeAK
Source System
DWStaging
PayeeAK
Source Table
EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR
PayeeId
Display Name
PayeeId
PayeeId
ETL Rules
The payee id from the Source System
PayeeId
Example Values
3645, A00897165, FIR5150000
PayeeId
MS_Description
The Payee Id Number
PayeeId
SCD Type
1
PayeeId
Source Field Name
PERSON_ID STUDENT_ID CUSTOMER_ID VA_VENDOR_CODE
PayeeId
Source System
DWStaging
PayeeId
Source Table
EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR
PayeeName
Display Name
PayeeName
PayeeName
ETL Rules
Extracted from various files. Student, Employee and Non-Employee will compress last name, first name and middle initial. Convert
PayeeName
Example Values
Cowan, Sophia
PayeeName
MS_Description
The name of the Payee
PayeeName
SCD Type
1
PayeeName
Source Field Name
VA_MAILING_ADDRESS_NAME
PayeeName
Source System
DWStaging
PayeeName
Source Table
EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR
PayeeNameConsolidated
Display Name
PayeeNameConsolidated
PayeeNameConsolidated
ETL Rules
Extracted from various files. Student, Employee and Non-Employee will compress last name, first name and middle initial. Convert
PayeeNameConsolidated
Example Values
AT&T
PayeeNameConsolidated
MS_Description
The name of the Payee. In case of Vendors, this will be the Vendor Name, not the name on the Address Sequence
PayeeNameConsolidated
SCD Type
1
PayeeNameConsolidated
Source Field Name
VENDOR_NAME
PayeeNameConsolidated
Source System
DWStaging
PayeeNameConsolidated
Source Table
EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR
PayeeSequence
Display Name
PayeeSequence
PayeeSequence
ETL Rules
Extracted from Vendor
PayeeSequence
Example Values
1
PayeeSequence
MS_Description
The sequence number of payees that are vendors
PayeeSequence
SCD Type
1
PayeeSequence
Source Field Name
VA_VENDOR_SEQ_NBR
PayeeSequence
Source System
DWStaging
PayeeSequence
Source Table
EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR
PayeeSK
Display Name
PayeeSK
PayeeSK
Example Values
1, 2, 3?
PayeeSK
MS_Description
Surrogate primary key
PayeeSK
SCD Type
key
PayeeSK
Source System
Derived
PayeeType
Display Name
PayeeType
PayeeType
ETL Rules
Extracted from the UTL_CODE_TABLE_FILE, table name PAYEETYPE Convert to Upper/Lower case
PayeeType
Example Values
Employee, Non-Employee
PayeeType
MS_Description
The type of Payee
PayeeType
SCD Type
1
PayeeType
Source System
DWStaging
PayeeType
Source Table
UTL_CODE_TABLE_FILE. Table PAYEE_TYPE
PayeeTypeCode
Display Name
PayeeTypeCode
PayeeTypeCode
Example Values
N, E, V, C, S
PayeeTypeCode
MS_Description
The code associated with the Payee Type
PayeeTypeCode
SCD Type
1
PayeeTypeCode
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
State
Display Name
State
State
ETL Rules
Extracted from the UTL_CODE_TABLE_FILE, table name STATE Convert to Upper/Lower case
State
Example Values
Florida
State
MS_Description
The state associated with the Payee Address
State
SCD Type
1
State
Source Field Name
DESCRIPTION
State
Source System
DWStaging
State
Source Table
UTL_COE_TABLE_FILE
StateCode
Display Name
StateCode
StateCode
ETL Rules
For Vendors, this is first Pay Address Sequence. For Customers we get the BA address, if that does not exist, the AD address and
StateCode
Example Values
FL
StateCode
MS_Description
The state abbreviation of the Payee Address
StateCode
SCD Type
1
StateCode
Source Field Name
STATE_CODE, VA_STATE, STATE
StateCode
Source System
DWStaging
StateCode
Source Table
EMPLOYEE_A_ADDRESS_INFO, NON_EMPLOYEE_A_ADDRESS_INFO, FIP_VENDOR_VA_ADDRESS_LINE, ST_ADDRESSES_A, AR_CUSTOMER_A_ADDRESS_DETAILS
ZipCode
Display Name
ZipCode
ZipCode
ETL Rules
Follow the same rules as for StateCode
ZipCode
Example Values
33308
ZipCode
MS_Description
The zip code associated with the Payee Address
ZipCode
SCD Type
1
ZipCode
Source Field Name
VA_ZIP, ZIP_CODE, ZIP_CD
ZipCode
Source System
DWStaging
ZipCode
Source Table
EMPLOYEE_A_ADDRESS_INFO, NON_EMPLOYEE_A_ADDRESS_INFO, FIP_VENDOR_VA_ADDRESS_LINE, ST_ADDRESSES_A, AR_CUSTOMER_A_ADDRESS_DETAILS
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimPayee] Script Date: 03/09/2017 17:14:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimPayee](
    [PayeeSK] [int] IDENTITY(1,1) NOT NULL,
    [PayeeAK] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeSequence] [smallint] NOT NULL,
    [PayeeTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayeeNameConsolidated] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [IsMinority] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StateCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [State] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ZipCode] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Country] [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.DimPayee] PRIMARY KEY CLUSTERED 
(
    [PayeeSK] 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'Payee' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'This table will contain a row for each possible Payee in the system. Data will be extracted from ST-STDNT, EMPLOYEE-A, NON-EMPLO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee'


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Follow the same rules as for StateCode, Use COUNTRY-ST table on UTL_CODE_TABLE to get country name' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'Country'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'United States, Canada' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'Country'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The country that is associated with the Payee Address' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'Country'


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


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'Derived for CUSTOMER, COUNTRY_CODE, CNTRY, VA_COUNTRY' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'Country'


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'EMPLOYEE_A_ADDRESS_INFO, NON_EMPLOYEE_A_ADDRESS_INFO, FIP_VENDOR_VA_ADDRESS_LINE, ST_ADDRESSES_A, AR_CUSTOMER_A_ADDRESS_DETAILS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'Country'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from Vendor Only, set to Unkown for Student, Employee, Customer and Non-Employees. For Vendors, Join the Vendor Addres' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'IsMinority'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Yes, No, Unknown' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'IsMinority'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicate if the Payee has indicated they are a minority' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'IsMinority'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'This field should be concatenated with the PayeeTypeCode. For Employees this will be E and the PersonId with 0''s added before ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeAK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'V FIR516000001' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeAK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business Key for the Payee. This will be a combination of Payee Type, Payee Id and Payee Seq ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeAK'


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


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PERSON_ID STUDENT_ID CUSTOMER_ID VA_VENDOR_CODE contactenated with PayeeTypeCode and PayeeSeqeunce for a Vendor' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeAK'


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeAK'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The payee id from the Source System' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeId'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'3645, A00897165, FIR5150000' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeId'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Payee Id Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeId'


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


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PERSON_ID STUDENT_ID CUSTOMER_ID VA_VENDOR_CODE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeId'


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeId'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from various files. Student, Employee and Non-Employee will compress last name, first name and middle initial. Convert' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeName'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Cowan, Sophia' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeName'


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeName'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from various files. Student, Employee and Non-Employee will compress last name, first name and middle initial. Convert' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeNameConsolidated'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'AT&T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeNameConsolidated'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the Payee. In case of Vendors, this will be the Vendor Name, not the name on the Address Sequence' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeNameConsolidated'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeNameConsolidated'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from Vendor' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeSequence'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The sequence number of payees that are vendors' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeSequence'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'EMPLOYEE_A NON_EMPLOYEE_A ST_STDNT_A AR_CUSTOMER_A FIP_VENDOR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeSequence'


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


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


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Employee, Non-Employee' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeType'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The type of Payee' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeType'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE. Table PAYEE_TYPE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeType'


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'N, E, V, C, S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeTypeCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code associated with the Payee Type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'PayeeTypeCode'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Florida' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'State'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The state associated with the Payee Address' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'State'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'For Vendors, this is first Pay Address Sequence. For Customers we get the BA address, if that does not exist, the AD address and' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'StateCode'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'FL' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'StateCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The state abbreviation of the Payee Address' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'StateCode'


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


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'STATE_CODE, VA_STATE, STATE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'StateCode'


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'EMPLOYEE_A_ADDRESS_INFO, NON_EMPLOYEE_A_ADDRESS_INFO, FIP_VENDOR_VA_ADDRESS_LINE, ST_ADDRESSES_A, AR_CUSTOMER_A_ADDRESS_DETAILS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'StateCode'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Follow the same rules as for StateCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'ZipCode'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'33308' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'ZipCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The zip code associated with the Payee Address' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'ZipCode'


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


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'VA_ZIP, ZIP_CODE, ZIP_CD' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'ZipCode'


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'EMPLOYEE_A_ADDRESS_INFO, NON_EMPLOYEE_A_ADDRESS_INFO, FIP_VENDOR_VA_ADDRESS_LINE, ST_ADDRESSES_A, AR_CUSTOMER_A_ADDRESS_DETAILS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimPayee', @level2type=N'COLUMN',@level2name=N'ZipCode'
  Sample Data
Country IsMinority PayeeAK PayeeId PayeeName PayeeNameConsolidated PayeeSequence PayeeSK PayeeType PayeeTypeCode RowEndDate RowIsCurrent RowStartDate State StateCode ZipCode
United States Unknown SA06135800 A06135800 Collins, Alyse Collins, Alyse 0 578894 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33403
United States Unknown SC11038858 C11038858 Lee, Cheryl Ann Lee, Cheryl Ann 0 727639 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33436
United States Unknown SR14265201 R14265201 Jaramillo, Ruth Jaramillo, Ruth 0 1341325 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33469
United States Unknown SV13257464 V13257464 Villa, Veronica Villa, Veronica 0 1463364 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33463
United States Unknown SB06263818 B06263818 Gladwell, Brian Scott Gladwell, Brian Scott 0 652442 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33431
United States Unknown SA11869443 A11869443 Kahn, Alexander T Kahn, Alexander T 0 615682 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 32608
United States Unknown SB08160509 B08160509 Wilson, Brian Christophe Wilson, Brian Christophe 0 660930 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33428
United States Unknown SS11858222 S11858222 Madey, Sean Joseph Madey, Sean Joseph 0 1390543 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33428
United States Unknown SJ11126901 J11126901 Klinsport, Jillynn Christine Klinsport, Jillynn Christine 0 987985 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33444
United States Unknown SG11622446 G11622446 Henry, Gregory William Henry, Gregory William 0 890731 Student S 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:04:00-05:00 Florida FL 33486
Powered by BI Documenter