[Home] [Help] [Dependency Information]
Object Name: | HR_CERIDIAN_500_BENEFIT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HR_CERIDIAN_500_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_CERIDIAN_500_OAB_BENEFIT_V view.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number | |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date for benefits element entry | |
EFFECTIVE_END_DATE | DATE | Effective end date for benefits element entry | ||
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | Employee assignment number. | |
PRIMARY_FLAG | VARCHAR2 | (30) | Yes | Indicates primary employee assignment. Y/N. |
SOCIAL_SECURITY_NUMBER | VARCHAR2 | (30) | Social security number | |
COMPANY | VARCHAR2 | (240) | Yes | GRE |
DEDUCTION_DESCR | VARCHAR2 | (80) | Benefit name | |
EE_CONTRIBUTION | VARCHAR2 | (61) | Employee contribution | |
ER_CONTRIBUTION | VARCHAR2 | (61) | Employer contribution | |
EE_CONTRIBUTION_PERIOD | VARCHAR2 | (41) | Employee contribution per pay period | |
ER_CONTRIBUTION_PERIOD | VARCHAR2 | (41) | Employer contribution per pay period | |
PERIOD_TYPE | VARCHAR2 | (150) | Frequency with which benefit contributions are made | |
NUMBER_PER_FISCAL_YEAR | NUMBER | (15) | Yes | Number of times the benefit contribution is taken per fiscal year |
ASSIGNMENT_ID | NUMBER | (10) | Yes | Assignment ID |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group ID |
PAYROLL_ID | NUMBER | (9) | Business Group ID | |
PERSON_ID | NUMBER | (10) | Yes | Person ID |
BDED_LAST_UPDATE_DATE | DATE | Date on which benefit element entry last changed | ||
BCON_LAST_UPDATE_DATE | DATE | Date on which default benefit contribution amount last changed |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_NUMBER
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ASSIGNMENT_NUMBER
, PRIMARY_FLAG
, SOCIAL_SECURITY_NUMBER
, COMPANY
, DEDUCTION_DESCR
, EE_CONTRIBUTION
, ER_CONTRIBUTION
, EE_CONTRIBUTION_PERIOD
, ER_CONTRIBUTION_PERIOD
, PERIOD_TYPE
, NUMBER_PER_FISCAL_YEAR
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, PAYROLL_ID
, PERSON_ID
, BDED_LAST_UPDATE_DATE
, BCON_LAST_UPDATE_DATE
FROM APPS.HR_CERIDIAN_500_BENEFIT_V;
APPS.HR_CERIDIAN_500_BENEFIT_V is not referenced by any database object
|
|
|