TRN_INSTRCT_TBL(SQL Table) |
Index Back |
---|---|
Training InstructorsUse TRN_INSTRCT_TBL to record information about instructors of training courses for your company. Instructors can be internal (employees), in which case you would use their EmplID as their instructor ID, or external, in which case you would assign a unique identifier. You can use another record named TRN_INSTRCT_CRS to identify the courses an instructor is qualified to teach. This functionality is part of the Training Administration application. You can create only one TRN_INSTRCT_TBL record per instructor. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTRUCTOR_ID | Character(11) | VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table: PER_INSTR_SRCH |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | VENDOR | Character(6) | VARCHAR2(6) NOT NULL |
Vendor ID
Prompt Table: TRN_VENDOR_TBL |
4 | INTERNAL_EXTERNAL | Character(1) | VARCHAR2(1) NOT NULL |
Internal/External
E=External I=Internal |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
6 | SCHOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL |
School Code
Prompt Table: SCHOOL_TBL |
7 | SCHOOL | Character(30) | VARCHAR2(30) NOT NULL | School Name |
8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
9 | AREA_OF_EXPERTISE | Character(30) | VARCHAR2(30) NOT NULL | Area of Expertise |
10 | COST_UNIT_CD | Character(10) | VARCHAR2(10) NOT NULL |
Cost Unit
Default Value: TRAINING Prompt Table: ST_COST_UNIT_VW |
11 | PER_UNIT_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Per Unit Cost |
12 | DESCRLONG | Long Character | CLOB | Long Description |
13 | INSTRUCTOR_RFC_MEX | Character(16) | VARCHAR2(16) NOT NULL | Instructor RFC Mexico |
14 | TRN_FULL_TIME_INST | Character(1) | VARCHAR2(1) NOT NULL |
French Report 2483 : Full Time Instructor
Y/N Table Edit Default Value: N |
15 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN |