SAE_LIS_ADDRMAP(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SAE_TARGET_ID | Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID |
2 | SAE_LIS_ADDR_TYPE | 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 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: ADDRESS_TYP_TBL |