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.PAY_PSS_TRANSACTION_STEPS

Object Details

Object Name:	PAY_PSS_TRANSACTION_STEPS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_PSS_TRANSACTION_STEPS
Subobject Name:
Status:	VALID

PAY_PSS_TRANSACTION_STEPS stores in progress transaction
data from the Self Service Payment Methods interface.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_PSS_TRANSACTION_STEPS_PK

TRANSACTION_STEP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_PSS_TRANSACTION_STEPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_STEP_ID
PAY_PSS_TRANSACTION_STEPS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXTERNAL_ACCOUNT_ID
PAY_PSS_TRANSACTION_STEPS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	O_EXTERNAL_ACCOUNT_ID
PAY_PSS_TRANSACTION_STEPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
PAY_PSS_TRANSACTION_STEPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_PSS_TRANSACTION_STEPS		PAY_EXTERNAL_ACCOUNTS	PAY_PSS_TRANSACTION_STEPS O_EXTERNAL_ACCOUNT_ID
PAY_PSS_TRANSACTION_STEPS		PAY_EXTERNAL_ACCOUNTS	PAY_PSS_TRANSACTION_STEPS EXTERNAL_ACCOUNT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_STEP_ID	NUMBER		Yes	System-generated primary key column.
TRANSACTION_ID	NUMBER		Yes	System-generated value that groups a set of rows together into a transaction.
SOURCE_TABLE	VARCHAR2	(30)	Yes	Payments table from which the data is stored.
STATE	VARCHAR2	(30)	Yes	The state of this transaction step.
PERSONAL_PAYMENT_METHOD_ID	NUMBER			Primary key for existing payment method.
UPDATE_OVN	NUMBER		Yes	OBJECT_VERSION_NUMBER required for updates.
DELETE_OVN	NUMBER			OBJECT_VERSION_NUMBER used for deletes.
UPDATE_DATETRACK_MODE	VARCHAR2	(30)		Datetrack mode used for updates.
DELETE_DATETRACK_MODE	VARCHAR2	(30)		Datetrack mode used for deletes.
DELETE_DISABLED	VARCHAR2	(30)	Yes	Whether or not deletes are allowed for this payment method.
EFFECTIVE_DATE	DATE		Yes	Effective date of updates/creates.
ORG_PAYMENT_METHOD_ID	NUMBER		Yes	ORG_PAYMENT_METHOD_ID used in this transaction step.
ASSIGNMENT_ID	NUMBER		Yes	The assignment that this payment method relates to.
PAYMENT_TYPE	VARCHAR2	(30)	Yes	The payment type of this payment.
CURRENCY_CODE	VARCHAR2	(30)	Yes	The currency for this payment.
TERRITORY_CODE	VARCHAR2	(30)	Yes	The territory for this payment.
REAL_PRIORITY	NUMBER			The actual priority value to be allocated to this payment when it is updated.
LOGICAL_PRIORITY	NUMBER			The proposed priority displayed to the user.
AMOUNT_TYPE	VARCHAR2	(30)		Whether the proposed amount is monetary or a percentage of net pay.
AMOUNT	NUMBER			The proposed amount value.
EXTERNAL_ACCOUNT_ID	NUMBER			Reference to the proposed bank details in PAY_EXTERNAL_ACCOUNTS.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Proposed descriptive flex segment.
ATTRIBUTE17	VARCHAR2	(150)		Proposed descriptive flex segment.
ATTRIBUTE18	VARCHAR2	(150)		Proposed descriptive flex segment.
ATTRIBUTE19	VARCHAR2	(150)		Proposed descriptive flex segment.
ATTRIBUTE20	VARCHAR2	(150)		Proposed descriptive flex segment.
O_REAL_PRIORITY	NUMBER			The current actual priority for the payment.
O_LOGICAL_PRIORITY	NUMBER			The current priority for display to the user.
O_AMOUNT_TYPE	VARCHAR2	(30)		Whether the current amount is monetary or a percentage of net pay.
O_AMOUNT	NUMBER			The current amount value.
O_EXTERNAL_ACCOUNT_ID	NUMBER			Reference to the current bank details in PAY_EXTERNAL_ACCOUNTS.
O_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Current Payments descriptive flex context.
O_ATTRIBUTE1	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE2	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE3	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE4	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE5	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE6	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE7	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE8	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE9	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE10	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE11	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE12	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE13	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE14	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE15	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE16	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE17	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE18	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE19	VARCHAR2	(150)		Current Payments descriptive flex segment.
O_ATTRIBUTE20	VARCHAR2	(150)		Current Payments descriptive flex segment.
RUN_TYPE_ID	NUMBER	(10)		Foreign key to PAY_RUN_TYPES.
PPM_INFORMATION_CATEGORY	VARCHAR2	(30)		New Context of the Further Personal Payment Method Info DFF
PPM_INFORMATION1	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION2	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION3	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION4	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION5	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION6	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION7	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION8	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION9	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION10	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION11	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION12	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION13	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION14	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION15	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION16	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION17	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION18	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION19	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION20	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION21	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION22	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION23	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION24	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION25	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION26	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION27	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION28	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION29	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
PPM_INFORMATION30	VARCHAR2	(150)		Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION_CATEGORY	VARCHAR2	(30)		Old Context of the Previous Further Personal Payment Method Info DFF Segment.
O_PPM_INFORMATION1	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION2	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION3	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION4	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION5	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION6	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION7	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION8	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION9	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION10	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION11	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION12	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION13	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION14	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION15	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION16	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION17	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION18	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION19	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION20	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION21	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION22	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION23	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION24	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION25	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION26	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION27	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION28	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION29	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment
O_PPM_INFORMATION30	VARCHAR2	(150)		Previous Further Personal Payment Method Info DFF Segment

Query Text

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


SELECT TRANSACTION_STEP_ID
,      TRANSACTION_ID
,      SOURCE_TABLE
,      STATE
,      PERSONAL_PAYMENT_METHOD_ID
,      UPDATE_OVN
,      DELETE_OVN
,      UPDATE_DATETRACK_MODE
,      DELETE_DATETRACK_MODE
,      DELETE_DISABLED
,      EFFECTIVE_DATE
,      ORG_PAYMENT_METHOD_ID
,      ASSIGNMENT_ID
,      PAYMENT_TYPE
,      CURRENCY_CODE
,      TERRITORY_CODE
,      REAL_PRIORITY
,      LOGICAL_PRIORITY
,      AMOUNT_TYPE
,      AMOUNT
,      EXTERNAL_ACCOUNT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      O_REAL_PRIORITY
,      O_LOGICAL_PRIORITY
,      O_AMOUNT_TYPE
,      O_AMOUNT
,      O_EXTERNAL_ACCOUNT_ID
,      O_ATTRIBUTE_CATEGORY
,      O_ATTRIBUTE1
,      O_ATTRIBUTE2
,      O_ATTRIBUTE3
,      O_ATTRIBUTE4
,      O_ATTRIBUTE5
,      O_ATTRIBUTE6
,      O_ATTRIBUTE7
,      O_ATTRIBUTE8
,      O_ATTRIBUTE9
,      O_ATTRIBUTE10
,      O_ATTRIBUTE11
,      O_ATTRIBUTE12
,      O_ATTRIBUTE13
,      O_ATTRIBUTE14
,      O_ATTRIBUTE15
,      O_ATTRIBUTE16
,      O_ATTRIBUTE17
,      O_ATTRIBUTE18
,      O_ATTRIBUTE19
,      O_ATTRIBUTE20
,      RUN_TYPE_ID
,      PPM_INFORMATION_CATEGORY
,      PPM_INFORMATION1
,      PPM_INFORMATION2
,      PPM_INFORMATION3
,      PPM_INFORMATION4
,      PPM_INFORMATION5
,      PPM_INFORMATION6
,      PPM_INFORMATION7
,      PPM_INFORMATION8
,      PPM_INFORMATION9
,      PPM_INFORMATION10
,      PPM_INFORMATION11
,      PPM_INFORMATION12
,      PPM_INFORMATION13
,      PPM_INFORMATION14
,      PPM_INFORMATION15
,      PPM_INFORMATION16
,      PPM_INFORMATION17
,      PPM_INFORMATION18
,      PPM_INFORMATION19
,      PPM_INFORMATION20
,      PPM_INFORMATION21
,      PPM_INFORMATION22
,      PPM_INFORMATION23
,      PPM_INFORMATION24
,      PPM_INFORMATION25
,      PPM_INFORMATION26
,      PPM_INFORMATION27
,      PPM_INFORMATION28
,      PPM_INFORMATION29
,      PPM_INFORMATION30
,      O_PPM_INFORMATION_CATEGORY
,      O_PPM_INFORMATION1
,      O_PPM_INFORMATION2
,      O_PPM_INFORMATION3
,      O_PPM_INFORMATION4
,      O_PPM_INFORMATION5
,      O_PPM_INFORMATION6
,      O_PPM_INFORMATION7
,      O_PPM_INFORMATION8
,      O_PPM_INFORMATION9
,      O_PPM_INFORMATION10
,      O_PPM_INFORMATION11
,      O_PPM_INFORMATION12
,      O_PPM_INFORMATION13
,      O_PPM_INFORMATION14
,      O_PPM_INFORMATION15
,      O_PPM_INFORMATION16
,      O_PPM_INFORMATION17
,      O_PPM_INFORMATION18
,      O_PPM_INFORMATION19
,      O_PPM_INFORMATION20
,      O_PPM_INFORMATION21
,      O_PPM_INFORMATION22
,      O_PPM_INFORMATION23
,      O_PPM_INFORMATION24
,      O_PPM_INFORMATION25
,      O_PPM_INFORMATION26
,      O_PPM_INFORMATION27
,      O_PPM_INFORMATION28
,      O_PPM_INFORMATION29
,      O_PPM_INFORMATION30
FROM HR.PAY_PSS_TRANSACTION_STEPS;

Dependencies

[top of page]

HR.PAY_PSS_TRANSACTION_STEPS does not reference any database object

HR.PAY_PSS_TRANSACTION_STEPS is referenced by following:

HR: PAY_PSS_TRANSACTION_STEPS#