PERSON_DISP_VW(SQL View) |
Index Back |
|---|---|
Person Display ViewView to display the Person Details. |
| SELECT DISTINCT NAMES.BO_ID ,PERSON.PERSON_ID , NAMES.FIRST_NAME ,NAMES.FIRST_NAME_SRCH ,NAMES.MIDDLE_NAME ,NAMES.LAST_NAME ,NAMES.LAST_NAME_SRCH ,PERSON.BIRTHDATE ,PERSON.SEX , NATID.NATIONAL_ID , ADDR.ADDRESS1 ,ADDR.CITY ,EML.CM_CONCAT_UPPER ,ADDR.STATE ,ADDR.POSTAL FROM PS_BO_NAME NAMES LEFT OUTER JOIN PS_RD_PERSON PERSON ON ( NAMES.BO_ID=PERSON.BO_ID)LEFT OUTER JOIN PS_BO_SRCH_ADD ADDR ON ( NAMES.BO_ID=ADDR.BO_ID)LEFT OUTER JOIN PS_BO_SRCH_EML EML ON ( NAMES.BO_ID=EML.BO_ID)LEFT OUTER JOIN PS_NATID_VW NATID ON ( NAMES.BO_ID=NATID.BO_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 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 4 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 5 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 6 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | BIRTHDATE | Date(10) | DATE | Birthdate of the person. |
| 9 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender of the person.
F=Female M=Male U=Unknown |
| 10 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 11 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 12 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 13 | CM_CONCAT_UPPER | Character(100) | VARCHAR2(100) NOT NULL | Uppper Concatenated Contact Method |
| 14 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 15 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |