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

Object Details

Object Name:	HR_STU_HISTORY
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_STU_HISTORY
Subobject Name:
Status:	VALID

HR_STU_HISTORY records which versions of HRMS startup data have been
installed. It records ,for each Legislation, what version of the
startup data dat file has been imported into the account and whether
the merge of that data was successful.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_STU_HISTORY_PK	NORMAL	UNIQUE	APPS_TS_SEED	PACKAGE_NAME ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
PACKAGE_NAME	VARCHAR2	(30)	Yes	Label identifying the version of dat file installed
DATE_OF_EXPORT	DATE		Yes	Date the dat file was created
DATE_OF_IMPORT	DATE		Yes	Date the DAT file was installed
STATUS	VARCHAR2	(240)	Yes	Whether the merge is in Phase1/Phase2/Complete
LEGISLATION_CODE	VARCHAR2	(30)		Foreign key to FND_TERRITORIES.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT PACKAGE_NAME
,      DATE_OF_EXPORT
,      DATE_OF_IMPORT
,      STATUS
,      LEGISLATION_CODE
,      ZD_EDITION_NAME
FROM HR.HR_STU_HISTORY;

Dependencies

[top of page]

HR.HR_STU_HISTORY does not reference any database object

HR.HR_STU_HISTORY is referenced by following:

HR: HR_STU_HISTORY#