COURSEPrompt Table: CRSE_SESSN_SRCH
SESSION_NBRINSTRUCTOR_IDPrompt Table: TRN_INSTR_SRCH
1=Trainer
2=Team Builder
2=Team Builder
3=Trainer/Team Builder
3=Both
TRN_T_INS_I_ESP(SQL Table) |
Index Back |
|---|---|
Instructor for internet methodInstructors by session of internet method. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: CRSE_SESSN_SRCH |
| 2 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 3 | INSTRUCTOR_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table: TRN_INSTR_SRCH |
| 4 | TRN_T_HOURS_ESP | Number(7,2) | DECIMAL(6,2) NOT NULL | Total Hours |
| 5 | TRN_T_PROFILE_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Instructor Profile
1=Trainer 2=Team Builder 2=Team Builder 3=Trainer/Team Builder 3=Both |