| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 IT_GRP_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee Group Id
|
| 2 |
SFTWR_TITLE |
Character(50) |
VARCHAR2(50) NOT NULL |
Software Title
|
| 3 |
IT_INSTALLED_QTY |
Number(10,0) |
DECIMAL(10) NOT NULL |
Installed
|
| 4 |
IT_AUTH_QTY |
Number(10,0) |
DECIMAL(10) NOT NULL |
Authorized
|
| 5 |
IT_ASSIGNED_QTY |
Number(10,0) |
DECIMAL(10) NOT NULL |
Devices Assigned to Group
|
| 6 |
IT_UNRESOLVED_QTY |
Number(10,0) |
DECIMAL(10) NOT NULL |
Quantity of Devices that are not assigned to a Software Device Group
|
| 7 |
LASTUPDDTTM |
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.
|