Section - 6 : Input Data Structure
The New York state application code expects to receive the NYID-INSURANCE-INFO input data structure. This data structure should be in a native format (such as EBCDIC on MVS, ASCII on Windows NT) and will be converted to ASCII, if necessary by Oracle routines.
Note: The New York state required data formatting is adopted from public industry standards. These formatting requirements are accomplished in the software you get from the NYSID. These formats include the American Association of Motor Vehicle Administrators (AAMVA) compliant bar code, MD5 message digest algorithms, and the public domain encryption algorithm called Triple DES which generates the required internal digital signature.
The New York application code is written in C/C++ and uses many conventions specific to those languages. Many Oracle implementations will use COBOL programs to interface to this application code. Therefore, part of the interface project involves inter-language communication. Oracle provides COBOL layouts that match the format expected by the C/C++ programs, and will work across the inter-language procedure calls.
The COBOL copybook record structure is defined in NYINSINF.CBL as shown below. COBOL application programs should first set the structure to all NULLs (low values such as binary zero).
This makes sure the FILLER members remain set to NULL as each data member is assigned. As each data member is assigned a value, COBOL will blank fill any unused character positions. The receiving program (written in C/C++) will use a structure view and treat each field as a null-terminated C string.
01 NYID-INSURANCE-INFO.
02 NYID-REGISTRANT-SUB-FILE.
04 NYID-R-LAST-NAME-1 PIC X(18).
04 FILLER PIC X.
04 NYID-R-FIRST-NAME-1 PIC X(16).
04 FILLER PIC X.
04 NYID-R-MIDDLE-NAME-1 PIC X(16).
04 FILLER PIC X.
04 NYID-R-NAME-SUFFIX-1 PIC X(3).
04 FILLER PIC X.
04 NYID-R-NAME-AS-ONE-1 PIC X(20).
04 FILLER PIC X.
04 NYID-R-CLIENT-ID-1 PIC X(9).
04 FILLER PIC X.
04 NYID-R-LAST-NAME-2 PIC X(18).
04 FILLER PIC X.
04 NYID-R-FIRST-NAME-2 PIC X(16).
04 FILLER PIC X.
04 NYID-R-MIDDLE-NAME-2 PIC X(16).
04 FILLER PIC X.
04 NYID-R-NAME-SUFFIX-2 PIC X(3).
04 FILLER PIC X.
04 NYID-R-NAME-AS-ONE-2 PIC X(20).
04 FILLER PIC X.
04 NYID-R-CLIENT-ID-2 PIC X(9).
04 FILLER PIC X.
04 NYID-R-STREET PIC X(20).
04 FILLER PIC X.
04 NYID-R-CITY PIC X(15).
04 FILLER PIC X.
04 NYID-R-STATE PIC X(2).
04 FILLER PIC X.
04 NYID-R-ZIP-CODE PIC X(9).
04 FILLER PIC X.
04 NYID-R-ORGANIZATION-LINE-1 PIC X(20).
04 FILLER PIC X.
04 NYID-R-ORGANIZATION-LINE-2 PIC X(20).
04 FILLER PIC X.
04 NYID-R-ORGANIZATION-FEIN PIC X(9).
04 FILLER PIC X.
02 NYID-VEHICLE-SUB-FILE.
04 NYID-V-VIN-NUMBER PIC X(25).
04 FILLER PIC X.
04 NYID-V-YEAR PIC X(4).
04 FILLER PIC X.
04 NYID-V-MAKE PIC X(5).
04 FILLER PIC X.
04 NYID-V-REP-IND PIC X(1).
04 FILLER PIC X.
04 NYID-V-HIST-IND PIC X(1).
04 FILLER PIC X.
04 NYID-V-TOW-IND PIC X(1).
04 FILLER PIC X.
04 NYID-V-SEATS PIC X(2).
04 FILLER PIC X.
04 NYID-V-VIN-OVERRIDE PIC X(1).
04 FILLER PIC X.
02 NYID-INSURANCE-SUB-FILE.
04 NYID-I-DOCUMENT-TYPE PIC X(15).
04 FILLER PIC X.
04 NYID-I-PAPER-SELECTION PIC X(15).
04 FILLER PIC X.
04 NYID-I-ISSUER-ID PIC X(10).
04 FILLER PIC X.
04 NYID-I-INS-COMPANY-CODE PIC X(3).
04 FILLER PIC X.
04 NYID-I-INS-COMPANY-NAME PIC X(40).
04 FILLER PIC X.
04 NYID-I-INS-ISSUANCE-DATE PIC X(8).
04 FILLER PIC X.
04 NYID-I-COVERAGE-START-DATE PIC X(8).
04 FILLER PIC X.
04 NYID-I-COVERAGE-END-DATE PIC X(8).
04 FILLER PIC X.
04 NYID-I-POLICY-NUMBER PIC X(15).
04 FILLER PIC X.
04 NYID-I-AGENCY-NAME PIC X(40).
04 FILLER PIC X.
04 NYID-I-AGENCY-ADDRESS-LINE-1 PIC X(40).
04 FILLER PIC X.
04 NYID-I-AGENCY-ADDRESS-LINE-2 PIC X(40).
04 FILLER PIC X.
04 NYID-I-IS-ORGANIZATION PIC X(1).
04 FILLER PIC X.
02 NYID-DIGITAL-CERT-SUB-FILE.
04 NYID-S-SIGNATURE-TYPE PIC X(4).
04 FILLER PIC X.
04 NYID-S-DIGITAL-SIGNATURE PIC X(32).
04 FILLER PIC X.