IT_RESOURCE_REQ (SQL View)	Index Back
View of IT Resources Request ITAM - view of IT Subtypes. IT Subtypes are mapped to a third party IT Resource values. It is the Resource field value we send in the XML Request.

IT_RESOURCE_REQ

(SQL View)

View of IT Resources Request

ITAM - view of IT Subtypes. IT Subtypes are mapped to a third party IT Resource values. It is the Resource field value we send in the XML Request.

SELECT B.IT_RESOURCE , A.DISCOVERY_DATE FROM PS_IT_SUBTYPE_LN B , PS_IT_SUBTYPE A WHERE B.ACTIVE_STATUS = 'A' AND B.ASSET_TYPE = A.ASSET_TYPE AND B.IT_SUBTYPE = A.IT_SUBTYPE AND A.RECON_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IT_RESOURCE Character(30) VARCHAR2(30) NOT NULL ITAM - Used for mapping the IT Devices. Example: The values Mini-Tower and Desktop from 3rd Party will be mapped to PSFT value of Desktop.

2 DISCOVERY_DATE Date(10) DATE Last Request Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IT_RESOURCE	Character(30)	VARCHAR2(30) NOT NULL	ITAM - Used for mapping the IT Devices. Example: The values Mini-Tower and Desktop from 3rd Party will be mapped to PSFT value of Desktop.
2	DISCOVERY_DATE	Date(10)	DATE	Last Request Date