BUS_CONTACT_IDNATIONAL_IDRBG_PERSON_VW(SQL View) |
Index Back |
|---|---|
Agent View Person ViewPerson View in Agent View Screen for GOV |
| SELECT DISTINCT P.BO_ID , ' ' , N.NAME ,P.PERSON_ID FROM PS_RD_PERSON P , PS_RD_PERSON_NAME N WHERE P.PERSON_ID = N.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUS_CONTACT_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Business Contact Id |
| 2 | NATIONAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |