Tuesday, November 8, 2016

Fast Formula – Benefits, part 7


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