PROCESS_INSTANCECONSEC_NBR_MEXCOURSESESSION_NBRE=External
I=Internal
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
STPS_CO_TMP_MEX(SQL Table) |
Index Back |
|---|---|
STPS Report Course DataSTPS Report Course Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CONSEC_NBR_MEX |
Number(3,0) | SMALLINT NOT NULL | Consecutive Number Mexico |
| 3 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 4 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 5 | ESTAB_CD_MEX | Number(7,0) | INTEGER NOT NULL | Establishment Code for STPS MEX |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | THEME_AREA_MEX | Character(4) | VARCHAR2(4) NOT NULL | Theme Area of training courses Mexico |
| 8 | DURATION_CONVERTED | Number(6,1) | DECIMAL(5,1) NOT NULL | Converted Duration |
| 9 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 10 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 11 | INTERNAL_EXTERNAL | Character(1) | VARCHAR2(1) NOT NULL |
Internal/External
E=External I=Internal |
| 12 | INSTRUCTOR_RFC_MEX | Character(16) | VARCHAR2(16) NOT NULL | Instructor RFC Mexico |
| 13 | TRAINING_TYPE_MEX | Character(1) | VARCHAR2(1) NOT NULL |
Training Type Mexico
1=Classroom 2=On-line 3=Mixed |
| 14 | 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 |