EX_SHT_APRVL_VW

(SQL View)
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.

SELECT A.EX_DOC_ID , A.SEQ_NUM , A.APPROVER_TYPE , A.APPROVER_PROFILE , A.OPRID , A.EMPLID , ' ' , A.ACTION_NAME , A.ACTION_DTTM , A.COMMENTS FROM PS_EX_APRVL_HIST A WHERE A.EX_DOC_TYPE = 'S'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 1

3 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
4 APPROVER_PROFILE Character(15) VARCHAR2(15) NOT NULL Approver profile name

Prompt Table: EX_PROF_APPR_VW
Set Control Field: SETID

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 NAME Character(50) VARCHAR2(50) NOT NULL Name
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 ACTION_DTTM DateTime(26) TIMESTAMP Override Date Time
10 COMMENTS Long Character CLOB Comment