[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_PERSON_RATES# |
---|---|
Object Type: | VIEW |
Owner: | BEN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_RATE_ID | NUMBER | (15) | Yes | |
GROUP_PER_IN_LER_ID | NUMBER | (15) | Yes | |
PL_ID | NUMBER | (15) | Yes | |
OIPL_ID | NUMBER | (15) | ||
GROUP_PL_ID | NUMBER | (15) | Yes | |
GROUP_OIPL_ID | NUMBER | (15) | ||
LF_EVT_OCRD_DT | DATE | Yes | ||
PERSON_ID | NUMBER | (15) | ||
ASSIGNMENT_ID | NUMBER | (15) | ||
ELIG_FLAG | VARCHAR2 | (30) | ||
WS_VAL | NUMBER | |||
WS_MN_VAL | NUMBER | |||
WS_MX_VAL | NUMBER | |||
WS_INCR_VAL | NUMBER | |||
ELIG_SAL_VAL | NUMBER | |||
STAT_SAL_VAL | NUMBER | |||
OTH_COMP_VAL | NUMBER | |||
TOT_COMP_VAL | NUMBER | |||
MISC1_VAL | NUMBER | |||
MISC2_VAL | NUMBER | |||
MISC3_VAL | NUMBER | |||
REC_VAL | NUMBER | |||
REC_MN_VAL | NUMBER | |||
REC_MX_VAL | NUMBER | |||
REC_INCR_VAL | NUMBER | |||
WS_VAL_LAST_UPD_DATE | DATE | |||
WS_VAL_LAST_UPD_BY | NUMBER | (15) | ||
PAY_PROPOSAL_ID | NUMBER | (15) | ||
ELEMENT_ENTRY_VALUE_ID | NUMBER | (15) | ||
INELIG_RSN_CD | VARCHAR2 | (30) | ||
ELIG_OVRID_DT | DATE | |||
ELIG_OVRID_PERSON_ID | NUMBER | (15) | ||
COPY_DIST_BDGT_VAL | NUMBER | |||
COPY_WS_BDGT_VAL | NUMBER | |||
COPY_RSRV_VAL | NUMBER | |||
COPY_DIST_BDGT_MN_VAL | NUMBER | |||
COPY_DIST_BDGT_MX_VAL | NUMBER | |||
COPY_DIST_BDGT_INCR_VAL | NUMBER | |||
COPY_WS_BDGT_MN_VAL | NUMBER | |||
COPY_WS_BDGT_MX_VAL | NUMBER | |||
COPY_WS_BDGT_INCR_VAL | NUMBER | |||
COPY_RSRV_MN_VAL | NUMBER | |||
COPY_RSRV_MX_VAL | NUMBER | |||
COPY_RSRV_INCR_VAL | NUMBER | |||
COPY_DIST_BDGT_ISS_VAL | NUMBER | |||
COPY_WS_BDGT_ISS_VAL | NUMBER | |||
COPY_DIST_BDGT_ISS_DATE | DATE | |||
COPY_WS_BDGT_ISS_DATE | DATE | |||
COMP_POSTING_DATE | DATE | |||
WS_RT_START_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CURRENCY | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_RATE_ID
, GROUP_PER_IN_LER_ID
, PL_ID
, OIPL_ID
, GROUP_PL_ID
, GROUP_OIPL_ID
, LF_EVT_OCRD_DT
, PERSON_ID
, ASSIGNMENT_ID
, ELIG_FLAG
, WS_VAL
, WS_MN_VAL
, WS_MX_VAL
, WS_INCR_VAL
, ELIG_SAL_VAL
, STAT_SAL_VAL
, OTH_COMP_VAL
, TOT_COMP_VAL
, MISC1_VAL
, MISC2_VAL
, MISC3_VAL
, REC_VAL
, REC_MN_VAL
, REC_MX_VAL
, REC_INCR_VAL
, WS_VAL_LAST_UPD_DATE
, WS_VAL_LAST_UPD_BY
, PAY_PROPOSAL_ID
, ELEMENT_ENTRY_VALUE_ID
, INELIG_RSN_CD
, ELIG_OVRID_DT
, ELIG_OVRID_PERSON_ID
, COPY_DIST_BDGT_VAL
, COPY_WS_BDGT_VAL
, COPY_RSRV_VAL
, COPY_DIST_BDGT_MN_VAL
, COPY_DIST_BDGT_MX_VAL
, COPY_DIST_BDGT_INCR_VAL
, COPY_WS_BDGT_MN_VAL
, COPY_WS_BDGT_MX_VAL
, COPY_WS_BDGT_INCR_VAL
, COPY_RSRV_MN_VAL
, COPY_RSRV_MX_VAL
, COPY_RSRV_INCR_VAL
, COPY_DIST_BDGT_ISS_VAL
, COPY_WS_BDGT_ISS_VAL
, COPY_DIST_BDGT_ISS_DATE
, COPY_WS_BDGT_ISS_DATE
, COMP_POSTING_DATE
, WS_RT_START_DATE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, CURRENCY
FROM BEN.BEN_CWB_PERSON_RATES#;
|
|
|