Benefit Formula Input
Values:
|
Formula Type Base Name
|
Input Values
|
|
Coverage Amount Limit
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_RT_STRT_DT
|
|
|
Coverage Lower Limit
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_RT_STRT_DT
|
|
|
Default to Assign Pending Action
|
BEN_PEN_IV_PRTT_ENRT_RSLT_ID
|
|
BEN_PER_IV_PERSON_ID
|
|
|
BEN_PIL_IV_PER_IN_LER_ID
|
|
|
Dependent Coverage End Date
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
BEN_IV_EFFECTIVE_DATE
|
|
|
Dependent Coverage Start Date
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
BEN_IV_EFFECTIVE_DATE
|
|
|
Dependent Eligibility
|
BEN_ELP_I_ELIGY_PRFL_ID
|
|
BEN_IV_RT_STRT_DT
|
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
Eligibility Access Calculation Rule
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
Enrollment Coverage Start Date
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
BEN_IV_EFFECTIVE_DATE
|
|
|
Enrollment End
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
BEN_IV_EFFECTIVE_DATE
|
|
|
Enrollment Period End Date
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
BEN_IV_EFFECTIVE_DATE
|
|
|
Enrollment Period Start Date
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
BEN_IV_EFFECTIVE_DATE
|
|
|
Family Member Determination
|
PERSON_ID
|
|
BEN_IV_RT_STRT_DT
|
|
|
BEN_IV_CVG_STRT_DT
|
|
|
Maximum Coverage Amount Calculation
|
BEN_IV_PERSON_ID
|
|
Maximum Period of Enrollment Value and UOM
|
BEN_IV_PERSON_ID
|
|
Participation Eligibility End Date
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
Participation Eligibility Start Date
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
Participation and Rate Eligibility
|
BEN_ELP_I_ELIGY_PRFL_ID
|
|
BEN_IV_RT_STRT_DT
|
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
Person Change Causes Life Event
(Different set of inputvalues passed for different table/columns) |
BEN_SAL_IN_ASSIGNMENT_ID
|
|
BEN_SAL_IO_ASSIGNMENT_ID
|
|
|
BEN_SAL_IN_SALARY_AMOUNT
|
|
|
BEN_SAL_IO_SALARY_AMOUNT
|
|
|
BEN_SAL_IN_SALARY_BASIS_ID
|
|
|
BEN_SAL_IO_SALARY_BASIS_ID
|
|
|
BEN_SAL_IN_NEXT_PERF_REVIEW_DATE
|
|
|
BEN_SAL_IO_NEXT_PERF_REVIEW_DATE
|
|
|
BEN_SAL_IN_NEXT_SAL_REVIEW_DATE
|
|
|
BEN_SAL_IO_NEXT_SAL_REVIEW_DATE
|
|
|
BEN_SAL_IN_SALARY_REASON_CODE
|
|
|
BEN_SAL_IO_SALARY_REASON_CODE
|
|
|
BEN_SAL_IN_DATE_FROM
|
|
|
BEN_SAL_IO_DATE_FROM
|
|
|
BEN_SAL_IN_DATE_TO
|
|
|
BEN_SAL_IO_DATE_TO
|
|
|
BEN_SAL_IN_ELEMENT_ENTRY_ID
|
|
|
BEN_SAL_IO_ELEMENT_ENTRY_ID
|
|
|
BEN_SAL_IN_FORCED_RANKING
|
|
|
BEN_SAL_IO_FORCED_RANKING
|
|
|
BEN_SAL_IN_PERFORMANCE_RATING
|
|
|
BEN_SAL_IN_PERFORMANCE_REVIEW_ID
|
|
|
BEN_SAL_IN_REVIEW_DATE
|
|
|
BEN_SAL_IO_REVIEW_DATE
|
|
|
BEN_SAL_IN_SALARY_BASIS_NAME
|
|
|
BEN_SAL_IO_SALARY_BASIS_NAME
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PTU_IN_PERSON_TYPE_USAGE_ID
|
|
|
BEN_PTU_IO_PERSON_TYPE_USAGE_ID
|
|
|
BEN_PTU_IN_EFFECTIVE_START_DATE
|
|
|
BEN_PTU_IO_EFFECTIVE_START_DATE
|
|
|
BEN_PTU_IN_EFFECTIVE_END_DATE
|
|
|
BEN_PTU_IO_EFFECTIVE_END_DATE
|
|
|
BEN_PTU_IN_PERSON_ID
|
|
|
BEN_PTU_IO_PERSON_ID
|
|
|
BEN_IV_LER_ID
|
|
|
BEN_PTU_IN_PERSON_TYPE_ID
|
|
|
BEN_PTU_IO_PERSON_TYPE_ID
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PSS_IN_PERSON_ID
|
|
|
BEN_PSS_IO_PERSON_ID
|
|
|
BEN_PSS_IN_BUSINESS_GROUP_ID
|
|
|
BEN_PSS_IO_BUSINESS_GROUP_ID
|
|
|
BEN_PSS_IN_EXPIRATION_DATE
|
|
|
BEN_PSS_IO_EXPIRATION_DATE
|
|
|
BEN_PSS_IN_ISSUE_DATE
|
|
|
BEN_PSS_IO_ISSUE_DATE
|
|
|
BEN_PSS_IN_ISSUING_AUTHORITY
|
|
|
BEN_PSS_IO_ISSUING_AUTHORITY
|
|
|
BEN_PSS_IN_ISSUING_COUNTRY
|
|
|
BEN_PSS_IO_ISSUING_COUNTRY
|
|
|
BEN_PSS_IN_ISSUING_LOCATION
|
|
|
BEN_PSS_IO_ISSUING_LOCATION
|
|
|
BEN_PSS_IN_LEGISLATION_CODE
|
|
|
BEN_PSS_IO_LEGISLATION_CODE
|
|
|
BEN_PSS_IN_PASSPORT_ID
|
|
|
BEN_PSS_IN_PASSPORT_NUMBER
|
|
|
BEN_PSS_IO_PASSPORT_NUMBER
|
|
|
BEN_PSS_IN_PASSPORT_TYPE
|
|
|
BEN_PSS_IO_PASSPORT_TYPE
|
|
|
BEN_PSS_IN_PERSON_ID
|
|
|
BEN_PSS_IO_PERSON_ID
|
|
|
BEN_PSS_IN_PROFESSION
|
|
|
BEN_PSS_IO_PROFESSION
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PRV_IN_ACTY_TYP_CD
|
|
|
BEN_PRV_IO_ACTY_TYP_CD
|
|
|
BEN_PRV_IN_ANN_RT_VAL
|
|
|
BEN_PRV_IO_ANN_RT_VAL
|
|
|
BEN_PRV_IN_CMCD_RT_VAL
|
|
|
BEN_PRV_IO_CMCD_RT_VAL
|
|
|
BEN_PRV_IN_ELCTNS_MADE_DT
|
|
|
BEN_PRV_IO_ELCTNS_MADE_DT
|
|
|
BEN_PRV_IN_PRTT_RT_VAL_STAT_CD
|
|
|
BEN_PRV_IO_PRTT_RT_VAL_STAT_CD
|
|
|
BEN_PRV_IN_RT_END_DT
|
|
|
BEN_PRV_IO_RT_END_DT
|
|
|
BEN_PRV_IN_RT_OVRIDN_FLAG
|
|
|
BEN_PRV_IO_RT_OVRIDN_FLAG
|
|
|
BEN_PRV_IN_RT_OVRIDN_THRU_DT
|
|
|
BEN_PRV_IO_RT_OVRIDN_THRU_DT
|
|
|
BEN_PRV_IN_RT_STRT_DT
|
|
|
BEN_PRV_IO_RT_STRT_DT
|
|
|
BEN_PRV_IN_RT_VAL
|
|
|
BEN_PRV_IO_RT_VAL
|
|
|
BEN_PRV_IO_TX_TYP_CD
|
|
|
BEN_PRV_IN_TX_TYP_CD
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PPS_IN_DATE_START
|
|
|
BEN_PPS_IO_DATE_START
|
|
|
BEN_PPS_IN_ACCEPTED_TERMINATION_DATE
|
|
|
BEN_PPS_IO_ACCEPTED_TERMINATION_DATE
|
|
|
BEN_PPS_IN_ACTION_OCCURRENCE_ID
|
|
|
BEN_PPS_IO_ACTION_OCCURRENCE_ID
|
|
|
BEN_PPS_IN_ACTUAL_TERMINATION_DATE
|
|
|
BEN_PPS_IO_ACTUAL_TERMINATION_DATE
|
|
|
BEN_PPS_IN_ADJUSTED_SVC_DATE
|
|
|
BEN_PPS_IO_ADJUSTED_SVC_DATE
|
|
|
BEN_PPS_IN_DATE_START
|
|
|
BEN_PPS_IO_DATE_START
|
|
|
BEN_PPS_IN_LAST_WORKING_DATE
|
|
|
BEN_PPS_IO_LAST_WORKING_DATE
|
|
|
BEN_PPS_IN_LEGAL_ENTITY_ID
|
|
|
BEN_PPS_IO_LEGAL_ENTITY_ID
|
|
|
BEN_PPS_IN_LEGISLATION_CODE
|
|
|
BEN_PPS_IO_LEGISLATION_CODE
|
|
|
BEN_PPS_IN_NOTIFIED_TERMINATION_DATE
|
|
|
BEN_PPS_IO_NOTIFIED_TERMINATION_DATE
|
|
|
BEN_PPS_IN_ON_MILITARY_SERVICE
|
|
|
BEN_PPS_IO_ON_MILITARY_SERVICE
|
|
|
BEN_PPS_IN_ORIGINAL_DATE_OF_HIRE
|
|
|
BEN_PPS_IO_ORIGINAL_DATE_OF_HIRE
|
|
|
BEN_PPS_IN_PRIMARY_FLAG
|
|
|
BEN_PPS_IO_PRIMARY_FLAG
|
|
|
BEN_PPS_IN_PROJECTED_TERMINATION_DATE
|
|
|
BEN_PPS_IO_PROJECTED_TERMINATION_DATE
|
|
|
BEN_PPS_IN_WORKER_NUMBER
|
|
|
BEN_PPS_IO_WORKER_NUMBER
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PPL_IN_PERSON_ID
|
|
|
BEN_PPL_IO_PERSON_ID
|
|
|
BEN_PPL_IN_BUSINESS_GROUP_ID
|
|
|
BEN_PPL_IO_BUSINESS_GROUP_ID
|
|
|
BEN_PPL_IN_EFFECTIVE_END_DATE
|
|
|
BEN_PPL_IO_EFFECTIVE_END_DATE
|
|
|
BEN_PPL_IN_EFFECTIVE_START_DATE
|
|
|
BEN_PPL_IO_EFFECTIVE_START_DATE
|
|
|
BEN_PPL_IN_HIGHEST_EDUCATION_LEVEL
|
|
|
BEN_PPL_IO_HIGHEST_EDUCATION_LEVEL
|
|
|
BEN_PPL_IN_LEGISLATION_CODE
|
|
|
BEN_PPL_IO_LEGISLATION_CODE
|
|
|
BEN_PPL_IN_MARITAL_STATUS
|
|
|
BEN_PPL_IO_MARITAL_STATUS
|
|
|
BEN_PPL_IN_MARITAL_STATUS_DATE
|
|
|
BEN_PPL_IO_MARITAL_STATUS_DATE
|
|
|
BEN_PPL_IN_PERSON_ID
|
|
|
BEN_PPL_IO_PERSON_ID
|
|
|
BEN_PPL_IN_PERSON_LEGISLATIVE_ID
|
|
|
BEN_PPL_IO_PERSON_LEGISLATIVE_ID
|
|
|
BEN_PPL_IN_SEX
|
|
|
BEN_PPL_IO_SEX
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PPF_IN_ATTRIBUTE1
.. 6
|
|
|
BEN_PPF_IO_ATTRIBUTE1
.. 6
|
|
|
BEN_PPF_IN_ATTRIBUTE_CATEGORY
|
|
|
BEN_PPF_IO_ATTRIBUTE_CATEGORY
|
|
|
BEN_PPF_IN_MAILING_ADDRESS_ID
|
|
|
BEN_PPF_IO_MAILING_ADDRESS_ID
|
|
|
BEN_PPF_IN_PERSON_NUMBER
|
|
|
BEN_PPF_IO_PERSON_NUMBER
|
|
|
BEN_PPF_IN_PRIMARY_EMAIL_ID
|
|
|
BEN_PPF_IO_PRIMARY_EMAIL_ID
|
|
|
BEN_PPF_IN_PRIMARY_NID_ID
|
|
|
BEN_PPF_IO_PRIMARY_NID_ID
|
|
|
BEN_PPF_IN_APPLICANT_NUMBER
|
|
|
BEN_PPF_IO_APPLICANT_NUMBER
|
|
|
BEN_PPF_IN_WAIVE_DATA_PROTECT
|
|
|
BEN_PPF_IO_WAIVE_DATA_PROTECT
|
|
|
BEN_PPF_IN_START_DATE
|
|
|
BEN_PPF_IO_START_DATE
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PPE_IN_PERSON_ID
|
|
|
BEN_PPE_IO_PERSON_ID
|
|
|
BEN_PPE_IN_BLOOD_TYPE
|
|
|
BEN_PPE_IO_BLOOD_TYPE
|
|
|
BEN_PPE_IN_BUSINESS_GROUP_ID
|
|
|
BEN_PPE_IO_BUSINESS_GROUP_ID
|
|
|
BEN_PPE_IN_CORRESPONDENCE_LANGUAGE
|
|
|
BEN_PPE_IO_CORRESPONDENCE_LANGUAGE
|
|
|
BEN_PPE_IN_COUNTRY_OF_BIRTH
|
|
|
BEN_PPE_IO_COUNTRY_OF_BIRTH
|
|
|
BEN_PPE_IN_DATE_OF_BIRTH
|
|
|
BEN_PPE_IO_DATE_OF_BIRTH
|
|
|
BEN_PPE_IN_DATE_OF_DEATH
|
|
|
BEN_PPE_IO_DATE_OF_DEATH
|
|
|
BEN_PPE_IN_PARTY_ID
|
|
|
BEN_PPE_IO_PARTY_ID
|
|
|
BEN_PPE_IN_PERSON_ID
|
|
|
BEN_PPE_IO_PERSON_ID
|
|
|
BEN_PPE_IN_REGION_OF_BIRTH
|
|
|
BEN_PPE_IO_REGION_OF_BIRTH
|
|
|
BEN_PPE_IN_START_DATE
|
|
|
BEN_PPE_IO_START_DATE
|
|
|
BEN_PPE_IN_TOWN_OF_BIRTH
|
|
|
BEN_PPE_IO_TOWN_OF_BIRTH
|
|
|
BEN_PPE_IN_USER_GUID
|
|
|
BEN_PPE_IO_USER_GUID
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_NID_IN_NATIONAL_IDENTIFIER_ID
|
|
|
BEN_NID_IO_NATIONAL_IDENTIFIER_ID
|
|
|
BEN_NID_IN_NATIONAL_IDENTIFIER_TYPE
|
|
|
BEN_NID_IO_NATIONAL_IDENTIFIER_TYPE
|
|
|
BEN_NID_IN_BUSINESS_GROUP_ID
|
|
|
BEN_NID_IO_BUSINESS_GROUP_ID
|
|
|
BEN_NID_IN_CREATED_BY
|
|
|
BEN_NID_IO_CREATED_BY
|
|
|
BEN_NID_IN_ISSUE_DATE
|
|
|
BEN_NID_IO_ISSUE_DATE
|
|
|
BEN_NID_IN_EXPIRATION_DATE
|
|
|
BEN_NID_IO_EXPIRATION_DATE
|
|
|
BEN_NID_IN_LAST_UPDATED_BY
|
|
|
BEN_NID_IO_LAST_UPDATED_BY
|
|
|
BEN_NID_IN_LAST_UPDATE_LOGIN
|
|
|
BEN_NID_IO_LAST_UPDATE_LOGIN
|
|
|
BEN_NID_IN_NATIONAL_IDENTIFIER_NUMBER
|
|
|
BEN_NID_IO_NATIONAL_IDENTIFIER_NUMBER
|
|
|
BEN_NID_IN_LEGISLATION_CODE
|
|
|
BEN_NID_IO_LEGISLATION_CODE
|
|
|
BEN_NID_IN_PLACE_OF_ISSUE
|
|
|
BEN_NID_IO_PLACE_OF_ISSUE
|
|
|
BEN_NID_IN_PERSON_ID
|
|
|
BEN_NID_IO_PERSON_ID
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
|
|
|
BEN_PEI_IN_PERSON_ID
|
|
|
BEN_PEI_IO_PERSON_ID
|
|
|
BEN_PEI_IN_EFFECTIVE_END_DATE
|
|
|
BEN_PEI_IO_EFFECTIVE_END_DATE
|
|
|
BEN_PEI_IN_EFFECTIVE_START_DATE
|
|
|
BEN_PEI_IO_EFFECTIVE_START_DATE
|
|
|
BEN_PEI_IN_PERSON_EXTRA_INFO_ID
|
|
|
BEN_PEI_IO_PERSON_EXTRA_INFO_ID
|
|
|
BEN_PEI_IN_PERSON_ID
|
|
|
BEN_PEI_IO_PERSON_ID
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PEE_IN_PERSON_ID
|
|
|
BEN_PEE_IO_PERSON_ID
|
|
|
BEN_PEE_IN_EFFECTIVE_END_DATE
|
|
|
BEN_PEE_IO_EFFECTIVE_END_DATE
|
|
|
BEN_PEE_IN_EFFECTIVE_START_DATE
|
|
|
BEN_PEE_IO_EFFECTIVE_START_DATE
|
|
|
BEN_PEE_IN_ELEMENT_ENTRY_ID
|
|
|
BEN_PEE_IO_ELEMENT_ENTRY_ID
|
|
|
BEN_PEE_IN_ELEMENT_ENTRY_VALUE_ID
|
|
|
BEN_PEE_IO_ELEMENT_ENTRY_VALUE_ID
|
|
|
BEN_PEE_IN_ENTRY_USAGE_ID
|
|
|
BEN_PEE_IO_ENTRY_USAGE_ID
|
|
|
BEN_PEE_IN_INPUT_VALUE_ID
|
|
|
BEN_PEE_IO_INPUT_VALUE_ID
|
|
|
BEN_PEE_IN_SCREEN_ENTRY_VALUE
|
|
|
BEN_PEE_IO_SCREEN_ENTRY_VALUE
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PDP_IN_PERSON_ID
|
|
|
BEN_PDP_IO_PERSON_ID
|
|
|
BEN_PDP_IN_CVG_PNDG_FLAG
|
|
|
BEN_PDP_IO_CVG_PNDG_FLAG
|
|
|
BEN_PDP_IN_CVG_STRT_DT
|
|
|
BEN_PDP_IO_CVG_STRT_DT
|
|
|
BEN_PDP_IN_CVG_THRU_DT
|
|
|
BEN_PDP_IO_CVG_THRU_DT
|
|
|
BEN_PDP_IN_DPNT_PERSON_ID
|
|
|
BEN_PDP_IO_DPNT_PERSON_ID
|
|
|
BEN_PDP_IN_ELIG_PER_ELCTBL_CHC_ID
|
|
|
BEN_PDP_IO_ELIG_PER_ELCTBL_CHC_ID
|
|
|
BEN_PDP_IN_ENDED_CVG_THRU_DT
|
|
|
BEN_PDP_IO_ENDED_CVG_THRU_DT
|
|
|
BEN_PDP_IN_ENDED_PER_IN_LER_ID
|
|
|
BEN_PDP_IO_ENDED_PER_IN_LER_ID
|
|
|
BEN_PDP_IN_OVRDN_FLAG
|
|
|
BEN_PDP_IO_OVRDN_FLAG
|
|
|
BEN_PDP_IN_OVRDN_THRU_DT
|
|
|
BEN_PDP_IO_OVRDN_THRU_DT
|
|
|
BEN_PDP_IN_PRTT_ENRT_RSLT_ID
|
|
|
BEN_PDP_IO_PRTT_ENRT_RSLT_ID
|
|
|
BEN_PDP_IN_PRVS_CVG_STRT_DT
|
|
|
BEN_PDP_IO_PRVS_CVG_STRT_DT
|
|
|
BEN_PDP_IN_PRVS_CVG_THRU_DT
|
|
|
BEN_PDP_IO_PRVS_CVG_THRU_DT
|
|
|
BEN_PDP_IN_RLNSHP_CD
|
|
|
BEN_PDP_IO_RLNSHP_CD
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_PBB_IN_PERSON_ID
|
|
|
BEN_PBB_IO_PERSON_ID
|
|
|
BEN_PBB_IN_EFFECTIVE_START_DATE
|
|
|
BEN_PBB_IO_EFFECTIVE_START_DATE
|
|
|
BEN_PBB_IN_EFFECTIVE_END_DATE
|
|
|
BEN_PBB_IO_EFFECTIVE_END_DATE
|
|
|
BEN_PBB_IN_VAL
|
|
|
BEN_PBB_IO_VAL
|
|
|
BEN_PBB_IN_BNFTS_BAL_ID
|
|
|
BEN_PBB_IO_BNFTS_BAL_ID
|
|
|
BEN_IV_LER_ID
|
|
|
BEN_PBB_IN_UOM
|
|
|
BEN_PBB_IO_UOM
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_ADD_IN_ADDRESS_ID
|
|
|
BEN_ADD_IO_ADDRESS_ID
|
|
|
BEN_ADD_IN_ADDRESS_TYPE
|
|
|
BEN_ADD_IO_ADDRESS_TYPE
|
|
|
BEN_ADD_IN_BUSINESS_GROUP_ID
|
|
|
BEN_ADD_IO_BUSINESS_GROUP_ID
|
|
|
BEN_ADD_IN_CREATED_BY
|
|
|
BEN_ADD_IO_CREATED_BY
|
|
|
BEN_ADD_IN_EFFECTIVE_END_DATE
|
|
|
BEN_ADD_IO_EFFECTIVE_END_DATE
|
|
|
BEN_ADD_IN_EFFECTIVE_START_DATE
|
|
|
BEN_ADD_IO_EFFECTIVE_START_DATE
|
|
|
BEN_ADD_IN_LAST_UPDATED_BY
|
|
|
BEN_ADD_IO_LAST_UPDATED_BY
|
|
|
BEN_ADD_IN_LAST_UPDATE_LOGIN
|
|
|
BEN_ADD_IO_LAST_UPDATE_LOGIN
|
|
|
BEN_ADD_IN_OBJECT_VERSION_NUMBER
|
|
|
BEN_ADD_IO_OBJECT_VERSION_NUMBER
|
|
|
BEN_ADD_IN_PERSON_ADDR_USAGE_ID
|
|
|
BEN_ADD_IO_PERSON_ADDR_USAGE_ID
|
|
|
BEN_ADD_IN_PERSON_ID
|
|
|
BEN_ADD_IO_PERSON_ID
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_LEH_IN_PERSON_ID
|
|
|
BEN_LEH_IO_PERSON_ID
|
|
|
BEN_LEH_IN_EFFECTIVE_START_DATE
|
|
|
BEN_LEH_IO_EFFECTIVE_START_DATE
|
|
|
BEN_LEH_IN_EFFECTIVE_END_DATE
|
|
|
BEN_LEH_IO_EFFECTIVE_END_DATE
|
|
|
BEN_LEH_IN_LE_HABITS_COV_ID
|
|
|
BEN_LEH_IO_LE_HABITS_COV_ID
|
|
|
BEN_LEH_IN_LEGISLATIVE_DATA_GROUP_ID
|
|
|
BEN_LEH_IO_LEGISLATIVE_DATA_GROUP_ID
|
|
|
BEN_IV_LER_ID
|
|
|
BEN_LEH_IN_DISABILITY_STATUS
|
|
|
BEN_LEH_IO_DISABILITY_STATUS
|
|
|
BEN_LEH_IN_DPDNT_ADOPTION_DATE
|
|
|
BEN_LEH_IO_DPDNT_ADOPTION_DATE
|
|
|
BEN_LEH_IN_DPDNT_VLNTRY_SVCE_FLAG
|
|
|
BEN_LEH_IO_DPDNT_VLNTRY_SVCE_FLAG
|
|
|
BEN_LEH_IN_ON_MILITARY_SERVICE
|
|
|
BEN_LEH_IO_ON_MILITARY_SERVICE
|
|
|
BEN_LEH_IN_RECEIPT_OF_DEATH_CERT_DATE
|
|
|
BEN_LEH_IO_RECEIPT_OF_DEATH_CERT_DATE
|
|
|
BEN_LEH_IN_REGISTERED_DISABLED_FLAG
|
|
|
BEN_LEH_IO_REGISTERED_DISABLED_FLAG
|
|
|
BEN_LEH_IN_STUDENT_STATUS
|
|
|
BEN_LEH_IO_STUDENT_STATUS
|
|
|
BEN_LEH_IN_TOBACCO_TYPE_USAGE
|
|
|
BEN_LEH_IO_TOBACCO_TYPE_USAGE
|
|
|
BEN_IV_CONTACT_TYPE
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
|
|
|
BEN_EGD_IN_INELG_RSN_CD
|
|
|
BEN_EGD_IO_INELG_RSN_CD
|
|
|
BEN_EGD_IN_DPNT_INELIG_FLAG
|
|
|
BEN_EGD_IO_DPNT_INELIG_FLAG
|
|
|
BEN_EGD_IN_ELIG_STRT_DT
|
|
|
BEN_EGD_IO_ELIG_STRT_DT
|
|
|
BEN_EGD_IN_ELIG_THRU_DT
|
|
|
BEN_EGD_IO_ELIG_THRU_DT
|
|
|
BEN_EGD_IN_OVRDN_FLAG
|
|
|
BEN_EGD_IO_OVRDN_FLAG
|
|
|
BEN_EGD_IN_OVRDN_THRU_DT
|
|
|
BEN_EGD_IO_OVRDN_THRU_DT
|
|
|
BEN_EGD_IN_CREATE_DT
|
|
|
BEN_EGD_IO_CREATE_DT
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_DIS_IN_PERSON_ID
|
|
|
BEN_DIS_IO_PERSON_ID
|
|
|
BEN_DIS_IN_ASSESSMENT_DUE_DATE
|
|
|
BEN_DIS_IO_ASSESSMENT_DUE_DATE
|
|
|
BEN_DIS_IN_CATEGORY
|
|
|
BEN_DIS_IO_CATEGORY
|
|
|
BEN_DIS_IN_DEGREE
|
|
|
BEN_DIS_IO_DEGREE
|
|
|
BEN_DIS_IN_DESCRIPTION
|
|
|
BEN_DIS_IO_DESCRIPTION
|
|
|
BEN_DIS_IN_EFFECTIVE_END_DATE
|
|
|
BEN_DIS_IO_EFFECTIVE_END_DATE
|
|
|
BEN_DIS_IN_EFFECTIVE_START_DATE
|
|
|
BEN_DIS_IO_EFFECTIVE_START_DATE
|
|
|
BEN_DIS_IN_INCIDENT_ID
|
|
|
BEN_DIS_IO_INCIDENT_ID
|
|
|
BEN_DIS_IN_LEGISLATION_CODE
|
|
|
BEN_DIS_IO_LEGISLATION_CODE
|
|
|
BEN_DIS_IN_ORGANIZATION_ID
|
|
|
BEN_DIS_IO_ORGANIZATION_ID
|
|
|
BEN_DIS_IN_QUOTA_FTE
|
|
|
BEN_DIS_IO_QUOTA_FTE
|
|
|
BEN_DIS_IN_REGISTRATION_DATE
|
|
|
BEN_DIS_IO_REGISTRATION_DATE
|
|
|
BEN_DIS_IN_REGISTRATION_EXP_DATE
|
|
|
BEN_DIS_IO_REGISTRATION_EXP_DATE
|
|
|
BEN_DIS_IN_REGISTRATION_ID
|
|
|
BEN_DIS_IO_REGISTRATION_ID
|
|
|
BEN_DIS_IN_STATUS
|
|
|
BEN_DIS_IO_STATUS
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
|
|
|
BEN_CRD_IN_CRT_ORDR_PL_DPNT_ID
|
|
|
BEN_CRD_IO_CRT_ORDR_PL_DPNT_ID
|
|
|
BEN_CRD_IN_BUSINESS_GROUP_ID
|
|
|
BEN_CRD_IO_BUSINESS_GROUP_ID
|
|
|
BEN_CRD_IN_CONTACT_PERSON_ID
|
|
|
BEN_CRD_IO_CONTACT_PERSON_ID
|
|
|
BEN_CRD_IN_CRT_ORDR_ID
|
|
|
BEN_CRD_IO_CRT_ORDR_ID
|
|
|
BEN_CRD_IN_PL_TYP_ID
|
|
|
BEN_CRD_IO_PL_TYP_ID
|
|
|
BEN_CRD_IN_PL_ID
|
|
|
BEN_CRD_IO_PL_ID
|
|
|
BEN_CRD_IN_RLSHP_TYP_CD
|
|
|
BEN_CRD_IO_RLSHP_TYP_CD
|
|
|
BEN_CRD_IN_ORDR_END_DATE
|
|
|
BEN_CRD_IO_ORDR_END_DATE
|
|
|
BEN_CRD_IN_ORDR_START_DATE
|
|
|
BEN_CRD_IO_ORDR_START_DATE
|
|
|
BEN_CRD_IN_PRVNT_DEENRT_FLAG
|
|
|
BEN_CRD_IO_PRVNT_DEENRT_FLAG
|
|
|
BEN_CRD_IN_CRD_ATTRIBUTE_CATEGORY
|
|
|
BEN_CRD_IO_CRD_ATTRIBUTE_CATEGORY
|
|
|
BEN_CRD_IN_CRD_ATTRIBUTE1 ..30
|
|
|
BEN_CRD_IO_CRD_ATTRIBUTE1 ..30
|
|
|
BEN_CRD_IN_CRD_ATTRIBUTE_NUMBER1 .. 20
|
|
|
BEN_CRD_IO_CRD_ATTRIBUTE_NUMBER1 .. 20
|
|
|
BEN_CRD_IN_CRD_ATTRIBUTE_DATE1 .. 15
|
|
|
BEN_CRD_IO_CRD_ATTRIBUTE_DATE1 .. 15
|
|
|
BEN_CRD_IN_LAST_UPDATE_DATE
|
|
|
BEN_CRD_IO_LAST_UPDATE_DATE
|
|
|
BEN_CRD_IN_LAST_UPDATED_BY
|
|
|
BEN_CRD_IO_LAST_UPDATED_BY
|
|
|
BEN_CRD_IN_LAST_UPDATE_LOGIN
|
|
|
BEN_CRD_IO_LAST_UPDATE_LOGIN
|
|
|
BEN_CRD_IN_CREATED_BY
|
|
|
BEN_CRD_IO_CREATED_BY
|
|
|
BEN_CRD_IN_CREATION_DATE
|
|
|
BEN_CRD_IO_CREATION_DATE
|
|
|
BEN_CRD_IN_OBJECT_VERSION_NUMBER
|
|
|
BEN_CRD_IO_OBJECT_VERSION_NUMBER
|
|
|
BEN_CRD_IN_CONFIG_ID_1 .. 10
|
|
|
BEN_CRD_IO_CONFIG_ID_1 .. 10
|
|
|
BEN_CRD_IN_CONFIG_NUM_1 .. 10
|
|
|
BEN_CRD_IO_CONFIG_NUM_1 .. 10
|
|
|
BEN_CRD_IN_CONFIG_CHAR_1 .. 10
|
|
|
BEN_CRD_IO_CONFIG_CHAR_1 .. 10
|
|
|
BEN_CRD_IN_CONFIG_DATE_1 .. 10
|
|
|
BEN_CRD_IO_CONFIG_DATE_1 .. 10
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
|
|
|
BEN_CRT_IN_CRT_ORDR_ID
|
|
|
BEN_CRT_IO_CRT_ORDR_ID
|
|
|
BEN_CRT_IN_EFFECTIVE_START_DATE
|
|
|
BEN_CRT_IO_EFFECTIVE_START_DATE
|
|
|
BEN_CRT_IN_EFFECTIVE_END_DATE
|
|
|
BEN_CRT_IO_EFFECTIVE_END_DATE
|
|
|
BEN_CRT_IN_CRT_ORDR_TYP_CD
|
|
|
BEN_CRT_IO_CRT_ORDR_TYP_CD
|
|
|
BEN_CRT_IN_CRT_ORDR_STAT_CD
|
|
|
BEN_CRT_IO_CRT_ORDR_STAT_CD
|
|
|
BEN_CRT_IN_BUSINESS_GROUP_ID
|
|
|
BEN_CRT_IO_BUSINESS_GROUP_ID
|
|
|
BEN_CRT_IN_CONTACT_PERSON_ID
|
|
|
BEN_CRT_IO_CONTACT_PERSON_ID
|
|
|
BEN_CRT_IN_CRT_ORDR_ID
|
|
|
BEN_CRT_IO_CRT_ORDR_ID
|
|
|
BEN_CRT_IN_PL_TYP_ID
|
|
|
BEN_CRT_IO_PL_TYP_ID
|
|
|
BEN_CRT_IN_PL_ID
|
|
|
BEN_CRT_IO_PL_ID
|
|
|
BEN_CRT_IN_RLSHP_TYP_CD
|
|
|
BEN_CRT_IO_RLSHP_TYP_CD
|
|
|
BEN_CRT_IN_ORDR_END_DATE
|
|
|
BEN_CRT_IO_ORDR_END_DATE
|
|
|
BEN_CRT_IN_ORDR_START_DATE
|
|
|
BEN_CRT_IO_ORDR_START_DATE
|
|
|
BEN_CRT_IN_PRVNT_DEENRT_FLAG
|
|
|
BEN_CRT_IO_PRVNT_DEENRT_FLAG
|
|
|
BEN_CRT_IN_CRD_ATTRIBUTE_CATEGORY
|
|
|
BEN_CRT_IO_CRD_ATTRIBUTE_CATEGORY
|
|
|
BEN_CRT_IN_CRD_ATTRIBUTE1 ..30
|
|
|
BEN_CRT_IO_CRD_ATTRIBUTE1 ..30
|
|
|
BEN_CRT_IN_CRD_ATTRIBUTE_NUMBER1 .. 20
|
|
|
BEN_CRT_IO_CRD_ATTRIBUTE_NUMBER1 .. 20
|
|
|
BEN_CRT_IN_CRD_ATTRIBUTE_DATE1 .. 15
|
|
|
BEN_CRT_IO_CRD_ATTRIBUTE_DATE1 .. 15
|
|
|
BEN_CRT_IN_LAST_UPDATE_DATE
|
|
|
BEN_CRT_IO_LAST_UPDATE_DATE
|
|
|
BEN_CRT_IN_LAST_UPDATED_BY
|
|
|
BEN_CRT_IO_LAST_UPDATED_BY
|
|
|
BEN_CRT_IN_LAST_UPDATE_LOGIN
|
|
|
BEN_CRT_IO_LAST_UPDATE_LOGIN
|
|
|
BEN_CRT_IN_CREATED_BY
|
|
|
BEN_CRT_IO_CREATED_BY
|
|
|
BEN_CRT_IN_CREATION_DATE
|
|
|
BEN_CRT_IO_CREATION_DATE
|
|
|
BEN_CRT_IN_OBJECT_VERSION_NUMBER
|
|
|
BEN_CRT_IO_OBJECT_VERSION_NUMBER
|
|
|
BEN_CRT_IN_CONFIG_ID_1 .. 10
|
|
|
BEN_CRT_IO_CONFIG_ID_1 .. 10
|
|
|
BEN_CRT_IN_CONFIG_NUM_1 .. 10
|
|
|
BEN_CRT_IO_CONFIG_NUM_1 .. 10
|
|
|
BEN_CRT_IN_CONFIG_CHAR_1 .. 10
|
|
|
BEN_CRT_IO_CONFIG_CHAR_1 .. 10
|
|
|
BEN_CRT_IN_CONFIG_DATE_1 .. 10
|
|
|
BEN_CRT_IO_CONFIG_DATE_1 .. 10
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
|
|
|
BEN_CRT_IN_PERSON_ID
|
|
|
BEN_CRT_IO_PERSON_ID
|
|
|
BEN_CRT_IN_APLS_PERD_ENDG_DT
|
|
|
BEN_CRT_IN_APLS_PERD_STRTG_DT
|
|
|
BEN_CRT_IN_CRT_ORDR_ID
|
|
|
BEN_CRT_IN_CRT_ORDR_TYP_CD
|
|
|
BEN_CRT_IN_DETD_QLFD_ORDR_DT
|
|
|
BEN_CRT_IN_ISSUE_DT
|
|
|
BEN_CRT_IN_PL_ID
|
|
|
BEN_CRT_IN_PL_TYP_ID
|
|
|
BEN_CRT_IN_QDRO_AMT
|
|
|
BEN_CRT_IN_QDRO_DSTR_MTHD_CD
|
|
|
BEN_CRT_IN_QDRO_NUM_PYMT_VAL
|
|
|
BEN_CRT_IN_QDRO_PCT
|
|
|
BEN_CRT_IN_RCVD_DT
|
|
|
BEN_CRT_IN_UOM
|
|
|
BEN_CRT_IO_APLS_PERD_ENDG_DT
|
|
|
BEN_CRT_IO_APLS_PERD_STRTG_DT
|
|
|
BEN_CRT_IO_CRT_ORDR_ID
|
|
|
BEN_CRT_IO_CRT_ORDR_TYP_CD
|
|
|
BEN_CRT_IO_DETD_QLFD_ORDR_DT
|
|
|
BEN_CRT_IO_ISSUE_DT
|
|
|
BEN_CRT_IO_PL_ID
|
|
|
BEN_CRT_IO_PL_TYP_ID
|
|
|
BEN_CRT_IO_QDRO_AMT
|
|
|
BEN_CRT_IO_QDRO_DSTR_MTHD_CD
|
|
|
BEN_CRT_IO_QDRO_NUM_PYMT_VAL
|
|
|
BEN_CRT_IO_QDRO_PCT
|
|
|
BEN_CRT_IO_RCVD_DT
|
|
|
BEN_CRT_IO_UOM
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
|
|
|
BEN_CON_IN_BENEFICIARY_FLAG
|
|
|
BEN_CON_IN_CONTACT_PERSON_ID
|
|
|
BEN_CON_IN_CONTACT_TYPE
|
|
|
BEN_CON_IN_DEPENDENT_FLAG
|
|
|
BEN_CON_IN_EFFECTIVE_END_DATE
|
|
|
BEN_CON_IN_EFFECTIVE_START_DATE
|
|
|
BEN_CON_IN_EMERGENCY_CONTACT_FLAG
|
|
|
BEN_CON_IN_END_LIFE_REASON_ID
|
|
|
BEN_CON_IN_PERSONAL_FLAG
|
|
|
BEN_CON_IN_PERSON_ID
|
|
|
BEN_CON_IN_PRIMARY_CONTACT_FLAG
|
|
|
BEN_CON_IN_RLTD_PER_RSDS_W_DSGNTR_FLAG
|
|
|
BEN_CON_IN_START_LIFE_REASON_ID
|
|
|
BEN_CON_IN_THIRD_PARTY_PAY_FLAG
|
|
|
BEN_CON_IO_BENEFICIARY_FLAG
|
|
|
BEN_CON_IO_CONTACT_PERSON_ID
|
|
|
BEN_CON_IO_CONTACT_TYPE
|
|
|
BEN_CON_IO_DEPENDENT_FLAG
|
|
|
BEN_CON_IO_EFFECTIVE_END_DATE
|
|
|
BEN_CON_IO_EFFECTIVE_START_DATE
|
|
|
BEN_CON_IO_EMERGENCY_CONTACT_FLAG
|
|
|
BEN_CON_IO_END_LIFE_REASON_ID
|
|
|
BEN_CON_IO_PERSONAL_FLAG
|
|
|
BEN_CON_IO_PERSON_ID
|
|
|
BEN_CON_IO_PRIMARY_CONTACT_FLAG
|
|
|
BEN_CON_IO_RLTD_PER_RSDS_W_DSGNTR_FLAG
|
|
|
BEN_CON_IO_START_LIFE_REASON_ID
|
|
|
BEN_CON_IO_THIRD_PARTY_PAY_FLAG
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_BRE_IN_PERSON_ID
|
|
|
BEN_BRE_IN_EFFECTIVE_START_DATE
|
|
|
BEN_BRE_IN_EFFECTIVE_END_DATE
|
|
|
BEN_BRE_IN_BENEFIT_RELATION_ID
|
|
|
BEN_BRE_IN_LEGAL_ENTITY_ID
|
|
|
BEN_IV_LER_ID
|
|
|
BEN_BRE_IN_UPDATED_SOURCE
|
|
|
BEN_BRE_IN_ORIGINAL_SOURCE
|
|
|
BEN_BRE_IN_PRIMARY_REL
|
|
|
BEN_BRE_IN_REL_PRMRY_ASG_ID
|
|
|
BEN_BRE_IN_STATUS
|
|
|
BEN_BRE_IO_PERSON_ID
|
|
|
BEN_BRE_IO_EFFECTIVE_START_DATE
|
|
|
BEN_BRE_IO_EFFECTIVE_END_DATE
|
|
|
BEN_BRE_IO_BENEFIT_RELATION_ID
|
|
|
BEN_BRE_IO_LEGAL_ENTITY_ID
|
|
|
BEN_BRE_IO_UPDATED_SOURCE
|
|
|
BEN_BRE_IO_ORIGINAL_SOURCE
|
|
|
BEN_BRE_IO_PRIMARY_REL
|
|
|
BEN_BRE_IO_REL_PRMRY_ASG_ID
|
|
|
BEN_BRE_IO_STATUS
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_BBG_IN_PERSON_ID
|
|
|
BEN_BBG_IN_EFFECTIVE_START_DATE
|
|
|
BEN_BBG_IN_EFFECTIVE_END_DATE
|
|
|
BEN_BBG_IN_BENEFIT_GROUP_ID
|
|
|
BEN_BBG_IN_LEGISLATIVE_DATA_GROUP_ID
|
|
|
BEN_IV_LER_ID
|
|
|
BEN_BBG_IO_PERSON_ID
|
|
|
BEN_BBG_IO_EFFECTIVE_START_DATE
|
|
|
BEN_BBG_IO_EFFECTIVE_END_DATE
|
|
|
BEN_BBG_IO_BENEFIT_GROUP_ID
|
|
|
BEN_BBG_IO_LEGISLATIVE_DATA_GROUP_ID
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_AWM_IN_PERSON_ID
|
|
|
BEN_AWM_IN_ACTION_OCCURRENCE_ID
|
|
|
BEN_AWM_IN_ADDS_TO_BUDGET
|
|
|
BEN_AWM_IN_ASSIGNMENT_ID
|
|
|
BEN_AWM_IN_ASSIGN_WORK_MEASURE_ID
|
|
|
BEN_AWM_IN_BUSINESS_GROUP_ID
|
|
|
BEN_AWM_IN_EFFECTIVE_END_DATE
|
|
|
BEN_AWM_IN_EFFECTIVE_START_DATE
|
|
|
BEN_AWM_IN_UNIT
|
|
|
BEN_AWM_IN_VALUE
|
|
|
BEN_AWM_IO_PERSON_ID
|
|
|
BEN_AWM_IO_ACTION_OCCURRENCE_ID
|
|
|
BEN_AWM_IO_ADDS_TO_BUDGET
|
|
|
BEN_AWM_IO_ASSIGNMENT_ID
|
|
|
BEN_AWM_IO_ASSIGN_WORK_MEASURE_ID
|
|
|
BEN_AWM_IO_BUSINESS_GROUP_ID
|
|
|
BEN_AWM_IO_EFFECTIVE_END_DATE
|
|
|
BEN_AWM_IO_EFFECTIVE_START_DATE
|
|
|
BEN_AWM_IO_UNIT
|
|
|
BEN_AWM_IO_VALUE
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_ASG_IN_ACTION_CODE
|
|
|
BEN_ASG_IN_ASSIGNMENT_NAME
|
|
|
BEN_ASG_IN_ASSIGNMENT_STATUS_TYPE
|
|
|
BEN_ASG_IN_BUSINESS_UNIT_ID
|
|
|
BEN_ASG_IN_DUTIES_TYPE
|
|
|
BEN_ASG_IN_EMPLOYEE_CATEGORY
|
|
|
BEN_ASG_IN_LABOUR_UNION_MEMBER_FLAG
|
|
|
BEN_ASG_IN_PERSON_TYPE_ID
|
|
|
BEN_ASG_IN_USER_PERSON_TYPE
|
|
|
BEN_ASG_IN_POSITION_ID
|
|
|
BEN_ASG_IN_PROBATION_PERIOD
|
|
|
BEN_ASG_IN_PROBATION_UNIT
|
|
|
BEN_ASG_IN_WORK_AT_HOME
|
|
|
BEN_ASG_IN_EFFECTIVE_START_DATE
|
|
|
BEN_ASG_IN_EFFECTIVE_END_DATE
|
|
|
BEN_ASG_IN_ORGANIZATION_ID
|
|
|
BEN_ASG_IN_GRADE_ID
|
|
|
BEN_ASG_IN_JOB_ID
|
|
|
BEN_ASG_IN_WORK_TERMS_ASSIGNMENT_ID
|
|
|
BEN_ASG_IN_LOCATION_ID
|
|
|
BEN_ASG_IN_ASSIGNMENT_STATUS_TYPE_ID
|
|
|
BEN_ASG_IN_ASSIGNMENT_TYPE
|
|
|
BEN_ASG_IN_PRIMARY_FLAG
|
|
|
BEN_ASG_IN_EMPLOYMENT_CATEGORY
|
|
|
BEN_ASG_IN_BARGAINING_UNIT_CODE
|
|
|
BEN_ASG_IN_HOURLY_SALARIED_CODE
|
|
|
BEN_ASG_IN_NORMAL_HOURS
|
|
|
BEN_IV_LER_ID
|
|
|
BEN_ASG_IO_ACTION_CODE
|
|
|
BEN_ASG_IO_ASSIGNMENT_NAME
|
|
|
BEN_ASG_IO_ASSIGNMENT_STATUS_TYPE
|
|
|
BEN_ASG_IO_BUSINESS_UNIT_ID
|
|
|
BEN_ASG_IO_DUTIES_TYPE
|
|
|
BEN_ASG_IO_EMPLOYEE_CATEGORY
|
|
|
BEN_ASG_IO_LABOUR_UNION_MEMBER_FLAG
|
|
|
BEN_ASG_IO_PERSON_TYPE_ID
|
|
|
BEN_ASG_IO_USER_PERSON_TYPE
|
|
|
BEN_ASG_IO_POSITION_ID
|
|
|
BEN_ASG_IO_PROBATION_PERIOD
|
|
|
BEN_ASG_IO_PROBATION_UNIT
|
|
|
BEN_ASG_IO_WORK_AT_HOME
|
|
|
BEN_ASG_IO_EFFECTIVE_START_DATE
|
|
|
BEN_ASG_IO_EFFECTIVE_END_DATE
|
|
|
BEN_ASG_IO_ORGANIZATION_ID
|
|
|
BEN_ASG_IO_GRADE_ID
|
|
|
BEN_ASG_IO_JOB_ID
|
|
|
BEN_ASG_IO_WORK_TERMS_ASSIGNMENT_ID
|
|
|
BEN_ASG_IO_LOCATION_ID
|
|
|
BEN_ASG_IO_ASSIGNMENT_STATUS_TYPE_ID
|
|
|
BEN_ASG_IO_ASSIGNMENT_TYPE
|
|
|
BEN_ASG_IO_PRIMARY_FLAG
|
|
|
BEN_ASG_IO_EMPLOYMENT_CATEGORY
|
|
|
BEN_ASG_IO_BARGAINING_UNIT_CODE
|
|
|
BEN_ASG_IO_HOURLY_SALARIED_CODE
|
|
|
BEN_ASG_IO_NORMAL_HOURS
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
|
|
|
BEN_AEI_IN_PERSON_ID
|
|
|
BEN_AEI_IN_ACTION_OCCURRENCE_ID
|
|
|
BEN_AEI_IN_ASSIGNMENT_EXTRA_INFO_ID
|
|
|
BEN_AEI_IN_ASSIGNMENT_ID
|
|
|
BEN_AEI_IN_EFFECTIVE_END_DATE
|
|
|
BEN_AEI_IN_EFFECTIVE_LATEST_CHANGE
|
|
|
BEN_AEI_IN_EFFECTIVE_SEQUENCE
|
|
|
BEN_AEI_IN_EFFECTIVE_START_DATE
|
|
|
BEN_AEI_IN_LEGISLATION_CODE
|
|
|
BEN_AEI_IO_PERSON_ID
|
|
|
BEN_AEI_IO_ACTION_OCCURRENCE_ID
|
|
|
BEN_AEI_IO_ASSIGNMENT_EXTRA_INFO_ID
|
|
|
BEN_AEI_IO_ASSIGNMENT_ID
|
|
|
BEN_AEI_IO_EFFECTIVE_END_DATE
|
|
|
BEN_AEI_IO_EFFECTIVE_LATEST_CHANGE
|
|
|
BEN_AEI_IO_EFFECTIVE_SEQUENCE
|
|
|
BEN_AEI_IO_EFFECTIVE_START_DATE
|
|
|
BEN_AEI_IO_LEGISLATION_CODE
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
|
|
|
BEN_ADD_IN_ADDRESS_ID
|
|
|
BEN_ADD_IN_ADDRESS_TYPE
|
|
|
BEN_ADD_IN_COUNTRY
|
|
|
BEN_ADD_IN_COUNTRY
|
|
|
BEN_ADD_IN_POSTAL_CODE
|
|
|
BEN_ADD_IN_REGION_1 .. 3
|
|
|
BEN_ADD_IN_TOWN_OR_CITY
|
|
|
BEN_ADD_IN_BUSINESS_GROUP_ID
|
|
|
BEN_ADD_IN_EFFECTIVE_END_DATE
|
|
|
BEN_ADD_IN_EFFECTIVE_START_DATE
|
|
|
BEN_ADD_IO_ADDRESS_ID
|
|
|
BEN_ADD_IO_ADDRESS_TYPE
|
|
|
BEN_ADD_IO_COUNTRY
|
|
|
BEN_ADD_IO_COUNTRY
|
|
|
BEN_ADD_IO_POSTAL_CODE
|
|
|
BEN_ADD_IO_REGION_1 .. 3
|
|
|
BEN_ADD_IO_TOWN_OR_CITY
|
|
|
BEN_ADD_IO_BUSINESS_GROUP_ID
|
|
|
BEN_ADD_IO_EFFECTIVE_END_DATE
|
|
|
BEN_ADD_IO_EFFECTIVE_START_DATE
|
|
|
NEW_VAL
|
|
|
OLD_VAL
|
|
|
PK_ID
|
|
|
COLUMN
|
|
|
|
|
|
BEN_ABA_IN_PER_ABSENCE_ENTRY_ID
|
|
|
BEN_ABA_IO_PER_ABSENCE_ENTRY_ID
|
|
|
BEN_ABA_IO_PERIOD_OF_SERVICE_ID
|
|
|
BEN_ABA_IN_PERIOD_OF_SERVICE_ID
|
|
|
BEN_ABA_IO_ABSENCE_CASE_ID
|
|
|
BEN_ABA_IN_ABSENCE_CASE_ID
|
|
|
BEN_ABA_IO_SINGLE_DAY_FLAG
|
|
|
BEN_ABA_IN_SINGLE_DAY_FLAG
|
|
|
BEN_ABA_IO_START_DATE_DURATION
|
|
|
BEN_ABA_IN_START_DATE_DURATION
|
|
|
BEN_ABA_IO_END_DATE_DURATION
|
|
|
BEN_ABA_IN_END_DATE_DURATION
|
|
|
BEN_ABA_IO_ABSENCE_PATTERN_CD
|
|
|
BEN_ABA_IN_ABSENCE_PATTERN_CD
|
|
|
BEN_ABA_IO_ENTERPRISE_ID
|
|
|
BEN_ABA_IN_ENTERPRISE_ID
|
|
|
BEN_ABA_IO_LEGISLATIVE_DATA_GROUP_ID
|
|
|
BEN_ABA_IN_LEGISLATIVE_DATA_GROUP_ID
|
|
|
BEN_ABA_IO_LEGAL_ENTITY_ID
|
|
|
BEN_ABA_IN_LEGAL_ENTITY_ID
|
|
|
BEN_ABA_IO_PERSON_ID
|
|
|
BEN_ABA_IN_PERSON_ID
|
|
|
BEN_ABA_IO_ABSENCE_TYPE_ID
|
|
|
BEN_ABA_IN_ABSENCE_TYPE_ID
|
|
|
BEN_ABA_IN_ABSENCE_TYPE
|
|
|
BEN_ABA_IO_ABSENCE_TYPE
|
|
|
BEN_ABA_IO_CHILD_EVENT_TYPE_CD
|
|
|
BEN_ABA_IN_CHILD_EVENT_TYPE_CD
|
|
|
BEN_ABA_IO_ABSENCE_TYPE_REASON_ID
|
|
|
BEN_ABA_IN_ABSENCE_TYPE_REASON_ID
|
|
|
BEN_ABA_IO_ABSENCE_ENTRY_BASIC_FLAG
|
|
|
BEN_ABA_IN_ABSENCE_ENTRY_BASIC_FLAG
|
|
|
BEN_ABA_IO_ABSENCE_STATUS_CD
|
|
|
BEN_ABA_IN_ABSENCE_STATUS_CD
|
|
|
BEN_ABA_IO_APPROVAL_STATUS_CD
|
|
|
BEN_ABA_IN_APPROVAL_STATUS_CD
|
|
|
BEN_ABA_IO_START_DATE
|
|
|
BEN_ABA_IN_START_DATE
|
|
|
BEN_ABA_IO_START_DATETIME
|
|
|
BEN_ABA_IN_START_DATETIME
|
|
|
BEN_ABA_IO_END_DATETIME
|
|
|
BEN_ABA_IN_END_DATETIME
|
|
|
BEN_ABA_IO_END_DATE
|
|
|
BEN_ABA_IN_END_DATE
|
|
|
BEN_ABA_IO_START_TIME
|
|
|
BEN_ABA_IN_START_TIME
|
|
|
BEN_ABA_IO_END_TIME
|
|
|
BEN_ABA_IN_END_TIME
|
|
|
BEN_ABA_IO_PLANNED_END_DATE
|
|
|
BEN_ABA_IN_PLANNED_END_DATE
|
|
|
BEN_ABA_IO_OPEN_ENDED_FLAG
|
|
|
BEN_ABA_IN_OPEN_ENDED_FLAG
|
|
|
BEN_ABA_IO_CONFIRMED_DATE
|
|
|
BEN_ABA_IN_CONFIRMED_DATE
|
|
|
BEN_ABA_IO_SUBMITTED_DATE
|
|
|
BEN_ABA_IN_SUBMITTED_DATE
|
|
|
BEN_ABA_IO_CONDITION_START_DATE
|
|
|
BEN_ABA_IN_CONDITION_START_DATE
|
|
|
BEN_ABA_IO_DURATION
|
|
|
BEN_ABA_IN_DURATION
|
|
|
BEN_ABA_IO_UOM
|
|
|
BEN_ABA_IN_UOM
|
|
|
BEN_ABA_IO_COMMENTS
|
|
|
BEN_ABA_IN_COMMENTS
|
|
|
BEN_ABA_IO_CREATED_BY
|
|
|
BEN_ABA_IN_CREATED_BY
|
|
|
BEN_ABA_IO_PROJECT_ID
|
|
|
BEN_ABA_IN_PROJECT_ID
|
|
|
BEN_ABA_IO_CREATION_DATE
|
|
|
BEN_ABA_IN_CREATION_DATE
|
|
|
BEN_ABA_IO_LAST_UPDATED_BY
|
|
|
BEN_ABA_IN_LAST_UPDATED_BY
|
|
|
BEN_ABA_IO_LAST_UPDATE_DATE
|
|
|
BEN_ABA_IN_LAST_UPDATE_DATE
|
|
|
BEN_ABA_IN_LAST_UPDATED_BY
|
|
|
BEN_ABA_IO_LAST_UPDATE_DATE
|
|
|
BEN_ABA_IN_LAST_UPDATE_DATE
|
|
|
BEN_ABA_IO_LAST_UPDATE_LOGIN
|
|
|
BEN_ABA_IN_LAST_UPDATE_LOGIN
|
|
|
BEN_ABA_IO_OBJECT_VERSION_NUMBER
|
|
|
BEN_ABA_IN_OBJECT_VERSION_NUMBER
|
|
|
BEN_ABA_IO_ATTRIBUTE_CATEGORY
|
|
|
BEN_ABA_IN_ATTRIBUTE_CATEGORY
|
|
|
BEN_ABA_IO_ATTRIBUTE1 .. 30
|
|
|
BEN_ABA_IN_ATTRIBUTE1 .. 30
|
|
|
BEN_ABA_IO_ATTRIBUTE_NUMBER1 .. 12
|
|
|
BEN_ABA_IN_ATTRIBUTE_NUMBER1 .. 12
|
|
|
BEN_ABA_IO_ATTRIBUTE_DATE1.. 10
|
|
|
BEN_ABA_IN_ATTRIBUTE_DATE1..10
|
|
|
BEN_ABA_IO_INFORMATION_CATEGORY
|
|
|
BEN_ABA_IN_INFORMATION_CATEGORY
|
|
|
BEN_ABA_IO_INFORMATION1..30
|
|
|
BEN_ABA_IN_INFORMATION1..30
|
|
|
BEN_ABA_IO_INFORMATION_NUMBER1 .. 20
|
|
|
BEN_ABA_IN_INFORMATION_NUMBER1 .. 20
|
|
|
BEN_ABA_IO_INFORMATION_DATE1 .. 15
|
|
|
BEN_ABA_IN_INFORMATION_DATE1 .. 15
|
|
|
BEN_ABA_IO_SPL_CONDITION
|
|
|
BEN_ABA_IN_SPL_CONDITION
|
|
|
BEN_ABA_IO_INITIAL_REPORT_BY_ID
|
|
|
BEN_ABA_IN_INITIAL_REPORT_BY_ID
|
|
|
BEN_ABA_IO_NOTIFICATION_DATE
|
|
|
BEN_ABA_IN_NOTIFICATION_DATE
|
|
|
BEN_ABA_IO_LATE_NOTIFY_FLAG
|
|
|
BEN_ABA_IN_LATE_NOTIFY_FLAG
|
|
|
BEN_ABA_IO_INITIAL_TIMELY_NOTIFY_FLAG
|
|
|
BEN_ABA_IN_INITIAL_TIMELY_NOTIFY_FLAG
|
|
|
BEN_ABA_IO_CERTIFICATION_AUTH_FLAG
|
|
|
BEN_ABA_IN_CERTIFICATION_AUTH_FLAG
|
|
|
BEN_ABA_IO_AUTH_STATUS_UPDATE_DATE
|
|
|
BEN_ABA_IN_AUTH_STATUS_UPDATE_DATE
|
|
|
BEN_ABA_IO_TIMELINESS_OVERRIDE_DATE
|
|
|
BEN_ABA_IN_TIMELINESS_OVERRIDE_DATE
|
|
|
BEN_ABA_IO_DISEASE_CODE
|
|
|
BEN_ABA_IN_DISEASE_CODE
|
|
|
BEN_ABA_IO_PERIOD_OF_INCAP_TO_WORK_FLAG
|
|
|
BEN_ABA_IN_PERIOD_OF_INCAP_TO_WORK_FLAG
|
|
|
BEN_ABA_IO_ESTABLISHMENT_DATE
|
|
|
BEN_ABA_IN_ESTABLISHMENT_DATE
|
|
|
|
|
|
Person Selection
|
BEN_IV_PERSON_ID
|
|
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
Rate End Date
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
Rate Lower Limit
|
|
|
BEN_IV_RT_STRT_DT
|
|
|
BEN_IV_CVG_STRT_DT
|
|
|
|
|
|
Rate Upper Limit
|
|
|
BEN_IV_RT_STRT_DT
|
|
|
BEN_IV_CVG_STRT_DT
|
|
|
To Be Sent Date
|
VALUE
|
|
BEN_IV_RT_STRT_DT
|
|
|
BEN_IV_CVG_STRT_DT
|
|
|
Variable Rate Add On Calculation
|
BEN_IV_RT_STRT_DT
|
|
BEN_IV_CVG_STRT_DT
|
|
|
BEN_IV_PERSON_ID
|
|
|
BEN_IV_EFFECTIVE_DATE
|
Hi Tilak,
ReplyDeleteDo you know about input values of Fast formula for Rate start date type. I am really in a pickle for following BR:
Rate start date should be life event date if elections are made withing 31 days, and if made after 31days then it should be the date on which elections have been made. The problem is when I ma fetching eff_date in the FF then it is picking up as Life event start date , so don't know how to fetch the election date to compare, any help would be great.
i do not see any election date in rate start date formula.
DeleteIf you know where it is stored, u can use payroll value set to get the date.
Please post the question to BEN support forum, you may get better solution.
Hi Tilak Lakshmi,
ReplyDeleteYour site is very helpful. I am looking for an instructor. Are you interested to take classes? I have bought some videos from a reputed website but it was not at all helpful. Can you please let me know if you are interested? Thanks
Hi Tilak,
ReplyDeleteWe need to use element entry values in the benefit fast formula for coverage calculations. Do you have any sample to get values from element entry values. Thanks,
Regards,
Raja
The DBI from EE is like any other DBI. I don't think I have used any EE DBI in my examples. What is your problem with EE DBI ?.
DeleteThere are may seeded FF are using EE DBIs.
Are you facing any issue with them or expecting any ?
Hi Tilak, I need help to trigger a Life event based on employees standard working hours change. The requirement is to trigger an event if the hours on assignment change from under 30 hours per week of 30 or more hours per week.
ReplyDeleteYour question is very generic and you not sharing any information about formula type or formula you tried. It could be achieved in many ways.
DeleteI may suggest using the DBI, PER_ASG_STANDARD_WORKING_HOURS.
Find the previous working hours and find current one. Hope this helps.
thanks Tilak
ReplyDeleteExample FF:
ReplyDelete========================================================================
DEFAULT FOR PER_PERSON_ENTERPRISE_HIRE_DATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR BEN_IV_RT_STRT_DT IS '4712/12/31 00:00:00' (date)
DEFAULT FOR BEN_IV_CVG_STRT_DT IS '4712/12/31 00:00:00' (date)
DEFAULT FOR BEN_IV_EFFECTIVE_DATE IS '4712/12/31 00:00:00' (date)
DEFAULT FOR BEN_IV_PERSON_ID IS 1111
INPUTS are BEN_IV_RT_STRT_DT(date),BEN_IV_CVG_STRT_DT(date),BEN_IV_PERSON_ID(number),BEN_IV_EFFECTIVE_DATE(date)
currdtchar = GLOBAL_PAY_INTERFACE_EXTRACTION_DATE
ln_sysdate = to_date(currdtchar,'rrrr/mm/dd')
IF ( PER_PERSON_ENTERPRISE_HIRE_DATE <= ln_sysdate )
THEN
(
L_start_dt = PER_PERSON_ENTERPRISE_HIRE_DATE
)
ELSE
(
L_start_dt = PER_PERSON_ENTERPRISE_HIRE_DATE
)
RETURN L_start_dt
============================================
This is not working
Please advise more into this,
Thanks,
The person will be automatically enrolled to the benefit plan based on his/her promotion.
ReplyDeleteA life event is created to capture the promotion but it is not changing when a promotion occurred.
It will take the job change as the assignment change and it will not take when a promotion is triggered.
I need to write fast formula in order to fire above case.
there is nothing called "it is not working".
ReplyDeleteWhat it is doing? , erring, or returning wrong value, if so what is your expectation?
1) You are comparing date with string, i am not sure why you need to convert the date to string
2)I do not see any debugging in your formula. if you do not know, pease read my blog on it. https://tilak-lakshmi.blogspot.com/2017/03/how-to-debug-fast-formula.html
3) your if and else is returning the same value, if so , why do you need the condition?
there is no information about the type of formula?
Good information, thanks for sharing this blog.
ReplyDeleteOracle Fusion HCM Online Training
Is there a BEN_ASG_IN_ACTION for an action reason code? and not just action?
ReplyDeleteHi Tilak Lakshmi,
ReplyDeleteYour site is very helpful. I am looking for an instructor. Are you interested to take classes? Can you please let me know if you are interested? Thanks
pls provide your contact information, let me know what you are looking for
Deletethere is no input value mentioned BEN_LEH_IN_TOBACCO_TYPE_USAGE and BEN_LEH_IO_TOBACCO_TYPE_USAGE
ReplyDeletethese information I got from Ben Documentation. You need to test the Tobacco usage LE change Formula
Delete