IT_EXCPT_ACTN (SQL Table)	Index Back
Exception Actions A view of the actions associated with the selected assets from IT_EXCPT_SEL

IT_EXCPT_ACTN

(SQL Table)

Exception Actions

A view of the actions associated with the selected assets from IT_EXCPT_SEL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 DTTM_STAMP DateTime(26) TIMESTAMP 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 RULE_ID Character(20) VARCHAR2(20) NOT NULL Rule ID

5 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

6 ACTN_APPLY Character(1) VARCHAR2(1) NOT NULL IT Business Rule Apply Action To 'Financial', 'Non-Financial' or 'Both' types of Asset.
A=N/A
B=Both
F=Financial
N=Non-Fin

7 ACTN_DESCR Character(30) VARCHAR2(30) NOT NULL Rule Action Description

8 EXECUTE_SW Character(1) VARCHAR2(1) NOT NULL Automatically execute switch

9 RULE_DESCR Character(30) VARCHAR2(30) NOT NULL Rule Description

10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

12 SFTWR_ERR_FLAG Character(1) VARCHAR2(1) NOT NULL Software Error Flag
N=No Errors/Exceptions
O=Over The Limit
P=Processed / In Process
R=Resolved
U=Unauthorized Install
W=Auto Processed Unauthorized
X=Auto Processed Over Limit
Y=Processed Over the Limit
Z=Processed Unauthorized Install

13 SCOPE_ACTN Character(1) VARCHAR2(1) NOT NULL Scope Action
A=All unreconciled ARM Assets
C=Assets from Search Criteria
N=No Action
S=Selected Assets
Default Value: N

14 NAME Character(50) VARCHAR2(50) NOT NULL Name

15 FROM_CLAUSE Character(254) VARCHAR2(254) NOT NULL From Clause

16 WHERE_CLAUSE_LONG2 Long Character(8192) CLOB Where Clause

17 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	DTTM_STAMP	DateTime(26)	TIMESTAMP	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	RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Rule ID
5	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
6	ACTN_APPLY	Character(1)	VARCHAR2(1) NOT NULL	IT Business Rule Apply Action To 'Financial', 'Non-Financial' or 'Both' types of Asset. A=N/A B=Both F=Financial N=Non-Fin
7	ACTN_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Rule Action Description
8	EXECUTE_SW	Character(1)	VARCHAR2(1) NOT NULL	Automatically execute switch
9	RULE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Rule Description
10	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
11	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
12	SFTWR_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Software Error Flag N=No Errors/Exceptions O=Over The Limit P=Processed / In Process R=Resolved U=Unauthorized Install W=Auto Processed Unauthorized X=Auto Processed Over Limit Y=Processed Over the Limit Z=Processed Unauthorized Install
13	SCOPE_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Scope Action A=All unreconciled ARM Assets C=Assets from Search Criteria N=No Action S=Selected Assets Default Value: N
14	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
15	FROM_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	From Clause
16	WHERE_CLAUSE_LONG2	Long Character(8192)	CLOB	Where Clause
17	COMMENTS_254	Character(254)	VARCHAR2(254) NOT NULL	EDI Comments