RBC_PERSONID_VW(SQL View) |
Index Back |
---|---|
View to get PERSON_IDView to get PERSON_ID |
SELECT PERSON_ID , NAME FROM PS_RD_PERSON_NAME WHERE PRIMARY_IND='Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |