Skip to content

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

VIEW: HR.PAY_SHADOW_ELEMENT_TYPES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER (9) Yes
ELEMENT_TYPE_ID NUMBER (9) Yes
CLASSIFICATION_NAME VARCHAR2 (80) Yes
EXCLUSION_RULE_ID NUMBER (9)
ADDITIONAL_ENTRY_ALLOWED_FLAG VARCHAR2 (30) Yes
PAYROLL_FORMULA_ID NUMBER (9)
ADJUSTMENT_ONLY_FLAG VARCHAR2 (30) Yes
CLOSED_FOR_ENTRY_FLAG VARCHAR2 (30) Yes
ELEMENT_NAME VARCHAR2 (80)
INDIRECT_ONLY_FLAG VARCHAR2 (30) Yes
MULTIPLE_ENTRIES_ALLOWED_FLAG VARCHAR2 (30) Yes
MULTIPLY_VALUE_FLAG VARCHAR2 (30) Yes
POST_TERMINATION_RULE VARCHAR2 (30) Yes
PROCESS_IN_RUN_FLAG VARCHAR2 (30) Yes
RELATIVE_PROCESSING_PRIORITY NUMBER (9) Yes
PROCESSING_TYPE VARCHAR2 (30)
INPUT_CURRENCY_CODE VARCHAR2 (15)
OUTPUT_CURRENCY_CODE VARCHAR2 (15)
BENEFIT_CLASSIFICATION_NAME VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
QUALIFYING_AGE NUMBER (2)
QUALIFYING_LENGTH_OF_SERVICE NUMBER (6)
QUALIFYING_UNITS VARCHAR2 (30)
REPORTING_NAME VARCHAR2 (80)
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)
ELEMENT_INFORMATION_CATEGORY VARCHAR2 (30)
ELEMENT_INFORMATION1 VARCHAR2 (150)
ELEMENT_INFORMATION2 VARCHAR2 (150)
ELEMENT_INFORMATION3 VARCHAR2 (150)
ELEMENT_INFORMATION4 VARCHAR2 (150)
ELEMENT_INFORMATION5 VARCHAR2 (150)
ELEMENT_INFORMATION6 VARCHAR2 (150)
ELEMENT_INFORMATION7 VARCHAR2 (150)
ELEMENT_INFORMATION8 VARCHAR2 (150)
ELEMENT_INFORMATION9 VARCHAR2 (150)
ELEMENT_INFORMATION10 VARCHAR2 (150)
ELEMENT_INFORMATION11 VARCHAR2 (150)
ELEMENT_INFORMATION12 VARCHAR2 (150)
ELEMENT_INFORMATION13 VARCHAR2 (150)
ELEMENT_INFORMATION14 VARCHAR2 (150)
ELEMENT_INFORMATION15 VARCHAR2 (150)
ELEMENT_INFORMATION16 VARCHAR2 (150)
ELEMENT_INFORMATION17 VARCHAR2 (150)
ELEMENT_INFORMATION18 VARCHAR2 (150)
ELEMENT_INFORMATION19 VARCHAR2 (150)
ELEMENT_INFORMATION20 VARCHAR2 (150)
THIRD_PARTY_PAY_ONLY_FLAG VARCHAR2 (30)
SKIP_FORMULA VARCHAR2 (80)
OBJECT_VERSION_NUMBER NUMBER (9)
LAST_UPDATE_DATE DATE

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

ITERATIVE_FLAG VARCHAR2 (30)
ITERATIVE_PRIORITY NUMBER (9)
ITERATIVE_FORMULA_NAME VARCHAR2 (80)
PROCESS_MODE VARCHAR2 (30)
GROSSUP_FLAG VARCHAR2 (30)
ADVANCE_INDICATOR VARCHAR2 (30)
ADVANCE_PAYABLE VARCHAR2 (30)
ADVANCE_DEDUCTION VARCHAR2 (30)
PROCESS_ADVANCE_ENTRY VARCHAR2 (30)
PRORATION_GROUP VARCHAR2 (80)
PRORATION_FORMULA VARCHAR2 (80)
RECALC_EVENT_GROUP VARCHAR2 (80)
ONCE_EACH_PERIOD_FLAG VARCHAR2 (30)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT TEMPLATE_ID
,      ELEMENT_TYPE_ID
,      CLASSIFICATION_NAME
,      EXCLUSION_RULE_ID
,      ADDITIONAL_ENTRY_ALLOWED_FLAG
,      PAYROLL_FORMULA_ID
,      ADJUSTMENT_ONLY_FLAG
,      CLOSED_FOR_ENTRY_FLAG
,      ELEMENT_NAME
,      INDIRECT_ONLY_FLAG
,      MULTIPLE_ENTRIES_ALLOWED_FLAG
,      MULTIPLY_VALUE_FLAG
,      POST_TERMINATION_RULE
,      PROCESS_IN_RUN_FLAG
,      RELATIVE_PROCESSING_PRIORITY
,      PROCESSING_TYPE
,      STANDARD_LINK_FLAG
,      INPUT_CURRENCY_CODE
,      OUTPUT_CURRENCY_CODE
,      BENEFIT_CLASSIFICATION_NAME
,      DESCRIPTION
,      QUALIFYING_AGE
,      QUALIFYING_LENGTH_OF_SERVICE
,      QUALIFYING_UNITS
,      REPORTING_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ELEMENT_INFORMATION_CATEGORY
,      ELEMENT_INFORMATION1
,      ELEMENT_INFORMATION2
,      ELEMENT_INFORMATION3
,      ELEMENT_INFORMATION4
,      ELEMENT_INFORMATION5
,      ELEMENT_INFORMATION6
,      ELEMENT_INFORMATION7
,      ELEMENT_INFORMATION8
,      ELEMENT_INFORMATION9
,      ELEMENT_INFORMATION10
,      ELEMENT_INFORMATION11
,      ELEMENT_INFORMATION12
,      ELEMENT_INFORMATION13
,      ELEMENT_INFORMATION14
,      ELEMENT_INFORMATION15
,      ELEMENT_INFORMATION16
,      ELEMENT_INFORMATION17
,      ELEMENT_INFORMATION18
,      ELEMENT_INFORMATION19
,      ELEMENT_INFORMATION20
,      THIRD_PARTY_PAY_ONLY_FLAG
,      SKIP_FORMULA
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ITERATIVE_FLAG
,      ITERATIVE_PRIORITY
,      ITERATIVE_FORMULA_NAME
,      PROCESS_MODE
,      GROSSUP_FLAG
,      ADVANCE_INDICATOR
,      ADVANCE_PAYABLE
,      ADVANCE_DEDUCTION
,      PROCESS_ADVANCE_ENTRY
,      PRORATION_GROUP
,      PRORATION_FORMULA
,      RECALC_EVENT_GROUP
,      ONCE_EACH_PERIOD_FLAG
,      ZD_EDITION_NAME
FROM HR.PAY_SHADOW_ELEMENT_TYPES#;

Dependencies

[top of page]

HR.PAY_SHADOW_ELEMENT_TYPES# references the following:

SchemaHR
TablePAY_SHADOW_ELEMENT_TYPES
HR.PAY_SHADOW_ELEMENT_TYPES# is referenced by following:

SchemaAPPS
SynonymPAY_SHADOW_ELEMENT_TYPES
TriggerPAY_SHADOW_ELEMENT_TYPES+
TriggerPAY_SHADOW_ELEMENT_TYPES_WHO