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

Object Details

Object Name:	IGSBV_EMPLOYMENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_EMPLOYMENTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity contains the employment information of a person.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes	Party identifier. Foreign key to IGSBV_PERSON_DETAILS.
BEGIN_DATE	DATE			Starting date of the employment
END_DATE	DATE			End date of the employment
CONTACT	VARCHAR2	(60)		contact for the employment
POSITION	VARCHAR2	(60)		Position during the employment
EMPLOYER	VARCHAR2	(60)		Employer for the employment
DIVISION	VARCHAR2	(60)		Division of the employment
BRANCH	VARCHAR2	(80)		Branch where employeed
MILITARY_RANK	VARCHAR2	(240)		Military rank during the employment
SERVED	VARCHAR2	(240)		Whether served during the employment
STATION	VARCHAR2	(240)		Station where employeed
_LA:TYPE_OF_EMPLOYMENT	CHAR	(65)		Type of employment
FRACTION_OF_EMPLOYMENT	NUMBER			Fraction of employment
_LA:TENURE_OF_EMPLOYMENT	CHAR	(52)		Tenure of employment
OCCUPATIONAL_TITLE_CODE	VARCHAR2	(15)		Occupational code
WEEKLY_WORK_HOURS	NUMBER			Weekly hours of work.
COMMENTS	VARCHAR2	(2000)		Comments
REASON_FOR_LEAVING	VARCHAR2	(240)
EMPLOYED_BY_PARTY_ID	NUMBER	(15)
HZ_EMP_DTL_ID	NUMBER	(15)	Yes	Unique identifier of employment details
EMPLOYMENT_HISTORY_ID	NUMBER	(15)	Yes	Foreign key to HZ_EMPLOYMENT_HISTORY
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT PARTY_ID
,      BEGIN_DATE
,      END_DATE
,      CONTACT
,      POSITION
,      EMPLOYER
,      DIVISION
,      BRANCH
,      MILITARY_RANK
,      SERVED
,      STATION
,      _LA:TYPE_OF_EMPLOYMENT
,      FRACTION_OF_EMPLOYMENT
,      _LA:TENURE_OF_EMPLOYMENT
,      OCCUPATIONAL_TITLE_CODE
,      WEEKLY_WORK_HOURS
,      COMMENTS
,      REASON_FOR_LEAVING
,      EMPLOYED_BY_PARTY_ID
,      HZ_EMP_DTL_ID
,      EMPLOYMENT_HISTORY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_EMPLOYMENTS;

Dependencies

[top of page]

APPS.IGSBV_EMPLOYMENTS references the following:

APPS: HZ_EMPLOYMENT_HISTORY; IGS_AD_HZ_EMP_DTL

APPS.IGSBV_EMPLOYMENTS is not referenced by any database object