| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 3 |
SAD_PB_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Type
A=Applicant
S=Student
Default Value: A
|
| 4 |
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:
%EDITTABLE
|
| 5 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
Prompt Table:
%EDITTABLE2
|
| 6 |
SAD_PB_REC_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Record Number
|
| 7 |
ADM_APPL_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Application Nbr
Prompt Table:
%EDITTABLE4
|
| 8 |
APPL_PROG_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Application Program Nbr
Prompt Table:
%EDITTABLE5
|
| 9 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 10 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 11 |
SAD_PB_UPLOAD |
Character(4) |
VARCHAR2(4) NOT NULL |
New CAS Record
LCMP=Upload Complete
LRDY=Upload Ready
NEW=New
|
| 12 |
SAD_PB_UPL_FILEID |
Character(50) |
VARCHAR2(50) NOT NULL |
Upload File ID Override
|
| 13 |
SAD_PB_UPDATE |
Character(4) |
VARCHAR2(4) NOT NULL |
Update Status
DCMP=Update Complete
DRDY=Update Ready
DRQD=Update Required
|
| 14 |
SAD_PB_UPD_FILEID |
Character(50) |
VARCHAR2(50) NOT NULL |
Update File ID Override
|
| 15 |
SAD_PB_EXP_FILEID |
Character(50) |
VARCHAR2(50) NOT NULL |
Export File ID
|
| 16 |
SAD_PB_REPORT |
Character(4) |
VARCHAR2(4) NOT NULL |
Report Status
RCMP=Report Complete
RRDY=Report Ready
|
| 17 |
SAD_PB_REP_FILEID |
Character(50) |
VARCHAR2(50) NOT NULL |
Report File ID Override
|
| 18 |
UPDATE_DT |
Date(10) |
DATE NOT NULL |
Last Updated
Default Value: %date
|
| 19 |
UPDATED_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated UserID
|
| 20 |
SAD_PB_CAS_NUMBER |
Character(14) |
VARCHAR2(14) NOT NULL |
CAS Number
|
| 21 |
SAD_PB_CAS_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
CAS Status
ASG=ASSIGNED
CNC=CANCELLED
EXP=EXPIRED
OBS=OBSOLETE
USD=USED
WDR=WITHDRAWN
|
| 22 |
SAD_PB_CAS_STATDT |
Date(10) |
DATE |
CAS Status Date
|
| 23 |
SAD_PB_REP_YRONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Year Only
Y/N Table Edit
Default Value: N
|
| 24 |
SAD_PB_REP_YRMONTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Year/Month Only
Y/N Table Edit
Default Value: N
|
| 25 |
SAD_PB_PART_INST |
Character(11) |
VARCHAR2(11) NOT NULL |
Partner Institution
Prompt Table:
SAD_PB_EX_ORGVW
|
| 26 |
SAD_PB_OVRS_INST |
Character(11) |
VARCHAR2(11) NOT NULL |
Overseas Institution
Prompt Table:
SAD_PB_OINSTVW1
|
| 27 |
SAD_PB_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Nationality
|
| 28 |
PASSPORT_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Passport Number
|
| 29 |
SAD_PB_REP_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Reported Plan
Prompt Table:
%EDITTABLE3
|
| 30 |
SAD_PB_CTITLE_OVR |
Character(250) |
VARCHAR2(250) NOT NULL |
Course Title Override
|
| 31 |
SAD_PB_REP_SITE |
Character(10) |
VARCHAR2(10) NOT NULL |
Reported Site
Prompt Table:
CAMPUS_LOC_VW
|
| 32 |
SAD_PB_ACAD_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Level
20=SCQF level 6
21=SCQF level 7
22=SCQF level 8
23=SCQF level 9
24=SCQF level 10
25=SCQF level 11
26=SCQF level 12
27=SCQF level 12 - DES
3=QCF / NQF level 3
4=QCF / NQF level 4
40=CEFR A2
41=CEFR B1
42=CEFR B2
43=CEFR C1
44=CEFR C2
5=QCF / NQF level 5
6=QCF / NQF level 6
7=QCF / NQF level 7
8=QCF / NQF level 8
9=QCF / NQF level 8 - DES
|
| 33 |
SAD_PB_SACAD_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Secondary Academic Level
Prompt Table:
SAD_PB_ACDLVLVW
|
| 34 |
SAD_PB_CRS_STARTDT |
Date(10) |
DATE |
Course start date
|
| 35 |
SAD_PB_LAT_ACCPTDT |
Date(10) |
DATE |
Latest Acceptance Date
|
| 36 |
SAD_PB_EXP_ENROLDT |
Date(10) |
DATE |
Expected Enrollment
|
| 37 |
SAD_PB_EXP_ENDDT |
Date(10) |
DATE |
Expected End
|
| 38 |
SAD_PB_MONTH_DUR |
Number(2,0) |
SMALLINT NOT NULL |
Months Duration
|
| 39 |
SAD_PB_FT_CRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Course
Prompt Table:
XL_PSYESNO_VW
|
| 40 |
SAD_PB_CRSE_HRS |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Course Hours
|
| 41 |
SAD_PB_PLAC_ORG |
Character(11) |
VARCHAR2(11) NOT NULL |
Placement Organisation
Prompt Table:
EXT_ORG_TBL_VW
|
| 42 |
SAD_PB_WRK_PLAC |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Placement
Prompt Table:
XL_PSYESNO_VW
|
| 43 |
SAD_PB_ACCOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Accomodation Provided
Prompt Table:
XL_PSYESNO_VW
|
| 44 |
SAD_PB_1YR_CRSFEE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
First Year Course Fees
|
| 45 |
SAD_PB_CRSFEE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
First Year Course Fees
Default Value: 0
|
| 46 |
SAD_PB_ACCOM_FEES |
Character(1) |
VARCHAR2(1) NOT NULL |
Accomodation Fees Included
Prompt Table:
XL_PSYESNO_VW
|
| 47 |
SAD_PB_ACCFEE_PAID |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
First Year Course Fees
Default Value: 0
|
| 48 |
SAD_PB_1YR_BRDFEE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
First Year Boarding Fees
|
| 49 |
SAD_PB_BRDFEE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
First Year Course Fees
Default Value: 0
|
| 50 |
SAD_PB_OFF_DOCS |
Long Character(2000) |
VARCHAR2(2000) |
Offer Documents
|
| 51 |
SAD_PB_ATAS_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
ATAS Certificate Required
Prompt Table:
XL_PSYESNO_VW
|
| 52 |
SAD_PB_DEAN_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Dean's Certificate Required
Prompt Table:
XL_PSYESNO_VW
|
| 53 |
SAD_PB_PREV_UKSTD |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous UK Study
N=No
Y=Yes
|
| 54 |
SAD_PB_PROG_JUST |
Long Character(1000) |
VARCHAR2(1000) |
Progression Justification
|
| 55 |
SAD_PB_SELT_NOTREQ |
Character(4) |
VARCHAR2(4) NOT NULL |
Reason SELT Not Required
A=Gifted student
B=English speaking country
C=English speaking degree
D=HEI sponsor assessment
E=Switch from Child to General
|
| 56 |
SAD_PB_SELT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
SELT Required
N=No
Y=Yes
|
| 57 |
SAD_PB_TRAIN_PROV |
Character(4) |
VARCHAR2(4) NOT NULL |
Test Provider
A=Cambridge ESOL
B=City and Guilds
C=Education Testing Service ETS
D=Pearson
E=Trinity
|
| 58 |
SAD_PB_CURR_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Current Level Comparison
H=Higher
L=Lower
S=Same
|
| 59 |
SAD_PB_ENG_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
English Level Attained
A2=CEFR level A2
B1=CEFR level B1
B2=CEFR level B2
C1=CEFR level C1
C2=CEFR level C2
|
| 60 |
SAD_PB_PREV_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Previous Academic Level
20=SCQF level 6
21=SCQF level 7
22=SCQF level 8
23=SCQF level 9
24=SCQF level 10
25=SCQF level 11
26=SCQF level 12
27=SCQF level 12 - DES
3=QCF / NQF level 3
4=QCF / NQF Level 4
40=CEFR A2
41=CEFR B1
42=CEFR B2
43=CEFR C1
44=CEFR C2
5=QCF / NQF Level 5
6=QCF / NQF Level 6
7=QCF / NQF Level 7
8=QCF / NQF Level 8
9=QCF / NQF level 8 - DES
|
| 61 |
SAD_PB_PLAC_JUST |
Long Character(1000) |
VARCHAR2(1000) |
Placement Justification
|
| 62 |
SAD_PB_PLAC_PERC |
Character(4) |
VARCHAR2(4) NOT NULL |
Placement Percentage
005=5%
010=10%
015=15%
020=20%
025=25%
030=30%
033=33%
035=35%
040=40%
045=45%
050=50%
055=55%
060=60%
065=65%
070=70%
075=75%
080=80%
085=85%
090=90%
095=95%
100=100%
Prompt Table:
SAD_PB_PERC_VW
|
| 63 |
SAD_PB_SELT_LISTEN |
Character(4) |
VARCHAR2(4) NOT NULL |
Placement Percentage
A2=CEFR level A2
B1=CEFR level B1
B2=CEFR level B2
C1=CEFR level C1
C2=CEFR level C2
|
| 64 |
SAD_PB_SELT_READ |
Character(4) |
VARCHAR2(4) NOT NULL |
Placement Percentage
A2=CEFR level A2
B1=CEFR level B1
B2=CEFR level B2
C1=CEFR level C1
C2=CEFR level C2
|
| 65 |
SAD_PB_SELT_SPEAK |
Character(4) |
VARCHAR2(4) NOT NULL |
Placement Percentage
A2=CEFR level A2
B1=CEFR level B1
B2=CEFR level B2
C1=CEFR level C1
C2=CEFR level C2
|
| 66 |
SAD_PB_SELT_WRITE |
Character(4) |
VARCHAR2(4) NOT NULL |
Placement Percentage
A2=CEFR level A2
B1=CEFR level B1
B2=CEFR level B2
C1=CEFR level C1
C2=CEFR level C2
|
| 67 |
SAD_PB_GRADUATE |
Character(4) |
VARCHAR2(4) NOT NULL |
Graduate Status
GELG=Graduate Eligible
GINE=Graduate Ineligible
GREP=Graduate Reported
|
| 68 |
SAD_PB_GRD_FILEID |
Character(50) |
VARCHAR2(50) NOT NULL |
Graduate File ID
|
| 69 |
SAD_PB_GRD_NOTES |
Long Character(1000) |
VARCHAR2(1000) |
Graduate Notes
|