PSPRJSTATERULES(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | 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 | 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 |