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

VIEW: APPS.HR_ADP_OAB_BENEFIT_V

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

View Type

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


This view returns information about standard/advanced benefits enrollments.
If you have implemented basic benefits, use the HR_ADP_BENEFIT_V to return information about medical, dental and vision benefits.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_CODE_EQUIVALENT VARCHAR2 (60)
ADP company code
GRE_NAME VARCHAR2 (240) Yes GRE name
GRE_ID VARCHAR2 (60)
GRE ID
ORGANIZATION_ID NUMBER (15) Yes Organization ID for employee's HR organization
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number
PERSON_ID NUMBER (10) Yes Person ID
BUSINESS_GROUP_ID NUMBER (15) Yes Business group ID
ASSIGNMENT_ID NUMBER (10) Yes Assignment ID
ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment number
ASSIGNMENT_SEQUENCE NUMBER

Assignment sequence
PRIMARY_FLAG VARCHAR2 (30) Yes Indicates primary employee assignment. Y/N.
PAY_FREQUENCY VARCHAR2 (40)
Payroll frequency
PROGRAM VARCHAR2 (240)
Benefit program name
BENEFIT_NAME VARCHAR2 (240) Yes Benefit plan name
BENEFIT_PLAN_TYPE VARCHAR2 (240) Yes Benefit plan type
EMPLOYEE_CONTRIBUTION VARCHAR2 (60)
The amount the employee contributes
EMPLOYER_CONTRIBUTION VARCHAR2 (0)
The amount the employer contributes
EE_CONTRIBUTION_LIMIT NUMBER

Employee contribution limit
ER_CONTRIBUTION_LIMIT VARCHAR2 (0)
Employer contribution limit
COVERAGE_TYPE VARCHAR2 (4000)
Benefit plan option. For example, Employee Only, Employee plus Spouse.
COVERAGE_START_DATE DATE
Yes Date on which benefit contributions start
COVERAGE_END_DATE DATE

Date on which benefit contributions end
PER_LAST_UPDATE_DATE DATE

Date on which person information was last changed
ASG_LAST_UPDATE_DATE DATE

Date on which assignment information was last changed
BEN_LAST_UPDATE_DATE DATE

Date on which benefit contributions information was last changed
TP_LAST_UPDATE_DATE DATE

The date on which the time period type definition relevant to this record was last changed
GREATEST_LAST_UPDATE_DATE DATE

Date on which anything significant that is returned by this view was changed for this employee
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COMPANY_CODE_EQUIVALENT
,      GRE_NAME
,      GRE_ID
,      ORGANIZATION_ID
,      EMPLOYEE_NUMBER
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_SEQUENCE
,      PRIMARY_FLAG
,      PAY_FREQUENCY
,      PROGRAM
,      BENEFIT_NAME
,      BENEFIT_PLAN_TYPE
,      EMPLOYEE_CONTRIBUTION
,      EMPLOYER_CONTRIBUTION
,      EE_CONTRIBUTION_LIMIT
,      ER_CONTRIBUTION_LIMIT
,      COVERAGE_TYPE
,      COVERAGE_START_DATE
,      COVERAGE_END_DATE
,      PER_LAST_UPDATE_DATE
,      ASG_LAST_UPDATE_DATE
,      BEN_LAST_UPDATE_DATE
,      TP_LAST_UPDATE_DATE
,      GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_OAB_BENEFIT_V;

Dependencies

[top of page]

APPS.HR_ADP_OAB_BENEFIT_V references the following:

SchemaAPPS
SynonymBEN_ACTY_BASE_RT_F
SynonymBEN_ACTY_RT_PTD_LMT_F
SynonymBEN_PGM_F
SynonymBEN_PL_F
SynonymBEN_PL_TYP_F
SynonymBEN_PRTT_ENRT_RSLT_F
SynonymBEN_PRTT_RT_VAL
SynonymBEN_PTD_LMT_F
PL/SQL PackageHR_ADP - show dependent code
ViewHR_ADP_EMP_REF_V
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PAY_INTERFACE_PKG - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
SynonymPAY_ELEMENT_ENTRIES_F
SynonymPAY_ELEMENT_ENTRY_VALUES_F
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_TIME_PERIOD_TYPES

APPS.HR_ADP_OAB_BENEFIT_V is not referenced by any database object