CountyOfService

Data Type: Character Maximum Length: 1024
Flag Enumerations (LookupMulti): LA, OR, OS, OT, RI, SB, SD, VE, IM, KR, SL, SA, FC, ALA, ALP, AMA, BUT, CAL, COL, CC, DN, ED, FRE, GLE, HUM, INY, KIN, LAK, LAS, MAD, MRN, MPA, MEN, MER, MOD, MNO, MON, NAP, NEV, PLA, PLU, SAC, SBT, SF, SJ, SM, SCL, SCR, SHA, SIE, SIS, SOL, SON, STA, SUT, TEH, TRI, TUL, TUO, YOL, YUB
Go To Lookup

DeletedBy

Data Type: Character Maximum Length: 8

DeletedYN

Data Type: Boolean Maximum Length: 1

InactivatedTimestamp

Data Type: DateTime Maximum Length: 27

InactiveMemberHandling

Data Type: Character Maximum Length: 50
Sequential Enumerations (Lookup): BIONMB, COMPH, LMTB, MIACT, NNFL
Go To Lookup

LastLoginTimestamp

Data Type: DateTime Maximum Length: 27

MemberAddress1

Data Type: Character Maximum Length: 50

MemberAddress2

Data Type: Character Maximum Length: 50

MemberAOR

Data Type: Character Maximum Length: 50
Sequential Enumerations (Lookup): AR, CV, IG, EV, GD, IN, IV, MB, PV, PF, SB, SW, TR, WS, ZZ, EL, EY, XX, AV, BH, BB, CD, CLAW, CJ, CRIS, DAMLS, DW, HM, ITEC, LG, MU, NP, OC, OA, PW, PS, PD, RS, SAND, SI, SOCAL, SR, SU, VC, AM, DN, LC, MD, MP, MC, OR, PA, PL, SC, TC, YG, AL, AT, BF, BW, BE, BK, BI, CL, CE, CM, CA, CO, DL, DC, ES, ED, FR, GA, HH, HU, ID, IC, KR, KC, LN, LI, LV, ML, MN, MO, NV, NB, ND, NC, NS, OK, OJ, OB, PT, PR, PI, PC, RI, RW, SO, SE, SD, SG, SF, SP, SM, SA, SL, SZ, SJ, SV, SH, SQ, SS, ST, SK, SY, TA, TI, TY, TU, TE, VCRDS, VV, WT, WC, YC, MLSL, JT, PJ, SN
Go To Lookup

MemberAORkeyNumeric

Data Type: Int Maximum Length: 255

MemberAORPhone

Data Type: Character Maximum Length: 16

MemberAORPhoneExt

Data Type: Character Maximum Length: 10

MemberApplicationGrant

Data Type: Character Maximum Length: 1024
Flag Enumerations (LookupMulti): BRLM, CLLM, MXLM, PNLM
Go To Lookup

MemberAssociationComments

Data Type: Character Maximum Length: 500

MemberCity

Data Type: Character Maximum Length: 50

MemberContactOrder1

Data Type: Character Maximum Length: 60
Sequential Enumerations (Lookup): _12, _11, _18, _13, _14, _15, _17, _16, _2, _1, _8, _3, _4, _5, _7, _6, _10, _9, _19, _20, _21, _22, _23
Go To Lookup

MemberContactOrder2

Data Type: Character Maximum Length: 60
Sequential Enumerations (Lookup): _12, _11, _18, _13, _14, _15, _17, _16, _2, _1, _8, _3, _4, _5, _7, _6, _10, _9, _19, _20, _21, _22, _23
Go To Lookup

MemberContactOrder3

Data Type: Character Maximum Length: 60
Sequential Enumerations (Lookup): _12, _11, _18, _13, _14, _15, _17, _16, _2, _1, _8, _3, _4, _5, _7, _6, _10, _9, _19, _20, _21, _22, _23
Go To Lookup

MemberContactOrder4

Data Type: Character Maximum Length: 60
Sequential Enumerations (Lookup): _12, _11, _18, _13, _14, _15, _17, _16, _2, _1, _8, _3, _4, _5, _7, _6, _10, _9, _19, _20, _21, _22, _23
Go To Lookup

MemberContactOrder5

Data Type: Character Maximum Length: 60
Sequential Enumerations (Lookup): _12, _11, _18, _13, _14, _15, _17, _16, _2, _1, _8, _3, _4, _5, _7, _6, _10, _9, _19, _20, _21, _22, _23
Go To Lookup

MemberContactOrder6

Data Type: Character Maximum Length: 60
Sequential Enumerations (Lookup): _12, _11, _18, _13, _14, _15, _17, _16, _2, _1, _8, _3, _4, _5, _7, _6, _10, _9, _19, _20, _21, _22, _23
Go To Lookup

MemberCountry

Data Type: Character Maximum Length: 2
Sequential Enumerations (Lookup): US, CA, MX, AF, AL, DZ, AS, AD, AO, AI, AQ, AG, AR, AM, AW, AU, AT, AZ, BS, BH, BD, BB, BY, BE, BZ, BJ, BM, BT, BO, BA, BW, BV, BR, IO, BN, BG, BF, BI, CI, KH, CM, CV, KY, CF, TD, CL, CN, CX, CC, CO, KM, CG, CD, CK, CR, HR, CU, CY, CZ, DK, DJ, DM, DO, EC, EG, SV, GQ, ER, EE, ET, FK, FO, FJ, FI, FR, GF, PF, TF, GA, GM, GE, DE, GH, GI, GR, GL, GD, GP, GU, GT, GG, GN, GW, GY, HT, HM, VA, HN, HK, HU, IS, IN, ID, IR, IQ, IE, IM, IL, IT, JM, JP, JE, JO, KZ, KE, KI, KP, KR, KW, KG, LA, AX, LV, LB, LS, LR, LY, LI, LT, LU, MO, MK, MG, MW, MY, MV, ML, MT, MH, MQ, MR, MU, YT, FM, MD, MC, MN, ME, MS, MA, MZ, MM, NA, NR, NP, NL, AN, NC, NZ, NI, NE, NG, NU, NF, MP, NO, OM, PK, PW, PS, PA, PG, PY, PE, PH, PN, PL, PT, PR, QA, RE, RO, RU, RW, BL, SH, KN, LC, MF, PM, VC, WS, SM, ST, SA, SN, RS, SC, SL, SG, SK, SI, SB, SO, ZA, GS, ES, LK, SD, SR, SJ, SZ, SE, CH, SY, TW, TJ, TZ, TH, TL, TG, TK, TO, TT, TN, TR, TM, TC, TV, UG, UA, AE, GB, UM, UY, UZ, VU, VE, VN, VG, VI, WF, EH, YE, ZM, ZW
Go To Lookup

MemberDashboardTile

Data Type: Character Maximum Length: 1024
Flag Enumerations (LookupMulti): ZILL, PRGN, SCIP, SSS, SSSL, SBC, SBCL, AORL, MTRX
Go To Lookup

MemberDesignation

Data Type: Character Maximum Length: 50
Flag Enumerations (LookupMulti): ABR, ALC, CCIM, CIPS, CPM, CRB, CRS, CRE, GAA, GREEN, GRI, PMN, RCE, RAA, SRS, SIOR, SRES, AHWD, CRETS, EPRO, MRP, PSA, RENE, RSPS, SFR, TRC, CDPE
Go To Lookup

MemberDirectPhone

Data Type: Character Maximum Length: 16

MemberDirectPhoneExt

Data Type: Character Maximum Length: 10

MemberEmail

Data Type: Character Maximum Length: 80

MemberFax

Data Type: Character Maximum Length: 16

MemberFirstName

Data Type: Character Maximum Length: 50

MemberHomePhone

Data Type: Character Maximum Length: 16

MemberHomePhoneExt

Data Type: Character Maximum Length: 10

MemberIsAssistantTo

Data Type: Character Maximum Length: 50

MemberKeyNumeric

Data Type: Int Maximum Length: 255

MemberLanguages

Data Type: Character Maximum Length: 1024
Flag Enumerations (LookupMulti):
Go To Lookup

MemberLastName

Data Type: Character Maximum Length: 50

MemberLoginId

Data Type: Character Maximum Length: 25

MemberMiddleName

Data Type: Character Maximum Length: 50

MemberMlsAccessYN

Data Type: Boolean Maximum Length: 1

MemberMlsSecurityClass

Data Type: Character Maximum Length: 25
Sequential Enumerations (Lookup): ON, AP, OM, PH, BANGP, DN, OA, OG, TP, AD, DR, OD, AN, BANGM, DB, PA, AG, BANGG, AM, HA, HB, BANGQ, BANGN, BANGL, AS, BANGK, DO, SC, PB, AF, IMS, CA, CB, HM, TM, TN
Go To Lookup

MemberMobilePhone

Data Type: Character Maximum Length: 16

MemberMoveType

Data Type: Character Maximum Length: 24
Sequential Enumerations (Lookup): K, M
Go To Lookup

MemberNamePrefix

Data Type: Character Maximum Length: 10

MemberNationalAssociationId

Data Type: Character Maximum Length: 25

MemberOtherPhoneSMSNumber

Data Type: Character Maximum Length: 16

MemberPager

Data Type: Character Maximum Length: 16

MemberPassword

Data Type: Character Maximum Length: 25

MemberPostalCode

Data Type: Character Maximum Length: 10

MemberPostalCodePlus4

Data Type: Character Maximum Length: 4

MemberStateLicense

Data Type: Character Maximum Length: 50

MemberStateOrProvince

Data Type: Character Maximum Length: 2
Sequential Enumerations (Lookup): AK, AL, AR, AZ, CA, CO, CT, DC, DE, FL, GA, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, OS, PA, RI, SC, SD, TN, TX, UT, VA, VI, VT, WA, WI, WV, WY, BC, MB, NB, NF, NS, NT, NU, ON, PE, QC, SK, YT, AB
Go To Lookup

MemberStatus

Data Type: Character Maximum Length: 25
Sequential Enumerations (Lookup): A, I, D
Go To Lookup

MemberTollFreePhone

Data Type: Character Maximum Length: 16

MemberTollFreePhoneExt

Data Type: Character Maximum Length: 10

MemberTransferOptions

Data Type: Character Maximum Length: 29
Sequential Enumerations (Lookup): MOH, MOMLO, MLB
Go To Lookup

MemberType

Data Type: Character Maximum Length: 50
Sequential Enumerations (Lookup): R, DR, NMB, S, APR, CLA, OM, AORS, DRA, MLOA, MLSS, NONM
Go To Lookup

MemberVoiceMail

Data Type: Character Maximum Length: 16

MemberVoiceMailExt

Data Type: Character Maximum Length: 10

ModificationTimestamp

Data Type: DateTime Maximum Length: 27

MultipleLogonsYN

Data Type: Boolean Maximum Length: 1

OffersEmail

Data Type: Character Maximum Length: 80

OfficeAOR

Data Type: Character Maximum Length: 60
Sequential Enumerations (Lookup): AR, CV, IG, EV, GD, IN, IV, MB, PV, PF, SB, SW, TR, WS, ZZ, EL, EY, XX, AV, BH, BB, CD, CLAW, CJ, CRIS, DAMLS, DW, HM, ITEC, LG, MU, NP, OC, OA, PW, PS, PD, RS, SAND, SI, SOCAL, SR, SU, VC, AM, DN, LC, MD, MP, MC, OR, PA, PL, SC, TC, YG, AL, AT, BF, BW, BE, BK, BI, CL, CE, CM, CA, CO, DL, DC, ES, ED, FR, GA, HH, HU, ID, IC, KR, KC, LN, LI, LV, ML, MN, MO, NV, NB, ND, NC, NS, OK, OJ, OB, PT, PR, PI, PC, RI, RW, SO, SE, SD, SG, SF, SP, SM, SA, SL, SZ, SJ, SV, SH, SQ, SS, ST, SK, SY, TA, TI, TY, TU, TE, VCRDS, VV, WT, WC, YC, MLSL, JT, PJ, SN
Go To Lookup

OfficeBrokerKeyNumeric

Data Type: Int Maximum Length: 255

OfficeCorporateLicense

Data Type: Character Maximum Length: 50

OfficeFax

Data Type: Character Maximum Length: 16

OfficeKeyNumeric

Data Type: Int Maximum Length: 255

OfficeMlsId

Data Type: Character Maximum Length: 25

OriginalEntryTimestamp

Data Type: DateTime Maximum Length: 27

OriginatingSystemID

Data Type: Character Maximum Length: 25

OriginatingSystemMemberKey

Data Type: Character Maximum Length: 255

OriginatingSystemModificationTimestamp

Data Type: DateTime Maximum Length: 27

PhotosChangeTimestamp

Data Type: DateTime Maximum Length: 27

PhotosCount

Data Type: Int Maximum Length: 2

RatePlugAccessYN

Data Type: Boolean Maximum Length: 1

SecurityFeePaidYN

Data Type: Boolean Maximum Length: 1

Signature

Data Type: Character Maximum Length: 200

SocialMediaWebsiteUrlOrId

Data Type: Character Maximum Length: 8000

SourceSystemID

Data Type: Character Maximum Length: 25

SourceSystemMemberKey

Data Type: Character Maximum Length: 255

SourceSystemModificationTimestamp

Data Type: DateTime Maximum Length: 27

SyndicateAgentOption

Data Type: Character Maximum Length: 27
Sequential Enumerations (Lookup): AASA, RTAS, NOAC
Go To Lookup

SyndicateTo

Data Type: Character Maximum Length: 1024
Flag Enumerations (LookupMulti): ZILL, RCOM, HCOM, TRUL
Go To Lookup

SystemTransferStatus

Data Type: Character Maximum Length: 1024
Sequential Enumerations (Lookup): EGRE, EGIP, EGCO, EGER, INRE, INIP, INCO, INER, TRRE, SOCC
Go To Lookup

TeamLeadMlsId

Data Type: Character Maximum Length: 25