GPJP_MTH_COL_VW

(SQL View)
 Index Back

Prev Employment Last Month

Previous Employment Last Month

SELECT %Substring(A.FIELDVALUE,1,2) , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'GPJP_MTH_COL_HIR' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM WHERE FIELDNAME = A.FIELDNAME AND FIELDVALUE = A.FIELDVALUE) AND A.EFF_STATUS = 'A'

  • Related Language Record: GPJP_MTH_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPJP_MTH_COL_HIR Character(2) VARCHAR2(2) NOT NULL Previous Employment Last Month
    01=January
    02=February
    03=March
    04=April
    05=May
    06=June
    07=July
    08=August
    09=September
    10=October
    11=November
    12=December
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description