[Home] [Help] [Dependency Information]
Object Name: | HR_ATH_ENROLL_ALL_PLANS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HR_ATH_ENROLL_ALL_PLANS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View to support Authoria Integration
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMPLOYEE_ID | VARCHAR2 | (40) | fk to hr_ath_employee_v | |
PLAN_ID | VARCHAR2 | (81) | plan identifier in Authoria | |
START_DATE | DATE | Yes | start date for this plan | |
END_DATE | DATE | end date for this plan | ||
COVERAGE_TIER | VARCHAR2 | (4000) | coverage tier | |
COVERAGE_AMOUNT | VARCHAR2 | (40) | coverage amount | |
COVERAGE_COST_EEIC | VARCHAR2 | (4000) | coverage cost eeic | |
COVERAGE_COST_EEPYC | VARCHAR2 | (4000) | coverage cost eepyc | |
ER_CONTRIBUTION_ERPYC | VARCHAR2 | (4000) | er contribution erpyc | |
PRIMARY_BENEFICIARIES | VARCHAR2 | (4000) | primary beneficiaries | |
CONTINGENT_BENEFICIARIES | VARCHAR2 | (4000) | contingent beneficiaries | |
PRIMARY_CARE_PROVIDERS | VARCHAR2 | (4000) | primary care providers | |
ENRT_CVG_STRT_DT | VARCHAR2 | (10) | enrollment coverage start date | |
ENRT_CVG_THRU_DT | VARCHAR2 | (11) | enrollment coverage thru date |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_ID
, PLAN_ID
, START_DATE
, END_DATE
, COVERAGE_TIER
, COVERAGE_AMOUNT
, COVERAGE_COST_EEIC
, COVERAGE_COST_EEPYC
, ER_CONTRIBUTION_ERPYC
, PRIMARY_BENEFICIARIES
, CONTINGENT_BENEFICIARIES
, PRIMARY_CARE_PROVIDERS
, ENRT_CVG_STRT_DT
, ENRT_CVG_THRU_DT
FROM APPS.HR_ATH_ENROLL_ALL_PLANS_V;
APPS.HR_ATH_ENROLL_ALL_PLANS_V is not referenced by any database object
|
|
|