PSPTANALYSISHDR |
index back |
|---|---|
Analysis Header |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 PROJECTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| GUID |
Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| PTTST_ANALYSISNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |
| DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| PTTST_COMPTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Compare Type
D=To Database F=From File |
| PTMAINTNUMROWSP | Number(30,0) | DECIMAL(30) NOT NULL |
Number of Rows processed.
Default: 0 |
| PTMAINTNUMROWST | Number(30,0) | DECIMAL(30) NOT NULL |
Totoal number of Rows
Default: 0 |
| PTMAINTPROGPERCENT | Number(3,0) | SMALLINT NOT NULL |
Totoal number of Rows
Default: 0 |
| RUNSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
Process Scheduler Process Run Status
1=Cancel 10=Not Successful 11=Posted 12=Unable to post 13=Resend 14=Posting 15=Content Generated 16=Pending 17=Success With Warning 18=Blocked 19=Restart 2=Delete 3=Error 4=Hold 5=Queued 6=Initiated 7=Processing 8=Cancelled 9=Success Default: 7 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |