SCC_SFP_SAFI_VW

(SQL View)
 Index Back

SFP SAFI Log View

View of SAFI log returning entries that have generated FPOv2 message entries.

SELECT S.EMPLID , S.INSTITUTION , S.SCC_SFP_PROG_CODE , S.SCC_VOC_MSG_SEQ , S.ACAD_CAREER , S.ACAD_PROG , S.ACAD_PLAN , S.ADM_APPL_NBR , S.CAMPUS , S.STDNT_CAR_NBR , S.APPL_PROG_NBR , S.PROG_STATUS , S.SCC_SFP_PROG_OLD ,M.DESCRLONG FROM PS_SCC_SFP_SAFILOG S , PS_SCC_SFA_MSG_MAP M ,PS_SCC_SFA_MSG_MAP A WHERE S.EMPLID = M.EMPLID AND S.SCC_VOC_MSG_SEQ = M.SCC_VOC_MSG_SEQ AND S.EMPLID = A.EMPLID AND A.SCC_VFA_MESSAGE_CL = 'AAID' AND instr(A.descrlong, s.institution || '-'|| S.scc_sfp_prog_code ) > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 SCC_SFP_PROG_CODE Character(4) VARCHAR2(4) NOT NULL SFP program code
4 SCC_VOC_MSG_SEQ Number(15,0) DECIMAL(15) NOT NULL Vocado message sequence number
5 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
6 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
7 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
8 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
9 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
10 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
11 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
12 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted
13 SCC_SFP_PROG_OLD Character(1) VARCHAR2(1) NOT NULL SFP old program code

Y/N Table Edit

Default Value: N

14 DESCRLONG Long Character CLOB Long Description