SelectWkAttendances
- James Overell
Returns current (temporary) work table for Attendances. User needs to be previously authenticated through LoginUser before being able to make a call to this web service. InsertWkAttendances needs to be previously called.
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. |
WKATTENDANCEMASTERSEQ |
Numeric |
Yes |
Work table attendance identifier to query on. |
Sample Input
<InputXML>
<VendorTokenGUID>3FC2ABA9-8F37-4CC9-934C-6ABCCA9F44B7</VendorTokenGUID>
<VendorPassword>s3cr3t</VendorPassword>
< WKATTENDANCEMASTERSEQ >123</ WKATTENDANCEMASTERSEQ >
</InputXML>
Relevant Database Object(s)
- spswkAttendances_ws
- spswkAttendances
Output Object (XML)
Element/Attribute |
|---|
wkAttendancesSeq |
AttendanceSeq |
ID |
StudentName |
StudentNameSort |
PossibleAbsenceCode |
PossibleDescription |
AttendedFlag |
PossibleReasonCode |
LateArrivalFlag |
LateArrivalTime |
EarlyDepartureFlag |
EarlyDepartureTime |
UserFlag1 |
UserFlag2 |
UserFlag3 |
UserFlag4 |
UserFlag5 |
PossibleNonAttendFlag |
PossibleNonAttendReason |
NonAttendAbsenceEventsSeq |
Status |
StatusDescription |
TodaysAttendanceString |
ActualAbsenceTypeCode |
ActualAbsenceReasonCode |
ActualEventComment |
AbsenceEventTypeSynergyMeaning |
AttendanceMasterSeq |
AlertsBlock |
MedicalAlertFlag |
MedicalAlert |
SpecialNeedsFlag |
SpecialNeedsDescription |
CommentWarningFlag |
CommentDescription |
ParentsSeparatedFlag |
ParentsSeparatedDescription |
CourtOrderFlag |
CourtOrderDescription |
Custom1Flag |
Custom1Description |
Custom2Flag |
Custom2Description |
Custom3Flag |
Custom3Description |
Custom4Flag |
Custom4Description |
Custom5Flag |
Custom5Description |
Custom6Flag |
Custom6Description |
Custom7Flag |
Custom7Description |
Custom8Flag |
Custom8Description |
Custom9Flag |
Custom9Description |
Custom10Flag |
Custom10Description |
StandardAlertsFlag |
CustomAlertsFlag |
|
See Also
- UpdateWkAttendances
- InsertWkAttendances
- TransferWkAttendances