DW_EB_X_EBS_COMMON_W_PARTY_PER_D

Party Person Dimension includes B2B Customer and B2C Contact data

Details

Module: Common Tables (EBS_COMMON)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Comments	Referred Table
DATASOURCE_NUM_ID	NUMBER		10	This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances.
EFFECTIVE_FROM_DT	TIMESTAMP		6	This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
INTEGRATION_ID	VARCHAR2	80 CHAR		This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts.
ACCESS_LVL_CODE	VARCHAR2	80 CHAR		Access Level Code
ACCNT_FLG	VARCHAR2	1 CHAR		Account Flag
ACCNT_ID	VARCHAR2	30 CHAR		Account Id
ACTIVE_FLG	VARCHAR2	1 CHAR		Active Flag
ADDR_EFF_DT	TIMESTAMP		6	Effective from when current address is Valid in DW
AGENT_FLG	VARCHAR2	1 CHAR		Agent Flag
AGE_RANGE	VARCHAR2	30 CHAR		Age Range
ANNL_INCOME	NUMBER		28,10	Annual Income
APPR_AUTH	NUMBER		28,10	Approval Authorization
APPR_AUTH_CAT_CODE	VARCHAR2	80 CHAR		Approved Auth Category Code
APPR_CURCY_CD	VARCHAR2	30 CHAR		Approved Currency Code
AUX1_CHANGED_ON_DT	TIMESTAMP		6	Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX2_CHANGED_ON_DT	TIMESTAMP		6	Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX3_CHANGED_ON_DT	TIMESTAMP		6	Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX4_CHANGED_ON_DT	TIMESTAMP		6	Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX5_CHANGED_ON_DT	TIMESTAMP		6	Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
BASE_CURCY_CD	VARCHAR2	20 CHAR		Base Currency Code
BIRTH_DT	TIMESTAMP		6	Birth Date
BIRTH_PLACE	VARCHAR2	100 CHAR		Birth Place
CALL_FLG	VARCHAR2	1 CHAR		Call Flag
CALL_LST_NAME	VARCHAR2	50 CHAR		Call Last Name
CHANGED_BY_WID	NUMBER		38	This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DT	TIMESTAMP		6	Identifies the date and time when the record was last modified in the source system.
CITIZENSHIP_CODE	VARCHAR2	80 CHAR		Citizenship Code
CITY_CODE	VARCHAR2	120 CHAR		Source City Code
CNTCT_ANNUAL_RVN	VARCHAR2	100 CHAR
CNTCT_COMPANY_RVN	VARCHAR2	100 CHAR
CNTCT_COMPANY_SIZE	VARCHAR2	100 CHAR
CNTCT_EMPLOYEES	NUMBER		15
CNTCT_INDUSTRY	VARCHAR2	100 CHAR
CNTCT_SALESPERSON	VARCHAR2	100 CHAR
COMPLEXION_CODE	VARCHAR2	80 CHAR		Complexion Code
COMP_OWNER_FLG	VARCHAR2	1 CHAR		Computer Ownership Flag
COM_PREFERENCE_CODE	VARCHAR2	80 CHAR		Comunication Preference
CONSUMER_FLG	VARCHAR2	1 CHAR		Consumer Flag
CONTACT_FLG	VARCHAR2	1 CHAR		Contact Flag
CONTACT_ID	VARCHAR2	30 CHAR		Customer Contact
CONTACT_TYPE_CODE	VARCHAR2	80 CHAR		Contact Type
CON_ACTIVE_FLG	VARCHAR2	1 CHAR		Contact Active Flag (Y/N) : If the contact is active then it is set to Y otherwise to N
CON_BU_NAME	VARCHAR2	100 CHAR		Contact Business Unit Name
CON_FORMED_DT	TIMESTAMP		6	Contact Formed Date
COUNTRY_CODE	VARCHAR2	120 CHAR		Source Country Code
CREATED_BY_WID	NUMBER		38	This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6	Identifies the date and time when the record was initially created in the source system.
CREATED_SOURCE_CODE	VARCHAR2	80 CHAR
CREDIT_SCORE	NUMBER		28,10	Credit Score
CSN	VARCHAR2	150 CHAR		CSN
CURRENT_FLG	VARCHAR2	1 CHAR		This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous.
CUSTOMER_NUM	VARCHAR2	80 CHAR		Customer Number
CUST_CAT_CODE	VARCHAR2	80 CHAR		Customer Category Code
CUST_END_DT	TIMESTAMP		6	Customer End Date
CUST_SINCE_DT	TIMESTAMP		6	Customer Since Date
CUST_VALUE_CODE	VARCHAR2	80 CHAR		Customer Value Code
CUST_VAL_EFF_DT	TIMESTAMP		6	Customer Value Effective Date
C_CITY_CODE	VARCHAR2	120 CHAR		Customized City Code
C_CONTINENT_CODE	VARCHAR2	120 CHAR		Customized Continent Code
C_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR		Customized Country Region Code
C_COUNTY_CODE	VARCHAR2	120 CHAR		Customized County Code
C_REGION_CODE	VARCHAR2	120 CHAR		Customized Region Code
C_STATE_PROV_CODE	VARCHAR2	120 CHAR		Customized State Province Code
DEATH_DT	TIMESTAMP		6	Death Date
DECEASE_FLG	VARCHAR2	1 CHAR		Decease Flag
DELETE_FLG	VARCHAR2	1 CHAR		This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active.
DEPARTMENT_NAME	VARCHAR2	100 CHAR		Department Name
DEPT_TYPE_CODE	VARCHAR2	80 CHAR		Department Type Code
DISABILITY	VARCHAR2	50 CHAR		Disability
DISABLED_FLG	VARCHAR2	1 CHAR
EDUCATION_BCKGND_CODE	VARCHAR2	80 CHAR		Education Background Code
EDUCATION_YEARS	NUMBER		10	Education Years
EFFECTIVE_TO_DT	TIMESTAMP		6	This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
EMAIL_ADDRESS	VARCHAR2	100 CHAR		Email Address
EMAIL_SR_UPD_FLG	VARCHAR2	1 CHAR		Email Sr Upd Flag
EMPLMNT_STAT_CODE	VARCHAR2	80 CHAR		Employment Stat Code
EMP_ACCNT_BU_NAME	VARCHAR2	100 CHAR		Employee Account Business Unit Name
EMP_ACCNT_LOC	VARCHAR2	50 CHAR		Employee Account Location
EMP_ACCNT_NAME	VARCHAR2	100 CHAR		Employee Account Name
EMP_ACTIVE_FLG	VARCHAR2	1 CHAR		Employee Active Flag (Y/N) : If the employee still exits then it is set to Y otherwise to N
EMP_FLG	VARCHAR2	1 CHAR		Employee Flag
EMP_FORMED_DT	TIMESTAMP		6	Employee Formed Date
EMP_HIRE_DT	TIMESTAMP		6	Employee Hire Date
ENTREPRISE_FLG	VARCHAR2	1 CHAR		Entreprise Flag
ETHNICITY1_CD	VARCHAR2	30 CHAR		Ethnicity1 Code
ETHNICITY2_CD	VARCHAR2	30 CHAR		Ethnicity2 Code
ETHNICITY_CODE	VARCHAR2	80 CHAR		Ethnicity Code
ETL_PROC_WID	NUMBER		38	Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
EXT_CON_STORE	VARCHAR2	30 CHAR		Ext Con Store
EYE_COLOR_LEFT_CODE	VARCHAR2	80 CHAR		Left Eye Color Code
EYE_COLOR_RIGHT_CODE	VARCHAR2	80 CHAR		Right Eye Color Code
FAX_PH_NUM	VARCHAR2	40 CHAR		Fax Phone Number
FST_NAME	VARCHAR2	150 CHAR		First Name
FST_PROMO_DT	TIMESTAMP		6	First Promotion Date
FULL_NAME	VARCHAR2	250 CHAR		Full Name
GEO_WID	NUMBER		38	Foreign Key to Geography Dimension	DW_EB_X_EBS_COMMON_W_GEO_D
GOALS	VARCHAR2	250 CHAR		Goals
GRAD_YR	NUMBER		10	Graduation Year
HAIR_COLOR	VARCHAR2	30 CHAR		Hair Color
HARD_TO_REACH	VARCHAR2	11 CHAR		Hard To Reach
HEIGHT	VARCHAR2	30 CHAR		Height
HELD_POSTN	VARCHAR2	50 CHAR		Held Postion
HOBBY	VARCHAR2	30 CHAR		Hobby
INCOME_RANGE_CODE	VARCHAR2	80 CHAR		Income Range Code
INCOME_RNG_EFF_DT	TIMESTAMP		6	Income Rng Eff Date
INS_OCCUPATION	VARCHAR2	50 CHAR		Ins Occupation
INTERNAL_FLG	VARCHAR2	1 CHAR		Internal Flag
INVST_EXPERIENCE_CODE	VARCHAR2	80 CHAR		Investment Experience Code
INVST_HORIZON_CODE	VARCHAR2	80 CHAR		Investment Horizon Code
INVST_KNOWLEDGE_CODE	VARCHAR2	80 CHAR		Investment Knowledge Code
INVST_OBJECTIVE_CODE	VARCHAR2	80 CHAR		Investment Objective Code
INVST_PROFILE_CODE	VARCHAR2	80 CHAR		Investment Profile Code
INVST_RISK_CODE	VARCHAR2	80 CHAR		Investment Risk Code
JOB_CATEGORY_CODE	VARCHAR2	80 CHAR		Job Category Code
JOB_TITLE	VARCHAR2	75 CHAR		Job Title
LAST_CONTACT_DATE	TIMESTAMP		6	Last Contact Date
LAST_NAME	VARCHAR2	150 CHAR		Last Name
LOGIN	VARCHAR2	50 CHAR		Login
LST_PROMO_DT	TIMESTAMP		6	Last Promotion Date
MARITAL_STAT_CODE	VARCHAR2	80 CHAR		Marital Stat Code
MARKETING_MODULE_FLG	VARCHAR2	1 CHAR		CRM Module Flag for Marketing
MARKET_SALES_FUNNEL_STAGE	VARCHAR2	100 CHAR
MEMBER_FLG	VARCHAR2	1 CHAR		Member Flag
MEMBER_NUM	VARCHAR2	50 CHAR		Member Number
MID_NAME	VARCHAR2	50 CHAR		Middle Name
MKT_POTENTIAL	VARCHAR2	30 CHAR		Market Potential
MOBILE_NUM	VARCHAR2	100 CHAR		Mobile Number
MRKT_CAP_PREF_CODE	VARCHAR2	80 CHAR		Market Cap Pref Code
NAME_EFF_DT	TIMESTAMP		6	Effective from when current Name is Valid in DW
NATIONALITY	VARCHAR2	30 CHAR		Nationality
NET_WORTH_CODE	VARCHAR2	80 CHAR		Net Worth Code
NET_WORTH_EFF_DT	TIMESTAMP		6	Net Worth Effective Date
NUM_CMPGNS	NUMBER		10	Number Cmpgns
NUM_OFRS_PRSNTD	NUMBER		10	Total Number of Offers presented
OU_MAIL_STOP	VARCHAR2	30 CHAR		OU Mail Stop
PAGER_NUM	VARCHAR2	100 CHAR		Pager Number
PARTY_UNIQUE_NAME	VARCHAR2	250 CHAR		Last Name
PAR_HELD_POSTN	VARCHAR2	50 CHAR		Parent Held Postion
POSTAL_CODE	VARCHAR2	120 CHAR		Postal Code or Zipcode
PREF_CALL_FREQ	VARCHAR2	30 CHAR		Preferred Call Frequency
PREF_COMM_MEDIA_CODE	VARCHAR2	80 CHAR		Preferred Comm Media Code
PREF_LANG_ID	VARCHAR2	15 CHAR		Preferred Language Id
PRESCRIBER_FLG	VARCHAR2	1 CHAR		Prescriber Flag
PRE_LANG	VARCHAR2	50 CHAR		Preferred Language
PRIMARY_PHONE_AREA_CODE	VARCHAR2	18 CHAR		Primary Phone Area Code
PRIMARY_RELATIONSHIP_ID	NUMBER		18	Primary Relationship ID
PRODUCT_SOL_OF_INT	VARCHAR2	100 CHAR
PROF_TITLE	VARCHAR2	30 CHAR		Professional Title
PROSPECT_FLG	VARCHAR2	1 CHAR		Prospect Flag
PROSPECT_ID	VARCHAR2	30 CHAR		Prospect ID
PROVIDER_FLG	VARCHAR2	1 CHAR		Provider Flag
PRSP_CON_UID	VARCHAR2	100 CHAR		Contact or Prospect ID
PR_HOUSEHOLD_WID	NUMBER		38	Primary Household Dimension Id
PR_MKT_SEGMENT	VARCHAR2	50 CHAR		Primary Marketing Segment
PR_POSTN	VARCHAR2	50 CHAR		Primary Postion
PR_SPECIALTY	VARCHAR2	100 CHAR		Primary Specialty
REGION_CODE	VARCHAR2	120 CHAR		Source Region Code
RESDNCE_CATEGORY_CODE	VARCHAR2	80 CHAR		Residence Category Code
RESDNCE_TYPE_CODE	VARCHAR2	80 CHAR		ResidenceType Code
RESDNCE_VAL	NUMBER		28,10	Residence Value
RESIDENCY_INSTN	VARCHAR2	50 CHAR		Residency Installation
ROW_WID	NUMBER		38	Surrogate key to uniquely identify a record
RSRCH_CHNL_PREF_CODE	VARCHAR2	80 CHAR		Research Channel Preference Code
SALES_ACCNT_FLG	VARCHAR2	1 CHAR		Sales Account Flag
SALES_ACCT_SINCE_DT	TIMESTAMP		6	Sales Account Since Date
SALES_AFFINITY_CODE	VARCHAR2	30 CHAR		Sales Affinity Code
SALES_BUYING_ROLE_CODE	VARCHAR2	30 CHAR		Sales Buying Role Code
SALES_MODULE_FLG	VARCHAR2	1 CHAR		CRM Module Flag for Sales
SCD1_WID	NUMBER		38	Slow Changing Type 1 WID
SELF_EMPL_FLG	VARCHAR2	1 CHAR		Self Employed Flag
SEMINAR_INVIT_FLG	VARCHAR2	1 CHAR		Seminar Invite Flag
SERVICE_MODULE_FLG	VARCHAR2	1 CHAR		CRM Module Flag for Service
SEX_MF_CODE	VARCHAR2	80 CHAR		Gender Code
SPEAKER_FLG	VARCHAR2	1 CHAR		Speaker Flag
SPECIALTY_BRICK	VARCHAR2	40 CHAR		Specialty Brick
SPOUSE_NAME	VARCHAR2	30 CHAR		Spouse Name
SRC_EFF_FROM_DT	TIMESTAMP		6	This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
SRC_EFF_TO_DT	TIMESTAMP		6	This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
STAFF	VARCHAR2	255 CHAR		Staff
STATE_CODE	VARCHAR2	120 CHAR		Source State Code
STATUS_CODE	VARCHAR2	80 CHAR		Status Code
STAT_REASON_CODE	VARCHAR2	80 CHAR		Status Reason Code
STUDENT_FLG	VARCHAR2	1 CHAR		Student Flag
ST_ADDRESS1	VARCHAR2	255 CHAR		Street Address Line 1
ST_ADDRESS2	VARCHAR2	200 CHAR		Street Address Line 2
ST_ADDRESS3	VARCHAR2	200 CHAR		Street Address Line 3
ST_ADDRESS4	VARCHAR2	200 CHAR		Street Address Line 4
SUPPLIER_FLG	VARCHAR2	1 CHAR		Supplier Flag
SUPPLIER_ID	VARCHAR2	80 CHAR		Supplier Id
SUPPLIER_NUM	VARCHAR2	80 CHAR		Supplier Number
SUPPLIER_TYPE_CODE	VARCHAR2	80 CHAR		Supplier Type Code
SUPPRESS_CALL_FLG	VARCHAR2	1 CHAR		Suppress Call Flag (Y/N) : If the contact is not be called it is set Y otherwise to N
SUPPRESS_EMAIL_FLG	VARCHAR2	1 CHAR		Suppress Email Flag (Y/N) : If the contact's email is not be sent then it is set to Y otherwise to N
SUPPRESS_FAX_FLG	VARCHAR2	1 CHAR		Suppress Fax Flag (Y/N) : If the contact's fax is not to be sent then it is set to Y otherwise to N
SUPPRESS_MAIL_FLG	VARCHAR2	1 CHAR		Suppress Mail Flag (Y/N) : If the contact's mail is not to be sent then it is set to Y otherwise to N
TAX_BRACKET	NUMBER		28,10	Tax Bracket
TENANT_ID	VARCHAR2	80 CHAR		This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model.
TERR_NAME	VARCHAR2	75 CHAR		Territory Name
VETERAN_FLG	VARCHAR2	1 CHAR		Veteran Flag
VIS_PR_BU_ID	VARCHAR2	15 CHAR		Visibility Primary BU Id
VIS_PR_POSTN_DH_WID	NUMBER		38	Vis Pr Postn Dh Wid
VIS_PR_POS_ID	VARCHAR2	15 CHAR		Visibility Primary BU Name
WEIGHT	VARCHAR2	30 CHAR		Weight
WORK_PHONE	VARCHAR2	40 CHAR		Work Phone
W_COUNTRY_CODE	VARCHAR2	120 CHAR		Warehouse Country Code
W_CRM_MODULE_CODE	VARCHAR2	80 CHAR		CRM Module Code
X_CUSTOM	VARCHAR2	10 CHAR		This column is used as a generic field for customer extensions.
YEARS_AT_ACCNT	NUMBER		28,10	Years At Account
YRS_AT_RESIDENCE	NUMBER		28,10	Years At Residence
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6