SAD_SL_ADDR_XLATBILL=Billing
LIVE=Living
MAIL=Mailing
PERM=Permanent
Prompt Table: ADDR_USAGE_TBL
SAD_SL_AD_USAGE(SQL Table) |
Index Back |
|---|---|
Studielink Address Usage TableTable to link Studielink Address types with Address Usages |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_SL_ADDR_XLAT |
Character(4) | VARCHAR2(4) NOT NULL |
Used to allow prompting for valid Studielink address type values.
BILL=Billing LIVE=Living MAIL=Mailing PERM=Permanent |
| 2 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table: ADDR_USAGE_TBL |