SSR_APT_RTKA_VW

(SQL View)
 Index Back

APT Item


SELECT A.EMPLID , A.INSTITUTION , A.SSR_APT_INSTANCE , A.SSR_APT_ITEM_SEQ , B.ATTEMPT_NBR , C.SSR_SEQ_NBR , A.SSR_APT_ITEM_PAR , A.SSR_APT_ITEM_FOR , A.SSR_ITEM_ID , A.SSR_ITEM_TYPE , B.SSR_ATT_OUTCOME , B.SSR_RETAKE_ELIG , B.SSR_ATT_STAT , C.SSR_YR_OF_PROG , C.ACAD_YEAR , C.STRM , C.SESSION_CODE , C.SSR_PERIOD_ID , C.SSR_CR_TYPE FROM PS_SSR_APT_ITEM A , PS_SSR_APT_ATT B , PS_SSR_APT_SCHD C WHERE A.EMPLID=B.EMPLID AND A.INSTITUTION=B.INSTITUTION AND A.SSR_APT_INSTANCE=B.SSR_APT_INSTANCE AND A.SSR_APT_ITEM_SEQ=B.SSR_APT_ITEM_SEQ AND A.EMPLID=C.EMPLID AND A.INSTITUTION=C.INSTITUTION AND A.SSR_APT_INSTANCE=C.SSR_APT_INSTANCE AND A.SSR_APT_ITEM_SEQ=C.SSR_APT_ITEM_SEQ AND B.ATTEMPT_NBR=C.ATTEMPT_NBR AND B.SSR_RETAKE_ELIG ='Y' AND B.ATTEMPT_NBR = ( SELECT MAX(D.ATTEMPT_NBR) FROM PS_SSR_APT_ATT D , PS_SSR_APT_SCHD E WHERE A.EMPLID=D.EMPLID AND A.INSTITUTION=D.INSTITUTION AND A.SSR_APT_INSTANCE=D.SSR_APT_INSTANCE AND A.SSR_APT_ITEM_SEQ=D.SSR_APT_ITEM_SEQ AND A.EMPLID=E.EMPLID AND A.INSTITUTION=E.INSTITUTION AND A.SSR_APT_INSTANCE=E.SSR_APT_INSTANCE AND A.SSR_APT_ITEM_SEQ=E.SSR_APT_ITEM_SEQ AND D.ATTEMPT_NBR=E.ATTEMPT_NBR AND E.STRM <> ' ')

  • Parent record: SSR_APT_HDR

    • # 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 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number
    4 SSR_APT_ITEM_SEQ Number(6,0) INTEGER NOT NULL APT Item Seq
    5 ATTEMPT_NBR Number(3,0) SMALLINT NOT NULL Attempt Nbr
    6 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
    7 SSR_APT_ITEM_PAR Number(6,0) INTEGER NOT NULL Parent Item Seq Nbr
    8 SSR_APT_ITEM_FOR Number(6,0) INTEGER NOT NULL Substitute for
    9 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID

    Prompt Table: SSR_AIR_HDR

    10 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type

    Prompt Table: SSR_ITEM_TYPE

    11 SSR_ATT_OUTCOME Character(4) VARCHAR2(4) NOT NULL Attempt Outcome
    20=Not Passed
    40=Passed
    12 SSR_RETAKE_ELIG Character(1) VARCHAR2(1) NOT NULL Eligible for Retake
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    13 SSR_ATT_STAT Character(2) VARCHAR2(2) NOT NULL Attempt Status
    20=Activated
    60=Provisional
    80=Finalized
    14 SSR_YR_OF_PROG Character(4) VARCHAR2(4) NOT NULL Year of Program
    00=Not Set
    01=01 - First Year
    02=02 - Second Year
    03=03 - Third Year
    04=04 - Fourth Year
    05=05 - Fifth Year
    06=06 - Sixth Year
    15 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    16 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: SSR_TERM_CAT_VW

    17 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2

    Prompt Table: SESSION_TBL_VW

    18 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID

    Prompt Table: SSR_PERIOD_TBL

    19 SSR_CR_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Type
    20=Enrollment
    30=Exam-only Course
    40=Transfer Credit - Course
    60=Transfer Credit - Test
    80=Transfer Credit - Other