Record Type |
Description |
Notes |
0010 | Global Information Record | Required. 1 per flat file. |
1000 | Letter record | Required. 1 per letter. |
1100 | Mailing Information | Required. 1 per letter. |
Note | Additional record types are defined for specific letters. Refer to Specific Record Types for details. | |
9990 | End of Letter Record | Required. 1 per letter. |
The following table describes the structure of the sort key and the values for the common record types.
Field Name |
Format |
Source / Value / Description |
LTR_TMPL_CD |
A12 |
|
CC_ID |
A10 |
|
CC Record Group |
A2 |
This field forces the letter’s records into the correct order. Values: 10 – General Letter information 20 – Mailing information Note: Specific letter record types define their own CC Record Group. Refer to Specific Record Types for examples. 99 – End Letter |
Sub Record Group |
A2 |
Available for specific letter record types to further control the sort of records. Refer to Specific Record Types for examples. |
Mailing key contains the postal code.
The following shows the letter information for the common record types together with their associated record type, sort and mailing key.
Global Information Record
This is a “header” record that contains information about the extract run as a whole.
Field Name |
Format |
Source / Value / Description |
Record Type | A4 | "0010" |
Sort Key | A26 | This is blank for this record type only. |
Mailing Key | A15 | This is blank for this record type only. |
BATCH_CD | A8 | CI_BATCH_INST / The Batch Process that called the Letter Extract COBOL routine |
BATCH_NBR | N10 | CI_BATCH_INST / A sequence number for serial instances of a Batch Process over time |
BATCH_RERUN_NBR | N10 | CI_BATCH_INST / The number of times a particular batch has been re-run since its initial run |
Letter Count | N10 | Total number of letters in this extract |
Date/Time | A26 | System time of extraction. |
CC Id Start | A10 | The lowest CC ID in a particular thread in the extract |
CC Id End | A10 | The highest CC ID in a particular thread in the extract |
BATCH_THREAD_NBR | N10 | CI_BATCH_THD / Identifies a thread distinctly within a group of threads |
Thread Count | N10 | Total number of threads in the extract run |
Letter Record
One record is produced for every letter to be printed.
Field Name |
Format |
Source / Value / Description |
Record Type | A4 | "1000" |
Sort Key | A26 | |
Mailing Key | A15 | |
CC_ID | A10 | CI_CC / System-assigned identifier for a Customer Contact. |
PER_ID | A10 | CI_CC / System-assigned identifier for the Person who will receive the letter. |
CC_DT | D10 | CI_CC / The date of the Customer Contact. |
CC_TM | T15 | CI_CC / The time of the Customer Contact. |
CC_CL_CD | A4 | CI_CC / The category of contact. |
CC_TYPE_CD | A12 | CI_CC / The type of contact within the category. |
LTR_TMPL_CD | A12 | CI_CC / The template of the letter. |
LTR_DT | D10 | From the current system date/time - the date to print on the letter. |
Mailing Information Record
One record is produced for every letter to be printed.
Field Name |
Format |
Source / Value / Description |
Record Type | A4 | "1100" |
Sort Key | A26 | |
Mailing Key | A15 | |
ENTITY_NAME1 | A64 | If an override mailing name has been specified on the CI_PER row, this field contains the first line of the person’s override mailing name (OVRD_MAIL_NAME1). Otherwise, the person’s primary name is used (ENTITY_NAME). |
ENTITY_NAME2 | A64 | If an override mailing name has been specified on the CI_PER row, this field contains the 2nd line of the person’s override mailing name (OVRD_MAIL_NAME2). Otherwise, this field is blank. |
ENTITY_NAME3 | A64 | If an override mailing name has been specified on the CI_PER row, this field contains the 3rd line of the person’s override mailing name (OVRD_MAIL_NAME3). Otherwise, this field is blank. |
ADDRESS_SBR |
Address Constituents. Total number of bytes = 361. Refer to How The Address is Determined below for the source of the address information. |
|
COUNTRY | A3 | |
ADDRESS1 | A64 | |
ADDRESS2 | A64 | |
ADDRESS3 | A64 | |
ADDRESS4 | A64 | |
CITY | A30 | |
NUM1 | A6 | |
NUM2 | A4 | |
HOUSE_TYPE | A2 | |
COUNTY | A30 | |
STATE | A6 | |
POSTAL | A12 | |
GEO_CODE | A11 | |
IN_CITY_LIMIT | A1 |
End of Letter Record
Field Name |
Format |
Source / Value / Description |
Record Type | A4 | "9990" |
Sort Key | A26 | |
Mailing Key | A15 |
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]