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_TYPES

Object Details

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

PER_PROPOSAL_QUESTION_TYPES contains a list of web offer questions
that can be used in a specific offer profile. It defines the question
label, its html definition, whether the question has field-level help
and what kind of list of values is available..

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_PROPOSAL_QUESTIONS_TYPE_PK

PROPOSAL_QUESTION_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_PROPOSAL_QUESTIONS_TYPE_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROPOSAL_QUESTION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_QUESTION_NAME	VARCHAR2	(60)	Yes	The primary key column.
FULL_TEXT	VARCHAR2	(2000)		The label for the question that the hiring manger will see on the web offers page.
ALIGN	VARCHAR2	(30)		The alignment for the the question that the hiring manger will see on the web offers page.
QUESTION_HEADER	VARCHAR2	(2000)		A label that displays above the question label.
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.
HTML_TYPE	VARCHAR2	(30)	Yes	Determines the HTML style of field that this question uses on the web offers page.
WIDTH_SIZE	NUMBER	(9)		Determines how wide the question entry area will be on the web offer page.
HEIGHT_SIZE	NUMBER	(9)		For HTML styles that take a 'height' parameter, this defines how large the field will display.
MAXLENGTH	NUMBER	(9)		The maximum number of characters allowed for entry.
DEFAULT_VALUE_TYPE	VARCHAR2	(30)		Is the default value for the field based on SQL or a specific value.
DEFAULT_VALUE	VARCHAR2	(2000)		The default value for the question that the hiring manger will see on the web offers page.
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.
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.
PROVIDE_FIND	VARCHAR2	(1)		If the question requires a list of values, this field should be 'Y'.
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.
FIND_SELECT_SQL	VARCHAR2	(2000)		If the question requires a list of values, this field contains the SQL to run the list of values.
TYPE	VARCHAR2	(30)		Identifies the Question Type 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 column
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_NAME
,      FULL_TEXT
,      ALIGN
,      QUESTION_HEADER
,      HELP_TEXT
,      NOTE_TEXT
,      HTML_TYPE
,      WIDTH_SIZE
,      HEIGHT_SIZE
,      MAXLENGTH
,      DEFAULT_VALUE_TYPE
,      DEFAULT_VALUE
,      LOOKUP_TYPE
,      OPTION_SQL_TEXT
,      PROVIDE_FIND
,      FIND_FILTER_COLUMN
,      FIND_SELECT_SQL
,      TYPE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM HR.PER_PROPOSAL_QUESTION_TYPES;

Dependencies

[top of page]

HR.PER_PROPOSAL_QUESTION_TYPES does not reference any database object

HR.PER_PROPOSAL_QUESTION_TYPES is referenced by following:

APPS: PER_PROPOSAL_QUESTION_TYPES; PER_PROPOSAL_QUESTION_TYPE_WHO
PUBLIC: PER_PROPOSAL_QUESTION_TYPES