Go to previous topic
Go to next topic
Last Post 14 Mar 2019 04:29 AM by  Stephany Duda
tblBAS update GENDER
 2 Replies
Author Messages

New Member

New Member

12 Feb 2019 01:52 PM
    Dear all,
    Gender is collected in both tblBAS (field GENDER) and tblVIS (field GENDER_ID)
    We suggest updating tblBAS:
    1. Rename GENDER to GENDER_ID
    2. Add codes, so that it matches field GENDER_ID in tblVIS
    1 = Male
    2 = Female
    3 = Transgender male
    4 = Transgender female
    5 = Other
    (6 = non-binary)
    9 = Unknown

    Any comments or suggestions?

    Kind regards

    New Member

    New Member

    04 Mar 2019 03:04 PM
    Per my reply to the other GENDER_ID-related topic, this would be ok.

    New Member

    New Member

    14 Mar 2019 04:29 AM
    Bev and I recommend naming this variable GENDER_IDENT (identity) instead of GENDER_ID so that we preserve the variable naming conventions. Up until now, we've been using the "_ID" suffix for true table IDs like LAB_ID, ART_ID, etc. This is a different type of variable, so I think _IDENT might be more appropriate.