[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_COMP_HIST_DWLD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
Employee Compensation View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MGR_PERSON_ID | NUMBER | (15) | Yes | Mgr Person Id |
MGR_PER_IN_LER_ID | NUMBER | (15) | Yes | Mgr Per In Ler Id |
ASSIGNMENT_ID | NUMBER | (15) | Yes | Assignment Id |
EMP_NAME | VARCHAR2 | (240) | Emp Name | |
GROUP_PER_IN_LER_ID | NUMBER | (15) | Yes | Group Per In Ler Id |
GROUP_PLAN_ID | NUMBER | (15) | Group Plan Id | |
LF_EVENT_OCRD_DT | DATE | Lf Event Ocrd Dt | ||
FTE | NUMBER | Fte | ||
YEAR | VARCHAR2 | (4) | Year | |
STOCK1 | NUMBER | Stock1 | ||
STOCK2 | NUMBER | Stock2 | ||
PAY_RATE_CURRENCY | VARCHAR2 | (169) | Pay Rate Currency | |
PAY_BASIS | VARCHAR2 | (169) | Pay Basis | |
PAY_RATE_AMOUNT | VARCHAR2 | (169) | Pay Rate Amount | |
BONUS | VARCHAR2 | (163) | Bonus | |
OTHER_COMP | VARCHAR2 | (163) | Other Comp | |
COMMISSION | VARCHAR2 | (163) | Commission | |
OVERTIME | VARCHAR2 | (163) | Overtime |
Cut, paste (and edit) the following text to query this object:
SELECT MGR_PERSON_ID
, MGR_PER_IN_LER_ID
, ASSIGNMENT_ID
, EMP_NAME
, GROUP_PER_IN_LER_ID
, GROUP_PLAN_ID
, LF_EVENT_OCRD_DT
, FTE
, YEAR
, STOCK1
, STOCK2
, PAY_RATE_CURRENCY
, PAY_BASIS
, PAY_RATE_AMOUNT
, BONUS
, OTHER_COMP
, COMMISSION
, OVERTIME
FROM APPS.BEN_CWB_COMP_HIST_DWLD_V;
APPS.BEN_CWB_COMP_HIST_DWLD_V is not referenced by any database object
|
|
|