TRN_VENDOR_TBL

(SQL Table)
Index Back

Training Vendors

Use TRN_VENDOR_TBL to identify vendors that provide instructors, services, or equipment and materials for training courses tracked by your company. You can also use a subordinate record named TRN_VENDR_CNTCT to specify the contact persons for this vendor. This functionality is part of the Training Administration application. You can create only one TRN_VENDOR_TBL record per vendor ID.

  • Related Language Record: TRN_VENDOR_LANG
  • Parent Record Of TRN_VENDR_CNTCT TRN_VNDRCNT_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID
    2 TRN_VENDOR_TYPE Character(1) VARCHAR2(1) NOT NULL Vendor Type
    C=Consulting Firm
    E=Equipment Rental
    F=Facilities Rentals
    I=Outside Instructors
    M=Training Materials
    O=Other
    P=Training Provider
    S=Guest Speaker
    T=Financing Fund
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    8 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    9 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    10 CITY Character(30) VARCHAR2(30) NOT NULL City
    11 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    12 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    13 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    14 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    15 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    16 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    17 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    18 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    19 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    20 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    21 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    22 MINORITY_OWNED Character(1) VARCHAR2(1) NOT NULL Minority Owned

    Y/N Table Edit

    Default Value: N

    23 AP_VENDOR_ID Character(15) VARCHAR2(15) NOT NULL Accounts Payable Vendor ID
    24 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost
    25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: TD_COST_UNIT_VW

    27 CERTIF_DT_FRA Date(10) DATE Certification Date
    28 CERTIFIED_SW_FRA Character(1) VARCHAR2(1) NOT NULL Certified

    Y/N Table Edit

    Default Value: N

    29 CERTIF_NBR_FRA Character(15) VARCHAR2(15) NOT NULL Certification Number
    30 PRVD_COMP_DOM_FRA Character(1) VARCHAR2(1) NOT NULL Specialty
    A=Administrative
    B=Commercial
    C=Miscellaneous
    D=General
    E=Human Capital Management
    F=Computer science
    G=Languages
    H=Management
    I=Safety
    J=Systems
    K=Technique
    31 FINANCING_TYPE Character(3) VARCHAR2(3) NOT NULL Financing Type
    A=Financing Fund
    F=Financing Training Leave Fund
    32 PROVIDER_REF_FRA Character(6) VARCHAR2(6) NOT NULL French Report 2483 : Provider Referenced By

    Prompt Table: TRN_PROV_FIN_VW

    33 COMMENTS Long Character CLOB Comment