TRN_INSTRCT_VW

(SQL View)
 Index Back

Training Instructors View

Use TRN_INSTRCT_TBL to record information about instructors of training courses for your company. Instructors can be internal (employees) or external (non-employees), although both types of instructor use their EmplID as their instructor ID. 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.

SELECT DISTINCT B.OPRID ,A.INSTRUCTOR_ID ,B.NAME ,A.INTERNAL_EXTERNAL ,A.VENDOR ,A.SCHOOL_CODE ,A.SCHOOL ,A.CURRENCY_CD ,A.AREA_OF_EXPERTISE ,A.COST_UNIT_CD ,A.PER_UNIT_COST ,B.NAME_AC FROM PS_TRN_INSTRCT_TBL A ,PS_PERALL_SEC_SRCH B WHERE B.EMPLID = A.INSTRUCTOR_ID AND %EffdtCheck(TRN_INSTRCT_TBL, A, %currentdatein) AND A.EFF_STATUS = 'A'

  • Related Language Record: TRN_INSTR_SRCHL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
    3 NAME Character(50) VARCHAR2(50) NOT NULL Name

    Default Value: PERSON_NAME.NAME

    4 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
    E=External
    I=Internal
    5 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID

    Prompt Table: TRN_VENDOR_TBL

    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

    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
    11 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost
    12 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name