RUN_CNTL_TRMAC1

(SQL Table)
Index Back

Term Activation Run Cntl

This run control record is used for SR Term Activation. It is one of five run control records used for term activation. This particular record contains some of the basic population control values as well as fields used for the update control feature and log control feature. All fields required to run the process are stored here.

  • Parent record: PRCSRUNCNTL
  • # 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 RUN_MODE Character(1) VARCHAR2(1) NOT NULL Created for the term activation process. Valid values are "U" (update only) and "I" (Insert only).
    I=Insert Only
    U=Update Only

    Default Value: I

    4 PRCS_SLCTN_CRTR Character(1) VARCHAR2(1) NOT NULL Selection Criteria
    C=Custom Population
    P=Panel Criteria
    S=Population Selection

    Default Value: P

    5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    6 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Default Value: OPR_DEF_TBL_CS.ACAD_CAREER

    7 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    8 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    9 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBL

    10 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    11 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group

    Prompt Table: STDNT_GROUP_TBL

    12 STDNT_TYPE Character(2) VARCHAR2(2) NOT NULL Student Type
    B=Both Continuing & New Students
    C=Continuing Students Only
    N=New Students Only

    Default Value: B

    13 START_DT Date(10) DATE Start Date
    14 END_DT Date(10) DATE end date
    15 COMMIT_FREQ Number(7,0) INTEGER NOT NULL Commit Frequency

    Default Value: 1000

    16 TRMAC_TUIT_CALC Character(1) VARCHAR2(1) NOT NULL Tuition Calc Required
    B=Business Unit Table
    C=No Change
    N=No
    Y=Yes

    Default Value: B

    17 TRMAC_FA_CALC Character(1) VARCHAR2(1) NOT NULL FA Stats Calc Required
    C=No Change
    D=Default Behavior
    N=No
    Y=Yes

    Default Value: D

    18 TRMAC_FRM_OF_STUDY Character(4) VARCHAR2(4) NOT NULL Form of Study
    ABRD=Study Abroad
    CAND=Advanced to Candidacy
    DEFL=Default Behavior
    DTCH=Detached Study
    ENRL=Class Enrollment
    NOCH=No Change

    Default Value: DEFL

    19 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    P=Enrolled Part-Time
    T=Three Quarter Time

    Default Value: F

    20 TRMAC_ELIG_ENRL Character(1) VARCHAR2(1) NOT NULL Eligible to Enroll
    C=No Change
    D=Default Behavior
    N=No
    Y=Yes

    Default Value: D

    21 REFRESH_TERM_DT Character(1) VARCHAR2(1) NOT NULL Refresh Term Cntrl Dates
    N=No
    Y=Yes

    Default Value: N

    22 TERM_CONNECT_TYPE Character(3) VARCHAR2(3) NOT NULL Connector Type
    AND=AND
    OR=OR

    Default Value: AND

    23 LOG_ACTV_STDNT Character(1) VARCHAR2(1) NOT NULL Activated Students

    Y/N Table Edit

    Default Value: Y

    24 LOG_ACTV_DTL Character(1) VARCHAR2(1) NOT NULL Activated Student Detail

    Y/N Table Edit

    Default Value: N

    25 LOG_EXCL_STDNT Character(1) VARCHAR2(1) NOT NULL Excluded Students

    Y/N Table Edit

    Default Value: Y

    26 LOG_EXCL_DTL Character(1) VARCHAR2(1) NOT NULL Excluded Student Detail

    Y/N Table Edit

    Default Value: N

    27 LOG_RUN_CRTR Character(1) VARCHAR2(1) NOT NULL Run Criteria

    Y/N Table Edit

    Default Value: Y

    28 GLBL_EXCLSN_RULE Character(8) VARCHAR2(8) NOT NULL Global Exclusion Rule

    Prompt Table: TRMAC_GLBL_EXCL