IT_ASSET_LOG(SQL Table) |
Index Back |
---|---|
Asset LogLogs information from ITAM actions performed against the asset. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
2 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
3 | DTTM_STAMP | DateTime(26) | TIMESTAMP NOT NULL | 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. |
4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
5 | COMMENTS | Long Character | CLOB | Comment |