B Retail Insights Attributes and Physical Mappings

This appendix contains the list of attributes that exist in Retail Insights and their physical mappings to the Dimension tables (_D tables). For any custom attributes that are built as part of a customization, please map to the columns that are not used in this list.

Attributes and Physical Mappings List

Table B-1 Attributes and Physical Mappings

DIMENSION	OBIEE_ATTR_NAME	PHYSICAL_COL_NAME	TABLE_NAME	FILTER_CONDITION
Cluster	Cluster Group Code	CLSTR_GRP_CODE	W_RTL_CLSTR_GRP_D	N/A
Cluster	Cluster Code	CLSTR_HDR_CODE	W_RTL_CLSTR_HDR_D	N/A
Cluster	Primary Age Class	PRMY_AGE_CLASS	W_RTL_CLSTR_HDR_D	N/A
Cluster	Primary Income Level	PRMY_INCOME_LVL	W_RTL_CLSTR_HDR_D	N/A
Cluster	Cluster Description	CLSTR_HDR_DESC	W_RTL_CLSTR_HDR_D	N/A
Consumer Group	Consumer Segment Name	CONSEG_NAME	W_RTL_CONSUMERSEG_D	N/A
Consumer Group	Consumer Segment Type	CONSEG_TYPE	W_RTL_CONSUMERSEG_D	N/A
Consumer Group	Family Size	FAMILY_SIZE	W_RTL_CONSUMERSEG_D	N/A
Consumer Household Group	Composition Group Indicator	HH_COMPOSITION_IND	W_RTL_HOUSEHOLD_COMP_D	N/A
Consumer Household Group	Household Size	HG_SIZE	W_RTL_HOUSEHOLD_GRP_D	N/A
Consumer Household Group	Presence of Children	HG_PRESENCE_OF_CHILDREN	W_RTL_HOUSEHOLD_GRP_D	N/A
Consumer Household Group	Hispanic Household	HISPANIC_FLG	W_RTL_HOUSEHOLD_GRP_D	N/A
Consumer Household Group	Household Head Age Level	HG_AGE_LEVEL	W_RTL_HOUSEHOLD_GRP_D	N/A
Customer	Address ID	ADDRESS_ID	W_RTL_CUST_ADDRESS_D	N/A
Customer	Age	EXTRACT( YEAR FROM CURRENT_DATE ) - W_PARTY_PER_D.CUSTOMER_BIRTH_YEAR	W_PARTY_PER_D	N/A
Customer	Age Range	CASE WHEN EXTRACT( YEAR FROM CURRENT_DATE ) - W_PARTY_PER_D.CUSTOMER_BIRTH_YEAR BETWEEN 15 AND 19 THEN '15 - 19' WHEN EXTRACT( YEAR FROM CURRENT_DATE ) - W_PARTY_PER_D.CUSTOMER_BIRTH_YEAR BETWEEN 20 AND 28 THEN '20 - 28' WHEN EXTRACT( YEAR FROM CURRENT_DATE ) - W_PARTY_PER_D.CUSTOMER_BIRTH_YEAR BETWEEN 29 AND 37 THEN '29 - 37' WHEN EXTRACT( YEAR FROM CURRENT_DATE ) - W_PARTY_PER_D.CUSTOMER_BIRTH_YEAR BETWEEN 38 AND 50 THEN '38 - 50' WHEN EXTRACT( YEAR FROM CURRENT_DATE ) - W_PARTY_PER_D.CUSTOMER_BIRTH_YEAR BETWEEN 51 AND 65 THEN '51 - 65' ELSE '66 and above' END	W_PARTY_PER_D	N/A
Customer	Annual Income	ANNL_INCOME	W_PARTY_PER_D	N/A
Customer	Churn Score	CHURN_SCORE	W_PARTY_PER_D	N/A
Customer	Churn Score Range	CASE WHEN CHURN_SCORE < 21 THEN '0-20' WHEN CHURN_SCORE < 41 THEN '21-40' WHEN CHURN_SCORE < 61 THEN '41-60' WHEN CHURN_SCORE < 81 THEN '61-80' WHEN CHURN_SCORE < 101 THEN '81-100' ELSE 'Unspecified' END	W_PARTY_PER_D	N/A
Customer	Churn Score Range Sort	CASE WHEN CHURN_SCORE < 21 THEN 1 WHEN CHURN_SCORE < 41 THEN 2 WHEN CHURN_SCORE < 61 THEN 3 WHEN CHURN_SCORE < 81 THEN 4 WHEN CHURN_SCORE < 101 THEN 5 ELSE 6 END	W_PARTY_PER_D	N/A
Customer	City	CITY_NAME	W_RTL_CUST_ADDRESS_D	N/A
Customer	Country	COUNTRY_NAME	W_RTL_CUST_ADDRESS_D	N/A
Customer	Customer Address Class Code	ADDRESS_CLASS_CODE	W_RTL_CUST_ADDRESS_D	N/A
Customer	Customer Address Type Code	ADDRESS_TYPE_CODE	W_RTL_CUST_ADDRESS_D	N/A
Customer	Customer Birth Month	CUSTOMER_BIRTH_MONTH	W_PARTY_PER_D	N/A
Customer	Customer Birth Year	CUSTOMER_BIRTH_YEAR	W_PARTY_PER_D	N/A
Customer	Customer Income Band	ANNL_INCOME_RANGE	W_PARTY_PER_D	N/A
Customer	Customer Individual Gender Code	SEX_MF_CODE	W_PARTY_PER_D	N/A
Customer	Customer Individual Marital State Code	MARITAL_STAT_CODE	W_PARTY_PER_D	N/A
Customer	Customer Number	CUSTOMER_NUM	W_PARTY_PER_D	N/A
Customer	Customer Primary City	CITY_NAME	W_PARTY_PER_D	N/A
Customer	Customer Primary Country	COUNTRY_NAME	W_PARTY_PER_D	N/A
Customer	Customer Primary Postal Code	POSTAL_CODE	W_PARTY_PER_D	N/A
Customer	Customer Primary State	STATE_NAME	W_PARTY_PER_D	N/A
Customer	Customer Primary State Code	STATE_CODE	W_PARTY_PER_D	N/A
Customer	Customer Status Code	CUST_STATUS_CODE	W_PARTY_PER_D	N/A
Customer	Customer Type	PARTY_TYPE_CODE	W_PARTY_PER_D	N/A
Customer	Education Background Code	EDUCATION_BCKGND_CODE	W_PARTY_PER_D	N/A
Customer	Ethnicity Code	ETHNICITY_CODE	W_PARTY_PER_D	N/A
Customer	Frequency Category Code	FREQUENCY_CAT_CODE	W_PARTY_PER_D	N/A
Customer	Monetary Category Code	MONETARY_CAT_CODE	W_PARTY_PER_D	N/A
Customer	Nationality Code	NATIONALITY	W_PARTY_PER_D	N/A
Customer	Occupation Code	INS_OCCUPATION	W_PARTY_PER_D	N/A
Customer	Opt Out Flag	OPT_OUT_FLG	W_PARTY_PER_D	N/A
Customer	Postal Code	POSTAL_CODE	W_RTL_CUST_ADDRESS_D	N/A
Customer	Primary Address Flag	PRIMARY_ADDRESS_FLG	W_RTL_CUST_ADDRESS_D	N/A
Customer	Prospect Flag	PROSPECT_FLG	W_PARTY_PER_D	N/A
Customer	Recency Category Code	RECENCY_CAT_CODE	W_PARTY_PER_D	N/A
Customer	RFM Categories Code	RFM_CAT_CODE	W_PARTY_PER_D	N/A
Customer	State	STATE_NAME	W_RTL_CUST_ADDRESS_D	N/A
Customer	State Code	STATE_CODE	W_RTL_CUST_ADDRESS_D	N/A
Customer	Years at Address	YEAR_AT_ADDRESS	W_RTL_CUST_ADDRESS_D	N/A
Customer	Dwelling Status	DWELLING_STATUS	W_RTL_CUST_ADDRESS_D	N/A
Customer	Dwelling Size	DWELLING_SIZE	W_RTL_CUST_ADDRESS_D	N/A
Customer	Dwelling Tenure	DWELLING_TENURE	W_RTL_CUST_ADDRESS_D	N/A
Customer	Dwelling Type	DWELLING_TYPE	W_RTL_CUST_ADDRESS_D	N/A
Customer	Activity Code	ACTIVITY_CODE	W_PARTY_PER_D	N/A
Customer	Activity Code	ATTITUDE_CODE	W_PARTY_PER_D	N/A
Customer	Benefit Sought Code	BENEFIT_SOUGHT_CODE	W_PARTY_PER_D	N/A
Customer	Climate Code	CLIMATE_CODE	W_PARTY_PER_D	N/A
Customer	Customer Lifetime Value Code	CUST_LIFETIME_VALUE_CODE	W_PARTY_PER_D	N/A
Customer	Customer Lifetime Value	CUST_LIFETIME_VALUE	W_PARTY_PER_D	N/A
Customer	Customer Profitability Code	CUST_PROFITABILITY_CODE	W_PARTY_PER_D	N/A
Customer	Family Lifecycle Code	FAMILY_LIFE_CYCL_CODE	W_PARTY_PER_D	N/A
Customer	Interest Code	INTEREST_CODE	W_PARTY_PER_D	N/A
Customer	Occasion Code	OCCASION_CODE	W_PARTY_PER_D	N/A
Customer	Opinion Code	OPINION_CODE	W_PARTY_PER_D	N/A
Customer	Religion Code	RELIGION_CODE	W_PARTY_PER_D	N/A
Customer	Readiness To Buy Code	READINESS_TO_BUY_CODE	W_PARTY_PER_D	N/A
Customer	Social Class Code	SOCIAL_CLASS_CODE	W_PARTY_PER_D	N/A
Customer	Hours Worked	HOURS_WORKED	W_PARTY_PER_D	N/A
Customer	Age of Kids	KIDS_AGE_GROUP	W_PARTY_PER_D	N/A
Customer	Metro Area Size	METRO_AREA_SIZE	W_PARTY_PER_D	N/A
Customer	Population Density	POPULATION_DENSITY	W_PARTY_PER_D	N/A
Customer	No of Teens	TEEN_NUM	W_PARTY_PER_D	N/A
Customer	Usage Rate	USAGE_RATE	W_PARTY_PER_D	N/A
Customer	Years Primary Store	YEARS_PRIMARY_STORE	W_PARTY_PER_D	N/A
Customer Segment	Customer Segment ID	CUSTSEG_ID	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Name	CUSTSEG_NAME	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Type	CUSTSEG_TYPE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Age Range	AGE_RANGE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Gender Code	SEX_MF_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Family Size	FAMILY_SIZE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Generation Code	GENERATION_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Annual Income Range	ANNL_INCOME_RANGE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Occupation Code	OCCUPATION_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Education Background Code	EDUCATION_BCKGND_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Ethnicity Code	ETHNICITY_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Nationality Code	NATIONALITY_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Religion Code	RELIGION_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Social Class Code	SOCAL_CLASS_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Family Lifecycle Code	FAMILY_LIFE_CYCL_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Region Code	REGION_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Metro Area Size	METRO_AREA_SIZE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Population Density	POPULATION_DENSITY	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Climate Code	CLIMATE_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Benefit Sought Code	BENEFIT_SOUGHT_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Usage Rate	USAGE_RATE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Readiness To Buy Code	READINESS_TO_BUY_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Occasion Code	OCCASION_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Activity Code	ACTIVITY_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Interest Code	INTEREST_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Opinion Code	OPINION_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Attitude Code	ATTITUDE_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Value Code	VALUE_CODE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Average Purchase	AVG_PURCHASE	W_RTL_CUSTSEG_BEHAVIOR_D	N/A
Customer Segment	Customer Segment Average Trip	AVG_TRIP	W_RTL_CUSTSEG_BEHAVIOR_D	N/A
Customer Segment	Customer Segment Average Transaction Count	AVG_TRX_CNT	W_RTL_CUSTSEG_BEHAVIOR_D	N/A
Customer Segment	Customer Segment Category Level Name	LEVEL_NAME	W_RTL_CUSTSEG_BEHAVIOR_D	N/A
Customer Segment	Customer Segment Total Trip	TOTAL_TRIP	W_RTL_CUSTSEG_BEHAVIOR_D	N/A
Customer Segment	Customer Segment Description	CUSTSEG_DESC	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Source Type	CUSTSEG_SRC_TYPE	W_RTL_CUSTSEG_D	N/A
Customer Segment	Customer Segment Org Level Name	ORG_HIER_KEY	W_RTL_CUSTSEG_D	N/A
Household	Household Class Id	CUST_HOUSEHOLD_CLASS	W_RTL_CUST_HOUSEHOLD_D	N/A
Household	Household Income group	HH_INCOME_GRP	W_HOUSEHOLD_D	N/A
Household	Household size	HG_SIZE	W_RTL_HOUSEHOLD_GRP_D	N/A
Household	Income	HH_INCOME	W_HOUSEHOLD_D	N/A
Household	Number of Dependents	DEPENDS_NUM	W_HOUSEHOLD_D	N/A
Household	Number of Adults	ADULTS_NUM	W_HOUSEHOLD_D	N/A
Household	Number of Children	CHILDREN_NUM	W_HOUSEHOLD_D	N/A
Household	Number of Seniors	SENIOR_NUM	W_HOUSEHOLD_D	N/A
Household	Number of Teens	TEEN_NUM	W_HOUSEHOLD_D	N/A
Customer Segment Loyalty	Seg Dept Loyalty Score	LOY_SCORE	W_RTL_LOY_CUSTSEG_DP_LC_WK_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Seg Class Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Seg Dept Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Seg Class Loyalty Score	LOY_SCORE	W_RTL_LOY_CUSTSEG_CL_LC_WK_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Seg Dept Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUSTSEG_DP_LC_WK_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Seg Dept Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Seg Class Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUSTSEG_CL_LC_WK_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Seg Class Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Seg Subclass Loyalty Score	LOY_SCORE	W_RTL_LOY_CUSTSEG_SC_LC_WK_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Seg Subclass Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Seg Subclass Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUSTSEG_SC_LC_WK_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Seg Subclass Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Seg Style Brand Loyalty Score	LOY_SCORE	W_RTL_LOY_CUSTSEG_LC_WK_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Seg Style Brand Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Seg Style Brand Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUSTSEG_LC_WK_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Seg Style Brand Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Dept Business Month Loyalty Score	LOY_SCORE	W_RTL_LOY_CUST_DP_LC_MH_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Dept Business Month Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Dept Business Month Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUST_DP_LC_MH_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Dept Business Month Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Class Business Month Loyalty Score	LOY_SCORE	W_RTL_LOY_CUST_CL_LC_MH_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Class Business Month Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Class Business Month Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUST_CL_LC_MH_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Class Business Month Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Style Business Month Brand Loyalty Score	LOY_SCORE	W_RTL_LOY_CUST_LC_MH_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Style Business Month Brand Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Style Business Month Brand Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUST_LC_MH_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Style Business Month Brand Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Class Greg Month Loyalty Score	LOY_SCORE	W_RTL_LOY_CUST_CL_LC_MH_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Class Greg Month Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Class Greg Month Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUST_CL_LC_MH_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Class Greg Month Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Dept Greg Month Loyalty Score	LOY_SCORE	W_RTL_LOY_CUST_DP_LC_MH_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Dept Greg Month Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Dept Greg Month Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUST_DP_LC_MH_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Dept Greg Month Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Style Greg Month Brand Loyalty Score	LOY_SCORE	W_RTL_LOY_CUST_LC_MH_F	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Style Greg Month Brand Loyalty Score Range	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID= -1
Customer Segment Loyalty	Cust Style Greg Month Brand Loyalty Score by Promo	LOY_SCORE	W_RTL_LOY_CUST_LC_MH_F	PROMO_COMPONENT_TYPE_WID<> -1
Customer Segment Loyalty	Cust Style Greg Month Brand Loyalty Score Range by Promo	LOY_SCORE_DESC	W_RTL_LOY_SCORE_BAND_D	PROMO_COMPONENT_TYPE_WID<> -1
Market Item	Market Item Description	MARKET_PROD_NAME	W_RTL_MARKET_PRODUCT_D_TL	CURRENT_FLG = 'Y'
Market Item	Market Item Brand	MARKET_PROD_BRAND_DESC	W_RTL_MARKET_PROD_BRAND_D_TL	MARKET_PROD_GRP_TYPE='BRAND'
Market Item	Market Sub Brand	MARKET_PROD_SUB_BRAND_DESC	W_RTL_MARKET_PROD_BRAND_D_TL	MARKET_PROD_GRP_TYPE='BRAND'
Market Item	Market Brand Owner	MARKET_BRAND_OWNER_DESC	W_RTL_MARKET_PROD_BRAND_D_TL	MARKET_PROD_GRP_TYPE='BRAND'
Market Item	Market Brand Owner Number	MARKET_BRAND_OWNER_NUM	W_RTL_MARKET_PROD_BRAND_D	MARKET_PROD_GRP_TYPE='BRAND'
Market Item	Multi Pack	MULTI_PACK	W_RTL_MARKET_PRODUCT_D	CURRENT_FLG = 'Y'
Market Item	Universal Prod Code	case when W_RTL_MARKET_PRODUCT_D.MARKET_PROD_LVL_NAME = 'UPC' then W_RTL_MARKET_PRODUCT_D.MARKET_PROD_NUM end	W_RTL_MARKET_PRODUCT_D	N/A
Organization Customer	Annual Revenue	ANNUAL_REVENUE	W_PARTY_ORG_D	N/A
Organization Customer	Base Currency Code	BASE_CURCY_CD	W_PARTY_ORG_D	N/A
Organization Customer	Competitor Flag	COMPETITOR_FLG	W_PARTY_ORG_D	N/A
Organization Customer	Customer Category code	CUST_CAT_CODE	W_PARTY_ORG_D	N/A
Organization Customer	Customer Since Date	CUST_SINCE_DT	W_PARTY_ORG_D	N/A
Organization Customer	DUNS Number	DUNS_NUM	W_PARTY_ORG_D	N/A
Organization Customer	Govt ID Type	GOVT_ID_TYPE	W_PARTY_ORG_D	N/A
Organization Customer	Govt ID Value	GOVT_ID_VALUE	W_PARTY_ORG_D	N/A
Organization Customer	Internet home page	INTERNET_HOME_PAGE	W_PARTY_ORG_D	N/A
Organization Customer	Line of Business	LINE_OF_BUSINESS	W_PARTY_ORG_D	N/A
Organization Customer	Organization Size Code	ORG_SIZE_CODE	W_PARTY_ORG_D	N/A
Organization Customer	Prospect Flag	PROSPECT_FLG	W_PARTY_PER_D	N/A
Organization Customer	Partner Flag	PRTNR_FLG	W_PARTY_ORG_D	N/A
Organization Customer	Potential Sales Volume	PTNTL_SLS_VOL	W_PARTY_ORG_D	N/A
Organization Customer	Sales Account Flag	SALES_ACCNT_FLG	W_PARTY_ORG_D	N/A
Organization Customer	Sales Account Type Code	SALES_ACCNT_TYPE_CODE	W_PARTY_ORG_D	N/A
Organization Customer	Sales Ref Flag	SALES_REF_FLG	W_PARTY_ORG_D	N/A
Organization Customer	SIC Code	SIC_CODE	W_PARTY_ORG_D	N/A
Organization Customer	Service Provider Flag	SRV_PROVDR_FLG	W_PARTY_ORG_D	N/A
Organization Customer	Supplier Flag	SUPPLIER_FLG	W_PARTY_ORG_D	N/A
Organization Customer	Supplier ID	SUPPLIER_ID	W_PARTY_ORG_D	N/A
Organization Customer	Existing Sales Account Flag	EXIST_SALES_ACCNT_FLG	W_PARTY_ORG_D	N/A
Organization Customer	Customer Type Code	CUST_TYPE_CODE	W_PARTY_ORG_D	N/A
Organization Customer	Customer Type	PARTY_TYPE_CODE	W_PARTY_PER_D	N/A
Organization Customer	Customer Number	CUSTOMER_NUM	W_PARTY_PER_D	N/A
Trade Area	Trade Area Type	TRADE_AREA_TYPE	W_RTL_TRADE_AREA_D	N/A
Trade Area	Commuter Population	COMMUTER_POPULATION	W_RTL_TRADE_AREA_D	N/A
Trade Area	Peak Season Population	PEAK_SEASON_POPULATION	W_RTL_TRADE_AREA_D	N/A
Trade Area	Tourist Population	TOURIST_POPULATION	W_RTL_TRADE_AREA_D	N/A
Trade Area	State Population	STATE_POPULATION	W_RTL_TRADE_AREA_D	N/A
Trade Area	Number Of Households	HOUSEHOLD_COUNT	W_RTL_TRADE_AREA_D	N/A
Trade Area	Average Family Size	AVG_FAMILY_SIZE	W_RTL_TRADE_AREA_D	N/A
Trade Area	Per Capita Income	PER_CAPITA_INCOME	W_RTL_TRADE_AREA_D	N/A
Trade Area	Average Number Of Vehicles	AVG_NUM_OF_VEHICLES	W_RTL_TRADE_AREA_D	N/A
Trade Area	Average Drive Time	AVERAGE_DRIVE_TIME	W_RTL_TRADE_AREA_D	N/A
Trade Area	Pull Factor	PULL_FACTOR	W_RTL_TRADE_AREA_D	N/A
Fiscal Calender	Fiscal Period	MCAL_PERIOD_NAME	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Year Number	MCAL_YEAR	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Year	MCAL_PER_NAME_YEAR	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Year Start Date	MCAL_YEAR_START_DT	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Year End Date	MCAL_YEAR_END_DT	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Half Year	MCAL_PER_NAME_HALF	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Quarter	MCAL_PER_NAME_QTR	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Period Start Date	MCAL_PERIOD_START_DT	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Period End Date	MCAL_PERIOD_END_DT	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Week	MCAL_PERIOD_NAME_WEEK	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Week Start Date	MCAL_WEEK_START_DT	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Week End Date	MCAL_WEEK_END_DT	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Day Name	MCAL_CAL_NAME	W_MCAL_DAY_D	N/A
Fiscal Calender	Fiscal Date	MCAL_DAY_DT	W_MCAL_DAY_D	N/A
Customer Order	CO Header Number	CO_HEAD_ID	W_RTL_CO_HEAD_D	N/A
Customer Order	CO Line Number	CO_LINE_ID	W_RTL_CO_LINE_D	N/A
Customer Order	Original Item Number	ORIGINAL_PROD_NUM	W_RTL_CO_LINE_D	N/A
Customer Order	CO Line Original Item	PRODUCT_NAME	W_PRODUCT_D_TL	N/A
Customer Order	CO Line Substitute Item	SUBSTITUTE_PROD_NUM	W_RTL_CO_LINE_D	N/A
Customer Order	Request Date	REQUEST_DT	W_RTL_CO_LINE_D	N/A
Customer Order	Bill Date	BILL_DATE	W_RTL_CO_LINE_D	N/A
Customer Order	Estimated Availability Date	EST_AVAIL_DT	W_RTL_CO_LINE_D	N/A
Customer Order	Tax Exempt Indicator	TAX_EXEMPT_IND	W_RTL_CO_LINE_D	N/A
Customer Order	Original Expected Date	ORIGINAL_DT	W_RTL_CO_LINE_D	N/A
Customer Order	Cancel Flag	CANCEL_FLG	W_RTL_CO_LINE_D	N/A
Customer Order	Partial Shipment Indicator	CO_PARTIAL_SHIPMENT_INDICATOR	W_RTL_CO_HEAD_D	N/A
Employee	Employee Name	FULL_NAME	W_EMPLOYEE_D	N/A
Employee	Employee Cashier Flag	CASHIER_FLG	W_EMPLOYEE_D	CASHIER_FLG ='Y'
Employee	Employee Sale Representative Flag	SALES_REP_FLG	W_EMPLOYEE_D	SALES_REP_FLG='Y'
Employee	Sales Person	FULL_NAME	W_EMPLOYEE_D	SALES_REP_FLG='Y'
Employee	Cashier	FULL_NAME	W_EMPLOYEE_D	CASHIER_FLG ='Y'
Employee	Customer Service Representative	FULL_NAME	W_EMPLOYEE_D	SERVICE_REP_FLG ='Y'
Gregorian Calendar	Year Number	CAL_YEAR	W_MCAL_DAY_D	N/A
Gregorian Calendar	Year	CAL_YEAR_NAME	W_MCAL_DAY_D	N/A
Gregorian Calendar	Year Start Date	CAL_YEAR_START_DT	W_MCAL_DAY_D	N/A
Gregorian Calendar	Year End Date	CAL_YEAR_END_DT	W_MCAL_DAY_D	N/A
Gregorian Calendar	Half Year	PER_NAME_HALF	W_QTR_D	N/A
Gregorian Calendar	Quarter	PER_NAME_QTR	W_QTR_D	N/A
Gregorian Calendar	Month	PER_NAME_MONTH	W_MONTH_D	N/A
Gregorian Calendar	Month Start Date	CAL_MONTH_START_DT	W_MCAL_DAY_D	N/A
Gregorian Calendar	Month End Date	CAL_MONTH_END_DT	W_MCAL_DAY_D	N/A
Gregorian Calendar	Week	CAL_WEEK_NAME	W_MCAL_DAY_D	N/A
Gregorian Calendar	Week Start Date	CAL_WEEK_START_DT	W_MCAL_DAY_D	N/A
Gregorian Calendar	Week End Date	CAL_WEEK_END_DT	W_MCAL_DAY_D	N/A
Gregorian Calendar	Day Name	MCAL_CAL_NAME	W_MCAL_DAY_D	N/A
Gregorian Calendar	Date	MCAL_DAY_DT	W_MCAL_DAY_D	N/A
Item	Class Number	LVL5ANC_PRODCAT_ID	W_PROD_CAT_DH	W_PROD_CAT_DH.LEVEL_NAME='CLS'
Item	Company Number	TOP_LVL_PRODCAT_ID	W_PROD_CAT_DH	W_PROD_CAT_DH.LEVEL_NAME='CMP'
Item	Department Number	LVL6ANC_PRODCAT_ID	W_PROD_CAT_DH	W_PROD_CAT_DH.LEVEL_NAME='DEPT'
Item	Diff ID	FLEX_ATTRIB_2_CHAR	W_RTL_ITEM_GRP1_D	W_RTL_ITEM_GRP1_D.PROD_GRP_TYPE = 'ITEMDIFF'
Item	Diff Type	FLEX_ATTRIB_1_CHAR	W_RTL_ITEM_GRP1_D	W_RTL_ITEM_GRP1_D.PROD_GRP_TYPE = 'ITEMDIFF'
Item	Division Number	LVL8ANC_PRODCAT_ID	W_PROD_CAT_DH	W_PROD_CAT_DH.LEVEL_NAME='DIV'
Item	Group Number	LVL7ANC_PRODCAT_ID	W_PROD_CAT_DH	W_PROD_CAT_DH.LEVEL_NAME='GRP'
Item	Item	PRODUCT_NAME	W_PRODUCT_D_TL	N/A
Item	Item Level	PRODUCT_ATTR11_NAME	W_PRODUCT_ATTR_D	N/A
Item	Item Level 1 Number	PRODUCT_ATTR13_NAME	W_PRODUCT_ATTR_D	N/A
Item	Item Level 2 Number	PRODUCT_ATTR14_NAME	W_PRODUCT_ATTR_D	N/A
Item	Item Level 3 Number	PRODUCT_ATTR15_NAME	W_PRODUCT_ATTR_D	N/A
Item	Item List ID	FLEX_ATTRIB_5_NUM	W_RTL_ITEM_GRP1_D	W_RTL_ITEM_GRP1_D.PROD_GRP_TYPE='ITEMLIST'
Item	Item Number	PROD_NUM	W_PRODUCT_D	N/A
Item	Merchandise Flag	PRODUCT_ATTR5_NAME	W_PRODUCT_ATTR_D	N/A
Item	Mfg Recommended Retail	PRODUCT_ATTR3_NUM_VALUE	W_PRODUCT_ATTR_D	N/A
Item	Original Retail	PRODUCT_ATTR2_NUM_VALUE	W_PRODUCT_ATTR_D	N/A
Item	Pack Desc	PRODUCT_NAME	W_PRODUCT_D_TL	PACK_FLG='Y'
Item	Pack Flag	PACK_FLG	W_PRODUCT_D	N/A
Item	Pack Number	PROD_NUM	W_PRODUCT_D	N/A
Item	Pack Orderable Number	PRODUCT_ATTR7_NAME	W_PRODUCT_ATTR_D	N/A
Item	Pack Sellable Number	PRODUCT_ATTR5_NAME	W_PRODUCT_ATTR_D	N/A
Item	Pack Simple Number	PRODUCT_ATTR6_NAME	W_PRODUCT_ATTR_D	N/A
Item	Package Size	PRODUCT_ATTR8_NAME	W_PRODUCT_ATTR_D	N/A
Item	Package UOM	PRODUCT_ATTR9_NAME	W_PRODUCT_ATTR_D	N/A
Item	Retail Zone Group ID	PRODUCT_ATTR1_NUM_VALUE	W_PRODUCT_ATTR_D	N/A
Item	Subclass Number	LVL4ANC_PRODCAT_ID	W_PROD_CAT_DH	W_PROD_CAT_DH.LEVEL_NAME='SBC'
Item	Transaction Level	PRODUCT_ATTR12_NAME	W_PRODUCT_ATTR_D	N/A
Item	UDA Detail ID	FLEX_ATTRIB_3_CHAR	W_RTL_ITEM_GRP1_D	W_RTL_ITEM_GRP1_D.PROD_GRP_TYPE = 'ITEMUDA'
Item	UDA Head ID	FLEX_ATTRIB_1_CHAR	W_RTL_ITEM_GRP1_D	W_RTL_ITEM_GRP1_D.PROD_GRP_TYPE = 'ITEMUDA'
Item	Color ID	COLOR_ID	W_RTL_PRODUCT_COLOR_D	N/A
Item	Sub Color ID	SUBCOLOR_ID	W_RTL_PRODUCT_COLOR_D	N/A
Item	Sub Brand ID	SUB_BRAND_ID	W_RTL_PRODUCT_BRAND_D	N/A
Item	Brand ID	BRAND_ID	W_RTL_PRODUCT_BRAND_D	N/A
Item	Fabric ID	PROD_ATTR_ID	W_RTL_PRODUCT_ATTR_D	PROD_ATTR_TYPE"='FABRIC'
Item	Flavor ID	PROD_ATTR_ID	W_RTL_PRODUCT_ATTR_D	PROD_ATTR_TYPE"='FLAVOR'
Item	Scent ID	PROD_ATTR_ID	W_RTL_PRODUCT_ATTR_D	PROD_ATTR_TYPE"='SCENT'
Item	Style ID	PROD_ATTR_ID	W_RTL_PRODUCT_ATTR_D	PROD_ATTR_TYPE"='STYLE'
Item	Sub Brand	BRAND_DESCR	W_RTL_PRODUCT_BRAND_D_TL	N/A
Item	Brand	SUB_BRAND_DESCR	W_RTL_PRODUCT_BRAND_D_TL	N/A
Item	Item Diff Agg ID	PROD_AGG_ID	W_RTL_PRODUCT_AGGR_D	W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='STYLE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SCENT' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SIZE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FLAVOR' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FABRIC' AND W_RTL_PRODUCT_BRAND_D.LEVEL_NAME='B' AND W_RTL_PRODUCT_COLOR_D . LEVEL_NAME='C'
Item	Size ID Item Diff Agg	PROD_ATTR_ID	W_RTL_PRODUCT_ATTR_D	W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='STYLE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SCENT' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SIZE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FLAVOR' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FABRIC' AND W_RTL_PRODUCT_BRAND_D.LEVEL_NAME='B' AND W_RTL_PRODUCT_COLOR_D . LEVEL_NAME='C'
Item	Style ID Item Diff Agg	PROD_ATTR_ID	W_RTL_PRODUCT_ATTR_D	W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='STYLE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SCENT' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SIZE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FLAVOR' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FABRIC' AND W_RTL_PRODUCT_BRAND_D.LEVEL_NAME='B' AND W_RTL_PRODUCT_COLOR_D . LEVEL_NAME='C'
Item	Scent ID Item Diff Agg	PROD_ATTR_ID	W_RTL_PRODUCT_ATTR_D	W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='STYLE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SCENT' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SIZE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FLAVOR' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FABRIC' AND W_RTL_PRODUCT_BRAND_D.LEVEL_NAME='B' AND W_RTL_PRODUCT_COLOR_D . LEVEL_NAME='C'
Item	Fabric ID Item Diff Agg	PROD_ATTR_ID	W_RTL_PRODUCT_ATTR_D	W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='STYLE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SCENT' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SIZE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FLAVOR' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FABRIC' AND W_RTL_PRODUCT_BRAND_D.LEVEL_NAME='B' AND W_RTL_PRODUCT_COLOR_D . LEVEL_NAME='C'
Item	Flavor ID Item Diff Agg	PROD_ATTR_ID	W_RTL_PRODUCT_ATTR_D	W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='STYLE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SCENT' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SIZE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FLAVOR' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FABRIC' AND W_RTL_PRODUCT_BRAND_D.LEVEL_NAME='B' AND W_RTL_PRODUCT_COLOR_D . LEVEL_NAME='C'
Item	Brand ID Item Diff Agg	BRAND_ID	W_RTL_PRODUCT_BRAND_D	W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='STYLE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SCENT' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SIZE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FLAVOR' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FABRIC' AND W_RTL_PRODUCT_BRAND_D.LEVEL_NAME='B' AND W_RTL_PRODUCT_COLOR_D . LEVEL_NAME='C'
Item	Color ID Item Diff Agg	COLOR_ID	W_RTL_PRODUCT_COLOR_D	W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='STYLE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SCENT' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='SIZE' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FLAVOR' AND W_RTL_PRODUCT_ATTR_D . PROD_ATTR_TYPE='FABRIC' AND W_RTL_PRODUCT_BRAND_D.LEVEL_NAME='B' AND W_RTL_PRODUCT_COLOR_D . LEVEL_NAME='C'
Organization	Address Line 1	ST_ADDRESS1	W_INT_ORG_D	N/A
Organization	Address Line 2	ST_ADDRESS2	W_INT_ORG_D	N/A
Organization	Address Line 3	ORG_ATTR53_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Address Type	ORG_ATTR2_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Area Mgr	ORG_HIER12_MGR	W_INT_ORG_DH	N/A
Organization	Area Number	ORG_HIER12_NUM	W_INT_ORG_DH	N/A
Organization	Banner	BANNER_NAME	W_RTL_CHANNEL_D	N/A
Organization	Banner ID	BANNER_ID	W_RTL_CHANNEL_D	N/A
Organization	Break Pack Flag	ORG_ATTR8_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Chain Mgr	ORG_HIER13_MGR	W_INT_ORG_DH	N/A
Organization	Chain Number	ORG_HIER13_NUM	W_INT_ORG_DH	N/A
Organization	Channel ID	CHANNEL_ID	W_RTL_CHANNEL_D	N/A
Organization	Channel Type	ORG_ATTR5_NUM_VALUE	W_RTL_CHANNEL_D	N/A
Organization	City	CITY_CODE	W_INT_ORG_D	N/A
Organization	Comp Flag	COMP_FLG	W_RTL_LOC_WK_D	N/A
Organization	Company Number	ORG_TOP_NUM	W_INT_ORG_DH	N/A
Organization	Country	ORG_ATTR46_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Currency Code	W_CURR_CODE	W_INT_ORG_D	N/A
Organization	Default WH ID	ORG_ATTR20_NAME	W_INT_ORG_ATTR_D	N/A
Organization	District Mgr	ORG_HIER10_MGR	W_INT_ORG_DH	N/A
Organization	District Number	ORG_HIER10_NUM	W_INT_ORG_DH	N/A
Organization	Linear Distance	ORG_ATTR2_NUM_VALUE	W_INT_ORG_ATTR_D	N/A
Organization	Loc	ORG_NAME	W_INT_ORG_D_TL	N/A
Organization	Loc Close Date	SRC_EFF_TO_DT	W_INT_ORG_D	N/A
Organization	Loc List	LOC_LIST_NAME	W_RTL_LOC_LIST_D	N/A
Organization	Loc List ID	LOC_LIST_ID	W_RTL_LOC_LIST_D	N/A
Organization	Loc Mgr	MGR_NAME	W_INT_ORG_D	N/A
Organization	Loc Name 10	ORG_ATTR34_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Loc Name 3	ORG_ATTR33_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Loc Name Secondary	ORG_ATTR52_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Loc Number	ORG_NUM	W_INT_ORG_D	N/A
Organization	Loc Open Date	SRC_EFF_FROM_DT	W_INT_ORG_D	N/A
Organization	Loc Trait	LOC_TRAIT_NAME	W_RTL_LOC_TRAIT_D	N/A
Organization	Loc Trait ID	LOC_TRAIT_ID	W_RTL_LOC_TRAIT_D	N/A
Organization	Loc Type	ORG_ATTR23_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Mall	ORG_ATTR9_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Org Unit ID	ORG_UNIT_ID	W_RTL_ORG_FIN_D	N/A
Organization	Phone Number	PHONE_NUM	W_INT_ORG_D	N/A
Organization	Physical WH ID	ORG_ATTR14_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Postal Code	POSTAL_CODE	W_INT_ORG_D	N/A
Organization	Promo Zone ID	ORG_ATTR16_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Region Mgr	ORG_HIER11_MGR	W_INT_ORG_DH	N/A
Organization	Region Number	ORG_HIER11_NUM	W_INT_ORG_DH	N/A
Organization	Remodel Date	ORG_ATTR1_DATE	W_INT_ORG_ATTR_D	N/A
Organization	Selling Area	ORG_ATTR1_NUM_VALUE	W_INT_ORG_ATTR_D	N/A
Organization	SOB ID	SET_OF_BOOKS_ID	W_RTL_ORG_FIN_D	N/A
Organization	State	ORG_ATTR47_NAME	W_INT_ORG_ATTR_D	N/A
Organization	State Code	C_STATE_PROV_CODE	W_INT_ORG_D	N/A
Organization	Stockholding Flag	ORG_ATTR19_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Store Class	ORG_ATTR41_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Store Format Desc	ORG_ATTR21_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Store Format ID	ORG_ATTR22_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Store Type	ORG_ATTR23_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Total Area	ORG_ATTR3_NUM_VALUE	W_INT_ORG_ATTR_D	N/A
Organization	Tsf Entity ID	TSF_ENTITY_ID	W_RTL_ORG_FIN_D	N/A
Organization	Tsf Zone ID	ORG_ATTR26_NAME	W_INT_ORG_ATTR_D	N/A
Organization	VAT Included Flag	ORG_ATTR29_NAME	W_INT_ORG_ATTR_D	N/A
Organization	VAT Region ID	ORG_ATTR28_NAME	W_INT_ORG_ATTR_D	N/A
Organization	Virtual WH Flag	ORG_ATTR30_NAME	W_INT_ORG_ATTR_D	N/A
Organization	WF Customer	ORG_ATTR39_NAME	W_INT_ORG_ATTR_D	N/A
Organization	WF Customer Group	ORG_ATTR37_NAME	W_INT_ORG_ATTR_D	N/A
Organization	WF Customer Group ID	ORG_ATTR36_NAME	W_INT_ORG_ATTR_D	N/A
Organization	WF Customer ID	ORG_ATTR38_NAME	W_INT_ORG_ATTR_D	N/A
Organization	WF Customer Type	ORG_ATTR35_NAME	W_INT_ORG_ATTR_D	N/A
Reason	Reason Type Code	REASON_CODE	W_REASON_D
Retail Type	Retail Type	W_XACT_TYPE_CODE	W_XACT_TYPE_D	W_XACT_CAT_CODE = 'RETAIL_TRAN_TYPE'
Supplier	Currency Code	BASE_CURCY_CD	W_PARTY_ORG_D	SUPPLIER_FLG='Y'
Supplier	Supplier	ORG_NAME	W_PARTY_ORG_D	SUPPLIER_FLG='Y'
Supplier	Supplier Status	SUPPLIER_ACTIVE_FLG	W_PARTY_ORG_D	SUPPLIER_FLG='Y'
Supplier	Supplier Start Date	EFFECTIVE_FROM_DT	W_PARTY_ORG_D	SUPPLIER_FLG='Y'
Supplier	Supplier End Date	EFFECTIVE_TO_DT	W_PARTY_ORG_D	SUPPLIER_FLG='Y'
Supplier	Supplier Trait ID	SUPPLIER_TRAIT_ID	W_RTL_SUPPLIER_TRAIT_D	N/A
Supplier	Parent Supplier Number	PARTY_ATTR8_NAME	W_PARTY_ATTR_D	N/A
Supplier	Parent Supplier	PARTY_ATTR14_NAME	W_PARTY_ATTR_D	N/A
Shipment Method	Shipment Method Code	SHIP_METHOD_CODE	W_RTL_CO_SHIP_METHOD_D	N/A
Shipment Type	Shipment Type Code	SHIP_TYPE_CODE	W_RTL_CO_SHIP_TYPE_D	N/A
Time of Day	Minute Number	MINUTE_NUM	W_TIME_OF_DAY_D	N/A
Time of Day	Hour Number 24 Hour Format	HOUR_24_NUM	W_TIME_OF_DAY_D	N/A
Time of Day	Half Hour Interval	CASE WHEN W_TIME_OF_DAY_D.Minute_Num < 30 THEN W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':00 - ' || W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':29' ELSE W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':30 - ' || W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':59' END	W_TIME_OF_DAY_D	N/A
Time of Day	Qtr Hour Interval	case when W_MINUTE_OF_DAY_D.MINUTE_NUM < 15 then W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':00 - ' || W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':14' when W_MINUTE_OF_DAY_D.MINUTE_NUM between 15 and 29 then W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':15 - ' || W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':29' when W_MINUTE_OF_DAY_D.MINUTE_NUM between 30 and 44 then W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':30 - ' || W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':44' else W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':45 - ' || W_MINUTE_OF_DAY_D.HOUR_24_NUM || ':59' end	W_MINUTE_OF_DAY_D	N/A
Status	Status Class	W_STATUS_CLASS	W_STATUS_D	N/A
Status	Status Code	STATUS_CODE	W_STATUS_D	N/A
Customer Loyalty Account	Last Accural Date	LAST_ACCURAL DATE	W_RTL_CUST_LYL_ACCT_D	N/A
Customer Loyalty Account	Last Award Processed Date	LAST_AWARD_PROCESSED_DATE	W_RTL_CUST_LYL_ACCT_D	N/A
Customer Loyalty Account	Last Program Level Change Date	LAST_PGM_LVL_CHANGE_DATE	W_RTL_CUST_LYL_ACCT_D	N/A
Customer Loyalty Account	Last Transaction Date	LAST_TRANS_DATE	W_RTL_CUST_LYL_ACCT_D	N/A
Customer Loyalty Account	Loyalty Account Active Flag	ACCOUNT_ACTIVE_FLAG	W_RTL_CUST_LYL_ACCT_D	N/A
Customer Loyalty Account	Loyalty Account Card Serial Number	CARD_SERIAL_NUM	W_RTL_CUST_LYL_ACCT_D	N/A
Customer Loyalty Account	Loyalty Account Escrow Balance	ESCROW_PTS_BALANCE	W_RTL_CUST_LYL_ACCT_D	N/A
Customer Loyalty Account	Loyalty Account Expiry Flag	ACCOUNT_EXPIRED_FLAG	W_RTL_CUST_LYL_ACCT_D	N/A
Customer Loyalty Account	Loyalty Account From Date	EFFECTIVE_FROM_DATE	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Account Number	LOYALTY_ACCOUNT_ID	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Account Points Balance	EARNED_PTS_BALANCE	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Account To Date	EFFECTIVE_TO_DATE	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Points Currency Value	POINTS_CURRENCY_VALUE	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Points description	POINTS_NAME	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program Active Flag	LOYALTY_PROGRAM_ACTIVE_FLAG	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program Currency	PROGRAM_CURRENCY	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program Description	LOYALTY_PROGRAM_NAME	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program End Date	LOYALTY_PROGRAM_END_DATE	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program Level Active Flag	LYL_PROGRAM_LEVEL_ACTIVE_FLAG	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program Level Default Flag	DEFAULT_PROGRAM_LEVEL_FLAG	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program Level Description	LOYALTY_PROGRAM_LEVEL_NAME	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program Level Number	LOYALTY_PROGRAM_LEVEL_ID	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program Number	LOYALTY_PROGRAM_ID	W_RTL_CUST_LYL_ PROG _D	N/A
Customer Loyalty Account	Loyalty Program Start Date	LOYALTY_PROGRAM_START_DATE	W_RTL_CUST_LYL_ PROG _D	N/A
Clearances	Clearance ID	CLEARANCE_DISPLAY_ID	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Group ID	CLEARANCE_GROUP_ID	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Group Desc	CLEARANCE_GROUP_DESC	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Markdown ID	MARKDOWN_NBR	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Markdown Number	MARKDOWN_NBR _DESC	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance OOS Date	OUT_OF_STOCK_DATE	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Reason	REASON_CODE_DESC	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Change Type	CASE WHEN "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PRICE_CLR_IT_LC_D"."CHANGE_TYPE"= '0' THEN 'PERCENT OFF' WHEN "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PRICE_CLR_IT_LC_D"."CHANGE_TYPE"='1' THEN 'AMOUNT OFF' WHEN "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PRICE_CLR_IT_LC_D"."CHANGE_TYPE"='2' THEN 'FIXED PRICE' WHEN "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PRICE_CLR_IT_LC_D"."CHANGE_TYPE" ='4' THEN 'EXCLUDE' ELSE 'UNKNOWN' END	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Change Amt	CHANGE_AMOUNT	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Change UOM	CHANGE_UOM	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Change Currency	CHANGE_CURR_CODE	W_RTL_PRICE_CLR_IT_LC_D	N/A
Season Phase Operational	Season Id	SEASON_NUM	W_RTL_SEASON_D	N/A
Season Phase Operational	Season Desc	DOMAIN_MEMBER_NAME	W_DOMAIN_MEMBER_LKP_TL	W_DOMAIN_MEMBER_LKP_TL.DOMAIN_CODE = 'SEASON' AND W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_CODE = W_RTL_SEASON_D.SEASON_NUM
Season Phase Operational	Season Start Date	SRC_EFF_FROM_DT	W_RTL_SEASON_D	N/A
Season Phase Operational	Season End Date	SRC_EFF_TO_DT	W_RTL_SEASON_D	N/A
Season Phase Operational	Phase Id	PHASE_ID	W_RTL_PHASE_D	N/A
Season Phase Operational	Phase desc	DOMAIN_MEMBER_NAME	W_DOMAIN_MEMBER_LKP_TL	W_DOMAIN_MEMBER_LKP_TL.DOMAIN_CODE = 'PHASE' AND W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_CODE = W_RTL_PHASE_D.SEASON_NUM ||'~'||W_RTL_PHASE_D.PHASE_ID
Season Phase Operational	Phase Start date	SRC_EFF_FROM_DT	W_RTL_PHASE_D	N/A
Season Phase Operational	Phase End Date	SRC_EFF_TO_DT	W_RTL_PHASE_D	N/A
Season Phase Planning	Season Id	SEASON_NUM	W_RTL_ PHASE_D	N/A
Season Phase Planning	Season Desc	DOMAIN_MEMBER_NAME	W_DOMAIN_MEMBER_LKP_TL	W_DOMAIN_MEMBER_LKP_TL.DOMAIN_CODE = 'SEASON' AND W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_CODE = W_RTL_PHASE_D.SEASON_NUM
Season Phase Planning	Season Start Date	SRC_EFF_FROM_DT	W_RTL_SEASON_D	N/A
Season Phase Planning	Season End Date	SRC_EFF_TO_DT	W_RTL_SEASON_D	N/A
Season Phase Planning	Phase Id	PHASE_ID	W_RTL_ PHASE_D	N/A
Season Phase Planning	Phase desc	DOMAIN_MEMBER_NAME	W_DOMAIN_MEMBER_LKP_TL	W_DOMAIN_MEMBER_LKP_TL.DOMAIN_CODE = 'PHASE' AND W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_CODE = W_RTL_PHASE_D.SEASON_NUM ||'~'||W_RTL_PHASE_D.PHASE_ID
Season Phase Planning	Phase Start date	SRC_EFF_FROM_DT	W_RTL_ PHASE_D	N/A
Season Phase Planning	Phase End Date	SRC_EFF_TO_DT	W_RTL_ PHASE_D	N/A
Season Phase Planning	Phase Desc - Alternate	DOMAIN_MEMBER_NAME	W_DOMAIN_MEMBER_LKP_TL	N/A
Promotion	Pro Days Count	TimeStampDiff(SQL_TSI_DAY,cast( "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PROMO_D_Component"."EFFECTIVE_FROM_DT" as TIMESTAMP), CAST("Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PROMO_D_Component"."EFFECTIVE_TO_DT" as TIMESTAMP)) +1	W_RTL_PROMO_D	PROMO_LEVEL='C'
Promotion	Promo Event Description	PROMO_EVENT_DESC	W_RTL_PROMO_D_TL	N/A
Promotion	Promo Event End Date	SRC_EFF_TO_DT	W_RTL_PROMO_D	PROMO_LEVEL='E'
Promotion	Promo Event Id	PROMO_EVENT_ID	W_RTL_PROMO_D	PROMO_LEVEL='E'
Promotion	Promo Event Start Date	SRC_EFF_FROM_DT	W_RTL_PROMO_D	PROMO_LEVEL='E'
Promotion	Promo Event Strategy	PROMO_EVENT_STRATEGY	W_RTL_PROMO_D_TL	N/A
Promotion	Promo Event Theme Desc	PROMO_THEME	W_RTL_PROMO_D_TL	N/A
Promotion	Promo Event Type	PROMO_EVENT_TYPE	W_RTL_PROMO_D_TL	N/A
Promotion	Promo Description	PROMO_PARENT_DESC	W_RTL_PROMO_D_TL	N/A
Promotion	Promo End Date	SRC_EFF_TO_DT	W_RTL_PROMO_D	PROMO_LEVEL='P'
Promotion	Promo ID	PROMO_PARENT_ID	W_RTL_PROMO_D	PROMO_LEVEL='P'
Promotion	Promo Name	PROMO_PARENT_NAME	W_RTL_PROMO_D	PROMO_LEVEL='P'
Promotion	Promo Start Date	SRC_EFF_FROM_DT	W_RTL_PROMO_D	PROMO_LEVEL='P'
Promotion	Promo Offer End Date	SRC_EFF_TO_DT	W_RTL_PROMO_D	PROMO_LEVEL='C'
Promotion	Promo Offer ID	PROMO_COMPONENT_ID	W_RTL_PROMO_D	PROMO_LEVEL='C'
Promotion	Promo Offer Marketing Channel	PROMO_COMPONENT_MKT_CHANNEL	W_RTL_PROMO_D_TL	N/A
Promotion	Promo Offer Name	PROMO_COMPONENT_NAME	W_RTL_PROMO_D	PROMO_LEVEL='C'
Promotion	Promo Offer Start Date	SRC_EFF_FROM_DT	W_RTL_PROMO_D	PROMO_LEVEL='C'
Promotion	Promo Offer Type	PROMO_COMPONENT_TYPE	W_RTL_PROMO_D	PROMO_LEVEL='C'
Promotion	Target Name	TARGET_NAME	W_RTL_PROMO_D	PROMO_LEVEL='P'
Promotion	Coupon Code	COUPON_CODE	W_RTL_PROMO_D	PROMO_LEVEL='C'
Promotion	Flex Attrib 1 Char	FLEX_ATTRIB_1_CHAR	W_RTL_PROMO_D	N/A
Promotion	Flex Attrib 2 Char	FLEX_ATTRIB_2_CHAR	W_RTL_PROMO_D	N/A
Promotion	Flex Attrib 3 Char	FLEX_ATTRIB_3_CHAR	W_RTL_PROMO_D	N/A
Promotion	Flex Attrib 4 Char	FLEX_ATTRIB_4_CHAR	W_RTL_PROMO_D	N/A
Promotion	Flex Attrib 5 Num	FLEX_ATTRIB_5_NUM	W_RTL_PROMO_D	N/A
Promotion	Flex Attrib 6 Num	FLEX_ATTRIB_6_NUM	W_RTL_PROMO_D	N/A
Promotion	Flex Attrib 7 Num	FLEX_ATTRIB_7_NUM	W_RTL_PROMO_D	N/A
Promotion	Flex Attrib 8 Char	FLEX_ATTRIB_8_CHAR	W_RTL_PROMO_D	N/A
Promotion	Flex Attrib 9 Char	FLEX_ATTRIB_9_CHAR	W_RTL_PROMO_D	N/A
Promotion	Flex Attrib 10 Char	FLEX_ATTRIB_10_CHAR	W_RTL_PROMO_D	N/A
Promotion	Promotion Source	PROMO_SOURCE_ID	W_RTL_PROMO_D	N/A
Promotion	Promo Detail ID	PROMO_DETAIL_ID	W_RTL_PROMO_DETAIL_D	N/A
Promotion	Promo Condition/Reward Amount	COND_REWARD_AMT	W_RTL_PROMO_DETAIL_D	N/A
Promotion	Promo Condition/Reward Quantity	COND_REWARD_QTY	W_RTL_PROMO_DETAIL_D	N/A
Promotion	Promo Condition/Reward Type	COND_REWARD_TYPE	W_RTL_PROMO_DETAIL_D	N/A
Promotion	Promo Condition/Reward UOM	COND_REWARD_UOM	W_RTL_PROMO_DETAIL_D	N/A
Promotion	Promo Detail Type	PROMO_DETAIL_TYPE	W_RTL_PROMO_DETAIL_D	N/A
Stock Count	Stock Count Status	STATUS	W_RTL_LOC_STOCK_CNT_D	N/A
Stock Count	Stock Count ID	STOCK_CNT_ID	W_RTL_LOC_STOCK_CNT_D	N/A
Stock Count	Stock Count Description	STOCK_CNT_DESC	W_RTL_LOC_STOCK_CNT_D	N/A
Stock Count	Stock Count From Date	STOCK_CNT_FROM_DT	W_RTL_LOC_STOCK_CNT_D	N/A
Stock Count	Stock Count To Date	STOCK_CNT_TO_DT	W_RTL_LOC_STOCK_CNT_D	N/A
Stock Count	Stock Count Type	STOCK_CNT_TYPE	W_RTL_LOC_STOCK_CNT_D	N/A
Stock Count	Stock Count Location	ORG_NUM	W_RTL_LOC_STOCK_CNT_D	N/A
Retail Discount Type	Discount Type Code	DISC_TYPE_CODE	W_RTL_DISCOUNT_TYPE_D	CODE_TYPE = 'SADT'
Retail Discount Type	Discount Description	DOMAIN_MEMBER_NAME	W_DOMAIN_MEMBER_LKP_TL	W_DOMAIN_MEMBER_LKP_TL.DOMAIN_CODE = 'SADT' AND W_DOMAIN_MEMBER_LKP_TL.DOMAIN_TYPE_CODE = 'S' AND W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_CODE = W_RTL_DISCOUNT_TYPE_D.DISC_TYPE_CODE
Clearances	Clearance ID	CLEARANCE_DISPLAY_ID	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Group ID	CLEARANCE_GROUP_ID	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Group Desc	CLEARANCE_GROUP_DESC	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Markdown ID	MARKDOWN_NBR	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Markdown Number	MARKDOWN_NBR _DESC	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance OOS Date	OUT_OF_STOCK_DATE	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Reason	REASON_CODE_DESC	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Change Type	CASE WHEN "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PRICE_CLR_IT_LC_D"."CHANGE_TYPE"= '0' THEN 'PERCENT OFF' WHEN "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PRICE_CLR_IT_LC_D"."CHANGE_TYPE"='1' THEN 'AMOUNT OFF' WHEN "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PRICE_CLR_IT_LC_D"."CHANGE_TYPE"='2' THEN 'FIXED PRICE' WHEN "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_RTL_PRICE_CLR_IT_LC_D"."CHANGE_TYPE" ='4' THEN 'EXCLUDE' ELSE 'UNKNOWN' END	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Change Amt	CHANGE_AMOUNT	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Change UOM	CHANGE_UOM	W_RTL_PRICE_CLR_IT_LC_D	N/A
Clearances	Clearance Change Currency	CHANGE_CURR_CODE	W_RTL_PRICE_CLR_IT_LC_D	N/A