COURSEPrompt Table: COURSE_TBL
SESSION_NBRPrompt Table: CRSE_SESSN_VW
Prompt Table: COMPANY_TBL
TRN_T_CMP_ESPVW(SQL View) |
Index Back |
|---|---|
FT Company Envolved VW ESPTripartite Foundation. This view is used to retrieve the envolved Companies in FT Course Session. |
| SELECT DISTINCT A.COURSE ,A.SESSION_NBR ,B.COMPANY FROM PS_TRAINING A , PS_DEPT_TBL B WHERE A.ATTENDANCE <> 'W' AND A.DEPTID = B.DEPTID AND A.BUSINESS_UNIT = B.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 2 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL |
Course Session Nbr
Prompt Table: CRSE_SESSN_VW |
| 3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |