SIRDSTPROV FILE
Province
This file defines states or provinces and assigns them to their applicable
country.
REFERENCED BY
RD30.1 RD30.2 RD32.5 RD32.6 RD50.1 RD50.2
RD70.1 RD70.2 RD930
UPDATED BY
RD16.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSP-COUNTRY-CODE Alpha 2 RD16.1
Element: Country Code
WSP-STATE-PROV Alpha 2 RD16.1
Element: State Prov
WSP-DESCRIPTION Alpha 50 (Lower Case) RD16.1
Element: Description This field contains the description.
WSP-DATE Numeric 8 (yyyymmdd) RD16.1
Element: Date This field contains the system date
when this was created.
WSP-TIME Numeric 6 (hhmmss) RD16.1
Element: Time
SIRDSTPROV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WSPSET1 COUNTRY-CODE RD16.1 RD30.1
STATE-PROV RD30.2 RD32.5
RD32.6 RD50.1
RD50.2 RD70.1
RD70.2 RD930
SIRDSTPROV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Rdctry SIRDCTRY Required
WSP-COUNTRY-CODE -> WCT-COUNTRY-CODE
|
