TR_WR_HEADER (SQL Table)	Index Back
Treasury Wire Header Treasury Wire Header Entry Operator/Date Approval OperID/Date (NOT USED AT TIS TIME) Template used (this controls graying of fields) Related Tables: TR_WR_CF_VW (from account info) TR_WR_DETAIL (to account info) Child Table: TR_WR_INTERM (intermediate routing instructions)

TR_WR_HEADER

(SQL Table)

Treasury Wire Header

Treasury Wire Header Entry Operator/Date Approval OperID/Date (NOT USED AT TIS TIME) Template used (this controls graying of fields) Related Tables: TR_WR_CF_VW (from account info) TR_WR_DETAIL (to account info) Child Table: TR_WR_INTERM (intermediate routing instructions)

Parent Record Of TR_WR_CF_VW TR_WR_DETAIL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_GL_NONVW

2 TR_SOURCE_ID Character(12) VARCHAR2(12) NOT NULL An internal work field that represents a unique identifier for records depicting a given treasury po
Prompt Table: TR_WR_HEADER

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

5 DTTM_ENTERED DateTime(26) TIMESTAMP Date Time Stamp for Entry

6 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
Default Value: P

7 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By

8 APPROVAL_DT Date(10) DATE Date of Approval

9 TR_WR_TEMPLATE_ID Character(12) VARCHAR2(12) NOT NULL Treasury Wires / Treasury Wire Templates This uniquely identifies templates within a Business Unit.
Prompt Table: TR_WR_TMPL_VW

10 ACCTG_TMPL_ID Character(15) VARCHAR2(15) NOT NULL A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
Prompt Table: TRA_WIRE_TPL_VW

11 FED_WIRE_ID Character(22) VARCHAR2(22) NOT NULL This field will hold the Federal Wire ID # that is given upon confirmation of a successful wire transfer.

12 REPETITVE_TRNFR_CD Character(15) VARCHAR2(15) NOT NULL Repetitive Transfer Code assigned by customers Bank

13 DRAWDOWN_FLG Character(1) VARCHAR2(1) NOT NULL Drawdown Transfer Flag, either yes or no.
N=No
Y=Yes
Y/N Table Edit
Default Value: N

14 TMPL_EXPIRATION_DT Date(10) DATE Transfer Template Expiration Date

15 TRP_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Pool Business Unit
Prompt Table: SP_TRPBU_NONVW

16 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.
Prompt Table: TRP_PL_ACT_VW1

17 PRENOTE_FLAG Character(1) VARCHAR2(1) NOT NULL Prenotification Flag
Y/N Table Edit
Default Value: N

18 CD Character(30) VARCHAR2(30) NOT NULL Code
Prompt Table: EXT_CODE_VW

19 PRTRY Character(30) VARCHAR2(30) NOT NULL Proprietary

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW
2	TR_SOURCE_ID	Character(12)	VARCHAR2(12) NOT NULL	An internal work field that represents a unique identifier for records depicting a given treasury po Prompt Table: TR_WR_HEADER
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
5	DTTM_ENTERED	DateTime(26)	TIMESTAMP	Date Time Stamp for Entry
6	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending Default Value: P
7	OPRID_APPROVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
8	APPROVAL_DT	Date(10)	DATE	Date of Approval
9	TR_WR_TEMPLATE_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Wires / Treasury Wire Templates This uniquely identifies templates within a Business Unit. Prompt Table: TR_WR_TMPL_VW
10	ACCTG_TMPL_ID	Character(15)	VARCHAR2(15) NOT NULL	A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits. Prompt Table: TRA_WIRE_TPL_VW
11	FED_WIRE_ID	Character(22)	VARCHAR2(22) NOT NULL	This field will hold the Federal Wire ID # that is given upon confirmation of a successful wire transfer.
12	REPETITVE_TRNFR_CD	Character(15)	VARCHAR2(15) NOT NULL	Repetitive Transfer Code assigned by customers Bank
13	DRAWDOWN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Drawdown Transfer Flag, either yes or no. N=No Y=Yes Y/N Table Edit Default Value: N
14	TMPL_EXPIRATION_DT	Date(10)	DATE	Transfer Template Expiration Date
15	TRP_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Pool Business Unit Prompt Table: SP_TRPBU_NONVW
16	POOL_ID	Character(10)	VARCHAR2(10) NOT NULL	Pool ID field. Prompt Table: TRP_PL_ACT_VW1
17	PRENOTE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Flag Y/N Table Edit Default Value: N
18	CD	Character(30)	VARCHAR2(30) NOT NULL	Code Prompt Table: EXT_CODE_VW
19	PRTRY	Character(30)	VARCHAR2(30) NOT NULL	Proprietary