VEH_HST_DTL_LNG (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.

VEH_HST_DTL_LNG

(SQL Table)

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 for VEH_HOST_DTL

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 Nbr
Default Value: 1
Prompt Table: VEHICLE_HOST

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

6 COMMENTS Long Character CLOB Comment

#	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 Nbr Default Value: 1 Prompt Table: VEHICLE_HOST
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	COMMENTS	Long Character	CLOB	Comment