PSPRJSTATERULES

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTPRJCURRENT Character(4) VARCHAR2(4) NOT NULL Current Project State
APCP=Approved for 'Copy from'
CEST=Collection engine stopped
CMFF='Compare from' failed
CMFS='Compare from' succeeded
CPFF='Copy from' failed
CPFS='Copy from' succeeded
CPPF=Copying from
CPPT=Copying to
CPTF='Copy to' failed
CPTS='Copy to' succeeded
CRTD=Created
EVAP=Evaluating Approval
NTAP=Not Approved
RCLE=Running Collection Engine
REVP=Reviewing Process
SCPF=Scheduled for 'Copy from'
SCPT=Scheduled for 'Copy to'
TRMD=Terminated
UPRD=Using Project Designer
VECP=Validation Error 'Copy from'
2 PTPRJNEXT Character(4) VARCHAR2(4) NOT NULL Next Project State
APCP=Approved for 'Copy from'
CEST=Collection engine stopped
CMFF='Compare from' failed
CMFS='Compare from' succeeded
CPFF='Copy from' failed
CPFS='Copy from' succeeded
CPPF=Copying from
CPPT=Copying to
CPTF='Copy to' failed
CPTS='Copy to' succeeded
CRTD=Created
EVAP=Evaluating Approval
NTAP=Not Approved
RCLE=Running Collection Engine
REVP=Reviewing Process
SCPF=Scheduled for 'Copy from'
SCPT=Scheduled for 'Copy to'
TRMD=Terminated
UPRD=Using Project Designer
VECP=Validation Error 'Copy from'
3 PTPRJCURDESCR Character(254) VARCHAR2(254) NOT NULL Current Project State
4 PTPRJNEXTDESCR Character(254) VARCHAR2(254) NOT NULL Next Project State