Field
Type
Length
Data element
Description
EXT_PAT_ID
CHAR
000020
External Patient Identification
EXT_PAT_IDX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
LAST_NAME_PAT
CHAR
000030
Patient Last Name
LAST_NAME_PATX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
FRST_NAME_PAT
CHAR
000030
Patient First Name
FRST_NAME_PATX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
BIRTH_NAME
CHAR
000030
Birthname
BIRTH_NAMEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
DOB
DATS
000008
Birthdate
DOBX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
BIRTHCTRY
CHAR
000003
Country of Birth
BIRTHCTRYX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
BIRTHCTRY_ISO
CHAR
000002
ISO Code of the Country/Region
BIRTHPLACE
CHAR
000025
Patient Birthplace
BIRTHPLACEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
SEX_EXT
CHAR
000001
Sex Indicator - User-Specific
SEX_EXTX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
PSEUDO
CHAR
000030
Pseudonym, Order Name
PSEUDOX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
FORM_ADDRS_STXT
CHAR
000004
Form-of-Address Key
FORM_ADDRS_STXTX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
TITLE
CHAR
000004
Academic Title: Key
TITLEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
AFFIX
CHAR
000004
Name supplement, e.g. noble title (key)
AFFIXX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
PREFIX
CHAR
000004
Name Prefix (Key)
PREFIXX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
PAT_ADDR_NO
CHAR
000010
Address Number
PAT_ADDR_NOX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
PAT_ADDR2_NO
CHAR
000010
Address Number
PAT_ADDR2_NOX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
MAR_STAT_TEXT
CHAR
000006
Marital Status
MAR_STAT_TEXTX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
REL_DENOM_STXT
CHAR
000004
Religious Denomination
REL_DENOM_STXTX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
NATIONALITY
CHAR
000003
Nationality
NATIONALITYX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
PAT_LANGU
LANG
000001
Patient Language
PAT_LANGUX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
PAT_LANGU_ISO
CHAR
000002
2-Character SAP Language Code
ORGAN_DONOR
CHAR
000001
Organ Donor Indicator
ORGAN_DONORX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
VIP
CHAR
000001
VIP Indicator
VIPX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
EXPIRED
CHAR
000001
Patient Is Deceased
EXPIREDX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
DT_O_DEATH_FROM
DATS
000008
Date of Death From
DT_O_DEATH_FROMX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
TM_O_DEATH_FROM
TIMS
000006
Time of Death From
TM_O_DEATH_FROMX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
DT_O_DEATH_TO
DATS
000008
Date of Death To
DT_O_DEATH_TOX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
TM_O_DEATH_TO
TIMS
000006
Time of Death To
TM_O_DEATH_TOX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
C_OF_DEATH
CHAR
000003
Cause of Death
C_OF_DEATHX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
EMERG_ADM
CHAR
000001
Emergency Admission Indicator
EMERG_ADMX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
QUICK_ADM
CHAR
000001
Quick Admission Indicator
QUICK_ADMX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
NON_RESIDENT
CHAR
000001
Indicator That Patient Is Non-Resident
NON_RESIDENTX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
INACTIVE
CHAR
000001
'Inactive' Indicator
INACTIVEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
PUBLISTBLOCK
CHAR
000001
Patient Does not Appear in Public List
PUBLISTBLOCKX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
RELIG_LIST
CHAR
000001
Religious List Indicator
RELIG_LISTX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
PARISH
CHAR
000002
Parish
PARISHX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
RACEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
SSN
CHAR
000020
Social Insurance Number
SSNX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
DOC_TYPE
CHAR
000002
Type of Identification Document
DOC_TYPEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
DOC_NO
CHAR
000015
Identification Document Number
DOC_NOX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP1_LNAME
CHAR
000030
Last Name of Person to Be Contacted
CONTACTP1_LNAMEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP1_FNAME
CHAR
000030
First Name of Person to Be Contacted
CONTACTP1_FNAMEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP1_RELSH
CHAR
000001
Relationship
CONTACTP1_RELSHX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP1_LGLREP
CHAR
000001
Legal Representative
CONTACTP1_LGLREPX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP1_EXTID
CHAR
000020
External Identification of Next of Kin
CONTACTP1_EXTIDX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP1_ADDRNO
CHAR
000010
Address Number
CONTACTP1_ADDRNOX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP2_LNAME
CHAR
000030
Last Name of Person to Be Contacted
CONTACTP2_LNAMEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP2_FNAME
CHAR
000030
First Name of Person to Be Contacted
CONTACTP2_FNAMEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP2_RELSH
CHAR
000001
Relationship
CONTACTP2_RELSHX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP2_LGLREP
CHAR
000001
Legal Representative
CONTACTP2_LGLREPX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP2_EXTID
CHAR
000020
External Identification of Next of Kin
CONTACTP2_EXTIDX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
CONTACTP2_ADDRNO
CHAR
000010
Address Number
CONTACTP2_ADDRNOX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
FAM_PHYS
CHAR
000010
Personnel Number of Family Physician
FAM_PHYSX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
REF_PHYS
CHAR
000010
Personnel Number of Referring Physician
REF_PHYSX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
REF_PHYS2
CHAR
000010
Personnel Number of Referring Physician
REF_PHYS2X
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
USER1
CHAR
000020
User-Defined Field 1
USER1X
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
USER2
CHAR
000020
User-Defined Field 2
USER2X
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
USER3
DATS
000008
User-Defined Field 3
USER3X
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
USER4
DATS
000008
User-Defined Field 4
USER4X
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
USER5
CHAR
000050
User-Defined Field 5
USER5X
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
USER6
CHAR
000001
User-Defined Field 6
USER6X
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
UPDATE_DATE
DATS
000008
Date of Last Change
UPDATE_DATEX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
UPDATE_USER
CHAR
000012
Name of Person Who Last Changed Data
UPDATE_USERX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
DTH_LOC
CHAR
000002
Location
DTH_LOCX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
POST_DIS_PHYS
CHAR
000010
Postdischarge Physician for Inpatient Stays
POST_DIS_PHYSX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
POST_DIS_PHYS_OUTP
CHAR
000010
Postdischarge Physician for Outpatient Stays
POST_DIS_PHYS_OUTPX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
LAST_NAME_PAT_LONG
CHAR
000070
Patient Last Name
LAST_NAME_PAT_LONGX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
FRST_NAME_PAT_LONG
CHAR
000070
Patient First Name
FRST_NAME_PAT_LONGX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
BIRTH_NAME_LONG
CHAR
000070
Birth Name
BIRTH_NAME_LONGX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
TITLE_ACA2
CHAR
000004
Second academic title (key)
TITLE_ACA2X
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
SEX_SPECIALIZATION
CHAR
000001
Additional Attribute for Sex
SEX_SPECIALIZATIONX
CHAR
000001
Boolean Data Type for ON (= "X") and OFF (= " ")
Length: 39422 Date: 20240425 Time: 080938 sap01-206 ( 86 ms )
