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

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
6 26-Nov-2021 10:22 2 KB JMyers to previous
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 935 bytes 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
IVRQL
IVRQL

Version management

Difference between version and

At line 1 added 2 lines
[{TableOfContents }]
!!!QUALIFICATIONS INTERFACE FILE
At line 4 added one line
The Qualifications Interface File screen is used to import qualification records into the software data structures.
At line 6 added one line
Qualifications Interface File data is maintained on the [INF_CV_QUALIFICATIONS] table.
At line 8 added 17 lines
;[ID|ID]:This field identifies the posting record within the data base.
;[Candidate|CANDIDATE_CODE]:This field provides a code to identify the candidate.
;[Status|QUALIFICATION_STATUS]:This field holds the category that this qualification may fall into.
;[Type|QUALIFICATION_TYPE]:This field defines the type of qualification listed in this employee’s development profile.
;[Category|QUALIFICATION_CATEGORY]:This field holds the category that this qualification may fall into.
;[Description|DESCRIPTION]:This field provides a sort description of the qualification.
;[Qualification|QUALIFICATION_NAME]:This field is a user-defined code that uniquely identifies the qualification being defined.
;[Reference|QUALIFICATION_REFERENCE]:The ‘Reference’ field allows you to further define the qualification.
;[Start Date|QUALIFICATION_START_DATE]/[End Date|QUALIFICATION_END_DATE]:If the qualification has a time limit, a drivers’ license for example, these fields will display the first and last date the qualification is in effect.
;[Confirmed On|DATE_CONFIRMED]:This field displays the date the qualification was confirmed.
;[Confirmed By|CONFIRMED_BY]:This displays the name of the individual who confirmed the qualification.
;[Confirmed Status|CONFIRMED_STATUS]:This field indicates status of any confirmation that needs to be made on this qualification.
;[Interest Level|INTEREST_LEVEL]:This field indicates the interest level the employee may have in the qualification.
;[Proficiency|PROFICIENCY]:This field displays the level of proficiency that the employee has for this particular qualification.
;[Years of Experience|YEARS_EXPERIENCE]:This field indicates how many years experience the employee has with this particular qualification.
;[Year Last Used|YEAR_LAST_USED]:This field indicates the number of years since the candidate last used the qualification.
;[Qualification Type|SUBTYPE_CODE]:If the qualification is sorted beyond the main qualification type, this field identifies the subtype.
At line 5 removed 3 lines
!!!Alias: [IVRQL]
(INF_CV_QUALIFICATIONS)
\\
At line 9 removed 27 lines
Qualifications
!!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.
|[CANDIDATE_CODE]|Varchar2(16)|Y|
|[QUALIFICATION_STATUS]|Varchar2(30)|Y|
|[QUALIFICATION_TYPE]|Varchar2(30)|Y|
|[QUALIFICATION_CATEGORY]|Varchar2(30)| |
|[DESCRIPTION]|Varchar2(50)| |
|[QUALIFICATION_NAME]|Varchar2(50)| |
|[QUALIFICATION_REFERENCE]|Varchar2(50)| |
|[QUALIFICATION_START_DATE]|Date()| |
|[QUALIFICATION_END_DATE]|Date()| |
|[DATE_CONFIRMED]|Date()| |
|[CONFIRMED_BY]|Varchar2(50)| |
|[CONFIRMED_STATUS]|Varchar2(30)| |
|[INTEREST_LEVEL]|Varchar2(30)| |
|[PROFICIENCY]|Varchar2(30)| |
|[YEARS_EXPERIENCE]|Number(5)| |
|[YEAR_LAST_USED]|Date()| |
|[SUBTYPE_CODE]|Varchar2(16)| |
[{If var='loginstatus' contains 'authenticated'
At line 37 changed 2 lines
![Discussion|Edit:Internal.IVRQL]
[{InsertPage page='Internal.IVRQL' default='Click to create a new discussion page'}]
![Notes|Edit:Internal.IVRQL]
[{InsertPage page='Internal.IVRQL' default='Click to create a new notes page'}]
At line 40 removed one line
}]
This page (revision-6) was last changed on 26-Nov-2021 10:22 by JMyersTop