BSP_CYCLE_NUMRUN_CNTL_IDBANK_CDBNK_SESSIONBNK_CONNECTION1=Request Published
2=Cerg Accepted Request
4=Cerg Processed - Good
5=Cerg Published
6=PeopleSoft Subscribed - Good
7=PeopleSoft Subscribed - Bad
8=Loaded to Staging Table
BNK_STMT_RQST_D(SQL Table) |
Index Back |
|---|---|
BSP Request Table - DetailMessage detail for Bank Statement Requests sent to Cerg |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BSP_CYCLE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | BSP Cycle Number |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 4 | BNK_SESSION |
Character(8) | VARCHAR2(8) NOT NULL | Session field used for 3rd party integration w/Cerg |
| 5 | BNK_CONNECTION |
Character(8) | VARCHAR2(8) NOT NULL | Connection field used for 3rd party integration w/Cerg |
| 6 | BNK_STMT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Bank Statement Status
1=Request Published 2=Cerg Accepted Request 4=Cerg Processed - Good 5=Cerg Published 6=PeopleSoft Subscribed - Good 7=PeopleSoft Subscribed - Bad 8=Loaded to Staging Table |