HR_TBH_RECDFVWL

(SQL View)
Index Back

Template Record View

This is the related-language record for the Template Record View, which is the search view for the Template Record/Field Setup component. This view will exlcude the Instance Number and join the Template Record Setup Table to the PeopleTools Record Definition table so as to include the record name in field prompts.

SELECT A.RECNAME , B.LANGUAGE_CD , B.RECDESCR FROM PS_HR_TBH_RECDEFN A , PSRECDEFNLANG B WHERE A.INSTANCE = 1 AND B.RECNAME = A.RECNAME

  • Related Language Record for HR_TBH_RECDEFVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description