| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | CHAR | (N' ') | No | TNC301G0 | N_EDIPROC | Allow NULL? |
| 4 | RELQNT | IS-H: Number of messages to be released | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | ISH_RELQNT | |
| 5 | RELAPPR | IS-H: Release mode for waiting msg for approved inbound msg | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_RELAPPR | Allow NULL? |
| 6 | RELPEND | IS-H: Release mode waiting msg for inbnd msg status pending | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_RELPEND | Allow NULL? |
| 7 | RELREJT | IS-H: Release Mode for Waiting Msg for Inb.Msg Tech.Rejected | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_RELREJT | Allow NULL? |
| 8 | RELREJF | IS-H: Release mode for waiting msg for inbnd msg 'final rej' | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_RELREJF | Allow NULL? |
| 9 | RELERRM | IS-H: Release Mode for Waiting Message due to Error Message | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_RELERRM | Allow NULL? |
| 10 | WKLERRS | IS-H: Error Messages in Inbound Worklist | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_WKLERRS | Allow NULL? |
| 11 | WKLERRC | IS-H: Error Messages at Case Level in Inbound Worklist | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_WKLERRC | Allow NULL? |
| 12 | WKLERRO | IS-H: Other Error Segments in Inbound Worklist | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_WKLERRO | Allow NULL? |
| 13 | UPLAPPR | IS-H: Upload Approved Data into Application | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_UPLAPPR | Allow NULL? |
| 14 | UPLPEND | IS-H: Upload "pending" data into application | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_UPLPEND | Allow NULL? |
| 15 | UPLREJT | IS-H: Upload "Technically Rejected" Data into Application | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_UPLREJT | Allow NULL? |
| 16 | UPLREJF | IS-H: Upload rejected data into application | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_UPLREJF | Allow NULL? |
| 17 | NCINPAT | IS-H: Exclude inpatient non-claim cases | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NCINPAT | Allow NULL? |
| 18 | NCOUTPAT | IS-H: Exclude Outpatient Non-Claim Cases | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NCOUTPAT | Allow NULL? |
| 19 | NCLONGST | IS-H: Exclude long-stay non-claim cases | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NCLONGST | Allow NULL? |
| 20 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 21 | UPTIM | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_UPTIM | Allow NULL? |
| 22 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 23 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 24 | ERTIM | IS-H: Time when Data Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_ERTIM | Allow NULL? |
| 25 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 26 | NCIN8H | IS-H: Exclude Inpatient Non-Claim Cases Under 8 Hours | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NCIN8H | Allow NULL? |
