Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             REFERENC FILE

                          Applicant Reference

The Applicant Reference file contains applicant reference information.

REFERENCED BY

HR170     HR70.1    HR90.1    HREF.1    PA232     PA241
PA231

UPDATED BY

PA120     PA32.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

REF-COMPANY          Numeric 4                                   PA32.1
Company              Contains the company number represents
                     an established company.

REF-APPLICANT        Numeric 9                                   PA32.1
Applicant            This field contains the applicant's
                     number.

REF-SEQ-NBR          Numeric 4                                   PA32.1
Sequence Number      This field contains the reference
                     sequence number, which is automatically
                     assigned when the record is created.

REF-LAST-NAME        Alpha 30  (Lower Case)                      PA32.1
Last Name            This field contains the reference's
                     last name.

REF-FIRST-NAME       Alpha 15  (Lower Case)                      PA32.1
First Name           This field contains the reference's
                     first name.

REF-MIDDLE-INIT      Alpha 1                                     PA32.1
Middle Initial       This field contains the reference's
                     middle initial.

REF-ADDR1            Alpha 30  (Lower Case)                      PA32.1
Address 1            This field contains the first line of
                     the reference's address.

REF-ADDR2            Alpha 30  (Lower Case)                      PA32.1
Address 2            This field contains the second line of
                     the reference's address.

REF-ADDR3            Alpha 30  (Lower Case)                      PA32.1
Address 3            Contains the third line of address
                     information.

REF-ADDR4            Alpha 30  (Lower Case)                      PA32.1
Address 4            Contains the fourth line of address
                     information.

REF-CITY             Alpha 18  (Lower Case)                      PA32.1
City                 This field contains the city of the
                     reference's address.

REF-STATE            Alpha 2                                     PA32.1
State or Province    This field contains the state of the
                     reference's address.

REF-ZIP              Alpha 10                                    PA32.1
Postal Code          This field contains the postal code of
                     the reference's address.

REF-WK-PHONE-CNTRY   Alpha 6                                     PA32.1
Work Telephone       Contains the country code of the
Country              reference's work telephone number.

REF-WK-PHONE-NBR     Alpha 15                                    PA32.1
Work Telephone       Contains the reference's telephone
                     number.

REF-WK-PHONE-EXT     Alpha 5                                     PA32.1
Work Telephone       Contains the extension of the
Extension            reference's work telephone number.

REF-HM-PHONE-CNTRY   Alpha 6                                     PA32.1
Hm Phone Cntry       Contains the country code of the
                     reference's home telephone number.

REF-HM-PHONE-NBR     Alpha 15                                    PA32.1
Hm Phone Nbr         Contains the reference's home telephone
                     number.

REF-CONTACT-FLAG     Alpha 1                                     PA32.1
Contacted            This field indicates if the reference
                     has been contacted.
                     N = Not contacted
                     Y = Has Been Contacted

REF-FULL-NAME        Derived
Full Name

REF-ASSOCIATION      Alpha 10                                    PA32.1
Association          Contains a value that indicates how the
                     reference is related to the applicant.

REF-COUNTRY-CODE     Alpha 2                                     PA32.1
Country Code         Contains the country of the reference's
                     address.

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


REF-TIME-STAMP       Numeric 6  (hhmmss)                         PA32.1
Time Stamp           Contains the server time (hour, minute,
                     and second) when the record was last
                     changed.

REF-USER-ID          Alpha 10  (Lower Case)                      PA32.1
User ID Name         Contains the user ID of the person who
                     last changed this record.

                         REFERENC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

REFSET1   COMPANY                                                HR170   HR70.1
          APPLICANT                                              HR90.1  HREF.1
          SEQ-NBR                                                PA232   PA241
                                                                 PA32.1

REFSET2   COMPANY       KeyChange                                PA120   PA231
          APPLICANT
          LAST-NAME
          FIRST-NAME
          MIDDLE-INIT
          SEQ-NBR

                         REFERENC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required

                            REF-COMPANY         -> APL-COMPANY
                            REF-APPLICANT       -> APL-APPLICANT

Association    PCODES       Required
                            When REF-ASSOCIATION != Spaces

                            "AS"                -> PCO-TYPE
                            REF-ASSOCIATION     -> PCO-CODE

Company        PRSYSTEM     Required

                            REF-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

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

                            REF-COUNTRY-CODE    -> INT-COUNTRY-CODE

                         REFERENC FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Comments       PACOMMENTS   Delete Cascades

                            REF-COMPANY         -> PAC-COMPANY
                            1                   -> PAC-EMP-APP
                            "RF"                -> PAC-CMT-TYPE
                            REF-APPLICANT       -> PAC-EMPLOYEE
                            Spaces              -> PAC-JOB-CODE
                            Spaces              -> PAC-ACTION-CODE
                            REF-SEQ-NBR         -> PAC-LN-NBR
                                                   PAC-SEQ-NBR