[Home] [Help] [Dependency Information]
Object Name: | HRI_EQ_BEN_ELCTN_EVTS |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
This table stores the data related to the Benefits that will be used in HRI.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_EQ_BEN_ELCTN_EVTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PER_IN_LER_ID
PGM_ID EVENT_CD |
HRI_EQ_BEN_ELCTN_EVTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LF_EVT_OCRD_DT | DATE | LF_EVT_OCRD_DT | ||
EVENT_DATE | VARCHAR2 | (30) | EVENT_DATE | |
PERSON_ID | NUMBER | (15) | PERSON_ID | |
PGM_ID | NUMBER | (15) | PGM ID | |
ELIG_IND | NUMBER | ELIG_IND | ||
ENRT_IND | NUMBER | ENRT_IND | ||
DFLT_IND | NUMBER | DFLT_IND | ||
EVENT_CD | VARCHAR2 | (30) | EVENT_CD | |
DFLT_ENRT_DT | DATE | DFLT_ENRT_DT | ||
DFLT_ASND_DT | DATE | DFLT_ASND_DT | ||
ELCNS_MADE_DT | DATE | ELCNS_MADE_DT | ||
ENRT_TYP_CYCL_CD | VARCHAR2 | (30) | ENRT_TYP_CYCL_CD | |
ENRT_PERD_END_DT | DATE | ENRT_PERD_END_DT | ||
ENRT_PERD_STRT_DT | DATE | ENRT_PERD_STRT_DT | ||
PROCG_END_DT | DATE | PROCG_END_DT | ||
PIL_ELCTBL_POPL_STAT_CD | VARCHAR2 | (30) | PIL_ELCTBL_POPL_STAT_CD | |
AUTO_ASND_DT | DATE | AUTO_ASND_DT | ||
FND_CONCURRENT_REQUEST_ID | NUMBER | (15) | FND_CONCURRENT_REQUEST_ID | |
BUSINESS_GROUP_ID | NUMBER | (15) | BUSINESS_GROUP_ID | |
PIL_ELCTBL_CHC_POPL_ID | NUMBER | (15) | PIL_ELCTBL_CHC_POPL_ID | |
PER_IN_LER_ID | NUMBER | (15) | PER_IN_LER_ID | |
PL_ID | NUMBER | (15) | PL ID | |
ENRT_PERD_ID | NUMBER | (15) | ENRT_PERD_ID | |
ASSIGNMENT_ID | NUMBER | (15) | ASSIGNMENT_ID | |
LAST_UPDATE_DATE | DATE | LAST_UPDATE_DATE | ||
LAST_UPDATED_BY | NUMBER | (15) | LAST_UPDATED_BY | |
LAST_UPDATE_LOGIN | NUMBER | (15) | LAST_UPDATE_LOGIN | |
CREATED_BY | NUMBER | (15) | CREATED_BY | |
CREATION_DATE | DATE | CREATION_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;
HRI.HRI_EQ_BEN_ELCTN_EVTS does not reference any database object
HRI.HRI_EQ_BEN_ELCTN_EVTS is referenced by following:
|
|
|