[Home] [Help] [Dependency Information]
Object Name: | PAY_US_DEDUCTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_US_DEDUCTIONS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | (10) | Foreign key to PER_ALL_ASSIGNMENTS_F | |
TAX_UNIT_ID | NUMBER | (15) | Identifies the Government Reporting Entity, or Legal Entity for the assignment | |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | Foreign key to PAY_ASSIGNMENT_ACTIONS |
ACTION_STATUS | VARCHAR2 | (1) | Yes | Assignment action status |
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | Foreign key to PAY_PAYROLL_ACTIONS |
ACTION_TYPE | VARCHAR2 | (30) | Yes | Payroll action type |
EFFECTIVE_DATE | DATE | Yes | Payroll action effective's date | |
ELEMENT_NAME | VARCHAR2 | (80) | Yes | Deduction element name |
ELEMENT_TYPE_ID | NUMBER | (9) | Yes | Foreign key to PAY_ELEMENT_TYPES_F |
CLASSIFICATION_NAME | VARCHAR2 | (80) | Yes | Element classification name |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS | |
EFFECTIVE_START_DATE | DATE | Yes | Elemtent type's effective start date | |
EFFECTIVE_END_DATE | DATE | Yes | Elemtent type's effective end date | |
LEGISLATION_CODE | VARCHAR2 | (30) | Element type legislation code | |
ELEMENT_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
PROCESSING_PRIORITY | NUMBER | (9) | Yes | Processing priority order for any entries of this element in a payroll run |
REPORTING_NAME | VARCHAR2 | (80) | Short name for the element | |
REPORTING_NAME_ALT | VARCHAR2 | (80) | Translated name by which a user identifies the element or classification | |
BALANCE_NAME | VARCHAR2 | (80) | Yes | Translated balance name |
BALANCE_TYPE_ID | NUMBER | (9) | Yes | Balance Type ID |
BALANCE_UOM | VARCHAR2 | (30) | Yes | Unit of measure, for example, Money |
VIEW_MODE | VARCHAR2 | (4000) | Assignment/Person/GRE balance level | |
CALC_ALL_TIMETYPES | NUMBER | |||
CURRENT_VAL | NUMBER | Current Amount | ||
RUN_VAL | NUMBER | Run amount | ||
PYDATE_VAL | NUMBER | Period to date amount | ||
MONTH_VAL | NUMBER | Amount for the month | ||
QTD_VAL | NUMBER | Quarter to date amount | ||
YTD_VAL | NUMBER | Year to date amount |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, TAX_UNIT_ID
, ASSIGNMENT_ACTION_ID
, ACTION_STATUS
, PAYROLL_ACTION_ID
, ACTION_TYPE
, EFFECTIVE_DATE
, ELEMENT_NAME
, ELEMENT_TYPE_ID
, CLASSIFICATION_NAME
, BUSINESS_GROUP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, LEGISLATION_CODE
, ELEMENT_INFORMATION10
, PROCESSING_PRIORITY
, REPORTING_NAME
, REPORTING_NAME_ALT
, BALANCE_NAME
, BALANCE_TYPE_ID
, BALANCE_UOM
, VIEW_MODE
, CALC_ALL_TIMETYPES
, CURRENT_VAL
, RUN_VAL
, PYDATE_VAL
, MONTH_VAL
, QTD_VAL
, YTD_VAL
FROM APPS.PAY_US_DEDUCTIONS_V;
|
|
|