PROCESS_INSTANCE0001=Security Object
0002=Membership List
0003=View List
0004=All Objects
0005=Security Profile
0001=Dynamic List Refresh
0002=New and Updated List Members
0003=Data Integrity
Default Value: 0003
RSECBUILDER_AET(SQL Table) |
Index Back |
|---|---|
State Record Security BuildState record for the CRM application security list build process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 8 | RECNAME_KEY | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 9 | RSEC_ALLOW_REUSE | Character(1) | VARCHAR2(1) NOT NULL | Allow reuse of a security domain is determined using this flag. |
| 10 | RSEC_IMPLICIT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag in the view list definition to determine if the view list is based on an implicit criteria. |
| 11 | RSEC_PROFILE_ID | Character(30) | VARCHAR2(30) NOT NULL | A unique identifier of security profile for application security. |
| 12 | RSEC_LONG_SQLTEXT | Long Character | CLOB | Used for capturing the SQL text for dynamic list definitions for application security. |
| 13 | RSEC_MEMBER_ID | Character(30) | VARCHAR2(30) NOT NULL | Security Membership ID for application security membership definition. |
| 14 | RSEC_MEMBER_SQLTXT | Character(254) | VARCHAR2(254) NOT NULL | Work field used to display the dynamic criteria defined. |
| 15 | RSEC_METADATA_ID | Character(30) | VARCHAR2(30) NOT NULL | An ID field to define meta data in application security. |
| 16 | RSEC_OBJECT_ID | Character(30) | VARCHAR2(30) NOT NULL | Security Object ID used for defining application security objects. |
| 17 | RSEC_OBJECT_SQLTXT | Character(254) | VARCHAR2(254) NOT NULL | Dynamic criteria of membership and view list displayed. |
| 18 | RSEC_PROCESS_SCOPE | Character(4) | VARCHAR2(4) NOT NULL |
The process type of the AE list build process.
0001=Security Object 0002=Membership List 0003=View List 0004=All Objects 0005=Security Profile |
| 19 | RSEC_PROCESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
The process type of the AE list build process.
0001=Dynamic List Refresh 0002=New and Updated List Members 0003=Data Integrity Default Value: 0003 |
| 20 | RSEC_PROCINST_TRIG | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 21 | RSEC_RECNAME_LIST | Character(15) | VARCHAR2(15) NOT NULL | This field is used to store the view record associated with application security. |
| 22 | RSEC_RECNAME_VIEW | Character(15) | VARCHAR2(15) NOT NULL | This field is used to store the view record associated with application security. |
| 23 | 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. |
| 24 | RSEC_UID | Character(30) | VARCHAR2(30) NOT NULL | Unique identifier used in the application engine job. |
| 25 | RSEC_VIEW_ID | Character(30) | VARCHAR2(30) NOT NULL | Unique identifier of a view list used in application security. |
| 26 | RSEC_VIEW_ID_PARNT | Character(30) | VARCHAR2(30) NOT NULL | Field to store the value of the parent view ID that the new view ID got spawned off for 'Implicit' dynamic domains. |
| 27 | RSEC_VIEW_SQLTXT | Character(254) | VARCHAR2(254) NOT NULL | Text field to display the dynamic criteria of membership or view list. |
| 28 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |