PSPTANALYSISHDR(SQL Table) |
Index Back |
|---|---|
Analysis Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROJECTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 2 | GUID |
Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 3 | PTTST_ANALYSISNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |
| 5 | 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. |
| 6 | PTTST_COMPTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Compare Type
D=To Database F=From File |
| 7 | PTMAINTNUMROWSP | Number(30,0) | DECIMAL(30) NOT NULL |
Number of Rows processed.
Default Value: 0 |
| 8 | PTMAINTNUMROWST | Number(30,0) | DECIMAL(30) NOT NULL |
Totoal number of Rows
Default Value: 0 |
| 9 | PTMAINTPROGPERCENT | Number(3,0) | SMALLINT NOT NULL |
Totoal number of Rows
Default Value: 0 |
| 10 | 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 Value: 7 |