| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 2 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
SAD_PB_PART_INST |
Character(11) |
VARCHAR2(11) NOT NULL |
Partner Institution
Prompt Table:
EXT_ORG_TBL_VW
|
| 5 |
SAD_PB_OVRS_INST |
Character(11) |
VARCHAR2(11) NOT NULL |
Overseas Institution
Prompt Table:
SAD_PB_OINSTVW
|
| 6 |
SAD_PB_WRK_PLAC |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Placement
Prompt Table:
XL_PSYESNO_VW
|
| 7 |
SAD_PB_ACCOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Accomodation Provided
Prompt Table:
XL_PSYESNO_VW
|
| 8 |
SAD_PB_PLAC_ORG |
Character(11) |
VARCHAR2(11) NOT NULL |
Placement Organisation
Prompt Table:
EXT_ORG_TBL_VW
|
| 9 |
SAD_PB_ATAS_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
ATAS Certificate Required
Prompt Table:
XL_PSYESNO_VW
|
| 10 |
SAD_PB_DEAN_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Dean's Certificate Required
Prompt Table:
XL_PSYESNO_VW
|
| 11 |
SAD_PB_1YR_CRSFEE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
First Year Course Fees
|
| 12 |
SAD_PB_1YR_BRDFEE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
First Year Boarding Fees
|
| 13 |
SAD_PB_ACCOM_FEES |
Character(1) |
VARCHAR2(1) NOT NULL |
Accomodation Fees Included
Prompt Table:
XL_PSYESNO_VW
|
| 14 |
SAD_PB_MONTH_DUR |
Number(2,0) |
SMALLINT NOT NULL |
Months Duration
|
| 15 |
SAD_PB_CRSE_HRS |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Course Hours
|
| 16 |
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%
|
| 17 |
SAD_PB_PLAC_JUST |
Long Character(1000) |
VARCHAR2(1000) |
Placement Justification
|
| 18 |
SAD_PB_SELT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
SELT Required
N=No
Y=Yes
Prompt Table:
XL_PSYESNO_VW
|
| 19 |
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
|