P6_TAGNBR_VW

(SQL View)
 Index Back

P6 Tag Number View

Grab range for Tag Number From and To

SELECT DISTINCT BUSINESS_UNIT , TAG_NUMBER FROM %Table(ASSET) WHERE TAG_NUMBER <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
2 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number