RQRMNT_USE_VW

(SQL View)
Index Back

View to select rqrmnt usages

View that selects all requirement usages other than 'ENR' and 'SHR'.

SELECT RQRMNT_USE_VAL, DESCR FROM PS_RQRMNT_USE_TBL WHERE RQRMNT_USE_VAL <> 'ENR' AND RQRMNT_USE_VAL <> 'SHR'

  • Related Language Record: RQRMNTUSEVWLANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RQRMNT_USE_VAL Character(4) VARCHAR2(4) NOT NULL Requirement Usage
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description