| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | PARTNER | Identification of Patient w. Prov. Data | nvarchar | 10 | 0 | CHAR | (N' ') | No | BUT000 | ISH_PPT_ID | Allow NULL? |
| 3 | STD_LN | IS-H: Standardized Last Name | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | NNAMES_PAT | Allow NULL? |
| 4 | STD_FN | Standardized First Name | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | VNAMES_PAT | Allow NULL? |
| 5 | STD_BN | IS-H: Standardized Birth Name | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | GBNAMS_PAT | Allow NULL? |
| 6 | CRT_USR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 7 | CRT_DAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 8 | CHG_USR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 9 | CHG_DAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 10 | CCL_USR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
| 11 | CCL_DAT | Date of Cancellation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORN_DAT | Allow NULL? |
| 12 | CCL_IND | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 13 | SI_NUM | IS-H: Social Insurance Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_RVNUM | Allow NULL? |
| 14 | DOC_TYP | Type of Identification Document | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN17D | ISH_PASSTY | Allow NULL? |
| 15 | DOC_NUM | IS-H: Identification Document Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | ISH_PASSNR | Allow NULL? |
| 16 | DOB_UN | Birthdate Is Unknown | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_UNKNOWN_GBDAT | Allow NULL? |
| 17 | PNT_EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | EXT_PATNR | Allow NULL? |
| 18 | PPT_GA | IS-H: Geographical Area | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | EINZGEBIET | Allow NULL? |
| 19 | /ISHFR/BIRTHRK | IS-H FR: Birth Rank | char | 1 | 0 | NUMC | (N'0') | Yes | | /ISHFR/ISH_BIRTH_RANK | Allow NULL? |
| 20 | LAST_NAME_LONG | Patient Last Name | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | ISH_NNAME_PAT_LONG | Allow NULL? |
| 21 | FIRST_NAME_LONG | Patient First Name | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | ISH_VNAME_PAT_LONG | Allow NULL? |
| 22 | BIRTH_NAME_LONG | Birth Name | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | ISH_GBNAM_LONG | Allow NULL? |
