EMPLIDPrompt Table: PERSON
BEGIN_DTPrompt Table: ASSIGNMENT
HOME_HOST0=Home
1=Host 1
2=Host 2
Prompt Table: %RECNAME_EDIT
ASGN_HOME_HOST(SQL Table) |
Index Back |
|---|---|
EE Assignment-Home/Host DataASGN_HOME_HOST is one of a group of records used to record information about an employee's job assignments away from home base. Use ASGN_HOME_HOST to set up a 'home' parent record and a 'host' parent record for an employee's international assignment data. Subordinate detail records contain the details pertaining to the assignment. This data is part of the International Assignment application. You can create multiple ASGN_HOME_HOST records for an employee. |
| # | 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 | HOME_HOST |
Character(1) | VARCHAR2(1) NOT NULL |
Home or Host
0=Home 1=Host 1 2=Host 2 |
| 4 | HOME_HOST_EMPL_RCD | Character(3) | VARCHAR2(3) NOT NULL |
Home/Host Empl Record
Prompt Table: %RECNAME_EDIT |