BSP_CYCLE_NUM1=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_H(SQL Table) |
Index Back |
|---|---|
BSP Request Table - HeaderMessage header 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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 5 | 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 |