SUB_RULE_DEFN (SQL Table)	Index Back
Substitution Rule Definition Substitution Rule Definition for the Accounting Template

SUB_RULE_DEFN

(SQL Table)

Substitution Rule Definition

Substitution Rule Definition for the Accounting Template

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 SUB_RULE_ID Character(20) VARCHAR2(20) NOT NULL The unique key identifier for a given accounting template substitution rule.

3 SOURCE_TYPE Character(1) VARCHAR2(1) NOT NULL Categorizes Treasury Accounting Templates according to the type of transaction they process (badly named field). Keep this field in sync with TR_SOURCE_CD and TRA_SOURCE_CD. 01/11/99 - CMH - Removed 'A' from XLAT, will use 'W' for TR Wires 11/20/99 - MC - Added 'H' for Hedge Accounting 06/29/00 - RV - Changed 'F' to Fees. Fees now cover Deal Fees, LC Fees, Facility Fees, etc. 09/08/00 - RV - Changed Treasury Wires to EFT Requests. 07/15/04 - SD - Added 'P' for Investment Pools
B=BSP
D=Deals
F=Fees
H=Hedge Accounting
I=Interest
P=Investment Pools
W=EFT Requests

4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

6 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified

7 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	SUB_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	The unique key identifier for a given accounting template substitution rule.
3	SOURCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Categorizes Treasury Accounting Templates according to the type of transaction they process (badly named field). Keep this field in sync with TR_SOURCE_CD and TRA_SOURCE_CD. 01/11/99 - CMH - Removed 'A' from XLAT, will use 'W' for TR Wires 11/20/99 - MC - Added 'H' for Hedge Accounting 06/29/00 - RV - Changed 'F' to Fees. Fees now cover Deal Fees, LC Fees, Facility Fees, etc. 09/08/00 - RV - Changed Treasury Wires to EFT Requests. 07/15/04 - SD - Added 'P' for Investment Pools B=BSP D=Deals F=Fees H=Hedge Accounting I=Interest P=Investment Pools W=EFT Requests
4	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
5	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
6	LAST_MAINT_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a transaction was last modified
7	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID