RX_GUEST_TMPLT(SQL Table) |
Index Back |
|---|---|
Guest Template RecordThis record contains all fields required to create a self-service user. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 2 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
Prompt Table: RX_CONSUMER_VW |
| 3 | PRCSPRFLCLS | Character(30) | VARCHAR2(30) NOT NULL |
A class that determines a user's process profile
Prompt Table: PSCLASSDEFN |
| 4 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL |
Operator Class
Prompt Table: PSCLASSDEFN |
| 5 | OPERPSWD | Character(32) | VARCHAR2(32) NOT NULL | An user's password |
| 6 | TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Template ID
Prompt Table: RX_CUST_REG_TBL |
| 7 | PSWDAGEWRK | Character(1) | VARCHAR2(1) NOT NULL |
Password Age
N=Never Expires Y=Expires In Default Value: N |
| 8 | PSWDEXPIRESDAYS | Number(3,0) | SMALLINT NOT NULL | Days before password expires |
| 9 | RX_PRIVACY_KEY | Character(10) | VARCHAR2(10) NOT NULL |
Terms and Conditions field for Setup
Prompt Table:
RX_REGTXT_SETUP
|
| 10 | TRANSFER | Character(1) | VARCHAR2(1) NOT NULL |
Password Age used in order capture for catalog transfer
N=Catalog Y=Customer Care Default Value: N |