| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 3 |
PARENT_SERIAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Serial ID
|
| 4 |
MFG_ID_DISCO |
Character(200) |
VARCHAR2(200) NOT NULL |
Manufacturer ID
|
| 5 |
IT_RESOURCE |
Character(30) |
VARCHAR2(30) NOT NULL |
ITAM - Used for mapping the IT Devices.
Example: The values Mini-Tower and Desktop from 3rd Party will be mapped to PSFT value of Desktop.
|
| 6 |
MODEL_DISCO |
Character(200) |
VARCHAR2(200) NOT NULL |
Discovery Model from 3rd Party
|
| 7 |
PRIMARY_USER |
Character(64) |
VARCHAR2(64) NOT NULL |
Primary Logon User
|
| 8 |
USER_DOMAIN |
Character(64) |
VARCHAR2(64) NOT NULL |
Network User Domain
|
| 9 |
MACHINENAME_DISCO |
Character(64) |
VARCHAR2(64) NOT NULL |
Machine Name from 3rd Party
|
| 10 |
IP_ADDRESS_DISCO |
Character(39) |
VARCHAR2(39) NOT NULL |
IP Address from Third Party
|
| 11 |
DISCOVERY_DATE |
Date(10) |
DATE |
Last Inventory Date
|
| 12 |
IT_UD_CHAR1 |
Character(50) |
VARCHAR2(50) NOT NULL |
IT User Defined Char Field1
|
| 13 |
IT_UD_CHAR2 |
Character(50) |
VARCHAR2(50) NOT NULL |
IT User Defined Char Field2
|
| 14 |
IT_UD_DATE1 |
Date(10) |
DATE |
IT User Defined Date Field
|