SF_1098_OVRD_VW (SQL View)	Index Back
SF 1098-T Override View This view contains the detail data for the 1098-T, Tuition Payments Statement, form for the record with the maximum sequence number. This view is used by the run control panels as a prompt for emplid's.

SF_1098_OVRD_VW

(SQL View)

SF 1098-T Override View

This view contains the detail data for the 1098-T, Tuition Payments Statement, form for the record with the maximum sequence number. This view is used by the run control panels as a prompt for emplid's.

SELECT A.SF_TIN ,A.CALENDAR_YEAR ,A.EMPLID ,B.NAME FROM PS_SF_1098_DTL A , PS_SCC_PRI_NAME_VW B WHERE A.SEQ_NO = ( SELECT MAX(X.SEQ_NO) FROM PS_SF_1098_DTL X WHERE A.EMPLID = X.EMPLID AND A.SF_TIN = X.SF_TIN AND A.CALENDAR_YEAR = X.CALENDAR_YEAR) AND A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SF_TIN Number(9,0) DECIMAL(9) NOT NULL 1098-T Federal Taxpayer ID

2 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

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

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SF_TIN	Number(9,0)	DECIMAL(9) NOT NULL	1098-T Federal Taxpayer ID
2	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name