PSTIMEZONEDEFN

index back

Time Zone Data


  • Related language record: PSTIMEZONEDFNLG
  • PeopleSoft Field Name Field Type Column Type Description
    TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    PTEFFDTTM DateTime(26) TIMESTAMP NOT NULL Effective DateTime
    TIMEZONESTDLBL Character(8) VARCHAR2(8) NOT NULL Time Zone Standard Label
    TIMEZONEDSTLBL Character(8) VARCHAR2(8) NOT NULL Time Zone Daylight Label
    UTCOFFSET Signed Number(4,0) DECIMAL(3) NOT NULL Universal Time Coord Offset
    OBSERVEDST Character(1) VARCHAR2(1) NOT NULL Observes Daylight Savings Time

    Y/N Table Edit

    Default: N

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

    Prompt Table: PSDSTTIME
    Set Control Field: DSTID

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

    Prompt Table: PSDSTTIME
    Set Control Field: DSTID

    TZDESCR Character(50) VARCHAR2(50) NOT NULL Time Zone Description
    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.
    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.
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19