RESID_HOME_DTL

(SQL Table)
 Index Back

EE Assignment-Home Residences

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_HM_DTL_LNG

  • Parent record: RESIDENCE_HOME

    • # 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_HOME

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 HOME_RESID_BEFORE Character(1) VARCHAR2(1) NOT NULL Home Status Before Assignment
    C=Cohabitate
    O=Own
    R=Rent
    6 HOME_RESID_DURING Character(1) VARCHAR2(1) NOT NULL Home Status During Assignment
    B=Sublet
    N=Not Applicable
    R=Rented
    S=Sold
    V=Vacant
    7 PROPERTY_MGMT Character(1) VARCHAR2(1) NOT NULL Property Management

    Y/N Table Edit

    Default Value: N

    8 HOME_FURNITURE Character(1) VARCHAR2(1) NOT NULL Home Furniture
    M=Moved
    N=Not Applicable
    S=Sold
    T=Stored
    9 COMMENTS Long Character CLOB Comment