<File Name> Data Detail

File Name Samsung accoung_[GKID]_[yyyymmdd].xlsx

File Description Brief description of file/data purpose

List all field names and description that is in the above file.

Field Category Field Name Field Description

Account Basic Information TCSO_PRTY When you join a member
Table
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
USR_NM User name
USR_TP_CD User type code
1 : Individual
7 : Minor
USR_STS_CD User status code
1 : active
4 : blocked
5 : blacklist
8 : long-term unused
9 : withdrawal
USR_DISP_NM User display name (nickname)
USR_LCAL_TZ_CD User's timezone code
LANG_CD User's preferenced language code
(ISO language code)
CNTY_CD Country code
JN_DT Joining data/time
GNDR_TP_CD Gender type
F:Female, M:Male
BRTH_DD Birthday
OCUP_NM Occupation name
CMPNY_NM Company name
FAM_NM Family name
GVN_NM Given name
ADDTNL_NM Additional name
 PRFX_NM Prefix name
SFX_NM Suffix name
TTL_TXT Job title
EMAIL_RCV_YN_FG Email reception agreement flag
SMS_RCV_YN_FG SMS reception agreement flag
RCV_EMAIL_TXT Email address for email reception
RCV_SMS_PHON_NUM_TXT Mobile phone number for SMS
reception
RCV_SMS_PHON_CNTY_CD Mobile country code for SMS
reception
CRT_RGN_CD First created region code
MDFY_RGN_CD Last modified region code
JN_CHNL_CD Join channel code
M : Mobile
W : Web
PRVC_ACPT_YN_FG Privacy acceptance agreement flag
PRVC_ACPT_DT Privacy acceptance date/time
EMAIL_VLD_CHK Email validation check flag
JN_CHNL_DTL_CD Join channel detail code
'PW' : PC Web
'MW' : Mobile Web
'HW' : Hybrid Web
'PD' : Phone Device
'TV' : Television
'SW' : Setup Wizard
'PA' : PC Application
DATA_CLTN_ANL_ACPT_YN_FG Data combination agreement flag
ADVT_ACPT_YN_FG Advertisement acceptance
agreement flag
OWD_TRSF_ACPT_YN_FG Onward transfer Acceptance
agreement flag
CUSTZ_SVC_CLTN_USG_ACPT_YN_F Customized service usage
G acceptance agreement flag
Account login ID TCSO_PRTY_IDNTN When you join a member
Management Table
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
LGN_ID Login ID
SF_LGN_ID Login ID
USR_PWD_CHNG_DT User Password Change Date/time
CNTY_CLNG_CD Country Calling Code
TPHON_NUM_TXT Telephone Number Text
Account Device TCSO_PRTY_DVCE When you login on the terminal
Registration Table device
DVCE_SEQ Sequence number
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
DVCE_TP_CD Device type code
1 : Phone Device
2 : Camera
3 : TV
4 : PC
5 : AIRCONDITIONER
6 : WEARABLE
7 : IOTDEVICE
8 : FAMILYHUB
9 : OVEN
10 : ROBOTCLEANER
DVCE_MODEL_ID Device model ID
DVCE_UNQ_ID Device unique ID
DVCE_PHSL_ADDR_TXT Device physical address text
DVCE_STS_CD Device status code
1 : active
DVCE_REG_DT Device registration date/time
PHON_NUM_TXT Phone number text
DVCE_NM Device name
DVCE_MCC_TXT Device mobile country code
DVCE_MNC_TXT Device mobile network code
DVCE_CUST_CD_TXT Device customer code
PHON_NUM_CNTY_CD Country code
PHON_NUM_SMS_AUTH_FG Phone number SMS
authentification flag
SW_VER_TXT Software version text
DVCE_TMCC_TXT Mobile telephone country code
DVCE_MLT_USR_ID Device multi user ID
0: normal mode
Non-zero : multi mode such as
Secure folder
DVCE_SUB_TP_CD Device sub type code of TV device
TV, BD, SEK, MFM, STB
DVCE_SRL_NUM_TXT Device serial number text
DVCE_NTWK_ADDR_TXT Device network address text
DVCE_CLNT_OS_VER OS version
DVCE_CLNT_VER Client version
Account Contact Address TCSO_PRTY_CNTCT_ADDR When you register the member’s
Table address information
ADDR_TP_SEQ Sequence number
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
ADDR_TP_DTL_TXT Contact address type detail
CNTY_NM Country name
POST_OFCE_BX_NUM_TXT Post office box number
XTND_ADDR Extended address
ST_TXT Street address
LCLT_TXT Locality
RGN_TXT Region area that larger than locality
e.g: province
POST_CD_TXT Postal code
ITNTNL_YN_FG Domestic or international flag for
address type detail
PREF_ADDR_TP_YN_FG Preferenced address type flag
Y or N
Account Contact Method TCSO_PRTY_CNTCT_MTHD When you register the member’s
Table contact information
CNTCT_MTHD_TP_TXT Specify given data type
1. EMAIL, 2: TEL, 3:URL
May
store(“EMAIL”/”TEL/”URL”
)
CNTCT_MTHD_TP_SEQ Specify sequence number of
contact method value refer to
method type and detail
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
CNTCT_MTHD_VAL_TXT Specify contact method value refer
to method type and detail ex) TEL,
WORK, VOICE : 070-7015-6918
PREF_CNTCT_MTHD_YN_FG Specific contact method type
preferred by user
Account Workshop TCSO_PRTY_WK_HIST When you register the member’s
Information Table company information
WRK_HIST_SEQ Sequence number
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
CMPNY_NM Company name
CMPNY_UNT_TXT Company department name
 JB_TTL Job Title
Account Terms and TCSO_TNC_ACPTNC If you agree to the terms and
Conditions Acceptance conditions when joining, logging
Table and using Samsung service
MBL_CNTY_CD Mobile country code
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
TNC_VER_TXT Terms and Conditions version
TNC_ACPT_FG Terms and Conditions acceptance
flag
TNC_ACPT_DT Terms and Conditions acceptance
date/time
TNC_ACPT_LANG_CD Terms and Conditions acceptance
language code
Account Profile TCSO_PRTY_PREF_PRF When you register the member’s
Preference Information preference information
Table
PREF_PRF_TP_TXT Preference profile type
INTEREST : Hobby / Interest
PRODUCT : Favorite Product
PRE-VENDOR : Previous device
brand
PREF_PRF_SEQ Sequence number
PREF_PRF_VAL_TXT Preference profile value
"1" : Education
"2" : Computer
"3" : Game
"4" : Entertainment
"5" : Art
"6" : Life information
"7" : Health
"8" : Society/Politics
"9" : Economy
"A" : Travel
"B" : Sports/Leisure
"C" : Shopping
"D" : Fashion
"E" : Famly/Parenting
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Place Information TCSO_PRTY_PLC_INFO When you register the member’s
Table
GPS based location information
NM Place name
 CTGY Place category
Home : 1, Work : 2, Car : 3, Others : 4,
School : 5, Unknown : -1
TP Place type
USER_DEFINED : 1, APP_PROVIDED :
2, SYSTEM_PREDICTED 3
ADDR Place address
LATD Place latitude
LOTD Place longitude
WIFI_NM WIFI Name
WIFI_BID WIFI BSSID
BLTH_NM Bluetooth Name
BLTH_MAC_ADDR Bluetooth Mac Address
TSP_UTM Coordinated Universal Time
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Profile Name TCSO_PRTY_PRF_NM When you register the name on the
Table member’s profile
PRFX_NM Prefix Name
GVN_NM Given Name
MIDL_NM Middle Name
FAM_NM Family Name
SFX_NM Name Suffix
MDFY_TSP Last modified timestamp
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Profile Status TCSO_PRTY_PRF_STS_MSG When you register the status
Message Table message on the member’s profile
STS_MSG_TXT Status Message
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Profile Note Table TCSO_PRTY_PRF_NOTE When you register the note on the
member’s profile
NOTE_TXT Note Text
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Profile TCSO_PRTY_PRF_MSGR_ACCNT When you register the messenger
Messenger Account Table account on the member’s profile
MSGR_ACCNT_TXT Messenger Account Text
MSGR_ACCNT_TP Messenger Account Type
MSGR_ACCNT_LBL Messenger Account Label
 CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Profile TCSO_PRTY_PRF_PNUM When you register the phone
PhoneNumber Table number on the member’s
PNUM_TXT PhoneNumber Text
PNUM_TP PhoneNumber Type
PNUM_LBL PhoneNumber Label
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Profile Email TCSO_PRTY_PRF_EMAIL When you register the email
Address Table address on the member’s profile
EMAIL_TXT Email Address Text
EMAIL_TP Email Address Type
EMAIL_LBL Email Address Label
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Profile Web TCSO_PRTY_PRF_WEB_ADDR When you register the web address
Address Table on the member’s profile
WEB_ADDR_TXT Web Address Text
WEB_ADDR_TP Web Address Type
WEB_ADDR_LBL Web Address Label
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Profile Event TCSO_PRTY_PRF_EVNT When you register the event
Table schedule on the member’s profile
EVNT_TXT Event Text
EVNT_TP Event Type
EVNT_LBL Event Label
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
Account Profile Birthday TCSO_PRTY_PRF_BRTH_DD When you register the birthday on
Table the member’s profile
BRTH_DD_TXT Birth Date Text
CRT_APSVC_ID First creator service name
MDFY_APSVC_ID Last modifier service name
BRTH_DD_TP_CD Birth Date Type
“0” : Solar
“1” : Lunar
“2” : Leap month
3rd Party Disclaimer TCSO_3RD_PRTY_DSCMR_ACPTNC When you agree to 3rd party
Acceptance disclaimer
 APSVC_ID Application Service ID
DSCMR_VER_TXT Disclaimer Version Text
CRT_APSVC_ID Create Application Service ID
MDFY_APSVC_ID Last modifier service name
Account Linking TCSO_ACCNT_LKNG_INFOR When you link to a 3rd party account
Information Table
APSVC_3RD_PRTY_APSVC_ID 3rd Party Application ID
CRT_APSVC_ID Create Application Service ID
MDFY_APSVD_ID Last modifier service name