VEH_HOME_DTL (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_HOME_DTL

(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: VEH_HM_DTL_LANG

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 #
Default Value: 1
Prompt Table: VEHICLE_HOME

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

5 HOME_VEH_STATUS Character(1) VARCHAR2(1) NOT NULL Home Vehicle Status
M=Moved
N=Not Applicable
S=Sold
T=Stored

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 # Default Value: 1 Prompt Table: VEHICLE_HOME
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	HOME_VEH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Home Vehicle Status M=Moved N=Not Applicable S=Sold T=Stored
6	COMMENTS	Long Character	CLOB	Comment