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


TABLE: HR.PQH_POSITION_TRANSACTIONS

Object Details
Object Name: PQH_POSITION_TRANSACTIONS
Object Type: TABLE
Owner: HR
FND Design Data: TablePQH.PQH_POSITION_TRANSACTIONS
Subobject Name:
Status: VALID


POSITION_TRANSACTION along with POSN_TRAN_TIME_PERIOD is used to maintain and create positions. Each transaction needs to be approved by pre-identified approvers. On approval these transactions are applied to database.
Each transaction can be a combination of one or more templates or no template et al. A Position Control transaction may in turn start another budget transaction, which may be required to be approved before Position Control transaction can be applied to database.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PQH_POSITION_TRANSACTIONS_PK
  1. ColumnPOSITION_TRANSACTION_ID
Indexes
Index Type Uniqueness Tablespace Column
PQH_POSITION_TRANSACTIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_TRANSACTION_ID
SYS_IL0000137900C00149$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
PQH_POSITION_TRANSACTIONS_FK11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTRY_GRADE_ID
PQH_POSITION_TRANSACTIONS_FK12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAVAILABILITY_STATUS_ID
PQH_POSITION_TRANSACTIONS_FK16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_BASIS_ID
PQH_POSITION_TRANSACTIONS_FK18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWF_TRANSACTION_CATEGORY_ID
PQH_POSITION_TRANSACTIONS_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
PQH_POSITION_TRANSACTIONS_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_ID
PQH_POSITION_TRANSACTIONS_FK6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_DEFINITION_ID
PQH_POSITION_TRANSACTIONS_FK8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PQH_POSITION_TRANSACTIONS_FK9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
PQH_POSITION_TRANSACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK8 TableHR_ALL_ORGANIZATION_UNITS PQH_POSITION_TRANSACTIONS BUSINESS_GROUP_ID
PQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK9 TableHR_ALL_ORGANIZATION_UNITS PQH_POSITION_TRANSACTIONS ORGANIZATION_ID
PQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK4 TableHR_LOCATIONS_ALL PQH_POSITION_TRANSACTIONS LOCATION_ID
PQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK11 TablePER_GRADES PQH_POSITION_TRANSACTIONS ENTRY_GRADE_ID
PQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK5 TablePER_JOBS PQH_POSITION_TRANSACTIONS JOB_ID
PQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK16 TablePER_PAY_BASES PQH_POSITION_TRANSACTIONS PAY_BASIS_ID
PQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK6 TablePER_POSITION_DEFINITIONS PQH_POSITION_TRANSACTIONS POSITION_DEFINITION_ID
TablePQH_PTX_DPF_DF PQH_PTX_DPF_DF_FK1 PQH_POSITION_TRANSACTIONS PQH_PTX_DPF_DF POSITION_TRANSACTION_ID
TablePQH_PTX_EXTRA_INFO PQH_PTX_EXTRA_INFO_FK2 PQH_POSITION_TRANSACTIONS PQH_PTX_EXTRA_INFO POSITION_TRANSACTION_ID
TablePQH_PTX_SHADOW PQH_PTX_SHADOW_FK PQH_POSITION_TRANSACTIONS PQH_PTX_SHADOW POSITION_TRANSACTION_ID
TablePQH_TXN_JOB_REQUIREMENTS PQH_TXN_JOB_REQUIREMENTS_FK2 PQH_POSITION_TRANSACTIONS PQH_TXN_JOB_REQUIREMENTS POSITION_TRANSACTION_ID
TablePQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK4 PQH_POSITION_TRANSACTIONS PQH_WORKSHEET_DETAILS POSITION_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
POSITION_TRANSACTION_ID NUMBER (15) Yes Primary Key
ACTION_DATE DATE

Efffective date of the transaction
POSITION_ID NUMBER (15)
Position Identifier
AVAILABILITY_STATUS_ID NUMBER (15)
Current Status of the Position. Active/Frozen/Closed/Deleted
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group identifier
ENTRY_GRADE_ID NUMBER (15)
Grade Identifier
ENTRY_STEP_ID NUMBER (15)
Grade Step identifier
ENTRY_GRADE_RULE_ID NUMBER (15)
Grade Rule identifier
JOB_ID NUMBER (15)
Job identifier
LOCATION_ID NUMBER (15)
Location Identifier
ORGANIZATION_ID NUMBER (15)
Organization Identifier
PAY_BASIS_ID NUMBER (15)
Pay basis Identifier
PAY_FREQ_PAYROLL_ID NUMBER (15)
Payroll Identifier
POSITION_DEFINITION_ID NUMBER (15)
Position key flexfield identifier
PRIOR_POSITION_ID NUMBER (15)
Prior Position Identifier
RELIEF_POSITION_ID NUMBER (15)
Relief Position Identifier
SUCCESSOR_POSITION_ID NUMBER (15)
Successor Position Identifier
SUPERVISOR_ID NUMBER (15)
Supervisor Identifier (Person)
SUPERVISOR_POSITION_ID NUMBER (15)
Supervisor's Position id
AMENDMENT_DATE DATE

Amendment Date
AMENDMENT_RECOMMENDATION VARCHAR2 (2000)
Amendment Recomendation
AMENDMENT_REF_NUMBER VARCHAR2 (30)
Amendment Reference Number. Information only.
AVAIL_STATUS_PROP_END_DATE DATE

Date the currnet status beomes void. Informational only.
BARGAINING_UNIT_CD VARCHAR2 (30)
Bargaining Unit
COUNTRY1 VARCHAR2 (30)
Attribute used to state a country where work will be required.
COUNTRY2 VARCHAR2 (30)
Attribute used to store a country where work may be required.
COUNTRY3 VARCHAR2 (30)
Attribute used to store country where work may be required to be
CURRENT_JOB_PROP_END_DATE DATE

Date Current Job id (Job_id) ends
CURRENT_ORG_PROP_END_DATE DATE

End date in Current Organization
DATE_EFFECTIVE DATE

Date when position becomes effective.
DATE_END DATE

Date after which position is no longer valid
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. Most positions will have 1.0 FTE; some representing the same work in the same unit may be combined (e.g., 3.0 FTE). A pooled position may or may not be assigned FTE.
FTE_CAPACITY VARCHAR2 (30)
Indicates full time capacity.
LOCATION1 VARCHAR2 (30)
Indicates a location where the job/position will required work to
LOCATION2 VARCHAR2 (30)
Indicates a location where the job/position will require work to
LOCATION3 VARCHAR2 (30)
Indicates a location where the job/position will require work to
MAX_PERSONS NUMBER (4)
Maximum number of employees on this position.
NAME VARCHAR2 (240)
Position Name
OTHER_REQUIREMENTS VARCHAR2 (2000)
Comments relevant to the job/position.
OVERLAP_PERIOD NUMBER (22)
Overlap period
OVERLAP_UNIT_CD VARCHAR2 (30)
Unit of Period.
PASSPORT_REQUIRED VARCHAR2 (30)
Indicates that a passport is required for the job/position.
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)
Allow recruitment 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 placeholder
PROPOSED_DATE_FOR_LAYOFF DATE

Proposed Date for layoff placeholder
RELOCATE_DOMESTICALLY VARCHAR2 (30)
Willingness to relocate domestically.
RELOCATE_INTERNATIONALLY VARCHAR2 (30)
Willingness to relocate internationally.
RELOCATION_REQUIRED VARCHAR2 (30)
Indicates that the job/position requires relocation.
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 info
SERVICE_MINIMUM VARCHAR2 (30)
Indicates the minimum length of service to be considered for the
TERM_START_DAY_CD VARCHAR2 (30)
Start Day of Work Term
TERM_START_MONTH_CD VARCHAR2 (30)
Start Month of Work Term
TIME_NORMAL_FINISH VARCHAR2 (5)
Finish time.
TIME_NORMAL_START VARCHAR2 (5)
Start time.
TRANSACTION_STATUS VARCHAR2 (30)
An indicator of whether the position is active (in use), frozen (cannot be filled once empty), closed (no longer in use) or deleted (never in use).
TRAVEL_REQUIRED VARCHAR2 (30)
Indicates whether travel is required
VISIT_INTERNATIONALLY VARCHAR2 (30)
Indicates whether a person is willing to visit internationally.
WORKING_HOURS NUMBER (22)
Working Hours
WORKS_COUNCIL_APPROVAL_FLAG VARCHAR2 (30)
Work Council Approvla Flag
WORK_ANY_COUNTRY VARCHAR2 (30)
Yes/No field to descibe whether work is required to be done in an
WORK_ANY_LOCATION VARCHAR2 (30)
Willingness to work in any location.
WORK_DURATION VARCHAR2 (30)
Work duration that is required.
WORK_PERIOD_TYPE_CD VARCHAR2 (30)
Identifies that the position is only used during part of the year.
WORK_SCHEDULE VARCHAR2 (30)
Indicates work schedule desired.
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)
Developer descriptive flexfield
ATTRIBUTE22 VARCHAR2 (150)
Developer descriptive flexfield
ATTRIBUTE23 VARCHAR2 (150)
Developer descriptive flexfield
ATTRIBUTE24 VARCHAR2 (150)
Developer descriptive flexfield
ATTRIBUTE25 VARCHAR2 (150)
Developer descriptive flexfield
ATTRIBUTE26 VARCHAR2 (150)
Developer descriptive flexfield
ATTRIBUTE27 VARCHAR2 (150)
Developer descriptive flexfield
ATTRIBUTE28 VARCHAR2 (150)
Developer descriptive flexfield
ATTRIBUTE29 VARCHAR2 (150)
Developer descriptive flexfield
ATTRIBUTE30 VARCHAR2 (150)
Developer descriptive flexfield
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes 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) Yes Object version Number
WF_TRANSACTION_CATEGORY_ID NUMBER (15)
Transaction Category Identifier For Work Flow
COMMENTS CLOB (4000)
Comments
Query Text

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


SELECT POSITION_TRANSACTION_ID
,      ACTION_DATE
,      POSITION_ID
,      AVAILABILITY_STATUS_ID
,      BUSINESS_GROUP_ID
,      ENTRY_GRADE_ID
,      ENTRY_STEP_ID
,      ENTRY_GRADE_RULE_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PAY_BASIS_ID
,      PAY_FREQ_PAYROLL_ID
,      POSITION_DEFINITION_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
,      COUNTRY1
,      COUNTRY2
,      COUNTRY3
,      CURRENT_JOB_PROP_END_DATE
,      CURRENT_ORG_PROP_END_DATE
,      DATE_EFFECTIVE
,      DATE_END
,      EARLIEST_HIRE_DATE
,      FILL_BY_DATE
,      FREQUENCY
,      FTE
,      FTE_CAPACITY
,      LOCATION1
,      LOCATION2
,      LOCATION3
,      MAX_PERSONS
,      NAME
,      OTHER_REQUIREMENTS
,      OVERLAP_PERIOD
,      OVERLAP_UNIT_CD
,      PASSPORT_REQUIRED
,      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
,      RELOCATE_DOMESTICALLY
,      RELOCATE_INTERNATIONALLY
,      RELOCATION_REQUIRED
,      REPLACEMENT_REQUIRED_FLAG
,      REVIEW_FLAG
,      SEASONAL_FLAG
,      SECURITY_REQUIREMENTS
,      SERVICE_MINIMUM
,      TERM_START_DAY_CD
,      TERM_START_MONTH_CD
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      TRANSACTION_STATUS
,      TRAVEL_REQUIRED
,      VISIT_INTERNATIONALLY
,      WORKING_HOURS
,      WORKS_COUNCIL_APPROVAL_FLAG
,      WORK_ANY_COUNTRY
,      WORK_ANY_LOCATION
,      WORK_DURATION
,      WORK_PERIOD_TYPE_CD
,      WORK_SCHEDULE
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      WF_TRANSACTION_CATEGORY_ID
,      COMMENTS
FROM HR.PQH_POSITION_TRANSACTIONS;

Dependencies

[top of page]

HR.PQH_POSITION_TRANSACTIONS does not reference any database object

HR.PQH_POSITION_TRANSACTIONS is referenced by following:

SchemaHR
ViewPQH_POSITION_TRANSACTIONS#