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: HR.PER_PROPOSAL_QUESTION_MEMBERS

Object Details

Object Name:	PER_PROPOSAL_QUESTION_MEMBERS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_PROPOSAL_QUESTION_MEMBERS
Subobject Name:
Status:	VALID

PER_PROPOSAL_QUESTION_MEMBERS contains the specific questions that a
hiring manager is going to see when she selects an offer profile
to work with.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_PROPOSAL_QUESTION_MEMBE_PK

PROPOSAL_QUESTION_MEMBER_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_PROPOSAL_QUESTION_MEMBE_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROPOSAL_QUESTION_MEMBER_ID
PER_PROPOSAL_QUESTION_MEMBE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROPOSAL_QUESTION_NAME
PER_PROPOSAL_QUESTION_MEMBE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROPOSAL_CATEGORY_MEMBER_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_PROPOSAL_QUESTION_MEMBERS		PER_PROPOSAL_CATEGORY_MEMBERS	PER_PROPOSAL_QUESTION_MEMBERS PROPOSAL_CATEGORY_MEMBER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_QUESTION_MEMBER_ID	NUMBER	(15)	Yes	System-generated primary key column.
PROPOSAL_QUESTION_NAME	VARCHAR2	(60)	Yes	Foreign key to PER_PROPOSAL_QUESTION_TYPES.
PROPOSAL_CATEGORY_MEMBER_ID	NUMBER	(15)	Yes	Foreign key to PER_PROPOSAL_CATEGORY_MEMBERS.
APPROVAL_DISPLAY_STATUS	VARCHAR2	(30)	Yes	The value of this column determines if the approval mgr will see the question and answer always, only if the hiring manger entered a value for the question or only on the 'details' page.
FULL_TEXT	VARCHAR2	(2000)		The label for the question that the hiring manger will see on the web offers page. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
ALIGN	VARCHAR2	(30)		The alignment for the the question that the hiring manger will see on the web offers page. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
QUESTION_HEADER	VARCHAR2	(2000)		A label that displays above the question label. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
HELP_TEXT	VARCHAR2	(2000)		Not used at this time.
NOTE_TEXT	VARCHAR2	(2000)		Placing a value here causes the question to have field level help on the web offers page. Overrides any value in PER_PROPOSAL_QUESTION_TYPES, unless this value is null and the Types table has a value.
DEFAULT_VALUE_TYPE	VARCHAR2	(30)		Is the default value for the field based on SQL or a specific value. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
DEFAULT_VALUE	VARCHAR2	(2000)		The default value for the question that the hiring manger will see on the web offers page. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
LOOKUP_TYPE	VARCHAR2	(80)		If the question is a combo list or radio button, this causes the values available to come from a specific lookup type. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
OPTION_SQL_TEXT	VARCHAR2	(2000)		If the question is a combo list or radio button, this causes the values available to come from running the specified SQL statement. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
PROVIDE_FIND	VARCHAR2	(1)		If the question requires a list of values, this field should be 'Y'. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
FIND_FILTER_COLUMN	VARCHAR2	(2000)		If the question requires a list of values, this field indicates what column in the FIND_SELECT_SQL should be written back to this question's answer value. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
FIND_SELECT_SQL	VARCHAR2	(2000)		If the question requires a list of values, this field contains the SQL to run the list of values. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
QUESTION_DISPLAY_ORDER	NUMBER	(5)	Yes	The order this question should appear on the Web Offers page in relation to the other questions within the same category. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
TYPE	VARCHAR2	(30)		Identifies the Question Member as being for either a Candidate Offer or an Appraisal Questionnaire
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE			Standard who columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
CREATED_BY	NUMBER	(15)		Standard who column

Query Text

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


SELECT PROPOSAL_QUESTION_MEMBER_ID
,      PROPOSAL_QUESTION_NAME
,      PROPOSAL_CATEGORY_MEMBER_ID
,      APPROVAL_DISPLAY_STATUS
,      FULL_TEXT
,      ALIGN
,      QUESTION_HEADER
,      HELP_TEXT
,      NOTE_TEXT
,      DEFAULT_VALUE_TYPE
,      DEFAULT_VALUE
,      LOOKUP_TYPE
,      OPTION_SQL_TEXT
,      PROVIDE_FIND
,      FIND_FILTER_COLUMN
,      FIND_SELECT_SQL
,      QUESTION_DISPLAY_ORDER
,      TYPE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM HR.PER_PROPOSAL_QUESTION_MEMBERS;

Dependencies

[top of page]

HR.PER_PROPOSAL_QUESTION_MEMBERS does not reference any database object

HR.PER_PROPOSAL_QUESTION_MEMBERS is referenced by following:

APPS: PER_PROPOSAL_QUESTION_MEMBERS; PER_PROPOSAL_QUESTION_MEMB_WHO
PUBLIC: PER_PROPOSAL_QUESTION_MEMBERS