RD_PERSON_CI_VW(SQL View) |
Index Back |
---|---|
CI View for RD_PERSONThis 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 | 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 | 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 | 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
|
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 |