tables_fields:main_tables:name

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
tables_fields:main_tables:name [2023/01/20 11:21] – Gary Willettstables_fields:main_tables:name [2023/04/06 14:31] (current) – Gary Willetts
Line 50: Line 50:
 | hold            | If true, you can't issue or receive items to/from this name | Boolean |  | | 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 |  | | 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 | * | | last            | Patients only: patient's last name | Alpha | * |
 | latitude        | The degrees latitude of the name's location | Real  |  | | 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 |  | | 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 | * | | 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 |  | | ordering_method | The type of customer stock history this customer uses: im=imprest, sh=stock history | Alpha |  |
 | overpayment     | **Deprecated as of v4.11 and not used - calculated as needed** 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 |  |
  • Last modified: 2023/01/20 11:21
  • by Gary Willetts