SQL Side Gig

The #1 community for Gun Owners of the Northeast

Member Benefits:

  • No ad networks!
  • Discuss all aspects of firearm ownership
  • Discuss anti-gun legislation
  • Buy, sell, and trade in the classified section
  • Chat with Local gun shops, ranges, trainers & other businesses
  • Discover free outdoor shooting areas
  • View up to date on firearm-related events
  • Share photos & video with other members
  • ...and so much more!
  • MDFF2008

    Ultimate Member
    Aug 12, 2008
    24,735
    Is there anyway I could meet with one of you, and pay you to get this done?
     

    sundaeman

    Active Member
    MDS Supporter
    Sep 16, 2008
    999
    I looked around for a little bit... This may point you the right way...

    https://sites.smu.edu/des/SRQP/?a=datadictionary&tabledetail=ACAD_PLAN




    Field Name: ACAD_PLAN

    Relevant Tables:
    Table Field Name Field Descr
    ACAD_DEGR_PLAN ACAD_PLAN Code for Academic Plan, or Major/Minor
    ACAD_DEGR_SPLN ACAD_PLAN Code for Academic Plan, or Major/Minor
    ACAD_PLAN ACAD_PLAN Code for Academic Plan, or Major/Minor
    ACAD_PLAN_OWNER ACAD_PLAN Code for Academic Plan, or Major/Minor
    ACAD_PLAN_TBL ACAD_PLAN Code for Academic Plan, or Major/Minor
    ACAD_SUBPLAN ACAD_PLAN Code for Academic Plan, or Major/Minor
    ACAD_SUBPLN_TBL ACAD_PLAN Code for Academic Plan, or Major/Minor
     

    sundaeman

    Active Member
    MDS Supporter
    Sep 16, 2008
    999
    I'm not sure about your data but this may do it. But now that i've thought about it double majors or not declaring one may be a problem... but its an idea.

    FROM (PS_STDNT_CAR_TERM A LEFT OUTER JOIN PS_SCC_EMAIL_QVW B ON A.EMPLID = B.EMPLID AND B.E_ADDR_TYPE = 'CAMP' ), PS_SCC_PERDATA_QVW C, PS_TERM_TBL E, (PS_ACAD_PROG F LEFT OUTER JOIN PS_SCC_VISA_P_QVW G ON F.EMPLID = G.EMPLID AND G.EFFDT >= F.EFFDT ), ((PS_ACAD_PLAN H LEFT OUTER JOIN PS_ACAD_SUBPLAN J ON H.EMPLID = J.EMPLID AND H.ACAD_CAREER = J.ACAD_CAREER AND H.STDNT_CAR_NBR = J.STDNT_CAR_NBR AND H.EFFSEQ = J.EFFSEQ AND H.ACAD_PLAN = J.ACAD_PLAN AND J.EFFDT <= SYSDATE ) LEFT OUTER JOIN PS_ACAD_SUBPLN_TBL D ON J.ACAD_PLAN = D.ACAD_PLAN AND J.ACAD_SUB_PLAN = D.ACAD_SUB_PLAN AND D.EFFDT <= SYSDATE ), (PS_ACAD_PROG K LEFT OUTER JOIN PS_ACAD_PROG L ON K.EMPLID = L.EMPLID AND K.ACAD_CAREER = L.ACAD_CAREER AND K.STDNT_CAR_NBR = L.STDNT_CAR_NBR AND K.EFFSEQ = L.EFFSEQ AND L.EFFDT <= K.EFFDT AND L.PROG_ACTION = 'MATR' AND L.ADMIT_TERM = K.ADMIT_TERM ), PS_ADDRESS_NPC_VW M, PS_ACAD_PLAN_OWNER N, PS_TU_ACAD_ORG_GRP O, PS_ACAD_PLAN_TBL P
    WHERE
    P.ACAD_PLAN_TYPE ='whatever value you use for major' AND
    ( A.STRM = :1
    AND A.UNT_TAKEN_PRGRSS+ A.UNT_AUDIT > 0
     

    Users who are viewing this thread

    Latest posts

    Forum statistics

    Threads
    274,921
    Messages
    7,259,069
    Members
    33,349
    Latest member
    christian04

    Latest threads

    Top Bottom