06 survey log file records lookup earslog es2lkup

Survey Log File (Records in Lookup File) (EARSLOG/ES2LKUP)

EARSLOG (ES2LKUP) - Length 132 - Revised 9/8/2006

Columns​ ​		Len	Key	Type	COBOL Field Name	Description & Notes
1	2	2	Key	Char	SLOG-REC-TYPE	Record type code distinguishes Survey Log records from other Lookup File entries; 'SL' = Survey Log entry
3	6	4	Key	Char	SLOG-REC-KEY-SEQ	Record sequence number used to distinguish one Survey Log record from another; numbered sequentially from 0000 upward
7	12	6	Key	Char	FILLER	spaces
13	132	120		Char	SLOG-DATA	Remainder of the record identified by this field name
13	132	120R		Char	SLOG-DESCRIPTION	Full-data component of the Survey Log record; redefined below and in the records that follow
​​​​​--- Header Survey Log Record, Denoting Processing Year (0000) --- ​ ​ ​ ​ ​ ​
13	16	4		Num	SLOG-REFILE-YEAR	Year of refiling (ending year of the cycle; e.g., 2003-2004 cycle => '2004')
17	132	116		Char	FILLER	spaces
​​​​​--- First Mailing Record (Record sequence number 0001) --- ​ ​ ​ ​ ​ ​
13	20	8		Num	SLOG-MAIL-1-DATE-NVS	First mailing's single accounts' (NVS forms) shipping date (yyyymmdd format)
21	28	8		Num	SLOG-MAIL-1-DATE-TRS	Date of first mailing of TRS-eligible accounts NVS forms (yyyymmdd format)
29	36	8		Num	SLOG-MAIL-1-DATE-NVM	First mailing's multi families' (NVM forms) shipping date (yyyymmdd format)
37	43	7		Num	SLOG-MAIL-1-NVS	Number of single account (NVS) forms shipped in first mailing (10 million limit)
44	50	7		Num	SLOG-MAIL-1-TRS	NVS forms for carry-over singles included with first mailing
51	57	7		Num	SLOG-MAIL-1-NVM	Number of multi-family (NVM) forms sent out in the first mailing
58	64	7		Num	SLOG-MAIL-1-SINGLES	Number of single accounts involved in the combined NVS and TRS first mailings
65	71	7		Num	SLOG-MAIL-1-MASTERS	Number of masters included in first mailing of NVM forms
72	78	7		Num	SLOG-MAIL-1-WORKSITES	Number of worksites included in first mailing of NVM forms
79	85	7		Num	SLOG-MAIL-1-SINGLE-CARRY	Number of carried-over singles included in first NVS forms mailings
86	92	7		Num	SLOG-MAIL-1-MASTER-CARRY	Number of carry-over masters included in first NVM form mailing
93	99	7		Num	SLOG-MAIL-1-WORKSITES-CARRY	Number of carry-over worksites included in first NVM forms mailing
100	106	7		Num	SLOG-MAIL-1-N7R-NVS	Number of single account (NVS) forms that involve a NAICS 2007 revision code
108	113	7		Num	SLOG-MAIL-1-N7R-NVM	Number of multi family (NVM) forms involving a NAICS 2007 revision code
114	132	19		Char	FILLER	spaces
​​​​​--- Second Mailing Record (Sequence Number 0002) --- ​ ​ ​ ​ ​ ​
13	20	8		Num	SLOG-MAIL-2-DATE-NVS	Date of second mailing of single account (NVS) refiling forms (yyyymmdd format)
21	28	8		Num	SLOG-MAIL-2-DATE-TRS	Date of second mailing of TRS-eligible NVS forms (yyyymmdd format)
29	36	8		Num	SLOG-MAIL-2-DATE-NVM	NVM forms' second mailing date (yyyymmdd format)
37	43	7		Num	SLOG-MAIL-2-NVS	Number of NVS forms produced during the second mailing
44	50	7		Num	SLOG-MAIL-2-TRS	Number of TRS-eligible NVS forms produced during the second mailing
51	57	7		Num	SLOG-MAIL-2-NVM	Number of NVM forms produced by the second mailing
58	64	7		Num	SLOG-MAIL-2-SINGLES	Count of single accounts included in the second NVS refiling forms' mailing
65	71	7		Num	SLOG-MAIL-2-MASTERS	Count of master accounts involved with the second mailing of NVM refiling forms
72	78	7		Num	SLOG-MAIL-2-WORKSITES	Count of worksites included in the second mailing of NVM refiling forms
79	132	54		Char	FILLER	spaces
​​​​​--- Third Mailing Record (Sequence Number 0003) --- ​ ​ ​ ​ ​ ​
13	20	8		Num	SLOG-MAIL-3-DATE-NVS	Date of third mailing of single account (NVS) refiling forms (yyyymmdd format)
21	28	8		Num	SLOG-MAIL-3-DATE-TRS	Third TRS-eligible NVS forms mailing date (yyyymmdd format)
29	36	8		Num	SLOG-MAIL-3-DATE-NVM	NVM forms' third mailing date (yyyymmdd format)
37	43	7		Num	SLOG-MAIL-3-NVS	Number of NVS forms produced during the third mailing
44	50	7		Num	SLOG-MAIL-3-TRS	Number of TRS-eligible NVS forms produced during the third mailing
51	57	7		Num	SLOG-MAIL-3-NVM	Number of NVM forms produced during the third mailing
58	64	7		Num	SLOG-MAIL-3-SINGLES	Count of single accounts included in the third NVS refiling forms' mailing
65	71	7		Num	SLOG-MAIL-3-MASTERS	Count of master accounts involved with the third mailing of NVM refiling forms
72	78	7		Num	SLOG-MAIL-3-WORKSITES	Count of worksites included in the third mailing of NVM refiling forms
79	132	54		Char	FILLER	spaces
​​​​​--- Fourth Mailing Record (Sequence Number 0004) --- ​ ​ ​ ​ ​ ​
13	20	8		Num	SLOG-MAIL-4-DATE-NVS	Date of fourth mailing of single account (NVS) refiling forms (yyyymmdd format)
21	28	8		Num	SLOG-MAIL-4-DATE-TRS	Date of fourth mailing of TRS-eligible NVS refiling forms (yyyymmdd format)
29	36	8		Num	SLOG-MAIL-4-DATE-NVM	NVM forms' fourth mailing date (yyyymmdd format)
37	43	7		Num	SLOG-MAIL-4-NVS	Number of NVS forms printed during the fourth mailing
44	50	7		Num	SLOG-MAIL-4-TRS	Number of TRS-eligible NVS forms printed during the fourth mailing
51	57	7		Num	SLOG-MAIL-4-NVM	Number of NVM forms printed for the fourth mailing
58	64	7		Num	SLOG-MAIL-4-SINGLES	Count of single accounts included in the fourth NVS refiling forms' mailing
65	71	7		Num	SLOG-MAIL-4-MASTERS	Count of master accounts involved with the fourth mailing of NVM refiling forms
72	78	7		Num	SLOG-MAIL-4-WORKSITES	Count of worksites included in the fourth mailing of NVM refiling forms
79	85	7		Num	SLOG-CURRENT-TRS	Number of TRS forms sent out in most recent mailing; this field, like the two counts that follow, can apply to the first, second, third, or fourth mailing, whichever is the most recent; the counts are stored in this record for convenience
86	92	7		Num	SLOG-CURRENT-NVS	Number of NVS forms sent out in most recent mailing
93	99	7		Num	SLOG-CURRENT-NVM	Number of NVM forms sent out in most recent mailing
100	132	33		Num	FILLER	spaces
​​​​​--- "Fifth" Mailing Record – Used to store the last NCA Mailing Date (Sequence Number 0005) --- ​ ​ ​ ​ ​ ​
13	20	8		Num	SLOG-LAST-MAIL-DATE-NCA	Date of the most recent mailing of Non-Classified Account (NCA) refiling forms (using the standard yyyymmdd format)
21	132	112		Char	FILLER	spaces
Survey Log File Data Set Name:                   WS.ES202.LOOKUP Service Center DSN:           YBUssX.A145.LOOKUP ('ss' = State FIPS code) Type of File:                         Sequential File Layout:                          EARSLOG CICS ID:                               ES2LKUP (EssLKUP for Service Center; 'ss' is State FIPS) This is an alias of the Lookup File, used for maintaining statistics related to the course of refiling processes.  The dates and number of forms used in each of the mailings are noted in addition to special flags and dates for other auxiliary processing information.  There are five records in this group.  The records are initialized in Job EARJ100A as part of generating the new year's Refiling File.  All of the record counts are set to zero for proper tracking throughout the year. Most of the updates to this file occur in batch jobs.  The standard refiling form print jobs (103D and 104D) update the Survey Log records by setting the tallies of forms produced by the various mailings.  Survey Log records have only limited connection to CICS programs, in that the EARC screen can increment deleted record counts when an account is removed from the Refiling File.  Otherwise the data remain untouched by CICS throughout the cycle. ​Special totals for accounts that have some involvement with NAICS codes that are included in the 2007 NAICS revision are listed in the first mailing as a Version 9 enhancement. ​ ​ ​ ​ ​

Related Links

• TRS Eligible File (EARTRS)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home