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

Object Details

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

View Type

A Business Intelligence System view

This entity contains the OSS specific employment information of a person.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes	Party identifier. Foreign key to IGSFV_PERSON_DETAILS.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for a person.
START_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)		Designation of the person.
EMPLOYER	VARCHAR2	(60)		Name of the company who employed the person.
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	(67)		Type of employment
FRACTION_OF_EMPLOYMENT	NUMBER			Fraction of employment
_LA:TENURE_OF_EMPLOYMENT	CHAR	(54)		Tenure of employment
OCCUPATIONAL_TITLE_CODE	VARCHAR2	(15)		Occupational code
OCCUPATIONAL_TITLE	VARCHAR2	(60)		Title of the occupation.
WEEKLY_WORK_HOURS	NUMBER			Weekly hours of work.
COMMENTS	VARCHAR2	(2000)		Comments
REASON_FOR_LEAVING	VARCHAR2	(240)		Reason for Leaving
EMPLOYED_BY_PARTY_NUMBER	VARCHAR2	(30)		Unique Identification number of the Employer
EMPLOYED_BY_PARTY_ID	NUMBER	(15)		Unique Identifier of the Employer
HZ_EMP_DTL_ID	NUMBER	(15)	Yes	Employment details identifier
EMPLOYMENT_HISTORY_ID	NUMBER	(15)	Yes	Foreign key to HZ_EMPLOYMENT_HISTORY
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	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
,      PERSON_NUMBER
,      START_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
,      OCCUPATIONAL_TITLE
,      WEEKLY_WORK_HOURS
,      COMMENTS
,      REASON_FOR_LEAVING
,      EMPLOYED_BY_PARTY_NUMBER
,      EMPLOYED_BY_PARTY_ID
,      HZ_EMP_DTL_ID
,      EMPLOYMENT_HISTORY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_EMPLOYMENTS;

Dependencies

[top of page]

APPS.IGSFV_EMPLOYMENTS references the following:

APPS: HZ_EMPLOYMENT_HISTORY; HZ_PARTIES; IGS_AD_HZ_EMP_DTL; IGS_PS_DIC_OCC_TITLS

APPS.IGSFV_EMPLOYMENTS is not referenced by any database object