EX_TRANS_RTG (SQL Table)	Index Back
Transaction Approval Routing Transaction Approval Routing. This record stores the transaction routing list header information.

EX_TRANS_RTG

(SQL Table)

Transaction Approval Routing

Transaction Approval Routing. This record stores the transaction routing list header information.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Prompt Table: SP_BU_GL_NONVW

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 APPRVR_TYPE Character(10) VARCHAR2(10) NOT NULL Approver type used to cross reference an AWE process id and stage.
Prompt Table: EX_APPR_TYPE_VW
Set Control Field: BUSINESS_UNIT_GL

4 NOTIFICATION_TO Character(1) VARCHAR2(1) NOT NULL Send notifications to...
A=Notify All Approvers
F=Notify First Approver
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BU_GL_NONVW
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	APPRVR_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Approver type used to cross reference an AWE process id and stage. Prompt Table: EX_APPR_TYPE_VW Set Control Field: BUSINESS_UNIT_GL
4	NOTIFICATION_TO	Character(1)	VARCHAR2(1) NOT NULL	Send notifications to... A=Notify All Approvers F=Notify First Approver Default Value: A