HR_OBD_TMPL_VWL

(SQL View)
Index Back

RL view for HR_OBD_TMPL_VW


SELECT TMP.AGC_LIST_ID , LNG.LANGUAGE_CD , LNG.DESCR100 FROM PS_AGC_TMPL_TBL TMP , PS_AGC_TMPL_LNG LNG WHERE LNG.AGC_TEMPLATE_ID = TMP.AGC_TEMPLATE_ID AND LNG.EFFDT = TMP.EFFDT

  • Related Language Record for HR_OBD_TMPL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_LIST_ID Character(31) VARCHAR2(31) NOT NULL Activity Guide Composer List Id
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description