SCHEDULE_KEY1=Inactive
2=Active
Default Value: 1
1=On the Lease Start Date
2=Use Action Date
3=On a Specific Date
1=Days
2=Months
3=Years
1=Daily
2=Weekly
3=Monthly
4=Yearly
5=Never
RE_OPTSCHED(SQL View) |
Index Back |
|---|---|
Critical Date Schedule ViewThis view holds the Critical Date Schedule details on the subpage |
| SELECT SCHEDULE_KEY , SCHED_STATUS , START_OPT , START_ENUM , START_PRD , FREQ_OPTION , FREQ_ENUM , FREQ_MNTH_NBR , FREQ_DAY_NBR , FREQ_DOW , START_DATE , LAST_GEN_DT FROM PS_RE_OPT_SCHED |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCHEDULE_KEY |
Number(10,0) | DECIMAL(10) NOT NULL | Schedule key |
| 2 | SCHED_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Notifications Enabled - Active/Inactive
1=Inactive 2=Active Default Value: 1 |
| 3 | START_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Start Option for option schedule
1=On the Lease Start Date 2=Use Action Date 3=On a Specific Date |
| 4 | START_ENUM | Number(4,0) | SMALLINT NOT NULL | Notification Start Date |
| 5 | START_PRD | Character(1) | VARCHAR2(1) NOT NULL |
Start Period Options - Critical Dates
1=Days 2=Months 3=Years |
| 6 | FREQ_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Notification Frequency Option
1=Daily 2=Weekly 3=Monthly 4=Yearly 5=Never |
| 7 | FREQ_ENUM | Number(4,0) | SMALLINT NOT NULL | Frequency - Day |
| 8 | FREQ_MNTH_NBR | Number(2,0) | SMALLINT NOT NULL | Monthly Frequency |
| 9 | FREQ_DAY_NBR | Number(2,0) | SMALLINT NOT NULL | Frequency Day |
| 10 | FREQ_DOW | Number(6,0) | INTEGER NOT NULL | Frequency - Day of Week |
| 11 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 12 | LAST_GEN_DT | Date(10) | DATE | Last Notification Generation Date |