IT_SFTWR_MAP (SQL View)	Index Back
ITAM-3rd Party Software Titles View of 3rd Party Software Titles that are mapped to defined ITAM Software Titles. Used in Discovery Run Control and in the Get_DiscoveryData AppClass.

IT_SFTWR_MAP

(SQL View)

ITAM-3rd Party Software Titles

View of 3rd Party Software Titles that are mapped to defined ITAM Software Titles. Used in Discovery Run Control and in the Get_DiscoveryData AppClass.

SELECT A.IT_MAP_CODE FROM PS_IT_MAP_CD A , PS_IT_SFTWR B WHERE A.IT_MAP_TYPE = '020' AND A.SETID = 'SFTWR' AND A.IT_MAP_ID = B.SFTWR_TITLE AND (B.TRACK_REQ = 'Y' OR B.PERMISSION_REQD = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IT_MAP_CODE Character(50) VARCHAR2(50) NOT NULL Third Party Values