| # |
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 |
SCC_BRINCD_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table:
SCC_BRINCD_NLD
|
| 3 |
SAD_BR_EDU_SEC_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
Educational Sector
BO=Professional Education
ED=Education
VA=VAVO
Default Value: BO
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
SAD_BR_HAN_SEL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
BRON Handicap selection
A=Student Attribute
D=Service Indicator
T=Studentgroup
|
| 6 |
SAD_BR_HAN_VAL_NLD |
Character(20) |
VARCHAR2(20) NOT NULL |
BRON Handicap value
Prompt Table:
%EDITTABLE
|
| 7 |
STDNT_ATTR |
Character(4) |
VARCHAR2(4) NOT NULL |
Student Attribute
Prompt Table:
STDNT_ATTR_TBL
|
| 8 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 9 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 10 |
SAD_BR_USEPLAN_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Plans indicator. Used in the Dutch Bron Functionality for educational sector VAVO.
A=Academic Program
P=Academic Plan
S=Academic Subplan
|
| 11 |
SAD_BR_QUA_RET_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Qualification Retrieved From
A=Academic Program
T=Test Administration
|
| 12 |
SAD_BR_TRM_END_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Term End Date
E=Expected Graduation Date
O=End Date OWO
|
| 13 |
SAD_BR_HIG_PED_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Prior Education
A=Admissions Prior Education NLD
R=Student Prior Educations NLD
|
| 14 |
SAD_BR_BPV_FLD_DSC |
Character(18) |
VARCHAR2(18) NOT NULL |
BPV Field description selection for BPV organization
Prompt Table:
SAD_BPV_RECFLD
|
| 15 |
SAD_BR_BPVADDR_TYP |
Character(4) |
VARCHAR2(4) NOT NULL |
Selection of BPV address for BRON
Prompt Table:
SAD_ADDR_TP_NLD
|
| 16 |
SAD_BR_BPV_REC_DSC |
Character(15) |
VARCHAR2(15) NOT NULL |
BPV Organization description selection for BPV organization
Prompt Table:
PSRECDEFN
|
| 17 |
SAD_BR_306_C_PST |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppress Postal Changes
Y/N Table Edit
Default Value: N
|
| 18 |
SAD_BR_322_NO_SND |
Character(1) |
VARCHAR2(1) NOT NULL |
322 Do Not Send BPV
Y/N Table Edit
Default Value: N
|
| 19 |
SAD_BR_324_WO_DIPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Generic Tests W/O Dipl
Y/N Table Edit
Default Value: N
|
| 20 |
SCC_CAF_ATTRIB_NM |
Character(20) |
VARCHAR2(20) NOT NULL |
Common Attribute
Prompt Table:
SAD_BR_AIRCF_VW
|
| 21 |
SSR_RSLT_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Result Type
Prompt Table:
SAD_BR_RSLT_VW
|
| 22 |
SSR_RES_MAP_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Result Scale
Prompt Table:
SSR_RSLT_INST
|
| 23 |
GRADING_SCHEME |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table:
SAD_BR_GRDSC_VW
|
| 24 |
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:
SSR_RES_MPDTLVW
|
| 25 |
SAD_BR_RES_SCL_NLD |
Character(12) |
VARCHAR2(12) NOT NULL |
Result Scale
Prompt Table:
SSR_RSLT_INST
|
| 26 |
SAD_BR_GRD_SCH_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table:
SAD_BR_GDSCE_VW
|
| 27 |
SAD_BR_GRD_BAS_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
Prompt Table:
SAD_BR_MPDTL_VW
|
| 28 |
SAD_BR_HIST_NLD |
Number(3,0) |
SMALLINT NOT NULL |
Exclude Historical Changes Old
|