Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             INTERVIEW FILE

                          Applicant Interview

The Applicant Interview file contains interview information for both external
and internal applicants.

An external applicant is a person applying from outside the company; an
internal applicant is an employee applying from inside the company.

REFERENCED BY

HR90.1    PA241     PA311     HR170     HR70.1    PA231
PA243

UPDATED BY

HR11.1    PA02.1    PA102     PA115     PA120     PA41.1
PA42.1    PA43.1    PA43.2    PA502

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ITV-COMPANY          Numeric 4                                   PA41.1
Company              Contains the company number which
                     represents an established company.

ITV-EMP-APP          Numeric 1                                   PA41.1
Type                 Indicates whether the person is an
                     external or internal applicant.

                     An external applicant is a person
                     applying from outside the company; an
                     internal applicant is an employee
                     applying from inside the company.
                     0 = Internal
                     1 = External

ITV-APPLICANT        Numeric 9                                   PA41.1
Applicant            For external applicants, this field
                     contains the applicant's number. For
                     internal applicants, this field contains
                     the employee's number.

ITV-SEQ-NBR          Numeric 4                                   PA243   PA41.1
Interview Number     Contains the interview number. It is
                     used as the key for interview comments.

ITV-JOB-CODE         Alpha 9                                     PA41.1
Job Code             Contains the job for which the
                     applicant interviewed.

ITV-IV-DATE          Numeric 8  (yyyymmdd)                       PA243   PA41.1
Interview Date       Contains the interview date.

ITV-EMP-NBR1         Numeric 9                                   PA41.1
Interviewed By       Contains the employee number of first
                     interviewer. This must be a valid
                     employee number.

ITV-EMP-LST-NM1      Alpha 30                                    PA41.1
Interviewed By -     Contains the first interviewer's last
Last Name            name. If an employee number was entered,
                     the name fields default. If an employee
                     number was not selected, the Personnel
                     system does not verify the name.

ITV-EMP-FST-NM1      Alpha 15                                    PA41.1
Interviewed By -     Contains the first interviewer's first
First Name           name. If an employee number was
                     selected, the name fields default. If an
                     employee number was not selected, the
                     Personnel system does not verify the
                     name.

ITV-EMP-MI1          Alpha 1                                     PA41.1
Interviewed By - MI  Contains the first interviewer's middle
                     initial. If an employee number was
                     selected, the name fields default. If an
                     employee number was not selected, the
                     Personnel system does not verify the
                     name.

ITV-EMP-NBR2         Numeric 9                                   PA41.1
Interviewed By 2     Contains the employee number of second
                     interviewer. This must be a valid
                     employee number.

ITV-EMP-LST-NM2      Alpha 30                                    PA41.1
Interviewed By 2 -   Contains the second interviewer's last
Last Name            name. If an employee number was
                     selected, the name fields default. If an
                     employee number was not selected, the
                     Personnel system does not verify the
                     name.

ITV-EMP-FST-NM2      Alpha 15                                    PA41.1
Interviewed By 2 -   Contains the second interviewer's first
First Name           name. If an employee number was
                     selected, the name fields default. If an
                     employee number was not selected, the
                     Personnel system does not verify the
                     name.

ITV-EMP-MI2          Alpha 1                                     PA41.1
Interviewed By 2 -   Contains the second interviewer's
MI                   middle initial. If an employee number
                     was selected, the name fields default.
                     If an employee number was not selected,
                     the Personnel system does not verify the
                     name.

ITV-RATING           Alpha 10                                    PA41.1
Rating               Contains the interview rating code.

ITV-NEXT-IV-DATE     Numeric 8  (yyyymmdd)                       PA41.1
Follow Up Date       Contains the follow-up interview date.

ITV-FOLLOW-IV        Alpha 1                                     PA41.1
Follow Up            Contains the follow-up interview
                     indicator.
                     Y = Yes
                     N = No

ITV-IV-TEST1         Alpha 10                                    PA41.1
Interview Test 1     Contains the name of test one.

ITV-IV-TEST2         Alpha 10                                    PA41.1
Interview Test 2     Contains the name of test two.

ITV-IV-TEST3         Alpha 10                                    PA41.1
Interview Test 3     Contains the name of test three.

ITV-IV-TEST4         Alpha 10                                    PA41.1
Interview Test 4     Contains the name of test four.

ITV-IV-TEST-GR1      Alpha 10                                    PA41.1
Interview Test 1     Contains the rating for test one.
Grade

ITV-IV-TEST-GR2      Alpha 10                                    PA41.1
Interview Test 2     Contains the rating for test two.
Grade

ITV-IV-TEST-GR3      Alpha 10                                    PA41.1
Interview Test 3     Contains the rating for test three.
Grade

ITV-IV-TEST-GR4      Alpha 10                                    PA41.1
Interview Test 4     Contains the rating for test four.
Grade

ITV-BEGIN-TIME       Numeric 6  (hhmmss)                         PA41.1
Interview Time -     Contains the time the interview began.
Begin

ITV-END-TIME         Numeric 6  (hhmmss)                         PA41.1
Interview Time - End Contains the time the interview ended.

ITV-FOLLOW-TIME      Numeric 6  (hhmmss)                         PA41.1
Follow Up Time       Contains the time of the follow up
                     interview.

ITV-REQUISITION      Numeric 9                                   PA41.1
Requisition          Contains the requisition with which the
                     applicant is associated.

ITV-POSITION         Alpha 12                                    PA41.1
Position             Contains the user-defined code that
                     represents a position in the company.

ITV-APP-STATUS       Alpha 2                                     PA41.1
Status               Contains the applicant status that
                     indicates where the applicant is in the
                     recruiting process on the interview
                     date.

ITV-FULL-NAME1       Derived
Full Name 1

ITV-FULL-NAME2       Derived
Full Name 2

                         INTERVIEW FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITVSET1   COMPANY                                                HR11.1  HR90.1
          EMP-APP                                                PA115   PA241
          APPLICANT                                              PA311   PA41.1
          SEQ-NBR

ITVSET2   COMPANY       KeyChange                                HR170   HR70.1
          EMP-APP                                                PA120   PA231
          APPLICANT
          IV-DATE
          SEQ-NBR

ITVSET3   COMPANY       KeyChange, Subset                        PA02.1  PA102
          REQUISITION   Where REQUISITION != Zeroes              PA243   PA42.1
          EMP-APP                                                PA43.1  PA43.2
          APPLICANT                                              PA502
          SEQ-NBR*

                         INTERVIEW FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

App Status     EMSTATUS     Required

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

Applicant      APPLICANT    Required
                            When ITV-EMP-APP = 1

                            ITV-COMPANY        -> APL-COMPANY
                            ITV-APPLICANT      -> APL-APPLICANT

By Employee1   EMPLOYEE     Required
                            When ITV-EMP-NBR1 != Zeroes

                            ITV-COMPANY        -> EMP-COMPANY
                            ITV-EMP-NBR1       -> EMP-EMPLOYEE

By Employee2   EMPLOYEE     Required
                            When ITV-EMP-NBR2 != Zeroes

                            ITV-COMPANY        -> EMP-COMPANY
                            ITV-EMP-NBR2       -> EMP-EMPLOYEE

Company        PRSYSTEM     Required

                            ITV-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When ITV-EMP-APP = Zeroes

                            ITV-COMPANY        -> EMP-COMPANY
                            ITV-APPLICANT      -> EMP-EMPLOYEE

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

                            ITV-COMPANY        -> JBC-COMPANY
                            ITV-JOB-CODE       -> JBC-JOB-CODE

Pa Employee    PAEMPLOYEE   Required
                            When ITV-EMP-APP = Zeroes

                            ITV-COMPANY        -> PEM-COMPANY
                            ITV-APPLICANT      -> PEM-EMPLOYEE

Rating         PCODES       Required
                            When ITV-RATING != Spaces

                            "IR"               -> PCO-TYPE
                            ITV-RATING         -> PCO-CODE

Requisition    PAJOBREQ     Required
                            When ITV-REQUISITION != Zeroes

                            ITV-COMPANY        -> PJR-COMPANY
                            ITV-REQUISITION    -> PJR-REQUISITION

                         INTERVIEW FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Em Comments    PACOMMENTS   Delete Cascades

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

Position       PAPOSITION   Required
                            When (ITV-POSITION != Spaces )

                            ITV-COMPANY        -> POS-COMPANY
                            ITV-POSITION       -> POS-POSITION
                                                  POS-EFFECT-DATE

Position1      PAPOSITION   Required

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

Position2      PAPOSITION   Required

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

Position3      PAPOSITION   Required

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