| REPEAT_CODE_TBL(SQL Table) | Index Back | 
|---|---|
| Repeat Code TableThis table contains valid values of Repeat properties | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | SetID Default Value: OPR_DEF_TBL_CS.SETID_CAREER Prompt Table: SETID_TBL | |
| 2 | Character(4) | VARCHAR2(4) NOT NULL | Repeat Scheme Prompt Table: REPEAT_SCHM_TBL | |
| 3 | Date(10) | DATE NOT NULL | Effective Date Default Value: %date | |
| 4 | Character(4) | VARCHAR2(4) NOT NULL | Repeat Code NTEA=No Taking Exam/Assessment | |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description Default Value: REPEAT_CODE_TBL.DESCR | 
| 7 | EARN_CREDIT | Character(1) | VARCHAR2(1) NOT NULL | Earn Credit Y/N Table Edit Default Value: Y | 
| 8 | UNITS_ATTEMPTED | Character(1) | VARCHAR2(1) NOT NULL | Units Attempted I=In Progress N=No Y=Yes Default Value: Y | 
| 9 | INCLUDE_IN_GPA | Character(1) | VARCHAR2(1) NOT NULL | Include in GPA Y/N Table Edit Default Value: Y | 
| 10 | PRINT_REPEAT_DESCR | Character(1) | VARCHAR2(1) NOT NULL | Print Repeat Description Y/N Table Edit Default Value: Y | 
| 11 | PRINT_REPEAT_DATE | Character(1) | VARCHAR2(1) NOT NULL | Print Repeat Date Y/N Table Edit Default Value: N | 
| 12 | DESCRFORMAL | Character(50) | VARCHAR2(50) NOT NULL | Formal Description field Default Value: REPEAT_CODE_TBL.DESCR | 
| 13 | SAA_DISPLAY_OPTION | Character(1) | VARCHAR2(1) NOT NULL | This field will control if items will print/display in Academic Advisement Reports N=Display Name O=Display Operator X=Do Not Display Y/N Table Edit Default Value: N | 
| 14 | SSR_INCL_GRD_RPTCK | Character(1) | VARCHAR2(1) NOT NULL | Flag to identify how repeat check would process a given grade value 1=1) Count = Y Process = Y 2=2) Count = Y Process = N 3=3) Count = N Process = Y 4=4) Count = N Process = N Default Value: 1 | 
| 15 | SSR_RPTCK_OVERLAY | Character(1) | VARCHAR2(1) NOT NULL | Allow to be overlaid Y/N Table Edit Default Value: Y | 
| 16 | SSR_RPTCK_BYPS_CUR | Character(1) | VARCHAR2(1) NOT NULL | Bypass Process if exists Y/N Table Edit Default Value: N |