SSR_IAM_LOCERTV

(SQL View)
 Index Back

IAM Result View 1

IAM Result View 1

SELECT D.INSTITUTION , D.EMPLID , D.SSR_ACTIVITY_ID , D.SSR_ACT_ID_SEQ_NBR , D.SSR_RSLT_TYPE , D.SSR_RSLT_SEQ , D.SSR_IAM_RSLT_STAT , D.SSR_ACT_ID_ROOT , D.SSR_AC_CONTENT_TP , D.SSR_AC_EXAM_ONLY , D.ACAD_CAREER , D.STRM , D.SSR_PERIOD_ID , D.SSR_EFFDT , D.ACAD_ORG , D.SESSION_CODE , D.CRSE_ID , D.CRSE_OFFER_NBR , D.SUBJECT , D.CATALOG_NBR , D.SSR_APT_INSTANCE , D.DESCR FROM PS_SSR_IAM_RSLTVW2 D , PS_SSR_IAM_ROOTEXT E , PS_INSTITUTION_TBL F , PS_SSR_IAM G WHERE ( D.EMPLID = E.EMPLID AND D.INSTITUTION = E.INSTITUTION AND D.SSR_ACTIVITY_ID = E.SSR_ACTIVITY_ID AND D.SSR_ACT_ID_SEQ_NBR = E.SSR_ACT_ID_SEQ_NBR AND E.INSTITUTION = F.INSTITUTION AND F.EFFDT = ( SELECT MAX(H.EFFDT) FROM PS_INSTITUTION_TBL H WHERE F.INSTITUTION = H.INSTITUTION AND H.EFFDT <= %CurrentDateIn) AND ((E.SSR_IAM_LOCK = 'N' OR E.SSR_IAM_LOCK = ' ') OR (F.SSR_RSLT_PEAM = 'Y' AND E.SSR_IAM_LOCK = 'Y') ) AND D.EMPLID = G.EMPLID AND D.INSTITUTION = G.INSTITUTION AND D.SSR_ACTIVITY_ID = G.SSR_ACTIVITY_ID AND D.SSR_ACT_ID_SEQ_NBR = G.SSR_ACT_ID_SEQ_NBR AND ((G.SSR_IAM_LOCK = 'N' ) OR (F.SSR_RSLT_PEAM = 'Y' AND G.SSR_IAM_LOCK = 'Y' AND G.SSR_ACTIVITY_ID = G.SSR_ACT_ID_ROOT)))

  • 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_AC_EXAM_ONLY Character(1) VARCHAR2(1) NOT NULL Exam Only Course
    11 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
    12 STRM Character(4) VARCHAR2(4) NOT NULL Term
    13 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID
    14 SSR_EFFDT Date(10) DATE Effective Date
    15 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    16 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
    17 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    18 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    19 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    20 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    21 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number
    22 DESCR Character(30) VARCHAR2(30) NOT NULL Description