REPEAT_RULE(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | 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 Prompt Table: ACAD_CAR_TBL |
3 | REPEAT_RULE | Character(10) | VARCHAR2(10) NOT NULL | Repeat Rule |
4 | EFFECTIVE_TERM | Character(4) | VARCHAR2(4) NOT NULL |
Effective Term
Prompt Table: TERM_TBL |
5 | TOT_ATT_IN_RANGE | Number(2,0) | SMALLINT NOT NULL | Total Attempts Allowed |
6 | REPEAT_ATT_VIOL | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code Violated
Prompt Table: REPEAT_CODE_TBL |
7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: REPEAT_RULE.DESCR |
9 | ENRL_ERROR_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Message
E=Error I=Ignore W=Warning |
10 | REPEAT_1 | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code 1
Prompt Table: REPEAT_CODE_TBL |
11 | REPEAT_2 | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code 2
Prompt Table: REPEAT_CODE_TBL |
12 | REPEAT_3 | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code 3
Prompt Table: REPEAT_CODE_TBL |
13 | REPEAT_4 | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code 4
Prompt Table: REPEAT_CODE_TBL |
14 | REPEAT_5 | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code 5
Prompt Table: REPEAT_CODE_TBL |
15 | REPEAT_6 | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code 6
Prompt Table: REPEAT_CODE_TBL |
16 | REPEAT_7 | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code 7
Prompt Table: REPEAT_CODE_TBL |
17 | REPEAT_8 | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code 8
Prompt Table: REPEAT_CODE_TBL |
18 | UNITS_REPEAT_LIMIT | Number(6,2) | DECIMAL(5,2) NOT NULL | Total Units Allowed |
19 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL |
Description of length 254
Default Value: REPEAT_RULE.DESCR |
20 | SSR_RPTCK_OPT_01 | Character(2) | VARCHAR2(2) NOT NULL |
1st Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |
21 | SSR_RPTCK_OPT_02 | Character(2) | VARCHAR2(2) NOT NULL |
2nd Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |
22 | SSR_RPTCK_OPT_03 | Character(2) | VARCHAR2(2) NOT NULL |
3rd Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |
23 | SSR_RPTCK_OPT_04 | Character(2) | VARCHAR2(2) NOT NULL |
4th Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |
24 | SSR_RPTCK_OPT_05 | Character(2) | VARCHAR2(2) NOT NULL |
5th Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |
25 | SSR_RPTCK_OPT_06 | Character(2) | VARCHAR2(2) NOT NULL |
6th Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |
26 | SSR_RPTCK_OPT_07 | Character(2) | VARCHAR2(2) NOT NULL |
7th Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |
27 | SSR_RPTCK_OPT_08 | Character(2) | VARCHAR2(2) NOT NULL |
8th Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |
28 | SSR_RPTCK_OPT_09 | Character(2) | VARCHAR2(2) NOT NULL |
9th Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |
29 | SSR_RPTCK_OPT_10 | Character(2) | VARCHAR2(2) NOT NULL |
10th Option
BG=Best Grade Points Per Unit CX=From Course Transfer Credit EC=Earn Credit Flag = Y EN=From Enrollment IA=Include in GPA = Y MD=Most Recent Date MT=Most Recent Term OX=From Other Transfer Credit TX=From Test Transfer Credit UA=Units Attempted = Y WG=Worst Grade Points Per Unit |