PTIAMDACTHST_VW(SQL View) |
Index Back |
|---|
| SELECT A.PTIAAUJOBNAME , A.PTIAAUADHOCFLG , D.DESCR254 , B.PTIAAUJOBSTATE , B.LASTUPDDTTM , C.RQSTDTTM , B.PRCSINSTANCE , C.RUNSTATUS FROM PS_PTIAMDACTDEF A , PS_PTIAMDJOBEXCEP B LEFT OUTER JOIN PSPRCSRQST C ON B.PRCSINSTANCE = C.PRCSINSTANCE ,PS_PTIASPCHARCODES D WHERE A.PTIAAUJOBNAME = B.PTIAAUJOBNAME AND D.PTIASPLOOKUPCODE = 'ACTNAME' AND D.PTIASPCHARVALUE = A.PTIAMDACTIVITY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTIAAUJOBNAME |
Character(100) | VARCHAR2(100) NOT NULL | Job Name |
| 2 | PTIAAUJOBRUNMODE | Character(1) | VARCHAR2(1) NOT NULL |
Run Mode
A=Ad hoc S=Scheduled |
| 3 | PTIAAUJOBID | Character(100) | VARCHAR2(100) NOT NULL | Job ID |
| 4 | PTIAAUJOBSTATE | Character(20) | VARCHAR2(20) NOT NULL | Job State |
| 5 | PTIAAU_DTTM_STAMP | DateTime(26) | TIMESTAMP | Run Date Time |
| 6 | PTIAAUNEXTDTTM | DateTime(26) | TIMESTAMP | Next Runtime |
| 7 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 8 | 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 |