IT_ACTN_ERR(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 | 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 |