Lawson Insight Technical Documentation |
|
PCODESDTL
PCODESDTL FILE
Contains contact information detail (address and phone number) for specific
types of PCODES.
REFERENCED BY
BN106 BN150 BN305 BN66.1 ET530 ETI2.1
ETI3.1 HR11.1 HR11.2 HR204 HR511 LP130
PA02.1 PA100 PA102 PA115 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 PR296
PR32.2 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR45.1 PR529 PR530 PR560 PR80.1 PR82.1
PR84.1 PR85.1 PR89.1 UK102 UK560 TA147
UPDATED BY
HR04.2 HR04.3 HR04.7 HR04.8 HR04.9 HR80.1
HR80.2 HR80.3 HR80.4 HR80.5 HR80.6 HR80.7
HR80.8 HR80.9 HR81.1 HR81.2 HR81.3 HR81.4
HR81.5 HR81.6 HR81.7 HR81.8 HR81.9 HR82.1
HR82.2 HR82.3 HR82.4 HR82.5 HR82.6 HR82.7
HR82.8 HR82.9 HR83.1 HR83.2 HR83.3 HR83.4
HR83.5 HR83.6 HR83.7 HR83.8 HR83.9 HR84.1
HR84.2 HR84.3 HR84.4 HR84.5 HR84.6 HR84.7
HR84.8 HR84.9 HR85.1 HR85.2 HR85.3 HR85.4
HR85.5 HR85.6 HR85.7 HR85.8 HR86.1 HR86.2
HR86.3 HR86.4 HR86.5 HR86.6 HR86.7 HR86.8
HR86.9 HR87.1 HR87.2 HR87.3 HR87.4 HR87.5
HR87.6 HR87.7 HR87.8 HR87.9 HR88.1 HR88.2
HR88.3 HR88.4 HR88.5 HR88.6 HR88.7 HR89.1
HR89.2 HR89.3 HR89.4 HR89.5 HR89.6 HR89.7
HR89.8 HR89.9 HR91.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDD-TYPE Alpha 2 HR04.2 HR04.3
Element: Type Indicates whether code is HR04.7 HR04.8
establishment, hospital, or physician. HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PDD-CODE Alpha 10 HR04.2 HR04.3
Element: Code Contains the code. HR04.7 HR04.8
HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PDD-CONTACT-LAST Alpha 30 (Lower Case) HR04.2 HR04.3
Element: Contact Last Contains the last name of the contact HR04.7 HR04.8
person. HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PDD-CONTACT-FIRST Alpha 15 (Lower Case) HR04.2 HR04.3
Element: Contact First Contains the first name of the contact HR04.7 HR04.8
person. HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PDD-CONTACT-MI Alpha 1 HR04.2 HR04.3
Element: Contact Mi Contains the middle initial of the HR04.7 HR04.8
contact person. HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PDD-ADDR1 Alpha 30 (Lower Case) HR04.9
Element: Addr1 This field contains the first line of
address information.
PDD-ADDR2 Alpha 30 (Lower Case) HR04.9
Element: Addr1 This field contains the first line of
address information.
PDD-ADDR3 Alpha 30 (Lower Case) HR04.9
Element: Addr1 This field contains the first line of
address information.
PDD-ADDR4 Alpha 30 (Lower Case) HR04.9
Element: Addr1 This field contains the first line of
address information.
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 This field contains the two-character
state code of the address.
PDD-ZIP Alpha 10 HR04.9
Element: Zip 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
Element: Phone Country This field contains the prefix of the
telephone number. For example, the
country or city code.
PDD-PHONE Alpha 15 HR04.9
Element: Phone Phone number.
PDD-PHONE-EXT Alpha 5 HR04.9
Element: Phone Ext This field contains the telephone
extension number.
PDD-FAX-COUNTRY Alpha 6 HR04.9
Element: Phone Country This field contains the prefix of the
telephone number. For example, the
country or city code.
PDD-FAX-NUMBER Alpha 15 HR04.9
Element: Phone Phone number.
PDD-FAX-EXT Alpha 5 HR04.9
Element: Phone Ext This field contains the telephone
extension number.
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: Supp Addr1
PDD-SUPP-ADDR2 Alpha 30 (Lower Case) HR04.9
Element: Supp Addr2
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: Supp City
PDD-SUPP-STATE Alpha 2 HR04.9
Element: Supp State
PDD-SUPP-ZIP Alpha 10 HR04.9
Element: Supp Zip
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
PDD-FACILITY-NAME Alpha 30 HR04.2 HR04.3
Element: Facility Name HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
...
PDD-HIPAA-ID-NBR Alpha 30 HR04.2 HR04.3
Element: Hipaa Id Nbr HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
...
PDD-HIPAA-ID-TYPE Numeric 1 HR04.2 HR04.3
Element: Hipaa Id Type 1 = Social Number HR04.7 HR04.8
2 = Federal EIN HR80.1 HR80.2
3 = HCFA Provider Number HR80.3 HR80.4
4 = Other HR80.5 HR80.6
5 = Service Provider Nbr HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
...
PCODESDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDDSET1 TYPE BN106 BN150
CODE BN305 BN66.1
ET530 ETI2.1
ETI3.1 HR04.2
HR04.3 HR04.7
HR04.8 HR04.9
HR11.1 HR11.2
HR204 HR511
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
...
PCODESDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cma PCODES Required
When PDD-CMA-CODE != Spaces
"CA" -> 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
|