HRS_GVT_OCC_LNI

(SQL View)
Index Back

GVT: Occupational Series Table

Related Language record for GVT_OCCUPATION.

SELECT GVT_OCC_SERIES ,LANGUAGE_CD ,EFFDT ,GVT_DESCR40 ,GVT_DESCR70 FROM PS_GVT_OCCUP_LANG

  • Related Language Record for HRS_GVT_OCC_I
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 GVT_DESCR40 Character(40) VARCHAR2(40) NOT NULL Description Field
    5 GVT_DESCR70 Character(70) VARCHAR2(70) NOT NULL Description Field