SAP Table NPAT - IS-H: Patient Master Data (General)

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
PATNR X PATNR CHAR 3 10 0 NPAT IS-H: Patient Number
EINRI EINRI CHAR 13 4 0 TN01 IS-H: Institution
GSCHL GSCHL CHAR 17 1 0 IS-H: Sex Indicator - Internal
NNAME NNAME_PAT CHAR 18 30 0 IS-H: Patient Last Name
NNAMS NNAMES_PAT CHAR 48 30 0 IS-H: Standardized Last Name
VNAME VNAME_PAT CHAR 78 30 0 IS-H: Patient First Name
VNAMS VNAMES_PAT CHAR 108 30 0 Standardized First Name
TITEL RI_TITEL CHAR 138 15 0 T535N IS-H: Title
NAMZU RI_NAMZU CHAR 153 15 0 T535N IS-H: Name Affix
VORSW RI_VORSW CHAR 168 15 0 T535N IS-H: Name Prefix
NAME2 NAME2_PAT CHAR 183 30 0 Pseudonym, Order Name
GBDAT RI_GBDAT DATS 213 8 0 IS-H: Birthdate
GBNAM GBNAM CHAR 221 30 0 IS-H: Birthname
GBNAS GBNAMS_PAT CHAR 251 30 0 IS-H: Standardized Birthname
GLAND GLAND CHAR 281 3 0 T005 IS-H: Country of Birth
TODKZ PAT_TOD CHAR 284 1 0 IS-H: Patient Is Deceased
TODDT TODDV DATS 285 8 0 IS-H: Date of Death From
TODZT TODZV TIMS 293 6 0 Time of Death From
TODDB TODDB DATS 299 8 0 Date of Death To
TODZB TODZB TIMS 307 6 0 IS-H: Time of Death To
TODUR TODUR CHAR 313 3 0 IS-H: Cause of Death
ANRED RI_ANRDS CHAR 316 2 0 IS-H: Form-of-Address Key
FAMST RI_FAMST CHAR 318 1 0 IS-H: Marital Status
KONFE RI_KONFE CHAR 319 2 0 IS-H: Religion
NATIO RI_NATIO CHAR 321 3 0 T005 IS-H: Nationality
SPRAS SPRAS_PAT LANG 324 1 0 T002 Patient Language
LAND LAND_PAT CHAR 325 3 0 T005 IS-H: Country of patient's place of residence
PSTLZ PSTLZ_PAT CHAR 328 10 0 IS-H: Patient Postal Code
ORT ORT01_PAT CHAR 338 25 0 IS-H: City where Patient Resides
ORT2 ORT02_PAT CHAR 363 25 0 Patient District
STRAS STRAS_PAT CHAR 388 30 0 IS-H: Street and House Number of Patient
BLAND ISH_REGION CHAR 418 3 0 T005S IS-H: Region (Federal State, Province, County)
GEBIE EINZGEBIET CHAR 421 9 0 NPEZ IS-H: Geographical Area
TELF1 TELF_PAT CHAR 430 16 0 IS-H: Patient Telephone Number
SPEND SPENKZ CHAR 446 1 0 IS-H: Organ Donor Indicator
SPENT SPENTEXT CHAR 447 50 0 Explanation for Donor Indicator
SPELT RI_LGTXT CHAR 497 1 0 Indicator that Long Text Exists
VIPKZ VIPKZ CHAR 498 1 0 IS-H: VIP Indicator
ARCHV ARCHIV CHAR 499 1 0 IS-H: Archived Data Indicator
STATU PAT_STATUS CHAR 500 1 0 Patient Status
EXTNR EXT_PATNR CHAR 501 20 0 IS-H: External Patient Identification
NOTAN NOTAUF CHAR 521 1 0 IS-H: Emergency Admission Indicator
KRZAN KURZAUF CHAR 522 1 0 IS-H: Quick Admission Indicator
RFPAT RFPAT CHAR 523 10 0 NPAT Reference to Patient Number in Merging
RFZIF PZIFF_PAT CHAR 533 1 0 IS-H: Check Digit for Patient
BERUF BERUF CHAR 534 25 0 IS-H: Patient Occupation
AGNUM AGNUM_PAT CHAR 559 10 0 NGPA IS-H: Patient's Employer
AGNAM AGNAM CHAR 569 30 0 IS-H: Employer Name
AGLAN AGLAN CHAR 599 3 0 T005 IS-H: Employer Country
AGPLZ AGPLZ CHAR 602 10 0 IS-H: Employer Postal Code
AGORT AGORT CHAR 612 25 0 IS-H: Employer City
AGSTR AGSTR CHAR 637 30 0 IS-H: Employer Street
AGTEL AGTEL CHAR 667 16 0 IS-H: Employer Telephone Number
RVNUM ISH_RVNUM CHAR 683 20 0 IS-H: Social Insurance Number
ANNA1 NNAME_ANG CHAR 703 30 0 IS-H: Last Name of Person to Be Contacted
ANVN1 VNAME_ANG CHAR 733 30 0 IS-H: First Name of Person to Be Contacted
ANLA1 LAND_ANG CHAR 763 3 0 T005 Country of the Person to Be Contacted
ANPL1 PSTLZ_ANG CHAR 766 10 0 IS-H: Postal Code
ANOR1 ORT01_ANG CHAR 776 25 0 IS-H: City where Person to Be Contacted Resides
ANST1 STRAS_ANG CHAR 801 30 0 IS-H: Street and House Number of Person to Be Contacted
ANTE1 TELF_ANG CHAR 831 16 0 IS-H: Telephone Number of Person to Be Contacted
ANVV1 VERWVH CHAR 847 1 0 IS-H: Relationship
VMKZ1 VORMUND CHAR 848 1 0 IS-H: Legal Representative
ANNA2 NNAME_ANG CHAR 849 30 0 IS-H: Last Name of Person to Be Contacted
ANVN2 VNAME_ANG CHAR 879 30 0 IS-H: First Name of Person to Be Contacted
ANLA2 LAND_ANG CHAR 909 3 0 T005 Country of the Person to Be Contacted
ANPL2 PSTLZ_ANG CHAR 912 10 0 IS-H: Postal Code
ANOR2 ORT01_ANG CHAR 922 25 0 IS-H: City where Person to Be Contacted Resides
ANST2 STRAS_ANG CHAR 947 30 0 IS-H: Street and House Number of Person to Be Contacted
ANTE2 TELF_ANG CHAR 977 16 0 IS-H: Telephone Number of Person to Be Contacted
ANVV2 VERWVH CHAR 993 1 0 IS-H: Relationship
VMKZ2 VORMUND CHAR 994 1 0 IS-H: Legal Representative
KZTXT TEXT_PAT CHAR 995 50 0 IS-H: Comment on Patient
LGTXT RI_LGTXT CHAR 1045 1 0 Indicator that Long Text Exists
BEGDT RI_BEGDT DATS 1046 8 0 IS-H: Valid-From Date of Record
ENDDT RI_ENDDT DATS 1054 8 0 IS-H: Valid-To Date of Record
HISTK RI_HISTK CHAR 1062 1 0 Indicator that History Records Are Available
RISKF ISH_RISIKO CHAR 1063 1 0 IS-H: Risk Information Exists for the Patient
TESTP TESTP CHAR 1064 1 0 Test Patient Status
PZIFF PZIFF_PAT CHAR 1065 1 0 IS-H: Check Digit for Patient
ERDAT RI_ERDAT DATS 1066 8 0 IS-H: Date when Record Created
ERUSR RI_ERNAM CHAR 1074 12 0 IS-H: Name of Employee who Created Record
UPDAT RI_UPDAT DATS 1086 8 0 IS-H: Date of Last Change
UPUSR RI_UPNAM CHAR 1094 12 0 IS-H: Name of Person who Last Changed Data
STORN RI_STORN CHAR 1106 1 0 IS-H: Cancellation Indicator
STUSR STORN_USER CHAR 1107 12 0 IS-H: Name of User who Canceled Data Record
STDAT STORN_DAT DATS 1119 8 0 Date of Cancellation
GBORT ISH_GBORT CHAR 1127 25 0 IS-H: Patient Birthplace
HARNR HARNR CHAR 1152 10 0 NGPA IS-H: Personnel Number of Family Physician
EARNR EARNR CHAR 1162 10 0 NGPA IS-H: Personnel Number of Referring Physician
UARNR UARNR CHAR 1172 10 0 NGPA IS-H: Personnel Number of Referring Physician
RACE ISH_RACE CHAR 1182 2 0 IS-H: Race
RESID ISH_RESID CHAR 1184 1 0 IS-H: Indicator that Patient is Non-Resident
PASSTY ISH_PASSTY CHAR 1185 2 0 Type of Identification Document
PASSNR ISH_PASSNR CHAR 1187 15 0 IS-H: Identification Document Number
ADRNR ISH_ADRNR CHAR 1202 10 0 NADR IS-H: Address Number
ADROB ISH_ADROBJ CHAR 1212 4 0 IS-H: Address Object
ADNAG ISH_ADRNR CHAR 1216 10 0 NADR IS-H: Address Number
ADOAG ISH_ADROBJ CHAR 1226 4 0 IS-H: Address Object
ADNN1 ISH_ADRNR CHAR 1230 10 0 NADR IS-H: Address Number
ADON1 ISH_ADROBJ CHAR 1240 4 0 IS-H: Address Object
ADNN2 ISH_ADRNR CHAR 1244 10 0 NADR IS-H: Address Number
ADON2 ISH_ADROBJ CHAR 1254 4 0 IS-H: Address Object
ANEX1 EXTNR_ANG CHAR 1258 20 0 IS-H: External Identification of Next of Kin/Assoc. Party
ANEX2 EXTNR_ANG CHAR 1278 20 0 IS-H: External Identification of Next of Kin/Assoc. Party
ADRN2 ISH_ADRNR CHAR 1298 10 0 NADR IS-H: Address Number
ADRO2 ISH_ADROBJ CHAR 1308 4 0 IS-H: Address Object
INACT ISH_INACTIVE CHAR 1312 1 0 'Inactive' Indicator
USER1 ISH_PATUSER1 CHAR 1313 20 0 IS-H: User-Defined Field 1
USER2 ISH_PATUSER2 CHAR 1333 20 0 IS-H: User-Defined Field 2
USER3 ISH_PATUSER3 DATS 1353 8 0 IS-H: User-Defined Field 3
USER4 ISH_PATUSER4 DATS 1361 8 0 IS-H: User-Defined Field 4
USER5 ISH_PATUSER5 CHAR 1369 50 0 IS-H: User-Defined Field 5
USER6 ISH_PATUSER6 CHAR 1419 1 0 IS-H: User-Defined Field 6
EXTAUFG EXTAUFG CHAR 1420 1 0
EXTAUFGA EXTAUFGA CHAR 1421 2 0
EMPSC ISH_EMPDAT DATS 1423 8 0 IS-H: Employed Since
UNKNOWN_GBDAT ISH_UNKNOWN_GBDAT CHAR 1431 1 0
INSID ISH_VERS_NR CHAR 1432 1 0