BO_IDPERSON_IDCOUNTRYPrompt Table: NID_TYPE_VW
NATIONAL_ID_TYPEPrompt Table: NID_TYPE1_VW
Y/N Table Edit
CRM=CRM
EBS=EBIZ Suite
EXT=External
HRMS=HCM
SCM=SCM
Default Value: CRM
RD_PERS_NID_VW(SQL View) |
Index Back |
|---|---|
National ID with BO_IDChild table of Person to hold all person's national Id information for different country. View with BO_ID as the PID |
| SELECT A.BO_ID , B.PERSON_ID , B.COUNTRY , B.NATIONAL_ID_TYPE , B.NATIONAL_ID , B.PRIMARY_NID , B.SOURCE_IND FROM PS_RD_PERSON A , PS_RD_PERS_NID B WHERE A.PERSON_ID = B.PERSON_ID |
| # | 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 |
| 3 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: NID_TYPE_VW |
| 4 | NATIONAL_ID_TYPE |
Character(6) | VARCHAR2(6) NOT NULL |
National ID Type
Prompt Table: NID_TYPE1_VW |
| 5 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 6 | PRIMARY_NID | Character(1) | VARCHAR2(1) NOT NULL |
Primary ID field used in HD_360_RESPONSE_SYNC message.
Y/N Table Edit |
| 7 | 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 |