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

VIEW: APPS.BEN_AUTO_ENRT_TERM_V

Object Details
Object Name: BEN_AUTO_ENRT_TERM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BEN_AUTO_ENRT_TERM_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER (15)
Foreign Key to PER_ALL_ASSIGNMENTS_F.
BNFT_AMT NUMBER

Amount.
BNFT_NNMNTRY_UOM VARCHAR2 (30)
Non-monetary unit of measure.
BNFT_ORDR_NUM NUMBER (15)
Order number.
BNFT_TYP_CD VARCHAR2 (30)
Benefit type.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
COMP_LVL_CD VARCHAR2 (30)
Compensation level.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
ENRT_CVG_STRT_DT DATE
Yes Enrollment coverage start date.
ENRT_CVG_THRU_DT DATE
Yes Enrollment coverage through date.
ENRT_MTHD_CD VARCHAR2 (30) Yes Enrollment method.
ENRT_OVRIDN_FLAG VARCHAR2 (30) Yes Enrollment Overriden Y or N.
ENRT_OVRID_RSN_CD VARCHAR2 (30)
Enrollment override reason.
ENRT_OVRID_THRU_DT DATE

Enrollment override through date.
ERLST_DEENRT_DT DATE

Earliest de-enrollment date.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LER_ID NUMBER (15) Yes Foreign Key to BEN_LER_F.
NO_LNGR_ELIG_FLAG VARCHAR2 (30) Yes No Longer Eligible Y or N.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated primary key. Increments by one each update.
OIPL_ID NUMBER (15)
Foreign Key to BEN_OIPL_F.
OIPL_ORDR_NUM NUMBER (15)
Option in plan order number.
ORGNL_ENRT_DT DATE

Original enrollment date.
PEN_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
PEN_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column.
PERSON_ID NUMBER (15) Yes Foreign Key to PER_PEOPLE_F.
PER_IN_LER_ID NUMBER (15)
Foreign Key to BEN_PER_IN_LER.
PGM_ID NUMBER (15)
Foreign key to BEN_PGM_F.
PLIP_ORDR_NUM NUMBER (15)
Plan in program order number.
PL_ID NUMBER (15) Yes Foreign Key to BEN_PL_F.
PL_ORDR_NUM NUMBER (15)
Plan order number.
PL_TYP_ID NUMBER (15)
Foreign key to BEN_PL_TYP_F.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PRTT_ENRT_RSLT_ID NUMBER (15) Yes Foreign key to BEN_PRTT_ENRT_RSLT_F.
PRTT_ENRT_RSLT_STAT_CD VARCHAR2 (30)
Participant enrollment result status.
PRTT_IS_CVRD_FLAG VARCHAR2 (30) Yes Participant Is Covered Y or N.
PTIP_ID NUMBER (15)
Foreign Key to BEN_PTIP_F.
PTIP_ORDR_NUM NUMBER (15)
Plan type in program order number.
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
RPLCS_SSPNDD_RSLT_ID NUMBER (15)
Foreign key to BEN_PRTT_ENRT_RSLT_F.
SSPNDD_FLAG VARCHAR2 (30) Yes Suspended Y or N.
UOM VARCHAR2 (30)
Unit of measure.
Query Text

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


SELECT ASSIGNMENT_ID
,      BNFT_AMT
,      BNFT_NNMNTRY_UOM
,      BNFT_ORDR_NUM
,      BNFT_TYP_CD
,      BUSINESS_GROUP_ID
,      COMP_LVL_CD
,      CREATED_BY
,      CREATION_DATE
,      EFFECTIVE_END_DATE
,      EFFECTIVE_START_DATE
,      ENRT_CVG_STRT_DT
,      ENRT_CVG_THRU_DT
,      ENRT_MTHD_CD
,      ENRT_OVRIDN_FLAG
,      ENRT_OVRID_RSN_CD
,      ENRT_OVRID_THRU_DT
,      ERLST_DEENRT_DT
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LER_ID
,      NO_LNGR_ELIG_FLAG
,      OBJECT_VERSION_NUMBER
,      OIPL_ID
,      OIPL_ORDR_NUM
,      ORGNL_ENRT_DT
,      PEN_ATTRIBUTE1
,      PEN_ATTRIBUTE10
,      PEN_ATTRIBUTE11
,      PEN_ATTRIBUTE12
,      PEN_ATTRIBUTE13
,      PEN_ATTRIBUTE14
,      PEN_ATTRIBUTE15
,      PEN_ATTRIBUTE16
,      PEN_ATTRIBUTE17
,      PEN_ATTRIBUTE18
,      PEN_ATTRIBUTE19
,      PEN_ATTRIBUTE2
,      PEN_ATTRIBUTE20
,      PEN_ATTRIBUTE21
,      PEN_ATTRIBUTE22
,      PEN_ATTRIBUTE23
,      PEN_ATTRIBUTE24
,      PEN_ATTRIBUTE25
,      PEN_ATTRIBUTE26
,      PEN_ATTRIBUTE27
,      PEN_ATTRIBUTE28
,      PEN_ATTRIBUTE29
,      PEN_ATTRIBUTE3
,      PEN_ATTRIBUTE30
,      PEN_ATTRIBUTE4
,      PEN_ATTRIBUTE5
,      PEN_ATTRIBUTE6
,      PEN_ATTRIBUTE7
,      PEN_ATTRIBUTE8
,      PEN_ATTRIBUTE9
,      PEN_ATTRIBUTE_CATEGORY
,      PERSON_ID
,      PER_IN_LER_ID
,      PGM_ID
,      PLIP_ORDR_NUM
,      PL_ID
,      PL_ORDR_NUM
,      PL_TYP_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PRTT_ENRT_RSLT_ID
,      PRTT_ENRT_RSLT_STAT_CD
,      PRTT_IS_CVRD_FLAG
,      PTIP_ID
,      PTIP_ORDR_NUM
,      REQUEST_ID
,      RPLCS_SSPNDD_RSLT_ID
,      SSPNDD_FLAG
,      UOM
FROM APPS.BEN_AUTO_ENRT_TERM_V;

Dependencies

[top of page]

APPS.BEN_AUTO_ENRT_TERM_V references the following:

SchemaAPPS
SynonymBEN_ELIG_PER_F
SynonymBEN_ELIG_PER_OPT_F
SynonymBEN_OIPL_F
SynonymBEN_PRTT_ENRT_RSLT_F

APPS.BEN_AUTO_ENRT_TERM_V is not referenced by any database object