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_STAT_TRANS_AUDIT

Object Details

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

This table is used to store the history of a transaction to meet the statutory requirement. e.g. For US Localization, the table stores the details of the W4 Changes done when an employee login from Self Service and modifies his records. This is required as IRS can ask the employer for a history of the changes which were done by the employee.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_STAT_TRANS_AUDIT_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_PARENT_ID
PAY_STAT_TRANS_AUDIT_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID
PAY_STAT_TRANS_AUDIT_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
PAY_STAT_TRANS_AUDIT_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PAY_STAT_TRANS_AUDIT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_DATE
PAY_STAT_TRANS_AUDIT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_EFFECTIVE_DATE
PAY_STAT_TRANS_AUDIT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE1 SOURCE1_TYPE
PAY_STAT_TRANS_AUDIT_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE2 SOURCE2_TYPE
PAY_STAT_TRANS_AUDIT_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE3 SOURCE3_TYPE
PAY_STAT_TRANS_AUDIT_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE4 SOURCE4_TYPE
PAY_STAT_TRANS_AUDIT_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE5 SOURCE5_TYPE
PAY_STAT_TRANS_AUDIT_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STAT_TRANS_AUDIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
STAT_TRANS_AUDIT_ID	NUMBER	(15)	Yes	Primary Key for the Table
TRANSACTION_TYPE	VARCHAR2	(30)	Yes	Transaction type e.g. ONLINE_TAX_FORMS
TRANSACTION_SUBTYPE	VARCHAR2	(30)		Transaction Subtype e.g. W4
TRANSACTION_DATE	DATE		Yes	Transaction Date
TRANSACTION_EFFECTIVE_DATE	DATE		Yes	Transaction Effective Date
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group ID
PERSON_ID	NUMBER	(9)		Person ID
ASSIGNMENT_ID	NUMBER	(9)		Assignment ID
SOURCE1	VARCHAR2	(30)		The value which is relevent for this transaction.e.g. for W4 this coulumn is used to identify if the Federal or the State tax record was updated. So, we store the Federal jurisdiction code (00-000-0000) or the state jurisdiction_code (XX-000-0000).
SOURCE1_TYPE	VARCHAR2	(30)		What is the column type which is in Source1 column e.g. JURISDICTION
SOURCE2	VARCHAR2	(30)		The 2nd value which is relevent for this transaction
SOURCE2_TYPE	VARCHAR2	(30)		Type of value in Souce2
SOURCE3	VARCHAR2	(30)		3rd value which is relevent for this transaction
SOURCE3_TYPE	VARCHAR2	(30)		Type of value in Souce3
SOURCE4	VARCHAR2	(30)		4th value which is relevent for this transaction
SOURCE4_TYPE	VARCHAR2	(30)		Type of value in Souce4
SOURCE5	VARCHAR2	(30)		5th value which is relevent for this transaction
SOURCE5_TYPE	VARCHAR2	(30)		Type of value in Souce5
TRANSACTION_PARENT_ID	NUMBER	(15)		If the main/parent transaction has caused few other updates. This coulmn will store the STAT_TRANS_AUDIT_ID for the parent record. e.g. for W4 if the Federal tax record is updates, the states which follow the federal will also be updated.
AUDIT_INFORMATION_CATEGORY	VARCHAR2	(30)		Audit Information Category e.g. W4FED, W4STATE
AUDIT_INFORMATION1	VARCHAR2	(150)		Audit Information1
AUDIT_INFORMATION2	VARCHAR2	(150)		Audit Information2
AUDIT_INFORMATION3	VARCHAR2	(150)		Audit Information3
AUDIT_INFORMATION4	VARCHAR2	(150)		Audit Information4
AUDIT_INFORMATION5	VARCHAR2	(150)		Audit Information5
AUDIT_INFORMATION6	VARCHAR2	(150)		Audit Information6
AUDIT_INFORMATION7	VARCHAR2	(150)		Audit Information7
AUDIT_INFORMATION8	VARCHAR2	(150)		Audit Information8
AUDIT_INFORMATION9	VARCHAR2	(150)		Audit Information9
AUDIT_INFORMATION10	VARCHAR2	(150)		Audit Information10
AUDIT_INFORMATION11	VARCHAR2	(150)		Audit Information11
AUDIT_INFORMATION12	VARCHAR2	(150)		Audit Information12
AUDIT_INFORMATION13	VARCHAR2	(150)		Audit Information13
AUDIT_INFORMATION14	VARCHAR2	(150)		Audit Information14
AUDIT_INFORMATION15	VARCHAR2	(150)		Audit Information15
AUDIT_INFORMATION16	VARCHAR2	(150)		Audit Information16
AUDIT_INFORMATION17	VARCHAR2	(150)		Audit Information17
AUDIT_INFORMATION18	VARCHAR2	(150)		Audit Information18
AUDIT_INFORMATION19	VARCHAR2	(150)		Audit Information19
AUDIT_INFORMATION20	VARCHAR2	(150)		Audit Information20
AUDIT_INFORMATION21	VARCHAR2	(150)		Audit Information21
AUDIT_INFORMATION22	VARCHAR2	(150)		Audit Information22
AUDIT_INFORMATION23	VARCHAR2	(150)		Audit Information23
AUDIT_INFORMATION24	VARCHAR2	(150)		Audit Information24
AUDIT_INFORMATION25	VARCHAR2	(150)		Audit Information25
AUDIT_INFORMATION26	VARCHAR2	(150)		Audit Information26
AUDIT_INFORMATION27	VARCHAR2	(150)		Audit Information27
AUDIT_INFORMATION28	VARCHAR2	(150)		Audit Information28
AUDIT_INFORMATION29	VARCHAR2	(150)		Audit Information29
AUDIT_INFORMATION30	VARCHAR2	(150)		Audit Information30
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
TITLE	VARCHAR2	(30)		Title
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number

Query Text

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


SELECT STAT_TRANS_AUDIT_ID
,      TRANSACTION_TYPE
,      TRANSACTION_SUBTYPE
,      TRANSACTION_DATE
,      TRANSACTION_EFFECTIVE_DATE
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      SOURCE1
,      SOURCE1_TYPE
,      SOURCE2
,      SOURCE2_TYPE
,      SOURCE3
,      SOURCE3_TYPE
,      SOURCE4
,      SOURCE4_TYPE
,      SOURCE5
,      SOURCE5_TYPE
,      TRANSACTION_PARENT_ID
,      AUDIT_INFORMATION_CATEGORY
,      AUDIT_INFORMATION1
,      AUDIT_INFORMATION2
,      AUDIT_INFORMATION3
,      AUDIT_INFORMATION4
,      AUDIT_INFORMATION5
,      AUDIT_INFORMATION6
,      AUDIT_INFORMATION7
,      AUDIT_INFORMATION8
,      AUDIT_INFORMATION9
,      AUDIT_INFORMATION10
,      AUDIT_INFORMATION11
,      AUDIT_INFORMATION12
,      AUDIT_INFORMATION13
,      AUDIT_INFORMATION14
,      AUDIT_INFORMATION15
,      AUDIT_INFORMATION16
,      AUDIT_INFORMATION17
,      AUDIT_INFORMATION18
,      AUDIT_INFORMATION19
,      AUDIT_INFORMATION20
,      AUDIT_INFORMATION21
,      AUDIT_INFORMATION22
,      AUDIT_INFORMATION23
,      AUDIT_INFORMATION24
,      AUDIT_INFORMATION25
,      AUDIT_INFORMATION26
,      AUDIT_INFORMATION27
,      AUDIT_INFORMATION28
,      AUDIT_INFORMATION29
,      AUDIT_INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TITLE
,      OBJECT_VERSION_NUMBER
FROM HR.PAY_STAT_TRANS_AUDIT;

Dependencies

[top of page]

HR.PAY_STAT_TRANS_AUDIT does not reference any database object

HR.PAY_STAT_TRANS_AUDIT is referenced by following:

HR: PAY_STAT_TRANS_AUDIT#