[Home] [Help] [Dependency Information]
Object Name: | HR_CERIDIAN_DEDUCTION_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HR_CERIDIAN_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 Ceridian Source 100 deductions. It will return both recurring and nonrecurring element entries.
Information on how to set up elements as Ceridian Source 100 deductions is provided in the Ceridian Source 100 Interface implementation guide. This document is available from MetaLink.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number | |
COMPANY | VARCHAR2 | (240) | Yes | GRE name |
DEDUCTION_DESCR | VARCHAR2 | (80) | Deduction code | |
RECURRING_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the element is recurring or nonrecurring. |
AMOUNT | VARCHAR2 | (4000) | Deduction amount | |
DEDUCTION_LIMIT | VARCHAR2 | (4000) | Deduction limit | |
ACTIVE_FLAG | VARCHAR2 | (1) | Indicates if this deduction is active | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group ID |
PERSON_ID | NUMBER | (10) | Yes | Person ID |
LAST_UPDATE_DATE | DATE | Date on which element entry information was last changed |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_NUMBER
, COMPANY
, DEDUCTION_DESCR
, RECURRING_FLAG
, AMOUNT
, DEDUCTION_LIMIT
, ACTIVE_FLAG
, BUSINESS_GROUP_ID
, PERSON_ID
, LAST_UPDATE_DATE
FROM APPS.HR_CERIDIAN_DEDUCTION_V;
APPS.HR_CERIDIAN_DEDUCTION_V is not referenced by any database object
|
|
|