PCODESDTL FILE
Contains contact information detail (address and phone number) for specific
types of PCODES.
REFERENCED BY
AC541 AC542 BN150 HR204 HR511 HR650
PA149 PA290 PA372 PA490 PA502 PA513
PA590 PA90.1 PR128 PR13.1 PR13.5 PR13.6
PR13.8 PR131 PR132 PR134 PR136 PR32.2
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR36.1 PR530 PR82.1
UK102 UK120
UPDATED BY
HR04.9
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDD-TYPE Alpha 2 HR04.9
Type Indicates whether code is
establishment, hospital, or physician.
ET = Establishment
HO = Hospital
PY = Physician
PDD-CODE Alpha 10 HR04.9
Code Contains the code.
PDD-CONTACT-LAST Alpha 30 (Lower Case) HR04.9
Contact Last Contains the last name of the contact
person.
PDD-CONTACT-FIRST Alpha 15 (Lower Case) HR04.9
Contact First Contains the first name of the contact
person.
PDD-CONTACT-MI Alpha 1 HR04.9
Contact Mi Contains the middle initial of the
contact person.
PDD-ADDR1 Alpha 30 (Lower Case) HR04.9
Address 1 This field contains the first line of
address information.
PDD-ADDR2 Alpha 30 (Lower Case) HR04.9
Address 2 This field contains the second line of
address information.
PDD-ADDR3 Alpha 30 (Lower Case) HR04.9
Address 3 This field contains the third line of
address information.
PDD-ADDR4 Alpha 30 (Lower Case) HR04.9
Address 4 This field contains the fourth line of
address information.
PDD-CITY Alpha 18 (Lower Case) HR04.9
City This field contains the city of the
address.
PDD-STATE Alpha 2 HR04.9
State or Province This field contains the two-character
state code of the address.
PDD-ZIP Alpha 10 HR04.9
Postal Code This field contains the postal code of
the address.
PDD-COUNTY Alpha 25 (Lower Case) HR04.9
County The county for the company address.
PDD-PHONE-COUNTRY Alpha 6 HR04.9
Telephone Country This field contains the prefix of the
Code telephone number. For example, the
country or city code.
PDD-PHONE Alpha 15 HR04.9
Telephone Number Phone number.
PDD-PHONE-EXT Alpha 5 HR04.9
Telephone Extension This field contains the telephone
extension number.
PDD-FAX-COUNTRY Alpha 6 HR04.9
Fax Country This field contains the prefix of the
fax number. For example, the country or
city code.
PDD-FAX-NUMBER Alpha 15 HR04.9
Fax Number This field contains the fax number.
PDD-FAX-EXT Alpha 5 HR04.9
Fax Extension This field contains the fax number
extension.
PDD-EMAIL-ADDRESS Alpha 60 (Lower Case) HR04.9
Email Address Contains the e-mail address.
PDD-USER1 Alpha 10 HR04.9
User1 Contains user-defined information.
PDD-USER2 Alpha 10 HR04.9
User2 Contains user-defined information.
PDD-DATE-STAMP Numeric 8 (yyyymmdd) HR04.9
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PDD-TIME-STAMP Numeric 6 (hhmmss) HR04.9
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PDD-USER-ID Alpha 10 (Lower Case) HR04.9
User ID Name Contains the user ID of the person who
last changed this record.
PDD-COUNTRY-CODE Alpha 2 HR04.9
Country Code Contains the country of the address.
PDD-CMA-CODE Alpha 10 HR04.9
Cma Code Contains the Census Metropolitan Area
code.
PDD-SUPP-ADDR1 Alpha 30 (Lower Case) HR04.9
Supplemental Address
PDD-SUPP-ADDR2 Alpha 30 (Lower Case) HR04.9
Address 2
PDD-SUPP-ADDR3 Alpha 30 (Lower Case) HR04.9
Supp Addr3
PDD-SUPP-ADDR4 Alpha 30 (Lower Case) HR04.9
Supp Addr4
PDD-SUPP-CITY Alpha 18 (Lower Case) HR04.9
City
PDD-SUPP-STATE Alpha 2 HR04.9
State
PDD-SUPP-ZIP Alpha 10 HR04.9
Postal Code
PDD-SUPP-CNTRY-CD Alpha 2 HR04.9
Supp Cntry Cd
PDD-REPORT-PROV Alpha 10 HR04.9
Report Prov
PCODESDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDDSET1 TYPE AC541 AC542
CODE BN150 HR04.9
HR204 HR511
HR650 PA149
PA290 PA372
PA490 PA502
PA513 PA590
PA90.1 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR131 PR132
PR134 PR136
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
...
PCODESDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cma PCODES Required
When PDD-CMA-CODE != Spaces
"C" -> PCO-TYPE
PDD-CMA-CODE -> PCO-CODE
Country INSTCTRYCD Required
When (PDD-COUNTRY-CODE != Spaces )
PDD-COUNTRY-CODE -> INT-COUNTRY-CODE
Pcodes PCODES Required
PDD-TYPE -> PCO-TYPE
PDD-CODE -> PCO-CODE
Report Prov PCODES Required
When PDD-REPORT-PROV != Spaces
"RP" -> PCO-TYPE
PDD-REPORT-PROV -> PCO-CODE
Supp Country INSTCTRYCD Not Required
PDD-SUPP-CNTRY-CD -> INT-COUNTRY-CODE
|
