Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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