SFTWR_TITLESERIAL_IDN=No
Y=Yes
Prompt Table: IT_GRP_PRMPT_VW
Default Value: N
IT_SWGRP_UNRSLV(SQL Table) |
Index Back |
|---|---|
SW Groups: Un-resolved IssuesFor Devices that do not belong to a Software Group but is a type of ITSubtype that uses the SerialID or Device-based model for Software Compliance. This table indicates whether the device has been added to a group to correct the "un-resolved" issue. Un-resolved: 1. Does not belong to a Group 2. Belongs to a Group but has not Declared Licenses yet. 3. Not in the ARM (so not in a Group either) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFTWR_TITLE |
Character(50) | VARCHAR2(50) NOT NULL | Software Title |
| 2 | SERIAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 3 | IN_ARM | Character(1) | VARCHAR2(1) NOT NULL |
In Asset Repository
N=No Y=Yes |
| 4 | MACHINENAME | Character(30) | VARCHAR2(30) NOT NULL | Machine Name |
| 5 | NBR_OF_CPU | Number(3,0) | SMALLINT NOT NULL | Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU. |
| 6 | IT_GRP_ID | Character(11) | VARCHAR2(11) NOT NULL |
Group Id
Prompt Table: IT_GRP_PRMPT_VW |
| 7 | RESOLVED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Resolved
Default Value: N |