SSR_GRAD_ADDRUSAGEPrompt Table: ADDR_USAGE_TBL
ADDRESS_TYPELANGUAGE_CDSSR_GR_ADPGTPLN(SQL View) |
Index Back |
|---|---|
Rel Lang for SSR_GR_ADPGTPVW |
| SELECT o.addr_usage , o.address_type , d.language_cd , d.addr_type_descr FROM ps_addr_order_tbl o , PS_ADDRESS_TYP_LNG d , ps_type_cntl_addr c WHERE d.address_type = o.address_type AND c.address_type = o.address_type AND c.type_control IN ('D', 'F', 'U') UNION ALL SELECT ' ' , t.address_type , t.language_cd , t.addr_type_descr FROM PS_ADDRESS_TYP_LNG t , ps_type_cntl_addr ct WHERE ct.address_type = t.address_type AND ct.type_control IN ('D', 'F', 'U') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_GRAD_ADDRUSAGE |
Character(10) | VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table: ADDR_USAGE_TBL |
| 2 | ADDRESS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Address Type |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | ADDR_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Address Type |