GP_RGST_STR_LVW

(SQL View)
Index Back

Payroll Reg Strings Lang View

This view is the related language view for the Payroll Results Register

SELECT A.PROGRAM_ID ,A.STRING_ID ,A.LANGUAGE_CD ,A.STRING_TEXT FROM PS_STRINGS_LNG_TBL A WHERE A.PROGRAM_ID = 'GP000001'

  • Related Language Record for GP_RGST_STR_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROGRAM_ID Character(8) VARCHAR2(8) NOT NULL Program ID
    2 STRING_ID Character(18) VARCHAR2(18) NOT NULL String ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 STRING_TEXT Character(100) VARCHAR2(100) NOT NULL String Text