OPRIDRUN_CNTL_IDA=Reset All Table
P=Reset By Project
R=Reset By Record
SYNCIDGEN_SRCH(SQL View) |
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 | 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 | RESETSYNCIDTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Reset Sync ID For
A=Reset All Table P=Reset By Project R=Reset By Record |
| 4 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | ONLYSETINVALIDID | Number(1,0) | SMALLINT NOT NULL | Reset All Sync IDs |