SF_1098_CHRG_VW

(SQL View)
 Index Back

Reportable 1098T Charges

This view selects all charges on ITEM_SF that have the 1098_FLG turned on for the Item Type

SELECT A.BUSINESS_UNIT , A.COMMON_ID , A.SA_ID_TYPE , A.ITEM_NBR , A.CALENDAR_YEAR , A.ITEM_TERM , A.ITEM_AMT , A.ITEM_TYPE , A.ITEM_TYPE_CD , A.ACAD_CAREER , A.STDNT_CAR_NBR , A.SESSION_CODE , A.CLASS_NBR FROM PS_ITEM_SF A , PS_ITEM_TYPE_TBL B , PS_SET_CNTRL_REC C , PS_BUS_UNIT_TBL_SF D WHERE A.ITEM_TYPE_CD = 'C' AND A.SA_ID_TYPE = 'P' AND A.ITEM_TYPE = B.ITEM_TYPE AND B.SETID = C.SETID AND B.EFFDT =( SELECT MAX(B1.EFFDT) FROM PS_ITEM_TYPE_TBL B1 WHERE B.SETID = B1.SETID AND B.ITEM_TYPE = B1.ITEM_TYPE AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND B.SF_1098_FLG = 'Y' AND C.SETCNTRLVALUE = D.INSTITUTION AND C.RECNAME = 'ITEM_TYPE_TBL' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
4 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
5 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
6 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
7 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
8 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
9 ITEM_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Item Type Code
A=Application Fee
B=Billing Only
C=Charge
D=Deposit
F=Financial Aid
G=GL Interface Only
H=Withholding
I=Interest
L=Pre-Paid Tuition
P=Payment
R=Refund
T=Transfers
V=Contributor Relations
W=Waiver
X=Write-off
Z=Pay Plan Credit
10 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
11 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
12 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
13 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr