SSR_APT_ITEM_V3

(SQL View)
 Index Back

APT Item


SELECT a.EMPLID , a.INSTITUTION , a.SSR_APT_INSTANCE , a.SSR_APT_ITEM_SEQ , a.SSR_APT_ITEM_PAR , a.SSR_APT_ITEM_FOR , a.SSR_ITEM_ID , a.SSR_ITEM_TYPE , ' ' /* , a.SSR_AIR_PAR_ITEM */ , a.SSR_GRADE_ITEM_FL , a.SSR_ENRL_CAT , a.SSR_ITEM_WEIGHT , a.SSR_EXAM_ONLY_FL , a.SSR_SUBSTITUTED_FL , a.SSR_SATISFIED_FL , b.ATTEMPT_NBR , b.SSR_ATT_OUTCOME , b.SSR_RETAKE_ELIG , b.SSR_ATT_STAT , b.CRSE_ID , c.SSR_SEQ_NBR , c.SSR_YR_OF_PROG , c.ACAD_YEAR , c.STRM , c.SESSION_CODE , c.SSR_PERIOD_ID , c.SSR_CR_TYPE , c.ssr_att_prgrs_lvl FROM PS_SSR_APT_ITEM a LEFT OUTER JOIN PS_SSR_APT_ATT b ON 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 LEFT OUTER JOIN PS_SSR_APT_SCHD C ON b.EMPLID=c.EMPLID AND b.INSTITUTION=c.INSTITUTION AND b.SSR_APT_INSTANCE=c.SSR_APT_INSTANCE AND b.SSR_APT_ITEM_SEQ=c.SSR_APT_ITEM_SEQ AND b.ATTEMPT_NBR=c.ATTEMPT_NBR

  • 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 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    21 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
    22 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
    23 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    24 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: SSR_TERM_CAT_VW

    25 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

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

    Prompt Table: SSR_PERIOD_TBL

    27 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
    28 SSR_ATT_PRGRS_LVL Character(2) VARCHAR2(2) NOT NULL Progress Level
    00=00-Newly Added
    20=20-Planned
    40=40-In Progress
    60=60-Completed
    80=80-Dropped