Table Column Types

Data Element Examples:

• Addition to Caseload:

• Adjustment Code Lookup

• Caseload fields

• Database audit trail
  This data is copied to the 'RADplus_audit_database_tables' SQL table.

• Date
  Includes calendar functionality, Today and Yesterday buttons, Date add (T+xx or T-xx), and scrolling arrows for adjusting the date.
  Acceptable input formats are:
  • DDMM (current year) DDMMYY (specific year)
  • DD/MM/YYYY
  • D/M/YY
  • DD-MM-YYYY
  • D-M-YY
• Decimal
  Permits whole or decimal numbers.
• Diagnosis
• Diagnosis - IMO Mapped Search
  This search works with ICD-10 code lookups.

• Dictionary data elements.
  Dictionary values are modified in the Dictionary Update form.

  • Single response dictionary (unlocked dictionary).

  • Single response dictionary (locked dictionary).
    User-defined locked dictionaries can be edited once the dictionary is unlocked (Table Definition form).

  • Multiple response data elements (unlocked dictionary)

  • Multiple response data elements (locked dictionary)

• Dollar Amount
  Permits the use of decimals.
   

• Draft/Final data element (Avatar CWS)
  The functionality is available when workflow user notification and requirement lists are defined.
  The User List Management, and Notification Users forms define available users.

• Draft/Final (Document Routing) data element.
  This allows Document Routing to use Draft/Final functionality in a modeled form. Any table aliases will be cleared when this field is set back to Draft from Final, and a new alias filed every time the field is set from Draft to Final.
  Once a Draft/Final column is added to a table, it cannot be removed from that table or any associated forms. A new envelope must be remodeled, omitting the column. 

• Draft/Pending Approval/Final data element (CWS only).
  This functionality is available when workflow user notification and requirement lists are defined.
  Once a Draft/Pending Approval/Final column is added to a table, it cannot be removed from that table or any associated forms. A new envelope must be remodeled, omitting the column. 

• Episode Program Default
  Includes functionality to automatically default current episode/program data for the selected client.
• Integer
  Permits whole numbers.
• MSO Adjustment Code Lookup
• MSO CPT Service Code Lookup
• MSO UB92 Revenue Code Lookup

• Multiple iterations table

• Name
• Non Scrolling Free Text
  This is a field supporting a single line of text.
• Other Entity Lookup
  This is a lookup field for a category of your choosing, such as:
  • Appointment Group File
  • Batch Claim Processing File
  • Benefit Plan File
  • Client
  • Family File
  • Funding Source File
  • Incident File
  • Library File
  • MEDS File
  • Member
  • Mental Health Library File
  • Mental Retardation Library File
  • MSO Other Payer
  • Order Entry Group
  • Payor
  • Performing Provider File
  • Program Maintenance
  • Provider File
  • Referral
  • Site
  • Sliding Fee Table
  • Staff File
  • Treatment Plan File
  • User
• Percentage
  Permits the use of decimals.
• Phone Number
  Numeric field accepting values in the following formats:
  • (000)000-0000
  • 0000000000
  • 000-0000
  • 0000000
  • (000)000-0000 X0000
  • 0000000000X0000
• Picture
• Removal From Caseload:
• Scrolling Free Text
  This is a field supporting multiple lines of text.

• Selection leaf:
  Provides the ability to link a user-defined form to a treatment plan element.

• Service Code Lookup

• Service selection
  Provides the ability to link a user-defined form to a client service in the parent system.

• Signature
• Social Security Number
  Numeric field accepting values of 9 digits in the format of ###-##-#### or ###-##-###P.
• SQL Query fields
  These allow you to generate dynamic dictionaries based upon other tables in the same application. (Additional ODBC connections are not supported in these prompts.) 
• State Table Lookup
• Time
  Include the Current button, and use of scrolling arrows for Hours, Minutes, AM, and PM.
  Numeric field accepting values in the following formats:
  • HHMM (24 hour)
  • HH:MM AM or PM
  • H:M A or P

• Unique Record Identifier fields

  Associates a unique number to every record filed in a table, across different facilities and PATIDs.
  If a single numeric value is sought to find a row of data, these identifiers can be used.

• Workflow Notification
• ZIP Code
  Numeric field accepting values in the format of 00000 or 00000-0000.