COMPANYPrompt Table: COMPANY_TBL
YEARCDCOURSEPrompt Table: COURSE_TBL
TRN_T_CRSE_SRCH(SQL View) |
Index Back |
|---|---|
Training Credit SimulatorTraining Credit Simulator |
| SELECT DISTINCT A.COMPANY , A.YEARCD , A.COURSE , B.DESCR FROM PS_TRN_T_COSTS_ESP A , PS_COURSE_TBL B WHERE A.COURSE = B.COURSE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | YEARCD |
Character(4) | VARCHAR2(4) NOT NULL | Calendar Year |
| 3 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |