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


VIEW: APPS.HR_ADP_EMP_REF_V

Object Details
Object Name: HR_ADP_EMP_REF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_ADP_EMP_REF_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 list of employees, together with their GREs. It also returns a column called company_code_equivalent, which should be mapped to the ADP Company Code in ADP Connection.
The version of the view that is delivered with Oracle HR returns gre_id as company_code_equivalent. If ADP Company Code is not implemented as GRE, this view should be customized to return the appropriate value in the company_code_equivalent column.
This view is referenced by the other ADP interface extract views, so a change to the derivation of company_code_equivalent in this view is reflected in the company_code_equivalent that is returned by the other views.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_CODE_EQUIVALENT VARCHAR2 (60)
ADP company code
GRE_ID VARCHAR2 (60)
GRE ID
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number
PERSON_ID NUMBER (10) Yes Person ID
BUSINESS_GROUP_ID NUMBER (15) Yes Business group ID
ASSIGNMENT_ID NUMBER (10) Yes Assignment ID
ASSIGNMENT_SEQUENCE NUMBER

Assignment sequence
PRIMARY_FLAG VARCHAR2 (30) Yes Indicates primary employee assignment. Y/N.
SOCIAL_SECURITY_NUMBER VARCHAR2 (30)
Social security number
FIRST_NAME VARCHAR2 (150)
Employee first name
LAST_NAME VARCHAR2 (150) Yes Employee last name
MIDDLE_NAMES VARCHAR2 (60)
Employee middle name(s)
SUFFIX VARCHAR2 (30)
Last name suffix, eg. Sr., Jr., III
ASG_ROWID ROWID (10)
Assignment rowid - for internal use
PER_ROWID ROWID (10)
Person rowid - for internal use
PERIOD_TYPE VARCHAR2 (30) Yes Periodicity of payroll. For example, Calendar Month.
DATE_START DATE
Yes Date on which period of service started for this employee
FINAL_PROCESS_DATE DATE

Final Process Date
LAST_UPDATE_DATE DATE

Date on which period of service information was last changed for this employee
Query Text

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


SELECT COMPANY_CODE_EQUIVALENT
,      GRE_ID
,      EMPLOYEE_NUMBER
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_SEQUENCE
,      PRIMARY_FLAG
,      SOCIAL_SECURITY_NUMBER
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAMES
,      SUFFIX
,      ASG_ROWID
,      PER_ROWID
,      PERIOD_TYPE
,      DATE_START
,      FINAL_PROCESS_DATE
,      LAST_UPDATE_DATE
FROM APPS.HR_ADP_EMP_REF_V;

Dependencies

[top of page]

APPS.HR_ADP_EMP_REF_V references the following:

SchemaAPPS
PL/SQL PackageHR_ADP - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
ViewPAY_PAYROLLS_F
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE
APPS.HR_ADP_EMP_REF_V is referenced by following:

SchemaAPPS
ViewHR_ADP_ACCRUAL_PLAN_V
ViewHR_ADP_ADDRESS_V
ViewHR_ADP_ASSIGNMENT_V
ViewHR_ADP_BENEFIT_V
ViewHR_ADP_CITY_TAX_V
ViewHR_ADP_COSTING_V
ViewHR_ADP_DEDUCTION_V
ViewHR_ADP_EFT_V
ViewHR_ADP_ELE_COSTING_V
ViewHR_ADP_EMPLOYEE_V
ViewHR_ADP_FED_TAX_V
ViewHR_ADP_GTL_V
ViewHR_ADP_OAB_BENEFIT_V
ViewHR_ADP_PAYMENT_METHODS_V
ViewHR_ADP_RESIDENT_STATE_TAX_V
ViewHR_ADP_STATE_TAX_V
ViewHR_ADP_WORKERS_COMP_V
ViewHR_ADP_WORK_STATE_TAX_V