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

TABLE: BEN.BEN_CWB_PL_DSGN

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


Stores the denormalized plan and option details for the CWB Plan.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BEN_CWB_PL_DSGN_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPL_ID
ColumnLF_EVT_OCRD_DT
ColumnOIPL_ID
BEN_CWB_PL_DSGN_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_PL_ID
ColumnGROUP_OIPL_ID
Columns
Name Datatype Length Mandatory Comments
PL_ID NUMBER (15) Yes Name
LF_EVT_OCRD_DT DATE
Yes Life Event Occured on Date
OIPL_ID NUMBER (15) Yes Option
EFFECTIVE_DATE DATE

Effective Date
NAME VARCHAR2 (240)
Name
GROUP_PL_ID NUMBER (15)
Group Plan
GROUP_OIPL_ID NUMBER (15)
Group Option
OPT_HIDDEN_FLAG VARCHAR2 (30)
Option Hidden Flag
OPT_ID NUMBER (15)
Option
PL_UOM VARCHAR2 (30)
Plan UOM
PL_ORDR_NUM NUMBER (15)
Plan Order
OIPL_ORDR_NUM NUMBER (15)
Option Order
PL_XCHG_RATE NUMBER

Plan Exchange Rate
OPT_COUNT NUMBER (3)
Option Count
USES_BDGT_FLAG VARCHAR2 (30)
Uses Budget
PRSRV_BDGT_CD VARCHAR2 (30)
Preserve Budget Code
UPD_START_DT DATE

Update Start Date
UPD_END_DT DATE

Update End Date
APPROVAL_MODE VARCHAR2 (30)
Approval Mode
ENRT_PERD_START_DT DATE

Enrollment Period Start Date
ENRT_PERD_END_DT DATE

Enrollment Period End Date
YR_PERD_START_DT DATE

Year Period Start Date
YR_PERD_END_DT DATE

Year Period End Date
WTHN_YR_START_DT DATE

Within Year Start Date
WTHN_YR_END_DT DATE

Within Year End Date
ENRT_PERD_ID NUMBER (15)
Enrollment Period
YR_PERD_ID NUMBER (15)
Year Period
BUSINESS_GROUP_ID NUMBER (15)
Performance Rating Update Date
PERF_REVW_STRT_DT DATE

Assignment Update Date
ASG_UPDT_EFF_DATE DATE

Assignment Update Date
EMP_INTERVIEW_TYP_CD VARCHAR2 (30)
Performance Rating Type
SALARY_CHANGE_REASON VARCHAR2 (30)
Salary Change Reason
WS_ABR_ID NUMBER (15)
Worksheet Rate
WS_NNMNTRY_UOM VARCHAR2 (30)
Worksheet Rate Non-Monetary UOM
WS_RNDG_CD VARCHAR2 (30)
Worksheet Rate Rounding Code
WS_SUB_ACTY_TYP_CD VARCHAR2 (30)
Worksheet Rate Sub Activity Type Code
DIST_BDGT_ABR_ID NUMBER (15)
Distribution Budget Rate
DIST_BDGT_NNMNTRY_UOM VARCHAR2 (30)
Distribution Budget Rate Non-Monetary UOM
DIST_BDGT_RNDG_CD VARCHAR2 (30)
Distribution Budget Rate Rounding Code
WS_BDGT_ABR_ID NUMBER (15)
Worksheet Budget Rate
WS_BDGT_NNMNTRY_UOM VARCHAR2 (30)
Worksheet Budget Rate Non-Monetary UOM
WS_BDGT_RNDG_CD VARCHAR2 (30)
Worksheet Budget Rate Rounding Code
RSRV_ABR_ID NUMBER (15)
Reserve Budget Rate
RSRV_NNMNTRY_UOM VARCHAR2 (30)
Reserve Budget Rate Non-Monetary UOM
RSRV_RNDG_CD VARCHAR2 (30)
Reserve Budget Rate Rounding Code
ELIG_SAL_ABR_ID NUMBER (15)
Eligible Salary Rate
ELIG_SAL_NNMNTRY_UOM VARCHAR2 (30)
Eligible Salary Rate Non-Monetary UOM
ELIG_SAL_RNDG_CD VARCHAR2 (30)
Eligible Salary Rate Rounding Code
MISC1_ABR_ID NUMBER (15)
Miscellaneous 1 Rate
MISC1_NNMNTRY_UOM VARCHAR2 (30)
Miscellaneous 1 Rate Non-Monetary UOM
MISC1_RNDG_CD VARCHAR2 (30)
Miscellaneous 1 Rate Rounding Code
MISC2_ABR_ID NUMBER (15)
Miscellaneous 2 Rate
MISC2_NNMNTRY_UOM VARCHAR2 (30)
Miscellaneous 2 Rate Non-Monetary UOM
MISC2_RNDG_CD VARCHAR2 (30)
Miscellaneous 2 Rate Rounding Code
MISC3_ABR_ID NUMBER (15)
Miscellaneous 3 Rate
MISC3_NNMNTRY_UOM VARCHAR2 (30)
Miscellaneous 3 Rate Non-Monetary UOM
MISC3_RNDG_CD VARCHAR2 (30)
Miscellaneous 3 Rate Rounding Code
STAT_SAL_ABR_ID NUMBER (15)
Stated Salary Rate
STAT_SAL_NNMNTRY_UOM VARCHAR2 (30)
Stated Salary Rate Non-Monetary UOM
STAT_SAL_RNDG_CD VARCHAR2 (30)
Stated Salary Rate Rounding Code
REC_ABR_ID NUMBER (15)
Recommended Rate
REC_NNMNTRY_UOM VARCHAR2 (30)
Recommended Rate Non-Monetary UOM
REC_RNDG_CD VARCHAR2 (30)
Recommended Rate Rounding Code
TOT_COMP_ABR_ID NUMBER (15)
Total Compensation
TOT_COMP_NNMNTRY_UOM VARCHAR2 (30)
Total Compensation Non-Monetary UOM
TOT_COMP_RNDG_CD VARCHAR2 (30)
Total Compensation Rounding Code
OTH_COMP_ABR_ID NUMBER (15)
Other Compensation
OTH_COMP_NNMNTRY_UOM VARCHAR2 (30)
Other Compensation Non-Monetary UOM
OTH_COMP_RNDG_CD VARCHAR2 (30)
Other Compensation Rounding Code
ACTUAL_FLAG VARCHAR2 (30)
Actual
ACTY_REF_PERD_CD VARCHAR2 (30)
Activity Reference Period
LEGISLATION_CODE VARCHAR2 (30)
Legislation Code
PL_ANNULIZATION_FACTOR NUMBER

Plan Annualization Factor
PL_STAT_CD VARCHAR2 (30)
Plan Status
WS_AMT_EDIT_CD VARCHAR2 (30)
Worksheet amount edit.
WS_AMT_EDIT_ENF_CD_FOR_NULLS VARCHAR2 (30)
Worksheet amount edit enforcement for null values.
WS_OVER_BUDGET_EDIT_CD VARCHAR2 (30)
Worksheet over budget edit
WS_OVER_BUDGET_TOLERANCE_PCT NUMBER

Worksheet over budget tolerance percentage
BDGT_OVER_BUDGET_EDIT_CD VARCHAR2 (30)
Distribution budget over budget code
BDGT_OVER_BUDGET_TOLERANCE_PCT NUMBER

Distribution budget over budget percentage
UOM_PRECISION NUMBER

UOM Precision
WS_ELEMENT_TYPE_ID NUMBER (15)
Worksheet Element Type
DATA_FREEZE_DATE DATE

Data Freeze date for capturing HR Information
AUTO_DISTR_FLAG VARCHAR2 (30)
Automatic Distribution.
PQH_DOCUMENT_SHORT_NAME VARCHAR2 (30)
PQH Document Short Name
OBJECT_VERSION_NUMBER NUMBER (9)
Standard Change indicator column
WS_INPUT_VALUE_ID NUMBER (15)
Worksheet Input Value
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER (15)
Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
CREATED_BY NUMBER (15)
Standard WHO Column
CREATION_DATE DATE

Standard WHO Column
OVRID_RT_STRT_DT DATE

Override Rate Start Date
OVR_PERF_REVW_STRT_DT DATE

Override Performance Review Start Date
DO_NOT_PROCESS_FLAG VARCHAR2 (30)
Post Process Flag
Query Text

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


SELECT PL_ID
,      LF_EVT_OCRD_DT
,      OIPL_ID
,      EFFECTIVE_DATE
,      NAME
,      GROUP_PL_ID
,      GROUP_OIPL_ID
,      OPT_HIDDEN_FLAG
,      OPT_ID
,      PL_UOM
,      PL_ORDR_NUM
,      OIPL_ORDR_NUM
,      PL_XCHG_RATE
,      OPT_COUNT
,      USES_BDGT_FLAG
,      PRSRV_BDGT_CD
,      UPD_START_DT
,      UPD_END_DT
,      APPROVAL_MODE
,      ENRT_PERD_START_DT
,      ENRT_PERD_END_DT
,      YR_PERD_START_DT
,      YR_PERD_END_DT
,      WTHN_YR_START_DT
,      WTHN_YR_END_DT
,      ENRT_PERD_ID
,      YR_PERD_ID
,      BUSINESS_GROUP_ID
,      PERF_REVW_STRT_DT
,      ASG_UPDT_EFF_DATE
,      EMP_INTERVIEW_TYP_CD
,      SALARY_CHANGE_REASON
,      WS_ABR_ID
,      WS_NNMNTRY_UOM
,      WS_RNDG_CD
,      WS_SUB_ACTY_TYP_CD
,      DIST_BDGT_ABR_ID
,      DIST_BDGT_NNMNTRY_UOM
,      DIST_BDGT_RNDG_CD
,      WS_BDGT_ABR_ID
,      WS_BDGT_NNMNTRY_UOM
,      WS_BDGT_RNDG_CD
,      RSRV_ABR_ID
,      RSRV_NNMNTRY_UOM
,      RSRV_RNDG_CD
,      ELIG_SAL_ABR_ID
,      ELIG_SAL_NNMNTRY_UOM
,      ELIG_SAL_RNDG_CD
,      MISC1_ABR_ID
,      MISC1_NNMNTRY_UOM
,      MISC1_RNDG_CD
,      MISC2_ABR_ID
,      MISC2_NNMNTRY_UOM
,      MISC2_RNDG_CD
,      MISC3_ABR_ID
,      MISC3_NNMNTRY_UOM
,      MISC3_RNDG_CD
,      STAT_SAL_ABR_ID
,      STAT_SAL_NNMNTRY_UOM
,      STAT_SAL_RNDG_CD
,      REC_ABR_ID
,      REC_NNMNTRY_UOM
,      REC_RNDG_CD
,      TOT_COMP_ABR_ID
,      TOT_COMP_NNMNTRY_UOM
,      TOT_COMP_RNDG_CD
,      OTH_COMP_ABR_ID
,      OTH_COMP_NNMNTRY_UOM
,      OTH_COMP_RNDG_CD
,      ACTUAL_FLAG
,      ACTY_REF_PERD_CD
,      LEGISLATION_CODE
,      PL_ANNULIZATION_FACTOR
,      PL_STAT_CD
,      WS_AMT_EDIT_CD
,      WS_AMT_EDIT_ENF_CD_FOR_NULLS
,      WS_OVER_BUDGET_EDIT_CD
,      WS_OVER_BUDGET_TOLERANCE_PCT
,      BDGT_OVER_BUDGET_EDIT_CD
,      BDGT_OVER_BUDGET_TOLERANCE_PCT
,      UOM_PRECISION
,      WS_ELEMENT_TYPE_ID
,      DATA_FREEZE_DATE
,      AUTO_DISTR_FLAG
,      PQH_DOCUMENT_SHORT_NAME
,      OBJECT_VERSION_NUMBER
,      WS_INPUT_VALUE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OVRID_RT_STRT_DT
,      OVR_PERF_REVW_STRT_DT
,      DO_NOT_PROCESS_FLAG
FROM BEN.BEN_CWB_PL_DSGN;

Dependencies

[top of page]

BEN.BEN_CWB_PL_DSGN does not reference any database object

BEN.BEN_CWB_PL_DSGN is referenced by following:

SchemaAPPS
SynonymBEN_CWB_PL_DSGN
TriggerBEN_CWB_PL_DSGN_WHO