DBA Data[Home] [Help] [Dependency Information]

TABLE: BEN.BEN_ELIG_MLTRY_STAT_PRTE_F

Object Details
Object Name: BEN_ELIG_MLTRY_STAT_PRTE_F
Object Type: TABLE
Owner: BEN
FND Design Data: TableBEN.BEN_ELIG_MLTRY_STAT_PRTE_F
Subobject Name:
Status: VALID


BEN_ELIG_MLTRY_STAT_PRTE_F identifies which person military statuses are included in (most typical usage) or excluded from (least typical) an eligibility profile. These criteria must be satisfied in order for the person to be eligible to participate in the compensation object.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: EML_PK
  1. ColumnELIG_MLTRY_STAT_PRTE_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
EML_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnELIG_MLTRY_STAT_PRTE_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
BEN_ELIG_MLTRY_STAT_PRTE_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnELIGY_PRFL_ID
Columns
Name Datatype Length Mandatory Comments
ELIG_MLTRY_STAT_PRTE_ID NUMBER (15) Yes System generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
EXCLD_FLAG VARCHAR2 (30) Yes Exclude Y or N.
ELIGY_PRFL_ID NUMBER (15) Yes Foreign key to BEN_ELIGY_PRFL_F.
MLTRY_STAT_CD VARCHAR2 (30)
Military status.
ORDR_NUM NUMBER (9)
Order number.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ELIG_MLTRY_STAT_PRTE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EXCLD_FLAG
,      ELIGY_PRFL_ID
,      MLTRY_STAT_CD
,      ORDR_NUM
FROM BEN.BEN_ELIG_MLTRY_STAT_PRTE_F;

Dependencies

[top of page]

BEN.BEN_ELIG_MLTRY_STAT_PRTE_F does not reference any database object

BEN.BEN_ELIG_MLTRY_STAT_PRTE_F is referenced by following:

SchemaBEN
ViewBEN_ELIG_MLTRY_STAT_PRTE_F#