RUN_CNTL_TRMAC1(SQL Table) |
Index Back |
---|---|
Term Activation Run CntlThis 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. |
# | 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 |