TRN_FACIL_EQUIP

(SQL Table)
Index Back

Equip Avail at Train Facility

Use TRN_FACIL_EQUIP to specify which training equipment and materials are available at a particular training facility, and the cost of using the equipment. This functionality is part of the Training Administration application. You can create multiple TRN_FACIL_EQUIP records for a training facility, each with a unique equipment code.

  • Parent record: TRN_FACIL_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

    Prompt Table: TRN_FACIL_TBL

    2 EQUIP_CD Character(4) VARCHAR2(4) NOT NULL Equipment/Materials Code

    Prompt Table: TRN_EQUIP_TBL

    3 QUANTITY Number(3,0) SMALLINT NOT NULL Quantity

    Default Value: 1

    4 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost
    5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_OPT_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    6 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit

    Prompt Table: COST_UNIT_TBL