SSR_GRAD_ADDRUSAGEPrompt Table: ADDR_USAGE_TBL
ADDRESS_TYPESSR_GR_ADPGTPVW(SQL View) |
Index Back |
|---|---|
Address Type View for Grad AppAddress Type View for Grad App |
| SELECT o.addr_usage , o.address_type , d.addr_type_descr FROM ps_addr_order_tbl o , PS_ADDRESS_TYP_TBL 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.addr_type_descr FROM PS_ADDRESS_TYP_TBL 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 | ADDR_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Address Type |