ECMap gives you the ability to import record definitions from a fixed-length flat file in the format shown below:
Field |
Start column |
End column |
|---|---|---|
Record Name |
1 |
40 |
Field Name |
41 |
70 |
Field Type |
71 |
72 |
Field Length |
73 |
81 |
Number Decimals |
82 |
86 |
Date Format |
87 |
97 |
Century Type |
98 |
98 |
Century Minimum |
99 |
100 |
The record name can be up to 40 characters, but is truncated if it exceeds 40.
The last four fields may or may not be required based on the field type.
The century type should be one of the following for data fields:
1 = use field century minimum
2 = use global century minimum
3 = use no century minimum
Importing a record definition from a file in the
format shown on the previous page
Choose Application Files>Import Definitions>FROM FILE from the main menu.
The Import Records From File window displays.
Enter the name of the file from which you want to import a record definition
or
Browse for it.
Select Run to import the record definitions.
A message displays saying that your records were imported.
A sample ECMap import file is shown below:
ImportRecord MEMBER# AN 12 ImportRecord SRV# AN 20 ImportRecord YMD_BIRTH DT 8 YYYYMMDD 250 ImportRecord AMTALLOW-P DI 8 2 ImportRecord AMTCHARGE DE 8 2 ImportRecord AMTPAY DE 8 2 ImportRecord AMTCOPAY DE 8 2 ImportRecord AMTCO2NS DE 8 2 ImportRecord AMTRISK UI 8 ImportRecord AMTTPP UI 8 ImportRecord AMTDISCOUNT UI 8 ImportRecord M-PAY-APPLY DI 8 2 ImportRecord FFS-EQUIV DI 8 2 ImportRecord AUTHORIZATION# AN 12 ImportRecord CDR-REGION AN 2 ImportRecord CLAIM-TYPE AN 2 ImportRecord DIAG# AN 6 ImportRecord DIAG2# AN 6 ImportRecord DIAG3# AN 6 ImportRecord DIAG4# AN 6 ImportRecord DIAG5# AN 6 ImportRecord DIVISION# AN 10 ImportRecord DRG# AN 4 ImportRecord INPATDAYS DI 8 2 ImportRecord DOS DI 8 2 ImportRecord MEDICARE-FLAG AN 2 ImportRecord PCP-AFF# AN 16 ImportRecord PCP-IPA AN 2 ImportRecord PCP-OFFICE# AN 4 ImportRecord POS-AFF# AN 16 ImportRecord POS-IPA AN 2 ImportRecord POS-OFFICE# AN 4 ImportRecord POS-PRAC# AN 4 ImportRecord PROC# AN 6 ImportRecord PROC2# AN 6 ImportRecord PROC3# AN 6 ImportRecord PROG# AN 2 ImportRecord PT-SVC-OPT AN 2 ImportRecord SEX AN 2 ImportRecord VC-CNT DI 8 2 ImportRecord YMDEFF DT 8 MM/DD/YY 150 ImportRecord YMDEND DT 11 YYYY MON DD350 ImportRecord YMDPAIDDT DT 7 JULIAN 350
