| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | EINRI | Institution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | BEWTY | Movement Category | char | 1 | 0 | | | | Allow NULL? |
| 4 | BWART | IS-H: Movement Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | TODKZ | IS-H: Indicator for Discharge Type "Deceased" | char | 1 | 0 | | | | Allow NULL? |
| 6 | NEUGB | IS-H: Indicator for Admission Type "Newborn" | char | 1 | 0 | | | | Allow NULL? |
| 7 | BEGLT | IS-H: Indicator for Admission Type "Companion" | char | 1 | 0 | | | | Allow NULL? |
| 8 | AUFKH | IS-H: Indicator for Admission Type 'From External Hospital' | char | 1 | 0 | | | | Allow NULL? |
| 9 | ENTKH | IS-H: Indicator for 'Discharge to External Hospital' | char | 1 | 0 | | | | Allow NULL? |
| 10 | VSTAT | IS-H: Indicator for Visit Type "Preadmission" | char | 1 | 0 | | | | Allow NULL? |
| 11 | NSTAT | IS-H: Indicator for Visit Type "Postdischarge" | char | 1 | 0 | | | | Allow NULL? |
| 12 | AMBOP | IS-H: Indicator for Visit Type "Outpatient Surgery" | char | 1 | 0 | | | | Allow NULL? |
| 13 | OPERA | IS-H: Indicator for Admission Type "Surgery" | char | 1 | 0 | | | | Allow NULL? |
| 14 | STASP | IS-H: Indicator for Admission Type "Statistics Block" | char | 1 | 0 | | | | Allow NULL? |
| 15 | KV_SP | IS-H: Indicator for Visit Type "PPA Block" | char | 1 | 0 | | | | Allow NULL? |
| 16 | BWGR1 | Movement Reason - 1st and 2nd Positions | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | BWGR2 | Movement Reason - 3rd and 4th Positions | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | TSTAT | IS-H: Indicator for Admission Type "Day Hospital" | char | 1 | 0 | | | | Allow NULL? |
| 19 | ENTBI | IS-H: Indicator for Admission Type "Delivery" | char | 1 | 0 | | | | Allow NULL? |
| 20 | AHWKH | IS-H CH: Admission from higher ranking hospital | char | 1 | 0 | | | | Allow NULL? |
| 21 | AWEHD | IS-H CH: Change main diagnoses (admission movement) | char | 1 | 0 | | | | Allow NULL? |
| 22 | EINPA | IS-H CH: Self-discharge | char | 1 | 0 | | | | Allow NULL? |
| 23 | EINDP | IS-H CH: Discharge upon third-party initiative | char | 1 | 0 | | | | Allow NULL? |
| 24 | EWEHD | IS-H CH: Change of main diagnosis (discharge movement) | char | 1 | 0 | | | | Allow NULL? |
| 25 | UNQCD | IS-H: Unique Code for Assigning External Codes | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | SHORT | IS-H: Indicator for Admission Type "Short Treatment" | char | 1 | 0 | | | | Allow NULL? |
| 27 | SEQKZ | IS-H: Technical Admission Due To Case Split | char | 1 | 0 | | | | Allow NULL? |
| 28 | VIS1 | IS-H: Initial Visit Indicator | char | 1 | 0 | | | | Allow NULL? |
| 29 | NOTKZ | IS-H: Emergency Case Indicator | char | 1 | 0 | | | | Allow NULL? |
| 30 | SPERRDT | IS-H: Block Date From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | BEGUT | | char | 1 | 0 | | | | Allow NULL? |
| 32 | SPEND | | char | 1 | 0 | | | | Allow NULL? |
| 33 | FREMD | | char | 1 | 0 | | | | Allow NULL? |
| 34 | DIALY | | char | 1 | 0 | | | | Allow NULL? |
| 35 | CHEMO | | char | 1 | 0 | | | | Allow NULL? |
| 36 | AREHA | | char | 1 | 0 | | | | Allow NULL? |
| 37 | UNGNENT | IS-H: Indicator for Invalid Visit Type after Discharge | char | 1 | 0 | | | | Allow NULL? |
| 38 | RBPROPOSE | IS-H: Clear Room and Bed Assignment | char | 1 | 0 | | | | Allow NULL? |
| 39 | STPAEXT | | char | 1 | 0 | | | | Allow NULL? |
| 40 | INVITRO | | char | 1 | 0 | | | | Allow NULL? |
| 41 | BEGLM | IS-H: Indicator for Companion Required for Medical Reasons | char | 1 | 0 | | | | Allow NULL? |
| 42 | EXTAUF | IS-H: External Order | char | 1 | 0 | | | | Allow NULL? |
| 43 | DAYHO | Indicator for Visit Type: Day Hospital | char | 1 | 0 | | | | Allow NULL? |
| 44 | REHA | Indicator for Admission Type: Rehabilitation | char | 1 | 0 | | | | Allow NULL? |
| 45 | LONGT | Indicator for Admission Type: Long-Stay Patient | char | 1 | 0 | | | | Allow NULL? |
| 46 | TREXH | | char | 1 | 0 | | | | Allow NULL? |
| 47 | /ISHFR/BTR48 | IS-H FR: Retransfer After 48 Hours | char | 1 | 0 | | | | Allow NULL? |
| 48 | /ISHFR/RETRO | IS-H FR: Pharmacy Sales | char | 1 | 0 | | | | Allow NULL? |
| 49 | /ISHFR/MEDSC | Medical Subsequent Case | char | 1 | 0 | | | | Allow NULL? |
| 50 | /ISHFR/AUFTRBEH | Cross-Institution Treatment | char | 1 | 0 | | | | Allow NULL? |
| 51 | /ISHFR/ACTREAT | Transfer to Inpatient Treatment | char | 1 | 0 | | | | Allow NULL? |
| 52 | ACASCLOP | | char | 1 | 0 | | | | Allow NULL? |
| 53 | ECASCLOP | | char | 1 | 0 | | | | Allow NULL? |
| 54 | BEGENDDT | Enter Default Start and End Dates for Case | char | 1 | 0 | | | | Allow NULL? |
