Functional systems analysis

profileRaup
FunctionalSpec_sample_1.docx
Home>Information Systems homework help>Functional systems analysis

Plan/ Plan ID: Georgia/GACO

LOB: Medicaid

Extract – Outbound

Application: CAS

Functional Spec

Project Title: GA Administrative Discharge Extract

JIRA# VSD-7641

CO # CO-15-0069

Implementation Date – Q2

Version 1.01

Beacon Health Options

Beacon Health Options

Last Updated: Feb 27, 2019

ii

Revision History

Version

Date

Revision Description

Revised By

1.01

02/25/2019

Initial Draft

1.02

Revisions

Revision History 2

II Functional Specifications 6

1 System(s) Affected: 6

2 Functional Specification 6

3 Create a new h istory table in CAS: 10

4 Business Rules 27

5 Error Reporting 29

6 File Format 32

7 File Naming Convention 32

8 File Processing 32

9 File Schedule 33

10 File Transfers 33

11 File Storage/ Archive 33

12 Notifications 34

13 Error Log Files 34

14 EDI Document Review and Approval 34

Sign off by at least one of the below is required: 34

15. Appendix 35

II Functional Specifications

The following specifications for internal use were discussed and agreed upon by appropriate members of BEACON’s staff.

1. System(s) Affected:

|_| Achieve Solutions®

|_| DevTrack

|_| Legacy IVRs

|_| SecurityConnect

|_| AuthLetterConnect

|X| EDI

|_| MBHP Checks

|_| ServiceConnect

|_| BenefitConnect

|_| eClaims

|_| MemberConnect

|_| StaffConnect

|_| Benefits on Line (BOL)

|_| ElectronicClaimConnect

|_| NetworkConnect

|_| TeleConnect

|X| CAS

|X| FileConnect

|_| OnDemand

|_| BEACON Health Alert

|_| CPTS

|_| HIPAA Letters

|_| OnTrack

|_| WRAP

|_| CareConnect

|_| HRConnect

|_| Oracle Financials

|_| Web Site

|_| Claims QuickView

|_| Healthy Connections

|_| ProviderConnect

|_| Web Based Training

|_| ClientConnect

|_| Hyperion

|_| QualityConnect

|_| FlexCare UI

|_| CommunicationConnect

|_| Infinium

|_| ReferralConnect

|_| FlexCare Databases

|_| DMHConnect

|_| KnowledgeConnect

|_| Scanning & Imaging

|_| Other: ___________

1. Functional Specification

Assumptions:

The goal of this project is to create an EDI process that shall notify the provider of the outcome (that these auth's have been discharged and the providers take this data and load them in to their EMR systems. So, that way they will know at the administrative level when the patients will be discharged and those patient if they come in for new service then the providers have to request in for new auth) of the discharge requests sent. This is an OB to Beacon that Admin discharges are going out the door to the respective providers.

There will be a need to create a new program to run the admin discharge job. EDI will schedule a job to run in the morning to extract the admin discharges created (CRM) and the responses are sent out to the providers. If CRM runs their batch discharge process at 11 pm every night M-F then EDI will be creating a new job schedule to run at 5 am every morning starting M-F.

Assumptions: Table starting with 'D' means data coming from CRM has valid and most accurate data.

· Create an EDI process that will validate the data/file sent contains all required information, as well as valid formatting.

· If an error is encountered when attempting to send the output files to their respective directory, then an email will be generated for resolution.

· Create a process that includes notifying the provider of the outcome of the discharge requests sent.

When the process selects discharges, it should only be selecting for those providers found in the crosswalk at the time the job is executed.  In other words, if we add a provider to the crosswalk, we are not going to go back and select all the admin discharges from the past to send to that provider. There will be a need to create unique submitter ID’s in the crosswalk so that the unique discharge records are extracted and sent out to the providers.

SUBMITTER ID: The CAS program should validate that only the unique Submitter ID is present in the crosswalk. The logic below details how the program should validate that a unique submitter ID is present in the crosswalk table. There could be multiple providers with submitter ID’s found in the crosswalk. But this process should only select the records that have providers who have discharged auths. These records are in AHDMAS. Select the records for only unique submitter ID to be sent to the provider.

When a new ADMIN discharge submitter is created in FileConnect, Beacon must be notified by DBHDD whether that provider should receive administrative discharge response files or not. If the provider is to receive administrative discharge response files, the service center must submit an IT request to add the provider to the GA Administrative Discharge response files crosswalk with a unique submitter ID (to be identified by DBHDD). EDI will update the corresponding submitter ID on the Crosswalk table.

Creation of Crosswalk Table for Submitter ID: The admin discharge records will be unique to each submitter.

Table Name: Crosswalk Table Maintenance (SECFLA.CWTMAS)

Field

Field Description

Type

Length

Notes

SRCSYS

Source System

“ADMINDCH”

TBLNUM

Table Number

“083”

TBLDSC

Table Description

A

4

“Admin Discharge Submitter ID”

USERAD

Added By User

A

10

SYSDAT

Add Date

Z

26

USERID

Last Changed By

A

10

LSTCHG

Last Changed Date

Z

26

Table Name: Crosswalk Maintenance (CWKMAS)

Field

Field Description

Type

Length

Notes

SRCSYS

Source System

“ADMINDCH”

TBLNUM

Table Number

“083”

PARENT

Parent Code

A

4

“GACO”

SRCVAL

Source Value 1

Requesting Provider ID

SRCVAL2

Source Value 2

SRCVAL3

Source Value 3

SRCVAL4

Source Value 4

STRTDT

Start Date

“0”

STOPDT

Stop Date

“9999999”

TRGTVL

Target Value 1

Submitter ID

TRGTVL2

Target Value 2

USERAD

Added By User

A

10

SYSDAT

Add Date

Z

26

USERID

Last Changed By

A

10

LSTCHG

Last Changed Date

Z

26

EDI Program: The admin discharge program will use automated ftp functionality to send the output files to the Providers identified by their unique submitter ID’s. The submitter ID’s are found in the crosswalk table created for admin discharge process. Table Name: Submitter ID

Field

Field Description

Type

Length

Notes

SUBMID

Submitter ID

A

10

Find CWKMAS.TRGTVL

Where CWKMAS.SRCSYS = “ADMINDCH”

and CWKMAS.TBLNUM = “083”

and CWKMAS.PARENT = “GACO”

and CWKMAS.SRCVAL = GBADMDCH.PRVID

If more than one submitter ID found in CWKMAS, do not process GA Administrative Discharge Response for this provider. Populate GA Administrative Discharge (GBADMDCH.ERRCOD) with error code ‘001’ and error message “More than one Submitter ID found in crosswalk.”

If no record found in CWKMAS, do not process GA Administrative Discharge Response for this provider. Populate GA Administrative Discharge (GBADMDCH.ERRCOD) with error code ‘002’ and error message “Submitter ID not found in crosswalk.”

When at least one error code is written to the history table in any one job, the program will send an email notification as outlined in the Email Notifications section below. The program should send a maximum of one GA Administrative Discharge Error notification email per job.

1. A new program should be created to select data - Mapping spreadsheet states how to populate the data from the source tables and write to the new GA Administrative Discharge history table GADHIST which will be created in CAS database.

New files need to be created: GADHIST

· GADHIST will be new history table in the EDIGACO library

· GADERR is the error table will be new in the EDIGACO library

· The history table/file GADHIST created for this process should mirror the layout of the GBDARCH.

Create a new history table in CAS: The history table will be GADHIST for extracting admin discharge records. This new table should mirror the table structure or the file layout ‘GBDARCH’. Below is the file/table layout with field definitions and mapping:

GADHIST – Admin Discharge History Table

FIELD_NAME

SOURCE TABLE

SOURCE FIELD

FIELD NOTES

FIELD LENGTH

DATA_TYPE

Business /Validation Rules

HISTID

 

 

Auto-assigned

15

NUMERIC

The extract output file will need to have start and end position columns.

TRNID

 

 

Auto-assigned

15

NUMERIC

FILEID

 

 

Auto-assigned

15

NUMERIC

FILEDT

 

 

Auto-assigned

7

DECIMAL

FILNAM

 

 

 

10

VARCHAR

EDISUBM

 

 

 

16

VARCHAR

SECPRST

 

 

 

1

CHAR

'SECPRST = '0' valid record and SECPRST = '1' ERROR AND DO NOT SEND

WRKSTA

 

 

 

1

CHAR

PARENT

CLNMAS

GACO

GACO

4

VARCHAR

TBLNUM = 81

MEMBNO

AHDMAS

MEMBNO

 

15

VARCHAR

LSTNAM

MEMMAS

LSTNAM

 

60

VARCHAR

FSTNAM

MEMMAS

FSTNAM

 

35

VARCHAR

AUTHNO1

DSCMAS

BRANCD BATDAT BATSEQ SEQNUM

Format: 01-CYYMMDD-000-000 Example: 01-2150922-001-006

25

VARCHAR

AUTSTA

 

 

Default to 'O" (Open)

1

CHAR

PRVNAM

DSCGA

BPRNAM

 

60

VARCHAR

PRVTAG

 

 

 

15

VARCHAR

PROVNO

CWKMAS

SRCVAL

 

15

VARCHAR

TRCKID

 

 

 

15

VARCHAR

VENDOR

AHDMAS

SVCVEN

 

15

VARCHAR

SUBMID

CWKMAS

TRGVL

 

10

VARCHAR

DISDAT1

DSCMAS

ACTDAT

MMDDYYYY

8

VARCHAR

DISRSN

DSCMAS

DRSCOD

 

2

VARCHAR

SVCDAT

DSCMAS

LSVDAT

MMDDYYYY

8

VARCHAR

DODDAT

DSCGA

DTHDAT

MMDDYYYY

8

VARCHAR

DTHFLG

DSCGA

DTHUNK

CYYMMDD

1

CHAR

DIAGN1

DCMMAS

BDICD1

 

8

VARCHAR

DIAGN2

DCMMAS

BDICD2

 

8

VARCHAR

DIAGN3

DCMMAS

BDICD3

 

8

VARCHAR

DIAGN4

DCMMAS

BDICD4

 

8

VARCHAR

DIAGN5

DCMMAS

BDICD5

 

8

VARCHAR

MEDDIA1

DCMMAS

MDICD1

 

8

VARCHAR

MEDDIA2

DCMMAS

MDICD2

 

8

VARCHAR

MEDDIA3

DCMMAS

MDICD3

 

8

VARCHAR

SOCIMP1

DCMMAS

AXFON

 

1

CHAR

SOCIMP2

DCMMAS

AXFEDU

 

1

CHAR

SOCIMP3

DCMMAS

AXFIN

 

1

CHAR

SOCIMP4

DCMMAS

AXFHCS

 

1

CHAR

SOCIMP5

DCMMAS

AXFLEG

 

1

CHAR

SOCIMP6

DCMMAS

AXFPRM

 

1

CHAR

SOCIMP7

DCMMAS

AXFNON

 

1

CHAR

SOCIMP8

DCMMAS

AXFOCC

 

1

CHAR

SOCIMP9

DSCMAS

AXFOTH

 

1

CHAR

SOCIMP10

DCSMAS

AXFFIN

 

1

CHAR

ASSMSR1

DSCGA

ASSMS1

 

1

CHAR

ASSSCR1

DSCGA

ASSSC1

 

6

VARCHAR

ASSOTH1

DSCGA

AS1OTH

 

25

VARCHAR

ASSMSR2

DSCGA

ASSMS2

 

1

CHAR

ASSSCR2

DSCGA

ASSSC2

 

6

VARCHAR

ASSOTH2

DSCGA

AS2OTH

 

25

VARCHAR

CLDFFAM

DSCCNANS

CNLDFFAM

 

1

CHAR

CLDFLIV

DSCCNANS

CNLDFLIV

 

1

CHAR

CLDFSOC

DSCCNANS

CNLDFSOC

 

1

CHAR

CLDFDEV

DSCCNANS

CNLDFDEV

 

1

CHAR

CLDFREC

DSCCNANS

CNLDFREC

 

1

CHAR

CLDFLEGL

DSCCNANS

CNLDFLEG

 

1

CHAR

CLDFMED

DSCCNANS

CNLDFMED

 

1

CHAR

CLDFPHYS

DSCCNANS

CNLDFPHY

 

1

CHAR

CLDFSLP

DSCCNANS

CNLDFSLP

 

1

CHAR

CLDFSEX

DSCCNANS

CNLDFSEX

 

1

CHAR

CLDFSCHBH

DSCCNANS

CNLDFBEH

 

1

CHAR

CLDFSCHAC

DSCCNANS

CNLDFACH

 

1

CHAR

CLDFSCHAT

DSCCNANS

CNLDFATT

 

1

CHAR

CRBSUIC

DSCCNANS

CNBEHSUI

 

1

CHAR

CRBSINJU

DSCCNANS

CNBEHMUT

 

1

CHAR

CRBSHARM

DSCCNANS

CNBEHHRM

 

1

CHAR

CRBDNGOTH

DSCCNANS

CNBEHDAN

 

1

CHAR

CRBSEXAGG

DSCCNANS

CNBEHSEX

 

1

CHAR

CRBRUNWAY

DSCCNANS

CNBEHRUN

 

1

CHAR

CRBDELINQ

DSCCNANS

CNBEHDEL

 

1

CHAR

CRBJUDG

DSCCNANS

CNBEHJDG

 

1

CHAR

CRBFIRE

DSCCNANS

CNBEHFIR

 

1

CHAR

CRBINTMIS

DSCCNANS

CNBEHMBH

 

1

CHAR

CRBSEXREA

DSCCNANS

CNBEHSRB

 

1

CHAR

CACCLANG

DSCCNANS

CNACCLAN

 

1

CHAR

CACCIDNT

DSCCNANS

CNACCIDT

 

1

CHAR

CACCRITUL

DSCCNANS

CNACCRIT

 

1

CHAR

CACCSTRES

DSCCNANS

CNACCSTR

 

1

CHAR

CBPSYCHS

DSCCNANS

CNNEDPSY

 

1

CHAR

CBCONCEN

DSCCNANS

CNNEDATT

 

1

CHAR

CBIMPULS

DSCCNANS

CNNEDIMP

 

1

CHAR

CBDEPRES

DSCCNANS

CNNEDDEP

 

1

CHAR

CBANXIET

DSCCNANS

CNNEDANX

 

1

CHAR

CBOPPOS

DSCCNANS

CNNEDOPP

 

1

CHAR

CBCONDCT

DSCCNANS

CNNEDCON

 

1

CHAR

CBATTACH

DSCCNANS

CNNEDACH

 

1

CHAR

CBEATING

DSCCNANS

CNNEDDIS

 

1

CHAR

CBREGRES

DSCCNANS

CNNEDBRG

 

1

CHAR

CBSOMAT

DSCCNANS

CNNEDSOM

 

1

CHAR

CBANGER

DSCCNANS

CNNEDANG

 

1

CHAR

TSSTRAUM

DSCCNANS

CNTRMTRM

 

1

CHAR

TSSGRIEF

DSCCNANS

CNTRMGRF

 

1

CHAR

TSSREEXP

DSCCNANS

CNTRMREX

 

1

CHAR

TSSAROUS

DSCCNANS

CNTRMHYP

 

1

CHAR

TSSAVOID

DSCCNANS

CNTRMSAV

 

1

CHAR

TSSNUMB

DSCCNANS

CNTRMNUM

 

1

CHAR

TSSDISOC

DSCCNANS

CNTRMDIS

 

1

CHAR

TSSAFFEC

DSCCNANS

CNTRMDYS

 

1

CHAR

TCESEXAB

DSCCNANS

CNACESEX

 

1

CHAR

TCEPHYAB

DSCCNANS

CNACEABU

 

1

CHAR

TCEEMOAB

DSCCNANS

CNACEEMO

 

1

CHAR

TCENEGLC

DSCCNANS

CNACENEG

 

1

CHAR

TCEMEDTR

DSCCNANS

CNACEMED

 

1

CHAR

TCEFAMVI

DSCCNANS

CNACEFMV

 

1

CHAR

TCECOMVI

DSCCNANS

CNACECMV

 

1

CHAR

TCESCHVI

DSCCNANS

CNACESCV

 

1

CHAR

TCEDISAS

DSCCNANS

CNACEDIS

 

1

CHAR

TCEWAR

DSCCNANS

CNACEWAR

 

1

CHAR

TCETEROR

DSCCNANS

CNACETER

 

1

CHAR

TCEWITNS

DSCCNANS

CNACECRM

 

1

CHAR

TCEPARCR

DSCCNANS

CNACEPCR

 

1

CHAR

TCEDISRP

DSCCNANS

CNACEDCR

 

1

CHAR

CSFAMILY

DSCCNANS

CNSTRFAM

 

1

CHAR

CSINTERP

DSCCNANS

CNSTRINT

 

1

CHAR

CSEDUCAT

DSCCNANS

CNSTREDU

 

1

CHAR

CSVOCAT

DSCCNANS

CNSTRVOC

 

1

CHAR

CSCOPE

DSCCNANS

CNSTRCOP

 

1

CHAR

CSOPTIM

DSCCNANS

CNSTROPT

 

1

CHAR

CSINTRST

DSCCNANS

CNSTRTAL

 

1

CHAR

CSRELIG

DSCCNANS

CNSTRSPI

 

1

CHAR

CSCOMMLF

DSCCNANS

CNSTRCOM

 

1

CHAR

FILLERA

DSCCNANS

CNSTRREL

 

1

CHAR

CSPERMNC

DSCCNANS

CNSTRPRM

 

1

CHAR

CSRESIL

DSCCNANS

CNSTRRES

 

1

CHAR

CSUSUBSU

DSCCNANS

CNSUBSUB

 

1

CHAR

CSUPEERIN

DSCCNANS

CNSUBPIN

 

1

CHAR

CSUENVIRN

DSCCNANS

CNSUBENV

 

1

CHAR

CSUINFLNC

DSCCNANS

CNSUBINF

 

1

CHAR

CSUSEVERU

DSCCNANS

CNSUBSEV

 

1

CHAR

CSUDURATU

DSCCNANS

CNSUBDUR

 

1

CHAR

CSURECSUP

DSCCNANS

CNSUBREC

 

1

CHAR

CSUSTGREC

DSCCNANS

CNSUBSTG

 

1

CHAR

TALIVING

DSCCNANS

CNTRNLIV

 

1

CHAR

TATRANS

DSCCNANS

CNTRNTRP

 

1

CHAR

TAPARROL

DSCCNANS

CNTRNPAR

 

1

CHAR

TARELAT

DSCCNANS

CNTRNITR

 

1

CHAR

TAMEDCPL

DSCCNANS

CNTRNMDC

 

1

CHAR

TAEDATT

DSCCNANS

CNTRNEDU

 

1

CHAR

TAVICTIM

DSCCNANS

CNTRNADV

 

1

CHAR

TAJOBFNC

DSCCNANS

CNTRNJOB

 

1

CHAR

CH5MOTOR

DSCCNANS

CNU5LDMO

 

1

CHAR

CH5SENSR

DSCCNANS

CNU5LDSE

 

1

CHAR

CH5COMM

DSCCNANS

CNU5LDCE

 

1

CHAR

CH5FLTHR

DSCCNANS

CNU5LDTH

 

1

CHAR

CH5FDELM

DSCCNANS

CNU5LDFD

 

1

CHAR

CH5BTHWT

DSCCNANS

CNU5LDBW

 

1

CHAR

CH5PRNAC

DSCCNANS

CNU5LDPC

 

1

CHAR

CH5SUBEX

DSCCNANS

CNU5CRSU

 

1

CHAR

CH5LBRDL

DSCCNANS

CNU5LDLD

 

1

CHAR

CH5PRBLM

DSCCNANS

CNU5LDFA

 

1

CHAR

CH5AVAIL

DSCCNANS

CNU5CRSP

 

1

CHAR

CH5CURIO

DSCCNANS

CNU5CSCU

 

1

CHAR

CH5PLYFL

DSCCNANS

CNU5CSPL

 

1

CHAR

CH5TMPRM

DSCCNANS

CNU5LDTP

 

1

CHAR

CH5DYCAR

DSCCNANS

CNU5LDCC

 

1

CHAR

CCSNPHYSI

DSCCNANS

CNCARMED

 

1

CHAR

CCSNMENHL

DSCCNANS

CNCARMEN

 

1

CHAR

CCSNINVLV

DSCCNANS

CNCARINV

 

1

CHAR

CCSNKNOWL

DSCCNANS

CNCARKNW

 

1

CHAR

CCSNSOCRS

DSCCNANS

CNCARSOC

 

1

CHAR

CCSNPSTTR

DSCCNANS

CNCARPTR

 

1

CHAR

CCSNSAFE

DSCCNANS

CNCARSAF

 

1

CHAR

CCSNSUBAB

DSCCNANS

CNCARSUB

 

1

CHAR

CCSNDEVEL

DSCCNANS

CNCARDEV

 

1

CHAR

CCSNSUPVS

DSCCNANS

CNCARSUP

 

1

CHAR

CCSNORGAN

DSCCNANS

CNCARORG

 

1

CHAR

CCSNRESST

DSCCNANS

CNCARRES

 

1

CHAR

CCSNPRTVI

DSCCNANS

CNCARMPV

 

1

CHAR

ALDFPHYS

DSCCNANS

ANLDFMED

 

1

CHAR

ALDFFAMFU

DSCCNANS

ANLDFFAM

 

1

CHAR

ALDFEMPL

DSCCNANS

ANLDFEMP

 

1

CHAR

ALDFSOCIL

DSCCNANS

ANLDFSOC

 

1

CHAR

ALDFREC

DSCCNANS

ANLDFREC

 

1

CHAR

ALDFINTDV

DSCCNANS

ANLDFDEV

 

1

CHAR

ALDFSEX

DSCCNANS

ANLDFSEX

 

1

CHAR

ALDFLIVSK

DSCCNANS

ANLDFIND

 

1

CHAR

ALDFRESST

DSCCNANS

ANLDFRES

 

1

CHAR

ALDFLEGL

DSCCNANS

ANLDFLEG

 

1

CHAR

ALDFSLEEP

DSCCNANS

ANLDFSLP

 

1

CHAR

ALDFSLFCR

DSCCNANS

ANLDFSLF

 

1

CHAR

ALDFDECIS

DSCCNANS

ANLDFDEC

 

1

CHAR

ALDFINVLV

DSCCNANS

ANLDFINV

 

1

CHAR

ALDFTRANS

DSCCNANS

ANLDFTRN

 

1

CHAR

ALDFMEDAD

DSCCNANS

ANLDFADH

 

1

CHAR

ALDFCRERO

DSCCNANS

ANLDFPCR

 

1

CHAR

STRFAMILY

DSCCNANS

ANSTRFAM

 

1

CHAR

STRSOCCON

DSCCNANS

ANSTRSOC

 

1

CHAR

STROPTIM

DSCCNANS

ANSTROPT

 

1

CHAR

STRINTRST

DSCCNANS

ANSTRTAL

 

1

CHAR

STREDUCAT

DSCCNANS

ANSTREDU

 

1

CHAR

STRVOLUN

DSCCNANS

ANSTRVOL

 

1

CHAR

STRJOBH

DSCCNANS

ANSTRJOB

 

1

CHAR

STRRELIG

DSCCNANS

ANSTRSPI

 

1

CHAR

STRCOMCON

DSCCNANS

ANSTRCOM

 

1

CHAR

STRSPRT

DSCCNANS

ANSTRSUP

 

1

CHAR

STRRESIL

DSCCNANS

ANSTRRSL

 

1

CHAR

STRRESRC

DSCCNANS

ANSTRRSF

 

1

CHAR

AACCLANG

DSCCNANS

ANACCLAN

 

1

CHAR

AACCIDNTL

DSCCNANS

ANACCIDT

 

1

CHAR

AACCRITUL

DSCCNANS

ANACCRIT

 

1

CHAR

AACCSTRES

DSCCNANS

ANACCSTR

 

1

CHAR

BHNPSYCH

DSCCNANS

ANBEHPSY

 

1

CHAR

BHNIMPLS

DSCCNANS

ANBEHIMP

 

1

CHAR

BHNDEPRES

DSCCNANS

ANBEHDEP

 

1

CHAR

BHNANXIET

DSCCNANS

ANBEHANX

 

1

CHAR

BHNIPRBLM

DSCCNANS

ANBEHIPR

 

1

CHAR

BHNANTISC

DSCCNANS

ANBEHABH

 

1

CHAR

BHNADJTRM

DSCCNANS

ANBEHATR

 

1

CHAR

BHNANGER

DSCCNANS

ANBEHANG

 

1

CHAR

BHNEATING

DSCCNANS

ANBEHEAT

 

1

CHAR

RSKSUICID

DSCCNANS

ANRSKSUI

 

1

CHAR

RSKDNGOTH

DSCCNANS

ANRSKDAN

 

1

CHAR

RSKSLFINJ

DSCCNANS

ANRSKSIB

 

1

CHAR

RSKSLFHRM

DSCCNANS

ANRSKOSH

 

1

CHAR

RSKEXPLT

DSCCNANS

ANRSKEXP

 

1

CHAR

RSKGAMBLG

DSCCNANS

ANRSKGAM

 

1

CHAR

RSKSEXAGG

DSCCNANS

ANRSKSEX

 

1

CHAR

RSKCRMBEH

DSCCNANS

ANRSKCRM

 

1

CHAR

SUSUBSU

DSCCNANS

ANSUBSUB

 

1

CHAR

SUPEERIN

DSCCNANS

ANSUBPIN

 

1

CHAR

SUENVIR

DSCCNANS

ANSUBENV

 

1

CHAR

SUINFLUN

 

 

 

1

CHAR

SUSEVUSE

DSCCNANS

ANSUBSEV

 

1

CHAR

SUDURUSE

DSCCNANS

ANSUBDUR

 

1

CHAR

SURCVSUP

DSCCNANS

ANSUBREC

 

1

CHAR

SUSTGRCV

DSCCNANS

ANSUBSTG

 

1

CHAR

ACSNOTAPP

DSCCNANS

ANCARNA

 

1

CHAR

ACSNPHYBE

DSCCNANS

ANCARHTH

 

1

CHAR

ACSNINVLV

DSCCNANS

ANCARINV

 

1

CHAR

ACSNKNOWL

DSCCNANS

ANCARKNW

 

1

CHAR

ACSNSOCRS

DSCCNANS

ANCARSOC

 

1

CHAR

ACSNFAMST

DSCCNANS

ANCARSTR

 

1

CHAR

ACSNSAFTY

DSCCNANS

ANCARSAF

 

1

CHAR

VCASPIR

DSCCNANS

ANVOCCAR

 

1

CHAR

VCJOBTM

DSCCNANS

ANVOCJTM

 

1

CHAR

VCJOBATT

DSCCNANS

ANVOCJAT

 

1

CHAR

VCJOBPER

DSCCNANS

ANVOCJPR

 

1

CHAR

VCJOBREL

DSCCNANS

ANVOCJRL

 

1

CHAR

VCJOBSKL

DSCCNANS

ANVOCJSK

 

1

CHAR

DNCOGN

DSCCNANS

ANDEVCOG

 

1

CHAR

DNCOMM

DSCCNANS

ANDEVCOM

 

1

CHAR

DNDEV

DSCCNANS

ANDEVDEV

 

1

CHAR

PCRKNOWLG

DSCCNANS

ANPARKNW

 

1

CHAR

PCRSUPER

DSCCNANS

ANPARSPV

 

1

CHAR

PCRINVCR

DSCCNANS

ANPARINV

 

1

CHAR

PCRORGZA

DSCCNANS

ANPARORG

 

1

CHAR

PCRVIOHOM

DSCCNANS

ANPARVIO

 

1

CHAR

TRSEXABU

DSCCNANS

ANTRMSEX

 

1

CHAR

TRPHYABU

DSCCNANS

ANTRMPAB

 

1

CHAR

TREMOABU

DSCCNANS

ANTRMEAB

 

1

CHAR

TRMEDTRM

DSCCNANS

ANTRMMED

 

1

CHAR

TRDISAST

DSCCNANS

ANTRMDIS

 

1

CHAR

TRWITFAM

DSCCNANS

ANTRMFMV

 

1

CHAR

TRWITCOM

DSCCNANS

ANTRMCMV

 

1

CHAR

TRAFFREG

DSCCNANS

ANTRMREG

 

1

CHAR

TRINTRUS

DSCCNANS

ANTRMINT

 

1

CHAR

TRATTACH

DSCCNANS

ANTRMATT

 

1

CHAR

TRDISSOC

DSCCNANS

ANTRMDSC

 

1

CHAR

SUSUICID

DSCCNANS

ANSUIIDE

 

1

CHAR

SUSUIINT

DSCCNANS

ANSUIINT

 

1

CHAR

SUSUIPLN

DSCCNANS

ANSUIPLN

 

1

CHAR

SUSUIHIS

DSCCNANS

ANSUIHIS

 

1

CHAR

DAINTENT

DSCCNANS

ANDNGINT

 

1

CHAR

DAPLAN

DSCCNANS

ANDNGPLN

 

1

CHAR

DAVIOH

DSCCNANS

ANDNGVIO

 

1

CHAR

DAFRUSMG

DSCCNANS

ANDNGFRM

 

1

CHAR

DAHOSTIL

DSCCNANS

ANDNGHOS

 

1

CHAR

DAPARNOD

DSCCNANS

ANDNGPRN

 

1

CHAR

DAANGRGN

DSCCNANS

ANDNGANG

 

1

CHAR

DAVIOTHK

DSCCNANS

ANDNGVTH

 

1

CHAR

DAAWRVIO

DSCCNANS

ANDNGAVP

 

1

CHAR

DARSPCSQ

DSCCNANS

ANDNGRCQ

 

1

CHAR

DASLFCTL

DSCCNANS

ANDNGCTL

 

1

CHAR

DATRTINV

DSCCNANS

ANDNGTRT

 

1

CHAR

SABRELAT

DSCCNANS

ANSABREL

 

1

CHAR

SABPHFRC

DSCCNANS

ANSABTHR

 

1

CHAR

SABPLAN

DSCCNANS

ANSABPLN

 

1

CHAR

SABAGEDF

DSCCNANS

ANSABAGE

 

1

CHAR

SABSXACT

DSCCNANS

ANSABACT

 

1

CHAR

SABRSPAC

DSCCNANS

ANSABRSP

 

1

CHAR

CRSERIOS

DSCCNANS

ANCRMSER

 

1

CHAR

CRHIS

DSCCNANS

ANCRMHIS

 

1

CHAR

CRARR

DSCCNANS

ANCRMARR

 

1

CHAR

CRPLAN

DSCCNANS

ANCRMPLN

 

1

CHAR

CRCOMSAF

DSCCNANS

ANCRMSAF

 

1

CHAR

CRLEGCPL

DSCCNANS

ANCRMLEG

 

1

CHAR

CRPEERIN

DSCCNANS

ANCRMINF

 

1

CHAR

CRENVIR

DSCCNANS

ANCRMENV

 

1

CHAR

SEDFLG

DSCGA

SEDIND

 

1

CHAR

SPMIFLG

DSCGA

SPMIID

 

1

CHAR

HMLS90

DSCGA

HOMLES

 

2

VARCHAR

HMLCHRON

DSCGA

CHLIND

 

1

CHAR

HSPEMR3X

DSCGA

ERGNCY

 

1

CHAR

HSPADM3X

DSCGA

PSYHSP

 

1

CHAR

INPADMCNT

DSCGA

PSYADM

 

2

VARCHAR

INPDYS

DSCGA

PSYDAY

 

2

VARCHAR

COMORBID

DSCGA

MHSUID

 

1

CHAR

COMMEDCR

DSCGA

COMRBD

 

1

CHAR

CURPREG

DSCGA

PREGNT

 

1

CHAR

BTHDUREP

DSCGA

LIVBTH

 

1

CHAR

BABYSTA

DSCGA

BBYSTS

 

1

CHAR

DEPENDCH

DSCGA

DPCHLD

 

1

CHAR

WEIGHT

DSCGA

CURWGT

Prefill with zeroes

3

VARCHAR

HEIGHTFT

DSCGA

HGHTFT

Prefill with zeroes

2

VARCHAR

HEIGHTIN

DSCGA

HGHTIN

Prefill with zeroes

2

VARCHAR

WAISTIN

DSCGA

WSTCIR

Prefill with zeroes

3

VARCHAR

SUBSUSED

DSCGA

SUBTYP

 

1

CHAR

SUBSTNC1

DSCGA

SUBSTNC1

 

4

VARCHAR

RTADMN1

DSCGA

SUBADMN1

 

1

CHAR

FRQUS1

DSCGA

SUBFRQUS1

 

1

CHAR

FSTUS1

DSCGA

SUBAGE1

Prefill with zeroes

2

VARCHAR

SUBSTNC2

DSCGA

SUBSTNC2

 

4

VARCHAR

RTADMN2

DSCGA

SUBADMN2

 

1

CHAR

FRQUS2

DSCGA

SUBFRQUS2

 

1

CHAR

FSTUS2

DSCGA

SUBAGE2

 

2

VARCHAR

SUBSTNC3

DSCGA

SUBSTNC3

 

4

VARCHAR

RTADMN3

DSCGA

SUBADMN3

 

1

CHAR

FRQUS3

DSCGA

SUBFRQUS3

 

1

CHAR

FSTUS3

DSCGA

SUBAGE3

 

2

VARCHAR

SELFHELP

DSCGA

SFHIND

 

1

CHAR

SLFHLPCT

DSCGA

SFHP30

 

2

VARCHAR

LGLSTAT

DSCGA

LGLSTS

 

1

CHAR

LGLINVLV

DSCGA

LGLINV

 

1

CHAR

LGLCUST

DSCGA

LGLCUS

 

1

CHAR

CRMJUS

DSCGA

CRJIND

 

1

CHAR

NBRARR

DSCGA

ARST30

Prefill with zeroes

2

VARCHAR

JLRECENT

DSCGA

JAILST

 

1

CHAR

JLRELDT

DSCGA

JAILRL

 

8

VARCHAR

JLADMCT

DSCGA

DAYREL

Prefill with zeroes

2

VARCHAR

JLDAYS

DSCGA

ARST90

 

2

VARCHAR

INCOME

DSCGA

JAIL90

 

1

CHAR

EARNINC

DSCGA

ERNINC

When populated, must be numeric. Must fill with leading zeros as necessary.

10

VARCHAR

FILLER02

 

 

 

5

VARCHAR

UNEMINC

DSCGA

UNEMIN

When populated, must be numeric. Must fill with leading zeros as necessary.

10

VARCHAR

FILLER03

 

 

 

5

VARCHAR

SSIINC

DSCGA

SSIDIS

 

10

VARCHAR

FILLER04

 

 

 

5

VARCHAR

VADISAB

DSCGA

VACDIS

 

10

VARCHAR

FILLER05

 

 

 

5

VARCHAR

TANF

DSCGA

TANFIN

 

10

VARCHAR

FILLER06

 

 

 

5

VARCHAR

TRSTFND

DSCGA

TRSTFD

 

10

VARCHAR

FILLER07

 

 

 

5

VARCHAR

PENSRI

DSCGA

PNSION

 

10

VARCHAR

FILLER08

 

 

 

5

VARCHAR

CHLDSUP

DSCGA

CHLDSP

 

10

VARCHAR

FILLER09

 

 

 

5

VARCHAR

ALIMONY

DSCGA

ALIMNY

 

10

VARCHAR

FILLER10

 

 

 

5

VARCHAR

OTHINC

DSCGA

OTHERS

 

10

VARCHAR

FILLER11

 

 

 

5

VARCHAR

SRCINC

DSCGA

SOURCE

 

25

VARCHAR

NONCASH

DSCGA

NCBIND

 

1

CHAR

SRCNOCSH

DSCNCBGA

NCBSRC

 

10

VARCHAR

SRCOTHR

DSCNCBGA

NCBOTH

 

100

VARCHAR

HLTHINS

DSCGA

INSIND

 

1

CHAR

INSTYP

DSCINSGA

INSTYP

 

8

VARCHAR

OTHTYP

DSCINSGA

OTHINS

 

25

VARCHAR

SCHATT

DSCGA

SCHL90

 

1

CHAR

SCHABS

DSCGA

ABSENT

Prefill with zeroes

2

VARCHAR

GRADLVL

DSCGA

CEMPDT

 

2

VARCHAR

EMPDAT

DSCGA

HOMLES

 

8

VARCHAR

HRSWKCMP

DSCGA

CEMPHR

Prefill with zeroes

2

VARCHAR

HRLYWAGE

DSCGA

CEMPWG

Prefill with zeroes

5

VARCHAR

EMPLDAT

DSCGA

NCEMDT

 

8

VARCHAR

HRSWKNON

DSCGA

NCEMHR

Prefill with zeroes

2

VARCHAR

NONTYPE

DSCGA

NCEMTP

 

2

VARCHAR

AVAILBL

DSCGA

AVWORK

 

1

CHAR

NOTAVLRS

DSCGA

NOWORK

 

1

CHAR

DTEMPCON

DSCGA

EMPLDT

 

8

VARCHAR

ENRSTACU

DSCGA

VOCREH

 

1

CHAR

ENRSTAPR

DSCGA

PREVVR

 

1

CHAR

CMPSTRT

DSCGA

CJOBST

 

1

CHAR

CMPLEAV

DSCGA

CJOBLV

 

1

CHAR

FILLER01

 

 

 

2

VARCHAR

DISPLAN

DSCGA

DPPIND

 

1

CHAR

DISTYPE

DSCGA

AMAIND

 

1

CHAR

PCPNOTIF

DSCGA

PCPIND

 

1

CHAR

LVLCARE

DSCGA

DISLOC

 

8

VARCHAR

OTHCARE

DSCGA

DLOCOTH

 

25

VARCHAR

TRMTINV1

DSCGA

ADVIND

 

1

CHAR

TRMTINV2

DSCGA

CHPIND

 

1

CHAR

TRMTINV3

DSCGA

ADTIND

 

1

CHAR

TRMTINV4

DSCGA

FAMIND

 

1

CHAR

TRMTINV5

DSCGA

OSPIND

 

1

CHAR

TRMTINV6

DSCGA

OPPIND

 

1

CHAR

TRMTINV7

DSCGA

LGLIND

 

1

CHAR

TRMTINV8

DSCGA

NONIND

 

1

CHAR

OTHSUPRT

DSCGA

OTHTXT

 

65

VARCHAR

DISRES

DSCGA

DISRES

 

2

VARCHAR

TIMRES

DSCGA

LNGLIV

 

2

VARCHAR

STABIL

DSCGA

HOSSTB

 

1

CHAR

MEDDIS

RVJMAS

JRNTXT

 

250

VARCHAR

GUARPART

DSCGA

DPTIND

 

1

CHAR

CONTACT

DSCGA

CONTCT

 

100

VARCHAR

RELATIN

DSCGA

CNTREL

 

2

VARCHAR

AREACD

DSCGA

FOLPH1

 

3

VARCHAR

EXCHANG

DSCGA

FOLPH2

 

3

VARCHAR

SUFFIX

DSCGA

FOLPH3

 

4

VARCHAR

EXTENSN

DSCGA

FOLPH4

 

8

VARCHAR

AFTPRV

DSCGA

AFBHPR

 

1

CHAR

AFTOON

DSCGA

BONIND

 

1

CHAR

AFTPRNAM

DSCGA

BPRNAM

 

150

VARCHAR

AFTPRACD

DSCGA

BPRPH1

 

3

VARCHAR

AFTPREXC

DSCGA

BPRPH2

 

3

VARCHAR

AFTPRSUF

DSCGA

BPRPH3

 

4

VARCHAR

AFTPREXT

DSCGA

BPRPH4

 

8

VARCHAR

AFTAD1

DSCGA

BPRADD

 

55

VARCHAR

AFTAD2

DSCGA

BPRAD2

 

55

VARCHAR

AFTCTY

DSCGA

BPRCTY

 

30

VARCHAR

AFTST

DSCGA

BPRSTA

 

2

VARCHAR

AFTZIP

DSCGA

BPRZIP

 

9

VARCHAR

AFTAPDAT

DSCGA

BAPDAT

 

8

VARCHAR

AFTAPTIM

DSCGA

BAPTIM

 

4

VARCHAR

AFTAPREM

DSCGA

BAPRMD

 

1

CHAR

PRSPHY

DSCGA

AFPRPR

 

1

CHAR

PRSOON

DSCGA

PONIND

 

1

CHAR

PRSNAM

DSCGA

PPRNAM

 

150

VARCHAR

PRSACD

DSCGA

PPRPH4

 

3

VARCHAR

PRSEXC

DSCGA

PPRADD

 

3

VARCHAR

PRSSUF

DSCGA

PPRAD2

 

4

VARCHAR

PRSEXT

DSCGA

PPRPH4

 

8

VARCHAR

PRSAD1

DSCGA

PPRADD

 

55

VARCHAR

PRSAD2

DSCGA

PPRAD2

 

55

VARCHAR

PRSCTY

DSCGA

PPRCTY

 

30

VARCHAR

PRSST

DSCGA

PPRSTA

 

2

VARCHAR

PRSZIP

DSCGA

PPRZIP

 

9

VARCHAR

PRSAPDAT

DSCGA

PAPDAT

MMDDYYYY

8

VARCHAR

PRSAPTIM

DSCGA

PAPTIM

 

4

VARCHAR

PRSAPREM

DSCGA

PAPRMD

 

1

CHAR

MEDNAM

DSCGA

MPRNAM

 

100

VARCHAR

MEDACD

DSCGA

MPRPH1

 

3

VARCHAR

MEDEXC

DSCGA

MPRPH2

 

3

VARCHAR

MEDSUF

DSCGA

MPRPH3

 

4

VARCHAR

MEDEXT

DSCGA

MPRPH4

 

8

VARCHAR

MEDRSN

DSCGA

MEDRSN

 

1

CHAR

MEDAPDAT

DSCGA

MAPDAT

MMDDYYYY

8

VARCHAR

MEDAPTIM

DSCGA

MAPTIM

HHMM

4

VARCHAR

MEDAPREM

DSCGA

MAPRMD

 

1

CHAR

TRWITCRM

DSCCNANS

CNACECRM

 

1

CHAR

TRWARAFF

DSCCNANS

CNACEWAR

 

1

CHAR

TRTERAFF

DSCCNANS

CNACETER

 

1

CHAR

CNANSIND

 

 

 

1

CHAR

PRVALT

 

 

 

15

VARCHAR

AUTHNO2

 

 

 

25

VARCHAR

DISNBR

 

 

 

25

VARCHAR

DISDAT2

 

 

 

8

VARCHAR

ERRCD1

3

VARCHAR

ERRDES1

350

VARCHAR

ERRCD2

3

VARCHAR

ERRDES2

350

VARCHAR

ERRCD3

3

VARCHAR

ERRDES3

350

VARCHAR

ERRCD4

3

VARCHAR

ERRDES4

350

VARCHAR

ERRCD5

3

VARCHAR

ERRDES5

350

VARCHAR

SYSDAT

 

CURRENT DATE

 

26

TIMESTAMP

LSTCHG

 

CURRENT DATE

 

26

TIMESTAMP

USERAD

 

NAME OF NEW PROGRAM

 

10

VARCHAR

USERID

 

NAME OF NEW PROGRAM

 

10

VARCHAR

Business Rules: Mapping spreadsheet talks about how to populate the data from the source tables in to the GADHIST (the new table). The history table that EDI is creating will be loaded with admin discharge data coming from the source tables. Below are the business rules for the fields that are very critical for this file to load meaning assuming the clinical data being pulled from CRM tables have the most valid and accurate.

Assumption: The data populating from CRM tables are DSCMAS and DSCCANS and there are rules already in place. So, it is going to be a straight load from these tables to populate the admin discharge history table.

Selection Criteria

Records on the Admin Discharge Response file should only contain Discharge records pertaining to GACO parent code. Thus when the standard Admin Discharge extract process populates records in the GADHIST file, all records populated should have a GADHIST.PARENT = ‘GACO’ value. The program should select the universal records in step 1 and then populate the admin discharge table with records for discharges created by that provider. After the program is run as a result, the authorizations are discharged and records are sent out as response file to each provider. When the records are written to the Admin Discharge History table, there will be records which will error out with a ERRSTS.

Criteria Logic

XWALK –WHERE CWKMAS.SRCVAL

RUN JOB: The user should be able to run the job manually. Below are the job parameters:

WHERE AHDMAS.PARENT = GACO

AND AHDMAS.USERAD = ‘V1WADO’

AND AHDMAS.SYSDAT = DATE RANGE (FROMDATE – TODATE) or DATE

MEMBNO = AHDMAS.MEMBNO

WHERE DSCMAS.MEMBNO = AHDMAS.MEMBNO

AND DSCMAS.PARENT = ‘GACO’

AND DSCMAS. PARENT = AHDMAS. PARENT

If MEMBNO is not found then ERROR OUT and write the record to GADERR.

LASTNAME = MEMMAS.LASTNAME

WHERE MEMMAS.MEMBNO = AHDMAS.MEMBNO

AND MEMMAS.PARENT = ‘GACO’

AND DSCMAS. PARENT = AHDMAS. PARENT

If LASTNAME is blank then ERROR OUT and write the record to GADERR.

FIRSTNAME = MEMMAS.FIRSTNAME

WHERE MEMMAS.MEMBNO = AHDMAS.MEMBNO

AND MEMMAS.PARENT = ‘GACO’

AND DSCMAS. PARENT = AHDMAS. PARENT

If FIRSTNAME is blank then ERROR OUT and write the record to GADERR.

AUTHNO1 – Concatenate each of the 4 fields with a hyphen (AHDMAS.BRANCD - AHDMAS.BATDAT- AHDMAS.BATSEQ- AHDMAS.SEQNUM)

WHERE DSCMAS. MEMBNO = AHDMAS.MEMBNO

AND AHDMAS.PARENT = ‘GACO’

AND DSCMAS. PARENT = AHDMAS. PARENT

PROVNO = AHDMAS.PROVTO

WHERE DSCMAS.MEMBNO = AHDMAS.MEMBNO

AND AHDMAS.PARENT = ‘GACO’

AND DSCMAS. PARENT = AHDMAS. PARENT

If PROVTO is blank then ERROR OUT and write the record to GADERR.

VENDOR = AHDMAS. SVCVND

WHERE DSCMAS.MEMBNO = AHDMAS.MEMBNO

AND AHDMAS.PARENT = ‘GACO’

AND DSCMAS. PARENT = AHDMAS. PARENT

If SVCVND is blank then ERROR OUT and write the record to GADERR.

1. SECPRST: IF GADHIST.SECPRST = 0 THEN VALID RECORDS AND IF GADHIST.SECPRST = 1 THEN ERROR OUT AND IF GADHIST.SECPRST = 7 THEN SUCCESFULLY PROCESSED AND GADHIST.SECPRST = 4 THEN CLOSED.

Create an Output file: Below is the file layout including the starting and ending positions of data elements when .txt output file is generated. When the output file is created there will be no need to extract errors on the file for the providers. The error fields will be blank.

GADHIST – Admin Discharge History Table

FIELD_NAME

SOURCE TABLE

SOURCE FIELD

FIELD NOTES

FIELD LENGTH

DATA_TYPE

START

END

HISTID

 

 

Auto-assigned

15

NUMERIC

TRNID

 

 

Auto-assigned

15

NUMERIC

FILEID

 

 

Auto-assigned

15

NUMERIC

FILEDT

 

 

Auto-assigned

7

DECIMAL

FILNAM

 

 

 

10

VARCHAR

EDISUBM

 

 

 

16

VARCHAR

SECPRST

 

 

 

1

CHAR

WRKSTA

 

 

 

1

CHAR

PARENT

CLNMAS

GACO

GACO

4

VARCHAR

1

4

MEMBNO

AHDMAS

MEMBNO

 

15

VARCHAR

5

19

LSTNAM

MEMMAS

LSTNAM

 

60

VARCHAR

20

79

FSTNAM

MEMMAS

FSTNAM

 

35

VARCHAR

80

114

AUTHNO1

DSCMAS

BRANCD BATDAT BATSEQ SEQNUM

Format: 01-CYYMMDD-000-000 Example: 01-2150922-001-006

25

VARCHAR

115

139

AUTSTA

 

 

Default to 'O" (Open)

1

CHAR

140

140

PRVNAM

DSCGA

BPRNAM

 

60

VARCHAR

141

200

PRVTAG

 

 

 

15

VARCHAR

201

215

PROVNO

CWKMAS

SRCVAL

 

15

VARCHAR

216

230

TRCKID

 

 

 

15

VARCHAR

231

245

VENDOR

AHDMAS

SVCVEN

 

15

VARCHAR

246

260

SUBMID

CWKMAS

TRGVL

 

10

VARCHAR

261

270

DISDAT1

DSCMAS

ACTDAT

MMDDYYYY

8

VARCHAR

271

278

DISRSN

DSCMAS

DRSCOD

 

2

VARCHAR

279

280

SVCDAT

DSCMAS

LSVDAT

MMDDYYYY

8

VARCHAR

281

288

DODDAT

DSCGA

DTHDAT

MMDDYYYY

8

VARCHAR

289

296

DTHFLG

DSCGA

DTHUNK

CYYMMDD

1

CHAR

297

297

DIAGN1

DCMMAS

BDICD1

 

8

VARCHAR

298

305

DIAGN2

DCMMAS

BDICD2

 

8

VARCHAR

306

313

DIAGN3

DCMMAS

BDICD3

 

8

VARCHAR

314

321

DIAGN4

DCMMAS

BDICD4

 

8

VARCHAR

322

329

DIAGN5

DCMMAS

BDICD5

 

8

VARCHAR

330

337

MEDDIA1

DCMMAS

MDICD1

 

8

VARCHAR

338

345

MEDDIA2

DCMMAS

MDICD2

 

8

VARCHAR

346

353

MEDDIA3

DCMMAS

MDICD3

 

8

VARCHAR

354

361

SOCIMP1

DCMMAS

AXFON

 

1

CHAR

362

362

SOCIMP2

DCMMAS

AXFEDU

 

1

CHAR

363

363

SOCIMP3

DCMMAS

AXFIN

 

1

CHAR

364

364

SOCIMP4

DCMMAS

AXFHCS

 

1

CHAR

365

365

SOCIMP5

DCMMAS

AXFLEG

 

1

CHAR

366

366

SOCIMP6

DCMMAS

AXFPRM

 

1

CHAR

367

367

SOCIMP7

DCMMAS

AXFNON

 

1

CHAR

368

368

SOCIMP8

DCMMAS

AXFOCC

 

1

CHAR

369

369

SOCIMP9

DSCMAS

AXFOTH

 

1

CHAR

370

370

SOCIMP10

DCSMAS

AXFFIN

 

1

CHAR

371

371

ASSMSR1

DSCGA

ASSMS1

 

1

CHAR

372

372

ASSSCR1

DSCGA

ASSSC1

 

6

VARCHAR

373

378

ASSOTH1

DSCGA

AS1OTH

 

25

VARCHAR

379

403

ASSMSR2

DSCGA

ASSMS2

 

1

CHAR

404

404

ASSSCR2

DSCGA

ASSSC2

 

6

VARCHAR

405

410

ASSOTH2

DSCGA

AS2OTH

 

25

VARCHAR

411

435

CLDFFAM

DSCCNANS

CNLDFFAM

 

1

CHAR

436

436

CLDFLIV

DSCCNANS

CNLDFLIV

 

1

CHAR

437

437

CLDFSOC

DSCCNANS

CNLDFSOC

 

1

CHAR

438

438

CLDFDEV

DSCCNANS

CNLDFDEV

 

1

CHAR

439

439

CLDFREC

DSCCNANS

CNLDFREC

 

1

CHAR

440

440

CLDFLEGL

DSCCNANS

CNLDFLEG

 

1

CHAR

441

441

CLDFMED

DSCCNANS

CNLDFMED

 

1

CHAR

442

442

CLDFPHYS

DSCCNANS

CNLDFPHY

 

1

CHAR

443

443

CLDFSLP

DSCCNANS

CNLDFSLP

 

1

CHAR

444

444

CLDFSEX

DSCCNANS

CNLDFSEX

 

1

CHAR

445

445

CLDFSCHBH

DSCCNANS

CNLDFBEH

 

1

CHAR

446

446

CLDFSCHAC

DSCCNANS

CNLDFACH

 

1

CHAR

447

447

CLDFSCHAT

DSCCNANS

CNLDFATT

 

1

CHAR

448

448

CRBSUIC

DSCCNANS

CNBEHSUI

 

1

CHAR

449

449

CRBSINJU

DSCCNANS

CNBEHMUT

 

1

CHAR

450

450

CRBSHARM

DSCCNANS

CNBEHHRM

 

1

CHAR

451

451

CRBDNGOTH

DSCCNANS

CNBEHDAN

 

1

CHAR

452

452

CRBSEXAGG

DSCCNANS

CNBEHSEX

 

1

CHAR

453

453

CRBRUNWAY

DSCCNANS

CNBEHRUN

 

1

CHAR

454

454

CRBDELINQ

DSCCNANS

CNBEHDEL

 

1

CHAR

455

455

CRBJUDG

DSCCNANS

CNBEHJDG

 

1

CHAR

456

456

CRBFIRE

DSCCNANS

CNBEHFIR

 

1

CHAR

457

457

CRBINTMIS

DSCCNANS

CNBEHMBH

 

1

CHAR

458

458

CRBSEXREA

DSCCNANS

CNBEHSRB

 

1

CHAR

459

459

CACCLANG

DSCCNANS

CNACCLAN

 

1

CHAR

460

460

CACCIDNT

DSCCNANS

CNACCIDT

 

1

CHAR

461

461

CACCRITUL

DSCCNANS

CNACCRIT

 

1

CHAR

462

462

CACCSTRES

DSCCNANS

CNACCSTR

 

1

CHAR

463

463

CBPSYCHS

DSCCNANS

CNNEDPSY

 

1

CHAR

464

464

CBCONCEN

DSCCNANS

CNNEDATT

 

1

CHAR

465

465

CBIMPULS

DSCCNANS

CNNEDIMP

 

1

CHAR

466

466

CBDEPRES

DSCCNANS

CNNEDDEP

 

1

CHAR

467

467

CBANXIET

DSCCNANS

CNNEDANX

 

1

CHAR

468

468

CBOPPOS

DSCCNANS

CNNEDOPP

 

1

CHAR

469

469

CBCONDCT

DSCCNANS

CNNEDCON

 

1

CHAR

470

470

CBATTACH

DSCCNANS

CNNEDACH

 

1

CHAR

471

471

CBEATING

DSCCNANS

CNNEDDIS

 

1

CHAR

472

472

CBREGRES

DSCCNANS

CNNEDBRG

 

1

CHAR

473

473

CBSOMAT

DSCCNANS

CNNEDSOM

 

1

CHAR

474

474

CBANGER

DSCCNANS

CNNEDANG

 

1

CHAR

475

475

TSSTRAUM

DSCCNANS

CNTRMTRM

 

1

CHAR

476

476

TSSGRIEF

DSCCNANS

CNTRMGRF

 

1

CHAR

477

477

TSSREEXP

DSCCNANS

CNTRMREX

 

1

CHAR

478

478

TSSAROUS

DSCCNANS

CNTRMHYP

 

1

CHAR

479

479

TSSAVOID

DSCCNANS

CNTRMSAV

 

1

CHAR

480

480

TSSNUMB

DSCCNANS

CNTRMNUM

 

1

CHAR

481

481

TSSDISOC

DSCCNANS

CNTRMDIS

 

1

CHAR

482

482

TSSAFFEC

DSCCNANS

CNTRMDYS

 

1

CHAR

483

483

TCESEXAB

DSCCNANS

CNACESEX

 

1

CHAR

484

484

TCEPHYAB

DSCCNANS

CNACEABU

 

1

CHAR

485

485

TCEEMOAB

DSCCNANS

CNACEEMO

 

1

CHAR

486

486

TCENEGLC

DSCCNANS

CNACENEG

 

1

CHAR

487

487

TCEMEDTR

DSCCNANS

CNACEMED

 

1

CHAR

488

488

TCEFAMVI

DSCCNANS

CNACEFMV

 

1

CHAR

489

489

TCECOMVI

DSCCNANS

CNACECMV

 

1

CHAR

490

490

TCESCHVI

DSCCNANS

CNACESCV

 

1

CHAR

491

491

TCEDISAS

DSCCNANS

CNACEDIS

 

1

CHAR

492

492

TCEWAR

DSCCNANS

CNACEWAR

 

1

CHAR

493

493

TCETEROR

DSCCNANS

CNACETER

 

1

CHAR

494

494

TCEWITNS

DSCCNANS

CNACECRM

 

1

CHAR

495

495

TCEPARCR

DSCCNANS

CNACEPCR

 

1

CHAR

496

496

TCEDISRP

DSCCNANS

CNACEDCR

 

1

CHAR

497

497

CSFAMILY

DSCCNANS

CNSTRFAM

 

1

CHAR

498

498

CSINTERP

DSCCNANS

CNSTRINT

 

1

CHAR

499

499

CSEDUCAT

DSCCNANS

CNSTREDU

 

1

CHAR

500

500

CSVOCAT

DSCCNANS

CNSTRVOC

 

1

CHAR

501

501

CSCOPE

DSCCNANS

CNSTRCOP

 

1

CHAR

502

502

CSOPTIM

DSCCNANS

CNSTROPT

 

1

CHAR

503

503

CSINTRST

DSCCNANS

CNSTRTAL

 

1

CHAR

504

504

CSRELIG

DSCCNANS

CNSTRSPI

 

1

CHAR

505

505

CSCOMMLF

DSCCNANS

CNSTRCOM

 

1

CHAR

506

506

FILLERA

DSCCNANS

CNSTRREL

 

1

CHAR

507

507

CSPERMNC

DSCCNANS

CNSTRPRM

 

1

CHAR

508

508

CSRESIL

DSCCNANS

CNSTRRES

 

1

CHAR

509

509

CSUSUBSU

DSCCNANS

CNSUBSUB

 

1

CHAR

510

510

CSUPEERIN

DSCCNANS

CNSUBPIN

 

1

CHAR

511

511

CSUENVIRN

DSCCNANS

CNSUBENV

 

1

CHAR

512

512

CSUINFLNC

DSCCNANS

CNSUBINF

 

1

CHAR

513

513

CSUSEVERU

DSCCNANS

CNSUBSEV

 

1

CHAR

514

514

CSUDURATU

DSCCNANS

CNSUBDUR

 

1

CHAR

515

515

CSURECSUP

DSCCNANS

CNSUBREC

 

1

CHAR

516

516

CSUSTGREC

DSCCNANS

CNSUBSTG

 

1

CHAR

517

517

TALIVING

DSCCNANS

CNTRNLIV

 

1

CHAR

518

518

TATRANS

DSCCNANS

CNTRNTRP

 

1

CHAR

519

519

TAPARROL

DSCCNANS

CNTRNPAR

 

1

CHAR

520

520

TARELAT

DSCCNANS

CNTRNITR

 

1

CHAR

521

521

TAMEDCPL

DSCCNANS

CNTRNMDC

 

1

CHAR

522

522

TAEDATT

DSCCNANS

CNTRNEDU

 

1

CHAR

523

523

TAVICTIM

DSCCNANS

CNTRNADV

 

1

CHAR

524

524

TAJOBFNC

DSCCNANS

CNTRNJOB

 

1

CHAR

525

525

CH5MOTOR

DSCCNANS

CNU5LDMO

 

1

CHAR

526

526

CH5SENSR

DSCCNANS

CNU5LDSE

 

1

CHAR

527

527

CH5COMM

DSCCNANS

CNU5LDCE

 

1

CHAR

528

528

CH5FLTHR

DSCCNANS

CNU5LDTH

 

1

CHAR

529

529

CH5FDELM

DSCCNANS

CNU5LDFD

 

1

CHAR

530

530

CH5BTHWT

DSCCNANS

CNU5LDBW

 

1

CHAR

531

531

CH5PRNAC

DSCCNANS

CNU5LDPC

 

1

CHAR

532

532

CH5SUBEX

DSCCNANS

CNU5CRSU

 

1

CHAR

533

533

CH5LBRDL

DSCCNANS

CNU5LDLD

 

1

CHAR

534

534

CH5PRBLM

DSCCNANS

CNU5LDFA

 

1

CHAR

535

535

CH5AVAIL

DSCCNANS

CNU5CRSP

 

1

CHAR

536

536

CH5CURIO

DSCCNANS

CNU5CSCU

 

1

CHAR

537

537

CH5PLYFL

DSCCNANS

CNU5CSPL

 

1

CHAR

538

538

CH5TMPRM

DSCCNANS

CNU5LDTP

 

1

CHAR

539

539

CH5DYCAR

DSCCNANS

CNU5LDCC

 

1

CHAR

540

540

CCSNPHYSI

DSCCNANS

CNCARMED

 

1

CHAR

541

541

CCSNMENHL

DSCCNANS

CNCARMEN

 

1

CHAR

542

542

CCSNINVLV

DSCCNANS

CNCARINV

 

1

CHAR

543

543

CCSNKNOWL

DSCCNANS

CNCARKNW

 

1

CHAR

544

544

CCSNSOCRS

DSCCNANS

CNCARSOC

 

1

CHAR

545

545

CCSNPSTTR

DSCCNANS

CNCARPTR

 

1

CHAR

546

546

CCSNSAFE

DSCCNANS

CNCARSAF

 

1

CHAR

547

547

CCSNSUBAB

DSCCNANS

CNCARSUB

 

1

CHAR

548

548

CCSNDEVEL

DSCCNANS

CNCARDEV

 

1

CHAR

549

549

CCSNSUPVS

DSCCNANS

CNCARSUP

 

1

CHAR

550

550

CCSNORGAN

DSCCNANS

CNCARORG

 

1

CHAR

551

551

CCSNRESST

DSCCNANS

CNCARRES

 

1

CHAR

552

552

CCSNPRTVI

DSCCNANS

CNCARMPV

 

1

CHAR

553

553

ALDFPHYS

DSCCNANS

ANLDFMED

 

1

CHAR

554

554

ALDFFAMFU

DSCCNANS

ANLDFFAM

 

1

CHAR

555

555

ALDFEMPL

DSCCNANS

ANLDFEMP

 

1

CHAR

556

556

ALDFSOCIL

DSCCNANS

ANLDFSOC

 

1

CHAR

557

557

ALDFREC

DSCCNANS

ANLDFREC

 

1

CHAR

558

558

ALDFINTDV

DSCCNANS

ANLDFDEV

 

1

CHAR

559

559

ALDFSEX

DSCCNANS

ANLDFSEX

 

1

CHAR

560

560

ALDFLIVSK

DSCCNANS

ANLDFIND

 

1

CHAR

561

561

ALDFRESST

DSCCNANS

ANLDFRES

 

1

CHAR

562

562

ALDFLEGL

DSCCNANS

ANLDFLEG

 

1

CHAR

563

563

ALDFSLEEP

DSCCNANS

ANLDFSLP

 

1

CHAR

564

564

ALDFSLFCR

DSCCNANS

ANLDFSLF

 

1

CHAR

565

565

ALDFDECIS

DSCCNANS

ANLDFDEC

 

1

CHAR

566

566

ALDFINVLV

DSCCNANS

ANLDFINV

 

1

CHAR

567

567

ALDFTRANS

DSCCNANS

ANLDFTRN

 

1

CHAR

568

568

ALDFMEDAD

DSCCNANS

ANLDFADH

 

1

CHAR

569

569

ALDFCRERO

DSCCNANS

ANLDFPCR

 

1

CHAR

570

570

STRFAMILY

DSCCNANS

ANSTRFAM

 

1

CHAR

571

571

STRSOCCON

DSCCNANS

ANSTRSOC

 

1

CHAR

572

572

STROPTIM

DSCCNANS

ANSTROPT

 

1

CHAR

573

573

STRINTRST

DSCCNANS

ANSTRTAL

 

1

CHAR

574

574

STREDUCAT

DSCCNANS

ANSTREDU

 

1

CHAR

575

575

STRVOLUN

DSCCNANS

ANSTRVOL

 

1

CHAR

576

576

STRJOBH

DSCCNANS

ANSTRJOB

 

1

CHAR

577

577

STRRELIG

DSCCNANS

ANSTRSPI

 

1

CHAR

578

578

STRCOMCON

DSCCNANS

ANSTRCOM

 

1

CHAR

579

579

STRSPRT

DSCCNANS

ANSTRSUP

 

1

CHAR

580

580

STRRESIL

DSCCNANS

ANSTRRSL

 

1

CHAR

581

581

STRRESRC

DSCCNANS

ANSTRRSF

 

1

CHAR

582

582

AACCLANG

DSCCNANS

ANACCLAN

 

1

CHAR

583

583

AACCIDNTL

DSCCNANS

ANACCIDT

 

1

CHAR

584

584

AACCRITUL

DSCCNANS

ANACCRIT

 

1

CHAR

585

585

AACCSTRES

DSCCNANS

ANACCSTR

 

1

CHAR

586

586

BHNPSYCH

DSCCNANS

ANBEHPSY

 

1

CHAR

587

587

BHNIMPLS

DSCCNANS

ANBEHIMP

 

1

CHAR

588

588

BHNDEPRES

DSCCNANS

ANBEHDEP

 

1

CHAR

589

589

BHNANXIET

DSCCNANS

ANBEHANX

 

1

CHAR

590

590

BHNIPRBLM

DSCCNANS

ANBEHIPR

 

1

CHAR

591

591

BHNANTISC

DSCCNANS

ANBEHABH

 

1

CHAR

592

592

BHNADJTRM

DSCCNANS

ANBEHATR

 

1

CHAR

593

593

BHNANGER

DSCCNANS

ANBEHANG

 

1

CHAR

594

594

BHNEATING

DSCCNANS

ANBEHEAT

 

1

CHAR

595

595

RSKSUICID

DSCCNANS

ANRSKSUI

 

1

CHAR

596

596

RSKDNGOTH

DSCCNANS

ANRSKDAN

 

1

CHAR

597

597

RSKSLFINJ

DSCCNANS

ANRSKSIB

 

1

CHAR

598

598

RSKSLFHRM

DSCCNANS

ANRSKOSH

 

1

CHAR

599

599

RSKEXPLT

DSCCNANS

ANRSKEXP

 

1

CHAR

600

600

RSKGAMBLG

DSCCNANS

ANRSKGAM

 

1

CHAR

601

601

RSKSEXAGG

DSCCNANS

ANRSKSEX

 

1

CHAR

602

602

RSKCRMBEH

DSCCNANS

ANRSKCRM

 

1

CHAR

603

603

SUSUBSU

DSCCNANS

ANSUBSUB

 

1

CHAR

604

604

SUPEERIN

DSCCNANS

ANSUBPIN

 

1

CHAR

605

605

SUENVIR

DSCCNANS

ANSUBENV

 

1

CHAR

606

606

SUINFLUN

 

 

 

1

CHAR

607

607

SUSEVUSE

DSCCNANS

ANSUBSEV

 

1

CHAR

608

608

SUDURUSE

DSCCNANS

ANSUBDUR

 

1

CHAR

609

609

SURCVSUP

DSCCNANS

ANSUBREC

 

1

CHAR

610

610

SUSTGRCV

DSCCNANS

ANSUBSTG

 

1

CHAR

611

611

ACSNOTAPP

DSCCNANS

ANCARNA

 

1

CHAR

612

612

ACSNPHYBE

DSCCNANS

ANCARHTH

 

1

CHAR

613

613

ACSNINVLV

DSCCNANS

ANCARINV

 

1

CHAR

614

614

ACSNKNOWL

DSCCNANS

ANCARKNW

 

1

CHAR

615

615

ACSNSOCRS

DSCCNANS

ANCARSOC

 

1

CHAR

616

616

ACSNFAMST

DSCCNANS

ANCARSTR

 

1

CHAR

617

617

ACSNSAFTY

DSCCNANS

ANCARSAF

 

1

CHAR

618

618

VCASPIR

DSCCNANS

ANVOCCAR

 

1

CHAR

619

619

VCJOBTM

DSCCNANS

ANVOCJTM

 

1

CHAR

620

620

VCJOBATT

DSCCNANS

ANVOCJAT

 

1

CHAR

621

621

VCJOBPER

DSCCNANS

ANVOCJPR

 

1

CHAR

622

622

VCJOBREL

DSCCNANS

ANVOCJRL

 

1

CHAR

623

623

VCJOBSKL

DSCCNANS

ANVOCJSK

 

1

CHAR

624

624

DNCOGN

DSCCNANS

ANDEVCOG

 

1

CHAR

625

625

DNCOMM

DSCCNANS

ANDEVCOM

 

1

CHAR

626

626

DNDEV

DSCCNANS

ANDEVDEV

 

1

CHAR

627

627

PCRKNOWLG

DSCCNANS

ANPARKNW

 

1

CHAR

628

628

PCRSUPER

DSCCNANS

ANPARSPV

 

1

CHAR

629

629

PCRINVCR

DSCCNANS

ANPARINV

 

1

CHAR

630

630

PCRORGZA

DSCCNANS

ANPARORG

 

1

CHAR

631

631

PCRVIOHOM

DSCCNANS

ANPARVIO

 

1

CHAR

632

632

TRSEXABU

DSCCNANS

ANTRMSEX

 

1

CHAR

633

633

TRPHYABU

DSCCNANS

ANTRMPAB

 

1

CHAR

634

634

TREMOABU

DSCCNANS

ANTRMEAB

 

1

CHAR

635

635

TRMEDTRM

DSCCNANS

ANTRMMED

 

1

CHAR

636

636

TRDISAST

DSCCNANS

ANTRMDIS

 

1

CHAR

637

637

TRWITFAM

DSCCNANS

ANTRMFMV

 

1

CHAR

638

638

TRWITCOM

DSCCNANS

ANTRMCMV

 

1

CHAR

639

639

TRAFFREG

DSCCNANS

ANTRMREG

 

1

CHAR

640

640

TRINTRUS

DSCCNANS

ANTRMINT

 

1

CHAR

641

641

TRATTACH

DSCCNANS

ANTRMATT

 

1

CHAR

642

642

TRDISSOC

DSCCNANS

ANTRMDSC

 

1

CHAR

643

643

SUSUICID

DSCCNANS

ANSUIIDE

 

1

CHAR

644

644

SUSUIINT

DSCCNANS

ANSUIINT

 

1

CHAR

645

645

SUSUIPLN

DSCCNANS

ANSUIPLN

 

1

CHAR

646

646

SUSUIHIS

DSCCNANS

ANSUIHIS

 

1

CHAR

647

647

DAINTENT

DSCCNANS

ANDNGINT

 

1

CHAR

648

648

DAPLAN

DSCCNANS

ANDNGPLN

 

1

CHAR

649

649

DAVIOH

DSCCNANS

ANDNGVIO

 

1

CHAR

650

650

DAFRUSMG

DSCCNANS

ANDNGFRM

 

1

CHAR

651

651

DAHOSTIL

DSCCNANS

ANDNGHOS

 

1

CHAR

652

652

DAPARNOD

DSCCNANS

ANDNGPRN

 

1

CHAR

653

653

DAANGRGN

DSCCNANS

ANDNGANG

 

1

CHAR

654

654

DAVIOTHK

DSCCNANS

ANDNGVTH

 

1

CHAR

655

655

DAAWRVIO

DSCCNANS

ANDNGAVP

 

1

CHAR

656

656

DARSPCSQ

DSCCNANS

ANDNGRCQ

 

1

CHAR

657

657

DASLFCTL

DSCCNANS

ANDNGCTL

 

1

CHAR

658

658

DATRTINV

DSCCNANS

ANDNGTRT

 

1

CHAR

659

659

SABRELAT

DSCCNANS

ANSABREL

 

1

CHAR

660

660

SABPHFRC

DSCCNANS

ANSABTHR

 

1

CHAR

661

661

SABPLAN

DSCCNANS

ANSABPLN

 

1

CHAR

662

662

SABAGEDF

DSCCNANS

ANSABAGE

 

1

CHAR

663

663

SABSXACT

DSCCNANS

ANSABACT

 

1

CHAR

664

664

SABRSPAC

DSCCNANS

ANSABRSP

 

1

CHAR

665

665

CRSERIOS

DSCCNANS

ANCRMSER

 

1

CHAR

666

666

CRHIS

DSCCNANS

ANCRMHIS

 

1

CHAR

667

667

CRARR

DSCCNANS

ANCRMARR

 

1

CHAR

668

668

CRPLAN

DSCCNANS

ANCRMPLN

 

1

CHAR

669

669

CRCOMSAF

DSCCNANS

ANCRMSAF

 

1

CHAR

670

670

CRLEGCPL

DSCCNANS

ANCRMLEG

 

1

CHAR

671

671

CRPEERIN

DSCCNANS

ANCRMINF

 

1

CHAR

672

672

CRENVIR

DSCCNANS

ANCRMENV

 

1

CHAR

673

673

SEDFLG

DSCGA

SEDIND

 

1

CHAR

674

674

SPMIFLG

DSCGA

SPMIID

 

1

CHAR

675

675

HMLS90

DSCGA

HOMLES

 

2

VARCHAR

676

677

HMLCHRON

DSCGA

CHLIND

 

1

CHAR

678

678

HSPEMR3X

DSCGA

ERGNCY

 

1

CHAR

679

679

HSPADM3X

DSCGA

PSYHSP

 

1

CHAR

680

680

INPADMCNT

DSCGA

PSYADM

 

2

VARCHAR

681

682

INPDYS

DSCGA

PSYDAY

 

2

VARCHAR

683

684

COMORBID

DSCGA

MHSUID

 

1

CHAR

685

685

COMMEDCR

DSCGA

COMRBD

 

1

CHAR

686

686

CURPREG

DSCGA

PREGNT

 

1

CHAR

687

687

BTHDUREP

DSCGA

LIVBTH

 

1

CHAR

688

688

BABYSTA

DSCGA

BBYSTS

 

1

CHAR

689

689

DEPENDCH

DSCGA

DPCHLD

 

1

CHAR

690

690

WEIGHT

DSCGA

CURWGT

Prefill with zeroes

3

VARCHAR

691

693

HEIGHTFT

DSCGA

HGHTFT

Prefill with zeroes

2

VARCHAR

694

695

HEIGHTIN

DSCGA

HGHTIN

Prefill with zeroes

2

VARCHAR

696

697

WAISTIN

DSCGA

WSTCIR

Prefill with zeroes

3

VARCHAR

698

700

SUBSUSED

DSCGA

SUBTYP

 

1

CHAR

701

701

SUBSTNC1

DSCGA

SUBSTNC1

 

4

VARCHAR

702

705

RTADMN1

DSCGA

SUBADMN1

 

1

CHAR

706

706

FRQUS1

DSCGA

SUBFRQUS1

 

1

CHAR

707

707

FSTUS1

DSCGA

SUBAGE1

Prefill with zeroes

2

VARCHAR

708

709

SUBSTNC2

DSCGA

SUBSTNC2

 

4

VARCHAR

710

713

RTADMN2

DSCGA

SUBADMN2

 

1

CHAR

714

714

FRQUS2

DSCGA

SUBFRQUS2

 

1

CHAR

715

715

FSTUS2

DSCGA

SUBAGE2

 

2

VARCHAR

716

717

SUBSTNC3

DSCGA

SUBSTNC3

 

4

VARCHAR

718

721

RTADMN3

DSCGA

SUBADMN3

 

1

CHAR

722

722

FRQUS3

DSCGA

SUBFRQUS3

 

1

CHAR

723

723

FSTUS3

DSCGA

SUBAGE3

 

2

VARCHAR

724

725

SELFHELP

DSCGA

SFHIND

 

1

CHAR

726

726

SLFHLPCT

DSCGA

SFHP30

 

2

VARCHAR

727

728

LGLSTAT

DSCGA

LGLSTS

 

1

CHAR

729

729

LGLINVLV

DSCGA

LGLINV

 

1

CHAR

730

730

LGLCUST

DSCGA

LGLCUS

 

1

CHAR

731

731

CRMJUS

DSCGA

CRJIND

 

1

CHAR

732

732

NBRARR

DSCGA

ARST30

Prefill with zeroes

2

VARCHAR

733

734

JLRECENT

DSCGA

JAILST

 

1

CHAR

735

735

JLRELDT

DSCGA

JAILRL

 

8

VARCHAR

736

743

JLADMCT

DSCGA

DAYREL

Prefill with zeroes

2

VARCHAR

744

745

JLDAYS

DSCGA

ARST90

 

2

VARCHAR

746

747

INCOME

DSCGA

JAIL90

 

1

CHAR

748

748

EARNINC

DSCGA

ERNINC

When populated, must be numeric. Must fill with leading zeros as necessary.

10

VARCHAR

749

758

FILLER02

 

 

 

5

VARCHAR

759

763

UNEMINC

DSCGA

UNEMIN

When populated, must be numeric. Must fill with leading zeros as necessary.

10

VARCHAR

764

773

FILLER03

 

 

 

5

VARCHAR

774

778

SSIINC

DSCGA

SSIDIS

 

10

VARCHAR

779

788

FILLER04

 

 

 

5

VARCHAR

789

793

VADISAB

DSCGA

VACDIS

 

10

VARCHAR

794

803

FILLER05

 

 

 

5

VARCHAR

804

808

TANF

DSCGA

TANFIN

 

10

VARCHAR

809

818

FILLER06

 

 

 

5

VARCHAR

819

823

TRSTFND

DSCGA

TRSTFD

 

10

VARCHAR

824

833

FILLER07

 

 

 

5

VARCHAR

834

838

PENSRI

DSCGA

PNSION

 

10

VARCHAR

839

848

FILLER08

 

 

 

5

VARCHAR

849

853

CHLDSUP

DSCGA

CHLDSP

 

10

VARCHAR

854

863

FILLER09

 

 

 

5

VARCHAR

864

868

ALIMONY

DSCGA

ALIMNY

 

10

VARCHAR

869

878

FILLER10

 

 

 

5

VARCHAR

879

883

OTHINC

DSCGA

OTHERS

 

10

VARCHAR

884

893

FILLER11

 

 

 

5

VARCHAR

894

898

SRCINC

DSCGA

SOURCE

 

25

VARCHAR

899

923

NONCASH

DSCGA

NCBIND

 

1

CHAR

924

924

SRCNOCSH

DSCNCBGA

NCBSRC

 

10

VARCHAR

925

934

SRCOTHR

DSCNCBGA

NCBOTH

 

100

VARCHAR

935

1034

HLTHINS

DSCGA

INSIND

 

1

CHAR

1035

1035

INSTYP

DSCINSGA

INSTYP

 

8

VARCHAR

1036

1043

OTHTYP

DSCINSGA

OTHINS

 

25

VARCHAR

1044

1068

SCHATT

DSCGA

SCHL90

 

1

CHAR

1069

1069

SCHABS

DSCGA

ABSENT

Prefill with zeroes

2

VARCHAR

1070

1071

GRADLVL

DSCGA

CEMPDT

 

2

VARCHAR

1072

1073

EMPDAT

DSCGA

HOMLES

 

8

VARCHAR

1074

1081

HRSWKCMP

DSCGA

CEMPHR

Prefill with zeroes

2

VARCHAR

1082

1083

HRLYWAGE

DSCGA

CEMPWG

Prefill with zeroes

5

VARCHAR

1084

1088

EMPLDAT

DSCGA

NCEMDT

 

8

VARCHAR

1089

1096

HRSWKNON

DSCGA

NCEMHR

Prefill with zeroes

2

VARCHAR

1097

1098

NONTYPE

DSCGA

NCEMTP

 

2

VARCHAR

1099

1100

AVAILBL

DSCGA

AVWORK

 

1

CHAR

1101

1101

NOTAVLRS

DSCGA

NOWORK

 

1

CHAR

1102

1102

DTEMPCON

DSCGA

EMPLDT

 

8

VARCHAR

1103

1110

ENRSTACU

DSCGA

VOCREH

 

1

CHAR

1111

1111

ENRSTAPR

DSCGA

PREVVR

 

1

CHAR

1112

1112

CMPSTRT

DSCGA

CJOBST

 

1

CHAR

1113

1113

CMPLEAV

DSCGA

CJOBLV

 

1

CHAR

1114

1114

FILLER01

 

 

 

2

VARCHAR

1115

1116

DISPLAN

DSCGA

DPPIND

 

1

CHAR

1117

1117

DISTYPE

DSCGA

AMAIND

 

1

CHAR

1118

1118

PCPNOTIF

DSCGA

PCPIND

 

1

CHAR

1119

1119

LVLCARE

DSCGA

DISLOC

 

8

VARCHAR

1120

1127

OTHCARE

DSCGA

DLOCOTH

 

25

VARCHAR

1128

1152

TRMTINV1

DSCGA

ADVIND

 

1

CHAR

1153

1153

TRMTINV2

DSCGA

CHPIND

 

1

CHAR

1154

1154

TRMTINV3

DSCGA

ADTIND

 

1

CHAR

1155

1155

TRMTINV4

DSCGA

FAMIND

 

1

CHAR

1156

1156

TRMTINV5

DSCGA

OSPIND

 

1

CHAR

1157

1157

TRMTINV6

DSCGA

OPPIND

 

1

CHAR

1158

1158

TRMTINV7

DSCGA

LGLIND

 

1

CHAR

1159

1159

TRMTINV8

DSCGA

NONIND

 

1

CHAR

1160

1160

OTHSUPRT

DSCGA

OTHTXT

 

65

VARCHAR

1161

1225

DISRES

DSCGA

DISRES

 

2

VARCHAR

1226

1227

TIMRES

DSCGA

LNGLIV

 

2

VARCHAR

1228

1229

STABIL

DSCGA

HOSSTB

 

1

CHAR

1230

1230

MEDDIS

RVJMAS

JRNTXT

 

250

VARCHAR

1231

1480

GUARPART

DSCGA

DPTIND

 

1

CHAR

1481

1481

CONTACT

DSCGA

CONTCT

 

100

VARCHAR

1482

1581

RELATIN

DSCGA

CNTREL

 

2

VARCHAR

1582

1583

AREACD

DSCGA

FOLPH1

 

3

VARCHAR

1584

1586

EXCHANG

DSCGA

FOLPH2

 

3

VARCHAR

1587

1589

SUFFIX

DSCGA

FOLPH3

 

4

VARCHAR

1590

1593

EXTENSN

DSCGA

FOLPH4

 

8

VARCHAR

1594

1601

AFTPRV

DSCGA

AFBHPR

 

1

CHAR

1602

1602

AFTOON

DSCGA

BONIND

 

1

CHAR

1603

1603

AFTPRNAM

DSCGA

BPRNAM

 

150

VARCHAR

1604

1753

AFTPRACD

DSCGA

BPRPH1

 

3

VARCHAR

1754

1756

AFTPREXC

DSCGA

BPRPH2

 

3

VARCHAR

1757

1759

AFTPRSUF

DSCGA

BPRPH3

 

4

VARCHAR

1760

1763

AFTPREXT

DSCGA

BPRPH4

 

8

VARCHAR

1764

1771

AFTAD1

DSCGA

BPRADD

 

55

VARCHAR

1772

1826

AFTAD2

DSCGA

BPRAD2

 

55

VARCHAR

1827

1881

AFTCTY

DSCGA

BPRCTY

 

30

VARCHAR

1882

1911

AFTST

DSCGA

BPRSTA

 

2

VARCHAR

1912

1913

AFTZIP

DSCGA

BPRZIP

 

9

VARCHAR

1914

1922

AFTAPDAT

DSCGA

BAPDAT

 

8

VARCHAR

1923

1930

AFTAPTIM

DSCGA

BAPTIM

 

4

VARCHAR

1931

1934

AFTAPREM

DSCGA

BAPRMD

 

1

CHAR

1935

1935

PRSPHY

DSCGA

AFPRPR

 

1

CHAR

1936

1936

PRSOON

DSCGA

PONIND

 

1

CHAR

1937

1937

PRSNAM

DSCGA

PPRNAM

 

150

VARCHAR

1938

2087

PRSACD

DSCGA

PPRPH4

 

3

VARCHAR

2088

2090

PRSEXC

DSCGA

PPRADD

 

3

VARCHAR

2091

2093

PRSSUF

DSCGA

PPRAD2

 

4

VARCHAR

2094

2097

PRSEXT

DSCGA

PPRPH4

 

8

VARCHAR

2098

2105

PRSAD1

DSCGA

PPRADD

 

55

VARCHAR

2106

2160

PRSAD2

DSCGA

PPRAD2

 

55

VARCHAR

2161

2215

PRSCTY

DSCGA

PPRCTY

 

30

VARCHAR

2216

2245

PRSST

DSCGA

PPRSTA

 

2

VARCHAR

2246

2247

PRSZIP

DSCGA

PPRZIP

 

9

VARCHAR

2248

2256

PRSAPDAT

DSCGA

PAPDAT

MMDDYYYY

8

VARCHAR

2257

2264

PRSAPTIM

DSCGA

PAPTIM

 

4

VARCHAR

2265

2268

PRSAPREM

DSCGA

PAPRMD

 

1

CHAR

2269

2269

MEDNAM

DSCGA

MPRNAM

 

100

VARCHAR

2270

2369

MEDACD

DSCGA

MPRPH1

 

3

VARCHAR

2370

2372

MEDEXC

DSCGA

MPRPH2

 

3

VARCHAR

2373

2375

MEDSUF

DSCGA

MPRPH3

 

4

VARCHAR

2376

2379

MEDEXT

DSCGA

MPRPH4

 

8

VARCHAR

2380

2387

MEDRSN

DSCGA

MEDRSN

 

1

CHAR

2388

2388

MEDAPDAT

DSCGA

MAPDAT

MMDDYYYY

8

VARCHAR

2389

2396

MEDAPTIM

DSCGA

MAPTIM

HHMM

4

VARCHAR

2397

2400

MEDAPREM

DSCGA

MAPRMD

 

1

CHAR

2401

2401

TRWITCRM

DSCCNANS

CNACECRM

 

1

CHAR

2402

2402

TRWARAFF

DSCCNANS

CNACEWAR

 

1

CHAR

2403

2403

TRTERAFF

DSCCNANS

CNACETER

 

1

CHAR

2404

2404

CNANSIND

 

 

 

1

CHAR

2405

2901

PRVALT

 

 

 

15

VARCHAR

2902

2902

AUTHNO2

 

 

 

25

VARCHAR

2903

2927

DISNBR

 

 

 

25

VARCHAR

2928

2952

DISDAT2

 

 

 

8

VARCHAR

2953

2960

ERRCD1

3

VARCHAR

2961

2963

ERRDES1

350

VARCHAR

2964

3313

ERRCD2

3

VARCHAR

3314

3316

ERRDES2

350

VARCHAR

3317

3666

ERRCD3

3

VARCHAR

3667

3669

ERRDES3

350

VARCHAR

3670

4019

ERRCD4

3

VARCHAR

4020

4022

ERRDES4

350

VARCHAR

4023

4372

ERRCD5

3

VARCHAR

4373

4375

ERRDES5

350

VARCHAR

4376

4725

SYSDAT

 

CURRENT DATE

 

26

TIMESTAMP

LSTCHG

 

CURRENT DATE

 

26

TIMESTAMP

USERAD

 

NAME OF NEW PROGRAM

 

10

VARCHAR

USERID

 

NAME OF NEW PROGRAM

 

10

VARCHAR

001

ERRCD1

12

VARCHAR

3

ERRDES1

 

12

VARCHAR

350

002

ERRCD2

 

12

VARCHAR

3

ERRDES2

  Submitter ID not found in crosswalk

12

VARCHAR

350

003

ERRCD3

 

12

VARCHAR

3

ERRDES3

 

PROVTO not found with error code

12

VARCHAR

350

004

ERRCD4

 

12

VARCHAR

3

ERRDES4

 

12

VARCHAR

350

005

ERRCD5

 

12

VARCHAR

3

ERRDES5

 

12

VARCHAR

350

EDI Program (xxxxxxxxx) (tbd)

There will be a need to create an EDI program which should facilitate an email generation upon successful admin discharge file transfer via sftp.

Successful FTP emails would only occur in the development environment (not production). This is to facilitate external provider testing support. If there are Files in GACO Folder, for each File FTP’ed, there will be an email message with the subject, ‘GACO Provider Discharge FTP for <FTP file name>’.

· Email message will include

· FTP Status: Success

· Response file name

· Submitter ID

· Email will be sent to EMAMAS.EMALAD where PROCID = ‘GADFTPSUC’

If the FTP process fails, there will be an email message with the subject, ‘GACO Provider Discharge FTP for <FTP file name>’.

· Email message will include

· FTP Status: Failure

· Instructions to resubmit the file

· 3.Email will be sent to EMAMAS.EMALAD where PROCID = ‘GADFTPERR’

Create Archive folder: The Admin Discharge Extract process will need to have an archive folder created to send the extract file to the archive location even before the file is sfpd’d to the providers. This way even the file is stuck in file connect path or if there is any network issue identified and the file cannot be sent out the door, this archive copy will serve as a back to either send manually or process it. This is an alternate method of storing the file as a backup. Once the file is in ftp path, there should be a way to re-route the file for a back up to the archive folder created. The path will be decided soon.

Error Reporting

An Error Report must be created for each data exchange. This report is going to be internal only. Beacon is not reporting any errors to the providers for this extract. The report must include the following information at a minimum:

Report Summary:

· File Name, File Date and File Size

· Date and Time processed

· Total number of records processed successfully.

· Total number of records that failed to process.

Report Detail:

· Identify each record that failed to process by including the following:

· Unique consumer ID (i.e. MEMBNO, PROVTO etc.)

· Error Type

· Detailed Error message identifying reason for failure of the record

· Field level failure (if any)

The GA admin discharge extract file will generate error reports distributed internally.

Error Table

Create an error table specific for this extract in CAS: The error table will be GADERR and it will have the below errors mentioned in the grid if there are any field level errors identified.

Field Name

Field Description

Type

Length

HISTID

History ID

N

15

TRNID

EDI logging transaction ID

N

15

PARENT

Parent/Client or extract formatting code

A

4

SRCID

ID value of the source record generating this error

N

15

MEMBNUM

Member Number/Member ID

A

15

ERRCD

Error Code

A

3

ERRLVL

Error Level – Warning or Fatal

A

1

ERRMSG

Error Message

A

100

SYSDAT

Date record was processed

P

7

SYSTIM

Time record was processed

P

7

Error Code

ERROR Message

Error Type

Data Type

Length

001

VARCHAR

3

MEMBNO not found

F

VARCHAR

100

002

VARCHAR

3

Submitter ID not found in crosswalk

F

VARCHAR

100

003

VARCHAR

3

PROVTO is blank

F

VARCHAR

100

004

VARCHAR

3

Vendor is blank

F

VARCHAR

100

005

VARCHAR

3

FisrtName is blank

W

VARCHAR

100

006

VARCHAR

3

Lastname is blank

W

VARCHAR

100

5 EDI TRNID, JOB ID AND FILE ID

Transaction ID, Job ID, and File ID

Standard EDI logging will be implemented.

Suggested data:

Create the following Transaction Types.

a. “'GACO'” record for the Admin Discharge authorization processing when the parent code for the extract is ‘GACO’

Create the following Job Type Records:

b. Parent code ‘GACO’

i. “GACOAD’” for Admin Discharge

The file will have the same characteristics as the current batch discharge response file, such as txt type file, fixed-length format, all fields are left-justified, each line ends with a CRLF, and, each record will be on a separate line.

The program should populate the admin discharge records from the respective source tables to populate GA Administrative Discharge table as outlined below: GADHIST

File Format

Type/Format: .txt fixed length text

File Layout Name: TBD

File Location: \\vo-dca-fcint\FileConnect\Archives\GA\AD\Archive

File Naming Convention

The file naming convention is [PROVIDER ID].DX.MMDDYY.00.00.00.txt

Beacon to Provider: The admin discharge file is OB to Beacon and sent out to the providers.

Server Directory

Data Details

File Naming Convention

Schedule

\Downloads

Admin Discharge Extract

[PROVIDER ID].DX.MMDDYY.00.00.00.txt

Daily/5 AM(TBD)

File Processing

Record vs File Failure

.

If no record found in CWKMAS, do not process GA Administrative Discharge Response for this provider. Populate GA Administrative Discharge (GADERR.ERRCOD) with error code ‘002’ and error message “Submitter ID not found in crosswalk.”

When at least one error code is written to the history table in any one job, the program will send an email notification as outlined in the Email Notifications section.

File Testing

Beacon will submit test files to DBHDD, 3 weeks prior to the agreed upon Implementation date.

File Schedule

The job will run daily at 5:00 am

The executable Job Name is: ___TBD AOXXXXX______________.

File Transfers

Beacon trading partners can use the FileConnect Portal web site as a file transfer portal. This site is accessed at https://www.valueoptions.com/fcportal/login.do and is used strictly for uploading or downloading files to and from Beacon. Set up forms will be sent separately to trading partners upon request.

Following is Beacon’s standard file transmission protocol:

Sender: Beacon

Receiver: GACOPROVIDER

Method: The file will be uploaded (pushed) to Beacon’s secure FTP server.

Secure FTP: ftp://ftps.beaconhs.com

File Storage/ Archive

CAS – (FileConnect)

· \\vo-dca-fcint\FileConnect\Archives\GA\AD\Archive

Notifications

The program should generate an email notification when at least one error is written to the history table (i.e., populates GADHIST.ERRCOD).

The email will be send to EMAMAS.EMALAD where PROCID = ‘GAAGENERR’. This PROCID is a placeholder until the job name is created Notifications will be generated via File Connect processes.

Error Log Files

When at least one error code is written to the history table in any one job, the program will send an email notification as outlined in the Email Notifications section. Error files or log are internal to Beacon.

EDI Document Review and Approval

Sign off by at least one of the below is required:

Name

Title

Date

Approved: __________

EDI Clinical Team Lead

Approved: __________

Director, EDI Operations - Provider & Clinical

15. Appendix

Process Flow