PCODESDTL FILE Human Resource Code Detail Contains contact information detail (address and phone number) for specific types of PCODES. REFERENCED BY HR204 PA149 PA290 PA372 PA490 PA590 PA90.1 UPDATED BY HR04.9 HR704 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-COUNTRY Alpha 30 (Lower Case) Country or Other This field contains the country of the address, or it can be used for additional information such as an attention name. 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 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 HR704 Country Code Contains the country of the address. PCODESDTL FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PDDSET1 TYPE HR04.9 HR204 CODE HR704 PA149 PA290 PA372 PA490 PA590 PA90.1 PCODESDTL FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH 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 |