SSR_IAM_RTVW1LN

(SQL View)
Index Back

Rel Lang for SSR_IAM_RSLTVW1

Rel Lang for SSR_IAM_RSLTVW1

SELECT A.INSTITUTION , A.EMPLID , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_RSLT_TYPE , A.SSR_RSLT_SEQ , A.LANGUAGE_CD , A.DESCR FROM PS_SSR_IAMRCRVW1LN A 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.LANGUAGE_CD , B.DESCR FROM PS_SSR_IAMROTVW1LN B

  • Related Language Record for SSR_IAM_LOCERTV SSR_IAM_LOCRSTV SSR_IAM_RSLTVW1
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description