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

Object Details

Object Name:	HRBV_DEPLOYMENT_FACTORS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Deployment factors (from PER_DEPLOYMENT_FACTORS table).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
WORK_ANY_COUNTRY	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
WORK_ANY_COUNTRY_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
WORK_ANY_LOCATION	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
WORK_ANY_LOCATION_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
RELOCATE_DOMESTICALLY	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
RELOCATE_DOMESTICALLY_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
RELOCATE_INTERNATIONALLY	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
RELOCATE_INTERNATIONALLY_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
TRAVEL_REQUIRED	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
TRAVEL_REQUIRED_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
COUNTRY1	VARCHAR2	(30)		Country1.
COUNTRY2	VARCHAR2	(30)		Country2.
COUNTRY3	VARCHAR2	(30)		Country3.
WORK_DURATION	VARCHAR2	(30)		(Lookup code based on lookup type PER_TIME_SCALES).
WORK_DURATION_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type PER_TIME_SCALES).
WORK_SCHEDULE	VARCHAR2	(30)		(Lookup code based on lookup type PER_WORK_SCHEDULE).
WORK_SCHEDULE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type PER_WORK_SCHEDULE).
WORK_HOURS	VARCHAR2	(30)		(Lookup code based on lookup type PER_WORK_HOURS).
WORK_HOURS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type PER_WORK_HOURS).
FTE_CAPACITY	VARCHAR2	(30)		(Lookup code based on lookup type PER_FTE_CAPACITY).
FTE_CAPACITY_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type PER_FTE_CAPACITY).
VISIT_INTERNATIONALLY	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
VISIT_INTERNATIONALLY_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
ONLY_CURRENT_LOCATION	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
ONLY_CURRENT_LOCATION_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
NO_COUNTRY1	VARCHAR2	(30)		No country1.
NO_COUNTRY2	VARCHAR2	(30)		No country2.
NO_COUNTRY3	VARCHAR2	(30)		No country3.
COMMENTS	VARCHAR2	(2000)		Comments.
EARLIEST_AVAILABLE_DATE	DATE			Earliest available date.
AVAILABLE_FOR_TRANSFER	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
AVAILABLE_FOR_TRANSFER_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
RELOCATION_PREFERENCE	VARCHAR2	(30)		(Lookup code based on lookup type PER_RELOCATION_PREFERENCES).
RELOCATION_PREFERENCE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type PER_RELOCATION_PREFERENCES).
RELOCATION_REQUIRED	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
RELOCATION_REQUIRED_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
PASSPORT_REQUIRED	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
PASSPORT_REQUIRED_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
LOCATION1	VARCHAR2	(30)		Location1.
LOCATION2	VARCHAR2	(30)		Location2.
LOCATION3	VARCHAR2	(30)		Location3.
OTHER_REQUIREMENTS	VARCHAR2	(2000)		Other requirements.
SERVICE_MINIMUM	VARCHAR2	(30)		(Lookup code based on lookup type PER_LENGTHS_OF_SERVICE).
SERVICE_MINIMUM_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type PER_LENGTHS_OF_SERVICE).
_DF:DPF	CHAR	(34)
DEPLOYMENT_FACTOR_ID	NUMBER	(9)	Yes	Primary key for PER_DEPLOYMENT_FACTORS.
POSITION_ID	NUMBER	(15)		Foreign key to PER_ALL_POSITIONS.
PERSON_ID	NUMBER	(10)		Foreign key to PER_ALL_PEOPLE_F.
JOB_ID	NUMBER	(9)		Foreign key to PER_JOBS.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS.
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
BG_SECURITY_FLAG_CODE	CHAR	(1)		Business group security flag code.

Query Text

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


SELECT WORK_ANY_COUNTRY
,      WORK_ANY_COUNTRY_M
,      WORK_ANY_LOCATION
,      WORK_ANY_LOCATION_M
,      RELOCATE_DOMESTICALLY
,      RELOCATE_DOMESTICALLY_M
,      RELOCATE_INTERNATIONALLY
,      RELOCATE_INTERNATIONALLY_M
,      TRAVEL_REQUIRED
,      TRAVEL_REQUIRED_M
,      COUNTRY1
,      COUNTRY2
,      COUNTRY3
,      WORK_DURATION
,      WORK_DURATION_M
,      WORK_SCHEDULE
,      WORK_SCHEDULE_M
,      WORK_HOURS
,      WORK_HOURS_M
,      FTE_CAPACITY
,      FTE_CAPACITY_M
,      VISIT_INTERNATIONALLY
,      VISIT_INTERNATIONALLY_M
,      ONLY_CURRENT_LOCATION
,      ONLY_CURRENT_LOCATION_M
,      NO_COUNTRY1
,      NO_COUNTRY2
,      NO_COUNTRY3
,      COMMENTS
,      EARLIEST_AVAILABLE_DATE
,      AVAILABLE_FOR_TRANSFER
,      AVAILABLE_FOR_TRANSFER_M
,      RELOCATION_PREFERENCE
,      RELOCATION_PREFERENCE_M
,      RELOCATION_REQUIRED
,      RELOCATION_REQUIRED_M
,      PASSPORT_REQUIRED
,      PASSPORT_REQUIRED_M
,      LOCATION1
,      LOCATION2
,      LOCATION3
,      OTHER_REQUIREMENTS
,      SERVICE_MINIMUM
,      SERVICE_MINIMUM_M
,      _DF:DPF
,      DEPLOYMENT_FACTOR_ID
,      POSITION_ID
,      PERSON_ID
,      JOB_ID
,      BUSINESS_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_DEPLOYMENT_FACTORS_V;

Dependencies

[top of page]

APPS.HRBV_DEPLOYMENT_FACTORS_V references the following:

APPS: HR_BIS - show dependent code; PER_DEPLOYMENT_FACTORS

APPS.HRBV_DEPLOYMENT_FACTORS_V is referenced by following:

PUBLIC: HRBV_DEPLOYMENT_FACTORS_V