PROCESS_INSTANCED=Database server
F=FTP server
U=URL Server
PV_ECONN_ITMRUN(SQL Table) |
Index Back |
|---|---|
ePro Connect Item DetailePro Connect Item Detail for Workbench Process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | FIRST_INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | LAST_INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 6 | SERVER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
One of type ftp or DB, marks each registered attachment server.
D=Database server F=FTP server U=URL Server |
| 7 | ATT_SRV_NAME | Character(254) | VARCHAR2(254) NOT NULL | Name of attachment server, if it is an ftp server; name of the database record which holds attached files, if attachments are to be stored in the database |
| 8 | SERVER_PATH | Character(254) | VARCHAR2(254) NOT NULL | For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found. |
| 9 | LASTUPDDTTM | 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. |