COURSEPrompt Table: CRSE_SESSN_SRCH
SESSION_NBRINSTRUCTOR_IDPrompt Table: TRN_INSTR_SRCH
TRN_T_TUT_TYPE_ESP1=Email
2=Video Conference
3=Forum
4=Other
LANGUAGE_CDTRN_INS_ESPLNG(SQL Table) |
Index Back |
|---|---|
Instructor for internet Lang RInstructors Tutorial Type by session of internet method. Language Record. |
| # | 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_TUT_TYPE_ESP |
Character(1) | VARCHAR2(1) NOT NULL |
Tutorial Type
1=Email 2=Video Conference 3=Forum 4=Other |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |