|
|
PCODESDTL FILE
Contains contact information detail (address and phone number) for specific
types of PCODES.
REFERENCED BY
AC541 AC542 BN150 BN66.1 HR11.1 HR11.2
HR204 HR511 HR650 PA02.1 PA100 PA102
PA13.1 PA13.2 PA149 PA290 PA372 PA490
PA496 PA502 PA513 PA52.1 PA52.2 PA52.3
PA52.4 PA52.5 PA590 PA594 PA90.1 PR110
PR113 PR120 PR128 PR13.1 PR13.5 PR13.6
PR13.8 PR130 PR131 PR132 PR134 PR136
PR139 PR140 PR189 PR195 PR197 PR198
PR29.1 PR32.2 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1
PR45.1 PR529 PR530 PR560 PR80.1 PR82.1
PR84.1 PR85.1 PR89.1 UK102 UK560 TA147
UK120
UPDATED BY
HR04.9
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDD-TYPE Alpha 2 HR04.9
Element: Type Indicates whether code is
establishment, hospital, or physician.
ET = Establishment
HO = Hospital
PY = Physician
PDD-CODE Alpha 10 HR04.9
Element: Code Contains the code.
PDD-CONTACT-LAST Alpha 30 (Lower Case) HR04.9
Element: Contact Last Contains the last name of the contact
person.
PDD-CONTACT-FIRST Alpha 15 (Lower Case) HR04.9
Element: Contact First Contains the first name of the contact
person.
PDD-CONTACT-MI Alpha 1 HR04.9
Element: Contact Mi Contains the middle initial of the
contact person.
PDD-ADDR1 Alpha 30 (Lower Case) HR04.9
Element: Address 1 This field contains the first line of
address information.
PDD-ADDR2 Alpha 30 (Lower Case) HR04.9
Element: Address 1
PDD-ADDR3 Alpha 30 (Lower Case) HR04.9
Element: Address 1
PDD-ADDR4 Alpha 30 (Lower Case) HR04.9
Element: Address 1
PDD-CITY Alpha 18 (Lower Case) HR04.9
Element: City This field contains the city of the
address.
PDD-STATE Alpha 2 HR04.9
Element: State or ProviThis field contains the two-character
state code of the address.
PDD-ZIP Alpha 10 HR04.9
Element: Postal Code This field contains the postal code of
the address.
PDD-COUNTY Alpha 25 (Lower Case) HR04.9
Element: 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
Element: Telephone NumbPhone number.
PDD-PHONE-EXT Alpha 5 HR04.9
Element: Telephone ExteThis field contains the telephone
extension number.
PDD-FAX-COUNTRY Alpha 6 HR04.9
Telephone Country
Code
PDD-FAX-NUMBER Alpha 15 HR04.9
Element: Telephone Number
PDD-FAX-EXT Alpha 5 HR04.9
Element: Telephone Extension
PDD-EMAIL-ADDRESS Alpha 60 (Lower Case) HR04.9
Element: Email Address Contains the e-mail address.
PDD-USER1 Alpha 10 HR04.9
Element: User1 Contains user-defined information.
PDD-USER2 Alpha 10 HR04.9
Element: User2 Contains user-defined information.
PDD-DATE-STAMP Numeric 8 (yyyymmdd) HR04.9
Element: 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
Element: 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
Element: User
PDD-COUNTRY-CODE Alpha 2 HR04.9
Element: Country Code Contains the country of the address.
PDD-CMA-CODE Alpha 10 HR04.9
Element: Cma Code Contains the Census Metropolitan Area
code.
PDD-SUPP-ADDR1 Alpha 30 (Lower Case) HR04.9
Element: Supplemental Address
PDD-SUPP-ADDR2 Alpha 30 (Lower Case) HR04.9
Element: Address 2
PDD-SUPP-ADDR3 Alpha 30 (Lower Case) HR04.9
Element: Supp Addr3
PDD-SUPP-ADDR4 Alpha 30 (Lower Case) HR04.9
Element: Supp Addr4
PDD-SUPP-CITY Alpha 18 (Lower Case) HR04.9
Element: City
PDD-SUPP-STATE Alpha 2 HR04.9
Element: State
PDD-SUPP-ZIP Alpha 10 HR04.9
Element: Postal Code
PDD-SUPP-CNTRY-CD Alpha 2 HR04.9
Element: Supp Cntry Cd
PDD-REPORT-PROV Alpha 10 HR04.9
Element: Report Prov
PDD-NUMERIC1 Signed 15.4 HR04.9
Element: Numeric1
PDD-NUMERIC2 Signed 15.4 HR04.9
Element: Numeric2
PCODESDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDDSET1 TYPE AC541 AC542
CODE BN150 BN66.1
HR04.9 HR11.1
HR11.2 HR204
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA149
PA290 PA372
PA490 PA496
PA502 PA513
PA52.1 PA52.2
PA52.3 PA52.4
PA52.5 PA590
PA594 PA90.1
...
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
Pcodestype PCODESTYPE Not Required
PDD-TYPE -> PCS-TYPE
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
|
