Technical and Vocation Education and Training Management Information System (TVETMIS)

• 100, 102

• Field  Name	Rules/Suggestions for Data
  Project_Code	PCI.PCD
  Project_Name	Must start with “PROJ”
  Financial_Item_Id	1 between 5
  Provider Code	GOPS-21   CPC
  Provider _ETQE_Id	SMNT-12   “EP”
  Date Stamp	SYSDAT

The combination of the above data is extracted and combined from the below mentioned options.

• FCSO-1 Maintain Cost Centre Definitions
• FCSO-1 Maintain Transaction Type Definitions
• FARO-23 General Ledger Journals

• TVETMIS -1  13000001	Items	Menu	Content	What to Fix
  Missing Mandatory value for Project Code:	ikxextcode	GOPS-21	PCI/PCD	One of the Values in PCI/PCD
  Illegal character found in Project Code:	ikxextcode	GOPS-21	PCI/PCD	One of the Values in PCI/PCD
  Illegal string found in Project Code:	ikxextcode	GOPS-21	PCI/PCD	One of the Values in PCI/PCD
  Missing Mandatory value for Project Desc:	ikxextdesc	GOPS-21	PCI/PCD	One of the Values in PCI/PCD
  Illegal character found in Project Desc:	ikxextdesc	GOPS-21	PCI/PCD	One of the Values in PCI/PCD
  Illegal string found in Project Desc:	ikxextdesc	GOPS-21	PCI/PCD	One of the Values in PCI/PCD
  Missing Mandatory value for Financial Item:	v_finitem	HARDCODED	Between 1 and 5	Between 1 and 5
  Illegal character found in Financial Item:	v_finitem	HARDCODED	Between 1 and 5	Between 1 and 5
  Missing Mandatory value for Date Stamp:	v_date_stamp	SYSDATE	System Date	Check Dates
  Date Stamp is before 01-Jan-1900:	v_date_stamp	SYSDATE	System Date	Check Dates
  Date Stamp is in the Future:	v_date_stamp	SYSDATE	System Date	Check Dates

•  

  File No	003	Menu	Content	What to Fix
  DDL   Name	Project_Code
  Field Type Rule	Field contains invalid characters Field may only contain characters like: ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	GOPS-21	PCI/PCD	One of the Values in PCI/PCD
  Fatal Error 02	Duplicate combination of Project_Code, Provider_Code and Provider_ETQE_Id	GOPS-21	PCI/PCD	One of the Values in PCI/PCD

   

  File No	003	Menu	Content	What to Fix
  DDL   Name	Project_Name
  Field Type Rule	Field contains invalid characters Field may only contain characters like: ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	GOPS-21	PCI/PCD	One of the Values in PCI/PCD

   

  File No	003	Menu	Content	What to Fix
  DDL   Name	Financial_Item_Id
  Field Type Rule	Field contains invalid characters Field may only contain characters like: ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890_.<>-@
  Fatal Error 01	Field contains an invalid Financial_Item_Id	GOPS-21	PCI/PCD	One of the Values in PCI/PCD
  Fatal Error 02	Field must contain a Financial_Item_Id that starts with the characters PROJ-	GOPS-21	PCI/PCD	One of the Values in PCI/PCD

   

  File No	003	Menu	Content	What to Fix
  DDL   Name	Provider_Code
  Field Type Rule	Field contains invalid characters Field may only contain characters like: ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Invalid combination of Provider_Code and Provider_ETQE_Id.   The combination of Provider_Code and Provider_ETQE_Id must exist on 100 - Provider	GOPS-21	PCI/PCD	One of the Values in PCI/PCD

   

  File No	003	Menu	Content	What to Fix
  DDL   Name	Provider_ETQE_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains invalid Provider_ETQE_Id	SMNT-12	EP	Default = 541

   

  File No	003	Menu	Content	What to Fix
  DDL   Name	Date_Stamp
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date	SYSDATE	DATE	Check Date
  Fatal Error 02	Date provided is unrealistic (pre 1900)	SYSDATE	DATE	Check Date

• Data Fields on file	Rules/Suggestions for Data
  Provider_Code	SAJCODE       or          GOPS-21 CPC
  Provider_ETQE_Id	SMNT-12                    EP
  Filler01	Leave Empty
  Provider_Name	SAJNAME or               GOPS-21 CPC
  Provider_Type_Id	SMNT-12  PT
  Provider_Postal_Address_1	Primary (P)ost            Numtype="C"
  Provider_Postal_Address_2
  Provider_Postal_Address_3
  Provider_Postal_Address_Code
  Provider_Phone_Number	(W)ork Telephone
  Provider_Fax_Number	(F)ax
  Filler02	Leave Empty
  Provider_Contact_Name	Leave Empty
  Provider_Contact_Email_Address	Leave Empty
  Provider_Contact_Phone_Number	Leave Empty
  Provider_Contact_Cell_Number	Leave Empty
  Filler03	Leave Empty
  Provider_Start_Date	SADYCON
  Provider_End_Date	Leave Empty
  Filler04	Leave Empty
  Provider_Class_Id	SADOWN                 or GOPS-21 PPC
  Provider_Status_Id	IAKACTIVE:              Hardcoded Rule
  Province_Code	GOPS-21 PRV
  Country_Code	GAOCOUNTRY          or GOPS-21 PCO
  Latitude_Degree	SAJLATDEG
  Latitude_Minutes	SAJLATMIN
  Latitude_Seconds	SAJLATSEC
  Longitude_Degree	SAJLONDEG
  Longitude_Minutes	SAJLONMIN
  Longitude_Seconds	SAJLONSEC
  Provider_Physical_Address_1	P(H)ysical Address
  Provider_Physical_Address_2
  Provider_Physical_Address_3
  Provider_Physical_Address_Code
  Provider_Website_Address	Web (S)ite
  Parent_Provider_Code	GOPS-21    CPC Default Campus
  Parent_Provider_ETQE_Id	SMNT-12  EP
  MIS_Type_Id	4 = Hardcode Value for "ITS"
  No_Of_Hostels	SADCODE: Count Nbr of Hostel Buildings
  DCS_Site_YN	Defaults “N”Dept of Correctional Services
  Date_Stamp	SYSDATE

• TVETMIS -1  13000002	Items	Menu	Content	What to fixTV
  Illegal Provider_Class_Id Conversion:    Get the Provider_class_id by looking at the status of the Default Delivery building of the campus. Not really ideal, but:     ALSO:     Get the "Year of Construction" to use for the Provider_start_date Then set it to the first of January of that year SPCS create the building with address, and link to campus...if there is no LOV then	v_classID Provider_Class_Id */  IF (get_conversion('FET', 'PPC',  g_values.v_classID) !	GOPS-21	PPC	One of the Values in PPC
  Illegal Province_Code Conversion: Get Province code from the Physical Addres postal code GCS2-2 make sure postal code linked GCS2-4 Make sure district linked to province	v_province	GOPS-21	PRV	One of the Values in PRV
  Illegal Country_Code Conversion:	v_country GCS-2 the country code is maybe blank	GOPS-21	PCO	One of the Values in PCO
  Missing Mandatory value for Provider_Code:	SAJCODE	GOPS-21	CPC	One of the Values in CPC
  Too long value for field Provider_Code:	SAJCODE	GOPS-21	CPC	One of the Values in CPC
  Illegal character found in Provider_Code:	SAJCODE	GOPS-21	CPC	One of the Values in CPC
  Illegal String found in Provider_Code:	SAJCODE	GOPS-21	CPC	One of the Values in CPC
  Missing Mandatory value for Provider_Name:	SAJNAME	GOPS-21	CPC	One of the Values in CPC
  Too long value for field Provider_Name:	SAJNAME	GOPS-21	CPC	One of the Values in CPC
  Illegal character found in Provider_Name:	SAJNAME	GOPS-21	CPC	One of the Values in CPC
  llegal String found in Provider_Name:	SAJNAME	GOPS-21	CPC	One of the Values in CPC
  Missing Mandatory value for Provider_Type_Id:	v_provider_type	SMNT-12	PT	Identify which type explains your institution best: 2_  Developer Enterprise NGO 3 _ Education 4 _ Employer 5 _ Training 500_ Education and Training Default will be "500"
  Too long value for field Provider_Type_Id:	v_provider_type	SMNT-12	PT
  Missing Mandatory value for Provider_Postal_Address_1:	v_postAddr1	Primary (P)ost	SPCS-1	Fix Address for Campus.
  Too long value for field Provider_Postal_Address_1:	v_postAddr1	Primary	SPCS-1	Fix Address for Campus.
  Illegal character found in Provider_Postal_Address_1:	v_postAddr1	Primary	SPCS-1	Fix Address for Campus.
  Illegal String found in Provider_Postal_Address_1:	v_postAddr1	Primary	SPCS-1	Fix Address for Campus.
  Missing Mandatory value for Provider_Postal_Address_2:	v_postAddr2	Primary	SPCS-1	Fix Address for Campus.
  Too long value for field Provider_Postal_Address_2:	v_postAddr2	Primary	SPCS-1	Fix Address for Campus.
  Illegal character found in Provider_Postal_Address_2:	v_postAddr2	Primary	SPCS-1	Fix Address for Campus.
  Illegal String found in Provider_Postal_Address_2:	v_postAddr2	Primary	SPCS-1	Fix Address for Campus.
  Too long value for field Provider_Postal_Address_3:	v_postAddr3	Primary	SPCS-1	Fix Address for Campus.
  Illegal character found in Provider_Postal_Address_3:	v_postAddr3	Primary	SPCS-1	Fix Address for Campus.
  Illegal String found in Provider_Postal_Address_3:	v_postAddr3	Primary	SPCS-1	Fix Address for Campus.
  Missing Mandatory value for Provider_Postal_Address_Code:	v_postPcode	Primary	SPCS-1	Fix Address for Campus.
  Too long value for field Provider_Postal_Address_Code:	v_postPcode	Primary	SPCS-1	Fix Address for Campus.
  Illegal character found in Provider_Postal_Address_Code:	v_postPcode	Primary	SPCS-1	Fix Address for Campus.
  Missing Mandatory value for Provider_Phone_Number:	v_tel	(W)ork Tel	SPCS-1	Fix Work Tel for Campus
  Too long value for field Provider_Phone_Number:	v_tel	(W)ork Tel	SPCS-1	Fix Work Tel for Campus
  Illegal character found in Provider_Phone_Number:	v_tel	(W)ork Tel	SPCS-1	Fix Work Tel for Campus
  Illegal String found in Provider_Phone_Number:	v_tel	(W)ork Tel	SPCS-1	Fix Work Tel for Campus
  Missing Mandatory value for Provider_Fax_Number:	v_fax	(F)ax Tel	SPCS-1	Fix Fax Tel for Campus
  Too long value for field Provider_Fax_Number:	v_fax	(F)ax Tel	SPCS-1	Fix Fax Tel for Campus
  Illegal character found in Provider_Fax_Number:	v_fax	(F)ax Tel	SPCS-1	Fix Fax Tel for Campus
  Illegal String found in Provider_Fax_Number:	v_fax	(F)ax Tel	SPCS-1	Fix Fax Tel for Campus
  Too long value for field Provider_Contact_Name:	v_pc_name			Leave Empty
  Illegal character found in Provider_Contact_Name:	v_pc_name			Leave Empty
  Illegal String found in Provider_Contact_Name:	v_pc_name			Leave Empty
  Too long value for field Provider_Contact_Email_Address:	v_pc_email			Leave Empty
  Illegal character found in Provider_Contact_Email_Address:	v_pc_email			Leave Empty
  Illegal String found in Provider_Contact_Email_Address:	v_pc_email			Leave Empty

• 
  

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-	See External Code Explantions
  Fatal Error 01	Duplicate Provider_Code	GOPS-21	PCI,PCD	Check the setup, make sure there are not 2 of the same.
  Fatal Error 02	Invalid combination of Provider_Code and Provider_ETQE_Id. The combination of Provider_Code and Provider_ETQE_Id must be registered on the recipient system and at the relevant Quality Council	SMNT-12	EP	Make sure that SMNT-12 EP has the correct default.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_ETQE_Id
  Field Type Rule	Field may only contain numbers	See External Code Explantions
  Fatal Error 01	Field contains invalid Provider_ETQE_Id	SMNT-12	EP	Make sure the correct ETQE ID is used.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Name
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-	See External Code Explantions
  Fatal Error 01	Field contains an invalid string like  %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	GOPS-21 Or SPCS-1	CPC   Name	Make sure the name is correct in both CPC and SPCS-1
  Fatal Error 02	Duplicate Provider_Name	GOPS-21	CPC	Make sure only 1 Campus is loaded per Capmus.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Type_Id
  Field Type Rule	Field may only contain numbers	See External Code Explantions SMNT-12 Options.
  Fatal Error 01	Field contains an invalid Provider_Type_Id	SMNT-12	PT	Make sure it contains the correct ID. Default is 500

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Postal_Address_1 Provider_Postal_Address_2 Provider_Postal_Address_3
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ -1234567890#&()/\:._`',
  Fatal Error 01	Field contains an invalid string like  %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SPCS-1	Address	Address needs fixing. See field type rule.
  Fatal Error 02	Field contains only numbers	SPCS-1	Address	There must be a valid address not only number.
  Fatal Error 03	Field may not contain four consecutive numbers – field possibly contains a postal code or address layout is incorrect	SPCS-1	Address	There may not be 0000 leading consecutive number.
  Non Fatal Error 01	Field contains invalid characters - field may not contain characters like %ZZZ% or %XXX% or %ADDRES%	SPCS-1	Address	Fix address must be propper no VVV XXX ADDRESS.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Postal_Address_Code Provider_Phone_Number Provider_Fax_Number
  Field Type Rule	Postal:  Field contains invalid characters - field may only contain characters like 1234567890 Phone_Fax: Field contains invalid characters - field may only contain characters like 1234567890 ()/-
  Fatal Error 01	Postal: Incorrect postal code supplied   Phone_Fax: Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SPCS-1       SPCS-1	Address Postal Code   Address Phone and Fax	Insert the correct postal code.     Make sure phone numbers are only numbers.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Contact_Name Provider_Contact_Email_Address Provider_Contact_Phone_Number Provider_Contact_Cell_Number
  Field Type Rule	Name: Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ`' - Email: Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890_.<>-@ Phone: Field contains invalid characters - field may only contain characters like 1234567890 ()/- Cell: Field contains invalid characters - field may only contain characters like 1234567890 ()-	All these are left empty for now.
  Fatal Error 01	Name: Field contains invalid characters - field may not contain characters like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or 0 or TEST or %ONTBREEK% or NIL or - or – Email: Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or – Phone: Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or – Cell: Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	Leave Empty	Leave Emtpy	Leave Empty
  Fatal Error 02	Email: E-mail address does not contain the @ character	Left Empty	Left Empty	Left Empty
  Non Fatal Error 01	Name: Field contains invalid characters - field may not contain characters like NA or U or NONE or GEEN	Left Empty	Left Empty	Left Empty

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Start_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Provider_Start_Date date is greater than Provider_End_Date	SPCS-4	Construction Date	Check Dates
  Fatal Error 02	Date is greater than today's date	SPCS-4	Construction Date	Date cannot be after SYSDATE.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_End_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Not applicable

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Class_Id
  Field Type Rule	Field may only contain numbers	See External Code Explantions
  Fatal Error 01	Field contains an invalid Provider_Class_Id	GOPS-21	PPC	Make sure the Ownership code is correct.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Status_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Provider_Status_Id	Hard Coded	IAKACTIVE
  Fatal Error 02	A valid Provider_End_Date value is required if Provider_Status_Id has a value of 513	Hard Coded	IAKACTIVE
  Fatal Error 03	Provider_End_Date must be left blank if Provider_Status_Id does not have a value of 513	Hard Coded	IAKACTIVE

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Province_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid Province_Code	GOPS-21	PRV	Check Values.
  Fatal Error 02	Invalid combination of Province_Code and Country_Code	GOPS-21	PRV	Check Values.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Country_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid Country_Code	GOPS-21	PCO	Check Values.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Latitude_Degree
  Field Type Rule	Field contains invalid characters – field may only contain characters like 1234567890-
  Fatal Error 01	Incomplete GPS reading provided	SPCS-1	Latitude Degree	Check Latitudes.
  Fatal Error 02	Incomplete Latitude/Longitude reading provided	SPCS-1	Latitude Degree	Check Latitudes.
  Fatal Error 03	Invalid Latitude_Degree value provided, value provided may not be greater than -22 and may not be less than -35

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Latitude_Minutes
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Invalid Latitude_Minutes value provided, value must contain 2 characters (include leading zero's if the value is less than 10) and may not be greater than 59	SPCS-1	Latitude Minutes	Check Latitudes

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Latitude_Seconds
  Field Type Rule	Field contains invalid characters – field may only contain characters like 1234567890.
  Fatal Error 01	Invalid Latitude_Seconds value provided, value must contain 6 characters in the format nn.nnn (include leading zero's if the value is less than 10) and may not be greater than 59.999	SPCS-1	Latitude Seconds	Check Latitudes

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Longitude_Degree
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Incomplete Latitude/Longitude reading provided	SPCS-1	Longitude Degree	Check Latitudes
  Fatal Error 02	Incomplete GPS reading provided	SPCS-1	Longitude Degree	Check Latitudes
  Fatal Error 03	Invalid Longitude_Degree value provided, value provided may not be greater than 33 and may not be less than 16

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Longitude_Minutes
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Invalid Longitude_Minutes value provided, value must contain 2 characters (include leading zero's if the value is less than 10) and may not be greater than 59	SPCS-1	Longitude Minutes	Check Latitudes

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Longitude_Seconds
  Field Type Rule	Field contains invalid characters – field may only contain characters like 1234567890.
  Fatal Error 01	Invalid Longitude_Seconds value provided, value must contain 6 characters in the format nn.nnn (include leading zero's if the value is less than 10) and may not be greater than 59.999	SPCS-1	Longitude Seconds	Check Latitudes

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Physical_Address_1 Provider_Physical_Address_2 Provider_Physical_Address_3 Provider_Physical_Address_Code
  Field Type Rule	Address_1: Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ -1234567890#&()/\:._`', Address_2 Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ -1234567890#&()/\:._`', Address_3 Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ -1234567890#&()/\:._`', Postal_Code: Field contains invalid characters - field may only contain characters like 1234567890
  Fatal Error 01	Address_1 Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or – Address_2 Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or – Address_3 Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or – Postal Incorrect postal code supplied	SPCS-1	P(H)ysical Add	Fix Address for Campus
  Fatal Error 02	Address_1 Field contains only numbers Address_2 Field contains only numbers Address_3 Field contains only numbers	SPCS-1	P(H)ysical Add	Fix Address for Campus
  Fatal Error 03	Address_3 Field may not contain four consecutive numbers – field possibly contains a postal code or address layout is incorrect	SPCS-1	P(H)ysical Add	Fix Address for Campus

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Provider_Website_Address
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ -1234567890#&()/\:._`',
  Fatal Error 01	Not applicable

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Parent_Provider_Code
  Field Type Rule	Field contains invalid characters –  field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Combination Parent_Provider_Code and Parent_Provider_ETQE_Id does not exist in file 100 - Provider as Provider_Code and Provider_ETQE_Id	GOPS-21	CPC	Check on of the Values

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Parent_Provider_ETQE_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains invalid Parent_Provider_ETQE_Id	SMNT-12	EP	Check Value

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	MIS_Type_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid MIS_Type_Id	"4"		Hardcode Value for "ITS"

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	No_Of_Hostels
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Not applicable	SPCS-4	Building Code

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	DCS_Site_YN
  Field Type Rule	Field contains invalid characters - field may only contain characters like YN
  Fatal Error 01	Not applicable	“N”		Dept of Correctional Serv.

   

  File No	100	Menu	Content	What to Fix
  DDL   Name	Date_Stamp
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date	SYSDATE	Date	Check Date
  Fatal Error 02	Date provided is unrealistic (pre 1900)	SYSDATE	Date	Check Date

• Qualification Offering Types {SACADO-2}
• Qualification {SACADO-1}
• Offering Types {GCS-5}

• File No	101	Menu	Content	What to Fix
  DDL   Name	Learnership_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Duplicate combination of Learnership_Id, Qualification_Id, Provider_Code and Provider_Etqe_Id	Leave	Empty
  Fatal Error 02	Both Learnership_Id and Qualification_Id are blank	Leave	Empty
  Fatal Error 03	Field contains an invalid Learnership_Id
  Fatal Error 04	Invalid combination of Learnership_Id and qualification_Id

   

  File No	101	Menu	Content	What to Fix
  DDL   Name	Qualification_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Qualification_Id. Must contain a valid SAQA Qualification ID as registered on the National Qualifications Framework (NQF)	Qaulification ID of DHET	IaIqarn	Insert iaiqarn for qualification.

   

  File No	101	Menu	Content	What to Fix
  DDL   Name	Provider_Code
  Field Type Rule	Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Invalid combination of Provider_Code and Provider_Etqe_Id. The combination of Provider_Code and Provider_Etqe_Id must exist on 100 - Provider	GOPS-21	CPC	One of the values  in CPC
  Fatal Error 02	Combination Provider_Code and Provider_Etqe_Id may not exist in 100 - Provider as  Parent_Provider_Code and Parent_Provider_ETQE_Id	GOPS-21	CPC	One of the values  in CPC

   

  File No	101	Menu	Content	What to Fix
  DDL   Name	Provider_Etqe_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains invalid Provider_Etqe_Id	SMN T-12	EP	Must have default.

   

  File No	101	Menu	Content	What to Fix
  DDL   Name	Provider_Accred_Start_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Provider_Accred_Start_Date date is greater than Provider_Accred_End_Date	SACADO-2		Date Instituted

   

  File No	101	Menu	Content	What to Fix
  DDL   Name	Provider_Accred_End_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Not applicable	SACADO-2		Date Phased Out.

   

  File No	101	Menu	Content	What to Fix
  DDL   Name	Provider_Status_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Provider_Status_Id	SACADO-2		Offering Type character.
  Fatal Error 02	A valid Provider_Accred_End_Date value is required if Provider_Status_Id has a value of 513
  Fatal Error 03	Provider_Accred_End_Date must be left blank if Provider_Status_Id does not have a value of 513

   

  File No	101	Menu	Content	What to Fix
  DDL   Name	Offering_Type_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Offering_Type_Id	GOPS-21	OTI	Check Value

   

  File No	101	Menu	Content	What to Fix
  DDL   Name	Date_Stamp
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date
  Fatal Error 02	Date provided is unrealistic (pre 1900)	Sysdate+A1

   

• 100

• Field Name	Rules/Suggestions for Data
  Provider_Code	CPC Default Campus on CC of campus
  Provider_ETQE_Id	EP
  Financial_Item_Id	FII Must be left Empty if Project_Code has value
  Financial_Type_Id	1 - 5
  Year	Fgcfiny : Between 2010 - 2050
  Month	Fgcfinc: Between 1 - 12
  Amount	Fgctval
  Project_Code	PCI,PCD : Start with "PROJ-"
  Date_Stamp	Fgcidte

• 13000003	Items	Menu	Content	What to Fix
  RULE for v_fintitem: Must be left Empty if Project_Code has value:
  Project_Code Must be Empty if Financial_Item_Id was provided or Vice-Versa:	v_finItem	GOPS-21	FII	One of the values in FII
  Invalid Financial_Item_Id / Financial_Type_Id Combination:	v_finItem	GOPS-21	FII	One of the values in FII
  Invalid Financial_Item_Id / Financial_Type_Id Combination:	v_finItem	GOPS-21	FII	One of the values in FII
  Invalid Financial_Item_Id / Financial_Type_Id Combination:	v_finItem	GOPS-21	FII	One of the values in FII
  Invalid Financial_Item_Id. Project not allowed:	v_finItem	GOPS-21	FII	One of the values in FII
  Either Project_Code OR Financial_Item_Id Must be provided:	v_finItem	GOPS-21	FII	One of the values in FII
  RULE for v_fintype: on GOPS-21 for FII 1 Budget Allocation (B) 2 Unspent Balance from Previous Year (B – J) 3 Actual (J) 4 Projected 5 Opening Balance as at Start of Year (S) Linked at the bottom of GOPS-21 PCD with “YYYNY”
  Illegal character found in Financial Type:	v_finType	GOPS-21	FII	Values to be 1 - 5
  Illegal string found in Financial Type:	v_finType	GOPS-21	FII	Values to be 1 - 5
  Illegal character found in Financial Item:	v_finItem	GOPS-21	FII	One of the values in FII
  Illegal string found in Financial Item:	v_finItem	GOPS-21	FII	One of the values in FII
  Missing Mandatory value for Year:	fgcfiny	FARO-23		Financial Year. Between 2010 - 2050
  Illegal character found in Year:	fgcfiny	FARO-23		Financial Year. Between 2010 - 2050
  Missing Mandatory value for Month:	fgcfinc	FARO-23		Financial Cycle: Between 1 - 12
  Illegal character found in Month:	fgcfinc	FARO-23		Financial Cycle: Between 1 - 12
  Missing Mandatory value for Amount:	fgctval	FARO-23		Value.
  Illegal character found in Amount:	fgctval	FARO-23		Value
  Illegal character found in Project Code:	v_projectCode	ikxextcode	PCD/PCI	GOPS-21
  Illegal string found in Project Code:	v_projectCode	ikxextcode	PCD/PCI	GOPS-21
  Missing Mandatory value for Date Stamp:	v_date_stamp	FARO-23	fgcidte	Date.
  Date Stamp is before 01-Jan-1900:	v_date_stamp	FARO-23	fgcidte	Date.
  Date Stamp is in the Future:	v_date_stamp	FARO-23	fgcidte	Date.

• 
  

  File No	102	Menu	Content	What to Fix
  DDL   Name	Provider_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Invalid combination of Provider_Code and Provider_ETQE_Id. The combination of Provider_Code and Provider_ETQE_Id must exist on 100 - Provider	GOPS-21	CPC	Check Value
  Fatal Error 02	Duplicate combination of Provider_Code, Provider_ETQE_Id, Financial_Item_Id, Financial_Type_Id, Year, Month and Project_Code	GOPS-21	CPC	Check Value

     

  File No	102	Menu	Content	What to Fix
  DDL   Name	Provider_ETQE_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains invalid Provider_ETQE_Id	SMNT-12	EP	Check Default

    

  File No	102	Menu	Content	What to Fix
  DDL   Name	Financial_Item_Id
  Field Type Rule	Field contains invalid characters –  field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890_.<>-@
  Fatal Error 01	Field contains an invalid Financial_Item_Id	GOPS-21	FII	One of the values in FII
  Fatal Error 02	Field may only contain a Financial_Item_Id that does not start with the characters PROJ-	GOPS-21	FII	One of the values in FII
  Fatal Error 03	Field must and may only be left blank if Project_Code is not blank

   

  File No	102	Menu	Content	What to Fix
  DDL   Name	Financial_Type_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Financial_Type_Id	GOPS-21	FII	Values to be 1 - 5
  Fatal Error 02	Record contains invalid combination of Financial_Type_Id, Financial_Item_Id and Project_Code	GOPS-21	FII	Values to be 1 - 5
  Fatal Error 03	Record contains invalid combination of Financial_Type_Id and Project_Code	GOPS-21	FII	Values to be 1 - 5
  Fatal Error 04	Record contains invalid combination of Financial_Type_Id, Financial_Item_Id and Project_Code	GOPS-21	FII	Values to be 1 - 5
  Fatal Error 05	Record contains invalid combination of Financial_Type_Id, Financial_Item_Id and Project_Code	GOPS-21	FII	Values to be 1 - 5
  Fatal Error 06	Record contains invalid combination of Financial_Type_Id and Financial_Item_Id	GOPS-21	FII	Values to be 1 - 5

   

  File No	102	Menu	Content	What to Fix
  DDL   Name	Year
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Record contains invalid Year	FARO-23		Financial Year. Between 2010 - 2050

   

  File No	102	Menu	Content	What to Fix
  DDL   Name	Month
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Record contains invalid Month	FARO-23		Financial Cycle:  Between 1 - 12

   

  File No	102	Menu	Content	What to Fix
  DDL   Name	Amount
  Field Type Rule	Field contains invalid characters – field may only contain characters like 1234567890.-
  Fatal Error 01	Not applicable	FARO-23		Value.

   

  File No	102	Menu	Content	What to Fix
  DDL   Name	Project_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Combination of Project_Code, Provider_Code and Provider_ETQE_Id does not exist in 003 - Project	GOPS-21	PCD/PCI	ikxextcode

   

  File No	102	Menu	Content	What to Fix
  DDL   Name	Date_Stamp
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date	FARO-23	fgcidte	Date.
  Fatal Error 02	Date provided is unrealistic (pre 1900)	FARO-23	fgcidte	Date.

   

• 100

• Field Name	Rules/Suggestions
  Programme_Code	IAIQUAL : WHERE IAIQARN IS NULL
  Programme_Description	IAIDESC : WHERE IAIQARN IS NULL
  Programme_Type_ID	IBSCODE : For GOPS-21 PTI
  NQF_Level_Id	IBSNQFLEV: For GOPS-21 NQF
  Subfield_Id	IAIFOLC : For GOPS-21 SDQ
  AET_Level_Id	v_abet_band_id : ABI Currently hardcode "1"
  Programme_Start_Date	IAJINDATE : Select MIN() because PK contains OT
  Programme_End_Date	IAJFODATE : Select MAX()because PK contains OT
  Provider_Code	v_providerCampus : CPC Default Campus on OT of curriculum
  Provider_ETQE_Id	SMNT-12 EP
  Programme_Status_Id	IAJACTIVE : Any Active => 1, Not Active => 2
  Programme_Credit	IAJMAXCRED : Only Allow Between 40 - 480
  Date_Stamp	v_date_stamp

• Qualification Offering Types {SACADO-2}
• Qualifications {SACADO-1}
• Approved Qualifications {SACADO-7}
• Qualification Types {SCODE3-1}
• Offering Types {GCS-5}
• Census Dates {GOPS-1}

• 13000004	Items	Menu	Content	What to Fix
  Default Empty Programme_Type_Id value to 1: Unknown	Ibscode SCODE3-1	GOPS-21	PTI	One of the Values in PTI
  llegal Programme_Type_Id Conversion:	Ibscode SCODE3-1	GOPS-21	PTI	One of the Values in PTI
  Default Empty NQF Level value to 1: Undefined'	Ibsnqflev SCODE3-1	GOPS-21	NQF	One of the Values in NQF
  Illegal NQF Level Conversion:	Ibsnqflev SCODE3-1	GOPS-21	NQF	One of the Values in NQF
  Default Subdomain ID value to 530: Undefined	Iaifolc SACADO-1 Page 2	GOPS-21	SDQ	One of the Values in SDQ
  Illegal Subdomain Conversion:	Iaifolc SACADO-1 Page 2	GOPS-21	SDQ	One of the Values in SDQ
  Missing Mandatory value for Qualification Code:	Iaiqual	SACADO-1	Qualification	Qualification
  Illegal character found in Qual Code:	Iaiqual	SACADO-1	Qualification	Qualification
  Illegal String found in Qual Code:	Iaiqual	SACADO-1	Qualification	Qualification
  Missing Mandatory value for Qualification Name:	iaidesc	SACADO-1	Qualification	Description
  Illegal character found in Qual Name:	iaidesc	SACADO-1	Qualification	Description
  Illegal String found in Qual Name:	iaidesc	SACADO-1	Qualification	Description
  Missing Mandatory value for Programme_Type_Id:	Ibscode SCODE3-1	GOPS-21	PTI	One of the Values in PTI
  Illegal character found in Programme_Type_Id:	Ibscode SCODE3-1	GOPS-21	PTI	One of the Values in PTI
  Missing Mandatory value for NQF Level:	Ibsnqflev SCODE3-1	GOPS-21	NQF	One of the Values in NQF
  Illegal character found in NQF Level:	Ibsnqflev SCODE3-1	GOPS-21	NQF	One of the Values in NQF
  Missing Mandatory value for Subdomain ID:	Iaifolc SACADO-1 Page 2	GOPS-21	SDQ	One of the Values in SDQ
  Illegal character found in Subdomain ID:	Iaifolc SACADO-1 Page 2	GOPS-21	SDQ	One of the Values in SDQ
  Missing Mandatory value for AET Level ID:	v_aet_level_id	ABI		Currently hardcode "1"
  Illegal character found in AET Level ID:	v_aet_level_id	ABI		Currently hardcode "1"
  Programme_Credit not in legal range of 40 – 480:	iajmaxcred	SACADO-1	Offering Type	Background.
  Missing Mandatory value for Start Date. Setting to:	iajindate	SACADO-1	Offering Type	Date Instituted
  Start Date is after todays date:	iajindate	SACADO-1	Offering Type	Date Instituted.
  Start Date is before 01-Jan-1900:	iajindate	SACADO-1	Offering Type	Date Instituted.
  Missing Mandatory value for End Date. Setting to:	iajfodate	SACADO-1	Offering Type	Date Phased Out
  End Date is before 01-Jan-1900:	iajfodate	SACADO-1	Offering Type	Date Phased Out.
  Start Date is after End Date:	iajfodate	SACADO-1	Offering Type	Date Phased Out.
  Programme End Date cannot be in the future:	iajfodate	SACADO-1	Offering Type	Date Phased Out.
  Start and End Date differs by more than 3 years:	iajfodate	SACADO-1	Offering Type	Date Phased Out
  Missing Mandatory value for Provider Code:	v_provider_code	GOPS-21	CPC	One of the Values.
  Illegal character found in Provider Code:	v_provider_code	GOPS-21	CPC	One of the Values
  Illegal String found in Provider Code :	v_provider_code	GOPS-21	CPC	One of the Values
  Missing Mandatory value for Provider ETQA Code:	v_etqe_id	SMNT-12	EP	Default
  Illegal character found in Provider ETQA Code:	v_etqe_id	SMNT-12	EP	Default.
  Missing Mandatory value for Date Stamp:	v_date_stamp

• 
  

  File No	301	Menu	Content	What to Fix
  DDL   Name	Programme_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SACADO-1	Qualification	Qualification
  Fatal Error 02	Duplicate combination of Programme_Code, Provider_Code and Provider_ETQE_Id	SACADO-1	Qualification	Qualification WHERE IAIQARN IS NULL

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Programme_Description
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SACADO-1	Qualification	Description WHERE IAIQARN IS NULL

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Programme_Type_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Programme_Type_Id	GOPS-21	PTI	One of the Values in   PTI

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	NQF_Level_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid NQF_Level_Id	GOPS-21	NQF	One of the Values in   NQF

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Subfield_Id
  Field Type Rule	Field may only contain numbers	Iaifolc SACADO-1 Page 2
  Fatal Error 01	Field contains an invalid Subfield_Id	GOPS-21	SDQ	One of the Values in   SDQ

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	AET_Level_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid AET_Level_Id	ABI		Currently hardcode "1"
  Fatal Error 02	Invalid AET_Level_Id and NQF_Level_Id combination. Following combinations are invalid: a.) AET_Level_Id = 1 AND NQF_Level_Id = 539 b.) AET_Level_Id = (2 OR 3 OR 4) AND NQF_Level_Id <> 539 c.) AET_Level_Id = 5 AND NQF_Level_Id <> 503.	ABI		Currently hardcode "1"

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Programme_Start_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Programme_Start_Date date is greater than Programme_End_Date	SACADO-1	Offering Type	Date Instituted
  Fatal Error 02	Date is greater than today's date	SACADO-1	Offering Type	Date Instituted
  Fatal Error 03	Date provided is unrealistic (pre 1900)

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Programme_End_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date	SACADO-1	Offering Type	Date Phased Out

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Provider_Code
  Field Type Rule	Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Invalid combination of Provider_Code and Provider_ETQE_Id. The combination of Provider_Code and Provider_ETQE_Id must exist on 100 - Provider	GOPS-21	CPC	One of the Values.
  Fatal Error 02	Combination Provider_Code and Provider_ETQE_Id may not exist in 100 - Provider as  Parent_Provider_Code and Parent_Provider_ETQE_Id	GOPS-21	CPC	One of the Values.

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Provider_ETQE_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains invalid Provider_ETQE_Id	SMNT-12	EP	Default

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Programme_Status_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Programme_Status_Id	SACADO-1	IAJACTIVE	Any Active => 1, Not Active => 2
  Fatal Error 02	A valid Programme_End_Date value is required if Programme_Status_Id has a value of 2	SACADO-1	IAJACTIVE	Any Active => 1, Not Active => 2
  	Programme_End_Date must be left blank if Programme_Status_Id does not have a value of 2	SACADO-1	IAJACTIVE	Any Active => 1, Not Active => 2

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Programme_Credit
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains a value less than 40	SACADO-1	Offering Type	Background.
  Fatal Error 02	Field contains a value greater than 480	SACADO-1	Offering Type	Background.

   

  File No	301	Menu	Content	What to Fix
  DDL   Name	Date_Stamp
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date	SYSDATE	DATE	Check Date
  Fatal Error 02	Date provided is unrealistic (pre 1900)	SYSDATE	DATE	Check Date

   

• 100, 307

• Field Name	Rules/Suggestions
  Subject_Code	ialsubj
  Subject_Name	ialdesc
  NQF_Level_Id	ialnqflev : SCODE3-1 NQF
  Subfield_Id	ialfolc : SCODE3-1 b6 SDQ
  AET_Level_Id	v_abet_band_id: ABI Currently hardcode "1"
  Subject_Reg_Start_Date	iakindate
  Subject_Reg_End_Date	iakfodate
  Provider_Code	v_providerCampus DefaultCampus on OT of curriculum
  Provider_ETQE_Id	EP
  Subject_Status_Id	iakactive Any Active => 1, Not Active => 2
  Subject_Credit	Iakcredit or ialcredit : Must be between 1 and 110
  Date_Stamp	iallastupd/iakindate/sysdate

• Subjects {SACADO-10} where the Unit Standard is blank
• Subject Offering Type and Blocks {SACADO-12}
• Offering Types {GCS-5}
• Census Dates {GOPS-1}
• Curriculum {SACADO-17}
• For Qualifications {SACADO-1} where the Qualification Category in the Qualification Type {SCODE3-1} is not (I)nternal 

• 13000005	Items	Menu	Content	What to Fix.
  Default Empty NQF Level value to 515: nknown:	Ialnqflev SACADO-10	GOPS-21	NQF	SACADO-10 no NQF level
  Illegal NQF Level Conversion:	Ialnqflev SACADO-10	GOPS-21	NQF	One of the Values in NQF.
  Default Subdomain value to 530: Unknown:	Ialfolc SACADO-10	GOPS-21	SDQ	SACADO-10 National Sub Field of Learning is empty
  Illegal Subdomain Conversion:	Ialfolc SACADO-10	GOPS-21	SDQ	One of the Values in SDQ.
  Missing Mandatory value for Course/Subject Code:	Ialsubj	SACADO-10	Subject Code
  Illegal character found in Course/Subject Code:	Ialsubj	SACADO-10	Subject Code
  Illegal String found in Course/Subject Code:	Ialsubj	SACADO-10	Subject Code
  Missing Mandatory value for Course Description:	Ialdesc	SACADO-10	Name
  Illegal character found in Course Description:	Ialdesc	SACADO-10	Name
  Illegal String found in Course Description:	Ialdesc	SACADO-10	Name
  Missing Mandatory value for NQF Level:	Ialnqflev SACADO-10	GOPS-21	NQF	One of the Values in NQF.
  Illegal character found in NQF Level:	Ialnqflev SACADO-10	GOPS-21	NQF	One of the Values in NQF.
  Missing Mandatory value for Subdomain ID:	Ialfolc SACADO-10	GOPS-21	SDQ	One of the Values in SDQ.
  Illegal character found in Subdomain ID:	Ialfolc SACADO-10	GOPS-21	SDQ	One of the Values in SDQ.
  Missing Mandatory value for AET Level ID:	v_aet_level_id			ABI Currently hardcode "1"
  Illegal character found in AET Level ID:	v_aet_level_id			ABI Currently hardcode "1"
  Missing Mandatory value for Registration Start Date. Setting to:	iakindate	SACADO-17	Date Instituted	Check Dates.
  Start Date is after todays date:	iakindate	SACADO-17	Date Instituted	Check Dates.
  Start Date is before 01-Jan-1900:	iakindate	SACADO-17	Date Instituted	Check Dates.
  Missing Mandatory value for Registration End Date. Setting to:	iakfodate	SACADO-17	Date Phased Out	Check Dates.
  End Date is before 01-Jan-1900:	iakfodate	SACADO-17	Date Phased Out	Check Dates.
  Start Date is after End Date:	iakfodate	SACADO-17	Date Phased Out	Check Dates.
  End Date cannot be in the future:	iakfodate	SACADO-17	Date Phased Out	Check Dates.
  Start and End Date differs by more than 3 years:	iakfodate	SACADO-17	Date Phased Out	Check Dates.
  Missing Mandatory value for Provider Code:	v_provider_code	GOPS-21	CPC	One of the values in CPC
  Illegal character found in Provider Code:	v_provider_code	GOPS-21	CPC	One of the values in CPC
  Illegal String found in Provider Code:	v_provider_code	GOPS-21	CPC	One of the values in CPC
  Missing Mandatory value for Provider ETQA ID:	v_etqe_id	SMNT-12	EP	See Defaults
  Illegal character found in Provider ETQA ID:	v_etqe_id	SMNT-12	EP	See Defaults
  Missing Mandatory value for Date Stamp:	v_date_stamp		iallastupd/iakindate/sysdate	Check Dates.
  Illegal Subject Credit. Must be between 1 and 110:	v_SubjCredit	SACADO-17	Must be between 1 and 110	Check Credits.

• 
  

  File No	303	Menu	Content	What to Fix
  DDL   Name	Subject_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SACADO-10	Subject Code
  Fatal Error 02	Duplicate combination of Subject_Code, Provider_Code and Provider_ETQE_Id	SACADO-10	Subject Code

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	Subject_Name
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SACADO-10	Name

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	NQF_Level_Id
  Field Type Rule	Field may only contain numbers	SACADO-10
  Fatal Error 01	Field contains an invalid NQF_Level_Id	GOPS-21	NQF	One of the Values in NQF.

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	Subfield_Id
  Field Type Rule	Field may only contain numbers	Scode 3-1 b6 SDQ
  Fatal Error 01	Field contains an invalid Subfield_Id	GOPS-21	SDQ	One of the Values in SDQ.

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	AET_Level_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid AET_Level_Id			ABI  Currently hardcode "1
  Fatal Error 02	Invalid AET_Level_Id and NQF_Level_Id combination. Following combinations are invalid: a.) AET_Level_Id = 1 AND NQF_Level_Id = 539 b.) AET_Level_Id = (2 OR 3 OR 4) AND NQF_Level_Id <> 539 c.) AET_Level_Id = 5 AND NQF_Level_Id <> 503.			ABI  Currently hardcode "1

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	Subject_Reg_Start_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Subject_Reg_Start_Date date is greater than Subject_Reg_End_Date	SACADO-17	Date Instituted	Check Dates.
  Fatal Error 02	Date is greater than today's date	SACADO-17	Date Instituted	Check Dates.
  Fatal Error 03	Date provided is unrealistic (pre 1900)	SACADO-17	Date Instituted	Check Dates.

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	Subject_Reg_End_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date	SACADO-17	Date Phased Out	Check Dates.

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	Provider_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Invalid combination of Provider_Code and Provider_ETQE_Id. The combination of Provider_Code and Provider_ETQE_Id must exist on 100 - Provider	GOPS-21	CPC	One of the values in CPC
  Fatal Error 02	Combination Provider_Code and Provider_ETQE_Id may not exist in 100 - Provider as  Parent_Provider_Code and Parent_Provider_ETQE_Id	GOPS-21	CPC	One of the values in CPC

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	Provider_ETQE_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains invalid Provider_ETQE_Id	SMNT-12	EP	See Defaults

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	Subject_Status_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Subject_Status_Id	iakactive		Any Active => 1, Not Active => 2 Any Active => 1, Not Active => 2
  Fatal Error 02	A valid Subject_Reg_End_Date value is required if Subject_Status_Id has a value of 2	iakactive		Any Active => 1, Not Active => 2 Any Active => 1, Not Active => 2
  	Subject_Reg_End_Date must be left blank if Subject_Status_Id does not have a value of 2

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	Subject_Credit
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Value provided may not be less than 1	SACADO-17	Must be between 1 and 110	Check Credits.
  Fatal Error 02	Field contains a value greater than 110	SACADO-17	Must be between 1 and 110	Check Credits.

   

  File No	303	Menu	Content	What to Fix
  DDL   Name	Date_Stamp
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date		iallastupd/ iakindate /sysdate	Check Dates
  Fatal Error 02	Date provided is unrealistic (pre 1900)		iallastupd/ iakindate /sysdate	Check Dates

   

• 100, 301,303

• Field Name	Rules/Suggestions
  Programme_Code	iakqual
  Subject_Code	iaksubj
  Prog_Subj_Start_Date	iakindate
  Prog_Subj_End_Date	iakfodate
  Provider_Code	v_provider: CPC Default Campus on OT of curriculum
  Provider_ETQE_Id	SMNT-12 EP
  Prog_Subj_Status_Id	Iakactive: Any Active => 1, Not Active => 2
  Prog_Subj_Credit	Iakcredit: Must be between 1 and 110
  Prog_Subj_Type_Id	v_SubjTypeID: F3 1=Core, 2=Elective, 3=Fundamental
  Date_Stamp	iakindate/sysdate ALL date Formats as follows: YYYYMMDD

• Subjects {SACADO-10} where the Unit Standard is blank
• Subject Offering Type and Blocks {SACADO-12}
• Offering Types {GCS-5}
• Census Dates {GOPS-1}
• Curriculum {SACADO-17}
• For Qualifications {SACADO-1} where the SAQA-ID is blank and the Qualification Category in the Qualification Type {SCODE3-1} is not (I)nternal 

• 13000006	Items	Menu	Content	What to Fix.
  Missing Mandatory value for Programme Code:	Iakqual	SACADO-17	Qualification	Qualification Code
  Illegal character found in Programme Code:	Iakqual	SACADO-17	Qualification	Qualification Code
  Illegal String found in Programme Code:	Iakqual	SACADO-17	Qualification	Qualification Code
  Missing Mandatory value for Course/Subject Code:	Iaksubj	SACADO-17	Subject	Subject Code
  Illegal character found in Course/Subject Code:	Iaksubj	SACADO-17	Subject	Subject Code
  Illegal String found in Course/Subject Code:	Iaksubj	SACADO-17	Subject	Subject Code
  Missing Mandatory value for Registration Start Date. Setting to:	iakindate	SACADO-17	Date Instituted.	Check Dates
  Start Date is after todays date:	iakindate	SACADO-17	Date Instituted	Check Dates
  Start Date is before 01-Jan-1900:	iakindate	SACADO-17	Date Instituted	Check Dates
  Missing Mandatory value for Registration End Date. Setting to:	iakfodate	SACADO-17	Date Phased Out	Check Dates
  End Date is before 01-Jan-1900:	iakfodate	SACADO-17	Date Phased Out	Check Dates
  Start Date is after End Date:	iakfodate	SACADO-17	Date Phased Out	Check Dates
  End Date cannot be in the future:	iakfodate	SACADO-17	Date Phased Out	Check Dates
  Start and End Date differs by more than 3 years:	iakfodate	SACADO-17	Date Phased Out	Check Dates
  Missing Mandatory value for Provider Code:	v_provider_code	GOPS-21	CPC	One of the Values in CPC
  Illegal character found in Provider Code:	v_provider_code	GOPS-21	CPC	One of the Values in CPC
  Illegal String found in Provider Code:	v_provider_code	GOPS-21	CPC	One of the Values in CPC
  Missing Mandatory value for Provider ETQA ID:	v_etqe_id	SMNT-12	EP	Defaults
  Illegal character found in Provider ETQA ID:	v_etqe_id	SMNT-12	EP	Defaults
  Missing Mandatory value for Date Stamp:	v_date_stamp		iakindate/sysdate	Check Dates.
  Illegal Subject Credit. Must be between 1 and 110:	v_SubjCredit	SACADO-17	Must be between 1 and 110	Check Credits.

• 
  

  File No	307	Menu	Content	What to Fix
  DDL   Name	Programme_Code
  Field Type Rule	Field contains invalid characters –  field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Duplicate combination of Programme_Code, Subject_Code, Provider_Code and Provider_ETQE_Id	SACADO-17	Qualification	Qualification Code
  Fatal Error 02	Combination of Programme_Code, Provider_Code and Provider_ETQE_Id does not exist in 301 - Programme	SACADO-17	Qualification	Qualification Code

   

  File No	307	Menu	Content	What to Fix
  DDL   Name	Subject_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Combination of Subject_Code, Provider_Code and Provider_ETQE_Id does not exist in 303 - Subject	SACADO-17	Subject	Subject Code

   

  File No	307	Menu	Content	What to Fix
  DDL   Name	Prog_Subj_Start_Date	Next Cell		Last Cell
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Prog_Subj_Start_Date date is greater than Prog_Subj_End_Date	SACADO-17	Date Instituted.	Check Dates
  Fatal Error 02	Date is greater than today's date	SACADO-17	Date Instituted.	Check Dates
  Fatal Error 03	Date provided is unrealistic (pre 1900)	SACADO-17	Date Instituted.	Check Dates

   

  File No	307	Menu	Content	What to Fix
  DDL   Name	Prog_Subj_End_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date	SACADO-17	Date Phased Out	Check Dates

   

  File No	307	Menu	Content	What to Fix
  DDL   Name	Provider_ETQE_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains invalid Provider_ETQE_Id	SMNT-12	EP	Defaults

   

  File No	307	Menu	Content	What to Fix
  DDL   Name	Prog_Subj_Status_Id
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ-1234567890@_
  Fatal Error 01	Field contains an invalid Prog_Subj_Status_Id	iakactive	Date	Any Active => 1, Not Active => 2
  Fatal Error 02	A valid Prog_Subj_End_Date value is required if Prog_Subj_Status_Id has a value of 2	iakactive	Date	Any Active => 1, Not Active => 2
  	Prog_Subj_End_Date must be left blank if Prog_Subj_Status_Id does not have a value of 2

   

  File No	307	Menu	Content	What to Fix
  DDL   Name	Prog_Subj_Credit
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Value provided may not be less than 1	SACADO-17	Must be between 1 and 110	Check Credits.
  Fatal Error 02	Field contains a value greater than 110	SACADO-17	Must be between 1 and 110	Check Credits.

   

  File No	307	Menu	Content	What to Fix
  DDL   Name	Prog_Subj_Type_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Prog_Subj_Type_Id	SMNT-12	F3	1=Core, 2=Elective, 3=Fundamental

   

  File No	307	Menu	Content	What to Fix
  DDL   Name	Date_Stamp
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date		Iakindate /sysdate	Check Dates.
  Fatal Error 02	Date provided is unrealistic (pre 1900)		Iakindate sysdate	Check Dates.

   

• 503(301,303,307,400,401,501) or 401

• Student Biographical {SREGB-1}
  • Students registered for the reporting year
• Personnel Biographical {PBOP-1}
  • Personnel Members that have been in-service during the reporting year

• 3000007	Items	Menu	Content	What to Fix.
  Missing Mandatory value for Equity. Setting to "U"nknown'	Iadethn SREGB-1 p2 Group	GCS-7 Group Codes	GOPS-21 EQT	One of the Values in EQT
  Illegal Equity Conversion	Iadethn SREGB-1 p2 Group	GCS-7 Group Codes	GOPS-21 EQT	One of the Values in EQT
  Illegal Nationality Conversion	Iadcntryc SREGB-1 p2 Country Code	GCS2-6 Citizenship Codes	GOPS-21 NAT	One of the Values in NAT
  Illegal Language Conversion:	Iadpreflang SREGB-1 Preffered Lang	GCS-6 Language codes	GOPS-21 LNG	One of the Values in LNG
  Missing Mandatory value for Citizen Resident Status. Setting to "U"nknown'	Iadindalien SREGB-1 Non-Resident	Hardcoded P => PR Permanent Resident N => SA South Africa Y => O Other  => U Unknown	CRS	Needed Value.
  Illegal Citizen Resident Status Conversion	Iadindalien SREGB-1 Non-Resident	P => PR Permanent Resident N => SA South Africa Y => O Other  => U Unknown	CRS	Check Value
  Illegal Province Code Conversion	Innprovc	GCS2-5 Province Codes	GOPS-21 PRV	One of the Values in PRV
  Illegal character found in National ID:	Iadidno	SREGB-1	ID No	Check ID No. Only Numeric.
  National ID assigned to more than one student	Iadidno	SREGB-1	ID No	Query ID No. Only Numeric
  Gender in National ID differs from Gender field	iadidno	SREGB-1	ID No	Check Gender. 0-4 Female 5-9 Male
  Illegal National ID. Must be 13 characters long	iadidno	SREGB-1	ID No	Check ID No. Only Numeric
  National ID May not contain 0000 in Position 1 - 4	iadidno	SREGB-1	ID No	Check ID No. Only Numeric
  National ID May not contain 0000 in Position 7 - 10	iadidno	SREGB-1	ID No	Check ID No. Only Numeric
  National ID May not contain String like	iadidno	SREGB-1	ID No	Check ID No. Only Numeric
  Illegal character found in Person Alt ID	Iadstno	SREGB-1	StudentNo	Numeric Only no spaces.
  Illegal String found in Person Alt ID	Iadstno	SREGB-1	StudentNo	Numeric Only no spaces.
  Illegal character found in Alt ID Type	v_alt_id_type	SMNT-12	AI	Hardcode "537"
  Missing Mandatory value for Equity Code	Iadethn SREGB-1 p Group	GOPS-21	EQT	One of the Values in EQT
  Illegal character found in Equity Code	Iadethn SREGB-1 p2 Group	GOPS-21	EQT	One of the Values in EQT
  Missing Mandatory value for Nationality Code	Iadcntryc SREGB-1 p2 Country Code	GOPS-21	NAT	One of the Values in NAT
  Illegal character found in Nationality Code	Iadcntryc SREGB-1 p2 Country Code	GOPS-21	NAT	One of the Values in NAT
  Missing Mandatory value for Home Language	Iadpreflang SREGB-1 Preffered Lang	GOPS-21	LNG	One of the Values in LNG
  Illegal character found in Home Language	Iadpreflang SREGB-1 Preffered Lang	GOPS-21	LNG	One of the Values in LNG
  Missing Mandatory value for Gender Code	Iadsex	SREGB-1	Gender	No conversion was needed.
  Illegal character found in Gender	Iadsex	SREGB-1	Gender	No conversion was needed.
  Missing Mandatory value for Citizen Resident Status:	Iadindalien SREGB-1	Hardcoded P => PR Permanent Resident N => SA South Africa Y => O Other  => U Unknown	CRS	Needs a value.
  Illegal character found in Citizen Resident Status	Iadindalien SREGB-1	Hardcoded P => PR Permanent Resident N => SA South Africa Y => O Other  => U Unknown	CRS	Needs a value.
  Missing Mandatory value for Disability Status	v_disability	GOPS-21	DIS	One of the Values.Must have Zero infront ‘01’
  Illegal character found in Disability Status	v_disability	GOPS-21	DIS	One of the Values.Must have Zero infront ‘01’
  Illegal character found in Seeing Disability	v_seeing'	GOPS-21	DI2	One of the Values.Must have NO Zero ‘1’
  Illegal character found in Hearing Disability	v_hearing	GOPS-21	DI3	One of the Values.Must have NO Zero ‘1’
  Illegal character found in Walking Disability	v_walking	GOPS-21	DI4	One of the Values.Must have NO Zero ‘1’
  Illegal character found in Remembering Disability	v_remembering	GOPS-21	DI5	One of the Values.Must have NO Zero ‘1’
  Illegal character found in Comunicating Disability	v_comunicating	GOPS-21	DI6	One of the Values.Must have NO Zero ‘1’
  Illegal character found in Self-Care Disability	v_selfCare	GOPS-21	DI7	One of the Values.Must have NO Zero ‘1’
  Missing Mandatory value for Person Last Name	iadsurn	SREGB-1	Surname	Fix Surname.
  Illegal character found in Person Last Name	iadsurn	SREGB-1	Surname	Fix Surname.
  llegal String found in Person Last Name	iadsurn	SREGB-1	Surname	Fix Surname.
  Missing Mandatory value for Person First Name	iadnames	SREGB-1	Name	Fix name.
  Illegal character found in Person First Name	iadnames	SREGB-1	Name	Fix name.
  Illegal String found in Person First Name	iadnames	SREGB-1	Name	Fix name.
  Illegal character found in Person Middle Name	v_middleName	SREGB-1	Alt Name	Fix alternate name.
  Illegal String found in Person Middle Name	v_middleName	SREGB-1	Alt Name	Fix alternate name.
  Ignoring student flagged as Duplicate	iadnames	SREGB-1	Name	Fix name.
  Ignoring student flagged as Duplicate	iadsurn	SREGB-1	Surname	Fix Surname.
  Persons name and Surname may not be the same	iadsurn	SREGB-1	Surname	Fix Surname.
  Illegal character found in Person Title:	iadtitle	SREGB-1	Title	Fix Title
  Illegal String found in Person Title	iadtitle	SREGB-1	Title	Fix Title
  Missing Mandatory value for Birth Date	iadbirdat	SREGB-1	Birthdate	Enter Birthdate.
  Birth Date is before 01-Jan-1850	iadbirdat	SREGB-1	Birthdate	Fix Birthdate
  Student may not be younger than 15	iadbirdat	SREGB-1	Birthdate	Fix Bbirthdate
  The Birth Date differs from the National ID Date Component	iadbirdat	SREGB-1	Birthdate	Birthdate and ID incorrect.
  Missing Mandatory value for Province Code	Innprovc	GOPS-21	PRV	One of the Values in PRV
  Missing Mandatory value for Date Stamp	iaddate	SREGB-1	Last Changed	Date Needed.
  Illegal character found in Home Address 1	v_homeAddr1	SREGB-1	Address	Fix the Address.
  Home Address 1 cannot contain only numbers	v_homeAddr1	SREGB-1	Address	Fix the Address.
  Illegal String found in Home Address 1	v_homeAddr1	SREGB-1	Address	Fix the Address.
  Illegal character found in Home Address 2	v_homeAddr2	SREGB-1	Address	Fix the Address.
  Home Address 2 cannot contain only numbers	v_homeAddr2	SREGB-1	Address	Fix the Address.
  Illegal String found in Home Address 2	v_homeAddr2	SREGB-1	Address	Fix the Address.
  Illegal character found in Home Address 3	v_homeAddr3	SREGB-1	Address	Fix the Address.
  Home Address 3 cannot contain only numbers:	v_homeAddr3	SREGB-1	Address	Fix the Address.
  Illegal String found in Home Address 3	v_homeAddr3	SREGB-1	Address	Fix the Address.
  Home Address 3 cannot contain 4 Consecutive numbers:	v_homeAddr3	SREGB-1	Address	Fix the Address.
  Illegal character found in Home Post Code	v_homePCode	SREGB-1	Postal Code	Fix the postal code.
  Home Post Code must contain exactly 4 characters:	v_homePCode	SREGB-1	Postal Code	Fix the postal code
  Illegal character found in Postal Address 1	v_postAddr1	SREGB-1	Address	Fix the Address.
  Postal Address 1 cannot contain only numbers:	v_postAddr1	SREGB-1	Address	Fix the Address.
  Illegal String found in Postal Address 1	v_postAddr1	SREGB-1	Address	Fix the Address.
  Illegal character found in Postal Address 2	v_postAddr2	SREGB-1	Address	Fix the Address.
  Postal Address 2 cannot contain only numbers	v_postAddr2	SREGB-1	Address	Fix the Address.
  Illegal String found in Postal Address 2	v_postAddr2	SREGB-1	Address	Fix the Address.
  Illegal character found in Postal Address 3	v_postAddr3	SREGB-1	Address	Fix the Address.
  Postal Address 3 cannot contain only numbers:	v_postAddr3	SREGB-1	Address	Fix the Address.
  Illegal String found in Postal Address 3	v_postAddr3	SREGB-1	Address	Fix the Address.
  Postal Address 3 cannot contain 4 Consecutive numbers:	v_postAddr3	SREGB-1	Address	Fix the Address.
  Illegal character found in Postal Post Code	v_postPCode	SREGB-1	Postal Code	Fix the postal code.
  Postal Post Code must contain exactly 4 characters	v_postPCode	SREGB-1	Postal Code	Fix the postal code.
  Illegal character found in Student Phone Number	v_studPhone	SREGB-1	PhoneNo	Fix Phone Number.
  Illegal String found in Student Phone Number	v_studPhone	SREGB-1	PhoneNo	Fix Phone Number.
  Illegal character found in Cell Phone:	v_studCell	SREGB-1	CellNo	Fix Cell Number.
  Illegal String found in Cell Phone	v_studCell	SREGB-1	CellNo	Fix Cell Number
  Illegal character found in Fax Number:	v_studCell	SREGB-1	CellNo	Fix Cell Number
  Illegal String found in Fax Number:	v_studFax	SREGB-1	FaxNo	Fix Fax Number
  Illegal character found in EMail	v_studEMail	SREGB-1	Email	Fix Email
  Illegal String found in EMail	v_studEMail	SREGB-1	Email	Fix Email
  Invalid EMail Address	v_studEMail	SREGB-1	Email	Fix Email
  EMail Address does not contain an @ character:	v_studEMail	SREGB-1	Email	Fix Email
  Missing Mandatory value for Province Code	innprovc	GOPS-21	PRV	One of the Values in PRV
  Illegal character found in Province Code	innprovc	GOPS-21	PRV	One of the Values in PRV
  Illegal String found in Provider Code:	v_provider_code	GOPS-21	CPC	One of the Values in CPC
  Illegal character found in Provider Code	v_provider_code	GOPS-21	CPC	One of the Values in CPC
  Illegal character found in Provider ETQA ID	v_etqa_id	SMNT-12	EP.	Default
  Popi Act Decision Date cannot be in the future:	popiActDate

• 
  

  File No	400	Menu	Content	What to Fix
  DDL   Name	National_Id
  Field Type Rule	Field contains invalid characters – field may only contain characters like 1234567890
  Fatal Error 01	Both National_Id and Person_Alternate_Id are blank	SREGB-1	ID No	Check ID No. Only Numeric.
  Fatal Error 02	National_Id does not have a length of exactly 13	SREGB-1	ID No	Check ID No. Only Numeric.
  Fatal Error 03	National_Id contains 0000 from digits 7 - 10	SREGB-1	ID No	Check ID No. Only Numeric.
  Fatal Error 04	National_Id contains 0000 from digits 1 - 4	SREGB-1	ID No	Check ID No. Only Numeric.
  Fatal Error 05	Field contains invalid characters - field may not contain characters like 1111111111111 or 2222222222222 or 3333333333333 or 4444444444444 or 5555555555555 or 6666666666666 or 7777777777777 or 8888888888888 or 9999999999999	SREGB-1	ID No	Check ID No. Only Numeric.
  Fatal Error 06	Field must be blank if POPI_Act_Status_ID has a value of 2	SREGB-1	ID No	Check ID No. Only Numeric.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Alternate_Id
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ-1234567890@_
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	StudentNo	Numeric Only no spaces.
  Fatal Error 02	Invalid Alternate_Id_Type_Id provided for record with a Person_Alternate_Id value	SREGB-1	StudentNo	Numeric Only no spaces.
  Fatal Error 03	Invalid Alternate_Id_Type_Id provided for record without a Person_Alternate_Id value	SREGB-1	StudentNo	Numeric Only no spaces.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Alternate_Id_Type_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Alternate_Id_Type_Id
  Fatal Error 02	Duplicate combination of Alternate_Id_Type_Id, National_Id, Provider_Code and Provider_ETQE_Id for student record (duplicated national ID per provider)	SREGB-1	StudentNo	Numeric Only no spaces.
  Fatal Error 03	Duplicate combination of Alternate_Id_Type_Id and National_Id for person record (duplicated national ID)	SREGB-1	StudentNo	Numeric Only no spaces.
  Fatal Error 04	Duplicate combination of Alternate_Id_Type_Id, Person_Alternate_Id, Provider_Code and Provider_ETQE_Id for student record (duplicated student number per provider)	SMNT-12	AI	Hardcode "537"
  Fatal Error 05	Duplicate combination of Alternate_Id_Type_Id and Person_Alternate_Id for person record (duplicated alternate ID)	SMNT-12	AI	Hardcode "537"
  Fatal Error 06	Alternate_Id_Type_Id = 537 and combination of Alternate_Id_Type_Id, Person_Alternate_Id, National_Id, Provider_Code and Provider_ETQE_Id is not associated with any child records in files 501 and 503	SMNT-12	AI	Hardcode "537"
  Fatal Error 07	Alternate_Id_Type_Id <> 537 and combination of Alternate_Id_Type_Id, Person_Alternate_Id and National_Id is not associated with any child records in files 401, 501 and 503	SMNT-12	AI	Hardcode "537"

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Equity_Code
  Field Type Rule	Field contains invalid characters field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid Equity_Code	GOPS-21	EQT	One of the Values in EQT

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Nationality_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid Nationality_Code	GOPS-21	NAT	One of the Values in NAT

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Home_Language_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid Home_Language_Code	GOPS-21	LNG	One of the Values in LNG

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Gender_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid Gender_Code	SREGB-1	Gender	No conversion was needed.
  Fatal Error 02	Gender component of National_Id does not match with gender code value supplied in Gender_Code. The 7th character of a SA National ID indicates a gender of female when less than 5 and male when greater than 4.	SREGB-1	Gender	No conversion was needed.

    

  File No	400	Menu	Content	What to Fix
  DDL   Name	Citizen_Resident_Status_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid Citizen_Resident_Status_Code	Hardcoded P => PR     Permanent Resident N => SA     South Africa Y => O       Other    => U       Unknown			CRS	Needs a value.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Disability_Status_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid Disability_Status_Code	GOPS-21	DIS	One of the Values.Must have Zero infront ‘01’

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Last_Name
  Field Type Rule	Field contains invalid characters –  field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ`' -
  Fatal Error 01	Field contains invalid characters –  field may not contain characters like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	Surname	Fix Surname.
  Fatal Error 02	Field must be blank if POPI_Act_Status_ID has a value of 2	SREGB-1	Surname	Fix Surname.
  Fatal Error 03	A value for this field must be provided if POPI_Act_Status_ID does not have a value of 2	SREGB-1	Surname	Fix Surname.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_First_Name
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ`'-
  Fatal Error 01	Field contains invalid characters – field may not contain characters like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	Name	Fix name.
  Fatal Error 02	Field must be blank if POPI_Act_Status_ID has a value of 2	SREGB-1	Name	Fix name.
  Fatal Error 03	A value for this field must be provided if POPI_Act_Status_ID does not have a value of 2	SREGB-1	Name	Fix name.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Middle_Name
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ`' -
  Fatal Error 01	Field contains invalid characters - field may not contain characters like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	Alt Name	Fix alternate name.
  Fatal Error 02	Field must be blank if POPI_Act_Status_ID has a value of 2	SREGB-1	Alt Name	Fix alternate name.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Title
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ`' -
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	Title	Fix Title
  Fatal Error 02	Field contains invalid characters - field may not contain characters like NA or U or NONE or GEEN	SREGB-1	Title	Fix Title

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Birth_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date provided is unrealistic (pre 1850)	SREGB-1	Birthdate	Fix Birthdate

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Home_Address_1 Person_Home_Address_2 Person_Home_Address_3
  Field Type Rule	Address_1 Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ -1234567890#&()/\:._`', Address_2 Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ -1234567890#&()/\:._`', Address_3 Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ -1234567890#&()/\:._`',
  Fatal Error 01	Address_1 Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or – Address_2 Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or – Address_3 Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	Address	Fix the Address.
  Fatal Error 02	Address_1 Field contains only numbers Address_2 Field contains only numbers Address_3 Field contains only numbers	SREGB-1	Address	Fix the Address.
  Fatal Error 03	Address_1 Field must be blank if POPI_Act_Status_ID has a value of 2 Address_2 Field must be blank if POPI_Act_Status_ID has a value of 2 Address_3 Field may not contain four consecutive numbers – field possibly contains a postal code or address layout is incorrect	SREGB-1	Address	Fix the Address.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Postal_Address_1 Person_Postal_Address_2 Person_Postal_Address_3
  Field Type Rule	Address_1  and 2 and 3 Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ -1234567890#&()/\:._`',
  Fatal Error 01	Address_1  and 2 and 3 Field contains only numbers	SREGB-1	Address	Fix the Address.
  Fatal Error 02	Address_1  and 2 Field must be blank if POPI_Act_Status_ID has a value of 2 Address_3 Field may not contain four consecutive numbers – field possibly contains a postal code or address layout is incorrect	SREGB-1	Address	Fix the Address.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Home_Addr_Postal_Code Person_Postal_Addr_Post_Code
  Field Type Rule	Home Address Field contains invalid characters - field may only contain characters like 1234567890 Postal Address Field contains invalid characters - field may only contain characters like 1234567890
  Fatal Error 01	Home and Postal Incorrect postal code supplied	SREGB-1	Postal Code	Fix the postal code.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Phone_Number
  Field Type Rule	Field contains invalid characters –  field may only contain characters like 1234567890 ()/-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	PhoneNo	Fix Phone Number.
  Fatal Error 02	Field must be blank if POPI_Act_Status_ID has a value of 2	SREGB-1	PhoneNo	Fix Phone Number.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Cell_Phone_Number
  Field Type Rule	Field contains invalid characters – field may only contain characters like 1234567890 ()-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	CellNo	Fix Cell Number.
  Fatal Error 02	Field must be blank if POPI_Act_Status_ID has a value of 2	SREGB-1	CellNo	Fix Cell Number.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Fax_Number
  Field Type Rule	Field contains invalid characters – field may only contain characters like 1234567890 ()/-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	FaxNo	Fix Fax Number
  Fatal Error 02	Field must be blank if POPI_Act_Status_ID has a value of 2	SREGB-1	FaxNo	Fix Fax Number

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Email_Address
  Field Type Rule	Field contains invalid characters - field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890_.<>-@
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	SREGB-1	Email	Fix Email
  Fatal Error 02	E-mail address does not contain the @ character	SREGB-1	Email	Fix Email
  Fatal Error 03	Field must be blank if POPI_Act_Status_ID has a value of 2	SREGB-1	Email	Fix Email

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Province_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._,`'-
  Fatal Error 01	Field contains an invalid Province_Code	GOPS-21	PRV	One of the Values in PRV

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Provider_Code
  Field Type Rule	Field contains invalid characters field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –	GOPS-21	CPC	One of the Values in CPC
  Fatal Error 02	Invalid combination of Provider_Code and Provider_ETQE_Id. The combination of Provider_Code and Provider_ETQE_Id must exist on 100 - Provider	GOPS-21	CPC	One of the Values in CPC

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Provider_ETQE_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains invalid Provider_ETQE_Id	SMNT-12	EP.	Default

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Previous_Lastname
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ`' -	Not stored in ITS
  Fatal Error 01	Field contains invalid characters - field may not contain characters like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or 0 or TEST or %ONTBREEK% or NIL or - or –
  Fatal Error 02	Field must be blank if POPI_Act_Status_ID has a value of 2
  NON FATAL	Field contains invalid characters - field may not contain characters like NA or U or NONE or GEEN

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Previous_Alternate_Id
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ-1234567890@_	Not stored in ITS
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –
  Fatal Error 02	Incomplete previous person details supplied
  Fatal Error 03	Invalid Person_Previous_Alternate_Id_Type_Id provided for record with a Person_Previous_Alternate_Id value
  Fatal Error 04	Invalid Person_Previous_Alternate_Id_Type_Id provided for record without a Person_Previous_Alternate_Id value

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Previous_Alternate_Id_Type_Id
  Field Type Rule	Field may only contain numbers	Not stored in ITS
  Fatal Error 01	Field contains an invalid Person_Previous_Alternate_Id_Type_Id

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Previous_Provider_Code
  Field Type Rule	Field contains invalid characters – field may only contain characters like ABCDEFGHIJKLMNOPQRTSUVWXYZ1234567890@#&+() /\:._-
  Fatal Error 01	Field contains an invalid string like %UNKNOWN% or %AS ABOVE% or %SOOS BO% or %DELETE% or N/A or NA or U or NONE or GEEN or 0 or TEST or %ONTBREEK% or NIL or - or –
  Fatal Error 02	Invalid combination of Person_Previous_Provider_Code and Person_Previous_Provider_ETQE_Id. The combination of Person_Previous_Provider_Code and Person_Previous_Provider_ETQE_Id must exist on 100 - Provider

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Person_Previous_Provider_ETQE_Id
  Field Type Rule	Field may only contain numbers	Not stored in ITS
  Fatal Error 01	Field contains invalid Person_Previous_Provider_ETQE_Id

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Seeing_Rating_Id Hearing_Rating_Id Walking_Rating_Id Remembering_Rating_Id Communicating_Rating_Id Self_Care_Rating_Id
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid Seeing_Rating_Id Field contains an invalid Hearing_Rating_Id Field contains an invalid Walking_Rating_Id Field contains an invalid Remembering_Rating_Id Field contains an invalid Communicating_Rating_Id Field contains an invalid Self_Care_Rating_Id	GOPS-21	DI2   DI3 DI4 DI5 DI6 DI7	These must have a value.

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	POPI_Act_Status_ID
  Field Type Rule	Field may only contain numbers
  Fatal Error 01	Field contains an invalid POPI_Act_Status_ID

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	POPI_Act_Status_Date
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date
  Fatal Error 02	A value for this field must be provided if POPI_Act_Status_ID has a value of 1 or 2
  Fatal Error 03	Field must be blank if POPI_Act_Status_ID does not have a value of 1 or 2

   

  File No	400	Menu	Content	What to Fix
  DDL   Name	Date_Stamp
  Field Type Rule	Field may only contain a valid date in the format YYYYMMDD
  Fatal Error 01	Date is greater than today's date	SREGB-1	iaddate	paalastupd
  Fatal Error 02	Date provided is unrealistic (pre 1900)	SREGB-1	iaddate	paalastupd