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_PGM_F

Object Details

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

BEN_PGM_F identifies the processing characteristics for a compensation program. A program is a way to group plans together which are typically offered as a package of benefits to a group of people. Attributes of the program which control participation eligibility are logically inherited down to the plans which are defined to it, this allows plan sponsors to establish plan definitions more easily and is a primary means of determining what plans should be put into a program. Additionally, this table defines the standard unit of measure and reference period for activity rates used by the plans in the program.
For example, Acme Flex Program, Acme Assigned Benefits for New Hires, Acme COBRA Program, Acme Executive Benefits Program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: BEN_PGM_F_PK

PGM_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_PGM_F_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PGM_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
BEN_PGM_F_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
BEN_PGM_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENRT_CVG_END_DT_RL
BEN_PGM_F_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENRT_CVG_STRT_DT_RL
BEN_PGM_F_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DPNT_CVG_STRT_DT_RL
BEN_PGM_F_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DPNT_CVG_END_DT_RL

Columns

Name	Datatype	Length	Mandatory	Comments
PGM_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.
NAME	VARCHAR2	(240)	Yes	Name of the program.
DPNT_ADRS_RQD_FLAG	VARCHAR2	(30)	Yes	Dependent address required Y or N.
PGM_PRVDS_NO_AUTO_ENRT_FLAG	VARCHAR2	(30)	Yes	Program Provides No Automatic Enrollment Y or N.
DPNT_DOB_RQD_FLAG	VARCHAR2	(30)	Yes	Dependent date of birth required Y or N.
PGM_PRVDS_NO_DFLT_ENRT_FLAG	VARCHAR2	(30)	Yes	Program Provides No Default Enrollment Y or N.
DPNT_LEGV_ID_RQD_FLAG	VARCHAR2	(30)	Yes	Dependent Legislative Identifier required Y or N.
ELIG_APLS_FLAG	VARCHAR2	(30)	Yes	Eligibility applies Y or N.
USES_ALL_ASMTS_FOR_RTS_FLAG	VARCHAR2	(30)	Yes	Uses All Assignments For Rates Y or N.
PRTN_ELIG_OVRID_ALWD_FLAG	VARCHAR2	(30)	Yes	Participation Eligible Override Allowed Y or N.
PGM_USE_ALL_ASNTS_ELIG_FLAG	VARCHAR2	(30)	Yes	Program uses all assignments for eligibility Y or N.
COORD_CVG_FOR_ALL_PLS_FLG	VARCHAR2	(30)	Yes	Coordinate coverage for all plans Y or N.
DPNT_DSGN_NO_CTFN_RQD_FLAG	VARCHAR2	(30)	Yes	Dependent designation certification required Y or N.
DRVBL_FCTR_DPNT_ELIG_FLAG	VARCHAR2	(30)	Yes	Derivable factors for dependent eligibility Y or N.
DRVBL_FCTR_PRTN_ELIG_FLAG	VARCHAR2	(30)	Yes	Derivable factors for participation eligibility Y or N.
DRVBL_FCTR_APLS_RTS_FLAG	VARCHAR2	(30)	Yes	Derivable factors apply to rates Y or N.
TRK_INELIG_PER_FLAG	VARCHAR2	(30)	Yes	Track Ineligible Person Y or N.
ALWS_UNRSTRCTD_ENRT_FLAG	VARCHAR2	(30)	Yes	Allows Unrestricted Enrollment Y or N.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign Key to HR_ORGANIZATION_UNITS
PGM_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column.
PGM_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield segment column.
PGM_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.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated primary key. Increments by one each update.
DPNT_DSGN_LVL_CD	VARCHAR2	(30)		Dependent designation level.
ENRT_CVG_END_DT_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
PGM_STAT_CD	VARCHAR2	(30)		Program status.
IVR_IDENT	VARCHAR2	(90)		Interactive Voice Response identifier.
PGM_TYP_CD	VARCHAR2	(30)		Program type.
ENRT_CVG_STRT_DT_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
DPNT_CVG_STRT_DT_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
URL_REF_NAME	VARCHAR2	(240)		URL reference name.
PGM_DESC	VARCHAR2	(2000)		Program description.
DPNT_DSGN_CD	VARCHAR2	(30)		Dependent designation code.
MX_DPNT_PCT_PRTT_LF_AMT	NUMBER	(15)		Maximum dependent percent of participant life insurance coverage amount.
MX_SPS_PCT_PRTT_LF_AMT	NUMBER	(15)		Maximum spouse percent of the participant life insurance coverage amount.
DPNT_CVG_END_DT_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
ACTY_REF_PERD_CD	VARCHAR2	(30)		Activity reference period.
ENRT_CVG_END_DT_CD	VARCHAR2	(30)		Enrollment coverage end date code.
DPNT_CVG_END_DT_CD	VARCHAR2	(30)		Dependent coverage end date code.
DPNT_CVG_STRT_DT_CD	VARCHAR2	(30)		Dependent coverage start date code.
ENRT_CVG_STRT_DT_CD	VARCHAR2	(30)		Enrollment coverage start date code.
ENRT_INFO_RT_FREQ_CD	VARCHAR2	(30)		Enrollment information rate frequency.
RT_STRT_DT_CD	VARCHAR2	(30)		Rate start date code.
RT_STRT_DT_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
RT_END_DT_CD	VARCHAR2	(30)		Rate end date code.
RT_END_DT_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
PGM_GRP_CD	VARCHAR2	(30)		Program group.
PGM_UOM	VARCHAR2	(30)		Program unit of measure.
ENRT_CD	VARCHAR2	(30)		Enrollment code.
ENRT_MTHD_CD	VARCHAR2	(30)		Enrollment method.
AUTO_ENRT_MTHD_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
ENRT_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
POE_LVL_CD	VARCHAR2	(30)		Period of enrollment level.
VRFY_FMLY_MMBR_CD	VARCHAR2	(30)		Verify family member code
VRFY_FMLY_MMBR_RL	NUMBER	(15)		Foreign key to FF_FORMULAS_F.
PER_CVRD_CD	VARCHAR2	(30)		Person covered code.
SHORT_CODE	VARCHAR2	(30)		Short Code
SHORT_NAME	VARCHAR2	(30)		short Name
DFLT_ELEMENT_TYPE_ID	NUMBER	(15)		Default Salary Element
DFLT_INPUT_VALUE_ID	NUMBER	(15)		Defualt input value of salary element
DFLT_PGM_FLAG	VARCHAR2	(30)	Yes	Default Grade Ladder Flag
DFLT_STEP_CD	VARCHAR2	(30)		Default Step a Employee is placed
DFLT_STEP_RL	NUMBER	(15)		Default Step Rule
SCORES_CALC_MTHD_CD	VARCHAR2	(30)		Employee score calculation method
SCORES_CALC_RL	NUMBER	(15)		Employee score calculation rule
UPDATE_SALARY_CD	VARCHAR2	(30)		Salary Updation method code
USE_MULTI_PAY_RATES_FLAG	VARCHAR2	(30)	Yes	Allow multiple rates for grades and steps
USE_PROG_POINTS_FLAG	VARCHAR2	(30)	Yes	Use Progression Points Flag
USE_SCORES_CD	VARCHAR2	(30)		Use Scores to rank employees
SALARY_CALC_MTHD_CD	VARCHAR2	(30)		Salary Calculation Method Code
SALARY_CALC_MTHD_RL	NUMBER	(15)		Salary Calculation Method Rule
GSP_ALLOW_OVERRIDE_FLAG	VARCHAR2	(30)	Yes	Grade Step Override Flag Y or N
USE_VARIABLE_RATES_FLAG	VARCHAR2	(30)	Yes	Grade Step Use Variable Rates Flag
LEGISLATION_CODE	VARCHAR2	(30)		Foreign key to FND_TERRITORIES.
LEGISLATION_SUBGROUP	VARCHAR2	(30)		Further identifies the legislation of startup data.
SUSP_IF_DPNT_SSN_NT_PRV_CD	VARCHAR2	(30)		Suspend or Unsuspend the Enrollment if Dependent's Social Security Number is not Provided based on the Code.
SUSP_IF_DPNT_DOB_NT_PRV_CD	VARCHAR2	(30)		Suspend or Unsuspend the Enrollment if dependent's Date Of Birth is not provided based on the code.
SUSP_IF_DPNT_ADR_NT_PRV_CD	VARCHAR2	(30)		Suspend or unsuspend the Enrollment if dependent's Address is not provided based on the code.
SUSP_IF_CTFN_NOT_DPNT_FLAG	VARCHAR2	(30)	Yes	Suspend the Enrollment if Certification for Dependent is not Provided.
DPNT_CTFN_DETERMINE_CD	VARCHAR2	(30)		Dependent Certification determination code.

Query Text

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


SELECT PGM_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NAME
,      DPNT_ADRS_RQD_FLAG
,      PGM_PRVDS_NO_AUTO_ENRT_FLAG
,      DPNT_DOB_RQD_FLAG
,      PGM_PRVDS_NO_DFLT_ENRT_FLAG
,      DPNT_LEGV_ID_RQD_FLAG
,      ELIG_APLS_FLAG
,      USES_ALL_ASMTS_FOR_RTS_FLAG
,      PRTN_ELIG_OVRID_ALWD_FLAG
,      PGM_USE_ALL_ASNTS_ELIG_FLAG
,      COORD_CVG_FOR_ALL_PLS_FLG
,      DPNT_DSGN_NO_CTFN_RQD_FLAG
,      DRVBL_FCTR_DPNT_ELIG_FLAG
,      DRVBL_FCTR_PRTN_ELIG_FLAG
,      DRVBL_FCTR_APLS_RTS_FLAG
,      TRK_INELIG_PER_FLAG
,      ALWS_UNRSTRCTD_ENRT_FLAG
,      BUSINESS_GROUP_ID
,      PGM_ATTRIBUTE_CATEGORY
,      PGM_ATTRIBUTE1
,      PGM_ATTRIBUTE2
,      PGM_ATTRIBUTE3
,      PGM_ATTRIBUTE4
,      PGM_ATTRIBUTE5
,      PGM_ATTRIBUTE6
,      PGM_ATTRIBUTE7
,      PGM_ATTRIBUTE8
,      PGM_ATTRIBUTE9
,      PGM_ATTRIBUTE10
,      PGM_ATTRIBUTE11
,      PGM_ATTRIBUTE12
,      PGM_ATTRIBUTE13
,      PGM_ATTRIBUTE14
,      PGM_ATTRIBUTE15
,      PGM_ATTRIBUTE16
,      PGM_ATTRIBUTE17
,      PGM_ATTRIBUTE18
,      PGM_ATTRIBUTE19
,      PGM_ATTRIBUTE20
,      PGM_ATTRIBUTE21
,      PGM_ATTRIBUTE22
,      PGM_ATTRIBUTE23
,      PGM_ATTRIBUTE24
,      PGM_ATTRIBUTE25
,      PGM_ATTRIBUTE26
,      PGM_ATTRIBUTE27
,      PGM_ATTRIBUTE28
,      PGM_ATTRIBUTE29
,      PGM_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      DPNT_DSGN_LVL_CD
,      ENRT_CVG_END_DT_RL
,      PGM_STAT_CD
,      IVR_IDENT
,      PGM_TYP_CD
,      ENRT_CVG_STRT_DT_RL
,      DPNT_CVG_STRT_DT_RL
,      URL_REF_NAME
,      PGM_DESC
,      DPNT_DSGN_CD
,      MX_DPNT_PCT_PRTT_LF_AMT
,      MX_SPS_PCT_PRTT_LF_AMT
,      DPNT_CVG_END_DT_RL
,      ACTY_REF_PERD_CD
,      ENRT_CVG_END_DT_CD
,      DPNT_CVG_END_DT_CD
,      DPNT_CVG_STRT_DT_CD
,      ENRT_CVG_STRT_DT_CD
,      ENRT_INFO_RT_FREQ_CD
,      RT_STRT_DT_CD
,      RT_STRT_DT_RL
,      RT_END_DT_CD
,      RT_END_DT_RL
,      PGM_GRP_CD
,      PGM_UOM
,      ENRT_CD
,      ENRT_MTHD_CD
,      AUTO_ENRT_MTHD_RL
,      ENRT_RL
,      POE_LVL_CD
,      VRFY_FMLY_MMBR_CD
,      VRFY_FMLY_MMBR_RL
,      PER_CVRD_CD
,      SHORT_CODE
,      SHORT_NAME
,      DFLT_ELEMENT_TYPE_ID
,      DFLT_INPUT_VALUE_ID
,      DFLT_PGM_FLAG
,      DFLT_STEP_CD
,      DFLT_STEP_RL
,      SCORES_CALC_MTHD_CD
,      SCORES_CALC_RL
,      UPDATE_SALARY_CD
,      USE_MULTI_PAY_RATES_FLAG
,      USE_PROG_POINTS_FLAG
,      USE_SCORES_CD
,      SALARY_CALC_MTHD_CD
,      SALARY_CALC_MTHD_RL
,      GSP_ALLOW_OVERRIDE_FLAG
,      USE_VARIABLE_RATES_FLAG
,      LEGISLATION_CODE
,      LEGISLATION_SUBGROUP
,      SUSP_IF_DPNT_SSN_NT_PRV_CD
,      SUSP_IF_DPNT_DOB_NT_PRV_CD
,      SUSP_IF_DPNT_ADR_NT_PRV_CD
,      SUSP_IF_CTFN_NOT_DPNT_FLAG
,      DPNT_CTFN_DETERMINE_CD
FROM BEN.BEN_PGM_F;

Dependencies

[top of page]

BEN.BEN_PGM_F does not reference any database object

BEN.BEN_PGM_F is referenced by following:

APPS: BEN_PGM_F; BEN_PGM_F_WHO