[Home] [Help] [Dependency Information]
Object Name: | PAY_AC_EMP_EARN_ACTION_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_AC_EMP_EARN_ACTION_INFO_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
This view retrieves Employee's Hours and Earnings data from the archiver.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_CONTEXT_ID | NUMBER | (15) | Yes | System-generated primary key column |
TAX_UNIT_ID | NUMBER | (15) | Identifies the Government Reporting Entity, or Legal Entity for the assignment | |
EFFECTIVE_DATE | DATE | Effective Date | ||
ELEMENT_CLASSIFICATION | VARCHAR2 | (240) | Element classification | |
ELEMENT_TYPE_ID | VARCHAR2 | (240) | Element type ID | |
REPORTING_NAME | VARCHAR2 | (240) | Element reporting name | |
PRIMARY_BALANCE | VARCHAR2 | (240) | Primary balance | |
PROCESSING_PRIORITY | VARCHAR2 | (240) | Element processing priority | |
RATE | NUMBER | Rate | ||
RATE_MUL | NUMBER | Rate_mul | ||
CURRENT_HOURS | NUMBER | Current earned hours | ||
CURRENT_AMOUNT | NUMBER | Current amount | ||
YTD_HOURS | NUMBER | Year to date hours | ||
YTD_AMOUNT | NUMBER | Yeart to date amount | ||
DATE_EARNED | DATE | Date Earned | ||
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
ELEMENT_CATEGORY | VARCHAR2 | (240) | Element Category | |
JURISDICTION_CODE | VARCHAR2 | (240) | Jurisdiction Code |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_CONTEXT_ID
, TAX_UNIT_ID
, EFFECTIVE_DATE
, ELEMENT_CLASSIFICATION
, ELEMENT_TYPE_ID
, REPORTING_NAME
, PRIMARY_BALANCE
, PROCESSING_PRIORITY
, RATE
, RATE_MUL
, CURRENT_HOURS
, CURRENT_AMOUNT
, YTD_HOURS
, YTD_AMOUNT
, DATE_EARNED
, START_DATE
, END_DATE
, ELEMENT_CATEGORY
, JURISDICTION_CODE
FROM APPS.PAY_AC_EMP_EARN_ACTION_INFO_V;
APPS.PAY_AC_EMP_EARN_ACTION_INFO_V is not referenced by any database object
|
|
|