SUP_OB_USR_REG

(SQL Table)
Index Back

User Registration

2022/12/26 KAJ 34912027 8.60 Crypto Uptake

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 SUP_USR_APR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
B=Pushback
P=Pending Approval
R=Rejected
4 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
6 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

8 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

Prompt Table: RT_TYPE_TBL

9 SUP_TMPL_USRID Character(30) VARCHAR2(30) NOT NULL Supplier Template Default User Id
10 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime
11 OPERPSWD Character(32) VARCHAR2(32) NOT NULL An user's password
12 SUP_OB_OPERPSWD Character(254) VARCHAR2(254) NOT NULL An user's password 2022/12/26 KAJ 34912027 8.60 Crypto Uptake