[Home] [Help] [Dependency Information]
Object Name: | FEM_CUSTOMER_DETAIL |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Customer Detail
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
FEM.FEM_CUSTOMER_DETAIL does not reference any database object
FEM.FEM_CUSTOMER_DETAIL is referenced by following:
|
|
|