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
|
