eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BEN.BEN_BENEFIT_ACTIONS

Object Details

Object Name:	BEN_BENEFIT_ACTIONS
Object Type:	TABLE
Owner:	BEN
FND Design Data:	BEN.BEN_BENEFIT_ACTIONS
Subobject Name:
Status:	VALID

BEN_BENEFIT_ACTIONS contains the run parameters for the benefits concurrent manager processing, such as the Participation Process and Extract Process, run by the concurrent manager. This information is used mainly to restart the batch process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: BEN_BENEFIT_ACTIONS_PK

BENEFIT_ACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_BENEFIT_ACTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BENEFIT_ACTION_ID
BEN_BENEFIT_ACTIONS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
BEN_BENEFIT_ACTIONS_FK10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID
BEN_BENEFIT_ACTIONS_FK12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RPTG_GRP_ID
BEN_BENEFIT_ACTIONS_FK17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEGAL_ENTITY_ID
BEN_BENEFIT_ACTIONS_FK18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
BEN_BENEFIT_ACTIONS_FK8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
BEN_BENEFIT_ACTIONS_FK9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BENFTS_GRP_ID
BEN_BENEFIT_ACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
BEN_BENEFIT_ACTIONS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELIGY_PRFL_ID
BEN_BENEFIT_ACTIONS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VRBL_RT_PRFL_ID
BEN_BENEFIT_ACTIONS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ID
BEN_BENEFIT_ACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_TYPE_ID
BEN_BENEFIT_ACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PGM_ID
BEN_BENEFIT_ACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PL_ID
BEN_BENEFIT_ACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POPL_ENRT_TYP_CYCL_ID
BEN_BENEFIT_ACTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LER_ID
BEN_BENEFIT_ACTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PSTL_ZIP_RNG_ID
BEN_BENEFIT_ACTIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PL_TYP_ID
BEN_BENEFIT_ACTIONS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OPT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BENEFIT_ACTION_ID	NUMBER	(15)	Yes	Foreign key to BEN_BENEFIT_ACTION.
PROCESS_DATE	DATE		Yes	Process Date.
MODE_CD	VARCHAR2	(30)	Yes	Mode code.
DERIVABLE_FACTORS_FLAG	VARCHAR2	(30)	Yes	Derivable Factors Y or N.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign Key to HR_ORGANIZATION_UNITS
VALIDATE_FLAG	VARCHAR2	(30)	Yes	Validate Y or N.
DEBUG_MESSAGES_FLAG	VARCHAR2	(30)	Yes	Debug Messages Y or N.
NO_PROGRAMS_FLAG	VARCHAR2	(30)	Yes	No Programs Y or N.
NO_PLANS_FLAG	VARCHAR2	(30)	Yes	No Plans Y or N.
AUDIT_LOG_FLAG	VARCHAR2	(30)	Yes	Audit Log Y or N.
LF_EVT_OCRD_DT	VARCHAR2	(240)		Life event occurred date.
CLOSE_UNEAI_FLAG	VARCHAR2	(30)		Close Unprocessed employee action items Y or N.
UNEAI_EFFECTIVE_DATE	DATE			Close unresolved action item effective date.
RPTG_GRP_ID	NUMBER	(15)		Foreign key to BEN_RPTG_GRP_F
LER_ID	NUMBER	(15)		Foreign Key to BEN_LER_F.
LEGAL_ENTITY_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
PSTL_ZIP_RNG_ID	NUMBER	(15)		Foreign key to BEN_ZIP_RNG_F.
CM_TYP_ID	NUMBER	(15)		Foreign Key to BEN_CM_TYP_F.
AGE_FCTR_ID	NUMBER	(15)		Foreign Key to BEN_AGE_FCTR_F.
PL_TYP_ID	NUMBER	(15)		Foreign key to BEN_PL_TYP_F.
LOS_FCTR_ID	NUMBER	(15)		Foreign key to BEN_LOS_FCTR_F.
CMBN_AGE_LOS_FCTR_ID	NUMBER	(15)		Foreign key to BEN_CMBN_AGE_LOS_FCTR_F.
OPT_ID	NUMBER	(15)		Foreign Key to BEN_OPT_F.
ACTN_TYP_ID	NUMBER	(15)		Foreign Key to BEN_ACTN_TYP_F.
USE_FCTR_TO_SEL_FLAG	VARCHAR2	(30)		Use Factor To Select Y or N.
LOS_DET_TO_USE_CD	VARCHAR2	(30)		Length of service date to use code.
PTNL_LER_FOR_PER_STAT_CD	VARCHAR2	(30)		Potential life event reason for person status.
BFT_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column.
BFT_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield segment column.
BFT_ATTRIBUTE30	VARCHAR2	(150)		Descriptive Flexfield segment column.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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).
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.
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).
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).
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated primary key. Increments by one each update.
ORGANIZATION_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
LOCATION_ID	NUMBER	(15)		Foreign key to HR_LOCATIONS.
PERSON_ID	NUMBER	(15)		Foreign Key to PER_PEOPLE_F.
ELIGY_PRFL_ID	NUMBER	(15)		Foreign key to BEN_ELIGY_PRFL_F.
VRBL_RT_PRFL_ID	NUMBER	(15)		Foreign key to BEN_VRBL_RT_PRFL_F
PAYROLL_ID	NUMBER	(15)		Foreign key to PAY_PAYROLLS_F.
PGM_ID	NUMBER	(15)		Foreign key to BEN_PGM_F.
PL_ID	NUMBER	(15)		Foreign Key to BEN_PL_F.
POPL_ENRT_TYP_CYCL_ID	NUMBER	(15)		Foreign key to BEN_POPL_ENRT_TYP_CYCL_F.
COMP_SELECTION_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
PERSON_TYPE_ID	NUMBER	(15)		Foreign key to PER_PERSON_TYPES.
BENFTS_GRP_ID	NUMBER	(15)		Foreign key to BEN_BENFTS_GRP_F.
PERSON_SELECTION_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
CM_TRGR_TYP_CD	VARCHAR2	(30)		Communication trigger type.
MIN_AGE	NUMBER	(15)		Minimum age.
MAX_AGE	NUMBER	(15)		Maximum age.
MIN_LOS	NUMBER	(15)		Mininum length of service.
MAX_LOS	NUMBER	(15)		Maximum length of service.
MIN_CMBN	NUMBER	(15)		No longer used.
MAX_CMBN	NUMBER	(15)		No longer used.
DATE_FROM	DATE			Date from.
ELIG_ENROL_CD	VARCHAR2	(30)		Eligible or Enrolled.
LMT_PRPNIP_BY_ORG_FLAG	VARCHAR2	(30)		Limit By Person's Organization Y or N.
INELG_ACTION_CD	VARCHAR2	(30)		Inelg Action Cd
GRANT_PRICE_VAL	NUMBER			Grant Price Value
ENRT_PERD_ID	NUMBER	(15)		Enrollment Period Id
ASG_EVENTS_TO_ALL_SEL_DT	VARCHAR2	(30)		Assign Events To All Selection Date.
CAGR_ID	NUMBER	(15)		CAGR.
CONCAT_SEGS	VARCHAR2	(2000)		Concatinated Segments.
GRADE_LADDER_ID	NUMBER	(15)		Grade Ladder.
ORG_HIERARCHY_ID	NUMBER	(15)		Organization Hierarchy.
ORG_STARTING_NODE_ID	NUMBER	(15)		Organization Starting Node.
PER_SEL_DT_CD	VARCHAR2	(30)		Person Selection Date Code.
PER_SEL_DT_FROM	DATE			Person Selection Date from.
PER_SEL_DT_TO	DATE			Person Selection Date To
PER_SEL_FREQ_CD	VARCHAR2	(30)		Person Selection Frequency Code.
QUAL_STATUS	VARCHAR2	(30)		Qualification Status.
QUAL_TYPE	NUMBER			Qualification Type.
RATE_ID	NUMBER	(15)		Rate.
YEAR_FROM	NUMBER			Year From.
YEAR_TO	NUMBER			Year To.

Query Text

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


SELECT BENEFIT_ACTION_ID
,      PROCESS_DATE
,      MODE_CD
,      DERIVABLE_FACTORS_FLAG
,      BUSINESS_GROUP_ID
,      VALIDATE_FLAG
,      DEBUG_MESSAGES_FLAG
,      NO_PROGRAMS_FLAG
,      NO_PLANS_FLAG
,      AUDIT_LOG_FLAG
,      LF_EVT_OCRD_DT
,      CLOSE_UNEAI_FLAG
,      UNEAI_EFFECTIVE_DATE
,      RPTG_GRP_ID
,      LER_ID
,      LEGAL_ENTITY_ID
,      PSTL_ZIP_RNG_ID
,      CM_TYP_ID
,      AGE_FCTR_ID
,      PL_TYP_ID
,      LOS_FCTR_ID
,      CMBN_AGE_LOS_FCTR_ID
,      OPT_ID
,      ACTN_TYP_ID
,      USE_FCTR_TO_SEL_FLAG
,      LOS_DET_TO_USE_CD
,      PTNL_LER_FOR_PER_STAT_CD
,      BFT_ATTRIBUTE_CATEGORY
,      BFT_ATTRIBUTE1
,      BFT_ATTRIBUTE3
,      BFT_ATTRIBUTE4
,      BFT_ATTRIBUTE5
,      BFT_ATTRIBUTE6
,      BFT_ATTRIBUTE7
,      BFT_ATTRIBUTE8
,      BFT_ATTRIBUTE9
,      BFT_ATTRIBUTE10
,      BFT_ATTRIBUTE11
,      BFT_ATTRIBUTE12
,      BFT_ATTRIBUTE13
,      BFT_ATTRIBUTE14
,      BFT_ATTRIBUTE15
,      BFT_ATTRIBUTE16
,      BFT_ATTRIBUTE17
,      BFT_ATTRIBUTE18
,      BFT_ATTRIBUTE19
,      BFT_ATTRIBUTE20
,      BFT_ATTRIBUTE21
,      BFT_ATTRIBUTE22
,      BFT_ATTRIBUTE23
,      BFT_ATTRIBUTE24
,      BFT_ATTRIBUTE25
,      BFT_ATTRIBUTE26
,      BFT_ATTRIBUTE27
,      BFT_ATTRIBUTE28
,      BFT_ATTRIBUTE29
,      BFT_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      ORGANIZATION_ID
,      LOCATION_ID
,      PERSON_ID
,      ELIGY_PRFL_ID
,      VRBL_RT_PRFL_ID
,      PAYROLL_ID
,      PGM_ID
,      PL_ID
,      POPL_ENRT_TYP_CYCL_ID
,      COMP_SELECTION_RL
,      PERSON_TYPE_ID
,      BENFTS_GRP_ID
,      PERSON_SELECTION_RL
,      CM_TRGR_TYP_CD
,      MIN_AGE
,      MAX_AGE
,      MIN_LOS
,      MAX_LOS
,      MIN_CMBN
,      MAX_CMBN
,      DATE_FROM
,      ELIG_ENROL_CD
,      LMT_PRPNIP_BY_ORG_FLAG
,      INELG_ACTION_CD
,      GRANT_PRICE_VAL
,      ENRT_PERD_ID
,      ASG_EVENTS_TO_ALL_SEL_DT
,      CAGR_ID
,      CONCAT_SEGS
,      GRADE_LADDER_ID
,      ORG_HIERARCHY_ID
,      ORG_STARTING_NODE_ID
,      PER_SEL_DT_CD
,      PER_SEL_DT_FROM
,      PER_SEL_DT_TO
,      PER_SEL_FREQ_CD
,      QUAL_STATUS
,      QUAL_TYPE
,      RATE_ID
,      YEAR_FROM
,      YEAR_TO
FROM BEN.BEN_BENEFIT_ACTIONS;

Dependencies

[top of page]

BEN.BEN_BENEFIT_ACTIONS does not reference any database object

BEN.BEN_BENEFIT_ACTIONS is referenced by following:

APPS: BEN_BENEFIT_ACTIONS; BEN_BENEFIT_ACTIONS_WHO