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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19