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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
RESETSYNCIDTYPECharacter(1)VARCHAR2(1) NOT NULLReset Sync ID For
A=Reset All Table
P=Reset By Project
R=Reset By Record
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
ONLYSETINVALIDIDNumber(1,0)SMALLINT NOT NULLReset All Sync IDs
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19