STL_NETSCHED_SETIDSCHEDULELANGUAGE_CDSTL_SCHED_VW_LG(SQL View) |
Index Back |
|---|---|
View of schedules with setid |
| SELECT a.Setid , a.Schedule , r.language_cd , r.Descr FROM PS_SCHEDULE_TBL a , PS_SCHEDULE_LANG r WHERE a.setid = r.setid AND a.schedule = r.schedule |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STL_NETSCHED_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID for Settlement Instructions used on other objects that don't contain setid as part of their key. |
| 2 | SCHEDULE |
Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |