RD_PERSON_2_VW(SQL View) |
Index Back |
|---|---|
PersonThe Fields SETID and CONTACT_ID have been added to maintain the cross reference with PS FDM. |
| SELECT BO_ID , PERSON_ID , CONTACT_FLAG , TITLE , RB_LANGUAGE_CD , EMPLID , SEX , BIRTHDATE , COMM_METHOD , SALUTATION_CD , SETID , AUTHORIZATION_ID , PREF_WF_ROUTE_MTHD , SOURCE_IND , PIM_ACCT_NAME , DRIVER_LICENCE , DRIVER_L_STATE , DRIVER_L_EXP_DATE , RD_EMPLOYER , DO_NOT_CONTACT , DO_NOT_EMAIL , DO_NOT_MAIL , DO_NOT_CALL , MARKET , ROW_LASTMANT_OPRID , ROW_LASTMANT_DTTM FROM PS_RD_PERSON |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Default Value: NEXT |
| 3 | 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 |
| 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: E |
| 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 |
| 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_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Do Not Email
N=No Y=Yes |
| 22 | DO_NOT_MAIL | Character(1) | VARCHAR2(1) NOT NULL |
Do Not Mail
N=No Y=Yes |
| 23 | DO_NOT_CALL | Character(1) | VARCHAR2(1) NOT NULL |
channel flag of privacy preference
N=No Y=Yes |
| 24 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 25 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 26 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |