IT_IGN_ME_FILL

(SQL View)
Index Back

Ignored Exceptions

Ignored exceptions for the assets not reporting drill down

SELECT 'ME' , D.BUSINESS_UNIT_AM , D.ASSET_ID , H.SERIAL_ID , H.RULE_ID , %CurrentDateIn , %DateNull , ' ' , %CurrentDateTimeIn , D.MANUFACTURER_B , D.ARM_MODEL , D.EMPLID2 , A.FIELDNAME FROM PS_IT_RECON_HRDWR H , PS_IT_RECON_DSPLY D , PS_IT_RULE_ATTR A , PS_IT_RULE_DEFN R WHERE H.SERIAL_ID = D.SERIAL_ID AND R.RULE_ID = H.RULE_ID AND R.ATTRIBUTE_ID = A.ATTRIBUTE_ID AND R.ACTIVE_STATUS = 'A' AND A.ACTIVE_STATUS ='A' AND NOT EXISTS ( SELECT 'X' FROM PS_IT_IGN_ME M WHERE M.SERIAL_ID = H.SERIAL_ID AND H.RULE_ID = M.RULE_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IT_SOURCE Character(3) VARCHAR2(3) NOT NULL ITAM Source for Financial Impact
ME=Manage Exceptions
NRA=Assets Not Reporting
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
4 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
5 RULE_ID Character(20) VARCHAR2(20) NOT NULL Rule ID
6 BEGIN_DT Date(10) DATE Begin Date

Default Value: %date

7 EXPIRE_DT Date(10) DATE Expiration Dt
8 LAST_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL LastUpdatedUser
9 UPDATE_DTTM DateTime(26) TIMESTAMP 02/28/02 EGS (CN#PL900-1): Added
10 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
11 MODEL Character(30) VARCHAR2(30) NOT NULL Model
12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
13 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).