IT_SW_ERR_AET(SQL Table) |
Index Back |
|---|---|
ITAM - Used for Software EditsTable used as a state record for IT Software editting of data received from 3rd party Discovery Supplier. Used in IT_LOAD_PROC AppEngine. |
| # | 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 | KNOWN_AS | Character(128) | VARCHAR2(128) NOT NULL | Software Known As |
| 4 | SFTWR_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Software Title |
| 5 | IT_MAP_ID | Character(50) | VARCHAR2(50) NOT NULL | PeopleSoft Map ID |
| 6 | 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 |
| 7 | COUNT_1 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |