| 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 | T000 | MANDT | Allow NULL? |
| 2 | PARTNER | Insurance Provider Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | BUT000 | ISH_INS_ID | Allow NULL? |
| 3 | INS_PROV_GRP | IS-H: Indicator Denoting Insurance Provider Group | char | 1 | 0 | CHAR | (N' ') | Yes | | GRU_KZ | Allow NULL? |
| 4 | INS_PROV_TYPE | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TN18 | KOSTR_ART | Allow NULL? |
| 5 | TYPE_CP_REL | IS-H: Determine IV Control Parameters Using Ins. Prov. Type | char | 1 | 0 | CHAR | (N' ') | Yes | | KTART_PARA | Allow NULL? |
| 6 | HINS_NUM | IS-H: Number Identifying the Health Insurer | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | KKSNR | Allow NULL? |
| 7 | HINS_CARD_NUM | IS-H: Health Insurer Number as per Healthcare Smart Card | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHIPNR | Allow NULL? |
| 8 | CONT_PER1 | Contact Person, e.g. Inpatient | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ANPER1 | Allow NULL? |
| 9 | CONT_PER2 | Contact Person, e.g. Outpatient | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ANPER2 | Allow NULL? |
| 10 | SORT_BILL | IS-H: Sort Rules for Billing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ABRSORT | Allow NULL? |
| 11 | INDV_INVP | IS-H: Invoice List Output per IP at Invoice Print | char | 1 | 0 | CHAR | (N' ') | Yes | | SAMMELRE | Allow NULL? |
| 12 | IB_WO_COC | IS-H: Interim Billing for Svces w/o Confirmation of Coverage | char | 1 | 0 | CHAR | (N' ') | Yes | | ABRLEI_ZWI | Allow NULL? |
| 13 | FB_WO_COC | IS-H: Final Billing for Svces w/o Confirmation of Coverage | char | 1 | 0 | CHAR | (N' ') | Yes | | ENDABR_LEI | Allow NULL? |
| 14 | FB_ON_DIAG | IS-H: Final Billing only if Diagnosis Entered | char | 1 | 0 | CHAR | (N' ') | Yes | | ENDABR_DIA | Allow NULL? |
| 15 | IB_DAYS | IS-H: Interim Billing After x Days as of Admission | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ABR_TAGE | Allow NULL? |
| 16 | INT_BILL | IS-H: Ind. Specifying if Int. Bill. is to be Performed | char | 1 | 0 | CHAR | (N' ') | Yes | | ABR_ZWI | Allow NULL? |
| 17 | INVP_CTRL | IS-H: Control for Invoice Print | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_RDRUCK | Allow NULL? |
| 18 | MAN_INV_PROC | IS-H: Manual Invoice Processing is Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | REBEARB | Allow NULL? |
| 19 | INV_COMP | IS-H: Separate Invoice for Companion | char | 1 | 0 | CHAR | (N' ') | Yes | | SEP_RE | Allow NULL? |
| 20 | PFI_PRINT | IS-H: Print Pro Forma Invoice | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PROFORMA | Allow NULL? |
| 21 | IV_REQD | IS-H: Insurance Verification Procedure 'X'=Yes, ' '=No | char | 1 | 0 | CHAR | (N' ') | Yes | | KUEVER | Allow NULL? |
| 22 | IB_INTRVL | IS-H: Interim Billing Interval (Weeks/Days/Quarter) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ABR_INTERV | Allow NULL? |
| 23 | FB_INTRVL | IS-H: Final Billing Interval (Weekly, Every 2 Weeks,Monthly) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RHYT_ENDAB | Allow NULL? |
| 24 | IV_RMNDR | IS-H: Insurance Verification Reminder; 'X'=Yes ' '=No | char | 1 | 0 | CHAR | (N' ') | Yes | | KUEMAH | Allow NULL? |
| 25 | IVR_RMNDR_DAYS | IS-H: Reminder Period for IV Request in Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | KUE_MAFRI | Allow NULL? |
| 26 | IVR_ON_DIAG | IS-H: Send IV Request Only if Diagnosis Is Maintained | char | 1 | 0 | CHAR | (N' ') | Yes | | KUEVERSAND | Allow NULL? |
| 27 | COMTY | Insurance Communication Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ISH_CN_COMTYPE | Allow NULL? |
| 28 | IVR_DIAG_PRINT | IS-H: Print Diagnosis on IV Request (Yes/No) | char | 1 | 0 | CHAR | (N' ') | Yes | | DIADRUCK | Allow NULL? |
| 29 | IVR_ADMN_NOTIF | IS-H: Admission Notif. to Be Printed in Standard Form Print | char | 1 | 0 | CHAR | (N' ') | Yes | | AUFN_ANZ | Allow NULL? |
| 30 | IVR_DISCH_NOTIF | IS-H: Discharge Notification to Be Created | char | 1 | 0 | CHAR | (N' ') | Yes | | ENTL_ANZ | Allow NULL? |
| 31 | COPAY_REQD | IS-H: Insurance Provider Requires Copayment | char | 1 | 0 | CHAR | (N' ') | Yes | | KOSTR_ZUZ | Allow NULL? |
| 32 | COPAY_PROC | IS-H: Copayment Procedure for Billing | char | 1 | 0 | CHAR | (N' ') | Yes | | VERFZUZ | Allow NULL? |
| 33 | SOCIAL_INS | IS-H: Indicator for Social Insurance | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_SOZIALVERS | Allow NULL? |
| 34 | IVR_EXT_INTRVL | IS-H: Interval for Extending IV Requests | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | VERL_KUEAN | Allow NULL? |
| 35 | IVR_CRT_INTRVL | IS-H: Interval for Creating IV Requests | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | KUEAN_ZTR | Allow NULL? |
| 36 | START_DAY | IS-H: Start Day for Interval | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | STARTTAG | Allow NULL? |
| 37 | PSIGN | IS-H: Insurance Provider Control | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KTR_TYPE | Allow NULL? |
| 38 | INS_CURR | IS-H: Currency of Insurance Provider | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS_KTR | Allow NULL? |
| 39 | CRT_USR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 40 | CRT_DAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 41 | CHG_USR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 42 | CHG_DAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 43 | DEL_USR | User Who Deleted Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_LOUSR | Allow NULL? |
| 44 | DEL_DAT | Date of Deletion | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_LODAT | Allow NULL? |
| 45 | DEL_FLG | Deletion Flag/Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LOEKZ | Allow NULL? |
| 46 | TAX_CLASS | IS-H: Tax Classification of Insurance Provider | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXKD_ISH | Allow NULL? |
| 47 | DCP_HCM | Data Collection Point for EDI Message Transmission | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NC301P | ISH_DAS301 | Allow NULL? |
| 48 | PPA_SNAME | IS-H: HI Search Name From Ins. Provider Master File (PPA) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ISH_KSSNAM | Allow NULL? |
| 49 | INS_SNAME | IS-H: Stnd. HI Search Name from Ins. Provider Master File | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ISH_KSSNAS | Allow NULL? |
| 50 | PPA_NUM | Responsible PPA Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_PPA_ID | Allow NULL? |
| 51 | REJ_DL_IV | IS-H CH: Rejection deadline for insurance verification | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_KUALF | Allow NULL? |
| 52 | IV_PROC_CH | IS-H CH: IV procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNWCH72 | NWCH_KUCODE | Allow NULL? |
| 53 | EA_NUM | IS-H CH: European Article Number (EAN) | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | NWCH_EANR | Allow NULL? |
| 54 | TIERS_PAY_PROC | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 55 | PROC_LKF_ACC | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 56 | INS_NUM_LKF_CAT | | nvarchar | 3 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 57 | ADR_KIND | Address Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TB009 | BU_ADRKIND | Allow NULL? |
| 58 | /ISHFR/COMP_INS | IS-H FR: Complementary Insurance | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/COMP_INS | Allow NULL? |
| 59 | /ISHFR/ELSASS | IS-H FR: Insurance Provider ALSACE | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/ELSASS | Allow NULL? |
| 60 | /ISHFR/LIMPDVTY | IS-H FR: Limit for Payment Distribution by Contract Scheme | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/LIMPDVTY | Allow NULL? |
| 61 | /ISHFR/WODAYFR | IS-H FR: Without Per Diem | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/WODAYFR | Allow NULL? |
| 62 | /ISHFR/HIST | IS-H FR: Health Insurer Type | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | /ISHFR/ISH_HIST | Allow NULL? |
| 63 | /ISHFR/COUNC_GEN | IS-H FR: General Council | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/COUNCIL_GEN | Allow NULL? |
| 64 | BAG | | nvarchar | 5 | 0 | | (N'00000') | Yes | | | Allow NULL? |
