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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group ID
XPERSON_ID	NUMBER	(10)	Yes	Xperson ID
FULL_NAME	VARCHAR2	(240)		Full Name of employee
SUMMARY_PERSON_TYPE	VARCHAR2	(2)		Summary person type
NATIONAL_IDENTIFIER	VARCHAR2	(30)		National Information
CONTRACT_RELATIONSHIP	VARCHAR2	(4000)		Contract Relationship
PERSON_TYPE	VARCHAR2	(4000)		PErson Type
SYSTEM_PERSON_TYPE	VARCHAR2	(30)	Yes	System Person Type
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number
APPLICANT_NUMBER	VARCHAR2	(30)		Applicant Number
HIRE_DATE	DATE		Yes	Hire Date
DATE_OF_BIRTH	DATE			Date Of Birth
XCONTRACT_ID	NUMBER	(9)		Xcontract id
REFERENCE	VARCHAR2	(80)		Refrence
TYPE	VARCHAR2	(30)		Type
TYPE_MEANING	VARCHAR2	(80)		Type meaning
STATUS	VARCHAR2	(30)		status
STATUS_MEANING	VARCHAR2	(80)		Status Meaning
STATUS_REASON	VARCHAR2	(80)		Status Reason
DOC_STATUS	VARCHAR2	(240)		Doc Status
DOC_STATUS_MEANING	VARCHAR2	(80)		Doc Status Meaning
DOC_STATUS_CHANGE_DATE	DATE			Doc Status Change Date
DESCRIPTION	VARCHAR2	(2000)		Description
DURATION	NUMBER	(22)		Duration
DURATION_UNITS	VARCHAR2	(80)		Duration Units
CONTRACTUAL_JOB_TITLE	VARCHAR2	(80)		Contractural Job Status
PARTIES	VARCHAR2	(80)		Parties
START_REASON	VARCHAR2	(80)		Start reason
END_REASON	VARCHAR2	(80)		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	(80)		Extension Period Units
CTR_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Column
CTR_INFORMATION1	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION2	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION3	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION4	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION5	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION6	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION7	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION8	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION9	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION10	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION11	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION12	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION13	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION14	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION15	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION16	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION17	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION18	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION19	VARCHAR2	(150)		Descriptive Flexfield Column
CTR_INFORMATION20	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield Column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield Column
EFFECTIVE_START_DATE	DATE			Effective Start Date
EFFECTIVE_END_DATE	DATE			Effective End Date
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment ID
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Assignment Number
SINGLE_MATCH	CHAR	(1)		Single Match
ATTACHMENT_EXISTS	VARCHAR2	(4000)		Attachment Exists
PEOPLE_GROUP_ID	NUMBER	(15)		People group id

Query Text

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


SELECT BUSINESS_GROUP_ID
,      XPERSON_ID
,      FULL_NAME
,      SUMMARY_PERSON_TYPE
,      NATIONAL_IDENTIFIER
,      CONTRACT_RELATIONSHIP
,      PERSON_TYPE
,      SYSTEM_PERSON_TYPE
,      EMPLOYEE_NUMBER
,      APPLICANT_NUMBER
,      HIRE_DATE
,      DATE_OF_BIRTH
,      XCONTRACT_ID
,      REFERENCE
,      TYPE
,      TYPE_MEANING
,      STATUS
,      STATUS_MEANING
,      STATUS_REASON
,      DOC_STATUS
,      DOC_STATUS_MEANING
,      DOC_STATUS_CHANGE_DATE
,      DESCRIPTION
,      DURATION
,      DURATION_UNITS
,      CONTRACTUAL_JOB_TITLE
,      PARTIES
,      START_REASON
,      END_REASON
,      NUMBER_OF_EXTENSIONS
,      EXTENSION_REASON
,      EXTENSION_PERIOD
,      EXTENSION_PERIOD_UNITS
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      OBJECT_VERSION_NUMBER
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      SINGLE_MATCH
,      ATTACHMENT_EXISTS
,      PEOPLE_GROUP_ID
FROM APPS.PER_CONTRACTS_V2;

Dependencies

[top of page]

APPS.PER_CONTRACTS_V2 references the following:

APPS: FND_ATTACHMENT_UTIL_PKG - show dependent code; FND_SESSIONS; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_PERSON_TYPE_USAGE_INFO - show dependent code; HR_SECURITY - show dependent code; PER_ASSIGNMENTS_F; PER_CONTRACTS_F; PER_MANAGE_CONTRACTS_PKG - show dependent code; PER_PEOPLE_F; PER_PERIODS_OF_SERVICE; PER_PERSON_TYPES
PUBLIC: DUAL

APPS.PER_CONTRACTS_V2 is not referenced by any database object