VEH_HM_DTL_LANG (SQL Table)	Index Back
EE Assignment Vehic Data-Home VEH_HOME_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_HOME_DTL to record further details about each personal vehicle that remains at home while the employee is on assignment elsewhere. This record is subordinate to VEHICLE_HOME.

VEH_HM_DTL_LANG

(SQL Table)

EE Assignment Vehic Data-Home

VEH_HOME_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_HOME_DTL to record further details about each personal vehicle that remains at home while the employee is on assignment elsewhere. This record is subordinate to VEHICLE_HOME.

Related Language Record for VEH_HOME_DTL

Parent record: VEHICLE_HOME

# 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_HOME

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_HOME
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