| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TASK_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Task Identification
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
BATCH_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Batch ID
|
| 4 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 5 |
PARENT_SERIAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Serial ID
|
| 6 |
MFG_ID_DISCO |
Character(200) |
VARCHAR2(200) NOT NULL |
Manufacturer ID
|
| 7 |
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.
|
| 8 |
MODEL_DISCO |
Character(200) |
VARCHAR2(200) NOT NULL |
Discovery Model from 3rd Party
|
| 9 |
PRIMARY_USER |
Character(64) |
VARCHAR2(64) NOT NULL |
Primary Logon User
|
| 10 |
USER_DOMAIN |
Character(64) |
VARCHAR2(64) NOT NULL |
Network User Domain
|
| 11 |
MACHINENAME_DISCO |
Character(64) |
VARCHAR2(64) NOT NULL |
Machine Name from 3rd Party
|
| 12 |
IP_ADDRESS_DISCO |
Character(39) |
VARCHAR2(39) NOT NULL |
IP Address from Third Party
|
| 13 |
DISCOVERY_DATE |
Date(10) |
DATE |
Last Inventory Date
|
| 14 |
IT_UD_CHAR1 |
Character(50) |
VARCHAR2(50) NOT NULL |
IT User Defined Char Field1
|
| 15 |
IT_UD_CHAR2 |
Character(50) |
VARCHAR2(50) NOT NULL |
IT User Defined Char Field2
|
| 16 |
IT_UD_DATE1 |
Date(10) |
DATE |
IT User Defined Date Field
|
| 17 |
SOURCE_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Source Key ID
|