DSTIDY/N Table Edit
Default Value: N
1=January
10=October
11=November
12=December
2=February
3=March
4=April
5=May
6=June
7=July
8=August
9=September
0=Sunday
1=Monday
2=Tuesday
3=Wednesday
4=Thursday
5=Friday
6=Saturday
Default Value: 0
PSDSTTIME(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DSTID |
Character(12) | VARCHAR2(12) NOT NULL | Daylight Saving Time ID |
| 2 | DSTABSOLUTE | Character(1) | VARCHAR2(1) NOT NULL |
Absolute Date
Y/N Table Edit Default Value: N |
| 3 | DSTMONTH | Character(2) | VARCHAR2(2) NOT NULL |
Month
1=January 10=October 11=November 12=December 2=February 3=March 4=April 5=May 6=June 7=July 8=August 9=September |
| 4 | DSTDAY | Number(2,0) | SMALLINT NOT NULL | Day |
| 5 | DSTDAYOFWEEK | Character(1) | VARCHAR2(1) NOT NULL |
Day of the Week
0=Sunday 1=Monday 2=Tuesday 3=Wednesday 4=Thursday 5=Friday 6=Saturday |
| 6 | DSTHOUR | Number(2,0) | SMALLINT NOT NULL | Hour |
| 7 | DSTMINUTE | Number(2,0) | SMALLINT NOT NULL |
Minute
Default Value: 0 |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |