VIEW: BEN.BEN_CWB_PL_DSGN#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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