BUDGET_PERIODBUSINESS_UNITCOURSELANGUAGE_CDTRN_CRSE_LNG_VW(SQL View) |
Index Back |
|---|---|
Training Course Rel Lang ViewRelated Language View For Course |
| SELECT DISTINCT D.BUDGET_PERIOD ,D.BUSINESS_UNIT ,C.COURSE ,C.LANGUAGE_CD ,C.DESCR FROM PS_TRAINING A , PS_BUDGET_PERIOD B , PS_COURSE_TBL_LANG C ,PS_BUDGET_BUS_UNIT D WHERE A.COURSE=C.COURSE AND A.COURSE_START_DT >= B.EFFDT AND A.COURSE_START_DT <= B.THRU_DATE AND B.BUDGET_PERIOD=D.BUDGET_PERIOD AND A.BUSINESS_UNIT=D.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUDGET_PERIOD |
Character(10) | VARCHAR2(10) NOT NULL | Budget Period |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |