SSR_IAMRSCRSVW1

(SQL View)
Index Back

IAM Result View for Course

IAM Result View for Course Content Type

SELECT INSTITUTION , EMPLID , SSR_ACTIVITY_ID , SSR_ACT_ID_SEQ_NBR , SSR_RSLT_TYPE , SSR_RSLT_SEQ , SSR_IAM_RSLT_STAT , SSR_ACT_ID_ROOT , SSR_AC_CONTENT_TP , SSR_COMPONENT , SSR_PERIOD_ID , SSR_AC_EXAM_ONLY , ACAD_CAREER , STRM , SSR_EFFDT , ACAD_ORG , SESSION_CODE , CRSE_ID , CRSE_OFFER_NBR , SUBJECT , CATALOG_NBR , CLASS_NBR , SSR_APT_INSTANCE , SSR_APT_ITEM_SEQ , DESCR , SSR_ACAD_PROG_FLAG , ROW_NUMBER() OVER(PARTITION BY INSTITUTION , EMPLID , SSR_ACTIVITY_ID , SSR_ACT_ID_SEQ_NBR , SSR_RSLT_TYPE , SSR_RSLT_SEQ ORDER BY SSR_ACAD_PROG_FLAG , SSR_APT_INSTANCE) AS SSR_APT_PRI_NUM FROM PS_SSR_IAM_RSCRSVW

  • Related Language Record: SSR_IAMRCRVW1LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    4 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number
    5 SSR_RSLT_TYPE Character(20) VARCHAR2(20) NOT NULL Result Type
    6 SSR_RSLT_SEQ Number(3,0) SMALLINT NOT NULL Result Sequence Nbr
    7 SSR_IAM_RSLT_STAT Character(2) VARCHAR2(2) NOT NULL Result Status
    00=00-Undetermined
    05=05-Manual
    07=07-Imported
    10=10-Calculated
    20=20-Awaiting Approval
    30=30-Approved
    40=40-Overridden
    50=50-Final
    8 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    9 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type
    10 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
    CLN=Clinical
    CON=Continuance
    DIS=Discussion
    FLD=Field Studies
    IND=Independent Study
    LAB=Laboratory
    LEC=Lecture
    PRA=Practicum
    RSC=Research
    SEM=Seminar
    SUP=Supervision
    THE=Thesis Research
    TUT=Tutorial
    11 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID
    12 SSR_AC_EXAM_ONLY Character(1) VARCHAR2(1) NOT NULL Exam Only Course
    13 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    14 STRM Character(4) VARCHAR2(4) NOT NULL Term
    15 SSR_EFFDT Date(10) DATE Effective Date
    16 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    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
    18 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    19 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    20 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    21 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    22 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    23 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number
    24 SSR_APT_ITEM_SEQ Number(6,0) INTEGER NOT NULL APT Item Seq
    25 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    26 SSR_ACAD_PROG_FLAG Number(1,0) SMALLINT NOT NULL Primary Academic Program Flag
    27 SSR_APT_PRI_NUM Number(3,0) SMALLINT NOT NULL APT Priority Number