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_ASSIGNMENT_V

Object Details

Object Name:	HR_CERIDIAN_ASSIGNMENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_CERIDIAN_ASSIGNMENT_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 employee assignments.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee number
COMPANY	VARCHAR2	(240)	Yes	GRE name
LAST_NAME	VARCHAR2	(150)	Yes	Employee last name
FIRST_NAME	VARCHAR2	(150)		Employee first name
MIDDLE_NAME	VARCHAR2	(60)		Employee middle name(s)
HIRE_DATE	DATE		Yes	Hire date
DATE_LAST_PAID	DATE			Final date for all payroll processing of this person.
WORKERS_COMP_CODE	VARCHAR2	(60)		WC code
PAY_FREQUENCY	VARCHAR2	(40)		Payroll frequency
HOURLY_RATE	VARCHAR2	(60)		Hourly rate
ANNUAL_SALARY	VARCHAR2	(60)		Annual salary
PAYROLL_STATUS	VARCHAR2	(1)		Payroll status
STANDARD_HOURS	NUMBER	(22)		Normal working hours.
DISTRIBUTION_DATA	VARCHAR2	(180)		Segments 1, 2 and 3 of the cost allocation keyflex (assignment level)
SHIFT	VARCHAR2	(60)		Shift
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group ID
PERSON_ID	NUMBER	(10)	Yes	Person ID
PER_LAST_UPDATE_DATE	DATE			Date on which person information was last changed
SAL_LAST_UPDATE_DATE	DATE			Date on which salary information was last changed
ADR_LAST_UPDATE_DATE	DATE			Date on which address information was last changed
ASG_LAST_UPDATE_DATE	DATE			Date on which assignment information was last changed
COST_LAST_UPDATE_DATE	DATE			Date on which costing information was last changed
LAST_UPDATE_DATE	DATE			Date on which period of service, workers comp, assignment status type information was last changed

Query Text

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


SELECT EMPLOYEE_NUMBER
,      COMPANY
,      LAST_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      HIRE_DATE
,      DATE_LAST_PAID
,      WORKERS_COMP_CODE
,      PAY_FREQUENCY
,      HOURLY_RATE
,      ANNUAL_SALARY
,      PAYROLL_STATUS
,      STANDARD_HOURS
,      DISTRIBUTION_DATA
,      SHIFT
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      PER_LAST_UPDATE_DATE
,      SAL_LAST_UPDATE_DATE
,      ADR_LAST_UPDATE_DATE
,      ASG_LAST_UPDATE_DATE
,      COST_LAST_UPDATE_DATE
,      LAST_UPDATE_DATE
FROM APPS.HR_CERIDIAN_ASSIGNMENT_V;

Dependencies

[top of page]

APPS.HR_CERIDIAN_ASSIGNMENT_V references the following:

APPS: HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; HR_SOFT_CODING_KEYFLEX; PAY_COST_ALLOCATIONS_F; PAY_COST_ALLOCATION_KEYFLEX; PAY_ELEMENT_ENTRIES_F; PAY_ELEMENT_ENTRY_VALUES_F; PAY_ELEMENT_LINKS_X; PAY_ELEMENT_TYPES_X; PAY_INPUT_VALUES_F; PAY_JOB_WC_CODE_USAGES; PAY_PAYROLLS_X; PER_ADDRESSES; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_ASSIGNMENT_STATUS_TYPES; PER_ASS_STATUS_TYPE_AMENDS; PER_PAY_BASES; PER_PERIODS_OF_SERVICE; PER_TIME_PERIOD_TYPES

APPS.HR_CERIDIAN_ASSIGNMENT_V is not referenced by any database object