SCH_PUNCH_VW

(SQL View)
 Index Back

Schedule Punch View

View returns punch types and translates from the translate table for the punch types applicable to each combination of schedule type (Punch, Elapsed, Flex) and OFF Shift indicator (Y, N).

SELECT %Substring(A.FIELDVALUE, 1, 2) , %Substring(C.FIELDVALUE, 1, 1) , %Substring(B.FIELDVALUE, 1, 2) , B.EFFDT , B.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEM B , PSXLATITEM C WHERE A.FIELDNAME='SCH_TYPE' AND B.FIELDNAME = 'PUNCH_TYPE' AND C.FIELDNAME = 'OFFDAY_IND' AND A.EFF_STATUS = 'A' AND C.EFF_STATUS = 'A' 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 B1, B, %CurrentDateIn) AND %EffdtCheck(PSXLATITEM C1, C, %CurrentDateIn)

  • Related Language Record: SCH_PCH_LG_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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name