Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAEMERGCNT


                            PAEMERGCNT FILE

                       Employee Emergency Contact

The Employee Emergency Contact file contains emergency contact information
for employees.

REFERENCED BY

HPAE.1    HR170     HR70.1    HR90.1    PA212     PA311


UPDATED BY

PA12.1    PA512     HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAE-COMPANY            Numeric 4                                 PA12.1  PA512
Element: Company Hr

PAE-EMPLOYEE           Numeric 9                                 PA12.1  PA512
Element: Employee      Contains the employee's number. It is
                       use to correlate all information related
                       to the employee.

PAE-SEQ-NBR            Numeric 4                                 PA12.1  PA512
Element: Seq Nbr       Contains a sequence number that keeps
                       records unique. It is automatically
                       assigned.

PAE-LAST-NAME          Alpha 30  (Lower Case)                    PA12.1  PA512
Element: Last Name     Contains the last name of the emergency
                       contact person.

PAE-FIRST-NAME         Alpha 15  (Lower Case)                    PA12.1  PA512
Element: First Name    Contains the first name of the
                       emergency contact person.

PAE-MIDDLE-INIT        Alpha 1                                   PA12.1  PA512
Element: Middle Init   Contains the middle initial of the
                       emergency contact person.

PAE-ADDR1              Alpha 30  (Lower Case)                    PA12.1  PA512
Element: Addr1         Contains the first line of address.

PAE-ADDR2              Alpha 30  (Lower Case)                    PA12.1  PA512
Element: Addr1         Contains the second line of the address.

PAE-ADDR3              Alpha 30  (Lower Case)                    PA12.1  PA512
Element: Addr1         Contains the third line of address.

PAE-ADDR4              Alpha 30  (Lower Case)                    PA12.1  PA512
Element: Addr1         Contains the fourth line of address.

PAE-CITY               Alpha 18  (Lower Case)                    PA12.1  PA512
Element: City          Contains the city of the address.

PAE-STATE              Alpha 2                                   PA12.1  PA512
Element: State         Contains the state of the emergency
                       contact's address.

PAE-ZIP                Alpha 10                                  PA12.1  PA512
Element: Zip           Contains the postal code of the address.

PAE-RELATIONSHIP       Alpha 30  (Lower Case)                    PA12.1  PA512
Element: Relationship  Contains the relationship of the
                       emergency contact person to the
                       employee.

PAE-HM-PHONE-CNTRY     Alpha 6                                   PA12.1  PA512
Element: Hm Phone CntryContains the prefix of the emergency
                       contact's home telephone number.

PAE-HM-PHONE-NBR       Alpha 15                                  PA12.1  PA512
Element: Hm Phone Nbr  Contains the emergency contact's home
                       telephone number.

PAE-WK-PHONE-CNTRY     Alpha 6                                   PA12.1  PA512
Element: Wk Phone CntryContains the prefix of the emergency
                       contact's work telephone number.

PAE-WK-PHONE-NBR       Alpha 15                                  PA12.1  PA512
Element: Wk Phone Nbr  Contains the emergency contact's work
                       telephone number.

PAE-WK-PHONE-EXT       Alpha 5                                   PA12.1  PA512
Element: Wk Phone Ext  Contains the extension of the emergency
                       contact's telephone number.

PAE-CL-PHONE-CNTRY     Alpha 6                                   PA12.1  PA512
Element: Phone Country This field contains the prefix of the
                       telephone number. For example, the
                       country or city code.


PAE-CL-PHONE-NBR       Alpha 15                                  PA12.1  PA512
Element: Phone         Phone number.

PAE-FULL-NAME          Derived
Element: Full Name

PAE-COUNTRY-CODE       Alpha 2                                   PA12.1  PA512
Element: Country Code  Contains the country of the address.

PAE-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA12.1  PA512
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

PAE-TIME-STAMP         Numeric 6  (hhmmss)                       PA12.1  PA512
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

PAE-USER-ID            Alpha 10  (Lower Case)                    PA12.1  PA512
Element: User

PAE-LABEL-NAME         Derived
Element: Label Name

                         PAEMERGCNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAESET1   COMPANY                                                HPAE.1  HR11.1
          EMPLOYEE                                               HR170   HR70.1
          SEQ-NBR                                                HR90.1  PA115
                                                                 PA12.1  PA212
                                                                 PA311   PA512

                         PAEMERGCNT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PAE-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

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

                            PAE-COUNTRY-CODE    -> INT-COUNTRY-CODE

Employee       EMPLOYEE     Required

                            PAE-COMPANY         -> EMP-COMPANY
                            PAE-EMPLOYEE        -> EMP-EMPLOYEE

Pa Employee    PAEMPLOYEE   Required

                            PAE-COMPANY         -> PEM-COMPANY
                            PAE-EMPLOYEE        -> PEM-EMPLOYEE

                         PAEMERGCNT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Comments       PACOMMENTS   Delete Cascades

                            PAE-COMPANY         -> PAC-COMPANY
                            Zeroes              -> PAC-EMP-APP
                            "EC"                -> PAC-CMT-TYPE
                            PAE-EMPLOYEE        -> PAC-EMPLOYEE
                            Spaces              -> PAC-JOB-CODE
                            Spaces              -> PAC-ACTION-CODE
                            PAE-SEQ-NBR         -> PAC-LN-NBR
                                                   PAC-SEQ-NBR