PSTIMEZONE

(SQL View)
 Index Back

Time Zone Data


SELECT A.TIMEZONE , TIMEZONESTDLBL , TIMEZONEDSTLBL , UTCOFFSET , OBSERVEDST , DSTOFFSET , DSTSTART , DSTEND , TZDESCR , SYNCID , LASTUPDDTTM FROM PSTIMEZONEDEFN A JOIN ( SELECT TIMEZONE , MAX(PTEFFDTTM) PTEFFDTTM FROM PSTIMEZONEDEFN WHERE PTEFFDTTM < %CurrentDateTimeIn GROUP BY TIMEZONE) B ON A.TIMEZONE = B.TIMEZONE AND A.PTEFFDTTM = B.PTEFFDTTM

  • Related Language Record: PSTIMEZONELANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    2 TIMEZONESTDLBL Character(8) VARCHAR2(8) NOT NULL Time Zone Standard Label
    3 TIMEZONEDSTLBL Character(8) VARCHAR2(8) NOT NULL Time Zone Daylight Label
    4 UTCOFFSET Signed Number(4,0) DECIMAL(3) NOT NULL Universal Time Coord Offset
    5 OBSERVEDST Character(1) VARCHAR2(1) NOT NULL Observes Daylight Savings Time

    Y/N Table Edit

    Default Value: N

    6 DSTOFFSET Signed Number(4,0) DECIMAL(3) NOT NULL Daylight Savings Offset
    7 DSTSTART Character(12) VARCHAR2(12) NOT NULL Daylight Saving Time Start

    Prompt Table: PSDSTTIME
    Set Control Field: DSTID

    8 DSTEND Character(12) VARCHAR2(12) NOT NULL Daylight Savings Time End

    Prompt Table: PSDSTTIME
    Set Control Field: DSTID

    9 TZDESCR Character(50) VARCHAR2(50) NOT NULL Time Zone Description
    10 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.