COURSEPrompt Table: ESTABCD_TBL_MEX
Prompt Table: THEME_A_TBL_MEX
1=Classroom
2=On-line
3=Mixed
1=Update and improve skills
2=Information on new technology
3=To fill vacant or new position
4=Prevent Job Hazards
5=Productivity Increase
COURSE_TBL_MEX(SQL Table) |
Index Back |
|---|---|
Course Information MexicoCourse Information Mexico |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 2 | ESTAB_CD_MEX | Number(7,0) | INTEGER NOT NULL |
Establishment Code for STPS MEX
Prompt Table: ESTABCD_TBL_MEX |
| 3 | THEME_AREA_MEX | Character(4) | VARCHAR2(4) NOT NULL |
Theme Area of training courses Mexico
Prompt Table: THEME_A_TBL_MEX |
| 4 | TRAINING_TYPE_MEX | Character(1) | VARCHAR2(1) NOT NULL |
Training Type Mexico
1=Classroom 2=On-line 3=Mixed |
| 5 | TRAINING_OBJ_MEX | Character(1) | VARCHAR2(1) NOT NULL |
Training Objective of the course Mexico
1=Update and improve skills 2=Information on new technology 3=To fill vacant or new position 4=Prevent Job Hazards 5=Productivity Increase |