RQRMNT_USE_TBVW

(SQL View)
Index Back

View to select 4 digit rq usea

View that selects only those requirement useages that have four characters.

SELECT RQRMNT_USE_VAL, EFFDT, SPECIAL_REPT_TYPE, DESCR FROM PS_RQRMNT_USE_TBL WHERE %SUBSTRING(RQRMNT_USE_VAL, 1, 1) <> ' ' and %SUBSTRING(RQRMNT_USE_VAL, 2, 1) <> ' ' and %SUBSTRING(RQRMNT_USE_VAL, 3, 1) <> ' ' and %SUBSTRING(RQRMNT_USE_VAL, 4, 1) <> ' '

  • Related Language Record: RQRMNTUSETVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RQRMNT_USE_VAL Character(4) VARCHAR2(4) NOT NULL Requirement Usage
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 SPECIAL_REPT_TYPE Character(4) VARCHAR2(4) NOT NULL Special Report
    NO=No Special Formatting
    SPC=Special Report Format
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description