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 |