SAD_PB_CONFIG(SQL Table) |
Index Back |
---|
# | 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 | SAD_PB_SLN | Character(9) | VARCHAR2(9) NOT NULL | Sponser Licence Number |
3 | SAD_PB_TIERID | Character(1) | VARCHAR2(1) NOT NULL |
Tier ID
4=Tier 4 |
4 | SAD_PB_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Category
C=Child G=General |
5 | SAD_PB_SCHEMAID | Character(1) | VARCHAR2(1) NOT NULL |
Schema ID
C=T4Child Ready To Go G=T4General Ready To Go |
6 | SSR_HE_SPLAN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Subplan
Y/N Table Edit Default Value: N |
7 | SAD_PB_MAIN_SITE | Character(10) | VARCHAR2(10) NOT NULL |
Main Site of Study
Prompt Table:
LOCATION_VW
|
8 | SAD_PB_WRK_PLAC | Character(1) | VARCHAR2(1) NOT NULL |
Work Placement
Prompt Table: XL_PSYESNO_VW |
9 | SAD_PB_ATAS_CERT | Character(1) | VARCHAR2(1) NOT NULL |
ATAS Certificate Required
Prompt Table: XL_PSYESNO_VW |
10 | SAD_PB_ACCOM | Character(1) | VARCHAR2(1) NOT NULL |
Accomodation Provided
Prompt Table: XL_PSYESNO_VW |
11 | SAD_PB_DEAN_CERT | Character(1) | VARCHAR2(1) NOT NULL |
Dean's Certificate Required
Prompt Table: XL_PSYESNO_VW |
12 | SAD_PB_1YR_CRSFEE | Number(10,2) | DECIMAL(9,2) NOT NULL | First Year Course Fees |
13 | SAD_PB_1YR_BRDFEE | Number(10,2) | DECIMAL(9,2) NOT NULL | First Year Boarding Fees |
14 | SAD_PB_ACCOM_FEES | Character(1) | VARCHAR2(1) NOT NULL |
Accomodation Fees Included
Prompt Table: XL_PSYESNO_VW |
15 | SAD_PB_UPLOAD | Character(4) | VARCHAR2(4) NOT NULL |
New CAS Record
LCMP=Upload Complete LRDY=Upload Ready NEW=New Prompt Table: SAD_PB_UPLSTVW |
16 | SAD_PB_UPLRDY | Character(4) | VARCHAR2(4) NOT NULL |
Upload Ready
Prompt Table: SAD_PB_UPLSTVW |
17 | SAD_PB_UPLCMP | Character(4) | VARCHAR2(4) NOT NULL |
Upload Complete
Prompt Table: SAD_PB_UPLSTVW |
18 | SAD_PB_UPDRQD | Character(4) | VARCHAR2(4) NOT NULL |
Update Required
Prompt Table: SAD_PB_UPDSTVW |
19 | SAD_PB_UPDRDY | Character(4) | VARCHAR2(4) NOT NULL |
Update Ready
Prompt Table: SAD_PB_UPDSTVW |
20 | SAD_PB_UPDATE | Character(4) | VARCHAR2(4) NOT NULL |
Update Complete
DCMP=Update Complete DRDY=Update Ready DRQD=Update Required Prompt Table: SAD_PB_UPDSTVW |
21 | SAD_PB_REPRDY | Character(4) | VARCHAR2(4) NOT NULL |
Report Ready
Prompt Table: SAD_PB_REPSTVW |
22 | SAD_PB_REPORT | Character(4) | VARCHAR2(4) NOT NULL |
Report Complete
RCMP=Report Complete RRDY=Report Ready Prompt Table: SAD_PB_REPSTVW |
23 | SAD_PB_ACADORG_SEC | Character(1) | VARCHAR2(1) NOT NULL |
Apply Academic Org Security
Default Value: N |
24 | SAD_PB_PREV_UKSTD | Character(1) | VARCHAR2(1) NOT NULL |
Previous UK Study
N=No Y=Yes Prompt Table: XL_PSYESNO_VW |
25 | SAD_PB_SELT_REQD | Character(1) | VARCHAR2(1) NOT NULL |
SELT Required
N=No Y=Yes Prompt Table: XL_PSYESNO_VW |
26 | SAD_PB_SCQF | Character(1) | VARCHAR2(1) NOT NULL |
Use SCQF Level
Y/N Table Edit |
27 | SAD_PB_GRDELIG | Character(4) | VARCHAR2(4) NOT NULL |
Graduate Eligible
Prompt Table: SAD_PB_GDLST_VW |
28 | SAD_PB_GRDRPTD | Character(4) | VARCHAR2(4) NOT NULL |
Graduate Reported
Prompt Table: SAD_PB_GDLST_VW |