[Home] [Help] [Dependency Information]
Object Name: | PER_CAGR_ENTITLEMENT_ITEMS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAGR_ENTITLEMENT_ITEM_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | ||
ITEM_NAME | VARCHAR2 | (80) | Yes | |
ELEMENT_TYPE_ID | NUMBER | (15) | ||
INPUT_VALUE_ID | VARCHAR2 | (15) | ||
COLUMN_TYPE | VARCHAR2 | (30) | Yes | |
COLUMN_SIZE | NUMBER | (15) | Yes | |
LEGISLATION_CODE | VARCHAR2 | (30) | ||
BENEFICIAL_RULE | VARCHAR2 | (30) | ||
CAGR_API_ID | NUMBER | (10) | ||
CAGR_API_PARAM_ID | NUMBER | (10) | ||
CATEGORY_NAME | VARCHAR2 | (30) | Yes | |
UOM | VARCHAR2 | (30) | ||
BENEFICIAL_FORMULA_ID | NUMBER | (15) | ||
FLEX_VALUE_SET_ID | NUMBER | (10) | ||
BENEFICIAL_RULE_VALUE_SET_ID | NUMBER | (10) | ||
MULTIPLE_ENTRIES_ALLOWED_FLAG | VARCHAR2 | (30) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
OPT_ID | NUMBER | (15) | ||
AUTO_CREATE_ENTRIES_FLAG | VARCHAR2 | (30) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT CAGR_ENTITLEMENT_ITEM_ID
, BUSINESS_GROUP_ID
, ITEM_NAME
, ELEMENT_TYPE_ID
, INPUT_VALUE_ID
, COLUMN_TYPE
, COLUMN_SIZE
, LEGISLATION_CODE
, BENEFICIAL_RULE
, CAGR_API_ID
, CAGR_API_PARAM_ID
, CATEGORY_NAME
, UOM
, BENEFICIAL_FORMULA_ID
, FLEX_VALUE_SET_ID
, BENEFICIAL_RULE_VALUE_SET_ID
, MULTIPLE_ENTRIES_ALLOWED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, OPT_ID
, AUTO_CREATE_ENTRIES_FLAG
, ZD_EDITION_NAME
FROM HR.PER_CAGR_ENTITLEMENT_ITEMS#;
|
|
|