GPFR_DA_REC_ADR

(SQL Table)
Index Back

Address mapping - Child

DADS Address Mapping child table.

# 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_RECORD Character(3) VARCHAR2(3) NOT NULL Field for the DADS - Address Mapping
001=Address 1
003=Street Number
004=Bis or Ter
006=Street Name
009=Town
010=ZIP Code
012=City
013=Country Code
3 GPFR_DA_ADDRESS1 Character(18) VARCHAR2(18) NOT NULL Field for the DADS - Address Mapping

Prompt Table: GPFR_DA_ADRF_VW

4 GPFR_DA_ADDRESS2 Character(18) VARCHAR2(18) NOT NULL Field for the DADS - Address Mapping

Prompt Table: %EDITTABLE2

5 GPFR_DA_ADDRESS3 Character(18) VARCHAR2(18) NOT NULL Field for the DADS - Address Mapping

Prompt Table: %EDITTABLE3

6 GPFR_DA_ADR_SBSTRG Character(1) VARCHAR2(1) NOT NULL Field for the DADS - Address Mapping
0=No Substring
1=Street Number
2=Bis or Ter
3=Delimited

Default Value: 0

7 GPFR_DA_ADR_DELIM Character(1) VARCHAR2(1) NOT NULL Field for the DADS - Address Mapping
0=None
1=Comma
2=Space
3=Comma or Space

Default Value: 0

8 GPFR_DA_ADR_SEL Character(1) VARCHAR2(1) NOT NULL Field for the DADS - Address Mapping
0=None
1=Left
2=Right

Default Value: 0