PERSON_IDPrompt Table: RD_PERSON
BO_IDPrompt Table: BO
SRTY_PRIV_CDPrompt Table: RB_SRTY_PRIV
Prompt Table: RB_SRTY_OPER
RB_SRTY_DL_SRCH(SQL Table) |
Index Back |
|---|---|
Security User PrivilegesSecurity User Privileges |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RD_PERSON |
| 2 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL |
Business Object ID
Prompt Table: BO |
| 3 | SRTY_PRIV_CD |
Character(12) | VARCHAR2(12) NOT NULL |
Security privilege code. Used by CRM self-service to define security privileges
Prompt Table: RB_SRTY_PRIV |
| 4 | APPROVAL_FLG | Character(1) | VARCHAR2(1) NOT NULL | approval flag |
| 5 | SRTY_OPERATOR_CD | Character(4) | VARCHAR2(4) NOT NULL |
security operator code
Prompt Table: RB_SRTY_OPER |
| 6 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |