Skip to main content

Import Group Section

Import a group data file.

Prerequisites:

  • The imported file should be a .txt file, using tab-delimited fields.
  1. Click Select Data Import File.
    An Open dialog displays. Navigate to the file, click Open.
  2. Click Review Import Data.
  3. In the Successful Or Rejected Records field, select to display the information imported:
  • Select Successful to display correctly imported records.
  • Select Rejected to display records that have not been imported due to error.
  • Select Both to display correctly imported and rejected records.
  1. Click File Import Data.

Note: If your facility is using Netsmart ProviderConnect, importing authorization groups can be verified in the ProviderConnect Service Authorization form.

Group Import File Format

This import can support up to 40 definitions.

Field Name

Required

Field Type

Comments

Note: Columns must be delimited by tabs. 

   

Authorization Grouping

Yes

Free text

Name of the authorization group.

Must begin with an uppercase letter.

If the group already exists in the system or in the file, the record will not be processed

Effective Date

Conditional

Date

This field is required if the "Avatar MSO -> System Maintenance -> Authorization Grouping Definition ->->-> Enable Effective Date" registry setting is set to "Y". This field will be ignored if the registry setting is set to "N" and it is present in the file.

In the MMDDYYYY format.

Procedure Code Type 1

Yes

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 1

Yes

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Units 1

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 2

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 2

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 2

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 3

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 3

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 3

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 4

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 4

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 4

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 5

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 5

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 5

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 6

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 6

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 6

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 7

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 7

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 7

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 8

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 8

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 8

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 9

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 9

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 9

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 10

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 10

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 10

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 11

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 11

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 11

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 12

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 12

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 12

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 13

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 13

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 13

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 14

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 14

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 14

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 15

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 15

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 15

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 16

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 16

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 16

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 17

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 17

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 17

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 18

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 18

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 18

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 19

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 19

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 19

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 20

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 20

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 20

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 21

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 21

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 21

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 22

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 22

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 22

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 23

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 23

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 23

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 24

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 24

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 24

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 25

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 25

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 25

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 26

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 26

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 26

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 27

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 27

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 27

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 28

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 28

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 28

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 29

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 29

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 29

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 30

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 30

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 30

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 31

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 31

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 31

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 32

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 32

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 32

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 33

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 33

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 33

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 34

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 34

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 34

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 35

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 35

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 35

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 36

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 36

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 36

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 37

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 37

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 37

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 38

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 38

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 38

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 39

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 39

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 39

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.

Procedure Code Type 40

No

Single Select Dictionary

Must be C (CPT Code) or R (Revenue Code)

Procedure Code 40

Conditional

Single Select Dictionary

Must contain a valid procedure code of the previous Procedure Code Type.

Any duplicate codes entered will create an error

Required if Procedure Code Type is defined

Units 40

No

Numeric

Must be a number from 1 to 4 digits long

A 0 will be ignored.