Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPLICANT


                             APPLICANT FILE

                               Applicant

The Applicant file contains information on applicants.

REFERENCED BY

DA15.1    HAPL.1    HGLM.1    HPOS.1    HPQC.1    HPRS.1
HR00.1    HR01.1    HR15.1    HR170     HR30.1    HR515
HR54.1    HR70.1    HREF.1    HRS1.1    HRSC.1    HS50.1
HS50.2    HS50.5    HS51.1    HS51.2    HS52.1    HS52.2
PA102     PA135     PA149     PA19.1    PA231     PA232
PA233     PA234     PA235     PA236     PA238     PA239
PA240     PA241     PA242     PA243     PA244     PA248
PA249     PA262     PA263     PA272     PA33.1    PA349
PA37.1    PA43.1    PA43.2    PA44.1    PA45.1    PA49.1
PA49.3    PA53.1    PA533     PA54.1    PA549     PA62.1
PA63.1    PA64.1    PA64.2    PA65.1    PA65.2    TR120
TR121     TR20.1    TR20.2    TR20.3    TR22.1    TR500
PBIP.1    PR197     PRSC.1    HAP2.1    HAP3.1

UPDATED BY

HR90.1    PA100     PA120     PA20.1    PA21.1    PA22.1
PA24.1    PA27.1    PA31.1    PA32.1    PA34.1    PA35.1
PA36.1    PA38.1    PA39.1    PA40.1    PA41.1    PA52.4
PA520     PA531     TR21.1    TR26.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APL-COMPANY            Numeric 4                                 PA31.1  PA39.1
Element: Company       Contains the company number which         PA40.1  PA531
                       represents an established company.

APL-APPLICANT          Numeric 9                                 PA31.1  PA39.1
Element: Applicant     Contains the applicant's number. The      PA40.1  PA531
                       number correlates all information about
                       the applicant.

APL-LAST-NAME          Alpha 30  (Lower Case)                    PA31.1  PA43.1
Element: Last Name     Contains the applicant's last name.       PA531

APL-FIRST-NAME         Alpha 15  (Lower Case)                    PA31.1  PA43.1
Element: First Name    Contains the applicant's first name.      PA531

APL-MIDDLE-NAME        Alpha 15  (Lower Case)                    PA31.1  PA531
Element: Middle Name   Contains the applicant's middle name.

APL-MIDDLE-INIT        Alpha 1                                   PA31.1  PA43.1
Element: Middle InitialContains the applicant's middle initial.  PA531

APL-NICK-NAME          Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Nick Name     Contains the applicant's nickname.

APL-ADDR1              Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Address 1     Contains the first line of the
                       applicant's address.

APL-ADDR2              Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Address 2     Contains the second line of the
                       applicant's address.

APL-ADDR3              Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Address 3     Contains the third line of the
                       applicant's address.

APL-ADDR4              Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Address 4     Contains the fourth line of the
                       applicant's address.

APL-CITY               Alpha 18  (Lower Case)                    PA31.1  PA531
Element: City          Contains the city of the applicant's
                       address.

APL-STATE              Alpha 2                                   PA31.1  PA531
Element: State or ProviContains the state of the applicant's
                       address.

APL-ZIP                Alpha 10                                  PA31.1  PA531
Element: Postal Code   Contains the postal code of the
                       applicant's address.

APL-HM-PHONE-CNTRY     Alpha 6                                   PA31.1  PA531
Home Phone Country     Contains the prefix of the applicant's
Code                   home telephone.

APL-HM-PHONE-NBR       Alpha 15                                  PA31.1  PA531
Element: Home Phone NumContains the applicant's home telephone
                       number.

APL-WK-PHONE-CNTRY     Alpha 6                                   PA31.1  PA531
Work Phone Country     Contains the prefix of the applicant's
Code                   work telephone number.

APL-WK-PHONE-NBR       Alpha 15                                  PA31.1  PA531
Element: Work Phone NumContains the applicant's work telephone
                       number.

APL-WK-PHONE-EXT       Alpha 5                                   PA31.1  PA531
Element: Work Phone ExtContains the extension of the
                       applicant's work telephone number.

APL-FAX-COUNTRY        Alpha 6                                   PA31.1  PA531
Element: Fax Country CoContains the prefix of the fax number.
                       For example, the country or city code.

APL-FAX-NBR            Alpha 15                                  PA31.1  PA531
Element: Fax Number    Contains the applicant's fax telephone
                       number.

APL-FAX-EXT            Alpha 5                                   PA31.1  PA531
Element: Fax Extension Number

APL-DATE-HIRED         Numeric 8  (yyyymmdd)                     PA100   PA31.1
Element: Hire Date     Contains the date the applicant was       PA52.4  PA531
                       hired.

APL-APP-STATUS         Alpha 2                                   PA31.1  PA531
Element: Applicant StatContains the applicant's status.

APL-FICA-NBR           Alpha 15                                  PA31.1  PA531
Element: Social Number Contains the applicant's Social
                       Security number.

APL-DATE-APPLIED       Numeric 8  (yyyymmdd)                     PA31.1  PA531
Element: Date Applied  Contains the date the applicant applied.

APL-HIRE-SOURCE        Alpha 10                                  PA31.1  PA531
Element: Hire Source   Indicates how the applicant found out
                       about job. This must be valid in the
                       Human Resource Codes file.

APL-REF-LST-NAME       Alpha 30  (Lower Case)                    PA31.1  PA531
Referred By Last       Contains the last name of the employee
Name                   who referred the applicant.

APL-REF-FST-NAME       Alpha 15  (Lower Case)                    PA31.1  PA531
Referred By First      Contains the first name of the employee
Name                   who referred the applicant.

APL-REF-MID-INIT       Alpha 1                                   PA31.1  PA531
Referred By Middle     Contains the middle initial of the
Initial                employee who referred the applicant.

APL-FINDERS-FEE        Numeric 10                                PA31.1  PA531
Element: Finders Fee   Contains the finders fee.

APL-PREV-APPLY         Alpha 1                                   PA31.1  PA531
Element: Previously AppIndicates whether the applicant
                       previously applied with company.
                       N = No
                       Y = Yes

APL-PREV-LOCATION      Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Where         Contains the location to which the
                       applicant previously applied.

APL-PREV-DATE          Numeric 8  (yyyymmdd)                     PA31.1  PA531
Element: When          Contains the date the applicant
                       previously applied.

APL-PREV-EMPLOY        Alpha 1                                   PA31.1  PA531
Element: Previously EmpIndicates whether the applicant
                       previously worked for the company.
                       N = No
                       Y = Yes

APL-PREV-EMP-NBR       Numeric 9                                 PA31.1  PA531
Element: Employee NumbeContains the applicant's previous
                       employee number.

APL-PREV-LOC-WORK      Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Where         Contains the applicant's previous work
                       location.

APL-PREV-BEG-DATE      Numeric 8  (yyyymmdd)                     PA31.1  PA531
Element: When - Begin DContains the beginning date of the
                       applicant's previous employment.

APL-PREV-END-DATE      Numeric 8  (yyyymmdd)                     PA31.1  PA531
Element: When - End DatContains the ending date of the
                       applicant's previous employment.

APL-RATING             Alpha 10                                  PA31.1  PA531
Element: Rating        Contains applicant rating codes.

APL-FORMER-LST-NM      Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Former Last NaContains the former last name of the
                       applicant.

APL-FORMER-FST-NM      Alpha 15  (Lower Case)                    PA31.1  PA531
Element: Former First NContains the former first name of the
                       applicant.

APL-FORMER-MI          Alpha 1                                   PA31.1  PA531
Former Middle          Contains the former middle initial of
Initial                the applicant.

APL-PREV-ADDR1         Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Previous AddreContains the first line of the
                       applicant's previous address.

APL-PREV-ADDR2         Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Previous AddreContains the second line of the
                       applicant's previous address.

APL-PREV-ADDR3         Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Previous AddreContains the third line of the
                       applicant's previous address.

APL-PREV-ADDR4         Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Previous AddreContains the fourth line of the
                       applicant's previous address.

APL-PREV-CITY          Alpha 18  (Lower Case)                    PA31.1  PA531
Element: City          Contains the city of the applicant's
                       previous address.

APL-PREV-STATE         Alpha 2                                   PA31.1  PA531
Element: State or ProviContains the state of the applicant's
                       previous address.

APL-PREV-ZIP           Alpha 10                                  PA31.1  PA531
Element: Postal Code   Contains the postal code of the
                       applicant's previous address.

APL-PREV-CNTRY-CD      Alpha 2                                   PA31.1  PA531
Element: Prev Cntry Cd Contains the country code for the
                       applicant's previous address.

APL-EEO-CLASS          Alpha 4  (Lower Case)                     PA31.1  PA531
Element: EEO Class     Contains the applicant's EEO-class.

APL-SEX                Alpha 1                                   PA31.1  PA531
Element: Gender        Contains the applicant's sex.
                       F = Female
                       M = Male
                       X = Not Disclosed

APL-AGE-FLAG           Alpha 1                                   PA31.1  PA531
Element: Age           Indicates whether the applicant is
                       between the ages of 18 and 70.
                       Y = Yes
                       N = No

APL-HANDICAP-ID        Alpha 1                                   PA31.1  PA531
Element: Disability    Indicates whether the applicant is
                       disabled.
                       Y = Yes
                       N = No
                       X = Not Disclosed

APL-JOB1               Alpha 9                                   PA31.1  PA531
Element: Primary Job CoContains the job code of the
                       applicant's first job choice.

APL-JOB2               Alpha 9                                   PA31.1  PA531
Element: Secondary Job Contains the job code of the
                       applicant's second job choice.

APL-JOB3               Alpha 9                                   PA31.1  PA531
Element: Tertiary Job CContains the job code of the
                       applicant's third job choice.

APL-BEG-PAY            Signed 11.2                               PA31.1  PA531
Element: Beginning Pay Contains the minimum expected pay.

APL-END-PAY            Signed 11.2                               PA31.1  PA531
Element: Ending Pay    Contains the maximum expected pay.

APL-DATE-AVAIL         Numeric 8  (yyyymmdd)                     PA31.1  PA531
Element: Date AvailableContains the date the applicant is
                       available to begin work.

APL-VETERAN            Alpha 1                                   PA31.1  PA531
Element: Veteran       Indicates whether the applicant is a
                       veteran.
                       1 = Veteran
                       2 = Disabled Veteran
                       3 = Vietnam Era Veteran
                       4 = Vietnam Era Disabled Veteran
                       N = No
                       Y = Yes
                       X = Not Disclosed

APL-DRAFT-STATUS       Alpha 3                                   PA31.1  PA39.1
Bill of Exchange       Contains the user-defined draft status.   PA531
Status

APL-FINAL-RANK         Alpha 3                                   PA31.1  PA39.1
Element: Final MilitaryContains the applicant's final military   PA531
                       rank.

APL-CUR-STATUS         Alpha 2                                   PA31.1  PA39.1
Element: Current StatusIndicates the applicant's current         PA531
                       military status.
                       NG = National Guard
                       RE = Reserves

APL-LAST-PHYSICAL      Numeric 8  (yyyymmdd)                     PA31.1  PA40.1
Element: Last Physical Contains the date of the last physical    PA531
                       examination.

APL-WK-RST-CODE1       Alpha 10                                  PA31.1  PA40.1
Work Restriction       Contains the first work restriction       PA531
Code 1                 code for the applicant.

APL-WK-RST-CODE2       Alpha 10                                  PA31.1  PA40.1
Work Restriction       Contains the second work restriction      PA531
Code 2                 code for the applicant.

APL-WK-RST-CODE3       Alpha 10                                  PA31.1  PA40.1
Work Restriction       Contains the third work restriction       PA531
Code 3                 code for the applicant.

APL-WK-RST-CODE4       Alpha 10                                  PA31.1  PA40.1
Work Restriction       Contains the fourth work restriction      PA531
Code 4                 code for the applicant.

APL-RESUME             Alpha 1                                   PA31.1  PA531
Element: Resume ReceiveIndicates whether the applicant's
                       resume has been received.
                       Y = Yes
                       N = No

APL-LAST-COM-SEQ       Numeric 4                                 HR90.1  PA31.1
Last Comment           Contains the last sequence number used    PA531
Sequence Number        for the Personnel Comments file.

APL-LAST-REF-SEQ       Numeric 4                                 PA31.1  PA32.1
Last Reference         Contains the last sequence number used    PA531
Sequence Nmbr          for references.

APL-LAST-INT-SEQ       Numeric 4                                 PA31.1  PA41.1
Last Interview         Contains the last sequence number used    PA531
Sequence Number        for interviews.

APL-LAST-MIL-SEQ       Numeric 4                                 PA31.1  PA39.1
Last Military          Contains the last sequence number used    PA531
Sequence Number        for military service record.

APL-LAST-EPC-SEQ       Numeric 4                                 PA20.1  PA21.1
Last Emp Code          Contains the last sequence number used    PA22.1  PA24.1
Sequence Number        for employee codes.                       PA27.1  PA31.1
                                                                 PA34.1  PA35.1
                                                                 PA36.1  PA38.1
                                                                 PA520   PA531
                                                                 TR21.1  TR26.1

APL-POSITION1          Alpha 12                                  PA31.1  PA531
Primary Position       Contains the first position in which
Number                 the applicant is interested.

APL-POSITION2          Alpha 12                                  PA31.1  PA531
Secondary Position     Contains the second position in which
Number                 the applicant is interested.

APL-POSITION3          Alpha 12                                  PA31.1  PA531
Tertiary Position      Contains the third position in which
Number                 the applicant is interested.

APL-PROCESS-LEVEL      Alpha 5                                   PA31.1  PA531
Element: Process Level Contains the process level the
                       applicant is associated with.

APL-EMP-STATUS         Alpha 2                                   PA31.1  PA531
Element: Employee StatuContains the employee status that
                       indicates whether the applicant wants to
                       work full-time, part-time, seasonal,
                       temporary, and so on.

APL-WORK-SCHED         Alpha 10                                  PA31.1  PA531
Element: Work Schedule Contains the work schedule that
                       indicates when the applicant wants to
                       work.

APL-SEC-LVL            Numeric 1                                 PA31.1  PA531
Element: Security LevelThis field is not used. It is for
                       future security enhancements.

APL-SEC-LOCATION       Alpha 10                                  PA31.1  PA531
Element: Security LocatThis field is not used. It is for
                       future security enhancements.

APL-NBR-FTE            Signed 4.3                                PA31.1  PA531
Full Time              Contains the FTE (Full-Time
Equivalent Number      Equivalency) factor that indicates the
                       percent of annual hours the applicant
                       wants to work. For example, if the
                       applicant wants to work full-time, this
                       field is 1.

APL-PIN                Alpha 10  (Lower Case)                    PA31.1  PA531
Element: Pin           Contains the applicant personal ID
                       number. This is used for Employee
                       Self-Service.

APL-ELIG-WORK          Alpha 1                                   PA31.1  PA531
Element: Elig Work     Indicates whether the applicant is
                       eligible to work in the United States.
                       Y = Yes
                       N = No

APL-TRAV-AVAIL         Alpha 1                                   PA31.1  PA531
Element: Trav Avail    Indicates whether the applicant is
                       available for travel.
                       Y = Yes
                       N = No

APL-TRAV-PCT           Numeric 3                                 PA31.1  PA531
Element: Trav Pct      Indicates the percentage the applicant
                       is available for travel.

APL-RELOC-AVAIL        Alpha 1                                   PA31.1  PA531
Element: Reloc Avail   Indicates whether the applicant is
                       available for relocation.
                       Y = Yes
                       N = No

APL-OT-AVAIL           Alpha 1                                   PA31.1  PA531
Element: Ot Avail      Indicates whether the applicant is
                       available for overtime.
                       Y = Yes
                       N = No

APL-EMAIL-ADDRESS      Alpha 60  (Lower Case)                    PA31.1  PA531
Element: Email Address Contains the applicant's email address.

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

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

APL-USER-ID            Alpha 10  (Lower Case)                    PA31.1  PA531
Element: User

APL-EMPLOYEE           Numeric 9                                 PA100   PA31.1
Element: Employee      Contains the name of the employee to      PA52.4  PA531
                       contact when the applicant is hired.

APL-CURRENCY-CODE      Alpha 5                                   PA31.1  PA531
Element: Currency Code Contains the currency in which the pay
                       is recorded.

APL-CURR-ND            Numeric 1                                 PA31.1  PA531
Account Currency
Code

APL-COUNTRY-CODE       Alpha 2                                   PA31.1  PA531
Element: Country Code  Contains the country of the applicant's
                       address.

APL-BIRTHDATE          Numeric 8  (yyyymmdd)                     PA31.1  PA531
Element: Date          Contains the applicant's birthdate.

APL-LANGUAGE-CODE      Alpha 10                                  PA31.1  PA531
Element: Language Code Contains the applicant's language, if
                       other than the company's default
                       language.

APL-NAME-PREFIX        Alpha 4  (Lower Case)                     PA31.1  PA531
Element: Name Prefix   Contains the applicant's title.

APL-NAME-SUFFIX        Alpha 4  (Lower Case)                     PA31.1  PA531
Element: Name Suffix   Contains the applicant's name suffix.

APL-DISABILITY         Alpha 10                                  PA31.1  PA531
Element: Disability    Indicates the type of disability the
                       applicant has.

APL-BASE-BEG-PAY       Signed 11.2                               PA31.1  PA531
Element: Base Beg Pay  Contains the applicant's beginning pay
                       (of the previous job) in the company's
                       base currency.

APL-BASE-END-PAY       Signed 11.2                               PA31.1  PA531
Element: Base End Pay  Contains the applicant's ending pay (of
                       previous job) in the company's base
                       currency.

APL-BASE-CURRENCY      Alpha 5                                   PA31.1  PA531
To Company Base        Contains the company base currency.
Currency

APL-BASE-ND            Numeric 1                                 PA31.1  PA531
Account Currency
Code

APL-BASE-FEE           Numeric 10                                PA31.1  PA531
Element: Base Fee      Contains the finder's fee in the
                       company's base currency.

APL-CURR-CODE-2        Alpha 5                                   PA31.1  PA531
Report Currency 2      Contains the currency in which the
Code                   finder's fee is recorded.

APL-CURR-CODE-ND-2     Numeric 1                                 PA31.1  PA531
Account Currency
Code

APL-RELIGION           Alpha 10                                  PA31.1  PA531
Element: Religion      Contains the applicant's religion.

APL-LAST-NAME-PRE      Alpha 30  (Lower Case)                    PA31.1  PA531
Element: Last Name Pre

APL-CONSENT            Alpha 1                                   PA31.1  PA531
Element: Consent       N = No
                       Y = Yes
                       " " = No

APL-LAST-PRE           Derived
Element: Last Pre

APL-LAST-SUF           Derived
Element: Last Suf

APL-LAST-PRE-SUF       Derived
Element: Last Pre Suf

APL-LAST-NAME-EXP      Derived
Element: Last Name Exp

APL-FIRST-MI           Derived
Element: First Mi

APL-FIRST-MI-EXP       Derived
Element: First Mi Exp

APL-LABEL-NAME         Derived
Element: Label Name    Contains the applicant's name, as it
                       should appear on labels.

APL-LABEL-ADDR         Derived
Element: Label Address Contains the applicants address as it
                       should appear on labels.

APL-FULL-NAME          Derived
Element: Full Name     Contains the applicant's full name.

APL-SHORT-NAME         Derived
Element: Short Name    Contains the applicant's short name.

APL-COUNTY             Alpha 25  (Lower Case)
Element: County        The county for the company address.

APL-LABEL-NAME-1       Derived
Element: Label Name 1

                         APPLICANT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APLSET1   COMPANY                                                DA15.1  HAPL.1
          APPLICANT                                              HGLM.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR00.1  HR01.1
                                                                 HR15.1  HR170
                                                                 HR30.1  HR515
                                                                 HR54.1  HR70.1
                                                                 HR90.1  HREF.1
                                                                 HRS1.1  HRSC.1
                                                                 HS50.1  HS50.2
                                                                 HS50.5  HS51.1
                                                                 HS51.2  HS52.1
                                                                 HS52.2  PA100
                                                                 PA102   PA120
                                                                 PA135   PA149
                                                                 ...

APLSET2   COMPANY       KeyChange                                HAP2.1  PA231
          LAST-NAME
          FIRST-NAME
          MIDDLE-INIT
          APPLICANT

APLSET3   COMPANY       KeyChange                                HAP3.1  PA31.1
          FICA-NBR                                               PA531
          APPLICANT

APLSET4   COMPANY       KeyChange, Subset
          EMPLOYEE      Where EMPLOYEE != Zeroes
          APPLICANT

                         APPLICANT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

App Status     EMSTATUS     Required
                            When APL-APP-STATUS != Spaces

                            APL-COMPANY          -> EMS-COMPANY
                            APL-APP-STATUS       -> EMS-EMP-STATUS

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

                            APL-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            APL-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

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

                            APL-COUNTRY-CODE     -> INT-COUNTRY-CODE

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

                            APL-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Currency2      CUCODES      Required
                            When APL-CURR-CODE-2 != Spaces

                            APL-CURR-CODE-2      -> CUC-CURRENCY-CODE

Disability     PCODES       Required
                            When APL-DISABILITY != Spaces

                            "DI"                 -> PCO-TYPE
                            APL-DISABILITY       -> PCO-CODE

Emp Status     EMSTATUS     Required
                            When APL-EMP-STATUS != Spaces

                            APL-COMPANY          -> EMS-COMPANY
                            APL-EMP-STATUS       -> EMS-EMP-STATUS

Employee       EMPLOYEE     Required
                            When APL-EMPLOYEE != Zeroes

                            APL-COMPANY          -> EMP-COMPANY
                            APL-EMPLOYEE         -> EMP-EMPLOYEE

Hire Source    PCODES       Required
                            When APL-HIRE-SOURCE != Spaces

                            "HS"                 -> PCO-TYPE
                            APL-HIRE-SOURCE      -> PCO-CODE

Job1           JOBCODE      Required
                            When APL-JOB1 != Spaces

                            APL-COMPANY          -> JBC-COMPANY
                            APL-JOB1             -> JBC-JOB-CODE

Job2           JOBCODE      Required
                            When APL-JOB2 != Spaces

                            APL-COMPANY          -> JBC-COMPANY
                            APL-JOB2             -> JBC-JOB-CODE

Job3           JOBCODE      Required
                            When APL-JOB3 != Spaces

                            APL-COMPANY          -> JBC-COMPANY
                            APL-JOB3             -> JBC-JOB-CODE

Prev Country   INSTCTRYCD   Required
                            When (APL-PREV-CNTRY-CD != Spaces )

                            APL-PREV-CNTRY-CD    -> INT-COUNTRY-CODE

Process Level  PRSYSTEM     Required
                            When APL-PROCESS-LEVEL != Spaces

                            APL-COMPANY          -> PRS-COMPANY
                            APL-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Rating         PCODES       Required
                            When APL-RATING != Spaces

                            "AR"                 -> PCO-TYPE
                            APL-RATING           -> PCO-CODE

Religion       PCODES       Not Required
                            Valid When APL-RELIGION != Spaces

                            "RE"                 -> PCO-TYPE
                            APL-RELIGION         -> PCO-CODE

Wk Rst Code1   PCODES       Required
                            When APL-WK-RST-CODE1 != Spaces

                            "WR"                 -> PCO-TYPE
                            APL-WK-RST-CODE1     -> PCO-CODE

Wk Rst Code2   PCODES       Required
                            When APL-WK-RST-CODE2 != Spaces

                            "WR"                 -> PCO-TYPE
                            APL-WK-RST-CODE2     -> PCO-CODE

Wk Rst Code3   PCODES       Required
                            When APL-WK-RST-CODE3 != Spaces

                            "WR"                 -> PCO-TYPE
                            APL-WK-RST-CODE3     -> PCO-CODE

Wk Rst Code4   PCODES       Required
                            When APL-WK-RST-CODE4 != Spaces

                            "WR"                 -> PCO-TYPE
                            APL-WK-RST-CODE4     -> PCO-CODE

Work Schedule  PCODES       Required
                            When APL-WORK-SCHED != Spaces

                            "WS"                 -> PCO-TYPE
                            APL-WORK-SCHED       -> PCO-CODE

                         APPLICANT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ce Comments    PACOMMENTS   Delete Cascades

                            APL-COMPANY          -> PAC-COMPANY
                            1                    -> PAC-EMP-APP
                            "CE"                 -> PAC-CMT-TYPE
                            APL-APPLICANT        -> PAC-EMPLOYEE
                            Spaces               -> PAC-JOB-CODE
                            Spaces               -> PAC-ACTION-CODE
                            Zeroes               -> PAC-LN-NBR
                                                    PAC-SEQ-NBR

Certificates   EMPCODES     Delete Cascades

                            APL-COMPANY          -> EPC-COMPANY
                            "CE"                 -> EPC-TYPE
                            1                    -> EPC-EMP-APP
                            APL-APPLICANT        -> EPC-EMPLOYEE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Competency     EMPCODES     Delete Cascades

                            APL-COMPANY          -> EPC-COMPANY
                            1                    -> EPC-EMP-APP
                            APL-APPLICANT        -> EPC-EMPLOYEE
                                                    EPC-TYPE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Correspondence HRCORRESP

                            APL-COMPANY          -> HCP-COMPANY
                            "2"                  -> HCP-REQ-TYPE
                            APL-APPLICANT        -> HCP-ID-NBR
                            Zeroes               -> HCP-DEPENDENT
                                                    HCP-SEQ-NBR

Ed Comments    PACOMMENTS   Delete Cascades

                            APL-COMPANY          -> PAC-COMPANY
                            1                    -> PAC-EMP-APP
                            "ED"                 -> PAC-CMT-TYPE
                            APL-APPLICANT        -> PAC-EMPLOYEE
                            Spaces               -> PAC-JOB-CODE
                            Spaces               -> PAC-ACTION-CODE
                            Zeroes               -> PAC-LN-NBR
                                                    PAC-SEQ-NBR

Education      EMPCODES     Delete Cascades

                            APL-COMPANY          -> EPC-COMPANY
                            "ED"                 -> EPC-TYPE
                            1                    -> EPC-EMP-APP
                            APL-APPLICANT        -> EPC-EMPLOYEE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Employers      APPJOBHIST   Delete Cascades

                            APL-COMPANY          -> AJH-COMPANY
                            APL-APPLICANT        -> AJH-APPLICANT
                                                    AJH-EMPLOYEE
                                                    AJH-EMPLOYER-NAME
                                                    AJH-SEQ-NBR

Ethnicity      HRCTRYCODE
                            Valid When APL-EEO-CLASS != Spaces

                            "ET"                 -> CTC-TYPE
                                                    CTC-COUNTRY-CODE
                                                    CTC-HRCTRY-CODE

Ge Comments    PACOMMENTS   Delete Cascades

                            APL-COMPANY          -> PAC-COMPANY
                            1                    -> PAC-EMP-APP
                            "GE"                 -> PAC-CMT-TYPE
                            APL-APPLICANT        -> PAC-EMPLOYEE
                            Spaces               -> PAC-JOB-CODE
                            Spaces               -> PAC-ACTION-CODE
                            Zeroes               -> PAC-LN-NBR
                                                    PAC-SEQ-NBR

Hist Err       HISTERR      Delete Cascades

                            APL-COMPANY          -> HER-COMPANY
                            APL-APPLICANT        -> HER-EMPLOYEE
                                                    HER-OBJ-ID
                                                    HER-EFFECT-DATE
                                                    HER-ACTION-CODE
                                                    HER-ACTION-NBR
                                                    HER-FLD-NBR
                                                    HER-SEQ-NBR

Interview Date INTERVIEW    Delete Cascades

                            APL-COMPANY          -> ITV-COMPANY
                            1                    -> ITV-EMP-APP
                            APL-APPLICANT        -> ITV-APPLICANT
                                                    ITV-IV-DATE
                                                    ITV-SEQ-NBR

Interviews     INTERVIEW    Delete Cascades

                            APL-COMPANY          -> ITV-COMPANY
                            1                    -> ITV-EMP-APP
                            APL-APPLICANT        -> ITV-APPLICANT
                                                    ITV-SEQ-NBR

Iv Comments    PACOMMENTS   Delete Cascades

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

Jh Comments    PACOMMENTS   Delete Cascades

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

Job History    APPJOBHIST   Delete Cascades

                            APL-COMPANY          -> AJH-COMPANY
                            APL-APPLICANT        -> AJH-APPLICANT
                            Zeroes               -> AJH-EMPLOYEE
                                                    AJH-SEQ-NBR

Job Interest   PAJOBINTRS   Delete Cascades

                            APL-COMPANY          -> PJI-COMPANY
                            1                    -> PJI-EMP-APP
                            APL-APPLICANT        -> PJI-EMPLOYEE
                                                    PJI-JOB-CODE
                                                    PJI-POSITION

Jobauth        JOBAUTH      Delete Cascades

                            APL-COMPANY          -> JBA-COMPANY
                            1                    -> JBA-EMP-APP
                            APL-APPLICANT        -> JBA-EMPLOYEE
                                                    JBA-JOB-CODE
                                                    JBA-POSITION

Md Comments    PACOMMENTS   Delete Cascades

                            APL-COMPANY          -> PAC-COMPANY
                            1                    -> PAC-EMP-APP
                            "MD"                 -> PAC-CMT-TYPE
                            APL-APPLICANT        -> PAC-EMPLOYEE
                            Spaces               -> PAC-JOB-CODE
                            Spaces               -> PAC-ACTION-CODE
                            Zeroes               -> PAC-LN-NBR
                                                    PAC-SEQ-NBR

Mi Comments    PACOMMENTS   Delete Cascades

                            APL-COMPANY          -> PAC-COMPANY
                            1                    -> PAC-EMP-APP
                            "MI"                 -> PAC-CMT-TYPE
                            APL-APPLICANT        -> PAC-EMPLOYEE
                            Spaces               -> PAC-JOB-CODE
                            Spaces               -> PAC-ACTION-CODE
                            Zeroes               -> PAC-LN-NBR
                                                    PAC-SEQ-NBR

Military       MILITARY     Delete Cascades

                            APL-COMPANY          -> MIL-COMPANY
                            1                    -> MIL-EMP-APP
                            APL-APPLICANT        -> MIL-EMPLOYEE
                                                    MIL-BR-SERVICE
                                                    MIL-SEQ-NBR

Name Prefix    HRCTRYCODE
                            Valid When APL-NAME-PREFIX != Spaces

                            "PR"                 -> CTC-TYPE
                            APL-NAME-PREFIX      -> CTC-HRCTRY-CODE
                                                    CTC-COUNTRY-CODE

Name Suffix    HRCTRYCODE
                            Valid When APL-NAME-SUFFIX != Spaces

                            "SU"                 -> CTC-TYPE
                            APL-NAME-SUFFIX      -> CTC-HRCTRY-CODE
                                                    CTC-COUNTRY-CODE

Position1      PAPOSITION   Required
                            When APL-POSITION1 != Spaces

                            APL-COMPANY          -> POS-COMPANY
                            APL-POSITION1        -> POS-POSITION
                                                    POS-EFFECT-DATE

Position2      PAPOSITION   Required
                            When APL-POSITION2 != Spaces

                            APL-COMPANY          -> POS-COMPANY
                            APL-POSITION2        -> POS-POSITION
                                                    POS-EFFECT-DATE

Position3      PAPOSITION   Required
                            When APL-POSITION3 != Spaces

                            APL-COMPANY          -> POS-COMPANY
                            APL-POSITION3        -> POS-POSITION
                                                    POS-EFFECT-DATE

Ref Name       REFERENC     Delete Cascades

                            APL-COMPANY          -> REF-COMPANY
                            APL-APPLICANT        -> REF-APPLICANT
                                                    REF-LAST-NAME
                                                    REF-FIRST-NAME
                                                    REF-MIDDLE-INIT
                                                    REF-SEQ-NBR

References     REFERENC     Delete Cascades

                            APL-COMPANY          -> REF-COMPANY
                            APL-APPLICANT        -> REF-APPLICANT
                                                    REF-SEQ-NBR

Relocation     EMPCODES     Delete Cascades

                            APL-COMPANY          -> EPC-COMPANY
                            "RL"                 -> EPC-TYPE
                            1                    -> EPC-EMP-APP
                            APL-APPLICANT        -> EPC-EMPLOYEE
                                                    EPC-CODE
                                                    EPC-SUBJECT
                                                    EPC-SEQ-NBR

Requisitions   PAREQAPP     Delete Cascades

                            APL-COMPANY          -> PRA-COMPANY
                            1                    -> PRA-EMP-APP
                            APL-APPLICANT        -> PRA-APPLICANT
                                                    PRA-REQUISITION

Rl Comments    PACOMMENTS   Delete Cascades

                            APL-COMPANY          -> PAC-COMPANY
                            1                    -> PAC-EMP-APP
                            "RL"                 -> PAC-CMT-TYPE
                            APL-APPLICANT        -> PAC-EMPLOYEE
                            Spaces               -> PAC-JOB-CODE
                            Spaces               -> PAC-ACTION-CODE
                            Zeroes               -> PAC-LN-NBR
                                                    PAC-SEQ-NBR

Sk Comments    PACOMMENTS   Delete Cascades

                            APL-COMPANY          -> PAC-COMPANY
                            1                    -> PAC-EMP-APP
                            "SK"                 -> PAC-CMT-TYPE
                            APL-APPLICANT        -> PAC-EMPLOYEE
                            Spaces               -> PAC-JOB-CODE
                            Spaces               -> PAC-ACTION-CODE
                            Zeroes               -> PAC-LN-NBR
                                                    PAC-SEQ-NBR

User Fields    HREMPUSF     Delete Cascades

                            APL-COMPANY          -> HEU-COMPANY
                            1                    -> HEU-EMP-APP
                            APL-APPLICANT        -> HEU-EMPLOYEE
                                                    HEU-FIELD-KEY