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

TABLE: HR.PAY_PARAMETERS

Object Details
Object Name: PAY_PARAMETERS
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID


Table holding the detailed information about the parameters including the qualifier for the parameters, the legislation code and business group to which the parameter belongs to and whether override allowed etc


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER (15) Yes Primary key for the parameter record
PARAMETER_DEF_ID NUMBER (15)
Refers to the parent parameter definition table
QUALIFIER VARCHAR2 (30)
Qualifier key specifying the usage of this parameter
OVERRIDE_ALLOWED VARCHAR2 (30)
Specifies whether the overriding of this parameter should be allowed in the process
BUSINESS_GROUP_ID NUMBER (15)
Business group to which this parameter belongs
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
LEGISLATION_CODE VARCHAR2 (30)
Legislation code to which this parameter belongs
Query Text

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


SELECT PARAMETER_ID
,      PARAMETER_DEF_ID
,      QUALIFIER
,      OVERRIDE_ALLOWED
,      BUSINESS_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LEGISLATION_CODE
FROM HR.PAY_PARAMETERS;

Dependencies

[top of page]

HR.PAY_PARAMETERS does not reference any database object

HR.PAY_PARAMETERS is referenced by following:

SchemaHR
ViewPAY_PARAMETERS#