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

TABLE: FEM.FEM_CUSTOMER_DETAIL_T

Object Details
Object Name: FEM_CUSTOMER_DETAIL_T
Object Type: TABLE
Owner: FEM
Subobject Name:
Status: VALID


FEM_CUSTOMER_DETAIL_T is an interface table for loading and updating Analytic Customer Detail data into the FEM_CUSTOMER_DETAIL table using the Detail Client Data Loader. With the exception of the information required for the Calendar Period dimension as well as the STATUS column, each column on the interface table maps to a column in the destination table. The mapping between the columns on the interface table and the destination table is stored as Table Registration metadata. Users can go to the Table Registration user interface to view and update the column mapping metadata. Most columns that have a one-to-one mapping between the interface and destination tables share the same column name. If the interface table column maps to a destination table column with a different name, then the column most likely represents a dimension that has both a user-defined non-translatable alphanumeric identifier (or "Display Code") and a system generated numeric identifier (or "ID") for its members. Users should always populate the interface table column with the dimension "Display Code" value. The Detail Client Data Loader transforms the member values in the interface table into the correct internal numeric identifiers for each member. For example, LEDGER_DISPLAY_CODE and LEDGER_ID are columns that represent the Ledger dimension on the interface table and destination table, respectively. Users just need to populate the LEDGER_DISPLAY_CODE with the "Display Code" value. The data loader transforms the "Display Code" value into an internal numeric identifier before storing into the LEDGER_ID column on the destination table.
As noted above, members for the Calendar Period dimension are not identified in this manner. Rather, they are identified by a combination of the following information:
Level (CALP_DIM_GRP_DISPLAY_CODE), End Date (CAL_PERIOD_END_DATE), and Period Number (CAL_PERIOD_NUMBER). The loader also uses the Ledger (LEDGER_DISPLAY_CODE) to identify the Calendar to be used to verify the existence of all of the Calendar Period members in the load.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Customer Detail Data
Category: BUSINESS_ENTITY FEM_FACT_REPOSITORY


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_CUSTOMER_DETAIL_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCALP_DIM_GRP_DISPLAY_CODE
ColumnCAL_PERIOD_NUMBER
ColumnCAL_PERIOD_END_DATE
ColumnCUSTOMER_DISPLAY_CODE
ColumnDATASET_DISPLAY_CODE
ColumnSOURCE_SYSTEM_DISPLAY_CODE
ColumnLEDGER_DISPLAY_CODE
Columns
Name Datatype Length Mandatory Comments
STATUS VARCHAR2 (60) Yes Designates the Status of the row for loading. Records with a STATUS="LOAD" will be loaded by the Source Data Loader. All other STATUS codes designate some sort of error from the load. The user (translated) text description can be found in FND Messages using this error status code as the Message Name.
CALP_DIM_GRP_DISPLAY_CODE VARCHAR2 (150) Yes Calendar Period Dimension Group
CAL_PERIOD_NUMBER NUMBER (15) Yes Calendar Period Number. Provides alternate identification for the Calendar Period, together with Ledger ID, Calendar Period End Date, and Calendar Period Dimension Group Name.
CAL_PERIOD_END_DATE DATE
Yes The end date of the calendar period
DATASET_DISPLAY_CODE VARCHAR2 (150) Yes Dataset identifier.
LEDGER_DISPLAY_CODE VARCHAR2 (150) Yes Ledger identifier.
SOURCE_SYSTEM_DISPLAY_CODE VARCHAR2 (150) Yes Source System Identier.
CUSTOMER_DISPLAY_CODE VARCHAR2 (150) Yes Customer
MARKET_SEGMENT_DISPLAY_CODE VARCHAR2 (150) Yes Market Segment
ADDITIONAL_RES_OWNED_FLAG NUMBER

Additional Residence Owned Flag
ADDITIONAL_RES_RENTED_FLAG NUMBER

Additional Residence Rented Flag
ADDRESS_SUPPLEMENT VARCHAR2 (40)
A freeform note field for adding to the address field
AGE NUMBER

Age
AGE_SEGMENT_CODE VARCHAR2 (20)
Age Segment Code
ANNUAL_INCOME NUMBER

The customers annual income.
BIRTH_DATE DATE

Birth Date
BUSINESS_CONTACT_NAME VARCHAR2 (40)
Business Contact Name
BUSINESS_CONTACT_TITLE VARCHAR2 (40)
Business Contact Title
BUSINESS_OWNER VARCHAR2 (40)
Business Owner
BUSINESS_TYPE_CODE VARCHAR2 (5)
Type of Business
CARRIER_ROUTE VARCHAR2 (5)
Route
CENSUS_BLOCK VARCHAR2 (1)
block
CENSUS_COUNTY VARCHAR2 (3)
county
CENSUS_STATE VARCHAR2 (2)
state
CENSUS_TRACT VARCHAR2 (6)
tract
CITY VARCHAR2 (25)
The city portion of the customer address
COUNTRY VARCHAR2 (40)
The country portion of the customer address
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
CREDIT_SCORE NUMBER

Credit Score
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
EMPLOYER VARCHAR2 (40)
Employer
EMPLOYMENT_START_DATE DATE

Employee Start Date
FAX_PHONE VARCHAR2 (20)
The fax number for the customer
FIRST_CONTACT_DATE DATE

First Contact Date
FIRST_NAME VARCHAR2 (30)
The Given name for the customer.
FULL_NAME VARCHAR2 (40)
The Full name for the customer
GEOGRAPHY_DISPLAY_CODE VARCHAR2 (150)
Geography
GOVERNMENT_ID_NUMBER VARCHAR2 (30)
Government Id Number
HOMEOWNER_FLAG VARCHAR2 (1)
Customer is a Home Owner
HOME_CONTACT_PHONE VARCHAR2 (20)
The home number for the customer
HOME_VALUE NUMBER

Value of Primary Residence
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
IN_BUSINESS_SINCE DATE

In Business Since
LAST_CONTACT_DATE DATE

Last Contact Date
LAST_NAME VARCHAR2 (30)
The surname for the customer
LINE_OF_BUSINESS_CODE VARCHAR2 (5)
Line of Business
MARITAL_STATUS_CODE VARCHAR2 (1)
Marital Status
MIDDLE_NAME VARCHAR2 (30)
The middle name for the customer
NAME_PREFIX VARCHAR2 (20)
A freeform entry column for the standard name prefixes such as Ms., Mrs., Mr, and ect.
NAME_SUFFIX VARCHAR2 (20)
A freeform entry column for the standard name prefixes such as Jr.
NAME_SUPPLEMENT VARCHAR2 (40)
Unknown
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
OTHER_PHONE VARCHAR2 (20)
The alternative number for the customer
POSTAL_CODE VARCHAR2 (30)
Postal code data column
PROPENSITY_TO_BUY VARCHAR2 (10)
Propensity to Buy
RESIDENCE_TYPE_CODE VARCHAR2 (5)
Type of Residence
RESIDENT_YEARS NUMBER

Number of years at residence
RETENTION_SCORE VARCHAR2 (10)
Retention Score
SALUTATION VARCHAR2 (30)
A freeform entry column for the standard name prefixes such as Ms., Mrs., Mr, and ect.
SEX VARCHAR2 (1)
Sex of customer
STATE VARCHAR2 (2)
The state portion of the customer address
STREET_ADDRESS VARCHAR2 (40)
The street address portion of the customer address
STREET_NAME VARCHAR2 (40)
The name of the street that is a portion of the customer address
STREET_NUMBER VARCHAR2 (10)
The number portion of the street address
STREET_NUMBER_SUPPLEMENT VARCHAR2 (10)
A freeform note field for adding to the street address
TELEMARKET_CODE VARCHAR2 (5)
This the marketing channel.
VEHICLE_TYPE_CODE VARCHAR2 (5)
This is category within Product_id
VEHICLE_VALUE NUMBER

Vehicle Value
VIP_FLAG VARCHAR2 (1)
VIP Flag
WORK_BUS_PHONE VARCHAR2 (20)
The business number for the customer
YEARS_AS_CUST NUMBER

Years as customer
YEARS_IN_BUSINESS NUMBER

Years in Business
Query Text

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


SELECT STATUS
,      CALP_DIM_GRP_DISPLAY_CODE
,      CAL_PERIOD_NUMBER
,      CAL_PERIOD_END_DATE
,      DATASET_DISPLAY_CODE
,      LEDGER_DISPLAY_CODE
,      SOURCE_SYSTEM_DISPLAY_CODE
,      CUSTOMER_DISPLAY_CODE
,      MARKET_SEGMENT_DISPLAY_CODE
,      ADDITIONAL_RES_OWNED_FLAG
,      ADDITIONAL_RES_RENTED_FLAG
,      ADDRESS_SUPPLEMENT
,      AGE
,      AGE_SEGMENT_CODE
,      ANNUAL_INCOME
,      BIRTH_DATE
,      BUSINESS_CONTACT_NAME
,      BUSINESS_CONTACT_TITLE
,      BUSINESS_OWNER
,      BUSINESS_TYPE_CODE
,      CARRIER_ROUTE
,      CENSUS_BLOCK
,      CENSUS_COUNTY
,      CENSUS_STATE
,      CENSUS_TRACT
,      CITY
,      COUNTRY
,      COUNTRY_CODE
,      CREDIT_BUREAU_CODE
,      CREDIT_CARD_CODE
,      CREDIT_SCORE
,      CURRENCY_CODE
,      CUSTOMER_AGE_OLDEST
,      CUSTOMER_AGE_YOUNGEST
,      DECEASED_FLAG
,      EDUCATION_LEVEL_CODE
,      EMPLOYEE_FLAG
,      EMPLOYER
,      EMPLOYMENT_START_DATE
,      FAX_PHONE
,      FIRST_CONTACT_DATE
,      FIRST_NAME
,      FULL_NAME
,      GEOGRAPHY_DISPLAY_CODE
,      GOVERNMENT_ID_NUMBER
,      HOMEOWNER_FLAG
,      HOME_CONTACT_PHONE
,      HOME_VALUE
,      INCOME_CLASS_CODE
,      INCOME_SOURCE_CODE
,      IN_BUSINESS_SINCE
,      LAST_CONTACT_DATE
,      LAST_NAME
,      LINE_OF_BUSINESS_CODE
,      MARITAL_STATUS_CODE
,      MIDDLE_NAME
,      NAME_PREFIX
,      NAME_SUFFIX
,      NAME_SUPPLEMENT
,      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
,      OTHER_PHONE
,      POSTAL_CODE
,      PROPENSITY_TO_BUY
,      RESIDENCE_TYPE_CODE
,      RESIDENT_YEARS
,      RETENTION_SCORE
,      SALUTATION
,      SEX
,      STATE
,      STREET_ADDRESS
,      STREET_NAME
,      STREET_NUMBER
,      STREET_NUMBER_SUPPLEMENT
,      TELEMARKET_CODE
,      VEHICLE_TYPE_CODE
,      VEHICLE_VALUE
,      VIP_FLAG
,      WORK_BUS_PHONE
,      YEARS_AS_CUST
,      YEARS_IN_BUSINESS
FROM FEM.FEM_CUSTOMER_DETAIL_T;

Dependencies

[top of page]

FEM.FEM_CUSTOMER_DETAIL_T does not reference any database object

FEM.FEM_CUSTOMER_DETAIL_T is referenced by following:

SchemaAPPS
SynonymFEM_CUSTOMER_DETAIL_T