RSEC_BUILDERRUN(SQL Table) |
Index Back |
|---|---|
Security builder run controlRun control record for the CRM application security list build process. |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | RSEC_PROFILE_ID | Character(30) | VARCHAR2(30) NOT NULL |
A unique identifier of security profile for application security.
Prompt Table: RSEC_DYNPROF_VW |
| 4 | RSEC_MEMBER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Security Membership ID for application security membership definition.
Prompt Table: RSEC_DYNMEMB_VW |
| 5 | RSEC_OBJECT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Security Object ID used for defining application security objects.
Prompt Table: RSEC_DYNOBJ_VW |
| 6 | 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 Default Value: 0004 |
| 7 | 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: 0002 |
| 8 | RSEC_PROCINST_TRIG | Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Default Value: 0 |
| 9 | RSEC_SYSTEM_MAINT | Character(1) | VARCHAR2(1) NOT NULL |
Application security, system maintained record is identified using this field.
Y/N Table Edit Default Value: N |
| 10 | RSEC_VIEW_ID | Character(30) | VARCHAR2(30) NOT NULL |
Unique identifier of a view list used in application security.
Prompt Table: RSEC_DYNVIEW_VW |