| Function Name | Passed to function | Returned from function |
| AcYrName | Academic year ident code | Name of academic year |
| AddressLine | Address block & line number
| Single line of address |
| AdMake | 9address lines, may be blank | Single address block |
| AdPupPtype | Adult contact ident number | All pupils belonging to adult, separated by ',' |
| AdultName | Adult contact ident number | Adult contact address name |
AdultPhones
| Adult contact ident number | Adult phone numbers
|
AdultPhonesPriority
| Adult contact ident number | Phone numbers plus priority number
|
| AgeFrom | Pupils’ dob & current date | Number of years in pupils’ age |
AgeFromFloat
| Pupils’ dob & current date | Same value as AgeFrom, as a float
|
| AgeMonth | Pupils’ dob & current date | Number of months in age (i.e. x years and Y months) |
| AgeYearMonth | | |
AgeYearStart
| | |
AlertMark
| | |
| ApplicationType | Application Ident code | Application type |
| AsLook | Pupil ident no. & subject ident no. | Subject teacher ident no. |
| AsLook2 | Pupil ident no. & subject ident no. | Assessment comment |
AvClassAge
| | |
| BoardType | Boarding type ident no. | Boarder type (day or full) |
| BuildName | Building ident no. | Building name |
| BusDate | The resultant date from GNow() | “September (this ac yr) to July (this ac yr)” |
| BusPick | Pickup point ident no. | Bus route ident no. |
| BusPrice | Pickup point ident no. | Bus fare |
CheckPointName
| | |
ChildClass
| | |
| ChildFirstAndGiven | | |
| ChildName | Pu_CompNo old pupil ident no. | Pupil first & surnames |
| ChildOrig | PupOrigNum current pupil ident no. | Pupil given & surnames |
| ChildSurName | PupOrigNum | Pupil surname and first name |
| ChildSurNameGiven | | |
| ClassName | Class ident no. | Name of class |
CoversDone
| | |
CurrentAcYear
| | |
| DateGet | Date ident no. | Full calendar date |
DateIdent
| | |
DateIdentGet
| | |
DateMonthYear
| | |
| DateToString | | |
EthnicityName
| | |
EType
| | |
| ExamBoardNo | Enternal Board Ident no. | FBS Exam board ident no. |
| ExamCode | Exam option ident no. | Option code ident no. |
| ExamCodeExtra | PupOrigNum | Returns Check Sum for UCI no. |
| ExamName | Exam option ident no. | Name of subject option |
| FeatureName | Feature ident no. | Feature name |
| FeederName | Feeder school ident no. | Feeder school title |
GetAcYear
| | |
GetAcYearName
| | |
GetClass
| | |
| GetDateIdent | Largest date ident where diff between that and current date ident is zero | Current date ident no. |
GetFirstTelType
| | |
GetMaxRecharge
| | |
| GetRegType | Registration type ident no. | Registration type |
| GNow | Todays’ Date | current date as dd/mm/yyyy for SQL |
| GroupName | Subject group ident no. | Name of subject group |
GroupSub
| | |
| GroupYear | | |
| HasSibling | | |
| HeadSig | | |
| HeadTitle | | |
| House2Name | | |
| Nationalities | | |
| Offers | | |
| PeriodDayName | Period ident no. | Name of day in which period occurs. |
| PeriodName | Period ident no. | Period name (i.e. 1 to 9) |
PTName
| | |
PTypeName
| | |
| PupAppNotes | | |
PupInitials
| | |
| PupPType | | |
| RegMark | | |
| Religion | | |
| RoomName | Room ident no. | Room short name (e.g. A.9) |
| SanPlusMinus | | |
SchoolAddress
| | |
| SchoolType | Pupil type ident no. | Pupil type description |
| Scorer | Grade | Score |
SecurityLabel
| | |
SelectionCounter
| | |
| SiblingList | | |
| SplitSelect | | |
| StaffAddName | Staff user ident no. | Staff address name |
| StaffMnem | Staff user ident no. | Staff Mnemonic |
| StaffName | Staff user ident no. | Staff name |
StaffReportName
| | |
StaffSurname
| | |
| StaffTeaching | | |
SubjectCode
| | |
| SubjectName | Subject ident no. | Subject name |
| SubjSub | | |
| TagName | Tag ident no. | Title of tag |
| TimeFreeNote | Free time type ident no. | Free time type |
| TitleCase | | |
| TrimCust | | |
| TutGpName | | |
| UCILetter | | |
| VaccineType | | |
| YearFull | Pupil year ident no. | Full year name from Years table
|
| YearName | Pupil year ident no. | Name of year (e.g. 7g) |
| YearOrder | Pupil year ident no. | Number of year (i.e. no ‘g’ or ‘b’) |
