SSR_IAM_RSLTVW1

(SQL View)
 Index Back

IAM Result View 1

IAM Result View 1

SELECT A.INSTITUTION , A.EMPLID , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_RSLT_TYPE , A.SSR_RSLT_SEQ , A.SSR_IAM_RSLT_STAT , A.SSR_ACT_ID_ROOT , A.SSR_AC_CONTENT_TP , A.SSR_COMPONENT , A.SSR_PERIOD_ID , A.SSR_AC_EXAM_ONLY , A.ACAD_CAREER , A.STRM , A.SSR_EFFDT , A.ACAD_ORG , A.SESSION_CODE , A.CRSE_ID , A.CRSE_OFFER_NBR , A.SUBJECT , A.CATALOG_NBR , A.SSR_APT_INSTANCE , A.SSR_APT_ITEM_SEQ , A.DESCR FROM PS_SSR_IAMRSCRSVW1 A WHERE A.SSR_APT_PRI_NUM = 1 UNION SELECT B.INSTITUTION , B.EMPLID , B.SSR_ACTIVITY_ID , B.SSR_ACT_ID_SEQ_NBR , B.SSR_RSLT_TYPE , B.SSR_RSLT_SEQ , B.SSR_IAM_RSLT_STAT , B.SSR_ACT_ID_ROOT , B.SSR_AC_CONTENT_TP , B.SSR_COMPONENT , B.SSR_PERIOD_ID , B.SSR_AC_EXAM_ONLY , B.ACAD_CAREER , B.STRM , B.SSR_EFFDT , B.ACAD_ORG , B.SESSION_CODE , B.CRSE_ID , B.CRSE_OFFER_NBR , B.SUBJECT , B.CATALOG_NBR , B.SSR_APT_INSTANCE , B.SSR_APT_ITEM_SEQ , B.DESCR FROM PS_SSR_IAMRSOTHVW1 B WHERE B.SSR_APT_PRI_NUM = 1

  • Related Language Record: SSR_IAM_RTVW1LN

    • # 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 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number
    23 SSR_APT_ITEM_SEQ Number(6,0) INTEGER NOT NULL APT Item Seq
    24 DESCR Character(30) VARCHAR2(30) NOT NULL Description