STG_CONSUMER_T

(SQL Table)
Index Back

List Import Stage Table

This Record handles the List Import Stage Table.

# 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