[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_SUMMARY# |
---|---|
Object Type: | VIEW |
Owner: | BEN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_ID | NUMBER | (15) | Yes | |
GROUP_PER_IN_LER_ID | NUMBER | (15) | Yes | |
GROUP_PL_ID | NUMBER | (15) | Yes | |
GROUP_OIPL_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (15) | ||
LF_EVT_OCRD_DT | DATE | |||
STATUS | VARCHAR2 | (30) | ||
ELIG_COUNT_DIRECT | NUMBER | (15) | ||
ELIG_COUNT_ALL | NUMBER | (15) | ||
EMP_RECV_COUNT_DIRECT | NUMBER | (15) | ||
EMP_RECV_COUNT_ALL | NUMBER | (15) | ||
ELIG_SAL_VAL_DIRECT | NUMBER | |||
ELIG_SAL_VAL_ALL | NUMBER | |||
WS_VAL_DIRECT | NUMBER | |||
WS_VAL_ALL | NUMBER | |||
WS_BDGT_VAL_DIRECT | NUMBER | |||
WS_BDGT_VAL_ALL | NUMBER | |||
WS_BDGT_ISS_VAL_DIRECT | NUMBER | |||
WS_BDGT_ISS_VAL_ALL | NUMBER | |||
BDGT_VAL_DIRECT | NUMBER | |||
BDGT_ISS_VAL_DIRECT | NUMBER | |||
STAT_SAL_VAL_DIRECT | NUMBER | |||
STAT_SAL_VAL_ALL | NUMBER | |||
OTH_COMP_VAL_DIRECT | NUMBER | |||
OTH_COMP_VAL_ALL | NUMBER | |||
TOT_COMP_VAL_DIRECT | NUMBER | |||
TOT_COMP_VAL_ALL | NUMBER | |||
REC_VAL_DIRECT | NUMBER | |||
REC_VAL_ALL | NUMBER | |||
REC_MN_VAL_DIRECT | NUMBER | |||
REC_MN_VAL_ALL | NUMBER | |||
REC_MX_VAL_DIRECT | NUMBER | |||
REC_MX_VAL_ALL | NUMBER | |||
MISC1_VAL_DIRECT | NUMBER | |||
MISC1_VAL_ALL | NUMBER | |||
MISC2_VAL_DIRECT | NUMBER | |||
MISC2_VAL_ALL | NUMBER | |||
MISC3_VAL_DIRECT | NUMBER | |||
MISC3_VAL_ALL | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT SUMMARY_ID
, GROUP_PER_IN_LER_ID
, GROUP_PL_ID
, GROUP_OIPL_ID
, PERSON_ID
, LF_EVT_OCRD_DT
, STATUS
, ELIG_COUNT_DIRECT
, ELIG_COUNT_ALL
, EMP_RECV_COUNT_DIRECT
, EMP_RECV_COUNT_ALL
, ELIG_SAL_VAL_DIRECT
, ELIG_SAL_VAL_ALL
, WS_VAL_DIRECT
, WS_VAL_ALL
, WS_BDGT_VAL_DIRECT
, WS_BDGT_VAL_ALL
, WS_BDGT_ISS_VAL_DIRECT
, WS_BDGT_ISS_VAL_ALL
, BDGT_VAL_DIRECT
, BDGT_ISS_VAL_DIRECT
, STAT_SAL_VAL_DIRECT
, STAT_SAL_VAL_ALL
, OTH_COMP_VAL_DIRECT
, OTH_COMP_VAL_ALL
, TOT_COMP_VAL_DIRECT
, TOT_COMP_VAL_ALL
, REC_VAL_DIRECT
, REC_VAL_ALL
, REC_MN_VAL_DIRECT
, REC_MN_VAL_ALL
, REC_MX_VAL_DIRECT
, REC_MX_VAL_ALL
, MISC1_VAL_DIRECT
, MISC1_VAL_ALL
, MISC2_VAL_DIRECT
, MISC2_VAL_ALL
, MISC3_VAL_DIRECT
, MISC3_VAL_ALL
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM BEN.BEN_CWB_SUMMARY#;
|
|
|