This page (revision-12) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
12 26-Nov-2021 10:22 2 KB rforbes to previous
11 26-Nov-2021 10:22 2 KB JMyers to previous | to last
10 26-Nov-2021 10:22 5 KB JMyers to previous | to last
9 26-Nov-2021 10:22 5 KB JMyers to previous | to last
8 26-Nov-2021 10:22 5 KB JMyers to previous | to last
7 26-Nov-2021 10:22 4 KB JMyers to previous | to last
6 26-Nov-2021 10:22 4 KB JMyers to previous | to last
5 26-Nov-2021 10:22 4 KB JMyers to previous | to last
4 26-Nov-2021 10:22 3 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links
IVRASE
IVRASE

Version management

Difference between version and

At line 1 changed 2 lines
[{TableOfContents }]
!!!ASSESSMENT EVENTS INTERFACE FILE
!!!Alias: [IVRASE]
(INF_CV_ASSESSMENTEVENTS)
\\
At line 4 changed one line
The Assessments Events Interface File screen is used to import assessment event records into the software data structures.
Assessment Events
At line 6 changed one line
Assessments Events Interface File data is maintained on the [INF_CV_ASSESSMENTEVENTS] table.
!!Table Columns
\\
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[ASSESSMENT_CODE]|Varchar2(16)|Y|
|[PERSON_CODE]|Varchar2(16)| |
|[CANDIDATE_CODE]|Varchar2(16)|Y|
|[ASSESSMENT_EVENT_STATUS]|Varchar2(30)|Y|
|[ASSESSMENT_DATE_TIME]|Date()|Y|
|[LOCATION_CODE]|Varchar2(16)| |
|[ENTITY_CODE]|Varchar2(16)| |
|[EMPLOYMENT_TYPE]|Varchar2(30)| |
|[HIRE_DATE]|Date()| |
|[ASSIGNMENT_CODE]|Varchar2(16)| |
|[ASSIGNMENT_START_DATE]|Date()| |
|[CONTACT_FIRST_NAME]|Varchar2(50)| |
|[CONTACT_LAST_NAME]|Varchar2(50)| |
|[RELATION]|Varchar2(30)| |
|[EMPLOYER]|Varchar2(50)| |
|[USER_NAME]|Varchar2(30)| |
|[JOB_PROFILE_CODE]|Varchar2(16)| |
|[STAGE_SEQUENCE]|Number(5)| |
|[STEP_SEQUENCE]|Number(5)| |
|[ASSESSMENT_RATING]|Varchar2(30)| |
|[ASSESSMENT_POINTS]|Number(5)| |
|[ASSESSMENT_BONUS_POINTS]|Number(5)| |
|[ASSESSMENT_BONUS_REASON_TEXT]|Varchar2(4000)| |
|[APPLICATION_CODE]|Varchar2(16)| |
|[POSTING_CODE]|Varchar2(16)| |
At line 8 changed 25 lines
;[ID|ID]:This field uniquely identifies the assessment event record within the data base.
;[Assessment|ASSESSMENT_CODE]:This field defines the exact assessment the candidate will be taking.
;[Person Code|PERSON_CODE]:The person associated with the assessment event is displayed in this field.
;[Candidate|CANDIDATE_CODE]:The candidate associated with the assessment event is displayed in this field.
;[Status|ASSESSMENT_EVENT_STATUS]:This field will display the current status of the assessment events.
;[Date/Time|ASSESSMENT_DATE_TIME]:This field indicates the date/time of the assessment.
;[Location|LOCATION_CODE]:The location of the assessment event is displayed in this field.
;[Entity|ENTITY_CODE]:The entity associated with the assessment event is displayed in this field.
;[Employment Type|EMPLOYMENT_TYPE]:The person's employment type is displayed in this field.
;[Date of Hire|HIRE_DATE]:The person's date of hire is displayed in this field.
;[Assignment|ASSIGNMENT_CODE]:The assignment associated with the assessment event is displayed in this field.
;[Start Date|ASSIGNMENT_START_DATE]:The assignment start date is indicated in this field.
;[First Name|FIRST_NAME]/[Last Name|LAST_NAME]:The assessment event contact person is indicated in this field.
;[Relation|RELATION]:The relationship between the employee and the contact person is indicated in this field.
;[Employer|EMPLOYER]:The person's employer is indicated in this field.
;[User|USER_NAME]:The user associated with the assessment is displayed in this field.
;[Job Profile|JOB_PROFILE_CODE]:The job associated with the assessment is displayed in this field.
;[Stage Sequence|STAGE_SEQUENCE]:This field defines the sequential order of the recruiting stages.
;[Step Sequence|STEP_SEQUENCE]:This field defines the sequential order of the recruiting steps.
;[Rating|ASSESSMENT_RATING]:This field displays the rating the candidate received for this assessment.
;[Points|ASSESSMENT_POINTS]:This field allows you to record the points the candidate obtained in this assessment.
;[Assessment Bonus Points|ASSESSMENT_BONUS_POINTS]:This field displays any bonus points the candidate achieved with this assessment.
;[Assessment Bonus Reason|ASSESSMENT_BONUS_REASON_TEXT]:The reason for the bonus points that the candidate achieved is displayed in this field.
;[Application|APPLICATION_CODE]:The application associated with the assessment event is displayed in this field.
;[Posting|POSTING_CODE]:The posting associated with the assessment event is displayed in this field.
[{If var='loginstatus' contains 'authenticated'
At line 35 changed 2 lines
![Notes|Edit:Internal.IVRASE]
[{InsertPage page='Internal.IVRASE' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IVRASE]
[{InsertPage page='Internal.IVRASE' default='Click to create a new discussion page'}]
At line 43 added one line
}]
This page (revision-12) was last changed on 26-Nov-2021 10:22 by rforbesTop