DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_ATH_ENROLL_ALL_PLANS_V

Object Details
Object Name: HR_ATH_ENROLL_ALL_PLANS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_ATH_ENROLL_ALL_PLANS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View to support Authoria Integration


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.HR_ATH_ENROLL_ALL_PLANS_V references the following:

SchemaAPPS
SynonymBEN_OIPL_F
SynonymBEN_OPT_F
SynonymBEN_PLIP_F
SynonymBEN_PRTT_ENRT_RSLT_F
PL/SQL PackageFND_MESSAGE - show dependent code
PL/SQL PackageHR_AUTH_BRIDGE - show dependent code
APPS.HR_ATH_ENROLL_ALL_PLANS_V is referenced by following:

SchemaPUBLIC
SynonymHR_ATH_ENROLL_ALL_PLANS_V