SCH_PUNCH_LG_VW

(SQL View)
 Index Back

Schedule Punch Related Lang Vw

Schedule Punch view selects punch type translate values for non-base languages.

SELECT %Substring(FIELDVALUE, 1, 2) , LANGUAGE_CD , EFFDT , XLATLONGNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'PUNCH_TYPE'

  • Related Language Record for SCH_PUNCH4_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
    0=Elapsed
    1=In
    2=Out
    3=Meal
    4=Break
    5=Transfer
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name