[Home] [Help] [Dependency Information]
Object Name: | PAY_US_EARNINGS_AMOUNTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_US_EARNINGS_AMOUNTS_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) | System-generated primary key from 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 | System-generated primary key from PAY_ASSIGNMENT_ACTIONS |
ACTION_STATUS | VARCHAR2 | (1) | Yes | Assignment action status |
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | System-generated primary key from 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 | Earnings element name |
ELEMENT_TYPE_ID | NUMBER | (9) | Yes | System-generated primary key from PAY_ELEMENT_TYPES_F |
TAX_CATEGORY_CODE | VARCHAR2 | (150) | Tax category code | |
CLASSIFICATION_NAME | VARCHAR2 | (80) | Yes | Element classification name |
PROCESSING_PRIORITY | NUMBER | (9) | Yes | Processing priority order for any entries of this element in a payroll run |
EFFECTIVE_START_DATE | DATE | Yes | Elemtent type's effective start date | |
EFFECTIVE_END_DATE | DATE | Yes | Elemtent type's effective end date | |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS | |
LEGISLATION_CODE | VARCHAR2 | (30) | Element type legislation code | |
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 | (4000) | Translated balance name | |
BALANCE_TYPE_ID | NUMBER | (9) | Yes | Balance type ID |
HOURS_BALANCE_TYPE_ID | NUMBER | Hours Balance type ID | ||
HOURS_BALANCE_NAME | VARCHAR2 | (4000) | Hours balance name | |
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 | ||
HOURS_CURRENT_VAL | NUMBER | Hours: current value | ||
HOURS_RUN_VAL | NUMBER | Hours: run value | ||
HOURS_QTD_VAL | NUMBER | Hours: quarter to date value | ||
HOURS_YTD_VAL | NUMBER | Hours: year to date value |
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
, TAX_CATEGORY_CODE
, CLASSIFICATION_NAME
, PROCESSING_PRIORITY
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, REPORTING_NAME
, REPORTING_NAME_ALT
, BALANCE_NAME
, BALANCE_TYPE_ID
, HOURS_BALANCE_TYPE_ID
, HOURS_BALANCE_NAME
, BALANCE_UOM
, VIEW_MODE
, CALC_ALL_TIMETYPES
, CURRENT_VAL
, RUN_VAL
, PYDATE_VAL
, MONTH_VAL
, QTD_VAL
, YTD_VAL
, HOURS_CURRENT_VAL
, HOURS_RUN_VAL
, HOURS_QTD_VAL
, HOURS_YTD_VAL
FROM APPS.PAY_US_EARNINGS_AMOUNTS_V;
|
|
|