BN_M_EBX_ADR_VW(SQL View) |
Index Back |
|---|---|
EbenX EMPL Address ViewThis view is used for the eBenX integration with Peoplesoft Benefits. This view joins to BN_M_SNAP_FILTR which is only populated during the EBNX_EXTRACT Application Engine Process |
| SELECT DISTINCT A.EMPLID , B.COUNTRY , B.ADDRESS1 , B.ADDRESS2 , B.ADDRESS3 , B.ADDRESS4 , B.CITY , B.STATE , B.POSTAL , B.HOME_PHONE FROM PS_BN_M_SNAP_FILTR A , PS_BN_SNAP_PER B WHERE A.EMPLID = B.EMPLID AND B.DEPENDENT_BENEF = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 4 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 5 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 6 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 7 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 8 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 9 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 10 | HOME_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Home Phone # |