IT_ACTN_ER_SRCH (SQL View)	Index Back
Asset Log Logs information from ITAM actions performed against the asset.

IT_ACTN_ER_SRCH

(SQL View)

Asset Log

Logs information from ITAM actions performed against the asset.

SELECT DISTINCT E1.ACTN_ERR_SOURCE , E1.OPRID , ' ' FROM PS_IT_ACTN_ERR E1

# 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 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
Prompt Table: IT_ACTN_ERR

#	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	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 Prompt Table: IT_ACTN_ERR