EX_SUM_APPR_ERR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
2	APPR_TRANS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Approval Transaction Type. CA=Cash Advance ER=Expense Report TA=Travel Authorization TJ=Time Adjustment TR=Time Report
3	TRANSACTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction ID
4	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
5	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
6	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
7	TRAVEL_AUTH_ID	Character(10)	VARCHAR2(10) NOT NULL	Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
8	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID
9	LINE_SELECT_CB	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit
10	AWLEVEL	Number(1,0)	SMALLINT NOT NULL	Level e.g. Header = 0, Line = 1. 0=Header 1=Line
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	PERIOD_END_DT	Date(10)	DATE	Represents the date termination point for a given time set utilized in cash worksheet processing.
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
15	TRANS_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Status APR=Approved APY=Approved for Payment CLS=Closed DEN=Denied HLD=On Hold PAR=Approvals in Process PD=Paid PND=Pending RCN=Reconciled STG=Staged SUB=Submitted for Approval
16	TRANSACTION_DATE	Date(10)	DATE	Transaction Date
17	SUBMISSION_DATE	Date(10)	DATE	Submission Date
18	SHEET_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Report Status APY=Approved for Payment APZ=Approved For Zero Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNU=Denied by Auditor ESC=Escheated Payment HDA=On Hold, with Approver HDU=On Hold, with Auditor HLD=On Hold MFS=Marked for Submit OPN=Open PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process RAP=Approved SFA=Submission in Process STG=Staged SUB=Submitted for Approval XML=Submitted, Pending Validation
19	TIME_SHEET_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Time Sheet Status ADJ=Adjusted APR=Approved DEN=Denied DNA=Denied by Approver DNU=Denied by Project Manager HDA=Hold by Approver HDU=Hold by Project Manager HLD=Hold MFS=Marked for Submit PAR=Approvals in Process PND=Pending PRO=In Process SFA=Submission in Process SUB=Submitted for Approval XML=Submitted, Pending Validation
20	TRAVEL_AUTH_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Describes the current status of the travel authorization - whether pending, submitted or approved. This field is associated with the header record of travel authorizations and is found on many records and panels within travel authorization objects. The status will change depending on the action taken upon the travel authorization. PeopleCode is used to update the status. APR=Approved CLS=Closed DEN=Denied DNA=Denied by Approver DNU=Denied by Auditor HDA=On Hold, with Approver HDU=On Hold, with Auditor HLD=On Hold PAR=Approvals in Process PND=Pending PRO=In Process RCN=Reconciled RRT=Transaction Rerouted SFA=Submission in Process STG=Staged SUB=Submitted for Approval XML=Submitted, Pending Validation
21	ADV_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Advance Status APY=Approved for Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNU=Denied by Auditor HDA=On Hold, with Approver HDU=On Hold, with Auditor HLD=On Hold PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process PST=Past Due Balance RAP=Approved RCN=Reconciled RRT=Reroute Transaction SFA=Submission in Process STG=Staged SUB=Submitted for Approval XML=Submitted, Pending Validation
22	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
23	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
24	DTL_TOTAL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total
25	POL_TOTAL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	PolTotal
26	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded
27	NO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	No Receipt
28	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
29	DUPLICATES_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Duplicates Exist
30	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant
31	OUTSIDE_THRESHLD	Character(1)	VARCHAR2(1) NOT NULL	Outside Threshold
32	RISK_EXISTS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Risk Exists
33	OLDER_TRANSACTION	Character(1)	VARCHAR2(1) NOT NULL	Older Transactions
34	DATE_FROM	Date(10)	DATE	Date From
35	APPRVR_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Approver type used to cross reference an AWE process id and stage.
36	APPRVR_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Approver Type Description
37	SOURCE_COMPONENT	Character(3)	VARCHAR2(3) NOT NULL	Source Component MOD=Modify Approved Transactions SUM=Summary Approvals Default Value: SUM
38	APPR_PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Approval in Process Flag Y/N Table Edit Default Value: N
39	DATE_TIME_HM	DateTime(26)	TIMESTAMP	Date Timestamp
40	OPRID_LAST_ACTION	Character(30)	VARCHAR2(30) NOT NULL	Last User to Take Action
41	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
42	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
43	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
44	MESSAGE_TEXT_254	Character(254)	VARCHAR2(254) NOT NULL	Message Text