IT_RULE_ATT0

(SQL View)
 Index Back

Reconcilable Rule Attributes


SELECT A.ATTRIBUTE_ID , A.ATTRIBUTE_DESCR FROM %Table(IT_RULE_ATTR) A WHERE A.ACTIVE_STATUS = 'A' AND (A.RECNAME <> 'IT_HRDWR_CACHE' OR (A.RECNAME = 'IT_HRDWR_CACHE' AND A.FIELDNAME = 'SERIAL_ID')) AND A.FIELDNAME <> 'ASSET_SUBTYPE' AND ((A.FIELDNAME = 'BUSINESS_UNIT' AND A.RECNAME = 'ASSET') OR EXISTS ( SELECT 'X' FROM PSRECFIELDDB B WHERE B.RECNAME = 'IT_HRDWR_CACHE' AND B.FIELDNAME = A.FIELDNAME ))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ATTRIBUTE_ID Character(20) VARCHAR2(20) NOT NULL Attribute ID
2 ATTRIBUTE_DESCR Character(20) VARCHAR2(20) NOT NULL Description