Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PARTICIPNT


                            PARTICIPNT FILE

                           COBRA Participant

The COBRA Participant file contains information about COBRA participants.

REFERENCED BY

BN00.1    BN101     BN102     BN103     BN105     BN106
BN181     BN230     BN233     BN270     BN281     BN285
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN320
BN321     BN331     BN430     BN480     BN53.1    BN531
BN532     BN71.1    BN72.1    BN77.1    BN81.1    BN81.2
BN82.1    BN85.1    BS32.1    HR13.2    HR13.3    HR13.4
HR30.1

UPDATED BY

BN100     BN170     BN171     BN175     BN180     BN70.1
BN70.2    BN80.1    BN90.1    PA100     PA52.1    PA52.5

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAR-COMPANY            Numeric 4                                 BN100   BN70.1
Element: Company Hr    Contains the company number.              BN70.2  PA100
                                                                 PA52.1  PA52.5

PAR-PARTICIPNT         Numeric 9                                 BN100   BN70.1
Element: Participant NuContains COBRA participant numbers.       BN70.2  PA100
                                                                 PA52.1  PA52.5

PAR-LAST-NAME          Alpha 30  (Lower Case)                    BN100   BN70.1
Element: Last Name     Contains the last name of the COBRA       PA100   PA52.1
                       participant or retiree.                   PA52.5

PAR-FIRST-NAME         Alpha 15  (Lower Case)                    BN100   BN70.1
Element: First Name    Contains the first name of the COBRA      PA100   PA52.1
                       participant or retiree.                   PA52.5

PAR-MIDDLE-INIT        Alpha 1                                   BN100   BN70.1
Element: Middle InitialContains the middle initial of the        PA100   PA52.1
                       COBRA participant or retiree.             PA52.5

PAR-EMPLOYEE           Numeric 9                                 BN100   BN70.1
Element: Employee      Contains the employee's number. The       PA100   PA52.1
                       number correlates all information about   PA52.5
                       the employee.

PAR-DEPENDENT          Numeric 4                                 BN70.1
Element: Dependent NumbIf the participant is a dependent, this
                       field contains the dependent number.

PAR-ADDR1              Alpha 30  (Lower Case)                    BN100   BN70.1
Element: Address 1     Contains the first line of address        PA100   PA52.1
                       information.                              PA52.5

PAR-ADDR2              Alpha 30  (Lower Case)                    BN100   BN70.1
Element: Address 1     Contains the second line of address       PA100   PA52.1
                       information.                              PA52.5

PAR-ADDR3              Alpha 30  (Lower Case)                    BN70.1  PA52.1
Element: Address 1     Contains the third line of address        PA52.5
                       information.

PAR-ADDR4              Alpha 30  (Lower Case)                    BN70.1  PA52.1
Element: Address 1     Contains the fourth line of address       PA52.5
                       information.

PAR-CITY               Alpha 18  (Lower Case)                    BN100   BN70.1
Element: City          Contains the city of the address.         PA100   PA52.1
                                                                 PA52.5

PAR-STATE              Alpha 2                                   BN100   BN70.1
Element: State or ProviContains the state of the address.        PA100   PA52.1
                                                                 PA52.5

PAR-ZIP                Alpha 10                                  BN100   BN70.1
Element: Postal Code   Contains the postal code of the address.  PA100   PA52.1
                                                                 PA52.5

PAR-HM-PHONE-CNTRY     Alpha 6                                   BN100   BN70.1
Element: Hm Phone CntryContains the prefix of the home           PA100   PA52.1
                       telephone number.                         PA52.5

PAR-HM-PHONE-NBR       Alpha 15                                  BN100   BN70.1
Element: Hm Phone Nbr  Contains the telephone number.            PA100   PA52.1
                                                                 PA52.5

PAR-BIRTHDATE          Numeric 8  (yyyymmdd)                     BN100   BN70.1
Element: Date of Birth Contains the birthdate of the             PA100   PA52.1
                       participant.                              PA52.5

PAR-SEX                Alpha 1                                   BN100   BN70.1
Element: Gender        Contains the gender of the COBRA          PA100   PA52.1
                       participant.                              PA52.5
                       M = Male
                       F = Female

PAR-SMOKER             Alpha 1                                   BN100   BN70.1
Element: Smoker        Indicates whether the COBRA participant   PA100   PA52.1
                       is a smoker.                              PA52.5
                       Y = Yes
                       N = No
                       " "

PAR-OCCUR-TYPE         Alpha 2                                   BN100   BN70.1
Type of First          Contains the first occurrence.            PA100   PA52.1
Occurrence                                                       PA52.5

PAR-OCCUR-DATE         Numeric 8  (yyyymmdd)                     BN100   BN70.1
Date of First          Contains the date of the first            PA100   PA52.1
Occurrence             occurrence.                               PA52.5

PAR-OCCUR-TYPE2        Alpha 2                                   BN70.2
Type of Second         Contains the second occurrence.
Occurrence

PAR-OCCUR-DATE2        Numeric 8  (yyyymmdd)                     BN70.2
Date of Second         Contains the date of the second
Occurrence             occurrence.

PAR-EVENT-DATE         Numeric 8  (yyyymmdd)                     BN70.1
Date of First Cobra    Contains the date the individual
Event                  notified the company of the first
                       occurrence.

PAR-EVENT-DATE2        Numeric 8  (yyyymmdd)
Date of Second         Contains the date the individual
Cobra Event            notified the company of the second
                       occurrence.

PAR-RIGHTS-DATE        Numeric 8  (yyyymmdd)                     BN171   BN70.2
Notification of        Contains the date the company notified
Cobra Rights           the individual of his or her COBRA
                       rights.

PAR-ELECT-DATE         Numeric 8  (yyyymmdd)                     BN70.2
Element: Elect Date    Contains the date the COBRA participant
                       notified the company of his or her
                       benefit election.

PAR-DELINQ-DATE        Numeric 8  (yyyymmdd)                     BN171   BN70.2
Element: Delinq Date   Contains the date the company notified
                       the COBRA participant of his or her
                       delinquent payment.

PAR-REFUSE-DATE        Numeric 8  (yyyymmdd)                     BN70.2
Refusal of Coverage    Contains the date the individual
Date                   declined COBRA benefit coverage.

PAR-CANCEL-DATE        Numeric 8  (yyyymmdd)                     BN170   BN70.2
Element: Cancel Date   Contains the date the COBRA
                       participant's benefits were canceled.

PAR-DIF-PLN-DATE       Numeric 8  (yyyymmdd)                     BN70.2
Different Ins          Contains the date the COBRA
Coverage Date          participant's coverage began in another
                       plan.

PAR-MEDIC-DATE         Numeric 8  (yyyymmdd)                     BN70.2
Element: Date Medicare Contains the date that Medicare begins.

PAR-DEFLT-DATE         Numeric 8  (yyyymmdd)                     BN175   BN70.2
Cancel for Delinq      Contains the cancellation date for
Premium Date           premium delinquency.

PAR-TERM-DATE          Numeric 8  (yyyymmdd)                     BN100   BN170
Element: Termination DaContains the date coverage terminates.    BN175   BN70.1
                                                                 BN70.2  PA100
                                                                 PA52.1  PA52.5

PAR-LAST-CMT-SEQ       Numeric 4                                 BN90.1
Last Comment           Contains the sequence number of the
Sequence Number        last comment entry.

PAR-LAST-INV-NBR       Numeric 4                                 BN180   BN80.1
Element: Last Invoice NContains the last invoice number issued
                       to the COBRA participant.

PAR-FICA-NBR           Alpha 20                                  BN100   BN70.1
Element: Social Number Contains the COBRA participant's Social   PA100   PA52.1
                       Security number.                          PA52.5

PAR-SEC-LVL            Numeric 1
Element: Sec Lvl

PAR-SEC-LOCATION       Alpha 10
Element: Sec Location

PAR-FULL-NAME          Derived
Element: Full Name

PAR-LABEL-NAME         Derived
Element: Label Name

PAR-LABEL-ADDR         Derived
Element: Label Address

PAR-COUNTRY-CODE       Alpha 2                                   BN100   BN70.1
Element: Country Code  The country code.  Required for VAT and   PA100   PA52.1
                       intrastat reporting.  Must be defined in  PA52.5
                        IN01.1 (Country Maintenance).

PAR-CONSENT            Alpha 1                                   BN70.1
Element: Consent       N = No
                       Y = Yes
                       " " = No

                         PARTICIPNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PARSET1   COMPANY                                                BN00.1  BN100
          PARTICIPNT                                             BN101   BN102
                                                                 BN103   BN105
                                                                 BN106   BN170
                                                                 BN171   BN175
                                                                 BN180   BN181
                                                                 BN230   BN233
                                                                 BN270   BN281
                                                                 BN285   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN320   BN321
                                                                 BN331   BN430
                                                                 BN480   BN53.1
                                                                 BN531   BN532
                                                                 ...

PARSET2   COMPANY       KeyChange                                BN270
          LAST-NAME
          FIRST-NAME
          MIDDLE-INIT
          PARTICIPNT

PARSET3   COMPANY       KeyChange                                BN100
          EMPLOYEE
          PARTICIPNT

                         PARTICIPNT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            PAR-COMPANY         -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            PAR-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Country        INSTCTRYCD   Required
                            When (PAR-COUNTRY-CODE != Spaces )

                            PAR-COUNTRY-CODE    -> INT-COUNTRY-CODE

Dependent      EMDEPEND     Required
                            When PAR-DEPENDENT != Zeroes

                            PAR-COMPANY         -> EMD-COMPANY
                            PAR-EMPLOYEE        -> EMD-EMPLOYEE
                            PAR-DEPENDENT       -> EMD-SEQ-NBR

Employee       EMPLOYEE     Required
                            When PAR-EMPLOYEE != Zeroes

                            PAR-COMPANY         -> EMP-COMPANY
                            PAR-EMPLOYEE        -> EMP-EMPLOYEE

Occur Type     OCCURTYPE    Required
                            When PAR-OCCUR-TYPE != Spaces

                            PAR-COMPANY         -> OCC-COMPANY
                            PAR-OCCUR-TYPE      -> OCC-OCCUR-TYPE

Occurtype2     OCCURTYPE    Required
                            When PAR-OCCUR-TYPE2 != Spaces

                            PAR-COMPANY         -> OCC-COMPANY
                            PAR-OCCUR-TYPE2     -> OCC-OCCUR-TYPE

                         PARTICIPNT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Correspondence HRCORRESP

                            PAR-COMPANY         -> HCP-COMPANY
                            "3"                 -> HCP-REQ-TYPE
                            PAR-PARTICIPNT      -> HCP-ID-NBR
                            Zeroes              -> HCP-DEPENDENT
                                                   HCP-SEQ-NBR

Part Benefit   PARTBEN      Delete Restricted

                            PAR-COMPANY         -> PTB-COMPANY
                            PAR-PARTICIPNT      -> PTB-PARTICIPNT
                                                   PTB-EMPLOYEE
                                                   PTB-PLAN-TYPE
                                                   PTB-PLAN-CODE
                                                   PTB-START-DATE