[Home] [Help] [Dependency Information]
Object Name: | HRFV_DEF_BENEFIT_CONTRIBUTIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HRFV_DEF_BENEFIT_CONTRIBUTIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows the history of default contribution levels for healthcare benefits.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
BENEFIT_NAME | VARCHAR2 | (80) | Yes | |
BENEFIT_CLASSIFICATION_NAME | VARCHAR2 | (80) | Yes | |
DESCRIPTION | VARCHAR2 | (240) | ||
EFFECTIVE_START_DATE | DATE | Yes | ||
EFFECTIVE_END_DATE | DATE | |||
COVERAGE_TYPE | VARCHAR2 | (4000) | ||
EMPLOYEE_CONTRIBUTION | NUMBER | |||
EMPLOYER_CONTRIBUTION | NUMBER | |||
TOTAL_CONTRIBUTION | NUMBER | |||
COBRA_ELIGIBLE | VARCHAR2 | (4000) | ||
DEPENDENTS_COVERED_FLAG | VARCHAR2 | (4000) | ||
BENEFIT_CONTRIBUTION_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ELEMENT_TYPE_ID | NUMBER | (9) | Yes | |
FORMULA_ID | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, BENEFIT_NAME
, BENEFIT_CLASSIFICATION_NAME
, DESCRIPTION
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, COVERAGE_TYPE
, EMPLOYEE_CONTRIBUTION
, EMPLOYER_CONTRIBUTION
, TOTAL_CONTRIBUTION
, COBRA_ELIGIBLE
, DEPENDENTS_COVERED_FLAG
, BENEFIT_CONTRIBUTION_ID
, BUSINESS_GROUP_ID
, ELEMENT_TYPE_ID
, FORMULA_ID
FROM APPS.HRFV_DEF_BENEFIT_CONTRIBUTIONS;
APPS.HRFV_DEF_BENEFIT_CONTRIBUTIONS is not referenced by any database object
|
|
|