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

Object Details

Object Name:	GHR_ASSIGNMENTS_H_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_ASSIGNMENTS_H_V
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
PA_HISTORY_ID	NUMBER	(15)	Yes	Personnel Action History ID
PROCESS_DATE	DATE		Yes	Process Date
EFFECTIVE_DATE	DATE		Yes	Effective Date
DML_OPERATION	VARCHAR2	(1)		DML Operation
PRE_VALUES_FLAG	VARCHAR2	(1)		Pre Values Existed
ALTERED_PA_REQUEST_ID	NUMBER	(15)		Personnal Action Request ID of Original Action
PA_REQUEST_ID	NUMBER	(15)		Personnel Action Request ID
NATURE_OF_ACTION_ID	NUMBER	(15)		Nature of Action ID
ASSIGNMENT_ID	NUMBER			Assignment ID
EFFECTIVE_START_DATE	DATE			Effective Start Date
EFFECTIVE_END_DATE	DATE			Effective End Date
RECRUITER_ID	NUMBER			Recruiter ID
ASSIGNMENT_STATUS_TYPE_ID	NUMBER			Assignment Status Type ID
PAYROLL_ID	NUMBER			Payroll ID
PERSON_REFERRED_BY_ID	NUMBER			Person Referred by ID
SUPERVISOR_ID	NUMBER			Supervisor ID
SPECIAL_CEILING_STEP_ID	NUMBER			Special ceiling Step ID
PERSON_ID	NUMBER			Person ID
RECRUITMENT_ACTIVITY_ID	NUMBER			Recruitment Activity ID
SOURCE_ORGANIZATION_ID	NUMBER			Source Organization ID
PEOPLE_GROUP_ID	NUMBER			People Group ID
SOFT_CODING_KEYFLEX_ID	NUMBER			Soft Keyflex
VACANCY_ID	NUMBER			Vacancy ID
PAY_BASIS_ID	NUMBER			Pay Basis ID
ASSIGNMENT_SEQUENCE	NUMBER			Assignment Sequence
ASSIGNMENT_TYPE	VARCHAR2	(1)		Type of Assignment
PRIMARY_FLAG	VARCHAR2	(30)		Primary Flag
APPLICATION_ID	NUMBER			Application ID
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Assignment Number
CHANGE_REASON	VARCHAR2	(30)		Change Reason
COMMENT_ID	NUMBER			Comment ID
DATE_PROBATION_END	DATE			Date Probation End
DEFAULT_CODE_COMB_ID	NUMBER			Default Code Combination ID
EMPLOYMENT_CATEGORY	VARCHAR2	(30)		Employment Category
FREQUENCY	VARCHAR2	(30)		Frequency
INTERNAL_ADDRESS_LINE	VARCHAR2	(80)		Internal Address Line
MANAGER_FLAG	VARCHAR2	(30)		Manager Flag
NORMAL_HOURS	NUMBER			Normal Hours
PERF_REVIEW_PERIOD	NUMBER			Performance Review Period
PERF_REVIEW_PERIOD_FREQUENCY	VARCHAR2	(255)		Performance Review Period Frequencey
PERIOD_OF_SERVICE_ID	NUMBER			Period of Service ID
PROBATION_PERIOD	NUMBER			Probation Period
PROBATION_UNIT	VARCHAR2	(30)		Probation Unit
SAL_REVIEW_PERIOD	NUMBER			Salary Review Period
SAL_REVIEW_PERIOD_FREQUENCY	VARCHAR2	(30)		Salary Review Period Frequency
SET_OF_BOOKS_ID	NUMBER			Set of Books Identifier
SOURCE_TYPE	VARCHAR2	(30)		Source Type
TIME_NORMAL_FINISH	VARCHAR2	(5)		Time Normal Finish
TIME_NORMAL_START	VARCHAR2	(5)		Time Normal Start
TITLE	VARCHAR2	(30)		Title
ORGANIZATION_ID	NUMBER			Organization ID
JOB_ID	NUMBER			Job ID
POSITION_ID	NUMBER			Position ID
GRADE_ID	NUMBER			Grade ID
LOCATION_ID	NUMBER			Location ID
BUSINESS_GROUP_ID	NUMBER			Business Group of the Record
REQUEST_ID	NUMBER			Request ID
PROGRAM_APPLICATION_ID	NUMBER			Program Application ID
PROGRAM_ID	NUMBER			Program ID
PROGRAM_UPDATE_DATE	DATE			Program Update Date
ASS_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Determines context of the Assignment Descriptive Flexfield in parameters.
ASS_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfield
ASS_ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfield

Query Text

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


SELECT PA_HISTORY_ID
,      PROCESS_DATE
,      EFFECTIVE_DATE
,      DML_OPERATION
,      PRE_VALUES_FLAG
,      ALTERED_PA_REQUEST_ID
,      PA_REQUEST_ID
,      NATURE_OF_ACTION_ID
,      ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      RECRUITER_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      PAYROLL_ID
,      PERSON_REFERRED_BY_ID
,      SUPERVISOR_ID
,      SPECIAL_CEILING_STEP_ID
,      PERSON_ID
,      RECRUITMENT_ACTIVITY_ID
,      SOURCE_ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      VACANCY_ID
,      PAY_BASIS_ID
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_TYPE
,      PRIMARY_FLAG
,      APPLICATION_ID
,      ASSIGNMENT_NUMBER
,      CHANGE_REASON
,      COMMENT_ID
,      DATE_PROBATION_END
,      DEFAULT_CODE_COMB_ID
,      EMPLOYMENT_CATEGORY
,      FREQUENCY
,      INTERNAL_ADDRESS_LINE
,      MANAGER_FLAG
,      NORMAL_HOURS
,      PERF_REVIEW_PERIOD
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PERIOD_OF_SERVICE_ID
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      SAL_REVIEW_PERIOD
,      SAL_REVIEW_PERIOD_FREQUENCY
,      SET_OF_BOOKS_ID
,      SOURCE_TYPE
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      TITLE
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      LOCATION_ID
,      BUSINESS_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASS_ATTRIBUTE_CATEGORY
,      ASS_ATTRIBUTE1
,      ASS_ATTRIBUTE2
,      ASS_ATTRIBUTE3
,      ASS_ATTRIBUTE4
,      ASS_ATTRIBUTE5
,      ASS_ATTRIBUTE6
,      ASS_ATTRIBUTE7
,      ASS_ATTRIBUTE8
,      ASS_ATTRIBUTE9
,      ASS_ATTRIBUTE10
,      ASS_ATTRIBUTE11
,      ASS_ATTRIBUTE12
,      ASS_ATTRIBUTE13
,      ASS_ATTRIBUTE14
,      ASS_ATTRIBUTE15
,      ASS_ATTRIBUTE16
,      ASS_ATTRIBUTE17
,      ASS_ATTRIBUTE18
,      ASS_ATTRIBUTE19
,      ASS_ATTRIBUTE20
,      ASS_ATTRIBUTE21
,      ASS_ATTRIBUTE22
,      ASS_ATTRIBUTE23
,      ASS_ATTRIBUTE24
,      ASS_ATTRIBUTE25
,      ASS_ATTRIBUTE26
,      ASS_ATTRIBUTE27
,      ASS_ATTRIBUTE28
,      ASS_ATTRIBUTE29
,      ASS_ATTRIBUTE30
FROM APPS.GHR_ASSIGNMENTS_H_V;

Dependencies

[top of page]

APPS.GHR_ASSIGNMENTS_H_V references the following:

APPS: FND_DATE - show dependent code; GHR_GENERAL - show dependent code; GHR_PA_HISTORY

APPS.GHR_ASSIGNMENTS_H_V is referenced by following:

APPS: GHR_API - show dependent code; GHR_HISTORY_CONV_RG - show dependent code; GHR_HISTORY_CONV_RG - show dependent code