BSP_FILE_VW (SQL View)	Index Back
Bank Statement File Load Info Stores information regarding bank statement files loaded into the system..

BSP_FILE_VW

(SQL View)

Bank Statement File Load Info

Stores information regarding bank statement files loaded into the system..

SELECT DISTINCT A.EVENT_TRACKING_ID ,A.FILE_NAME ,A.BSP_FILE_STATUS ,A.DATETIME_STAMP ,B.STATEMENT_ID ,C.BNK_ID_NBR FROM PS_BSP_FILE_INFO A , PS_BS_STATEMENT_EC B , PS_BANK_STMT_HDR C WHERE A.EVENT_TRACKING_ID = B.IMPORT_FILE_ID AND B.STATEMENT_ID = C.STATEMENT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.

2 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name

3 BSP_FILE_STATUS Character(1) VARCHAR2(1) NOT NULL Bank Statement File Status.
D=Ready
E=Error
F=Formatting
R=Reading
S=Staged
W=Warning

4 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
2	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
3	BSP_FILE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Bank Statement File Status. D=Ready E=Error F=Formatting R=Reading S=Staged W=Warning
4	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
5	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header
6	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.