SSR_BR_BND_IND

(SQL View)
 Index Back

Tut Fee Pop Select Reslt table


SELECT P.EMPLID , %Substring(PR1.NATIONAL_ID, 1, 9) , %Substring(PR2.NATIONAL_ID, 1, 9) , %Substring(APT.CIP_CODE,1,5) , XRF.SSR_BR_AC_LDAP_NLD , T.TERM_BEGIN_DT , T.ACAD_YEAR FROM PS_HCR_PERSON_I P JOIN PS_ACAD_PROG AP ON P.EMPLID=AP.EMPLID JOIN PS_TERM_TBL T ON AP.INSTITUTION=T.INSTITUTION AND AP.ACAD_CAREER=T.ACAD_CAREER JOIN PS_SSR_BR_ACLD_NLD XRF ON AP.ACAD_LOAD_APPR=XRF.ACAD_LOAD_APPR JOIN PS_ACAD_PROG_TBL APT ON AP.ACAD_PROG = APT.ACAD_PROG LEFT OUTER JOIN PS_PERS_NID PR1 ON PR1.EMPLID =P.EMPLID AND PR1.NATIONAL_ID_TYPE = 'PR' LEFT OUTER JOIN PS_PERS_NID PR2 ON PR2.EMPLID =P.EMPLID AND PR2.NATIONAL_ID_TYPE = 'OND' WHERE T.TERM_CATEGORY=( SELECT TERM_CATEGORY FROM PS_SSR_BR_PRCO_NLD) AND AP.EFFDT= ( SELECT MAX(E_AP.EFFDT) FROM PS_ACAD_PROG E_AP WHERE AP.EMPLID = E_AP.EMPLID AND AP.ACAD_CAREER = E_AP.ACAD_CAREER AND AP.STDNT_CAR_NBR = E_AP.STDNT_CAR_NBR AND E_AP.EFFDT <= T.TERM_BEGIN_DT) AND AP.EFFSEQ = ( SELECT MAX(E_AP.EFFSEQ) FROM PS_ACAD_PROG E_AP WHERE AP.EMPLID = E_AP.EMPLID AND AP.ACAD_CAREER = E_AP.ACAD_CAREER AND AP.STDNT_CAR_NBR = E_AP.STDNT_CAR_NBR AND AP.EFFDT = E_AP.EFFDT) AND AP.PROG_STATUS='AC' AND APT.EFFDT= ( SELECT MAX(E_APT.EFFDT) FROM PS_ACAD_PROG_TBL E_APT WHERE APT.INSTITUTION=E_APT.INSTITUTION AND APT.ACAD_PROG=E_APT.ACAD_PROG AND APT.EFFDT<=T.TERM_BEGIN_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
3 SAD_SL_O_NBR Character(9) VARCHAR2(9) NOT NULL Onumber
4 SAD_SL_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
5 SSR_BR_AC_LDAP_NLD Character(2) VARCHAR2(2) NOT NULL Approved Academic Load
DT=Part-Time
DU=Dual
VT=Full-Time
6 ENROLLMENT_DT Date(10) DATE Original Enrollment Date
7 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year