TRN_INSTRCT_TBL

(SQL Table)
Index Back

Training Instructors

Use 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.

  • Related Language Record: TRN_INSTRCT_LNG
  • Parent Record Of TRN_INSTRCT_CRS
  • # 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