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


TABLE: HR.HR_ALL_POSITIONS_F

Object Details
Object Name: HR_ALL_POSITIONS_F
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_ALL_POSITIONS_F
Subobject Name:
Status: VALID


HR_ALL_POSITIONS_F is the datetracked table holding position definitions. A position is defined as the unique occurrence of a job in one organization. There can be many different positions that share the same JOB_ID and ORGANIZATION_ID, but each position is uniquely identified by the POSITION_ID and by the NAME. The position name is a concatenation of flexfield segments stored in the PER_POSITION_DEFINITIONS table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HR_ALL_POSITIONS_F_PK
  1. ColumnPOSITION_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
HR_ALL_POSITIONS_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
SYS_IL0000043737C00136$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
HR_ALL_POSITIONS_F_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRIOR_POSITION_ID
HR_ALL_POSITIONS_F_FK10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_TRANSACTION_ID
HR_ALL_POSITIONS_F_FK11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTRY_GRADE_ID
HR_ALL_POSITIONS_F_FK12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAVAILABILITY_STATUS_ID
HR_ALL_POSITIONS_F_FK13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_FREQ_PAYROLL_ID
HR_ALL_POSITIONS_F_FK14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTRY_GRADE_RULE_ID
HR_ALL_POSITIONS_F_FK15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTRY_STEP_ID
HR_ALL_POSITIONS_F_FK16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_BASIS_ID
HR_ALL_POSITIONS_F_FK17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPERVISOR_ID
HR_ALL_POSITIONS_F_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPERVISOR_POSITION_ID
HR_ALL_POSITIONS_F_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUCCESSOR_POSITION_ID
HR_ALL_POSITIONS_F_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
HR_ALL_POSITIONS_F_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_ID
HR_ALL_POSITIONS_F_FK6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_DEFINITION_ID
HR_ALL_POSITIONS_F_FK7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRELIEF_POSITION_ID
HR_ALL_POSITIONS_F_FK8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
HR_ALL_POSITIONS_F_FK9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
HR_ALL_POSITIONS_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK8 TableHR_ALL_ORGANIZATION_UNITS HR_ALL_POSITIONS_F BUSINESS_GROUP_ID
HR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK9 TableHR_ALL_ORGANIZATION_UNITS HR_ALL_POSITIONS_F ORGANIZATION_ID
HR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK4 TableHR_LOCATIONS_ALL HR_ALL_POSITIONS_F LOCATION_ID
HR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK11 TablePER_GRADES HR_ALL_POSITIONS_F ENTRY_GRADE_ID
HR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK5 TablePER_JOBS HR_ALL_POSITIONS_F JOB_ID
HR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK16 TablePER_PAY_BASES HR_ALL_POSITIONS_F PAY_BASIS_ID
HR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK6 TablePER_POSITION_DEFINITIONS HR_ALL_POSITIONS_F POSITION_DEFINITION_ID
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
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
COMMENTS CLOB (4000)
Comments
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
,      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
,      COMMENTS
FROM HR.HR_ALL_POSITIONS_F;

Dependencies

[top of page]

HR.HR_ALL_POSITIONS_F does not reference any database object

HR.HR_ALL_POSITIONS_F is referenced by following:

SchemaHR
ViewHR_ALL_POSITIONS_F#