IT_HW_ERR_AET(SQL Table) |
Index Back |
|---|---|
IT - Used for DuplicatesTable used as a state record for IT Hardware Serial IDs that are duplicates in the dataset. |
| # | 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 | 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. |
| 4 | IP_ADDRESS_DISCO | Character(39) | VARCHAR2(39) NOT NULL | IP Address from Third Party |
| 5 | IP_ADDR_FORMAT1 | Character(39) | VARCHAR2(39) NOT NULL | Used in formatting an IP Address entered online or received from a 3rd party integration source. Format is: xxx.xxx.xxx.xxx |
| 6 | KNOWN_AS | Character(128) | VARCHAR2(128) NOT NULL | Software Known As |
| 7 | IT_ERR_CODE | Character(3) | VARCHAR2(3) NOT NULL |
IT Load Error Code
010=Duplicate Serial ID Error 020=IU Duplicate Serial ID Error 030=Unmapped IP Address Error 040=Unmapped Manufacturer Error 050=Unmapped Primary User - EMPLID 060=Unmapped Asset Subtype 070=No GL BU mapped to HR BU 080=Unmapped IT Resource Error 090=Unmapped Software Title Error 100=Software data missing parent |
| 8 | COUNT_1 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |