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 |