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]

VIEW: APPS.BIL_DIMV_EMP_STATUS

Object Details

Object Name:	BIL_DIMV_EMP_STATUS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIL.BIL_DIMV_EMP_STATUS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

BIL_DIMV_EMP_STATUS - Dimension view used to provide access to descriptive information
related to employee status. Used for reporting on salesforce.
.
Source is Oracle Applications Human Resources schema.
.
.

[View Source]

Columns

Name	Datatype	Length	Comments
EMPLOYMENT_STATUS_PK	VARCHAR2	(30)	Human Resource employee status lookup identifier
EMPLOYMENT_STATUS	VARCHAR2	(80)	Human Resource employee lookup meaning
ENABLED_FLAG	VARCHAR2	(1)	Human resource employee lookup enabled flag
START_DATE_ACTIVE	DATE		Human Resources employee status start date active
END_DATE_ACTIVE	DATE		Human Resources employee status end date active
DESCRIPTION	VARCHAR2	(240)	Human Resources employee status description
ID	VARCHAR2	(30)	Human Resource employee status lookup identifier
VALUE	VARCHAR2	(80)	Human Resource employee lookup meaning

Query Text

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


SELECT EMPLOYMENT_STATUS_PK
,      EMPLOYMENT_STATUS
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      ID
,      VALUE
FROM APPS.BIL_DIMV_EMP_STATUS;

Dependencies

[top of page]

APPS.BIL_DIMV_EMP_STATUS references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_API - show dependent code; HR_LOOKUPS

APPS.BIL_DIMV_EMP_STATUS is not referenced by any database object