PSARCHAUDIT

index back

Archive Audit


PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PSARCH_EVENTCharacter(2)VARCHAR2(2) NOT NULLArchiving Event
PSARCH_EVENTDTTMDateTime(26)TIMESTAMPEvent Date/Time
PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see PSARCHTEMPLATE).
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
PSARCH_PROCESSCharacter(1)VARCHAR2(1) NOT NULLArchive Process
D=Archive Delete
H=Remove from History
I=Import Process
P=Run Reports
R=Archive Rollback
S=Archive Selection
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
PSARCH_BATCHNUMNumber(30,0)DECIMAL(30) NOT NULLArchive Batch Number
PSARCH_NUMOFROWSSigned Number(19,0)DECIMAL(18) NOT NULLNumber of Rows
PSARCH_SQLLong CharacterCLOBSQL Statement
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19