| FileMan FileNo | FileMan Filename | Package | 
|---|---|---|
| 9002014 | MHSS EXTRACT LOG | Mental Health Social Services | 
| Package | Total | FileMan Files | 
|---|---|---|
| Mental Health Social Services | 2 | MHSS DATA TRANS ERROR CODES(#9002014.5)[.16] MHSS RECORD(#9002011)[#9002014.05101(.01), #9002014.2101(.01)] | 
| Utility Tables | 1 | LOCATION(#9999999.06)[.09] | 
| Field # | Name | Loc | Type | Details | 
|---|---|---|---|---|
| .001 | NUMBER | NUMBER | 
 | |
| .01 | BEGINNING DATE | 0;1 | DATE | ************************REQUIRED FIELD************************ 
 | 
| .02 | ENDING DATE | 0;2 | DATE | ************************REQUIRED FIELD************************ 
 | 
| .03 | RUN START DATE/TIME | 0;3 | DATE | ************************REQUIRED FIELD************************ 
 | 
| .04 | RUN STOP DATE/TIME | 0;4 | DATE | ************************REQUIRED FIELD************************ 
 | 
| .05 | COUNT OF ERRORS | 0;5 | NUMBER | 
 | 
| .06 | COUNT OF TRANSACTIONS | 0;6 | NUMBER | ************************REQUIRED FIELD************************ 
 | 
| .07 | FILE NAME CREATED | 0;7 | FREE TEXT | ************************REQUIRED FIELD************************ 
 | 
| .08 | COUNT OF VISITS PROCESSED | 0;8 | NUMBER | ************************REQUIRED FIELD************************ 
 | 
| .09 | RUN LOCATION | 0;9 | POINTER TO LOCATION FILE (#9999999.06) | ************************REQUIRED FIELD************************LOCATION(#9999999.06) 
 | 
| .11 | # ADDS | 0;11 | NUMBER | 
 | 
| .12 | # MODS | 0;12 | NUMBER | 
 | 
| .13 | # DELETES | 0;13 | NUMBER | 
 | 
| .15 | TRANSMISSION STATUS | 0;15 | SET | ************************REQUIRED FIELD************************ 
 
 | 
| .16 | PROCESSING ERROR ENCOUNTERED | 0;16 | POINTER TO MHSS DATA TRANS ERROR CODES FILE (#9002014.5) | MHSS DATA TRANS ERROR CODES(#9002014.5) 
 | 
| .17 | # ENCS | 0;17 | NUMBER | 
 | 
| .18 | # SUICIDE FORMS | 0;18 | NUMBER | 
 | 
| .19 | EXPORT FILENAME | 0;19 | FREE TEXT | 
 | 
| .21 | DATE RANGE EXPORT? | 0;21 | SET | 
 
 | 
| 2101 | RECORDS | 21;0 | POINTER Multiple #9002014.2101 | 9002014.2101 
 | 
| 3101 | SUICIDE FORMS | 31;0 | Multiple #9002014.03101 | 9002014.03101 | 
| 5101 | TRANSACTION ERRORS | 51;0 | POINTER Multiple #9002014.05101 | 9002014.05101 |