[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PQP_OMP_TEMPLATE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PQP.PQP_OMP_TEMPLATE_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ELEMENT_TYPE_ID | NUMBER | (9) | Yes | Primary key of absence information element |
| BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ALL_ORGANIZATION_UNITS | |
| LEGISLATION_CODE | VARCHAR2 | (30) | Legislation code | |
| CLASSIFICATION_ID | NUMBER | (9) | Yes | Foreign key to HR_ORG_CLASSIFICATIONS |
| CLASSIFICATION_NAME | VARCHAR2 | (80) | Yes | Classification of absence information element |
| PROCESSING_TYPE | VARCHAR2 | (30) | Yes | Processing type of the absence information element |
| BASE_NAME | VARCHAR2 | (50) | Base element name | |
| ELEMENT_NAME | VARCHAR2 | (80) | Yes | Element name |
| REPORTING_NAME | VARCHAR2 | (80) | Reporting name of the element | |
| DESCRIPTION | VARCHAR2 | (240) | Description of absence information element | |
| PROCESSING_PRIORITY | NUMBER | (9) | Yes | Processing priority of the element |
| EFFECTIVE_START_DATE | DATE | Yes | Effective start date of the element | |
| EFFECTIVE_END_DATE | DATE | Yes | Effective end date of the element | |
| PLAN_ID | VARCHAR2 | (150) | Benefits plan id | |
| PLAN_NAME | VARCHAR2 | (240) | Yes | Benefits plan name |
| PLAN_DESCRIPTION | VARCHAR2 | (150) | Benefits plan description | |
| LOS_CALC | VARCHAR2 | (150) | OMP qualifying date | |
| LOS_DURATION | VARCHAR2 | (150) | OMP qualifying date duration | |
| LOS_UOM | VARCHAR2 | (150) | OMP qualifying date Unit of measure | |
| AVGEARN_DURATION | VARCHAR2 | (150) | Average earnings calculation duration | |
| AVGEARN_UOM | VARCHAR2 | (150) | Average earnings calculation unit of measure | |
| AVGEARN_BALNAME | VARCHAR2 | (150) | Average earnings calculation balance name | |
| ABS_DAYS | VARCHAR2 | (150) | Absence Entitlement Type | |
| ABS_ENT_MATLEAVES_UDT_ID | VARCHAR2 | (150) | Absence entitlement parameters user defined table id | |
| ABS_ENT_MATERNITY_LEAVES | VARCHAR2 | (80) | Absence entitlement parameters user defined table name | |
| ABS_ENT_HOLIDAYS_UDT_ID | VARCHAR2 | (150) | Absence entitlement calendar user defined table id | |
| ABS_ENT_HOLIDAYS | VARCHAR2 | (80) | Absence entitlement calendar user defined table name | |
| ABS_DAILYRATE_CALC | VARCHAR2 | (150) | Absence daily rate divisor | |
| ABS_DAILYRATE_CALC_PERIOD | VARCHAR2 | (150) | Absence daily rate divisor type | |
| ABS_DAILYRATE_CALC_DURATION | VARCHAR2 | (150) | Absence daily rate divisor duration | |
| ABS_PAY_INFO_SRC_COMP | VARCHAR2 | (150) | Pay Component Rate Type | |
| ABS_PAY_INFO_SRC_COMP_NAME | VARCHAR2 | (80) | Pay Component Rate Type Name | |
| PRIMARY_ABS_INFO_ELE_FLAG | VARCHAR2 | (150) | Primary absence information element flag | |
| ABS_DEFAULT_WORKPATTERN | VARCHAR2 | (150) | Default work pattern name | |
| ELEMENT_TYPE | VARCHAR2 | (150) | Element type | |
| ABS_TYPES_LIST_NAME | VARCHAR2 | (150) | Absence types list name | |
| LAST_UPDATE_DATE | DATE | Standard WHO column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard WHO column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
| CREATED_BY | NUMBER | (15) | Standard WHO column | |
| CREATION_DATE | DATE | Standard WHO column | ||
| ABSENCE_CATEGORY | VARCHAR2 | (150) | Stores Absence Category i.e. Maternity |
Cut, paste (and edit) the following text to query this object:
SELECT ELEMENT_TYPE_ID
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, CLASSIFICATION_ID
, CLASSIFICATION_NAME
, PROCESSING_TYPE
, BASE_NAME
, ELEMENT_NAME
, REPORTING_NAME
, DESCRIPTION
, PROCESSING_PRIORITY
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, PLAN_ID
, PLAN_NAME
, PLAN_DESCRIPTION
, LOS_CALC
, LOS_DURATION
, LOS_UOM
, AVGEARN_DURATION
, AVGEARN_UOM
, AVGEARN_BALNAME
, ABS_DAYS
, ABS_ENT_MATLEAVES_UDT_ID
, ABS_ENT_MATERNITY_LEAVES
, ABS_ENT_HOLIDAYS_UDT_ID
, ABS_ENT_HOLIDAYS
, ABS_DAILYRATE_CALC
, ABS_DAILYRATE_CALC_PERIOD
, ABS_DAILYRATE_CALC_DURATION
, ABS_PAY_INFO_SRC_COMP
, ABS_PAY_INFO_SRC_COMP_NAME
, PRIMARY_ABS_INFO_ELE_FLAG
, ABS_DEFAULT_WORKPATTERN
, ELEMENT_TYPE
, ABS_TYPES_LIST_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, ABSENCE_CATEGORY
FROM APPS.PQP_OMP_TEMPLATE_V;
APPS
BEN_PL_F
BEN_PL_TYP_F
FND_NUMBER
- show dependent code
FND_SESSIONS
HR_API
- show dependent code
HR_LOOKUPS
PAY_ELEMENT_CLASSIFICATIONS
PAY_ELEMENT_TEMPLATES
PAY_ELEMENT_TYPES_F
PAY_ELEMENT_TYPE_EXTRA_INFO
PAY_TEMPLATE_CORE_OBJECTS
PAY_USER_TABLES
APPS.PQP_OMP_TEMPLATE_V is not referenced by any database object
|
|
|
|