ADDRESS_TYPELANGUAGE_CDSCC_ADDR_TYPFLN(SQL View) |
Index Back |
|---|---|
Adress type lang viewRelated language address type view used in Fluid Addresses page |
| SELECT A.ADDRESS_TYPE , AL.LANGUAGE_CD , AL.ADDR_TYPE_SHORT , AL.ADDR_TYPE_DESCR , AL.SCC_DISPLAY_FIELD FROM PS_ADDRESS_TYP_TBL A LEFT OUTER JOIN PS_TYPE_CNTL_ADDR C ON A.ADDRESS_TYPE = C.ADDRESS_TYPE , PS_ADDRESS_TYP_LNG AL WHERE ((C.Type_Control <>'N' AND C.Type_control IS NOT NULL) OR C.Type_Control IS NULL) AND AL.ADDRESS_TYPE = A.ADDRESS_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADDRESS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Address Type |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | ADDR_TYPE_SHORT | Character(15) | VARCHAR2(15) NOT NULL | Short Address Type |
| 4 | ADDR_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Address Type |
| 5 | SCC_DISPLAY_FIELD | Character(40) | VARCHAR2(40) NOT NULL | Field to display address type on Fluid page |