IT_EXCPT_ACTNHR (SQL View)	Index Back
Exception Actions A view of the actions associated with the selected assets from IT_EXCPT_SEL for transactions from automatic reconciliation that ended in error

IT_EXCPT_ACTNHR

(SQL View)

Exception Actions

A view of the actions associated with the selected assets from IT_EXCPT_SEL for transactions from automatic reconciliation that ended in error

SELECT DISTINCT TMP.OPRID , TMP.DTTM_STAMP , ACTN.RULE_ID , ACTN.RULE_ACTION_OPTN , ACTN.MESSAGE_SET_NBR , ACTN.MESSAGE_NBR , 'N' , D.FIN_IMPACT_FLG , ACTN.ACTN_APPLY , 'Y' FROM PS_IT_RULE_ACTN ACTN , PS_IT_RULE_DEFN D , PS_IT_RECON_HRDWR H , PS_IT_EXCPTSEL_TMP TMP , PS_IT_RECON_ERR ERR WHERE ERR.SERIAL_ID = TMP.SERIAL_ID AND ERR.RULE_ID = TMP.RULE_ID AND ERR.RULE_ACTION_OPTN = ACTN.RULE_ACTION_OPTN AND TMP.SERIAL_ID = H.SERIAL_ID AND TMP.RULE_ID = D.RULE_ID AND TMP.RULE_ID = H.RULE_ID AND TMP.RULE_ID = ACTN.RULE_ID AND ACTN.EXECUTE_SW = 'Y' AND H.COMP_STATUS = 'U'

# 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 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.

3 RULE_ID Character(20) VARCHAR2(20) NOT NULL Rule ID

4 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

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

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

7 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

8 FIN_IMPACT_FLG Character(1) VARCHAR2(1) NOT NULL Financial Impact Flag

9 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

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

#	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	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.
3	RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Rule ID
4	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
5	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
6	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
7	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
8	FIN_IMPACT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Financial Impact Flag
9	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
10	EXECUTE_SW	Character(1)	VARCHAR2(1) NOT NULL	Automatically execute switch