[Home] [Help] [Dependency Information]
Object Name: | HR_ATH_DEPENDENT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HR_ATH_DEPENDENT_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_employees_v | |
PLAN_ID | VARCHAR2 | (81) | plan identifier in Authoria | |
NAME | VARCHAR2 | (40) | person_id of dependent | |
FULL_NAME | VARCHAR2 | (240) | full name of dependent | |
START_DATE | DATE | start date for this dependent | ||
END_DATE | DATE | end date for this dependent | ||
DATE_OF_BIRTH | VARCHAR2 | (10) | Date of Birth | |
NATIONAL_IDENTIFIER | VARCHAR2 | (30) | National Identifier | |
CVG_STRT_DT | VARCHAR2 | (10) | Coverage start date | |
CVG_THRU_DT | VARCHAR2 | (11) | Coverage thru date | |
RELATIONSHIPS | VARCHAR2 | (4000) | person_id for the dependent |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_ID
, PLAN_ID
, NAME
, FULL_NAME
, START_DATE
, END_DATE
, DATE_OF_BIRTH
, NATIONAL_IDENTIFIER
, CVG_STRT_DT
, CVG_THRU_DT
, RELATIONSHIPS
FROM APPS.HR_ATH_DEPENDENT_V;
|
|
|