TRN_FACIL_EQUIP(SQL Table) |
Index Back |
---|---|
Equip Avail at Train FacilityUse 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. |
# | 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 |