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


VIEW: APPS.HR_ADP_WORKERS_COMP_V

Object Details
Object Name: HR_ADP_WORKERS_COMP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_ADP_WORKERS_COMP_V
Subobject Name:
Status: VALID

View Type

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


This view returns workers compensation information for employees.


[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
PERSON_ID NUMBER (10) Yes Person ID
BUSINESS_GROUP_ID NUMBER (15) Yes Business group ID
PAY_FREQUENCY VARCHAR2 (40)
Payroll frequency
ASSIGNMENT_ID NUMBER (10) Yes Assignment ID
ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment number
ASSIGNMENT_SEQUENCE NUMBER

Assignment sequence
PRIMARY_FLAG VARCHAR2 (30) Yes Indicates primary employee assignment. Y/N.
JOB_NAME VARCHAR2 (700)
Job name
WORKERS_COMP_CODE VARCHAR2 (60)
WC code
WORK_STATE_CODE VARCHAR2 (120)
State abbreviation, eg. CA
GREATEST_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_CODE_EQUIVALENT
,      GRE_NAME
,      GRE_ID
,      ORGANIZATION_ID
,      EMPLOYEE_NUMBER
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      PAY_FREQUENCY
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_SEQUENCE
,      PRIMARY_FLAG
,      JOB_NAME
,      WORKERS_COMP_CODE
,      WORK_STATE_CODE
,      GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_WORKERS_COMP_V;

Dependencies

[top of page]

APPS.HR_ADP_WORKERS_COMP_V references the following:

SchemaAPPS
PL/SQL PackageHR_ADP - show dependent code
ViewHR_ADP_EMP_REF_V
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
SynonymPAY_JOB_WC_CODE_USAGES
ViewPAY_PAYROLLS_X
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_JOBS
SynonymPER_TIME_PERIOD_TYPES

APPS.HR_ADP_WORKERS_COMP_V is not referenced by any database object