[Home] [Help] [Dependency Information]
Object Name: | HR_CERIDIAN_500_ALT_RATES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HR_CERIDIAN_500_ALT_RATES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view returns information about alternative pay rates (for example, overtime rates) for employees.
It returns element entries for the "Ceridian Alternate Pay Rates" element. Information on how to set up this element is provided in the Ceridian Source 500 Interface implementation guide, which is available from MetaLink.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY | VARCHAR2 | (240) | Yes | GRE name |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number | |
EFFECTIVE_START_DATE | DATE | Yes | Element entry effective start date | |
EFFECTIVE_END_DATE | DATE | Element entry effective end date | ||
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 | |
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 |
ALT_RATE_A | NUMBER | Pay rate A | ||
ALT_RATE_B | NUMBER | Pay rate B | ||
ALT_RATE_C | NUMBER | Pay rate C | ||
ALT_RATE_D | NUMBER | Pay rate D | ||
LAST_UPDATE_DATE | DATE | Date on which anything significant that is returned by this view was changed for this employee |
Cut, paste (and edit) the following text to query this object:
SELECT COMPANY
, EMPLOYEE_NUMBER
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ASSIGNMENT_NUMBER
, PRIMARY_FLAG
, SOCIAL_SECURITY_NUMBER
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, PAYROLL_ID
, PERSON_ID
, ALT_RATE_A
, ALT_RATE_B
, ALT_RATE_C
, ALT_RATE_D
, LAST_UPDATE_DATE
FROM APPS.HR_CERIDIAN_500_ALT_RATES_V;
APPS.HR_CERIDIAN_500_ALT_RATES_V is not referenced by any database object
|
|
|