SF_1098_DTL_VW (SQL View)	Index Back
SF 1098-T Detail View This view contains the detail data for the 1098-T, Tuition Payments Statement, form for the record with the maximum sequence number.

SF_1098_DTL_VW

(SQL View)

SF 1098-T Detail View

This view contains the detail data for the 1098-T, Tuition Payments Statement, form for the record with the maximum sequence number.

SELECT A.EMPLID ,A.SF_TIN ,A.CALENDAR_YEAR FROM PS_SF_1098_DTL A 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)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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