COMB_IDDAY=Day
FRI=5-Friday
MON=1-Monday
SAT=6-Saturday
SUN=7-Sunday
THU=4-Thursday
TUE=2-Tuesday
WED=3-Wednesday
EO=Every Other
EVE=Every
MTH=Month
WEE=Week
TL_CAL_VAL_COMB(SQL Table) |
Index Back |
|---|---|
Used in Calendar processUsed in Calendar process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMB_ID |
Number(5,0) | INTEGER NOT NULL | COMBINATION ID |
| 2 | START_IDX | Character(4) | VARCHAR2(4) NOT NULL | Period starts on |
| 3 | START_UNIT | Character(3) | VARCHAR2(3) NOT NULL |
Indicates starting point of a repeating calendar period. Can be expressed as DAY=Day FRI=5-Friday MON=1-Monday SAT=6-Saturday SUN=7-Sunday THU=4-Thursday TUE=2-Tuesday WED=3-Wednesday |
| 4 | BREAK_IDX | Character(3) | VARCHAR2(3) NOT NULL |
Break Index for complex Period
EO=Every Other EVE=Every |
| 5 | BREAK_UNIT | Character(3) | VARCHAR2(3) NOT NULL |
Break Unit for Complex Period
MTH=Month WEE=Week |