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_ATH_ELIGIBLE_TBLS

Object Details

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

This table contains ODBC connectivity information for the Authoria eligible benefits table(s).

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ATH_DSN	VARCHAR2	(200)	Yes	DSN for the table
ATH_UID	VARCHAR2	(30)		Authoria schema username
ATH_PWD	VARCHAR2	(30)		Authoria schema password
ATH_TABLENAME	VARCHAR2	(30)	Yes	Table name
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
LAST_UPDATE_DATE	DATE			Standard who column

Query Text

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


SELECT ATH_DSN
,      ATH_UID
,      ATH_PWD
,      ATH_TABLENAME
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM HR.HR_ATH_ELIGIBLE_TBLS;

Dependencies

[top of page]

HR.HR_ATH_ELIGIBLE_TBLS does not reference any database object

HR.HR_ATH_ELIGIBLE_TBLS is referenced by following:

APPS: HR_ATH_ELIGIBLE_TBLS; HR_ATH_ELIGIBLE_TBLS_WHO
PUBLIC: HR_ATH_ELIGIBLE_TBLS