[Home] [Help] [Dependency Information]
Object Name: | BENBV_ENRT_PERD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BENBV_ENRT_PERD_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 |
---|---|---|---|---|
END_DT | DATE | Yes | Enrollment period end date. | |
STRT_DT | DATE | Yes | Enrollment period strt date. | |
ENRT_CVG_END_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
RT_END_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
DFLT_ENRT_DT | DATE | Default enrollment date. | ||
ENRT_CVG_STRT_DT | DATE | Enrollment coverage start date. | ||
ENRT_CVG_END_DT | DATE | Enrollment coverage end date. | ||
RT_STRT_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
PROCG_END_DT | DATE | Processing end date. | ||
ENRT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
ASND_LF_EVT_DT | DATE | Assigned life event date. | ||
BDGT_UPD_END_DT | DATE | Budget update end date. | ||
BDGT_UPD_STRT_DT | DATE | Budget update start date. | ||
WS_UPD_END_DT | DATE | Worksheet update end date. | ||
WS_UPD_STRT_DT | DATE | Worksheet update start date. | ||
PERF_REVW_STRT_DT | DATE | Performance review start date. | ||
ASG_UPDT_EFF_DATE | DATE | Asignment update effective date. | ||
DATA_FREEZE_DATE | DATE | Data Freeze Date. | ||
HRCHY_RL | NUMBER | (15) | Hierarchy Rule. | |
_DF:ENP | CHAR | (25) | ||
CLS_ENRT_DT_TO_USE_CD | VARCHAR2 | (30) | Close enrollment date to use (Lookup code based on lookup type BEN_CLS_ENRT_DT_TO_USE). | |
CLS_ENRT_DT_TO_USE_CD_M | VARCHAR2 | (4000) | Close enrollment date to use (Lookup meaning based on lookup type BEN_CLS_ENRT_DT_TO_USE). | |
ENRT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Enrollment coverage start date code (Lookup code based on lookup type BEN_ENRT_CVG_STRT). | |
ENRT_CVG_STRT_DT_CD_M | VARCHAR2 | (4000) | Enrollment coverage start date code (Lookup meaning based on lookup type BEN_ENRT_CVG_STRT). | |
ENRT_CVG_END_DT_CD | VARCHAR2 | (30) | Enrollment coverage end date code (Lookup code based on lookup type BEN_ENRT_CVG_END). | |
ENRT_CVG_END_DT_CD_M | VARCHAR2 | (4000) | Enrollment coverage end date code (Lookup meaning based on lookup type BEN_ENRT_CVG_END). | |
RT_STRT_DT_CD | VARCHAR2 | (30) | Rate start date (Lookup code based on lookup type BEN_RT_STRT). | |
RT_STRT_DT_CD_M | VARCHAR2 | (4000) | Rate start date (Lookup meaning based on lookup type BEN_RT_STRT). | |
RT_END_DT_CD | VARCHAR2 | (30) | Rate end date (Lookup code based on lookup type BEN_RT_END). | |
RT_END_DT_CD_M | VARCHAR2 | (4000) | Rate end date (Lookup meaning based on lookup type BEN_RT_END). | |
DFLT_WS_ACC_CD | VARCHAR2 | (30) | Default worksheet access (Lookup code based on lookup type BEN_WS_ACC). | |
DFLT_WS_ACC_CD_M | VARCHAR2 | (4000) | Default worksheet access (Lookup meaning based on lookup type BEN_WS_ACC). | |
EMP_INTERVIEW_TYPE_CD | VARCHAR2 | (30) | Employee interview type (Lookup code based on lookup type EMP_INTERVIEW_TYPE). | |
EMP_INTERVIEW_TYPE_CD_M | VARCHAR2 | (4000) | Employee interview type (Lookup meaning based on lookup type EMP_INTERVIEW_TYPE). | |
HRCHY_TO_USE_CD | VARCHAR2 | (30) | Hierarchy to use (Lookup code based on lookup type BEN_HRCHY_TO_USE). | |
HRCHY_TO_USE_CD_M | VARCHAR2 | (4000) | Hierarchy to use (Lookup meaning based on lookup type BEN_HRCHY_TO_USE). | |
PRSVR_BDGT_CD | VARCHAR2 | (30) | Preserve budget code (Lookup code based on lookup type BEN_PRSVR_BDGT). | |
PRSVR_BDGT_CD_M | VARCHAR2 | (4000) | Preserve budget code (Lookup meaning based on lookup type BEN_PRSVR_BDGT). | |
ENRT_PERD_DET_OVRLP_BCKDT_CD | VARCHAR2 | (30) | Period determination (Lookup code based on lookup type BEN_ENRT_PERD_DET_CD). | |
ENRT_PERD_DET_OVRLP_BCKDT_CD_M | VARCHAR2 | (4000) | Period determination (Lookup meaning based on lookup type BEN_ENRT_PERD_DET_CD). | |
SAL_CHG_REASON_CD | VARCHAR2 | (30) | Salary change reason code(Lookup Code of Lookup Type PROPOSAL_REASON) | |
SAL_CHG_REASON_CD_M | VARCHAR2 | (4000) | Salary change reason code(Lookup meaning of Lookup Type PROPOSAL_REASON) | |
APPROVAL_MODE_CD | VARCHAR2 | (30) | Approval Mode Code (Lookup Code of Lookup Type BEN_CWB_APPROVAL_MODE) | |
APPROVAL_MODE_CD_M | VARCHAR2 | (4000) | Approval Mode Code (Lookup meaning of Lookup Type BEN_CWB_APPROVAL_MODE) | |
HRCHY_AME_TRN_CD | VARCHAR2 | (30) | Hierarchy AME Code | |
HRCHY_AME_TRN_CD_M | VARCHAR2 | (4000) | ||
AUTO_DISTR_FLAG | VARCHAR2 | (30) | Yes | Auto distribute (Lookup code based on lookup type YES_NO). |
AUTO_DISTR_FLAG_M | VARCHAR2 | (4000) | Auto distribute (Lookup meaning based on lookup type YES_NO). | |
USES_BDGT_FLAG | VARCHAR2 | (30) | Yes | Uses budget (Lookup code based on lookup type YES_NO). |
USES_BDGT_FLAG_M | VARCHAR2 | (4000) | Uses budget (Lookup meaning based on lookup type YES_NO). | |
ENRT_PERD_ID | NUMBER | (15) | Yes | System generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS. |
POPL_ENRT_TYP_CYCL_ID | NUMBER | (15) | Yes | Foreign key to BEN_POPL_ENRT_TYP_CYCL_F. |
YR_PERD_ID | NUMBER | (15) | Yes | Foreign key to BEN_YR_PERD. |
LER_ID | NUMBER | (15) | Foreign key to BEN_LER_F. | |
POS_STRUCTURE_VERSION_ID | NUMBER | (15) | Foreign key to PER_POS_STRUCTURE_VERSIONS. | |
WTHN_YR_PERD_ID | NUMBER | (15) | Foreign key to BEN_WTHN_YR_PERD. | |
HRCHY_AME_APP_ID | NUMBER | (15) | ||
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 END_DT
, STRT_DT
, ENRT_CVG_END_DT_RL
, RT_END_DT_RL
, DFLT_ENRT_DT
, ENRT_CVG_STRT_DT
, ENRT_CVG_END_DT
, RT_STRT_DT_RL
, PROCG_END_DT
, ENRT_CVG_STRT_DT_RL
, ASND_LF_EVT_DT
, BDGT_UPD_END_DT
, BDGT_UPD_STRT_DT
, WS_UPD_END_DT
, WS_UPD_STRT_DT
, PERF_REVW_STRT_DT
, ASG_UPDT_EFF_DATE
, DATA_FREEZE_DATE
, HRCHY_RL
, _DF:ENP
, CLS_ENRT_DT_TO_USE_CD
, CLS_ENRT_DT_TO_USE_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
, DFLT_WS_ACC_CD
, DFLT_WS_ACC_CD_M
, EMP_INTERVIEW_TYPE_CD
, EMP_INTERVIEW_TYPE_CD_M
, HRCHY_TO_USE_CD
, HRCHY_TO_USE_CD_M
, PRSVR_BDGT_CD
, PRSVR_BDGT_CD_M
, ENRT_PERD_DET_OVRLP_BCKDT_CD
, ENRT_PERD_DET_OVRLP_BCKDT_CD_M
, SAL_CHG_REASON_CD
, SAL_CHG_REASON_CD_M
, APPROVAL_MODE_CD
, APPROVAL_MODE_CD_M
, HRCHY_AME_TRN_CD
, HRCHY_AME_TRN_CD_M
, AUTO_DISTR_FLAG
, AUTO_DISTR_FLAG_M
, USES_BDGT_FLAG
, USES_BDGT_FLAG_M
, ENRT_PERD_ID
, BUSINESS_GROUP_ID
, POPL_ENRT_TYP_CYCL_ID
, YR_PERD_ID
, LER_ID
, POS_STRUCTURE_VERSION_ID
, WTHN_YR_PERD_ID
, HRCHY_AME_APP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.BENBV_ENRT_PERD_V;
APPS.BENBV_ENRT_PERD_V is not referenced by any database object
|
|
|