TL_PNCH_LNG_VW

(SQL View)
Index Back

Related Lang View of Punch Typ

Punch Type View for Web Clock

SELECT %Substring(A.FIELDVALUE, 1, 2) , A.EFFDT , A.LANGUAGE_CD , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'PUNCH_TYPE' AND FIELDVALUE <> '0'

# 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 EFFDT Date(10) DATE NOT NULL Effective Date
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description