PTIAMDACTS_VW(SQL View) |
Index Back |
|---|
| SELECT A.PTIAAUJOBNAME , A.PTIAAUADHOCFLG ,B.DESCR254 , ( SELECT PTIAAUJOBSTATE FROM PS_PTIAMDJOBEXCEP C WHERE C.PTIAAUJOBNAME= A.PTIAAUJOBNAME AND C.PRCSINSTANCE = ( SELECT MAX(PRCSINSTANCE) FROM PS_PTIAMDJOBEXCEP D WHERE D.PTIAAUJOBNAME=C.PTIAAUJOBNAME)) , ( SELECT LASTUPDDTTM FROM PS_PTIAMDJOBEXCEP C WHERE C.PTIAAUJOBNAME= A.PTIAAUJOBNAME AND C.PRCSINSTANCE = ( SELECT MAX(PRCSINSTANCE) FROM PS_PTIAMDJOBEXCEP D WHERE D.PTIAAUJOBNAME=C.PTIAAUJOBNAME)) ,'' ,0 , ' ' FROM PS_PTIAMDACTDEF A , PS_PTIASPCHARCODES B WHERE B.PTIASPCHARVALUE = A.PTIAMDACTIVITY AND B.PTIASPLOOKUPCODE = 'ACTNAME' |
| # | 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 |