IT_EXCPT_ACTN_S(SQL View) |
Index Back |
|---|---|
Exception ActionsA view of the actions associated with the selected assets from IT_EXCPT_SEL |
| SELECT DISTINCT TMP.OPRID , TMP.DTTM_STAMP , ACTN.RULE_ID , ACTN.RULE_ACTION_OPTN , ACTN.MESSAGE_SET_NBR , ACTN.MESSAGE_NBR , 'Y' , ACTN.ACTN_APPLY ,'N' FROM PS_IT_RULE_ACTN ACTN , PS_IT_RECON_SFTWR S , PS_IT_EXCPTSEL_TMP TMP WHERE TMP.SERIAL_ID = S.SERIAL_ID AND TMP.RULE_ID = S.RULE_ID AND TMP.RULE_ID = ACTN.RULE_ID AND ACTN.EXECUTE_SW = 'N' AND (S.SFTWR_ERR_FLAG = 'O' OR S.SFTWR_ERR_FLAG = 'U' OR S.SFTWR_ERR_FLAG = 'X' OR S.SFTWR_ERR_FLAG = 'W') |
| # | 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 | 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 |
| 9 | EXECUTE_SW | Character(1) | VARCHAR2(1) NOT NULL | Automatically execute switch |