EMPLIDADDR_USAGEBUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
SSR_PHON_USE_VW(SQL View) |
Index Back |
|---|---|
SR 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 , A.PHONE_TYPE , B.ADDR_USAGE_ORDER , %subrec(PHONE_SBR, A) FROM PS_HCR_PER_PHONE_I A ,PS_PHONE_ORDER_TBL B WHERE A.PHONE_TYPE=B.PHONE_TYPE AND B.ADDR_USAGE_ORDER = ( SELECT MIN(Y.ADDR_USAGE_ORDER) FROM PS_PHONE_ORDER_TBL Y , PS_HCR_PER_PHONE_I Z WHERE Y.ADDR_USAGE=B.ADDR_USAGE AND Y.PHONE_TYPE=Z.PHONE_TYPE AND Z.EMPLID=A.EMPLID AND Y.PHONE_TYPE = B.PHONE_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 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
| 4 | ADDR_USAGE_ORDER | Number(4,0) | SMALLINT NOT NULL | Address Usage Order |
| 5 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 6 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |