RQRMNTUSETVWLNG

(SQL View)
 Index Back

Related lang veiw for 4 len rq

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

SELECT RQRMNT_USE_VAL , LANGUAGE_CD , EFFDT , DESCR FROM PS_RQRMNT_USE_LNG 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 for RQRMNT_USE_TBVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RQRMNT_USE_VAL Character(4) VARCHAR2(4) NOT NULL Requirement Usage
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description