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_US_GEO_UPDATE

Object Details

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

PAY_US_GEO_UPDATE is used to keep a detailed log of changes
made to the employee tax data due to geocode changes. The
table is populated by the periodic geocode patch with details
about the previous and new geocodes for the assignments.
The table is also used to generate a report of changes for the user.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_US_GEO_UPDATE_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	ASSIGNMENT_ID
PAY_US_GEO_UPDATE_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	ID
PAY_US_GEO_UPDATE_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	PROCESS_TYPE PROCESS_MODE PROCESS_DATE ASSIGNMENT_ID

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	Id from pay_patch_status
ASSIGNMENT_ID	NUMBER	(15)		Assignment id from per_all_assignments_f
PERSON_ID	NUMBER	(15)		person_id from per_all_people_f
TABLE_NAME	VARCHAR2	(30)		Name of the table for which the data has been modified.
TABLE_VALUE_ID	NUMBER	(30)		Unique identifier for the table referenced in the table_name column
OLD_JURI_CODE	VARCHAR2	(30)		Jurisdiction code before the patch was applied.
NEW_JURI_CODE	VARCHAR2	(30)		The modified jurisdiction code.
PROCESS_TYPE	VARCHAR2	(30)		The type of geocode change.
PROCESS_DATE	DATE			Date on which the patch was applied.
PROCESS_MODE	VARCHAR2	(20)		Mode in which the patch was run. Can be 'DEBUG' or 'UPGRADE'.
STATUS	VARCHAR2	(10)		For future use.
DESCRIPTION	VARCHAR2	(1000)		For future use

Query Text

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


SELECT ID
,      ASSIGNMENT_ID
,      PERSON_ID
,      TABLE_NAME
,      TABLE_VALUE_ID
,      OLD_JURI_CODE
,      NEW_JURI_CODE
,      PROCESS_TYPE
,      PROCESS_DATE
,      PROCESS_MODE
,      STATUS
,      DESCRIPTION
FROM HR.PAY_US_GEO_UPDATE;

Dependencies

[top of page]

HR.PAY_US_GEO_UPDATE does not reference any database object

HR.PAY_US_GEO_UPDATE is referenced by following:

APPS: PAY_US_GEO_UPDATE
PUBLIC: PAY_US_GEO_UPDATE