CA_SP_FILE_INFO (SQL Table)	Index Back
Sponsor File Info Stores information regarding Sponsor files loaded into the system..

CA_SP_FILE_INFO

(SQL Table)

Sponsor File Info

Stores information regarding Sponsor files loaded into the system..

# 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 CA_SP_FILE_STATUS Character(1) VARCHAR2(1) NOT NULL Contracts Sponsor File Status
D=Ready
E=Error
F=Formatting
R=Reading
S=Staged
W=Warning

4 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

5 FILE_PATH_NAME Character(254) VARCHAR2(254) NOT NULL Datamover File Path

6 FILEDATA Long Character CLOB File Data

#	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	CA_SP_FILE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contracts Sponsor File Status D=Ready E=Error F=Formatting R=Reading S=Staged W=Warning
4	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
5	FILE_PATH_NAME	Character(254)	VARCHAR2(254) NOT NULL	Datamover File Path
6	FILEDATA	Long Character	CLOB	File Data