[Home] [Help] [Dependency Information]
Object Name: | HRI_EQ_BEN_ELCTN_EVTS# |
---|---|
Object Type: | VIEW |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LF_EVT_OCRD_DT | DATE | |||
EVENT_DATE | VARCHAR2 | (30) | ||
PERSON_ID | NUMBER | (15) | ||
PGM_ID | NUMBER | (15) | ||
ELIG_IND | NUMBER | |||
ENRT_IND | NUMBER | |||
DFLT_IND | NUMBER | |||
EVENT_CD | VARCHAR2 | (30) | ||
DFLT_ENRT_DT | DATE | |||
DFLT_ASND_DT | DATE | |||
ELCNS_MADE_DT | DATE | |||
ENRT_TYP_CYCL_CD | VARCHAR2 | (30) | ||
ENRT_PERD_END_DT | DATE | |||
ENRT_PERD_STRT_DT | DATE | |||
PROCG_END_DT | DATE | |||
PIL_ELCTBL_POPL_STAT_CD | VARCHAR2 | (30) | ||
AUTO_ASND_DT | DATE | |||
FND_CONCURRENT_REQUEST_ID | NUMBER | (15) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | ||
PIL_ELCTBL_CHC_POPL_ID | NUMBER | (15) | ||
PER_IN_LER_ID | NUMBER | (15) | ||
PL_ID | NUMBER | (15) | ||
ENRT_PERD_ID | NUMBER | (15) | ||
ASSIGNMENT_ID | NUMBER | (15) | ||
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 LF_EVT_OCRD_DT
, EVENT_DATE
, PERSON_ID
, PGM_ID
, ELIG_IND
, ENRT_IND
, DFLT_IND
, EVENT_CD
, DFLT_ENRT_DT
, DFLT_ASND_DT
, ELCNS_MADE_DT
, ENRT_TYP_CYCL_CD
, ENRT_PERD_END_DT
, ENRT_PERD_STRT_DT
, PROCG_END_DT
, PIL_ELCTBL_POPL_STAT_CD
, AUTO_ASND_DT
, FND_CONCURRENT_REQUEST_ID
, BUSINESS_GROUP_ID
, PIL_ELCTBL_CHC_POPL_ID
, PER_IN_LER_ID
, PL_ID
, ENRT_PERD_ID
, ASSIGNMENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HRI.HRI_EQ_BEN_ELCTN_EVTS#;
|
|
|