Skip to content

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

VIEW: HR.PAY_STAT_TRANS_AUDIT#

Object Details
Object Name: PAY_STAT_TRANS_AUDIT#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
STAT_TRANS_AUDIT_ID NUMBER (15) Yes
TRANSACTION_TYPE VARCHAR2 (30) Yes
TRANSACTION_SUBTYPE VARCHAR2 (30)
TRANSACTION_DATE DATE
Yes
TRANSACTION_EFFECTIVE_DATE DATE
Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
PERSON_ID NUMBER (9)
ASSIGNMENT_ID NUMBER (9)
SOURCE1 VARCHAR2 (30)
SOURCE1_TYPE VARCHAR2 (30)
SOURCE2 VARCHAR2 (30)
SOURCE2_TYPE VARCHAR2 (30)
SOURCE3 VARCHAR2 (30)
SOURCE3_TYPE VARCHAR2 (30)
SOURCE4 VARCHAR2 (30)
SOURCE4_TYPE VARCHAR2 (30)
SOURCE5 VARCHAR2 (30)
SOURCE5_TYPE VARCHAR2 (30)
TRANSACTION_PARENT_ID NUMBER (15)
AUDIT_INFORMATION_CATEGORY VARCHAR2 (30)
AUDIT_INFORMATION1 VARCHAR2 (150)
AUDIT_INFORMATION2 VARCHAR2 (150)
AUDIT_INFORMATION3 VARCHAR2 (150)
AUDIT_INFORMATION4 VARCHAR2 (150)
AUDIT_INFORMATION5 VARCHAR2 (150)
AUDIT_INFORMATION6 VARCHAR2 (150)
AUDIT_INFORMATION7 VARCHAR2 (150)
AUDIT_INFORMATION8 VARCHAR2 (150)
AUDIT_INFORMATION9 VARCHAR2 (150)
AUDIT_INFORMATION10 VARCHAR2 (150)
AUDIT_INFORMATION11 VARCHAR2 (150)
AUDIT_INFORMATION12 VARCHAR2 (150)
AUDIT_INFORMATION13 VARCHAR2 (150)
AUDIT_INFORMATION14 VARCHAR2 (150)
AUDIT_INFORMATION15 VARCHAR2 (150)
AUDIT_INFORMATION16 VARCHAR2 (150)
AUDIT_INFORMATION17 VARCHAR2 (150)
AUDIT_INFORMATION18 VARCHAR2 (150)
AUDIT_INFORMATION19 VARCHAR2 (150)
AUDIT_INFORMATION20 VARCHAR2 (150)
AUDIT_INFORMATION21 VARCHAR2 (150)
AUDIT_INFORMATION22 VARCHAR2 (150)
AUDIT_INFORMATION23 VARCHAR2 (150)
AUDIT_INFORMATION24 VARCHAR2 (150)
AUDIT_INFORMATION25 VARCHAR2 (150)
AUDIT_INFORMATION26 VARCHAR2 (150)
AUDIT_INFORMATION27 VARCHAR2 (150)
AUDIT_INFORMATION28 VARCHAR2 (150)
AUDIT_INFORMATION29 VARCHAR2 (150)
AUDIT_INFORMATION30 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

TITLE VARCHAR2 (30)
OBJECT_VERSION_NUMBER NUMBER (9)
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# references the following:

SchemaHR
TablePAY_STAT_TRANS_AUDIT
HR.PAY_STAT_TRANS_AUDIT# is referenced by following:

SchemaAPPS
SynonymPAY_STAT_TRANS_AUDIT
TriggerPAY_STAT_TRANS_AUDIT_WHO