BO_BASIC_TMP2 (SQL Table)	Index Back
Basic CDM Data for Individuals Basic CDM Data for Individuals - used by BO_BAS_LOAD AE

BO_BASIC_TMP2

(SQL Table)

Basic CDM Data for Individuals

Basic CDM Data for Individuals - used by BO_BAS_LOAD AE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
Prompt Table: BO_ROLE_TYPE_V1

3 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object

4 BAS_SYSID Number(18,0) DECIMAL(18) NOT NULL Basic Data System ID

5 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

6 EXTERNAL_LIST_ID Character(20) VARCHAR2(20) NOT NULL External List Id

7 SOURCE_SYSID Number(18,0) DECIMAL(18) NOT NULL Source System ID

8 COMPANY_SYSID Number(18,0) DECIMAL(18) NOT NULL Company_SYS_ID

9 BO_ID_COMPANY Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

10 ROLE_TYPE_ID_ORG Number(12,0) DECIMAL(12) NOT NULL Organization Role Type ID

11 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

12 DATASET_SYSID Number(18,0) DECIMAL(18) NOT NULL Data Set ID
Default Value: 1

13 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #

14 TITLE Character(35) VARCHAR2(35) NOT NULL Title

15 FUNCTIONAL_TITLE Character(40) VARCHAR2(40) NOT NULL Functional Title

16 DEPARTMENT Character(40) VARCHAR2(40) NOT NULL Department

17 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

18 BIRTHDATE Date(10) DATE Birthdate of the person.

19 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown

20 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL The person's preferred method of communication.
C=Call
E=Email Only
F=Fax
I=XML only
M=Standard Mail
P=Email & Print
R=XML & Print
S=SMS

21 SALUTATION_CD Character(6) VARCHAR2(6) NOT NULL Salutation Code.

22 NCOA_LAST_OVERLAY Date(10) DATE NCOA Last Overlay Date

23 ORIGIN Character(40) VARCHAR2(40) NOT NULL Origin

24 DO_NOT_EMAIL Character(1) VARCHAR2(1) NOT NULL Do Not Email
N=No
Y=Yes

25 DO_NOT_MAIL Character(1) VARCHAR2(1) NOT NULL Do Not Mail
N=No
Y=Yes

26 DO_NOT_CONTACT Character(1) VARCHAR2(1) NOT NULL DO_NOT_CONTACT is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994.
N=Contact Permitted
Y=Do not contact

27 DO_NOT_SMS Character(1) VARCHAR2(1) NOT NULL DO_NOT_SMS is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994.
N=SMS Permitted
Y=Do not SMS

28 NAME_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Name UID

29 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL This is the country name format field.
Prompt Table: COUNTRY_TBL

30 NAME Character(50) VARCHAR2(50) NOT NULL Name

31 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials

32 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

33 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

34 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix

35 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix

36 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title

37 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

38 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

39 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

40 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

41 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name

42 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name

43 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name

44 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)

45 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name

46 PROFILE_CM_SEQ_ADD Number(31,0) DECIMAL(31) NOT NULL This field is used to store the profile contact method sequence number for an address.

47 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

48 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

49 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

50 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

51 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

52 CITY Character(30) VARCHAR2(30) NOT NULL City

53 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

54 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2

55 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference

56 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

57 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

58 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

59 COUNTY Character(30) VARCHAR2(30) NOT NULL County

60 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

61 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

62 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

63 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit
Default Value: Y

64 CROSS_STREET_1 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location

65 CROSS_STREET_2 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location

66 ADDRESS_SUB_TYPE Character(4) VARCHAR2(4) NOT NULL Address Sub Type Field
ADDR=Address
INT=Intersection
Default Value: ADDR

67 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS1_AC

68 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS3_AC

69 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS2_AC

70 ADDRESS4_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 4.

71 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC

72 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
Prompt Table: RD_REGION_VW

73 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Prompt Table: PSTIMEZONE

74 CM_ID_PHONE Number(31,0) DECIMAL(31) NOT NULL CM_ID_PHONE
Prompt Table: CM_PHONE

75 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

76 PROFILE_CM_SEQ_PH1 Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for a primary phone number.

77 COUNTRY_CD1 Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.

78 PHONE1 Character(24) VARCHAR2(24) NOT NULL Primary Phone

79 EXTENSION1 Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.

80 PROFILE_CM_SEQ_PH2 Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for an alternate phone number.

81 COUNTRY_CD2 Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.

82 PHONE2 Character(24) VARCHAR2(24) NOT NULL Telephone

83 EXTENSION2 Character(6) VARCHAR2(6) NOT NULL Phone Extension

84 PROFILE_CM_SEQ_PC1 Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for a primary phone number.

85 COUNTRY_CELL_CD1 Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.

86 PHONE_CELL1 Character(24) VARCHAR2(24) NOT NULL Pager

87 EXTENSION_CELL1 Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.

88 PROFILE_CM_SEQ_FAX Number(31,0) DECIMAL(31) NOT NULL CM Profile Detail ID................................................

89 COUNTRY_CD3 Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.

90 FAX Character(24) VARCHAR2(24) NOT NULL This is the fax number field.

91 EXTENSION3 Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.

92 PROFILE_CM_SEQ_EM1 Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for a primary email address.

93 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.

94 EMAIL_DOMAIN Character(50) VARCHAR2(50) NOT NULL Email Domain

95 HTML_FLAG1 Character(1) VARCHAR2(1) NOT NULL Field to determine if an Email Address can receive HTML Based Email.
N=No
Y=Yes

96 PROFILE_CM_SEQ_EM2 Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for an alternate email address.

97 EMAIL_ADDR_ALT Character(70) VARCHAR2(70) NOT NULL alternate email address

98 EMAIL_DOMAIN_ALT Character(50) VARCHAR2(50) NOT NULL Email Domain

99 HTML_FLAG2 Character(1) VARCHAR2(1) NOT NULL Field to determine if an Email Address can receive HTML Based Email.
N=No
Y=Yes

100 PROFILE_CM_SEQ_EM3 Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for an alternate email address.

101 EMAIL_ADDR_ALT_2 Character(70) VARCHAR2(70) NOT NULL This field contains the second alternative email address in Basic Data Table.

102 EMAIL_DOMAIN_ALT_2 Character(50) VARCHAR2(50) NOT NULL This field contains the second alternative email domain address in Basic Data Table.

103 HTML_FLAG3 Character(1) VARCHAR2(1) NOT NULL Field to determine if an Email Address can receive HTML Based Email.
N=No
Y=Yes

104 PROFILE_CM_SEQ_EM4 Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for an alternate email address.

105 EMAIL_ADDR_ALT_3 Character(70) VARCHAR2(70) NOT NULL This field contains the thrid alternative email address in Basic Data Table.

106 EMAIL_DOMAIN_ALT_3 Character(50) VARCHAR2(50) NOT NULL This field contains the thrid alternative email domain address in Basic Data Table.

107 HTML_FLAG4 Character(1) VARCHAR2(1) NOT NULL Field to determine if an Email Address can receive HTML Based Email.
N=No
Y=Yes

108 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

109 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

110 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

111 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

112 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

113 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID Prompt Table: BO_ROLE_TYPE_V1
3	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object
4	BAS_SYSID	Number(18,0)	DECIMAL(18) NOT NULL	Basic Data System ID
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
6	EXTERNAL_LIST_ID	Character(20)	VARCHAR2(20) NOT NULL	External List Id
7	SOURCE_SYSID	Number(18,0)	DECIMAL(18) NOT NULL	Source System ID
8	COMPANY_SYSID	Number(18,0)	DECIMAL(18) NOT NULL	Company_SYS_ID
9	BO_ID_COMPANY	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
10	ROLE_TYPE_ID_ORG	Number(12,0)	DECIMAL(12) NOT NULL	Organization Role Type ID
11	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID
12	DATASET_SYSID	Number(18,0)	DECIMAL(18) NOT NULL	Data Set ID Default Value: 1
13	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
14	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
15	FUNCTIONAL_TITLE	Character(40)	VARCHAR2(40) NOT NULL	Functional Title
16	DEPARTMENT	Character(40)	VARCHAR2(40) NOT NULL	Department
17	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
18	BIRTHDATE	Date(10)	DATE	Birthdate of the person.
19	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender of the person. F=Female M=Male U=Unknown
20	COMM_METHOD	Character(1)	VARCHAR2(1) NOT NULL	The person's preferred method of communication. C=Call E=Email Only F=Fax I=XML only M=Standard Mail P=Email & Print R=XML & Print S=SMS
21	SALUTATION_CD	Character(6)	VARCHAR2(6) NOT NULL	Salutation Code.
22	NCOA_LAST_OVERLAY	Date(10)	DATE	NCOA Last Overlay Date
23	ORIGIN	Character(40)	VARCHAR2(40) NOT NULL	Origin
24	DO_NOT_EMAIL	Character(1)	VARCHAR2(1) NOT NULL	Do Not Email N=No Y=Yes
25	DO_NOT_MAIL	Character(1)	VARCHAR2(1) NOT NULL	Do Not Mail N=No Y=Yes
26	DO_NOT_CONTACT	Character(1)	VARCHAR2(1) NOT NULL	DO_NOT_CONTACT is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994. N=Contact Permitted Y=Do not contact
27	DO_NOT_SMS	Character(1)	VARCHAR2(1) NOT NULL	DO_NOT_SMS is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994. N=SMS Permitted Y=Do not SMS
28	NAME_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Name UID
29	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	This is the country name format field. Prompt Table: COUNTRY_TBL
30	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
31	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
32	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
33	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
34	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
35	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Suffix
36	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title
37	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
38	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
39	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
40	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
41	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Middle Name
42	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
43	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Name
44	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)
45	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	PREF_FIRST_NAME field is used to identify the employees preferred first name
46	PROFILE_CM_SEQ_ADD	Number(31,0)	DECIMAL(31) NOT NULL	This field is used to store the profile contact method sequence number for an address.
47	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
48	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
49	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
50	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
51	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
52	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
53	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
54	NUM2	Character(4)	VARCHAR2(4) NOT NULL	Number 2
55	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
56	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
57	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
58	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
59	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
60	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
61	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
62	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
63	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit Default Value: Y
64	CROSS_STREET_1	Character(50)	VARCHAR2(50) NOT NULL	Cross Street of a location
65	CROSS_STREET_2	Character(50)	VARCHAR2(50) NOT NULL	Cross Street of a location
66	ADDRESS_SUB_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Sub Type Field ADDR=Address INT=Intersection Default Value: ADDR
67	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS1_AC
68	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS3_AC
69	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS2_AC
70	ADDRESS4_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 4.
71	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	CITY_AC
72	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RD_REGION_VW
73	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
74	CM_ID_PHONE	Number(31,0)	DECIMAL(31) NOT NULL	CM_ID_PHONE Prompt Table: CM_PHONE
75	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
76	PROFILE_CM_SEQ_PH1	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for a primary phone number.
77	COUNTRY_CD1	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
78	PHONE1	Character(24)	VARCHAR2(24) NOT NULL	Primary Phone
79	EXTENSION1	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
80	PROFILE_CM_SEQ_PH2	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for an alternate phone number.
81	COUNTRY_CD2	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
82	PHONE2	Character(24)	VARCHAR2(24) NOT NULL	Telephone
83	EXTENSION2	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
84	PROFILE_CM_SEQ_PC1	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for a primary phone number.
85	COUNTRY_CELL_CD1	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
86	PHONE_CELL1	Character(24)	VARCHAR2(24) NOT NULL	Pager
87	EXTENSION_CELL1	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
88	PROFILE_CM_SEQ_FAX	Number(31,0)	DECIMAL(31) NOT NULL	CM Profile Detail ID................................................
89	COUNTRY_CD3	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
90	FAX	Character(24)	VARCHAR2(24) NOT NULL	This is the fax number field.
91	EXTENSION3	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
92	PROFILE_CM_SEQ_EM1	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for a primary email address.
93	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
94	EMAIL_DOMAIN	Character(50)	VARCHAR2(50) NOT NULL	Email Domain
95	HTML_FLAG1	Character(1)	VARCHAR2(1) NOT NULL	Field to determine if an Email Address can receive HTML Based Email. N=No Y=Yes
96	PROFILE_CM_SEQ_EM2	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for an alternate email address.
97	EMAIL_ADDR_ALT	Character(70)	VARCHAR2(70) NOT NULL	alternate email address
98	EMAIL_DOMAIN_ALT	Character(50)	VARCHAR2(50) NOT NULL	Email Domain
99	HTML_FLAG2	Character(1)	VARCHAR2(1) NOT NULL	Field to determine if an Email Address can receive HTML Based Email. N=No Y=Yes
100	PROFILE_CM_SEQ_EM3	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for an alternate email address.
101	EMAIL_ADDR_ALT_2	Character(70)	VARCHAR2(70) NOT NULL	This field contains the second alternative email address in Basic Data Table.
102	EMAIL_DOMAIN_ALT_2	Character(50)	VARCHAR2(50) NOT NULL	This field contains the second alternative email domain address in Basic Data Table.
103	HTML_FLAG3	Character(1)	VARCHAR2(1) NOT NULL	Field to determine if an Email Address can receive HTML Based Email. N=No Y=Yes
104	PROFILE_CM_SEQ_EM4	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for an alternate email address.
105	EMAIL_ADDR_ALT_3	Character(70)	VARCHAR2(70) NOT NULL	This field contains the thrid alternative email address in Basic Data Table.
106	EMAIL_DOMAIN_ALT_3	Character(50)	VARCHAR2(50) NOT NULL	This field contains the thrid alternative email domain address in Basic Data Table.
107	HTML_FLAG4	Character(1)	VARCHAR2(1) NOT NULL	Field to determine if an Email Address can receive HTML Based Email. N=No Y=Yes
108	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
109	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
110	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
111	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
112	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
113	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time