ASGN_CMP_HOMHST(SQL Table) |
Index Back |
|---|---|
EE Assgn Compensatn-Home/HostASGN_CMP_HOMHST 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. This record specifies the currency to use to calculate an employee's compensation for an international assignment. You can create one ASGN_CMP_HOMHST record for the home portion of the employee's compensation, and one or more records for the host portion(s) of the compensation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | PAY_INSTR_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Payment Instruction Type
I=International Compensation O=Onetime payment Default Value: I |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date Prompt Table: ASGN_CMP_EFFDT |
| 4 | HOME_HOST |
Character(1) | VARCHAR2(1) NOT NULL |
Home or Host
0=Home 1=Host 1 2=Host 2 Default Value: 0 Prompt Table: ASGN_HOMHST_VW |
| 5 | FROM_CUR | Character(3) | VARCHAR2(3) NOT NULL |
From Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 6 | TO_CUR | Character(3) | VARCHAR2(3) NOT NULL |
To Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Default Value: INSTALLATION.EXCHNG_TO_RT_TYPE Prompt Table: RT_TYPE_TBL |
| 8 | CUR_EXCHNG_RT | Number(16,8) | DECIMAL(15,8) NOT NULL | Currency Exchange Rate |