Subscriber Activity Export

The following data elements can be used with the “SubTranExprt” usage.

Data Element	Description
AAM Zone ID	Subscriber’s AAM zone.
Address ID	ID of subscriber’s address in Circulation.
Allow Web Access	Allow web access setting (yes/no).
Area Code	Occupant’s area code.
AreaID, AreaID[H]	Area in which subscriber’s delivery route is located.
Attention Line	Occupant’s attention line.
Auto Renew Length	Length of the auto-renew subscription.
Auto Renew Term	Term of the auto-renew subscription.
Bill Address ID	Address ID of bill-to address.
Billing Method	Subscriber’s billing method.
BillingMethod[H]	Subscriber’s billing method at the time of the transaction.
Bill Occupant ID	Occupant ID of bill-to occupant.
Bill to fields	All standard address and occupant fields are available for the bill-to address and occupant.
BillToAllowWebAccess
BillToAreaCode
BillToAttentionLine
BillToBuildng
BillToCensusBlockID
BillToCensusTrackID
BillToCityID
BillToComplex
BillToCountryID
BillToCountyID
BillToDeliveryInstructions
BillToDirectionsToAddress
BillToDwellingStatusDate
BillToDwellingStatusID
BillToDwellingTypeID
BillToEmailAddress
BillToExtension
BillToFirmName
BillToFirstName
BillToHomePage
BillToHouseNumber
BillToHouseNumberModifier
BillToIsOnline	Digital Sales indicator (yes/no) for BillTo Address
BillToLastName
BillToMailAccessible
BillToMilitaryForeign
BillToNameAddressLine[1] to [7]
BillToOccupantTitle
BillToOccupantTypeID
BillToOtherName
BillToOtherNameUsage
BillToPhone
BillToPhoneUnlisted
BillToPORouteNumber
BillToPORouteType
BillToPORouteWalkSequence
BillToPostDirectional
BillToPreDirectional
BillToRoueAccessible
BillToShortName
BillToStateID
BillToStateName
BillToStreetName
BillToStreetSuffixID
BillToTownOf25ID
BillToUnitDesignatorID
BillToUnitNumber
BillToZipBarCode
BillToZipCode
BillToZipExtension
Building	Address building.
Carrier City ID Carrier City ID [H]	City of the delivery carrier’s address.
Carrier ID Carrier ID[H]	ID of the subscriber’s delivery carrier.
Carrier Name Carrier Name [H]	Name of the subscriber’s delivery carrier.
Carrier Zip Code Carrier Zip Code [H]	Zip code of the delivery carrier’s address.
Carrier Zip Extension Carrier Zip Extension [H]	Zip extension of the delivery carrier’s address.
Census Block ID, Census Tract ID	Address census tract and block.
City ID	Address city.
Complex	Address complex.
Copies Copies[H]	Number of copies of the paper delivered to the subscriber. Copies based on the current date or (for Copies[H]) the transaction date.
Country ID	Address country.
Country Name	Name of country in address.
County ID	Address county.
Create Date, Create Time, Create User	Date, time and user information for transaction.
CreditStatusID	Subscriber’s assigned credit status.
Date Last Renewal Sent	Date last renewal notice or invoice was sent to subscriber.
Delivery Instructions	Occupant delivery instructions.
Delivery Placement ID	Newspaper delivery placement for subscriber.
Delivery Point ID
Delivery Schedule ID	Subscriber’s delivery schedule.
DeliveryScheduleID[H]	Subscriber’s delivery schedule at the time of the transaction.
DemographicAnswer	Subscriber’s answer to a demographic question.
Directions To Address	Address delivery directions.
DistribZoneID DistribZoneID[H]	Distribution zone in which subscriber’s delivery route is located.
DistrictID DistrictID[H]	District in which subscriber’s delivery route is located.
Dwelling Status Date, Dwelling Status ID	Address dwelling status and date last updated.
Dwelling Type ID	Address dwelling type.
Email Address	Occupant’s email address.
End Grace Date End Grace Date [H]	The date on which the grace period will end for the subscriber.
Expire Date Expire Date [H]	The stop date for the subscription
Extension	Phone number extension.
File Create Date, File Create Time	Create date and time for export file.
Filler	Filler fields will be blank.
Firm Name	Firm name, if other name usage is “Firm”.
First Name	Occupant’s first name.
Gets Paper	This flag is set to yes or no depending on whether the occupant is an active subscriber (i.e. is an active subscriber who is not temp stopped).
Home Page	Occupant’s home page.
Honorific ID	Occupant’s honorific (name suffix)
House Number	Address house number.
House Number Modifier	Address house number modifier.
Insert Group ID Insert Group ID[H]	Insert group assigned to the subscriber’s route.
IsOnline	Digital Sales indicator (yes/no)
LabelGroupID LabelGroup[H]	Subscriber’s label group, if the subscription is mail delivered.
LastFullPaymentLength	Length purchased by the last subscriber payment, including grace paid.
LastFullPaymentTerm	Largest term purchased by subscriber’s last payment, taking grace days into consideration.
Last Name	Occupant’s last name.
LastPaymentAmount	Amount of the last payment.
LastPaymentLength	Length of subscriber’s last payment, not including grace paid.
LastPaymentMethod	Payment method of last payment: “Auto Renew Bank Draft”, “Auto Renew Credit Card”, “Bank Draft”, “Credit Card”, “Cash” or “Check”.
LastPaymentTaxAmount	Tax amount of last payment.
LastPaymentTerm	Largest term purchased by subscriber’s last payment.
Literal	Literal fields will be hard coded to display whatever is entered in “format”. For example if a given field should always display “D”, set it up as a literal and enter “D” in FORMAT.
Mail Accessible	Address mail accessible flag (yes/no).
Middle Initial	Occupant’s middle initial.
Military Foreign	Address military/foreign information.
Name Address Lines	These six lines can be used for the subscriber’s name and address, rather than using individual name and address elements.
Number of Renewals Sent	Number of renewal notices or invoices sent to the subscriber so far in the current subscription period.
Occupant ID	Subscriber’s occupant ID in Circulation.
Occupant Salutation ID	Occupant’s title, such as “Mr.”
Occupant Title	Occupant’s Title
Occupant Type ID	Subscriber’s occupant type.
Old Rate Code ID	Old Rate Code associated with payment rate terms for this subscription
Original Start Date	Subscriber’s original start date.
Other Name	Occupant’s other name.
Other Name Usage	Occupant’s other name usage.
Phone	Occupant’s phone number.
Phone Unlisted	Phone number unlisted setting (yes/no).
PO Route Number, PO Route Type, PO Route Walk Sequence	Address post office route number, type and walk sequence.
Post Directional	Street address post directional.
Pre Directional	Street address predirectional.
Previous Delivery Requested	Whether the subscriber requested previous delivery.
Process Date, Process Time	Process date and time for transaction.
Product ID, Publication Name	Subscriber’s publication ID and name.
Publish Date	Publishing date on which transaction was processed.
Purchase Number	Purchase number entered with transaction.
Rate Amount	Amount of the subscriber’s rate.
Rate Code ID Rate Code ID [H]	Subscriber’s rate.
Rate Length	Subscriber’s subscription length.
Rate Tax Amount	Tax amount of the subscriber’s rate.
Rate Term	Subscriber’s rate term.
Reason Code	Reason code entered for transaction.
Receive Bonus Days	Bonus day flag for subscriber (yes/no).
Record Count	Record number in file.
Record Identifier**	Field that identifies the record type, for example “D” to indicate a detail record.
RegionID RegionID[H]	Region in which subscriber’s delivery route is located.
Remarks	Remarks entered with transaction.
Renewal Delivery Override	Renewal delivery method override (yes/no).
Renewal Override Code	Override code for renewal delivery method.
Route Accessible	Address route accessible flag (yes/no).
RouteID RouteID[H]	Subscriber’s route, if subscription is route-delivered.
RouteTypeID RouteTypeID[H]	Route type of subscriber’s route.
Send Invoice, Send Renewal	Send invoice and renewal flags, entered during starts or billing changes (yes/no).
Short Name	Abbreviated company name used by banks.
Source Code	Source code entered for transaction.
State ID, State Name	Address state ID and name.
Street Name	Address street name.
Street Suffix ID	Address street suffix.
Subscriber	Flag that determines whether the occupant is a current subscriber (yes/no).
Subscription ID	Subscriber’s subscription ID.
Subsource ID	Subsource for source code entered with transaction.
Town of 25 ID	Address Town of 25.
Tran Date	Transaction date for subscriber transaction.
Tran Type ID	Transaction type (start, billing change, etc.).
Unit Designator ID, Unit Number	Unit type and number.
ZIP Bar Code, ZIP Code, ZIP Extension	Zip code, Zip code + 4, and Zip bar code.

* Field is required.

** Field is required if a record identifier is entered on the record type setup screen.

[H] indicates the historical value at the time of the transaction.