OPRIDRUN_CNTL_IDY/N Table Edit
Default Value: Y
1=Specific Tree
2=All Trees
3=Security Type
5=Permission List
RUN_CNTL_SCRTY1(SQL Table) |
Index Back |
|---|---|
HR Run Control for SecurityContains fields that are used as input parameters for the Security Join Table updates to SJT_CLASS_ALL |
| # | 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 | UPDATE_ROW_LVL_SEC | Character(1) | VARCHAR2(1) NOT NULL |
Refresh All Rows?
Y/N Table Edit Default Value: Y |
| 4 | UPDATE_ROW_LVL_SET | Character(1) | VARCHAR2(1) NOT NULL |
Set of Security to Refresh
1=Specific Tree 2=All Trees 3=Security Type 5=Permission List |
| 5 | ASOFDATE | Date(10) | DATE | As of Date |