IT_SFTWR_SETID (SQL View)	Index Back
SETID for Software Titles View selects a hardcoded value for SETID to be used for Software Titles (which do not have or make use of the SETID field). Due to the concept in IT_MAP_CODE Component where Manufacturers require a SETID, but Software Titles do not, made design decision to define a fixed or hardcoded value of "SFTWR" for the required field, SETID, and use the value only for Software Titles.

IT_SFTWR_SETID

(SQL View)

SETID for Software Titles

View selects a hardcoded value for SETID to be used for Software Titles (which do not have or make use of the SETID field). Due to the concept in IT_MAP_CODE Component where Manufacturers require a SETID, but Software Titles do not, made design decision to define a fixed or hardcoded value of "SFTWR" for the required field, SETID, and use the value only for Software Titles.

SELECT 'SFTWR' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID