PTIASPSTDCATVW

(SQL View)
Index Back

Standard Search Criteria List


SELECT DISTINCT PTIASPRPTTAGNAME , PTIASPRPTTAGVALUE , 'N' FROM PS_PTIASPRPTTAGS WHERE PTIASPRPTTAGNAME = 'Standard' AND PTIASPRPTTAGVALUE != 'Required At Upgrade'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTTAGNAME Character(30) VARCHAR2(30) NOT NULL TAG Name
2 PTIASPRPTTAGVALUE Character(254) VARCHAR2(254) NOT NULL TAG Value
3 PTIASPSELECTSTDCAT Character(1) VARCHAR2(1) NOT NULL Standard Search Criteria flag

Default Value: N