RESID_HOST_DTL (SQL Table)	Index Back
EE Assignment-Host Residences Use RESIDENCE_HOST and RESID_HOST_DTL together to record information about an employee's residence(s) at a foreign job assignment location away from home. Create the RESIDENCE_HOST record first, then RESID_HOST_DTL. This functionality is part of the International Assignment module. You use a different set of records, RESIDENCE_HOME and RESID_HOME_DTL, to record similar data about the employee's residence(s) at home while they are on a foreign job assignment.

RESID_HOST_DTL

(SQL Table)

EE Assignment-Host Residences

Use RESIDENCE_HOST and RESID_HOST_DTL together to record information about an employee's residence(s) at a foreign job assignment location away from home. Create the RESIDENCE_HOST record first, then RESID_HOST_DTL. This functionality is part of the International Assignment module. You use a different set of records, RESIDENCE_HOME and RESID_HOME_DTL, to record similar data about the employee's residence(s) at home while they are on a foreign job assignment.

Related Language Record: RES_HST_DTL_LNG

Parent record: RESIDENCE_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 RESIDENCE_NBR Number(2,0) SMALLINT NOT NULL Residence Number
Default Value: 1
Prompt Table: RESIDENCE_HOST

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

5 HOST_RESID_STATUS Character(1) VARCHAR2(1) NOT NULL Host Residence Status
C=Cohabitate
H=Hotel
M=Company Owned
O=Own
R=Rental

6 HOST_FURNITURE Character(1) VARCHAR2(1) NOT NULL Host Furniture
N=Not Applicable
O=Own
R=Rental

7 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	RESIDENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Residence Number Default Value: 1 Prompt Table: RESIDENCE_HOST
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	HOST_RESID_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Host Residence Status C=Cohabitate H=Hotel M=Company Owned O=Own R=Rental
6	HOST_FURNITURE	Character(1)	VARCHAR2(1) NOT NULL	Host Furniture N=Not Applicable O=Own R=Rental
7	COMMENTS	Long Character	CLOB	Comment