RUNCNTL_XFR_HDR

(SQL Table)
Index Back

Transfer Credit Copy Hdr

This table is used by Transfer Credit Copy Function.

  • Related Language Record: RUNCNTL_XFR_HDL
  • Parent Record Of RUNCNTL_XFR_D2 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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 FROM_SEQ_NBR Number(3,0) SMALLINT NOT NULL From Sequence Number
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 TRNSFR_SRC_ID Character(11) VARCHAR2(11) NOT NULL Source ID

    Prompt Table: TRNSFR_SRCID_VW

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

    Prompt Table: TRNSFR_COMP_VW

    8 EFFDT Date(10) DATE NOT NULL Effective Date

    Prompt Table: TRNSFR_C_EFF_VW

    9 TRNSFR_EQV_CMP_FRM Character(4) VARCHAR2(4) NOT NULL From Component Seq#
    10 TRNSFR_EQV_CMP_TO Character(4) VARCHAR2(4) NOT NULL To Component Seq#
    11 TO_COMP_SUBJ_AREA Character(16) VARCHAR2(16) NOT NULL To Component Subject Area
    12 EFFDT_TO Date(10) DATE NOT NULL Effective Date To
    13 SELECT_ALL Character(1) VARCHAR2(1) NOT NULL Select All

    Default Value: N

    14 FILTER_SELECTION Character(1) VARCHAR2(1) NOT NULL Filter Selection

    Default Value: N

    15 RUN_STATUS_CD Character(1) VARCHAR2(1) NOT NULL Run Status Code
    C=Completed
    E=Ran With Errors
    I=In Process
    N=Not Run

    Default Value: I

    16 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    17 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    18 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

    Prompt Table: SCHL_SUBJ_TRVW

    19 BREAK_BY_SUBJECT Character(1) VARCHAR2(1) NOT NULL Break by Incoming Subject

    Y/N Table Edit

    Default Value: N