SCC_SFP_R_ISIRF (SQL Table)	Index Back
SFP ISIR Field Reporting Table This table does not persist any data and is mainly used as the backing table for the entity used to load SFP ISIR data from the ISIR web service response payload.

SCC_SFP_R_ISIRF

(SQL Table)

SFP ISIR Field Reporting Table

This table does not persist any data and is mainly used as the backing table for the entity used to load SFP ISIR data from the ISIR web service response payload.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

3 SCC_VOC_MSG_SEQ Number(15,0) DECIMAL(15) NOT NULL Vocado message sequence number

4 ISIR_SEQ_NO Number(5,0) INTEGER NOT NULL Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
3	SCC_VOC_MSG_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Vocado message sequence number
4	ISIR_SEQ_NO	Number(5,0)	INTEGER NOT NULL	Sequence Number