DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_POSITION_API_V

Object Details
Object Name: HR_POSITION_API_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_POSITION_API_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
POSITION_ID NUMBER (15) Yes System-generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Effective Start Date, part of the primary key.
EFFECTIVE_END_DATE DATE
Yes Effective End Date, part of the primary key.
AVAILABILITY_STATUS_ID NUMBER (15) Yes Current Status of the Position. Refers to PER_SHARED_TYPES.
BUSINESS_GROUP_ID NUMBER (15) Yes 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) Yes Foreign key to PER_JOBS
LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS_ALL
ORGANIZATION_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
PAY_BASIS_ID NUMBER (9)
Foreign key to PER_PAY_BASES.
PAY_FREQ_PAYROLL_ID NUMBER (15)
Pseudo Foreign key to PAY_ALL_PAYROLLS_F
POSITION_DEFINITION_ID NUMBER (15) Yes 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_ID NUMBER (10)
Foreign key to PER_PEOPLE.
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.
AVAIL_STATUS_PROP_END_DATE DATE

Date the current status beomes void.
BARGAINING_UNIT_CD VARCHAR2 (30)
Bargaining Unit
COMMENTS CLOB (4000)
Comments
COPIED_TO_OLD_TABLE_FLAG VARCHAR2 (30)
Set to Y, if data has been copied to PER_ALL_POSITIONS
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.
DATE_EFFECTIVE DATE
Yes Date when position becomes effective.
DATE_END DATE

Date after which position is no longer valid. For full HRMS installations, this column will remain null.
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
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
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
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield
REQUEST_ID NUMBER (15)
Standard who column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard who column.
PROGRAM_ID NUMBER (15)
Standard who column.
PROGRAM_UPDATE_DATE DATE

Standard who column.
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
SEGMENT1 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT2 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT3 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT4 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT5 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT6 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT7 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT8 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT9 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT10 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT11 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT12 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT13 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT14 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT15 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT16 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT17 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT18 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT19 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT20 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT30 VARCHAR2 (60)
Key flexfield segment column.
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_BASIS_ID
,      PAY_FREQ_PAYROLL_ID
,      POSITION_DEFINITION_ID
,      POSITION_TRANSACTION_ID
,      PRIOR_POSITION_ID
,      RELIEF_POSITION_ID
,      SUCCESSOR_POSITION_ID
,      SUPERVISOR_ID
,      SUPERVISOR_POSITION_ID
,      AMENDMENT_DATE
,      AMENDMENT_RECOMMENDATION
,      AMENDMENT_REF_NUMBER
,      AVAIL_STATUS_PROP_END_DATE
,      BARGAINING_UNIT_CD
,      COMMENTS
,      COPIED_TO_OLD_TABLE_FLAG
,      CURRENT_JOB_PROP_END_DATE
,      CURRENT_ORG_PROP_END_DATE
,      DATE_EFFECTIVE
,      DATE_END
,      EARLIEST_HIRE_DATE
,      FILL_BY_DATE
,      FREQUENCY
,      FTE
,      MAX_PERSONS
,      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
,      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
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
FROM APPS.HR_POSITION_API_V;

Dependencies

[top of page]

APPS.HR_POSITION_API_V references the following:

SchemaAPPS
SynonymHR_ALL_POSITIONS_F
SynonymPER_POSITION_DEFINITIONS

APPS.HR_POSITION_API_V is not referenced by any database object