IT_LOAD_ERR_VW(SQL View) |
Index Back |
|---|---|
ITAM - Load ErrorsView of the Load Errors. Used by AM Common Search to populate the grid in IT_LOAD_ERRORS page. |
| SELECT DISTINCT (A.SERIAL_ID) , A.IT_ERR_CODE , A.MFG_ID_DISCO , A.IT_RESOURCE , A.KNOWN_AS , A.DESCR , B.MODEL_DISCO , B.PRIMARY_USER , B.USER_DOMAIN , B.MACHINENAME_DISCO , B.IP_ADDRESS_DISCO , B.DISCOVERY_DATE , %subrec(IT_UDFIELDS_SBR, B) , A.DTTM_STAMP , B.PROCESS_INSTANCE FROM PS_IT_LOAD_ERR A , PS_IT_DISCO_HW_ERR B WHERE A.SERIAL_ID = B.SERIAL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SERIAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 2 | 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 |
| 3 | MFG_ID_DISCO | Character(200) | VARCHAR2(200) NOT NULL | Manufacturer ID |
| 4 | 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. |
| 5 | KNOWN_AS | Character(128) | VARCHAR2(128) NOT NULL | Software Known As |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | MODEL_DISCO | Character(200) | VARCHAR2(200) NOT NULL | Discovery Model from 3rd Party |
| 8 | PRIMARY_USER | Character(64) | VARCHAR2(64) NOT NULL | Primary Logon User |
| 9 | USER_DOMAIN | Character(64) | VARCHAR2(64) NOT NULL | Network User Domain |
| 10 | MACHINENAME_DISCO | Character(64) | VARCHAR2(64) NOT NULL | Machine Name from 3rd Party |
| 11 | IP_ADDRESS_DISCO | Character(39) | VARCHAR2(39) NOT NULL | IP Address from Third Party |
| 12 | DISCOVERY_DATE | Date(10) | DATE | Last Inventory Date |
| 13 | IT_UD_CHAR1 | Character(50) | VARCHAR2(50) NOT NULL | IT User Defined Char Field1 |
| 14 | IT_UD_CHAR2 | Character(50) | VARCHAR2(50) NOT NULL | IT User Defined Char Field2 |
| 15 | IT_UD_DATE1 | Date(10) | DATE | IT User Defined Date Field |
| 16 | DTTM_STAMP | 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. |
| 17 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |