TRN_EQUIP_TBL(SQL Table) |
Index Back |
|---|---|
Training EquipmentUse TRN_EQUIP_TBL to assign codes to various pieces of equipment and materials used in training courses. You also assign an equipment type to each piece of equipment. Equipment and materials can include books, handouts, whiteboards, projectors, computers, and monitors. This functionality is part of the Training Administration application. You can create only one TRN_EQUIP_TBL record for a particular equipment code. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EQUIP_CD |
Character(4) | VARCHAR2(4) NOT NULL | Equipment/Materials Code |
| 2 | EQUIP_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Equipment Type
AV=Audio/Visual BO=Books DP=Procedure Documentation EQ=Equipment FP=Building Floor Plans HB=Network Hub HO=Handout IT=Instructor Text LD=LCD Panel MI=Miscellaneous NT=Network Connection OP=Overhead Projector PC=Personal Computers ST=Student Text SU=Supplies WB=White Board |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | AUTHOR | Character(30) | VARCHAR2(30) NOT NULL | Author |
| 6 | YR_PUBLISHED | Number(4,0) | SMALLINT NOT NULL | Year Published |
| 7 | ISBN | Character(13) | VARCHAR2(13) NOT NULL | ISBN Number |