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
tables_fields:main_tables:name [2023/01/20 12:39] – Gary Willettstables_fields:main_tables:name [2023/04/06 14:31] (current) – Gary Willetts
Line 65: 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 12:39
  • by Gary Willetts