SAD_SL_PREDU_VW

(SQL View)
 Index Back

Prior Ed Studielink view


SELECT B.EMPLID ,B.SSR_PRIOR_EDU_NLD ,A.SAD_SL_INDEX_ID ,A.SAD_SL_STDLNK_NBR ,A.SAD_SL_ORG_CODE ,A.SAD_SL_REG_NBR ,A.SAD_SL_EXAM_YY ,A.SAD_SL_EXAM_MM ,A.SAD_SL_EXAM_DD ,A.SAD_SL_ORG_NAME ,A.SAD_SL_REG_NAME ,A.SAD_SL_EXT_REG_NNM ,A.SAD_SL_EXT_REG_NM ,A.SAD_SL_EDU_CITY ,A.SAD_SL_EDU_CNTRY ,A.SAD_SL_DIPLOMA_IND ,A.SAD_SL_QCLVRF_STAT ,A.SAD_SL_VERIF_DT ,A.SAD_SL_VERIFIER_CD ,A.SAD_SL_INST_NAME ,A.SAD_SL_VERIFIER_NM ,A.SAD_SL_SUBORG FROM PS_SAD_SL_03_QCL A ,PS_SSR_STD_EDU_NLD B ,PS_EXTERNAL_SYSTEM C ,PS_SAD_SL_TRNS_INF D WHERE C.EXTERNAL_SYSTEM='SLN' AND A.SAD_SL_STDLNK_NBR = C.EXTERNAL_SYSTEM_ID AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_EXTERNAL_SYSTEM C1 WHERE C.EMPLID = C1.EMPLID AND C.EXTERNAL_SYSTEM = C1.EXTERNAL_SYSTEM AND C1.EFFDT <= %CurrentDateIn) AND B.EMPLID = C.EMPLID AND D.SAD_SL_TRANS_STAT = 'P' AND D.SAD_SL_TRANS_DTTM = A.SAD_SL_TRANS_DTTM AND D.SAD_SL_TRANS_INOUT = A.SAD_SL_TRANS_INOUT AND D.SAD_SL_TRANS_SEQ = A.SAD_SL_TRANS_SEQ AND D.SAD_SL_INDEX_ID = A.SAD_SL_INDEX_ID UNION SELECT B.EMPLID ,B.SSR_PRIOR_EDU_NLD ,A.SAD_SL_INDEX_ID ,A.SAD_SL_STDLNK_NBR ,A.SAD_SL_ORG_CODE ,A.SAD_SL_REG_NBR ,A.SAD_SL_EXAM_YY ,A.SAD_SL_EXAM_MM ,A.SAD_SL_EXAM_DD ,A.SAD_SL_ORG_NAME ,A.SAD_SL_REG_NAME ,A.SAD_SL_EXT_REG_NNM ,A.SAD_SL_EXT_REG_NM ,A.SAD_SL_EDU_CITY ,A.SAD_SL_EDU_CNTRY ,A.SAD_SL_DIPLOMA_IND ,A.SAD_SL_QCLVRF_STAT ,A.SAD_SL_VERIF_DT ,A.SAD_SL_VERIFIER_CD ,A.SAD_SL_INST_NAME ,A.SAD_SL_VERIFIER_NM ,A.SAD_SL_SUBORG FROM PS_SAD_SL_07_QCL A ,PS_SSR_STD_EDU_NLD B ,PS_EXTERNAL_SYSTEM C ,PS_SAD_SL_TRNS_INF D WHERE C.EXTERNAL_SYSTEM='SLN' AND A.SAD_SL_STDLNK_NBR = C.EXTERNAL_SYSTEM_ID AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_EXTERNAL_SYSTEM C1 WHERE C.EMPLID = C1.EMPLID AND C.EXTERNAL_SYSTEM = C1.EXTERNAL_SYSTEM AND C1.EFFDT <= %CurrentDateIn) AND B.EMPLID = C.EMPLID AND D.SAD_SL_TRANS_STAT = 'P' AND D.SAD_SL_TRANS_DTTM = A.SAD_SL_TRANS_DTTM AND D.SAD_SL_TRANS_INOUT = A.SAD_SL_TRANS_INOUT AND D.SAD_SL_TRANS_SEQ = A.SAD_SL_TRANS_SEQ AND D.SAD_SL_INDEX_ID = A.SAD_SL_INDEX_ID UNION SELECT B.EMPLID ,B.SSR_PRIOR_EDU_NLD ,A.SAD_SL_INDEX_ID ,A.SAD_SL_STDLNK_NBR ,A.SAD_SL_ORG_CODE ,A.SAD_SL_REG_NBR ,A.SAD_SL_EXAM_YY ,A.SAD_SL_EXAM_MM ,A.SAD_SL_EXAM_DD ,A.SAD_SL_ORG_NAME ,A.SAD_SL_REG_NAME ,A.SAD_SL_EXT_REG_NNM ,A.SAD_SL_EXT_REG_NM ,A.SAD_SL_EDU_CITY ,A.SAD_SL_EDU_CNTRY ,A.SAD_SL_DIPLOMA_IND ,A.SAD_SL_QCLVRF_STAT ,A.SAD_SL_VERIF_DT ,A.SAD_SL_VERIFIER_CD ,A.SAD_SL_INST_NAME ,A.SAD_SL_VERIFIER_NM ,A.SAD_SL_SUBORG FROM PS_SAD_SL_10_QCL A ,PS_SSR_STD_EDU_NLD B ,PS_EXTERNAL_SYSTEM C ,PS_SAD_SL_TRNS_INF D WHERE C.EXTERNAL_SYSTEM='SLN' AND A.SAD_SL_STDLNK_NBR = C.EXTERNAL_SYSTEM_ID AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_EXTERNAL_SYSTEM C1 WHERE C.EMPLID = C1.EMPLID AND C.EXTERNAL_SYSTEM = C1.EXTERNAL_SYSTEM AND C1.EFFDT <= %CurrentDateIn) AND B.EMPLID = C.EMPLID AND A.SAD_SL_TRANS_INOUT = 'I' AND D.SAD_SL_TRANS_STAT = 'P' AND D.SAD_SL_TRANS_DTTM = A.SAD_SL_TRANS_DTTM AND D.SAD_SL_TRANS_INOUT = A.SAD_SL_TRANS_INOUT AND D.SAD_SL_TRANS_SEQ = A.SAD_SL_TRANS_SEQ AND D.SAD_SL_INDEX_ID = A.SAD_SL_INDEX_ID

  • Parent record: SAD_SL_07

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 SSR_PRIOR_EDU_NLD Character(5) VARCHAR2(5) NOT NULL Prior Education
    3 SAD_SL_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Index ID
    4 SAD_SL_STDLNK_NBR Character(9) VARCHAR2(9) NOT NULL Studielink Number
    5 SAD_SL_ORG_CODE Character(4) VARCHAR2(4) NOT NULL Brincode Prior Education
    6 SAD_SL_REG_NBR Character(5) VARCHAR2(5) NOT NULL Prior Education
    7 SAD_SL_EXAM_YY Character(4) VARCHAR2(4) NOT NULL Graduation Year
    8 SAD_SL_EXAM_MM Character(2) VARCHAR2(2) NOT NULL Graduation Month
    9 SAD_SL_EXAM_DD Character(2) VARCHAR2(2) NOT NULL Graduation Day
    10 SAD_SL_ORG_NAME Character(70) VARCHAR2(70) NOT NULL Name Prior Education
    11 SAD_SL_REG_NAME Character(100) VARCHAR2(100) NOT NULL Prior Education Description
    12 SAD_SL_EXT_REG_NNM Character(5) VARCHAR2(5) NOT NULL Prior Education Extension
    13 SAD_SL_EXT_REG_NM Character(100) VARCHAR2(100) NOT NULL Prior Education Extension Name
    14 SAD_SL_EDU_CITY Character(24) VARCHAR2(24) NOT NULL City Prior Education
    15 SAD_SL_EDU_CNTRY Character(4) VARCHAR2(4) NOT NULL Prior Edu Extn Country Code
    16 SAD_SL_DIPLOMA_IND Character(1) VARCHAR2(1) NOT NULL Diploma
    17 SAD_SL_QCLVRF_STAT Character(2) VARCHAR2(2) NOT NULL Verified Status
    A=Institute Verification Removed
    DD=Decentralized Diploma
    N=Not Verified
    18 SAD_SL_VERIF_DT Character(10) VARCHAR2(10) NOT NULL Date of Verification
    19 SAD_SL_VERIFIER_CD Character(4) VARCHAR2(4) NOT NULL Verified by Brincode
    20 SAD_SL_INST_NAME Character(70) VARCHAR2(70) NOT NULL Verified by Institution
    21 SAD_SL_VERIFIER_NM Character(35) VARCHAR2(35) NOT NULL Verified by Employee
    22 SAD_SL_SUBORG Character(2) VARCHAR2(2) NOT NULL SubOrganization