EMPLIDPrompt Table: PERSON
DEPENDENT_IDPrompt Table: DEPENDENT_VW
DT_ELIGIBLEDefault Value: %date
ACCOMPANYING_DEPPrompt Table: DEPENDENT_BENEF
TRVL_DEPENDENT(SQL Table) |
Index Back |
|---|---|
EE Comp-Paid Travel-DependentsUse TRVL_CMPY_PAID in the International Assignment application to record company-paid travel for the primary traveler (employee or a dependent) when the employee is on an overseas job assignment. If the primary traveler is accompanied by other dependents, use the subordinate record TRVL_DEPENDENT to identify the dependents accompanying the primary traveler. Examples: - If the employee is traveling alone, create one TRVL_CMPY_PAID record (leave DEPENDENT_ID blank). - If a dependent is traveling alone, create one TRVL_CMPY_PAID record (enter both EMPLID and DEPENDENT_ID). - If the employee is traveling only with his or her spouse, create one TRVL_CMPY_PAID record (leave DEPENDENT_ID blank) and one TRVL_DEPENDENT record for the dependent. - If the employee is traveling with the spouse and three dependent children, create one TRVL_CMPY_PAID record (leave DEPENDENT_ID blank) and four TRVL_DEPENDENT records (one each for the spouse and each child). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | DEPENDENT_ID |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent ID
Prompt Table: DEPENDENT_VW |
| 3 | DT_ELIGIBLE |
Date(10) | DATE NOT NULL |
Date Eligible
Default Value: %date |
| 4 | ACCOMPANYING_DEP |
Character(2) | VARCHAR2(2) NOT NULL |
Accompanying Dependent
Prompt Table: DEPENDENT_BENEF |