BUS_EXPENSE_DTL (SQL Table)	Index Back
EE Business Expense Details Use BUS_EXPENSE_DTL to record details of an employee's business expenses for a specified expense period. This record is subordinate to BUS_EXPENSE_PER. You can create multiple BUS_EXPENSE_DTL records for an employee.

BUS_EXPENSE_DTL

(SQL Table)

EE Business Expense Details

Use BUS_EXPENSE_DTL to record details of an employee's business expenses for a specified expense period. This record is subordinate to BUS_EXPENSE_PER. You can create multiple BUS_EXPENSE_DTL records for an employee.

Parent record: BUS_EXPENSE_PER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 EXPENSE_PERIOD_DT Date(10) DATE NOT NULL Expense Period End Date
Default Value: %date

4 CHARGE_DT Date(10) DATE Charge Date
Default Value: %date

5 EXPENSE_CD Character(2) VARCHAR2(2) NOT NULL Expense code.
01=Airfare
02=Lodging
03=Car Rental
04=Meals
05=Telephone
06=Travel
07=Relocation
08=Entertainment
09=Parking
10=Mileage
11=Advertising
12=Referral Fee
13=Postage
14=Publication
15=Membership
16=Miscellaneous
17=Staff Time
18=Job Boards
19=Pre-Employment Request

6 EXPENSE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Expense Amount

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

8 BUSINESS_PURPOSE Character(20) VARCHAR2(20) NOT NULL Business Purpose

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_HR

10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EXPENSE_PERIOD_DT	Date(10)	DATE NOT NULL	Expense Period End Date Default Value: %date
4	CHARGE_DT	Date(10)	DATE	Charge Date Default Value: %date
5	EXPENSE_CD	Character(2)	VARCHAR2(2) NOT NULL	Expense code. 01=Airfare 02=Lodging 03=Car Rental 04=Meals 05=Telephone 06=Travel 07=Relocation 08=Entertainment 09=Parking 10=Mileage 11=Advertising 12=Referral Fee 13=Postage 14=Publication 15=Membership 16=Miscellaneous 17=Staff Time 18=Job Boards 19=Pre-Employment Request
6	EXPENSE_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Expense Amount
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
8	BUSINESS_PURPOSE	Character(20)	VARCHAR2(20) NOT NULL	Business Purpose
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL