EX_APRVL_HIST (SQL Table)	Index Back
Expenses Action History This record will store actions successfully taken on Expenses transactions (Expense Report, Cash Advance, Travel Authorization, Time Report, and Time Adjustments). Records will be inserted into this table when upon successful completion of the action by user or approver.

EX_APRVL_HIST

(SQL Table)

Expenses Action History

This record will store actions successfully taken on Expenses transactions (Expense Report, Cash Advance, Travel Authorization, Time Report, and Time Adjustments). Records will be inserted into this table when upon successful completion of the action by user or approver.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID

2 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization

3 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
Default Value: 1

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 1

5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSONAL_DATA

7 ACTION_DTTM DateTime(26) TIMESTAMP Override Date Time

8 ACTION_NAME Character(3) VARCHAR2(3) NOT NULL Action taken on a transaction
APR=Approved
AUT=Auto Approved
BUD=Budget Checked
DEL=Deleted
DNY=Denied
HLD=On Hold
PAS=Post Approval Submit
REC=Receipt Verified
RES=Resubmitted
REV=Reviewed
RSN=Reassigned
SBR=Sent Back For Revision
SUB=Submitted
WDR=Withdrawn

9 APPROVER_TYPE Character(1) VARCHAR2(1) NOT NULL Defines types of approvers, including originator, regular approver and auditor.
A=Approver
O=Originator
P=Project Manager
T=Post-Pay Auditor
U=Pre-Pay Auditor

10 APPROVER_PROFILE Character(15) VARCHAR2(15) NOT NULL Approver profile name
Prompt Table: EX_PROF_APPR_VW
Set Control Field: SETID

11 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
2	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
3	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number Default Value: 1
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
7	ACTION_DTTM	DateTime(26)	TIMESTAMP	Override Date Time
8	ACTION_NAME	Character(3)	VARCHAR2(3) NOT NULL	Action taken on a transaction APR=Approved AUT=Auto Approved BUD=Budget Checked DEL=Deleted DNY=Denied HLD=On Hold PAS=Post Approval Submit REC=Receipt Verified RES=Resubmitted REV=Reviewed RSN=Reassigned SBR=Sent Back For Revision SUB=Submitted WDR=Withdrawn
9	APPROVER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Defines types of approvers, including originator, regular approver and auditor. A=Approver O=Originator P=Project Manager T=Post-Pay Auditor U=Pre-Pay Auditor
10	APPROVER_PROFILE	Character(15)	VARCHAR2(15) NOT NULL	Approver profile name Prompt Table: EX_PROF_APPR_VW Set Control Field: SETID
11	COMMENTS	Long Character	CLOB	Comment