HRS_GVT_CAT_LNG

(SQL View)
 Index Back

RS Veteran code language view

RS Veteran code language view

SELECT A.FIELDVALUE ,A.LANGUAGE_CD , A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'GVT_VET_RECR_CODE' AND %EffdtCheck(PSXLATITEMLANG , A, %CurrentDateIn)

  • Related Language Record for HRS_GVT_CAT_ITM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_VET_RECR_CODE Character(3) VARCHAR2(3) NOT NULL Recruitment Code
    1=CPS
    2=CP
    3=XP
    4=TP
    5=NV
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 HRS_VET_SHORTNM Character(10) VARCHAR2(10) NOT NULL Veteran's Code
    4 HRS_VET_LONGNM Character(30) VARCHAR2(30) NOT NULL Veteran's Code