SFTWR_TITLEIT_SFTWR_INVSMV(SQL View) |
Index Back |
|---|---|
Software Inventory Monitor |
| SELECT SFTWR_TITLE ,IT_INVENTORY_QTY ,IT_INSTALLED_QTY + IT_DEVICE_QTY ,IT_DEVICE_QTY ,IT_AUTH_QTY ,IT_UNAUTH_QTY ,DTTM_STAMP ,PROCESS_INSTANCE FROM PS_IT_SFTWR_INVSUM WHERE IT_INSTALLED_QTY <> 0 OR IT_INVENTORY_QTY <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFTWR_TITLE |
Character(50) | VARCHAR2(50) NOT NULL | Software Title |
| 2 | IT_INVENTORY_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Inventory |
| 3 | IT_INSTALLED_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Installed |
| 4 | IT_DEVICE_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Installed |
| 5 | IT_AUTH_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Authorized |
| 6 | IT_UNAUTH_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Unauthorized |
| 7 | 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. |
| 8 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |