Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPJOBHIST


                            APPJOBHIST FILE

                         Applicant Job History

The Applicant Job History file contains information about an applicant's
previous job experience and history.

REFERENCED BY

HR170     HR70.1    HR90.1    PA233     PA241     PA231
PA219     PA311

UPDATED BY

BN305     HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1
HR11.1    HR11.2    HR511     HR54.1    HRS1.1    HRSC.1
PA02.1    PA100     PA102     PA115     PA120     PA13.1
PA13.2    PA19.1    PA33.1    PA502     PA513     PA52.1
PA52.3    PA52.4    PA52.5    PA533     PA54.1    PR110
PR113     PR120     PR13.1    PR13.5    PR13.6    PR13.8


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AJH-COMPANY            Numeric 4                                 PA19.1  PA33.1
Element: Company Hr    Contains the company number which         PA533
                       represents an established company.

AJH-APPLICANT          Numeric 9                                 BN305   HAP3.1
Element: Applicant     Contains the applicant's number. The      HEP4.1  HPOS.1
                       number correlates all information about   HPQC.1  HPRS.1
                       the applicant.                            HR11.1  HR11.2
                                                                 HR511   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA19.1  PA33.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA533   PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

AJH-SEQ-NBR            Numeric 4                                 BN305   HAP3.1
Element: Seq Nbr       Contains a sequence number that keeps     HEP4.1  HPOS.1
                       records unique. It is automatically       HPQC.1  HPRS.1
                       assigned when records are created.        HR11.1  HR11.2
                                                                 HR511   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA19.1  PA33.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA533   PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

AJH-EMPLOYER-NAME      Alpha 30  (Lower Case)                    PA19.1  PA33.1
Element: Employer Name Contains the employer's name.             PA533

AJH-ADDR1              Alpha 30  (Lower Case)                    PA19.1  PA33.1
Element: Addr1         Contains first line of the previous       PA533
                       employer's address.

AJH-ADDR2              Alpha 30  (Lower Case)                    PA19.1  PA33.1
Element: Addr1         Contains the second line of the           PA533
                       previous employer's address.

AJH-ADDR3              Alpha 30  (Lower Case)                    PA19.1  PA33.1
Element: Addr1         Contains the third line of the previous   PA533
                       employer's address.

AJH-ADDR4              Alpha 30  (Lower Case)                    PA19.1  PA33.1
Element: Addr1         Contains the fourth line of the           PA533
                       previous employer's address.

AJH-CITY               Alpha 18  (Lower Case)                    PA19.1  PA33.1
Element: City          Contains the city of the previous         PA533
                       employer's address.

AJH-STATE              Alpha 2                                   PA19.1  PA33.1
Element: State         Contains the state of the previous        PA533
                       employer's address.

AJH-ZIP                Alpha 10                                  PA19.1  PA33.1
Element: Zip           Contains the postal code of the           PA533
                       previous employer's address.

AJH-TITLE              Alpha 30  (Lower Case)                    PA19.1  PA33.1
Element: Title         Contains the supervisor's title at the    PA533
                       applicant's previous job.

AJH-SUP-NAME           Alpha 30  (Lower Case)                    PA19.1  PA33.1
Element: Sup Name      Contains the name of the applicant's      PA533
                       previous supervisor.

AJH-WK-PHONE-CNTRY     Alpha 6                                   PA19.1  PA33.1
Element: Wk Phone CntryContains the prefix of the applicant's    PA533
                       previous work telephone number.

AJH-WK-PHONE-NBR       Alpha 15                                  PA19.1  PA33.1
Element: Wk Phone Nbr  Contains the applicant's previous work    PA533
                       telephone number.

AJH-WK-PHONE-EXT       Alpha 5                                   PA19.1  PA33.1
Element: Wk Phone Ext  Contains the extension of the             PA533
                       applicant's previous work telephone
                       number.

AJH-BEG-DATE           Numeric 8  (yyyymmdd)                     PA19.1  PA33.1
Element: Beg Date      Contains the beginning employment date    PA533
                       from the applicant's previous
                       employment.

AJH-END-DATE           Numeric 8  (yyyymmdd)                     PA19.1  PA33.1
Element: End Date      Contains the ending employment date       PA533
                       from the applicant's previous
                       employment.

AJH-BEG-PAY            Signed 11.2                               PA19.1  PA33.1
Element: Salary        Contains the applicant's beginning        PA533
                       salary from the previous employment.

AJH-END-PAY            Signed 11.2                               PA19.1  PA33.1
Element: Salary        Contains the applicant's ending salary    PA533
                       from the previous employment.

AJH-JOB-CODE           Alpha 9                                   PA19.1  PA33.1
Element: Job Code      Contains the job code in this company     PA533
                       that most closely resembles the
                       employee's previous job.

AJH-CUR-EMPR-FLAG      Alpha 1                                   PA19.1  PA33.1
Element: Cur Empr Flag Indicates whether the employer is the     PA533
                       applicant's current employer.
                       N = Not Current Employer
                       Y = Current Employer

AJH-CONTACT-FLAG       Alpha 1                                   PA19.1  PA33.1
Element: Contact Flag  Indicates whether the previous employer   PA533
                       has been contacted.
                       N = Not Contacted
                       Y = Contacted

AJH-CAN-CALL-FLAG      Alpha 1                                   PA19.1  PA33.1
Element: Can Call Flag Indicates whether the previous employer   PA533
                       can be contacted.
                       N = Do Not Contact
                       Y = Can Be Contacted

AJH-EMPLOYEE           Numeric 9                                 BN305   HAP3.1
Element: Employee      Contains the employee number. Each        HEP4.1  HPOS.1
                       person employed by the company is         HPQC.1  HPRS.1
                       assigned a unique number. The system      HR11.1  HR11.2
                       uses the employee number to correlate     HR511   HR54.1
                       all of the information related to that    HRS1.1  HRSC.1
                       person.                                   PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA19.1  PA33.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA533   PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

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

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

AJH-USER-ID            Alpha 10  (Lower Case)                    PA19.1  PA33.1
Element: User                                                    PA533

AJH-CURRENCY-CODE      Alpha 5                                   PA19.1  PA33.1
Element: Currency Code Contains the currency in which the        PA533
                       applicant pay was recorded.

AJH-CURR-ND            Numeric 1                                 PA19.1  PA33.1
Element: Acct Nd       Contains the number of decimals for the   PA533
                       currency.

AJH-COUNTRY-CODE       Alpha 2                                   PA19.1  PA33.1
Element: Country Code  Contains the country of the applicant's   PA533
                       address.

AJH-BASE-BEG-PAY       Signed 11.2                               PA19.1  PA33.1
Element: Salary        The applicant's beginning base pay.       PA533

AJH-BASE-END-PAY       Signed 11.2                               PA19.1  PA33.1
Element: Salary        Contains the applicant's ending base      PA533
                       pay.

AJH-BASE-CURRENCY      Alpha 5                                   PA19.1  PA33.1
Element: Base Currency The company base currency.                PA533

AJH-BASE-ND            Numeric 1                                 PA19.1  PA33.1
Element: Base Nd       The number of decimal positions defined   PA533
                       for the company base currency.

                         APPJOBHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AJHSET1   COMPANY                                                BN305   HAP3.1
          APPLICANT                                              HEP4.1  HPOS.1
          EMPLOYEE                                               HPQC.1  HPRS.1
          SEQ-NBR                                                HR11.1  HR11.2
                                                                 HR170   HR511
                                                                 HR54.1  HR70.1
                                                                 HR90.1  HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA19.1
                                                                 PA233   PA241
                                                                 PA33.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 ...

AJHSET2   COMPANY       KeyChange                                PA120   PA231
          APPLICANT
          EMPLOYEE
          EMPLOYER-NAME
          SEQ-NBR

AJHSET3   COMPANY       Subset                                   HR11.1  HR90.1
          EMPLOYEE      Where EMPLOYEE != Zeroes                 PA115   PA19.1
          SEQ-NBR                                                PA219   PA311
          APPLICANT

                         APPJOBHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When AJH-APPLICANT != Zeroes

                            AJH-COMPANY          -> APL-COMPANY
                            AJH-APPLICANT        -> APL-APPLICANT

Base Currency  CUCODES      Required
                            When (AJH-CURRENCY-CODE != Spaces )

                            AJH-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            AJH-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

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

                            AJH-COUNTRY-CODE     -> INT-COUNTRY-CODE

Currency       CUCODES      Required
                            When (AJH-CURRENCY-CODE != Spaces )

                            AJH-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required
                            When AJH-EMPLOYEE != Zeroes

                            AJH-COMPANY          -> EMP-COMPANY
                            AJH-EMPLOYEE         -> EMP-EMPLOYEE

Job Code       JOBCODE      Required
                            When AJH-JOB-CODE != Spaces

                            AJH-COMPANY          -> JBC-COMPANY
                            AJH-JOB-CODE         -> JBC-JOB-CODE

Paemployee     PAEMPLOYEE   Required
                            When AJH-EMPLOYEE != Zeroes

                            AJH-COMPANY          -> PEM-COMPANY
                            AJH-EMPLOYEE         -> PEM-EMPLOYEE

                         APPJOBHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Comments       PACOMMENTS   Delete Cascades
                            Valid When AJH-APPLICANT != Zeroes

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

Emp Comments   PACOMMENTS   Delete Cascades
                            Valid When AJH-EMPLOYEE != Zeroes

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