TIMEZONEPTEFFDTTMY/N Table Edit
Default Value: N
PSTIMEZONEDEFN(SQL Table) |
Index Back |
|---|---|
Time Zone Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TIMEZONE |
Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 2 | PTEFFDTTM |
DateTime(26) | TIMESTAMP NOT NULL | Effective DateTime |
| 3 | TIMEZONESTDLBL | Character(8) | VARCHAR2(8) NOT NULL | Time Zone Standard Label |
| 4 | TIMEZONEDSTLBL | Character(8) | VARCHAR2(8) NOT NULL | Time Zone Daylight Label |
| 5 | UTCOFFSET | Signed Number(4,0) | DECIMAL(3) NOT NULL | Universal Time Coord Offset |
| 6 | OBSERVEDST | Character(1) | VARCHAR2(1) NOT NULL |
Observes Daylight Savings Time
Y/N Table Edit Default Value: N |
| 7 | DSTOFFSET | Signed Number(4,0) | DECIMAL(3) NOT NULL | Daylight Savings Offset |
| 8 | DSTSTART | Character(12) | VARCHAR2(12) NOT NULL | Daylight Saving Time Start |
| 9 | DSTEND | Character(12) | VARCHAR2(12) NOT NULL | Daylight Savings Time End |
| 10 | TZDESCR | Character(50) | VARCHAR2(50) NOT NULL | Time Zone Description |
| 11 | 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. |
| 12 | 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. |