Understanding the Collections Update Report Output

The XML file generated by the Collections Update (Collectupdate) report and is forwarded to Unique Management for update or synchronization reporting (depending on the mode in which the report is run). This XML file is structured as follows.

Field	Description	Example
<mode>	Defines the mode in which the report was run. Values are SUBMISSION, UPDATE, SYNCHRONIZE, TEST-SUBMISSION, TEST-UPDATE, and TEST-SYNCHRONIZE. The Collections Update report can be run in four modes: UPDATE or TEST-UPDATE and SYCHRONIZE or TEST-SYNCHRONIZE UPDATE mode is when the report is run to report users that are in collection that had activity since last debt reporting. SYNCHRONIZE mode is when the report was run to report ALL users in collections. The TEST- prefix indicates that the report was NOT run to update database records.	UPDATE
<created>	Describes the date the report was run.	6/2/2008, 10:45
<key>	File record number	514
<name_key>	User’s name, capitalized and formatted as LASTNAME FIRSTNAME for sorting.	DOE JOHN
<full_name>	User’s full name, shown in mixed case letters and formatted as Last name, First name, middle initial (if any).	Doe, John Q.
<last_name>	User’s last name, shown in mixed case letters.	Doe
<first_name>	User’s first name and middle initial (if any), shown in mixed case letters. If the user’s full name appears in field 2, this field is left blank.	John
<id>	User’s user ID number.	XXXX123456789
<alt_id>	Value in the Alt ID field in the user record. This alternate ID may be a Social Security Number or driver’s license number.	DL12345
<previous_id>	User’s previous ID	222
<previous_id>	User’s previous ID	111
<language>	User’s language in the user record.	ENGLISH
<profile>	User’s profile name listed in the Profile Name field in the user record.	PUBLIC
<birthdate>	User’s birthdate in the user record.	03/30/1957
<category1>	Value in the User Category 1 field in the user record, if any.	MALE
<category2>	Value in the User Category 2 field in the user record, if any.	HIGHSCHOOL
<category3>	Value in the User Category 3 field in the user record, if any.
<category4>	Value in the User Category 4 field in the user record, if any.
<category5>	Value in the User Category 5 field in the user record, if any.
<category6>	Value in the User Category 6 field in the user record, if any.
<category7>	Value in the User Category 7 field in the user record, if any.
<category8>	Value in the User Category 8 field in the user record, if any.
<category9>	Value in the User Category 9 field in the user record, if any.
<category10>	Value in the User Category 10 field in the user record, if any.
<category11>	Value in the User Category 11 field in the user record, if any.
<category12>	Value in the User Category 12 field in the user record, if any.
<care_of>	User’s name who is responsible for this user.	Mrs. John Doe Sr.
<day_phone>	Value in the DAYPHONE entry in the Addresses tab of the user record. This entry typically shows the daytime or work phone number for the user.	256-555-1414
<home_phone>	Value in the HOMEPHONE entry in the Addresses tab of the user record.	256-555-1234
<phone>	Value in the PHONE entry in the Addresses tab of the user record.	256-555-5678
<work_phone>	Value in the WORKPHONE entry in the Addresses tab of the user record.	256-555-9101
<zipcode>	User’s zip code. The ZIP entry in the Addresses tab of the user record is necessary to allow sorting by zip code.	35801
<address_line1>	Address line 1 of the mailing address block.	100 Main St.
<address_line2>	Address line 2 of the mailing address block.	Huntsville, AL
<address_line3>	Address line 3 of the mailing address block.
<address_line4>	Address line 4 of the mailing address block.
<address_line5>	Address line 5 of the mailing address block.
<bill_fines_due>	User’s total unpaid bill balance.	70.00
<first_delinquency_date>	Date of oldest unpaid bill. This date is shown in the date format configured for the SirsiDynix Symphony system, such as YYYYMMDD.	20080303
<total_amount_due>	Total amount due. This amount includes unpaid bill balances and the collection fee.	86.00
<amount_paid>	Amount this user has paid toward this bill.	40.00
<amount_forgiven>	This field is populated when paid bill(s) has a reason of PROCESSFEE and the payment type for the bill is CANCEL.	5.00
<value_returned>	This field is populated when paid bill(s) has a reason of LOST and the payment type for the bill is CANCEL.	25.00
<library>	There are two elements that describe the <library> element: <name> and <amount_due>. <name> is the Library policy name of the library that has an outstanding bill for this user. <amount_due> is the amount due to this library	MAIN 66.00
<bill_status>	If the bill is paid in full, then this field will contain the value ALLPAID.	ALLPAID
<paid_in_full_date_time>	The date/time the bill(s) paid in full. This value comes from the debtcollect master record (field name paid_in_full).	6/2/2009, 10:55

Sample XML output from the Collection Update report run in the UPDATE mode follows.

<mode>UPDATE</mode>

<user>

<name_key>PARKER PETER</name_key>

<full_name>Parker, Peter</full_name>

<last_name>Parker</last_name>

<first_name>Peter</first_name>

<alt_id>1000000000991</alt_id>

<previous_id>1000000001015</previous_id>

<previous_id>1000000001007</previous_id>

<language>ENGLISH</language>

<profile>PUBLIC</profile>

<category2>RESIDENT</category2>

<category3>ENGLISH</category3>

<care_of>Peter Parker</care_of>

<day_phone>888-555-1122</day_phone>

<home_phone>888-555-1133</home_phone>

<work_phone>888-555-1100</work_phone>

<address_line1>Peter Parker</address_line1>

<address_line2>100 North 1st</address_line2>

<address_line3>Apt B.</address_line3>

<address_line4>Maryville, IL</address_line4>

<address_line5>62062</address_line5>

</user>

<bill_fines_due>20.00</bill_fines_due>

<first_deliquency_date>20080602</first_deliquency_date>

<total_amount_due>20.00</total_amount_due>

<amount_paid>15.00</amount_paid>

<amount_forgiven>7.50</amount_forgiven>

<value_returned>5.00</value_returned>

<name>ROCKEFELLR</name>

<amount_due>15.00</amount_due>

</library>

<name>MORGAN</name>

<amount_due>5.00</amount_due>