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 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID_CAREER Prompt Table: SETID_TBL |
2 | REPEAT_SCHEME | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Scheme
Prompt Table: REPEAT_SCHM_TBL |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | REPEAT_CODE | 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 |