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_ADP_ASSIGNMENT_V

Object Details

Object Name:	HR_ADP_ASSIGNMENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_ADP_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
COMPANY_CODE_EQUIVALENT	VARCHAR2	(60)		ADP company code
GRE_NAME	VARCHAR2	(240)	Yes	GRE name
GRE_ID	VARCHAR2	(60)		GRE ID
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization ID for employee's HR organization
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee number
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business group ID
PERSON_ID	NUMBER	(10)	Yes	Person ID
PAY_FREQUENCY	VARCHAR2	(40)		Payroll frequency
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment ID
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Assignment number
PRIMARY_FLAG	VARCHAR2	(30)	Yes	Indicates primary employee assignment. Y/N.
EFFECTIVE_START_DATE	DATE		Yes	Effective start date for assignment
EFFECTIVE_END_DATE	DATE		Yes	Effective end date for assignment.
ASSIGNMENT_SEQUENCE	NUMBER			Assignment sequence
JOB_NAME	VARCHAR2	(700)		Job name
FLSA_CODE	VARCHAR2	(150)		FLSA code
EEO_CATEGORY	VARCHAR2	(150)		EEO category for the job
RATE	NUMBER			Salary or pay rate
PAY_BASIS	VARCHAR2	(1)		Pay basis. For example, H - Hourly, M - Monthly
NORMAL_HOURS	NUMBER	(22)		Normal working hours
PREVIOUS_SALARY_CHANGE_DATE	DATE			The date on which the employee's salary or pay rate last changed
NEXT_SAL_REVIEW_DATE	DATE			Date of the next salary review
SALARY_CHANGE_REASON	VARCHAR2	(30)		Reason for most recent salary change
RATE_EFFECTIVE_DATE	DATE		Yes	The date on which the current salary became effective
SEASONAL_EMPLOYEE_FLAG	VARCHAR2	(60)		Indicates if this is a seasonal employee. Y/N
CORPORATE_OFFICER_FLAG	VARCHAR2	(60)		Indicates if this employee is a corporate officer. Y/N
FINAL_PROCESS_DATE	DATE			Final date for all payroll processing for this person
PAYROLL_STATUS	VARCHAR2	(1)		Payroll processing status... D - Do not process; P - Process
HOME_DEPT	VARCHAR2	(240)	Yes	The HR organization to which employee is assigned
HOME_JOB	VARCHAR2	(700)		The job to which the employee is assigned
CHANGE_REASON_CODE	VARCHAR2	(30)		A code that records the reason for the most recent change to the assignment
CHANGE_REASON_MEANING	VARCHAR2	(4000)		The reason for the most recent change to the assignment
LOCATION	VARCHAR2	(60)		The employee's work location
WORK_STATE	VARCHAR2	(150)		The employee's work state for tax purposes
PER_LAST_UPDATE_DATE	DATE			Date on which person information was last changed for this employee
ASG_LAST_UPDATE_DATE	DATE			Date on which assignment information was last changed for this employee
PPP_LAST_UPDATE_DATE	DATE			Date on which salary proposal information was last changed for this employee
POS_LAST_UPDATE_DATE	DATE			Date on which period of service information was last changed for this employee
SAL_LAST_UPDATE_DATE	DATE			Date on which salary information was last changed for this employee
JOB_LAST_UPDATE_DATE	DATE			Date on which information about the employee's job was last changed
OTHER_LAST_UPDATE_DATE	DATE			Date on which information about the definition of the employee's assignment status was last changed
GREATEST_LAST_UPDATE_DATE	DATE			Date on which anything significant that is returned by this view was last changed for this employee

Query Text

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


SELECT COMPANY_CODE_EQUIVALENT
,      GRE_NAME
,      GRE_ID
,      ORGANIZATION_ID
,      EMPLOYEE_NUMBER
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      PAY_FREQUENCY
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      PRIMARY_FLAG
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_SEQUENCE
,      JOB_NAME
,      FLSA_CODE
,      EEO_CATEGORY
,      RATE
,      PAY_BASIS
,      NORMAL_HOURS
,      PREVIOUS_SALARY_CHANGE_DATE
,      NEXT_SAL_REVIEW_DATE
,      SALARY_CHANGE_REASON
,      RATE_EFFECTIVE_DATE
,      SEASONAL_EMPLOYEE_FLAG
,      CORPORATE_OFFICER_FLAG
,      FINAL_PROCESS_DATE
,      PAYROLL_STATUS
,      HOME_DEPT
,      HOME_JOB
,      CHANGE_REASON_CODE
,      CHANGE_REASON_MEANING
,      LOCATION
,      WORK_STATE
,      PER_LAST_UPDATE_DATE
,      ASG_LAST_UPDATE_DATE
,      PPP_LAST_UPDATE_DATE
,      POS_LAST_UPDATE_DATE
,      SAL_LAST_UPDATE_DATE
,      JOB_LAST_UPDATE_DATE
,      OTHER_LAST_UPDATE_DATE
,      GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_ASSIGNMENT_V;

Dependencies

[top of page]

APPS.HR_ADP_ASSIGNMENT_V references the following:

APPS: HR_ADP - show dependent code; HR_ADP_EMP_REF_V; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_SECURITY - show dependent code; HR_SOFT_CODING_KEYFLEX; PAY_ELEMENT_ENTRIES_F; PAY_ELEMENT_ENTRY_VALUES_F; PAY_ELEMENT_LINKS_F; PAY_ELEMENT_LINKS_X; PAY_ELEMENT_TYPES_F; PAY_INPUT_VALUES_F; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_ASSIGNMENT_STATUS_TYPES; PER_ASS_STATUS_TYPE_AMENDS; PER_JOBS; PER_PAY_BASES; PER_PAY_PROPOSALS; PER_PERIODS_OF_SERVICE; PER_TIME_PERIOD_TYPES

APPS.HR_ADP_ASSIGNMENT_V is not referenced by any database object