IT_LOAD_SUM_VW(SQL View) |
Index Back |
|---|---|
ITAM: Summary View Load ErrorsITAM - Used by pagelet for Load Errors metric. Summary count of errors; grouped by Error Code. |
| SELECT IT_ERR_CODE , COUNT(*) FROM PS_IT_LOAD_ERR GROUP BY IT_ERR_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Number Of Errors |