EX_SHT_APRVL_VW(SQL View) |
Index Back |
---|---|
Expenses Action HistoryThis 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
|
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 |