EMPLIDPrompt Table: PEOPLE_SRCH
Prompt Table: ADDRESS_TYP_TBL
AD=Address
EM=E-Mail
Prompt Table: SCC_CNT_ADFMTVW
AB=House Boat Reference
WW=House Trailer Reference
Prompt Table: STATE_TBL
Y/N Table Edit
ADDR_USAGE_VW(SQL View) |
Index Back |
|---|---|
Addr Usage Selection ViewThis view is used for selecting the address based upon the address usage from the address search panel. This view utilizes the address order table to find the matching address, if any. |
| SELECT A.Emplid , A.ADDRESS_TYPE , B.Addr_Usage_Order , B.Addr_Usage , B.Addr_Usage_Type , A.Effdt , %subrec(ADDRESS_SBR, A) FROM PS_ADDRESSES A , PS_Addr_Order_Tbl B WHERE A.ADDRESS_TYPE = B.ADDRESS_TYPE AND A.Effdt = ( SELECT MAX(Z.Effdt) FROM PS_ADDRESSES Z WHERE A.Emplid = Z.Emplid AND A.ADDRESS_TYPE = Z.ADDRESS_TYPE AND Z.Effdt <= %CurrentDateIn) AND A.Eff_Status ='A' AND B.Addr_Usage_Type = 'AD' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: ADDRESS_TYP_TBL |
| 3 | ADDR_USAGE_ORDER | Number(4,0) | SMALLINT NOT NULL | Address Usage Order |
| 4 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL | Address Usage |
| 5 | ADDR_USAGE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Address Usage Type
AD=Address EM=E-Mail |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
| 8 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 9 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 10 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 11 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 12 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 13 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 14 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 15 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 16 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 17 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 18 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 19 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 20 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 21 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 22 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 23 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |