SAD_PB_CONFIG

#	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