PRCSSYSTEM(SQL Table) |
Index Back |
|---|---|
Process Scheduler System RecThis record is used by the Process Scheduler to store the last process instance as well as the system's default Operating System. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPSYS | Character(1) | VARCHAR2(1) NOT NULL |
Operating System
0=DOS 1=NT/Win95 Client 2=Windows 3=OS/2 4=UNIX 5=VMS 6=MPE/XL 7=OS390 8=NT 9=OS/400 Default Value: 1 Prompt Table:
PRCSSRVROPSYS
|
| 2 | RETENTIONDAYS | Number(3,0) | SMALLINT NOT NULL | Retention Days |
| 3 | PT_RETENTIONDAYS | Number(4,0) | SMALLINT NOT NULL | Retention Days |
| 4 | PRCSPURGENEXTDTTM | DateTime(26) | TIMESTAMP | Purge Next Date/Time |
| 5 | RECURDTTM | DateTime(26) | TIMESTAMP | Recur Date/Time |
| 6 | PRCSPURGERECURNAME | Character(30) | VARCHAR2(30) NOT NULL |
Purge Recurrence Name
Prompt Table: PRCSRECUR |
| 7 | PURGEPRCSFILES | Number(1,0) | SMALLINT NOT NULL | Purge Process Files |
| 8 | ARCH_PROCESSED | Character(1) | VARCHAR2(1) NOT NULL | Arch Processed |
| 9 | PRCSSYSLOADOPT | Character(2) | VARCHAR2(2) NOT NULL |
System Load Balancing Option
0=Assign To Primary O/S Only 1=Assign To Server In Any O/S Default Value: 1 |
| 10 | VERSION_UPDATED | Character(1) | VARCHAR2(1) NOT NULL | Version Number Updated |
| 11 | PTPRCSIBMSGSLOGLEV | Character(1) | VARCHAR2(1) NOT NULL |
Integration Log Level
E=Error I=Informational N=None Default Value: I |
| 12 | PTPRCSPMNUPDATE | Character(1) | VARCHAR2(1) NOT NULL |
Auto Update
Y/N Table Edit Default Value: Y |
| 13 | PTPRCSPOPUPNOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Field Added for Process Scheduler Pop-up Notification System Level Settings
Y/N Table Edit Default Value: N |