RES_HST_DTL_LNG

(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.

  • Related Language Record for RESID_HOST_DTL
  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 COMMENTS Long Character CLOB Comment