| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 4 |
WORK_ORDER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order ID
|
| 5 |
TIME_SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 6 |
PLOG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 7 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 8 |
URL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
|
| 9 |
SERVER_ID |
Number(4,0) |
SMALLINT NOT NULL |
File Server ID
|
| 10 |
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.
|
| 11 |
SCM_ATTACH_ID |
Character(64) |
VARCHAR2(64) NOT NULL |
The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
|
| 12 |
ATT_FTPSRV_LOGIN |
Character(24) |
VARCHAR2(24) NOT NULL |
Login name for attachment ftp servers
|
| 13 |
ATT_FTPSRV_PASSWD |
Character(254) |
VARCHAR2(254) NOT NULL |
Password for attachment ftp servers
|
| 14 |
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
|
| 15 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 16 |
SP_ATTACHMENT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Attachment ID
|
| 17 |
SPECIAL_INSTRUCT |
Long Character |
CLOB |
Special Instructions
|