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_CONTRACTS_V

Object Details

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

View Type

A Business Intelligence System view

Contracts (from PER_CONTRACTS table).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EFFECTIVE_START_DATE	DATE		Yes	Effective start date.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date.
REFERENCE	VARCHAR2	(80)	Yes	Reference.
TYPE	VARCHAR2	(30)	Yes	(Lookup code based on lookup type CONTRACT_TYPE).
TYPE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type CONTRACT_TYPE).
STATUS	VARCHAR2	(30)	Yes	(Lookup code based on lookup type CONTRACT_STATUS).
STATUS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type CONTRACT_STATUS).
STATUS_REASON	VARCHAR2	(240)		(Lookup code based on lookup type CONTRACT_STATUS_REASON).
STATUS_REASON_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type CONTRACT_STATUS_REASON).
DOC_STATUS	VARCHAR2	(240)		Document status.
DOC_STATUS_CHANGE_DATE	DATE			Date of change.
DESCRIPTION	VARCHAR2	(2000)		Description.
DURATION	NUMBER	(22)		Duration.
DURATION_UNITS	VARCHAR2	(30)		(Lookup code based on lookup type QUALIFYING_UNITS).
DURATION_UNITS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type QUALIFYING_UNITS).
CONTRACTUAL_JOB_TITLE	VARCHAR2	(80)		Contractual job title.
PARTIES	VARCHAR2	(80)		Parties.
START_REASON	VARCHAR2	(30)		(Lookup code based on lookup type CONTRACT_START_REASON).
START_REASON_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type CONTRACT_START_REASON).
END_REASON	VARCHAR2	(30)		(Lookup code based on lookup type CONTRACT_END_REASON).
END_REASON_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type CONTRACT_END_REASON).
NUMBER_OF_EXTENSIONS	NUMBER	(9)		Number of extensions.
EXTENSION_REASON	VARCHAR2	(80)		Extension reason.
EXTENSION_PERIOD	NUMBER	(22)		Extension period.
EXTENSION_PERIOD_UNITS	VARCHAR2	(30)		(Lookup code based on lookup type QUALIFYING_UNITS).
EXTENSION_PERIOD_UNITS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type QUALIFYING_UNITS).
CTR_INFORMATION_CATEGORY	VARCHAR2	(30)		Ctr information category.
CTR_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
CTR_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
_DF:CTC	CHAR	(25)		Descriptive Flexfield Column
LEGISLATION_CODE	VARCHAR2	(4000)		Legislation code.
CONTRACT_ID	NUMBER	(9)	Yes	Primary key for PER_CONTRACTS.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS.
PERSON_ID	NUMBER	(9)	Yes	Foreign key to PER_ALL_PEOPLE_F.
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 EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      REFERENCE
,      TYPE
,      TYPE_M
,      STATUS
,      STATUS_M
,      STATUS_REASON
,      STATUS_REASON_M
,      DOC_STATUS
,      DOC_STATUS_CHANGE_DATE
,      DESCRIPTION
,      DURATION
,      DURATION_UNITS
,      DURATION_UNITS_M
,      CONTRACTUAL_JOB_TITLE
,      PARTIES
,      START_REASON
,      START_REASON_M
,      END_REASON
,      END_REASON_M
,      NUMBER_OF_EXTENSIONS
,      EXTENSION_REASON
,      EXTENSION_PERIOD
,      EXTENSION_PERIOD_UNITS
,      EXTENSION_PERIOD_UNITS_M
,      CTR_INFORMATION_CATEGORY
,      CTR_INFORMATION1
,      CTR_INFORMATION2
,      CTR_INFORMATION3
,      CTR_INFORMATION4
,      CTR_INFORMATION5
,      CTR_INFORMATION6
,      CTR_INFORMATION7
,      CTR_INFORMATION8
,      CTR_INFORMATION9
,      CTR_INFORMATION10
,      CTR_INFORMATION11
,      CTR_INFORMATION12
,      CTR_INFORMATION13
,      CTR_INFORMATION14
,      CTR_INFORMATION15
,      CTR_INFORMATION16
,      CTR_INFORMATION17
,      CTR_INFORMATION18
,      CTR_INFORMATION19
,      CTR_INFORMATION20
,      _DF:CTC
,      LEGISLATION_CODE
,      CONTRACT_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_CONTRACTS_V;

Dependencies

[top of page]

APPS.HRBV_CONTRACTS_V references the following:

APPS: HR_API - show dependent code; HR_BIS - show dependent code; PER_CONTRACTS_F

APPS.HRBV_CONTRACTS_V is not referenced by any database object