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


VIEW: HR.PAY_ELEMENT_ENTRIES_F#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ELEMENT_ENTRY_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
ASSIGNMENT_ID NUMBER (10) Yes
UPDATING_ACTION_ID NUMBER (15)
ELEMENT_LINK_ID NUMBER (9) Yes
ORIGINAL_ENTRY_ID NUMBER (15)
CREATOR_TYPE VARCHAR2 (30) Yes
ENTRY_TYPE VARCHAR2 (30) Yes
COMMENT_ID NUMBER (15)
CREATOR_ID NUMBER (15)
REASON VARCHAR2 (30)
TARGET_ENTRY_ID NUMBER (15)
SOURCE_ID NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ENTRY_INFORMATION_CATEGORY VARCHAR2 (30)
ENTRY_INFORMATION1 VARCHAR2 (150)
ENTRY_INFORMATION2 VARCHAR2 (150)
ENTRY_INFORMATION3 VARCHAR2 (150)
ENTRY_INFORMATION4 VARCHAR2 (150)
ENTRY_INFORMATION5 VARCHAR2 (150)
ENTRY_INFORMATION6 VARCHAR2 (150)
ENTRY_INFORMATION7 VARCHAR2 (150)
ENTRY_INFORMATION8 VARCHAR2 (150)
ENTRY_INFORMATION9 VARCHAR2 (150)
ENTRY_INFORMATION10 VARCHAR2 (150)
ENTRY_INFORMATION11 VARCHAR2 (150)
ENTRY_INFORMATION12 VARCHAR2 (150)
ENTRY_INFORMATION13 VARCHAR2 (150)
ENTRY_INFORMATION14 VARCHAR2 (150)
ENTRY_INFORMATION15 VARCHAR2 (150)
ENTRY_INFORMATION16 VARCHAR2 (150)
ENTRY_INFORMATION17 VARCHAR2 (150)
ENTRY_INFORMATION18 VARCHAR2 (150)
ENTRY_INFORMATION19 VARCHAR2 (150)
ENTRY_INFORMATION20 VARCHAR2 (150)
ENTRY_INFORMATION21 VARCHAR2 (150)
ENTRY_INFORMATION22 VARCHAR2 (150)
ENTRY_INFORMATION23 VARCHAR2 (150)
ENTRY_INFORMATION24 VARCHAR2 (150)
ENTRY_INFORMATION25 VARCHAR2 (150)
ENTRY_INFORMATION26 VARCHAR2 (150)
ENTRY_INFORMATION27 VARCHAR2 (150)
ENTRY_INFORMATION28 VARCHAR2 (150)
ENTRY_INFORMATION29 VARCHAR2 (150)
ENTRY_INFORMATION30 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

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

SUBPRIORITY NUMBER (9)
PERSONAL_PAYMENT_METHOD_ID NUMBER (9)
DATE_EARNED DATE

OBJECT_VERSION_NUMBER NUMBER (9)
BALANCE_ADJ_COST_FLAG VARCHAR2 (30)
SOURCE_ASG_ACTION_ID NUMBER (15)
SOURCE_LINK_ID NUMBER (9)
SOURCE_TRIGGER_ENTRY NUMBER (15)
SOURCE_PERIOD NUMBER (15)
SOURCE_RUN_TYPE NUMBER (9)
UPDATING_ACTION_TYPE VARCHAR2 (30)
SOURCE_START_DATE DATE

SOURCE_END_DATE DATE

ELEMENT_TYPE_ID NUMBER (9)
ALL_ENTRY_VALUES_NULL VARCHAR2 (30)
LABEL_IDENTIFIER VARCHAR2 (30)
PREV_UPD_ACTION_ID NUMBER (15)
Query Text

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


SELECT ELEMENT_ENTRY_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      COST_ALLOCATION_KEYFLEX_ID
,      ASSIGNMENT_ID
,      UPDATING_ACTION_ID
,      ELEMENT_LINK_ID
,      ORIGINAL_ENTRY_ID
,      CREATOR_TYPE
,      ENTRY_TYPE
,      COMMENT_ID
,      CREATOR_ID
,      REASON
,      TARGET_ENTRY_ID
,      SOURCE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ENTRY_INFORMATION_CATEGORY
,      ENTRY_INFORMATION1
,      ENTRY_INFORMATION2
,      ENTRY_INFORMATION3
,      ENTRY_INFORMATION4
,      ENTRY_INFORMATION5
,      ENTRY_INFORMATION6
,      ENTRY_INFORMATION7
,      ENTRY_INFORMATION8
,      ENTRY_INFORMATION9
,      ENTRY_INFORMATION10
,      ENTRY_INFORMATION11
,      ENTRY_INFORMATION12
,      ENTRY_INFORMATION13
,      ENTRY_INFORMATION14
,      ENTRY_INFORMATION15
,      ENTRY_INFORMATION16
,      ENTRY_INFORMATION17
,      ENTRY_INFORMATION18
,      ENTRY_INFORMATION19
,      ENTRY_INFORMATION20
,      ENTRY_INFORMATION21
,      ENTRY_INFORMATION22
,      ENTRY_INFORMATION23
,      ENTRY_INFORMATION24
,      ENTRY_INFORMATION25
,      ENTRY_INFORMATION26
,      ENTRY_INFORMATION27
,      ENTRY_INFORMATION28
,      ENTRY_INFORMATION29
,      ENTRY_INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SUBPRIORITY
,      PERSONAL_PAYMENT_METHOD_ID
,      DATE_EARNED
,      OBJECT_VERSION_NUMBER
,      BALANCE_ADJ_COST_FLAG
,      SOURCE_ASG_ACTION_ID
,      SOURCE_LINK_ID
,      SOURCE_TRIGGER_ENTRY
,      SOURCE_PERIOD
,      SOURCE_RUN_TYPE
,      UPDATING_ACTION_TYPE
,      SOURCE_START_DATE
,      SOURCE_END_DATE
,      ELEMENT_TYPE_ID
,      ALL_ENTRY_VALUES_NULL
,      LABEL_IDENTIFIER
,      PREV_UPD_ACTION_ID
FROM HR.PAY_ELEMENT_ENTRIES_F#;

Dependencies

[top of page]

HR.PAY_ELEMENT_ENTRIES_F# references the following:

SchemaHR
TablePAY_ELEMENT_ENTRIES_F
HR.PAY_ELEMENT_ENTRIES_F# is referenced by following:

SchemaAPPS
TriggerGHR_PAY_ELEMENT_ENTRS_AFIUD
TriggerHR_PAY_IF_ELE_ENT_ASD
TriggerHR_PAY_IF_ELE_ENT_BRD
SynonymPAY_ELEMENT_ENTRIES_F
TriggerPAY_ELEMENT_ENTRIES_F_OVN
TriggerPAY_ELEMENT_ENTRIES_F_WHO