PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 14 Mar 2019 04:29 AM by  Stephany Duda
tblBAS update GENDER
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages

Pernille Iversen



New Member


Posts:11
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
    Pernille

    Max Bucht



    New Member


    Posts:11
    New Member


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

    Stephany Duda



    New Member


    Posts:5
    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.
    You are not authorized to post a reply.