VEH_HOST_DTL

(SQL Table)
 Index Back

EE Assignment Vehic Data-Host

VEH_HOST_DTL is one of a group of records used to record information about an employee's job assignments away from home base. This data is part of the International Assignment application. Use VEH_HOST_DTL to record further details about each personal vehicle used by the employee at the away-from-home jobsite. This record is subordinate to VEHICLE_HOST.

  • Related Language Record: VEH_HST_DTL_LNG

  • Parent record: VEHICLE_HOST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 BEGIN_DT Date(10) DATE NOT NULL Begin Date

    Prompt Table: ASSIGNMENT

    3 VEHICLE_NBR Number(2,0) SMALLINT NOT NULL Vehicle #

    Default Value: 1

    Prompt Table: VEHICLE_HOST

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 HOST_VEH_STATUS Character(1) VARCHAR2(1) NOT NULL Host Vehicle Status
    M=Company Owned
    N=None
    O=Own
    R=Rental
    6 VEHICLE_REASON Character(1) VARCHAR2(1) NOT NULL Reason for Vehicle
    J=Job Related
    N=Not Applicable
    T=Transfer Related
    7 AVAILABILITY_DT Date(10) DATE Date Available
    8 CASH_IN_LIEU Character(1) VARCHAR2(1) NOT NULL Cash In Lieu

    Y/N Table Edit

    Default Value: N

    9 COMMENTS Long Character CLOB Comment