Lawson Insight Technical Documentation |
|
PCODESDTL
PCODESDTL FILE
Contains contact information detail (address and phone number) for specific
types of PCODES.
REFERENCED BY
BN106 BN150 HR11.1 HR11.2 HR204 HR511
PA02.1 PA100 PA102 PA13.1 PA13.2 PA149
PA290 PA372 PA496 PA502 PA513 PA52.1
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 PR29.1 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
PR82.1 PR84.1 UK102 TA147 TP135
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
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
ET = Establishment HR80.2 HR80.3
HO = Hospital HR80.4 HR80.5
PY = Physician 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: Address 1 This field contains the first line of
address information.
PDD-ADDR2 Alpha 30 (Lower Case) HR04.9
Element: Address 1 This field contains the second line of
address information.
PDD-ADDR3 Alpha 30 (Lower Case) HR04.9
Element: Address 1 This field contains the third line of
address information.
PDD-ADDR4 Alpha 30 (Lower Case) HR04.9
Element: Address 1 This field contains the fourth 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 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 This field contains the prefix of the
Code fax number. For example, the country or
city code.
PDD-FAX-NUMBER Alpha 15 HR04.9
Element: Telephone NumbThis field contains the fax number.
PDD-FAX-EXT Alpha 5 HR04.9
Element: Telephone ExteThis field contains the fax number
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 Contains the user ID of the person who
last changed this record.
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
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
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 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 HR81.6
HR81.7 HR81.8
HR81.9 HR82.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
|