INST_ADDR_VW(SQL View) |
Index Back |
|---|---|
Financial Aid Address 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 DISTINCT A.EMPLID , D.INSTITUTION , D.APP_SOURCE_CODE , C.ADDRESS_TYPE , C.ADDR_USAGE_ORDER , %subrec(ADDRESS_SBR, A) FROM PS_ADDRESSES A , PS_ADDR_ORDER_TBL C , PS_INST_CONTROL D , PS_FA_ADDR_USAGE E WHERE A.ADDRESS_TYPE = C.ADDRESS_TYPE AND A.EMPLID = D.EMPLID AND D.INSTITUTION = E.INSTITUTION AND C.ADDR_USAGE = E.ADDR_USAGE AND E.EFFDT = ( SELECT MAX(G.EFFDT) FROM PS_FA_ADDR_USAGE G WHERE E.INSTITUTION = G.INSTITUTION AND E.CPS_SCHOOL_CODE =G.CPS_SCHOOL_CODE AND G.EFFDT <= %CurrentDateIn) AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_ADDRESSES X WHERE X.EMPLID = A.EMPLID AND X.ADDRESS_TYPE = A.ADDRESS_TYPE AND X.EFFDT<=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STDNT_AID_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | APP_SOURCE_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Application Source Code
0=Need Access 0=Need Access 1=Electronic Initial Application 2=Electronic Renewal Aplication 3=Electronic Correction 4=FAFSA Express 5=ACT 6=I-NET 7=NCS 8=Profile 9=Institutional Application O=FT Canada Student Loan P=PT Canada Student Loan |
| 4 | ADDRESS_TYPE1 | Character(10) | VARCHAR2(10) NOT NULL | Address Type |
| 5 | ADDR_USAGE_ORDER | Number(4,0) | SMALLINT NOT NULL | Address Usage Order |
| 6 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
| 7 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 8 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 9 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 10 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 12 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 13 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 14 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 15 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 16 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 17 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 18 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 19 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 20 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 21 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 22 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |