| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Default Value: OPR_DEF_TBL_CS.ACAD_PROG
Prompt Table:
ACAD_PROG_TBL
|
| 3 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table:
ACAD_PLAN_TBLVW
|
| 4 |
TRNSFR_SRC_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Source ID
|
| 5 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 6 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
DEF_RULE_SRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Rule Source Type
E=External Organization
I=Institution
|
| 9 |
DEF_RULE_SRC_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Default Rule Source ID
Prompt Table:
%EDITTABLE7
|
| 10 |
CRS_TRNSFR_EQVLNCY |
Character(6) |
VARCHAR2(6) NOT NULL |
Default Transfer Equivalency
Prompt Table:
EXT_TRNSFR_D_VW
|
| 11 |
OVR_RULE_SRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rule Source Type
E=External Organization
I=Institution
|
| 12 |
OVR_RULE_SRC_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Override Rule Source ID
Prompt Table:
%EDITTABLE8
|
| 13 |
CRS_OVRRD_EQVLNCY |
Character(6) |
VARCHAR2(6) NOT NULL |
Course Override Equivalency
Prompt Table:
EXT_TRNSFR_O_VW
|
| 14 |
AGR_RULE_SRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Agreement Rule Source Type
E=External Organization
I=Institution
|
| 15 |
AGR_RULE_SRC_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Agreement Source ID
Prompt Table:
%EDITTABLE9
|
| 16 |
CRS_AGRMNT_EQVLNCY |
Character(6) |
VARCHAR2(6) NOT NULL |
Course Agreement Equivalency
Prompt Table:
EXT_TRNSFR_A_VW
|
| 17 |
GRADING_SCHEME |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table:
GRADESCHEME_TBL
|
| 18 |
GRADING_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
ANC=ABC/NC Grading
AUD=Audit
BMT=Multi-Term Course: Not Graded
CNC=Credit / No Credit
EQV=Equivalent
GRD=Graded
HSC=Hundred Point Scale (NLD)
LAW=Law
MED=Medical School Grades
NOG=No Grade Associated
NON=Non-Graded Component
NQF=NQF Scale
OPT=Student Option
PNP=Pass/Not Pass
SUS=Satisfactory/Unsatisfactory
TRN=Transfer Grading Basis
TSC=Ten Point Scale (NLD)
Prompt Table:
GRADE_BASE_TCVW
|
| 19 |
GRADE_TRANSFER |
Character(3) |
VARCHAR2(3) NOT NULL |
Default Grade- Transfer Credit
Prompt Table:
GRD_NO_CNV_VW
|
| 20 |
TRNSFR_HS_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer HS Courses
Y/N Table Edit
Default Value: N
|