EMPLIDADDR_USAGEPrompt Table: HCR_ADDR_TYP_I
Prompt Table: SCC_CNT_ADFMTVW
AB=House Boat Reference
WW=House Trailer Reference
Prompt Table: STATE_TBL
Y/N Table Edit
SF_ADDR_USAGE2(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. This view is different that SF_ADDR_USAGE because it only will return 1 row - the row with the highest priority (lowest numerical value). |
| SELECT A.EMPLID , B.ADDR_USAGE , A.ADDRESS_TYPE , B.ADDR_USAGE_ORDER , %subrec(ADDRESS_SBR, A) FROM PS_ADDRESSES4_VW A ,PS_ADDR_ORDER_TBL B WHERE A.ADDRESS_TYPE=B.ADDRESS_TYPE AND B.ADDR_USAGE_ORDER = ( SELECT MIN(Y.ADDR_USAGE_ORDER) FROM PS_ADDR_ORDER_TBL Y , PS_ADDRESSES4_VW Z WHERE Y.ADDR_USAGE=B.ADDR_USAGE AND Y.ADDRESS_TYPE=Z.ADDRESS_TYPE AND Z.EMPLID=A.EMPLID) |
| # | 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: HCR_ADDR_TYP_I |
| 4 | ADDR_USAGE_ORDER | Number(4,0) | SMALLINT NOT NULL | Address Usage Order |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
| 6 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 7 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 8 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 9 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 10 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 11 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 12 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 13 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 14 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 15 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 16 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 17 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 18 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 19 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 20 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 21 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |