Related Articles
How to read the FPS files
There are Two (2) FPS Files mapped to Wisenet Fields. You can open up the FPS files as exported from Wisenet. Using these field mappings you can see where this data sits in your Wisenet database.
Quick Tip
The quickest way to find a field is to type it into the Search function just above the table.
| FPS Name | FPS Field No | Field Length | FPS File 1 | Student Contract Section | Student Contract Name | Wisenet Field | Field Location |
|---|---|---|---|---|---|---|---|
| Data Accuracy Date | 1 | N | This date is produced when the FPS File report is run from Wisenet | ||||
| PEIs_UEN_No | 2 | 10 | N | intro | Unique Entity Number (UEN) | SGProviderUEN | Organisation |
| PEI_Name | 3 | Y | intro | Full Name of Private Education Institution (“PEI”) | Name | Organisation | |
| Bank_Insurer_Type | 4 | 2 | N | SGBankInsurerType | Organisation> Edutrust | ||
| FPS_Provider | 5 | 150 | Y | PEI-appointed FPS provider | SGFPSProvider | Organisation> Edutrust | |
| PEI_Facility_Account_No | 6 | 30 | N | SGFacilityAccountNo | Organisation> Edutrust | ||
| Facility_Valid_Till_Date | 7 | N | SGValidTilDate | Organisation> Edutrust | |||
| Protection_Scheme_Type | 8 | 1 | N | SGProtectionSchemeType | Course Offer Enrolment> FPS | ||
| STP_Requirement | 9 | 1 | Y | SGSTPRequirement | Course Offer Enrolment | ||
| Student_ID_Given_By_PEI | 10 | N | RefExport | Client | |||
| NRIC_FIN_No | 11 | 9 | Y | SGNRICFIN | Client | ||
| Student_Name | 12 | 66 | Y | Full Name of Student | FirstName + MiddleName + LastName | Client | |
| Date_Of_Birth | 13 | Y | Date of Birth (DD/MM/YYYY) | DOB | Client | ||
| Gender | 14 | N | Gender | Client | |||
| Singapore_Citizen_PR_Indicator | 15 | 1 | Y | SGCitizenPRStatus | Client | ||
| Nationality | 16 | N | Nationality | NZCountryOfCitizenshipID | Client | ||
| STP_Application_Date | 17 | N | SGSTPApplicationDate | Course Offer Enrolment | |||
| STP_IPA_Date | 18 | N | SGSTPIPADate | Client | |||
| STP_Issue_Date | 19 | N | SGSTPIssueDate | Client | |||
| STP_Expiry_Date | 20 | N | SGSTPExpiryDate | Client | |||
| STP_Cancellation_Date | 21 | N | SGSTPCancellationDate | Client | |||
| Full_Part_Time_Indicator | 22 | Y | Full-time or Part-time Course | StudyModeID | Client | ||
| Course_ID | 23 | Y | CourseCode | Course | |||
| Course_Title | 24 | Y | Schedule A | Name of Course | CourseDesc | Course | |
| Course_Start_Date | 25 | Y | Schedule A | Course Commencement Date | RegStartDate | Client | |
| Course_End_Date | 26 | Y | Schedule A | Course Completion Date | RegEndDate | Course Offer Enrolment | |
| Course_Durations_Not_More_Than_50_Hours_Or_30_Days_Declaration | 27 | N | Course Offer Enrolment | ||||
| Course_Durations_Month | 28 | Y | Schedule A | Course Duration (in months) | Combined: Duration is recorded in Course Enrolment, inherits from course offer & course. The reported value can be full time or part time, and this depends on the COR Study Mode | ||
| Fee_Protection_Status | 29 | 1 | SGFPSStatus | Course Offer Enrolment | |||
| Total_Course_Fee_Stated_In_Student_Contract | 30 | Y | Schedule B | Total Course Fees Payable | Course Fees | Course Offer Enrolment | |
| Total_Course_Fee_To_Be_Protected | 31 | N | SGFPSTotalProtectedFee | Course Offer Enrolment | |||
| Fee_Collection_Cap | 32 | Y | SGFeeCollectionCap | Course Offer Enrolment>FPS EduTrust-certified PEI (12-month) X/Z x 12 =where X is the total amount of the payable Course Fees set out in Schedule 2.1; Z is the total duration of Course (in months) as stipulated in Clause 1.4. | |||
| Course_Termination_Date | 33 | Y | RegActualEndDate | Course Offer Enrolment | |||
| Date_That_Refund_Instruction_Sent_To_Bank_By_PEI | 34 | Y | SGRefundRequestDate | Course Offer Enrolment>FPS | |||
| Course_Fee_Amount_Refunded | 35 | Y | SGRefundAmount | Course Offer Enrolment>FPS | |||
| Instalment_ID | 36 | Y | Schedule B | instalment number | SGInstalmentID | Course Offer Enrolment>FPS | |
| Scheduled_Payment_Amount | 37 | Y | Schedule B | Instalment Amount | SGScheduledAmount | Course Offer Enrolment>FPS | |
| Scheduled_Payment_Due_Date | 38 | Y | Schedule B | due date | SGScheduledDueDate | Course Offer Enrolment>FPS | |
| Escrow_Unique_No_Or_Insurance_Policy_No | 39 | 30 | Y | SGPolicyNumber | Course Offer Enrolment>FPS | ||
| Protection_Start_Date | 40 | Y | SGProtectionStartDate | Course Offer Enrolment>FPS | |||
| Protection_End_Date | 41 | Y | SGProtectionEndDate | Course Offer Enrolment>FPS | |||
| Amount_Received_By_The_PEI_From_Student | 42 | Y | SGAmountReceived | Course Offer Enrolment>FPS | |||
| Protection_Amount | 43 | Y | SGProtectionAmount | Course Offer Enrolment>FPS | |||
| Protection_Amount_Received_Date | 44 | Y | SGProtectionAmountReceivedDate | Course Offer Enrolment>FPS | |||
| Payment_Acknowledgement_No | 45 | 30 | Y | SGPaymentAcknowledgementNo | Course Offer Enrolment>FPS | ||
| FPS Waiver Reason | 46 | 2 | Y | SGWaiverReason | Course Offer Enrolment>FPS | ||
| Waiver Ref No. from CPE | 47 | 25 | SGWaiverRefNo | Course Offer Enrolment>FPS | |||
| CPE's approval date for FPS's Waiver | 48 | SGWaiverApprovalDate | Course Offer Enrolment>FPS | ||||
| Name of Sponsor Organization | 49 | 150 | SGSponsorOrganisation | Course Offer Enrolment>FPS | |||
| Any other useful Information | 50 | 100 | SGOtherInfo | Course Offer Enrolment>FPS | |||
| intro | NRIC Number (for SC/PR) / Passport Number and Student’s Pass Number (for international student) | NRIC Number (for SC/PR) / Passport Number and Student’s Pass Number | Client | ||||
| intro | Full Name of Parent/Legal Guardian*(if Student is under eighteen (18) years of age) | NoKFirstName + NoKMiddleName + NoKLastName | Client | ||||
| intro | NRIC/Passport Number | NoKPassportNumber | Client | ||||
| Schedule A | Type of award | QualificationCatID | Course | ||||
| 200 | Schedule A | Organization which Develops the Course | CourseDesigner | Course | |||
| 200 | Schedule A | Organization which Awards/Confers the Qualification: | AwardingProvider | Course | |||
| Schedule A | Course entry requirement(s) | SGSchedule1 | Course | ||||
| Schedule A | Course schedule with modules and/or subjects | SGSchedule1 | Course | ||||
| Schedule A | Scheduled holidays (public and school) and/or semester/term break for course | SGSchedule1 | Course | ||||
| Schedule A | Examination and/or other assessment period | SGSchedule1 | Course | ||||
| Schedule A | Expected examination results release date | SGSchedule1 | Course | ||||
| Schedule B | Examination / Moderation fee | Course Offer Enrolment Checklists where ChecklistType = Schedule2 and ChecklistItem is what ever you wish to display for each enrolment | |||||
| Course Checklists where ChecklistType = Schedule2.2 and ChecklistItem is what ever you wish to display for each enrolment | |||||||
| SGEdutrustIssueDate | Organisation> Edutrust | ||||||
| SGEdutrustCertificateNumber | Organisation> Edutrust | ||||||
| SGEdutrustExpiryDate | Organisation> Edutrust | ||||||
| SGEdutrustAwardStatus | Organisation> Edutrust | ||||||
| SGEdutrustAwardType | Organisation> Edutrust | ||||||
| intro | CPE Registration Number (where applicable) | SGCPERegistrationNumber | Organisation> Edutrust | ||||
| SGCPERegistrationDate | Organisation> Edutrust | ||||||
| SGCPERegistrationStatus | Organisation> Edutrust | ||||||
| SGCPERegistrationType | Organisation> Edutrust | ||||||
| SGCPEExpiryDate | Organisation> Edutrust | ||||||
| NominalHours | Course | ||||||
| 20 | SGPEIAcronym | Organisation | |||||
| SGCPERegistrationType | Course Offer Enrolment>FPS | ||||||
| 200 | SGRefundNotes | Course Offer Enrolment>FPS | |||||
| SGMonthsPerPayment | Course Offer Enrolment>FPS |