eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: FEM.FEM_CUSTOMER_DETAIL

Object Details

Object Name:	FEM_CUSTOMER_DETAIL
Object Type:	TABLE
Owner:	FEM
Subobject Name:
Status:	VALID

Customer Detail

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_CUSTOMER_DETAIL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID CAL_PERIOD_ID DATASET_CODE SOURCE_SYSTEM_CODE LEDGER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_ID	NUMBER		Yes	Customer Id
FULL_NAME	VARCHAR2	(40)		Full Name
FIRST_NAME	VARCHAR2	(30)		First Name
LAST_NAME	VARCHAR2	(30)		Last Name
MIDDLE_NAME	VARCHAR2	(30)		Middle Name
NAME_PREFIX	VARCHAR2	(20)		Name Prefix
NAME_SUFFIX	VARCHAR2	(20)		Name Suffix
NAME_SUPPLEMENT	VARCHAR2	(40)		Name Supplement
SALUTATION	VARCHAR2	(30)		Salutation
ADDRESS_SUPPLEMENT	VARCHAR2	(40)		Address Supplement
CITY	VARCHAR2	(25)		City
COUNTRY	VARCHAR2	(40)		Country
POSTAL_CODE	VARCHAR2	(30)		Postal Code
STATE	VARCHAR2	(2)		State
STREET_ADDRESS	VARCHAR2	(40)		Street Address
STREET_NAME	VARCHAR2	(40)		Street Name
STREET_NUMBER	VARCHAR2	(10)		Street Number
STREET_NUMBER_SUPPLEMENT	VARCHAR2	(10)		Street Number Supplement
FAX_PHONE	VARCHAR2	(20)		Fax Phone
HOME_CONTACT_PHONE	VARCHAR2	(20)		Home Contact Phone
OTHER_PHONE	VARCHAR2	(20)		Other Phone
WORK_BUS_PHONE	VARCHAR2	(20)		Work Bus Phone
CARRIER_ROUTE	VARCHAR2	(5)		Carrier Route
CENSUS_BLOCK	VARCHAR2	(1)		Census Block
CENSUS_COUNTY	VARCHAR2	(3)		Census County
CENSUS_STATE	VARCHAR2	(2)		Census State
CENSUS_TRACT	VARCHAR2	(6)		Census Tract
ANNUAL_INCOME	NUMBER			Annual Income
CREDIT_SCORE	NUMBER			Credit Score
HOME_VALUE	NUMBER			Home Value
PROPENSITY_TO_BUY	VARCHAR2	(10)		Propensity To Buy
RETENTION_SCORE	VARCHAR2	(10)		Retention Score
VEHICLE_VALUE	NUMBER			Vehicle Value
AGE	NUMBER			Age
BIRTH_DATE	DATE			Birth Date
EMPLOYER	VARCHAR2	(40)		Employer
EMPLOYMENT_START_DATE	DATE			Employment Start Date
FIRST_CONTACT_DATE	DATE			First Contact Date
GOVERNMENT_ID_NUMBER	VARCHAR2	(30)		Government Id Number
LAST_CONTACT_DATE	DATE			Last Contact Date
RESIDENT_YEARS	NUMBER			Resident Years
SEX	VARCHAR2	(1)		Sex
YEARS_AS_CUST	NUMBER			Years As Cust
BUSINESS_CONTACT_NAME	VARCHAR2	(40)		Business Contact Name
BUSINESS_CONTACT_TITLE	VARCHAR2	(40)		Business Contact Title
BUSINESS_OWNER	VARCHAR2	(40)		Business Owner
IN_BUSINESS_SINCE	DATE			In Business Since
YEARS_IN_BUSINESS	NUMBER			Years In Business
CAL_PERIOD_ID	NUMBER		Yes	Calendar Period
CREATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Created By Request
CREATED_BY_REQUEST_ID	NUMBER		Yes	Created By Object
DATASET_CODE	NUMBER		Yes	Dataset Code
LAST_UPDATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Last Updated By Request
LAST_UPDATED_BY_REQUEST_ID	NUMBER		Yes	Last Updated By Object
LEDGER_ID	NUMBER		Yes	Ledger
MARKET_SEGMENT_ID	NUMBER		Yes	Market Segment
SOURCE_SYSTEM_CODE	NUMBER		Yes	Source System Code
ADDITIONAL_RES_OWNED_FLAG	NUMBER			Additional Residence Owned Flag
ADDITIONAL_RES_RENTED_FLAG	NUMBER			Additional Residence Rented Flag
AGE_SEGMENT_CODE	VARCHAR2	(20)		Age Segment Code
BUSINESS_TYPE_CODE	VARCHAR2	(5)		Type of Business
COUNTRY_CODE	VARCHAR2	(5)		A standard country code to represent the counrty portion of the customer address
CREDIT_BUREAU_CODE	VARCHAR2	(5)		Credit Bureau Code
CREDIT_CARD_CODE	VARCHAR2	(5)		Credit Card Code
CURRENCY_CODE	VARCHAR2	(15)		Currency
CUSTOMER_AGE_OLDEST	NUMBER			Age of Oldest Customer in Group
CUSTOMER_AGE_YOUNGEST	NUMBER			Age of youngest Customer in Group
DECEASED_FLAG	VARCHAR2	(1)		Deceased Flag
EDUCATION_LEVEL_CODE	VARCHAR2	(5)		Level of Education
EMPLOYEE_FLAG	VARCHAR2	(1)		Employee Flag
GEOGRAPHY_ID	NUMBER			Geography
HOMEOWNER_FLAG	VARCHAR2	(1)		Customer is a Home Owner
INCOME_CLASS_CODE	VARCHAR2	(10)		A classification for the type of income derived from this customer
INCOME_SOURCE_CODE	VARCHAR2	(5)		A classification for the source of income derived from this customer
LINE_OF_BUSINESS_CODE	VARCHAR2	(5)		Line of Business
MARITAL_STATUS_CODE	VARCHAR2	(1)		Marital Status
NONPROFIT_FLAG	VARCHAR2	(1)		Nonprofit Flag
NO_PROMO_MAIL_FLAG	VARCHAR2	(1)		Flag indicating if mail promotion sent to customer
NUM_CHILDREN_IN_CUST_GROUP	NUMBER			Number of Children in this Customer Group
NUM_CUST_IN_CUST_GROUP	NUMBER			Number of Customers in this Customer Group
NUM_PEOPLE_IN_CUST_GROUP	NUMBER			Number of People in this Customer Group
OCCUPATION_CODE	VARCHAR2	(20)		Occumpation
OFFICER_CODE	VARCHAR2	(10)		Officer Code
RESIDENCE_TYPE_CODE	VARCHAR2	(5)		Type of Residence
TELEMARKET_CODE	VARCHAR2	(5)		This the marketing channel.
VEHICLE_TYPE_CODE	VARCHAR2	(5)		This is category within Product_id
VIP_FLAG	VARCHAR2	(1)		VIP Flag

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMER_ID
,      FULL_NAME
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      NAME_PREFIX
,      NAME_SUFFIX
,      NAME_SUPPLEMENT
,      SALUTATION
,      ADDRESS_SUPPLEMENT
,      CITY
,      COUNTRY
,      POSTAL_CODE
,      STATE
,      STREET_ADDRESS
,      STREET_NAME
,      STREET_NUMBER
,      STREET_NUMBER_SUPPLEMENT
,      FAX_PHONE
,      HOME_CONTACT_PHONE
,      OTHER_PHONE
,      WORK_BUS_PHONE
,      CARRIER_ROUTE
,      CENSUS_BLOCK
,      CENSUS_COUNTY
,      CENSUS_STATE
,      CENSUS_TRACT
,      ANNUAL_INCOME
,      CREDIT_SCORE
,      HOME_VALUE
,      PROPENSITY_TO_BUY
,      RETENTION_SCORE
,      VEHICLE_VALUE
,      AGE
,      BIRTH_DATE
,      EMPLOYER
,      EMPLOYMENT_START_DATE
,      FIRST_CONTACT_DATE
,      GOVERNMENT_ID_NUMBER
,      LAST_CONTACT_DATE
,      RESIDENT_YEARS
,      SEX
,      YEARS_AS_CUST
,      BUSINESS_CONTACT_NAME
,      BUSINESS_CONTACT_TITLE
,      BUSINESS_OWNER
,      IN_BUSINESS_SINCE
,      YEARS_IN_BUSINESS
,      CAL_PERIOD_ID
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      DATASET_CODE
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      LEDGER_ID
,      MARKET_SEGMENT_ID
,      SOURCE_SYSTEM_CODE
,      ADDITIONAL_RES_OWNED_FLAG
,      ADDITIONAL_RES_RENTED_FLAG
,      AGE_SEGMENT_CODE
,      BUSINESS_TYPE_CODE
,      COUNTRY_CODE
,      CREDIT_BUREAU_CODE
,      CREDIT_CARD_CODE
,      CURRENCY_CODE
,      CUSTOMER_AGE_OLDEST
,      CUSTOMER_AGE_YOUNGEST
,      DECEASED_FLAG
,      EDUCATION_LEVEL_CODE
,      EMPLOYEE_FLAG
,      GEOGRAPHY_ID
,      HOMEOWNER_FLAG
,      INCOME_CLASS_CODE
,      INCOME_SOURCE_CODE
,      LINE_OF_BUSINESS_CODE
,      MARITAL_STATUS_CODE
,      NONPROFIT_FLAG
,      NO_PROMO_MAIL_FLAG
,      NUM_CHILDREN_IN_CUST_GROUP
,      NUM_CUST_IN_CUST_GROUP
,      NUM_PEOPLE_IN_CUST_GROUP
,      OCCUPATION_CODE
,      OFFICER_CODE
,      RESIDENCE_TYPE_CODE
,      TELEMARKET_CODE
,      VEHICLE_TYPE_CODE
,      VIP_FLAG
FROM FEM.FEM_CUSTOMER_DETAIL;

Dependencies

[top of page]

FEM.FEM_CUSTOMER_DETAIL does not reference any database object

FEM.FEM_CUSTOMER_DETAIL is referenced by following:

APPS: FEM_CUSTOMER_DETAIL