SCC_TEMP_IDADDR_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
SSF_ADR_USG_STG(SQL View) |
Index Back |
|---|---|
SF Address Usage SelectionThis 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.SCC_TEMP_ID , B.ADDR_USAGE , A.ADDRESS_TYPE , B.ADDR_USAGE_ORDER , %subrec(ADDRESS_SBR, A) FROM PS_SCC_STG_ADDR 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_SCC_STG_ADDR Z WHERE Y.ADDR_USAGE=B.ADDR_USAGE AND Y.ADDRESS_TYPE=Z.ADDRESS_TYPE AND Z.SCC_TEMP_ID=A.SCC_TEMP_ID AND Y.ADDRESS_TYPE = B.ADDRESS_TYPE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_TEMP_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Temp Constituent 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 |