InsertWkAttendances
- James Overell
Create and initialise work table prior to doing attendance-related operations
Input Object (XML)
Element |
SQL Data Type |
Mandatory |
Description |
VendorTokenGUID |
GUID |
Yes |
Specific GUID that Synergetic will give the third party app to validate them upon every web service request. |
VendorPassword |
Varchar(100) |
Yes |
Password provided to the vendor by CDA. |
FileType |
Varchar |
Yes |
File Type of class to do attendances on. |
FileYear |
Numeric |
Yes |
File Year of class to do attendances on. |
FileSemester |
Numeric |
Yes |
File Semester of class to do attendances on. |
ClassCampus |
Varchar |
Yes |
Campus of class to do attendances on. |
ClassCode |
Varchar |
Yes |
Class code to do attendances on. |
AttendaceDate |
Date |
Yes |
Attendance date. |
AttendancePeriod |
Numeric |
Yes |
Attendance period. |
StaffID |
Numeric |
Yes |
ID for class staff. |
TimeTableGroup |
Varchar |
Yes |
Attendance time table group. |
Sample Input
<InputXML>
<VendorTokenGUID>3FC2ABA9-8F37-4CC9-934C-6ABCCA9F44B7</VendorTokenGUID>
<VendorPassword>s3cr3t</VendorPassword>
<FileType>A</FileType>
<FileYear>2006</FileType>
<FileSemester>2</FileSemester>
<ClassCampus>J</ClassCampus>
<ClassCode>00EN1</ClassCode>
<AttendanceDate>2006-01-01</AttendanceDate>
<StaffID>56</StaffID>
<TimeTableGroup>JUN</TimeTableGroup>
</InputXML>
Output Object (XML)
Element/Attribute |
SQL Data Type |
Description |
Message |
Varchar(max) |
Contains message related to the operation. |
NewDataInsertedFlag |
Boolean |
Not used in this operation. |
wkAttendanceMasterSeq |
Numeric |
An identifier to be used with subsequent calls (mostly to manipulate / transfer) work table. |
See Also
- UpdateWkAttendances
- SelectWkAttendances
- TransferWkAttendances