Differences

This shows you the differences between two versions of the page.

--- tables_fields:main_tables:name [2020/01/07 01:04] – ↷ Page moved from tables:main_tables:name to tables_fields:main_tables:name lou
+++ tables_fields:main_tables:name [2023/04/06 14:31] (current) – Gary Willetts
@@ Line 1: / Line 1: @@
 ====== Name ======
+[[..:|Back to list of main tables]]
-[[tables:main_tables:|Back to list of main tables]]
 <WRAP center round info 60%>
@@ Line 50: / Line 49: @@
 | group_ID        | ID of the department this name has been assigned to | Long | * |
 | hold            | If true, you can't issue or receive items to/from this name | Boolean |  |
+| is_deleted      | Only used for patients in mobile. Soft delete flag i.e. patients with this set to true are not displayed or included in search results | Boolean |  |
+| isDeceased      | Only used for patients in mobile. Set to true if the patient has died | Boolean |  |
 | last            | Patients only: patient's last name | Alpha | * |
 | latitude        | The degrees latitude of the name's location | Real  |  |
@@ Line 64: / Line 65: @@
 | next_of_kin_relative | Relation that is patient's next of kin e.g. 'Parent' | Alpha |  |
 | occupation_ID   | Patients only: ID of the patient's occupation | Longint | * |
+| om_created_datetime | The time a name was created. Used by Open mSupply in a sync system. | Time |  |
+| om_gender | Gender, used by Open mSupply in a sync system. mSupply only has male and female as choices, Open mSupply has a much wider selection of options | Text |  |
 | ordering_method | The type of customer stock history this customer uses: im=imprest, sh=stock history | Alpha |  |
-| overpayment     | Amount overpaid to a customer from a supplier | Real |  |
+| overpayment     | **Deprecated as of v4.11 and not used - calculated as needed** Amount overpaid to a customer from a supplier | Real |  |
 | PATIENT_PHOTO   | Patients only: patient's photo | Picture |  |
 | phone           | Name's phone number | Alpha   |  |
@@ Line 88: / Line 91: @@
 | supplier        | True if this name is a supplier | Boolean | * |
 | title           | Patients only: patient's title (Mr, Ms etc.) | Alpha |  |
-| **type** (v3.5 on) |“store” - a name associated with a mSupply virtual store\\  “invad” - a reserved name used for inventory adjustment transactions\\  “build” - a reserved name used for build transactions\\  “repack” - a reserved name used for repack transactions\\ “patient” - patients  \\ “facility” - a supplier or customer who is external to your mSupply virtual store system  (see booleans name.customer and name.supplier for differentiation) | Alpha | * |
+| **type** (v3.5 on) |“store” - a name associated with an mSupply virtual store\\  “invad” - a reserved name used for inventory adjustment transactions\\  “build” - a reserved name used for build transactions\\  “repack” - a reserved name used for repack transactions\\ “patient” - patients  \\ “facility” - a supplier or customer who is external to your mSupply virtual store system  (see booleans name.customer and name.supplier for differentiation) | Alpha | * |
 | url             | Web page of this name. Includes "http:%%/%%/" | Alpha |  |
 | web_id          | The user name used to log on to the web interface | Alpha | * |
 | ZIP             | Postal address postcode | Longint |  |
 ---- struct data ----
+pagestatus.status    :
 ----