BS_BACT_PD_EC_E (SQL Table)	Index Back
BTF:Bank Acct Statement Header Bank Account Statement Header

BS_BACT_PD_EC_E

(SQL Table)

BTF:Bank Acct Statement Header

Bank Account Statement Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case

2 STATEMENT_ID Number(10,0) DECIMAL(10) NOT NULL Statement ID for bank statements, key on Bank Statement Header

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

4 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.

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

6 GROUP_STATUS Character(1) VARCHAR2(1) NOT NULL Specifies exactly how data in a group of accounts are to be processed.
1=Update
2=Deletion
3=Correction
4=Test Only

7 ASOFDATE Date(10) DATE As of Date

8 ASOFTIME Time(15) TIMESTAMP As of Time

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

10 DTTM_REFRESHED DateTime(26) TIMESTAMP Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header
3	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
4	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
5	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
6	GROUP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Specifies exactly how data in a group of accounts are to be processed. 1=Update 2=Deletion 3=Correction 4=Test Only
7	ASOFDATE	Date(10)	DATE	As of Date
8	ASOFTIME	Time(15)	TIMESTAMP	As of Time
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	DTTM_REFRESHED	DateTime(26)	TIMESTAMP	Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.