RA_BASIC_IND_VW (SQL View)	Index Back
View of BO_BASIC_IND This view uses BAS_SYSID as the key for single key access to Individual Basic data.

RA_BASIC_IND_VW

(SQL View)

View of BO_BASIC_IND

This view uses BAS_SYSID as the key for single key access to Individual Basic data.

SELECT A.BAS_SYSID , A.BO_ID , A.ROLE_TYPE_ID , A.BO_REL_ID , A.SETID , A.EXTERNAL_LIST_ID , A.SOURCE_SYSID , A.COMPANY_SYSID , A.BO_ID_COMPANY , A.DATASET_SYSID , A.SSN , A.TITLE , A.FUNCTIONAL_TITLE , A.DEPARTMENT , A.LANGUAGE_CD , A.BIRTHDATE , A.SEX , A.COMM_METHOD , A.SALUTATION_CD , A.NCOA_LAST_OVERLAY , A.ORIGIN , A.DO_NOT_EMAIL , %subrec(BO_BAS_NAME_SBR,A) , %subrec(BO_BAS_ADDR_SBR,A) , %subrec(BO_BAS_PHN1_SBR,A) , %subrec(BO_BAS_PHN2_SBR,A) , %subrec(BO_BAS_FAX_SBR,A) , %subrec(BO_BAS_EML1_SBR,A) , %subrec(BO_BAS_EML2_SBR,A) , %subrec(RB_AUDIT_SBR,A) FROM %Table(BO_BASIC_IND) A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

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 DATASET_SYSID Number(18,0) DECIMAL(18) NOT NULL Data Set ID

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

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

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

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

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

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

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

18 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

19 SALUTATION_CD Character(6) VARCHAR2(6) NOT NULL Salutation Code.
Prompt Table: SALUTATION_TBL

20 NCOA_LAST_OVERLAY Date(10) DATE NCOA Last Overlay Date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

41 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

95 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.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BAS_SYSID	Number(18,0)	DECIMAL(18) NOT NULL	Basic Data System ID
2	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
3	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID Prompt Table: BO_ROLE_TYPE_V1
4	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object
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	DATASET_SYSID	Number(18,0)	DECIMAL(18) NOT NULL	Data Set ID
11	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
12	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
13	FUNCTIONAL_TITLE	Character(40)	VARCHAR2(40) NOT NULL	Functional Title
14	DEPARTMENT	Character(40)	VARCHAR2(40) NOT NULL	Department
15	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
16	BIRTHDATE	Date(10)	DATE	Birthdate of the person.
17	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender of the person. F=Female M=Male U=Unknown
18	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
19	SALUTATION_CD	Character(6)	VARCHAR2(6) NOT NULL	Salutation Code. Prompt Table: SALUTATION_TBL
20	NCOA_LAST_OVERLAY	Date(10)	DATE	NCOA Last Overlay Date
21	ORIGIN	Character(40)	VARCHAR2(40) NOT NULL	Origin
22	DO_NOT_EMAIL	Character(1)	VARCHAR2(1) NOT NULL	Do Not Email N=No Y=Yes
23	NAME_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Name UID
24	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	This is the country name format field. Prompt Table: COUNTRY_TBL
25	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
26	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
27	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
28	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
29	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
30	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Suffix
31	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title
32	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
33	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
34	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
35	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
36	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Middle Name
37	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
38	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Name
39	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)
40	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	PREF_FIRST_NAME field is used to identify the employees preferred first name
41	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.
42	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
43	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
44	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
45	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
46	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
47	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
48	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
49	NUM2	Character(4)	VARCHAR2(4) NOT NULL	Number 2
50	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
51	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
52	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
53	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
54	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
55	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
56	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
57	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
58	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit Default Value: Y
59	CROSS_STREET_1	Character(50)	VARCHAR2(50) NOT NULL	Cross Street of a location
60	CROSS_STREET_2	Character(50)	VARCHAR2(50) NOT NULL	Cross Street of a location
61	ADDRESS_SUB_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Sub Type Field ADDR=Address INT=Intersection Default Value: ADDR
62	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS1_AC
63	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS3_AC
64	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS2_AC
65	ADDRESS4_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 4.
66	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	CITY_AC
67	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RD_REGION_VW
68	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
69	CM_ID_PHONE	Number(31,0)	DECIMAL(31) NOT NULL	CM_ID_PHONE Prompt Table: CM_PHONE
70	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
71	PROFILE_CM_SEQ_PH1	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for a primary phone number.
72	COUNTRY_CD1	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
73	PHONE1	Character(24)	VARCHAR2(24) NOT NULL	Primary Phone
74	EXTENSION1	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
75	PROFILE_CM_SEQ_PH2	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for an alternate phone number.
76	COUNTRY_CD2	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
77	PHONE2	Character(24)	VARCHAR2(24) NOT NULL	Telephone
78	EXTENSION2	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
79	PROFILE_CM_SEQ_FAX	Number(31,0)	DECIMAL(31) NOT NULL	CM Profile Detail ID................................................
80	COUNTRY_CD3	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
81	FAX	Character(24)	VARCHAR2(24) NOT NULL	This is the fax number field.
82	EXTENSION3	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
83	PROFILE_CM_SEQ_EM1	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for a primary email address.
84	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
85	EMAIL_DOMAIN	Character(50)	VARCHAR2(50) NOT NULL	Email Domain
86	HTML_FLAG1	Character(1)	VARCHAR2(1) NOT NULL	Field to determine if an Email Address can receive HTML Based Email. N=No Y=Yes
87	PROFILE_CM_SEQ_EM2	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for an alternate email address.
88	EMAIL_ADDR_ALT	Character(70)	VARCHAR2(70) NOT NULL	alternate email address
89	EMAIL_DOMAIN_ALT	Character(50)	VARCHAR2(50) NOT NULL	Email Domain
90	HTML_FLAG2	Character(1)	VARCHAR2(1) NOT NULL	Field to determine if an Email Address can receive HTML Based Email. N=No Y=Yes
91	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
92	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
93	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
94	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
95	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.
96	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time