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

HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1    HR54.1
HRS1.1    HRSC.1    PA100     PA102     PA120     PA19.1
PA33.1    PA52.1    PA52.3    PA52.4    PA52.5    PA533
PA54.1    PRSC.1    HR11.1    PA115

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                                 HAP3.1  HEP4.1
Element: Applicant     Contains the applicant's number. The      HPOS.1  HPQC.1
                       number correlates all information about   HPRS.1  HR54.1
                       the applicant.                            HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA19.1  PA33.1
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA533   PA54.1
                                                                 PRSC.1

AJH-SEQ-NBR            Numeric 4                                 HAP3.1  HEP4.1
Element: Sequence NumbeContains a sequence number that keeps     HPOS.1  HPQC.1
                       records unique. It is automatically       HPRS.1  HR54.1
                       assigned when records are created.        HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA19.1  PA33.1
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA533   PA54.1
                                                                 PRSC.1

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: Address 1     Contains first line of the previous       PA533
                       employer's address.

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

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

AJH-ADDR4              Alpha 30  (Lower Case)                    PA19.1  PA33.1
Element: Address 1     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 or ProviContains the state of the previous        PA533
                       employer's address.

AJH-ZIP                Alpha 10                                  PA19.1  PA33.1
Element: Postal Code   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: Supervisor's NContains the name of the applicant's      PA533
                       previous supervisor.

AJH-WK-PHONE-CNTRY     Alpha 6                                   PA19.1  PA33.1
Work Telephone         Contains the prefix of the applicant's    PA533
Country                previous work telephone number.

AJH-WK-PHONE-NBR       Alpha 15                                  PA19.1  PA33.1
Element: Work TelephoneContains the applicant's previous work    PA533
                       telephone number.

AJH-WK-PHONE-EXT       Alpha 5                                   PA19.1  PA33.1
Work Telephone         Contains the extension of the             PA533
Extension              applicant's previous work telephone
                       number.

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

AJH-END-DATE           Numeric 8  (yyyymmdd)                     PA19.1  PA33.1
Element: Ending 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: Current EmployIndicates 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: Contacted     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      Indicates whether the previous employer   PA533
                       can be contacted.
                       N = Do Not Contact
                       Y = Can Be Contacted

AJH-EMPLOYEE           Numeric 9                                 HAP3.1  HEP4.1
Element: Employee      Contains the employee number. Each        HPOS.1  HPQC.1
                       person employed by the company is         HPRS.1  HR54.1
                       assigned a unique number. The system      HRS1.1  HRSC.1
                       uses the employee number to correlate     PA100   PA102
                       all of the information related to that    PA19.1  PA33.1
                       person.                                   PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA533   PA54.1
                                                                 PRSC.1

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          Contains the user ID of the person who    PA533
                       last changed this record.

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
Account Currency       Contains the number of decimals for the   PA533
Code                   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
Base Number Of         The number of decimal positions defined   PA533
Decimals               for the company base currency.

                         APPJOBHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AJHSET1   COMPANY                                                HAP3.1  HEP4.1
          APPLICANT                                              HPOS.1  HPQC.1
          EMPLOYEE                                               HPRS.1  HR170
          SEQ-NBR                                                HR54.1  HR70.1
                                                                 HR90.1  HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA19.1
                                                                 PA233   PA241
                                                                 PA33.1  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA533
                                                                 PA54.1  PRSC.1

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