SAA_ACDPRG_LVW

(SQL View)
 Index Back

Acad Progress Language View


SELECT L.LANGUAGE_CD , A.EMPLID , A.ANALYSIS_DB_SEQ , A.SAA_CAREER_RPT , A.TSCRPT_TYPE , 'KEYRQG' , A.RQRMNT_GROUP , A.REQUIREMENT , A.RQ_LINE_NBR , A.RQRMNT_GROUP , L.SAA_DESCR80 , A.SAA_ENTRY_SEQ , A.ITEM_R_STATUS FROM PS_SAA_ARSLT_RGVW A , PS_RQ_GRP_TBL B , PS_RQ_GRP_LANG L WHERE A.RQRMNT_GROUP = B.RQRMNT_GROUP AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_RQ_GRP_TBL B1 WHERE B1.RQRMNT_GROUP = B.RQRMNT_GROUP AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND L.RQRMNT_GROUP = B.RQRMNT_GROUP AND L.EFFDT = B.EFFDT UNION ALL SELECT L.LANGUAGE_CD , A.EMPLID , A.ANALYSIS_DB_SEQ , A.SAA_CAREER_RPT , A.TSCRPT_TYPE , 'KEYREQ' , A.RQRMNT_GROUP , A.REQUIREMENT , A.RQ_LINE_NBR , A.REQUIREMENT , L.SAA_DESCR80 , A.SAA_ENTRY_SEQ , C.ITEM_R_STATUS FROM PS_SAA_ARSLT_RLVW A , PS_RQ_MAIN_TBL B , PS_SAA_ARSLT_RQVW C , PS_RQ_MAIN_LANG L WHERE A.SAA_ENTRY_SEQ = ( SELECT MIN(A1.SAA_ENTRY_SEQ) FROM PS_SAA_ARSLT_RLVW A1 WHERE A1.EMPLID = A.EMPLID AND A1.ANALYSIS_DB_SEQ = A.ANALYSIS_DB_SEQ AND A1.SAA_CAREER_RPT = A.SAA_CAREER_RPT AND A1.RQRMNT_GROUP = A.RQRMNT_GROUP AND A1.REQUIREMENT = A.REQUIREMENT) AND A.REQUIREMENT = B.REQUIREMENT AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_RQ_MAIN_TBL B1 WHERE B1.REQUIREMENT = B.REQUIREMENT AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND B.RQ_PRINT_CNTL NOT IN ('NVR','SKP') AND C.EMPLID = A.EMPLID AND C.ANALYSIS_DB_SEQ = A.ANALYSIS_DB_SEQ AND C.SAA_CAREER_RPT = A.SAA_CAREER_RPT AND C.RQRMNT_GROUP = A.RQRMNT_GROUP AND C.REQUIREMENT = A.REQUIREMENT AND L.REQUIREMENT = B.REQUIREMENT AND L.EFFDT = B.EFFDT UNION ALL SELECT L.LANGUAGE_CD , A.EMPLID , A.ANALYSIS_DB_SEQ , A.SAA_CAREER_RPT , A.TSCRPT_TYPE , 'KEYRQL' , A.RQRMNT_GROUP , A.REQUIREMENT , A.RQ_LINE_NBR , A.RQ_LINE_NBR , L.SAA_DESCR80 , A.SAA_ENTRY_SEQ , A.ITEM_R_STATUS FROM PS_SAA_ARSLT_RLVW A , PS_RQ_MAIN_TBL B , PS_RQ_LINE_TBL C , PS_RQ_LINE_LANG L WHERE A.REQUIREMENT = B.REQUIREMENT AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_RQ_MAIN_TBL B1 WHERE B1.REQUIREMENT = B.REQUIREMENT AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND C.REQUIREMENT = A.REQUIREMENT AND C.RQ_LINE_NBR = A.RQ_LINE_NBR AND B.EFFDT = C.EFFDT AND L.REQUIREMENT = C.REQUIREMENT AND L.EFFDT = C.EFFDT AND L.RQ_LINE_KEY_NBR = C.RQ_LINE_KEY_NBR

  • Related Language Record for SAA_ACD_PRG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 ANALYSIS_DB_SEQ Number(4,0) SMALLINT NOT NULL Analysis DB Sequence
    4 SAA_CAREER_RPT Character(4) VARCHAR2(4) NOT NULL This field is used in academic advisement as a key to the results tables.
    5 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
    6 ENTRY_R_TYPE Character(6) VARCHAR2(6) NOT NULL Entry Type
    7 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
    8 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement
    9 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
    10 SAA_RQG_REQ_RQL Character(9) VARCHAR2(9) NOT NULL Academic Requirements
    11 SAA_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used to display information in the new student view for academic advisement reports.
    12 SAA_ENTRY_SEQ Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement to track the position of the output in the report.
    13 ITEM_R_STATUS Character(4) VARCHAR2(4) NOT NULL Item Status
    COMP=Complete
    EXMP=Exempted
    FAIL=Fail