TRVL_CMPY_PAID (SQL Table)	Index Back
EE Company-Paid Travel Use 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).

TRVL_CMPY_PAID

(SQL Table)

EE Company-Paid Travel

Use 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).

Parent record: PERSON

# 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 DT_TAKEN Date(10) DATE Date Taken

5 CASH_IN_LIEU Character(1) VARCHAR2(1) NOT NULL Cash In Lieu
Y/N Table Edit
Default Value: N

6 ALTERNATE_LOC Character(1) VARCHAR2(1) NOT NULL Alternate Location
Y/N Table Edit
Default Value: N

7 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL

9 TRAVEL_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Travel
Prompt Table: TRAVEL_TYPE_TBL

10 TRAVEL_MODE Character(1) VARCHAR2(1) NOT NULL Mode of Travel
A=Air
C=Car
T=Train
Default Value: A

11 COUNTRY_FROM Character(3) VARCHAR2(3) NOT NULL From Country
Prompt Table: COUNTRY_TBL

12 STATE_FROM Character(6) VARCHAR2(6) NOT NULL From State
Prompt Table: STATE_NAMES_FRM

13 CITY_FROM Character(30) VARCHAR2(30) NOT NULL From City

14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

15 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

16 CITY Character(30) VARCHAR2(30) NOT NULL City

#	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	DT_TAKEN	Date(10)	DATE	Date Taken
5	CASH_IN_LIEU	Character(1)	VARCHAR2(1) NOT NULL	Cash In Lieu Y/N Table Edit Default Value: N
6	ALTERNATE_LOC	Character(1)	VARCHAR2(1) NOT NULL	Alternate Location Y/N Table Edit Default Value: N
7	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
9	TRAVEL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Travel Prompt Table: TRAVEL_TYPE_TBL
10	TRAVEL_MODE	Character(1)	VARCHAR2(1) NOT NULL	Mode of Travel A=Air C=Car T=Train Default Value: A
11	COUNTRY_FROM	Character(3)	VARCHAR2(3) NOT NULL	From Country Prompt Table: COUNTRY_TBL
12	STATE_FROM	Character(6)	VARCHAR2(6) NOT NULL	From State Prompt Table: STATE_NAMES_FRM
13	CITY_FROM	Character(30)	VARCHAR2(30) NOT NULL	From City
14	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
15	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
16	CITY	Character(30)	VARCHAR2(30) NOT NULL	City