[Home] [Help] [Dependency Information]
Object Name: | BEN_PTIP_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_PTIP_F |
Subobject Name: | |
Status: | VALID |
BEN_PTIP_F identifies processing requirements for a plan type that is supported within a program. For example, the ABC Corporation Flexible Benefits Program is composed of Medical, Dental, Vision, Employee Group Term Life Insurance, Health Care Flexible Spending Account, and Dependent Care Flexible Spending Account types of plans.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_PTIP_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PTIP_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_PTIP_F_FK5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_PTIP_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_TYP_ID |
BEN_PTIP_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PGM_ID |
BEN_PTIP_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CMBN_PTIP_ID |
BEN_PTIP_F_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CMBN_PTIP_OPT_ID |
BEN_PTIP_F_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACRS_PTIP_CVG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PTIP_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. | |
PTIP_STAT_CD | VARCHAR2 | (30) | Yes | Plan type in program status. |
COORD_CVG_FOR_ALL_PLS_FLAG | VARCHAR2 | (30) | Yes | Coordinate coverage for all plans Y or N. |
DPNT_CVG_NO_CTFN_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent coverage requires no certification Y or N. |
DPNT_ADRS_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent address required Y or N. |
DPNT_LEGV_ID_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent Legislative Identifier required Y or N. |
DPNT_DOB_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent date of birth required Y or N. |
CRS_THIS_PL_TYP_ONLY_FLAG | VARCHAR2 | (30) | Yes | Credits this plan type only Y or N. |
NO_MX_PL_TYP_OVRID_FLAG | VARCHAR2 | (30) | Yes | No Maximum Plan Type Override Y or N. |
PRVDS_CR_FLAG | VARCHAR2 | (30) | Yes | Provides Credit Y or N. |
WVBL_FLAG | VARCHAR2 | (30) | Yes | Waivable Y or N. |
DRVD_FCTR_DPNT_CVG_FLAG | VARCHAR2 | (30) | Yes | Derived factor for dependent coverage Y or N. |
NO_MN_PL_TYP_OVERID_FLAG | VARCHAR2 | (30) | Yes | No Minimum Plan Type Override Y or N. |
SBJ_TO_SPS_LF_INS_MX_FLAG | VARCHAR2 | (30) | Yes | Subject To Spouse Life Insurance Maximum Y or N. |
SBJ_TO_DPNT_LF_INS_MX_FLAG | VARCHAR2 | (30) | Yes | Subject To Dependent Life Insurance Maximum Y or N. |
USE_TO_SUM_EE_LF_INS_FLAG | VARCHAR2 | (30) | Yes | Use To Sum Employee Life Insurance Y or N. |
PL_TYP_ID | NUMBER | (15) | Yes | Foreign key to BEN_PL_TYP_F. |
PGM_ID | NUMBER | (15) | Yes | Foreign key to BEN_PGM_F. |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS | |
DRVBL_FCTR_APLS_RTS_FLAG | VARCHAR2 | (30) | Yes | Derivable factors apply to rates Y or N. |
DRVBL_FCTR_PRTN_ELIG_FLAG | VARCHAR2 | (30) | Yes | Derivable factors for participation eligibility Y or N. |
ELIG_APLS_FLAG | VARCHAR2 | (30) | Yes | Eligibility applies Y or N. |
PRTN_ELIG_OVRID_ALWD_FLAG | VARCHAR2 | (30) | Yes | Participation Eligible Override Allowed Y or N. |
TRK_INELIG_PER_FLAG | VARCHAR2 | (30) | Yes | Track Ineligible Person Y or N. |
CTP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
CTP_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
CTP_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_CD | VARCHAR2 | (30) | Dependent designation code. | |
DPNT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Dependent coverage start date code. | |
DPNT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
DPNT_CVG_END_DT_CD | VARCHAR2 | (30) | Dependent coverage end date code. | |
DPNT_CVG_END_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
POSTELCN_EDIT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
MX_CVG_ALWD_AMT | NUMBER | Maximum coverage allowed amount. | ||
MN_ENRD_RQD_OVRID_NUM | NUMBER | (15) | Minimum required enrollment to override the value defined for the plan type. | |
MX_ENRD_ALWD_OVRID_NUM | NUMBER | (15) | Maximum enrollment allowed to override the value defined for the plan type. | |
ORDR_NUM | NUMBER | (15) | Order number. | |
RQD_PERD_ENRT_NENRT_VAL | NUMBER | (15) | Required period of enrollment value. | |
RQD_PERD_ENRT_NENRT_TM_UOM | VARCHAR2 | (30) | Required period of enrollment unit of measure. | |
IVR_IDENT | VARCHAR2 | (90) | Interactive Voice Response identifier. | |
RQD_ENRT_PERD_TCO_CD | VARCHAR2 | (30) | Required enrollment period total compensation object code. | |
RQD_PERD_ENRT_NENRT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
ENRT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Enrollment coverage start date code. | |
ENRT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
ENRT_CVG_END_DT_CD | VARCHAR2 | (30) | Enrollment coverage end date code. | |
ENRT_CVG_END_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
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. | |
URL_REF_NAME | VARCHAR2 | (240) | URL reference name. | |
ACRS_PTIP_CVG_ID | NUMBER | (15) | Foreign Key to BEN_ACRS_PTIP_CVG_F. | |
CMBN_PTIP_OPT_ID | NUMBER | (15) | Foreign key to BEN_CMBN_PTIP_OPT_F. | |
CMBN_PTIP_ID | NUMBER | (15) | Foreign key to BEN_CMBN_PTIP_F. | |
AUTO_ENRT_MTHD_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
ENRT_MTHD_CD | VARCHAR2 | (30) | Enrollment method | |
ENRT_CD | VARCHAR2 | (30) | Enrollment code. | |
ENRT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
DFLT_ENRT_CD | VARCHAR2 | (30) | Default enrollment code. | |
DFLT_ENRT_DET_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
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 | |
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 based on the Dependent's Social Security Number Code. | |
SUSP_IF_DPNT_DOB_NT_PRV_CD | VARCHAR2 | (30) | Suspend or unsuspend the enrollment based on the dependent's Date of Birth Code. | |
SUSP_IF_DPNT_ADR_NT_PRV_CD | VARCHAR2 | (30) | Suspend or unsuspend the enrollment based on the dependent's address code. | |
SUSP_IF_CTFN_NOT_DPNT_FLAG | VARCHAR2 | (30) | Yes | Suspend the enrollment based on whether the certification is provided or not. |
DPNT_CTFN_DETERMINE_CD | VARCHAR2 | (30) | Dependent Certification determination code. |
Cut, paste (and edit) the following text to query this object:
SELECT PTIP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, PTIP_STAT_CD
, COORD_CVG_FOR_ALL_PLS_FLAG
, DPNT_CVG_NO_CTFN_RQD_FLAG
, DPNT_ADRS_RQD_FLAG
, DPNT_LEGV_ID_RQD_FLAG
, DPNT_DOB_RQD_FLAG
, CRS_THIS_PL_TYP_ONLY_FLAG
, NO_MX_PL_TYP_OVRID_FLAG
, PRVDS_CR_FLAG
, WVBL_FLAG
, DRVD_FCTR_DPNT_CVG_FLAG
, NO_MN_PL_TYP_OVERID_FLAG
, SBJ_TO_SPS_LF_INS_MX_FLAG
, SBJ_TO_DPNT_LF_INS_MX_FLAG
, USE_TO_SUM_EE_LF_INS_FLAG
, PL_TYP_ID
, PGM_ID
, BUSINESS_GROUP_ID
, DRVBL_FCTR_APLS_RTS_FLAG
, DRVBL_FCTR_PRTN_ELIG_FLAG
, ELIG_APLS_FLAG
, PRTN_ELIG_OVRID_ALWD_FLAG
, TRK_INELIG_PER_FLAG
, CTP_ATTRIBUTE_CATEGORY
, CTP_ATTRIBUTE1
, CTP_ATTRIBUTE2
, CTP_ATTRIBUTE3
, CTP_ATTRIBUTE4
, CTP_ATTRIBUTE5
, CTP_ATTRIBUTE6
, CTP_ATTRIBUTE7
, CTP_ATTRIBUTE8
, CTP_ATTRIBUTE9
, CTP_ATTRIBUTE10
, CTP_ATTRIBUTE11
, CTP_ATTRIBUTE12
, CTP_ATTRIBUTE13
, CTP_ATTRIBUTE14
, CTP_ATTRIBUTE15
, CTP_ATTRIBUTE16
, CTP_ATTRIBUTE17
, CTP_ATTRIBUTE18
, CTP_ATTRIBUTE19
, CTP_ATTRIBUTE20
, CTP_ATTRIBUTE21
, CTP_ATTRIBUTE22
, CTP_ATTRIBUTE23
, CTP_ATTRIBUTE24
, CTP_ATTRIBUTE25
, CTP_ATTRIBUTE26
, CTP_ATTRIBUTE27
, CTP_ATTRIBUTE28
, CTP_ATTRIBUTE29
, CTP_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, DPNT_DSGN_CD
, DPNT_CVG_STRT_DT_CD
, DPNT_CVG_STRT_DT_RL
, DPNT_CVG_END_DT_CD
, DPNT_CVG_END_DT_RL
, POSTELCN_EDIT_RL
, MX_CVG_ALWD_AMT
, MN_ENRD_RQD_OVRID_NUM
, MX_ENRD_ALWD_OVRID_NUM
, ORDR_NUM
, RQD_PERD_ENRT_NENRT_VAL
, RQD_PERD_ENRT_NENRT_TM_UOM
, IVR_IDENT
, RQD_ENRT_PERD_TCO_CD
, RQD_PERD_ENRT_NENRT_RL
, ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT_RL
, ENRT_CVG_END_DT_CD
, ENRT_CVG_END_DT_RL
, RT_STRT_DT_CD
, RT_STRT_DT_RL
, RT_END_DT_CD
, RT_END_DT_RL
, URL_REF_NAME
, ACRS_PTIP_CVG_ID
, CMBN_PTIP_OPT_ID
, CMBN_PTIP_ID
, AUTO_ENRT_MTHD_RL
, ENRT_MTHD_CD
, ENRT_CD
, ENRT_RL
, DFLT_ENRT_CD
, DFLT_ENRT_DET_RL
, VRFY_FMLY_MMBR_CD
, VRFY_FMLY_MMBR_RL
, PER_CVRD_CD
, SHORT_CODE
, SHORT_NAME
, 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_PTIP_F;
BEN.BEN_PTIP_F does not reference any database object
BEN.BEN_PTIP_F is referenced by following:
|
|
|