EMPLIDADDR_USAGEPrompt Table: ADDRESS_TYP_TBL
SF_EADDR_USAGE(SQL View) |
Index Back |
|---|---|
SF Addr Usage Selection ViewThis view is used for selecting the address based upon the address usage for the address search panel. This view utilizes the address order table to find the matching address, if any. |
| SELECT A.EMPLID ,B.ADDR_USAGE ,B.ADDRESS_TYPE ,B.ADDR_USAGE_ORDER ,A.EMAIL_ADDR FROM PS_EMAIL_ADDRESSES A ,PS_ADDR_ORDER_TBL B WHERE A.E_ADDR_TYPE=B.ADDRESS_TYPE AND B.ADDR_USAGE_ORDER= ( SELECT MIN(Y.ADDR_USAGE_ORDER) FROM PS_ADDR_ORDER_TBL Y , PS_EMAIL_ADDRESSES Z WHERE Y.ADDR_USAGE=B.ADDR_USAGE AND Y.ADDRESS_TYPE=Z.E_ADDR_TYPE AND Y.ADDR_USAGE_TYPE = 'EM' AND Z.EMPLID=A.EMPLID AND Y.ADDRESS_TYPE = B.ADDRESS_TYPE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ADDR_USAGE |
Character(10) | VARCHAR2(10) NOT NULL | Address Usage |
| 3 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: ADDRESS_TYP_TBL |
| 4 | ADDR_USAGE_ORDER | Number(4,0) | SMALLINT NOT NULL | Address Usage Order |
| 5 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |