OPRIDRUN_CNTL_IDA=Reset All Table
P=Reset By Project
R=Reset By Record
SYNCIDGEN_SRCH |
index back |
|---|
| SELECT A.OPRID , A.RUN_CNTL_ID , B.RESETSYNCIDTYPE , B.PROJECTNAME , B.RECNAME , B.ONLYSETINVALIDID FROM PS_PRCSRUNCNTL A , PS_SYNCIDGEN_CNTL B WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| RESETSYNCIDTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Reset Sync ID For
A=Reset All Table P=Reset By Project R=Reset By Record |
| PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| ONLYSETINVALIDID | Number(1,0) | SMALLINT NOT NULL | Reset All Sync IDs |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |