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]

TABLE: HR.PQH_PTX_SHADOW

Object Details

Object Name:	PQH_PTX_SHADOW
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_PTX_SHADOW
Subobject Name:
Status:	VALID

Position Extra information shadow used for refreshing position transaction extra information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_PTX_SHADOW_PK

POSITION_TRANSACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_PTX_SHADOW_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	POSITION_TRANSACTION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_PTX_SHADOW		PQH_POSITION_TRANSACTIONS	PQH_PTX_SHADOW POSITION_TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_TRANSACTION_ID	NUMBER	(15)	Yes	Primary Key
ACTION_DATE	DATE			Effective date of the transaction
POSITION_ID	NUMBER	(15)		Position identifier
AVAILABILITY_STATUS_ID	NUMBER	(15)	Yes	Current Status of the Position. Active/Frozen/Closed/Deleted
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business group
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 frequency identifier
POSITION_DEFINITION_ID	NUMBER	(15)	Yes	position keyflexfield 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 (person)
SUPERVISOR_POSITION_ID	NUMBER	(15)		Supervisor's Position id
AMENDMENT_DATE	DATE			Amendment Date
AMENDMENT_RECOMMENDATION	VARCHAR2	(2000)		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	(10)		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.
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
FTE_CAPACITY	VARCHAR2	(30)		Indicates full time capacity.
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)		Permit Hiring 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)		Postiong Description
PROBATION_PERIOD	NUMBER	(22)		Probationary period.
PROBATION_PERIOD_UNIT_CD	VARCHAR2	(30)		Qualifying units.
RELOCATE_DOMESTICALLY	VARCHAR2	(30)		Willingness to relocate domestically.
RELOCATE_INTERNATIONALLY	VARCHAR2	(30)		Willingness to relocate internationally.
PROPOSED_FTE_FOR_LAYOFF	NUMBER	(10)		FTE proposed for lay off
RELOCATION_REQUIRED	VARCHAR2	(30)		Indicates that the job/position requires relocation.
PROPOSED_DATE_FOR_LAYOFF	DATE			Date for lay off
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 requirement
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.
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_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
WORK_DURATION	VARCHAR2	(30)		Work duration that is required.
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
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
WORK_SCHEDULE	VARCHAR2	(30)		Indicates work schedule desired.
COMMENTS	LONG	(0)		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
,      LOCATION1
,      LOCATION2
,      FTE_CAPACITY
,      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
,      RELOCATE_DOMESTICALLY
,      RELOCATE_INTERNATIONALLY
,      PROPOSED_FTE_FOR_LAYOFF
,      RELOCATION_REQUIRED
,      PROPOSED_DATE_FOR_LAYOFF
,      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
,      TRAVEL_REQUIRED
,      VISIT_INTERNATIONALLY
,      WORKING_HOURS
,      WORKS_COUNCIL_APPROVAL_FLAG
,      WORK_ANY_COUNTRY
,      WORK_ANY_LOCATION
,      WORK_PERIOD_TYPE_CD
,      WORK_TERM_END_DAY_CD
,      WORK_TERM_END_MONTH_CD
,      WORK_DURATION
,      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
,      WORK_SCHEDULE
,      COMMENTS
FROM HR.PQH_PTX_SHADOW;

Dependencies

[top of page]

HR.PQH_PTX_SHADOW does not reference any database object

HR.PQH_PTX_SHADOW is referenced by following:

APPS: PQH_PTX_SHADOW; PQH_PTX_SHADOW_WHO
PUBLIC: PQH_PTX_SHADOW