[Home] [Help] [Dependency Information]
Object Name: | BENBV_PTIP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BENBV_PTIP_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
DPNT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
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 | Plan type max coverage amount. | ||
MN_ENRD_RQD_OVRID_NUM | NUMBER | (15) | Plan type number of plans min. | |
MX_ENRD_ALWD_OVRID_NUM | NUMBER | (15) | Plan type number of plans max. | |
ORDR_NUM | NUMBER | (15) | Plan type in program sequence. | |
RQD_PERD_ENRT_NENRT_VAL | NUMBER | (15) | Plan type required period of enrollment value. | |
RQD_PERD_ENRT_NENRT_TM_UOM | VARCHAR2 | (30) | Plan type required period of enrollment uom (Lookup code based on lookup type BEN_RQD_PERD_ENRT_NENRT_TM_UOM). | |
RQD_PERD_ENRT_NENRT_TM_UOM_M | VARCHAR2 | (4000) | Plan type required period of enrollment uom (Lookup meaning based on lookup type BEN_RQD_PERD_ENRT_NENRT_TM_UOM). | |
IVR_IDENT | VARCHAR2 | (90) | Plan type in program integrated voice response. | |
RQD_PERD_ENRT_NENRT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
ENRT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
ENRT_CVG_END_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
RT_STRT_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
RT_END_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
URL_REF_NAME | VARCHAR2 | (240) | Plan type in program web address. | |
AUTO_ENRT_MTHD_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
ENRT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
DFLT_ENRT_DET_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
VRFY_FMLY_MMBR_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
SHORT_CODE | VARCHAR2 | (30) | Plan type in program short code. | |
SHORT_NAME | VARCHAR2 | (30) | Plan type in program short name. | |
LEGISLATION_CODE | VARCHAR2 | (30) | Foreign key to FND_TERRITORIES. | |
LEGISLATION_SUBGROUP | VARCHAR2 | (30) | Further identifies the legislation of startup data. | |
_DF:CTP | CHAR | (22) | ||
PTIP_STAT_CD | VARCHAR2 | (30) | Yes | Plan type in program status (Lookup code based on lookup type BEN_STAT). |
PTIP_STAT_CD_M | VARCHAR2 | (4000) | Plan type in program status (Lookup meaning based on lookup type BEN_STAT). | |
DPNT_DSGN_CD | VARCHAR2 | (30) | Paln type in program dependent designation code (Lookup code based on lookup type BEN_DPNT_DSGN). | |
DPNT_DSGN_CD_M | VARCHAR2 | (4000) | Paln type in program dependent designation code (Lookup meaning based on lookup type BEN_DPNT_DSGN). | |
DPNT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Plan type dependent coverage start date code (Lookup code based on lookup type BEN_DPNT_CVG_STRT). | |
DPNT_CVG_STRT_DT_CD_M | VARCHAR2 | (4000) | Plan type dependent coverage start date code (Lookup meaning based on lookup type BEN_DPNT_CVG_STRT). | |
DPNT_CVG_END_DT_CD | VARCHAR2 | (30) | Plan type dependent coverage end date code (Lookup code based on lookup type BEN_DPNT_CVG_END). | |
DPNT_CVG_END_DT_CD_M | VARCHAR2 | (4000) | Plan type dependent coverage end date code (Lookup meaning based on lookup type BEN_DPNT_CVG_END). | |
RQD_ENRT_PERD_TCO_CD | VARCHAR2 | (30) | Required enrollment period total compensation object code (Lookup code based on lookup type BEN_RQD_ENRT_PERD_TCO). | |
RQD_ENRT_PERD_TCO_CD_M | VARCHAR2 | (4000) | Required enrollment period total compensation object code (Lookup meaning based on lookup type BEN_RQD_ENRT_PERD_TCO). | |
ENRT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Plan type enrollment coverage start date (Lookup code based on lookup type BEN_ENRT_CVG_STRT). | |
ENRT_CVG_STRT_DT_CD_M | VARCHAR2 | (4000) | Plan type enrollment coverage start date (Lookup meaning based on lookup type BEN_ENRT_CVG_STRT). | |
ENRT_CVG_END_DT_CD | VARCHAR2 | (30) | Plan type enrollment coverage end date (Lookup code based on lookup type BEN_ENRT_CVG_END). | |
ENRT_CVG_END_DT_CD_M | VARCHAR2 | (4000) | Plan type enrollment coverage end date (Lookup meaning based on lookup type BEN_ENRT_CVG_END). | |
RT_STRT_DT_CD | VARCHAR2 | (30) | Plan type rate start date code (Lookup code based on lookup type BEN_RT_STRT). | |
RT_STRT_DT_CD_M | VARCHAR2 | (4000) | Plan type rate start date code (Lookup meaning based on lookup type BEN_RT_STRT). | |
RT_END_DT_CD | VARCHAR2 | (30) | Plan type rate end date code (Lookup code based on lookup type BEN_RT_END). | |
RT_END_DT_CD_M | VARCHAR2 | (4000) | Plan type rate end date code (Lookup meaning based on lookup type BEN_RT_END). | |
ENRT_MTHD_CD | VARCHAR2 | (30) | Plan type enrollment method (Lookup code based on lookup type BEN_ENRT_MTHD). | |
ENRT_MTHD_CD_M | VARCHAR2 | (4000) | Plan type enrollment method (Lookup meaning based on lookup type BEN_ENRT_MTHD). | |
ENRT_CD | VARCHAR2 | (30) | Plan type enrollment code (Lookup code based on lookup type BEN_ENRT). | |
ENRT_CD_M | VARCHAR2 | (4000) | Plan type enrollment code (Lookup meaning based on lookup type BEN_ENRT). | |
DFLT_ENRT_CD | VARCHAR2 | (30) | Plan type default enrollment code (Lookup code based on lookup type BEN_DFLT_ENRT). | |
DFLT_ENRT_CD_M | VARCHAR2 | (4000) | Plan type default enrollment code (Lookup meaning based on lookup type BEN_DFLT_ENRT). | |
VRFY_FMLY_MMBR_CD | VARCHAR2 | (30) | Plan type in program family member code (Lookup code based on lookup type BEN_FMLY_MMBR). | |
VRFY_FMLY_MMBR_CD_M | VARCHAR2 | (4000) | Plan type in program family member code (Lookup meaning based on lookup type BEN_FMLY_MMBR). | |
PER_CVRD_CD | VARCHAR2 | (30) | Plan type in program person covered code (Lookup code based on lookup type BEN_PER_CVRD). | |
PER_CVRD_CD_M | VARCHAR2 | (4000) | Plan type in program person covered code (Lookup meaning based on lookup type BEN_PER_CVRD). | |
COORD_CVG_FOR_ALL_PLS_FLAG | VARCHAR2 | (30) | Yes | Plan type coordinate coverage for all plans (Lookup code based on lookup type YES_NO). |
COORD_CVG_FOR_ALL_PLS_FLAG_M | VARCHAR2 | (4000) | Plan type coordinate coverage for all plans (Lookup meaning based on lookup type YES_NO). | |
DPNT_CVG_NO_CTFN_RQD_FLAG | VARCHAR2 | (30) | Yes | Plan type dependent no certification needed (Lookup code based on lookup type YES_NO). |
DPNT_CVG_NO_CTFN_RQD_FLAG_M | VARCHAR2 | (4000) | Plan type dependent no certification needed (Lookup meaning based on lookup type YES_NO). | |
DPNT_ADRS_RQD_FLAG | VARCHAR2 | (30) | Yes | Plan type dependent address (Lookup code based on lookup type YES_NO). |
DPNT_ADRS_RQD_FLAG_M | VARCHAR2 | (4000) | Plan type dependent address (Lookup meaning based on lookup type YES_NO). | |
DPNT_LEGV_ID_RQD_FLAG | VARCHAR2 | (30) | Yes | Plan type dependent suspend enrollment if not provided ssn/legislative id (Lookup code based on lookup type YES_NO). |
DPNT_LEGV_ID_RQD_FLAG_M | VARCHAR2 | (4000) | Plan type dependent suspend enrollment if not provided ssn/legislative id (Lookup meaning based on lookup type YES_NO). | |
DPNT_DOB_RQD_FLAG | VARCHAR2 | (30) | Yes | Plan type dependent date of birth (Lookup code based on lookup type YES_NO). |
DPNT_DOB_RQD_FLAG_M | VARCHAR2 | (4000) | Plan type dependent date of birth (Lookup meaning based on lookup type YES_NO). | |
CRS_THIS_PL_TYP_ONLY_FLAG | VARCHAR2 | (30) | Yes | Credits this plan type only (Lookup code based on lookup type YES_NO). |
CRS_THIS_PL_TYP_ONLY_FLAG_M | VARCHAR2 | (4000) | Credits this plan type only (Lookup meaning based on lookup type YES_NO). | |
NO_MX_PL_TYP_OVRID_FLAG | VARCHAR2 | (30) | Yes | Plan type number of plans no max (Lookup code based on lookup type YES_NO). |
NO_MX_PL_TYP_OVRID_FLAG_M | VARCHAR2 | (4000) | Plan type number of plans no max (Lookup meaning based on lookup type YES_NO). | |
PRVDS_CR_FLAG | VARCHAR2 | (30) | Yes | Plan tpe in program provides credit (Lookup code based on lookup type YES_NO). |
PRVDS_CR_FLAG_M | VARCHAR2 | (4000) | Plan tpe in program provides credit (Lookup meaning based on lookup type YES_NO). | |
WVBL_FLAG | VARCHAR2 | (30) | Yes | Plan type in program waivable (Lookup code based on lookup type YES_NO). |
WVBL_FLAG_M | VARCHAR2 | (4000) | Plan type in program waivable (Lookup meaning based on lookup type YES_NO). | |
DRVD_FCTR_DPNT_CVG_FLAG | VARCHAR2 | (30) | Yes | Plan type dependent coverage eligibility requirements derivable factors apply (Lookup code based on lookup type YES_NO). |
DRVD_FCTR_DPNT_CVG_FLAG_M | VARCHAR2 | (4000) | Plan type dependent coverage eligibility requirements derivable factors apply (Lookup meaning based on lookup type YES_NO). | |
NO_MN_PL_TYP_OVERID_FLAG | VARCHAR2 | (30) | Yes | Plan type number of plans no min (Lookup code based on lookup type YES_NO). |
NO_MN_PL_TYP_OVERID_FLAG_M | VARCHAR2 | (4000) | Plan type number of plans no min (Lookup meaning based on lookup type YES_NO). | |
SBJ_TO_SPS_LF_INS_MX_FLAG | VARCHAR2 | (30) | Yes | Plan type subject to spouses max percentage insurance coverage (Lookup code based on lookup type YES_NO). |
SBJ_TO_SPS_LF_INS_MX_FLAG_M | VARCHAR2 | (4000) | Plan type subject to spouses max percentage insurance coverage (Lookup meaning based on lookup type YES_NO). | |
SBJ_TO_DPNT_LF_INS_MX_FLAG | VARCHAR2 | (30) | Yes | Plan type subject to dependents max percentage insurance coverage (Lookup code based on lookup type YES_NO). |
SBJ_TO_DPNT_LF_INS_MX_FLAG_M | VARCHAR2 | (4000) | Plan type subject to dependents max percentage insurance coverage (Lookup meaning based on lookup type YES_NO). | |
USE_TO_SUM_EE_LF_INS_FLAG | VARCHAR2 | (30) | Yes | Plan type sum participants insurance (Lookup code based on lookup type YES_NO). |
USE_TO_SUM_EE_LF_INS_FLAG_M | VARCHAR2 | (4000) | Plan type sum participants insurance (Lookup meaning based on lookup type YES_NO). | |
DRVBL_FCTR_APLS_RTS_FLAG | VARCHAR2 | (30) | Yes | Plan type in program derivable factors apply to rates (Lookup code based on lookup type YES_NO). |
DRVBL_FCTR_APLS_RTS_FLAG_M | VARCHAR2 | (4000) | Plan type in program derivable factors apply to rates (Lookup meaning based on lookup type YES_NO). | |
DRVBL_FCTR_PRTN_ELIG_FLAG | VARCHAR2 | (30) | Yes | Plan type in program derivable factors for participation eligibility (Lookup code based on lookup type YES_NO). |
DRVBL_FCTR_PRTN_ELIG_FLAG_M | VARCHAR2 | (4000) | Plan type in program derivable factors for participation eligibility (Lookup meaning based on lookup type YES_NO). | |
ELIG_APLS_FLAG | VARCHAR2 | (30) | Yes | Plan type in program eligibility applies (Lookup code based on lookup type YES_NO). |
ELIG_APLS_FLAG_M | VARCHAR2 | (4000) | Plan type in program eligibility applies (Lookup meaning based on lookup type YES_NO). | |
PRTN_ELIG_OVRID_ALWD_FLAG | VARCHAR2 | (30) | Yes | Plan type in program participation eligibility override allowed (Lookup code based on lookup type YES_NO). |
PRTN_ELIG_OVRID_ALWD_FLAG_M | VARCHAR2 | (4000) | Plan type in program participation eligibility override allowed (Lookup meaning based on lookup type YES_NO). | |
TRK_INELIG_PER_FLAG | VARCHAR2 | (30) | Yes | Plan type in program track ineligible person (Lookup code based on lookup type YES_NO). |
TRK_INELIG_PER_FLAG_M | VARCHAR2 | (4000) | Plan type in program track ineligible person (Lookup meaning based on lookup type YES_NO). | |
PTIP_ID | NUMBER | (15) | Yes | System generated primary key column. |
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. | |
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. | |
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). | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DPNT_CVG_STRT_DT_RL
, 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
, RQD_PERD_ENRT_NENRT_TM_UOM_M
, IVR_IDENT
, RQD_PERD_ENRT_NENRT_RL
, ENRT_CVG_STRT_DT_RL
, ENRT_CVG_END_DT_RL
, RT_STRT_DT_RL
, RT_END_DT_RL
, URL_REF_NAME
, AUTO_ENRT_MTHD_RL
, ENRT_RL
, DFLT_ENRT_DET_RL
, VRFY_FMLY_MMBR_RL
, SHORT_CODE
, SHORT_NAME
, LEGISLATION_CODE
, LEGISLATION_SUBGROUP
, _DF:CTP
, PTIP_STAT_CD
, PTIP_STAT_CD_M
, DPNT_DSGN_CD
, DPNT_DSGN_CD_M
, DPNT_CVG_STRT_DT_CD
, DPNT_CVG_STRT_DT_CD_M
, DPNT_CVG_END_DT_CD
, DPNT_CVG_END_DT_CD_M
, RQD_ENRT_PERD_TCO_CD
, RQD_ENRT_PERD_TCO_CD_M
, ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT_CD_M
, ENRT_CVG_END_DT_CD
, ENRT_CVG_END_DT_CD_M
, RT_STRT_DT_CD
, RT_STRT_DT_CD_M
, RT_END_DT_CD
, RT_END_DT_CD_M
, ENRT_MTHD_CD
, ENRT_MTHD_CD_M
, ENRT_CD
, ENRT_CD_M
, DFLT_ENRT_CD
, DFLT_ENRT_CD_M
, VRFY_FMLY_MMBR_CD
, VRFY_FMLY_MMBR_CD_M
, PER_CVRD_CD
, PER_CVRD_CD_M
, COORD_CVG_FOR_ALL_PLS_FLAG
, COORD_CVG_FOR_ALL_PLS_FLAG_M
, DPNT_CVG_NO_CTFN_RQD_FLAG
, DPNT_CVG_NO_CTFN_RQD_FLAG_M
, DPNT_ADRS_RQD_FLAG
, DPNT_ADRS_RQD_FLAG_M
, DPNT_LEGV_ID_RQD_FLAG
, DPNT_LEGV_ID_RQD_FLAG_M
, DPNT_DOB_RQD_FLAG
, DPNT_DOB_RQD_FLAG_M
, CRS_THIS_PL_TYP_ONLY_FLAG
, CRS_THIS_PL_TYP_ONLY_FLAG_M
, NO_MX_PL_TYP_OVRID_FLAG
, NO_MX_PL_TYP_OVRID_FLAG_M
, PRVDS_CR_FLAG
, PRVDS_CR_FLAG_M
, WVBL_FLAG
, WVBL_FLAG_M
, DRVD_FCTR_DPNT_CVG_FLAG
, DRVD_FCTR_DPNT_CVG_FLAG_M
, NO_MN_PL_TYP_OVERID_FLAG
, NO_MN_PL_TYP_OVERID_FLAG_M
, SBJ_TO_SPS_LF_INS_MX_FLAG
, SBJ_TO_SPS_LF_INS_MX_FLAG_M
, SBJ_TO_DPNT_LF_INS_MX_FLAG
, SBJ_TO_DPNT_LF_INS_MX_FLAG_M
, USE_TO_SUM_EE_LF_INS_FLAG
, USE_TO_SUM_EE_LF_INS_FLAG_M
, DRVBL_FCTR_APLS_RTS_FLAG
, DRVBL_FCTR_APLS_RTS_FLAG_M
, DRVBL_FCTR_PRTN_ELIG_FLAG
, DRVBL_FCTR_PRTN_ELIG_FLAG_M
, ELIG_APLS_FLAG
, ELIG_APLS_FLAG_M
, PRTN_ELIG_OVRID_ALWD_FLAG
, PRTN_ELIG_OVRID_ALWD_FLAG_M
, TRK_INELIG_PER_FLAG
, TRK_INELIG_PER_FLAG_M
, PTIP_ID
, PL_TYP_ID
, PGM_ID
, BUSINESS_GROUP_ID
, ACRS_PTIP_CVG_ID
, CMBN_PTIP_OPT_ID
, CMBN_PTIP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.BENBV_PTIP_V;
APPS.BENBV_PTIP_V is not referenced by any database object
|
|
|