PBI Configuration Record

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
Set Control Field: INSTITUTION

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