ICLX_PARTICIPANT

Error Table for Participants with XI Input | #masterdata | Component: Claims Management
Column Name Description
CLIENT Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM Number of Claim
PARTICIPANT_GUID GUID of Length 32
Column Name Description
Column Name Description
Column Name Description
BIRTHDT Participant: Participant Date of Birth
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
TYPE Participant: Participant Type Show values
Column Name Description Domain name
CLAIM_GUID GUID of Length 32 SYSUUID_C
CREATEDBY Created By XUBNAME
CREATETIME Created: Date + Time ICL_TIMESTAMP
PARTICIPANT_NO Participant: Participant Number BU_PARTNER
NAME_LAST Participant: Participant Last Name BU_NAME
NAME_FIRST Participant: Participant First Name BU_NAME
ORG_NAME_LAST Participant: Participant Name 1 BU_NAME
ORG_NAME_FIRST Participant: Participant Name 2 BU_NAME
SEX Participant: Participant Gender Key BU_SEXID
STREET Participant: Participant Street TEXT60
HOUSE_NUM1 Participant: Participant House Number TEXT10
POST_CODE1 Participant: Participant Postal Code CHAR10
CITY1 Participant: Participant City TEXT40
COUNTRY Participant: Country/Region Key LAND1
REGION Participant: Participant Region Key REGIO
TEL_NUMBER Participant: Participant Phone Number CHAR30
TEL_EXTENS Participant: Participant Phone Number Extension CHAR10
FAX_NUMBER Participant: Participant Fax Number CHAR30
FAX_EXTENS Participant: Participant Fax Number Extension CHAR10
SMTP_ADDR Participant: Participant Email Address CHAR50
FEIN Participant: Participant Federal Employer Identification No. BPTAXNUM
SSN Participant: Participant Social Security Number BPTAXNUM
LANGUAGE Participant: Participant Language Key SPRAS
Master Data Relations Join Conditions
Participant: Participant Marital Status Key
  • ICLX_PARTICIPANT.CLIENT == TB027.CLIENT
  • ICLX_PARTICIPANT.MARST == TB027.MARST
Participant: Participant Title Key
  • Participant: Participant Title Key
  • Client
  • ICLX_PARTICIPANT.TITLE == TSAD3.TITLE
  • ICLX_PARTICIPANT.CLIENT == TSAD3.CLIENT