Skip to Content
avatar image
Former Member

What represent userSign and userSign2 in OUSR?

Please tell so I can better understand.

U_Name is User Name

User_Code is username

userSign?

userSign2?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 29, 2014 at 03:24 AM

    Hi,

    UserSign--> Created user ID

    UserSign2-->Updated user ID

    Run below query to get descriptions:

    SELECT T0.[U_NAME],t0.user_code, t0.userID, T0.[userSign], T0.[userSign2] FROM OUSR T0

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2014 at 02:21 AM

    Hi Jose,

    Below quoted from the Ref DB help files.

    UserSign is the user who create the current user record

    UserSign2 is the user who update the current user record.

    Regards
    Edy


    OUSR.jpg (44.3 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jose,

      Equivalent names in where ?

      The fields are both internal fields.

      They are not user accessible fields, as such, i believe the description described in the help file is enough.

      Regards

      Edy