INTERVIEW – Applicant Interview

System
Personnel (PA)
Prefix
ITV
Primary key
COMPANY, EMP-APP, APPLICANT, SEQ-NBR
Fields
33
Updated by
14 programs
Referenced by
7 programs

INTERVIEW is the Applicant Interview table in Lawson Personnel (prefix ITV). It is indexed by COMPANY, EMP-APP, APPLICANT, SEQ-NBR (ITVSET1); alternate indexes: ITVSET2 and ITVSET3. It is related 1:1 to EMSTATUS, APPLICANT, EMPLOYEE, PRSYSTEM, JOBCODE, PAEMPLOYEE, PCODES and PAJOBREQ and 1:M to PACOMMENTS and PAPOSITION. It is updated by HR11.1, LT101, LT111, PA02.1, PA102, PA115, PA120, PA41.1 and 6 more and referenced by HR170, HR70.1, HR90.1, PA231, PA241, PA243 and PA311. The table has 33 fields, 3 indexes and 16 documented relations.

About 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.

Fields (33)

Column = COBOL field name without the ITV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ITV-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.PA41.1
ITV-EMP-APP PK
EMP_APP		Numeric 1Indicates 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
PA41.1
ITV-APPLICANT PK
APPLICANT		Numeric 9For external applicants, this field contains the applicant's number. For internal applicants, this field contains the employee's number.PA41.1
ITV-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the interview number. It is used as the key for interview comments.PA243, PA41.1
ITV-JOB-CODE
JOB_CODE		Alpha 9Contains the job for which the applicant interviewed.PA41.1
ITV-IV-DATE
IV_DATE		Numeric 8 (yyyymmdd)Contains the interview date.PA243, PA41.1
ITV-EMP-NBR1
EMP_NBR1		Numeric 9Contains the employee number of first interviewer. This must be a valid employee number.PA41.1
ITV-EMP-LST-NM1
EMP_LST_NM1		Alpha 30Contains the first interviewer's last 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.PA41.1
ITV-EMP-FST-NM1
EMP_FST_NM1		Alpha 15Contains the first interviewer's first 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.PA41.1
ITV-EMP-MI1
EMP_MI1		Alpha 1Contains 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.PA41.1
ITV-EMP-NBR2
EMP_NBR2		Numeric 9Contains the employee number of second interviewer. This must be a valid employee number.PA41.1
ITV-EMP-LST-NM2
EMP_LST_NM2		Alpha 30Contains the second interviewer's last 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.PA41.1
ITV-EMP-FST-NM2
EMP_FST_NM2		Alpha 15Contains the second interviewer's first 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.PA41.1
ITV-EMP-MI2
EMP_MI2		Alpha 1Contains the second 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.PA41.1
ITV-RATING
RATING		Alpha 10Contains the interview rating code.PA41.1
ITV-NEXT-IV-DATE
NEXT_IV_DATE		Numeric 8 (yyyymmdd)Contains the follow-up interview date.PA41.1
ITV-FOLLOW-IV
FOLLOW_IV		Alpha 1Contains the follow-up interview indicator.
  • Y Yes
  • N No
PA41.1
ITV-IV-TEST1
IV_TEST1		Alpha 10Contains the name of test one.PA41.1
ITV-IV-TEST2
IV_TEST2		Alpha 10Contains the name of test two.PA41.1
ITV-IV-TEST3
IV_TEST3		Alpha 10Contains the name of test three.PA41.1
ITV-IV-TEST4
IV_TEST4		Alpha 10Contains the name of test four.PA41.1
ITV-IV-TEST-GR1
IV_TEST_GR1		Alpha 10Contains the rating for test one.PA41.1
ITV-IV-TEST-GR2
IV_TEST_GR2		Alpha 10Contains the rating for test two.PA41.1
ITV-IV-TEST-GR3
IV_TEST_GR3		Alpha 10Contains the rating for test three.PA41.1
ITV-IV-TEST-GR4
IV_TEST_GR4		Alpha 10Contains the rating for test four.PA41.1
ITV-BEGIN-TIME
BEGIN_TIME		Numeric 6 (hhmmss)Contains the time the interview began.PA41.1
ITV-END-TIME
END_TIME		Numeric 6 (hhmmss)Contains the time the interview ended.PA41.1
ITV-FOLLOW-TIME
FOLLOW_TIME		Numeric 6 (hhmmss)Contains the time of the follow up interview.PA41.1
ITV-REQUISITION
REQUISITION		Numeric 9Contains the requisition with which the applicant is associated.PA41.1
ITV-POSITION
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.PA41.1
ITV-APP-STATUS
APP_STATUS		Alpha 2Contains the applicant status that indicates where the applicant is in the recruiting process on the interview date.PA41.1
ITV-FULL-NAME1
FULL_NAME1		Derived——
ITV-FULL-NAME2
FULL_NAME2		Derived——

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ITVSET1COMPANY, EMP-APP, APPLICANT, SEQ-NBRPrimaryHR11.1, HR90.1, PA115, PA241, PA311, PA41.1
ITVSET2COMPANY, EMP-APP, APPLICANT, IV-DATE, SEQ-NBRKeyChangeHR170, HR70.1, PA120, PA231
ITVSET3COMPANY, REQUISITION, EMP-APP, APPLICANT, SEQ-NBR*KeyChange, SubsetWhere REQUISITION != ZeroesLT101, LT111, PA02.1, PA102, PA243, PA42.1, PA42.3, PA43.1 +3 more

Relations

One to one (11) — lookups and parents

RelationTableRulesConditionField map
App StatusEMSTATUSRequiredITV-COMPANY → EMS-COMPANY, APL-APP-STATUS → EMS-EMP-STATUS
ApplicantAPPLICANTRequiredWhen ITV-EMP-APP = 1ITV-COMPANY → APL-COMPANY, ITV-APPLICANT → APL-APPLICANT
By Employee1EMPLOYEERequiredWhen ITV-EMP-NBR1 != ZeroesITV-COMPANY → EMP-COMPANY, ITV-EMP-NBR1 → EMP-EMPLOYEE
By Employee2EMPLOYEERequiredWhen ITV-EMP-NBR2 != ZeroesITV-COMPANY → EMP-COMPANY, ITV-EMP-NBR2 → EMP-EMPLOYEE
CompanyPRSYSTEMRequiredITV-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen ITV-EMP-APP = ZeroesITV-COMPANY → EMP-COMPANY, ITV-APPLICANT → EMP-EMPLOYEE
Job CodeJOBCODERequiredWhen ITV-JOB-CODE != SpacesITV-COMPANY → JBC-COMPANY, ITV-JOB-CODE → JBC-JOB-CODE
Pa EmployeePAEMPLOYEERequiredWhen ITV-EMP-APP = ZeroesITV-COMPANY → PEM-COMPANY, ITV-APPLICANT → PEM-EMPLOYEE
PaemployeePAEMPLOYEERequiredWhen ITV-EMP-APP = ZeroesITV-COMPANY → PEM-COMPANY, ITV-APPLICANT → PEM-EMPLOYEE
RatingPCODESRequiredWhen ITV-RATING != Spaces"IR" → PCO-TYPE, ITV-RATING → PCO-CODE
RequisitionPAJOBREQRequiredWhen ITV-REQUISITION != ZeroesITV-COMPANY → PJR-COMPANY, ITV-REQUISITION → PJR-REQUISITION

One to many (5) — child tables

RelationTableRulesConditionField map
Em CommentsPACOMMENTSDelete CascadesITV-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, → PAC-DATE
PositionPAPOSITIONRequiredWhen (ITV-POSITION != Spaces)ITV-COMPANY → POS-COMPANY, ITV-POSITION → POS-POSITION, → POS-EFFECT-DATE
Position1PAPOSITIONRequiredITV-COMPANY → POS-COMPANY, APL-POSITION1 → POS-POSITION, → POS-EFFECT-DATE
Position2PAPOSITIONRequiredITV-COMPANY → POS-COMPANY, APL-POSITION2 → POS-POSITION, → POS-EFFECT-DATE
Position3PAPOSITIONRequiredITV-COMPANY → POS-COMPANY, APL-POSITION3 → POS-POSITION, → POS-EFFECT-DATE

Programs

Updated by (14)

Referenced by (7)