PROCESS_INSTANCEY/N Table Edit
Y/N Table Edit
EAR=Earlier Than
EQT=Equal To
GTE=Greater Than or Equal To
GTN=Greater Than
LAT=Later Than
LIK=Like
LTE=Less Than or Equal To
LTN=Less Than
NEQ=Not Equal To
UPG_SRTYMTX_AET(SQL Table) |
Index Back |
|---|---|
FSI Security Matrix TableFSI Security Matrix Table used by Component RBF_SRTY_MATRIX |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RSEC_PROFILE_ID | Character(30) | VARCHAR2(30) NOT NULL | A unique identifier of security profile for application security. |
| 3 | RSEC_VIEW_ID | Character(30) | VARCHAR2(30) NOT NULL | Unique identifier of a view list used in application security. |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | RSEC_MEMBER_ID | Character(30) | VARCHAR2(30) NOT NULL | Security Membership ID for application security membership definition. |
| 6 | BUS_CONTACT_ID | Number(31,0) | DECIMAL(31) NOT NULL | Business Contact Id |
| 7 | ACCOUNT_REF_ID | Number(31,0) | DECIMAL(31) NOT NULL | Account Reference Id (BO ID) |
| 8 | APPROVAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
approval flag
Y/N Table Edit |
| 9 | CONDITIONAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Conditional Flag
Y/N Table Edit |
| 10 | SRTY_LIMIT_CD | Character(4) | VARCHAR2(4) NOT NULL | secutiy limit/denial code |
| 11 | RSEC_REL_SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The related synchronization id stores the syncid of the primary record of the security object. This field is used in creating the security list record. |
| 12 | SRTY_OPERATOR_CD | Character(4) | VARCHAR2(4) NOT NULL | security operator code |
| 13 | SRTY_ROLE_CD | Character(4) | VARCHAR2(4) NOT NULL | security role code |
| 14 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 15 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 16 | RSEC_FUNC_CD | Character(30) | VARCHAR2(30) NOT NULL | Security privilege code. Used by CRM self-service to define security privileges |
| 17 | RSEC_REVOKE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag used to determine if the functional option is revoked in application security. |
| 18 | EOEC_MP_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
the conditional operator of the sql condition (<,<=,>,>=,=,<>, LIKE,...)
EAR=Earlier Than EQT=Equal To GTE=Greater Than or Equal To GTN=Greater Than LAT=Later Than LIK=Like LTE=Less Than or Equal To LTN=Less Than NEQ=Not Equal To |
| 19 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 20 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 21 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |