Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

REFERENC


                             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
Element: Company Hr    Contains the company number represents
                       an established company.

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

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

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

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

REF-MIDDLE-INIT        Alpha 1                                   PA32.1
Element: Middle InitialThis field contains the reference's
                       middle initial.

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

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

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

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

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

REF-STATE              Alpha 2                                   PA32.1
Element: State or ProviThis field contains the state of the
                       reference's address.

REF-ZIP                Alpha 10                                  PA32.1
Element: 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
Element: Work TelephoneContains 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
Element: Hm Phone CntryContains the country code of the
                       reference's home telephone number.

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

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

REF-FULL-NAME          Derived
Element: Full Name

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

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

REF-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA32.1
Element: 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
Element: 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
Element: User          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