GetCollHistFlip

GetCollHistFlip
Input XML Tags

XML Tag	Definition	Notes
comcorp	Five digit system number assigned to each corp.	0
house	Six digit house number
cust	2 digit customer number
detail	0= Summary rcds only 1= Summary and Detail rcds	0
ascending	1= oldest first 2= current first	If not equal to '1' or '2', service will default to order2params.defhistflip. If equal to '1', the "type" field can be used, if equal to '2', the "type" field will be ignored.
count	Determines how many records are returned. Legal range is 1 - 999
type	Type of history record to be returned. If "ascending" is equal to '2', this value is ignored.	1=Open, 2=Close, 3=Change, 4=Step, 5=NPD Crtd, 6=NPD Routd, 7=NPD Cmplt, 8=NSF Chks, 9=Late Fees, 10= Bad WrtOff, 11=PartlPay, 12=Collector pmt, 13=Manaul Hold, 14=Manual collector, 15=Memo Correction, 16=Change Tally
timestamp	History record time stamp	If "ascending" equals '1', the service returns only those records whose create date are greater than the input TIMESTAMP. If "ascending" equals '2', the service returns only those records whose create date are less than or equal to the input TIMESTAMP.

Output XML Tags

XML Tag	Column Name	Data Type	Nullable	Definition
chsm_corp	CORP	CHAR	N	Five digit accounting corp number assigned to each corp
chsm_house	HOUSE	CHAR	N	Up to six digit house number
chsm_cust	CUST	CHAR	N	Two digit customer number
Open Group / Type 1
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - Open
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. MM/DD hh:mm
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
date				Beginning date delimiter
datedesc	DATEDESC	CHAR(4)		Date description
chsc_newdate	NEWDATE	DATETIME	Y	Transfer effective date. Valid Values: MM/DD/YY
/date				Ending date delimiter
path				Beginning path delimiter
chsc_newpath	NEWPATH	SMALLINT SIGNED	N	Collection Path the account now has with this change. Valid Values:
pathdesc	PATHDESC	CHAR(8)	N	Newpath description
/path				Ending path delimiter
chsc_newclass	NEWCLASS	SMALLINT SIGNED	N	Collection Class the account now has with this change. Valid Values:
step				Beginning step delimiter
chsc_newstep	NEWSTEP	SMALLINT SIGNED	N	Collection Step the account now has with this change. Valid Values:
stepdesc	STEPDESC	CHAR(8)	N	Step description
/step				Ending step delimiter
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
Close Group / Type 2
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - Close
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. MM/DD hh:mm
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chsc_olddate	OLDDATE	DATETIME	Y	Step Date the account had before the change. Valid Values:
path				Beginning path delimiter
chsc_oldpath	OLDPATH	SMALLINT SIGNED	N	Collection Path the account had before the change. Valid Values:
pathdesc	PATHDESC	CHAR(8)	N	Newpath description
/path				Ending path delimiter
chsc_oldclass	OLDCLASS	SMALLINT SIGNED	N	Collection Class the account had before the change. Valid Values:
step				Beginning step delimiter
chsc_oldstep	OLDSTEP	SMALLINT SIGNED	N	Collection Step the account had before the change. Valid Values:
stepdesc	STEPDESC	CHAR(8)	N	Step description
/step				Ending step delimiter
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter

Change Group / Type 3
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - Change
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. MM/DD hh:mm
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chsc_olddate	OLDDATE	DATETIME	Y	Step Date the account had before the change. Valid Values:
path				Beginning path delimiter
chsc_oldpath	OLDPATH	SMALLINT SIGNED	N	Collection Path the account had before the change. Valid Values:
pathdesc	PATHDESC	CHAR(8)	N	Newpath description
/path				Ending path delimiter
chsc_oldclass	OLDCLASS	SMALLINT SIGNED	N	Collection Class the account had before the change. Valid Values:
step				Beginning step delimiter
chsc_oldstep	OLDSTEP	SMALLINT SIGNED	N	Collection Step the account had before the change. Valid Values:
stepdesc	STEPDESC	CHAR(8)	N	Step description
/step				Ending step delimiter
date				Beginning date delimiter
datedesc	DATEDESC	CHAR(4)		Date description
chsc_newdate	NEWDATE	DATETIME	Y	Transfer effective date. Valid Values: MM/DD/YY
/date				Ending date delimiter
path				Beginning path delimiter
chsc_newpath	NEWPATH	SMALLINT SIGNED	N	Collection Path the account now has with this change. Valid Values:
pathdesc	PATHDESC	CHAR(8)	N	Newpath description
/path				Ending path delimiter
chsc_newclass	NEWCLASS	SMALLINT SIGNED	N	Collection Class the account now has with this change. Valid Values:
step				Beginning step delimiter
chsc_newstep	NEWSTEP	SMALLINT SIGNED	N	Collection Step the account now has with this change. Valid Values:
stepdesc	STEPDESC	CHAR(8)	N	Step description
/step				Ending step delimiter
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
Step Group / Type 4
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - Step
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
chsm_histtype	HISTTYPE	NUMERIC SIGNED
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chsc_olddate	OLDDATE	DATETIME	Y	Step Date the account had before the change. Valid Values:
path				Beginning path delimiter
chsc_oldpath	OLDPATH	SMALLINT SIGNED	N	Collection Path the account had before the change. Valid Values:
pathdesc	PATHDESC	CHAR(8)	N	Newpath description
/path				Ending path delimiter
chsc_oldclass	OLDCLASS	SMALLINT SIGNED	N	Collection Class the account had before the change. Valid Values:
step				Beginning step delimiter
chsc_oldstep	OLDSTEP	SMALLINT SIGNED	N	Collection Step the account had before the change. Valid Values:
stepdesc	STEPDESC	CHAR(8)	N	Step description
/step				Ending step delimiter
productsgroup				Beginning productsgroup delimiter
type_version	TYPE/VERSION	CHAR(4)	N	1st character = type; 2-4 characters = formversion
/productsgroup				Ending productsgroup delimiter
date				Beginning date delimiter
datedesc	DATEDESC	CHAR(4)		Date description
chsc_newdate	NEWDATE	DATETIME	Y	Transfer effective date. Valid Values: MM/DD/YY
/date				Ending date delimiter
path				Beginning path delimiter
chsc_newpath	NEWPATH	SMALLINT SIGNED	N	Collection Path the account now has with this change. Valid Values:
pathdesc	PATHDESC	CHAR(8)	N	Newpath description
/path				Ending path delimiter
chsc_newclass	NEWCLASS	SMALLINT SIGNED	N	Collection Class the account now has with this change. Valid Values:
step				Beginning step delimiter
chsc_newstep	NEWSTEP	SMALLINT SIGNED	N	Collection Step the account now has with this change. Valid Values:
stepdesc	STEPDESC	CHAR(8)	N	Step description
/step				Ending step delimiter
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
NPD Crdt Group / Type 5
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - NPD Crdt
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chse_npdate	NPDDATE	DATETIME	Y	Creation Date for the report.. Valid Values MM/DD/YY
productsgroup				Beginning productsgroup delimiter
type_version	TYPE/VERSION	CHAR(4)	N	1st character = type ; 2-4 characters = formversion
/productsgroup				Ending productsgroup delimiter
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
NPD Routd Group / Type 6
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - NPD Routd
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chse_npdate	NPDDATE	DATETIME	Y	Creation Date for the report.. Valid Values
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
NPD Cmplt Group / Type 7
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - NPD Cmplt
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
NSF Chks Group / Type 8
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - NSF Chks
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chse_payment	PAYAMT	NUMERIC SIGNED	Y	The amount of the payment. Valid Values:
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
Late Fees Group / Type 9
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - Late Fees
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chse_payment	PAYAMT	NUMERIC SIGNED	Y	The amount of the payment. Valid Values:
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
BD WrtOff Group / Type 10
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - BD WrtOff
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chse_payment	PAYAMT	NUMERIC SIGNED	Y	The amount of the payment. Valid Values:
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
Partl Pay Group / Type 11
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description - Partl Pay
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chsc_olddate	OLDDATE	DATETIME	Y	Step Date the account had before the change. Valid Values:
path				Beginning path delimiter
chsc_oldpath	OLDPATH	SMALLINT SIGNED	N	Collection Path the account had before the change. Valid Values:
pathdesc	PATHDESC	CHAR(8)	N	Newpath description
/path				Ending path delimiter
chsc_oldclass	OLDCLASS	SMALLINT SIGNED	N	Collection Class the account had before the change. Valid Values:
step				Beginning step delimiter
chsc_oldstep	OLDSTEP	SMALLINT SIGNED	N	Collection Step the account had before the change. Valid Values:
stepdesc	STEPDESC	CHAR(8)	N	Step description
/step				Ending step delimiter
chse_payment	PAYAMT	NUMERIC SIGNED	Y	The amount of the payment. Valid Values:
date				Beginning date delimiter
datedesc	DATEDESC	CHAR(4)		Date description
chsc_newdate	NEWDATE	DATETIME	Y	Transfer effective date. Valid Values: MM/DD/YY
/date				Ending date delimiter
path				Beginning path delimiter
chsc_newpath	NEWPATH	SMALLINT SIGNED	N	Collection Path the account now has with this change. Valid Values:
pathdesc	PATHDESC	CHAR(8)	N	Newpath description
/path				Ending path delimiter
chsc_newclass	NEWCLASS	SMALLINT SIGNED	N	Collection Class the account now has with this change. Valid Values:
step				Beginning step delimiter
chsc_newstep	NEWSTEP	SMALLINT SIGNED	N	Collection Step the account now has with this change. Valid Values:
stepdesc	STEPDESC	CHAR(8)	N	Step description
/step				Ending step delimiter
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
Clctr Pmt Group / Type 12
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description -Clctr Pmt
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
chse_payment	PAYAMT	NUMERIC SIGNED	Y	The amount of the payment. Valid Values:
collectortype	COLECTORTYPE	CHAR(5)	N
chsc_collector	COLLECTOR	CHAR(6)	N	Designates the collector id or agency. Valid Values: if 1st position is '*' then 2nd is 95 code agencytable otherwise is the collector ID.
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
Mnl Hold Group / Type 13
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description -Mnl Hold
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
hold_desc	HOLDDESC	CHAR(21)	N	Description of hold type
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
Mnl Clctr Group / Type 14
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description -Mnl Clctr
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
Memo Corr Group / Type 15
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description -Memo Corr
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter
Chg Tally Group / Type 16
historygroup				Beginning historygroup delimiter
summary				Beginning summary delimiter
timestamp		DATETIME	N	Timestamp of the record; YYYY-MM-DD:hh:mm:ss.nnnnnn
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report MM/DD
histtype_shrtdsc	SHRTDSC	CHAR(9)	N	Short description -Chg Tally
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Oldestaging description
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
/summary				Ending summary delimiter
detail				Beginning detail delimiter
chsm_createdate	CREATEDATE	DATETIME	N	Creation Date for the report.. YYYY-MM-DD
histtype_longdsc	LONGDSC	CHAR(9)	N	1=open 2=close 3=change 4=step 5=NPD created6=NPD routed 7=NPD compltd 8=NSF check 9= Late Fee 10=Writeoff 11=Part Paymt 12=Colltr pymt13=Man Hold 14=Man colltr 15=Memo corr 16=tally
chsm_prognbr	PROGNBR	CHAR(3)	N	Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.
chsm_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction.
chsm_balance	BALANCE	NUMERIC SIGNED	N	Account Balance. Valid Values:
oldestagingdesc	OLDESTAGINGDESC	CHAR(3)	N	Account oldest aging bucket. Valid Values: 0=credit or zero 1=current 2=30 day 3=60 day 4=90 day 5= 120 and over is the highest aging
tally_type	TALLYTYPE	CHAR(19)	N	1=aging 2=mnths on cable 3=open to collctns 4=NPDcreated 5=NPD routed 6=NPD cmpltd 7=NSF checks 8=. Valid Values: Late fees 9=Writeoffs 10=Date ext 11=Partials 12=#Pymt 13=times at 120 14=times 90 15=a t 60 16=at 30
monthdesc		CHAR(9)	N	Month description
chst_oldlastdate	OLDLASTDATE	DATETIME	Y	What the Last Date was. Valid Values:
chst_oldtally	OLDTALLY	INT SIGNED	N	Old/previous tally count. Valid Values:
chst_newlastdate	NEWLASTDATE	DATETIME	Y	What the last date is. Valid Values:
chst_newtally	NEWTALLY	INT SIGNED	N	New tally count. Valid Values:
/detail				Ending detail delimiter
/historygroup				Ending historygroup delimiter

Source Tables

Change Log

6/13/01	Added timestamp tag to all historygroups
7/20/01	Modified "input" tag: timestamp definition

Usage

Associated XML Documents