RUNCNTL_XRD2_VL

(SQL View)
 Index Back

Transfer Credit Copy Dtl 2

This table is used by Transfer Credit Copy Function. This is a related language record (view) for RUNCNTL_XRD2_VL.

SELECT A.OPRID , A.RUN_CNTL_ID , A.INSTITUTION , A.FROM_SEQ_NBR , A.TRNSFR_EQVLNCY_CMP , B.LANGUAGE_CD , B.DESCR FROM PS_RUNCNTL_XFR_D2 A ,PS_RUNCNTL_XFR_D2L B WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID AND A.INSTITUTION = B.INSTITUTION AND A.FROM_SEQ_NBR = B.FROM_SEQ_NBR AND A.TRNSFR_EQVLNCY_CMP = B.TRNSFR_EQVLNCY_CMP

  • Related Language Record for RUNCNTL_XRD2_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    4 FROM_SEQ_NBR Number(3,0) SMALLINT NOT NULL From Sequence Number
    5 TRNSFR_EQVLNCY_CMP Character(4) VARCHAR2(4) NOT NULL Equiv Component
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description