TRNSFR_TO_VW

(SQL View)
 Index Back

External Transfer Source View

View to handle Transfer Credit Component Subject Area Copy Function

SELECT A.OPRID ,A.RUN_CNTL_ID ,A.INSTITUTION ,A.FROM_SEQ_NBR ,B.TRNSFR_EQVLNCY_CMP ,C.CRSE_ID ,A.TRNSFR_SRC_ID ,A.COMP_SUBJECT_AREA ,A.EFFDT , C.CRSE_OFFER_NBR , C.UNT_TAKEN FROM PS_RUNCNTL_XFR_HDR A , PS_RUNCNTL_XFR_D2 B , PS_TRNSFR_TO C 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 C.INSTITUTION = A.INSTITUTION AND C.TRNSFR_SRC_ID = A.TRNSFR_SRC_ID AND C.COMP_SUBJECT_AREA = A.COMP_SUBJECT_AREA AND C.EFFDT = A.EFFDT AND C.TRNSFR_EQVLNCY_CMP = B.TRNSFR_EQVLNCY_CMP

  • Parent record: 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

    Prompt Table: INSTITUTION_TBL

    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 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    7 TRNSFR_SRC_ID Character(11) VARCHAR2(11) NOT NULL Source ID

    Prompt Table: TRNSFR_SRCID_VW

    8 COMP_SUBJECT_AREA Character(16) VARCHAR2(16) NOT NULL Component Subject Area

    Prompt Table: TRNSFR_COMP_VW

    9 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    Prompt Table: TRNSFR_C_EFF_VW

    10 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    11 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken