DENTV TP GET TRANSACTIONS

TITLEVALUE
NAMEDENTV TP GET TRANSACTIONS
DESCRIPTIONReturns all of the Transaction type records from the Treatment Plan
Transaction/Exam file (228.2) for a particular patient..
TAGTXN
ROUTINEDENTVTP5
INPUT PARAMETERSSEQUENCE NUMBER1
INPUT PARAMETERDFN
DESCRIPTIONThis is a pointer to the PATIENT file.
PARAMETER TYPELITERAL
REQUIREDYES
MAXIMUM DATA LENGTH20
INPUT PARAMETERSSEQUENCE NUMBER2
INPUT PARAMETERTYPE
DESCRIPTIONThis flag (T, E, P, or S) indicates the type of records to retrieve.
T = transaction records
E = periodontal exams
P = periodontal screening & recording
S = soft tissue lesion

If not passed, default value is T
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH1
INPUT PARAMETERSSEQUENCE NUMBER3
INPUT PARAMETERSDT
DESCRIPTIONThis is an optional date in Fileman format. If passed only records
greater than or equal to this date will be retrieved.
If not passed, default value is Jan 1, 2002
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH7
INPUT PARAMETERSSEQUENCE NUMBER4
INPUT PARAMETEREDT
DESCRIPTIONThis is an optional date in Fileman format. If passed only records
less than or equal to this date will be retrieved.
If not passed, default value is TODAY
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH7
INPUT PARAMETERSSEQUENCE NUMBER5
INPUT PARAMETERPROV
DESCRIPTIONThis optional parameter will be the provider's record number (ien) to the
NEW PERSON file (i.e., their DUZ value). If passed, then only those
records with that provider will be returned.
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH12
RETURN VALUE TYPEGLOBAL ARRAY
RETURN PARAMETER DESCRIPTIONReturns a global array List[n] := txn data.
If there are problems, then the return will be List[1] := -1^message
The format of the Transaction data in each node will be:
List[n] := p1^p2^p3^p4^p5^p6^p7^p8^p9^p10^p11^p12^p13^p14^p15^p16^
p17^p18^p19^p20^p21^p22^p23^p24^p25^p26^p27^p28^p29^p30
p31^p32^p33^p34^p35^p36^p37 where
p1 := txn id p20 :=group
p2 := provider name p21 :=deleted flag (-1=true, 0=false)
p3 := ADA code p22 :=cost ($ amount)
p4 := ADA description p23 :=category (text)
p5 := aspect(VALUE from 228.3) p24 :=seq index (numeric)
p6 := chart type(VALUE from 228.3) p25 :=plaque index (numeric)
p7 := condition (VALUE from 228.3) p26 :=read only flag (-1=true)
p8 := material (VALUE from 228.3) p27 :=Date created (external)
p9 := region (VALUE from 228.3) p28 :=icd1 (external)
p10:= status (VALUE from 228.3) p29 :=icd2 (external)
p11:= date (external) p30 :=icd3 (external)
p12:= time counter (numeric) p31 :=icd4 (external)
p13:= tooth# (numeric) p32 :=icd5 (external)
p14:= surface (text) p33 :=ctv (numeric)
p15:= phase (numeric) p34 :=rvu (numeric)
p16:= isJuvenile (YES/NO/null) p35 :=Dental Encounter ien
p17:= chart# (numeric) p36 :=product line (text)
p18:= visible (YES/NO/null) p37 :=canal# (text)
p19:= next appt (YES/NO/null)
For Soft tissue leasions, each line format:
p1^p2^p3^p4^p5^p6^p7^p8^p9 where
p1 = transaction ID p6 = marker color
p2 = provider duz p7 = marker shape
p3 = fm date p8 = marker size
p4 = x coordinate p9 = description
p5 = y coordinate

For PerioExams, the data returned is a multiline list:
1st line: $# [starting record indicator]
2nd line: transaction ID ^ provider duz ^ pe exam#
3rd, 4th, 5th, ... lines: periodontal information
last line: $$ [ending record indicator]
The PC program needs to concantenate all the peridontal information
lines (lines 3,4,5,...,last-1) together to form one string (up to 604
bytes)

In all record types, the transaction ID and the Fileman internal record
number are the same.
AVAILABILITYAGREEMENT
INACTIVE
CLIENT MANAGER
WORD WRAP ONTRUE
VERSION
SUPPRESS RDV USER SETUP
APP PROXY ALLOWED