[Home] [Help] [Dependency Information]
Object Name: | HR_ADP_DEDUCTION_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HR_ADP_DEDUCTION_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view returns element entries for those elements that have been set up as regular ADP deductions. It will return both recurring and nonrecurring element entries.
Information on how to set up elements as ADP deductions is provided in the ADP Interface implementation guide. This document is available from MetaLink.
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 the 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 |
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. |
DEDUCTION_NAME | VARCHAR2 | (80) | Yes | Deduction name |
DEDUCTION_AMOUNT | NUMBER | Deduction amount | ||
DEDUCTION_UNITS | VARCHAR2 | (1) | Deduction units | |
DEDUCTION_FREQUENCY | VARCHAR2 | (150) | Frequency that this deduction is taken | |
DEDUCTION_LIMIT | NUMBER | Deduction limit | ||
PAY_FREQUENCY | VARCHAR2 | (40) | Payroll frequency | |
BEGIN_DATE | DATE | The start date for the deduction | ||
END_DATE | DATE | The end date for the deduction | ||
PER_LAST_UPDATE_DATE | DATE | Date on which person information last changed | ||
ASG_LAST_UPDATE_DATE | DATE | Date on which assignment information last changed | ||
DED_LAST_UPDATE_DATE | DATE | Date on which the element type definition for this deduction was last changed | ||
DDED_LAST_UPDATE_DATE | DATE | Date on which the element entry for this deduction 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 |
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
, ASSIGNMENT_ID
, ASSIGNMENT_NUMBER
, ASSIGNMENT_SEQUENCE
, PRIMARY_FLAG
, DEDUCTION_NAME
, DEDUCTION_AMOUNT
, DEDUCTION_UNITS
, DEDUCTION_FREQUENCY
, DEDUCTION_LIMIT
, PAY_FREQUENCY
, BEGIN_DATE
, END_DATE
, PER_LAST_UPDATE_DATE
, ASG_LAST_UPDATE_DATE
, DED_LAST_UPDATE_DATE
, DDED_LAST_UPDATE_DATE
, GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_DEDUCTION_V;
APPS.HR_ADP_DEDUCTION_V is not referenced by any database object
|
|
|