PSARCHBATCH_SRC

index back

SELECT PSARCH_ID , PSARCH_BATCHNUM , OPRID , PSARCH_DTTM , PROCESS_INSTANCE FROM PSARCHBATCH

PeopleSoft Field Name Field Type Column Type Description
PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PSARCH_DTTM DateTime(26) TIMESTAMP Archive Date Time
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19