[Home] [Help] [Dependency Information]
Object Name: | PAY_SHADOW_ELEMENT_TYPES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_SHADOW_ELEMENT_TYPES |
Subobject Name: | |
Status: | VALID |
Models PAY_ELEMENT_TYPES_F in the element template shadow schema.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_SHADOW_ELEMENT_TYPES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ELEMENT_TYPE_ID |
PAY_SHADOW_ELEMENT_TYPES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYROLL_FORMULA_ID |
PAY_SHADOW_ELEMENT_TYPES_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TEMPLATE_ID |
PAY_SHADOW_ELEMENT_TYPES_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXCLUSION_RULE_ID |
Table | |
Foreign Table | Foreign Key Column | PAY_SHADOW_ELEMENT_TYPES | PAY_ELEMENT_TEMPLATES | PAY_SHADOW_ELEMENT_TYPES TEMPLATE_ID | PAY_SHADOW_ELEMENT_TYPES | PAY_SHADOW_FORMULAS | PAY_SHADOW_ELEMENT_TYPES PAYROLL_FORMULA_ID | PAY_SHADOW_ELEMENT_TYPES | PAY_TEMPLATE_EXCLUSION_RULES | PAY_SHADOW_ELEMENT_TYPES EXCLUSION_RULE_ID | PAY_SHADOW_ELE_TYPE_USAGES | PAY_SHADOW_ELEMENT_TYPES | PAY_SHADOW_ELE_TYPE_USAGES ELEMENT_TYPE_ID | PAY_SHADOW_FORMULA_RULES | PAY_SHADOW_ELEMENT_TYPES | PAY_SHADOW_FORMULA_RULES SHADOW_ELEMENT_TYPE_ID | PAY_SHADOW_FORMULA_RULES | PAY_SHADOW_ELEMENT_TYPES | PAY_SHADOW_FORMULA_RULES ELEMENT_TYPE_ID | PAY_SHADOW_GU_BAL_EXCLUSIONS | PAY_SHADOW_ELEMENT_TYPES | PAY_SHADOW_GU_BAL_EXCLUSIONS SOURCE_ID | PAY_SHADOW_INPUT_VALUES | PAY_SHADOW_ELEMENT_TYPES | PAY_SHADOW_INPUT_VALUES ELEMENT_TYPE_ID | PAY_SHADOW_ITERATIVE_RULES | PAY_SHADOW_ELEMENT_TYPES | PAY_SHADOW_ITERATIVE_RULES ELEMENT_TYPE_ID | PAY_SHADOW_SUB_CLASSI_RULES | PAY_SHADOW_ELEMENT_TYPES | PAY_SHADOW_SUB_CLASSI_RULES ELEMENT_TYPE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (9) | Yes | Foreign key to PAY_ELEMENT_TEMPLATES. |
ELEMENT_TYPE_ID | NUMBER | (9) | Yes | System-generated primary key column. |
CLASSIFICATION_NAME | VARCHAR2 | (80) | Yes | Element classification name. Note: the name is used rather than t |
EXCLUSION_RULE_ID | NUMBER | (9) | Foreign key to PAY_TEMPLATE_EXCLUSION_RULES. | |
ADDITIONAL_ENTRY_ALLOWED_FLAG | VARCHAR2 | (30) | Yes | Indicates whether a recurring element can also have an additional nonrecurring entry of this type in any payroll period. |
PAYROLL_FORMULA_ID | NUMBER | (9) | Foreign key to PAY_SHADOW_FORMULAS. | |
ADJUSTMENT_ONLY_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the element is used only for adjusting balances |
CLOSED_FOR_ENTRY_FLAG | VARCHAR2 | (30) | Yes | Indicates whether entries can be currently entered or updated. |
ELEMENT_NAME | VARCHAR2 | (80) | User name for the element type. | |
INDIRECT_ONLY_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the element can be given to an assignment only as an indirect result from a formula. |
MULTIPLE_ENTRIES_ALLOWED_FLAG | VARCHAR2 | (30) | Yes | Indicates whether an assignment can have multiple normal entries for this element at any one time. |
MULTIPLY_VALUE_FLAG | VARCHAR2 | (30) | Yes | Indicates whether entries can be multiplied, for example, holiday |
POST_TERMINATION_RULE | VARCHAR2 | (30) | Yes | Rule for element processing when a person is terminated. |
PROCESS_IN_RUN_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the element can be processed in a payroll run. |
RELATIVE_PROCESSING_PRIORITY | NUMBER | (9) | Yes | Processing priority relative to the processing priority on the te |
PROCESSING_TYPE | VARCHAR2 | (30) | Indicates whether the element is recurring or nonrecurring. | |
STANDARD_LINK_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the default element link type is standard (Y) o |
INPUT_CURRENCY_CODE | VARCHAR2 | (15) | Foreign key to FND_CURRENCIES. | |
OUTPUT_CURRENCY_CODE | VARCHAR2 | (15) | Foreign key to FND_CURRENCIES. | |
BENEFIT_CLASSIFICATION_NAME | VARCHAR2 | (80) | Benefit classification name. Note: the name is used rather than t | |
DESCRIPTION | VARCHAR2 | (240) | Brief description of the element type. | |
QUALIFYING_AGE | NUMBER | (2) | Age at which a person qualifies for this element. | |
QUALIFYING_LENGTH_OF_SERVICE | NUMBER | (6) | Length of service required for the person to qualify for this ele | |
QUALIFYING_UNITS | VARCHAR2 | (30) | Units of measurement for qualifying length of service. | |
REPORTING_NAME | VARCHAR2 | (80) | Short name for the element, used in reports. | |
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) | Descriptive flexfield column. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ELEMENT_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
ELEMENT_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
THIRD_PARTY_PAY_ONLY_FLAG | VARCHAR2 | (30) | Indicates whether the element is paid by third party payments onl | |
SKIP_FORMULA | VARCHAR2 | (80) | Name of element skip formula for thiis element type. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object version number column. | |
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. | ||
ITERATIVE_FLAG | VARCHAR2 | (30) | Indicates wether the element can be adjusted by iterative rules | |
ITERATIVE_PRIORITY | NUMBER | (9) | The order of the iterative adjustment processing for iterative elements | |
ITERATIVE_FORMULA_NAME | VARCHAR2 | (80) | Name of the seeded iterative formula to be used | |
PROCESS_MODE | VARCHAR2 | (30) | Denotes the type of processing which may be applied to this element e.g. separate check,separate payment or process separately. | |
GROSSUP_FLAG | VARCHAR2 | (30) | Indicates if this element can be processed in a Net to Gross calculation. | |
ADVANCE_INDICATOR | VARCHAR2 | (30) | Advance indicator for element type. | |
ADVANCE_PAYABLE | VARCHAR2 | (30) | Advance payable flag. | |
ADVANCE_DEDUCTION | VARCHAR2 | (30) | Advance deduction flag. | |
PROCESS_ADVANCE_ENTRY | VARCHAR2 | (30) | Process advance entry flag. | |
PRORATION_GROUP | VARCHAR2 | (80) | Name of the seeded proration group to be used. | |
PRORATION_FORMULA | VARCHAR2 | (80) | Name of the seeded proration formula to be used. | |
RECALC_EVENT_GROUP | VARCHAR2 | (80) | Name of the seeded recalculation event group to be used. | |
ONCE_EACH_PERIOD_FLAG | VARCHAR2 | (30) | Indicates whether or not the element should only be |
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
FROM HR.PAY_SHADOW_ELEMENT_TYPES;
HR.PAY_SHADOW_ELEMENT_TYPES does not reference any database object
HR.PAY_SHADOW_ELEMENT_TYPES is referenced by following:
|
|
|