ASGN_HOMHST_VW (SQL View)	Index Back
Vw-Assignment Home/Host ASGN_HOMHST_VW 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. This view is used as a prompt table (F4 key) for the home/host side of employee compensation for overseas employees. Since employee compensation records contain EFFDT, this view labels BEGIN_DT as EFFDT to facilitate use with the compensation records.

ASGN_HOMHST_VW

(SQL View)

Vw-Assignment Home/Host

ASGN_HOMHST_VW 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. This view is used as a prompt table (F4 key) for the home/host side of employee compensation for overseas employees. Since employee compensation records contain EFFDT, this view labels BEGIN_DT as EFFDT to facilitate use with the compensation records.

Select A.Emplid ,A.Begin_Dt ,A.Home_Host ,A.Home_Host_Empl_Rcd FROM PS_ASGN_HOME_HOST A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 HOME_HOST Character(1) VARCHAR2(1) NOT NULL Home or Host
0=Home
1=Host 1
2=Host 2

4 HOME_HOST_EMPL_RCD Character(3) VARCHAR2(3) NOT NULL Home/Host Empl Record

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	HOME_HOST	Character(1)	VARCHAR2(1) NOT NULL	Home or Host 0=Home 1=Host 1 2=Host 2
4	HOME_HOST_EMPL_RCD	Character(3)	VARCHAR2(3) NOT NULL	Home/Host Empl Record