IT_SW2_ERR_AET(SQL Table) |
Index Back |
|---|---|
ITAM: Pre-Stage Software EditsTable used as a state record for IT Software Error Edits for data received from 3rd party Discovery Supplier in IT_DISCO_SW_PRE. Used in IT_LOAD_PRE AppEngine. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | TASK_ID |
Character(18) | VARCHAR2(18) NOT NULL | Task Identification |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BATCH_ID |
Character(18) | VARCHAR2(18) NOT NULL | Batch ID |
| 5 | SERIAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 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 |