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