SAE_LIS_ADDRMAP(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID | |
| 2 | Character(4) | VARCHAR2(4) NOT NULL | 
LIS Address Type
 BP=Billing_Primary BS=Billing_Secondary CP=Campus_Primary CS=Campus_Secondary HP=Home_Primary HS=Home_Secondary MP=Mailing_Primary MS=Mailing_Secondary PP=Private_Primary PRP=Permanent_Primary PRS=Permanent_Secondary PS=Private_Secondary TP=Temporary_Primary TS=Temporary_Secondary WP=Work_Primary WS=Work_Secondary  | 
|
| 3 | Character(4) | VARCHAR2(4) NOT NULL | 
Address Type
 Prompt Table: ADDRESS_TYP_TBL  |