mapcon.txt (2/19/90 - KGW) SFS added MilPer 6/11/90 ESINPUT type Descriptions _________________________ fulldate - YYMMDD - should always have Datecon as an ES conversion. L(TABLENAME) - Indicates that valid values are found in the first cloumn of TABLENAME. The same table is usually used by TABLECON(). 'L' indicates that a list function is used by the front end. T(TABLENAME) - Indicates that valid values are found in the first cloumn of TABLENAME. The same table is usually used by TABLECON(). 'T' indicates that a toggle function is used by the front end. YMDate - YYMM YN - only legal values are "Y" and "N" YNBlank - only legal values are "Y", "N", and "Blank" - should always have Tablecon(YNB,'-') as an ES conversion. Others - If none of the above, text, nor numeric probably okay to assume text for now. Conversion Descriptions _______________________ BY12(FIELDNAME) - Used to convert feet/inches to inches. Multiply FIELDNAME by 12 and add to current field. BYK() - divide current field by 1000. DATECON() - Used to convert yymmdd format to mm/dd/yy format. DECIMALPLACES(n) - the field has 'n' decimal places. For example, a field with 2 decimal places is marked DecimalPlaces(2). KS(KEY) - write out value of current field to remarks.txt using KEY. KSIF(KEY,TEST,VALUE,STRING) - write out STRING to remarks.txt using KEY if current field is = or != VALUE. Blank VALUEs are specified by ''. KSIF2(KEY,TEST,VALUE) - write out value of current field to remarks.txt using KEY if current field is = or != VALUE. Blank VALUEs are specified by ''. KSTAB(KEY,TABLENAME,INVALID) - combination Keyed string/table conversion. Do the table conversion. If the conversion succeeds write the conversion value to remarks.txt using KEY. If the conversion fails write to remarks.txt using KEY and the value specified by INVALID. TABLECON(TABLENAME,INVALID) - There are two columns in the table: Column 1 represents ESINPUT file value name while Column 2 represents the corresponding attribute values. Column 1 may also be used for validating ESINPUT data when the table name appears in the ESINPUT TYPE column of the mapping file. Column 1 should be treated as case insensitive, while column 2 is should be used as is (preserve case specified). If value does not match column 1, then INVALID should be output as the conversion value. TOMONTHS() - Used to calculate total number of months. ESINPUT form is YYMM. Multiply year portion by 12 and add to months portion. VALIND(TABLENAME,FIELD,INVALID) - Indirect validation; the proper table of valid values to be used for this field depends upon the value of another field - specified by FIELD: 1. Take that FIELD and do a TABLECON() on it using TABLENAME. 2. If TABLECON() fails (value not found in TABLE), then the conversion value should be set to the value specified in INVALID. 3. If TABLECON() succeeds, then the value returned is the name of the table to be used to validate the current field. Perform a second TABLECON() using this table, with the value of INVALID as the second parameter. So far, this has very limited use - FIELD is always Line-of-business. Do you want to specify differently? __________________________________________________________________________ DEATH ESINPUT: DM: L Level D Decreasing EXAM ESINPUT: DM: 2a QUES2A 2b QUES2B 2c QUES2C 2d QUES2D 2e QUES2E 2f QUES2F 2g QUES2G 2h QUES2H 2i QUES2I 2j QUES2J 2k QUES2K 2l QUES2L 3 QUES3 4 QUES4 5 QUES5 6a QUES6A 6b QUES6B 6c QUES6C 6d QUES6D 6e QUES6E 7a QUES7A 7b QUES7B 8 QUES8 9a QUES9A 9b QUES9B misc QUESMISC EXAMTYPE ESINPUT: DM: 0 NOEXAM 1 MEDPI 2 PMEDPI 3 MEDSP 4 PMEDSP FLEXV ESINPUT: DM: 16a QUES16A 16b QUES16B 16c QUES16C 17a QUES17A 17b QUES17B 17c QUES17C 18 QUES18 19 QUES19 20 QUES20 21 QUES21 FORM ESINPUT: DM: 174 form001 174-VL form002 11007 form003 3151R form004 3152R form005 1493R form006 1797 form007 7581B form008 7581B-VL form009 3401R form010 3401R-VL form011 7581A form012 7581A-VL form013 BP100 form014 15708 form015 15575 form016 15775 form017 15761DE form018 15761DC form019 15761GA form020 15674 form021 15576 form022 15576C form023 15576S form024 15761MA form025 15761 form026 15692 form027 15761NY form028 15669 form029 15577 form030 15675 form031 128 form032 128-VL form033 129 form034 15738 form035 15728 form036 3509R form037 272R-EC form038 7982 form039 157 form040 157-VL form041 8258 form042 1810R form043 VLI-187 form044 1112 form045 1112-CR form046 7157 form047 303R form048 2980 form049 496R form050 VLI-76 form051 12942 form052 UL-2011 form053 15772 form054 1341 form055 3053 form056 1548 form057 8218 form058 VLI-178 form059 7170R form060 13318 form061 13817 form062 13817VL form063 13817VL-CT form064 13817VL-NC form065 12976 form066 174R(I)NY form067 14822 form068 473R form069 3508R form070 50R form071 172 form072 7016 form073 13080 form074 VLI-155 form075 JHD-12 form076 W-9 form077 15871 form078 VLI-192 form079 13515 form080 13515VL form081 EKG form082 BPU-101SR form083 MA FORM form084 INCOME ESINPUT: DM: a 10000 b 15000 c 20000 d 25000 e 35000 f 50000 g 75000 h 100000 i 110000 u 0 INFORCE ESINPUT: DM: JH IND JHIND JH GRP JHGROUP OT IND OTHIND OT GRP OTHGROUP LOB ESINPUT: DM: 1 PNO 3 VLI 4 FLEXV MEDFORM ESINPUT: DM: VMED VLIMED VPMED VLIPMED OMED PNOMED OPMED PNOPMED MILGRADE ESINPUT: DM: E-9 E9 E-8 E8 E-7 E7 E-6 E6 E-5 E5 E-4 E4 E-3 E3 E-2 E2 E-1 E1 W-4 W4 W-3 W3 W-2 W2 W-1 W1 O-1 O1 O-2 O2 O-3 O3 O-4 O4 O-5 O5 O-6 O6 O-7 O7 O-8 O8 MILPER ESINPUT: DM: I INSURED S SPOUSE B BOTH O OTHER OWNER ESINPUT: DM: I INSURED B BUSINESS O OTHER PARTB ESINPUT: DM: 1a QUES1A 1b QUES1B 2 QUES2 3a QUES3A 3b QUES3B 4 QUES4 misc QUESMISC PARTC ESINPUT: DM: 15a QUES15A 15b QUES15B 15c QUES15C 15d QUES15D 15e QUES15E 15f QUES15F 15g QUES15G 15h QUES15H 16a QUES16A 16b QUES16B 17 QUES17 misc QUESMISC PHYSSTAT ESINPUT: DM: P Provided B Blank N None PIF ESINPUT: DM: 0 INVALID 1 NOTSENT 2 NORETURN 3 NOHIT 4 HIT 5 BADREPLY PNO ESINPUT: DM: 18a QUES18A 18b QUES18B 18c QUES18C 19a QUES19A 19b QUES19B 19c QUES19C 20 QUES20 21 QUES21 22 QUES22 23 QUES23 PREM ESINPUT: DM: A Annual S SemiAnn Q Quart P MonthlyPC E MonthlyEC G MonthlyMA REL ESINPUT: DM: Aunt Aunt Blank Blank Brother Brother Child Child Children Child Corporation Corp Cousin Cousin Daughter Daughter Father Father Fiance Fiance Friend Friend Granddaughter Granddghtr Grandfather Grandfthr Grandmother Grandmthr Grandson Grandson Legal Guardian Guardian Guardian Guardian Husband Husband Insured Insured Estate InsEstate Mother Mother Nephew Nephew Niece Niece Other Other Owner Owner Parents Parents Partner Partner Partnership Partner Pension Trust PT Sister Sister Son Son Spouse Spouse Stepdaughter Stepdghtr Stepfather Stepfather Stepmother Stepmother Stepson Stepson Trustee Trustee Uncle Uncle Wife Wife SEX ESINPUT: DM: M M F F SPECDATE ESINPUT: DM: Date Written Written Current Date Current Other RealDate STATE ESINPUT: DM: AB AB AL AL AK AK AZ AZ AR AR BC BC CA CA CO CO CT CT CU CU CZ CZ DE DE DC DC FL FL GA GA GU GU HI HI ID ID IL IL IN IN IA IA KS KS KY KY LA LA ME ME MD MD MA MA MB MB MI MI MN MN MS MS MO MO MT MT MX MX NB NB NE NE NF NF NS NS NV NV NH NH NJ NJ NM NM NY NY NC NC ND ND NT NT OH OH OK OK OR OR ON ON OF OF OP OP PA PA PE PE PI PI PR PR PQ PQ RI RI SC SC SD SD SK SK TN TN TX TX UT UT VT VT VA VA VI VI WA WA WV WV WI WI WY WY YI YI VLI ESINPUT: DM: 16a QUES16A 16b QUES16B 16c QUES16C 17a QUES17A 17b QUES17B 17c QUES17C 18 QUES18 19 QUES19 20 QUES20 21 QUES21 YNB ESINPUT: DM: Y Y N N B Blank