BUDGET_PERIODBUSINESS_UNITCOURSETRN_CRSE_VAL_VW(SQL View) |
Index Back |
|---|---|
Training Course ViewThis View is used to Retrive the Courses Based on the Budget Period. |
| SELECT DISTINCT D.BUDGET_PERIOD ,D.BUSINESS_UNIT ,C.COURSE ,C.DESCR FROM PS_TRAINING A , PS_BUDGET_PERIOD B , PS_COURSE_TBL 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |