COURSEPrompt Table: COURSE_TBL
TARGET_LANGUAGEPrompt Table: LANGUAGE_VW
1=Low
2=Moderate
3=High
1=Low
2=Moderate
3=High
1=Low
2=Moderate
3=High
Y/N Table Edit
Default Value: Y
COURSE_LANGUAGE(SQL Table) |
Index Back |
|---|---|
Training Course Goal-LanguagesUse COURSE_LANGUAGE to specify Languages, read/write/speak proficiency that a particular training course is training students for. This record belongs to the Training Administration application. You can create multiple COURSE_LANGUAGE records for a course, each with a unique Language code. |
| # | 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 | TARGET_LANGUAGE |
Character(8) | VARCHAR2(8) NOT NULL |
Language
Prompt Table: LANGUAGE_VW |
| 3 | READ_PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL |
Reading Proficiency
1=Low 2=Moderate 3=High |
| 4 | SPEAK_PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL |
Speaking Proficiency
1=Low 2=Moderate 3=High |
| 5 | WRITE_PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL |
Writing Proficiency
1=Low 2=Moderate 3=High |
| 6 | GRANT_TO_EE | Character(1) | VARCHAR2(1) NOT NULL |
Assign to EE after course
Y/N Table Edit Default Value: Y |