BLOX Digital Subscription Data Glossary Dictionary

	A	B	C	D
1	Subscription Export Data Glossary			Updated Dec. 15, 2023
2	For data export jobs from BLOX Subscription
3	Field Name	Description of Field	Sample Data	Notes

4	id	Internal id for user - not same as UUID for user	2169734
5	external_id	External ID used for migrations. Usually an account number
6	user_lastname	Last name	Userlast
7	user_firstname	First name	Userfirst
8	user_screenname	Username on site	myusername	Username of the user. Is unique per site.
9	user_email	Email address	me@gmai.com
10	user_address	User provided street	123 W. Main St.
11	user_municipality	City	Atlanta
12	user_region	State	GA
13	user_phone	Phone
14	user_postcode	Zip code or postal code	30309
15	user_authTime	The last time a user logged in to a site
16	user_deleteTime	The time a user was deleted
17	service_name	Name of the subscription service	Digital All Access
18	service_type	The "driver" for the subscription.	subscription	"Subscription" is a BLOX-system subscription. Others: free, visiondata, mediaspan, lee-falcon, dti, etc.
19	service_disabled	If the service was manually disabled
20	service_testmode	If the service is in test mode	0	Transactions in Test mode can be deleted. Live transactions cannot.
21	service_deleteTime	If the service has an overall termination date
22	service_comment1	Extra data passed to the purchase platform for tracking purposes	albanyherald.com
23	service_comment2	Extra data passed to the purchase platform for tracking purposes	Online Subscription
24	name	Purchaser name	Jason Braverman
25	postal_address	Purchaser address (ie delivery)	123 W Main St	May be different than user address
26	postal_city	Purchaser city (ie delivery)	Atlanta
27	postal_state	Purhcaser state (ie delivery)	GA
28	postal_postcode	Purchaser zip (ie delivery)	30309
29	account_last_4	Last 4 digits of credit card number	1234
30	trial	If this service has a trial period turned on
31	price	Price of service term, per term length, such as $9.99 per month	9.99	Same value as Rate
32	duration	Term length of service in days	30
33	disabled	If the service is disabled	0
34	startTime	Start time of term	2017-04-27 15:48:16	Not the original start date of the subscrpition
35	expireTime	End time of term (when subscription expires)	2017-05-27 15:48:16
36	transactionTime	When transaction was initiated. Last payment date	2017-04-27 15:48:16
37	notes	Notes on the subscription service itself	This is Jason's test for 99 cent 30 day trial.
38	paymentHandler	The payment handler that the purchase ran through	PayPal
39	transactionID	Transaction id	spreedly\|K49nB2YoXmCFaajFmhJu9tf1do\|AQ0EE6F116ED
40	refundTransactionID	If there was a refund, this field will be populated	AF0A5C9D3DC7	Refunds are the full amount of the price/rate
41	testmode	Replicates service_testmode	0
42	recurring	A flag that denotes whether the subscription renews or not (true/false)	1
43	service_id	BLOX Subscription service id	1991
44	user_uuid	BLOX internal user id. Universal unique ID of the user.	2aa9301a-2b82-11e7-9648-5cb9017b3617	Cannot be duplicated.
45	name_id
46	pending_id
47	promo_code	Optional field assigned to a Rate	CYBER2018
48	promo_code_type	Regular promo code or one-time code assigned to one user
49
50
51	description	Description on the Service. May be customer facing	Local journalism that strengthens the Hamilton and surrounding area’s communities
52	country	Country user enters during purchase	United States of America
53	currency	Currency in which user paid for their subscription	USD
54	cancel_date	When the subscription was canceled	2023-03-15 8:36:00	Either by request, or due to payment failure
55	cancel_reason_code	Reason the subscriber canceled	misunderstood	Assigned by the CSR or the system
56	cancel_notes	Optional notes field where a CSR can add additional information	User did not know the subscription auto-renewed
57	end_time	When grace period concludes and subscription expires/cancels	2017-05-27 15:48:16	If the service does not have a grace period set, this will be the same value as expire_time
58	rate_id	ID of the rate	73cfa9de-cda9-11ed-831a-000c29a8e11a
59	paymentmethod	How the subscription was purchased	card
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100