EX_ERR_APPR_VW

#	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	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
5	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
6	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
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	DATE_FROM	Date(10)	DATE	Date From
27	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
28	APPRVR_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Approver type used to cross reference an AWE process id and stage.
29	APPRVR_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Approver Type Description
30	STAGE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Unique stage identifier
31	SOURCE_COMPONENT	Character(3)	VARCHAR2(3) NOT NULL	Source Component MOD=Modify Approved Transactions SUM=Summary Approvals
32	MESSAGE_TEXT_254	Character(254)	VARCHAR2(254) NOT NULL	Message Text
33	URGENCY	Character(1)	VARCHAR2(1) NOT NULL	Urgency H=High L=Low M=Medium
34	EXCEPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Exceptions
35	PB_RISK	Character(1)	VARCHAR2(1) NOT NULL	Risk
36	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded
37	NO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	No Receipt
38	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
39	DUPLICATES_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Duplicates Exist
40	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant
41	OUTSIDE_THRESHLD	Character(1)	VARCHAR2(1) NOT NULL	Outside Threshold
42	RISK_EXISTS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Risk Exists
43	OLDER_TRANSACTION	Character(1)	VARCHAR2(1) NOT NULL	Older Transactions