FMLY_HOST_DEP (SQL Table)	Index Back
EE Assignmt-Dependents at Host FMLY_HOST_DEP 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 this record to record dependent IDs and specify whether a dependent is living at the host location.

FMLY_HOST_DEP

(SQL Table)

EE Assignmt-Dependents at Host

FMLY_HOST_DEP 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 this record to record dependent IDs and specify whether a dependent is living at the host location.

Parent record: FMLY_HOST_EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: FMLY_HOST_EFFDT.EFFDT
Prompt Table: FMLY_HOST_EFFDT

3 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID
Prompt Table: DEPENDENT_VW

4 AT_HOST Character(1) VARCHAR2(1) NOT NULL At Host
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: FMLY_HOST_EFFDT.EFFDT Prompt Table: FMLY_HOST_EFFDT
3	DEPENDENT_ID	Character(2)	VARCHAR2(2) NOT NULL	Dependent ID Prompt Table: DEPENDENT_VW
4	AT_HOST	Character(1)	VARCHAR2(1) NOT NULL	At Host Y/N Table Edit Default Value: N