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

TABLE: BEN.BEN_CWB_RPT_DETAIL

Object Details
Object Name: BEN_CWB_RPT_DETAIL
Object Type: TABLE
Owner: BEN
FND Design Data: TableBEN.BEN_CWB_RPT_DETAIL
Subobject Name:
Status: VALID


Stores the processing detail for each worker when the CWB post process is run for a CWB Plan


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CWB_RPT_DETAIL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCWB_RPT_DETAIL_ID
BEN_CWB_RPT_DETAIL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
BEN_CWB_RPT_DETAIL_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOUNTRY_CODE
BEN_CWB_RPT_DETAIL_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCURRENCY
BEN_CWB_RPT_DETAIL_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_RATE_ID
BEN_CWB_RPT_DETAIL_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_BASIS_ID
BEN_CWB_RPT_DETAIL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFULL_NAME
BEN_CWB_RPT_DETAIL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEMPLOYEE_NUMBER
BEN_CWB_RPT_DETAIL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLF_EVT_OCRD_DT
BEN_CWB_RPT_DETAIL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBASE_SALARY_CURRENCY
BEN_CWB_RPT_DETAIL_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_CHANGED_FLAG
BEN_CWB_RPT_DETAIL_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERFORMANCE_RATING
BEN_CWB_RPT_DETAIL_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBASE_SAL_FREQ
BEN_CWB_RPT_DETAIL_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnELIGIBILITY
CWB_RPT_DETAIL_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
CWB_RPT_DETAIL_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPL_ID
CWB_RPT_DETAIL_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_PL_ID
CWB_RPT_DETAIL_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS_CD
CWB_RPT_DETAIL_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
BENEFIT_ACTION_ID NUMBER (15) Yes Foreign key to BEN_BENEFIT_ACTION.
PERSON_RATE_ID NUMBER (15)
Foreign key to BEN_CWB_PERSON_RATES.
PL_ID NUMBER (15)
Foreign key to BEN_PL_F.
PERSON_ID NUMBER (15)
Foreign key to PER_PEOPLE_F.
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
GROUP_PL_ID NUMBER (15)
Foreign Key to BEN_PER_LER_F
WS_MGR_ID NUMBER (15)
Worksheet Manager Id
LF_EVT_OCRD_DT DATE

Life Event Occured date
FULL_NAME VARCHAR2 (240)
Person's full name
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee Number
BUSINESS_GROUP_ID NUMBER (15)
Business Group Id
BUSINESS_GROUP_NAME VARCHAR2 (240)
Business Group Name
MANAGER_NAME VARCHAR2 (240)
Worksheet Manager Name
PL_NAME VARCHAR2 (240)
Plan Name
OPT_NAME VARCHAR2 (240)
Option Name
AMOUNT NUMBER

Worksheet Amount
UNITS VARCHAR2 (30)
Units of measure
PERFORMANCE_RATING VARCHAR2 (30)
Performance rating
ASSIGNMENT_CHANGED_FLAG VARCHAR2 (30)
Is Assignment Changed
STATUS_CD VARCHAR2 (30)
Status
LF_EVT_CLOSED_FLAG VARCHAR2 (30)
Is life event closed
ERROR_OR_WARNING_TEXT VARCHAR2 (2000)
Error or warning text
CWB_RPT_DETAIL_ID NUMBER (15) Yes System generated primary key column.
GROUP_PER_IN_LER_ID NUMBER

Person Life event
GROUP_OIPL_ID NUMBER

Group Option
COUNTRY_CODE VARCHAR2 (30)
Country
BASE_SALARY_CURRENCY VARCHAR2 (30)
Currency of Base salary
CURRENCY VARCHAR2 (30)
Currency
BASE_SALARY NUMBER

Base Salary
ELIG_SALARY NUMBER

Eligible Salary
PERCENT_OF_ELIG_SAL NUMBER

Percentage of eligible salary
BASE_SAL_FREQ VARCHAR2 (30)
Frequency of Base salary
PAY_ANN_FACTOR NUMBER

Annualization Factor
PL_ANN_FACTOR NUMBER

Plan annualization factor
CONVERSION_FACTOR NUMBER

Conversion factor
ADJUSTED_AMOUNT NUMBER

Adjusted amount
PREV_SAL NUMBER

Previous salary
NEW_SAL NUMBER

New Salary
PAY_PROPOSAL_ID NUMBER

References PER_PAY_PROPOSALS
PAY_BASIS_ID NUMBER

References PER_PAY_BASES
ELEMENT_ENTRY_ID NUMBER

References PAY_ELEMENT_ENTRIES_F
EXCHANGE_RATE NUMBER

Exchange Rate
EFFECTIVE_DATE DATE

Effective Date
REASON VARCHAR2 (30)
Reason
ELIGIBILITY VARCHAR2 (30)
Eligibility
FTE_FACTOR NUMBER

Full Time Equivalent
ELEMENT_INPUT_VALUE VARCHAR2 (80)
Element Input Value
AMOUNT_POSTED NUMBER

Posted Amount
ASSIGNMENT_ID NUMBER

References PER_ALL_ASSIGNMENTS_F
ELEMENT_ENTRY_VALUE_ID NUMBER

References PAY_ELEMENT_ENTRY_VALUES_F
INPUT_VALUE_ID NUMBER

References PAY_INPUT_VALUES_F
ELEMENT_TYPE_ID NUMBER

References PAY_ELEMENT_TYPES_F
EEV_SCREEN_ENTRY_VALUE NUMBER

Element Entry screen entry value
ELMNT_PROCESSING_TYPE VARCHAR2 (30)
Element Processing type (recurring or non-recurring)
UOM_PRECISION NUMBER

Unit of measure
WS_SUB_ACTY_TYP_CD VARCHAR2 (30)
Worksheet sub-activity type code
POSTED_RATING VARCHAR2 (30)
Posted Rating
RATING_TYPE VARCHAR2 (30)
Rating Type
RATING_DATE DATE

Rating Date
PRIOR_JOB VARCHAR2 (700)
Prior Job
POSTED_JOB VARCHAR2 (700)
Posted Job
PROPOSED_JOB VARCHAR2 (700)
Proposed Job
PRIOR_POSITION VARCHAR2 (240)
Prior Position
POSTED_POSITION VARCHAR2 (240)
Posted Position
PROPOSED_POSITION VARCHAR2 (240)
Proposed Position
PRIOR_GRADE VARCHAR2 (240)
Prior Grade
POSTED_GRADE VARCHAR2 (240)
Posted Grade
PROPOSED_GRADE VARCHAR2 (240)
Proposed Grade
PRIOR_GROUP VARCHAR2 (240)
Prior Group
POSTED_GROUP VARCHAR2 (240)
Posted Group
PROPOSED_GROUP VARCHAR2 (240)
Proposed Group
ASGN_CHANGE_REASON VARCHAR2 (30)
Assignment Change reason
PENDING_WORKFLOW VARCHAR2 (30)
Pending workflow completion
PRIOR_FLEX1 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX1 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX1 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX2 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX2 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX2 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX3 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX3 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX3 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX4 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX4 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX4 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX5 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX5 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX5 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX6 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX6 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX6 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX7 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX7 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX7 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX8 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX8 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX8 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX9 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX9 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX9 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX10 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX10 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX10 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX11 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX11 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX11 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX12 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX12 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX12 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX13 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX13 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX13 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX14 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX14 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX14 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX15 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX15 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX15 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX16 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX16 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX16 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX17 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX17 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX17 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX18 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX18 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX18 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX19 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX19 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX19 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX20 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX20 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX20 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX21 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX21 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX21 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX22 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX22 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX22 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX23 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX23 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX23 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX24 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX24 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX24 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX25 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX25 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX25 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX26 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX26 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX26 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX27 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX27 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX27 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX28 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX28 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX28 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX29 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX29 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX29 VARCHAR2 (150)
Proposed Flex field attribute
PRIOR_FLEX30 VARCHAR2 (150)
Prior Flex field attribute
POSTED_FLEX30 VARCHAR2 (150)
Posted Flex field attribute
PROPOSED_FLEX30 VARCHAR2 (150)
Proposed Flex field attribute
NEW_RPT VARCHAR2 (1)
Flag to determine the use of New report
PREV_EEV_SCREEN_ENTRY_VALUE NUMBER

Previous screen entry value for the element
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 does not reference any database object

BEN.BEN_CWB_RPT_DETAIL is referenced by following:

SchemaAPPS
SynonymBEN_CWB_RPT_DETAIL