What represent userSign and userSign2 in OUSR?

[Former Member]

Please tell so I can better understand.

U_Name is User Name

User_Code is username

userSign?

userSign2?

Thanks.

[kothandaraman_nagarajan · Accepted solution]

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

[Former Member · Accepted solution]

So the number that is inside userSign and userSign2 is mapped to the UserID?

[edy_simon · Accepted solution]

Hi Jose,

Yes. it maps to USERID field in the same OUSR table.

Regards

Edy

[edy_simon]

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

[Former Member]

Thanks, but at db level those are id's... where can I see those id numbers descriptions? (or equivalent names)

[edy_simon]

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