index back

Time Zone Data

  • Related language record: PSTIMEZONEDFNLG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    TIMEZONECharacter(9)VARCHAR2(9) NOT NULLTime Zone
    PTEFFDTTMDateTime(26)TIMESTAMP NOT NULLEffective DateTime
    TIMEZONESTDLBLCharacter(8)VARCHAR2(8) NOT NULLTime Zone Standard Label
    TIMEZONEDSTLBLCharacter(8)VARCHAR2(8) NOT NULLTime Zone Daylight Label
    UTCOFFSETSigned Number(4,0)DECIMAL(3) NOT NULLUniversal Time Coord Offset
    OBSERVEDSTCharacter(1)VARCHAR2(1) NOT NULLObserves Daylight Savings Time

    Y/N Table Edit

    Default: N

    DSTOFFSETSigned Number(4,0)DECIMAL(3) NOT NULLDaylight Savings Offset
    DSTSTARTCharacter(12)VARCHAR2(12) NOT NULLDaylight Saving Time Start

    Prompt Table: PSDSTTIME
    Set Control Field: DSTID

    DSTENDCharacter(12)VARCHAR2(12) NOT NULLDaylight Savings Time End

    Prompt Table: PSDSTTIME
    Set Control Field: DSTID

    TZDESCRCharacter(50)VARCHAR2(50) NOT NULLTime Zone Description
    SYNCIDNumber(10,0)DECIMAL(10) NOT NULLThe 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.
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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, 8.54
    PTRef generated on 09-JUN-19