ADDRESS_TYPEPrompt Table: ADDRESS_TYP_TBL
BILL=Billing
LIVE=Living
MAIL=Mailing
PERM=Permanent
SAD_SL_AD_TP_VW(SQL View) |
Index Back |
|---|---|
Studielink Address Type ViewThis view links the Studielink address types to address usage. |
| SELECT B.ADDRESS_TYPE , A.ADDR_USAGE , A.SAD_SL_ADDR_XLAT , X.XLATLONGNAME FROM PS_SAD_SL_AD_USAGE A , PS_ADDR_ORDER_TBL B , PSXLATITEM X WHERE A.ADDR_USAGE = B.ADDR_USAGE AND B.ADDR_USAGE_ORDER = ( SELECT MIN(J.ADDR_USAGE_ORDER) FROM PS_ADDR_ORDER_TBL J WHERE B.ADDR_USAGE = J.ADDR_USAGE) AND X.FIELDNAME = 'SAD_SL_ADDR_XLAT' AND X.FIELDVALUE = A.SAD_SL_ADDR_XLAT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADDRESS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: ADDRESS_TYP_TBL |
| 2 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL | Address Usage |
| 3 | 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 |
| 4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |