SSR_APT_RTK_VW

(SQL View)
 Index Back

APT Item


SELECT itm.EMPLID , itm.INSTITUTION , itm.SSR_APT_INSTANCE , itm.SSR_APT_ITEM_SEQ , itm.SSR_APT_ITEM_PAR , itm.SSR_APT_ITEM_FOR , itm.SSR_ITEM_ID , itm.SSR_ITEM_TYPE , ' ' , itm.SSR_GRADE_ITEM_FL , itm.SSR_ENRL_CAT , itm.SSR_ITEM_WEIGHT , itm.SSR_EXAM_ONLY_FL , itm.SSR_SUBSTITUTED_FL , itm.SSR_SATISFIED_FL , att.ATTEMPT_NBR , att.SSR_ATT_OUTCOME , att.SSR_RETAKE_ELIG , att.SSR_ATT_STAT , sch.SSR_SEQ_NBR , sch.SSR_YR_OF_PROG , sch.ACAD_YEAR , sch.STRM , sch.SESSION_CODE , sch.SSR_PERIOD_ID , sch.SSR_CR_TYPE FROM PS_SSR_APT_ITEM itm LEFT OUTER JOIN PS_SSR_APT_ATT att ON itm.EMPLID=att.EMPLID AND itm.INSTITUTION=att.INSTITUTION AND itm.SSR_APT_INSTANCE=att.SSR_APT_INSTANCE AND itm.SSR_APT_ITEM_SEQ=att.SSR_APT_ITEM_SEQ LEFT OUTER JOIN PS_SSR_APT_SCHD sch ON att.EMPLID=sch.EMPLID AND att.INSTITUTION=sch.INSTITUTION AND att.SSR_APT_INSTANCE=sch.SSR_APT_INSTANCE AND att.SSR_APT_ITEM_SEQ=sch.SSR_APT_ITEM_SEQ AND att.ATTEMPT_NBR=sch.ATTEMPT_NBR WHERE att.SSR_RETAKE_ELIG = 'Y' AND (att.ATTEMPT_NBR = ( SELECT MAX(att1.ATTEMPT_NBR) FROM PS_SSR_APT_ATT att1 WHERE att1.EMPLID = att.EMPLID AND att1.INSTITUTION = att.INSTITUTION AND att1.SSR_APT_INSTANCE = att.SSR_APT_INSTANCE AND att1.SSR_APT_ITEM_SEQ = att.SSR_APT_ITEM_SEQ) OR att.ATTEMPT_NBR < ( SELECT MAX(att2.ATTEMPT_NBR) FROM PS_SSR_APT_ATT att2 WHERE att2.EMPLID = att.EMPLID AND att2.INSTITUTION = att.INSTITUTION AND att2.SSR_APT_INSTANCE = att.SSR_APT_INSTANCE AND att2.SSR_APT_ITEM_SEQ = att.SSR_APT_ITEM_SEQ AND att2.ATTEMPT_NBR > att.ATTEMPT_NBR AND att2.SSR_RETAKE_ELIG = ' ') )

  • 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 SSR_APT_ITEM_PAR Number(6,0) INTEGER NOT NULL Parent Item Seq Nbr
    6 SSR_APT_ITEM_FOR Number(6,0) INTEGER NOT NULL Substitute for
    7 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID

    Prompt Table: SSR_AIR_HDR

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

    Prompt Table: SSR_ITEM_TYPE

    9 SSR_AIR_PAR_ITEM Character(11) VARCHAR2(11) NOT NULL AIR Parent Item ID
    10 SSR_GRADE_ITEM_FL Character(1) VARCHAR2(1) NOT NULL Grading Item Type

    Y/N Table Edit

    Default Value: N

    11 SSR_ENRL_CAT Character(4) VARCHAR2(4) NOT NULL Enrollment Category

    Prompt Table: SSR_ENRL_CAT

    12 SSR_ITEM_WEIGHT Number(3,0) SMALLINT NOT NULL Item Weight

    Default Value: 1

    13 SSR_EXAM_ONLY_FL Character(1) VARCHAR2(1) NOT NULL Exam Only Option
    E=Exclude in selection
    I=Included
    O=Exam Only Course

    Y/N Table Edit

    Default Value: N

    14 SSR_SUBSTITUTED_FL Character(1) VARCHAR2(1) NOT NULL Substituted

    Y/N Table Edit

    Default Value: N

    15 SSR_SATISFIED_FL Character(1) VARCHAR2(1) NOT NULL Satisfied
    N=No
    W=Waived
    Y=Yes

    Default Value: N

    16 ATTEMPT_NBR Number(3,0) SMALLINT NOT NULL Attempt Nbr
    17 SSR_ATT_OUTCOME Character(4) VARCHAR2(4) NOT NULL Attempt Outcome
    20=Not Passed
    40=Passed
    18 SSR_RETAKE_ELIG Character(1) VARCHAR2(1) NOT NULL Eligible for Retake
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    19 SSR_ATT_STAT Character(2) VARCHAR2(2) NOT NULL Attempt Status
    20=Activated
    60=Provisional
    80=Finalized
    20 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
    21 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
    22 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    23 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: SSR_TERM_CAT_VW

    24 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

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

    Prompt Table: SSR_PERIOD_TBL

    26 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