eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: BEN.BEN_CWB_RPT_DETAIL#

Object Details

Object Name:	BEN_CWB_RPT_DETAIL#
Object Type:	VIEW
Owner:	BEN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BENEFIT_ACTION_ID	NUMBER	(15)	Yes
PERSON_RATE_ID	NUMBER	(15)
PL_ID	NUMBER	(15)
PERSON_ID	NUMBER	(15)
OIPL_ID	NUMBER	(15)
GROUP_PL_ID	NUMBER	(15)
WS_MGR_ID	NUMBER	(15)
LF_EVT_OCRD_DT	DATE
FULL_NAME	VARCHAR2	(240)
EMPLOYEE_NUMBER	VARCHAR2	(30)
BUSINESS_GROUP_ID	NUMBER	(15)
BUSINESS_GROUP_NAME	VARCHAR2	(240)
MANAGER_NAME	VARCHAR2	(240)
PL_NAME	VARCHAR2	(240)
OPT_NAME	VARCHAR2	(240)
AMOUNT	NUMBER
UNITS	VARCHAR2	(30)
PERFORMANCE_RATING	VARCHAR2	(30)
ASSIGNMENT_CHANGED_FLAG	VARCHAR2	(30)
STATUS_CD	VARCHAR2	(30)
LF_EVT_CLOSED_FLAG	VARCHAR2	(30)
ERROR_OR_WARNING_TEXT	VARCHAR2	(2000)
CWB_RPT_DETAIL_ID	NUMBER	(15)	Yes
GROUP_PER_IN_LER_ID	NUMBER
GROUP_OIPL_ID	NUMBER
COUNTRY_CODE	VARCHAR2	(30)
BASE_SALARY_CURRENCY	VARCHAR2	(30)
CURRENCY	VARCHAR2	(30)
BASE_SALARY	NUMBER
ELIG_SALARY	NUMBER
PERCENT_OF_ELIG_SAL	NUMBER
BASE_SAL_FREQ	VARCHAR2	(30)
PAY_ANN_FACTOR	NUMBER
PL_ANN_FACTOR	NUMBER
CONVERSION_FACTOR	NUMBER
ADJUSTED_AMOUNT	NUMBER
PREV_SAL	NUMBER
NEW_SAL	NUMBER
PAY_PROPOSAL_ID	NUMBER
PAY_BASIS_ID	NUMBER
ELEMENT_ENTRY_ID	NUMBER
EXCHANGE_RATE	NUMBER
EFFECTIVE_DATE	DATE
REASON	VARCHAR2	(30)
ELIGIBILITY	VARCHAR2	(30)
FTE_FACTOR	NUMBER
ELEMENT_INPUT_VALUE	VARCHAR2	(80)
AMOUNT_POSTED	NUMBER
ASSIGNMENT_ID	NUMBER
ELEMENT_ENTRY_VALUE_ID	NUMBER
INPUT_VALUE_ID	NUMBER
ELEMENT_TYPE_ID	NUMBER
EEV_SCREEN_ENTRY_VALUE	NUMBER
ELMNT_PROCESSING_TYPE	VARCHAR2	(30)
UOM_PRECISION	NUMBER
WS_SUB_ACTY_TYP_CD	VARCHAR2	(30)
POSTED_RATING	VARCHAR2	(30)
RATING_TYPE	VARCHAR2	(30)
RATING_DATE	DATE
PRIOR_JOB	VARCHAR2	(700)
POSTED_JOB	VARCHAR2	(700)
PROPOSED_JOB	VARCHAR2	(700)
PRIOR_POSITION	VARCHAR2	(240)
POSTED_POSITION	VARCHAR2	(240)
PROPOSED_POSITION	VARCHAR2	(240)
PRIOR_GRADE	VARCHAR2	(240)
POSTED_GRADE	VARCHAR2	(240)
PROPOSED_GRADE	VARCHAR2	(240)
PRIOR_GROUP	VARCHAR2	(240)
POSTED_GROUP	VARCHAR2	(240)
PROPOSED_GROUP	VARCHAR2	(240)
ASGN_CHANGE_REASON	VARCHAR2	(30)
PENDING_WORKFLOW	VARCHAR2	(30)
PRIOR_FLEX1	VARCHAR2	(150)
POSTED_FLEX1	VARCHAR2	(150)
PROPOSED_FLEX1	VARCHAR2	(150)
PRIOR_FLEX2	VARCHAR2	(150)
POSTED_FLEX2	VARCHAR2	(150)
PROPOSED_FLEX2	VARCHAR2	(150)
PRIOR_FLEX3	VARCHAR2	(150)
POSTED_FLEX3	VARCHAR2	(150)
PROPOSED_FLEX3	VARCHAR2	(150)
PRIOR_FLEX4	VARCHAR2	(150)
POSTED_FLEX4	VARCHAR2	(150)
PROPOSED_FLEX4	VARCHAR2	(150)
PRIOR_FLEX5	VARCHAR2	(150)
POSTED_FLEX5	VARCHAR2	(150)
PROPOSED_FLEX5	VARCHAR2	(150)
PRIOR_FLEX6	VARCHAR2	(150)
POSTED_FLEX6	VARCHAR2	(150)
PROPOSED_FLEX6	VARCHAR2	(150)
PRIOR_FLEX7	VARCHAR2	(150)
POSTED_FLEX7	VARCHAR2	(150)
PROPOSED_FLEX7	VARCHAR2	(150)
PRIOR_FLEX8	VARCHAR2	(150)
POSTED_FLEX8	VARCHAR2	(150)
PROPOSED_FLEX8	VARCHAR2	(150)
PRIOR_FLEX9	VARCHAR2	(150)
POSTED_FLEX9	VARCHAR2	(150)
PROPOSED_FLEX9	VARCHAR2	(150)
PRIOR_FLEX10	VARCHAR2	(150)
POSTED_FLEX10	VARCHAR2	(150)
PROPOSED_FLEX10	VARCHAR2	(150)
PRIOR_FLEX11	VARCHAR2	(150)
POSTED_FLEX11	VARCHAR2	(150)
PROPOSED_FLEX11	VARCHAR2	(150)
PRIOR_FLEX12	VARCHAR2	(150)
POSTED_FLEX12	VARCHAR2	(150)
PROPOSED_FLEX12	VARCHAR2	(150)
PRIOR_FLEX13	VARCHAR2	(150)
POSTED_FLEX13	VARCHAR2	(150)
PROPOSED_FLEX13	VARCHAR2	(150)
PRIOR_FLEX14	VARCHAR2	(150)
POSTED_FLEX14	VARCHAR2	(150)
PROPOSED_FLEX14	VARCHAR2	(150)
PRIOR_FLEX15	VARCHAR2	(150)
POSTED_FLEX15	VARCHAR2	(150)
PROPOSED_FLEX15	VARCHAR2	(150)
PRIOR_FLEX16	VARCHAR2	(150)
POSTED_FLEX16	VARCHAR2	(150)
PROPOSED_FLEX16	VARCHAR2	(150)
PRIOR_FLEX17	VARCHAR2	(150)
POSTED_FLEX17	VARCHAR2	(150)
PROPOSED_FLEX17	VARCHAR2	(150)
PRIOR_FLEX18	VARCHAR2	(150)
POSTED_FLEX18	VARCHAR2	(150)
PROPOSED_FLEX18	VARCHAR2	(150)
PRIOR_FLEX19	VARCHAR2	(150)
POSTED_FLEX19	VARCHAR2	(150)
PROPOSED_FLEX19	VARCHAR2	(150)
PRIOR_FLEX20	VARCHAR2	(150)
POSTED_FLEX20	VARCHAR2	(150)
PROPOSED_FLEX20	VARCHAR2	(150)
PRIOR_FLEX21	VARCHAR2	(150)
POSTED_FLEX21	VARCHAR2	(150)
PROPOSED_FLEX21	VARCHAR2	(150)
PRIOR_FLEX22	VARCHAR2	(150)
POSTED_FLEX22	VARCHAR2	(150)
PROPOSED_FLEX22	VARCHAR2	(150)
PRIOR_FLEX23	VARCHAR2	(150)
POSTED_FLEX23	VARCHAR2	(150)
PROPOSED_FLEX23	VARCHAR2	(150)
PRIOR_FLEX24	VARCHAR2	(150)
POSTED_FLEX24	VARCHAR2	(150)
PROPOSED_FLEX24	VARCHAR2	(150)
PRIOR_FLEX25	VARCHAR2	(150)
POSTED_FLEX25	VARCHAR2	(150)
PROPOSED_FLEX25	VARCHAR2	(150)
PRIOR_FLEX26	VARCHAR2	(150)
POSTED_FLEX26	VARCHAR2	(150)
PROPOSED_FLEX26	VARCHAR2	(150)
PRIOR_FLEX27	VARCHAR2	(150)
POSTED_FLEX27	VARCHAR2	(150)
PROPOSED_FLEX27	VARCHAR2	(150)
PRIOR_FLEX28	VARCHAR2	(150)
POSTED_FLEX28	VARCHAR2	(150)
PROPOSED_FLEX28	VARCHAR2	(150)
PRIOR_FLEX29	VARCHAR2	(150)
POSTED_FLEX29	VARCHAR2	(150)
PROPOSED_FLEX29	VARCHAR2	(150)
PRIOR_FLEX30	VARCHAR2	(150)
POSTED_FLEX30	VARCHAR2	(150)
PROPOSED_FLEX30	VARCHAR2	(150)
NEW_RPT	VARCHAR2	(1)
PREV_EEV_SCREEN_ENTRY_VALUE	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BENEFIT_ACTION_ID
,      PERSON_RATE_ID
,      PL_ID
,      PERSON_ID
,      OIPL_ID
,      GROUP_PL_ID
,      WS_MGR_ID
,      LF_EVT_OCRD_DT
,      FULL_NAME
,      EMPLOYEE_NUMBER
,      BUSINESS_GROUP_ID
,      BUSINESS_GROUP_NAME
,      MANAGER_NAME
,      PL_NAME
,      OPT_NAME
,      AMOUNT
,      UNITS
,      PERFORMANCE_RATING
,      ASSIGNMENT_CHANGED_FLAG
,      STATUS_CD
,      LF_EVT_CLOSED_FLAG
,      ERROR_OR_WARNING_TEXT
,      CWB_RPT_DETAIL_ID
,      GROUP_PER_IN_LER_ID
,      GROUP_OIPL_ID
,      COUNTRY_CODE
,      BASE_SALARY_CURRENCY
,      CURRENCY
,      BASE_SALARY
,      ELIG_SALARY
,      PERCENT_OF_ELIG_SAL
,      BASE_SAL_FREQ
,      PAY_ANN_FACTOR
,      PL_ANN_FACTOR
,      CONVERSION_FACTOR
,      ADJUSTED_AMOUNT
,      PREV_SAL
,      NEW_SAL
,      PAY_PROPOSAL_ID
,      PAY_BASIS_ID
,      ELEMENT_ENTRY_ID
,      EXCHANGE_RATE
,      EFFECTIVE_DATE
,      REASON
,      ELIGIBILITY
,      FTE_FACTOR
,      ELEMENT_INPUT_VALUE
,      AMOUNT_POSTED
,      ASSIGNMENT_ID
,      ELEMENT_ENTRY_VALUE_ID
,      INPUT_VALUE_ID
,      ELEMENT_TYPE_ID
,      EEV_SCREEN_ENTRY_VALUE
,      ELMNT_PROCESSING_TYPE
,      UOM_PRECISION
,      WS_SUB_ACTY_TYP_CD
,      POSTED_RATING
,      RATING_TYPE
,      RATING_DATE
,      PRIOR_JOB
,      POSTED_JOB
,      PROPOSED_JOB
,      PRIOR_POSITION
,      POSTED_POSITION
,      PROPOSED_POSITION
,      PRIOR_GRADE
,      POSTED_GRADE
,      PROPOSED_GRADE
,      PRIOR_GROUP
,      POSTED_GROUP
,      PROPOSED_GROUP
,      ASGN_CHANGE_REASON
,      PENDING_WORKFLOW
,      PRIOR_FLEX1
,      POSTED_FLEX1
,      PROPOSED_FLEX1
,      PRIOR_FLEX2
,      POSTED_FLEX2
,      PROPOSED_FLEX2
,      PRIOR_FLEX3
,      POSTED_FLEX3
,      PROPOSED_FLEX3
,      PRIOR_FLEX4
,      POSTED_FLEX4
,      PROPOSED_FLEX4
,      PRIOR_FLEX5
,      POSTED_FLEX5
,      PROPOSED_FLEX5
,      PRIOR_FLEX6
,      POSTED_FLEX6
,      PROPOSED_FLEX6
,      PRIOR_FLEX7
,      POSTED_FLEX7
,      PROPOSED_FLEX7
,      PRIOR_FLEX8
,      POSTED_FLEX8
,      PROPOSED_FLEX8
,      PRIOR_FLEX9
,      POSTED_FLEX9
,      PROPOSED_FLEX9
,      PRIOR_FLEX10
,      POSTED_FLEX10
,      PROPOSED_FLEX10
,      PRIOR_FLEX11
,      POSTED_FLEX11
,      PROPOSED_FLEX11
,      PRIOR_FLEX12
,      POSTED_FLEX12
,      PROPOSED_FLEX12
,      PRIOR_FLEX13
,      POSTED_FLEX13
,      PROPOSED_FLEX13
,      PRIOR_FLEX14
,      POSTED_FLEX14
,      PROPOSED_FLEX14
,      PRIOR_FLEX15
,      POSTED_FLEX15
,      PROPOSED_FLEX15
,      PRIOR_FLEX16
,      POSTED_FLEX16
,      PROPOSED_FLEX16
,      PRIOR_FLEX17
,      POSTED_FLEX17
,      PROPOSED_FLEX17
,      PRIOR_FLEX18
,      POSTED_FLEX18
,      PROPOSED_FLEX18
,      PRIOR_FLEX19
,      POSTED_FLEX19
,      PROPOSED_FLEX19
,      PRIOR_FLEX20
,      POSTED_FLEX20
,      PROPOSED_FLEX20
,      PRIOR_FLEX21
,      POSTED_FLEX21
,      PROPOSED_FLEX21
,      PRIOR_FLEX22
,      POSTED_FLEX22
,      PROPOSED_FLEX22
,      PRIOR_FLEX23
,      POSTED_FLEX23
,      PROPOSED_FLEX23
,      PRIOR_FLEX24
,      POSTED_FLEX24
,      PROPOSED_FLEX24
,      PRIOR_FLEX25
,      POSTED_FLEX25
,      PROPOSED_FLEX25
,      PRIOR_FLEX26
,      POSTED_FLEX26
,      PROPOSED_FLEX26
,      PRIOR_FLEX27
,      POSTED_FLEX27
,      PROPOSED_FLEX27
,      PRIOR_FLEX28
,      POSTED_FLEX28
,      PROPOSED_FLEX28
,      PRIOR_FLEX29
,      POSTED_FLEX29
,      PROPOSED_FLEX29
,      PRIOR_FLEX30
,      POSTED_FLEX30
,      PROPOSED_FLEX30
,      NEW_RPT
,      PREV_EEV_SCREEN_ENTRY_VALUE
FROM BEN.BEN_CWB_RPT_DETAIL#;

Dependencies

[top of page]

BEN.BEN_CWB_RPT_DETAIL# references the following:

BEN: BEN_CWB_RPT_DETAIL

BEN.BEN_CWB_RPT_DETAIL# is referenced by following:

APPS: BEN_CWB_RPT_DETAIL