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

Object Details

Object Name:	HRFV_TERMINATIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_TERMINATIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows information about employees who leave the enterprise. Current
employees are not shown. The information shown is
effective as of the employee's termination date.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
PERSON_NAME	VARCHAR2	(240)
BUDGET_MEASUREMENT_TYPE	VARCHAR2	(4000)
BUDGET_MEASUREMENT_CODE	VARCHAR2	(30)	Yes
TERMINATION_DATE	DATE
ASSIGNMENT_NUMBER	VARCHAR2	(30)
TERMINATION_REASON	VARCHAR2	(4000)
EMPLOYEE_NUMBER	VARCHAR2	(30)
PERSON_TYPE	VARCHAR2	(80)	Yes
EMPLOYEE_PERSON_TYPE	VARCHAR2	(4000)
USER_CONCAT_PERSON_TYPE	VARCHAR2	(4000)
EMPLOYMENT_CATEGORY	VARCHAR2	(4000)
ORGANIZATION_NAME	VARCHAR2	(240)	Yes
GRADE_NAME	VARCHAR2	(240)
JOB_NAME	VARCHAR2	(700)
POSITION_NAME	VARCHAR2	(240)
LOCATION_NAME	VARCHAR2	(60)
DATE_NOTIFIED	DATE
COMMENTS	CLOB	(4000)
ACCEPTED_BY	VARCHAR2	(240)
MONTHS_IN_SERVICE	NUMBER
MONTHS_IN_ORGANIZATION	NUMBER
MONTHS_IN_GRADE	NUMBER
MONTHS_IN_JOB	NUMBER
MONTHS_IN_POSITION	NUMBER
MONTHS_IN_LOCATION	NUMBER
SYSTEM_PERSON_TYPE_CODE	VARCHAR2	(30)	Yes
_DF	CHAR	(33)
_DF:PPOSDDF	CHAR	(35)
ASSIGNMENT_ID	NUMBER	(10)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
GRADE_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
LOCATION_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)	Yes
PERIOD_OF_SERVICE_ID	NUMBER	(9)	Yes
PERSON_ID	NUMBER	(10)	Yes
POSITION_ID	NUMBER	(15)
PERSON_TYPE_ID	NUMBER	(15)	Yes
PPF_LAST_UPDATE_DATE	DATE			Last Update Date WHO column from per_all_people_f
PPOS_LAST_UPDATE_DATE	DATE			Last Update Date WHO column from per_periods_of_service
PAF_LAST_UPDATE_DATE	DATE			Last Update Date WHO column from per_assignments_f
PPF_LAST_UPDATED_BY	NUMBER	(15)
PPOS_LAST_UPDATED_BY	NUMBER	(15)
PAF_LAST_UPDATED_BY	NUMBER	(15)

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      BUDGET_MEASUREMENT_TYPE
,      BUDGET_MEASUREMENT_CODE
,      TERMINATION_DATE
,      ASSIGNMENT_NUMBER
,      TERMINATION_REASON
,      EMPLOYEE_NUMBER
,      PERSON_TYPE
,      EMPLOYEE_PERSON_TYPE
,      USER_CONCAT_PERSON_TYPE
,      EMPLOYMENT_CATEGORY
,      ORGANIZATION_NAME
,      GRADE_NAME
,      JOB_NAME
,      POSITION_NAME
,      LOCATION_NAME
,      DATE_NOTIFIED
,      COMMENTS
,      ACCEPTED_BY
,      MONTHS_IN_SERVICE
,      MONTHS_IN_ORGANIZATION
,      MONTHS_IN_GRADE
,      MONTHS_IN_JOB
,      MONTHS_IN_POSITION
,      MONTHS_IN_LOCATION
,      SYSTEM_PERSON_TYPE_CODE
,      _DF
,      _DF:PPOSDDF
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PERIOD_OF_SERVICE_ID
,      PERSON_ID
,      POSITION_ID
,      PERSON_TYPE_ID
,      PPF_LAST_UPDATE_DATE
,      PPOS_LAST_UPDATE_DATE
,      PAF_LAST_UPDATE_DATE
,      PPF_LAST_UPDATED_BY
,      PPOS_LAST_UPDATED_BY
,      PAF_LAST_UPDATED_BY
FROM APPS.HRFV_TERMINATIONS;

Dependencies

[top of page]

APPS.HRFV_TERMINATIONS references the following:

APPS: HRI_BPL_PERSON_TYPE - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; HR_ALL_POSITIONS_F_TL; HR_API - show dependent code; HR_BIS - show dependent code; HR_DISCOVERER - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL_TL; HR_LOOKUPS; HR_SECURITY - show dependent code; PER_ALL_PEOPLE_F; PER_ASSIGNMENTS_F; PER_GRADES_TL; PER_JOBS_TL; PER_PERIODS_OF_SERVICE; PER_PERSON_TYPES; PER_PERSON_TYPES_TL

APPS.HRFV_TERMINATIONS is not referenced by any database object