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

Object Details

Object Name:	GHR_PA_DATA_FIELDS
Object Type:	TABLE
Owner:	HR
FND Design Data:	GHR.GHR_PA_DATA_FIELDS
Subobject Name:
Status:	VALID

GHR_PA_DATA_FIELDS holds the fields that are available on the request
for personnel action form and the extra information. Each data field
can then be associated to a processing method type family to
determine a processing method for that data field in that family (e.g.
Auto Populate, Non enterable). Each data field can also be associated
to a required type family to determine which data fields in that
family are required upon update to HR.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: GHR_PA_DATA_FIELDS_PK

PA_DATA_FIELD_ID

Unique Key: GHR_PA_DATA_FIELDS_UK1

NAME

Unique Key: GHR_PA_DATA_FIELDS_UK2

FORM_BLOCK_NAME
FORM_FIELD_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
GHR_PA_DATA_FIELDS_PK	NORMAL	UNIQUE	APPS_TS_SEED	PA_DATA_FIELD_ID
GHR_PA_DATA_FIELDS_UK1	NORMAL	UNIQUE	APPS_TS_SEED	NAME
GHR_PA_DATA_FIELDS_UK2	NORMAL	UNIQUE	APPS_TS_SEED	FORM_BLOCK_NAME FORM_FIELD_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
GHR_NOA_FAM_PROC_METHODS		GHR_PA_DATA_FIELDS	GHR_NOA_FAM_PROC_METHODS PA_DATA_FIELD_ID
GHR_RESTRICTED_PROC_METHODS		GHR_PA_DATA_FIELDS	GHR_RESTRICTED_PROC_METHODS PA_DATA_FIELD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PA_DATA_FIELD_ID	NUMBER	(15)	Yes	System-generated primary key from GHR_PA_DATA_FIELDS_S.
NAME	VARCHAR2	(30)	Yes	Personnel action data field name.
FORM_BLOCK_NAME	VARCHAR2	(30)		The block name in the form in which the data field occurs.
FORM_FIELD_NAME	VARCHAR2	(30)		The field name in the form in which the data field occurs.
RECORD_STRUCTURE_NAME	VARCHAR2	(30)		The name of the record structure in which the data field occurs. Used in update HR.
RECORD_STRUCTURE_COL_NAME	VARCHAR2	(30)		The column name in the record structure in which the data field occurs. Used in update HR.
ENABLED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the data field is enabled.
DATE_FROM	DATE		Yes	The date on which the data field becomes effective.
DATE_TO	DATE			The date after which the data field is no longer effective.
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column.
CREATED_BY	NUMBER	(15)	Yes	Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.

Query Text

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


SELECT PA_DATA_FIELD_ID
,      NAME
,      FORM_BLOCK_NAME
,      FORM_FIELD_NAME
,      RECORD_STRUCTURE_NAME
,      RECORD_STRUCTURE_COL_NAME
,      ENABLED_FLAG
,      DATE_FROM
,      DATE_TO
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.GHR_PA_DATA_FIELDS;

Dependencies

[top of page]

HR.GHR_PA_DATA_FIELDS does not reference any database object

HR.GHR_PA_DATA_FIELDS is referenced by following:

APPS: GHR_PA_DATA_FIELDS; GHR_PA_DATA_FIELDS_WHO
PUBLIC: GHR_PA_DATA_FIELDS