SSR_IAMRTNOTELN

(SQL View)
Index Back

IAM Rslt Note Vw Lang by Root

IAM Result Note View Language by Root

SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACT_ID_ROOTXRF , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_RSLT_SEQ , L.LANGUAGE_CD , A.SSR_DESCRLONG FROM PS_SSR_IAM_RSLTNTE A , PS_SSR_IAM_RNTELNG L WHERE A.EMPLID = L.EMPLID AND A.INSTITUTION = L.INSTITUTION AND A.SSR_ACTIVITY_ID = L.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = L.SSR_ACT_ID_SEQ_NBR AND A.SSR_RSLT_SEQ = L.SSR_RSLT_SEQ

  • Related Language Record for SSR_IAMRTNOTEVW
  • # 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_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    4 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    5 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number

    Default Value: 1

    6 SSR_RSLT_SEQ Number(3,0) SMALLINT NOT NULL Result Sequence Nbr

    Default Value: 1

    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 SSR_DESCRLONG Long Character CLOB Description