[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_PERSONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_DM_PERSONS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | Yes | Party identifier. | |
PERSON_FIRST_NAME | VARCHAR2 | (240) | First name of the person. | |
PERSON_MIDDLE_NAME | VARCHAR2 | (240) | Middle name of the person. | |
PERSON_LAST_NAME | VARCHAR2 | (240) | Last or surname of the person. | |
PERSON_NAME_SUFFIX | VARCHAR2 | (240) | Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix. | |
PERSON_TITLE | VARCHAR2 | (240) | A professional or family title. | |
PERSON_ACADEMIC_TITLE | VARCHAR2 | (240) | Academic title that is part of a person's name. | |
PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | (240) | Salutary introduction. | |
EMAIL_ADDRESS | VARCHAR2 | (240) | E-mail address. | |
ADDRESS1 | VARCHAR2 | (240) | First line of address. | |
ADDRESS2 | VARCHAR2 | (240) | Second line of address. | |
CITY | VARCHAR2 | (120) | The city of the party's registered location. | |
STATE | VARCHAR2 | (60) | State. | |
PROVINCE | VARCHAR2 | (60) | Province. | |
COUNTY | VARCHAR2 | (60) | County. | |
ZIP_CODE | VARCHAR2 | (60) | Zip code. | |
COUNTRY | VARCHAR2 | (60) | Country. | |
COMPETITOR_FLAG | VARCHAR2 | (240) | Indicates if a party is a competitor. | |
THIRD_PARTY_FLAG | VARCHAR2 | (240) | Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. | |
GENDER | VARCHAR2 | (30) | Gender. | |
ETHNICITY | VARCHAR2 | (60) | Ethnicity. | |
MARITAL_STATUS | VARCHAR2 | (30) | Marital status. | |
PERSONAL_INCOME | NUMBER | Personal income. | ||
HOH_FLAG | VARCHAR2 | (1) | Head of household indicator. | |
HOUSEHOLD_INCOME | NUMBER | Household income. | ||
HOUSEHOLD_SIZE | NUMBER | Household size. | ||
APARTMENT_FLAG | VARCHAR2 | (1) | Apartment indicator. | |
RENT_FLAG | VARCHAR2 | (1) | Rent indicator. | |
DEGREE_RECEIVED | VARCHAR2 | (1) | Degree received. | |
SCHOOL_TYPE | VARCHAR2 | (60) | School type. | |
INTEREST_ART_FLAG | VARCHAR2 | (1) | Interest in art indicator. | |
INTEREST_BOOKS_FLAG | VARCHAR2 | (1) | Interest in books indicator. | |
INTEREST_MOVIES_FLAG | VARCHAR2 | (1) | Interest in movies indicator. | |
INTEREST_MUSIC_FLAG | VARCHAR2 | (1) | Interest in music indicator. | |
INTEREST_THEATER_FLAG | VARCHAR2 | (1) | Interest in theater indicator. | |
INTEREST_TRAVEL_FLAG | VARCHAR2 | (1) | Interest in travel indicator. | |
INTEREST_DRINK_FLAG | VARCHAR2 | (1) | Interest in drinking indicator. | |
INTEREST_SMOKE_FLAG | VARCHAR2 | (1) | Interest in smoking indicator. | |
INTEREST_OTHER_FLAG | VARCHAR2 | (1) | Other interests indicator. | |
EMPLOYED_FLAG | VARCHAR2 | (1) | Employed indicator. | |
YEARS_EMPLOYED | NUMBER | Number of years employed. | ||
OCCUPATION | VARCHAR2 | (60) | Occupation. | |
MILITARY_BRANCH | VARCHAR2 | (80) | Military branch served. | |
RESIDENCE_TYPE | VARCHAR2 | (30) | Residence type. | |
RESIDENT_LENGTH | NUMBER | Number of years stayed at current residence. | ||
PRESENCE_OF_CHILDREN | NUMBER | Presence of children indicator. | ||
REFERENCE_USE_FLAG | VARCHAR2 | (1) | Indicates if customer has agreed to be a reference. | |
CREDIT_CHECK_FLAG | VARCHAR2 | (1) | Indicates whether a credit check is to be carried out. | |
TOLERANCE | NUMBER | Percentage over credit limit that this customer can exceed before action is taken. | ||
DISCOUNT_TERMS_FLAG | VARCHAR2 | (1) | Indicates if discount terms exist. Y for discount terms are allowed, N for no discount terms are allowed. | |
DUNNING_LETTERS_FLAG | VARCHAR2 | (1) | Indicates if dunning letters are sent to this customer when invoices, debit memos or chargebacks become past due. Y for dunning letters are sent, N for no dunning letters. | |
INTEREST_CHARGES_FLAG | VARCHAR2 | (1) | Indicates if this customer is charged interest. | |
SEND_STATEMENTS_FLAG | VARCHAR2 | (1) | Indicates if statements are sent to this customer. | |
CREDIT_HOLD_FLAG | VARCHAR2 | (1) | Indicates if a credit hold exists on this account. | |
CREDIT_RATING | VARCHAR2 | (60) | Credit rating. | |
RISK_CODE | VARCHAR2 | (60) | Risk code. | |
AGE | NUMBER | Age, in days, of a person. | ||
DAYS_SINCE_LAST_EVENT | NUMBER | Number of days since last attended an event. | ||
DAYS_SINCE_LAST_SCHOOL | NUMBER | Number of days since last attended school. | ||
NUM_TIMES_TARGETED | NUMBER | Number of times targeted. | ||
LAST_TARGETED_CHANNEL_CODE | NUMBER | Last targeted channel. | ||
TIMES_TARGETED_MONTH | NUMBER | Number of times targeted in the last month. | ||
TIMES_TARGETED_3_MONTHS | NUMBER | Number of times targeted in the last 3 months. | ||
TIMES_TARGETED_6_MONTHS | NUMBER | Number of times targeted in the last 6 months. | ||
TIMES_TARGETED_12_MONTHS | NUMBER | Number of times targeted in the last 12 months. | ||
DAYS_SINCE_LAST_TARGETED | NUMBER | Number of days since the last time targeted. | ||
AVG_DISC_OFFERED | NUMBER | Average discount offered. | ||
NUM_TYPES_DISC_OFFERED | NUMBER | Number of types of discounts offered. | ||
NUM_TIMES_TARGETED_EMAIL | NUMBER | Number of times targeted by email. | ||
NUM_TIMES_TARGETED_DIRECT | NUMBER | Number of times targeted by direct mail. | ||
NUM_TIMES_TARGETED_TELEMKT | NUMBER | Number of times targeted by telemarketing. | ||
NUM_TGT_BY_OFFR_TYP1 | NUMBER | Number of times targeted by offer 1. | ||
NUM_TGT_BY_OFFR_TYP2 | NUMBER | Number of times targeted by offer 2. | ||
NUM_TGT_BY_OFFR_TYP3 | NUMBER | Number of times targeted by offer 3. | ||
NUM_TGT_BY_OFFR_TYP4 | NUMBER | Number of times targeted by offer 4. | ||
DAYS_SINCE_FIRST_CONTACT | NUMBER | Number of days since the first contact. | ||
AVG_TALK_TIME | NUMBER | Average talk time. | ||
AVG_ORDER_AMOUNT | NUMBER | Average order amount. | ||
AVG_UNITS_PER_ORDER | NUMBER | Averge units per order. | ||
TOT_ORDER_AMOUNT_YEAR | NUMBER | Total order amount in the past year. | ||
TOT_ORDER_AMOUNT_9_MONTHS | NUMBER | Total order amount in the past 9 months. | ||
TOT_ORDER_AMOUNT_6_MONTHS | NUMBER | Total order amount in the past 6 months. | ||
TOT_ORDER_AMOUNT_3_MONTHS | NUMBER | Total order amount in the past 3 months. | ||
TOT_NUM_ORDERS_YEAR | NUMBER | Total number of orders in the past year. | ||
TOT_NUM_ORDER_9_MONTHS | NUMBER | Total number of orders in the past 9 months. | ||
TOT_NUM_ORDER_6_MONTHS | NUMBER | Total number of orders in the past 6 months. | ||
TOT_NUM_ORDER_3_MONTHS | NUMBER | Total number of orders in the past 3 months. | ||
DAYS_SINCE_ACCT_ESTABLISHED | NUMBER | Number of days since account established. | ||
DAYS_SINCE_ACCT_TERM | NUMBER | Number of days since account terms. | ||
DAYS_SINCE_ACCT_ACTIVATION | NUMBER | Number of days since account activation. | ||
DAYS_SINCE_ACCT_SUSPENDED | NUMBER | Number of days since the account was suspended. | ||
NUM_OF_SR_YEAR | NUMBER | Number of service requests in the past year. | ||
NUM_OF_SR_6_MONTHS | NUMBER | Number of service requests in the past 6 months. | ||
NUM_OF_SR_3_MONTHS | NUMBER | Number of service requests in the past 3 months. | ||
NUM_OF_SR_1_MONTH | NUMBER | Number of service requests in the past month. | ||
AVG_RESOLVE_DAYS_YEAR | NUMBER | Average number of days to resolve in the past year. | ||
AVG_RESOLVE_DAYS_6_MONTHS | NUMBER | Average number of days to resolve in the past 6 months. | ||
AVG_RESOLVE_DAYS_3_MONTHS | NUMBER | Average number of days to resolve in the past 3 months. | ||
AVG_RESOLVE_DAYS_1_MONTH | NUMBER | Average number of days to resolve in the past month. | ||
ORDER_LINES_DELIVERED | NUMBER | Number of order lines delivered. | ||
ORDER_LINES_ONTIME | NUMBER | Number of order lines delivered on time. | ||
ORDER_QTY_CUMUL | NUMBER | Cumulative order quantity. | ||
ORDER_RECENCY | NUMBER | Order recency. | ||
PAYMENTS | NUMBER | Payments. | ||
RETURNS | NUMBER | Returns. | ||
RETURN_BY_VALUE | NUMBER | Return by value. | ||
RETURN_BY_VALUE_PCT | NUMBER | Return by percentage value. | ||
ONTIME_PAYMENTS | NUMBER | On time payments. | ||
ONTIME_SHIP_PCT | NUMBER | Ontime ship percentage. | ||
CLOSED_SRS | NUMBER | Closed service requests. | ||
COGS | NUMBER | Cost of goods. | ||
CONTRACTS_CUML | NUMBER | Cumulative contracts. | ||
CONTRACT_AMT | NUMBER | Contract amount. | ||
CONTRACT_DURATION | NUMBER | Contract duration. | ||
INACTIVE_CONTRACTS | NUMBER | Inactive contracts. | ||
OPEN_CONTRACTS | NUMBER | Open contracts. | ||
NEW_CONTRACTS | NUMBER | New contracts. | ||
RENEWED_CONTRACTS | NUMBER | Renewed contracts. | ||
ESCALATED_SRS | NUMBER | Escalated service requests. | ||
FIRST_CALL_CL_RATE | NUMBER | First call close rate. | ||
NUM_OF_COMPLAINTS | NUMBER | Number of complaints. | ||
NUM_OF_INTERACTIONS | NUMBER | Number of interactions. | ||
NUM_OF_TRANSFERS | NUMBER | Number of transfers. | ||
OPEN_SRS | NUMBER | Open service requests. | ||
PCT_CALL_REWORK | NUMBER | Percentage of calls reworked. | ||
PRODUCTS | NUMBER | Products. | ||
REFERALS | NUMBER | Referrals. | ||
REOPENED_SRS | NUMBER | Re-opened service requests. | ||
SALES | NUMBER | Sales. | ||
TOTAL_SR_RESPONSE_TIME | NUMBER | Total service request response time. | ||
PCT_FIRST_CLOSED_SRS | NUMBER | Percentage of first closed service requests. | ||
AVG_COMPLAINTS | NUMBER | Average complaints. | ||
AVG_HOLD_TIME | NUMBER | Average hold time. | ||
AVG_LEN_OF_EMP | NUMBER | Average length of employment. | ||
AVG_TRANSFERS_PER_SR | NUMBER | Average transfers per service request. | ||
AVG_WORKLOAD | NUMBER | Average workload. | ||
TOT_CALLS | NUMBER | Total calls. | ||
CALL_LENGTH | NUMBER | Call length. | ||
PROFITABILITY | NUMBER | Profitability. | ||
SEEDED_TARGET | VARCHAR2 | (0) | Dummy column used for programmatic identification of seeded data mining data sources and target fields. Not intended for use by customers. |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_LAST_NAME
, PERSON_NAME_SUFFIX
, PERSON_TITLE
, PERSON_ACADEMIC_TITLE
, PERSON_PRE_NAME_ADJUNCT
, EMAIL_ADDRESS
, ADDRESS1
, ADDRESS2
, CITY
, STATE
, PROVINCE
, COUNTY
, ZIP_CODE
, COUNTRY
, COMPETITOR_FLAG
, THIRD_PARTY_FLAG
, GENDER
, ETHNICITY
, MARITAL_STATUS
, PERSONAL_INCOME
, HOH_FLAG
, HOUSEHOLD_INCOME
, HOUSEHOLD_SIZE
, APARTMENT_FLAG
, RENT_FLAG
, DEGREE_RECEIVED
, SCHOOL_TYPE
, INTEREST_ART_FLAG
, INTEREST_BOOKS_FLAG
, INTEREST_MOVIES_FLAG
, INTEREST_MUSIC_FLAG
, INTEREST_THEATER_FLAG
, INTEREST_TRAVEL_FLAG
, INTEREST_DRINK_FLAG
, INTEREST_SMOKE_FLAG
, INTEREST_OTHER_FLAG
, EMPLOYED_FLAG
, YEARS_EMPLOYED
, OCCUPATION
, MILITARY_BRANCH
, RESIDENCE_TYPE
, RESIDENT_LENGTH
, PRESENCE_OF_CHILDREN
, REFERENCE_USE_FLAG
, CREDIT_CHECK_FLAG
, TOLERANCE
, DISCOUNT_TERMS_FLAG
, DUNNING_LETTERS_FLAG
, INTEREST_CHARGES_FLAG
, SEND_STATEMENTS_FLAG
, CREDIT_HOLD_FLAG
, CREDIT_RATING
, RISK_CODE
, AGE
, DAYS_SINCE_LAST_EVENT
, DAYS_SINCE_LAST_SCHOOL
, NUM_TIMES_TARGETED
, LAST_TARGETED_CHANNEL_CODE
, TIMES_TARGETED_MONTH
, TIMES_TARGETED_3_MONTHS
, TIMES_TARGETED_6_MONTHS
, TIMES_TARGETED_12_MONTHS
, DAYS_SINCE_LAST_TARGETED
, AVG_DISC_OFFERED
, NUM_TYPES_DISC_OFFERED
, NUM_TIMES_TARGETED_EMAIL
, NUM_TIMES_TARGETED_DIRECT
, NUM_TIMES_TARGETED_TELEMKT
, NUM_TGT_BY_OFFR_TYP1
, NUM_TGT_BY_OFFR_TYP2
, NUM_TGT_BY_OFFR_TYP3
, NUM_TGT_BY_OFFR_TYP4
, DAYS_SINCE_FIRST_CONTACT
, AVG_TALK_TIME
, AVG_ORDER_AMOUNT
, AVG_UNITS_PER_ORDER
, TOT_ORDER_AMOUNT_YEAR
, TOT_ORDER_AMOUNT_9_MONTHS
, TOT_ORDER_AMOUNT_6_MONTHS
, TOT_ORDER_AMOUNT_3_MONTHS
, TOT_NUM_ORDERS_YEAR
, TOT_NUM_ORDER_9_MONTHS
, TOT_NUM_ORDER_6_MONTHS
, TOT_NUM_ORDER_3_MONTHS
, DAYS_SINCE_ACCT_ESTABLISHED
, DAYS_SINCE_ACCT_TERM
, DAYS_SINCE_ACCT_ACTIVATION
, DAYS_SINCE_ACCT_SUSPENDED
, NUM_OF_SR_YEAR
, NUM_OF_SR_6_MONTHS
, NUM_OF_SR_3_MONTHS
, NUM_OF_SR_1_MONTH
, AVG_RESOLVE_DAYS_YEAR
, AVG_RESOLVE_DAYS_6_MONTHS
, AVG_RESOLVE_DAYS_3_MONTHS
, AVG_RESOLVE_DAYS_1_MONTH
, ORDER_LINES_DELIVERED
, ORDER_LINES_ONTIME
, ORDER_QTY_CUMUL
, ORDER_RECENCY
, PAYMENTS
, RETURNS
, RETURN_BY_VALUE
, RETURN_BY_VALUE_PCT
, ONTIME_PAYMENTS
, ONTIME_SHIP_PCT
, CLOSED_SRS
, COGS
, CONTRACTS_CUML
, CONTRACT_AMT
, CONTRACT_DURATION
, INACTIVE_CONTRACTS
, OPEN_CONTRACTS
, NEW_CONTRACTS
, RENEWED_CONTRACTS
, ESCALATED_SRS
, FIRST_CALL_CL_RATE
, NUM_OF_COMPLAINTS
, NUM_OF_INTERACTIONS
, NUM_OF_TRANSFERS
, OPEN_SRS
, PCT_CALL_REWORK
, PRODUCTS
, REFERALS
, REOPENED_SRS
, SALES
, TOTAL_SR_RESPONSE_TIME
, PCT_FIRST_CLOSED_SRS
, AVG_COMPLAINTS
, AVG_HOLD_TIME
, AVG_LEN_OF_EMP
, AVG_TRANSFERS_PER_SR
, AVG_WORKLOAD
, TOT_CALLS
, CALL_LENGTH
, PROFITABILITY
, SEEDED_TARGET
FROM APPS.AMS_DM_PERSONS_V;
APPS.AMS_DM_PERSONS_V is not referenced by any database object
|
|
|