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.PAY_PARA_SET_VARIABLES

Object Details

Object Name:	PAY_PARA_SET_VARIABLES
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

This table holds the information about the parameters which belong to a particular set specified in the pay_parameter_sets

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SET_VARIABLE_ID	NUMBER	(15)	Yes	Primary key for the set variable
SET_ID	NUMBER	(15)		The set to which the variable belongs to
PARAMETER_ID	NUMBER	(15)		The parameter which is used for this variable
GROUP_ID	NUMBER	(15)		The group which this variable belongs to
VARIABLE_TYPE	VARCHAR2	(30)		Data type of the variable being used.
DEFAULT_TYPE	VARCHAR2	(30)		Type of the defaulting used. Can be SQL or Constant
DEFAULT_VALUE	VARCHAR2	(30)		Default value to be used for this variable.
DESCRIPTION	VARCHAR2	(200)		Desciription of the usage of this variable.
DISPLAY_FLAG	VARCHAR2	(1)	Yes	Flag specifying whether the variable should be displayed in the flow UI
SET_VAR_SEQUENCE	NUMBER	(15)		Sequence in which the variable should be used in the process.
BUSINESS_GROUP_ID	NUMBER	(15)		Business group to which this variable belongs to
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code to which this variable belongs to
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column

Query Text

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


SELECT SET_VARIABLE_ID
,      SET_ID
,      PARAMETER_ID
,      GROUP_ID
,      VARIABLE_TYPE
,      DEFAULT_TYPE
,      DEFAULT_VALUE
,      DESCRIPTION
,      DISPLAY_FLAG
,      SET_VAR_SEQUENCE
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_PARA_SET_VARIABLES;

Dependencies

[top of page]

HR.PAY_PARA_SET_VARIABLES does not reference any database object

HR.PAY_PARA_SET_VARIABLES is referenced by following:

HR: PAY_PARA_SET_VARIABLES#