This page (revision-8) 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
8 26-Nov-2021 10:22 4 KB jmyers to previous
7 26-Nov-2021 10:22 4 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
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 1 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

Version management

Difference between version and

At line 2 changed one line
!!!QUALIFICATIONS INTERFACE FILE
!!!WORK HISTORIES INTERFACE FILE
At line 4 changed one line
The Qualifications Interface File screen is used to import qualification records into the software data structures.
The Work Histories Interface File screen is used to import work history records into the software data structures.
At line 6 changed one line
Qualifications Interface File data is maintained on the [INF_CV_QUALIFICATIONS] table.
Work Histories Interface File data is maintained on the [INF_CV_WORKHISTORIES] table.
At line 8 changed one line
;[ID|ID]:This field identifies the posting record within the data base.
;[ID|ID]:This field identifies the work history record within the data base.
;[|CANDIDATE_CODE]:
;[|COMPANY_NAME]:
;[|COUNTRY_CODE]:
;[|STATE_PROVINCE_CODE]:
;[|INDUSTRY_CODE]:
;[|VERIFIED_STATUS]:
;[|DATE_VERIFIED]:
;[|CONTACT_NAME]:
;[|CONTACT_TITLE]:
;[|ADDRESS_LINE_1]:
;[|ADDRESS_LINE_2]:
;[|LOCALITY]:
;[|ZIP_POSTAL]:
;[|PHONE_NUMBER]:
;[|PHONE_EXTENSION]:
;[|ALT_PHONE_NUMBER]:
;[|ALT_PHONE_EXTENSION]:
;[|FAX_NUMBER]:
;[|EMAIL_ADDRESS]:
;[|LANGUAGE_CODE]:
;[|COMPANY_SIZE]:
;[|EMPLOYMENT_TYPE]:
;[|GROUP_TYPE]:
;[|RESPONSIBILITY_LEVEL]:
;[|JOB_CATEGORY]:
;[|ASSIGNMENT_TITLE]:
;[|ASSIGNMENT_START_DATE]:
;[|ASSIGNMENT_END_DATE]:
;[|REASON_FOR_LEAVING]:
;[|HOURS_PER_DAY]:
;[|HOURS_PER_WEEK]:
;[|WAGE_RATE]:
;[|RATE_BASIS]:
;[|AVAILABLE_TO_CONTACT]:
At line 10 removed 3 lines
!!!Alias: [IVRWH]
(INF_CV_WORKHISTORIES)
\\
At line 14 removed 42 lines
Work Histories
!!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|
|[COMPANY_NAME]|Varchar2(50)|Y|
|[COUNTRY_CODE]|Varchar2(16)| |
|[STATE_PROVINCE_CODE]|Varchar2(16)| |
|[INDUSTRY_CODE]|Varchar2(16)| |
|[VERIFIED_STATUS]|Varchar2(30)| |
|[DATE_VERIFIED]|Date()| |
|[CONTACT_NAME]|Varchar2(50)| |
|[CONTACT_TITLE]|Varchar2(50)| |
|[ADDRESS_LINE_1]|Varchar2(50)| |
|[ADDRESS_LINE_2]|Varchar2(50)| |
|[LOCALITY]|Varchar2(50)| |
|[ZIP_POSTAL]|Varchar2(16)| |
|[PHONE_NUMBER]|Varchar2(20)| |
|[PHONE_EXTENSION]|Varchar2(16)| |
|[ALT_PHONE_NUMBER]|Varchar2(20)| |
|[ALT_PHONE_EXTENSION]|Varchar2(16)| |
|[FAX_NUMBER]|Varchar2(20)| |
|[EMAIL_ADDRESS]|Varchar2(50)| |
|[LANGUAGE_CODE]|Varchar2(30)| |
|[COMPANY_SIZE]|Varchar2(30)| |
|[EMPLOYMENT_TYPE]|Varchar2(30)| |
|[GROUP_TYPE]|Varchar2(30)| |
|[RESPONSIBILITY_LEVEL]|Varchar2(30)| |
|[JOB_CATEGORY]|Varchar2(30)| |
|[ASSIGNMENT_TITLE]|Varchar2(50)| |
|[ASSIGNMENT_START_DATE]|Date()| |
|[ASSIGNMENT_END_DATE]|Date()| |
|[REASON_FOR_LEAVING]|Varchar2(30)| |
|[HOURS_PER_DAY]|Number(9)| |
|[HOURS_PER_WEEK]|Number(9)| |
|[WAGE_RATE]|Number(18)| |
|[RATE_BASIS]|Varchar2(30)| |
|[AVAILABLE_TO_CONTACT]|Varchar2(4)| |