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_PATCH_STATUS

Object Details

Object Name:	PAY_PATCH_STATUS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_PATCH_STATUS
Subobject Name:
Status:	VALID

PAY_PATCH_STATUS is used to check the patching level of
Payroll customers. It is currently only populated for the US
legislation. Helps in tracking if the pre-requisites for a patch
have been applied.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: PAY_PATCH_STATUS_PK

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_PATCH_STATUS_PK	NORMAL	UNIQUE	APPS_TS_SEED	ID
PAY_PATCH_STATUS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	PATCH_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_US_GEO_UPDATE		PAY_PATCH_STATUS	PAY_US_GEO_UPDATE ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER	(15)	Yes	System-generated primary key column.
PATCH_NUMBER	NUMBER	(15)	Yes	ARU or Bug number of the patch
PATCH_NAME	VARCHAR2	(240)	Yes	Name of the patch
PHASE	VARCHAR2	(30)		Last successfully completed phase of a multi-phase patch to complete successfuly
PROCESS_TYPE	VARCHAR2	(100)		Indicates the type of patch. For example: Statutory update
APPLIED_DATE	DATE			The date on which the patch was initialy applied
STATUS	VARCHAR2	(2)		Status of the patch
DESCRIPTION	VARCHAR2	(4000)		Description of the contents of the patch
UPDATE_DATE	DATE			Date of the most recent application of the patch
LEGISLATION_CODE	VARCHAR2	(30)		Foreign Key to FND_TERRITORIES.
APPLICATION_RELEASE	VARCHAR2	(10)		Release of Application patch was applied in.
PREREQ_PATCH_NAME	VARCHAR2	(240)		Pre-requisite patch name

Query Text

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


SELECT ID
,      PATCH_NUMBER
,      PATCH_NAME
,      PHASE
,      PROCESS_TYPE
,      APPLIED_DATE
,      STATUS
,      DESCRIPTION
,      UPDATE_DATE
,      LEGISLATION_CODE
,      APPLICATION_RELEASE
,      PREREQ_PATCH_NAME
FROM HR.PAY_PATCH_STATUS;

Dependencies

[top of page]

HR.PAY_PATCH_STATUS does not reference any database object

HR.PAY_PATCH_STATUS is referenced by following:

APPS: PAY_PATCH_STATUS
PUBLIC: PAY_PATCH_STATUS