Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

INTERVIEW


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

ITV-EMP-APP            Numeric 1                                 PA41.1
Element: 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
Element: 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
Element: Interview NumbContains the interview number. It is
                       used as the key for interview comments.

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

ITV-IV-DATE            Numeric 8  (yyyymmdd)                     PA243   PA41.1
Element: Interview DateContains the interview date.

ITV-EMP-NBR1           Numeric 9                                 PA41.1
Element: Interviewed ByContains 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
Element: Interviewed ByContains 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
Element: Interviewed ByContains 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
Element: Rating        Contains the interview rating code.

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

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

ITV-IV-TEST1           Alpha 10                                  PA41.1
Element: Interview TestContains the name of test one.

ITV-IV-TEST2           Alpha 10                                  PA41.1
Element: Interview TestContains the name of test two.

ITV-IV-TEST3           Alpha 10                                  PA41.1
Element: Interview TestContains the name of test three.

ITV-IV-TEST4           Alpha 10                                  PA41.1
Element: Interview TestContains 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
Element: Interview TimeContains the time the interview ended.

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

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

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

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

ITV-FULL-NAME1         Derived
Element: Full Name 1

ITV-FULL-NAME2         Derived
Element: 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