RD_PERSON_CI_VW

(SQL View)
Index Back

CI View for RD_PERSON

This view: RD_PERSON_CI_VW has the same structure as the record: RD_PERSON. As delivered, this view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly. The Fields SETID and CONTACT_ID have been added to maintain the cross reference with PS FDM.

SELECT A.PERSON_ID , A.CONTACT_FLAG , A.BO_ID , A.TITLE , A.RB_LANGUAGE_CD , A.EMPLID , A.SEX , A.BIRTHDATE , A.COMM_METHOD , A.SALUTATION_CD , A.SETID , A.AUTHORIZATION_ID , A.PREF_WF_ROUTE_MTHD , A.SOURCE_IND , A.PIM_ACCT_NAME , A.DRIVER_LICENCE , A.DRIVER_L_STATE , A.DRIVER_L_EXP_DATE , A.RD_EMPLOYER , A.DO_NOT_CONTACT , A.DO_NOT_SMS , A.DO_NOT_EMAIL , A.DO_NOT_CALL , A.DO_NOT_MAIL , A.TEMPLATE_FLAG , A.INSAGNT_LICENSE_ID , A.DATE_DECEASED , A.MARITAL_STATUS , A.OCCUPATION , A.INCOME , A.INCOME_CURRENCY , %subrec(RB_MARKET_SBR, A) , %subrec(RB_AUDIT_SBR, A) FROM PS_RD_PERSON A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Default Value: NEXT

2 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role.
E=External Contact
I=Internal Corporate Contact

Default Value: E

3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
4 TITLE Character(35) VARCHAR2(35) NOT NULL Title
5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default Value: PSOPTIONS.LANGUAGE_CD

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown
8 BIRTHDATE Date(10) DATE Birthdate of the person.
9 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

Default Value: C

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

Prompt Table: SALUTATION_TBL

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

Prompt Table: SP_SETID_NONVW

12 AUTHORIZATION_ID Character(10) VARCHAR2(10) NOT NULL Identification used for authorization purposes.
13 PREF_WF_ROUTE_MTHD Character(1) VARCHAR2(1) NOT NULL Preferred workflow notification method. E.g., Email, Worklist, or Both.
B=Both
E=Email
W=Worklist

Default Value: B

14 SOURCE_IND Character(4) VARCHAR2(4) NOT NULL EIP Source Indicator
CRM=CRM
EBS=EBIZ Suite
EXT=External
HRMS=HCM
SCM=SCM

Default Value: CRM

15 PIM_ACCT_NAME Character(30) VARCHAR2(30) NOT NULL PIM Account Name
16 DRIVER_LICENCE Character(40) VARCHAR2(40) NOT NULL drivers license
17 DRIVER_L_STATE Character(6) VARCHAR2(6) NOT NULL Driver State

Prompt Table: RD_DL_STATE_VW
Set Control Field: COUNTRY

18 DRIVER_L_EXP_DATE Date(10) DATE DL Expiry Date
19 RD_EMPLOYER Character(50) VARCHAR2(50) NOT NULL Defines the Employer of the Customer, Consumer or Employee
20 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
21 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
22 DO_NOT_EMAIL Character(1) VARCHAR2(1) NOT NULL Do Not Email
N=No
Y=Yes
23 DO_NOT_CALL Character(1) VARCHAR2(1) NOT NULL channel flag of privacy preference
N=No
Y=Yes
24 DO_NOT_MAIL Character(1) VARCHAR2(1) NOT NULL Do Not Mail
N=No
Y=Yes
25 TEMPLATE_FLAG Character(1) VARCHAR2(1) NOT NULL Use as Template Worker

Y/N Table Edit

26 INSAGNT_LICENSE_ID Character(20) VARCHAR2(20) NOT NULL insurance agent licence id
27 DATE_DECEASED Date(10) DATE Date Deceased
28 MARITAL_STATUS Character(2) VARCHAR2(2) NOT NULL Marital Status
1=Single
2=Married
3=Married but Separated
4=Divorced
5=Widow
29 OCCUPATION Character(50) VARCHAR2(50) NOT NULL Occupation
30 INCOME Number(15,2) DECIMAL(14,2) NOT NULL Income
31 INCOME_CURRENCY Character(3) VARCHAR2(3) NOT NULL Income Currency

Prompt Table: CURRENCY_CD_TBL

32 MARKET Character(3) VARCHAR2(3) NOT NULL Market
33 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
34 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
35 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
36 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
37 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.
38 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time