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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

HR_POSITIONS_F is a view based on the table HR_ALL_POSITIONS_F. It lists
all of the positons visible within the current security profile.

[View Source]

Columns

Name	Datatype	Length	Comments
POSITION_ID	NUMBER	(15)	System-generated primary key column.
EFFECTIVE_START_DATE	DATE		Effective Start Date, part of the primary key.
EFFECTIVE_END_DATE	DATE		Effective End Date, part of the primary key.
AVAILABILITY_STATUS_ID	NUMBER	(15)	Current Status of the Position. Refers to PER_SHARED_TYPES.
BUSINESS_GROUP_ID	NUMBER	(15)	Foreign key to HR_ORGANIZATION_UNITS.
ENTRY_GRADE_ID	NUMBER	(15)	Foreign key to PER_GRADES
ENTRY_GRADE_RULE_ID	NUMBER	(15)	Pseudo Foreign key to PAY_GRADE_RULES_F
ENTRY_STEP_ID	NUMBER	(15)	Pseudo Foreign key to PER_SPINAL_POINT_STEPS_F
JOB_ID	NUMBER	(15)	Foreign key to PER_JOBS
LOCATION_ID	NUMBER	(15)	Foreign key to HR_LOCATIONS_ALL
ORGANIZATION_ID	NUMBER	(15)	Foreign key to HR_ORGANIZATION_UNITS.
PAY_FREQ_PAYROLL_ID	NUMBER	(15)	Foreign key to PER_PAY_BASES.
POSITION_DEFINITION_ID	NUMBER	(15)	Pseudo Foreign key to PAY_ALL_PAYROLLS_F
DATE_EFFECTIVE_POS_DEF_ID	NUMBER	(15)	Foreign key to PER_POSITION_DEFINITIONS
POSITION_TRANSACTION_ID	NUMBER	(15)	Foreign key to PQH_POSITION_TRANSACTIONS
PRIOR_POSITION_ID	NUMBER	(15)	Pseudo Foreign key to HR_ALL_POSITIONS_F
RELIEF_POSITION_ID	NUMBER	(15)	Pseudo Foreign key to HR_ALL_POSITIONS_F
SUCCESSOR_POSITION_ID	NUMBER	(15)	Pseudo Foreign key to HR_ALL_POSITIONS_F
SUPERVISOR_POSITION_ID	NUMBER	(15)	Pseudo Foreign key to HR_ALL_POSITIONS_F
AMENDMENT_DATE	DATE		Amendment Date
AMENDMENT_RECOMMENDATION	VARCHAR2	(2000)	Amendment Recommendation
AMENDMENT_REF_NUMBER	VARCHAR2	(30)	Amendment Reference Number.
BARGAINING_UNIT_CD	VARCHAR2	(30)	Bargaining Unit
COMMENTS	CLOB	(4000)	Comments
CURRENT_JOB_PROP_END_DATE	DATE		Proposed date for current Job to end.
CURRENT_ORG_PROP_END_DATE	DATE		Proposed date for current Organization to end.
AVAIL_STATUS_PROP_END_DATE	DATE		Date when position becomes effective.
DATE_EFFECTIVE	DATE		Date after which position is no longer valid. For full HRMS installations, this column will remain null.
DATE_END	DATE		DATE_END
EARLIEST_HIRE_DATE	DATE		Earliest hire date
FILL_BY_DATE	DATE		The desired date by which the position should be filled.
FREQUENCY	VARCHAR2	(30)	Frequency
FTE	NUMBER	(13)	The full-time equivalents(FTE) assigned to this position.
MAX_PERSONS	NUMBER	(4)	Maximum number of employees on this position.
NAME	VARCHAR2	(240)	Position Name
DATE_EFFECTIVE_NAME	VARCHAR2	(240)	DATE_EFFECTIVE_NAME
OVERLAP_PERIOD	NUMBER	(22)	Overlap period
OVERLAP_UNIT_CD	VARCHAR2	(30)	Unit of Period.
PAY_TERM_END_DAY_CD	VARCHAR2	(30)	End Day of Pay Term
PAY_TERM_END_MONTH_CD	VARCHAR2	(30)	End Month of Pay Term
PERMANENT_TEMPORARY_FLAG	VARCHAR2	(30)	Indicates wheather position is Temporary or Permanent.
PERMIT_RECRUITMENT_FLAG	VARCHAR2	(30)	Recruitment can start or not.
POSITION_TYPE	VARCHAR2	(30)	Identifies whether the position is single FTE and single incumbent, single FTE and shared, multiple FTE and multiple incumbents, or pooled.
POSTING_DESCRIPTION	VARCHAR2	(2000)	Posting Description
PROBATION_PERIOD	NUMBER	(22)	Probationary period.
PROBATION_PERIOD_UNIT_CD	VARCHAR2	(30)	Qualifying units.
PROPOSED_FTE_FOR_LAYOFF	NUMBER	(10)	Proposed FTE for layoff
PROPOSED_DATE_FOR_LAYOFF	DATE		Proposed date for layoff
REPLACEMENT_REQUIRED_FLAG	VARCHAR2	(30)	Is replacement required when person assigned to position is absent.
REVIEW_FLAG	VARCHAR2	(30)	Identifies whether the characteristics of the position are under going review or change.
SEASONAL_FLAG	VARCHAR2	(30)	Is position Seasonal. Yes/No
SECURITY_REQUIREMENTS	VARCHAR2	(2000)	Security Requirements.
STATUS	VARCHAR2	(30)	Status of the Position. Valid or null values are considered to be valid.
TERM_START_DAY_CD	VARCHAR2	(30)	Start Day of Work and Pay Term
TERM_START_MONTH_CD	VARCHAR2	(30)	Start Month of Work or Pay Term
TIME_NORMAL_FINISH	VARCHAR2	(5)	Finish time.
TIME_NORMAL_START	VARCHAR2	(5)	Start time.
UPDATE_SOURCE_CD	VARCHAR2	(30)	Update Source Code.
WORKING_HOURS	NUMBER	(22)	Working Hours
WORKS_COUNCIL_APPROVAL_FLAG	VARCHAR2	(30)	Work Council Approval Flag
WORK_PERIOD_TYPE_CD	VARCHAR2	(30)	Identifies that the position is only used during part of the year.
WORK_TERM_END_DAY_CD	VARCHAR2	(30)	End Day of Work Term
WORK_TERM_END_MONTH_CD	VARCHAR2	(30)	End Month of Work Term
PAY_BASIS_ID	NUMBER	(9)	PAY_BASIS_ID
SUPERVISOR_ID	NUMBER	(10)	SUPERVISOR_ID
INFORMATION1	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION2	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION3	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION4	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION5	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION6	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION7	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION8	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION9	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION10	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION11	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION12	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION13	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION14	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION15	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION16	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION17	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION18	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION19	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION20	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION21	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION22	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION23	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION24	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION25	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION26	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION27	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION28	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION29	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION30	VARCHAR2	(150)	Developer Descriptive Flexfield
INFORMATION_CATEGORY	VARCHAR2	(30)	Developer Descriptive Flexfield
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
ATTRIBUTE21	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE22	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE23	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE24	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE25	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE26	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE27	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE28	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE29	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE30	VARCHAR2	(150)	Descriptive Flexfield Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive Flexfield Column
REQUEST_ID	NUMBER	(15)	REQUEST_ID
PROGRAM_APPLICATION_ID	NUMBER	(15)	PROGRAM_APPLICATION_ID
PROGRAM_ID	NUMBER	(15)	PROGRAM_ID
PROGRAM_UPDATE_DATE	DATE		PROGRAM_UPDATE_DATE
CREATED_BY	NUMBER	(15)	Standard who column
CREATION_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Standard who column
LAST_UPDATE_DATE	DATE		Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column
OBJECT_VERSION_NUMBER	NUMBER	(9)	OBJECT VERSION NUMBER

Query Text

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


SELECT POSITION_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      AVAILABILITY_STATUS_ID
,      BUSINESS_GROUP_ID
,      ENTRY_GRADE_ID
,      ENTRY_GRADE_RULE_ID
,      ENTRY_STEP_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PAY_FREQ_PAYROLL_ID
,      POSITION_DEFINITION_ID
,      DATE_EFFECTIVE_POS_DEF_ID
,      POSITION_TRANSACTION_ID
,      PRIOR_POSITION_ID
,      RELIEF_POSITION_ID
,      SUCCESSOR_POSITION_ID
,      SUPERVISOR_POSITION_ID
,      AMENDMENT_DATE
,      AMENDMENT_RECOMMENDATION
,      AMENDMENT_REF_NUMBER
,      BARGAINING_UNIT_CD
,      COMMENTS
,      CURRENT_JOB_PROP_END_DATE
,      CURRENT_ORG_PROP_END_DATE
,      AVAIL_STATUS_PROP_END_DATE
,      DATE_EFFECTIVE
,      DATE_END
,      EARLIEST_HIRE_DATE
,      FILL_BY_DATE
,      FREQUENCY
,      FTE
,      MAX_PERSONS
,      NAME
,      DATE_EFFECTIVE_NAME
,      OVERLAP_PERIOD
,      OVERLAP_UNIT_CD
,      PAY_TERM_END_DAY_CD
,      PAY_TERM_END_MONTH_CD
,      PERMANENT_TEMPORARY_FLAG
,      PERMIT_RECRUITMENT_FLAG
,      POSITION_TYPE
,      POSTING_DESCRIPTION
,      PROBATION_PERIOD
,      PROBATION_PERIOD_UNIT_CD
,      PROPOSED_FTE_FOR_LAYOFF
,      PROPOSED_DATE_FOR_LAYOFF
,      REPLACEMENT_REQUIRED_FLAG
,      REVIEW_FLAG
,      SEASONAL_FLAG
,      SECURITY_REQUIREMENTS
,      STATUS
,      TERM_START_DAY_CD
,      TERM_START_MONTH_CD
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      UPDATE_SOURCE_CD
,      WORKING_HOURS
,      WORKS_COUNCIL_APPROVAL_FLAG
,      WORK_PERIOD_TYPE_CD
,      WORK_TERM_END_DAY_CD
,      WORK_TERM_END_MONTH_CD
,      PAY_BASIS_ID
,      SUPERVISOR_ID
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      INFORMATION_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM APPS.HR_POSITIONS_F;

Dependencies

[top of page]

APPS.HR_POSITIONS_F references the following:

APPS: FND_PROFILE - show dependent code; HR_ALL_POSITIONS_F; HR_ALL_POSITIONS_F_TL; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code

APPS.HR_POSITIONS_F is referenced by following:

APPS: BEN_ASSIGNMENT_INTERNAL - show dependent code; GHR_EHRI_DYNRPT - show dependent code; GHR_MASS_AWARDS_PKG - show dependent code; GHR_MASS_AWARDS_PKG - show dependent code; GHR_MASS_CHANGES - show dependent code; GHR_MASS_CON_PROGRAM - show dependent code; GHR_MASS_CON_PROGRAM - show dependent code; GHR_MASS_SEL_NOA - show dependent code; GHR_MLC_PKG - show dependent code; GHR_MLC_PKG - show dependent code; GHR_MRE_PKG - show dependent code; GHR_MTO_PKG - show dependent code; GHR_PAY_CAPS - show dependent code; GHR_PAY_CAPS - show dependent code; GHR_PA_REQUESTS_PKG - show dependent code; GHR_PC_BASIC_PAY - show dependent code; GHR_POSNDT_API - show dependent code; GHR_RIF_PKG - show dependent code; GHR_SES_CONV_PKG - show dependent code; GHR_UTILITY - show dependent code; GHR_UTILITY - show dependent code; HR_CALENDAR_ENTITY_KEYS_V; HR_CALENDAR_USAGES_V; HR_CAU_BUS - show dependent code; HR_MASS_MOVE_API - show dependent code; HR_PDT_BUS - show dependent code; HR_PFT_BUS - show dependent code; HR_POSITIONS; HR_POSITIONS_V1; HR_POSITIONS_X; HR_POSITION_REQUIREMENT_API - show dependent code; HR_POS_BASE_V; HR_POS_LOV_V; HR_PROCESS_ASSIGNMENT_SS - show dependent code; HR_PSF_BUS - show dependent code; HR_REPORTS - show dependent code; HR_SALARY_SURVEY_MAPPING_API - show dependent code; HR_SUIT_MATCH_UTILITY_WEB - show dependent code; HR_VALID_GRADE_API - show dependent code; PAY_FI_ARCHIVE_PSTA - show dependent code; PER_ABSENCE_ATTENDANCES_PKG - show dependent code; PER_ASG_BUS2 - show dependent code; PER_ASSIGNMENTS_V8_PKG - show dependent code; PER_CEL_BUS - show dependent code; PER_COBRA_ECI - show dependent code; PER_DB_PER_SETUP - show dependent code; PER_DPF_BUS - show dependent code; PER_EXPANDED_POSITIONS; PER_JBR_BUS - show dependent code; PER_POS_STRUCTURE_ELEMENTS_PKG - show dependent code; PER_POS_STRUCTURE_ELEMENTS_V3; PER_QH_POPULATE - show dependent code; PER_SSM_BUS - show dependent code; PER_SUCCESSION_PLANNING_LOV; PER_SUC_BUS - show dependent code; PER_VACANCIES_PKG - show dependent code; PER_VGR_BUS - show dependent code; PQH_FR_UTILITY - show dependent code; PQH_WKS_BUDGET - show dependent code; PSP_GENERAL - show dependent code