INTERVIEW

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


UPDATED BY
HR11.1 HR170 HR70.1 LT101 PA02.1 PA102
PA115 PA120 PA231 PA241 PA243 PA311
PA41.1 PA42.1 PA42.3 PA43.1 PA43.2 PA502
PA535

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITV-COMPANY
Element: Company		Numeric 4
Contains the company number which represents an established company.
PA41.1
ITV-EMP-APP
Element: Type		Numeric 1
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
PA41.1
ITV-APPLICANT
Element: Applicant		Numeric 9
For external applicants, this field contains the applicant's number. For internal applicants, this field contains the employee's number.
PA41.1
ITV-SEQ-NBR
Element: Interview Number		Numeric 4
Contains the interview number. It is used as the key for interview comments.
PA243 PA41.1
ITV-JOB-CODE
Element: Job Code		Alpha 9
Contains the job for which the applicant interviewed.
PA41.1
ITV-IV-DATE
Element: Interview Date		Numeric 8 (yyyymmdd)
Contains the interview date.
PA243 PA41.1
ITV-EMP-NBR1
Element: Interviewed By		Numeric 9
Contains the employee number of first interviewer. This must be a valid employee number.
PA41.1
ITV-EMP-LST-NM1
Interviewed By -
Last Name		Alpha 30
Contains 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
Interviewed By -
First Name		Alpha 15
Contains 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
Element: Interviewed By - MI		Alpha 1
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.
PA41.1
ITV-EMP-NBR2
Element: Interviewed By 2		Numeric 9
Contains the employee number of second interviewer. This must be a valid employee number.
PA41.1
ITV-EMP-LST-NM2
Interviewed By 2 -
Last Name		Alpha 30
Contains 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
Interviewed By 2 -
First Name		Alpha 15
Contains 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
Interviewed By 2 -
MI		Alpha 1
Contains 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
Element: Rating		Alpha 10
Contains the interview rating code.
PA41.1
ITV-NEXT-IV-DATE
Element: Follow Up Date		Numeric 8 (yyyymmdd)
Contains the follow-up interview date.
PA41.1
ITV-FOLLOW-IV
Element: Follow Up		Alpha 1
Contains the follow-up interview indicator.
Y = Yes
N = No
PA41.1
ITV-IV-TEST1
Element: Interview Test 1		Alpha 10
Contains the name of test one.
PA41.1
ITV-IV-TEST2
Element: Interview Test 2		Alpha 10
Contains the name of test two.
PA41.1
ITV-IV-TEST3
Element: Interview Test 3		Alpha 10
Contains the name of test three.
PA41.1
ITV-IV-TEST4
Element: Interview Test 4		Alpha 10
Contains the name of test four.
PA41.1
ITV-IV-TEST-GR1
Interview Test 1
Grade		Alpha 10
Contains the rating for test one.
PA41.1
ITV-IV-TEST-GR2
Interview Test 2
Grade		Alpha 10
Contains the rating for test two.
PA41.1
ITV-IV-TEST-GR3
Interview Test 3
Grade		Alpha 10
Contains the rating for test three.
PA41.1
ITV-IV-TEST-GR4
Interview Test 4
Grade		Alpha 10
Contains the rating for test four.
PA41.1
ITV-BEGIN-TIME
Interview Time -
Begin		Numeric 6 (hhmmss)
Contains the time the interview began.
PA41.1
ITV-END-TIME
Element: Interview Time - End		Numeric 6 (hhmmss)
Contains the time the interview ended.
PA41.1
ITV-FOLLOW-TIME
Element: Follow Up Time		Numeric 6 (hhmmss)
Contains the time of the follow up interview.
PA41.1
ITV-REQUISITION
Element: Requisition		Numeric 9
Contains the requisition with which the applicant is associated.
PA41.1
ITV-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
PA41.1
ITV-APP-STATUS
Element: Status		Alpha 2
Contains the applicant status that indicates where the applicant is in the recruiting process on the interview date.
PA41.1
ITV-FULL-NAME1
Element: Full Name 1		Derived
ITV-FULL-NAME2
Element: Full Name 2		Derived


INTERVIEW FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITVSET1 COMPANY
EMP-APP
APPLICANT
SEQ-NBR
HR11.1 HR90.1
PA115 PA241
PA311 PA41.1
ITVSET2 COMPANY
EMP-APP
APPLICANT
IV-DATE
SEQ-NBR
KeyChange
HR170 HR70.1
PA120 PA231
ITVSET3 COMPANY
REQUISITION
EMP-APP
APPLICANT
SEQ-NBR*
KeyChange, Subset
WhereREQUISITION !=Zeroes
LT101 PA02.1
PA102 PA243
PA42.1 PA42.3
PA43.1 PA43.2
PA502 PA535


INTERVIEW FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
Paemployee 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
NAME		 RELATED 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

File created: Thu Jun 09 11:22:03 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.