TEST_CASECOMPARE_TYPE1=Delta (Results v.s Expected)
2=Expected data not in Results
3=Unexpected data in Results
COMPARE_SOURCEA=Actuals
E=Expected
STATEMENT_IDBNK_ID_NBRBRANCH_IDBANK_ACCOUNT_NUM1=Update
2=Deletion
3=Correction
4=Test Only
BS_BACT_PD_EC_C(SQL Table) |
Index Back |
|---|---|
BTF:Bank Acct Statement HeaderBank 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 | COMPARE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare report type
1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results |
| 3 | COMPARE_SOURCE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare data source (Actuals or Expected results).
A=Actuals E=Expected |
| 4 | STATEMENT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Statement ID for bank statements, key on Bank Statement Header |
| 5 | BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 6 | BRANCH_ID |
Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 7 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 8 | 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 |
| 9 | ASOFDATE | Date(10) | DATE | As of Date |
| 10 | ASOFTIME | Time(15) | TIMESTAMP | As of Time |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |