STG_CONSUMER_T

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag
2	ROW_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	Row Number
3	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Matching Action
4	AUTHORIZATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification used for authorization purposes.
5	BIRTHDATE	Date(10)	DATE	Birthdate of the person.
6	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
7	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
8	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
9	CR_RATING	Number(5,0)	INTEGER NOT NULL	Credit Rating Field. Used to store Credit Rating of a Company Or Consumer. It is used in BC (Business Contact) Record
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
11	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
12	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
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
15	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
16	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Middle Name
17	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)
18	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
19	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
20	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
21	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Suffix
22	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
23	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title
24	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
25	PIM_ACCT_NAME	Character(30)	VARCHAR2(30) NOT NULL	PIM Account Name
26	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	PREF_FIRST_NAME field is used to identify the employees preferred first name
27	SALUTATION_CD	Character(6)	VARCHAR2(6) NOT NULL	Salutation Code.
28	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
29	SEGMENT	Character(4)	VARCHAR2(4) NOT NULL	Segment code for customer data
30	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
31	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender of the person. F=Female M=Male U=Unknown
32	SINCE_DT	Date(10)	DATE	The customer has been a customer since this date.
33	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title