GPFR_DA_ADRF_VW

(SQL View)
Index Back

Country's Address Setup

view for Country's Address Setup for DADS - Address Mapping

SELECT COUNTRY , EO_ADDRESS_FIELD FROM PS_EO_ADDR_FMT_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

2 GPFR_DA_ADR_FLD Character(18) VARCHAR2(18) NOT NULL Field for the DADS - Address Mapping