SCHED_IDPrompt Table: BEN_JOBCODE_VW
BEN_SCHEDID_VW(SQL View) |
Index Back |
|---|---|
BEN Schedule ID View |
| SELECT DISTINCT B.SCHED_ID ,CASE WHEN (S.OE_DEFN_ID=' ' OR B.SCHED_ID=' ') THEN ( SELECT E.DESCR FROM PS_BAS_EVT_CLASS E WHERE E.EVENT_CLASS=B.EVENT_CLASS) ELSE S.DESCR END FROM PS_BAS_STMT_SUMM B,PS_BAS_SCHED S WHERE S.SCHED_ID=B.SCHED_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCHED_ID |
Character(6) | VARCHAR2(6) NOT NULL | Schedule ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Prompt Table: BEN_JOBCODE_VW |