SAD_UC_I_IVFMQ2

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application Code

3 SAD_UC_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier

4 SAD_UC_QUALID Number(10,0) DECIMAL(10) NOT NULL Qualification ID

5 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp

6 SAD_UC_QUALTYPE Character(250) VARCHAR2(250) NOT NULL Qualification Type

7 SAD_UC_AWDBDY10 Character(10) VARCHAR2(10) NOT NULL Awarding Body

8 SAD_UC_SUBJTITLE Character(100) VARCHAR2(100) NOT NULL Subject Title

9 SAD_UC_RESULT Character(20) VARCHAR2(20) NOT NULL Result

10 SAD_UC_GRADE Character(250) VARCHAR2(250) NOT NULL Grade

11 SAD_UC_PREGRADE Character(20) VARCHAR2(20) NOT NULL Predicted Grade

12 SAD_UC_QUALDTYEAR Number(4,0) SMALLINT NOT NULL Qualification Year

13 SAD_UC_QUALMONTH Number(2,0) SMALLINT NOT NULL Qualification Month

14 SAD_UC_CENTRENO Character(7) VARCHAR2(7) NOT NULL National Centre Number

15 SAD_UC_IMP_STATUS Character(1) VARCHAR2(1) NOT NULL Import Status
E=Error (E)
I=Imported (I)
N=New (N)
P=Pending (P)
R=Pending (R)
T=Error (T)

16 SAD_UC_UNITGRADES Long Character(2000) VARCHAR2(2000) Unit Grades

17 SAD_UC_PREDPRACGRD Character(20) VARCHAR2(20) NOT NULL Predicted Grades

18 SAD_UC_PRAC_GRADE Character(20) VARCHAR2(20) NOT NULL Practical Grade

19 SAD_UC_CAND_NUM Character(13) VARCHAR2(13) NOT NULL Candidate Number

20 SAD_UC_CENTRE_NAME Character(100) VARCHAR2(100) NOT NULL Centre Name

21 SAD_UC_ENTRY_MONTH Number(2,0) SMALLINT NOT NULL Entry Month

22 SAD_UC_ENTRY_YEAR Number(4,0) SMALLINT NOT NULL Entry Year

23 SAD_UC_LEVEL_CD Character(20) VARCHAR2(20) NOT NULL Level Code

24 SAD_UC_OTH_AWDBDY Character(10) VARCHAR2(10) NOT NULL Other Awarding Body

25 SAD_UC_RESULT_RECD Character(1) VARCHAR2(1) NOT NULL Result Received
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	SAD_UC_APPCODE	Character(10)	VARCHAR2(10) NOT NULL	Application Code
3	SAD_UC_PERS_ID	Character(10)	VARCHAR2(10) NOT NULL	Personalid - Unique personal identifier
4	SAD_UC_QUALID	Number(10,0)	DECIMAL(10) NOT NULL	Qualification ID
5	SAD_UC_TIMESTAMP	DateTime(26)	TIMESTAMP	Timestamp
6	SAD_UC_QUALTYPE	Character(250)	VARCHAR2(250) NOT NULL	Qualification Type
7	SAD_UC_AWDBDY10	Character(10)	VARCHAR2(10) NOT NULL	Awarding Body
8	SAD_UC_SUBJTITLE	Character(100)	VARCHAR2(100) NOT NULL	Subject Title
9	SAD_UC_RESULT	Character(20)	VARCHAR2(20) NOT NULL	Result
10	SAD_UC_GRADE	Character(250)	VARCHAR2(250) NOT NULL	Grade
11	SAD_UC_PREGRADE	Character(20)	VARCHAR2(20) NOT NULL	Predicted Grade
12	SAD_UC_QUALDTYEAR	Number(4,0)	SMALLINT NOT NULL	Qualification Year
13	SAD_UC_QUALMONTH	Number(2,0)	SMALLINT NOT NULL	Qualification Month
14	SAD_UC_CENTRENO	Character(7)	VARCHAR2(7) NOT NULL	National Centre Number
15	SAD_UC_IMP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Import Status E=Error (E) I=Imported (I) N=New (N) P=Pending (P) R=Pending (R) T=Error (T)
16	SAD_UC_UNITGRADES	Long Character(2000)	VARCHAR2(2000)	Unit Grades
17	SAD_UC_PREDPRACGRD	Character(20)	VARCHAR2(20) NOT NULL	Predicted Grades
18	SAD_UC_PRAC_GRADE	Character(20)	VARCHAR2(20) NOT NULL	Practical Grade
19	SAD_UC_CAND_NUM	Character(13)	VARCHAR2(13) NOT NULL	Candidate Number
20	SAD_UC_CENTRE_NAME	Character(100)	VARCHAR2(100) NOT NULL	Centre Name
21	SAD_UC_ENTRY_MONTH	Number(2,0)	SMALLINT NOT NULL	Entry Month
22	SAD_UC_ENTRY_YEAR	Number(4,0)	SMALLINT NOT NULL	Entry Year
23	SAD_UC_LEVEL_CD	Character(20)	VARCHAR2(20) NOT NULL	Level Code
24	SAD_UC_OTH_AWDBDY	Character(10)	VARCHAR2(10) NOT NULL	Other Awarding Body
25	SAD_UC_RESULT_RECD	Character(1)	VARCHAR2(1) NOT NULL	Result Received Y/N Table Edit