IT_ACTN_ERR

(SQL Table)
Index Back

Asset Log

Logs information from ITAM actions performed against the asset.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACTN_ERR_SOURCE Character(3) VARCHAR2(3) NOT NULL Action Error Source
ME=Manage Exceptions
NRA=Non-Reporting Assets
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPERATOR_VW

3 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
4 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.
5 RULE_ID Character(20) VARCHAR2(20) NOT NULL Rule ID
6 RULE_ACTION_OPTN Character(3) VARCHAR2(3) NOT NULL Rule Option
01=Update ARM
02=Add Asset
03=Retire Asset
05=Move to Inventory
10=Email Custodian
11=Email Manager
12=Email Primary User
13=Email Primary User Manager
14=Email Group Owner
20=Route to Role
7 ACTN_ERR_CODE Character(3) VARCHAR2(3) NOT NULL Action Error Code
010=No Email Address
020=Business Unit in another SetID
030=Component Interface Failed
050=Worklist creation failed
060=No Employee ID
070=Financial Asset Retirement
090=Duplicate Serial Number
100=Route Non-Financial Asset
110=New Serial Number not provided
120=Device asset not in ARM
8 ERROR_DTL Character(100) VARCHAR2(100) NOT NULL Error Description