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 |
Revision Description |
Revised By |
|
|
1.01 |
02/25/2019 |
Initial Draft |
|
|
1.02 |
|
Revisions |
|
|
|
|
|
|
|
|
|
|
|
II Functional Specifications 6
3 Create a new h istory table in CAS: 10
14 EDI Document Review and Approval 34
Sign off by at least one of the below is required: 34
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