BUS_EXPENSE_PER (SQL Table)	Index Back
EE Business Expense Time Pers Use BUS_EXPENSE_PER to record the expense period end date for which an employee's business expenses are recorded. The details of the employee's expenses are contained in BUS_EXPENSE_DTL, which is a subordinate record to BUS_EXPENSE_PER. You can create multiple BUS_EXPENSE_PER records for an employee.

BUS_EXPENSE_PER

(SQL Table)

EE Business Expense Time Pers

Use BUS_EXPENSE_PER to record the expense period end date for which an employee's business expenses are recorded. The details of the employee's expenses are contained in BUS_EXPENSE_DTL, which is a subordinate record to BUS_EXPENSE_PER. You can create multiple BUS_EXPENSE_PER records for an employee.

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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

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

#	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 Rcd Nbr
3	EXPENSE_PERIOD_DT	Date(10)	DATE NOT NULL	Expense Period End Date Default Value: %date