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

RESIDENCE_HOME

(SQL Table)

EE Assgnmt-Home Residnce Cntrl

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

Related Language Record: RES_HOME_LANG

Parent record: ASSIGNMENT

# 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

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description