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

VIEW: APPS.HR_CERIDIAN_500_ALT_RATES_V

Object Details
Object Name: HR_CERIDIAN_500_ALT_RATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_CERIDIAN_500_ALT_RATES_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 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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.HR_CERIDIAN_500_ALT_RATES_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_CERIDIAN - show dependent code
PL/SQL PackageHR_PAY_INTERFACE_PKG - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
SynonymPAY_ELEMENT_ENTRIES_F
SynonymPAY_ELEMENT_ENTRY_VALUES_F
SynonymPAY_ELEMENT_LINKS_F
ViewPAY_ELEMENT_LINKS_X
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_INPUT_VALUES_F
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE

APPS.HR_CERIDIAN_500_ALT_RATES_V is not referenced by any database object