[Home] [Help] [Dependency Information]
Object Name: | HR_ADP_BENEFIT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HR_ADP_BENEFIT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view returns information about employee medical, dental and vision benefits.
It should be used if you have implemented your benefits using basic benefits functionality.
If you have implemented standard or advanced benefits, use the HR_ADP_OAB_BENEFIT_V view.
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 | |
BENEFIT_NAME | VARCHAR2 | (80) | Yes | Benefit name |
BENEFIT_CLASSIFICATION | VARCHAR2 | (80) | Yes | Benefit classification |
BENEFIT_FREQUENCY | NUMBER | (15) | Yes | Number of times the benefit contribution is taken per fiscal year |
BENEFIT_PERIOD_TYPE | VARCHAR2 | (150) | The frequency with which the benefit contributions are taken. For example, Calendar Month | |
EMPLOYER_CONTRIBUTION | NUMBER | The amount that the employer contributes for this benefit | ||
EMPLOYEE_CONTRIBUTION | NUMBER | The amount that the employee contributes for this benefit | ||
COVERAGE_TYPE | VARCHAR2 | (30) | Yes | Type of coverage, eg "employee only", "employee and spouse". |
COVERAGE_START_DATE | DATE | Date on which employee first enrolled on this benefit | ||
COVERAGE_END_DATE | DATE | End date for benefit enrollment | ||
PER_LAST_UPDATE_DATE | DATE | Date on which person information was last changed for this employee | ||
ASG_LAST_UPDATE_DATE | DATE | Date on which assignment information was last changed for this employee | ||
BEN_LAST_UPDATE_DATE | DATE | Date on which the benefit definition was last changed | ||
BBEN_LAST_UPDATE_DATE | DATE | Date on which benefit enrollment information was last changed for this employee | ||
BCON_LAST_UPDATE_DATE | DATE | Date on which default contribution information for this benefit was last changed | ||
BBC_LAST_UPDATE_DATE | DATE | Date on which the benefit classification definition for this benefit was last changed | ||
TP_LAST_UPDATE_DATE | DATE | Date on which the time period type definition for this benefit was last changed | ||
GREATEST_LAST_UPDATE_DATE | DATE | Date on which anything significant that is returned by this view was last changed for this employee |
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
, BENEFIT_NAME
, BENEFIT_CLASSIFICATION
, BENEFIT_FREQUENCY
, BENEFIT_PERIOD_TYPE
, EMPLOYER_CONTRIBUTION
, EMPLOYEE_CONTRIBUTION
, COVERAGE_TYPE
, COVERAGE_START_DATE
, COVERAGE_END_DATE
, PER_LAST_UPDATE_DATE
, ASG_LAST_UPDATE_DATE
, BEN_LAST_UPDATE_DATE
, BBEN_LAST_UPDATE_DATE
, BCON_LAST_UPDATE_DATE
, BBC_LAST_UPDATE_DATE
, TP_LAST_UPDATE_DATE
, GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_BENEFIT_V;
APPS.HR_ADP_BENEFIT_V is not referenced by any database object
|
|
|