SSF_PADM_SR2_VW

(SQL View)
 Index Back

Payment Matriculation View


SELECT DISTINCT B.INSTITUTION_SET , A.BUSINESS_UNIT , A.EMPLID , A.OPRID , A.GRP_TIMESTAMP , A.ACAD_CAREER , A.ADM_APPL_NBR , A.STDNT_CAR_NBR , A.RECEIPT_NBR , A.SF_PMT_REF_NBR FROM PS_SSF_PADM_SR_VW A , PS_ISET_BU_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT GROUP BY B.INSTITUTION_SET, A.BUSINESS_UNIT , A.EMPLID , A.OPRID , A.GRP_TIMESTAMP , A.ACAD_CAREER , A.ADM_APPL_NBR , A.STDNT_CAR_NBR , A.RECEIPT_NBR , A.SF_PMT_REF_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

Prompt Table: SP_BU_SF_NONVW

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

Prompt Table: PEOPLE_SRCH_SF

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 GRP_TIMESTAMP DateTime(26) TIMESTAMP Group Line Time Stamp
6 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
7 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
8 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
9 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
10 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr