PRCSJOBITEMCHG

index back

PeopleSoft Field Name Field Type Column Type Description
PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name
SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
PRCSJOBCHNGTYPE Character(1) VARCHAR2(1) NOT NULL Job Change Type
1=Item Added
2=Item Changed
3=Item Deleted
PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
OLDPRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
OLDPRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
OLDPRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19