DENTV TP GET TRANSACTIONS (1905)    REMOTE PROCEDURE (8994)

Name Value
NAME DENTV TP GET TRANSACTIONS
TAG TXN
ROUTINE DENTVTP5
RETURN VALUE TYPE GLOBAL ARRAY
AVAILABILITY AGREEMENT
WORD WRAP ON TRUE
DESCRIPTION
Returns all of the Transaction type records from the Treatment Plan 
Transaction/Exam file (228.2) for a particular patient..
INPUT PARAMETER
  • DFN
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   20
    REQUIRED:   YES
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    This is a pointer to the PATIENT file.
    
  • TYPE
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   1
    REQUIRED:   NO
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    This 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
    
  • SDT
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   7
    REQUIRED:   NO
    SEQUENCE NUMBER:   3
    DESCRIPTION:   
    This 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
    
  • EDT
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   7
    REQUIRED:   NO
    SEQUENCE NUMBER:   4
    DESCRIPTION:   
    This 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
    
  • PROV
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   12
    REQUIRED:   NO
    SEQUENCE NUMBER:   5
    DESCRIPTION:   
    This 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.
    
RETURN PARAMETER DESCRIPTION
Returns a global array List[n] := txn data.
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)
If there are problems, then the return will be List[1] := -1^message
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
The format of the Transaction data in each node will be:
      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
 List[n] := p1^p2^p3^p4^p5^p6^p7^p8^p9^p10^p11^p12^p13^p14^p15^p16^
    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.
            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)