MICR2025TMP_TBL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

4 MICR_ID Character(30) VARCHAR2(30) NOT NULL MICR ID

5 EFFDT Date(10) DATE Effective Date
Default Value: %date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

7 REMIT_FROM_SETID Character(5) VARCHAR2(5) NOT NULL SetID

8 REMIT_FROM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Remit From Customer

9 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines

10 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

11 BANK_ACCT_TYPE Character(2) VARCHAR2(2) NOT NULL An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit
03=Checking Account
05=Stock
06=Bond
07=Life Insurance Value
08=Retirement Account
10=Business Account
11=Trust Fund Account
12=Stock & Bond Account
13=Life Insurance Acct
CA=Current Account
CH=Charges Account
DA=Demand Deposit
LN=Loan
RD=Return Items on DDA
RS=Return Items-Savings
SA=Settlement Account
SV=Savings Account
Z=Mutually Defined

12 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

13 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined

14 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun

15 IBAN_ID Character(34) VARCHAR2(34) NOT NULL IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	MICR_ID	Character(30)	VARCHAR2(30) NOT NULL	MICR ID
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
7	REMIT_FROM_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	REMIT_FROM_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Remit From Customer
9	BANK_ID_QUAL	Character(3)	VARCHAR2(3) NOT NULL	"A bank/counterparty attribute that determines
10	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
11	BANK_ACCT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	An account attribute that describes the ostensible purposes of a given bank/counterparty account. 01=Time Deposit 03=Checking Account 05=Stock 06=Bond 07=Life Insurance Value 08=Retirement Account 10=Business Account 11=Trust Fund Account 12=Stock & Bond Account 13=Life Insurance Acct CA=Current Account CH=Charges Account DA=Demand Deposit LN=Loan RD=Return Items on DDA RS=Return Items-Savings SA=Settlement Account SV=Savings Account Z=Mutually Defined
12	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
13	DFI_ID_QUAL	Character(2)	VARCHAR2(2) NOT NULL	A banking industry convention identifier utilized to drive data validation for a given bank/counterparty. 01=Transit Number 02=Swift ID/BIC 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined
14	DFI_ID_NUM	Character(12)	VARCHAR2(12) NOT NULL	A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
15	IBAN_ID	Character(34)	VARCHAR2(34) NOT NULL	IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders