SFDEPTMNT2VWLNG

(SQL View)
Index Back

General Led Depts

SFDEPTMNT2VWLNG is the related language recordfor the record SF_DEPARTMNT2VW

SELECT setid , deptid , effdt ,language_cd , descr FROM PS_DEPARTMENT_LANG

  • Related Language Record for SF_DEPARTMNT2VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 EFFDT Date(10) DATE Effective Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description