_ADDITIONALDATA
_ADDITIONALDATA is an SAP database table in S/4HANA. It contains 571 fields.
Fields (571)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| BE_HCMFamMbrISDFDirSISCard | BE_HCMFamMbrISDFDirSISCard | 1 | |
| BE_HCMFamMbrNaturalPersonPID | BE_HCMFamMbrNaturalPersonPID | 1 | |
| BE_HCMFamMbrPBDFDirSISCard | BE_HCMFamMbrPBDFDirSISCard | 1 | |
| BE_HCMFamMbrSISCardFctryNumber | BE_HCMFamMbrSISCardFctryNumber | 1 | |
| BE_HCMFamMbrSISCardNumber | BE_HCMFamMbrSISCardNumber | 1 | |
| BE_HCMFamMbrSISCardTypeId | BE_HCMFamMbrSISCardTypeId | 1 | |
| ChmlCmpstnInProcStatus | ChmlCmpstnInProcStatus | 1 | |
| ChmlCmpstnReldStatus | ChmlCmpstnReldStatus | 1 | |
| ChmlCompositionUUID | ChmlCompositionNavgnLink,ChmlCompositionUUID | 1 | |
| CN_HCMFamMbrHukouCode | CN_HCMFamMbrHukouCode | 1 | |
| Currency | Currency | 2 | |
| HCM_FamMbrCCLEntlInYrOfBrth | HCM_FamMbrCCLEntlInYrOfBrth | 1 | |
| HCM_FamMbrHasCCLStrtFromYrBrth | HCM_FamMbrHasCCLStrtFromYrBrth | 1 | |
| HCMBankDataDutyStationCode | HCMBankDataDutyStationCode | 1 | |
| HCMBankDataIdTypeCode | HCMBankDataIdTypeCode | 1 | |
| HCMFamCASeqNumber | HCMFamCASeqNumber | 1 | |
| HCMFamilyMemberChildTypeCode | HCMFamilyMemberChildTypeCode | 1 | |
| HCMFamilyMemberIsDeceased | HCMFamilyMemberIsDeceased | 2 | |
| HCMFamilyMemberKanjiFirstName | HCMFamilyMemberKanjiFirstName | 1 | |
| HCMFamilyMemberKanjiLastName | HCMFamilyMemberKanjiLastName | 1 | |
| HCMFamMbr2ndAddressLine | HCMFamMbr2ndAddressLine | 1 | |
| HCMFamMbr2ndBnftPhysnId | HCMFamMbr2ndBnftPhysnId | 2 | |
| HCMFamMbr2ndBnftPhysnName | HCMFamMbr2ndBnftPhysnName | 2 | |
| HCMFamMbr2ndDocumentExpiryDate | HCMFamMbr2ndDocumentExpiryDate | 1 | |
| HCMFamMbr2ndDocumentIssueDate | HCMFamMbr2ndDocumentIssueDate | 1 | |
| HCMFamMbr2ndDocumentNumber | HCMFamMbr2ndDocumentNumber | 1 | |
| HCMFamMbr2ndDocumentTypeCode | HCMFamMbr2ndDocumentTypeCode | 1 | |
| HCMFamMbr2ndName | HCMFamMbr2ndName | 1 | |
| HCMFamMbr3rdDocumentExpiryDate | HCMFamMbr3rdDocumentExpiryDate | 1 | |
| HCMFamMbr3rdDocumentIssueDate | HCMFamMbr3rdDocumentIssueDate | 1 | |
| HCMFamMbr3rdDocumentNumber | HCMFamMbr3rdDocumentNumber | 1 | |
| HCMFamMbr3rdDocumentTypeCode | HCMFamMbr3rdDocumentTypeCode | 1 | |
| HCMFamMbr4thDocumentExpiryDate | HCMFamMbr4thDocumentExpiryDate | 1 | |
| HCMFamMbr4thDocumentIssueDate | HCMFamMbr4thDocumentIssueDate | 1 | |
| HCMFamMbr4thDocumentNumber | HCMFamMbr4thDocumentNumber | 1 | |
| HCMFamMbr4thDocumentTypeCode | HCMFamMbr4thDocumentTypeCode | 1 | |
| HCMFamMbr5thDocumentExpiryDate | HCMFamMbr5thDocumentExpiryDate | 1 | |
| HCMFamMbr5thDocumentIssueDate | HCMFamMbr5thDocumentIssueDate | 1 | |
| HCMFamMbr5thDocumentNumber | HCMFamMbr5thDocumentNumber | 1 | |
| HCMFamMbr5thDocumentTypeCode | HCMFamMbr5thDocumentTypeCode | 1 | |
| HCMFamMbr6thDocumentExpiryDate | HCMFamMbr6thDocumentExpiryDate | 1 | |
| HCMFamMbr6thDocumentIssueDate | HCMFamMbr6thDocumentIssueDate | 1 | |
| HCMFamMbr6thDocumentNumber | HCMFamMbr6thDocumentNumber | 1 | |
| HCMFamMbr6thDocumentTypeCode | HCMFamMbr6thDocumentTypeCode | 1 | |
| HCMFamMbr7thDocumentExpiryDate | HCMFamMbr7thDocumentExpiryDate | 1 | |
| HCMFamMbr7thDocumentIssueDate | HCMFamMbr7thDocumentIssueDate | 1 | |
| HCMFamMbr7thDocumentNumber | HCMFamMbr7thDocumentNumber | 1 | |
| HCMFamMbr7thDocumentTypeCode | HCMFamMbr7thDocumentTypeCode | 1 | |
| HCMFamMbr8thDocumentExpiryDate | HCMFamMbr8thDocumentExpiryDate | 1 | |
| HCMFamMbr8thDocumentIssueDate | HCMFamMbr8thDocumentIssueDate | 1 | |
| HCMFamMbr8thDocumentNumber | HCMFamMbr8thDocumentNumber | 1 | |
| HCMFamMbr8thDocumentTypeCode | HCMFamMbr8thDocumentTypeCode | 1 | |
| HCMFamMbrAcademicDegree | HCMFamMbrAcademicDegree | 1 | |
| HCMFamMbrAcademicDegreeCode | HCMFamMbrAcademicDegreeCode | 1 | |
| HCMFamMbrAddressNumber | HCMFamMbrAddressNumber | 1 | |
| HCMFamMbrAdjustDeductTarget | HCMFamMbrAdjustDeductTarget | 1 | |
| HCMFamMbrAdoptionDate | HCMFamMbrAdoptionDate | 1 | |
| HCMFamMbrAEVisaNumber | HCMFamMbrAEVisaNumber | 1 | |
| HCMFamMbrAgeGroupDeductionCode | HCMFamMbrAgeGroupDeductionCode | 1 | |
| HCMFamMbrAllowanceTypeCode | HCMFamMbrAllowanceTypeCode | 1 | |
| HCMFamMbrAllwncReceiptDate | HCMFamMbrAllwncReceiptDate | 1 | |
| HCMFamMbrAlternativeName | HCMFamMbrChineseName | 1 | |
| HCMFamMbrApartmentId | HCMFamMbrApartmentId | 1 | |
| HCMFamMbrArabicFirstName | HCMFamMbrArabicFirstName | 5 | |
| HCMFamMbrArabicLastName | HCMFamMbrArabicLastName | 5 | |
| HCMFamMbrArabicSecondName | HCMFamMbrArabicSecondName | 5 | |
| HCMFamMbrArabicThirdName | HCMFamMbrArabicThirdName | 5 | |
| HCMFamMbrArrivalDate | HCMFamMbrArrivalDate | 1 | |
| HCMFamMbrBirthAdoptionNotifDte | HCMFamMbrBirthAdoptionNotifDte | 1 | |
| HCMFamMbrBirthCertRegister | HCMFamMbrBirthCertRegister | 1 | |
| HCMFamMbrBloodGroupCode | HCMFamMbrBloodGroupCode | 1 | |
| HCMFamMbrBnftPhysicianId | HCMFamMbrBnftPhysicianId | 2 | |
| HCMFamMbrBnftPhysicianName | HCMFamMbrBnftPhysicianName | 2 | |
| HCMFamMbrBorderEntryNumber | HCMFamMbrBorderEntryNumber | 1 | |
| HCMFamMbrBrthCertificateNumber | HCMFamMbrBrthCertificateNumber | 2 | |
| HCMFamMbrCAEndDate | HCMFamMbrCAEndDate | 1 | |
| HCMFamMbrCAObjId | HCMFamMbrCAObjId | 1 | |
| HCMFamMbrCAStartDate | HCMFamMbrCAStartDate | 1 | |
| HCMFamMbrCASubtype | HCMFamMbrCASubtype | 1 | |
| HCMFamMbrCertDeliveryDate | HCMFamMbrCertDeliveryDate | 1 | |
| HCMFamMbrChallengeTypeCode | HCMFamMbrChallengeTypeCode | 1 | |
| HCMFamMbrChangeReasonCode | HCMFamMbrChangeReasonCode | 1 | |
| HCMFamMbrChangeReasonText | HCMFamMbrChangeReasonText | 1 | |
| HCMFamMbrChildBnftProlongDate | HCMFamMbrChildBnftProlongDate | 1 | |
| HCMFamMbrChildDsbltyPillar1 | HCMFamMbrChildDsbltyPillar1 | 1 | |
| HCMFamMbrChildDsbltyPillar2 | HCMFamMbrChildDsbltyPillar2 | 1 | |
| HCMFamMbrChildDsbltyPillar3 | HCMFamMbrChildDsbltyPillar3 | 1 | |
| HCMFamMbrChildDsbltyTotPillar | HCMFamMbrChildDsbltyTotPillar | 1 | |
| HCMFamMbrChildHasAllowance | HCMFamMbrChildHasAllowance | 1 | |
| HCMFamMbrChildIdentifier | HCMFamMbrChildIdentifier | 1 | |
| HCMFamMbrChildStatusCode | HCMFamMbrChildStatusCode | 1 | |
| HCMFamMbrChineseName | HCMFamMbrChineseName | 1 | |
| HCMFamMbrCitizenServiceNumber | HCMFamMbrCitizenServiceNumber | 1 | |
| HCMFamMbrCityName | HCMFamMbrCityName | 6 | |
| HCMFamMbrCityText | HCMFamMbrCityText | 1 | |
| HCMFamMbrCivilId | HCMFamMbrCivilId | 1 | |
| HCMFamMbrCivilIdExpDate | HCMFamMbrCivilIdExpDate | 1 | |
| HCMFamMbrCivilIdIssueDate | HCMFamMbrCivilIdIssueDate | 1 | |
| HCMFamMbrCommNumber1 | HCMFamMbrCommNumber1 | 3 | |
| HCMFamMbrCommNumber2 | HCMFamMbrCommNumber2 | 3 | |
| HCMFamMbrCommNumber3 | HCMFamMbrCommNumber3 | 3 | |
| HCMFamMbrCommNumber4 | HCMFamMbrCommNumber4 | 3 | |
| HCMFamMbrCommType1Code | HCMFamMbrCommType1Code | 1 | |
| HCMFamMbrCommType2Code | HCMFamMbrCommType2Code | 1 | |
| HCMFamMbrCommType3Code | HCMFamMbrCommType3Code | 1 | |
| HCMFamMbrCommType4Code | HCMFamMbrCommType4Code | 1 | |
| HCMFamMbrCommTypeCode1 | HCMFamMbrCommTypeCode1 | 2 | |
| HCMFamMbrCommTypeCode2 | HCMFamMbrCommTypeCode2 | 2 | |
| HCMFamMbrCommTypeCode3 | HCMFamMbrCommTypeCode3 | 2 | |
| HCMFamMbrCommTypeCode4 | HCMFamMbrCommTypeCode4 | 2 | |
| HCMFamMbrCOName | HCMFamMbrCOName | 1 | |
| HCMFamMbrConfinementNumber | HCMFamMbrConfinementNumber | 1 | |
| HCMFamMbrContributionScale | HCMFamMbrContributionScale | 1 | |
| HCMFamMbrCoRelationshipText | HCMFamMbrCoRelationshipText | 1 | |
| HCMFamMbrCountryCode | HCMFamMbrCountryCode | 9 | |
| HCMFamMbrCountryEntranceDate | HCMFamMbrCountryEntranceDate | 1 | |
| HCMFamMbrCountyCode | HCMFamMbrCountyCode | 2 | |
| HCMFamMbrCPFNumber | HCMFamMbrCPFNumber | 1 | |
| HCMFamMbrCurrencyKey | HCMFamMbrCurrencyKey | 1 | |
| HCMFamMbrCurrentSchoolGrade | HCMFamMbrCurrentSchoolGrade | 1 | |
| HCMFamMbrDateType1EventCode | HCMFamMbrDateType1EventCode | 1 | |
| HCMFamMbrDateType2EventsCode | HCMFamMbrDateType2EventsCode | 1 | |
| HCMFamMbrDeathDate | HCMFamMbrDeathDate | 3 | |
| HCMFamMbrDepdntForYearEndAdjmt | HCMFamMbrDepdntForYearEndAdjmt | 1 | |
| HCMFamMbrDepdntHlthInsur | HCMFamMbrDepdntHlthInsur | 1 | |
| HCMFamMbrDepdntIsDisabled | HCMFamMbrDepdntIsDisabled | 1 | |
| HCMFamMbrDepdntLivingWithName | HCMFamMbrDepdntLivingWithName | 1 | |
| HCMFamMbrDepdntLivingWithStatC | HCMFamMbrDepdntLivingWithStatC | 1 | |
| HCMFamMbrDepdntNurseInsur | HCMFamMbrDepdntNurseInsur | 1 | |
| HCMFamMbrDepdntTotIncAmount | HCMFamMbrDepdntTotIncAmount | 1 | |
| HCMFamMbrDepdntTypeCode | HCMFamMbrDepdntTypeCode | 1 | |
| HCMFamMbrDependentsCountryCode | HCMFamMbrDependentsCountryCode | 1 | |
| HCMFamMbrDependentTypeCode | HCMFamMbrDependentTypeCode | 1 | |
| HCMFamMbrDepEstTotIncAmount | HCMFamMbrDepEstTotIncAmount | 1 | |
| HCMFamMbrDeptDeductionCode | HCMFamMbrDeptDeductionCode | 1 | |
| HCMFamMbrDesignationName | HCMFamMbrDesignationName | 1 | |
| HCMFamMbrDisabilityDescText | HCMFamMbrDisabilityDescText | 1 | |
| HCMFamMbrDisabilityGrade | HCMFamMbrDisabilityGrade | 1 | |
| HCMFamMbrDisabilityLevelCode | HCMFamMbrDisabilityLevelCode | 1 | |
| HCMFamMbrDisabilityReasonText | HCMFamMbrDisabilityReasonText | 1 | |
| HCMFamMbrDisabledDeductionCode | HCMFamMbrDisabledDeductionCode | 1 | |
| HCMFamMbrDistrictName | HCMFamMbrDistrictName | 4 | |
| HCMFamMbrDistrictText | HCMFamMbrDistrictText | 1 | |
| HCMFamMbrDocNmbr1ExpiryDate | HCMFamMbrDocNmbr1ExpiryDate | 2 | |
| HCMFamMbrDocNmbr1IssueDate | HCMFamMbrDocNmbr1IssueDate | 2 | |
| HCMFamMbrDocNmbr2ExpiryDate | HCMFamMbrDocNmbr2ExpiryDate | 2 | |
| HCMFamMbrDocNmbr2IssueDate | HCMFamMbrDocNmbr2IssueDate | 2 | |
| HCMFamMbrDocNmbr3ExpiryDate | HCMFamMbrDocNmbr3ExpiryDate | 2 | |
| HCMFamMbrDocNmbr3IssueDate | HCMFamMbrDocNmbr3IssueDate | 2 | |
| HCMFamMbrDocNmbr4ExpiryDate | HCMFamMbrDocNmbr4ExpiryDate | 2 | |
| HCMFamMbrDocNmbr4IssueDate | HCMFamMbrDocNmbr4IssueDate | 2 | |
| HCMFamMbrDocNmbr5ExpiryDate | HCMFamMbrDocNmbr5ExpiryDate | 2 | |
| HCMFamMbrDocNmbr5IssueDate | HCMFamMbrDocNmbr5IssueDate | 2 | |
| HCMFamMbrDocNmbr6ExpiryDate | HCMFamMbrDocNmbr6ExpiryDate | 2 | |
| HCMFamMbrDocNmbr6IssueDate | HCMFamMbrDocNmbr6IssueDate | 2 | |
| HCMFamMbrDocNmbr7ExpiryDate | HCMFamMbrDocNmbr7ExpiryDate | 1 | |
| HCMFamMbrDocNmbr7IssueDate | HCMFamMbrDocNmbr7IssueDate | 1 | |
| HCMFamMbrDocNmbr8ExpiryDate | HCMFamMbrDocNmbr8ExpiryDate | 1 | |
| HCMFamMbrDocNmbr8IssueDate | HCMFamMbrDocNmbr8IssueDate | 1 | |
| HCMFamMbrDocumentExpiryDate | HCMFamMbrDocumentExpiryDate | 1 | |
| HCMFamMbrDocumentIssueDate | HCMFamMbrDocumentIssueDate | 1 | |
| HCMFamMbrDocumentNumber | HCMFamMbrDocumentNumber | 1 | |
| HCMFamMbrDocumentNumber1 | HCMFamMbrDocumentNumber1 | 3 | |
| HCMFamMbrDocumentNumber2 | HCMFamMbrDocumentNumber2 | 2 | |
| HCMFamMbrDocumentNumber3 | HCMFamMbrDocumentNumber3 | 2 | |
| HCMFamMbrDocumentNumber4 | HCMFamMbrDocumentNumber4 | 2 | |
| HCMFamMbrDocumentNumber5 | HCMFamMbrDocumentNumber5 | 2 | |
| HCMFamMbrDocumentNumber6 | HCMFamMbrDocumentNumber6 | 2 | |
| HCMFamMbrDocumentNumber7 | HCMFamMbrDocumentNumber7 | 1 | |
| HCMFamMbrDocumentNumber8 | HCMFamMbrDocumentNumber8 | 1 | |
| HCMFamMbrDocumentTypeCode | HCMFamMbrDocumentTypeCode | 3 | |
| HCMFamMbrDocumentTypeCode1 | HCMFamMbrDocumentTypeCode1 | 2 | |
| HCMFamMbrDocumentTypeCode2 | HCMFamMbrDocumentTypeCode2 | 2 | |
| HCMFamMbrDocumentTypeCode3 | HCMFamMbrDocumentTypeCode3 | 2 | |
| HCMFamMbrDocumentTypeCode4 | HCMFamMbrDocumentTypeCode4 | 2 | |
| HCMFamMbrDocumentTypeCode5 | HCMFamMbrDocumentTypeCode5 | 2 | |
| HCMFamMbrDocumentTypeCode6 | HCMFamMbrDocumentTypeCode6 | 2 | |
| HCMFamMbrDocumentTypeCode7 | HCMFamMbrDocumentTypeCode7 | 1 | |
| HCMFamMbrDocumentTypeCode8 | HCMFamMbrDocumentTypeCode8 | 1 | |
| HCMFamMbrDpndcyDescriptionText | HCMFamMbrDpndcyDescriptionText | 1 | |
| HCMFamMbrDriversLicenseNumber | HCMFamMbrDriversLicenseNumber | 1 | |
| HCMFamMbrDriversLicExpireDte | HCMFamMbrDriversLicExpireDte | 1 | |
| HCMFamMbrDsbltyDetnDate | HCMFamMbrDsbltyDetnDate | 2 | |
| HCMFamMbrDsbltyPctgRate | HCMFamMbrDsbltyPctgRate | 2 | |
| HCMFamMbrDutyStationCode | HCMFamMbrDutyStationCode | 1 | |
| HCMFamMbrEducationLevelCode | HCMFamMbrEducationLevelCode | 2 | |
| HCMFamMbrEducationSpecCode | HCMFamMbrEducationSpecCode | 1 | |
| HCMFamMbrEmployerDsbltyDte | HCMFamMbrEmployerDsbltyDte | 2 | |
| HCMFamMbrEmployerName | HCMFamMbrEmployerName | 6 | |
| HCMFamMbrEmployerTypeCode | HCMFamMbrEmployerTypeCode | 1 | |
| HCMFamMbrEmploymentDate | HCMFamMbrEmploymentDate | 2 | |
| HCMFamMbrEntryDate | HCMFamMbrEntryDate | 1 | |
| HCMFamMbrEntryLedgerNumber | HCMFamMbrEntryLedgerNumber | 1 | |
| HCMFamMbrEntrySheetNumber | HCMFamMbrEntrySheetNumber | 1 | |
| HCMFamMbrEthnicOriginCode | HCMFamMbrEthnicOriginCode | 1 | |
| HCMFamMbrExemptionReasonCode | HCMFamMbrExemptionReasonCode | 1 | |
| HCMFamMbrFactLiveHoodText | HCMFamMbrFactLiveHoodText | 1 | |
| HCMFamMbrFamilyAllowance | HCMFamMbrFamilyAllowance | 1 | |
| HCMFamMbrFatherIdentifier | HCMFamMbrFatherIdentifier | 1 | |
| HCMFamMbrFinSuppAmount | HCMFamMbrFinSuppAmount | 1 | |
| HCMFamMbrFinSuppCurrencyKey | HCMFamMbrFinSuppCurrencyKey | 1 | |
| HCMFamMbrFirstName | HCMFamMbrFirstName | 2 | |
| HCMFamMbrFormOfAddressCode | HCMFamMbrFormOfAddressCode | 2 | |
| HCMFamMbrFromDate | HCMFamMbrFromDate | 1 | |
| HCMFamMbrFullAddressText | HCMFamMbrFullAddressText | 1 | |
| HCMFamMbrGradeCode | HCMFamMbrGradeCode | 1 | |
| HCMFamMbrHandicapCode | HCMFamMbrHandicapCode | 1 | |
| HCMFamMbrHandicapEndDate | HCMFamMbrHandicapEndDate | 1 | |
| HCMFamMbrHandicapStartDate | HCMFamMbrHandicapStartDate | 1 | |
| HCMFamMbrHasAcmdtnEntlmnt | HCMFamMbrHasAcmdtnEntlmnt | 2 | |
| HCMFamMbrHasBirthCert | HCMFamMbrHasBirthCert | 1 | |
| HCMFamMbrHasBnftFinIndep | HCMFamMbrHasBnftFinIndep | 2 | |
| HCMFamMbrHasBnftMedicare | HCMFamMbrHasBnftMedicare | 1 | |
| HCMFamMbrHasBnftMilitary | HCMFamMbrHasBnftMilitary | 2 | |
| HCMFamMbrHasBnftNonTaxable | HCMFamMbrHasBnftNonTaxable | 2 | |
| HCMFamMbrHasBnftSmoker | HCMFamMbrHasBnftSmoker | 2 | |
| HCMFamMbrHasCareNeeds | HCMFamMbrHasCareNeeds | 1 | |
| HCMFamMbrHasCCSLValidity | HCMFamMbrHasCCSLValidity | 1 | |
| HCMFamMbrHasChallenge | HCMFamMbrHasChallenge | 1 | |
| HCMFamMbrHasChallengeBonus | HCMFamMbrHasChallengeBonus | 1 | |
| HCMFamMbrHasChildAllowance | HCMFamMbrHasChildAllowance | 1 | |
| HCMFamMbrHasChildCareSubsidy | HCMFamMbrHasChildCareSubsidy | 1 | |
| HCMFamMbrHasChildCustody | HCMFamMbrHasChildCustody | 1 | |
| HCMFamMbrHasChildHandicap | HCMFamMbrHasChildHandicap | 1 | |
| HCMFamMbrHasCommonHousehold | HCMFamMbrHasCommonHousehold | 1 | |
| HCMFamMbrHasCompanyTransport | HCMFamMbrHasCompanyTransport | 1 | |
| HCMFamMbrHasCreditCard | HCMFamMbrHasCreditCard | 1 | |
| HCMFamMbrHasDisability | HCMFamMbrHasDisability | 2 | |
| HCMFamMbrHasEducationExpense | HCMFamMbrHasEducationExpense | 1 | |
| HCMFamMbrHasExtendedAgeLimit | HCMFamMbrHasExtendedAgeLimit | 1 | |
| HCMFamMbrHasFamilyAllowance | HCMFamMbrHasFamilyAllowance | 3 | |
| HCMFamMbrHasForcePayment | HCMFamMbrHasForcePayment | 1 | |
| HCMFamMbrHasHalfChildAllowance | HCMFamMbrHasHalfChildAllowance | 1 | |
| HCMFamMbrHasHealthInsurance | HCMFamMbrHasHealthInsurance | 2 | |
| HCMFamMbrHasIncOvr3MnthMinPens | HCMFamMbrHasIncOvr3MnthMinPens | 1 | |
| HCMFamMbrHasInsurance | HCMFamMbrHasInsurance | 1 | |
| HCMFamMbrHasLeavePassage | HCMFamMbrHasLeavePassage | 1 | |
| HCMFamMbrHasLivingAllowance | HCMFamMbrHasLivingAllowance | 1 | |
| HCMFamMbrHasMedicalExpense | HCMFamMbrHasMedicalExpense | 1 | |
| HCMFamMbrHasNHIFamily | HCMFamMbrHasNHIFamily | 1 | |
| HCMFamMbrHasNursingAllowance | HCMFamMbrHasNursingAllowance | 1 | |
| HCMFamMbrHasNurturingBnft | HCMFamMbrHasNurturingBnft | 1 | |
| HCMFamMbrHasOtherAddress | HCMFamMbrHasOtherAddress | 1 | |
| HCMFamMbrHasParentalRespy | HCMFamMbrHasParentalRespy | 1 | |
| HCMFamMbrHasPrivateHealthPlan | HCMFamMbrHasPrivateHealthPlan | 1 | |
| HCMFamMbrHasProLifeCertificate | HCMFamMbrHasProLifeCertificate | 1 | |
| HCMFamMbrHasProofLegalDep | HCMFamMbrHasProofLegalDep | 1 | |
| HCMFamMbrHasRegnSubmission | HCMFamMbrHasRegnSubmission | 1 | |
| HCMFamMbrHasRetireIncomeForRes | HCMFamMbrHasRetireIncomeForRes | 1 | |
| HCMFamMbrHasScholarshipBenefit | HCMFamMbrHasScholarshipBenefit | 1 | |
| HCMFamMbrHasShrdAccommodation | HCMFamMbrHasShrdAccommodation | 1 | |
| HCMFamMbrHasShrdParentalLeave | HCMFamMbrHasShrdParentalLeave | 1 | |
| HCMFamMbrHasSoleSupport | HCMFamMbrHasSoleSupport | 1 | |
| HCMFamMbrHasTwin | HCMFamMbrHasTwin | 1 | |
| HCMFamMbrHasUnderDependents | HCMFamMbrHasUnderDependents | 1 | |
| HCMFamMbrHealthNationalCard | HCMFamMbrHealthNationalCard | 1 | |
| HCMFamMbrHijriBirthDate | HCMFamMbrHijriBirthDate | 1 | |
| HCMFamMbrHlthInsPrimPaidByCode | HCMFamMbrHlthInsPrimPaidByCode | 1 | |
| HCMFamMbrHouseNumber | HCMFamMbrHouseNumber | 4 | |
| HCMFamMbrIdDocumentTypeCode | HCMFamMbrIdDocumentTypeCode | 1 | |
| HCMFamMbrIdentificationCardId | HCMFamMbrIdentificationCardId | 2 | |
| HCMFamMbrIdExpDate | HCMFamMbrIdExpDate | 1 | |
| HCMFamMbrIdExpiryDate | HCMFamMbrIdExpiryDate | 2 | |
| HCMFamMbrIdExpiryDate1 | HCMFamMbrIdExpiryDate1 | 1 | |
| HCMFamMbrIdIssueCountryCode1 | HCMFamMbrIdIssueCountryCode1 | 1 | |
| HCMFamMbrIdIssueDate | HCMFamMbrIdIssueDate | 3 | |
| HCMFamMbrIdIssueDate1 | HCMFamMbrIdIssueDate1 | 1 | |
| HCMFamMbrIdIssuePlaceText | HCMFamMbrIdIssuePlaceText | 1 | |
| HCMFamMbrIdIssuingAuth1 | HCMFamMbrIdIssuingAuth1 | 1 | |
| HCMFamMbrIdNumber | HCMFamMbrIdNumber | 2 | |
| HCMFamMbrIdNumber1 | HCMFamMbrIdNumber1 | 2 | |
| HCMFamMbrIdNumber2 | HCMFamMbrIdNumber2 | 1 | |
| HCMFamMbrIdNumber3 | HCMFamMbrIdNumber3 | 1 | |
| HCMFamMbrIdNumber4 | HCMFamMbrIdNumber4 | 1 | |
| HCMFamMbrIdNumber5 | HCMFamMbrIdNumber5 | 1 | |
| HCMFamMbrIdNumberCheckError | HCMFamMbrIdNumberCheckError | 1 | |
| HCMFamMbrIdSpouseFather | HCMFamMbrIdSpouseFather | 1 | |
| HCMFamMbrIdSpouseMother | HCMFamMbrIdSpouseMother | 1 | |
| HCMFamMbrIdType | HCMFamMbrIdType | 1 | |
| HCMFamMbrIdTypeCode1 | HCMFamMbrIdTypeCode1 | 2 | |
| HCMFamMbrIdTypeCode2 | HCMFamMbrIdTypeCode2 | 1 | |
| HCMFamMbrIdTypeCode3 | HCMFamMbrIdTypeCode3 | 1 | |
| HCMFamMbrIdTypeCode4 | HCMFamMbrIdTypeCode4 | 1 | |
| HCMFamMbrIdTypeCode5 | HCMFamMbrIdTypeCode5 | 1 | |
| HCMFamMbrIdTypeCode6 | HCMFamMbrIdTypeCode6 | 1 | |
| HCMFamMbrIdValidityDate | HCMFamMbrIdValidityDate | 1 | |
| HCMFamMbrIllnessCode1 | HCMFamMbrIllnessCode1 | 1 | |
| HCMFamMbrIllnessCode2 | HCMFamMbrIllnessCode2 | 1 | |
| HCMFamMbrIncIsMoreThan4000 | HCMFamMbrIncIsMoreThan4000 | 1 | |
| HCMFamMbrIncomeTaxNumber | HCMFamMbrIncomeTaxNumber | 1 | |
| HCMFamMbrIndividualRegNumber | HCMFamMbrIndividualRegNumber | 1 | |
| HCMFamMbrInitials | HCMFamMbrInitials | 1 | |
| HCMFamMbrInsConfirmFlag | HCMFamMbrInsConfirmFlag | 1 | |
| HCMFamMbrIqamaExpireDate | HCMFamMbrIqamaExpireDate | 1 | |
| HCMFamMbrIqamaNumber | HCMFamMbrIqamaNumber | 1 | |
| HCMFamMbrIsAdoptedChild | HCMFamMbrIsAdoptedChild | 1 | |
| HCMFamMbrIsAgedDependent | HCMFamMbrIsAgedDependent | 1 | |
| HCMFamMbrIsBscLivingDependent | HCMFamMbrIsBscLivingDependent | 1 | |
| HCMFamMbrIsChargePerson | HCMFamMbrIsChargePerson | 1 | |
| HCMFamMbrIsChildAllwncElgbl | HCMFamMbrIsChildAllwncElgbl | 1 | |
| HCMFamMbrIsChildCareExempt | HCMFamMbrIsChildCareExempt | 1 | |
| HCMFamMbrIsDepdntForTax | HCMFamMbrIsDepdntForTax | 1 | |
| HCMFamMbrIsDependent | HCMFamMbrIsDependent | 1 | |
| HCMFamMbrIsDisabled | HCMFamMbrIsDisabled | 1 | |
| HCMFamMbrIsEconomicDepdnt | HCMFamMbrIsEconomicDepdnt | 1 | |
| HCMFamMbrIsEduAllowanceElgbl | HCMFamMbrIsEduAllowanceElgbl | 1 | |
| HCMFamMbrIsEduDepdnt | HCMFamMbrIsEduDepdnt | 1 | |
| HCMFamMbrIsElgblForHlthIns | HCMFamMbrIsElgblForHlthIns | 1 | |
| HCMFamMbrIsElgblForTrvlTicket | HCMFamMbrIsElgblForTrvlTicket | 1 | |
| HCMFamMbrIsElgblTransAllwnc | HCMFamMbrIsElgblTransAllwnc | 1 | |
| HCMFamMbrIsEmployed | HCMFamMbrIsEmployed | 2 | |
| HCMFamMbrIsExtendedFamily | HCMFamMbrIsExtendedFamily | 1 | |
| HCMFamMbrIsFinDepdnt | HCMFamMbrIsFinDepdnt | 1 | |
| HCMFamMbrIsFosterChild | HCMFamMbrIsFosterChild | 1 | |
| HCMFamMbrIsGarnishmentRelevant | HCMFamMbrIsGarnishmentRelevant | 1 | |
| HCMFamMbrIsHandicapped | HCMFamMbrIsHandicapped | 1 | |
| HCMFamMbrIsLegalCohabitation | HCMFamMbrIsLegalCohabitation | 1 | |
| HCMFamMbrIsListedOnReport | HCMFamMbrIsListedOnReport | 1 | |
| HCMFamMbrIsLivingTogether | HCMFamMbrIsLivingTogether | 1 | |
| HCMFamMbrIsLvePassageApplbl | HCMFamMbrIsLvePassageApplbl | 1 | |
| HCMFamMbrIsNaturalized | HCMFamMbrIsNaturalized | 1 | |
| HCMFamMbrIsNHIExemptByLaw | HCMFamMbrIsNHIExemptByLaw | 1 | |
| HCMFamMbrIsNonCustodialChild | HCMFamMbrIsNonCustodialChild | 1 | |
| HCMFamMbrIsOnlyChild | HCMFamMbrIsOnlyChild | 1 | |
| HCMFamMbrIsOvr6MnthFosterChild | HCMFamMbrIsOvr6MnthFosterChild | 1 | |
| HCMFamMbrIsParticularPatient | HCMFamMbrIsParticularPatient | 1 | |
| HCMFamMbrIsPensioner | HCMFamMbrIsPensioner | 1 | |
| HCMFamMbrIsPhysicalChallenged | HCMFamMbrIsPhysicalChallenged | 1 | |
| HCMFamMbrIsReqSpecDevelopment | HCMFamMbrIsReqSpecDevelopment | 1 | |
| HCMFamMbrIsSameCompany | HCMFamMbrIsSameCompany | 1 | |
| HCMFamMbrIsSmoker | HCMFamMbrIsSmoker | 1 | |
| HCMFamMbrIsStudent | HCMFamMbrIsStudent | 4 | |
| HCMFamMbrIsStudying | HCMFamMbrIsStudying | 1 | |
| HCMFamMbrIsTaxDiscountElgbl | HCMFamMbrIsTaxDiscountElgbl | 1 | |
| HCMFamMbrIsUnder7Schoolchild | HCMFamMbrIsUnder7Schoolchild | 1 | |
| HCMFamMbrIsWidowed | HCMFamMbrIsWidowed | 1 | |
| HCMFamMbrIsWorking | HCMFamMbrIsWorking | 1 | |
| HCMFamMbrJobName | HCMFamMbrJobName | 2 | |
| HCMFamMbrJobStatusCode | HCMFamMbrJobStatusCode | 1 | |
| HCMFamMbrJobTitle | HCMFamMbrJobTitle | 2 | |
| HCMFamMbrJobTitleText | HCMFamMbrJobTitleText | 1 | |
| HCMFamMbrKanjiMiddleName | HCMFamMbrKanjiMiddleName | 1 | |
| HCMFamMbrKatakanaFirstName | HCMFamMbrKatakanaFirstName | 1 | |
| HCMFamMbrKatakanaLastName | HCMFamMbrKatakanaLastName | 1 | |
| HCMFamMbrKatakanaMiddleName | HCMFamMbrKatakanaMiddleName | 1 | |
| HCMFamMbrKosekiLastNameKanji | HCMFamMbrKosekiLastNameKanji | 1 | |
| HCMFamMbrKWIdNumber | HCMFamMbrKWIdNumber | 1 | |
| HCMFamMbrLaborPermitNumber | HCMFamMbrLaborPermitNumber | 1 | |
| HCMFamMbrLabPmtValidityDate | HCMFamMbrLabPmtValidityDate | 1 | |
| HCMFamMbrLastName | HCMFamMbrLastName | 2 | |
| HCMFamMbrLegalNomineeCode | HCMFamMbrLegalNomineeCode | 2 | |
| HCMFamMbrLglSeparationDate | HCMFamMbrLglSeparationDate | 2 | |
| HCMFamMbrLiveBirthCertificate | HCMFamMbrLiveBirthCertificate | 1 | |
| HCMFamMbrLiveWithDeduction | HCMFamMbrLiveWithDeduction | 1 | |
| HCMFamMbrMaritalStatusCode | HCMFamMbrMaritalStatusCode | 7 | |
| HCMFamMbrMaritalStatusDate | HCMFamMbrMaritalStatusDate | 2 | |
| HCMFamMbrMarriageCertNumber | HCMFamMbrMarriageCertNumber | 2 | |
| HCMFamMbrMedExamDate | HCMFamMbrMedExamDate | 1 | |
| HCMFamMbrMedlAbsncProofDte | HCMFamMbrMedlAbsncProofDte | 1 | |
| HCMFamMbrMiddleName | HCMFamMbrMiddleName | 1 | |
| HCMFamMbrMiddleNameKanji | HCMFamMbrMiddleNameKanji | 1 | |
| HCMFamMbrMiddleNameKatakana | HCMFamMbrMiddleNameKatakana | 1 | |
| HCMFamMbrModifierForPersId | HCMFamMbrModifierForPersId | 1 | |
| HCMFamMbrMotherFirstName | HCMFamMbrMotherFirstName | 1 | |
| HCMFamMbrMotherFullName | HCMFamMbrMotherFullName | 1 | |
| HCMFamMbrMotherIdentifier | HCMFamMbrMotherIdentifier | 1 | |
| HCMFamMbrMotherLastName | HCMFamMbrMotherLastName | 1 | |
| HCMFamMbrMunicipalityKeyCode | HCMFamMbrMunicipalityKeyCode | 1 | |
| HCMFamMbrNationalId | HCMFamMbrNationalId | 3 | |
| HCMFamMbrNaturalizationDate | HCMFamMbrNaturalizationDate | 1 | |
| HCMFamMbrNeighborhoodName | HCMFamMbrNeighborhoodName | 1 | |
| HCMFamMbrNHICntrbtFromDate | HCMFamMbrNHICntrbtFromDate | 1 | |
| HCMFamMbrNHIStatusCode | HCMFamMbrNHIStatusCode | 1 | |
| HCMFamMbrNHIStatusReasonCode | HCMFamMbrNHIStatusReasonCode | 1 | |
| HCMFamMbrNonResidentCode | HCMFamMbrNonResidentCode | 1 | |
| HCMFamMbrNumberOfChildren | HCMFamMbrNumberOfChildren | 1 | |
| HCMFamMbrNurturingBnftAmount | HCMFamMbrNurturingBnftAmount | 1 | |
| HCMFamMbrObjectIdentification | HCMFamMbrObjectIdentification | 1 | |
| HCMFamMbrObjId | HCMFamMbrObjId | 1 | |
| HCMFamMbrOccupationCode | HCMFamMbrOccupationCode | 1 | |
| HCMFamMbrOccupationStatus | HCMFamMbrOccupationStatus | 1 | |
| HCMFamMbrOccupationText | HCMFamMbrOccupationText | 2 | |
| HCMFamMbrOfclFirstNameKanji | HCMFamMbrOfclFirstNameKanji | 1 | |
| HCMFamMbrOfclFirstNameKatakana | HCMFamMbrOfclFirstNameKatakana | 1 | |
| HCMFamMbrOfclFirstNameRomaji | HCMFamMbrOfclFirstNameRomaji | 1 | |
| HCMFamMbrOMVisaNumber | HCMFamMbrOMVisaNumber | 1 | |
| HCMFamMbrOnlyChildCertDate | HCMFamMbrOnlyChildCertDate | 1 | |
| HCMFamMbrOnlyChildId | HCMFamMbrOnlyChildId | 1 | |
| HCMFamMbrOverseaExceptionCode | HCMFamMbrOverseaExceptionCode | 1 | |
| HCMFamMbrPartnerIncomeCode | HCMFamMbrPartnerIncomeCode | 1 | |
| HCMFamMbrPartnerProfessionCode | HCMFamMbrPartnerProfessionCode | 1 | |
| HCMFamMbrPassportExpDate | HCMFamMbrPassportExpDate | 1 | |
| HCMFamMbrPassportExpireDate | HCMFamMbrPassportExpireDate | 1 | |
| HCMFamMbrPassportExpiryDate | HCMFamMbrPassportExpiryDate | 4 | |
| HCMFamMbrPassportIssueDate | HCMFamMbrPassportIssueDate | 5 | |
| HCMFamMbrPassportNumber | HCMFamMbrPassportNumber | 7 | |
| HCMFamMbrPassportType | HCMFamMbrPassportType | 1 | |
| HCMFamMbrPensionNumber | HCMFamMbrPensionNumber | 1 | |
| HCMFamMbrPersnIsDisabled | HCMFamMbrPersnIsDisabled | 1 | |
| HCMFamMbrPhoneNumber | HCMFamMbrPhoneNumber | 10 | |
| HCMFamMbrPhoneTypeCode | HCMFamMbrPhoneTypeCode | 1 | |
| HCMFamMbrPoliticalStatusCode | HCMFamMbrPoliticalStatusCode | 1 | |
| HCMFamMbrPortOfEntryName | HCMFamMbrPortOfEntryName | 1 | |
| HCMFamMbrPostalCode | HCMFamMbrPostalCode | 9 | |
| HCMFamMbrPrivateHealthInsGroup | HCMFamMbrPrivateHealthInsGroup | 1 | |
| HCMFamMbrProofLegalDepDate | HCMFamMbrProofLegalDepDate | 1 | |
| HCMFamMbrProvinceName | HCMFamMbrProvinceName | 1 | |
| HCMFamMbrPsprtIssCntryCode | HCMFamMbrPsprtIssCntryCode | 1 | |
| HCMFamMbrPsprtIssPlaceTxt | HCMFamMbrPsprtIssPlaceTxt | 1 | |
| HCMFamMbrPublicNotaryName | HCMFamMbrPublicNotaryName | 1 | |
| HCMFamMbrQAEmployerTypeCode | HCMFamMbrQAEmployerTypeCode | 1 | |
| HCMFamMbrQAIdNumber | HCMFamMbrQAIdNumber | 1 | |
| HCMFamMbrQAVisaNumber | HCMFamMbrQAVisaNumber | 1 | |
| HCMFamMbrRaceCode | HCMFamMbrRaceCode | 1 | |
| HCMFamMbrRecordNumber | HCMFamMbrRecordNumber | 1 | |
| HCMFamMbrRegionCode | HCMFamMbrRegionCode | 7 | |
| HCMFamMbrRegistrationNumber | HCMFamMbrRegistrationNumber | 1 | |
| HCMFamMbrRegnSubmissionDate | HCMFamMbrRegnSubmissionDate | 1 | |
| HCMFamMbrRegnValidityYearDate | HCMFamMbrRegnValidityYearDate | 1 | |
| HCMFamMbrRelationshipCode | HCMFamMbrRelationshipCode | 1 | |
| HCMFamMbrResidencePermitNumber | HCMFamMbrResidencePermitNumber | 1 | |
| HCMFamMbrResidenceVisaExpDate | HCMFamMbrResidenceVisaExpDate | 1 | |
| HCMFamMbrResidenceVisaIssueDte | HCMFamMbrResidenceVisaIssueDte | 1 | |
| HCMFamMbrResidenceVisaNumber | HCMFamMbrResidenceVisaNumber | 1 | |
| HCMFamMbrResidencyTypeCode | HCMFamMbrResidencyTypeCode | 1 | |
| HCMFamMbrRomajiMiddleName | HCMFamMbrRomajiMiddleName | 1 | |
| HCMFamMbrRsdntlPmtValdtyDate | HCMFamMbrRsdntlPmtValdtyDate | 1 | |
| HCMFamMbrRutId | HCMFamMbrRutId | 1 | |
| HCMFamMbrSchoolCertValdtyDate | HCMFamMbrSchoolCertValdtyDate | 1 | |
| HCMFamMbrSchoolCityName | HCMFamMbrSchoolCityName | 1 | |
| HCMFamMbrSchoolCode | HCMFamMbrSchoolCode | 1 | |
| HCMFamMbrSchoolCountryCode | HCMFamMbrSchoolCountryCode | 1 | |
| HCMFamMbrSchoolHouseNumber | HCMFamMbrSchoolHouseNumber | 1 | |
| HCMFamMbrSchoolIdNumber | HCMFamMbrSchoolIdNumber | 1 | |
| HCMFamMbrSchoolingTypeCode | HCMFamMbrSchoolingTypeCode | 1 | |
| HCMFamMbrSchoolName | HCMFamMbrSchoolName | 2 | |
| HCMFamMbrSchoolPhoneNumber | HCMFamMbrSchoolPhoneNumber | 1 | |
| HCMFamMbrSchoolPostalCode | HCMFamMbrSchoolPostalCode | 1 | |
| HCMFamMbrSchoolRegionCode | HCMFamMbrSchoolRegionCode | 1 | |
| HCMFamMbrSchoolStreet | HCMFamMbrSchoolStreet | 1 | |
| HCMFamMbrShrdParentalLeaveDays | HCMFamMbrShrdParentalLeaveDays | 1 | |
| HCMFamMbrSickLeaveDate | HCMFamMbrSickLeaveDate | 1 | |
| HCMFamMbrSocialServicesNumber | HCMFamMbrSocialServicesNumber | 1 | |
| HCMFamMbrSpecialization | HCMFamMbrSpecialization | 2 | |
| HCMFamMbrSpouseCurrencyKey | HCMFamMbrSpouseCurrencyKey | 1 | |
| HCMFamMbrSpouseEarningsAmount | HCMFamMbrSpouseEarningsAmount | 1 | |
| HCMFamMbrSpouseEmployerName | HCMFamMbrSpouseEmployerName | 1 | |
| HCMFamMbrSpouseEmplStsCode | HCMFamMbrSpouseEmplStsCode | 2 | |
| HCMFamMbrSpouseIdentifier | HCMFamMbrSpouseIdentifier | 1 | |
| HCMFamMbrSpouseInSameCoNmbr | HCMFamMbrSpouseInSameCoNmbr | 1 | |
| HCMFamMbrSpousePersNoInSameCo | HCMFamMbrSpousePersNoInSameCo | 1 | |
| HCMFamMbrSpousePersNumber | HCMFamMbrSpousePersNumber | 2 | |
| HCMFamMbrSpouseTaxOfficeCode | HCMFamMbrSpouseTaxOfficeCode | 1 | |
| HCMFamMbrStartMonthOfNHICntrbt | HCMFamMbrNHIContributeFrom | 1 | |
| HCMFamMbrStateCode | HCMFamMbrStateCode | 1 | |
| HCMFamMbrStreet | HCMFamMbrStreet | 5 | |
| HCMFamMbrStreetName | HCMFamMbrStreetName | 1 | |
| HCMFamMbrStreetText | HCMFamMbrStreetText | 1 | |
| HCMFamMbrStudyGradeNumber | HCMFamMbrStudyGradeNumber | 1 | |
| HCMFamMbrSubtype | HCMFamMbrSubtype | 1 | |
| HCMFamMbrTaxId | HCMFamMbrTaxId | 2 | |
| HCMFamMbrTaxIsConfirmed | HCMFamMbrTaxIsConfirmed | 1 | |
| HCMFamMbrTaxPayerRefNumber | HCMFamMbrTaxPayerRefNumber | 1 | |
| HCMFamMbrTelephoneNumber | HCMFamMbrTelephoneNumber | 1 | |
| HCMFamMbrTicketEntlmntQtaType | HCMFamMbrTicketEntlmntQtaType | 1 | |
| HCMFamMbrTimeDate | HCMFamMbrTimeDate | 1 | |
| HCMFamMbrTinNumber | HCMFamMbrTinNumber | 1 | |
| HCMFamMbrToDate | HCMFamMbrToDate | 1 | |
| HCMFamMbrTownName | HCMFamMbrTownName | 1 | |
| HCMFamMbrTransAllwncEffDate | HCMFamMbrTransAllwncEffDate | 1 | |
| HCMFamMbrTypeOfChallengeCode | HCMFamMbrTypeOfChallengeCode | 1 | |
| HCMFamMbrUnifiedNumber | HCMFamMbrUnifiedNumber | 1 | |
| HCMFamMbrUnifiedNumberExpDate | HCMFamMbrUnifiedNumberExpDate | 1 | |
| HCMFamMbrUnifiedNumberIssueDte | HCMFamMbrUnifiedNumberIssueDte | 1 | |
| HCMFamMbrUNOrgKey | HCMFamMbrUNOrgKey | 1 | |
| HCMFamMbrVaccinateCardExpDate | HCMFamMbrVaccinateCardExpDate | 1 | |
| HCMFamMbrVillageName | HCMFamMbrVillageName | 1 | |
| HCMFamMbrVisaExpireDate | HCMFamMbrVisaExpireDate | 1 | |
| HCMFamMbrVisaExpiryDate | HCMFamMbrVisaExpiryDate | 3 | |
| HCMFamMbrVisaIssueDate | HCMFamMbrVisaIssueDate | 3 | |
| HCMFamMbrVisaNumber | HCMFamMbrVisaNumber | 1 | |
| HCMFamMbrWageType | HCMFamMbrWageType | 1 | |
| HCMFamMbrWageTypeAmount | HCMFamMbrWageTypeAmount | 1 | |
| HCMFamMbrWorkerIdCode | HCMFamMbrWorkerIdCode | 1 | |
| HCMPersDataAcademicDegreeCode | HCMPersDataAcademicDegreeCode | 1 | |
| HCMPersDataActualJobTxt | HCMPersDataActualJobTxt | 1 | |
| HCMPersDataAEHomeAirportCode | HCMPersDataAEHomeAirportCode | 1 | |
| HCMPersDataAESponsorId | HCMPersDataAESponsorId | 1 | |
| HCMPersDataArabicFirstName | HCMPersDataArabicFirstName | 3 | |
| HCMPersDataArabicLastName | HCMPersDataArabicLastName | 3 | |
| HCMPersDataArabicSecondName | HCMPersDataArabicSecondName | 3 | |
| HCMPersDataArabicThirdName | HCMPersDataArabicThirdName | 3 | |
| HCMPersDataBirthCertNumber | HCMPersDataBirthCertNumber | 2 | |
| HCMPersDataBloodGroup | HCMPersDataBloodGroup | 2 | |
| HCMPersDataBrdrEntryNumberText | HCMPersDataBrdrEntryNumberText | 1 | |
| HCMPersDataCoAccommodation | HCMPersDataCoAccommodation | 1 | |
| HCMPersDataContributionStrtDte | HCMPersDataContributionStrtDte | 1 | |
| HCMPersDataCountryEntranceDate | HCMPersDataCountryEntranceDate | 1 | |
| HCMPersDataEduLevelLegalRptTxt | HCMPersDataEduLevelLegalRptTxt | 1 | |
| HCMPersDataEnglishFirstName | HCMPersDataEnglishFirstName | 2 | |
| HCMPersDataEntryDate | HCMPersDataEntryDate | 2 | |
| HCMPersDataFatherName | HCMPersDataFatherName | 1 | |
| HCMPersDataFinNumber | HCMPersDataFinNumber | 1 | |
| HCMPersDataForeignNipCode | HCMPersDataForeignNipCode | 1 | |
| HCMPersDataGenderCode | HCMPersDataGenderCode | 3 | |
| HCMPersDataGulfCprtnCouncilID | HCMPersDataGulfCprtnCouncilID | 1 | |
| HCMPersDataHasAccommodation | HCMPersDataHasAccommodation | 1 | |
| HCMPersDataHasCatering | HCMPersDataHasCatering | 1 | |
| HCMPersDataHasCompanyTransport | HCMPersDataHasCompanyTransport | 1 | |
| HCMPersDataHasNipOnPitForms | HCMPersDataHasNipOnPitForms | 1 | |
| HCMPersDataHasNoCompanyHousing | HCMPersDataHasNoCompanyHousing | 2 | |
| HCMPersDataHasTransportation | HCMPersDataHasTransportation | 1 | |
| HCMPersDataHiringTestScoreVal | HCMPersDataHiringTestScoreVal | 1 | |
| HCMPersDataHomeAirport | HCMPersDataHomeAirport | 1 | |
| HCMPersDataIsElgblLeavePassage | HCMPersDataIsElgblLeavePassage | 1 | |
| HCMPersDataIsExcludeFrmLglRpt | HCMPersDataIsExcludeFrmLglRpt | 2 | |
| HCMPersDataIsExcludeLegalRpt | HCMPersDataIsExcludeLegalRpt | 3 | |
| HCMPersDataIsFamilyResidesInQA | HCMPersDataIsFamilyResidesInQA | 1 | |
| HCMPersDataIsFamilyResidesInSA | HCMPersDataIsFamilyResidesInSA | 1 | |
| HCMPersDataIsSingleParent | HCMPersDataIsSingleParent | 1 | |
| HCMPersDataJobCategoryCode | HCMPersDataJobCategoryCode | 1 | |
| HCMPersDataJobOnResidentPermit | HCMPersDataJobOnResidentPermit | 1 | |
| HCMPersDataKnownAsTxt | HCMPersDataKnownAsTxt | 2 | |
| HCMPersDataKWHomeAirportCode | HCMPersDataKWHomeAirportCode | 1 | |
| HCMPersDataKWSponsorId | HCMPersDataKWSponsorId | 1 | |
| HCMPersDataLanguageLevelText | HCMPersDataLanguageLevelText | 1 | |
| HCMPersDataLanguageSkill | HCMPersDataLanguageSkill | 1 | |
| HCMPersDataLastEnglishName | HCMPersDataLastEnglishName | 2 | |
| HCMPersDataLegalProfession | HCMPersDataLegalProfession | 1 | |
| HCMPersDataLegalReportingProf | HCMPersDataLegalReportingProf | 1 | |
| HCMPersDataMotherBirthName | HCMPersDataMotherBirthName | 1 | |
| HCMPersDataMotherName | HCMPersDataMotherName | 1 | |
| HCMPersDataNationalityNumber | HCMPersDataNationalityNumber | 1 | |
| HCMPersDataNationalizationDate | HCMPersDataNationalizationDate | 1 | |
| HCMPersDataNatltyAcqnDate | HCMPersDataNatltyAcqnDate | 1 | |
| HCMPersDataNatltyAcqnRsnText | HCMPersDataNatltyAcqnRsnText | 1 | |
| HCMPersDataOMHomeAirportCode | HCMPersDataOMHomeAirportCode | 1 | |
| HCMPersDataPassportProfCode | HCMPersDataPassportProfCode | 2 | |
| HCMPersDataPassportProfession | HCMPersDataPassportProfession | 1 | |
| HCMPersDataPersonCodeText | HCMPersDataPersonCodeText | 1 | |
| HCMPersDataPortOfEntryText | HCMPersDataPortOfEntryText | 2 | |
| HCMPersDataProfessionCode | HCMPersDataProfessionCode | 3 | |
| HCMPersDataProfessionText | HCMPersDataProfessionText | 1 | |
| HCMPersDataProfileClassCode | HCMPersDataProfileClassCode | 1 | |
| HCMPersDataQAHomeAirportCode | HCMPersDataQAHomeAirportCode | 1 | |
| HCMPersDataSecondEnglishName | HCMPersDataSecondEnglishName | 2 | |
| HCMPersDataSexOrientationCode | HCMPersDataSexOrientationCode | 1 | |
| HCMPersDataSpecializationText | HCMPersDataSpecializationText | 1 | |
| HCMPersDataSponsorId | HCMPersDataSponsorId | 2 | |
| HCMPersDataSponsorshipNumber | HCMPersDataSponsorshipNumber | 1 | |
| HCMPersDataThirdEnglishName | HCMPersDataThirdEnglishName | 2 | |
| HCMPersDataTinNumber | HCMPersDataTinNumber | 1 | |
| HCMPersonFirstNameHanja | HCMPersonFirstNameHanja | 1 | |
| HCMPersonFirstNameKR | HCMPersonFirstNameKR | 1 | |
| HCMPersonLastNameHanja | HCMPersonLastNameHanja | 1 | |
| HCMPersonLastNameKR | HCMPersonLastNameKR | 1 | |
| HCMPersonRegNumber | HCMPersonRegNumber | 1 | |
| HCMProvinceTaxCode | HCMProvinceTaxCode | 1 | |
| ID_HCMFamMbrBnftClsForBPJS | ID_HCMFamMbrBnftClsForBPJS | 1 | |
| ID_HCMFamMbrBPJSId | ID_HCMFamMbrBPJSId | 1 | |
| ID_HCMFamMbrBPJSInsDepType | ID_HCMFamMbrBPJSInsDepType | 1 | |
| PL_HCMFamMbrHouseNumber | PL_HCMFamMbrHouseNumber | 1 | |
| PL_HCMFamMbrIdNumber | PL_HCMFamMbrIdNumber | 1 | |
| PL_HCMFamMbrPESELNumber | PL_HCMFamMbrPESELNumber | 1 | |
| PL_HCMFamMbrStreet | PL_HCMFamMbrStreet | 1 | |
| PL_HCMFamMbrZCNACodeZUS | PL_HCMFamMbrZCNACodeZUS | 1 | |
| PL_HCMPersDataPESELNumber | PL_HCMPersDataPESELNumber | 1 | |
| PT_HCMFamMbrADSEBnfcyNumber | PT_HCMFamMbrADSEBnfcyNumber | 1 | |
| PT_HCMFamMbrADSECardValdtyDate | PT_HCMFamMbrADSECardValdtyDate | 1 | |
| PT_HCMFamMbrSSInstitutionCode | PT_HCMFamMbrSSInstitutionCode | 1 | |
| PT_HCMFamMbrSSNumber | PT_HCMFamMbrSSNumber | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ADDITIONALDATA (
BE_HCMFAMMBRISDFDIRSISCARD,
BE_HCMFAMMBRNATURALPERSONPID,
BE_HCMFAMMBRPBDFDIRSISCARD,
BE_HCMFAMMBRSISCARDFCTRYNUMBER,
BE_HCMFAMMBRSISCARDNUMBER,
BE_HCMFAMMBRSISCARDTYPEID,
CHMLCMPSTNINPROCSTATUS,
CHMLCMPSTNRELDSTATUS,
CHMLCOMPOSITIONUUID,
CN_HCMFAMMBRHUKOUCODE,
CURRENCY,
HCM_FAMMBRCCLENTLINYROFBRTH,
HCM_FAMMBRHASCCLSTRTFROMYRBRTH,
HCMBANKDATADUTYSTATIONCODE,
HCMBANKDATAIDTYPECODE,
HCMFAMCASEQNUMBER,
HCMFAMILYMEMBERCHILDTYPECODE,
HCMFAMILYMEMBERISDECEASED,
HCMFAMILYMEMBERKANJIFIRSTNAME,
HCMFAMILYMEMBERKANJILASTNAME,
HCMFAMMBR2NDADDRESSLINE,
HCMFAMMBR2NDBNFTPHYSNID,
HCMFAMMBR2NDBNFTPHYSNNAME,
HCMFAMMBR2NDDOCUMENTEXPIRYDATE,
HCMFAMMBR2NDDOCUMENTISSUEDATE,
HCMFAMMBR2NDDOCUMENTNUMBER,
HCMFAMMBR2NDDOCUMENTTYPECODE,
HCMFAMMBR2NDNAME,
HCMFAMMBR3RDDOCUMENTEXPIRYDATE,
HCMFAMMBR3RDDOCUMENTISSUEDATE,
HCMFAMMBR3RDDOCUMENTNUMBER,
HCMFAMMBR3RDDOCUMENTTYPECODE,
HCMFAMMBR4THDOCUMENTEXPIRYDATE,
HCMFAMMBR4THDOCUMENTISSUEDATE,
HCMFAMMBR4THDOCUMENTNUMBER,
HCMFAMMBR4THDOCUMENTTYPECODE,
HCMFAMMBR5THDOCUMENTEXPIRYDATE,
HCMFAMMBR5THDOCUMENTISSUEDATE,
HCMFAMMBR5THDOCUMENTNUMBER,
HCMFAMMBR5THDOCUMENTTYPECODE,
HCMFAMMBR6THDOCUMENTEXPIRYDATE,
HCMFAMMBR6THDOCUMENTISSUEDATE,
HCMFAMMBR6THDOCUMENTNUMBER,
HCMFAMMBR6THDOCUMENTTYPECODE,
HCMFAMMBR7THDOCUMENTEXPIRYDATE,
HCMFAMMBR7THDOCUMENTISSUEDATE,
HCMFAMMBR7THDOCUMENTNUMBER,
HCMFAMMBR7THDOCUMENTTYPECODE,
HCMFAMMBR8THDOCUMENTEXPIRYDATE,
HCMFAMMBR8THDOCUMENTISSUEDATE,
HCMFAMMBR8THDOCUMENTNUMBER,
HCMFAMMBR8THDOCUMENTTYPECODE,
HCMFAMMBRACADEMICDEGREE,
HCMFAMMBRACADEMICDEGREECODE,
HCMFAMMBRADDRESSNUMBER,
HCMFAMMBRADJUSTDEDUCTTARGET,
HCMFAMMBRADOPTIONDATE,
HCMFAMMBRAEVISANUMBER,
HCMFAMMBRAGEGROUPDEDUCTIONCODE,
HCMFAMMBRALLOWANCETYPECODE,
HCMFAMMBRALLWNCRECEIPTDATE,
HCMFAMMBRALTERNATIVENAME,
HCMFAMMBRAPARTMENTID,
HCMFAMMBRARABICFIRSTNAME,
HCMFAMMBRARABICLASTNAME,
HCMFAMMBRARABICSECONDNAME,
HCMFAMMBRARABICTHIRDNAME,
HCMFAMMBRARRIVALDATE,
HCMFAMMBRBIRTHADOPTIONNOTIFDTE,
HCMFAMMBRBIRTHCERTREGISTER,
HCMFAMMBRBLOODGROUPCODE,
HCMFAMMBRBNFTPHYSICIANID,
HCMFAMMBRBNFTPHYSICIANNAME,
HCMFAMMBRBORDERENTRYNUMBER,
HCMFAMMBRBRTHCERTIFICATENUMBER,
HCMFAMMBRCAENDDATE,
HCMFAMMBRCAOBJID,
HCMFAMMBRCASTARTDATE,
HCMFAMMBRCASUBTYPE,
HCMFAMMBRCERTDELIVERYDATE,
HCMFAMMBRCHALLENGETYPECODE,
HCMFAMMBRCHANGEREASONCODE,
HCMFAMMBRCHANGEREASONTEXT,
HCMFAMMBRCHILDBNFTPROLONGDATE,
HCMFAMMBRCHILDDSBLTYPILLAR1,
HCMFAMMBRCHILDDSBLTYPILLAR2,
HCMFAMMBRCHILDDSBLTYPILLAR3,
HCMFAMMBRCHILDDSBLTYTOTPILLAR,
HCMFAMMBRCHILDHASALLOWANCE,
HCMFAMMBRCHILDIDENTIFIER,
HCMFAMMBRCHILDSTATUSCODE,
HCMFAMMBRCHINESENAME,
HCMFAMMBRCITIZENSERVICENUMBER,
HCMFAMMBRCITYNAME,
HCMFAMMBRCITYTEXT,
HCMFAMMBRCIVILID,
HCMFAMMBRCIVILIDEXPDATE,
HCMFAMMBRCIVILIDISSUEDATE,
HCMFAMMBRCOMMNUMBER1,
HCMFAMMBRCOMMNUMBER2,
HCMFAMMBRCOMMNUMBER3,
HCMFAMMBRCOMMNUMBER4,
HCMFAMMBRCOMMTYPE1CODE,
HCMFAMMBRCOMMTYPE2CODE,
HCMFAMMBRCOMMTYPE3CODE,
HCMFAMMBRCOMMTYPE4CODE,
HCMFAMMBRCOMMTYPECODE1,
HCMFAMMBRCOMMTYPECODE2,
HCMFAMMBRCOMMTYPECODE3,
HCMFAMMBRCOMMTYPECODE4,
HCMFAMMBRCONAME,
HCMFAMMBRCONFINEMENTNUMBER,
HCMFAMMBRCONTRIBUTIONSCALE,
HCMFAMMBRCORELATIONSHIPTEXT,
HCMFAMMBRCOUNTRYCODE,
HCMFAMMBRCOUNTRYENTRANCEDATE,
HCMFAMMBRCOUNTYCODE,
HCMFAMMBRCPFNUMBER,
HCMFAMMBRCURRENCYKEY,
HCMFAMMBRCURRENTSCHOOLGRADE,
HCMFAMMBRDATETYPE1EVENTCODE,
HCMFAMMBRDATETYPE2EVENTSCODE,
HCMFAMMBRDEATHDATE,
HCMFAMMBRDEPDNTFORYEARENDADJMT,
HCMFAMMBRDEPDNTHLTHINSUR,
HCMFAMMBRDEPDNTISDISABLED,
HCMFAMMBRDEPDNTLIVINGWITHNAME,
HCMFAMMBRDEPDNTLIVINGWITHSTATC,
HCMFAMMBRDEPDNTNURSEINSUR,
HCMFAMMBRDEPDNTTOTINCAMOUNT,
HCMFAMMBRDEPDNTTYPECODE,
HCMFAMMBRDEPENDENTSCOUNTRYCODE,
HCMFAMMBRDEPENDENTTYPECODE,
HCMFAMMBRDEPESTTOTINCAMOUNT,
HCMFAMMBRDEPTDEDUCTIONCODE,
HCMFAMMBRDESIGNATIONNAME,
HCMFAMMBRDISABILITYDESCTEXT,
HCMFAMMBRDISABILITYGRADE,
HCMFAMMBRDISABILITYLEVELCODE,
HCMFAMMBRDISABILITYREASONTEXT,
HCMFAMMBRDISABLEDDEDUCTIONCODE,
HCMFAMMBRDISTRICTNAME,
HCMFAMMBRDISTRICTTEXT,
HCMFAMMBRDOCNMBR1EXPIRYDATE,
HCMFAMMBRDOCNMBR1ISSUEDATE,
HCMFAMMBRDOCNMBR2EXPIRYDATE,
HCMFAMMBRDOCNMBR2ISSUEDATE,
HCMFAMMBRDOCNMBR3EXPIRYDATE,
HCMFAMMBRDOCNMBR3ISSUEDATE,
HCMFAMMBRDOCNMBR4EXPIRYDATE,
HCMFAMMBRDOCNMBR4ISSUEDATE,
HCMFAMMBRDOCNMBR5EXPIRYDATE,
HCMFAMMBRDOCNMBR5ISSUEDATE,
HCMFAMMBRDOCNMBR6EXPIRYDATE,
HCMFAMMBRDOCNMBR6ISSUEDATE,
HCMFAMMBRDOCNMBR7EXPIRYDATE,
HCMFAMMBRDOCNMBR7ISSUEDATE,
HCMFAMMBRDOCNMBR8EXPIRYDATE,
HCMFAMMBRDOCNMBR8ISSUEDATE,
HCMFAMMBRDOCUMENTEXPIRYDATE,
HCMFAMMBRDOCUMENTISSUEDATE,
HCMFAMMBRDOCUMENTNUMBER,
HCMFAMMBRDOCUMENTNUMBER1,
HCMFAMMBRDOCUMENTNUMBER2,
HCMFAMMBRDOCUMENTNUMBER3,
HCMFAMMBRDOCUMENTNUMBER4,
HCMFAMMBRDOCUMENTNUMBER5,
HCMFAMMBRDOCUMENTNUMBER6,
HCMFAMMBRDOCUMENTNUMBER7,
HCMFAMMBRDOCUMENTNUMBER8,
HCMFAMMBRDOCUMENTTYPECODE,
HCMFAMMBRDOCUMENTTYPECODE1,
HCMFAMMBRDOCUMENTTYPECODE2,
HCMFAMMBRDOCUMENTTYPECODE3,
HCMFAMMBRDOCUMENTTYPECODE4,
HCMFAMMBRDOCUMENTTYPECODE5,
HCMFAMMBRDOCUMENTTYPECODE6,
HCMFAMMBRDOCUMENTTYPECODE7,
HCMFAMMBRDOCUMENTTYPECODE8,
HCMFAMMBRDPNDCYDESCRIPTIONTEXT,
HCMFAMMBRDRIVERSLICENSENUMBER,
HCMFAMMBRDRIVERSLICEXPIREDTE,
HCMFAMMBRDSBLTYDETNDATE,
HCMFAMMBRDSBLTYPCTGRATE,
HCMFAMMBRDUTYSTATIONCODE,
HCMFAMMBREDUCATIONLEVELCODE,
HCMFAMMBREDUCATIONSPECCODE,
HCMFAMMBREMPLOYERDSBLTYDTE,
HCMFAMMBREMPLOYERNAME,
HCMFAMMBREMPLOYERTYPECODE,
HCMFAMMBREMPLOYMENTDATE,
HCMFAMMBRENTRYDATE,
HCMFAMMBRENTRYLEDGERNUMBER,
HCMFAMMBRENTRYSHEETNUMBER,
HCMFAMMBRETHNICORIGINCODE,
HCMFAMMBREXEMPTIONREASONCODE,
HCMFAMMBRFACTLIVEHOODTEXT,
HCMFAMMBRFAMILYALLOWANCE,
HCMFAMMBRFATHERIDENTIFIER,
HCMFAMMBRFINSUPPAMOUNT,
HCMFAMMBRFINSUPPCURRENCYKEY,
HCMFAMMBRFIRSTNAME,
HCMFAMMBRFORMOFADDRESSCODE,
HCMFAMMBRFROMDATE,
HCMFAMMBRFULLADDRESSTEXT,
HCMFAMMBRGRADECODE,
HCMFAMMBRHANDICAPCODE,
HCMFAMMBRHANDICAPENDDATE,
HCMFAMMBRHANDICAPSTARTDATE,
HCMFAMMBRHASACMDTNENTLMNT,
HCMFAMMBRHASBIRTHCERT,
HCMFAMMBRHASBNFTFININDEP,
HCMFAMMBRHASBNFTMEDICARE,
HCMFAMMBRHASBNFTMILITARY,
HCMFAMMBRHASBNFTNONTAXABLE,
HCMFAMMBRHASBNFTSMOKER,
HCMFAMMBRHASCARENEEDS,
HCMFAMMBRHASCCSLVALIDITY,
HCMFAMMBRHASCHALLENGE,
HCMFAMMBRHASCHALLENGEBONUS,
HCMFAMMBRHASCHILDALLOWANCE,
HCMFAMMBRHASCHILDCARESUBSIDY,
HCMFAMMBRHASCHILDCUSTODY,
HCMFAMMBRHASCHILDHANDICAP,
HCMFAMMBRHASCOMMONHOUSEHOLD,
HCMFAMMBRHASCOMPANYTRANSPORT,
HCMFAMMBRHASCREDITCARD,
HCMFAMMBRHASDISABILITY,
HCMFAMMBRHASEDUCATIONEXPENSE,
HCMFAMMBRHASEXTENDEDAGELIMIT,
HCMFAMMBRHASFAMILYALLOWANCE,
HCMFAMMBRHASFORCEPAYMENT,
HCMFAMMBRHASHALFCHILDALLOWANCE,
HCMFAMMBRHASHEALTHINSURANCE,
HCMFAMMBRHASINCOVR3MNTHMINPENS,
HCMFAMMBRHASINSURANCE,
HCMFAMMBRHASLEAVEPASSAGE,
HCMFAMMBRHASLIVINGALLOWANCE,
HCMFAMMBRHASMEDICALEXPENSE,
HCMFAMMBRHASNHIFAMILY,
HCMFAMMBRHASNURSINGALLOWANCE,
HCMFAMMBRHASNURTURINGBNFT,
HCMFAMMBRHASOTHERADDRESS,
HCMFAMMBRHASPARENTALRESPY,
HCMFAMMBRHASPRIVATEHEALTHPLAN,
HCMFAMMBRHASPROLIFECERTIFICATE,
HCMFAMMBRHASPROOFLEGALDEP,
HCMFAMMBRHASREGNSUBMISSION,
HCMFAMMBRHASRETIREINCOMEFORRES,
HCMFAMMBRHASSCHOLARSHIPBENEFIT,
HCMFAMMBRHASSHRDACCOMMODATION,
HCMFAMMBRHASSHRDPARENTALLEAVE,
HCMFAMMBRHASSOLESUPPORT,
HCMFAMMBRHASTWIN,
HCMFAMMBRHASUNDERDEPENDENTS,
HCMFAMMBRHEALTHNATIONALCARD,
HCMFAMMBRHIJRIBIRTHDATE,
HCMFAMMBRHLTHINSPRIMPAIDBYCODE,
HCMFAMMBRHOUSENUMBER,
HCMFAMMBRIDDOCUMENTTYPECODE,
HCMFAMMBRIDENTIFICATIONCARDID,
HCMFAMMBRIDEXPDATE,
HCMFAMMBRIDEXPIRYDATE,
HCMFAMMBRIDEXPIRYDATE1,
HCMFAMMBRIDISSUECOUNTRYCODE1,
HCMFAMMBRIDISSUEDATE,
HCMFAMMBRIDISSUEDATE1,
HCMFAMMBRIDISSUEPLACETEXT,
HCMFAMMBRIDISSUINGAUTH1,
HCMFAMMBRIDNUMBER,
HCMFAMMBRIDNUMBER1,
HCMFAMMBRIDNUMBER2,
HCMFAMMBRIDNUMBER3,
HCMFAMMBRIDNUMBER4,
HCMFAMMBRIDNUMBER5,
HCMFAMMBRIDNUMBERCHECKERROR,
HCMFAMMBRIDSPOUSEFATHER,
HCMFAMMBRIDSPOUSEMOTHER,
HCMFAMMBRIDTYPE,
HCMFAMMBRIDTYPECODE1,
HCMFAMMBRIDTYPECODE2,
HCMFAMMBRIDTYPECODE3,
HCMFAMMBRIDTYPECODE4,
HCMFAMMBRIDTYPECODE5,
HCMFAMMBRIDTYPECODE6,
HCMFAMMBRIDVALIDITYDATE,
HCMFAMMBRILLNESSCODE1,
HCMFAMMBRILLNESSCODE2,
HCMFAMMBRINCISMORETHAN4000,
HCMFAMMBRINCOMETAXNUMBER,
HCMFAMMBRINDIVIDUALREGNUMBER,
HCMFAMMBRINITIALS,
HCMFAMMBRINSCONFIRMFLAG,
HCMFAMMBRIQAMAEXPIREDATE,
HCMFAMMBRIQAMANUMBER,
HCMFAMMBRISADOPTEDCHILD,
HCMFAMMBRISAGEDDEPENDENT,
HCMFAMMBRISBSCLIVINGDEPENDENT,
HCMFAMMBRISCHARGEPERSON,
HCMFAMMBRISCHILDALLWNCELGBL,
HCMFAMMBRISCHILDCAREEXEMPT,
HCMFAMMBRISDEPDNTFORTAX,
HCMFAMMBRISDEPENDENT,
HCMFAMMBRISDISABLED,
HCMFAMMBRISECONOMICDEPDNT,
HCMFAMMBRISEDUALLOWANCEELGBL,
HCMFAMMBRISEDUDEPDNT,
HCMFAMMBRISELGBLFORHLTHINS,
HCMFAMMBRISELGBLFORTRVLTICKET,
HCMFAMMBRISELGBLTRANSALLWNC,
HCMFAMMBRISEMPLOYED,
HCMFAMMBRISEXTENDEDFAMILY,
HCMFAMMBRISFINDEPDNT,
HCMFAMMBRISFOSTERCHILD,
HCMFAMMBRISGARNISHMENTRELEVANT,
HCMFAMMBRISHANDICAPPED,
HCMFAMMBRISLEGALCOHABITATION,
HCMFAMMBRISLISTEDONREPORT,
HCMFAMMBRISLIVINGTOGETHER,
HCMFAMMBRISLVEPASSAGEAPPLBL,
HCMFAMMBRISNATURALIZED,
HCMFAMMBRISNHIEXEMPTBYLAW,
HCMFAMMBRISNONCUSTODIALCHILD,
HCMFAMMBRISONLYCHILD,
HCMFAMMBRISOVR6MNTHFOSTERCHILD,
HCMFAMMBRISPARTICULARPATIENT,
HCMFAMMBRISPENSIONER,
HCMFAMMBRISPHYSICALCHALLENGED,
HCMFAMMBRISREQSPECDEVELOPMENT,
HCMFAMMBRISSAMECOMPANY,
HCMFAMMBRISSMOKER,
HCMFAMMBRISSTUDENT,
HCMFAMMBRISSTUDYING,
HCMFAMMBRISTAXDISCOUNTELGBL,
HCMFAMMBRISUNDER7SCHOOLCHILD,
HCMFAMMBRISWIDOWED,
HCMFAMMBRISWORKING,
HCMFAMMBRJOBNAME,
HCMFAMMBRJOBSTATUSCODE,
HCMFAMMBRJOBTITLE,
HCMFAMMBRJOBTITLETEXT,
HCMFAMMBRKANJIMIDDLENAME,
HCMFAMMBRKATAKANAFIRSTNAME,
HCMFAMMBRKATAKANALASTNAME,
HCMFAMMBRKATAKANAMIDDLENAME,
HCMFAMMBRKOSEKILASTNAMEKANJI,
HCMFAMMBRKWIDNUMBER,
HCMFAMMBRLABORPERMITNUMBER,
HCMFAMMBRLABPMTVALIDITYDATE,
HCMFAMMBRLASTNAME,
HCMFAMMBRLEGALNOMINEECODE,
HCMFAMMBRLGLSEPARATIONDATE,
HCMFAMMBRLIVEBIRTHCERTIFICATE,
HCMFAMMBRLIVEWITHDEDUCTION,
HCMFAMMBRMARITALSTATUSCODE,
HCMFAMMBRMARITALSTATUSDATE,
HCMFAMMBRMARRIAGECERTNUMBER,
HCMFAMMBRMEDEXAMDATE,
HCMFAMMBRMEDLABSNCPROOFDTE,
HCMFAMMBRMIDDLENAME,
HCMFAMMBRMIDDLENAMEKANJI,
HCMFAMMBRMIDDLENAMEKATAKANA,
HCMFAMMBRMODIFIERFORPERSID,
HCMFAMMBRMOTHERFIRSTNAME,
HCMFAMMBRMOTHERFULLNAME,
HCMFAMMBRMOTHERIDENTIFIER,
HCMFAMMBRMOTHERLASTNAME,
HCMFAMMBRMUNICIPALITYKEYCODE,
HCMFAMMBRNATIONALID,
HCMFAMMBRNATURALIZATIONDATE,
HCMFAMMBRNEIGHBORHOODNAME,
HCMFAMMBRNHICNTRBTFROMDATE,
HCMFAMMBRNHISTATUSCODE,
HCMFAMMBRNHISTATUSREASONCODE,
HCMFAMMBRNONRESIDENTCODE,
HCMFAMMBRNUMBEROFCHILDREN,
HCMFAMMBRNURTURINGBNFTAMOUNT,
HCMFAMMBROBJECTIDENTIFICATION,
HCMFAMMBROBJID,
HCMFAMMBROCCUPATIONCODE,
HCMFAMMBROCCUPATIONSTATUS,
HCMFAMMBROCCUPATIONTEXT,
HCMFAMMBROFCLFIRSTNAMEKANJI,
HCMFAMMBROFCLFIRSTNAMEKATAKANA,
HCMFAMMBROFCLFIRSTNAMEROMAJI,
HCMFAMMBROMVISANUMBER,
HCMFAMMBRONLYCHILDCERTDATE,
HCMFAMMBRONLYCHILDID,
HCMFAMMBROVERSEAEXCEPTIONCODE,
HCMFAMMBRPARTNERINCOMECODE,
HCMFAMMBRPARTNERPROFESSIONCODE,
HCMFAMMBRPASSPORTEXPDATE,
HCMFAMMBRPASSPORTEXPIREDATE,
HCMFAMMBRPASSPORTEXPIRYDATE,
HCMFAMMBRPASSPORTISSUEDATE,
HCMFAMMBRPASSPORTNUMBER,
HCMFAMMBRPASSPORTTYPE,
HCMFAMMBRPENSIONNUMBER,
HCMFAMMBRPERSNISDISABLED,
HCMFAMMBRPHONENUMBER,
HCMFAMMBRPHONETYPECODE,
HCMFAMMBRPOLITICALSTATUSCODE,
HCMFAMMBRPORTOFENTRYNAME,
HCMFAMMBRPOSTALCODE,
HCMFAMMBRPRIVATEHEALTHINSGROUP,
HCMFAMMBRPROOFLEGALDEPDATE,
HCMFAMMBRPROVINCENAME,
HCMFAMMBRPSPRTISSCNTRYCODE,
HCMFAMMBRPSPRTISSPLACETXT,
HCMFAMMBRPUBLICNOTARYNAME,
HCMFAMMBRQAEMPLOYERTYPECODE,
HCMFAMMBRQAIDNUMBER,
HCMFAMMBRQAVISANUMBER,
HCMFAMMBRRACECODE,
HCMFAMMBRRECORDNUMBER,
HCMFAMMBRREGIONCODE,
HCMFAMMBRREGISTRATIONNUMBER,
HCMFAMMBRREGNSUBMISSIONDATE,
HCMFAMMBRREGNVALIDITYYEARDATE,
HCMFAMMBRRELATIONSHIPCODE,
HCMFAMMBRRESIDENCEPERMITNUMBER,
HCMFAMMBRRESIDENCEVISAEXPDATE,
HCMFAMMBRRESIDENCEVISAISSUEDTE,
HCMFAMMBRRESIDENCEVISANUMBER,
HCMFAMMBRRESIDENCYTYPECODE,
HCMFAMMBRROMAJIMIDDLENAME,
HCMFAMMBRRSDNTLPMTVALDTYDATE,
HCMFAMMBRRUTID,
HCMFAMMBRSCHOOLCERTVALDTYDATE,
HCMFAMMBRSCHOOLCITYNAME,
HCMFAMMBRSCHOOLCODE,
HCMFAMMBRSCHOOLCOUNTRYCODE,
HCMFAMMBRSCHOOLHOUSENUMBER,
HCMFAMMBRSCHOOLIDNUMBER,
HCMFAMMBRSCHOOLINGTYPECODE,
HCMFAMMBRSCHOOLNAME,
HCMFAMMBRSCHOOLPHONENUMBER,
HCMFAMMBRSCHOOLPOSTALCODE,
HCMFAMMBRSCHOOLREGIONCODE,
HCMFAMMBRSCHOOLSTREET,
HCMFAMMBRSHRDPARENTALLEAVEDAYS,
HCMFAMMBRSICKLEAVEDATE,
HCMFAMMBRSOCIALSERVICESNUMBER,
HCMFAMMBRSPECIALIZATION,
HCMFAMMBRSPOUSECURRENCYKEY,
HCMFAMMBRSPOUSEEARNINGSAMOUNT,
HCMFAMMBRSPOUSEEMPLOYERNAME,
HCMFAMMBRSPOUSEEMPLSTSCODE,
HCMFAMMBRSPOUSEIDENTIFIER,
HCMFAMMBRSPOUSEINSAMECONMBR,
HCMFAMMBRSPOUSEPERSNOINSAMECO,
HCMFAMMBRSPOUSEPERSNUMBER,
HCMFAMMBRSPOUSETAXOFFICECODE,
HCMFAMMBRSTARTMONTHOFNHICNTRBT,
HCMFAMMBRSTATECODE,
HCMFAMMBRSTREET,
HCMFAMMBRSTREETNAME,
HCMFAMMBRSTREETTEXT,
HCMFAMMBRSTUDYGRADENUMBER,
HCMFAMMBRSUBTYPE,
HCMFAMMBRTAXID,
HCMFAMMBRTAXISCONFIRMED,
HCMFAMMBRTAXPAYERREFNUMBER,
HCMFAMMBRTELEPHONENUMBER,
HCMFAMMBRTICKETENTLMNTQTATYPE,
HCMFAMMBRTIMEDATE,
HCMFAMMBRTINNUMBER,
HCMFAMMBRTODATE,
HCMFAMMBRTOWNNAME,
HCMFAMMBRTRANSALLWNCEFFDATE,
HCMFAMMBRTYPEOFCHALLENGECODE,
HCMFAMMBRUNIFIEDNUMBER,
HCMFAMMBRUNIFIEDNUMBEREXPDATE,
HCMFAMMBRUNIFIEDNUMBERISSUEDTE,
HCMFAMMBRUNORGKEY,
HCMFAMMBRVACCINATECARDEXPDATE,
HCMFAMMBRVILLAGENAME,
HCMFAMMBRVISAEXPIREDATE,
HCMFAMMBRVISAEXPIRYDATE,
HCMFAMMBRVISAISSUEDATE,
HCMFAMMBRVISANUMBER,
HCMFAMMBRWAGETYPE,
HCMFAMMBRWAGETYPEAMOUNT,
HCMFAMMBRWORKERIDCODE,
HCMPERSDATAACADEMICDEGREECODE,
HCMPERSDATAACTUALJOBTXT,
HCMPERSDATAAEHOMEAIRPORTCODE,
HCMPERSDATAAESPONSORID,
HCMPERSDATAARABICFIRSTNAME,
HCMPERSDATAARABICLASTNAME,
HCMPERSDATAARABICSECONDNAME,
HCMPERSDATAARABICTHIRDNAME,
HCMPERSDATABIRTHCERTNUMBER,
HCMPERSDATABLOODGROUP,
HCMPERSDATABRDRENTRYNUMBERTEXT,
HCMPERSDATACOACCOMMODATION,
HCMPERSDATACONTRIBUTIONSTRTDTE,
HCMPERSDATACOUNTRYENTRANCEDATE,
HCMPERSDATAEDULEVELLEGALRPTTXT,
HCMPERSDATAENGLISHFIRSTNAME,
HCMPERSDATAENTRYDATE,
HCMPERSDATAFATHERNAME,
HCMPERSDATAFINNUMBER,
HCMPERSDATAFOREIGNNIPCODE,
HCMPERSDATAGENDERCODE,
HCMPERSDATAGULFCPRTNCOUNCILID,
HCMPERSDATAHASACCOMMODATION,
HCMPERSDATAHASCATERING,
HCMPERSDATAHASCOMPANYTRANSPORT,
HCMPERSDATAHASNIPONPITFORMS,
HCMPERSDATAHASNOCOMPANYHOUSING,
HCMPERSDATAHASTRANSPORTATION,
HCMPERSDATAHIRINGTESTSCOREVAL,
HCMPERSDATAHOMEAIRPORT,
HCMPERSDATAISELGBLLEAVEPASSAGE,
HCMPERSDATAISEXCLUDEFRMLGLRPT,
HCMPERSDATAISEXCLUDELEGALRPT,
HCMPERSDATAISFAMILYRESIDESINQA,
HCMPERSDATAISFAMILYRESIDESINSA,
HCMPERSDATAISSINGLEPARENT,
HCMPERSDATAJOBCATEGORYCODE,
HCMPERSDATAJOBONRESIDENTPERMIT,
HCMPERSDATAKNOWNASTXT,
HCMPERSDATAKWHOMEAIRPORTCODE,
HCMPERSDATAKWSPONSORID,
HCMPERSDATALANGUAGELEVELTEXT,
HCMPERSDATALANGUAGESKILL,
HCMPERSDATALASTENGLISHNAME,
HCMPERSDATALEGALPROFESSION,
HCMPERSDATALEGALREPORTINGPROF,
HCMPERSDATAMOTHERBIRTHNAME,
HCMPERSDATAMOTHERNAME,
HCMPERSDATANATIONALITYNUMBER,
HCMPERSDATANATIONALIZATIONDATE,
HCMPERSDATANATLTYACQNDATE,
HCMPERSDATANATLTYACQNRSNTEXT,
HCMPERSDATAOMHOMEAIRPORTCODE,
HCMPERSDATAPASSPORTPROFCODE,
HCMPERSDATAPASSPORTPROFESSION,
HCMPERSDATAPERSONCODETEXT,
HCMPERSDATAPORTOFENTRYTEXT,
HCMPERSDATAPROFESSIONCODE,
HCMPERSDATAPROFESSIONTEXT,
HCMPERSDATAPROFILECLASSCODE,
HCMPERSDATAQAHOMEAIRPORTCODE,
HCMPERSDATASECONDENGLISHNAME,
HCMPERSDATASEXORIENTATIONCODE,
HCMPERSDATASPECIALIZATIONTEXT,
HCMPERSDATASPONSORID,
HCMPERSDATASPONSORSHIPNUMBER,
HCMPERSDATATHIRDENGLISHNAME,
HCMPERSDATATINNUMBER,
HCMPERSONFIRSTNAMEHANJA,
HCMPERSONFIRSTNAMEKR,
HCMPERSONLASTNAMEHANJA,
HCMPERSONLASTNAMEKR,
HCMPERSONREGNUMBER,
HCMPROVINCETAXCODE,
ID_HCMFAMMBRBNFTCLSFORBPJS,
ID_HCMFAMMBRBPJSID,
ID_HCMFAMMBRBPJSINSDEPTYPE,
PL_HCMFAMMBRHOUSENUMBER,
PL_HCMFAMMBRIDNUMBER,
PL_HCMFAMMBRPESELNUMBER,
PL_HCMFAMMBRSTREET,
PL_HCMFAMMBRZCNACODEZUS,
PL_HCMPERSDATAPESELNUMBER,
PT_HCMFAMMBRADSEBNFCYNUMBER,
PT_HCMFAMMBRADSECARDVALDTYDATE,
PT_HCMFAMMBRSSINSTITUTIONCODE,
PT_HCMFAMMBRSSNUMBER
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA