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

TABLE: IEX.IEX_QUESTIONNAIRE_ITEMS

Object Details
Object Name: IEX_QUESTIONNAIRE_ITEMS
Object Type: TABLE
Owner: IEX
Subobject Name:
Status: VALID


Setup table for questionnaire administration


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
QUESTIONNAIRE_ITEM_ID NUMBER
Yes Primary Key
RECEIVABLE_ENABLED VARCHAR2 (1)
Does you organization collect delinquent receivables?
LOAN_ENABLED VARCHAR2 (1)
Does you organization collect loans?
LEASING_ENABLED VARCHAR2 (1)
Does you organization collect lease contracts?
CLAIM_ENABLED VARCHAR2 (1)
Do you need visibility to claims and deductions?
BUSINESS_LEVEL VARCHAR2 (30)
At what level does your organization do business with customers?
DISPLAY_PREF_ENABLED VARCHAR2 (1)
Do you want to review the display settings?
CORRESPONDENCE_ENABLED VARCHAR2 (1)
Do you send correspondence to your customers?
PAYMENT_ENABLED VARCHAR2 (1)
Do collections agents take payment from customers?
CC_ENABLED VARCHAR2 (1)
Do you accept crecit card payment?
EFT_ENABLED VARCHAR2 (1)
Do you accept bank EFT payment?
ADJUSTMENT_ENABLED VARCHAR2 (1)
Do you allow adjustment?
DISPUTE_ENABLED VARCHAR2 (1)
Do you allow dispute?
REVERSAL_ENABLED VARCHAR2 (1)
Do you allow payment reversal?
PROMISE_ENABLED VARCHAR2 (1)
Do you take the promises to pay from customers?
LATER_STAGE_DELINS VARCHAR2 (1)
Which later stage delinquencies does your organization manage?
BANKRUPTCY_ENABLED VARCHAR2 (1)
Does your organization manage bankruptcies?
REPOSESSION_ENABLED VARCHAR2 (1)
Does your organization manage reposession?
LITIGATION_ENABLED VARCHAR2 (1)
Does your organization manage litigation?
WRITEOFF_ENABLED VARCHAR2 (1)
Does your organization manage writeoff?
OTHER_DELIN_ENABLED VARCHAR2 (1)
Does your organization manage other delinquencies?
METRICS_ENABLED VARCHAR2 (1)
Oracle collections includes a number of seeded metrics calculations from which you can select. Do you want to review these metrics?
COLLECTIONS_METHODS VARCHAR2 (30)
Which collections method does your organization use?(Dunning/Strategies)
COLLECT_SEGMENTS_ENABLED VARCHAR2 (1)
Do you collect from different types, or segments, of customers?
CUSTOMER_SCORING_ENABLED VARCHAR2 (1)
Do you consider the degree of delinquency or the value of your customers when you collect?
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT QUESTIONNAIRE_ITEM_ID
,      RECEIVABLE_ENABLED
,      LOAN_ENABLED
,      LEASING_ENABLED
,      CLAIM_ENABLED
,      BUSINESS_LEVEL
,      DISPLAY_PREF_ENABLED
,      CORRESPONDENCE_ENABLED
,      PAYMENT_ENABLED
,      CC_ENABLED
,      EFT_ENABLED
,      ADJUSTMENT_ENABLED
,      DISPUTE_ENABLED
,      REVERSAL_ENABLED
,      PROMISE_ENABLED
,      LATER_STAGE_DELINS
,      BANKRUPTCY_ENABLED
,      REPOSESSION_ENABLED
,      LITIGATION_ENABLED
,      WRITEOFF_ENABLED
,      OTHER_DELIN_ENABLED
,      METRICS_ENABLED
,      COLLECTIONS_METHODS
,      COLLECT_SEGMENTS_ENABLED
,      CUSTOMER_SCORING_ENABLED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM IEX.IEX_QUESTIONNAIRE_ITEMS;

Dependencies

[top of page]

IEX.IEX_QUESTIONNAIRE_ITEMS does not reference any database object

IEX.IEX_QUESTIONNAIRE_ITEMS is referenced by following:

SchemaAPPS
SynonymIEX_QUESTIONNAIRE_ITEMS