IT_SERIAL_ID_VW (SQL View)	Index Back
IT Serial IDs ITAM - Serial IDs for all IT Hardware asset types. Used by the Manage Physical Use page as prompt table in Common Search configuration. Clone of IT_SERIAL_ID without the criteria of IN_PHY_USE=Y.

IT_SERIAL_ID_VW

(SQL View)

IT Serial IDs

ITAM - Serial IDs for all IT Hardware asset types. Used by the Manage Physical Use page as prompt table in Common Search configuration. Clone of IT_SERIAL_ID without the criteria of IN_PHY_USE=Y.

SELECT DISTINCT (SERIAL_ID) FROM PS_ASSET WHERE ASSET_TYPE = '010' AND ASSET_STATUS <> 'T'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID