FIN_ACCOUNT_IDBO_IDPERSON_IDRBF_ACC_PERS_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT a.FIN_ACCOUNT_ID ,a.BO_ID ,b.PERSON_ID , b.LAST_NAME ,b.FIRST_NAME FROM PS_RBF_CUST_ACT_VW a , PS_RB_PRSN_P_NM_VW b WHERE a.BO_ID = b.BO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIN_ACCOUNT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 2 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 3 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |