SSF_ST_TM_SO_VW

(SQL View)
 Index Back

Stdnt Purch Item (Only) View

Student Purchase Item (Student Only) View

SELECT A.EMPLID ,E.INSTITUTION_SET ,A.STRM ,B.SSF_PUR_ITM_OPTION ,C.SSF_PUR_CATEGORY ,F.DESCR ,B.SSF_PUR_ITEM_CODE ,B.DESCR ,B.DESCRLONG ,A.BUSINESS_UNIT ,A.ACAD_CAREER ,A.INSTITUTION ,A.ACAD_PROG_PRIMARY ,A.CAMPUS ,A.ACADEMIC_LOAD ,A.SEL_GROUP ,C.ACCOUNT_TYPE_SF ,C.ITEM_TYPE ,C.FLAT_AMT FROM PS_SSF_ST_CR_BU_VW A ,PS_SSF_PUR_ITEM_CD B ,PS_SSF_PURCH_ITEM C ,PS_ISET_BU_DTL E ,PS_SSF_PUR_CATGRY F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.TERM_END_DT >= %CurrentDateIn AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.SSF_PUR_ITEM_CODE = B.SSF_PUR_ITEM_CODE AND C.EFFDT <= %CurrentDateIn AND C.EFF_STATUS = 'A' AND C.SSF_EXP_DATE > %CurrentDateIn AND (C.STRM = ' ' OR C.STRM = A.STRM) AND B.SSF_PUR_ITM_OPTION = 'S' AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND F.BUSINESS_UNIT = C.BUSINESS_UNIT AND F.SSF_PUR_CATEGORY = C.SSF_PUR_CATEGORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
3 STRM Character(4) VARCHAR2(4) NOT NULL Term
4 SSF_PUR_ITM_OPTION Character(1) VARCHAR2(1) NOT NULL Option
A=All Users
G=Student Groups
S=All Term Activated Students
T=Students Who Match Attributes
5 SSF_PUR_CATEGORY Character(10) VARCHAR2(10) NOT NULL Puchase Category
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 SSF_PUR_ITEM_CODE Character(6) VARCHAR2(6) NOT NULL Purchase Item Code
8 SSF_DESCR Character(30) VARCHAR2(30) NOT NULL Student Financials' Description
9 DESCRLONG Long Character CLOB Long Description
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 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
12 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
13 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
14 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
15 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
F=Enrolled Full-Time
H=Enrolled Half-Time
L=Less than Half-Time
N=No Unit Load
P=Enrolled Part-Time
T=Three Quarter Time
16 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group
17 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type
18 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
19 FLAT_AMT Number(17,2) DECIMAL(16,2) NOT NULL Flat Amount