SCH_PCH_LG_VW

(SQL View)

SELECT %Substring(A.FIELDVALUE, 1, 2) , %Substring(C.FIELDVALUE, 1, 1) , %Substring(B.FIELDVALUE, 1, 2) , B.EFFDT , B.LANGUAGE_CD , B.XLATLONGNAME FROM PSXLATITEMLANG A , PSXLATITEMLANG B , PSXLATITEMLANG C WHERE A.FIELDNAME='SCH_TYPE' AND B.FIELDNAME = 'PUNCH_TYPE' AND C.FIELDNAME = 'OFFDAY_IND' AND ((A.FIELDVALUE = 'E' AND B.FIELDVALUE = '0') OR (A.FIELDVALUE = 'P' AND B.FIELDVALUE <> '0' AND (C.FIELDVALUE = 'N' OR B.FIELDVALUE IN ('1','2')) OR (A.FIELDVALUE = 'F' AND B.FIELDVALUE IN ('1','2')))) AND %EffdtCheck(PSXLATITEM A1, A, %CurrentDateIn) AND %EffdtCheck(PSXLATITEM C1, C, %CurrentDateIn)

Related Language Record for SCH_PUNCH_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCH_TYPE Character(2) VARCHAR2(2) NOT NULL Shift Type
E=Elapsed
F=Flex
P=Punch

2 OFFDAY_IND Character(1) VARCHAR2(1) NOT NULL Off Day Indicator
N=Work Shift
Y=Off Shift

3 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Shift Type E=Elapsed F=Flex P=Punch
2	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift
3	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name