eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.HR_CERIDIAN_500_SELECTION_V

Object Details

Object Name:	HR_CERIDIAN_500_SELECTION_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_CERIDIAN_500_SELECTION_V
Subobject Name:
Status:	VALID

View Type

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

This view returns a master list of employees and is used to support the entry of selection criteria in Ceridian's SourceLink interface module.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee number
COMPANY	VARCHAR2	(240)	Yes	GRE name
SOCIAL_SECURITY_NUMBER	VARCHAR2	(30)		Social security number
PAY_FREQUENCY_NAME	VARCHAR2	(30)	Yes	Payroll frequency, eg. Week, Calendar Month
PAY_FREQUENCY	VARCHAR2	(40)		Payroll frequency, eg. W, M
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes	Business group name
PAYROLL_NAME	VARCHAR2	(80)	Yes	Payroll name
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Employee assignment number.
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment ID
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group ID.
GRE_ID	NUMBER	(15)	Yes	GRE ID
PAYROLL_ID	NUMBER	(9)	Yes	Payroll ID
PERSON_ID	NUMBER	(10)	Yes	Person ID

Query Text

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


SELECT EMPLOYEE_NUMBER
,      COMPANY
,      SOCIAL_SECURITY_NUMBER
,      PAY_FREQUENCY_NAME
,      PAY_FREQUENCY
,      BUSINESS_GROUP_NAME
,      PAYROLL_NAME
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      GRE_ID
,      PAYROLL_ID
,      PERSON_ID
FROM APPS.HR_CERIDIAN_500_SELECTION_V;

Dependencies

[top of page]

APPS.HR_CERIDIAN_500_SELECTION_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_CERIDIAN - show dependent code; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; HR_SOFT_CODING_KEYFLEX; PAY_PAYROLLS_X; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_PERIODS_OF_SERVICE; PER_TIME_PERIOD_TYPES

APPS.HR_CERIDIAN_500_SELECTION_V is not referenced by any database object