SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
SCHED_PATTERNPERIOD_START_DTN=No
Y=Yes
WM_SCHEDPRD_VW(SQL View) |
Index Back |
|---|---|
Maintenance Schedule Period |
| SELECT P.SETID , P.SCHED_PATTERN , P.PERIOD_START_DT , P.PERIOD_END_DT , 'N' , %CurrentDateIn FROM PS_WM_SCHED_PERIOD P , PS_WM_SCHED_PTRN R WHERE %Join(COMMON_KEYS, WM_SCHED_PERIOD P, WM_SCHED_PTRN R) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SCHED_PATTERN |
Character(5) | VARCHAR2(5) NOT NULL | Schedule Pattern |
| 3 | PERIOD_START_DT |
Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 4 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 5 | CURRENT_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Current Period
N=No Y=Yes |
| 6 | TODAY_DATE | Date(10) | DATE | Represents the creation date for a given time set utilized in position processing. |