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: ViewPER.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 Mandatory 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:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHR_ALL_POSITIONS_F
SynonymHR_ALL_POSITIONS_F_TL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
APPS.HR_POSITIONS_F is referenced by following:

SchemaAPPS
Package BodyBEN_ASSIGNMENT_INTERNAL - show dependent code
Package BodyGHR_EHRI_DYNRPT - show dependent code
PL/SQL PackageGHR_MASS_AWARDS_PKG - show dependent code
Package BodyGHR_MASS_AWARDS_PKG - show dependent code
Package BodyGHR_MASS_CHANGES - show dependent code
PL/SQL PackageGHR_MASS_CON_PROGRAM - show dependent code
Package BodyGHR_MASS_CON_PROGRAM - show dependent code
Package BodyGHR_MASS_SEL_NOA - show dependent code
PL/SQL PackageGHR_MLC_PKG - show dependent code
Package BodyGHR_MLC_PKG - show dependent code
Package BodyGHR_MRE_PKG - show dependent code
Package BodyGHR_MTO_PKG - show dependent code
Package BodyGHR_PAY_CAPS - show dependent code
PL/SQL PackageGHR_PAY_CAPS - show dependent code
Package BodyGHR_PA_REQUESTS_PKG - show dependent code
Package BodyGHR_PC_BASIC_PAY - show dependent code
Package BodyGHR_POSNDT_API - show dependent code
Package BodyGHR_RIF_PKG - show dependent code
Package BodyGHR_SES_CONV_PKG - show dependent code
Package BodyGHR_UTILITY - show dependent code
PL/SQL PackageGHR_UTILITY - show dependent code
ViewHR_CALENDAR_ENTITY_KEYS_V
ViewHR_CALENDAR_USAGES_V
Package BodyHR_CAU_BUS - show dependent code
Package BodyHR_MASS_MOVE_API - show dependent code
Package BodyHR_PDT_BUS - show dependent code
Package BodyHR_PFT_BUS - show dependent code
ViewHR_POSITIONS
ViewHR_POSITIONS_V1
ViewHR_POSITIONS_X
Package BodyHR_POSITION_REQUIREMENT_API - show dependent code
ViewHR_POS_BASE_V
ViewHR_POS_LOV_V
Package BodyHR_PROCESS_ASSIGNMENT_SS - show dependent code
Package BodyHR_PSF_BUS - show dependent code
Package BodyHR_REPORTS - show dependent code
Package BodyHR_SALARY_SURVEY_MAPPING_API - show dependent code
Package BodyHR_SUIT_MATCH_UTILITY_WEB - show dependent code
Package BodyHR_VALID_GRADE_API - show dependent code
Package BodyPAY_FI_ARCHIVE_PSTA - show dependent code
Package BodyPER_ABSENCE_ATTENDANCES_PKG - show dependent code
Package BodyPER_ASG_BUS2 - show dependent code
Package BodyPER_ASSIGNMENTS_V8_PKG - show dependent code
Package BodyPER_CEL_BUS - show dependent code
Package BodyPER_COBRA_ECI - show dependent code
Package BodyPER_DB_PER_SETUP - show dependent code
Package BodyPER_DPF_BUS - show dependent code
ViewPER_EXPANDED_POSITIONS
Package BodyPER_JBR_BUS - show dependent code
Package BodyPER_POS_STRUCTURE_ELEMENTS_PKG - show dependent code
ViewPER_POS_STRUCTURE_ELEMENTS_V3
Package BodyPER_QH_POPULATE - show dependent code
Package BodyPER_SSM_BUS - show dependent code
ViewPER_SUCCESSION_PLANNING_LOV
Package BodyPER_SUC_BUS - show dependent code
Package BodyPER_VACANCIES_PKG - show dependent code
Package BodyPER_VGR_BUS - show dependent code
Package BodyPQH_FR_UTILITY - show dependent code
Package BodyPQH_WKS_BUDGET - show dependent code
Package BodyPSP_GENERAL - show dependent code