IT_ACTN_LOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
2	DTTM_PROCESSED	DateTime(26)	TIMESTAMP	Datetime processed Default Value: %datetime
3	IT_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	ITAM Source for Financial Impact ME=Manage Exceptions NRA=Assets Not Reporting
4	RULE_ACTN_ALL	Character(3)	VARCHAR2(3) NOT NULL	Rule Option A1=Retire a Non-Financial Asset A2=Email Custodian A3=Email Custodian's Manager A4=Email Custodian and Manager A5=Email Primary User A6=Email Primary User's Manager A7=Email Primary User and Manager A8=Move to Inventory A9=Route Retirement to Finance M01=Update ARM M02=Add Asset M03=Retire Asset M05=Move to Inventory M10=Email Custodian M11=Email Manager M12=Email Primary User M13=Email Primary User Manager M14=Email Group Owner M20=Route to Role
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
7	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
8	EXECUTED_BY	Character(30)	VARCHAR2(30) NOT NULL	Executed By User
9	RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Rule ID
10	DETAIL	Character(30)	VARCHAR2(30) NOT NULL	Detail Value
11	ARM_VALUE	Character(60)	VARCHAR2(60) NOT NULL	ARM Value
12	ARM_VALUE2	Character(60)	VARCHAR2(60) NOT NULL	ARM Value 2
13	DISCO_VALUE	Character(60)	VARCHAR2(60) NOT NULL	Discovery Value
14	DISCO_VALUE2	Character(60)	VARCHAR2(60) NOT NULL	Discovery Value 2